openSW-kioks

Tables (3)

Menu (메뉴)

  • id — PK — Primary key — NOT NULL
  • 상품명 (name) — Not NULL
  • 가격 (price) — Not NULL

Order (주문)

  • id — PK — Primary key — NOT NULL
  • 주문시간 (time) — Not NULL
  • 총액 (total) — Not NULL

OrderMenu (주문목록)

  • id — PK — Primary key — NOT NULL
  • 메뉴ID (menu_id) — FK — Foreign key → Menu.id — NOT NULL
  • 주문ID (order_id) — FK — Foreign key → Order.id — NOT NULL
  • 수량 (amount) — Not NULL