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