Shopping
Tables (3)
CUSTOMER
- customer_id — VARCHAR(36) — Primary key
- name — VARCHAR(255)
- email — VARCHAR(255)
- address — VARCHAR(255)
ORDER
- order_id — VARCHAR(36) — Primary key
- order_date — DATETIME
- quantity — INT
- customer_id — VARCHAR(36) — Foreign key → CUSTOMER.customer_id
- product_id — VARCHAR(36) — Foreign key → PRODUCT.product_id
PRODUCT
- product_id — VARCHAR(36) — Primary key
- name — VARCHAR(255)
- category — VARCHAR(255)
- price — DECIMAL(10, 2)