스마트 DT

테이블 (3)

Customer (customer)

  • Customer_id (Key) — INT — 기본 키 — NOT NULL
  • customer_name (Field) — VARCHAR(20)
  • customer_car_number (Field2) — VARCHAR(20)

Menu (menu)

  • menu_id (Key) — INT — 기본 키 — NOT NULL
  • menu_name (Field) — VARCHAR(20)
  • menu_has_caffeine (Field2) — BOOLEAN

Orders (Untitled)

  • Customer_id (Key) — INT — 외래 키 → Customer.Customer_id — NOT NULL
  • menu_id (Key2) — INT — 외래 키 → Menu.menu_id — NOT NULL
  • order_time (Field) — TIMESTAMP
  • Field2 — INT