Table: dbo.Active_Filter
Columns
Name | Type | Constraints | Description
active_filter_KEY | int (4) | NOT NULL | Database assigned primary key for this table
staff_KEY | int (4) | NOT NULL | Key to the Staff this filter is in use by.
filter_KEY | int (4) | NOT NULL | Key to the Filter being used for this Staff and description.
description | nvarchar (60) | NOT NULL | Description of where this filter is being used.

Primary key
Name | Columns | Description
PK_Active_Filter | active_filter_KEY |
Unique constraints
Name | Columns | Description
UK_Active_Filter$staff_KEY$filter_KEY$description | staff_KEY, filter_KEY, description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Active_Filter__Filter__filter_KEY | filter_KEY | Filter (filter_KEY) |
FK_Active_Filter__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |