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 |