Table: dbo.Active_Filter
Columns
NameTypeConstraintsDescription
active_filter_KEYint (4)NOT NULLDatabase assigned primary key for this table
staff_KEYint (4)NOT NULLKey to the Staff this filter is in use by.
filter_KEYint (4)NOT NULLKey to the Filter being used for this Staff and description.
descriptionnvarchar (60)NOT NULLDescription of where this filter is being used.
Primary key
NameColumnsDescription
PK_Active_Filteractive_filter_KEY
Unique constraints
NameColumnsDescription
UK_Active_Filter$staff_KEY$filter_KEY$descriptionstaff_KEY, filter_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Active_Filter__Filter__filter_KEYfilter_KEYFilter (filter_KEY)
FK_Active_Filter__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram