Table: dbo.Filter
Columns
NameTypeConstraintsDescription
filter_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_type_KEYint (4)NOT NULLKey to a Filter Type record.
descriptionnvarchar (500)NOT NULLUser defined description (unique per filter_type_KEY).
match_allbit (1)NOT NULLUse AND logic when true, OR logic when false.
create_datedatetime (8, 3)NOT NULL
Primary key
NameColumnsDescription
PK_Filterfilter_KEY
Unique constraints
NameColumnsDescription
UK_Filter$filter_type_KEY$descriptionfilter_type_KEY, description
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter__Filter_Type__filter_type_KEYfilter_type_KEYFilter_Type (filter_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line__Filter__filter_KEYfilter_KEYFilter_Line
FK_Filter_Line__Filter__subfilter__filter_KEYsubfilter__filter_KEYFilter_Line
FK_Filter_Selection__Filter__filter_KEYfilter_KEYFilter_Selection
FK_Active_Filter__Filter__filter_KEYfilter_KEYActive_Filter

Schema diagram