Marketing_Campaigns

idcampaign_namestart_dateend_date
1Spring Sale2022-05-012022-05-31
2Summer Promotion2022-06-012022-06-30
3Autumn Event2022-09-012022-09-30
4Winter Offer2022-11-012022-11-30
5New Year Special2023-01-012023-01-31

Approaches

idapproach_value
1Direct Mail
2Email Campaign
3Telephone Call
4Online Advertising
5Print Media

Marketing_Campaigns_Approaches

marketing_campaign_idapproach_id
(→ Marketing_Campaigns.id)(→ Approaches.id)
11
21
31
41
51
54

Customers

customer_idfirst_namelast_nameemail
1JohnDoejohn@gmail.com
2JaneSmithjane@yahoo.com
3MikeBrownmike@hotmail.com
4EmmaWhiteemma@outlook.com
5RobertBlackrobert@aol.com

Transactions

transaction_idamountdatecustomer_id
(→ Customers.customer_id)
1300.782022-06-011
2500.992022-06-022
3200.662022-06-033
4100.452022-06-044
5700.252022-06-055