Table: Active_Filter
This table keeps track of filters used in CommonDropDownList controls.
Columns
NameTypeConstraintsDescription
active_filter_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintNOT NULLKey to the Staff this filter is in use by.
filter_KEYintNOT NULLKey to the Filter being used for this Staff and description.
descriptionnvarchar (250)NOT NULLDescription of where this filter is being used.
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Active_Filter$active_filter_KEYactive_filter_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Active_Filter$staff_KEY$filter_KEY$descriptionstaff_KEY, filter_KEY, description
Indexes
NameColumnsDescription
IX_Active_Filter$filter_KEYfilter_KEYIndex supports foreign key FK_Active_Filter__Filter__filter_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Active_Filter__Filter__filter_KEYfilter_KEYFilteron delete cascade;
FK_Active_Filter__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram