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
NameTypeConstraintsDescription
insurepay_client_class_code_n_client_payroll_item_KEYint (4)NOT NULLPrimary key for this table.
client_payroll_item_KEYint (4)NOT NULLthe matching client payroll item key
insurepay_client_class_code_KEYint (4)NOT NULLthe match insurepay client class code key
Primary key
NameColumnsDescription
PK_Insurepay_Client_Class_Code_N_Client_Payroll_Iteminsurepay_client_class_code_n_client_payroll_item_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Client_Class_Code_N_Client_Payroll_Item$client_payroll_item_KEY$insurepay_client_class_code_KEYclient_payroll_item_KEY, insurepay_client_class_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Client_Class_Code_N_Client_Payroll_Item__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Insurepay_Client_Class_Code_N_Client_Payroll_Item__Insurepay_Client_Class_Code__insurepay_client_class_code_KEYinsurepay_client_class_code_KEYInsurepay_Client_Class_Code (insurepay_client_class_code_KEY)

Schema diagram