CHECK Table Level|([Gender]='f' OR [Gender]='m' OR [Gender]='F' OR [Gender]='M')
CHECK Table Level|([MaritalStatus]='s' OR [MaritalStatus]='m' OR [MaritalStatus]='S' OR [MaritalStatus]='M')
CHECK Table Level|([PayFrequency]=(3) OR [PayFrequency]=(2) OR [PayFrequency]=(1))
DEFAULT on column CurrentFlag|((1))
DEFAULT on column ModifiedDate|(getdate())
DEFAULT on column rowguid|(newid())
DEFAULT on column SalariedFlag|((1))
DEFAULT on column SickLeaveHours|((0))
DEFAULT on column VacationHours|((0))
FOREIGN KEY|AddressID
|REFERENCES AdventureWorks.Person.Address (AddressID)
FOREIGN KEY|ContactID
|REFERENCES AdventureWorks.Person.Contact (ContactID)
FOREIGN KEY|DepartmentID
|REFERENCES AdventureWorks.HumanResources.Department (DepartmentID)
FOREIGN KEY|ManagerID
|REFERENCES AdventureWorks.HumanResources.Employee (EmployeeID)
FOREIGN KEY|ShiftID
|REFERENCES AdventureWorks.HumanResources.Shift (ShiftID)
PRIMARY KEY (clustered)|EmployeeID