Difference between revisions of "HumanResources.Department (table)"

From dbscript Online Help
Jump to: navigation, search
Line 68: Line 68:
 
| HumanResources.Department
 
| HumanResources.Department
 
|- valign="top"
 
|- valign="top"
 
 
| '''Description
 
| '''Description
 
| Lookup table containing the departments within the Adventure Works Cycles company.
 
| Lookup table containing the departments within the Adventure Works Cycles company.
 
|-
 
|-
 
 
|}
 
|}
  

Revision as of 06:59, 30 November 2009

wikibot

Table HumanResources.Department


Column Data Type Nullable Default PK Index
DepartmentID smallint not null PK_Department_DepartmentID
Name dbo.Name not null AK_Department_Name
GroupName dbo.Name not null
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
HumanResources.EmployeeDepartmentHistory DepartmentID DepartmentID

automatically generated

Table HumanResources.Department
Description Lookup table containing the departments within the Adventure Works Cycles company.


Column Data Type Nullable Default Description / PK / Index
DepartmentID smallint not null Primary key for Department records.
PK_Department_DepartmentID
Name Name not null Name of the department.
AK_Department_Name
GroupName Name not null Name of the group to which the department belongs.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
HumanResources.EmployeeDepartmentHistory DepartmentID DepartmentID


Dependency Type Object Type Referenced Object
Data Type Type dbo.Name
Schema Schema HumanResources


Reference Type Object Type Referencing Object
Select View HumanResources.vEmployeeDepartment
Select View HumanResources.vEmployeeDepartmentHistory