| 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) | |