Table: dbo.Date_Filter_Value_Type
This table defines all of our date filter types for use in the date filter dropdown.
Columns
NameTypeConstraintsDescription
date_filter_value_type_KEYint (4)NOT NULLPrimary Key for this table.
descriptionnvarchar (60)NOT NULLthe description of the Date Filter Value type.
Primary key
NameColumnsDescription
PK_Date_Filter_Value_Typedate_filter_value_type_KEY
Unique constraints
NameColumnsDescription
UK_Date_Filter_Value_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_User_Preference__Date_Filter_Value_Type__view_account_activity_date_filter_value_type_KEYview_account_activity_date_filter_value_type_KEYUser_Preference

Schema diagram