Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: HumanResources Department (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:46


wikibot

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
Namedbo.Namenot null Name of the department.
AK_Department_Name
GroupNamedbo.Namenot 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

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployeeDepartment
SelectViewHumanResources.vEmployeeDepartmentHistory

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