UserPreferences Table (Platform Only)
The UserPreferences table stores custom properties associated with individual users. These properties allow the system to maintain flexible, user-specific attributes without modifying the core user schema.
The following table describes each field in the UserPreferences table:
| Column Name | Data Type | Required | Description |
|---|---|---|---|
| username | varchar | Yes | The name of the user with a property. |
| property | varchar | Yes | The name of the property associated with a user. |
| propertyvalue | varchar | No | The value of the property associated with a user. |
| createddate | datetime | Yes | The date and time when the property was created. |
| lastmodifieddate | datetime | Yes | The date and time when the property was last modified. |