37 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| FITBIT_HRV_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_HEARTRATE_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBITDEVICES_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBITDAILYDATA_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_RESTINGHEARTRATE_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SURVEYSTEPRESULTS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SURVEYSTEPRESULTS_SURVEYRESULTKEY_FK |
|
|
Restrict delete | ||
| SK_KEYBOARD_PARTICIPANT_ID_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_APPLEEXERCISETIME_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| NOTIFICATIONS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SURVEYRESULTS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SK_SPEECH_PARTICIPANT_ID_FK |
|
|
Restrict delete | ||
| SK_DEVICE_USAGE_PARTICIPANT_ID_FK |
|
|
Restrict delete | ||
| SURVEYCONSENTSIGNATURERESULTS_SURVEYRESULTKEY_FK |
|
|
Restrict delete | ||
| SURVEYCONSENTSIGNATURERESULTS_SURVEYSTEPRESULTKEY_FK |
|
|
Restrict delete | ||
| SURVEYCONSENTSIGNATURERESULTS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBIT_STEPS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBITRESTINGHEARTRATES_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITSTATISTICS_DAILYSTEPS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SURVEYTASKS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_STEPS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBITACTIVITYLOGS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITSTATISTICS_HOURLYSTEPS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SK_LIGHT_PARTICIPANT_ID_FK |
|
|
Restrict delete | ||
| FITBITSLEEPLOGS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SK_USAGE_PARTICIPANT_ID_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_DELETED_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SK_VISITS_PARTICIPANT_ID_FK |
|
|
Restrict delete | ||
| SURVEYQUESTIONRESULTS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| SURVEYQUESTIONRESULTS_SURVEYSTEPRESULTKEY_FK |
|
|
Restrict delete | ||
| SURVEYQUESTIONRESULTS_SURVEYRESULTKEY_FK |
|
|
Restrict delete | ||
| HEALTHKITSAMPLES_HEARTRATEVARIABILITY_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBITSLEEPLOGDETAILS_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| FITBIT_HEARTRATE_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| AUXILIARYDATA_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete | ||
| HEALTHKITACTIVITYSUMMARIES_PARTICIPANTIDENTIFIER_FK |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| SK_KEYBOARD | SK_KEYBOARD_CONTENT_JSON | content_json IS JSON |
| SK_SPEECH | SK_SPEECH_CONTENT_JSON | content_json IS JSON |
| SK_DEVICE_USAGE | SK_DEVICE_USAGE_CONTENT_JSON | content_json IS JSON |
| SURVEYDEFINITIONS | SURVEYDEFINITIONS_DEFINITION_JSON | DEFINITION IS JSON |
| STUDYPARTICIPANTS | STUDYPARTICIPANTS_CUSTOMFIELDS_JSON | CUSTOMFIELDS IS JSON |