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).
Constraints – defines the restrictions for the column, such as that it must be unique, contain non-null values, etc.
Select the table you would like to edit the schema for and click the SCHEMA tab:
When you are in the schema editor tool, you can inspect the existing table columns or add new ones.
To add a column, click the New button. You will see the following popup:
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.
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:
Learn the ins and outs of Backendless Database, our robust and scalable visual relational DB, with this free video course from Backendless CEO Mark Piller. New videos released weekly, so leave your feedback to shape future parts!
Today, Bubble announced a major change in their pricing structure. Intended to make their pricing “more predictable and easier to understand”, the reality was clear to their community: Bubble is simply not scalable anymore.
All Backendless apps have the ability to add a single custom domain for app hosting and API endpoints. Now, with the Springboard and Cloud 99 plans, you may add additional custom domains to your application. Upon creation, every new Backendless application is assigned a subdomain under the backendless.app domain. By default, this subdomain is the…