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)