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