Entity–Relationship Diagram
Generated with MySQL Workbench.
ER diagram exported from MySQL Workbench
Key Relationships
Main foreign key relationships and their cardinality.
Laboratory──1 : N──→Study1 : NOne lab can run multiple studies
Study──1 : N──→Participant1 : NOne study has many participants
Role──1 : N──→User1 : NOne role assigned to many users
Participant──1 : N──→Visit1 : NOne participant has many visits over time
Visit──1 : N──→ClinicaDataValue1 : NEach visit records many data values
ClinicalVariable──1 : N──→ClinicaDataValue1 : NEach variable appears in many data values
Visit──1 : N──→ClinicalFile1 : NEach visit can have associated files (images, sequencing data…)
User──1 : N──→ClinicalFile1 : NEach user can have associated files (images, sequencing data…)