Table: dbo.Insurepay_Client_Class_Code_N_Client_Benefit
Table is a dictionary table for insurepay_client_class_code_KEY and client_benefit_KEY.
Columns
NameTypeConstraintsDescription
insurepay_client_class_code_n_client_benefit_KEYint (4)NOT NULLPrimary key for this table.
client_benefit_KEYint (4)NOT NULLthe matching client benefit 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_Benefitinsurepay_client_class_code_n_client_benefit_KEY
Unique constraints
NameColumnsDescription
UK_Insurepay_Client_Class_Code_N_Client_Benefit$client_benefit_KEY$insurepay_client_class_code_KEYclient_benefit_KEY, insurepay_client_class_code_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Insurepay_Client_Class_Code_N_Client_Benefit__Client_Benefit__client_benefit_KEYclient_benefit_KEYClient_Benefit (client_benefit_KEY)
FK_Insurepay_Client_Class_Code_N_Client_Benefit__Insurepay_Client_Class_Code__insurepay_client_class_code_KEYinsurepay_client_class_code_KEYInsurepay_Client_Class_Code (insurepay_client_class_code_KEY)

Schema diagram