Table: dbo.Custom_Value_Staff
This table links a vendor 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.
staff_KEYint (4)NOT NULLThe vendor that owns this custom value.
Primary key
NameColumnsDescription
PK_Custom_Value_Staff$custom_value_KEYcustom_value_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Custom_Value_Staff__Custom_Value__custom_value_KEYcustom_value_KEYCustom_Value (custom_value_KEY)
FK_Custom_Value_Staff__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram