Subscribe rss
Blog categories
All | Backendless features
Feature 8: Create data table schema in Backendless console
January 13, 2015 by markpiller
Spread the love

In the previous feature highlight I described how to manually create data tables in Backendless console. In this post I will show how to setup 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.
  • Validator – validates data in the property using either a built-in or custom (regular expression validator).

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 Table Schema and Permissions button in the upper right corner of the interface.
  3. Once you are in the schema editor tool (which is identified by the Edit Schema menu), you can inspect the existing table columns or add new ones.
  4. To add a column, click the Add Column button. You will see the following popup:
    add column popup - Feature 8: Create data table schema in Backendless console
  5. Enter a name for the column and select the data type. 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 Save to create the column.

Schema management includes a lot more tasks than just creating table columns. In the future posts we will be reviewing the following:

  • Configuring validators.
  • Configuring default values.
  • Renaming/deleting columns and relationships.
  • Creating relationships with other data tables.
  • Creating relationships with Geopoints.
Share this post
Tweet about this on TwitterShare on FacebookGoogle+