STUDYPARTICIPANTS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PARTICIPANTIDENTIFIER VARCHAR2 15 null
ANALYTICSEVENTS_EMAILBOUNCE.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_EMAILCLICK.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_EMAILCOMPLAINT.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_EMAILDELIVERY.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_EMAILNOTIFICATIONSENT.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_EMAILOPEN.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_EMAILSEND.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_NOTIFICATIONSENT.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_PUSHNOTIFICATIONOPENED.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_PUSHNOTIFICATIONRECEIVED.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_PUSHNOTIFICATIONSENT.PARTICIPANTIDENTIFIER Implied Constraint R
ANALYTICSEVENTS_SURVEYSTEPVIEWED.PARTICIPANTIDENTIFIER Implied Constraint R
APPLE_WATCH_DEVICES.PARTICIPANTIDENTIFIER Implied Constraint R
AUXILIARYDATA.PARTICIPANTIDENTIFIER AUXILIARYDATA_PARTICIPANTIDENTIFIER_FK R
COMPETITION_PROGRAMS.PARTICIPANTIDENTIFIER Implied Constraint R
FITBIT_HEARTRATE.PARTICIPANTIDENTIFIER FITBIT_HEARTRATE_PARTICIPANTIDENTIFIER_FK R
FITBIT_HRV.PARTICIPANTIDENTIFIER FITBIT_HRV_PARTICIPANTIDENTIFIER_FK R
FITBIT_STEPS.PARTICIPANTIDENTIFIER FITBIT_STEPS_PARTICIPANTIDENTIFIER_FK R
FITBITACTIVITYLOGS.PARTICIPANTIDENTIFIER FITBITACTIVITYLOGS_PARTICIPANTIDENTIFIER_FK R
FITBITDAILYDATA.PARTICIPANTIDENTIFIER FITBITDAILYDATA_PARTICIPANTIDENTIFIER_FK R
FITBITDEVICES.PARTICIPANTIDENTIFIER FITBITDEVICES_PARTICIPANTIDENTIFIER_FK R
FITBITRESTINGHEARTRATES.PARTICIPANTIDENTIFIER FITBITRESTINGHEARTRATES_PARTICIPANTIDENTIFIER_FK R
FITBITSLEEPLOGDETAILS.PARTICIPANTIDENTIFIER FITBITSLEEPLOGDETAILS_PARTICIPANTIDENTIFIER_FK R
FITBITSLEEPLOGS.PARTICIPANTIDENTIFIER FITBITSLEEPLOGS_PARTICIPANTIDENTIFIER_FK R
GARMINACTIVITYSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINDAILYSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINHRVSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINMOVEIQACTIVITYSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINSLEEPSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINSTRESSDETAILSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINTHIRDPARTYDAILYSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
GARMINUSERMETRICSSUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
HEALTHKIT_DAILYDATA.PARTICIPANTIDENTIFIER Implied Constraint R
HEALTHKITACTIVITYSUMMARIES.PARTICIPANTIDENTIFIER HEALTHKITACTIVITYSUMMARIES_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_APPLEEXERCISETIME.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_APPLEEXERCISETIME_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_DELETED.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_DELETED_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_HEARTRATE.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_HEARTRATE_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_HEARTRATEVARIABILITY.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_HEARTRATEVARIABILITY_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_RESTINGHEARTRATE.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_RESTINGHEARTRATE_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSAMPLES_STEPS.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_STEPS_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSTATISTICS_DAILYSTEPS.PARTICIPANTIDENTIFIER HEALTHKITSTATISTICS_DAILYSTEPS_PARTICIPANTIDENTIFIER_FK R
HEALTHKITSTATISTICS_HOURLYSTEPS.PARTICIPANTIDENTIFIER HEALTHKITSTATISTICS_HOURLYSTEPS_PARTICIPANTIDENTIFIER_FK R
NOTIFICATIONS.PARTICIPANTIDENTIFIER NOTIFICATIONS_PARTICIPANTIDENTIFIER_FK R
SK_DEVICE_USAGE.PARTICIPANT_ID SK_DEVICE_USAGE_PARTICIPANT_ID_FK R
SK_KEYBOARD.PARTICIPANT_ID SK_KEYBOARD_PARTICIPANT_ID_FK R
SK_LIGHT.PARTICIPANT_ID SK_LIGHT_PARTICIPANT_ID_FK R
SK_SPEECH.PARTICIPANT_ID SK_SPEECH_PARTICIPANT_ID_FK R
SK_USAGE.PARTICIPANT_ID SK_USAGE_PARTICIPANT_ID_FK R
SK_VISITS.PARTICIPANT_ID SK_VISITS_PARTICIPANT_ID_FK R
STG_FITBIT_HRV.PARTICIPANTIDENTIFIER Implied Constraint R
SURVEYCONSENTSIGNATURERESULTS.PARTICIPANTIDENTIFIER SURVEYCONSENTSIGNATURERESULTS_PARTICIPANTIDENTIFIER_FK R
SURVEYQUESTIONRESULTS.PARTICIPANTIDENTIFIER SURVEYQUESTIONRESULTS_PARTICIPANTIDENTIFIER_FK R
SURVEYRESULTS.PARTICIPANTIDENTIFIER SURVEYRESULTS_PARTICIPANTIDENTIFIER_FK R
SURVEYSTEPRESULTS.PARTICIPANTIDENTIFIER SURVEYSTEPRESULTS_PARTICIPANTIDENTIFIER_FK R
SURVEYTASKS.PARTICIPANTIDENTIFIER SURVEYTASKS_PARTICIPANTIDENTIFIER_FK R
VW_BASELINE_SURVEY.PARTICIPANTIDENTIFIER Implied Constraint R
VW_IHS_PARTICIPANT_RECENT_DEVICES.PARTICIPANTIDENTIFIER Implied Constraint R
VW_IHS_PARTICIPANT_SUMMARY.PARTICIPANTIDENTIFIER Implied Constraint R
VW_IHS_RECRUITMENT.PARTICIPANTIDENTIFIER Implied Constraint R
GLOBALKEY RAW 16 √ null
EMAILADDRESS VARCHAR2 100 √ null
MIDDLENAME VARCHAR2 50 √ null
FIRSTNAME VARCHAR2 50 √ null
LASTNAME VARCHAR2 50 √ null
GENDER VARCHAR2 2 √ null
DATEOFBIRTH DATE 7 √ null
SECONDARYIDENTIFIER NUMBER 10 √ null
POSTALCODE VARCHAR2 15 √ null
ENROLLMENTDATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
EVENTDATES VARCHAR2 2000 √ null
CUSTOMFIELDS VARCHAR2 4000 √ null
UTCOFFSET VARCHAR2 20 √ null
TIMEZONE VARCHAR2 50 √ null
PREFERREDLANGUAGE VARCHAR2 10 √ null

Indexes

Constraint Name Type Sort Column(s)
STUDYPARTICIPANTS_PK Primary key Asc PARTICIPANTIDENTIFIER

Check Constraints

Constraint Name Constraint
STUDYPARTICIPANTS_CUSTOMFIELDS_JSON CUSTOMFIELDS IS JSON

Relationships

Close relationships within degrees of separation