HumanResources.EmployeePayHistory Table

Information

NameEmployeePayHistory
SchemaHumanResources
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:54

Extended Properties

NameTypeProperty NameValue
EmployeePayHistoryTABLEMS_DescriptionEmployee pay history.

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   EmployeeIDint  HumanResources.Employee.EmployeeID
 
 
 
   RateChangeDatedatetime   
 
 
 
   Ratemoney   
 
 
 
   PayFrequencytinyint   
 
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_EmployeePayHistory_EmployeeID_RateChangeDateClustered  EmployeeID, RateChangeDate

Check Constraints

NameColumnEnabledTrustedExpression
CK_EmployeePayHistory_RateRate  ([Rate]>=(6.50) AND [Rate]<=(200.00))
CK_EmployeePayHistory_PayFrequencyPayFrequency  ([PayFrequency]=(2) OR [PayFrequency]=(1))

Foreign Key Constraints

NameTypeReferenced Table
FK_EmployeePayHistory_Employee_EmployeeIDForeign keyHumanResources.Employee

SQL Script

CREATE TABLE [HumanResources].[EmployeePayHistory] (
    [EmployeeID] int NOT NULL,
    [RateChangeDate] datetime NOT NULL,
    [Rate] money NOT NULL,
    [PayFrequency] tinyint NOT NULL,
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);