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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | HumanResources.Department |- |} {| border="1" cellpadding="5" cellspacing="0...)
 
 
(12 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.
 +
|- valign="top"
 +
| GroupName
 +
| dbo.Name
 +
| not null
 
|  
 
|  
 +
| Name of the group to which the department belongs.
 +
|- valign="top"
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (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
 
| AK_Department_Name
 +
| Unique
 +
| Name
 +
|}
 +
 +
=== Detail Tables ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|- valign="top"
 +
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 +
| 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 ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| HumanResources.Department
 +
|- valign="top"
 +
| '''Description
 +
| Lookup table containing the departments within the Adventure Works Cycles company.
 
|-
 
|-
−
| GroupName
+
|}
−
| dbo.Name
+
 
 +
 
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description / PK / Index
 +
 +
|- valign="top"
 +
| DepartmentID
 +
| smallint
 
| not null
 
| not null
 
|  
 
|  
 +
| Primary key for Department records.<br />PK_Department_DepartmentID
 +
|- valign="top"
 +
| Name
 +
| Name
 +
| not null
 
|  
 
|  
 +
| Name of the department.<br />AK_Department_Name
 +
|- valign="top"
 +
| GroupName
 +
| Name
 +
| not null
 
|  
 
|  
−
|-
+
| 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.<br />
−
|
 
 
|}
 
|}
  
Line 60: 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 00:15, 24 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"