View HLPDTEST.STATEGPS.GPS_NODE_PROPS_VW 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_NAME varchar2 255  √  null
APPLICATION_ID number 22
T_GPS_APPLICATIONS.APPLICATION_ID Implied Constraint R
ROLE_APP_ID number 22
T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID Implied Constraint R
ROLE_NAME varchar2 255  √  null
ROLE_ID number 22
T_GPS_ROLES.ROLE_ID Implied Constraint R
ROLE_NODETYPE_ID number 22
T_GPS_ROLE_NODETYPE_STATES.ROLE_NODETYPE_ID Implied Constraint R
NODETYPE varchar2 255  √  null
NODETYPE_ID number 22
T_GPS_NODETYPES.NODETYPE_ID Implied Constraint R
NODETYPE_STATE_ID number 22
T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID Implied Constraint R
CLASS_ID number 22
T_GPS_RELATION_CLASSES.CLASS_ID Implied Constraint R
CLASS_NAME varchar2 255
CLASS_ALIAS_NAME varchar2 255  √  null
PROPERTY_ID number 22
T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID Implied Constraint R
PROPERTY_NAME varchar2 255
PROPERTY_ALIAS_NAME varchar2 255  √  null
PROPERTY_DISPLAY_VALUE varchar2 10  √  null
PROPERTY_TAB_NAME varchar2 255  √  null
MANDATORY varchar2 10  √  null
OVERRIDE varchar2 10  √  null
UPDATE_IF_QUERY varchar2 10  √  null
UPDATE_IF_NOT_QUERY varchar2 10  √  null
UPDATE_IF_QRY_WITH_OVERRIDE varchar2 10  √  null
UPDATE_IF_NOT_QRY_WITH_OVERIDE varchar2 10  √  null

Analyzed at Sun Nov 29 01:06 IST 2020

View Definition:
SELECT T_GPS_APPLICATIONS.APPLICATION_NAME, T_GPS_APPLICATIONS.APPLICATION_ID, T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID, T_GPS_ROLES.ROLE_NAME, T_GPS_ROLES.ROLE_ID, T_GPS_ROLE_NODETYPES.ROLE_NODETYPE_ID, T_GPS_NODETYPES.NODETYPE, T_GPS_NODETYPES.NODETYPE_ID, T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID, T_GPS_NT_STATE_CLASSES.CLASS_ID, T_GPS_NT_STATE_CLASSES.CLASS_NAME, T_GPS_NT_STATE_CLASSES.ALIAS_NAME as Class_Alias_Name, T_GPS_NT_ST_CLASS_PROPS.PROPERTY_ID, T_GPS_NT_ST_CLASS_PROPS.PROPERTY_NAME, T_GPS_NT_ST_CLASS_PROPS.ALIAS_NAME as Property_Alias_Name, LOWER(T_GPS_NT_ST_CLASS_PROPS.DISPLAY) as Property_Display_Value, decode(T_GPS_NT_ST_CLASS_PROPS.Tab_Name, null, T_GPS_NT_STATE_CLASSES.ALIAS_NAME, T_GPS_NT_ST_CLASS_PROPS.Tab_Name) as Property_Tab_Name, LOWER(T_GPS_NT_ST_CLASS_PROPS.Mandatory) as Mandatory, T_GPS_NT_ST_CLASS_PROPS.OVERRIDE, T_GPS_NT_ST_CLASS_PROPS.Update_If_Query, T_GPS_NT_ST_CLASS_PROPS.Update_If_Not_Query, decode(LOWER(T_GPS_NT_ST_CLASS_PROPS.Update_If_Query), 'false' , LOWER(T_GPS_NT_ST_CLASS_PROPS.OVERRIDE), LOWER(T_GPS_NT_ST_CLASS_PROPS.Update_If_Query)) Update_If_Qry_with_Override, decode(LOWER(T_GPS_NT_ST_CLASS_PROPS.Update_If_Not_Query), 'false' , LOWER(T_GPS_NT_ST_CLASS_PROPS.OVERRIDE), LOWER(T_GPS_NT_ST_CLASS_PROPS.Update_If_Not_Query)) Update_If_Not_Qry_with_Overide FROM STATEGPS.T_GPS_APPLICATIONS T_GPS_APPLICATIONS, STATEGPS.T_GPS_ROLE_APPLICATIONS T_GPS_ROLE_APPLICATIONS, STATEGPS.T_GPS_ROLES T_GPS_ROLES, STATEGPS.T_GPS_ROLE_NODETYPES T_GPS_ROLE_NODETYPES, STATEGPS.T_GPS_NODETYPES T_GPS_NODETYPES, STATEGPS.T_GPS_NODETYPE_STATES T_GPS_NODETYPE_STATES, STATEGPS.T_GPS_NT_STATE_CLASSES T_GPS_NT_STATE_CLASSES, STATEGPS.T_GPS_NT_ST_CLASS_PROPS T_GPS_NT_ST_CLASS_PROPS WHERE T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_ROLE_APPLICATIONS.APPLICATION_ID AND T_GPS_APPLICATIONS.APPLICATION_ID = T_GPS_NODETYPE_STATES.APPLICATION_ID AND T_GPS_ROLES.ROLE_ID = T_GPS_ROLE_APPLICATIONS.ROLE_ID AND T_GPS_ROLE_APPLICATIONS.ROLE_APP_ID = T_GPS_ROLE_NODETYPES.ROLE_APP_ID AND T_GPS_NODETYPES.NODETYPE_ID = T_GPS_NODETYPE_STATES.NODETYPE_ID AND T_GPS_NODETYPES.NODETYPE_ID = T_GPS_ROLE_NODETYPES.NODETYPE_ID AND T_GPS_NODETYPE_STATES.NODETYPE_STATE_ID = T_GPS_NT_STATE_CLASSES.NODETYPE_STATE_ID AND T_GPS_NT_STATE_CLASSES.CLASS_ID = T_GPS_NT_ST_CLASS_PROPS.CLASS_ID ----to check visible flag of nodetype_state_id AND LOWER(T_GPS_NODETYPE_STATES.VISIBLE_FLAG) = 'true' AND LOWER(T_GPS_APPLICATIONS.VISIBLE_FLAG)= 'true' --considering only props having display = true AND LOWER(T_GPS_NT_ST_CLASS_PROPS.DISPLAY) = 'true'
 
Possibly Referenced Tables/Views:


Close relationships: