Difference between revisions of "HumanResources (schema)"

From dbscript Online Help
Jump to: navigation, search
 
(8 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"
−
| '''schema
+
| '''Schema
−
| .HumanResources
+
| HumanResources
−
|-
+
|- valign="top"
 +
| '''Description
 +
| Contains objects related to employees and departments.
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE SCHEMA HumanResources AUTHORIZATION dbo
 
CREATE SCHEMA HumanResources AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
=== Dependencies ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.Department_(table)|HumanResources.Department]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Table
 +
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 +
 +
|- valign="top"
 +
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 +
 +
|- valign="top"
 +
| Schema
 +
| XML Schema Collection
 +
| [[HumanResources.HRResumeSchemaCollection_(xml schema collection)|HumanResources.HRResumeSchemaCollection]]
 +
 +
|}
 +
  
 
== automatically generated ==
 
== automatically generated ==
Line 17: Line 115:
 
|-
 
|-
 
| '''schema
 
| '''schema
−
| .HumanResources
+
| HumanResources
−
|-
+
|- valign="top"
−
 
 
 
| '''Description
 
| '''Description
 
| Contains objects related to employees and departments.
 
| Contains objects related to employees and departments.
 
|-
 
|-
−
 
 
|}
 
|}
  
Line 29: Line 125:
 
CREATE SCHEMA HumanResources AUTHORIZATION dbo
 
CREATE SCHEMA HumanResources AUTHORIZATION dbo
 
</pre>
 
</pre>
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.Department_(table)|HumanResources.Department]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 +
 +
|-
 +
| Schema
 +
| Table
 +
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 +
 +
|-
 +
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 +
 +
|-
 +
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 +
 +
|-
 +
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 +
 +
|-
 +
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 +
 +
|-
 +
| Schema
 +
| XML Schema Collection
 +
| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
 +
 +
|}

Latest revision as of 23:15, 23 June 2010

wikibot[edit]

Schema HumanResources
Description Contains objects related to employees and departments.

Source[edit]

CREATE SCHEMA HumanResources AUTHORIZATION dbo

Dependencies[edit]

Reference Type Object Type Referencing Object
Schema Table HumanResources.Department
Schema Table HumanResources.Employee
Schema Table HumanResources.EmployeeAddress
Schema Table HumanResources.EmployeeDepartmentHistory
Schema Table HumanResources.EmployeePayHistory
Schema Table HumanResources.JobCandidate
Schema Table HumanResources.Shift
Schema View HumanResources.vEmployee
Schema View HumanResources.vEmployeeDepartment
Schema View HumanResources.vEmployeeDepartmentHistory
Schema View HumanResources.vJobCandidate
Schema View HumanResources.vJobCandidateEducation
Schema View HumanResources.vJobCandidateEmployment
Schema Procedure HumanResources.uspUpdateEmployeeHireInfo
Schema Procedure HumanResources.uspUpdateEmployeeLogin
Schema Procedure HumanResources.uspUpdateEmployeePersonalInfo
Schema XML Schema Collection HumanResources.HRResumeSchemaCollection


automatically generated[edit]

schema HumanResources
Description Contains objects related to employees and departments. 
CREATE SCHEMA HumanResources AUTHORIZATION dbo


Reference Type Object Type Referencing Object
Schema Table HumanResources.Department
Schema Table HumanResources.Employee
Schema Table HumanResources.EmployeeAddress
Schema Table HumanResources.EmployeeDepartmentHistory
Schema Table HumanResources.EmployeePayHistory
Schema Table HumanResources.JobCandidate
Schema Table HumanResources.Shift
Schema View HumanResources.vEmployee
Schema View HumanResources.vEmployeeDepartment
Schema View HumanResources.vEmployeeDepartmentHistory
Schema View HumanResources.vJobCandidate
Schema View HumanResources.vJobCandidateEducation
Schema View HumanResources.vJobCandidateEmployment
Schema Procedure HumanResources.uspUpdateEmployeeHireInfo
Schema Procedure HumanResources.uspUpdateEmployeeLogin
Schema Procedure HumanResources.uspUpdateEmployeePersonalInfo
Schema XML Schema Collection HumanResources.HRResumeSchemaCollection
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources_(schema)&oldid=2569"