f
Tables (8)
menu
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(19, 2) — NOT NULL
- menu_group_id — BIGINT(20) — Foreign key → menu_group.id — NOT NULL
menu_group
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
menu_product
- seq — BIGINT(20) — Primary key — NOT NULL
- menu_id — BIGINT(20) — Foreign key → menu.id — NOT NULL
- product_id — BIGINT(20) — Foreign key → product.id — NOT NULL
- quantity — BIGINT(20) — NOT NULL
order_line_item
- seq — BIGINT(20) — Primary key — NOT NULL
- order_id — BIGINT(20) — Foreign key → orders.id — NOT NULL
- menu_id — BIGINT(20) — Foreign key → menu.id — NOT NULL
- quantity — BIGINT(20) — NOT NULL
order_table
- id — BIGINT(20) — Primary key — NOT NULL
- table_group_id — BIGINT(20) — Foreign key → table_group.id
- number_of_guests — INT(11) — NOT NULL
- empty — BIT(1) — NOT NULL
orders
- id — BIGINT(20) — Primary key — NOT NULL
- order_table_id — BIGINT(20) — Foreign key → order_table.id — NOT NULL
- order_status — VARCHAR(255) — NOT NULL
- ordered_time — DATETIME — NOT NULL
product
- id — BIGINT(20) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- price — DECIMAL(19, 2) — NOT NULL
table_group
- id — BIGINT(20) — Primary key — NOT NULL
- created_date — DATETIME — NOT NULL