Table: dbo.Filter_Line
Columns
NameTypeConstraintsDescription
filter_line_KEYint (4)NOT NULLDatabase assigned primary key for this table.
update__staff_KEYint (4)NOT NULLKey of Staff who last modified this row.
update_datedatetime (8, 3)NOT NULLThe date and time that this row was last modified.
filter_KEYint (4)NOT NULLKey to the Filter that this Line is for.
filter_base_type_KEYint (4)NOT NULLWhat this line is based on.
is_method_allbit (1)NOT NULLTrue when the method is All, false otherwise.
subfilter__filter_KEYint (4)If the method is Filter, the key to the filter; otherwise null.
filter_range_type_KEYint (4)If the method is Range, Key to a valid range for this base; otherwise null.
from_valuenvarchar (200)NOT NULLThe lesser of the two values.
to_valuenvarchar (200)NOT NULLThe greater of the two values.
create_datedatetime (8, 3)NOT NULL
Primary key
NameColumnsDescription
PK_Filter_Linefilter_line_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Line__Filter__filter_KEYfilter_KEYFilter (filter_KEY)
FK_Filter_Line__Filter__subfilter__filter_KEYsubfilter__filter_KEYFilter (filter_KEY)
FK_Filter_Line__Filter_Base_Type__filter_base_type_KEYfilter_base_type_KEYFilter_Base_Type (filter_base_type_KEY)
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEYfilter_range_type_KEYFilter_Range_Type (filter_range_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Select__Filter_Line__filter_line_KEYfilter_line_KEYFilter_Select

Schema diagram