View HLPDTEST.STATEGPS.T_GPS_MAIL_SENT_V 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
TOUSER varchar2 4000  √  null
SENT_AT date 7  √  null
MAILS_SENT_ID number 22  √  null
T_GPS_MAILS_SENT.MAILS_SENT_ID Implied Constraint R
STATUS varchar2 7  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
SELECT T_GPS_MAILS_SENT.TOUSER, T_GPS_MAILS_SENT.SENT_AT, 1 AS MAILS_SENT_ID, DECODE (T_GPS_MAILS_SENT.STATUS,'Mail had been sent sucessfully .... ','SUCCESS', 'success','SUCCESS', 'Mail has been sent sucessfully.','SUCCESS', 'Mail has been sent successfully.','SUCCESS','FAILURE') STATUS FROM STATEGPS.T_GPS_MAILS_SENT T_GPS_MAILS_SENT
 
Possibly Referenced Tables/Views:
T_GPS_MAILS_SENT 


Close relationships: