Table: dbo.Employee_Payroll_Item_Garnishment_Order
Contains each garnishment order amount per employee payroll item.
Columns
Name | Type | Constraints | Description
employee_payroll_item_garnishment_order_KEY | int (4) | NOT NULL | Primary key for this table.
employee_payroll_item_KEY | int (4) | NOT NULL | Employee payroll item this garnishment order belongs to.
garnishment_order_KEY | int (4) | NOT NULL | The garnishment order that belongs to this employee payroll item.
amount | decimal (9, 2) | NOT NULL | The required amount or percent of pay this particular garnishment is ordered for.

Primary key
Name | Columns | Description
PK_Employee_Payroll_Item_Garnishment_Order | employee_payroll_item_garnishment_order_KEY |
Unique constraints
Name | Columns | Description
UK_Employee_Payroll_Item_Garnishment_Order$employee_payroll_item_KEY$garnishment_order_KEY | employee_payroll_item_KEY, garnishment_order_KEY |
UK_Employee_Payroll_Item_Garnishment_Order$garnishment_order_KEY$employee_payroll_item_KEY | garnishment_order_KEY, employee_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Employee_Payroll_Item_Garnishment_Order__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Employee_Payroll_Item_Garnishment_Order__Garnishment_Order__garnishment_order_KEY | garnishment_order_KEY | Garnishment_Order (garnishment_order_KEY) |