View HLPDTEST.STATEGPS.GPS_EWKS_NODE_PROPS_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
SET_NAME varchar2 255  √  null
SET_ID number 22
T_GPS_COND_ST_CHANGE_SETS.SET_ID Implied Constraint R
FORM_NAME varchar2 255  √  null
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
CLASS_ID number 22
T_GPS_RELATION_CLASSES.CLASS_ID Implied Constraint R
CLASS_NAME varchar2 255
PROPERTY_ID number 22
T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID Implied Constraint R
PROPERTY_NAME varchar2 255
ALIAS_NAME varchar2 255  √  null
DISPLAY varchar2 10  √  null
PROP_ACL_ID number 22  √  null
T_GPS_ROLE_NODE_PROP_ACL.PROP_ACL_ID Implied Constraint R
VISIBLITY varchar2 10  √  null
READ_ACCESS varchar2 10  √  null
INSERT_ACCESS varchar2 10  √  null
UPDATE_ACCESS varchar2 10  √  null

Analyzed at Mon Mar 01 01:05 IST 2021

View Definition:
SELECT GPS_EWKS_NODE_PROPS_VW.application_name, GPS_EWKS_NODE_PROPS_VW.application_id, GPS_EWKS_NODE_PROPS_VW.set_name, GPS_EWKS_NODE_PROPS_VW.set_id, GPS_EWKS_NODE_PROPS_VW.form_name, GPS_EWKS_NODE_PROPS_VW.role_app_id, GPS_EWKS_NODE_PROPS_VW.role_name, GPS_EWKS_NODE_PROPS_VW.role_id, GPS_EWKS_NODE_PROPS_VW.class_id, GPS_EWKS_NODE_PROPS_VW.class_name, GPS_EWKS_NODE_PROPS_VW.property_id, GPS_EWKS_NODE_PROPS_VW.property_name, GPS_EWKS_NODE_PROPS_VW.alias_name, GPS_EWKS_NODE_PROPS_VW.display, t_gps_role_node_prop_acl.prop_acl_id, nvl(t_gps_role_node_prop_acl.read_access, 'true') AS visiblity, nvl(t_gps_role_node_prop_acl.read_access, GPS_EWKS_NODE_PROPS_VW.display) AS read_access, nvl(t_gps_role_node_prop_acl.insert_access, GPS_EWKS_NODE_PROPS_VW.insert_flag) AS insert_access, nvl(t_gps_role_node_prop_acl.update_access, GPS_EWKS_NODE_PROPS_VW.edit) AS update_access FROM GPS_EWKS_NODE_PROPS_VW GPS_EWKS_NODE_PROPS_VW LEFT JOIN t_gps_role_node_prop_acl t_gps_role_node_prop_acl ON GPS_EWKS_NODE_PROPS_VW.application_name = t_gps_role_node_prop_acl.application_name AND GPS_EWKS_NODE_PROPS_VW.role_name = t_gps_role_node_prop_acl.role_name AND GPS_EWKS_NODE_PROPS_VW.class_name = t_gps_role_node_prop_acl.class_name AND GPS_EWKS_NODE_PROPS_VW.property_name = t_gps_role_node_prop_acl.property_name
 
Possibly Referenced Tables/Views:
GPS_EWKS_NODE_PROPS_VW T_GPS_ROLE_NODE_PROP_ACL 


Close relationships: