Table: dbo.Filter_Range
Columns
NameTypeConstraintsDescription
filter_range_KEYint (4)NOT NULLDatabase assigned primary key for this table.
update__staff_KEYint (4)NOT NULLKey of Staff who last modified this row.
update_datedatetime (8, 3)NOT NULLThe date and time that this row was last modified.
filter_base_type_KEYint (4)NOT NULLWhat this range is based on.
filter_range_type_KEYint (4)NOT NULLWhat type of range is this.
from_valuenvarchar (60)NOT NULLThe lesser of the two values.
to_valuenvarchar (60)NOT NULLThe greater of the two values.
last_refresheddatetime (8, 3)NOT NULLThe last time that the Filter Range Cache was refreshed.
create_datedatetime (8, 3)NOT NULL
Primary key
NameColumnsDescription
PK_Filter_Rangefilter_range_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Range__Filter_Base_Type__filter_base_type_KEYfilter_base_type_KEYFilter_Base_Type (filter_base_type_KEY)
FK_Filter_Range__Filter_Range_Type__filter_range_type_KEYfilter_range_type_KEYFilter_Range_Type (filter_range_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Range_Cache__Filter_Range__filter_range_KEYfilter_range_KEYFilter_Range_Cache

Schema diagram