SchemaSpy Analysis of HLPDTEST.EMSPROD Generated by
SchemaSpy
Generated by SchemaSpy on Sun Aug 18 01:34 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
BANK_DETAILS 7 174
BANK_TABLE 7 176
BILLABLE_ITEMS_V 10 view
CURRENCY_START_END_DATE_V 2 view
EAAD_CATEGORY_DETAILS 7 717
EAAD_COMMENTS 17 1,282
EAAD_COMMENTS_SUMMARY 8 1
EAAD_COMPETENCY_NAME 3 4
EAAD_EXPECTATION_NAME 4 11
EAAD_PERF_DETAIL_EMAIL 7 0
EAAD_PERF_DETAIL_MANAGER 8 11
EAAD_PERF_DETAIL_OTHER 6 0
EAAD_PERFORMANCE_DETAIL_SELF 8 22
EAAD_PRO_REPORT_STRUCTURE 8 0
EAAD_READFORVIEW_STATUS 3 0
EAAD_READYFORREVIEW_STATUS 2 2
EAAD_REMUNERATION 13 1
EAAD_REMUNERATION_COMMENTS 8 0
EAAD_REMUNERATION_ENCRYPTION 13 222
EAAD_REPORTING_STRUCTURE 8 131
EAAD_ROLE_GOAL 3 121
EAAD_TRAINING_DETAILS 8 1
EAAD_TRAINING_GROUP 3 33
EAAD_TRAINING_MODULE 3 33
EIS_ATENA_MEDICAL_DETAILS 13 0
EIS_BANK_DETAILS 8 297
EIS_BRANCH_DETAILS 10 3
EIS_CAT_LOV 4 37
EIS_COMMENTS 8 71
EIS_CONS_PERFORM_RATING 13 237
EIS_CONS_RESPONSIBILITY 5 184
EIS_CONS_SKILL_RATING 7 2,728
EIS_CONS_TRAINING 7 78
EIS_CONSULTANT_INFO 9 228
EIS_CONSULTANT_TARGET 10 126
EIS_COUNTRIES 2 2
EIS_DESIGNATION_LOV 4 64
EIS_EAAD_REVISIONS 2 2
EIS_EMPLOYEE 51 820
EIS_EMPLOYEE_COMPENSATION 13 4
EIS_FORTIS_MEDICAL_DETAILS 13 0
EIS_GROUP_LOV 2 12
EIS_INDUSTRY_GROUP 2 8
EIS_INSURANCE_DETAILS 11 0
EIS_INSURING_COMPANY 10 1
EIS_LEAVE_DETAILS 3 0
EIS_LOGIN 7 817
EIS_MEDICAL_DETAILS 5 0
EIS_MEDICAL_INSURANCE 8 310
EIS_MEDICAL_LOV 2 0
EIS_NATIONALITY_LOV 3 2
EIS_PASSPORT_DETAILS 5 214
EIS_REPORTING_STRUCTURE 4 237
EIS_STATES 3 4
EIS_VISA_DETAILS 6 214
EMS_ACCESS_LEVEL 8 17,727
EMS_ADVANCE 1 11 85
EMS_CURRENCY_CONV_SUMMARY 7 view
EMS_CURRENCY_CONVERSION 3 9 187,034
EMS_CURRENCY_VIEW 7 view
EMS_EXPENCES_V 15 view
EMS_EXPENCES_V_REV1 14 view
EMS_EXPENSES 2 23 417,278
EMS_EXPENSES_DATES 3 3,499
EMS_EXPENSES_HISTORY 1 8 420,363
EMS_HISTORY 3 5 398
EMS_INVOICE 7 0
EMS_INVOICE_DOCS 8 32
EMS_INVOICEREPORT 12 view
EMS_ITEM 1 1 13 119
EMS_ITEM_TYPE 1 4 3
EMS_LATE_SUBMISSION_COUNTER 4 4,298
EMS_LOCATION_CURR 3 6 15
EMS_LOCATION_CURR_V 6 view
EMS_LOV_TYPE 7 12
EMS_LOV_VALUE 7 67
EMS_MANAGER_ADVANCE 11 5
EMS_MANAGER_PREFERENCE 2 8 0
EMS_MYAPPROVALS_V 22 view
EMS_PAYABLES_QB_REPORT_V 4 view
EMS_PERIOD_SUMMARY 1 4 8,099
EMS_PROJECT 2 13 999
EMS_QB_ACCOUNTS 1 1 2 39
EMS_QB_PROJECTS 1 7 90
EMS_QB_SERVICENAME 1 7 127
EMS_UPLOADED_EXPENSES 10 0
EMS_USER_PREFERENCE 8 76,723
EMS_USER_PREFERENCE_TEMP 8 22,813
EMSREPORT 12 view
EMSREPORTFORTMONTHWISE 12 view
EUL4_ACCESS_PRIVS 4 13 23
EUL4_APP_PARAMS 1 12 15
EUL4_ASM_POLICIES 3 12 0
EUL4_ASMP_CONS 4 13 0
EUL4_ASMP_LOGS 2 11 0
EUL4_BA_OBJ_LINKS 2 10 0
EUL4_BAS 3 13 0
EUL4_BATCH_PARAMS 1 15 0
EUL4_BATCH_QUERIES 3 1 13 0
EUL4_BATCH_REPORTS 2 2 19 0
EUL4_BATCH_SHEETS 2 1 10 0
EUL4_BQ_DEPS 4 12 0
EUL4_BQ_TABLES 2 10 0
EUL4_BR_RUNS 1 1 14 0
EUL4_DBH_NODES 2 1 15 4
EUL4_DOCUMENTS 3 1 17 0
EUL4_DOMAINS 1 2 20 0
EUL4_ELEM_XREFS 6 0
EUL4_EUL_USERS 5 21 2
EUL4_EXP_DEPS 7 15 0
EUL4_EXPRESSIONS 18 8 44 0
EUL4_FREQ_UNITS 2 10 6
EUL4_FUN_ARGUMENTS 1 18 268
EUL4_FUN_CTGS 1 14 10
EUL4_FUN_FC_LINKS 2 9 213
EUL4_FUNCTIONS 9 24 222
EUL4_GATEWAYS 15 2
EUL4_HI_NODES 3 1 14 0
EUL4_HI_SEGMENTS 1 6 14 3
EUL4_HIERARCHIES 5 1 17 1
EUL4_IG_EXP_LINKS 4 13 0
EUL4_IHS_FK_LINKS 2 9 0
EUL4_KEY_CONS 6 3 22 0
EUL4_NAMED_ELEMS 15 view
EUL4_OBJ_DEPS 2 9 0
EUL4_OBJ_JOIN_USGS 3 11 0
EUL4_OBJS 12 1 25 0
EUL4_ODBC_CATALOGS 1 view
EUL4_ODBC_SCHEMAS 1 view
EUL4_PLAN_TABLE 24 0
EUL4_QPP_STATS 47 0
EUL4_SEGMENTS 6 20 0
EUL4_SEQUENCES 3 1
EUL4_SQ_CRRLTNS 3 10 0
EUL4_SUB_QUERIES 2 3 15 0
EUL4_SUM_BITMAPS 3 12 0
EUL4_SUM_RFSH_SETS 1 2 22 0
EUL4_SUMMARY_OBJS 7 3 38 0
EUL4_SUMO_EXP_USGS 4 15 0
EUL4_VERSIONS 6 1
GLOBAL_LOCATION_CURRENCIES 5 71
INVOICE_PDF_GENERATION 7 view
LOV_TABLE 1 2 0
LOV_VALUE_TABLE 1 4 0
PLAN_TABLE 27 0
PS_TXN 5 16,062
SALKEY 1 1
T_EMS_EXPENSES_UPLOADED_BILLS 1 4 381
T_EMS_QB_ACCOUNTS 2 0
T_EMS_QB_CLASS 2 18
T_EMS_QB_DEPARTMENT 3 11
T_EMS_QB_ITEM 3 78
T_EMS_QB_LAST_UPDATED_DATE_V 3 view
T_EMS_QB_PROJECT 1 1 4 249
T_EMS_QB_SERVICENAME 1 1 7 683
T_INVOICE_BASE_GENERATION_V 8 view
T_INVOICE_INTEGRATION_QB 1 32 115
T_QB_CUSTOMERS_STAGE 10 249
T_QB_EMPLOYEES_STAGE 10 27
T_QB_SERVICES_STAGE 9 683
T_RESOURCE_WORKED_PERIODS 2 7 88
TASL_EXP 15 view
TIMEZONES 5 230
TIMEZONES_VIEW 2 162
           
145 Tables     1,500 1,189,346  
19 Views     173