텀프로젝트1

테이블 (11)

cart_items

  • cart_id — INT
  • user_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • size — INT — NOT NULL
  • quantity — INT

categories

  • category_id — INT
  • category_name — VARCHAR(30) — NOT NULL

materials

  • material_id — INT
  • material_name — VARCHAR(30) — NOT NULL

order_items

  • order_item_id — INT — 기본 키
  • order_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • size — INT — NOT NULL
  • quantity — INT — NOT NULL
  • price — INT — NOT NULL

orders

  • order_id — INT
  • user_id — INT — NOT NULL
  • total_price — INT — NOT NULL
  • created_at — TIMESTAMP

product_categories

  • pc_id — INT
  • product_id — INT — NOT NULL
  • category_id — INT — NOT NULL

product_images

  • image_id — INT
  • product_id — INT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

product_sizes

  • ps_id — INT
  • product_id — INT — NOT NULL
  • size — INT — NOT NULL
  • stock — INT

products

  • product_id — INT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — INT — NOT NULL
  • discount_rate — INT
  • material_id — INT
  • created_at — TIMESTAMP

reviews

  • review_id — INT
  • user_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • rating — INT
  • comment — TEXT — EX
  • created_at — TIMESTAMP

users

  • user_id — INT
  • username — VARCHAR(30) — NOT NULL
  • password — VARCHAR(200) — NOT NULL
  • role — ENUM('USER', 'ADMIN')
  • created_at — TIMESTAMP