Table: dbo.Filter_Line_Type
Columns
NameTypeConstraintsDescription
filter_line_type_KEYint (4)NOT NULLDatabase assigned primary key for this table.
descriptionnvarchar (60)NOT NULLThe description of this type of critera (overridden by Filter Base Type).
lookup_list_namenvarchar (256)NOT NULLName of the list that provides data for this type of criteria or an empty string.
lookup_value_membernvarchar (256)NOT NULLName of the property in the lookup list to compare to Filter_Base_Type.filter_column or an empty string.
subfilter__filter_type_KEYint (4)A key to a Filter Type if another filter can be used as a method.
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_Line_Typefilter_line_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEYsubfilter__filter_type_KEYFilter_Type (filter_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Base_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Base_Type
FK_Filter_Range_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Range_Type

Schema diagram