Preferences


Description

User and system preferences that store customizable settings and preferences for users and system-wide configurations to personalize the user experience.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
IsUserConfigurable Unknown 0 null

User configurable - Whether users can modify this preference

prefDesc varchar 100 null

Description field - Detailed description or explanation of Preferences information

PreferenceId Unknown 0 null

Primary key - Preferences unique identifier for each preference setting

PreferenceName Unknown 0 null

Preference name - Name of the preference setting

PreferenceType Unknown 0 null

Preference type - Data type of the preference value

PreferenceValue Unknown 0 null

Preference value - Value of the preference setting

prefID int identity 4 null

Reference identifier - Foreign key reference to related entity or lookup table

UserId Unknown 0 null

User reference - Reference to the user (null for system-wide preferences)

Indexes

Constraint Name Type Sort Column(s)
PK__Preferences__1D314762 Primary key Asc prefID

Relationships