schema icon 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 true
Control
Delete
Execute
Insert dbo true
References
Select
Take Ownership
Update
View Change Tracking
View Definition

Permissions for: public

Permission Grantor Grant With Grant Option Deny
Alter
Control
Delete dbo true
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