쇼핑몰

테이블 (7)

cart

  • cart_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • added_at — TIMESTAMP
  • INDEX — idx_user
  • CHECK — (quantity > 0)

categories

  • category_id — BIGINT
  • parent_category_id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMP
  • INDEX — idx_parent

order_items

  • order_item_id — BIGINT
  • order_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL
  • subtotal — DECIMAL(10, 2) — NOT NULL
  • INDEX — idx_order
  • INDEX — idx_product
  • CHECK — (quantity > 0)
  • CHECK — (price >= 0)
  • CHECK — (subtotal >= 0)

orders

  • order_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • order_date — TIMESTAMP
  • total_amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • shipping_address — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • INDEX — idx_user
  • INDEX — idx_status
  • INDEX — idx_order_date
  • CHECK — (total_amount >= 0)

products

  • product_id — BIGINT
  • category_id — BIGINT
  • name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • stock_quantity — INT — NOT NULL
  • image_url — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_category
  • INDEX — idx_price
  • CHECK — (price >= 0)
  • CHECK — (stock_quantity >= 0)

reviews

  • review_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • product_id — BIGINT — NOT NULL
  • rating — INT — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP
  • INDEX — idx_user
  • INDEX — idx_product
  • INDEX — idx_rating
  • CHECK — (rating >= 1 AND rating <= 5)

users

  • user_id — BIGINT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • address — VARCHAR(255)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • INDEX — idx_email