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