Table: Filter
Columns
NameTypeConstraintsDescription
filter_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
filter_type_KEYintNOT NULLKey to a Filter Type record.
descriptionnvarchar (250)NOT NULLUser defined description (unique per filter_type_KEY).
match_allbitNOT NULLUse AND logic when true, OR logic when false.
create_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Filter$filter_KEYfilter_KEYCLUSTERED
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
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line__Filter__filter_KEYfilter_KEYFilter_Lineon delete cascade;
FK_Filter_Line__Filter__subfilter__filter_KEYsubfilter__filter_KEYFilter_Line
FK_Active_Filter__Filter__filter_KEYfilter_KEYActive_Filteron delete cascade;
FK_Project_Template__Filter__staff_qualifications__filter_KEYstaff_qualifications__filter_KEYProject_Template
FK_Outlook_Contact_Synchronization_Folder__Filter__filter_KEYfilter_KEYOutlook_Contact_Synchronization_Folderon delete cascade;
FK_Task_Template__Filter__staff_qualifications__filter_KEYstaff_qualifications__filter_KEYTask_Template
FK_User_Preference__Filter__entry_remote_time_entry__filter_KEYentry_remote_time_entry__filter_KEYUser_Preference
FK_User_Preference__Filter__urgent__filter_KEYurgent__filter_KEYUser_Preferenceon delete set null;
FK_Schedule_Item__Filter__staff_qualifications__filter_KEYstaff_qualifications__filter_KEYSchedule_Item

Schema diagram