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_utc | 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 (250) | NOT NULL | Description of where this filter is being used. |
create_date_utc | 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; |