HR.DEPARTMENTS (table)

wikibot

Table	HR.DEPARTMENTS
Description	Departments table that shows details of departments where employees work. Contains 27 rows; references with locations, employees, and job_history tables.

Columns

Column	Data Type	Nullable	Default	Description
DEPARTMENT_ID	NUMBER(4, 0)	not null		Primary key column of departments table.
DEPARTMENT_NAME	VARCHAR2(30)	not null		A not null column that shows name of a department. Administration, Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public Relations, Sales, Finance, and Accounting.
MANAGER_ID	NUMBER(6, 0)	null		Manager_id of a department. Foreign key to employee_id column of employees table. The manager_id column of the employee table references this column.
LOCATION_ID	NUMBER(4, 0)	null		Location id where a department is located. Foreign key to location_id column of locations table.

Primary Key

Primary Key	Columns
DEPT_ID_PK	DEPARTMENT_ID

Indexes

Index	Type	Columns
DEPT_LOCATION_IX		LOCATION_ID

Check Constraints

Check Constraint	Expression	Description
DEPT_NAME_NN	"DEPARTMENT_NAME" IS NOT NULL

Foreign Keys

Relation	Column	Referenced Column
HR.LOCATIONS	LOCATION_ID	LOCATION_ID
HR.EMPLOYEES	MANAGER_ID	EMPLOYEE_ID

Detail Tables

Detail Table	Column	Referencing Column
HR.EMPLOYEES	DEPARTMENT_ID	DEPARTMENT_ID
HR.JOB_HISTORY	DEPARTMENT_ID	DEPARTMENT_ID