Table HLPDTEST.STATEGPS.T_GPS_CM_PT_CLASS_PROPS 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
CLASS_ID number 22  √  null
T_GPS_COM_PATH_CLASSES.CLASS_ID FK_T_GPS_CM_PT_CLASS_PROPS C
PROPERTY_ID number 22  √  null
T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID Implied Constraint R
PROPERTY_NAME varchar2 255  √  null
ALIAS_NAME varchar2 255  √  null
DESCRIPTOR varchar2 25  √  null
LOV varchar2 255  √  null
PARAMETER varchar2 255  √  null
ACTIVE varchar2 10  √  null

Table contained 2 rows at Tue Jan 26 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name
CLASS_ID Performance Asc T_GPS_CM_PT_CLASS_PROPS_INDEX

Close relationships  within of separation: