e-Commerce
Tables (5)
categories
- category_id — BIGINT
- category_name — VARCHAR(100) — NOT NULL
customers
- customer_id — BIGINT
- first_name — VARCHAR(50) — NOT NULL
- last_name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- phone — VARCHAR(30)
- city — VARCHAR(50)
- country — VARCHAR(50)
- signup_date — DATE — NOT NULL
order_items
- order_item_id — BIGINT
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(12,2) — NOT NULL
- discount_pct — DECIMAL(5,2) — NOT NULL
orders
- order_id — BIGINT
- customer_id — BIGINT — NOT NULL
- order_date — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- payment_method — VARCHAR(30) — NOT NULL
- shipping_fee — DECIMAL(12,2) — NOT NULL
products
- product_id — BIGINT
- category_id — BIGINT — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- unit_price — DECIMAL(12,2) — NOT NULL
- unit_cost — DECIMAL(12,2) — NOT NULL
- active — BOOLEAN — NOT NULL