AdventureWorks
| Table Name: | HumanResources.EmployeePayHistory |
| Description: | Employee pay history. |
| Primary Keys: | EmployeeID RateChangeDate |
| Field | Type | Defaults | Nulls? | Comments |
|---|---|---|---|---|
| EmployeeID | int | None | No | Employee identification number. Foreign key to Employee.EmployeeID. |
| RateChangeDate | datetime | None | No | Date the change in pay is effective |
| Rate | money | None | No | Salary hourly rate. |
| PayFrequency | tinyint | None | No | 1 = Salary received monthly, 2 = Salary received biweekly |
| ModifiedDate | datetime | (getdate()) | No | Date and time the record was last updated. |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_EmployeePayHistory_EmployeeID_RateChangeDate | Yes | Yes | EmployeeID RateChangeDate |
| Check Constraint | Text |
|---|---|
| CK_EmployeePayHistory_PayFrequency | ([PayFrequency]=(2) OR [PayFrequency]=(1)) |
| CK_EmployeePayHistory_Rate | ([Rate]>=(6.50) AND [Rate]<=(200.00)) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_EmployeePayHistory_Employee_EmployeeID | EmployeeID | HumanResources.Employee |