| 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 | ||