ER Diagram

erDiagram ActivityDefinition { string activity_definition_id string name string description uriorcurieList external_id } Aliquot { string aliquot_id EnumAvailabilityStatus availablity_status float quantity_number float concentration_number uriorcurieList external_id } BiospecimenCollection { string biospecimen_collection_id float age_at_collection EnumSampleCollectionMethod method EnumSite site EnumSpatialQualifiers spatial_qualifier EnumLaterality laterality uriorcurieList external_id } Concept { uriorcurie concept_curie string display } DOI { string do_id string bibliographic_reference uriorcurieList external_id } Dataset { string dataset_id string name string description string data_collection_start string data_collection_end } Demographics { 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 } Encounter { string encounter_id integer age_at_event uriorcurieList external_id } EncounterDefinition { string encounter_definition_id string name string description uriorcurieList external_id } File { string file_id string filename EnumEDAMFormats format EnumDataCategory data_category EnumEDAMDataTypes data_type integer size uriorcurie staging_url uriorcurie release_url uriorcurie drs_uri uriorcurieList external_id } FileHash { EnumFileHashType hash_type string hash_value } Investigator { string name string institution string investigator_title string email uriorcurieList external_id } Publication { string bibliographic_reference uri website uriorcurieList external_id } Record { uriorcurieList external_id } Sample { string sample_id uriorcurie sample_type uriorcurieList processing EnumAvailabilityStatus availablity_status uriorcurieList storage_method float quantity_number uriorcurieList external_id } Study { string study_id string study_title string study_code string study_short_name EnumProgramList program stringList funding_source string study_description uri website string acknowledgments string citation_statement uriorcurieList external_id } StudyMetadata { EnumParticipantLifespanStageList participant_lifespan_stage string selection_criteria EnumStudyDesignList study_design EnumClinicalDataSourceTypeList clinical_data_source_type EnumDataCategoryList data_category EnumResearchDomainList research_domain integer expected_number_of_participants integer actual_number_of_participants uriorcurieList external_id } Subject { string subject_id EnumSubjectType subject_type uriorcurie organism_type uriorcurieList external_id } SubjectAssertion { string assertion_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_unit_source uriorcurieList external_id } VirtualBiorepository { string name string institution uri website string vbr_readme uriorcurieList external_id } Aliquot ||--|o Concept : "concentration_unit" Aliquot ||--|o Concept : "quantity_unit" Aliquot ||--|o Sample : "sample_id" BiospecimenCollection ||--|o Encounter : "encounter_id" Dataset ||--|o DOI : "do_id" Dataset ||--}o File : "file_id" Dataset ||--}o Publication : "publication" Demographics ||--|| Subject : "subject_id" Encounter ||--|o EncounterDefinition : "encounter_definition_id" Encounter ||--|o Subject : "subject_id" EncounterDefinition ||--}o ActivityDefinition : "activity_definition_id" File ||--|o FileHash : "hash" File ||--}o Sample : "sample_id" File ||--}o Subject : "subject_id" Sample ||--|o BiospecimenCollection : "biospecimen_collection_id" Sample ||--|o Concept : "quantity_unit" Sample ||--|o Sample : "parent_sample_id" Study ||--|o DOI : "do_id" Study ||--|o Study : "parent_study" Study ||--}o Publication : "publication" Study ||--}| Investigator : "contact" Study ||--}| Investigator : "principal_investigator" StudyMetadata ||--|o VirtualBiorepository : "vbr" StudyMetadata ||--|| Study : "study_id" SubjectAssertion ||--|o Concept : "value_unit" SubjectAssertion ||--|o Encounter : "encounter_id" SubjectAssertion ||--|o Subject : "subject_id" SubjectAssertion ||--}o Concept : "concept" SubjectAssertion ||--}o Concept : "value_concept" VirtualBiorepository ||--}| Investigator : "contact"