os_participant_email_tmpls

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
IDENTIFIER BIGINT 19 √ null
CP_ID BIGINT 19 null
catissue_collection_protocol.IDENTIFIER FK_EMAIL_TMPL_CP_IDR
NAME VARCHAR 255 null
LOGO_URL VARCHAR 255 √ null
FROM_DISPLAY_NAME VARCHAR 255 √ null
FROM_EMAIL_ID VARCHAR 255 √ null
EMAIL_SUBJ VARCHAR 255 null
EMAIL_CONTENT TEXT 65535 null
CREATED_BY BIGINT 19 null
catissue_user.IDENTIFIER FK_EMAIL_TMPL_CREATORR
CREATION_TIME TIMESTAMP 19 null
UPDATED_BY BIGINT 19 √ null
catissue_user.IDENTIFIER FK_EMAIL_TMPL_UPDATERR
UPDATE_TIME TIMESTAMP 19 √ null
ACTIVITY_STATUS VARCHAR 16 Active

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc IDENTIFIER
FK_EMAIL_TMPL_CP_ID Performance Asc CP_ID
FK_EMAIL_TMPL_CREATOR Performance Asc CREATED_BY
FK_EMAIL_TMPL_UPDATER Performance Asc UPDATED_BY

Relationships

Close relationships within degrees of separation