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