HumanResources_(schema)

Modified: 2011/08/27 10:13 by wikibot - Uncategorized

» SH.TIMES_(table) » HumanResources_(schema)

wikibot

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

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