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