Table: Filter_Select
Columns
NameTypeConstraintsDescription
filter_select_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
filter_line_KEYintNOT NULLKey of the Filter Line this value is for.
selectedintNOT NULLThe value of the primary key for the selected item.
create_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Filter_Select$filter_select_KEYfilter_select_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Filter_Select$filter_line_KEYfilter_line_KEYIndex supports foreign key FK_Filter_Select__Filter_Line__filter_line_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Select__Filter_Line__filter_line_KEYfilter_line_KEYFilter_Lineon delete cascade;

Schema diagram