TGT`
Tables (3)
Orders (Untitled)
- 주문번호 (order_id) — Int — Primary key — NOT NULL — Auto Increament
- 테이블 넘버 (table_num) — Int — NOT NULL
- 주문시간 (order_time) — DateTime — NOT NULL
- 총 금액 (total_price) — Int — NOT NULL
Orderstatus (CopyOfUntitled2)
- 주방_id (kitchen_order_id) — Int — Primary key — NOT NULL — Auto Increament
- status (food_item) — VarChar(20) — NOT NULL
- 주문상세PK (order_item_id) — Int — Foreign key → order_items.주문상세PK — NOT NULL — Auto Increament
order_items (Untitled2)
- 주문상세PK (order_item_id) — Int — Primary key — NOT NULL — Auto Increament
- 주문번호 (order_id) — Int — Foreign key → Orders.주문번호 — NOT NULL — FK
- 메뉴이름 (food_item) — VarChar(20) — NOT NULL
- 음식별 수량 (quantity) — Int — NOT NULL