ScrewTurn Wiki

Edit

wikibot

TableHumanResources.Department
DescriptionLookup table containing the departments within the Adventure Works Cycles company.

Edit

Columns

ColumnData TypeNullableDefaultDescription
DepartmentIDsmallintnot null Primary key for Department records.
Namedbo.Namenot null Name of the department.
GroupNamedbo.Namenot null Name of the group to which the department belongs.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Edit

Primary Key

Primary KeyColumns
PK_Department_DepartmentIDDepartmentID

Edit

Indexes

IndexTypeColumns
AK_Department_NameUniqueName

Edit

Detail Tables

Detail TableColumnReferencing Column
HumanResources.EmployeeDepartmentHistoryDepartmentIDDepartmentID

Edit

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaHumanResources

Edit

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployeeDepartment
SelectViewHumanResources.vEmployeeDepartmentHistory

Edit

automatically generated

TableHumanResources.Department
DescriptionLookup table containing the departments within the Adventure Works Cycles company.

ColumnData TypeNullableDefaultDescription / PK / Index
DepartmentIDsmallintnot null Primary key for Department records.
PK_Department_DepartmentID
NameNamenot null Name of the department.
AK_Department_Name
GroupNameNamenot null Name of the group to which the department belongs.
ModifiedDatedatetimenot null(GETDATE())Date and time the record was last updated.



Detail TableColumnReferencing Column
HumanResources.EmployeeDepartmentHistoryDepartmentIDDepartmentID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
SchemaSchemaHumanResources

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployeeDepartment
SelectViewHumanResources.vEmployeeDepartmentHistory

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