The user data table is built from columns and populated with user records. Each column has a primitive type (describing what the column stores, like string or boolean) and a logical type (describing what the column represents, like address or phone number). Columns can store a single data value or multiple values, in which case they are called array columns.
Columns can be managed via the UI, or programmatically via the API.
Columns can be managed in the User Store page of UserClouds Console.
To add a column, go to the User Store page (pictured above), click Edit Columns and then click Add Column. You will be prompted to define:
- A column name
- A column type
- Whether the column is a single-value column or an array column (which can hold multiple values)
- Whether the column is unique
- Whether the column is indexed
- A default column value
Unique columns are always indexed, and cannot have a default value.
The only column characteristics that are mutable are (1) whether the column is indexed and (2) the default value. To change either setting in the UI, click Edit Columns, edit the value in question in line, then click "Save Changes".
To delete a column in the UI, go the User Store page, click Edit Columns, and click the Trash icon on the right hand side, then click "Save Changes".
To learn how to manage columns via the UserClouds API, consult our API Reference.
Updated about 2 months ago