Table: dbo.Filter
Columns
Name | Type | Constraints | Description
filter_KEY | int (4) | NOT NULL | Database assigned primary key for this table.
update__staff_KEY | int (4) | NOT NULL | Key of Staff who last modified this row.
update_date | datetime (8, 3) | NOT NULL | The date and time that this row was last modified.
filter_type_KEY | int (4) | NOT NULL | Key to a Filter Type record.
description | nvarchar (500) | NOT NULL | User defined description (unique per filter_type_KEY).
match_all | bit (1) | NOT NULL | Use AND logic when true, OR logic when false.
create_date | datetime (8, 3) | NOT NULL |

Primary key
Name | Columns | Description
PK_Filter | filter_KEY |
Unique constraints
Name | Columns | Description
UK_Filter$filter_type_KEY$description | filter_type_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Filter__Filter_Type__filter_type_KEY | filter_type_KEY | Filter_Type (filter_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Filter_Line__Filter__filter_KEY | filter_KEY | Filter_Line |
FK_Filter_Line__Filter__subfilter__filter_KEY | subfilter__filter_KEY | Filter_Line |
FK_Filter_Selection__Filter__filter_KEY | filter_KEY | Filter_Selection |
FK_Active_Filter__Filter__filter_KEY | filter_KEY | Active_Filter |