Table: Filter
Columns
Name | Type | Constraints | Description
filter_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
filter_type_KEY | int | NOT NULL | Key to a Filter Type record.
description | nvarchar (250) | NOT NULL | User defined description (unique per filter_type_KEY).
match_all | bit | NOT NULL | Use AND logic when true, OR logic when false.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Filter$filter_KEY | filter_KEY | CLUSTERED
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 |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Filter_Line__Filter__filter_KEY | filter_KEY | Filter_Line | on delete cascade;
FK_Filter_Line__Filter__subfilter__filter_KEY | subfilter__filter_KEY | Filter_Line |
FK_Active_Filter__Filter__filter_KEY | filter_KEY | Active_Filter | on delete cascade;
FK_Project_Template__Filter__staff_qualifications__filter_KEY | staff_qualifications__filter_KEY | Project_Template |
FK_Outlook_Contact_Synchronization_Folder__Filter__filter_KEY | filter_KEY | Outlook_Contact_Synchronization_Folder | on delete cascade;
FK_Task_Template__Filter__staff_qualifications__filter_KEY | staff_qualifications__filter_KEY | Task_Template |
FK_User_Preference__Filter__entry_remote_time_entry__filter_KEY | entry_remote_time_entry__filter_KEY | User_Preference |
FK_User_Preference__Filter__urgent__filter_KEY | urgent__filter_KEY | User_Preference | on delete set null;
FK_Schedule_Item__Filter__staff_qualifications__filter_KEY | staff_qualifications__filter_KEY | Schedule_Item |