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