Table HLPDTEST.STATEGPS.T_GPS_APPLICATIONS 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
APPLICATION_ID number 22
FREQUENTLY_ACCESSED_PROJECTS_V.APPLICATION_ID Implied Constraint R
GPS_EWKS_NODE_PROPS_CONFIG_V.APPLICATION_ID Implied Constraint R
GPS_EWKS_NODE_PROPS_VW.APPLICATION_ID Implied Constraint R
GPS_NODE_PORPS_CONFIG_V.APPLICATION_ID Implied Constraint R
GPS_NODE_PROPS_VW.APPLICATION_ID Implied Constraint R
ISSUE_PROJECT_LINKED_TC_VW.APPLICATION_ID Implied Constraint R
MIG_COMPLETED_VS_DUE_DATE_V.APPLICATION_ID Implied Constraint R
MYVIEW.APPLICATION_ID Implied Constraint R
PROJECT_CREATION_STATS_V.APPLICATION_ID Implied Constraint R
PROJECT_LINKED_TESTCASES_VW.APPLICATION_ID Implied Constraint R
RECENTLY_ACCESSED_OBJECTS_V.APPLICATION_ID Implied Constraint R
RECENTLY_ACCESSED_PROJECTS_V.APPLICATION_ID Implied Constraint R
T_APP_GROUPS.APP_ID FK_APP_ID C
T_APP_MAIL_SETUP_V.APPLICATION_ID Implied Constraint R
T_APP_NT_PARENT_RELATIONSHIP.APPLICATION_ID FK_NT_PARENT_REL_APP_ID C
T_APP_ROOT_NODETYPES.APPLICATION_ID FK_T_APP_ROOT_NT_APP_ID C
T_DAILY_OPEN_CLOSED_ISSUES_V.APPLICATION_ID Implied Constraint R
T_DUE_TASKS_V.APPLICATION_ID Implied Constraint R
T_EXEPLAN_HISTORY.PROJECT_ID EXEPLAN_PROJECT_ID C
T_GPS_APP_FDTS.APPLICATION_ID SYS_C0010355 C
T_GPS_APP_MODEL_VALID_RULES.APPLICATION_ID FK_T_GPS_MODEL_VALID_RULES C
T_GPS_APP_PROPERTIES.APPLICATION_ID FK_T_GPS_APP_PROPERTIES C
T_GPS_APP_TOKEN_INFO.APPLICATION_ID SYS_C0010289 C
T_GPS_APP_VIEW.APPLICATION_ID Implied Constraint R
T_GPS_APP_WORKFLOW_STATES_VIEW.APPLICATION_ID Implied Constraint R
T_GPS_APP_WORKFLOW_VIEW.APPLICATION_ID Implied Constraint R
T_GPS_APPLICATION_NODE_TYPES.APPLICATION_ID Implied Constraint R
T_GPS_APPLICATIONS_BACKUP.APPLICATION_ID Implied Constraint R
T_GPS_COMPRESSED_PATHS.APPLICATION_ID FK_T_GPS_COMPRESSED_PATHS C
T_GPS_CUSTOM_SETS.APPLICATION_ID FK_T_GPS_CUSTOM_SETS C
T_GPS_CUSTOM_SETS_BKP.APPLICATION_ID Implied Constraint R
T_GPS_DBV_USER_APPLICATIONS.APPLICATION_ID FK_T_GPS_DBV_APPLICATION C
T_GPS_FAVOURITE_LINKS.APPLICATION_ID FK_T_GPS_FAV_APPLICATION C
T_GPS_FAVOURITES_HISTORY.APPLICATION_ID FK_FAV_HISTORY_APPID R
T_GPS_GETCONTROLLER_FDT.APPLICATION_ID SYS_C0010296 C
T_GPS_GOOGLE_MAP_SETUP.APPLICATION_ID Implied Constraint R
T_GPS_INSTANCE_FEEDBACK_V.APPLICATION_ID Implied Constraint R
T_GPS_INSTANCES.APPLICATION_ID FK_T_GPS_INSTANCES C
T_GPS_MENUCONFIG.APPLICATION_ID FK_T_GPS_MENUCONFIG C
T_GPS_MODEL_NODE_PROPS_COMP_V.APPLICATION_ID Implied Constraint R
T_GPS_MODEL_SEARCH_ATTRIBUTES.APPLICATION_ID FK_T_GPS_MODEL_SEARCH_ATTBTS C
T_GPS_NODEGROUPS.APPLICATION_ID FK_T_GPS_NG_APP_ID C
T_GPS_NODETYPE_STATES.APPLICATION_ID FK_T_GPS_NODETYPE_STATES_APP C
T_GPS_OBJECT_REQUISITION.APPLICATION_ID Implied Constraint R
T_GPS_POPULAR_V.APPLICATION_ID Implied Constraint R
T_GPS_PROJECT_SCENARIOS.APPLICATION_ID T_GPS_PROJECT_SCENARIOS_FK1 C
T_GPS_RELATIONS.APPLICATION_ID FK_T_GPS_RELATIONS_APP_ID C
T_GPS_ROLE_APPLICATIONS.APPLICATION_ID FK_T_GPS_ROLES_APP_ID C
T_GPS_USEFUL_LINKS.APPLICATION_ID Implied Constraint R
T_GPS_USER_APPLICATIONS.APPLICATION_ID FK_T_GPS_USERS_APP_ID C
T_GPS_VIEWER_INSTANCES_SET.APPLICATION_ID FK_T_GPS_VIEWER_INSTANCES C
T_GPS_WF_DISABLED_OPERATIONS.APPLICATION_ID FK_T_GPS_WF_DIS_OPERATIONSS C
T_GPS_WF_INSTANCE_HISTORY.APPLICATION_ID Implied Constraint R
T_GPS_WF_INSTANCE_HISTORY_V.APPLICATION_ID Implied Constraint R
T_GPS_WORKFLOW_INSTANCES.APPLICATION_ID FK_T_GPS_WORKFLOW_INSTANCES C
T_GPS_WORKFLOW_TYPES.APPLICATION_ID FK_T_GPS_WORKFLOW_TYPES C
T_GPS_WORKFLOWMOVE_STATE.APPLICATION_ID Implied Constraint R
T_INSTANCES.APPLICATION_ID FK_T_INSTANCES C
T_ISSUES_CREATED_BY_ME_V.APPLICATION_ID Implied Constraint R
T_MONTHLY_OPEN_CLOSED_ISSUES_V.APPLICATION_ID Implied Constraint R
T_PROCESS_SLAS.PROJECT_ID PROJECT_ID_FORNKEY C
T_PROJECT_BFR_USAGE_THRESHOLD.PROJECT_ID T_PROJECT_BUFFER_THRESHOLD_FK C
T_PROJECT_BUFFER.PROJECT_ID PROJECT_BUFFER_FK C
T_PROJECT_CRITICAL_TASKS_V.APPLICATION_ID Implied Constraint R
T_PROJECT_CVS_MODULE.APPLICATION_ID Implied Constraint R
T_PROJECT_DETAILS.APPLICATION_ID FK_T_GPS_APPLICATIONS C
T_PROJECT_DUE_DATES_V.APPLICATION_ID Implied Constraint R
T_PROJECT_HOURS_V.APPLICATION_ID Implied Constraint R
T_PROJECT_ISSUES_STATUS_V.APPLICATION_ID Implied Constraint R
T_PROJECT_ROLE_USERS.APPLICATION_ID FK_APP_ID_PRU C
T_PROJECT_ROLES.APPLICATION_ID T_PROJECT_ROLES_T_GPS_APP_FK1 R
T_PROJECT_SLAS.PROJECT_ID PROJECT_ID_FOKEY C
T_PROJECT_TASK_V.APPLICATION_ID Implied Constraint R
T_REPORTING_PLAN_HISTORY.PROJECT_ID FK_PROJECT_ID C
T_REPORTING_PLAN_TASK_DETAIL1.PROJECT_ID FK_PLAN_TASK_DET_PROJECT_I R
T_REPORTING_PLAN_TASK_DETAILS.PROJECT_ID FK_PLAN_TASK_DET_PROJECT_ID R
T_RESOURCE_USAGE.PROJECT_ID FK_2_T_GPS_APPLICATIONS C
T_STARTED_TASKS_V.APPLICATION_ID Implied Constraint R
T_TICKET_DETAILS_V.APPLICATION_ID Implied Constraint R
T_TRADING_PARTY_PROJECTS.APPLICATION_ID FK_T_TRADING_PARTY_PROJECTS C
T_TRI2_PROJECT_MODULES.PROJECT_ID SYS_C0016865 R
T_WEEKLY_OPEN_CLOSED_ISSUES_V.APPLICATION_ID Implied Constraint R
T_WORKING_TIME.PROJECT_ID PROJECT_ID_FK R
V_MONTHLY_PROJECT_STATISTICS.APPLICATION_ID Implied Constraint R
V_TASKS_WHITEBOARD.APPLICATION_ID Implied Constraint R
XXT_PROJECT_NAME_V.APPLICATION_ID Implied Constraint R
APPLICATION_NAME varchar2 255  √  null
IMAGE_FILE varchar2 255  √  null
DESCRIPTION varchar2 4000  √  null
DEFAULT_GETCONTROLLERS varchar2 255  √  null
DEFAULT_PUTCONTROLLERS varchar2 255  √  null
VISIBLE_FLAG varchar2 255  √  'true'
CYCLE_TIME_ENABLED_FLAG varchar2 3  √  'N'
APPLICATION_ORDER number 22  √  null
CREATION_DATE date 7  √  null
LAST_UPDATED_DATE date 7  √  null
LAST_UPDATED_BY varchar2 50  √  null
CREATED_BY varchar2 50  √  null
DISPLAYNAME varchar2 255  √  null
APPLICATION_URL varchar2 255  √  null
APPLICATION_URL_DISPLAY_ON varchar2 255  √  null
APPLICATION_IMAGE varchar2 255  √  null
IS_CLOUD_ENABLED varchar2 5  √  null
ENABLE_WORKBENCH_IF_QUERY varchar2 20  √  null
ROOT_NODE_VIOLATION_MESSAGE varchar2 4000  √  null
WF_OP_MAIL_LINK_AUTH_FLAG varchar2 10  √  'false'
START_DATE timestamp(6) 11,6  √  null
END_DATE timestamp(6) 11,6  √  null
ACCESS_GRACE_PERIOD number 22 15
VISIBLE_IN_SEARCH varchar2 10  √  'true'
INCLUDE_IN_TIME_TRACKING varchar2 5  √  'true'
AUTO_EXPAND varchar2 10  √  null

Table contained 2,434 rows at Sun Nov 29 01:06 IST 2020

Indexes:
Column(s) Type Sort Constraint Name Anomalies
APPLICATION_NAME Must be unique Asc SYS_C009986 This unique column is also nullable
APPLICATION_ID + APPLICATION_NAME Performance Asc/Asc T_GPS_APPLICATIONS_INDEX  
VISIBLE_FLAG Performance Asc T_GPS_APPLICATIONS_VIS_CN1  

Close relationships  within of separation: