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