Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| HEALTHKITSAMPLEKEY | RAW | 16 | null |
|
|
||||||
| PARTICIPANTIDENTIFIER | VARCHAR2 | 15 | null |
|
|
||||||
| STARTDATE | TIMESTAMP(6) WITH TIME ZONE | 13,6 | √ | null |
|
|
|||||
| RECORD_DATE | TIMESTAMP(6) WITH TIME ZONE | 13,6 | √ | null |
|
|
|||||
| VALUE | VARCHAR2 | 200 | √ | null |
|
|
|||||
| UNITS | VARCHAR2 | 200 | √ | null |
|
|
|||||
| SOURCEIDENTIFIER | VARCHAR2 | 200 | √ | null |
|
|
|||||
| SOURCENAME | VARCHAR2 | 200 | √ | null |
|
|
|||||
| SOURCEVERSION | VARCHAR2 | 50 | √ | null |
|
|
|||||
| SOURCEOPERATINGSYSTEMVERSION | VARCHAR2 | 50 | √ | null |
|
|
|||||
| SOURCEPRODUCTTYPE | VARCHAR2 | 50 | √ | null |
|
|
|||||
| DEVICENAME | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICEMODEL | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICEMANUFACTURER | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICEHARDWAREVERSION | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICESOFTWAREVERSION | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICEFIRMWAREVERSION | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICELOCALIDENTIFIER | VARCHAR2 | 200 | √ | null |
|
|
|||||
| DEVICEFDAIDENTIFIER | VARCHAR2 | 200 | √ | null |
|
|
|||||
| METADATA | VARCHAR2 | 2000 | √ | null |
|
|
|||||
| INSERTEDDATE | TIMESTAMP(6) WITH TIME ZONE | 13,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| HEALTHKITSAMPLES_SLEEPANALYSISINTERVAL_PK | Primary key | Asc | HEALTHKITSAMPLEKEY |



