Table: Filter_Base_Type
Columns
NameTypeConstraintsDescription
filter_base_type_KEYintNOT NULLDatabase assigned primary key for this table.
filter_type_KEYintNOT NULLKey to the Filter Type that this Filter Base Type belongs to.
filter_line_type_KEYintNOT NULLKey to the type of criteria that this Filter Base Type uses.
descriptionnvarchar (300)NOT NULLDescription that is presented to the user.
filter_columnnvarchar (512)NOT NULLName of the property in Filter_Type.list_name that values will be compared to.
update__staff_KEYintNOT NULL
update_datedatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Filter_Base_Type$filter_base_type_KEYfilter_base_type_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Filter_Base_Type$filter_line_type_KEYfilter_line_type_KEYIndex supports foreign key FK_Filter_Base_Type__Filter_Line_Type__filter_line_type_KEY
IX_Filter_Base_Type$filter_type_KEYfilter_type_KEYIndex supports foreign key FK_Filter_Base_Type__Filter_Type__filter_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Filter_Base_Type__Filter_Line_Type__filter_line_type_KEYfilter_line_type_KEYFilter_Line_Type
FK_Filter_Base_Type__Filter_Type__filter_type_KEYfilter_type_KEYFilter_Type
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Filter_Line__Filter_Base_Type__filter_base_type_KEYfilter_base_type_KEYFilter_Lineon delete cascade;

Schema diagram