Relationship Tables

Overview

The following tables are generated from the metadata for the specific relationship type. As attributes for a relationship type are defined, columns are added to the tables. The tables that are created are not automatically removed as relationship types are retired.

Sample Relationship Tables

Sample Relationship Tables
Name	Naming Convention	Description
Relationship Type Table	MDM_<entity_type>_RT	Table used to maintain attribute values for a particular relationship type..

The following columns are common to all the staging tables and transpose tables. These tables are further populated with columns representing the attributes defined for the entity type.

MDM_<Entity_Type>_RT Columns

The relationship tables are schema-evolved to include columns for the attributes defined by the related relationship type.

MDM_<Entity_Type>_RT Columns
Name	Data Type	Null Option	Description
MDM_ENTITY_REL_ID	INTEGER	NOT NULL	Unique entity relationship identifier.

Last updated: April 19, 2017