A

Tables (4)

Board

  • boardID — int(11) — Primary key — NOT NULL
  • userID — varchar(30) — Foreign key → User.userID — NOT NULL
  • userNick (userNickn) — varchar(30)
  • boardTitle — varchar(50)
  • boardContent — varchar(2048)
  • boardDate — datetime
  • boardHit — int(11)
  • boardDelete — int(11)

Chat

  • chatID — varchar(30) — Primary key — NOT NULL
  • fromID — varchar(30) — Foreign key → User.userID — NOT NULL
  • toID — varchar(30) — Foreign key → User.userID — NOT NULL
  • chatContent — varchar(200)
  • chatTime — datetime

StudyGroup

  • groupID — varchar(30) — Primary key — NOT NULL
  • groupMaster — varchar(30) — Foreign key → User.userID — NOT NULL
  • studyName (groupName) — varchar(30)
  • studyStart — datetime
  • studyFinish — datetime
  • studyLocation — varchar(50)
  • groupPop — int(11)

User

  • userID — varchar(30) — Primary key — NOT NULL
  • userPassword — varchar(30)
  • userNick — varchar(15)
  • userEmail — varchar(50)
  • userProfile — varchar(200)
  • userBorn — varchar(20)
  • userGender — varchar(20)
  • isCertificated — tinyint(1)