ISD Team Project 2
Tables (6)
employee
- user_id — int(10) — Primary key — NOT NULL
- user_address — varchar(50)
- user_phoneNumber — varchar(50)
- user_email — varchar(50)
- user_password — varchar(50)
- user_name — varchar(50)
- user_role — varchar(50)
- user_enterYear — Daytime
order
- order_id — int(10) — Primary key — NOT NULL
- user_id — int(10) — Foreign key → employee.user_id — NOT NULL
- order_date — Daytime
- estimated_date — int(10)
- order_totalcost — int(10)
- order_status — varchar(50)
- Field
orderdetail
- order_id — int(10) — Foreign key → order.order_id — NOT NULL
- product_id — int(10) — Foreign key → product.product_id — NOT NULL
- detail_qty — int(10)
- product_name — varchar(10)
- supplier_sellingprice — int(10)
- delivery_date — Daytime
product
- product_id — int(10) — Primary key — NOT NULL
- product_name — varchar(50)
- product_price — varchar(50)
- product_volume — varchar(50)
- product_stock — int(10)
- product_weight — int(10)
- product_minQty — int(10)
- product_location — varchar(50)
- product_category — varchar(50)
- maintenance_cost — int(10)
shipment
- shipment_id — int(10) — Primary key — NOT NULL
- shipment_date — Daytime
- order_status — varchar(50)
shipmentdetail
- product_id — int(10) — Foreign key → product.product_id — NOT NULL
- shipment_id — int(10) — Foreign key → shipment.shipment_id — NOT NULL
- delivery_date — Daytime
- detail_qty — int(10)
- product_name — varchar(50)