Prior Table Table DEPARTMENTS Next Table

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

Columns of Table DEPARTMENTS
Column ID Column Name Datatype Not Null Data Default Comments
1 DEPARTMENT_ID NUMBER(4) Y   Primary key column of departments table.
2 DEPARTMENT_NAME VARCHAR2(30 BYTE) Y   A not null column that shows name of a department. Administration, Marketing, Purchasing, Human Resources, Shipping, IT, Executive, Public Relations, Sales, Finance, and Accounting.
3 MANAGER_ID NUMBER(6)     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.
4 LOCATION_ID NUMBER(4)     Location id where a department is located. Foreign key to location_id column of locations table.

Indexes on Table DEPARTMENTS
Uniqueness Index Name Type Columns Partitions Partition Type Partition Columns Subpartition Type Subpartition Columns
UNIQUE DEPT_ID_PK NORMAL DEPARTMENT_ID <none>        
NON-UNIQUE DEPT_LOCATION_IX NORMAL LOCATION_ID <none>        

Foreign Key Constraints on Table DEPARTMENTS
Constraint Name Columns Ref Table Owner Referenced Table Name Referenced Columns Delete Rule Status Deferrable Deferred
DEPT_LOC_FK LOCATION_ID HR LOCATIONS LOCATION_ID NO ACTION ENABLED No No
DEPT_MGR_FK MANAGER_ID HR EMPLOYEES EMPLOYEE_ID NO ACTION ENABLED No No

PK, UK, & Check Constraints on Table DEPARTMENTS
Constraint Name Type Condition Status Columns
DEPT_NAME_NN Check "DEPARTMENT_NAME" IS NOT NULL ENABLED DEPARTMENT_NAME
DEPT_ID_PK Primary Key   ENABLED DEPARTMENT_ID

Table DEPARTMENTS does not have...
Partitions
Redaction Policies