CRD MVP ERD

Tables (6)

items

  • 아이템 id (id) — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • base_price — INT — NOT NULL
  • type — ENUM('TOP', 'BOTTOM') — NOT NULL
  • image_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

order_item_customs

  • id — BIGINT — NOT NULL
  • order_item_id — BIGINT — Foreign key → order_items.id — NOT NULL
  • player_name — VARCHAR(50)
  • number — VARCHAR(10)
  • emblem_image_url — VARCHAR(500)
  • sleeve_option — VARCHAR(50)
  • front_image_url — VARCHAR(500)
  • back_image_url — VARCHAR(500)
  • Key — Foreign key → order_items.Key — NOT NULL
  • Key (Key2) — Foreign key → order_items.Key — NOT NULL

order_items

  • id — BIGINT — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • item_id — BIGINT — Foreign key — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — INT — NOT NULL
  • Key — Foreign key → orders.Key — NOT NULL
  • Key (Key2) — Foreign key → items.아이템 id — NOT NULL

orders

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — ENUM('PENDING', 'PAID', 'PRODUCING', 'SHIPPED', 'DONE', 'CANCELED') — NOT NULL
  • total_price — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • Key — Foreign key → users.Key — NOT NULL

payments

  • id — BIGINT — NOT NULL
  • order_id — BIGINT — Foreign key → orders.id — NOT NULL
  • toss_payment_key — VARCHAR(200) — NOT NULL
  • method — VARCHAR(50)
  • amount — INT — NOT NULL
  • status — ENUM('READY', 'DONE', 'CANCELED', 'FAILED') — NOT NULL
  • paid_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • Key — Foreign key → orders.Key — NOT NULL

users

  • Key — Primary key — NOT NULL
  • id — BIGINT — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • role — ENUM('USER', 'ADMIN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL