Table: dbo.Filter_Type
Columns
NameTypeConstraintsDescription
list_namenvarchar (256)NOT NULLName of the list that this type of filter limits.
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
descriptionnvarchar (60)NOT NULLUser friendly name for this type of filter.
filter_type_KEYint (4)NOT NULL
Primary key
NameColumnsDescription
PK_Filter_Typefilter_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line_Type__Filter_Type__subfilter__filter_type_KEYsubfilter__filter_type_KEYFilter_Line_Type
FK_Filter__Filter_Type__filter_type_KEYfilter_type_KEYFilter
FK_Filter_Base_Type__Filter_Type__filter_type_KEYfilter_type_KEYFilter_Base_Type

Schema diagram