SSUBOOK

Tables (3)

Board (Untitled3)

  • bid — INT — Primary key — NOT NULL
  • BGid (BGid2) — INT — Foreign key → BoardGroup.BGid — NOT NULL
  • uid (uid2) — INT — Foreign key → User.uid — NOT NULL
  • bgid (BGid) — INT
  • uid — INT
  • Title — VARCHAR(40)
  • Subject — VARCHAR(255)
  • Date — VARCHAR(40)

BoardGroup (Untitled2)

  • BGid — INT — Primary key — NOT NULL
  • BGName — VARCHAR(20)

User (Untitled)

  • uid — INT — Primary key — NOT NULL
  • id — VARCHAR(8)
  • password — VARCHAR(20)
  • nickname — VARCHAR(20)
  • name — VARCHAR(20)
  • email — VARCHAR(40)
  • profilepic — VARCHAR(255)
  • phone — VARCHAR(13)
  • Major — VARCHAR(5)
  • MajorSpec — VARCHAR(20)
  • Notify — BOOLEAN