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