GRID
Tables (11)
Company (Untitled)
- Key (companyID) — Primary key — NOT NULL
- Field (companyname)
- Field (companyaddr) — nullable
- Field (createdAT)
Table (Untitled3)
- Key (tableID) — Primary key — NOT NULL
- Key (userID) — Foreign key → User.Key — NOT NULL
- Key (companyID) — Foreign key → Company.Key — NOT NULL
- Field (tableName)
- Field (tableSection)
- Field (tableStatus)
- Field (customerName) — nullable
- Field (phoneNumber) — nullabel
- Field (remark) — nullable
- Field (persons) — nullable
- Field (price) — nullable
- Field (registeredAT) — nullable??
- Field2 (groupID) — nullbale
- Field2 (ismaster) — nullable
- Field3 (mastertablenumber) — nullable
- Field (createdat)
- Field2 (upadatedat') — nullable
TableGroup (Untitled4)
- Key (id) — Primary key — NOT NULL
- Key (master_table_id) — Foreign key → Table.Key — NOT NULL
- Key (companyID) — Foreign key → Company.Key — NOT NULL
- Field (createdat)
- Field (closedat) — null
User (Untitled2)
- Key (userID) — Primary key — NOT NULL
- Key (companyID) — Foreign key → Company.Key — NOT NULL
- Field (userName)
- Field2 (userRole)
- Field (useremail)
- Field3 (fcmToken)
- Field (createdAT)
- Field (tablecardfield)
history_purchases (Untitled10)
- Key (id) — Primary key — NOT NULL
- Key (history_id) — Foreign key → table_histories.Key — NOT NULL
- Field (item_id)
- Field (item_name)
- Field (quantity)
- Field (unit_price)
- Field (total_price)
- Field (createdat)
item_categories (Untitled11)
- Key (id) — Primary key — NOT NULL
- category_name (Field)
- sort_order (int)
- Field2 (bool)
items (Untitled7)
- Key (item_id) — Primary key — NOT NULL
- Key (companyID) — Foreign key → Company.Key — NOT NULL
- Field (item_name)
- Field (price)
- Field (is_active)
- Field (createdat)
- Field (updatedat)
- Key (item_cate_id) — Foreign key → item_categories.Key — NOT NULL
reservation (Untitled6)
- Key (reservation_id) — Primary key — NOT NULL
- Key (tableID) — Foreign key → Table.Key — NOT NULL
- Field (res_time)
- Field (res_price) — nullable
- Field (customer_name)
- Field (customer_phonenumber) — nullable
- Field (createdat)
- Field (updatedat) — nullable
reservation_purchases (Untitled8)
- Key (id) — Primary key — NOT NULL
- Key (reservation_id) — Foreign key → reservation.Key — NOT NULL
- Key (item_id) — Foreign key → items.Key — NOT NULL
- Field (item_name)
- Field (quantity)
- Field (unit_price)
- Field (total_price)
- Field (createdat)
- Field (updatedat) — nullable
table_histories (Untitled9)
- Key (id) — Primary key — NOT NULL
- Field (table_name)
- Field (section)
- Field (customer_name) — nullable
- Field (customer_phone) — nullable
- Field (persons) — nullable
- Field (total_price)
- Field (remark) — nullable
- Field (registeredat)
- Field (outat)
- Field (createdad)
- Field (userId)
- Field (user_name)
- Field2 (companyID)
- Field3 (tableID)
table_purchases' (Untitled5)
- Key (id) — Primary key — NOT NULL
- Key (tableID) — Foreign key → Table.Key — NOT NULL
- Key (item_id) — Foreign key → items.Key — NOT NULL
- Field (item_name)
- Field (quantity)
- Field (unit_price)
- Field (total_price)
- Field (createdat)
- Field (updatedat) — nullable