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