Table: dbo.Filter_Selection
Table used to store information about filters in use during the last user session.
Columns
NameTypeConstraintsDescription
filter_selection_KEYint (4)NOT NULLUnique primary key for the table.
staff_KEYint (4)NOT NULLForeign key to the associated staff KEY
filter_selection_type_KEYint (4)NOT NULLForeign key to the associated filter selection type KEY.
filter_KEYint (4)NOT NULLForeign key to the associated filter KEY.
Primary key
NameColumnsDescription
PK_Filter_Selectionfilter_selection_KEY
Unique constraints
NameColumnsDescription
UK_Filter_Selection$staff_KEY$filter_selection_type_KEYstaff_KEY, filter_selection_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Selection__Filter__filter_KEYfilter_KEYFilter (filter_KEY)
FK_Filter_Selection__Filter_Selection_Type__filter_selection_type_KEYfilter_selection_type_KEYFilter_Selection_Type (filter_selection_type_KEY)
FK_Filter_Selection__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram