HumanResources (schema)

From dbscript Online Help
Jump to: navigation, search

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