SyStore
Tables (3)
Menu (상품 목록)
- menu_id (pk) — bigint(20) — Primary key — NOT NULL
- name (Field) — varchar(255)
- price (Field2) — int(11)
- category (Field3) — varchar(255)
Order (주문)
- order_id (pk) — bigint(20) — Primary key — NOT NULL
- menu_id (fk) — bigint(20) — Foreign key → Menu.menu_id — NOT NULL
- table_id (fk2) — bigint(20) — Foreign key → Table.table_id — NOT NULL
- datetime (Field) — DateTime
- status (Field2) — varchar(255)
Table (좌석(자리))
- table_id (pk) — bigint(20) — Primary key — NOT NULL
- status (Field) — varchar(255)