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
NameTypeConstraintsDescription
insurepay_client_class_code_n_employee_payroll_item_KEYint (4)NOT NULLPrimary key for this table.
employee_payroll_item_KEYint (4)NOT NULLthe matching employee 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_Employee_Payroll_Iteminsurepay_client_class_code_n_employee_payroll_item_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item$employee_payroll_item_KEY$insurepay_client_class_code_KEYemployee_payroll_item_KEY, insurepay_client_class_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Client_Class_Code_N_Employee_Payroll_Item__Employee_Payroll_Item__employee_payroll_item_KEYemployee_payroll_item_KEYEmployee_Payroll_Item (employee_payroll_item_KEY)
FK_Insurepay_Client_Class_Code_N_Employee_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