|
HR |
||||||||||||
|
|
|||||||||||||
| Index | Type | Table |
|---|---|---|
| COUNTRY_C_ID_PK | IOT - TOP | COUNTRIES |
| DEPT_ID_PK | NORMAL | DEPARTMENTS |
| DEPT_LOCATION_IX | NORMAL | DEPARTMENTS |
| EMP_DEPARTMENT_IX | NORMAL | EMPLOYEES |
| EMP_EMAIL_UK | NORMAL | EMPLOYEES |
| EMP_EMP_ID_PK | NORMAL | EMPLOYEES |
| EMP_JOB_IX | NORMAL | EMPLOYEES |
| EMP_MANAGER_IX | NORMAL | EMPLOYEES |
| EMP_NAME_IX | NORMAL | EMPLOYEES |
| JHIST_DEPARTMENT_IX | NORMAL | JOB_HISTORY |
| JHIST_EMP_ID_ST_DATE_PK | NORMAL | JOB_HISTORY |
| JHIST_EMPLOYEE_IX | NORMAL | JOB_HISTORY |
| JHIST_JOB_IX | NORMAL | JOB_HISTORY |
| JOB_ID_PK | NORMAL | JOBS |
| LOC_CITY_IX | NORMAL | LOCATIONS |
| LOC_COUNTRY_IX | NORMAL | LOCATIONS |
| LOC_ID_PK | NORMAL | LOCATIONS |
| LOC_STATE_PROVINCE_IX | NORMAL | LOCATIONS |
| REG_ID_PK | NORMAL | REGIONS |