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