HR

Constraints

HR

Constraints

Constraint	Type	Table
COUNTR_REG_FK	Referential	COUNTRIES
COUNTRY_C_ID_PK	Primary Key	COUNTRIES
COUNTRY_ID_NN	Check	COUNTRIES
DEPT_ID_PK	Primary Key	DEPARTMENTS
DEPT_LOC_FK	Referential	DEPARTMENTS
DEPT_MGR_FK	Referential	DEPARTMENTS
DEPT_NAME_NN	Check	DEPARTMENTS
EMP_DEPT_FK	Referential	EMPLOYEES
EMP_EMAIL_NN	Check	EMPLOYEES
EMP_EMAIL_UK	Unique key	EMPLOYEES
EMP_EMP_ID_PK	Primary Key	EMPLOYEES
EMP_HIRE_DATE_NN	Check	EMPLOYEES
EMP_JOB_FK	Referential	EMPLOYEES
EMP_JOB_NN	Check	EMPLOYEES
EMP_LAST_NAME_NN	Check	EMPLOYEES
EMP_MANAGER_FK	Referential	EMPLOYEES
EMP_SALARY_MIN	Check	EMPLOYEES
JHIST_DATE_INTERVAL	Check	JOB_HISTORY
JHIST_DEPT_FK	Referential	JOB_HISTORY
JHIST_EMP_FK	Referential	JOB_HISTORY
JHIST_EMP_ID_ST_DATE_PK	Primary Key	JOB_HISTORY
JHIST_EMPLOYEE_NN	Check	JOB_HISTORY
JHIST_END_DATE_NN	Check	JOB_HISTORY
JHIST_JOB_FK	Referential	JOB_HISTORY
JHIST_JOB_NN	Check	JOB_HISTORY
JHIST_START_DATE_NN	Check	JOB_HISTORY
JOB_ID_PK	Primary Key	JOBS
JOB_TITLE_NN	Check	JOBS
LOC_C_ID_FK	Referential	LOCATIONS
LOC_CITY_NN	Check	LOCATIONS
LOC_ID_PK	Primary Key	LOCATIONS
REG_ID_PK	Primary Key	REGIONS
REGION_ID_NN	Check	REGIONS
SYS_C002413	Unknown	EMP_DETAILS_VIEW

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