ER Diagram

erDiagram Study { enum_studyCode studyCode string studyTitle enum_programList program string studyDescription stringList principalInvestigatorName stringList studyContactName stringList studyContactInstitution stringList studyContactEmail string vbrEmail uri vbrUrl string vbrReadme enum_researchDomainList researchDomain enum_participantLifespanStageList participantLifespanStage string selectionCriteria enum_studyDesignList studyDesign enum_clinicalDataSourceTypeList clinicalDataSourceType enum_dataCategoryList dataCategory uri studyWebsite stringList dbgap uriList publication integer expectedNumberOfParticipants enum_guidType guidType boolean guidMapped stringList acknowledgments stringList citationStatement } Dataset { string datasetName string datasetDescription string datasetGlobalId string datasetExternalId integer expectedNumberOfParticipants integer expectedNumberOfFiles string dataCollectionStartYear string dataCollectionEndYear enum_dataCategoryList dataCategory stringList dataType stringList experimentalStrategy stringList experimentalPlatform uriList publication string accessLimitations string accessRequirements stringList dbgap uri otherRepository string otherAccessAuthority boolean isHarmonized string datasetManifestLocation } DatasetManifest { string datasetName string datasetExternalId string fileName } Participant { string participantGlobalId stringList participantExternalId string familyId enum_familyType familyType string fatherId string motherId string siblingId string otherFamilyMemberId enum_familyRelationship familyRelationship enum_sex sex enum_race race enum_ethnicity ethnicity enum_downSyndromeStatus downSyndromeStatus integer ageAtFirstPatientEngagement string firstPatientEngagementEvent enum_vital_status outcomesVitalStatus integer ageAtLastVitalStatus } Condition { string participantExternalId string eventId string eventType string conditionMeasureSourceText integer ageAtConditionMeasureObservation enum_conditionInterpretation conditionInterpretation enum_conditionStatus conditionStatus enum_conditionDataSource conditionDataSource string hpoLabel string hpoCode string mondoLabel string mondoCode string maxoLabel string maxoCode string otherLabel string otherCode float measureValue string measureUnit } Biospecimen { string participantExternalId string sampleGlobalId string sampleExternalId string sampleType integer ageAtBiospecimenCollection string parentSampleGlobalId string parentSampleExternalId string parentSampleType string collectionGlobalId string collectionExternalId string collectionSampleType string containerGlobalId string containerExternalId float volume string volumeUnit float concentration string concentrationUnit string laboratoryProcedure string biospecimenStorage enum_Availability sampleAvailability enum_Availability containerAvailability } DataFile { string participantExternalId string sampleExternalId string fileName string fileGlobalId string fileUploadLocation string fileS3Location uriorcurie drsUri string fileHash enum_dataAccess dataAccess enum_dataCategory dataCategory string dataType stringList experimentalStrategy stringList experimentalPlatform string fileFormat integer fileSize string fileSizeUnit } Dataset ||--|| Study : "studyCode" DatasetManifest ||--|| Study : "studyCode" DatasetManifest ||--|o Dataset : "datasetGlobalId" DatasetManifest ||--|| DataFile : "fileGlobalId" Participant ||--}| Study : "studyCode" Condition ||--|| Study : "studyCode" Condition ||--|| Participant : "participantGlobalId" Biospecimen ||--|| Study : "studyCode" Biospecimen ||--|| Participant : "participantGlobalId" DataFile ||--|| Study : "studyCode" DataFile ||--|| Participant : "participantGlobalId" DataFile ||--|| Biospecimen : "sampleGlobalId"