Table: dbo.Payroll_Item_Special_Type
Table used to store payroll item special types.
Columns
NameTypeConstraintsDescription
payroll_item_special_type_KEYint (4)NOT NULLThe primary key for the table. Corresponds to a payroll item special type.
descriptionnvarchar (80)NOT NULLThe description for the payroll item special type.
Primary key
NameColumnsDescription
PK_Payroll_Item_Special_Typepayroll_item_special_type_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Item_Special_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__Payroll_Item_Special_Type__special_type_KEYspecial_type_KEYClient_Payroll_Item

Schema diagram