Table HLPDTEST.STATEGPS.T_GPS_VIEWER_INST_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_VIEWER_INSTANCES_CLASSES.CLASS_ID FK_T_GPS_VIEW_INST_CLAS_PROPS C
PROPERTY_ID number 22
T_GPS_DRILL_DOWN_PROPERTIES.PROPERTY_ID FK_T_GPS_DRILL_DOWN_PROPERTIES C
T_GPS_VIEWER_EDIT_CONFIG.PROPERTY_ID FK_EDIT_CONFIGURATION C
T_GPS_VIEWER_LOV_INFO.PROPERTY_ID T_GPS_VIEWER_LOV_INFO_FK C
T_GPS_VIEWER_PROPERTY_ORDER.PROPERTY_ID FK1_T_GPS_VWR_PROPERTY_ORDER C
T_GPS_VIEWER_PROPS_OPERATORS.PROPERTY_ID FK_T_GPS_VIEWER_PROPS_OP 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
DISPLAY varchar2 10  √  null
MANDATORY varchar2 10  √  null
FDT_FILE varchar2 255  √  null
FDT_PARAMETER varchar2 255  √  null
TOOLTIP varchar2 4000  √  null
EXTRA_INFO varchar2 4000  √  null
PROPERTY_ORDER number 22  √  null
QUERY_CRITERIA varchar2 10  √  null
QUERY_RESULTS varchar2 10  √  null
BUSINESS_KEY varchar2 10  √  null
SYSTEM_KEY varchar2 10  √  null
SORT_ORDER varchar2 255  √  null
COLUMN_WIDTH number 22  √  null
DEFAULT_VALUE varchar2 30  √  null
DESCRIPTION varchar2 3000  √  null
PIVOT varchar2 20  √  null
EDIT varchar2 5  √  null
EDIT_INFO varchar2 2500  √  null
PIVOT_INDEX number 22  √  null
QUERY_DEFAULT varchar2 255  √  null
ENABLE_LOV_EDIT varchar2 5  √  null
AFUNCTION varchar2 255  √  null
FUNCTION varchar2 255  √  null
AUTO_COPY varchar2 20  √  null
COLOURING varchar2 20  √  null
MANDATORY_FOR_EDIT varchar2 10  √  null
PROPERTY_TYPE varchar2 100  √  null
INSERT_FLAG varchar2 10  √  null
COLUMN_ALIGNMENT varchar2 10  √  null
FDT_INPUT_TYPE varchar2 10  √  null
ENABLE_LOV_INSERT varchar2 5  √  null
MANDATORY_FOR_INSERT varchar2 10  √  null
FILTER_ORDER number 22  √  null
TRANSPOSE_CONFIG varchar2 50  √  null
GROUP_FUNCTION varchar2 10  √  null
INSERT_DEFAULT_VALUE varchar2 2000  √  null
QUERY_ORDER number 22  √  null
MOBILE_HEADER varchar2 10  √  null
FORM_FIELD varchar2 10  √  null
HIDE_AT_USER_LEVEL varchar2 10  √  null
AUDIT_TRACK varchar2 10  √  null
QUERY_TOKEN varchar2 10  √  null
ADD_TO_QUERY varchar2 10  √  null
PSEUDO_OPERATOR varchar2 50  √  null
PSEUDO_QUERY_DEFAULT_VALUE1 varchar2 500  √  null
PSEUDO_QUERY_DEFAULT_VALUE2 varchar2 500  √  null
CHARACTER_LIMIT number 22  √  null
REGEX varchar2 200  √  null
REGEX_MESSAGE varchar2 4000  √  null
PASTDATE_RESTRICTION varchar2 10  √  'false'
FUTUREDATE_RESTRICTION varchar2 10  √  'false'
COPY_FROM_COLUMN varchar2 255  √  null
COPY_COLUMN_TITLE varchar2 500  √  null
DISABLE_PIVOTROW_SUBTOTAL varchar2 30  √  null
DISABLE_PIVOTCOLUMN_SUBTOTAL varchar2 30  √  null
COPY_COLUMN_TYPE varchar2 20  √  null
MASS_UPDATE_CONFIG varchar2 50  √  null
MULTILINE_ROWS varchar2 10  √  null
INCLUDE_IN_MODIFIED_DATA varchar2 5  √  null
INCLUDE_IN_GRAPH_DRILLDOWN varchar2 5  √  null
DISABLED_DAYS_OF_WEEK varchar2 100  √  null

Table contained 190,435 rows at Sat Oct 31 01:06 IST 2020

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

Close relationships  within of separation: