Table: dbo.Filter_Line
Columns
Name | Type | Constraints | Description
filter_line_KEY | int (4) | NOT NULL | Database assigned primary key for this table.
update__staff_KEY | int (4) | NOT NULL | Key of Staff who last modified this row.
update_date | datetime (8, 3) | NOT NULL | The date and time that this row was last modified.
filter_KEY | int (4) | NOT NULL | Key to the Filter that this Line is for.
filter_base_type_KEY | int (4) | NOT NULL | What this line is based on.
is_method_all | bit (1) | NOT NULL | True when the method is All, false otherwise.
subfilter__filter_KEY | int (4) |  | If the method is Filter, the key to the filter; otherwise null.
filter_range_type_KEY | int (4) |  | If the method is Range, Key to a valid range for this base; otherwise null.
from_value | nvarchar (200) | NOT NULL | The lesser of the two values.
to_value | nvarchar (200) | NOT NULL | The greater of the two values.
create_date | datetime (8, 3) | NOT NULL |

Primary key
Name | Columns | Description
PK_Filter_Line | filter_line_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Filter_Line__Filter__filter_KEY | filter_KEY | Filter (filter_KEY) |
FK_Filter_Line__Filter__subfilter__filter_KEY | subfilter__filter_KEY | Filter (filter_KEY) |
FK_Filter_Line__Filter_Base_Type__filter_base_type_KEY | filter_base_type_KEY | Filter_Base_Type (filter_base_type_KEY) |
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEY | filter_range_type_KEY | Filter_Range_Type (filter_range_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Filter_Select__Filter_Line__filter_line_KEY | filter_line_KEY | Filter_Select |