Relations

Relations are used for linking instances of different classes to each other. This is indispensable for any kind of business intelligence and document or object management system.

Relations help to establish navigation between various class instance lists, dashboards, and other UI components.

The following types of relations are available:

One-to-Many

In this case one instance of class A is linked to many instances of class B. Technically, in this case class B defines a field with type Long that contains an ID of class A instance. Field name and description constitute relation name. This field uses the Foreign Class Instance editor which allows the selection of an instance of class A once an instance of class B is being edited. An instance dashboard of class A may include a list of linked class B instances.

Information about a one-to-many link from class A to class B stored as a dedicated database table field in the table that keeps class B instances.

Many-to-Many

In this case, each instance of class A can be linked to multiple instances of class B and simultaneously each instance of class B may be linked to multiple instances of class A, using the same relation. Relation name and parameters are defined in the Many-to-Many relations table.

If a many-to-many relation is defined, a class instance dashboard for class A may contain a list of related class B instances and vice versa. To remove relations from an instance, select it in a Class Data Table with the related instances in a Class Instance dashboard, and click the Delete button.

If classes are mapped to a relational storage, a separate database table is created to contain links defined by each many-to-many relation.

Was this page helpful?