SURVEYCONSENTSIGNATURERESULTS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SURVEYCONSENTSIGNATURERESULTKEY RAW 16 null
SURVEYSTEPRESULTKEY RAW 16 null
SURVEYSTEPRESULTS.SURVEYSTEPRESULTKEY SURVEYCONSENTSIGNATURERESULTS_SURVEYSTEPRESULTKEY_FK R
SURVEYRESULTKEY RAW 16 null
SURVEYRESULTS.SURVEYRESULTKEY SURVEYCONSENTSIGNATURERESULTS_SURVEYRESULTKEY_FK R
PARTICIPANTIDENTIFIER VARCHAR2 15 null
STUDYPARTICIPANTS.PARTICIPANTIDENTIFIER SURVEYCONSENTSIGNATURERESULTS_PARTICIPANTIDENTIFIER_FK R
RESULTIDENTIFIER VARCHAR2 200 √ null
CONSENTED VARCHAR2 200 √ null
SIGNATUREIDENTIFIER VARCHAR2 200 √ null
SIGNATURETITLE VARCHAR2 200 √ null
SIGNATUREGIVENNAME VARCHAR2 200 √ null
SIGNATUREFAMILYNAME VARCHAR2 200 √ null
SIGNATUREDATE VARCHAR2 15 √ null
STARTDATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
ENDDATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null

Indexes

Constraint Name Type Sort Column(s)
SURVEYCONSENTSIGNATURERESULTS_PK Primary key Asc SURVEYCONSENTSIGNATURERESULTKEY

Relationships

Close relationships within degrees of separation