​
JoinInput

Input type for specifying join relationships between tables when updating data sources in a domain.
​
leftTable
TableInput!
required
The left table in the join relationship. See TableInput.
​
rightTable
TableInput!
required
The right table in the join relationship. See TableInput.
​
relationshipType
RelationshipType!
required
The type of relationship between the tables. See RelationshipType.
​
joinConditions
[JoinConditionInput!]!
required
List of join conditions that define how the tables are connected. See JoinConditionInput.

​
JoinConditionInput

Defines a single join condition between two table columns.
​
leftColumnName
String!
required
The name of the column in the left table to join on.
​
rightColumnName
String!
required
The name of the column in the right table to join on.

​
RelationshipType

Enum defining the cardinality relationship between joined tables. Values:
  • RELATIONSHIP_TYPE_UNKNOWN - Relationship type is not specified or unclear
  • ONE_TO_ONE - Each record in left table matches exactly one record in right table
  • ONE_TO_MANY - Each record in left table can match multiple records in right table
  • MANY_TO_ONE - Multiple records in left table can match one record in right table
  • MANY_TO_MANY - Multiple records in left table can match multiple records in right table

Update Data Sources

Use JoinInput to define table relationships

TableInput Schema

Configure tables that participate in joins

DomainModel Schema

Understand how joins fit within domain structure

Create Domain

Start with domain creation before adding joins