Difference between revisions of "HumanResources.Department (table)"
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 |