# Schema: HumanResources

## Properties

Name | Value
--- | ---
Name | HumanResources
ID | 5
Owner | dbo

## Extended Properties

Name | Value
--- | ---
MS_Description | Contains objects related to employees and departments.

## Permissions

#### Permissions for: duser

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
Alter | dbo |  |  |
Control |  |  |  |
Delete |  |  |  |
Execute |  |  |  |
Insert | dbo |  |  |
References |  |  |  |
Select |  |  |  |
Take Ownership |  |  |  |
Update |  |  |  |
View Change Tracking |  |  |  |
View Definition |  |  |  |

#### Permissions for: public

Permission | Grantor | Grant | With Grant Option | Deny
--- | --- | --- | --- | ---
Alter |  |  |  |
Control |  |  |  |
Delete | dbo |  |  |
Execute |  |  |  |
Insert |  |  |  |
References |  |  |  |
Select |  |  |  |
Take Ownership |  |  |  |
Update |  |  |  |
View Change Tracking |  |  |  |
View Definition |  |  |  |

## Objects

Name | Type
--- | ---
CK_Employee_BirthDate | CHECK constraint
CK_Employee_Gender | CHECK constraint
CK_Employee_HireDate | CHECK constraint
CK_Employee_MaritalStatus | CHECK constraint
CK_Employee_SickLeaveHours | CHECK constraint
CK_Employee_VacationHours | CHECK constraint
CK_EmployeeDepartmentHistory_EndDate | CHECK constraint
CK_EmployeePayHistory_PayFrequency | CHECK constraint
CK_EmployeePayHistory_Rate | CHECK constraint
FK_Employee_Person_BusinessEntityID | FOREIGN KEY constraint
FK_EmployeeDepartmentHistory_Department_DepartmentID | FOREIGN KEY constraint
FK_EmployeeDepartmentHistory_Employee_BusinessEntityID | FOREIGN KEY constraint
FK_EmployeeDepartmentHistory_Shift_ShiftID | FOREIGN KEY constraint
FK_EmployeePayHistory_Employee_BusinessEntityID | FOREIGN KEY constraint
FK_JobCandidate_Employee_BusinessEntityID | FOREIGN KEY constraint
PK_Department_DepartmentID | PRIMARY KEY constraint
PK_Employee_BusinessEntityID | PRIMARY KEY constraint
PK_EmployeeDepartmentHistory_BusinessEntityID_StartDate_DepartmentID | PRIMARY KEY constraint
PK_EmployeePayHistory_BusinessEntityID_RateChangeDate | PRIMARY KEY constraint
PK_JobCandidate_JobCandidateID | PRIMARY KEY constraint
PK_Shift_ShiftID | PRIMARY KEY constraint
uspUpdateEmployeeHireInfo | SQL Stored Procedure
uspUpdateEmployeeLogin | SQL Stored Procedure
uspUpdateEmployeePersonalInfo | SQL Stored Procedure
dEmployee | SQL DML trigger
ProcedureSynonym | Synonym
viewSynonym1 | Synonym
Department | Table (user-defined)
Employee | Table (user-defined)
EmployeeDepartmentHistory | Table (user-defined)
EmployeePayHistory | Table (user-defined)
JobCandidate | Table (user-defined)
Shift | Table (user-defined)
vEmployee | View
vEmployeeDepartment | View
vEmployeeDepartmentHistory | View
vJobCandidate | View
vJobCandidateEducation | View
vJobCandidateEmployment | View
HRResumeSchemaCollection | XML Schema Collection

## SQL

Script
CREATE SCHEMA [HumanResources] AUTHORIZATION [dbo] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Contains objects related to employees and departments.' , @level0type=N'SCHEMA',@level0name=N'HumanResources'

#### See also

List of Schemas