DATABASE
W5-05
ER DIAGRAM
Entity Relationship Diagram ของร้านค้าออนไลน์
CUSTOMER
🔑 customer_id
name
email
phone
ORDERS
🔑 order_id
order_date
total_amount
customer_id
PRODUCTS
🔑 product_id
product_name
price
stock
ORDER_ITEMS
🔑 order_item_id
order_id
product_id
quantity
CATEGORY
🔑 category_id
category_name
description
status