--- Client Table ---
PASS  Total clients = 2
PASS  Client TESTCLIENT001 = 1
PASS    restaurant_name = Lola Remedios Kitchen
PASS    currency = PHP
PASS    city = Cebu City
PASS    default_markup = 75
PASS  Client TESTCLIENT002 = 1
PASS    restaurant_name = Kuya Andys Grill

--- User Login Table ---
PASS  Total users = 2
PASS  User mariatest = 1
PASS    user_gid = TESTCLIENT001
PASS    status = ACTIVE
PASS    email = maria@lolaremedios.ph
PASS    password is set
PASS    firstname = Maria
PASS  User andytest = 1
PASS    user_gid = TESTCLIENT002
PASS    status = ACTIVE

--- Ingredient Table ---
PASS  Ingredients for client 001 = 112
PASS  Ingredients for client 002 = 112
PASS  Rice for client 001 = 1
PASS    unit = grams
PASS    cost_per_unit = .05
PASS    category = Staple
PASS  No ingredient named Chicken Adobo = 0

--- Menu Item Table ---
PASS  Menu items for client 001 = 50
PASS  Menu items for client 002 = 50
PASS  Chicken Adobo for client 001 = 1
PASS    category = Entree
PASS    servings = 4
PASS    item_gid is set
PASS    ingredients is set
PASS  Halo-Halo for client 001 = 1
PASS    category = Dessert
PASS  Item GIDs are unique

--- Pricing Factor Table ---
PASS  Factors for client 001 = 10
PASS  Factors for client 002 = 10
PASS  markup_pct for client 001 = 1
PASS    value = 75
PASS    description is set
PASS  labor_rate for client 001 = 1

--- Cross-Table Checks ---
PASS  User mariatest linked to Lola Remedios Kitchen
PASS  User andytest linked to Kuya Andys Grill

================================
ALL PASSED: 43 checks passed.
================================