column icon Column: ShiftID

Properties

Property Value
Datatype tinyint
Uses Database Collation false
Is Xml Document false

Advanced Properties

Property Value
Collation Name
Nullable false
Is Rowguidcol false
Is Filestream false
Is Sparse false
Is Column Set false
Is Replicated false
Is Non Sql Subscribed false
Is Merge Published false
Is DTS Replicated false

Extended Properties

Name Value
MS_Description Identifies which 8-hour shift the employee works. Foreign key to Shift.Shift.ID.

Identity Specification

Property Value
Has Identity Values false

Column Creation Options

Property Value
ANSI Padded false

See also

Table EmployeeDepartmentHistory
List of Tables