리복

테이블 (11)

Cart

  • cart_id — INT
  • user_id — INT — 외래 키 → Users.user_id
  • created_at — TIMESTAMP

CartItems

  • cart_item_id — INT
  • cart_id — INT — 외래 키 → Cart.cart_id
  • product_id — INT — 외래 키 → Products.product_id
  • size_id — INT — 외래 키 → Sizes.size_id
  • color_id — INT — 외래 키 → Colors.color_id
  • quantity — INT

Categories

  • category_id — INT
  • category_name — VARCHAR(255) — NOT NULL
  • parent_id — INT — 외래 키 → Categories.category_id

Colors

  • color_id — INT
  • color_name — VARCHAR(50) — NOT NULL
  • color_code — VARCHAR(7)

OrderDetails

  • order_detail_id — INT
  • order_id — INT — 외래 키 → Orders.order_id
  • product_id — INT — 외래 키 → Products.product_id
  • quantity — INT
  • price — DECIMAL(10, 2)

Orders

  • order_id — INT
  • user_id — INT — 외래 키 → Users.user_id
  • order_date — TIMESTAMP
  • total_price — DECIMAL(10, 2)
  • status — VARCHAR(50)

ProductDetails

  • detail_id — INT
  • product_id — INT — 외래 키 → Products.product_id
  • size_id — INT — 외래 키 → Sizes.size_id
  • color_id — INT — 외래 키 → Colors.color_id
  • stock_quantity — INT

Products

  • product_id — INT
  • product_name — VARCHAR(255) — NOT NULL
  • category_id — INT — 외래 키 → Categories.category_id
  • description — TEXT
  • price — DECIMAL(10, 2)
  • product_image — VARCHAR(255)

Reviews

  • review_id — INT
  • product_id — INT — 외래 키 → Products.product_id
  • user_id — INT — 외래 키 → Users.user_id
  • rating — INT
  • comment — TEXT — EX
  • review_date — TIMESTAMP

Sizes

  • size_id — INT
  • size_value — VARCHAR(50) — NOT NULL

Users

  • user_id — INT
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP