Table: Filter_Line
Columns
NameTypeConstraintsDescription
filter_line_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
filter_KEYintNOT NULLKey to the Filter that this Line is for.
filter_base_type_KEYintNOT NULLWhat this line is based on.
is_method_allbitNOT NULLTrue when the method is All, false otherwise.
subfilter__filter_KEYintIf the method is Filter, the key to the filter; otherwise null.
filter_range_type_KEYintIf the method is Range, Key to a valid range for this base; otherwise null.
from_valuenvarchar (100)NOT NULLThe lesser of the two values.
to_valuenvarchar (100)NOT NULLThe greater of the two values.
create_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Filter_Line$filter_line_KEYfilter_line_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Filter_Line$filter_base_type_KEYfilter_base_type_KEYIndex supports foreign key FK_Filter_Line__Filter_Base_Type__filter_base_type_KEY
IX_Filter_Line$filter_KEYfilter_KEYIndex supports foreign key FK_Filter_Line__Filter__filter_KEY
IX_Filter_Line$filter_range_type_KEYfilter_range_type_KEYIndex supports foreign key FK_Filter_Line__Filter_Range_Type__filter_range_type_KEY
IX_Filter_Line$subfilter__filter_KEYsubfilter__filter_KEYIndex supports foreign key FK_Filter_Line__Filter__subfilter__filter_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Line__Filter__filter_KEYfilter_KEYFilteron delete cascade;
FK_Filter_Line__Filter__subfilter__filter_KEYsubfilter__filter_KEYFilter
FK_Filter_Line__Filter_Base_Type__filter_base_type_KEYfilter_base_type_KEYFilter_Base_Typeon delete cascade;
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEYfilter_range_type_KEYFilter_Range_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Select__Filter_Line__filter_line_KEYfilter_line_KEYFilter_Selecton delete cascade;

Schema diagram