Table: dbo.Multiple_Garnishment_Calculation_Method
Columns
NameTypeConstraintsDescription
multiple_garnishment_calculation_method_KEYint (4)NOT NULLSurrogate primary key
descriptionnvarchar (60)NOT NULLDescription for what we do when there are multiple garnishments and the total exceeds the maximum.
Primary key
NameColumnsDescription
PK_Multiple_Garnishment_Calculation_Methodmultiple_garnishment_calculation_method_KEY
Unique constraints
NameColumnsDescription
UK_Multiple_Garnishment_Calculation_Method$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Employee_Payroll_Item__Multiple_Garnishment_Calculation_Method__multiple_garnishment_calculation_method_KEYmultiple_garnishment_calculation_method_KEYEmployee_Payroll_Item

Schema diagram