SchemaSpy Analysis of HLPDTEST.EIS Generated by
SchemaSpy
Generated by SchemaSpy on Sun Oct 20 01:35 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
DEPENDENTDETAILS 5 view
EIS_ADMIN_VIEW 54 view
EIS_BANK_DETAILS 1 9 2,312
EIS_BRANCH_DETAILS 1 2 16 4
EIS_CONSULTANT_INFO 9 866
EIS_CUSTOMER_MAIL_ALERT 12 19 16
EIS_CUSTOMER_MAILING_DETAILS 5 138
EIS_DESIGNATION_LOV 1 2 80
EIS_EMP_PREVIOUS_EXPERIENCE_V 2 view
EIS_EMP_TOTAL_EXPERIENCE_V 2 view
EIS_EMP_TRINITI_EXPERIENCE_V 2 view
EIS_EMPLOYEE 41 3 62 866
EIS_EMPLOYEE_ACCESSORIES 1 8 0
EIS_EMPLOYEE_ATTRITION_RATE_V 5 view
EIS_EMPLOYEE_BASIC_INFO_V 46 view
EIS_EMPLOYEE_CARD_DETAILS 1 8 0
EIS_EMPLOYEE_CERTIFICATION 6 121
EIS_EMPLOYEE_DEPENDENT_BKP 6 7
EIS_EMPLOYEE_DEPENDENTDETAILS 1 7 645
EIS_EMPLOYEE_EXPERIENCE 1 12 248
EIS_EMPLOYEE_IT_DETAILS 16 460
EIS_EMPLOYEE_LEAVE_MASTER 9 514
EIS_EMPLOYEE_LEAVE_MESSAGES 3 80
EIS_EMPLOYEE_LEAVES_DETAILS 1 23 26,841
EIS_EMPLOYEE_PAYROLL 1 27 0
EIS_EMPLOYEE_QUALIFICATION 1 6 319
EIS_EMPLOYEE_RESIGN 38 282
EIS_EMPLOYEE_SKILLSET 2 6 2,014
EIS_EMPLOYEE_TRAINING 1 6 0
EIS_EXTENDED_TRAINEE_DETAILS 5 0
EIS_EXTRA_CURRICULAR_INTERSTS 1 3 14
EIS_FORTIS_MEDICAL_DETAILS 1 13 0
EIS_GROUP_LOV 2 12
EIS_HARDWARE_DETAILS 1 21 0
EIS_INDUSTRY_GROUP 2 13
EIS_INSURING_COMPANY 10 1
EIS_LEAVE_MAILING_LIST 5 0
EIS_LEAVE_NOTIFICATION 6 0
EIS_LEAVE_OPERATION_LIST 3 2
EIS_LEAVES_HEADER 3 1
EIS_LEVEL1_SOFTSKILL_RATING 1 8 93
EIS_LOGIN 4 610
EIS_MEDICAL_INSURANCE 1 9 364
EIS_PASSPORT_DETAILS 1 6 413
EIS_PPR_DATA 1 5 658
EIS_PROBATION 1 2 18 9
EIS_PROBATION_EVAL 4 11 80
EIS_PROBATION_EVAL_CRITERIA 1 8 8
EIS_PROBATION_EVAL_DATE_V 3 view
EIS_PROBATION_EVAL_RATING 2 9 6
EIS_REPORTING_STRUCTURE 4 848
EIS_SALARY_DETAILS 16 0
EIS_SKILLSET 1 3 133
EIS_SOFTWARE_DETAILS 10 0
EIS_TAS_USERS 33 598
EIS_TASKS_REASSIGNED_ON_LEAVE 1 3 94
EIS_TIMEZONES 1 5 0
EIS_TRAINEE_DETAILS 8 175
EIS_VEHICLE_DETAILS 1 4 78
EIS_VISA_DETAILS 1 10 38
EMP_REPORTEE_USERNAMES 2 view
EMPLOYEE_ID_LINK 2 2 1
EMPLOYEEREPORT 16 view
EMPLOYEEVIEW 28 view
GET_PREVIOUS_DATE_DIFFRENCE_V 4 view
GET_TRINITI_DATE_DIFFRENCE_V 4 view
PASSPORTDETAILS 7 view
PERSONALINFORMATION 11 view
PLAN_TABLE 27 0
PRESENTADDRESS 8 view
PS_TXN 5 422
RMS_DATE 1 93
RMS_MODULE 14 0
RMS_PROJECT 13 1
RMS_RESOURCE 11 0
RMS_RESOURCE_DAILY_INFO 9 0
SYSDATE_V 1 view
T_APPRAISAL_AREAS 1 1 6 17
T_APPRAISAL_PERIOD 3 1 6 19
T_APPRAISAL_QUALITIES 2 1 7 101
T_APPRAISAL_SUB_AREAS 1 1 3 26
T_DEPARTMENTS 2 2 7
T_EMP_APPRAISAL_PROPERTIES 1 4 3,300
T_EMP_APPRAISAL_SUMMARY_V 14 view
T_EMPLOYEE_APPRAISAL_DETAILS 3 11 50,760
T_EMPLOYEE_APPRAISALS 2 4 6 1,650
T_JOB_APPLICANTS_STAGE 7 579
T_LEAVE_TYPE 6 6
T_ORA_FUSION_CLOUD_ENVS 1 6 13
T_PERIOD_QUALITY_BENCHMARK 1 2 4 582
T_USA_EMP_ACCURED_SUMMARY 1 5 2,840
T_USA_EMP_UNREAD_PROJECT_TIME 7 view
USA_HTP_APPR_DETAILS 7 2,344
V_HOLIDAY_NOTIFICATION_TEMP 11 view
           
74 Tables     712 102,822  
20 Views     232