SyStore

Tables (3)

Menu (상품 목록)

  • menu_id (pk) — bigint(20) — Primary key — NOT NULL
  • name (Field) — varchar(255)
  • price (Field2) — int(11)
  • category (Field3) — varchar(255)

Order (주문)

  • order_id (pk) — bigint(20) — Primary key — NOT NULL
  • menu_id (fk) — bigint(20) — Foreign key → Menu.menu_id — NOT NULL
  • table_id (fk2) — bigint(20) — Foreign key → Table.table_id — NOT NULL
  • datetime (Field) — DateTime
  • status (Field2) — varchar(255)

Table (좌석(자리))

  • table_id (pk) — bigint(20) — Primary key — NOT NULL
  • status (Field) — varchar(255)