무신사 클론 개인프로젝트

테이블 (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