Table: dbo.Payroll_Item_Special_Timing_Frequency
Table to identify the frequency for a special timing payroll item.
Columns
NameTypeConstraintsDescription
payroll_item_special_timing_frequency_KEYint (4)NOT NULLPrimary key; frequency key
descriptionnvarchar (34)NOT NULLDescription of the frequency
Primary key
NameColumnsDescription
PK_Payroll_Item_Special_Timing_Frequencypayroll_item_special_timing_frequency_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Item_Special_Timing_Frequency$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Item_Special_Timing__Payroll_Item_Special_Timing_Frequency__payroll_item_special_timing_frequency_KEYpayroll_item_special_timing_frequency_KEYPayroll_Item_Special_Timing

Schema diagram