Table HLPDTEST.STATEGPS.T_GPS_VIEWER_INSTANCES 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
SET_ID number 22  √  null
T_GPS_VIEWER_INSTANCES_SET.SET_ID FK_T_GPS_VIEWER_INSTANCES_NT C
USER_ID number 22  √  null
T_GPS_USERS.USER_ID Implied Constraint R
VIEWER_INSTANCES_ID number 22
GPS_EWKS_NODE_PROPS_VW.VIEWER_INSTANCES_ID Implied Constraint R
T_GPS_ROLE_LEVEL_EWKS_ACTIONS.VIEWER_INSTANCES_ID FK_ROLE_LEVEL_EWKS_ACTIONS C
T_GPS_ROLE_VIEWER_INSTANCES.VIEWER_INSTANCE_ID FK_T_GPS_ROLE_INSTANCE_F C
T_GPS_USER_VIEWER_INSTANCES.VIEWER_INSTANCE_ID FK_T_GPS_USER_INSTANCE_F C
T_GPS_VIEWER_AUDITTRAIL.VIEWER_INSTANCES_ID Implied Constraint R
T_GPS_VIEWER_CONFIGURATION_V.VIEWER_INSTANCES_ID Implied Constraint R
T_GPS_VIEWER_DEFAULTCONDITIONS.VIEWER_INSTANCES_ID FK_T_GPS_DEFAULT_CONDITIONS C
T_GPS_VIEWER_DRILL_DOWNS.PARENT_INSTANCE_ID FK_T_GPS_VIEWER_DRILL_DOWNS C
T_GPS_VIEWER_FOOTER_CONFIG.VIEWER_INSTANCES_ID SYS_C0035134 C
T_GPS_VIEWER_GRAPH_DETAILS.VIEWER_INSTANCES_ID FK_VIEWER_INSTANCES_ID C
T_GPS_VIEWER_INSTANCES_CLASSES.VIEWER_INSTANCES_ID FK_T_GPS_VIEWER_INST_CLASSES C
T_GPS_VIEWER_KPI_CONFIG.VIEWER_INSTANCES_ID SYS_C0010397 C
T_GPS_VIEWER_MAIL_CONFIG.VIEWER_INSTANCES_ID FK_VIEWER_INSTANCES C
T_GPS_VIEWER_PDF_FORMAT.VIEWER_INSTANCES_ID FK_VIEWER_PDF_FORMAT_ID R
T_GPS_VIEWER_SCHEDULE.VIEWER_INSTANCES_ID Implied Constraint R
T_GV_DEFAULT_REPORT_INFO.VIEWER_INSTANCES_ID FK_T_GV_DEFAULT_REPORT_INFO_NT C
T_GV_EDIT_DATA_VALIDATIONS.VIEWER_INSTANCES_ID FK_T_GV_EDIT_DATA_VALIDATIONS C
T_GV_OLAP_CONFIGURATION.VIEWER_INSTANCES_ID VIEWER_OLAP_FKY C
T_GV_TRANSIENT_FIELD_INFO.VIEWER_INSTANCES_ID SYS_C0032175 R
VR_SCHEDULE_V.VIEWER_INSTANCES_ID Implied Constraint R
EDYNAMO_CLASS varchar2 255
EDYNAMO_INSTANCE_NAME varchar2 255  √  null
UPDATED_AT date 7  √  null
FORM_NAME varchar2 255  √  null
FORM_HEADER varchar2 255  √  null
FORM_FOOTER varchar2 255  √  null
FORM_PAGE_NO number 22  √  null
FORM_DATE date 7  √  null
FORM_CREATED_BY varchar2 255  √  null
EIS_CONFIGURATION varchar2 255  √  null
FORM_LEVEL varchar2 30  √  null
FORM_VIEW varchar2 30  √  null
FORM_ORDER number 22  √  null
CONFIGURED_BY varchar2 20  √  null
USER_DEFINED_NAME varchar2 255  √  null
PUBLIC_ACCESS varchar2 10  √  null
POST_INSTANCE_NAME varchar2 1000  √  null
DESTINATION_DB_CONFIG varchar2 255  √  null
FORM_VIEW_TYPE varchar2 20  √  null
KPI_TYPE varchar2 255  √  null
INTERNAL_FRAME_TYPE varchar2 25  √  null
WHERE_CONDITION varchar2 4000  √  null
DEFAULT_REPORT varchar2 20  √  null
REPORT_DESCRIPTION varchar2 4000  √  null
QUERY_CRITERIA_FOR_OLAP varchar2 20  √  null
ALLOW_ADD_NEW_RECORD varchar2 20  √  null
CUSTOM_FRAME varchar2 20  √  null
ACTION_WHILE_UPDATE_CLASS varchar2 100  √  null
CUSTOM_VIEW_INSTANCE_NAME varchar2 100  √  null
DIMENSION_R2O_DETAILS_XML varchar2 100  √  null
CHUNK_SIZE number 22  √  null
ABOUT_REPORT blob 4000  √  null
ALLOW_CELL_WRAP varchar2 11  √  null
INTERNAL_FRAME varchar2 255  √  null
ACTION_AFTER_UPDATE_CLASS varchar2 100  √  null
VISIBLE_FLAG varchar2 30  √  'true'
DISPLAY_ANR_DIALOG varchar2 5  √  null
DRILLDOWN_WITH_NULL_VALUE varchar2 5  √  null
PIVOT_INFO varchar2 100  √  null
PSEUDO_REPORT_DETAILS varchar2 2000  √  null
MUTUALLY_EXCLUSIVE_QC varchar2 10  √  null
OLAP_FOR_PLANNING varchar2 10  √  null
DOCUMENT_PATH varchar2 4000  √  null
CASE_SENSITIVE_FLAG varchar2 10  √  null
OLAP_FUNCTION varchar2 1000  √  null
NONPLANNING_REPORT varchar2 10  √  null
DRILLDOWN_REPORT varchar2 10  √  null
ALLOW_DUPLICATE_HEADERS varchar2 10  √  null
UPDATED_BY varchar2 255  √  null
SEND_WHOLE_DATA varchar2 20  √  null
FORM_IMAGE varchar2 255  √  null
DISPLAY_NAME varchar2 255  √  null
GROUP_NAME varchar2 255  √  null
IS_TABBED varchar2 10  √  null
OPEN_REPORT_IN_RECORDVIEW varchar2 20  √  null
ADF_LINK varchar2 1000  √  null
OTP_ENABLE varchar2 10  √  null
CUSTOM_MESSAGE varchar2 255  √  null
DISABLE_QUERY_DIALOG varchar2 20  √  null
SHOW_PROCEDURE_OUTPUT varchar2 20  √  null
STOP_BLIND_QUERY varchar2 20  √  null
PSUEDO_WHERE_CONDITION varchar2 1000  √  null
VISIBLE_IN_SEARCH varchar2 10  √  'true'
ADD_NEWRECORD_IF_NODATA varchar2 10  √  'false'
RESTRICT_MULTIPLE_INSERT varchar2 5  √  'false'
FORMVIEW_IF_SINGLERECORD varchar2 10  √  'false'
HELP_LINK varchar2 255  √  null
WF_ACTIONS_MENU_TITLE varchar2 255  √  null
SPLITTER_POSITION number 4  √  null
EWORKSHEET_FOOTER_OPTIONS varchar2 100  √  null
ROW_SELECTION varchar2 30  √  null
AGGREGATE_SUM_FUNCTION varchar2 5  √  null
ROWS_PER_PAGE number 22  √  null
VIEW_COMPONENT_TYPE varchar2 100  √  null
GRAPH_AREA_ORIENTATION varchar2 20  √  null
GLOBAL_ACCESS varchar2 5  √  null
PIVOT_HEADER_OPTIONS varchar2 100  √  null
ALLOW_ONLYONE_DOC_TO_UPLOAD varchar2 5  √  null
AUTO_INTERVAL_TIME number 22  √  null

Table contained 9,607 rows at Thu Oct 28 01:06 IST 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
VIEWER_INSTANCES_ID Primary key Asc SYS_C0010122  
SET_ID Performance Asc T_GPS_VIEWER_INSTANCES_INDEX  
SET_ID + VISIBLE_FLAG Performance Asc/Asc T_GPS_VIEWER_INSTANCES_INDEX1  
SET_ID + FORM_NAME Must be unique Asc/Asc UK_T_GPS_VIEWER_INSTANCES These unique columns are also nullable

Close relationships  within of separation: