View HLPDTEST.STATEGPS.T_APP_MAIL_SETUP_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
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
SMTP_HOST_ID number 22
SMTP_HOST varchar2 4000  √  null
FROM_MAIL_ID_ID number 22
FROM_MAIL_ID varchar2 4000  √  null

Analyzed at Fri Oct 30 01:06 IST 2020

View Definition:
select APP.APPLICATION_ID,APP.APPLICATION_NAME,X.SMTP_HOST_ID,X.SMTP_HOST,Y.FROM_MAIL_ID_ID, Y.FROM_MAIL_ID FROM (SELECT APPLICATION_ID,PROPERTY_ID SMTP_HOST_ID,PROPERTY_VALUE SMTP_HOST FROM t_gps_app_properties where PROPERTY_NAME = 'SMTP HOST') X, (SELECT APPLICATION_ID,PROPERTY_ID FROM_MAIL_ID_ID,PROPERTY_VALUE FROM_MAIL_ID FROM t_gps_app_properties WHERE PROPERTY_NAME = 'FROM MAIL ID') Y, T_GPS_APPLICATIONS APP WHERE X.APPLICATION_ID = Y.APPLICATION_ID AND APP.APPLICATION_ID = X.APPLICATION_ID AND (APP.VISIBLE_FLAG IS NULL OR APP.VISIBLE_FLAG = 'true') ORDER BY APP.APPLICATION_NAME
 
Possibly Referenced Tables/Views:


Close relationships: