kitchenpos

Tables (7)

menu (세트메뉴)

  • Key (id) — BINARY — Primary key — NOT NULL
  • Key (menu_group_id) — BINARY — Foreign key → menu_group.Key — NOT NULL
  • 메뉴판에 표시할지 여부? (displayed) — BIT
  • 이름 (name) — VARCHAR(255)
  • 세트메뉴 가격 (price) — DECIMAL

menu_group

  • Key (id) — BINARY — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(255)

menu_product

  • Key (seq) — BIGINT (AUTO_INCREMENT) — Primary key — NOT NULL
  • Key (product_id) — BINARY — Foreign key → product.Key — NOT NULL
  • Key (menu_id) — BINARY — Foreign key → menu.Key — NOT NULL
  • 수량 (quantity) — BIGINT

order_line_item

  • Key (seq) — bigint(auto_increment) — Primary key — NOT NULL
  • Key (menu_id) — BINARY — Foreign key → menu.Key — NOT NULL
  • order_id — binary — Foreign key → orders.Key — NOT NULL
  • quantity — bigint

order_table

  • Key (id) — BINARY — Primary key — NOT NULL
  • 테이블에 앉았는지여부 (occupied) — BIT
  • Field (name) — VARCHAR(255)
  • 손님 수 (number_of_guests) — integer

orders

  • Key (id) — binary — Primary key — NOT NULL
  • Key (order_table_id) — BINARY — Foreign key → order_table.Key — NOT NULL
  • Field (delivery_address) — varchar(255)
  • Field (order_date_time) — datetime(6)
  • Field2 (status) — varchar(255)
  • Field3 (type) — varchar(255)

product

  • Key (id) — BINARY — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(255)
  • 가격 (price) — DECIMAL