MIS5
Tables (13)
Cart
- Cart_ID — INT
- Customer_ID — INT
- Product_ID — INT
- Added_Date — DATE
- Quantity — INT
Customer
- Customer_ID — INT
- Name — VARCHAR(100)
- Phone — VARCHAR(20)
- Address — TEXT
- Preferred_Category — VARCHAR(50)
- Age — INT
- Gender — VARCHAR(20)
Delivery
- Delivery_ID — INT
- Order_ID — INT
- Warehouse_ID — INT
- Cluster_ID — INT
- Start_Time — DATETIME
- End_Time — DATETIME
- Delivery_Manager — VARCHAR(100)
Homeplus
- Homeplus_ID — INT
- Name — VARCHAR(100)
- Location — TEXT
Inventory
- Inventory_ID — INT
- Product_ID — INT
- Homeplus_ID — INT
- Quantity — INT
- Arrival_Date — DATE
Order
- Order_ID — INT
- Customer_ID — INT
- Order_Date — DATE
- Delivery_Date — DATE
- Delivery_Type — VARCHAR(20)
- Is_Curated — BOOLEAN
- From_Homeplus_ID — INT
- To_Warehouse_ID — INT
Order_Detail
- Order_ID — INT
- Product_ID — INT
- Quantity — INT
- Storage_Type — VARCHAR(10)
Product
- Product_ID — INT
- Name — VARCHAR(100)
- Category — VARCHAR(50)
- Price — DECIMAL(10,2)
- Expiration_Date — DATE
- Storage_Type — VARCHAR(10)
- Warehouse_ID — INT
Recommendation
- Rec_ID — INT
- Customer_ID — INT
- Product_ID — INT
- Reason — TEXT
- Recommended_Date — DATE
Recommendation_Source
- Source_ID — INT
- Rec_ID — INT
- Source_Type — VARCHAR(20)
Review
- Review_ID — INT
- Product_ID — INT
- Customer_ID — INT
- Rating — INT
- Comment — TEXT — EX
- Review_Date — DATE
Transfer
- Transfer_ID — INT
- Order_ID — INT
- Product_ID — INT
- From_Homeplus_ID — INT
- To_Warehouse_ID — INT
- Transfer_Date — DATE
Warehouse
- Warehouse_ID — INT
- Location — TEXT
- Operating_Hours — VARCHAR(100)