Table HLPDTEST.STATEGPS.T_GPS_MODEL_SR_ATT_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_MODEL_SR_ATT_CLASSES.CLASS_ID FK_MODEL_SR_ATT_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
DEFAULT_VALUE varchar2 255  √  null
LOV varchar2 255  √  null
LOV_PARAMETER varchar2 255  √  null
EXTRA_INFO varchar2 2000  √  null
ACTIVE varchar2 50  √  null

Table contained 0 rows at Tue May 24 01:05 IST 2022

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

Close relationships  within of separation: