ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
HumanResources_(schema)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Schema''' | HumanResources |- valign="top" | '''Description''' | Contains objects related to employees and departments. |} === Source === {{{{<nowiki> CREATE SCHEMA HumanResources AUTHORIZATION dbo </nowiki>}}}} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- valign="top" | Schema | Table | [[HumanResources.Department_(table)|HumanResources.Department]] |- valign="top" | Schema | Table | [[HumanResources.Employee_(table)|HumanResources.Employee]] |- valign="top" | Schema | Table | [[HumanResources.EmployeeAddress_(table)|HumanResources.EmployeeAddress]] |- valign="top" | Schema | Table | [[HumanResources.EmployeeDepartmentHistory_(table)|HumanResources.EmployeeDepartmentHistory]] |- valign="top" | Schema | Table | [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] |- valign="top" | Schema | Table | [[HumanResources.JobCandidate_(table)|HumanResources.JobCandidate]] |- valign="top" | Schema | Table | [[HumanResources.Shift_(table)|HumanResources.Shift]] |- valign="top" | Schema | View | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] |- valign="top" | Schema | View | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] |- valign="top" | Schema | View | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] |- valign="top" | Schema | View | [[HumanResources.vJobCandidate_(view)|HumanResources.vJobCandidate]] |- valign="top" | Schema | View | [[HumanResources.vJobCandidateEducation_(view)|HumanResources.vJobCandidateEducation]] |- valign="top" | Schema | View | [[HumanResources.vJobCandidateEmployment_(view)|HumanResources.vJobCandidateEmployment]] |- valign="top" | Schema | Procedure | [[HumanResources.uspUpdateEmployeeHireInfo_(procedure)|HumanResources.uspUpdateEmployeeHireInfo]] |- valign="top" | Schema | Procedure | [[HumanResources.uspUpdateEmployeeLogin_(procedure)|HumanResources.uspUpdateEmployeeLogin]] |- valign="top" | Schema | Procedure | [[HumanResources.uspUpdateEmployeePersonalInfo_(procedure)|HumanResources.uspUpdateEmployeePersonalInfo]] |- valign="top" | Schema | XML Schema Collection | [[HumanResources.HRResumeSchemaCollection_(xml schema collection)|HumanResources.HRResumeSchemaCollection]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''schema''' | HumanResources |- valign="top" | '''Description''' | Contains objects related to employees and departments. |- |} {{{{<nowiki> CREATE SCHEMA HumanResources AUTHORIZATION dbo </nowiki>}}}} {| 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]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.