er
Tables (5)
customers
- customer_id — int — Primary key — NOT NULL
- customer_name — varchar(255)
- email — varchar(255)
order_items
- order_item_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → orders.order_id
- product_id — int — Foreign key → products.product_id
- quantity — int
orders
- order_id — int — Primary key — NOT NULL
- customer_id — int — Foreign key → customers.customer_id
- order_date — date
products
- product_id — int — Primary key — NOT NULL
- product_name — varchar(255)
- price — decimal(10,2)
reviews
- review_id — int — Primary key — NOT NULL
- product_id — int — Foreign key → products.product_id
- customer_id — int — Foreign key → customers.customer_id
- rating — int
- comment — text