Table: dbo.Journal_Filter_Value_Type
This table defines all of our journal filter types for use in the journal filter dropdown.
Columns
NameTypeConstraintsDescription
journal_filter_value_type_KEYint (4)NOT NULLPrimary Key for this table.
descriptionnvarchar (60)NOT NULLthe description of the Journal Filter Value type.
Primary key
NameColumnsDescription
PK_Journal_Filter_Value_Typejournal_filter_value_type_KEY
Unique constraints
NameColumnsDescription
UK_Journal_Filter_Value_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_User_Preference__Journal_Filter_Value_Type__view_account_activity_journal_filter_value_type_KEYview_account_activity_journal_filter_value_type_KEYUser_Preference

Schema diagram