키친포스
테이블 (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)