쇼핑몰 ERD

테이블 (9)

고객 (Customer)

  • CustomerID (customer_id) — 기본 키
  • Name (name)
  • Email (email)
  • Phone (phone_number)
  • PasswordHash (password_hash)
  • MemberLevel (member_level)
  • Address (address)

고객_쿠폰 (Customer_Coupon)

  • CustomerID (customer_id) — 외래 키 → 고객.CustomerID
  • CouponID (coupon_id) — 외래 키 → 쿠폰.CouponID
  • Used (used)

리뷰 (Review)

  • ReviewID (review_id) — 기본 키
  • Rating (rating)
  • Content (content)
  • ReviewDate (review_date)
  • ProductID (product_id)
  • CustomerID (customer_id) — 외래 키 → 고객.CustomerID

상품 (Product)

  • ProductID (product_id) — 기본 키
  • ProductName (product_name)
  • Brand (brand)
  • Price (price)
  • Size (size)
  • Material (material)
  • ProductDiscoutRate (product_discoutrate)
  • ImageURL (image_url)
  • CategoryID (category_id) — 외래 키 → 카테고리.CategoryID

재고 (Inventory)

  • ProductID (product_id) — 외래 키 → 상품.ProductID
  • Quantity (quantity)
  • WarehouseLocation (warehouse_location)
  • StockDate (stock_date)

주문 (Order)

  • OrderID (order_id) — 기본 키
  • OrderDate (order_date)
  • PaymentMethod (payment_method)
  • TotalAmount (total_amount)
  • OrderStatus (order_status)
  • CustomerID (customer_id) — 외래 키 → 고객.CustomerID

주문_상품 (Order_Product)

  • OrderID (order_id) — 외래 키 → 주문.OrderID
  • ProductID (product_id) — 외래 키 → 상품.ProductID
  • Quantity (quantity)

카테고리 (Category)

  • CategoryID (category_id) — 기본 키
  • CategoryName (category_name)

쿠폰 (Coupon)

  • CouponID (coupon_id) — 기본 키
  • CouponName (coupon_name)
  • Coupon_DiscountRate (coupon_discount_rate)
  • ExpirationDate (expiration_date)
  • Used (used)