Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
ANALYTICSEVENTS_EMAILBOUNCE.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_EMAILCLICK.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_EMAILCOMPLAINT.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_EMAILDELIVERY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_EMAILNOTIFICATIONSENT.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_EMAILOPEN.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_EMAILSEND.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_NOTIFICATIONSENT.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_PUSHNOTIFICATIONOPENED.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_PUSHNOTIFICATIONRECEIVED.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_PUSHNOTIFICATIONSENT.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
ANALYTICSEVENTS_SURVEYSTEPVIEWED.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
APPLE_WATCH_DEVICES.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
COMPETITION_PROGRAMS.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINACTIVITYSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINDAILYSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINHRVSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINMOVEIQACTIVITYSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINSLEEPSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINSTRESSDETAILSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINTHIRDPARTYDAILYSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
GARMINUSERMETRICSSUMMARY.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
HEALTHKIT_DAILYDATA.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
STG_FITBIT_HRV.[PARTICIPANTIDENTIFIER] STUDYPARTICIPANTS.[PARTICIPANTIDENTIFIER]
SURVEYRESULTS.[SURVEYTASKKEY] SURVEYTASKS.[SURVEYTASKKEY]

Tables without indexes

Table
ANALYTICSEVENTS_EMAILBOUNCE
ANALYTICSEVENTS_EMAILCLICK
ANALYTICSEVENTS_EMAILCOMPLAINT
ANALYTICSEVENTS_EMAILDELIVERY
ANALYTICSEVENTS_EMAILNOTIFICATIONSENT
ANALYTICSEVENTS_EMAILOPEN
ANALYTICSEVENTS_EMAILSEND
ANALYTICSEVENTS_NOTIFICATIONSENT
ANALYTICSEVENTS_PUSHNOTIFICATIONOPENED
ANALYTICSEVENTS_PUSHNOTIFICATIONRECEIVED
ANALYTICSEVENTS_PUSHNOTIFICATIONSENT
ANALYTICSEVENTS_SURVEYSTEPVIEWED
APPLE_WATCH_DEVICES
COMPETITION_PROGRAMS
COMPETITIONS
DAILY_WEARABLE_DATACOUNTS
FITBIT_HRV
FITBITACTIVITYLOGS
FITBITSLEEPLOGDETAILS
FITBITSLEEPLOGS
GARMINACTIVITYSUMMARY
GARMINDAILYSUMMARY
GARMINDAILYSUMMARY_SAMPLES
GARMINEPOCHSUMMARY
GARMINHRVSUMMARY
GARMINHRVSUMMARY_SAMPLES
GARMINMOVEIQACTIVITYSUMMARY
GARMINSLEEPSUMMARY
GARMINSLEEPSUMMARY_DURATION
GARMINSLEEPSUMMARY_SCORE
GARMINSTRESSDETAILSUMMARY
GARMINSTRESSDETAILSUMMARY_SAMPLES
GARMINTHIRDPARTYDAILYSUMMARY
GARMINTHIRDPARTYDAILYSUMMARY_SAMPLES
GARMINUSERMETRICSSUMMARY
HEALTHKIT_DAILYDATA
HEALTHKITSAMPLES_DATA_TYPE
HEALTHKITSAMPLES_DELETED
IHS_DATA_REFRESH_LOG
IHS_VIEW_DATA_DICTIONARY
LOAD_LOG
MANIFEST
SK_DEVICE_USAGE
SK_KEYBOARD
SK_LIGHT
SK_LIGHT_INT
SK_LIGHT_PARTICIPANTS
SK_LIGHT_TEST
SK_LOOKUP
SK_SPEECH
SK_USAGE
SK_VISITS
STG_ANALYTICSEVENTS_EMAILBOUNCE
STG_ANALYTICSEVENTS_EMAILCLICK
STG_ANALYTICSEVENTS_EMAILCOMPLAINT
STG_ANALYTICSEVENTS_EMAILDELIVERY
STG_ANALYTICSEVENTS_EMAILNOTIFICATIONSENT
STG_ANALYTICSEVENTS_EMAILOPEN
STG_ANALYTICSEVENTS_EMAILSEND
STG_ANALYTICSEVENTS_NOTIFICATIONSENT
STG_ANALYTICSEVENTS_PUSHNOTIFICATIONOPENED
STG_ANALYTICSEVENTS_PUSHNOTIFICATIONRECEIVED
STG_ANALYTICSEVENTS_PUSHNOTIFICATIONSENT
STG_ANALYTICSEVENTS_SURVEYSTEPVIEWED
STG_AUXILIARYDATA
STG_COMPETITIONS
STG_FITBIT_HEARTRATE
STG_FITBIT_HRV
STG_FITBIT_STEPS
STG_FITBITACTIVITYLOGS
STG_FITBITDAILYDATA
STG_FITBITDEVICES
STG_FITBITRESTINGHEARTRATES
STG_FITBITSLEEPLOGDETAILS
STG_FITBITSLEEPLOGS
STG_GARMINACTIVITYSUMMARY
STG_GARMINDAILYSUMMARY
STG_GARMINDAILYSUMMARY_SAMPLES
STG_GARMINEPOCHSUMMARY
STG_GARMINHRVSUMMARY
STG_GARMINHRVSUMMARY_SAMPLES
STG_GARMINMOVEIQACTIVITYSUMMARY
STG_GARMINSLEEPSUMMARY
STG_GARMINSLEEPSUMMARY_DURATION
STG_GARMINSLEEPSUMMARY_SCORE
STG_GARMINSTRESSDETAILSUMMARY
STG_GARMINSTRESSDETAILSUMMARY_SAMPLES
STG_GARMINTHIRDPARTYDAILYSUMMARY
STG_GARMINTHIRDPARTYDAILYSUMMARY_SAMPLES
STG_GARMINUSERMETRICSSUMMARY
STG_HEALTHKITACTIVITYSUMMARIES
STG_HEALTHKITSAMPLES_APPLEEXERCISETIME
STG_HEALTHKITSAMPLES_APPLEEXERCISETIME_DELETED
STG_HEALTHKITSAMPLES_HEARTRATE
STG_HEALTHKITSAMPLES_HEARTRATE_DELETED
STG_HEALTHKITSAMPLES_HEARTRATEVARIABILITY
STG_HEALTHKITSAMPLES_HEARTRATEVARIABILITY_DELETED
STG_HEALTHKITSAMPLES_RESTINGHEARTRATE
STG_HEALTHKITSAMPLES_RESTINGHEARTRATE_DELETED
STG_HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL
STG_HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL_DELETED
STG_HEALTHKITSAMPLES_STEPS
STG_HEALTHKITSAMPLES_STEPS_DELETED
STG_HEALTHKITSTATISTICS_DAILYSTEPS
STG_HEALTHKITSTATISTICS_HOURLYSTEPS
STG_MANIFEST
STG_NOTIFICATIONS
STG_SK_DEVICE_USAGE
STG_SK_KEYBOARD
STG_SK_LIGHT
STG_SK_SPEECH
STG_SK_USAGE
STG_SK_VISITS
STG_STUDYPARTICIPANTS
STG_SURVEYCONSENTSIGNATURERESULTS
STG_SURVEYDEFINITIONS
STG_SURVEYDICTIONARY
STG_SURVEYQUESTIONRESULTS
STG_SURVEYRESULTS
STG_SURVEYSTEPRESULTS
STG_SURVEYTASKS
SURVEYDICTIONARY

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected