Manage your columns

Introduction

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.

Managing Columns in the UI

Columns can be managed in the User Store page of UserClouds Console.

Adding Columns

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.

Updating Columns

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".

Deleting Columns

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".

Managing Columns via the API

To learn how to manage columns via the UserClouds API, consult our API Reference.