Table: dbo.Insurepay_Client_Class_Code_N_Client_Payroll_Item
Table is a dictionary table for insurepay_client_class_code_KEY and client_payroll_item_KEY.
Columns
Name | Type | Constraints | Description
insurepay_client_class_code_n_client_payroll_item_KEY | int (4) | NOT NULL | Primary key for this table.
client_payroll_item_KEY | int (4) | NOT NULL | the matching client 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_Client_Payroll_Item | insurepay_client_class_code_n_client_payroll_item_KEY |
Unique constraints
Name | Columns | Description
UK_Insurepay_Client_Class_Code_N_Client_Payroll_Item$client_payroll_item_KEY$insurepay_client_class_code_KEY | client_payroll_item_KEY, insurepay_client_class_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Insurepay_Client_Class_Code_N_Client_Payroll_Item__Client_Payroll_Item__client_payroll_item_KEY | client_payroll_item_KEY | Client_Payroll_Item (client_payroll_item_KEY) |
FK_Insurepay_Client_Class_Code_N_Client_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) |