FestivalOrder
Tables (3)
Menu (Untitled2)
- num (Key) — Primary key — NOT NULL
- name (Varchar)
- price (number)
- photo (varchar)
Order (Untitled)
- num (Key) — Primary key — NOT NULL
- table (Field)
- total_price (Field2)
- done (Field3)
- date (Field4)
OrderDetail (Untitled3)
- num (Key) — Primary key — NOT NULL
- ordernum (Key2) — Foreign key → Order.num — NOT NULL
- menunum (Key3) — Foreign key → Menu.num — NOT NULL
- done (Field)