Table: dbo.Filter_Base_Type
Columns
NameTypeConstraintsDescription
filter_base_type_KEYint (4)NOT NULLDatabase assigned primary key for this table.
filter_type_KEYint (4)NOT NULLKey to the Filter Type that this Filter Base Type belongs to.
filter_line_type_KEYint (4)NOT NULLKey to the type of criteria that this Filter Base Type uses.
descriptionnvarchar (120)NOT NULLDescription that is presented to the user.
filter_columnnvarchar (1024)NOT NULLName of the property in Filter_Type.list_name that values will be compared to.
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_Base_Typefilter_base_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Base_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Line_Type (filter_line_type_KEY)
FK_Filter_Base_Type__Filter_Type__filter_type_KEYfilter_type_KEYFilter_Type (filter_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line__Filter_Base_Type__filter_base_type_KEYfilter_base_type_KEYFilter_Line
FK_Filter_Range__Filter_Base_Type__filter_base_type_KEYfilter_base_type_KEYFilter_Range

Schema diagram