NOTIFICATIONS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID RAW 16 null
PARTICIPANTIDENTIFIER VARCHAR2 15 null
STUDYPARTICIPANTS.PARTICIPANTIDENTIFIER NOTIFICATIONS_PARTICIPANTIDENTIFIER_FK R
NOTIFY_DATE TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
CONTENTVERSION NUMBER 38 √ null
IDENTIFIER VARCHAR2 200 √ null
NOTIFICATIONBODY VARCHAR2 2000 √ null
NOTIFICATIONTITLE VARCHAR2 200 √ null
NOTIFICATIONTYPE VARCHAR2 50 √ null
SCOPE RAW 16 √ null
STATUSCODE VARCHAR2 200 √ null

Indexes

Constraint Name Type Sort Column(s)
NOTIFICATIONS_PK Primary key Asc ID

Relationships