## Marketing_Campaigns

id | campaign_name | start_date | end_date
--- | --- | --- | ---
1 | Spring Sale | 2022-05-01 | 2022-05-31
2 | Summer Promotion | 2022-06-01 | 2022-06-30
3 | Autumn Event | 2022-09-01 | 2022-09-30
4 | Winter Offer | 2022-11-01 | 2022-11-30
5 | New Year Special | 2023-01-01 | 2023-01-31

## Approaches

id | approach_value
--- | ---
1 | Direct Mail
2 | Email Campaign
3 | Telephone Call
4 | Online Advertising
5 | Print Media

## Marketing_Campaigns_Approaches

marketing_campaign_id | approach_id
--- | ---
(→ Marketing_Campaigns.id) | (→ Approaches.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 4

## Customers

customer_id | first_name | last_name | email
--- | --- | --- | ---
1 | John | Doe | john@gmail.com
2 | Jane | Smith | jane@yahoo.com
3 | Mike | Brown | mike@hotmail.com
4 | Emma | White | emma@outlook.com
5 | Robert | Black | robert@aol.com

## Transactions

transaction_id | amount | date | customer_id
--- | --- | --- | ---
|  |  | (→ Customers.customer_id)
1 | 300.78 | 2022-06-01 | 1
2 | 500.99 | 2022-06-02 | 2
3 | 200.66 | 2022-06-03 | 3
4 | 100.45 | 2022-06-04 | 4
5 | 700.25 | 2022-06-05 | 5