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 |