ISD Team Project

Tables (9)

delivery

  • deliveryID (delivery_id) — int(10) — Primary key — NOT NULL
  • supplier_id — int(10) — Foreign key → supplier.supplierID — NOT NULL
  • deliveryDate (delivery_date) — Daytime

deliverydetail

  • deliveryID (delivery_id) — int(10) — Foreign key → delivery.deliveryID — NOT NULL
  • productID (product_id) — int(10) — Foreign key → product.productID — NOT NULL
  • orderID (order_id) — int(10) — Foreign key → order.orderID — NOT NULL
  • userID (user_id) — int(10) — Foreign key → order.userID — NOT NULL
  • detail_qty — int(10)

order

  • orderID (order_id) — int(10) — Primary key — NOT NULL
  • userID (user_id) — int(10) — Foreign key → user.userID — NOT NULL
  • orderDate (order_date) — Daytime
  • expectedArrivalDate (expected_arrivaldate) — int(10)
  • orderTotalCost (order_totalcost) — int(10)
  • order_status — varchar(50)

orderdetail

  • orderID (order_id) — int(10) — Foreign key → order.orderID — NOT NULL
  • supplierID (supplier_id) — int(10) — Foreign key → supplier.supplierID — NOT NULL
  • productID (product_id) — int(10) — Foreign key → product.productID — NOT NULL
  • detailQty (detail_qty) — int(10)
  • discount — int(10)
  • description — varchar(50)
  • supplier_sellingprice — int(10)

product

  • productID (product_id) — int(10) — Primary key — NOT NULL
  • productName (product_name) — varchar(50)
  • productSellingPrice (product_sellingprice) — varchar(50)
  • productVolume (product_volume) — varchar(50)
  • productQty (product_qty) — int(10)
  • productWeight (product_weight) — int(10)
  • productMinqty (product_minQty) — int(10)
  • productLocation (product_location) — varchar(50)
  • category (product_category) — varchar(50)
  • maintenance_cost — int(10)

shipment

  • shipmentID (shipment_id) — int(10) — Primary key — NOT NULL
  • wareHouseOutdata (warehouse_outdate) — Daytime
  • shipment_status — varchar(50)

shipmentdetail

  • productID (product_id) — int(10) — Foreign key → product.productID — NOT NULL
  • shipmentID (shipment_id) — int(10) — Foreign key → shipment.shipmentID — NOT NULL
  • customerArrivalDate (customer_arrival_date) — Daytime
  • detail_qty — int(10)

supplier (Supplier)

  • supplierID (supplier_id) — int(10) — Primary key — NOT NULL
  • supplierName (supplier_name) — varchar(50)
  • supplierLocation (supplier_address) — varchar(50)
  • supplierPhoneNumber (supplier_phoneNumber) — varchar(50)

user

  • userID (user_id) — int(10) — Primary key — NOT NULL
  • userAddress (user_address) — varchar(50)
  • userPhoneNumber (user_phoneNumber) — varchar(50)
  • userEmail (user_email) — varchar(50)
  • userPassword (user_password) — varchar(50)
  • userName (user_name) — varchar(50)
  • userRole (user_role) — varchar(50)
  • userEnterYear (user_enterYear) — Daytime