Table: dbo.Filter_Range_Type
Columns
NameTypeConstraintsDescription
filter_range_type_KEYint (4)NOT NULLDatabase assigned primary key for this table.
filter_line_type_KEYint (4)NOT NULLKey to the Filter Line Type this Range Type belongs to.
descriptionnvarchar (60)NOT NULLName of this range as it should appear to the user.
lookup_display_membernvarchar (256)NOT NULLName of the property in the lookup list that has the value that should be used for the range criteria.
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
Primary key
NameColumnsDescription
PK_Filter_Range_Typefilter_range_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Line_Type (filter_line_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line__Filter_Range_Type__filter_range_type_KEYfilter_range_type_KEYFilter_Line
FK_Filter_Range__Filter_Range_Type__filter_range_type_KEYfilter_range_type_KEYFilter_Range

Schema diagram