miniProj-DB

Tables (4)

TB_Board (Untitled2)

  • Bno (Key) — int — Primary key — NOT NULL
  • UserName (Key2) — varchar — Foreign key → TB_Users.UserId
  • Btitle (Field) — varchar
  • Bcontent (Field2) — varchar
  • Bdate (Field4) — varchar

TB_UserHobby (Untitled4)

  • UserId (Key2) — Foreign key → TB_Users.UserId — NOT NULL
  • Hobbyno (Key3) — Foreign key → TB_hobby.Hobbyno — NOT NULL

TB_Users (Untitled)

  • UserId (Key) — varchar — Primary key — NOT NULL
  • UserPassword (Field) — varchar
  • UserName (Field3) — varchar
  • UserEmail (Field4) — varchar
  • UserGender (Field2) — varchar
  • UserPhoneNumber (Field5) — int

TB_hobby (Untitled3)

  • Hobbyno (Key) — Primary key — NOT NULL
  • Hname (Field)