ER Diagram

erDiagram AccessPolicy { coGlobalID access_policy_id uriorcurie data_use_accession EnumDataUsePermission data_use_permission EnumDataUseModifier data_use_modifier string disease_limitation string access_description uri website } ActivityDefinition { adGlobalID 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 } Any { } Assay { diGlobalID assay_id EnumAssayType assay_type string assay_source uriorcurieList external_id } BiospecimenCollection { string biospecimen_collection_id float age_at_collection 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 { lsGlobalID dataset_id string name string description string data_collection_start string data_collection_end } Demographics { integer age_at_last_vital_status integer age_at_first_engagement uriorcurieList external_id } Encounter { enGlobalID encounter_id integer age_at_event uriorcurieList external_id } EncounterDefinition { pdGlobalID encounter_definition_id string name string description uriorcurieList external_id } Family { grGlobalID family_id EnumFamilyType family_type string family_description EnumPresentAbsent consanguinity uriorcurie family_study_focus uriorcurieList external_id } FamilyMembership { string family_membership_id uriorcurieList external_id } FamilyRelationship { fmGlobalID family_relationship_id uriorcurieList external_id } File { drGlobalID file_id string filename EnumEDAMFormats format string file_extension uriorcurie data_category EnumEDAMDataTypes data_type integer size uriorcurie internal_uri uriorcurie release_uri uriorcurie drs_uri string storage_class EnumAvailabilityStatus availability 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 { bsGlobalID sample_id uriorcurie sample_type uriorcurieList processing EnumAvailabilityStatus availablity_status uriorcurieList storage_method float quantity_number uriorcurieList external_id } Study { string study_title string study_code string study_short_name stringList funding_source string study_description uri website string acknowledgments string citation_statement uriorcurieList external_id sdGlobalID study_id } StudyMetadata { EnumParticipantLifespanStageList participant_lifespan_stage string selection_criteria EnumDataSourceTypeList clinical_data_source_type uriorcurieList data_category integer expected_number_of_participants integer actual_number_of_participants uriorcurieList external_id } Subject { ptGlobalID subject_id uriorcurieList external_id } SubjectAssertion { string assertion_id EnumAsserterType asserter_type EnumDataSourceType assertion_source_type 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 { orGlobalID vbr_id string name string institution uri website string vbr_readme 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" Aliquot ||--|o Concept : "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 Any : "method" BiospecimenCollection ||--|o Any : "site" 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 Any : "vital_status" Demographics ||--|o Study : "study_id" Demographics ||--|| Any : "ethnicity" Demographics ||--|| Any : "sex" Demographics ||--|| Subject : "subject_id" Demographics ||--}| Any : "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 Any : "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 ||--|| Any : "relation" FamilyRelationship ||--|| Subject : "family_member_id" FamilyRelationship ||--|| Subject : "subject_id" File ||--|o AccessPolicy : "access_policy_id" File ||--|o Study : "study_id" File ||--}o FileHash : "hash" File ||--}o Sample : "sample_id" File ||--}o Subject : "subject_id" 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 ||--}| Any : "program" Study ||--}| Investigator : "contact" Study ||--}| Investigator : "principal_investigator" StudyMetadata ||--|o AccessPolicy : "access_policy_id" StudyMetadata ||--|o VirtualBiorepository : "vbr_id" StudyMetadata ||--|| Study : "study_id" StudyMetadata ||--}| Any : "research_domain" StudyMetadata ||--}| Any : "study_design" Subject ||--|o AccessPolicy : "access_policy_id" Subject ||--|o Any : "organism_type" Subject ||--|o Study : "study_id" Subject ||--|| Any : "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 Any : "value_concept" SubjectAssertion ||--}o Concept : "concept" VirtualBiorepository ||--|o AccessPolicy : "access_policy_id" VirtualBiorepository ||--|o Study : "study_id" VirtualBiorepository ||--}| Investigator : "contact"