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"