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

From dbscript Online Help
Jump to: navigation, search
 
(10 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 67: 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 89: Line 146:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Department records.PK_Department_DepartmentID
+
| Primary key for Department records.<br />PK_Department_DepartmentID
 
|- valign="top"
 
|- valign="top"
 
| Name
 
| Name
Line 95: Line 152:
 
| not null
 
| not null
 
|  
 
|  
−
| Name of the department.AK_Department_Name
+
| Name of the department.<br />AK_Department_Name
 
|- valign="top"
 
|- valign="top"
 
| GroupName
 
| GroupName
Line 101: Line 158:
 
| 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"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 107: Line 164:
 
| not null
 
| not null
 
| (GETDATE())
 
| (GETDATE())
−
| Date and time the record was last updated.
+
| Date and time the record was last updated.<br />
 
|}
 
|}
  
Line 127: Line 184:
 
{| 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"
 +
| '''Dependency Type
 +
| '''Object Type
 
| '''Referenced Object
 
| '''Referenced Object
−
| '''Object Type
+
 
−
| '''Dependency Type
 
−
 
 
|-
 
|-
 +
| Data Type
 +
| Type
 
| [[dbo.Name_(type)|dbo.Name]]
 
| [[dbo.Name_(type)|dbo.Name]]
−
| Type
+
 
−
| Data Type
+
|-
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 
 
|}
 
|}
  
Line 140: Line 203:
 
{| 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"
 +
| '''Reference Type
 +
| '''Object Type
 
| '''Referencing Object
 
| '''Referencing Object
−
| '''Object Type
+
 
−
| '''Reference Type
 
−
 
 
|-
 
|-
 +
| Select
 +
| View
 
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 +
|-
 +
| Select
 
| View
 
| View
−
| Select
 
−
|-
 
 
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
−
| View
+
 
−
| Select
 
 
|}
 
|}

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"