Palm oil

Tables (4)

Available_Products

  • Prod_title — varchar(40)
  • prod_category — varchar(35)
  • prod_price — varchar(40)
  • Pro_id (Pro_id2) — number — Foreign key → Product_info.Pro_id — NOT NULL

Customer(user)

  • Cust_id — number — Primary key — NOT NULL
  • Customer name (Cust_name) — varchar(30)
  • Cust_e-mail — varchar(40)
  • Cust_username — varchar(35)
  • Cust_password — varchar(40)

Image

  • Image_id — number — Primary key — NOT NULL
  • Image_category — varchar(40)
  • Image_Date (Imaget_Date) — date
  • Cust_id — number — Foreign key → Customer(user).Cust_id — NOT NULL

Product_info

  • Pro_id — number — Primary key — NOT NULL
  • Prod_name — varchar(40)
  • Prod_desc — varchar(35)
  • Prod_approval — varchar(5)
  • Image_id — number — Foreign key → Image.Image_id — NOT NULL