Tables


SchemaSpy Analysis of IHSD.IHS_2023

Generated on Thu Mar 28 19:40 EDT 2024

Intern Health Study database, utilizing Fitbit and Apple Health data acquired through MyDataHelps. 2023 Cohort.

XML Representation
Insertion Order Deletion Order
TABLES 145
VIEWS 4
COLUMNS 2096
Constraints 37
Anomalies 147
Routines 19

Database Properties

Database Type: Oracle - Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.22.0.0.0

Tables

Table / View Children Parents Columns Type Comments
GARMINSLEEPSUMMARY_SCORE 0 0 3 Table
STG_AUXILIARYDATA 0 0 6 Table
STG_HEALTHKITSTATISTICS_DAILYSTEPS 0 0 7 Table
STG_GARMINACTIVITYSUMMARY 0 0 33 Table
GARMINACTIVITYSUMMARY 0 1 33 Table
STG_GARMINSTRESSDETAILSUMMARY 0 0 8 Table
STG_GARMINSLEEPSUMMARY 0 0 16 Table
STG_FITBIT_HEARTRATE 0 0 4 Table
GARMINMOVEIQACTIVITYSUMMARY 0 1 10 Table
STG_ANALYTICSEVENTS_SURVEYSTEPVIEWED 0 0 11 Table
ANALYTICSEVENTS_EMAILDELIVERY 0 1 13 Table
STG_GARMINDAILYSUMMARY_SAMPLES 0 0 3 Table
STG_ANALYTICSEVENTS_PUSHNOTIFICATIONSENT 0 0 8 Table
FITBIT_HRV 0 1 6 Table
SK_LIGHT_TEST 0 0 8 Table
STG_FITBITSLEEPLOGDETAILS 0 0 6 Table
STG_SK_LIGHT 0 0 8 Table
STG_ANALYTICSEVENTS_EMAILDELIVERY 0 0 13 Table
STG_GARMINEPOCHSUMMARY 0 0 16 Table
HEALTHKITSAMPLES_HEARTRATE 0 1 21 Table
STG_ANALYTICSEVENTS_EMAILCLICK 0 0 16 Table
STG_HEALTHKITSAMPLES_HEARTRATEVARIABILITY_DELETED 0 0 3 Table
DAILY_WEARABLE_DATACOUNTS 0 0 16 Table
STG_ANALYTICSEVENTS_EMAILBOUNCE 0 0 13 Table
STG_ANALYTICSEVENTS_EMAILOPEN 0 0 14 Table
IHS_VIEW_DATA_DICTIONARY 0 0 4 Table
SK_LIGHT_PARTICIPANTS 0 0 2 Table
STG_GARMINSLEEPSUMMARY_DURATION 0 0 4 Table
STG_GARMINUSERMETRICSSUMMARY 0 0 8 Table
SK_LIGHT_INT 0 0 8 Table
STG_FITBIT_HRV 0 1 6 Table
STG_SK_USAGE 0 0 11 Table
MANIFEST 0 0 79 Table
FITBITDEVICES 0 1 6 Table
STG_GARMINHRVSUMMARY_SAMPLES 0 0 3 Table
STG_HEALTHKITSAMPLES_APPLEEXERCISETIME 0 0 21 Table
GARMINSLEEPSUMMARY_DURATION 0 0 4 Table
FITBITDAILYDATA 0 1 60 Table
HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL 0 1 21 Table
GARMINHRVSUMMARY 0 1 10 Table
STG_ANALYTICSEVENTS_PUSHNOTIFICATIONOPENED 0 0 6 Table
STG_SURVEYSTEPRESULTS 0 0 6 Table
HEALTHKITSAMPLES_RESTINGHEARTRATE 0 1 21 Table
SURVEYSTEPRESULTS 2 2 6 Table
SK_KEYBOARD 0 1 5 Table
HEALTHKITSAMPLES_APPLEEXERCISETIME 0 1 21 Table
SURVEYDICTIONARY 0 0 8 Table
ANALYTICSEVENTS_EMAILNOTIFICATIONSENT 0 1 6 Table
NOTIFICATIONS 0 1 10 Table
COMPETITION_PROGRAMS 0 1 4 Table
STG_HEALTHKITSAMPLES_RESTINGHEARTRATE 0 0 21 Table
STG_FITBITDAILYDATA 0 0 60 Table
SURVEYRESULTS 3 2 13 Table
STG_SURVEYTASKS 0 0 9 Table
SK_SPEECH 0 1 5 Table
SK_DEVICE_USAGE 0 1 5 Table
STG_ANALYTICSEVENTS_EMAILSEND 0 0 11 Table
STG_SURVEYCONSENTSIGNATURERESULTS 0 0 13 Table
STG_ANALYTICSEVENTS_PUSHNOTIFICATIONRECEIVED 0 0 6 Table
SURVEYCONSENTSIGNATURERESULTS 0 3 13 Table
STG_FITBIT_STEPS 0 0 4 Table
ANALYTICSEVENTS_EMAILCOMPLAINT 0 1 13 Table
FITBIT_STEPS 0 1 3 Table
STG_ANALYTICSEVENTS_NOTIFICATIONSENT 0 0 9 Table
STG_HEALTHKITSTATISTICS_HOURLYSTEPS 0 0 7 Table
ANALYTICSEVENTS_SURVEYSTEPVIEWED 0 1 11 Table
STG_HEALTHKITSAMPLES_HEARTRATE_DELETED 0 0 3 Table
GARMINUSERMETRICSSUMMARY 0 1 8 Table
FITBITRESTINGHEARTRATES 0 1 3 Table
HEALTHKITSTATISTICS_DAILYSTEPS 0 1 7 Table
STG_SK_SPEECH 0 0 4 Table
SK_LOOKUP 0 0 4 Table
SURVEYDEFINITIONS 0 0 6 Table
ANALYTICSEVENTS_PUSHNOTIFICATIONRECEIVED 0 1 6 Table
COMPETITIONS 0 0 10 Table
STG_SURVEYDICTIONARY 0 0 8 Table
SURVEYTASKS 1 1 9 Table
STG_GARMINHRVSUMMARY 0 0 10 Table
STG_FITBITACTIVITYLOGS 0 0 33 Table
STG_HEALTHKITSAMPLES_HEARTRATE 0 0 21 Table
STUDYPARTICIPANTS 60 0 16 Table
STG_GARMINTHIRDPARTYDAILYSUMMARY 0 0 21 Table
STG_GARMINSLEEPSUMMARY_SCORE 0 0 3 Table
HEALTHKITSAMPLES_STEPS 0 1 21 Table
STG_MANIFEST 0 0 79 Table
ANALYTICSEVENTS_EMAILOPEN 0 1 14 Table
GARMINDAILYSUMMARY_SAMPLES 0 0 3 Table
GARMINSTRESSDETAILSUMMARY 0 1 8 Table
FITBITACTIVITYLOGS 0 1 34 Table
STG_GARMINMOVEIQACTIVITYSUMMARY 0 0 10 Table
HEALTHKITSTATISTICS_HOURLYSTEPS 0 1 7 Table
STG_GARMINSTRESSDETAILSUMMARY_SAMPLES 0 0 4 Table
STG_STUDYPARTICIPANTS 0 0 16 Table
ANALYTICSEVENTS_EMAILBOUNCE 0 1 13 Table
STG_ANALYTICSEVENTS_EMAILCOMPLAINT 0 0 13 Table
STG_SURVEYDEFINITIONS 0 0 6 Table
STG_COMPETITIONS 0 0 10 Table
SK_LIGHT 0 1 8 Table
STG_SK_DEVICE_USAGE 0 0 4 Table
STG_SK_VISITS 0 0 11 Table
STG_SURVEYRESULTS 0 0 13 Table
GARMINDAILYSUMMARY 0 1 32 Table
FITBITSLEEPLOGS 0 1 20 Table
GARMINEPOCHSUMMARY 0 0 16 Table
GARMINSTRESSDETAILSUMMARY_SAMPLES 0 0 4 Table
SK_USAGE 0 1 11 Table
STG_GARMINDAILYSUMMARY 0 0 32 Table
STG_HEALTHKITSAMPLES_STEPS 0 0 21 Table
STG_SURVEYQUESTIONRESULTS 0 0 8 Table
STG_FITBITSLEEPLOGS 0 0 19 Table
ANALYTICSEVENTS_EMAILCLICK 0 1 16 Table
HEALTHKITSAMPLES_DELETED 0 1 4 Table
SK_VISITS 0 1 11 Table
STG_FITBITRESTINGHEARTRATES 0 0 3 Table
GARMINSLEEPSUMMARY 0 1 16 Table
STG_HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL_DELETED 0 0 3 Table
APPLE_WATCH_DEVICES 0 1 5 Table
STG_FITBITDEVICES 0 0 5 Table
STG_HEALTHKITACTIVITYSUMMARIES 0 0 11 Table
STG_HEALTHKITSAMPLES_STEPS_DELETED 0 0 3 Table
STG_ANALYTICSEVENTS_EMAILNOTIFICATIONSENT 0 0 6 Table
SURVEYQUESTIONRESULTS 0 3 8 Table
IHS_DATA_REFRESH_LOG 0 0 75 Table
STG_SK_KEYBOARD 0 0 4 Table
GARMINTHIRDPARTYDAILYSUMMARY_SAMPLES 0 0 3 Table
HEALTHKITSAMPLES_HEARTRATEVARIABILITY 0 1 21 Table
ANALYTICSEVENTS_EMAILSEND 0 1 11 Table
STG_HEALTHKITSAMPLES_HEARTRATEVARIABILITY 0 0 21 Table
STG_NOTIFICATIONS 0 0 10 Table
HEALTHKIT_DAILYDATA 0 1 3 Table
STG_HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL 0 0 21 Table
ANALYTICSEVENTS_NOTIFICATIONSENT 0 1 9 Table
ANALYTICSEVENTS_PUSHNOTIFICATIONSENT 0 1 8 Table
ANALYTICSEVENTS_PUSHNOTIFICATIONOPENED 0 1 6 Table
STG_GARMINTHIRDPARTYDAILYSUMMARY_SAMPLES 0 0 3 Table
FITBITSLEEPLOGDETAILS 0 1 7 Table
FITBIT_HEARTRATE 0 1 3 Table
HEALTHKITSAMPLES_DATA_TYPE 0 0 2 Table
AUXILIARYDATA 0 1 6 Table
LOAD_LOG 0 0 66 Table
STG_HEALTHKITSAMPLES_RESTINGHEARTRATE_DELETED 0 0 3 Table
STG_HEALTHKITSAMPLES_APPLEEXERCISETIME_DELETED 0 0 3 Table
GARMINHRVSUMMARY_SAMPLES 0 0 3 Table
GARMINTHIRDPARTYDAILYSUMMARY 0 1 21 Table
HEALTHKITACTIVITYSUMMARIES 0 1 11 Table
VW_IHS_PARTICIPANT_RECENT_DEVICES 0 1 4 View
VW_BASELINE_SURVEY 0 1 175 View
VW_IHS_RECRUITMENT 0 1 45 View
VW_IHS_PARTICIPANT_SUMMARY 0 1 14 View