ER Diagram

erDiagram AccessPolicy { string access_policy_id string description EnumDataAccessType data_access_type uri website EnumConsentScope consent_scope EnumAccessPolicyCodeList access_policy_code string disease_limitation EnumConsentStateCodes status } AgeAt { EnumAgeValueType value_type uriorcurie age_code date as_date string id uriorcurieList external_id } Aliquot { string aliquot_id EnumSpecimenAvailability availability_status float volume uriorcurie volume_units uriorcurie concentration uriorcurieList external_id } Any { } AssociatedParty { string name EnumResearchStudyPartyRole role EnumResearchStudyPartyOrganizationTypeList classifier string id uriorcurieList external_id } Family { string family_global_id string family_id EnumFamilyType family_type string description EnumConsanguinity consanguinity uriorcurie family_focus uriorcurieList external_id } FamilyRelationship { string family_relationship_id EnumFamilyRelationship relationship EnumRelationshipKnowledgeSource knowledge_source } FileLocation { string file_location_id uri location_uri string file_name } FileMetaData { string file_meta_data_id EnumFileMetaDataType meta_data_type uriorcurie assay_strategy uriorcurie platform_instrument uriorcurie library_prep uriorcurie library_selection uriorcurie strandedness uriorcurie target_region uriorcurie is_paired_end uriorcurie adaptor_trimmed uriorcurie reference_genome uriorcurie workflow_type uriorcurie workflow_tool } HasExternalId { uriorcurieList external_id } Institution { string institution_id string name uriorcurieList external_id } NCPIFile { uriorcurie file_format float file_size uriorcurie file_size_unit string content_version uriorcurie file_type string file_hash uriorcurie file_hash_type string description string file_global_id uriorcurieList external_id } Participant { string participant_id EnumBirthSex birthsex EnumRaceList race EnumEthnicity ethnicity EnumPopulation population string dob EnumDobMethod dob_method string age_at_last_vital boolean is_deceased EnumPatientKnowledgeSource patient_knowledge_source uriorcurieList external_id } ParticipantAssertion { string participant_assertion_id EnumEntityAsserter entity_asserter uriorcurie other_condition_modifiers EnumAssertionType assertion_type uriorcurie assertion_code string assertion_text uriorcurie assertion_source uriorcurie value_code string value_string float value_number uriorcurie value_units uriorcurie body_site uriorcurie body_location uriorcurie body_laterality uriorcurie cancer_stage } Period { string period_id date start date end } Person { string person_id } Practitioner { string practitioner_id string name string email string description string practitioner_title uriorcurieList external_id } PractitionerRole { string practitioner_role_id } Record { string id uriorcurieList external_id } RelativeDateTime { integer offset integer offset_end EnumOffsetType offset_type string id uriorcurieList external_id } ResearchStudy { string research_study_id string study_title uriorcurieList study_focus string description uriorcurieList study_condition stringList study_acknowledgement EnumStudyStatus study_status uriorcurieList study_design uriorcurieList external_id } ResearchStudyCollection { string research_study_collection_id string description string collection_title EnumResearchCollectionType research_study_collection_type stringList label uri website EnumCollectionStatus collection_status uriorcurieList external_id } Sample { string sample_id uriorcurie sample_type uriorcurie collection_method uriorcurie collection_site uriorcurie spatial_qualifier uriorcurie laterality uriorcurieList processing EnumSpecimenAvailability availability_status uriorcurie storage_method float quantity uriorcurie quantity_units uriorcurieList external_id } StudyMembership { string study_membership_id } AgeAt ||--|o RelativeDateTime : "age" Aliquot ||--|| Sample : "sample_id" AssociatedParty ||--|o Institution : "associated_party_institution_id" AssociatedParty ||--|o Practitioner : "associated_party_practitioner_id" AssociatedParty ||--|o PractitionerRole : "associated_party_practitioner_role_id" AssociatedParty ||--}o Period : "period_id" FamilyRelationship ||--|| Participant : "patient_id" FamilyRelationship ||--|| Participant : "relative_id" FileLocation ||--|| AccessPolicy : "access_policy_id" FileMetaData ||--}o Sample : "samples" NCPIFile ||--|| Participant : "participant_id" NCPIFile ||--}o FileMetaData : "file_meta_data_id" NCPIFile ||--}| FileLocation : "file_location_id" Participant ||--|o Family : "family_global_id" Participant ||--|o RelativeDateTime : "deceased_rel" Participant ||--}o Sample : "sample_id" ParticipantAssertion ||--|o AgeAt : "age_at_assertion" ParticipantAssertion ||--|o AgeAt : "age_at_event" ParticipantAssertion ||--|o AgeAt : "age_at_onset" ParticipantAssertion ||--|o AgeAt : "age_at_resolution" ParticipantAssertion ||--|| Participant : "participant_id" Person ||--}| Participant : "participant_id" Practitioner ||--|o Institution : "institution_id" Practitioner ||--|o PractitionerRole : "practitioner_role_id" PractitionerRole ||--|o Institution : "institution_id" PractitionerRole ||--|o Period : "period_id" PractitionerRole ||--|o Practitioner : "practitioner_id" ResearchStudy ||--|o ResearchStudy : "parent_study_id" ResearchStudy ||--}| AssociatedParty : "study_personnel" ResearchStudyCollection ||--}| ResearchStudy : "research_study_collection_member_id" Sample ||--|o AgeAt : "age_at_collection" Sample ||--|o Sample : "parent_sample_id" Sample ||--|| Participant : "participant_id" StudyMembership ||--|| AccessPolicy : "access_policy_id" StudyMembership ||--|| ResearchStudy : "research_study_id" StudyMembership ||--}| Participant : "participant_id"