Table: Filter_Line | |||
Columns | |||
Name | Type | Constraints | Description |
filter_line_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table. |
update__staff_KEY | int | NOT NULL | |
update_date | datetime | NOT NULL | |
filter_KEY | int | NOT NULL | Key to the Filter that this Line is for. |
filter_base_type_KEY | int | NOT NULL | What this line is based on. |
is_method_all | bit | NOT NULL | True when the method is All, false otherwise. |
subfilter__filter_KEY | int | If the method is Filter, the key to the filter; otherwise null. | |
filter_range_type_KEY | int | If the method is Range, Key to a valid range for this base; otherwise null. | |
from_value | nvarchar (100) | NOT NULL | The lesser of the two values. |
to_value | nvarchar (100) | NOT NULL | The greater of the two values. |
create_date | datetime | NOT NULL |
Primary key | |||
Name | Columns | Description | |
PK_Filter_Line$filter_line_KEY | filter_line_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Filter_Line$filter_base_type_KEY | filter_base_type_KEY | Index supports foreign key FK_Filter_Line__Filter_Base_Type__filter_base_type_KEY | |
IX_Filter_Line$filter_KEY | filter_KEY | Index supports foreign key FK_Filter_Line__Filter__filter_KEY | |
IX_Filter_Line$filter_range_type_KEY | filter_range_type_KEY | Index supports foreign key FK_Filter_Line__Filter_Range_Type__filter_range_type_KEY | |
IX_Filter_Line$subfilter__filter_KEY | subfilter__filter_KEY | Index supports foreign key FK_Filter_Line__Filter__subfilter__filter_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Filter_Line__Filter__filter_KEY | filter_KEY | Filter | on delete cascade; |
FK_Filter_Line__Filter__subfilter__filter_KEY | subfilter__filter_KEY | Filter | |
FK_Filter_Line__Filter_Base_Type__filter_base_type_KEY | filter_base_type_KEY | Filter_Base_Type | on delete cascade; |
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEY | filter_range_type_KEY | Filter_Range_Type |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Filter_Select__Filter_Line__filter_line_KEY | filter_line_KEY | Filter_Select | on delete cascade; |