HEALTHKITSAMPLES_STEPS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
HEALTHKITSAMPLEKEY RAW 16 null
PARTICIPANTIDENTIFIER VARCHAR2 15 null
STUDYPARTICIPANTS.PARTICIPANTIDENTIFIER HEALTHKITSAMPLES_STEPS_PARTICIPANTIDENTIFIER_FK R
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_STEPS_PK Primary key Asc HEALTHKITSAMPLEKEY

Relationships