shoppingmall

Tables (3)

Employee (Untitled3)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • pwd (Field) — varchar(20)
  • name (Field2) — varchar(20)
  • email (Field3) — varchar(40)
  • phonev (Field4) — varchar(20)

Product (Untitled2)

  • prodnum (Key) — number(5) — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • price (Field2) — INT
  • content (Field3) — varchar(1000)
  • UserNumber (Field4) — varchar(20) — Foreign key → User.UserNumber

User (Untitled)

  • UserNumber (Field) — varchar(20) — Primary key
  • pwd (Field2) — varchar(20)
  • name (Field3) — varchar(20)
  • email (Field4) — varchar(40)
  • address (Field5) — varchar(100)
  • phone (Field6) — varchar(20)