assignment
Tables (9)
Campaign
- Campaign_ID — INT — Primary key — NOT NULL
- Campaign_Name
- Campaign_Type
- Target_Age_Group
- Target_Segment
- Start_Date — DATE
- End_Date — DATE
- Objective
Coupon
- Coupon_ID — INT — Primary key — NOT NULL
- Campaign_ID — INT — Foreign key → Campaign.Campaign_ID — NOT NULL
- Coupon_Code
- Discount_Precentage — INT
- Expiration_Date — DATE
- Redemption_Rate — FLOAT
Customer
- Customer_ID — INT — Primary key — NOT NULL
- Name
- Age — INT
- Gender
- Tel
- Purchase_History
- Membership_status
- Preferred_Channel
Customer_Segement
- Customer_ID — INT — Foreign key → Customer.Customer_ID — NOT NULL
- Segment_ID — INT — Foreign key → Segment.Segment_ID — NOT NULL
POS_Transaction (Pos_Transaction)
- Transaction_ID — INT — Primary key — NOT NULL
- Purchase_ID — INT — Foreign key → Purchase.Purchase_ID — NOT NULL
- Customer_ID — INT — Foreign key → Purchase.Customer_ID — NOT NULL
- Store_ID — INT — Foreign key → Purchase.Store_ID — NOT NULL
- Campaign_ID — INT — Foreign key → Purchase.Campaign_ID — NOT NULL
- Transaction_Date — DATE
- Total_Amount
Promotion
- Promotion_ID — INT — Primary key — NOT NULL
- Campaign_ID — INT — Foreign key → Campaign.Campaign_ID — NOT NULL
- Promotion_Type
- Discount_Details
- Start_Date — DATE
- End_Date — DATE
Purchase
- Purchase_ID — INT — Primary key — NOT NULL
- Customer_ID — INT — Foreign key → Customer.Customer_ID — NOT NULL
- Store_ID — INT — Foreign key → Store.Store_ID — NOT NULL
- Campaign_ID — INT — Foreign key → Campaign.Campaign_ID — NOT NULL
- Purchase_Date — DATE
- Amount
- Product_Category
- Channel
Segment (Segement)
- Segment_ID — INT — Primary key — NOT NULL
- Segment_Name
- Criteria
Store
- Store_ID — INT — Primary key — NOT NULL
- Store_Location
- Store_Type