HW1
Tables (4)
DeliveryCompany
- company_id — INT
- company_name — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
DeliveryInfo
- product_id — INT
- company_id — INT
- warehouse_id — INT
- delivery_method — VARCHAR(50)
- delivery_cost — DECIMAL(10, 2)
Product
- product_id — INT
- product_name — VARCHAR(100) — NOT NULL
Warehouse
- warehouse_id — INT
- address — VARCHAR(255) — NOT NULL