HumanResources (schema)

From dbscript Online Help
Revision as of 22:59, 23 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

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