Proto

Tables (3)

buyTBL

  • userName — VARCHAR(3) — Foreign key → userTBL.userName — NOT NULL
  • prodName — VARCHAR(45) — Foreign key → prodTBL.prodName — NOT NULL
  • amount — INT — NOT NULL

prodTBL

  • prodName — VARCHAR(45) — Primary key — NOT NULL
  • price — INT — NOT NULL
  • company — VARCHAR(45)

userTBL

  • userName — VARCHAR(3) — Primary key — NOT NULL
  • birthYear (birtYear) — INT — NOT NULL
  • addr — VARCHAR(45) — NOT NULL
  • mobile — VARCHAR(12)