Table HLPDTEST.STATEGPS.T_GPS_MAILS_SENT Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
SMTPHOST varchar2 40  √  null
SMTPPORT varchar2 40  √  null
MAILAUTHENTICATIONFLAG varchar2 40  √  null
MAILAUTHENTICATIONUSERNAME varchar2 100  √  null
MAILAUTHENTICATIONPASSWORD varchar2 40  √  null
FROMUSER varchar2 255  √  null
TOUSER varchar2 4000  √  null
CC varchar2 4000  √  null
BCC varchar2 4000  √  null
MESSAGE varchar2 4000  √  null
SUBJECT varchar2 4000  √  null
STATUS varchar2 4000  √  null
ATTACHMENTS varchar2 4000  √  null
SENT_AT date 7  √  now
MAILS_SENT_ID number 22
T_GPS_MAIL_SENT_V.MAILS_SENT_ID Implied Constraint R
MESSAGE_BLOB blob 4000  √  null
TO_STATE_ID number 22  √  null
INSTANCE_ID number 22  √  null
T_GPS_WORKFLOW_INSTANCES.INSTANCE_ID Implied Constraint R
RESENT_AT date 7  √  null
RESEND_ATTEMPTS number 22  √  null
MIMEMESSAGE_FILE_ID number 22  √  null
STATUS_MESSAGE varchar2 4000  √  null
PREV_CONVO_MAILS_SENT_IDZ varchar2 255  √  null
PUBLIC_VISIBILITY varchar2 255  √  null

Table contained 1,444,041 rows at Wed May 25 01:05 IST 2022

Indexes:
Column(s) Type Sort Constraint Name
MAILS_SENT_ID Primary key Asc SYS_C0016081
BCC Performance Asc BCC_IDX
CC Performance Asc CC_IDX
MIMEMESSAGE_FILE_ID Performance Asc T_GPS_MAILS_SENT_MIME_FILE_IDX
Performance T_GPS_MAILS_SENT_SENTAT_IDX
SENT_AT Performance Asc T_GPS_MAILS_SENT_SENTAT_IDX2
TO_STATE_ID + INSTANCE_ID Performance Asc/Asc TO_STATE_ID_INSTANCE_ID_I
TOUSER Performance Asc TOUSER_IDX

Close relationships: