Message:

Subscribe rss
Blog categories
All | Backendless features
Feature 11: Declaring relations between tables (classes) using developer console
January 17, 2015 by markpiller
Spread the love

In my of my previous posts I described how to add columns/properties to a Backendless table/class using console. The types of properties reviewed in that post were all primitive: string, numbers, dates or boolean values. In addition to these data types, Backendless also supports relationships between objects stored in its persistent storage. These relationships are classic composition types in the object-oriented world. That means a table may declare a property (column) which references either one or a collection of objects from another (or the same) table. When these objects are materialized on the client-side (assuming the language supports object-oriented programming), the properties simply reference related objects. Consider the following example:

There are two classes Restaurant and Location. An instance of Restaurant contains a collection of Location objects:

Location class:

Restaurant class:

Backendless stores instances of these classes in tables named after the class name: Restaurant and Location. If at the time when an instance is being saved the table does not exist, Backendless creates it automatically. We refer to that approach as “code first”. However, you can also pre-create the tables and explicitly declare the relationships between them. This (“schema first”) approach has its own benefits which will be discussed at a later point.

The instructions below demonstrate how to create the same relationship which you can see in the code above. It assumes you already created the Restaurant and Location tables:

  1. Login to console, select your app and click the Data icon.
  2. Select the Restaurant table and click the Table Schema and Permission button located in the upper right corner of the user interface.
  3. Click the Add Column button.
  4. In the popup enter “locations” for the column name and select the Location table in the Related table drop down box. Also make sure to select One-to-Many for the Cardinality drop down box. The popup should look as shown in the image below:
    adding locations columns - Feature 11: Declaring relations between tables (classes) using developer console
  5. Click the Save button.
  6. The relation between the tables is saved and shows up as one of the columns in the Restaurant table:
    locations columns - Feature 11: Declaring relations between tables (classes) using developer console

Once the relationship is declared, you can use it to link objects together using console, it will also be used by the Backendless code generator when creating client-side classes based on storage schema. These and many other related features will be discussed in this feature-a-day series.

Share this post
Tweet about this on TwitterShare on FacebookGoogle+