Overview Tables Views Indexes Constraints Triggers Procedures Functions Packages Sequences Index

HR


A C D E F H J L M P R S U 

A

ADD_JOB_HISTORY procedure

C

CITY column of table LOCATIONS
CITY column of view EMP_DETAILS_VIEW
COMMISSION_PCT column of table EMPLOYEES
COMMISSION_PCT column of view EMP_DETAILS_VIEW
COUNTR_REG_FK constraint of table COUNTRIES
COUNTRIES table
COUNTRY_C_ID_PK constraint of table COUNTRIES
COUNTRY_C_ID_PK index of table COUNTRIES
COUNTRY_ID column of table COUNTRIES
COUNTRY_ID column of table LOCATIONS
COUNTRY_ID column of view EMP_DETAILS_VIEW
COUNTRY_ID_NN constraint of table COUNTRIES
COUNTRY_NAME column of table COUNTRIES
COUNTRY_NAME column of view EMP_DETAILS_VIEW

D

DEPARTMENT_ID column of table DEPARTMENTS
DEPARTMENT_ID column of table EMPLOYEES
DEPARTMENT_ID column of table JOB_HISTORY
DEPARTMENT_ID column of view EMP_DETAILS_VIEW
DEPARTMENT_NAME column of table DEPARTMENTS
DEPARTMENT_NAME column of view EMP_DETAILS_VIEW
DEPARTMENTS table
DEPARTMENTS_SEQ sequence
DEPT_ID_PK constraint of table DEPARTMENTS
DEPT_ID_PK index of table DEPARTMENTS
DEPT_LOC_FK constraint of table DEPARTMENTS
DEPT_LOCATION_IX index of table DEPARTMENTS
DEPT_MGR_FK constraint of table DEPARTMENTS
DEPT_NAME_NN constraint of table DEPARTMENTS

E

EMAIL column of table EMPLOYEES
EMP_DEPARTMENT_IX index of table EMPLOYEES
EMP_DEPT_FK constraint of table EMPLOYEES
EMP_DETAILS_VIEW view
EMP_EMAIL_NN constraint of table EMPLOYEES
EMP_EMAIL_UK constraint of table EMPLOYEES
EMP_EMAIL_UK index of table EMPLOYEES
EMP_EMP_ID_PK constraint of table EMPLOYEES
EMP_EMP_ID_PK index of table EMPLOYEES
EMP_HIRE_DATE_NN constraint of table EMPLOYEES
EMP_JOB_FK constraint of table EMPLOYEES
EMP_JOB_IX index of table EMPLOYEES
EMP_JOB_NN constraint of table EMPLOYEES
EMP_LAST_NAME_NN constraint of table EMPLOYEES
EMP_MANAGER_FK constraint of table EMPLOYEES
EMP_MANAGER_IX index of table EMPLOYEES
EMP_NAME_IX index of table EMPLOYEES
EMP_SALARY_MIN constraint of table EMPLOYEES
EMPLOYEE_ID column of table EMPLOYEES
EMPLOYEE_ID column of table JOB_HISTORY
EMPLOYEE_ID column of view EMP_DETAILS_VIEW
EMPLOYEES table
EMPLOYEES_SEQ sequence
END_DATE column of table JOB_HISTORY

F

FIRST_NAME column of table EMPLOYEES
FIRST_NAME column of view EMP_DETAILS_VIEW

H

HIRE_DATE column of table EMPLOYEES

J

JHIST_DATE_INTERVAL constraint of table JOB_HISTORY
JHIST_DEPARTMENT_IX index of table JOB_HISTORY
JHIST_DEPT_FK constraint of table JOB_HISTORY
JHIST_EMP_FK constraint of table JOB_HISTORY
JHIST_EMP_ID_ST_DATE_PK constraint of table JOB_HISTORY
JHIST_EMP_ID_ST_DATE_PK index of table JOB_HISTORY
JHIST_EMPLOYEE_IX index of table JOB_HISTORY
JHIST_EMPLOYEE_NN constraint of table JOB_HISTORY
JHIST_END_DATE_NN constraint of table JOB_HISTORY
JHIST_JOB_FK constraint of table JOB_HISTORY
JHIST_JOB_IX index of table JOB_HISTORY
JHIST_JOB_NN constraint of table JOB_HISTORY
JHIST_START_DATE_NN constraint of table JOB_HISTORY
JOB_HISTORY table
JOB_ID column of table EMPLOYEES
JOB_ID column of table JOB_HISTORY
JOB_ID column of table JOBS
JOB_ID column of view EMP_DETAILS_VIEW
JOB_ID_PK constraint of table JOBS
JOB_ID_PK index of table JOBS
JOB_TITLE column of table JOBS
JOB_TITLE column of view EMP_DETAILS_VIEW
JOB_TITLE_NN constraint of table JOBS
JOBS table

L

LAST_NAME column of table EMPLOYEES
LAST_NAME column of view EMP_DETAILS_VIEW
LOC_C_ID_FK constraint of table LOCATIONS
LOC_CITY_IX index of table LOCATIONS
LOC_CITY_NN constraint of table LOCATIONS
LOC_COUNTRY_IX index of table LOCATIONS
LOC_ID_PK constraint of table LOCATIONS
LOC_ID_PK index of table LOCATIONS
LOC_STATE_PROVINCE_IX index of table LOCATIONS
LOCATION_ID column of table DEPARTMENTS
LOCATION_ID column of table LOCATIONS
LOCATION_ID column of view EMP_DETAILS_VIEW
LOCATIONS table
LOCATIONS_SEQ sequence

M

MANAGER_ID column of table DEPARTMENTS
MANAGER_ID column of table EMPLOYEES
MANAGER_ID column of view EMP_DETAILS_VIEW
MAX_SALARY column of table JOBS
MIN_SALARY column of table JOBS

P

PHONE_NUMBER column of table EMPLOYEES
POSTAL_CODE column of table LOCATIONS

R

REG_ID_PK constraint of table REGIONS
REG_ID_PK index of table REGIONS
REGION_ID column of table COUNTRIES
REGION_ID column of table REGIONS
REGION_ID_NN constraint of table REGIONS
REGION_NAME column of table REGIONS
REGION_NAME column of view EMP_DETAILS_VIEW
REGIONS table

S

SALARY column of table EMPLOYEES
SALARY column of view EMP_DETAILS_VIEW
SECURE_DML procedure
SECURE_EMPLOYEES trigger of table EMPLOYEES
START_DATE column of table JOB_HISTORY
STATE_PROVINCE column of table LOCATIONS
STATE_PROVINCE column of view EMP_DETAILS_VIEW
STREET_ADDRESS column of table LOCATIONS
SYS_C002413 constraint

U

UPDATE_JOB_HISTORY trigger of table EMPLOYEES


Generated by OraDoclet, Copyright © Oracle Corporation 2005      Last updated: 01.01.2005