ssss

Tables (10)

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 — TINYINT(1)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_user_id

carts

  • id — INT
  • user_id — INT — Foreign key → users.id — NOT NULL
  • product_id — INT — Foreign key → products.id — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP

categories

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

order_items

  • id — INT
  • order_id — INT — Foreign key → orders.id — NOT NULL
  • product_id — INT — Foreign key → products.id — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • variant_name — VARCHAR(100) — 주문 당시 옵션명 스냅샷
  • order_price — DECIMAL(10, 2) — NOT NULL
  • quantity — INT — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_order_id
  • INDEX — idx_product_id

orders

  • 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)
  • phone — VARCHAR(20)
  • 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
  • INDEX — idx_status

payments

  • id — INT
  • order_id — INT — Foreign key → orders.id — NOT NULL
  • method — ENUM('cash', 'points', 'card') — NOT NULL
  • status — ENUM('PENDING', 'SUCCESS', 'FAILED', 'REFUNDED')
  • 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 — TINYINT(1)
  • sort_order — INT
  • INDEX — idx_product_id

products

  • id — INT
  • category_id — INT — Foreign key → categories.id — 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
  • updated_at — TIMESTAMP
  • INDEX — idx_category_id
  • INDEX — idx_status

reviews

  • id — INT
  • product_id — INT — Foreign key → products.id — NOT NULL
  • user_id — INT — Foreign key → users.id — 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
  • INDEX — idx_product_rating

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