Difference between revisions of "HumanResources (schema)"

From dbscript Online Help
Jump to: navigation, search
Line 12: Line 12:
  
  
 +
=== 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
 +
 +
|-
 +
| 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]]
 +
 +
|}
  
  

Revision as of 23:08, 2 February 2010

wikibot

Schema HumanResources
Description Contains objects related to employees and departments.


Source

CREATE SCHEMA HumanResources AUTHORIZATION dbo

Dependencies

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

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