ER Diagram

erDiagram Concept { uriorcurie concept_curie string display } DOI { uri doi string bibliographic_reference uriorcurieList external_id } Demographics { string subject_id EnumSex sex EnumRaceList race EnumEthnicity ethnicity EnumDownSyndromeStatus down_syndrome_status integer age_at_last_vital_status EnumVitalStatus vital_status integer age_at_first_engagement uriorcurieList external_id } Investigator { string name string institution string invesitgator_title string email uriorcurieList external_id } Publication { string bibliographic_reference uri website uriorcurieList external_id } Record { uriorcurieList external_id } Study { string study_id stringList funding_source string study_title string study_code string study_short_name EnumProgramList program string study_description EnumResearchDomainList research_domain EnumParticipantLifespanStageList participant_lifespan_stage string selection_criteria EnumStudyDesignList study_design EnumClinicalDataSourceTypeList clinical_data_source_type EnumDataCategoryList data_category uri website integer expected_number_of_participants integer actual_number_of_participants string acknowledgments string citation_statement uri doi uriorcurieList external_id } Subject { string subject_id EnumSubjectType subject_type uriorcurie organism_type uriorcurieList external_id } SubjectAssertion { string assertion_id string subject_id EnumAssertionProvenance assertion_provenance integer age_at_assertion integer age_at_event integer age_at_resolution string concept_source float value_number string value_source string value_units_source uriorcurieList external_id } VirtualBiorepository { string name string institution uri website string vbr_readme uriorcurieList external_id } Study ||--|o Study : "parent_study" Study ||--|o VirtualBiorepository : "vbr" Study ||--}o Publication : "publication" Study ||--}| Investigator : "contact" Study ||--}| Investigator : "principal_investigator" SubjectAssertion ||--|o Concept : "value_units" SubjectAssertion ||--}o Concept : "concept" SubjectAssertion ||--}o Concept : "value_concept" VirtualBiorepository ||--}| Investigator : "contact"