Difference between revisions of "HumanResources (schema)"
| Line 3: | Line 3: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- | |- | ||
| − | | ''' | + | | '''Schema |
| HumanResources | | HumanResources | ||
|- valign="top" | |- valign="top" | ||
| Line 10: | Line 10: | ||
|- | |- | ||
|} | |} | ||
| + | |||
<pre> | <pre> | ||
CREATE SCHEMA HumanResources AUTHORIZATION dbo | CREATE SCHEMA HumanResources AUTHORIZATION dbo | ||
</pre> | </pre> | ||
| − | |||
Revision as of 22:36, 2 February 2010
wikibot
| Schema | HumanResources |
| Description | Contains objects related to employees and departments. |
CREATE SCHEMA HumanResources AUTHORIZATION dbo
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 |
