Skip to main content

Define Relationships between Data Collections

Data in Conscia is modeled as a graph, which means that data is interconnected and has relationships. Relationships not only allow for data to be associated with one or multiple data records, but also serves as a pathway for exploring data.

alt_text

Types of Relationships

There are three types of relationships within the Conscia

  1. 1-to-1 Lookup Relationship
  2. 1-to-Many Lookup Relationship
  3. Dynamic Relationships

Lookup Relationships (1:1 / 1:M)

  • This is the most basic type of relationship where a record within a collection is mapped to another record in a different collection. An example might be a record which contains a "status" code, but the status descriptor needs to be pulled from another collection.
  • Lookup relationships may be a one to one mapping or may be in the form of 1-to-Many where a single record may contain a relationship to many other records. An example might be a property record that contains references to multiple apartments within the property.

Dynamic Relationships

  • Using an expression to relate data records in one collection to data records in another collection, dynamic relationships are used to create links between otherwise unrelated records.

alt_text

In this example, the Apartments collection has several relationships, including:

PropertiesThis is a 1:1 relationship that allows each apartment record to contain the building (property) name
AmenitiesThis is a 1:M relationship allowing an apartment to contain many amenities
Price RangeThis is a 1:M relationship where the price of the apartment can belong to multiple price buckets (ranges)
PropertyThis is a dynamic relationship that directly connects the apartment to the property. When rendering the details of the apartment, full details from the property are also accessible.

Viewing Relationships

Relationships are defined as part of a collections configuration. Power users can view the relationship(s) configuration for a collection in the DX Graph UI:

  1. Select SETTINGS > DATA MODEL from the main navigation
  2. From the list of data collections, select a collection by right clicking the record.
  3. From the inline menu, select EDIT > RELATIONSHIPS

alt_text

  1. Explore the different relationships by selecting a relationship type from the dropdown menu in the top right of the modal.

alt_text

  1. For any relationship, clicking on the arrow will expand the details of the relationship.

alt_text