wating_system
Tables (4)
menu
- menu_id — INT
- store_id — INT — Foreign key → store.store_id — NOT NULL
- menu_name — VARCHAR(50) — NOT NULL
- price — INT — NOT NULL
store
- store_id — INT
- store_name — VARCHAR(50) — NOT NULL
waiting
- waiting_id — INT
- store_id — INT — Foreign key → store.store_id — NOT NULL
- waiting_number — INT — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- party_size — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- registered_at — DATETIME — NOT NULL
- called_at — DATETIME
- entered_at — DATETIME
- cancelled_at — DATETIME
waiting_order
- waiting_order_id — INT
- waiting_id — INT — Foreign key → waiting.waiting_id — NOT NULL
- menu_id — INT — Foreign key → menu.menu_id — NOT NULL
- quantity — INT — NOT NULL