000
Tables (9)
Campaign
- Campaign_ID — INT
- Campaign_Name — VARCHAR(100)
- Campaign_Type — VARCHAR(50)
- Target_Age_Group — VARCHAR(100)
- Target_Segment — VARCHAR(100)
- Start_Date — DATE
- End_Date — DATE
- Objective — VARCHAR(255)
Coupon
- Coupon_ID — INT
- Campaign_ID — INT
- Coupon_Code — VARCHAR(50)
- Discount_Percentage — INT
- Expiration_Date — DATE
- Redemption_Rate — FLOAT
Customer
- Customer_ID — INT
- Name — VARCHAR(100)
- Age — INT
- Gender — VARCHAR(10)
- Contact_Info — VARCHAR(255)
- Purchase_History — TEXT
- Membership_Status — VARCHAR(50)
- Preferred_Channel — VARCHAR(50)
Customer_Segment
- Customer_ID — INT
- Segment_ID — INT
POS_Transaction
- Transaction_ID — INT
- Store_ID — INT
- Purchase_ID — INT
- Coupon_ID — INT
- Transaction_Date — DATE
- Total_Amount — DECIMAL(10, 2)
Promotion
- Promotion_ID — INT
- Campaign_ID — INT
- Promotion_Type — VARCHAR(50)
- Discount_Details — VARCHAR(255)
- Start_Date — DATE
- End_Date — DATE
Purchase
- Purchase_ID — INT
- Customer_ID — INT
- Campaign_ID — INT
- Purchase_Date — DATE
- Amount — DECIMAL(10, 2)
- Product_Category — VARCHAR(100)
- Channel — VARCHAR(50)
Segment
- Segment_ID — INT
- Segment_Name — VARCHAR(100)
- Criteria — VARCHAR(255)
Store
- Store_ID — INT
- Store_Location — VARCHAR(255)
- Store_Type — VARCHAR(50)