무신사 클론 개인프로젝트
테이블 (22)
brands
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(120) — NOT NULL
- slug — VARCHAR(160) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
cart_items
- id — BIGINT — 기본 키 — NOT NULL
- cart_id — CHAR(36) — NOT NULL
- product_id — BIGINT — NOT NULL
- variant_id — BIGINT — NOT NULL
- qty — INT — NOT NULL
- unit_price_cents — INT — NOT NULL
carts
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
categories
- id — BIGINT — 기본 키 — NOT NULL
- id (id2) — BIGINT — 외래 키 → products.id — NOT NULL
- id (id3) — BIGINT — 외래 키 → brands.id — NOT NULL
- parent_id — BIGINT
- name — VARCHAR(120) — NOT NULL
- slug — VARCHAR(160) — NOT NULL
- depth — TINYINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
coupons
- id — BIGINT — 기본 키 — NOT NULL
- code — VARCHAR(60) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- amount_cents — INT
- percent — TINYINT
- valid_from — DATETIME(3) — NOT NULL
- valid_to — DATETIME(3) — NOT NULL
- limit_per_user — INT — NOT NULL
- created_at — DATETIME(3) — NOT NULL
events
- Key — 기본 키 — NOT NULL
- name — VARCHAR(160) — NOT NULL
- starts_at — DATETIME(3) — NOT NULL
- ends_at — DATETIME(3) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
look_products
- look_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 기본 키 — NOT NULL
looks
- id (Key) — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(160) — NOT NULL
- content — TEXT
- created_at — DATETIME(3) — NOT NULL
notifications
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- type — VARCHAR(30) — NOT NULL
- message — VARCHAR(500) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
order_cancels
- id — BIGINT — 기본 키 — NOT NULL
- order_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- reason — VARCHAR(200)
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
order_items
- id (id2) — BIGINT — 외래 키 → orders.id — NOT NULL
- id (id22) — INT — 외래 키 → orders.id — NOT NULL
- id — BIGINT
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- variant_id — BIGINT — NOT NULL
- product_snapshot — JSON — NOT NULL
- variant_snapshot — JSON — NOT NULL
- qty — INT — NOT NULL
- unit_price_cents — INT — NOT NULL
- line_total_cents — INT — NOT NULL
orders
- id — BIGINT — 기본 키 — NOT NULL
- id (id2) — INT — 외래 키 → users.id — NOT NULL
- order_number — VARCHAR(40) — NOT NULL
- user_id — BIGINT — NOT NULL
- total_cents — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- payment_method — VARCHAR(20) — NOT NULL
- address_snapshot — JSON — NOT NULL
- coupon_snapshot — JSON
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
product_images
- id (id2) — BIGINT — 외래 키 → products.id — NOT NULL
- id — BIGINT
- product_id — BIGINT — NOT NULL
- url — TEXT — NOT NULL
- sort_order — INT — NOT NULL
product_reviews
- id (ud) — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- rating — TINYINT — NOT NULL
- content — VARCHAR(1000)
- created_at — DATETIME(3) — NOT NULL
product_variants
- id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — NOT NULL
- color — VARCHAR(40)
- size — VARCHAR(40)
- sku — VARCHAR(80)
- stock — INT — NOT NULL
- price_cents_override — INT
product_views
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT
- product_id — BIGINT — NOT NULL
- session_id — CHAR(36)
- created_at — DATETIME(3) — NOT NULL
products
- id — BIGINT — 기본 키 — NOT NULL
- brand_id — BIGINT
- category_id — BIGINT
- name — VARCHAR(200) — NOT NULL
- slug — VARCHAR(220) — NOT NULL
- description — TEXT
- price_cents — INT — NOT NULL
- discount_price_cents — INT
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
search_suggestions
- ID — BIGINT — 기본 키 — NOT NULL
- keyword — VARCHAR(120) — NOT NULL
- weight — INT — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
user_addresses
- id (id2) — INT — 외래 키 → users.id — NOT NULL
- id — BIGINT
- user_id — BIGINT — NOT NULL
- name — VARCHAR(40) — NOT NULL
- receiver — VARCHAR(60) — NOT NULL
- phone — VARCHAR(30) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- addr1 — VARCHAR(200) — NOT NULL
- addr2 — VARCHAR(200)
- is_default — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
user_coupons
- Key — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- coupon_id — BIGINT — NOT NULL
- claimed_at — DATETIME(3) — NOT NULL
- used_order_id — BIGINT
users
- id — INT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(80) — NOT NULL
- oauth_provider — VARCHAR(20)
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
wishlists
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- created_at — DATETIME(3) — NOT NULL