Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableHR.DEPARTMENTS
DescriptionDepartments table that shows details of departments where employees

Columns

ColumnData TypeNullableDefaultDescription
DEPARTMENT_IDNUMBER(4, 0)not null Primary key column of departments table.
DEPARTMENT_NAMEVARCHAR2(30)not null A not null column that shows name of a department. Administration,
MANAGER_IDNUMBER(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_IDNUMBER(4, 0)null Location id where a department is located. Foreign key to location_id column of locations table.

Primary Key

Primary KeyColumns
DEPT_ID_PKDEPARTMENT_ID

Indexes

IndexTypeColumns
DEPT_LOCATION_IX LOCATION_ID

Check Constraints

Check ConstraintExpressionDescription
DEPT_NAME_NN"DEPARTMENT_NAME" IS NOT NULL 

Foreign Keys

RelationColumnReferenced Column
HR.LOCATIONSLOCATION_IDLOCATION_ID
HR.EMPLOYEESMANAGER_IDEMPLOYEE_ID

Detail Tables

Detail TableColumnReferencing Column
HR.EMPLOYEESDEPARTMENT_IDDEPARTMENT_ID
HR.JOB_HISTORYDEPARTMENT_IDDEPARTMENT_ID

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.