How to define a data table schema in Backendless Console

by on January 13, 2015

In a previous feature, I described how to manually create data tables in Backendless Console. In this post, I will show how to set up a data table schema. A table schema in Backendless is a collection of table columns. Each column may have the following attributes:

  • Column name – identifies the column in the table and becomes a property in the objects saved in the table.
  • Data type – determines the type of data which can be stored in the corresponding object property. Available data types are: string (up to 500 characters), text (up to 3000 characters), datetime, integer, double, boolean.
  • Default value – when an object is stored and the property does not contain a value, Backendless assigns and stores the specified default value.
  • Validatorvalidates data in the property using either a built-in or custom (regular expression validator).
  • Constraints – defines the restrictions for the column, such as that it must be unique, contain non-null values, etc.

To access the schema editor tool:

  1. Login to Backendless console, select your app and click the Data icon.
  2. Select the table you would like to edit the schema for and click the SCHEMA tab:
  3. When you are in the schema editor tool, you can inspect the existing table columns or add new ones.
  4. To add a column, click the New button. You will see the following popup:
  5. Enter a name for the column and select the data type for the Type field. If you are not sure about the default value or the validator, ignore those fields for now – we will be reviewing them in future posts.
  6. Click CREATE to create the column.

Schema management includes a lot more tasks than just creating table columns. In other Recipe posts, you can learn about:

  • Configuring validators.
  • Configuring default values.
  • Renaming/deleting columns and relationships.
  • Creating relationships with other data tables.
  • Creating relationships with Geopoints.
  • Creating relationships with Files.
  • Configuring constraints.