Table: dbo.Insurepay_Client_Class_Code_N_Employee_Payroll_Item
Table is a dictionary table for insurepay_client_class_code_KEY and employee_payroll_item_KEY
Columns
Name | Type | Constraints | Description
insurepay_client_class_code_n_employee_payroll_item_KEY | int (4) | NOT NULL | Primary key for this table.
employee_payroll_item_KEY | int (4) | NOT NULL | the matching employee payroll item key
insurepay_client_class_code_KEY | int (4) | NOT NULL | the match insurepay client class code key

Primary key
Name | Columns | Description
PK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item | insurepay_client_class_code_n_employee_payroll_item_KEY |
Unique constraints
Name | Columns | Description
UK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item$employee_payroll_item_KEY$insurepay_client_class_code_KEY | employee_payroll_item_KEY, insurepay_client_class_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item__Employee_Payroll_Item__employee_payroll_item_KEY | employee_payroll_item_KEY | Employee_Payroll_Item (employee_payroll_item_KEY) |
FK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item__Insurepay_Client_Class_Code__insurepay_client_class_code_KEY | insurepay_client_class_code_KEY | Insurepay_Client_Class_Code (insurepay_client_class_code_KEY) |