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)