User Product ShoppingCart Order
id int 1 1 id int id int 1 id int
username varchar(50) name varchar(255) * user_id int * user_id int
email varchar(255) price decimal(10, 2) created_at datetime total_amount decimal(10, 2)
created_at datetime description text created_at datetime
created_at datetime
OrderItem
id int
order_id int *
product_id int *
quantity int
total_price decimal(10, 2)
User Product ShoppingCart Order
id int 1 1 id int id int 1 id int
username varchar(50) name varchar(255) * user_id int * user_id int
email varchar(255) price decimal(10, 2) created_at datetime total_amount decimal(10, 2)
created_at datetime description text created_at datetime
created_at datetime
OrderItem
id int
order_id int *
product_id int *
quantity int
total_price decimal(10, 2)