Opleidingen

Hieronder staat de broncode van het diagram hierboven. Dit kun je gebruiken om het diagram te bewerken op dbdiagram.io.

table Person {
  Id int [pk]
}

table LearningModule {
  Id int [pk]
  GroupId int [ref: - Group.Id]
  Type int
}

table LearningModuleTasks {
  LearningModuleId int [ref: - LearningModule.Id]
  TaskId int [ref: - LearningTask.Id]
}

table LearningTask {
  Id int [pk]
}

table Group {
  Id int [pk]
}

table GroupClass {
  Id int [pk]
  GroupId int [ref: > Group.Id]
}

table GroupClassDate {
  Id int [pk]
  GroupClassId int [ref: > GroupClass.Id]
  Date date
  From string
  Till string
}

table GroupClassDateTrainer {
  Id int [pk]
  GroupClassDateId int [ref: > GroupClassDate.Id]
  TrainerId int [ref: - Person.Id]
}

table GroupMember {
  Id int [pk]
  PersonId int [ref: - Person.Id]
  GroupId int [ref: - Group.Id]
  GroupClassId int [ref: - GroupClass.Id]
  Role int
}