int customer_id PK

string name

string email

string shipping_address

int order_id PK

int customer_id FK

date order_date

string status

int product_id PK

string product_name

decimal price

int stock_quantity

int order_id PK,FK

int product_id PK,FK

int quantity