Table HLPDTEST.STATEGPS.T_GPS_NT_ST_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_NT_STATE_CLASSES.CLASS_ID FK_T_GPS_NT_ST_CLASS_PROPS C
PROPERTY_ID number 22
T_GPS_GOOGLE_MAP_SETUP.IF_CHILD_PROPERTY_ID SYS_C0033228 R
T_GPS_NODE_EDIT_CONDITIONS.PROPERTY_ID EDIT_CONDITION_FK C
T_GPS_RLTION_CLASS_PROPS.PROPERTY_ID Implied Constraint R
PROPERTY_NAME varchar2 255
ALIAS_NAME varchar2 255  √  null
TAB_NAME varchar2 255  √  null
DATA_TYPE varchar2 255  √  null
FORMAT varchar2 255  √  null
DEFAULT_VALUE varchar2 255  √  null
COLUMN_WIDTH number 22  √  null
DISPLAY varchar2 10  √  null
DISPLAY_ON_TREE varchar2 10  √  null
MANDATORY varchar2 10  √  null
AUTO_NUMBER varchar2 10  √  null
FDT_FILE varchar2 255  √  null
FDT_PARAMETER varchar2 255  √  null
AUTO_LOV varchar2 10  √  null
INHERIT_FROM varchar2 255  √  null
OVERRIDE varchar2 10  √  null
CONDITIONAL varchar2 255  √  null
DESCRIPTION varchar2 2000  √  null
EXTRA_INFO varchar2 2000  √  null
PROPERTY_TYPE varchar2 255  √  null
UPDATE_IF_QUERY varchar2 10  √  null
BUSINESS_KEY varchar2 20  √  null
SYSTEM_KEY varchar2 20  √  null
EDIT_CONDITIONS varchar2 4000  √  null
DISPLAY_TREE_ORDER number 22  √  null
DISPLAY_ON_ERROR_REPORT varchar2 20  √  null
UPDATE_IF_NOT_QUERY varchar2 10  √  'false'

Table contained 3,533,456 rows at Fri Oct 30 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name
PROPERTY_ID Primary key Asc SYS_C0010062
CLASS_ID Performance Asc T_GPS_NT_ST_CLASS_PROPS_INDEX

Close relationships  within of separation: