Table: User_Preference_Custom_Field_Column
Contains records for the User Preference settings for Custom Fields
Columns
NameTypeConstraintsDescription
user_preference_KEYintNOT NULLKey of the User Preference that this entry is for
custom_field_KEYintNOT NULLKey of the Custom Field that this entry is for
skip_columnbitNOT NULLWhether or not this field should be skipped in Time and expense entry
hide_columnbitNOT NULLWhether or not this field should be hidden in Time and expense entry
hide_description_columnbitNOT NULLWhether or not the description column related to this field should be hidden in Time and expense entry
default_valuenvarchar (4000)NOT NULLThe default value for this field in Time and expense entry
Primary key
NameColumnsDescription
PK_User_Preference_Custom_Field_Column$user_preference_KEY$custom_field_KEYuser_preference_KEY, custom_field_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_User_Preference_Custom_Field_Column$custom_field_KEYcustom_field_KEYIndex supports foreign key FK_User_Preference_Custom_Field_Column__Custom_Field__custom_field_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_User_Preference_Custom_Field_Column__Custom_Field__custom_field_KEYcustom_field_KEYCustom_Fieldon delete cascade;
FK_User_Preference_Custom_Field_Column__User_Preference__user_preference_KEYuser_preference_KEYUser_Preferenceon delete cascade;

Schema diagram