dk

Tables (8)

Campaign

  • CampaignID — INT — Primary key
  • CampaignName — VARCHAR(255)
  • StartDate — DATE
  • EndDate — DATE
  • Objective — VARCHAR(255)

CampaignParticipation

  • ParticipationID — INT — Primary key
  • CustomerID — INT — Foreign key → Customer.CustomerID
  • CampaignID — INT — Foreign key → Campaign.CampaignID
  • ParticipationDate — DATE

Coupon

  • CouponID — INT — Primary key
  • CouponName — VARCHAR(255)
  • DiscountRate — FLOAT
  • ExpiryDate — DATE

CouponUsage

  • CouponUsageID — INT — Primary key
  • CouponID — INT — Foreign key → Coupon.CouponID
  • CustomerID — INT — Foreign key → Customer.CustomerID
  • UsageDate — DATE

Customer

  • CustomerID — INT — Primary key
  • Name — VARCHAR(255)
  • DateOfBirth — DATE
  • ContactInfo — VARCHAR(255)
  • Gender — VARCHAR(10)
  • MembershipLevel — VARCHAR(50)

Product

  • ProductID — INT — Primary key
  • ProductName — VARCHAR(255)
  • Category — VARCHAR(100)
  • Price — FLOAT

Purchase

  • PurchaseID — INT — Primary key
  • CustomerID — INT — Foreign key → Customer.CustomerID
  • PurchaseDate — DATE
  • TotalAmount — FLOAT
  • Channel — VARCHAR(50)

PurchaseDetail

  • PurchaseDetailID — INT — Primary key
  • PurchaseID (PurchaseID2) — INT — Foreign key → Purchase.PurchaseID
  • ProductID — INT
  • Quantity — INT
  • SubTotal — FLOAT
  • ProductID (ProductID2) — INT — Foreign key → Product.ProductID