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;