User property


Contents

Description

Defines user-specific properties. Properties are loosely defined as name-value pairs: property and property_value, respectively. The properties stored for a user are decided by the application. User properties can be used, for example, to persist user-specific settings (like user interface preferences).

Attributes

Column Name Type Default Description
Primary Key user_id int Internal id of the user
Primary Key property varchar(100) Name of the property being defined. Property names must be unique for a given user — i.e., the same property name cannot be used twice for the same user. To store more than one value for the same property, then the value should be set to an XML snippet or delimited list of values.
Required property_value varchar(255) Value for the user-specific property.
Primary Key primary key, Required required