Table: dbo.Custom_Value_Client
This table links a client to one of the custom values associated with it.
Columns
NameTypeConstraintsDescription
custom_value_KEYint (4)NOT NULLPrimary key for this table and FK to the custom value being referenced.
client_KEYint (4)NOT NULLThe client that owns this custom value.
Primary key
NameColumnsDescription
PK_Custom_Value_Client$custom_value_KEYcustom_value_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Value_Client__Client__client_KEYclient_KEYClient (client_KEY)
FK_Custom_Value_Client__Custom_Value__custom_value_KEYcustom_value_KEYCustom_Value (custom_value_KEY)

Schema diagram