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 |