SHOP
Tables (8)
Category
- category_id — INT
- category_name — VARCHAR(100) — NOT NULL
- parent_category_id — INT
Customer
- customer_id — INT
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- signup_date — DATE — NOT NULL
- default_delivery_id — INT
Delivery
- delivery_id — INT
- customer_id — INT — NOT NULL
- receiver_name — VARCHAR(50) — NOT NULL
- contact_phone — VARCHAR(20) — NOT NULL
- address — VARCHAR(200) — NOT NULL
- postal_code — VARCHAR(10)
- is_default — CHAR(1) — NOT NULL
Inventory
- product_id — INT — Primary key — NOT NULL
- warehouse_id — INT — Primary key — NOT NULL
- current_qty — INT — NOT NULL
- safety_qty — INT
Order_Item
- order_id — INT — Primary key — NOT NULL
- product_id — INT — Primary key — NOT NULL
- quantity — INT — NOT NULL
- unit_price — DECIMAL(10,2) — NOT NULL
- line_amount — DECIMAL(12,2) — NOT NULL
Orders
- order_id — INT
- customer_id — INT — NOT NULL
- order_date — DATETIME — NOT NULL
- delivery_id — INT — NOT NULL
- order_status — VARCHAR(20) — NOT NULL
- total_amount — DECIMAL(12,2) — NOT NULL
Product
- product_id — INT
- product_name — VARCHAR(100) — NOT NULL
- unit_price — DECIMAL(10,2) — NOT NULL
- description — TEXT
- reg_date — DATE — NOT NULL
- sales_status — VARCHAR(20) — NOT NULL
- category_id — INT — NOT NULL
Warehouse
- warehouse_id — INT
- warehouse_name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200)
- phone — VARCHAR(20)