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"