View HLPDTEST.STATEGPS.GPS_NODE_PORPS_CONFIG_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_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
PROP_ACL_ID number 22  √  null
T_GPS_ROLE_NODE_PROP_ACL.PROP_ACL_ID Implied Constraint R
READ_ACCESS varchar2 10  √  null
INSERT_ACCESS varchar2 10  √  null
UPDATE_ACCESS varchar2 10  √  null
UPDATE_IF_QRY_WITH_OVERRIDE varchar2 10  √  null
UPDATE_IF_NOT_QRY_WITH_OVERIDE varchar2 10  √  null

Analyzed at Fri Oct 30 01:06 IST 2020

View Definition:
SELECT gps_node_props_vw.application_name, gps_node_props_vw.application_id, gps_node_props_vw.role_app_id, gps_node_props_vw.role_name, gps_node_props_vw.role_id, gps_node_props_vw.role_nodetype_id, gps_node_props_vw.nodetype, gps_node_props_vw.nodetype_id, gps_node_props_vw.nodetype_state_id, gps_node_props_vw.class_id, gps_node_props_vw.class_name, gps_node_props_vw.class_alias_name, gps_node_props_vw.property_id, gps_node_props_vw.property_name, gps_node_props_vw.property_alias_name, gps_node_props_vw.property_display_value, gps_node_props_vw.property_tab_name, gps_node_props_vw.mandatory, gps_node_props_vw.override, gps_node_props_vw.update_if_query, gps_node_props_vw.update_if_not_query, t_gps_role_node_prop_acl.prop_acl_id, nvl(t_gps_role_node_prop_acl.read_access, 'true') AS read_access, nvl(t_gps_role_node_prop_acl.insert_access, gps_node_props_vw.update_if_not_qry_with_overide) AS insert_access, nvl(t_gps_role_node_prop_acl.update_access, gps_node_props_vw.update_if_qry_with_override) AS update_access, gps_node_props_vw.update_if_qry_with_override, gps_node_props_vw.update_if_not_qry_with_overide FROM gps_node_props_vw gps_node_props_vw LEFT JOIN t_gps_role_node_prop_acl t_gps_role_node_prop_acl ON gps_node_props_vw.application_name = t_gps_role_node_prop_acl.application_name AND gps_node_props_vw.role_name = t_gps_role_node_prop_acl.role_name AND gps_node_props_vw.nodetype = t_gps_role_node_prop_acl.nodetype AND gps_node_props_vw.class_name = t_gps_role_node_prop_acl.class_name AND gps_node_props_vw.property_name = t_gps_role_node_prop_acl.property_name
 
Possibly Referenced Tables/Views:


Close relationships: