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