FieldRelationships
Stores metadata about relationship fields within a table, identifying how objects are linked and the types of records they can reference.
Columns
| Name | Type | References | Description |
| Name [KEY] | String | API name of the field that defines the relationship, such as AccountId or OwnerId. | |
| ReferenceTo [KEY] | String | Name of the target object or table that this relationship field refers to. | |
| RelationshipName [KEY] | String | API name used to access the related object from this field, typically used in queries or code. | |
| Label | String | User-facing label for the relationship field, as displayed in the Salesforce UI. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| TableName | String | The name of the table to retrieve relationship information from. |