Table HLPDTEST.STATEGPS.T_GPS_NOTIFICATION_DETAILS 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
OPERATION_ID number 22  √  null
T_GPS_STATE_OPERATIONS.OPERATION_ID FK_T_GPS_NOTIFICATION_DETAILS C
FROM_MAIL_ID varchar2 100  √  null
SUBJECT varchar2 4000  √  null
SMTP_HOST varchar2 255  √  null
TO_EMAIL_ID varchar2 4000  √  null
INCLUDE_CHILD varchar2 10  √  null
ATTACHMENT varchar2 1000  √  null
NOTIFICATION_TYPE varchar2 25  √  null
INCLUDE_COND_STATE_PROPS varchar2 10  √  null
ERROR_SUBJECT varchar2 500  √  null
ERROR_MESSAGE varchar2 4000  √  null
TO_USER varchar2 255  √  null
TO_ROLE varchar2 255  √  null
MESSAGE blob 4000  √  null
EXPLODE_ROLE varchar2 10  √  null
NOTIFICATION_GENERATION_TYPE varchar2 255  √  null
NOTIFICATION_ID number 22  √  null
NOTIFICATION_DETAILS_ID number 22
T_GPS_CONDITIONAL_STATE_CHANGE.NOTIFICATION_DETAILS_ID FK_NOTIFICATION_DETAILS_ID C
WORKFLOW_TYPE_ID number 22  √  null
T_GPS_WORKFLOW_TYPES.WORKFLOW_TYPE_ID FK_T_GPS_NOTIF_DETAILS_WT C
CC_EMAIL_ID varchar2 255  √  null
BCC_EMAIL_ID varchar2 255  √  null
SEND_DEFAULT_MAIL varchar2 10  √  'false'
GROUP_BY varchar2 2000  √  null
IS_ACTION_ACK_MAIL varchar2 10  √  null
MAIL_ENABLED varchar2 5  √  'true'

Table contained 2,283 rows at Sun Nov 29 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
NOTIFICATION_DETAILS_ID Primary key Asc NOTIFICATION_DETAILS_ID_PK
OPERATION_ID Performance Asc T_GPS_NOTIFI_DETAILS_INDEX

Close relationships  within of separation: