D-order ver.4
Tables (16)
Coupon
- id — BigAutoField — Primary key — NOT NULL
- booth — BigAutoField — NOT NULL
- name — CharField
- description — CharField
- discount_type — CharField
- discount_value — DecimalField
- quantity — IntergerField
- created_at — DateTimeField
Menu
- id — BigAutoField — Primary key — NOT NULL
- booth — BigAutoField — NOT NULL
- name — CharField
- category — CharField
- description — CharField
- price — DecimalField
- stock — IntergerField
- image — ImageField
- created_at — DateTimeField
- updated_at — DateTimeField
SetMenu
- id — BigAutoField — Primary key — NOT NULL
- booth — BigAutoField — NOT NULL
- name — CharField
- category — CharField
- description — CharField
- price — IntergerField
- image — ImageField
- created_at — DateTimeField
- updated_at — DateTimeField
SetMenuItem
- id — BigAutoField — Primary key — NOT NULL
- setmenu — BigAutoField — Foreign key → SetMenu.id — NOT NULL
- menu — BigAutoField — Foreign key → Menu.id — NOT NULL
- quantity — IntergerField
StaffCall
- id — BigAutoField — Primary key — NOT NULL
- cart — BigAutoField — NOT NULL
- call_type — CharField
- status — CharField
- created_at — DateTimeField
- accepted_at — DateTimeField
- accepted_by — DateTimeField
- completed_at — DateTimeField
- Key — VARCHAR(255) — NOT NULL
booth
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
coupon
- id — BIGINT — Primary key — NOT NULL
- booth_id — BIGINT — Foreign key → booth.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- discount_type — VARCHAR(20) — NOT NULL
- discount_value — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- min_order_amount — BIGINT — NOT NULL
- max_discount_amount — BIGINT
- valid_from — DATETIME(6)
- valid_until — DATETIME(6)
- is_active — BOOLEAN — NOT NULL
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
menu
- id — BIGINT — Primary key — NOT NULL
- booth_id — BIGINT — Foreign key → booth.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- description — VARCHAR(500)
- price — BIGINT — NOT NULL
- stock — INT — NOT NULL
- is_sold_out — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- sort_order — INT — NOT NULL
- image_key — VARCHAR(500)
- version — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
menu_stock_history
- id — BIGINT — Primary key — NOT NULL
- menu_id — BIGINT — Foreign key → menu.id — NOT NULL
- order_item_id — BIGINT — Foreign key → order_item.id
- change_type — VARCHAR(30) — NOT NULL
- quantity_delta — INT — NOT NULL
- stock_before — INT — NOT NULL
- stock_after — INT — NOT NULL
- reason — VARCHAR(500)
- actor — VARCHAR(100)
- created_at — DATETIME(6) — NOT NULL
order_item
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → orders.id — NOT NULL
- menu_id — BIGINT — Foreign key → menu.id
- set_menu_id — BIGINT — Foreign key → set_menu.id
- parent_id — BIGINT — Foreign key → order_item.id
- quantity — INT — NOT NULL
- canceled_quantity — INT — NOT NULL
- fixed_price — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
orders
- id — BIGINT — Primary key — NOT NULL
- table_usage_id — BIGINT — Foreign key → table_usage.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- total_amount — BIGINT — NOT NULL
- discount_amount — BIGINT — NOT NULL
- final_amount — BIGINT — NOT NULL
- refunded_amount — BIGINT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- paid_at — DATETIME(6)
- canceled_at — DATETIME(6)
set_menu
- id — BIGINT — Primary key — NOT NULL
- booth_id — BIGINT — Foreign key → booth.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — NOT NULL
- description — VARCHAR(500)
- price — BIGINT — NOT NULL
- is_sold_out — BOOLEAN — NOT NULL
- is_active — BOOLEAN — NOT NULL
- sort_order — INT — NOT NULL
- image_key — VARCHAR(500)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
set_menu_item
- id — BIGINT — Primary key — NOT NULL
- set_menu_id — BIGINT — Foreign key → set_menu.id — NOT NULL
- menu_id — BIGINT — Foreign key → menu.id — NOT NULL
- quantity — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
staff_call
- id — BIGINT — Primary key — NOT NULL
- table_usage_id — BIGINT — Foreign key → table_usage.id — NOT NULL
- call_type — VARCHAR(50) — NOT NULL
- message — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- accepted_by — VARCHAR(100)
- created_at — DATETIME(6) — NOT NULL
- accepted_at — DATETIME(6)
- completed_at — DATETIME(6)
- canceled_at — DATETIME(6)
- updated_at — DATETIME(6) — NOT NULL
- version — BIGINT — NOT NULL
table_coupon
- id — BIGINT — Primary key — NOT NULL
- coupon_id — BIGINT — Foreign key → coupon.id — NOT NULL
- table_usage_id — BIGINT — Foreign key → table_usage.id — NOT NULL
- used_order_id — BIGINT — Foreign key → orders.id
- status — VARCHAR(20) — NOT NULL
- issued_at — DATETIME(6) — NOT NULL
- used_at — DATETIME(6)
- version — BIGINT — NOT NULL
table_usage
- id — BIGINT — Primary key — NOT NULL
- started_at — DATETIME(6) — NOT NULL
- ended_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL