SURVEYTASKS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SURVEYTASKKEY RAW 16 null
SURVEYRESULTS.SURVEYTASKKEY Implied Constraint R
PARTICIPANTIDENTIFIER VARCHAR2 15 null
STUDYPARTICIPANTS.PARTICIPANTIDENTIFIER SURVEYTASKS_PARTICIPANTIDENTIFIER_FK R
SURVEYKEY RAW 16 null
SURVEYNAME VARCHAR2 200 √ null
STATUS VARCHAR2 50 √ null
DUEDATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
INSERTEDDATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
CREATEDBY VARCHAR2 100 √ null
MODIFIEDDATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null

Indexes

Constraint Name Type Sort Column(s)
SURVEYTASKS_PK Primary key Asc SURVEYTASKKEY

Relationships

Close relationships within degrees of separation