| 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 | |