Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PARTICIPANTIDENTIFIER | VARCHAR2 | 15 | null |
|
|
||||||
| RECORD_DATE | TIMESTAMP(6) WITH TIME ZONE | 13,6 | √ | null |
|
|
|||||
| RECORD_DATE_UTC | TIMESTAMP(6) | 11,6 | SYS_EXTRACT_UTC("RECORD_DATE") |
|
|
||||||
| DEVICE | VARCHAR2 | 100 | √ | null |
|
|
|||||
| BATTERY | VARCHAR2 | 100 | √ | null |
|
|
|||||
| TYPE | VARCHAR2 | 100 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FITBITDEVICES_PK | Primary key | Asc/Asc | PARTICIPANTIDENTIFIER + RECORD_DATE_UTC |
Relationships
Close relationships within degrees of separation
