ER Diagram

erDiagram AccessPolicy { string access_description coGlobalID access_policy_id uriorcurie data_use_accession EnumDataUseModifier data_use_modifier EnumDataUsePermission data_use_permission string disease_limitation uri website } ActivityDefinition { string name string description adGlobalID activity_definition_id uriorcurieList external_id } Aliquot { string aliquot_id EnumAvailabilityStatus availability_status float concentration_number float quantity_number uriorcurieList external_id } Any { } Assay { diGlobalID assay_id string assay_source EnumAssayType assay_type uriorcurieList external_id } BiospecimenCollection { float age_at_collection string biospecimen_collection_id EnumSampleCollectionMethod method uriorcurieList external_id } Concept { uriorcurie concept_curie string display } DOI { string bibliographic_reference string do_id uriorcurieList external_id } Dataset { string name string description string data_collection_end string data_collection_start lsGlobalID dataset_id } Demographics { integer age_at_first_engagement integer age_at_last_vital_status uriorcurieList external_id } Encounter { integer age_at_event enGlobalID encounter_id uriorcurieList external_id } EncounterDefinition { string name string description pdGlobalID encounter_definition_id uriorcurieList external_id } Family { EnumPresentAbsent consanguinity string family_description grGlobalID family_id uriorcurie family_study_focus EnumFamilyType family_type uriorcurieList external_id } FamilyMembership { string family_membership_id uriorcurieList external_id } FamilyRelationship { fmGlobalID family_relationship_id uriorcurieList external_id } File { EnumAvailabilityStatus availability EnumEDAMDataTypes data_type uriorcurie drs_uri string file_extension drGlobalID file_id string filename EnumEDAMFormats format uriorcurie internal_uri uriorcurie release_uri integer size string storage_class uriorcurieList external_id } FileHash { EnumFileHashType hash_type string hash_value } IncludeParticipant { EnumDownSyndromeStatus down_syndrome_status integer age_at_first_engagement integer age_at_last_vital_status uriorcurieList external_id } Investigator { string name string email string institution string investigator_title uriorcurieList external_id } Publication { string bibliographic_reference uri website uriorcurieList external_id } Record { uriorcurieList external_id } Sample { EnumAvailabilityStatus availability_status uriorcurieList processing float quantity_number bsGlobalID sample_id uriorcurie sample_type uriorcurieList storage_method uriorcurieList external_id } Study { string acknowledgments string citation_statement stringList funding_source uriorcurieList program string study_code string study_description sdGlobalID study_id string study_short_name string study_title uri website uriorcurieList external_id } StudyMetadata { integer actual_number_of_participants EnumDataSourceTypeList clinical_data_source_type integer expected_number_of_participants EnumParticipantLifespanStageList participant_lifespan_stage string selection_criteria uriorcurieList external_id } Subject { uriorcurie organism_type ptGlobalID subject_id uriorcurieList external_id } SubjectAssertion { integer age_at_assertion integer age_at_event integer age_at_resolution EnumAsserterType asserter_type string assertion_id EnumDataSourceType assertion_source_type string concept_source float value_number string value_source string value_unit_source uriorcurieList external_id } VirtualBiorepository { string name string institution orGlobalID vbr_id string vbr_readme uri website uriorcurieList external_id } ActivityDefinition ||--|o AccessPolicy : "access_policy_id" ActivityDefinition ||--|o Study : "study_id" Aliquot ||--|o AccessPolicy : "access_policy_id" Aliquot ||--|o Concept : "concentration_unit, quantity_unit" Aliquot ||--|o Sample : "sample_id" Aliquot ||--|o Study : "study_id" Assay ||--|o AccessPolicy : "access_policy_id" Assay ||--|o ActivityDefinition : "activity_definition_id" Assay ||--|o Study : "study_id" Assay ||--}o File : "file_id" Assay ||--}o Sample : "sample_id" Assay ||--}o Subject : "subject_id" BiospecimenCollection ||--|o AccessPolicy : "access_policy_id" BiospecimenCollection ||--|o Concept : "laterality, site, spatial_qualifier" BiospecimenCollection ||--|o Encounter : "encounter_id" BiospecimenCollection ||--|o Study : "study_id" DOI ||--|o AccessPolicy : "access_policy_id" DOI ||--|o Study : "study_id" Dataset ||--|o DOI : "do_id" Dataset ||--}o File : "file_id" Dataset ||--}o Publication : "publication" Demographics ||--|o AccessPolicy : "access_policy_id" Demographics ||--|o Concept : "vital_status" Demographics ||--|o Study : "study_id" Demographics ||--|| Concept : "ethnicity, sex" Demographics ||--|| Subject : "subject_id" Demographics ||--}| Concept : "race" Encounter ||--|o AccessPolicy : "access_policy_id" Encounter ||--|o EncounterDefinition : "encounter_definition_id" Encounter ||--|o Study : "study_id" Encounter ||--|o Subject : "subject_id" EncounterDefinition ||--|o AccessPolicy : "access_policy_id" EncounterDefinition ||--|o Study : "study_id" EncounterDefinition ||--}o ActivityDefinition : "activity_definition_id" Family ||--|o AccessPolicy : "access_policy_id" Family ||--|o Study : "study_id" FamilyMembership ||--|o AccessPolicy : "access_policy_id" FamilyMembership ||--|o Concept : "family_role" FamilyMembership ||--|o Study : "study_id" FamilyMembership ||--|| Family : "family_id" FamilyMembership ||--|| Subject : "subject_id" FamilyRelationship ||--|o AccessPolicy : "access_policy_id" FamilyRelationship ||--|o Study : "study_id" FamilyRelationship ||--|| Concept : "relation" FamilyRelationship ||--|| Subject : "family_member_id, subject_id" File ||--|o AccessPolicy : "access_policy_id" File ||--|o Concept : "data_category" File ||--|o Study : "study_id" File ||--}o FileHash : "hash" File ||--}o Sample : "sample_id" File ||--}o Subject : "subject_id" IncludeParticipant ||--|o AccessPolicy : "access_policy_id" IncludeParticipant ||--|o Concept : "vital_status" IncludeParticipant ||--|o Study : "study_id" IncludeParticipant ||--|| Concept : "ethnicity, sex" IncludeParticipant ||--|| Subject : "subject_id" IncludeParticipant ||--}| Concept : "race" Investigator ||--|o AccessPolicy : "access_policy_id" Investigator ||--|o Study : "study_id" Publication ||--|o AccessPolicy : "access_policy_id" Publication ||--|o Study : "study_id" Record ||--|o AccessPolicy : "access_policy_id" Record ||--|o Study : "study_id" Sample ||--|o AccessPolicy : "access_policy_id" Sample ||--|o BiospecimenCollection : "biospecimen_collection_id" Sample ||--|o Concept : "quantity_unit" Sample ||--|o Sample : "parent_sample_id" Sample ||--|o Study : "study_id" Study ||--|o AccessPolicy : "access_policy_id" Study ||--|o DOI : "do_id" Study ||--|o Study : "parent_study" Study ||--}o Publication : "publication" Study ||--}| Investigator : "contact, principal_investigator" StudyMetadata ||--|o AccessPolicy : "access_policy_id" StudyMetadata ||--|o VirtualBiorepository : "vbr_id" StudyMetadata ||--|| Study : "study_id" StudyMetadata ||--}| Concept : "data_category, research_domain, study_design" Subject ||--|o AccessPolicy : "access_policy_id" Subject ||--|o Study : "study_id" Subject ||--|| Concept : "subject_type" SubjectAssertion ||--|o AccessPolicy : "access_policy_id" SubjectAssertion ||--|o Concept : "value_unit" SubjectAssertion ||--|o Encounter : "encounter_id" SubjectAssertion ||--|o Study : "study_id" SubjectAssertion ||--|o Subject : "subject_id" SubjectAssertion ||--}o Concept : "concept, value_concept" VirtualBiorepository ||--|o AccessPolicy : "access_policy_id" VirtualBiorepository ||--|o Study : "study_id" VirtualBiorepository ||--}| Investigator : "contact"