ER Diagram

erDiagram 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 } ClinicalTrial { string nctId enum_clinicalStudyDesign clinicalStudyDesign enum_trialPhase trialPhase enum_primaryPurpose primaryPurpose enum_interventionType interventionType stringList intervention stringList armInformation enum_armAllocation armAllocation enum_interventionAssignmentStrategy interventionAssignmentStrategy stringList primaryOutcomeMeasure stringList secondaryOutcomeMeasure stringList otherOutcomeMeasure } 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 } DataFile { string participantExternalId string participantDataFileManifestLocation string sampleExternalId string fileName string fileGlobalId string fileUploadLocation string fileS3Location uriorcurie drsUri string fileHash enum_dataAccess dataAccess enum_dataCategory dataCategory stringList dataType stringList experimentalStrategy stringList experimentalPlatform string fileFormat integer fileSize string fileSizeUnit } 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 uriList otherRepository string otherAccessAuthority boolean isHarmonized string datasetManifestLocation uri doi string doiCitation } DatasetManifest { string datasetName string datasetExternalId string fileName } Participant { enum_studyCode studyCode string participantGlobalId string 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 ageAtFirstParticipantEngagement string firstParticipantEngagementEvent enum_vital_status outcomesVitalStatus integer ageAtLastVitalStatus } ParticipantSampleDataFileManifest { } 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 uriList studyWebsite stringList dbgap uriList publication integer expectedNumberOfParticipants enum_guidType guidType boolean guidMapped stringList acknowledgments stringList citationStatement uri doi string doiCitation } Biospecimen ||--|| Participant : "participantGlobalId" Biospecimen ||--|| Study : "studyCode" ClinicalTrial ||--|| Study : "studyCode" Condition ||--|| Participant : "participantGlobalId" Condition ||--|| Study : "studyCode" DataFile ||--|| Biospecimen : "sampleGlobalId" DataFile ||--|| Participant : "participantGlobalId" DataFile ||--|| Study : "studyCode" Dataset ||--|| Study : "studyCode" DatasetManifest ||--|o Dataset : "datasetGlobalId" DatasetManifest ||--|| DataFile : "fileGlobalId" DatasetManifest ||--|| Study : "studyCode" ParticipantSampleDataFileManifest ||--|| Biospecimen : "sampleExternalId" ParticipantSampleDataFileManifest ||--|| DataFile : "fileName" ParticipantSampleDataFileManifest ||--|| Participant : "participantExternalId" ParticipantSampleDataFileManifest ||--|| Study : "studyCode"