SchemaSpy Analysis of HLPDTEST.STATEGPS Generated by
SchemaSpy
Generated by SchemaSpy on Sun Nov 29 01:06 IST 2020
Database Type: Oracle - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SourceForge.net

XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
ADFTESTINGTABLE 18 12
ALLOWED_HOSTS_FOR_SSO_API 2 1
AUTONUMBER_NODETYPE_VIEW 2 view
BP_BUSINESS_WORKFLOW_JDDT 3 view
BP_BUSINESS_WORKFLOW_NON_JDDT 3 view
BP_REPORT_WORKFLOW_JDDT 2 view
BP_REPORT_WORKFLOW_NON_JDDT 2 view
BP_SYSTEM_WORKFLOW_JDDT 2 view
BP_SYSTEM_WORKFLOW_NON_JDDT 2 view
BPM_MODELS_REPORT_V 5 view
BPM_TO_BPM_MAPPING 8 0
BSM_LABEL_VALUE_SETS_FLAG 3 0
CH 5 28
CHILD_STATE_DETAILS_V 3 view
COMPELTED_MIGRATIONS 7 view
CUMULATIVE_ISSUE_OPEN_CLOSED 6 view
EIS_USER_PROJECT_V 2 view
EMA 5 2
EWKS_WIZARD_LIMITATIONS 3 2
FORA 4 0
FREQUENTLY_ACCESSED_PROJECTS_V 4 view
GPS_EWKS_NODE_PROPS_CONFIG_V 19 view
GPS_EWKS_NODE_PROPS_VW 17 view
GPS_EWKS_NODE_ROLES_V 8 view
GPS_NODE_PORPS_CONFIG_V 27 view
GPS_NODE_PROPS_VW 23 view
GRAPHTESTINGDATA 11 30,000
HALFDAYVACATION 2 view
IDSLIST 1 3
IDSLIST1 1 4
INC_CREATION_PATTERN_CONFIG 8 0
ISSUE_LINKED_TESTCASES_VW 3 view
ISSUE_MODULE_LINKED_TC_VW 3 view
ISSUE_PROJECT_LINKED_TC_VW 3 view
ISSUE_TESTCASE_VW 4 view
LAST_YEAR_RES_UTILIZATION_V 8 view
LEAVE_TYPE_LIST 1 6
LEAVECONFIRMATIONVIEW 2 view
MIG_COMPLETED_VS_DUE_DATE_V 18 view
MIG_REQUESTS_V 18 view
MIGRATED_OBJECTS_V 15 view
MV_DAILY_TICKET_OPEN_CLOSED 6 66,112
MV_DATEWISE_TASKCOUNT 7 499,776
MV_KQIVSRESOURCE 4 268,306
MV_MONTHLY_TICKET_OPEN_CLOSED 6 22,326
MV_MONTHWISE_TASKCOUNT 7 211,966
MV_RESOURCE_PERFORMANCE 17 22,204
MV_RESOURCE_PERFORMANCE_MATRIX 11 301,301
MV_WEEKLY_TICKET_OPEN_CLOSED 6 41,924
MV_WEEKWISE_TASKCOUNT 7 359,427
MY_FOLLOW_UP_V 19 view
MYVIEW 42 view
OBJECT_VIEWER_V 6 view
PCOLL_CONTROL 4 0
PLAN_TABLE 27 0
PROJECT_CREATION_STATS_V 19 view
PROJECT_LINKED_TESTCASES_VW 3 view
PROJECT_NATIVE_TASKS_V 13 view
PROJECT_TASK_AUDIT_V 20 view
PRS_DEPT 3 1
PRS_EMP 4 1
PS_TXN 5 3
RAJINI 5 0
RECENTLY_ACCESSED_EWKS_V 8 view
RECENTLY_ACCESSED_FUNCTIONS_V 6 view
RECENTLY_ACCESSED_OBJECTS_V 11 view
RECENTLY_ACCESSED_PROJECTS_V 4 view
RECENTLY_ACCESSED_WF_V 7 view
RESOURCE_PERFORMANCE_V 5 view
SAMPLE1 6 0
SAMPLE2 5 0
SAMPLE_VIEWER_AUDITTRAIL_INFO 5 view
T_ALL_BPM_LATEST_VER_MODELS_V 23 view
T_APP_GROUPS 2 3 1,127
T_APP_MAIL_SETUP_V 6 view
T_APP_NODETYPES_RELATIONSHIP 2 5 7
T_APP_NT_PARENT_RELATIONSHIP 1 3 9 5
T_APP_ROOT_NODETYPES 3 6 3
T_APPRAISAL_STATUS_V 19 view
T_BPM_APR_DOC_HISTORY 2 3 31
T_BPM_APR_DOCUMENTS 1 2 7 26
T_BPM_APR_REQUESTS 2 11 238
T_BPM_APR_UPDATE_HISTORY 1 1 4 277
T_BPM_APR_WF_AUDIT 4 10 806
T_BPM_MODEL_NODE_PROPS_PIVOT_V 41 view
T_BPM_PUBLISHED_MODEL_VERSIONS 1 3 186
T_CASE_PREDECESSOR 3 0
T_CATEGORIES 7 6 287
T_CATEGORIES_V 3 view
T_CHANGE_MANAGEMENT_PROCESS 9 7 0
T_CHILD_CATEGORIES 2 2 274
T_CM_AFTER_ACTION_REVIEW 1 3 0
T_CM_AUDIENCE_INFO 1 1 4 0
T_CM_COMMUNICATION_PLAN 1 6 0
T_CM_COMPLIANCE_AUDIT 1 2 0
T_CM_IDENTIFY_RC_PR 1 5 0
T_CM_MANAGER_COACH_PLAN 1 4 0
T_CM_PROJECT_TEAM_INFO 1 4 0
T_CM_RESISTANCE_MGMT_PLAN 1 3 0
T_CM_SPONSOR_ROADMAP 1 6 0
T_CM_TRAINING_AUDIENCE_PLAN 1 9 0
T_CUSTOMER_REF 1 3 34,992
T_CUSTOMERS 2 8 4
T_DAILY_OPEN_CLOSED_ISSUES_V 6 view
T_DAILY_OPEN_CLOSED_TASKS_V 7 view
T_DB_POOL_CONTEXTS 1 5 6
T_DB_POOLS 1 15 5
T_DELETE_ROW_ACTION 1 1 3 3
T_DELETE_ROW_ACTION_UPDATE 1 6 5
T_DUE_TASKS_V 15 view
T_ETK_EXCEPTIONS 11 4,626,078
T_ETK_INSTANCES_INFO 10 0
T_ETK_ORAERROR_V 4 view
T_EXEPLAN_HISTORY 1 4 14,494
T_FAQ 1 6 0
T_FAQ_MODULE_SETUP 1 4 0
T_FDT_PARAMETER_WHERE_USED_V 19 view
T_FTP_ACCOUNTS 6 28
T_GOOGLE_MAP_ADDRESS_EXECUTION 6 0
T_GOOGLE_MAP_SEARCH_RESTRICT 3 0
T_GOOGLE_MAPS_GEOCODE_MAPPING 20 0
T_GPS_AD_CONFIG 1 5 0
T_GPS_ADF_EWKS_FEATURES 4 39
T_GPS_ADV_GRAPH_CONFIG_VALUES 3 81
T_GPS_ALL_OBJECTS 1 4 695
T_GPS_ALTERNATE_NODES 2 2 0
T_GPS_APP_FDTS 1 1 4 175
T_GPS_APP_FDTS_PARAMETERS 1 1 3 0
T_GPS_APP_FDTS_PARAMHASH 1 4 0
T_GPS_APP_MODEL_VALID_RULES 1 1 3 0
T_GPS_APP_PROPERTIES 1 1 4 14,534
T_GPS_APP_TOKEN_INFO 1 4 28
T_GPS_APP_VIEW 3 view
T_GPS_APP_WORKFLOW_STATES_VIEW 8 view
T_GPS_APP_WORKFLOW_VIEW 5 view
T_GPS_APPLICATION_NODE_TYPES 10 view
T_GPS_APPLICATIONS 42 27 2,434
T_GPS_APPLICATIONS_BACKUP 17 1,556
T_GPS_APPLICATIONS_MATRIX_V 10 view
T_GPS_AUTH_SYS_CONFIG 1 5 1
T_GPS_AUTONUMBERS 17 150
T_GPS_CALENDER_DATES 9 10,956
T_GPS_CHILD_NODES 2 2 56
T_GPS_CLASS_RELATIONS 3 3 3,049,124
T_GPS_CLASS_TABGROUP_CHILDS 1 4 34,107
T_GPS_CLASS_TABGROUPS 2 1 7 41,915
T_GPS_CM_PT_CLASS_PROPS 1 8 2
T_GPS_COM_PATH_CLASSES 1 1 4 24
T_GPS_COMPRESSED_PATH_PROPS 2 6 0
T_GPS_COMPRESSED_PATHS 1 1 6 1
T_GPS_COND_ST_CHANGE_PROPS 1 7 2,900
T_GPS_COND_ST_CHANGE_SETS 1 1 8 2,451
T_GPS_COND_STAT_TRACK_SETS 1 6 546,578
T_GPS_CONDITIONAL_STATE_CHANGE 2 3 5 765
T_GPS_CONDITIONAL_STATE_TRACK 1 3 8 274,102
T_GPS_CONNECTOR_ELBOWPOINTS 1 4 118,093
T_GPS_CUSTOM_SETS 3 2 19 791
T_GPS_CUSTOM_SETS_BKP 16 527
T_GPS_DATA_HANDLER 3 4,784
T_GPS_DBV_USER_APPLICATIONS 2 3 42
T_GPS_DBV_USERS 3 2 643
T_GPS_DEPLOYMENT_SIZE 5 293
T_GPS_DRILL_DOWN_CONDITION 1 6 1,555
T_GPS_DRILL_DOWN_PROPERTIES 4 1 10 8,128
T_GPS_EMAIL_CONTACT 15 0
T_GPS_ETKERRORMESSAGES 4 0
T_GPS_EWKS_WF_INSTANCE_MAPPING 1 4 12
T_GPS_EXCELDI_WORKBOOK_CONF 12 1,436
T_GPS_EXCEPTIONS 6 1,312,210
T_GPS_EXCEPTIONS_MV 5 8,278
T_GPS_EXCLUSIVE_SETS 1 1 4 740
T_GPS_FAVOURITE_LINKS 2 8 44,933
T_GPS_FAVOURITES_HISTORY 2 6 721,657
T_GPS_GETCONTROLLER_FDT 3 6 176
T_GPS_GOOGLE_MAP_SETUP 1 24 0
T_GPS_GRAPH_COLOR_CONDITIONS 1 6 11
T_GPS_IF_CHANGED_PROPERTY 1 3 13,894
T_GPS_INBOX_LABELS_CONFIG 6 8
T_GPS_INDENTED_MODELS_V 22 view
T_GPS_INSTANCE_ACTIVE_TRACKING 2 7 2,445
T_GPS_INSTANCE_FEEDBACK 3 8 35,043
T_GPS_INSTANCE_FEEDBACK_V 14 view
T_GPS_INSTANCE_LINKS 2 3 20,071
T_GPS_INSTANCE_MOVETO_TRACKING 3 7 18,847
T_GPS_INSTANCE_PROPERTIES 1 5 462,770
T_GPS_INSTANCES 2 4 20 1,006,526
T_GPS_JSP_AUDIT_DETAILS 4 3,142
T_GPS_KPI_PROPERTY_CONFIG 6 5,722
T_GPS_LOGLEVEL_AUDIT 6 128
T_GPS_MAIL_ATTACHMENT 1 4 134,458
T_GPS_MAIL_HISTORY 1 2 13 672,705
T_GPS_MAIL_SENT_MV 4 74,615
T_GPS_MAIL_SENT_V 4 view
T_GPS_MAILS_SENT 24 1,255,603
T_GPS_MASTER_MODELS 1 2 8 21,571
T_GPS_MASTER_MODELS_PROPERTIES 1 4 0
T_GPS_MENUCONFIG 4 2 14 154,418
T_GPS_MENUCONFIG_MODE 3 2 2
T_GPS_MENUCONFIG_RELATIONS 2 3 153,019
T_GPS_MODEL_NODE_PROPS_COMP_V 29 view
T_GPS_MODEL_PROPERTIES 1 4 33,005
T_GPS_MODEL_SEARCH_ATTRIBUTES 1 1 4 1
T_GPS_MODEL_SR_ATT_CLASS_PROPS 1 9 28
T_GPS_MODEL_SR_ATT_CLASSES 1 1 3 24
T_GPS_MODELS 7 2 11 51,738
T_GPS_MODELS_DELETE_TRACK 5 227
T_GPS_MODELS_HIERARCHY 17 view
T_GPS_MODELS_HIERARCHY_V 7 view
T_GPS_NEXT_NODES 2 2 1,006,578
T_GPS_NODE_CLASS_PROPERTIES 2 6 15,971,668
T_GPS_NODE_CLASSES 3 1 3 3,049,133
T_GPS_NODE_EDIT_CONDITIONS 1 8 5
T_GPS_NODE_FORMULA 1 1 5 2,174
T_GPS_NODE_MODEL_RELATIONS 2 3 14,218
T_GPS_NODE_RA_PROPERTIES 1 4 122,220
T_GPS_NODEGROUP_CHILDS 1 3 703
T_GPS_NODEGROUPS 1 2 4 95
T_GPS_NODENAME_ORDERS 1 3 21,076
T_GPS_NODES 19 1 8 2,037,905
T_GPS_NODETYPE_STATES 5 3 12 18,437
T_GPS_NODETYPES 10 14 278
T_GPS_NOTIFICATION_DETAILS 1 2 25 2,283
T_GPS_NT_ST_CLASS_PROPS 2 1 29 3,952,387
T_GPS_NT_STATE_CLASSES 3 1 4 417,339
T_GPS_OBJECT_REQUISITION 7 1,045
T_GPS_OBJECT_SUBSCRIPTIONS 2 8 3,459
T_GPS_OBJECTS_UNSUBSCRIBE_VW 7 view
T_GPS_OPERATION_ALGORITHM 1 4 988
T_GPS_OPERATION_ELBOWS 2 5 2,585
T_GPS_OPERATION_PROPERTIES 1 5 0
T_GPS_OPERATION_TO_STATES 2 2 20,163
T_GPS_PARENT_NODES 2 2 51
T_GPS_PASSWORD_CONFIGURATION 15 1
T_GPS_PATH 2 1 5 0
T_GPS_PATH_LEVEL_LEG 2 5 0
T_GPS_PHONE_CONTACT 13 0
T_GPS_POOLCONFIG_AUDIT_INFO 1 5 210
T_GPS_POOLCONFIG_AUDITTRIAL 1 4 42
T_GPS_POPULAR_V 6 view
T_GPS_PREVIOUS_NODES 2 2 1,006,603
T_GPS_PROJECT_SCENARIOS 2 5 0
T_GPS_PROPERTIES 4 545
T_GPS_PROPERTY_CHANGE_GROUPS 1 4 897
T_GPS_PROPERTY_CHANGE_SETS 2 1 6 757
T_GPS_PROPERTY_ORDER 1 3 405,380
T_GPS_QUERIES_AUDIT 4 700
T_GPS_QUERY_DEFAULT_VALUES 3 192
T_GPS_QUERY_EXECUTION_STATS 13 11,245
T_GPS_QUERY_EXECUTIONS 6 1,948,589
T_GPS_RELATION_CLASSES 1 1 3 470
T_GPS_RELATIONS 1 1 7 15
T_GPS_RLTION_CLASS_PROPS 1 3 321
T_GPS_ROLE_APP_OPERATIONS 2 3 177
T_GPS_ROLE_APPLICATIONS 7 2 4 3,170
T_GPS_ROLE_CATEGORIES 2 3 1,500
T_GPS_ROLE_CUSTOM_SETS 2 3 3,232
T_GPS_ROLE_LEVEL_EWKS_ACTIONS 2 21 16
T_GPS_ROLE_MENUCONFIG 3 4 146,113
T_GPS_ROLE_NODE_PROP_ACL 11 38
T_GPS_ROLE_NODETYPE_STATES 2 3 14,197
T_GPS_ROLE_NODETYPES 2 3 2,388
T_GPS_ROLE_OPERATIONS 2 3 16,940
T_GPS_ROLE_STATES 2 2 4 21,470
T_GPS_ROLE_VIEWER_INSTANCES 2 3 12,191
T_GPS_ROLE_VIEWER_SETS 1 2 3 1,923
T_GPS_ROLE_WORKFLOW_TYPES 1 2 3 7,066
T_GPS_ROLES 1 5 2,390
T_GPS_ROUTING_NOTIFICATION 1 7 595,885
T_GPS_SCHEMA_SIZE 5 2,480
T_GPS_SERVER_EXECUTION_STATS 10 2,845,204
T_GPS_SERVER_MEMORY_STATUS 6 1,441
T_GPS_SERVER_RUN_STATUS 4 1,110
T_GPS_SERVER_RUN_STATUS_MV 3 101
T_GPS_SET_GROUPS 1 3 740
T_GPS_SHAREPOINT_INFO 2 7 0
T_GPS_SSO_CUSTOMLINKS 9 0
T_GPS_SSO_EWORKSHEETS 11 0
T_GPS_STATE_EDIT_OPERATIONS 1 2 0
T_GPS_STATE_EWORKSHEETS 1 1 10 8
T_GPS_STATE_OPERATIONS 11 2 23 19,761
T_GPS_TASK_RESOURCES 1 4 3,134
T_GPS_TOUR_COMPLETION_STATUS 3 411
T_GPS_USEFUL_LINKS 7 13
T_GPS_USER_APP_OPERATIONS 2 3 3,475
T_GPS_USER_APPLICATIONS 7 2 4 24,882
T_GPS_USER_CATEGORIES 2 3 30,851
T_GPS_USER_CUSTOM_SETS 2 3 65,756
T_GPS_USER_LOGIN_ANALYSIS 6 view
T_GPS_USER_MENUCONFIG 3 4 1,032,191
T_GPS_USER_NODETYPE_STATES 2 3 196,017
T_GPS_USER_NODETYPES 2 3 48,142
T_GPS_USER_OPERATIONS 2 3 239,331
T_GPS_USER_SEARCHED_TAGS 4 37,931
T_GPS_USER_STATES 2 2 3 235,883
T_GPS_USER_VIEWER_INSTANCES 2 4 265,621
T_GPS_USER_VIEWER_SETS 1 2 3 35,159
T_GPS_USER_WORKFLOW_TYPES 1 2 4 50,622
T_GPS_USERS 1 4 1,169
T_GPS_VDD_BUILDFR_MAPPINGS 1 6 64
T_GPS_VDD_COLUMNS_MAPPING 1 8 8,781
T_GPS_VDD_CUSTOMLINK_MAPPINGS 1 4 2,101
T_GPS_VIEW_CLASS_TABGRP_CHILDS 1 3 5,193
T_GPS_VIEWER_ADV_GRAPH_CONFIG 1 6 154
T_GPS_VIEWER_ADV_GRAPH_DATA 2 3 319
T_GPS_VIEWER_AUDITTRACK_FIELDS 3 4
T_GPS_VIEWER_AUDITTRAIL 1 5 794,259
T_GPS_VIEWER_AUDITTRAIL_INFO 1 6 111,641,476
T_GPS_VIEWER_CLASS_TABGROUPS 2 1 4 11,795
T_GPS_VIEWER_CONFIGURATION_V 29 view
T_GPS_VIEWER_DEFAULTCONDITIONS 1 6 0
T_GPS_VIEWER_DIMENSIONS 1 2 1
T_GPS_VIEWER_DRILL_DOWNS 1 4 5,210
T_GPS_VIEWER_EDIT_CONDITIONS 1 7 37,109
T_GPS_VIEWER_EDIT_CONFIG 1 1 3 35,585
T_GPS_VIEWER_FOOTER_CONDITION 1 14 0
T_GPS_VIEWER_FOOTER_CONFIG 1 1 9 0
T_GPS_VIEWER_GRAPH_DETAILS 3 1 14 3,454
T_GPS_VIEWER_GRAPH_DRILLDOWNS 1 10 131
T_GPS_VIEWER_INST_CLASS_PROPS 5 1 68 198,799
T_GPS_VIEWER_INSTANCES 15 1 80 6,798
T_GPS_VIEWER_INSTANCES_CLASSES 2 1 5 6,732
T_GPS_VIEWER_INSTANCES_SET 5 1 12 485
T_GPS_VIEWER_KPI_CONFIG 1 7 1,147
T_GPS_VIEWER_LOV_DEPENDONS 1 6 7,968
T_GPS_VIEWER_LOV_INFO 2 1 12 17,564
T_GPS_VIEWER_MAIL_CONFIG 1 16 525
T_GPS_VIEWER_MEASURES 1 4 4
T_GPS_VIEWER_MULTIPLE_LOV 1 7 11
T_GPS_VIEWER_PDF_FORMAT 1 14 0
T_GPS_VIEWER_PROPERTY_ORDER 2 5 112,416
T_GPS_VIEWER_PROPS_OPERATORS 1 3 584
T_GPS_VIEWER_SCHEDULE 13 88
T_GPS_WF_DIS_NOTIFICATIONS 1 9 34
T_GPS_WF_DISABLED_OPERATIONS 4 1 12 145
T_GPS_WF_INST_CLASS_PROPS 1 9 3,498
T_GPS_WF_INST_FAIL_REASONS 2 7 362,409
T_GPS_WF_INST_NAMEORDERS 1 3 2,775
T_GPS_WF_INSTANCE_CLASSES 1 1 3 6,476
T_GPS_WF_INSTANCE_HISTORY 14 82,017,536
T_GPS_WF_INSTANCE_HISTORY_V 17 view
T_GPS_WF_STATE_FEEDBACK_FORM 1 2 13 1,449
T_GPS_WFMOVE_STATEOPERATIONS 3 6 585
T_GPS_WFT_PROPERTIES 1 3 2,059
T_GPS_WORKFLOW_INSTANCES 2 2 8 1,357
T_GPS_WORKFLOW_SOD_ASSIGNMENTS 2 5 231
T_GPS_WORKFLOW_STATE_PROP 1 4 1,281
T_GPS_WORKFLOW_STATES 35 1 32 23,151
T_GPS_WORKFLOW_TYPES 19 2 25 4,235
T_GPS_WORKFLOWMOVE_STATE 2 1 6 477
T_GPS_WORKFLOWMOVE_STATE_PROPS 1 5 1,534
T_GV_CONDITIONAL_CONFIG 4 455
T_GV_DEFAULT_REPORT_INFO 1 4 640
T_GV_EDIT_DATA_VALIDATIONS 1 7 1,848
T_GV_OLAP_CONFIGURATION 1 7 453
T_GV_TRANSIENT_FIELD_INFO 1 6 2
T_HTML_NODE_PROPSHEET_VERSION 1 8 416
T_INSTANCE_CHILD_DOCS 1 6 38
T_INSTANCE_DOCUMENTS 1 3 14,608
T_INSTANCE_DOCUMENTS_V 6 view
T_INSTANCE_OWNER_V 4 view
T_INSTANCE_PREDECESSOR 3 4 798
T_INSTANCES 22 1 14 184,734
T_ISSUE_TYPES 1 2 8
T_ISSUES_CREATED_BY_ME_V 38 view
T_MESSAGES 8 0
T_MIG_INSTANCE_CONTEXT_DETAILS 4 0
T_MIG_SP_EXECUTION_DETAILS 13 44
T_MOBILE_MODULES 1 8 32
T_MOBILE_MODULES_BKP 8 32
T_MOBILE_WIDGETS 1 7 9
T_MONTHLY_OPEN_CLOSED_ISSUES_V 6 view
T_MONTHLY_OPEN_CLOSED_TASKS_V 8 view
T_OPEN_ISSUES_PER_PRIORITY_V 5 view
T_PLANNED_ACCOMPLISHED 2 7 266
T_PROCESS_SLAS 2 9 12
T_PRODUCTS_SUMMARY_V 7 view
T_PROJECT_ACTIVITY 1 11 388,868
T_PROJECT_BFR_USAGE_THRESHOLD 1 7 66
T_PROJECT_BUFFER 1 3 21
T_PROJECT_CRITICAL_TASKS_V 19 view
T_PROJECT_CURRENT_PLAN_TASKS_V 17 view
T_PROJECT_CURRENT_PLAN_V 13 view
T_PROJECT_CUSTOM_PRIORITY 5 4
T_PROJECT_CVS_MODULE 7 7
T_PROJECT_DA_V 3 view
T_PROJECT_DETAILS 2 1 25 1,000
T_PROJECT_DETAILS_HISTORY 1 17 214
T_PROJECT_DUE_DATES_V 12 view
T_PROJECT_HOURS_V 4 view
T_PROJECT_ISSUE_TYPES 1 2 8
T_PROJECT_ISSUES_STATUS_V 15 view
T_PROJECT_NATIVE_TASK_V 13 view
T_PROJECT_OPEN_ISSUES_STATUS_V 4 view
T_PROJECT_PLAN_REMOVED_TASKS_V 14 view
T_PROJECT_PLAN_TASKS_V 18 view
T_PROJECT_RESOURCE_RATES 1 5 5
T_PROJECT_ROLE_USERS 1 5 500
T_PROJECT_ROLES 2 3 3
T_PROJECT_SLAS 1 1 10 0
T_PROJECT_SLAS_ESCALATIONS 1 6 0
T_PROJECT_SLAS_MV 16 6,544
T_PROJECT_TASK 10 2 39 634,059
T_PROJECT_TASK_HISTORY 1 14 1,076,525
T_PROJECT_TASK_V 62 view
T_PROJECTPLAN_CONFIG 10 1,071
T_PROMISED_DUEDATE_HISTORY 1 7 153,208
T_REPORTING_PLAN_HISTORY 4 1 13 19,300
T_REPORTING_PLAN_TASK_DETAIL1 5 20 0
T_REPORTING_PLAN_TASK_DETAILS 6 21 1,726,333
T_REPORTING_PLAN_TASKS 2 15 8,543,312
T_REPORTING_PLAN_TASKS_V 12 view
T_RESOURCE_USAGE 2 6 10,789
T_RFC_SUMMARY_V 7 view
T_ROOT_CAUSES 2 7
T_SCENARIO_PROPERTIES 1 4 155,054
T_SCRIPT_REPLAY_RESULTS 2 16 24
T_SFDC_CONNECTIONS 7 3
T_SLA_ESCALATION_V 5 view
T_SLA_RESOLUTION_VIOLATION_V 12 view
T_SLA_VIOLATION_V 13 view
T_SP_EXECUTION_DETAILS 2 10 2
T_SP_EXECUTION_OBJECT_DETAILS 1 12 2
T_SP_EXECUTION_PROP_DETAILS 1 9 0
T_SQL_ERRORS 3 4
T_STARTED_TASKS_V 62 view
T_SUPPORT_INVOICE_SCHEDULES 2 14 127
T_SUPPORT_TYPE 1 5 1
T_SURVEY_DETAILS 1 1 6 6,093
T_SURVEY_RESPONSES 1 2 8 4,112
T_SURVEYS 3 1 9 1,003
T_TAS_SOD_STATES 1 2 8 1
T_TASK_ACTION_ITEMS 1 4 0
T_TASK_ACTION_ITEMS_SEQ_TABLE 1 1
T_TASK_MANAGER_COMMENT 1 9 812,926
T_TASK_PREDECESSOR 2 3 7,936
T_TASK_PREDECESSOR_EXISTS_V 2 view
T_TASK_PRIORITY_V 4 view
T_TASK_SLAS 1 8 4
T_TASK_SLAS_MV 17 480
T_TEXT2SPEECH_SETTINGS 4 2
T_TICKET_CREATION_CONFIG 5 1
T_TICKET_DETAILS_V 24 view
T_TIME_TRACKING_DETAILS_V 16 view
T_TIME_TRACKING_V 17 view
T_TRADING_PARTY 3 1 19 123
T_TRADING_PARTY_PROJ_RESOURCES 3 378
T_TRADING_PARTY_PROJECTS 2 3 915
T_TRADING_PARTY_RESOURCES 2 3 854
T_TRI2_PROJECT_MODULES 2 3 50,740
T_TRI2_PRS2WF_NODE_MAPPING 2 3 6
T_TRI2_WORKFLOW_MODULE 2 7 12
T_USER_ROLES_APPLICATIONS_V 7 view
T_USERS_V 2 view
T_VALUE_SETS_HISTORY_SET 1 4 0
T_VIEWER_PROPERTY_CONDITIONS 11 11,137
T_WEBSERVICE_CONNECTIONS 6 15
T_WEBSERVICE_LOGIN_PARAMS 6 94
T_WEEKLY_OPEN_CLOSED_ISSUES_V 6 view
T_WEEKLY_OPEN_CLOSED_TASKS_V 7 view
T_WIDGETS_ASSIGNMENT_VW 15 view
T_WORKFLOW_PREDECESSOR 2 3 5
T_WORKFLOW_STATE_TASK_V 2 view
T_WORKING_TIME 1 10 47
TC_LABEL_VALUE_SETS_HISTORY 1 8 0
TC_LABEL_VALUE_SETS_RESULT_LOG 10 0
TEST_CASE_STEP_LOG_VW 54 view
TEST_TIME_TRACKING_V_7292 13 view
TESTING 2 3
TESTING_TIMEAXIS 5 2
TICKET_TASKS_V 19 view
UNIQUETABLE 4 0
USER_ACCESSED_SUMMARY_TREND_MV 3 12,733
V_ACTUAL_HOURS 2 view
V_COMMENTS 2 view
V_CURRENT_MONTH_TIMESHEET 12 view
V_CURRENT_WEEK_TIMESHEET 12 view
V_INSTANCE_PROPS 4 view
V_MANAGER_COMMENTS 2 view
V_MONTHLY_PROJECT_STATISTICS 4 view
V_NATIVE_TASK_COMMENTS 2 view
V_NATIVE_TASK_MANAGER_COMMENTS 2 view
V_PA_SUMMARY 2 view
V_PEREGRINE_RESOURCE_LOAD 10 view
V_PROJECT_RESOURCE_TIMESHEET 9 view
V_RESOURCE_TASK_SUMMARY 5 view
V_RESOURCE_WORK_SUMMARY 4 view
V_TASKS_WHITEBOARD 24 view
VR_SCHEDULE_V 14 view
WEEKLY_OPEN_CLOSE_MIGRATIONS_V 4 view
WHERETABLE 6 0
WORKFLOW_STATES_INSTANCES_MV 4 426
XXCAVIUM_SUPPORT_DAILY_OPEN 3 view
XXCAVIUM_SUPPORT_DAILY_SUMMARY 11 view
XXPI_PO_ACK_UPDATE_STG 23 3
XXT_PROJECT_NAME_V 3 view
           
368 Tables     2,732 261,979,663  
127 Views     1,416