Table HLPDTEST.STATEGPS.T_GPS_VIEWER_MAIL_CONFIG 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
MAIL_CONFIG_ID number 22
VIEWER_INSTANCES_ID number 22  √  null
T_GPS_VIEWER_INSTANCES.VIEWER_INSTANCES_ID FK_VIEWER_INSTANCES C
USER_NAME varchar2 255  √  null
SMTP_HOST varchar2 255  √  null
SMTP_PORT varchar2 255  √  null
FROM_MAIL_ID varchar2 1000  √  null
FROM_MAILID_PASSWORD varchar2 1000  √  null
TO_MAIL_ID varchar2 4000  √  null
CC varchar2 4000  √  null
BCC varchar2 4000  √  null
SUBJECT varchar2 4000  √  null
MESSAGE varchar2 4000  √  null
ATTACHMENT_FLAG varchar2 20  √  null
UPDATED_DATE date 7  √  null
FOOTERMESSAGE varchar2 4000  √  null
FILE_FORMAT varchar2 20  √  null

Table contained 498 rows at Wed Oct 28 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
MAIL_CONFIG_ID Primary key Asc SYS_C0019071

Close relationships  within of separation: