GNG

Tables (4)

Product (product)

  • proIDX — INT(11) — Primary key — NOT NULL
  • proName — VARCHAR(45)
  • proCost — INT(11)

loadcell

  • loadcellnum — INT(11) — Primary key — NOT NULL
  • loadcellcnt — INT(11)

shopping

  • shopIDX — INT(11) — Primary key — NOT NULL
  • faceIDX (faceIDX2) — INT(11) — Foreign key → user.faceIDX
  • proIDX (proIDX2) — INT(11) — Foreign key → Product.proIDX — NOT NULL

user

  • faceIDX — INT(11) — Primary key
  • PW — VARCHAR(45)
  • Face
  • userID — VARCHAR(45) — NOT NULL