wedding

Tables (20)

categories

  • category_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — DATETIME — NOT NULL

contracts

  • contract_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • final_quote_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • doc_url — TEXT
  • agreed_at — DATETIME
  • canceled_at — DATETIME
  • created_at — DATETIME — NOT NULL

couple_members

  • couple_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Primary key — NOT NULL
  • role — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME — NOT NULL

couples

  • couple_id — BIGINT — Primary key — NOT NULL
  • invite_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

favorites

  • user_id — BIGINT — Primary key — NOT NULL
  • vendor_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL

inquiries

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • quote_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • user_memo — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiry_responses

  • response_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • response_type — VARCHAR(20) — NOT NULL
  • message — TEXT
  • proposed_quote_id — BIGINT
  • created_at — DATETIME — NOT NULL

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • payload_json — TEXT
  • sent_at — DATETIME — NOT NULL
  • read_at — DATETIME

profiles

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • budget_min — INT
  • budget_max — INT
  • region_code — VARCHAR(30)
  • wedding_month — CHAR(7)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

quote_lines

  • quote_line_id — BIGINT — Primary key — NOT NULL
  • quote_id — BIGINT — NOT NULL
  • std_item_id — BIGINT — NOT NULL
  • item_type — VARCHAR(20) — NOT NULL
  • name_snapshot — VARCHAR(120) — NOT NULL
  • qty — INT — NOT NULL
  • unit_price_snapshot — INT — NOT NULL
  • amount — INT — NOT NULL
  • meta_json — TEXT
  • sort_order — INT — NOT NULL

quotes

  • quote_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • total_price — INT — NOT NULL
  • currency — CHAR(3) — NOT NULL
  • selections_json — TEXT
  • breakdown_json — TEXT
  • expires_at — DATETIME
  • created_at — DATETIME — NOT NULL

reports

  • report_id — BIGINT — Primary key — NOT NULL
  • reporter_user_id — BIGINT — NOT NULL
  • target_type — VARCHAR(20) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • reason_code — VARCHAR(50) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

review_attachments

  • attachment_id — BIGINT — Primary key — NOT NULL
  • review_id — BIGINT — NOT NULL
  • file_url — TEXT — NOT NULL
  • file_type — VARCHAR(20) — NOT NULL
  • verify_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL

reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • contract_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • rating — TINYINT — NOT NULL
  • content — TEXT — NOT NULL
  • verified — TINYINT(1) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

standard_price_items

  • std_item_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — NOT NULL
  • code — VARCHAR(60) — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • item_type — VARCHAR(20) — NOT NULL
  • unit_type — VARCHAR(20) — NOT NULL
  • sort_order — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • provider — VARCHAR(20) — NOT NULL
  • provider_uid — VARCHAR(128) — NOT NULL
  • phone — VARCHAR(30)
  • nickname — VARCHAR(50) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

vendor_categories

  • vendor_id — BIGINT — Primary key — NOT NULL
  • category_id — BIGINT — Primary key — NOT NULL

vendor_price_items

  • vendor_item_id — BIGINT — Primary key — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • std_item_id — BIGINT — NOT NULL
  • display_name — VARCHAR(120)
  • unit_price — INT — NOT NULL
  • min_qty — INT
  • max_qty — INT
  • rule_json — TEXT
  • is_active — TINYINT(1) — NOT NULL
  • updated_at — DATETIME — NOT NULL

vendor_staff

  • staff_id — BIGINT — Primary key — NOT NULL
  • vendor_id — BIGINT — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • password_hash — VARCHAR(255)
  • role — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL

vendors

  • vendor_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(120) — NOT NULL
  • description — TEXT
  • phone_public — VARCHAR(30)
  • address — VARCHAR(255) — NOT NULL
  • lat — DECIMAL(10,7)
  • lng — DECIMAL(10,7)
  • category_primary — VARCHAR(50)
  • price_disclosure_level — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • rating_avg — DECIMAL(3,2) — NOT NULL
  • review_cnt — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL