키친포스

테이블 (8)

Copy Of Copy Of orders (menu_group)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • ordered_time (name) — VARCHAR(255)

Copy Of Copy Of orders2 (table_group)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • Field (created_date) — DATETIME

Copy Of Copy Of orders3 (menu_product)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • id (menu_id) — BIGINT(20) — 외래 키 → Copy Of orders.id — NOT NULL
  • id (product_id) — BIGINT(20) — 외래 키 → Copy Of Copy Of orders4.id — NOT NULL
  • ordered_time (quantity) — BIGINT(20)

Copy Of Copy Of orders4 (product)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • ordered_time (name) — VARCHAR(255)
  • Field (price) — DECIMAL(19, 2)

Copy Of orders (menu)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • id (menu_group_id) — BIGINT(20) — 외래 키 → Copy Of Copy Of orders.id — NOT NULL
  • ordered_time (name) — VARCHAR(255)
  • Field (price) — DECIMAL(19, 2)

Copy Of orders2 (order_table)

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • id (table_group_id) — BIGINT(20) — 외래 키 → Copy Of Copy Of orders2.id — NOT NULL
  • Field (number_of_guest) — INT(11)
  • Field (empty) — BIT(1)

Untitled2 (order_line_item)

  • Key (seq) — BIGINT(20) — 기본 키 — NOT NULL
  • id (order_id) — BIGINT(20) — 외래 키 → orders.id — NOT NULL
  • id (menu_id) — BIGINT(20) — 외래 키 → Copy Of orders.id — NOT NULL
  • Field (quantity) — BIGINT(20)

orders

  • id — BIGINT(20) — 기본 키 — NOT NULL
  • id (order_table_id) — BIGINT(20) — 외래 키 → Copy Of orders2.id — NOT NULL
  • ordered_time — DATETIME
  • Field (order_status) — VARCHAR(255)