ANALYTICSEVENTS_EMAILCLICK


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PARTICIPANTIDENTIFIER VARCHAR2 15 √ null
STUDYPARTICIPANTS.PARTICIPANTIDENTIFIER Implied Constraint R
EVENT_TIMESTAMP TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
PARTICIPANTID VARCHAR2 200 √ null
EMAILEVENTKEY VARCHAR2 200 √ null
MAILDESTINATION VARCHAR2 200 √ null
MAILTIMESTAMP TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
MAILSOURCE VARCHAR2 200 √ null
MAILMESSAGEID VARCHAR2 200 √ null
NOTIFICATIONIDENTIFIER VARCHAR2 200 √ null
FROMDOMAIN VARCHAR2 200 √ null
LOCALECODE VARCHAR2 200 √ null
CLICKTIMESTAMP TIMESTAMP(6) WITH TIME ZONE 13,6 √ null
CLICKUSERAGENT VARCHAR2 500 √ null
CLICKIPADDRESS VARCHAR2 200 √ null
CLICKLINK VARCHAR2 500 √ null
CLICKLINKTAGS VARCHAR2 200 √ null

Relationships

Close relationships within degrees of separation