Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PARTICIPANTIDENTIFIER | VARCHAR2 | 15 | null |
|
|
||||||
| STUDY_PARTICIPANT_ID | NUMBER | 10 | √ | null |
|
|
|||||
| FITBIT | VARCHAR2 | 200 | √ | null |
|
|
|||||
| APPLE_WATCH | VARCHAR2 | 200 | √ | null |
|
|
|||||
| PHONE | VARCHAR2 | 200 | √ | null |
|
|
|||||
| STEP_LATEST | DATE | 7 | √ | null |
|
|
|||||
| SLEEP_LATEST | DATE | 7 | √ | null |
|
|
|||||
| MOOD_LATEST | DATE | 7 | √ | null |
|
|
|||||
| STEP_COUNT_30 | NUMBER | 0 | √ | null |
|
|
|||||
| STEP_COUNT_90 | NUMBER | 0 | √ | null |
|
|
|||||
| SLEEP_COUNT_30 | NUMBER | 0 | √ | null |
|
|
|||||
| SLEEP_COUNT_90 | NUMBER | 0 | √ | null |
|
|
|||||
| MOOD_COUNT_30 | NUMBER | 0 | √ | null |
|
|
|||||
| MOOD_COUNT_90 | NUMBER | 0 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
