Skip to end of banner
Go to start of banner

Digital Health Study Schema

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Synapse Table: syn21994974


Notes:

  • Need to select entries based on WHERE ((isDHProject IS NULL) OR (isDHProject <> 'TRUE')) AND (dhPortalIndex = 'TRUE') 
  • Wiki text often come from main project wikis and subpages (in contrast to other projects in which they come from folder and file wikis)
Display NameColumn NameFacet Y/NUI MappingDestinationSearchable Y/NSearch hint textNotes

id




Use this as link out to Synapse
Data AccessdataAccessInstructionsN
Link to wiki

Link out to this page to governance and access instructions

dataCollectionMethodNSecondary_Label_7




deviceLocationYSecondary_Label_9




devicePlatformYSecondary_Label_8




deviceTypeYSecondary_Label_5




diagnosisYSecondary_Label_1
Ye.g. Parkinson's

digitalAssessmentCategoryYSecondary_Label_10
Ye.g. tremor

digitalAssessmentDetails
Secondary_Label_11
Ye.g. walking

interventionYSecondary_Label_2
Ye.g. levodopa

investigator
Card_SubTitle
Ye.g. LastName

keywords
Secondary_Label_13
Ye.g. neurodegeneration
IndividualsnumberParticipants
Secondary_Label_3



Clinical or Phenotypic AssessmentreportedOutcomeYSecondary_Label_4
Ye.g. MDS-UPDRS

sensorDataType
Secondary_Label_12




sensorTypeYSecondary_Label_6



Study Namestudy
Card_Titlelink to 'id'Ye.g. mPower
Data DescriptionstudyDataDescriptionLocation


Ye.g. tremorData description similar to methods for AMP-AD
Study DescriptionstudyDescriptionLocation


Y
Full Study description for Study page

studyDescription
Card_Description




Study Detail Page

Study Detail pages retrieve data from multiple tables.

Study Name (study), Study Description, dataAccessInstructions (hyperlink to synapse with text "How to access the data"), and Data Description come from Study/Projects table.

Data from other sections come from the Digital Health Data File View, Digital Health Tools File View and Digital Health Publications tables.

The configuration for each section with example queries is shown here:


FieldColumn NameLocationStudy Information (example)Note

Study Name

study

study card header

MJFF Levodopa Response StudyLink to id in Synapse

Study description

studyDataDescriptionLocation

study card body


Pull content from wiki link

Access requirements

accessRequirements

study page body


Hyperlink to Synapse using text "How to access the data"

Data files


study page body, table

select * from syn21994970 where ((dhPortalIndex = 'TRUE') AND (projectId = 'syn20681023'))Or replace '*' with appropriate column selection

Tools


study page body, as cards

SELECT * FROM syn22014091 WHERE suggestedStudies HAS ('syn9746170')

Publications


study page body, as cards

SELECT * FROM syn22017695 WHERE synID HAS ('syn9746170')


  • No labels