| Table: dbo.Filter_Selection | |||
| Table used to store information about filters in use during the last user session. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| filter_selection_KEY | int (4) | NOT NULL | Unique primary key for the table. |
| staff_KEY | int (4) | NOT NULL | Foreign key to the associated staff KEY |
| filter_selection_type_KEY | int (4) | NOT NULL | Foreign key to the associated filter selection type KEY. |
| filter_KEY | int (4) | NOT NULL | Foreign key to the associated filter KEY. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Filter_Selection | filter_selection_KEY | ||
| Unique constraints | |||
| Name | Columns | Description | |
| UK_Filter_Selection$staff_KEY$filter_selection_type_KEY | staff_KEY, filter_selection_type_KEY | ||