D-link
Tables (6)
Comment
- Comment_ID — INT
- Group_ID — INT — Foreign key
- Writer_ID — INT — Foreign key
- Content — VARCHAR(500)
- Created_At — DATETIME
GroupMember
- Group_ID — INT — Foreign key → StudyGroup.Group_ID
- Student_ID — INT — Foreign key → Student.Student_ID
- Join_Date — DATE
Meeting
- Meeting_ID — INT
- Group_ID — INT — Foreign key
- Meeting_Date — DATETIME
- Location — VARCHAR(100)
Student
- Student_ID — INT
- Name — VARCHAR(50)
- Major — VARCHAR(50)
StudyGroup
- Group_ID — INT
- Subject_ID — VARCHAR(20) — Foreign key → Subject.Subject_ID
- Leader_ID — INT — Foreign key → Student.Student_ID
- Title — VARCHAR(200)
- Max_Members — INT
Subject
- Subject_ID — VARCHAR(20)
- Subject_Name — VARCHAR(100)
- Category — VARCHAR(50)