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)