customer_id
(Primary Key)
name
, email
, phone
registration_date
address
order_id
(Primary Key)
customer_id
(Foreign Key to Customers)
product_id
(Foreign Key to Products)
order_date
, quantity
, price
product_id
(Primary Key)
product_name
, category
, price
, cost
order_id
(Foreign Key to Orders)
event_type
(payment, delivery status, etc.)
event_date
, amount
interaction_id
(Primary Key)
customer_id
(Foreign Key to Customers)
interaction_date
, interaction_type
, interaction_details
return_id
(Primary Key)
order_id
(Foreign Key to Orders)
product_id
(Foreign Key to Products)
return_date
, return_reason
, refund_amount
loyalty_id
(Primary Key)
customer_id
(Foreign Key to Customers)
loyalty_points
, membership_level
, points_earned
, points_redeemed
campaign_id
(Primary Key)
customer_id
(Foreign Key to Customers)
campaign_type
, campaign_date
, campaign_response