View HLPDTEST.STATEGPS.AUTONUMBER_NODETYPE_VIEW 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
OBJECTTYPE varchar2 10  √  null
OBJECTNAME varchar2 255  √  null

Analyzed at Mon May 23 01:05 IST 2022

View Definition:
( (SELECT 'AUTONUMBER' , NUMBER_NAME FROM T_GPS_AUTONUMBERS) UNION (SELECT 'NODETYPE' , NODETYPE FROM T_GPS_NODETYPES))
 
Possibly Referenced Tables/Views: