Relation Table Structure

In the MDM tenant, when a relation is created, updated or deleted, a new record with all the data is written into a partition and the date appended using the eventTime parameter.

Note: insertedTime is an internal field.
The Table 1 : GBQ Relation Table contains the following data:
Table 1. Table 1 : GBQ Relation Table
Field name Type Mode
crosswalks RECORD REPEATED
crosswalks. value STRING NULLABLE
crosswalks. attributes STRING REPEATED
crosswalks. Uri STRING NULLABLE
crosswalks. updatedDate TIMESTAMP NULLABLE
crosswalks .deleteDate TIMESTAMP NULLABLE
crosswalks. reltioLoadDate TIMESTAMP NULLABLE
crosswalks. source STRING NULLABLE
crosswalks. sourceTable STRING NULLABLE
crosswalks. createDate TIMESTAMP NULLABLE
crosswalks. refEnitytOrRelationId STRING NULLABLE
createdTime TIMESTAMP NULLABLE
updatedTime TIMESTAMP NULLABLE
insertedTime TIMESTAMP NULLABLE
startDate TIMESTAMP NULLABLE
endDate TIMESTAMP NULLABLE
Uri STRING NULLABLE
updatedBy STRING NULLABLE
Type STRING NULLABLE
createdBy STRING NULLABLE
eventTime TIMESTAMP NULLABLE
versionTime INTEGER NULLABLE
deleted BOOLEAN NULLABLE
deletedTime TIMESTAMP NULLABLE
Id STRING NULLABLE
Start RECORD NULLABLE
Start. Id STRING NULLABLE
End RECORD NULLABLE
End. ID STRING NULLABLE
attributes RECORD NULLABLE
attributeName RECORD NULLABLE
attribute. value RECORD NULLABLE
attribute. Id STRING NULLABLE
attribute. isOv BOOLEAN NULLABLE