Proto

Tables (3)

buyTBL

  • Field
  • userName (CHAR(3))
  • prodName (VARCHAR(45))
  • amount (INT)

prodTBL

  • prodName (Key) — Primary key — NOT NULL
  • price (INT)
  • Field

userTBL

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