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:
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 |