Table: User_Preference_Custom_Field_Column | |||
Contains records for the User Preference settings for Custom Fields | |||
Columns | |||
Name | Type | Constraints | Description |
user_preference_KEY | int | NOT NULL | Key of the User Preference that this entry is for |
custom_field_KEY | int | NOT NULL | Key of the Custom Field that this entry is for |
skip_column | bit | NOT NULL | Whether or not this field should be skipped in Time and expense entry |
hide_column | bit | NOT NULL | Whether or not this field should be hidden in Time and expense entry |
hide_description_column | bit | NOT NULL | Whether or not the description column related to this field should be hidden in Time and expense entry |
default_value | nvarchar (4000) | NOT NULL | The default value for this field in Time and expense entry |
Primary key | |||
Name | Columns | Description | |
PK_User_Preference_Custom_Field_Column$user_preference_KEY$custom_field_KEY | user_preference_KEY, custom_field_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_User_Preference_Custom_Field_Column$custom_field_KEY | custom_field_KEY | Index supports foreign key FK_User_Preference_Custom_Field_Column__Custom_Field__custom_field_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_User_Preference_Custom_Field_Column__Custom_Field__custom_field_KEY | custom_field_KEY | Custom_Field | on delete cascade; |
FK_User_Preference_Custom_Field_Column__User_Preference__user_preference_KEY | user_preference_KEY | User_Preference | on delete cascade; |