sss

Tables (10)

Carts

  • id — INT
  • user_id — INT — NOT NULL
  • product_variant_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP

Order_Items

  • id — INT
  • order_id — INT — Foreign key → Orders.id — NOT NULL
  • product_id — INT — Foreign key → Products.id — NOT NULL
  • variant_name — VARCHAR(100) — 주문 당시 옵션명 스냅샷
  • order_price — DECIMAL(10, 2) — NOT NULL — 주문 당시 가격 스냅샷' CHECK (order_price >= 0
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP

Orders

  • id — VARCHAR(50)
  • user_id — INT — NOT NULL
  • total_amount — DECIMAL(12, 2) — NOT NULL
  • order_status — ENUM('PENDING', 'PAID', 'SHIPPING', 'DELIVERED', 'CANCELLED')
  • delivery_message — TEXT
  • ordered_at — TIMESTAMP
  • INDEX — idx_user_id
  • INDEX — idx_ordered_at

Payments

  • id — INT
  • order_id — INT — Foreign key → Orders.id — NOT NULL
  • method — VARCHAR(20) — NOT NULL
  • transaction_id — VARCHAR(100)
  • amount — DECIMAL(10, 2) — NOT NULL
  • paid_at — TIMESTAMP

Product_Images

  • id — INT
  • product_id — INT — Foreign key → Products.id — NOT NULL
  • image_url — VARCHAR(500) — NOT NULL
  • is_thumbnail — BOOLEAN
  • sort_order — INT
  • INDEX — idx_product_id

Products

  • id — INT
  • category_id — INT — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • base_price — DECIMAL(12, 2) — NOT NULL
  • status — ENUM('ACTIVE', 'SOLD_OUT', 'HIDDEN')
  • view_count — INT
  • created_at — TIMESTAMP
  • INDEX — idx_category_id

Reviews

  • id — INT
  • product_id — INT — Foreign key → Products.id — NOT NULL
  • user_id — INT — NOT NULL
  • order_item_id — INT — Foreign key → Order_Items.id — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • image_url — VARCHAR(500)
  • created_at — TIMESTAMP

addresses

  • id — INT
  • user_id — INT — Foreign key → users.id — NOT NULL
  • recipient_name — VARCHAR(50) — NOT NULL
  • address_main — VARCHAR(255) — NOT NULL
  • address_detail — VARCHAR(255)
  • zipcode — VARCHAR(10)
  • is_default — BOOLEAN
  • created_at — TIMESTAMP
  • INDEX — idx_user_id

categories

  • id — INT
  • parent_id — INT — Foreign key → categories.id
  • name — VARCHAR(50) — NOT NULL
  • depth — INT
  • INDEX — idx_parent_id

users

  • id — INT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • role — ENUM('CUSTOMER', 'ADMIN')
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP