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