SchemaSpy Analysis of HLPDTEST.PDA Generated by
SchemaSpy
Generated by SchemaSpy on Sun Oct 20 01:44 IST 2019
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
PDA_SUMMARY_V 3 view
PLAN_TABLE 35 0
T_ALERT_CONDITIONS 1 7 100
T_ALERTCONTACT_INFO 2 11 13
T_CAPACITY_CONSUMPTION_API 1 8 0
T_CAPACITY_CONSUMPTION_PERC_V 10 view
T_DQD_DAILY_MV 26 7,399,765
T_DQD_EXEC_DAILY_MV 4 93,127
T_DQD_MONTHLY_MV 22 324,792
T_DQD_WEEKLY_MV 22 1,356,768
T_DQI_MAIL_SETUP 10 8
T_DQI_RESULT_SETUP 1 6 3
T_FORECAST_REVENUE_API 1 8 0
T_GENERIC_SCHEDULES 6 2
T_GNG_AVAILABLE_ITEMS_LIST_V 7 view
T_GNG_EXECUTION_LIST 6 1 6 0
T_GNG_FINAL_ITEMS_LIST_V 8 view
T_GNG_ITEM_COMPONENTS 2 11 0
T_GNG_ITEMS_LIST 1 1 10 0
T_GNG_MANUALLY_INCLUDED_COMPS 1 9 0
T_GNG_SETUP 1 3 24 1
T_ITEM_REVENUE_PERC_V 12 view
T_ITEM_REVENUE_V 9 view
T_KQI_AREA_ASPECTS_V 17 view
T_KQI_CHARACTERISTICS 24 5 63 108
T_KQI_CRON_SCHEDULES 1 7 146
T_KQI_REPEAT_SCHEDULES 1 5 9
T_LATEST_MSD_GNG_V 34 view
T_MSD_API 33 0
T_MSD_KQI_PLAN_RESULT 7 0
T_NON_CONDITIONAL_CONTACTS 1 10 173
T_ORDER_REVENUE_API 1 8 0
T_PDA_COLUMN_MAPPING 4 16
T_PDA_CONDITIONALALERTS 3 35,254
T_PDA_CONDITIONALALERTS_TEMP 1 4 0
T_PDA_CONDITIONALALERTS_V 8 view
T_PDA_CONTACTS_MAIL_CONFIG 1 5 2,705
T_PDA_ERROR_INFO 4 0
T_PDA_EXECUTION_STATUS 1 5 115
T_PDA_GNG_FINAL_LIST 9 0
T_PDA_GNG_ITEMS_API 5 0
T_PDA_GRAPH_EVENTS_ORDER 2 10
T_PDA_HEADER 2 3 15
T_PDA_HEADER_DETAIL 2 7 19
T_PDA_HEADER_LOV 1 6 8
T_PDA_HOLIDAYS 6 126
T_PDA_INF_AL_DASHBOARD_V 3 view
T_PDA_INF_EXECUTION_RESULT 1 17 0
T_PDA_INF_EXTRACT 1 20 0
T_PDA_INF_GNG_DASHBOARD_V 3 view
T_PDA_ITEM_OVERRIDE 1 6 0
T_PDA_KQI_AREAS 5 8
T_PDA_KQI_ASPECTS 4 4
T_PDA_KQI_COLOR_CONFIG 7 0
T_PDA_KQI_EXECUTION_INFO 8 252,293
T_PDA_KQI_EXTRACT 1 26 82,444,955
T_PDA_KQI_EXTRACT_HISTORY 1 26 47,795,246
T_PDA_KQI_EXTRACT_TEMP 1 20 0
T_PDA_KQI_OVERRIDE 1 5 0
T_PDA_KQI_RESULT 1 18 84
T_PDA_KQI_RESULT_BACK 18 27
T_PDA_KQI_RESULT_HISTORY 1 18 172,086
T_PDA_KQI_RESULT_HISTORY_BACK 18 1,803
T_PDA_KQI_RESULT_V 25 view
T_PDA_KQIAREAS 7 0
T_PDA_OVERRIDEREASON_CODE 1 3 3
T_PDA_PER_GRAPH_TEMP 5 20
T_PDA_PERFORMANCE_EXTRACT 1 13 0
T_PDA_PF_ATTRIBUTES_SOURCES 7 4
T_PDA_PF_KQI_CONDITIONS 1 7 0
T_PDA_PF_KQI_CONDITIONS_GROUP 1 1 5 0
T_PDA_RELIABILITY_TOL_DETAILS 11 1
T_PDA_RESULT_COLOR_CONFIG 7 4
T_PDA_ROLES_INFO 8 7
T_PDA_SANITY_CHECK_TEMP1 8 8
T_PDA_SCHEDULES 1 8 204
T_PDA_SETUP 3 24
T_PDA_SQL_QUERIES 6 0
T_PDA_TEMPLATES 1 11 751
T_PDA_XREF_TEMPLATE_KQI 1 3 738
T_SURVEY_FEEDBACK 6 17
T_SURVEY_UNSUBSCRIBE_CONTACTS 3 0
T_TOLERANCE_DETAILS 2 12 119
T_UOM_DETAILS 9 3 17
T_XREF_ALERTCONDITION_KQI 2 1 2 54
           
73 Tables     775 139,881,760  
12 Views     139