Relationship dataset for the JSON data schema
Learn about the relationship dataset for JSON.
This table holds data for all relationships. Use these datasets to view your relationship metadata.
| Field | Description | Data type/Mode |
|---|---|---|
| Uri | The universal resource identifier. It is in the format Example: For relationships, the | Data type: STRING Mode: NULLABLE |
| Type | The relationship type in Reltio. | Data type: STRING Mode: NULLABLE |
| Id | The relationship identifier in Reltio. | Data type: STRING Mode: NULLABLE |
| createdTime | The timestamp when the relationship is created in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| createdBy | The user who created the relationship. | Data type: STRING Mode: NULLABLE |
| updatedTime | The timestamp when the relationship is last updated in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| updatedBy | The user who last updated the relationship. | Data type: STRING Mode: NULLABLE |
| deletedTime | The time when the relationship is deleted. | Data type: TIMESTAMP Mode: NULLABLE |
| deleted | An indicator that tells you whether the relationship is deleted or not. | Data type: BOOLEAN Mode: NULLABLE |
| startDate | The date when the relationship is created in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| endDate | The date when the relationship is marked for a soft delete, if it is already deleted, in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| eventTime | The time when an event is logged in Reltio. | Data type: TIMESTAMP Mode: NULLABLE |
| insertedTime | The time when an relationship is inserted in the GBQ table. | Data type: TIMESTAMP Mode: NULLABLE |
| versionTime | The object version in Reltio. | Data type: INTEGER Mode: NULLABLE |
| conflictedAttributes | The location of all attributes that are currently not in the attributes schema. After the tables are deleted and data is resynchronized, these values are added to the attribute column in the attributes schema. | Data type: STRING Mode: NULLABLE |
| Start | An object that has one property ID of the start object in the relationship (start object configured in L3). You can access the property ID using Start.Id . | Data type: RECORD Mode: NULLABLE |
| End | An object that has one property ID of the end object in the relationship (end object configured in L3). You can access the property ID using End.Id. | Data type: RECORD Mode: NULLABLE |
| crosswalks | A representation of the crosswalks of an object in Reltio. For more information, see topic crosswalks schema. | Data type: RECORD Mode: REPEATED |
| tags | The location of all tags that can be applied to the relationship. | Data type: STRING Mode: REPEATED |
| attributes | The location of the relationship's attribute information in JSON format. | Data type: JSON Mode: NULLABLE |
| Field | Description | GBQ type/GBQ mode |
|---|---|---|
| value | The crosswalk value. | GBQ type: STRING GBQ mode: NULLABLE |
| attributes | The list of attribute Uris that belong to the crosswalk. | GBQ type: STRING GBQ mode: REPEATED |
| Uri | The crosswalk's Universal resource identifier. | GBQ type: STRING GBQ mode: NULLABLE |
| createDate | The timestamp when the crosswalk is created in Reltio. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| updateDate | The timestamp when the crosswalk is last updated in Reltio. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| deleteDate | The timestamp when the crosswalk is deleted. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| reltioLoadDate | The timestamp when the crosswalk is loaded in Reltio. | GBQ type: TIMESTAMP GBQ mode: NULLABLE |
| source | The crosswalk source. | GBQ type: STRING GBQ mode: NULLABLE |
| sourceTable | The crosswalk source table. | GBQ type: STRING GBQ mode: NULLABLE |
| refEntityOrRelationId | The identifier of the relation that is used as a source for the reference attribute. | GBQ type: STRING GBQ mode: NULLABLE |