Table: dbo.Filter_Range
Columns
Name | Type | Constraints | Description
filter_range_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_base_type_KEY | int (4) | NOT NULL | What this range is based on.
filter_range_type_KEY | int (4) | NOT NULL | What type of range is this.
from_value | nvarchar (60) | NOT NULL | The lesser of the two values.
to_value | nvarchar (60) | NOT NULL | The greater of the two values.
last_refreshed | datetime (8, 3) | NOT NULL | The last time that the Filter Range Cache was refreshed.
create_date | datetime (8, 3) | NOT NULL |

Primary key
Name | Columns | Description
PK_Filter_Range | filter_range_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Filter_Range__Filter_Base_Type__filter_base_type_KEY | filter_base_type_KEY | Filter_Base_Type (filter_base_type_KEY) |
FK_Filter_Range__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_Range_Cache__Filter_Range__filter_range_KEY | filter_range_KEY | Filter_Range_Cache |