Table: Active_Filter
This table keeps track of filters used in CommonDropDownList controls.
Columns
Name | Type | Constraints | Description
active_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 |
staff_KEY | int | NOT NULL | Key to the Staff this filter is in use by.
filter_KEY | int | NOT NULL | Key to the Filter being used for this Staff and description.
description | nvarchar (30) | NOT NULL | Description of where this filter is being used.
create_date | datetime | NOT NULL |

Primary key
Name | Columns | Description
PK_Active_Filter$active_filter_KEY | active_filter_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Active_Filter__staff_KEY__filter_KEY__description | staff_KEY, filter_KEY, description |
Indexes
Name | Columns | Description
IX_Active_Filter$filter_KEY | filter_KEY | Index supports foreign key FK_Active_Filter__Filter__filter_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Active_Filter__Filter__filter_KEY | filter_KEY | Filter | on delete cascade;
FK_Active_Filter__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;