DSMS (department store management system)

테이블 (6)

고객 (Customer)

  • customer_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • age (Field2)
  • gender (Field3)
  • membership_level (Field4)
  • contact_info (Field5)

구매 내역 (Purchase)

  • purchase_id (Key) — 기본 키 — NOT NULL
  • customer_id (Key2) — 외래 키 → 고객.customer_id — NOT NULL
  • purchase_date (Field2)
  • total_amount (Field3)
  • coupon_id (Key3) — 외래 키 → 쿠폰.coupon_id — NOT NULL

구매상세 (Purchase_Item)

  • product_id (Key) — 외래 키 → 상품.product_id — NOT NULL
  • purchase_id (Key2) — 외래 키 → 구매 내역.purchase_id — NOT NULL
  • quantity (Field3)

상품 (Product)

  • product_id (Key) — 기본 키 — NOT NULL
  • product_name (Field)
  • category (Field2)
  • price (Field3)

캠페인 (Campaign)

  • campaign_id (Key) — 기본 키 — NOT NULL
  • campaign_name (Field)
  • start_date (Field2)
  • end_date (Field3)
  • target_audience (Field4)
  • coupon_id (Key2) — 외래 키 → 쿠폰.coupon_id — NOT NULL

쿠폰 (Coupon)

  • coupon_id (Key) — 기본 키 — NOT NULL
  • campaign_id (Field)
  • discount_amount (Field2)
  • expiration_date (Field3)