Table: dbo.Garnishment_Type
Columns
NameTypeConstraintsDescription
garnishment_type_KEYint (4)NOT NULLSurrogate primary key
descriptionnvarchar (60)NOT NULLUsed to store the name of a garnishment
maximum_percentage_of_disposable_incomedecimal (5, 2)NOT NULLPercentage field that holds the maximum percentage of disposable income that can be garnished for this garnishment.
calculation_orderint (4)NOT NULLThe order this garnishment type is calculated to other garnishment types.
Primary key
NameColumnsDescription
PK_Garnishment_Typegarnishment_type_KEY
Unique constraints
NameColumnsDescription
UK_Garnishment_Type$calculation_ordercalculation_order
UK_Garnishment_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Payroll_Item__Garnishment_Type__garnishment_type_KEYgarnishment_type_KEYClient_Payroll_Item
FK_Garnishment_Order__Garnishment_Type__garnishment_type_KEYgarnishment_type_KEYGarnishment_Order

Schema diagram