Difference between revisions of "HumanResources (schema)"

From dbscript Online Help
Jump to: navigation, search
Line 16: Line 16:
 
|-
 
|-
 
| '''schema
 
| '''schema
−
| .HumanResources
+
| HumanResources
 
|- valign="top"
 
|- valign="top"
  
Line 32: Line 32:
 
{| 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
 
  
 
|-
 
|-
 +
| Schema
 +
| Table
 
| [[HumanResources.Department_(table)|HumanResources.Department]]
 
| [[HumanResources.Department_(table)|HumanResources.Department]]
 +
 +
|-
 +
| Schema
 
| Table
 
| Table
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
 +
 
|-
 
|-
−
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
+
| Schema
 
| Table
 
| Table
 +
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 +
 
|-
 
|-
−
| [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]]
+
| Schema
 
| Table
 
| Table
 +
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 +
 +
|-
 
| Schema
 
| Schema
 +
| Table
 +
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 +
 
|-
 
|-
−
| [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
 
|-
 
|-
−
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
 
|-
 
|-
−
| [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
 
|-
 
|-
−
| [[HumanResources.Shift_(table)|HumanResources.Shift]]
 
−
| Table
 
 
| Schema
 
| Schema
 +
| View
 +
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 +
 
|-
 
|-
−
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 
−
| View
 
 
| Schema
 
| Schema
−
|-
 
−
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 
 
| View
 
| View
−
| Schema
+
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 +
 
 
|-
 
|-
−
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 
−
| View
 
 
| Schema
 
| Schema
−
|-
 
−
| [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]]
 
 
| View
 
| View
−
| Schema
+
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 +
 
 
|-
 
|-
−
| [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]]
 
−
| View
 
 
| Schema
 
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 +
 
|-
 
|-
−
| [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]]
 
−
| View
 
 
| Schema
 
| Schema
 +
| Procedure
 +
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 +
 
|-
 
|-
−
| [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]]
 
−
| Procedure
 
 
| Schema
 
| Schema
−
|-
 
−
| [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]]
 
 
| Procedure
 
| Procedure
−
| Schema
+
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 +
 
 
|-
 
|-
−
| [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]]
 
−
| Procedure
 
 
| Schema
 
| Schema
−
|-
+
| XML Schema Collection
 
| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
 
| [[HumanResources.HRResumeSchemaCollection_(xml_schema_collection)|HumanResources.HRResumeSchemaCollection]]
−
| XML Schema Collection
+
 
−
| Schema
 
 
|}
 
|}

Revision as of 06:39, 30 November 2009

wikibot

schema .HumanResources 
CREATE SCHEMA HumanResources AUTHORIZATION dbo

automatically generated

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=1721"