test
Tables (4)
Customer
- Key — Primary key — NOT NULL
- customer_id — INT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(20)
- created_at — DATETIME
Order_Item
- order_item_id — INT
- order_id — INT — Foreign key → Orders.order_id
- product_id — INT — Foreign key → Product.product_id
- order_price — INT
- quantity — INT
- Key — Foreign key → Orders.Key — NOT NULL
Orders
- order_id — INT
- customer_id — INT — Foreign key → Customer.customer_id
- order_date — DATETIME
- total_amount — INT
- Key — Foreign key → Customer.Key — NOT NULL
Product
- product_id — INT
- product_name — VARCHAR(100) — NOT NULL
- price — INT — NOT NULL
- stock_quantity — INT