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

From dbscript Online Help
Jump to: navigation, search
 
(11 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| HumanResources.Department
 
| HumanResources.Department
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Lookup table containing the departments within the Adventure Works Cycles company.
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 15: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description
−
| '''Index
+
 
−
+
|- valign="top"
−
|-
 
 
| DepartmentID
 
| DepartmentID
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
−
| PK_Department_DepartmentID
+
| Primary key for Department records.
−
|
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Name of the department.
−
| AK_Department_Name
+
|- valign="top"
−
|-
 
 
| GroupName
 
| GroupName
 
| dbo.Name
 
| dbo.Name
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Name of the group to which the department belongs.
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.
−
|
 
 
|}
 
|}
  
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| PK_Department_DepartmentID
 +
| DepartmentID
 +
|}
  
 +
=== Indexes ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
  
 +
|- valign="top"
 +
| AK_Department_Name
 +
| Unique
 +
| Name
 +
|}
 +
 +
=== Detail Tables ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 55: Line 74:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 
| DepartmentID
 
| DepartmentID
 
| DepartmentID
 
| DepartmentID
 
|}
 
|}
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 +
|}
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 +
|- valign="top"
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 +
|}
 +
  
 
== automatically generated ==
 
== automatically generated ==
Line 68: Line 126:
 
| '''Table
 
| '''Table
 
| HumanResources.Department
 
| HumanResources.Department
−
|-
+
|- 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.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 83: Line 139:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
−
|-
+
|- valign="top"
 
| DepartmentID
 
| DepartmentID
 
| smallint
 
| smallint
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Department records.
+
| Primary key for Department records.<br />PK_Department_DepartmentID
−
| PK_Department_DepartmentID
+
|- valign="top"
−
|-
 
 
| Name
 
| Name
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Name of the department.
+
| Name of the department.<br />AK_Department_Name
−
| AK_Department_Name
+
|- valign="top"
−
|-
 
 
| GroupName
 
| GroupName
 
| Name
 
| Name
 
| not null
 
| not null
 
|  
 
|  
−
| Name of the group to which the department belongs.
+
| Name of the group to which the department belongs.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 128: Line 179:
 
| DepartmentID
 
| DepartmentID
 
| DepartmentID
 
| DepartmentID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Data Type
 +
| Type
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 +
|-
 +
| Select
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 
|}
 
|}

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

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

Columns[edit]

Column Data Type Nullable Default Description
DepartmentID smallint not null Primary key for Department records.
Name dbo.Name not null Name of the department.
GroupName dbo.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.

Primary Key[edit]

Primary Key Columns
PK_Department_DepartmentID DepartmentID

Indexes[edit]

Index Type Columns
AK_Department_Name Unique Name

Detail Tables[edit]

Detail Table Column Referencing Column
HumanResources.EmployeeDepartmentHistory DepartmentID DepartmentID

References[edit]

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

Dependencies[edit]

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


automatically generated[edit]

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
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.Department_(table)&oldid=2595"