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