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)