11th-street MVP ERD
Tables (12)
category
- id — BIGINT — Primary key — NOT NULL
- parent_id — BIGINT — Foreign key → category.id
- name — VARCHAR(50) — NOT NULL
- depth — INT — NOT NULL
- sort_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
chat_message
- id — BIGINT — Primary key — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
- sender_id — BIGINT — Foreign key → member.id
- content — VARCHAR(1000) — NOT NULL
- client_message_id — VARCHAR(255) — NOT NULL
- message_type — VARCHAR(20) — NOT NULL
- product_id — BIGINT
- product_name_snapshot — VARCHAR(100)
- product_price_snapshot — DECIMAL(10, 2)
- sent_at — DATETIME — NOT NULL
chat_room
- id — BIGINT — Primary key — NOT NULL
- room_type — VARCHAR(20) — NOT NULL
- seller_id — BIGINT — Foreign key → member.id
- created_by_member_id — BIGINT — Foreign key → member.id — NOT NULL
- cs_status — VARCHAR(20)
- closed_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
chat_room_participant
- id — BIGINT — Primary key — NOT NULL
- chat_room_id — BIGINT — Foreign key → chat_room.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- participant_role — VARCHAR(20) — NOT NULL
- joined_at — DATETIME — NOT NULL
- left_at — DATETIME
coupon_policy
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- discount_type — VARCHAR(20) — NOT NULL
- discount_value — BIGINT — NOT NULL
- max_discount_amount — BIGINT
- issue_starts_at — DATETIME — NOT NULL
- issue_ends_at — DATETIME — NOT NULL
- total_quantity — INT — NOT NULL
- remaining_quantity — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
issued_coupon
- id — BIGINT — Primary key — NOT NULL
- coupon_policy_id — BIGINT — Foreign key → coupon_policy.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- issued_at — DATETIME — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- token_invalid_before — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
product
- id — BIGINT — Primary key — NOT NULL
- seller_id — BIGINT — Foreign key → member.id — NOT NULL
- category_id — BIGINT — Foreign key → category.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- stock_quantity — INT — NOT NULL
- sale_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
search_history
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id
- category_id — BIGINT — Foreign key → category.id
- guest_uuid — VARCHAR(50)
- keyword — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
time_sale
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- original_price — DECIMAL(10, 2) — NOT NULL
- sale_price — DECIMAL(10, 2) — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
time_sale_order
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- time_sale_id — BIGINT — Foreign key → time_sale.id — NOT NULL
- request_id — VARCHAR(36) — NOT NULL
- product_name_snapshot — VARCHAR(100) — NOT NULL
- original_price_snapshot — DECIMAL(10, 2) — NOT NULL
- sale_price_snapshot — DECIMAL(10, 2) — NOT NULL
- quantity — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- failure_reason — VARCHAR(255)
- ordered_at — DATETIME — NOT NULL
- completed_member_id — BIGINT
time_sale_stock
- id — BIGINT — Primary key — NOT NULL
- time_sale_id — BIGINT — Foreign key → time_sale.id — NOT NULL
- initial_quantity — INT — NOT NULL
- remaining_quantity — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL