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 |