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)