sale_id date_id day month year product_id product_name price customer_id

1 20231101 1 11 2023 1001 T-Shirt 25 201

2 20231102 2 11 2023 1002 Laptop 1000 202
3 20231103 3 11 2023 1003 Coffee Mug 15 203
4 20231104 4 11 2023 1004 Jeans 40 204
5 20231105 5 11 2023 1005 Jacket 120 205
6 20231106 6 11 2023 1006 Sneakers 90 206
7 20231107 7 11 2023 1007 Hat 15 207
8 20231108 8 11 2023 1008 Backpack 50 208
9 20231109 9 11 2023 1009 Smartphone 600 209
10 20231110 10 11 2023 1010 Watch 150 210
first_name last_name email store_id store_name store_location store_type_name
John Doe john.doe@ 3001 Store A New York Online
Jane Smith jane.smit 3002 Store B Los Angeles Physical
Alice Johnson alice@ema 3001 Store A New York Online
Bob Brown bob.brown 3003 Store C Chicago Physical
Carol White carol.whit 3002 Store B Los Angeles Physical
David Green david.gre 3001 Store A New York Online
Eva Black eva.black 3003 Store C Chicago Physical
Frank Blue frank.blue 3002 Store B Los Angeles Physical
Grace Yellow grace.yel 3001 Store A New York Online
Henry Red henry.red@email.com
3003 Store C Chicago Physical
payment_method_id payment_type quantity_soldtotal_sale_amount
1 Credit Card 2 50
2 PayPal 1 20
1 Credit Card 3 75
1 Credit Card 1 40
2 PayPal 2 240
1 Credit Card 1 90
2 PayPal 3 45
1 Credit Card 2 100
2 PayPal 1 600
1 Credit Card 2 300
payment_method_id
payment_type
quantity_sold
1 Credit Card 2
2 PayPal 1
1 Credit Card 3
1 Credit Card 1
2 PayPal 2
1 Credit Card 1
2 PayPal 3
1 Credit Card 2
2 PayPal 1
1 Credit Card 2
store_id store_name
store_location
store_type_name
3001 Store A New York Online
3002 Store B Los AngelePhysical
3001 Store A New York Online
3003 Store C Chicago Physical
3002 Store B Los AngelePhysical
3001 Store A New York Online
3003 Store C Chicago Physical
3002 Store B Los AngelePhysical
3001 Store A New York Online
3003 Store C Chicago Physical
product_id
product_name price
1001 T-Shirt 25
1002 Laptop 1000
1003 Coffee Mu 15
1004 Jeans 40
1005 Jacket 120
1006 Sneakers 90
1007 Hat 15
1008 Backpack 50
1009 Smartphon 600
1010 Watch 150
customer_idfirst_namelast_name email
201 John Doe john.doe@email.com
202 Jane Smith jane.smith@email.com
203 Alice Johnson alice@email.com
204 Bob Brown bob.brown@email.com
205 Carol White carol.white@email.com
206 David Green david.green@email.com
207 Eva Black eva.black@email.com
208 Frank Blue frank.blue@email.com
209 Grace Yellow grace.yellow@email.com
210 Henry Red henry.red@email.com
date_id day month year
20231101 1 11 2023
20231102 2 11 2023
20231103 3 11 2023
20231104 4 11 2023
20231105 5 11 2023
20231106 6 11 2023
20231107 7 11 2023
20231108 8 11 2023
20231109 9 11 2023
20231110 10 11 2023