# Reltio schema ERD

Table and field reference for the Fivetran Reltio connector.

## Table & Field Reference

### match

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| entity_id | String | PK, FK |
| match_group_id | String | PK, FK |
| matched_entity_id | String | PK, FK |
| type | String |  |

### relation_attribute_type

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| uri | String | PK |
| relation_type | String | PK, FK |
| parent_attribute | String | FK |
| attribute_system | Boolean |  |
| description | String |  |
| hidden | Boolean |  |
| important | Boolean |  |
| label | String |  |
| name | String |  |
| searchable | Boolean |  |
| skip_in_data_access | Boolean |  |
| type | String |  |
| values | Json |  |

### entity_attribute_type

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| uri | String | PK |
| entity_type | String | PK, FK |
| parent_attribute | String | FK |
| attribute_system | Boolean |  |
| description | String |  |
| hidden | Boolean |  |
| important | Boolean |  |
| label | String |  |
| name | String |  |
| searchable | Boolean |  |
| skip_in_data_access | Boolean |  |
| type | String |  |
| values | Json |  |

### entity_analytics_attribute_type

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| uri | String | PK |
| entity_type | String | PK, FK |
| parent_attribute | String | FK |
| description | String |  |
| label | String |  |
| max_occurs | Long |  |
| name | String |  |
| type | String |  |
| values | Json |  |

### relation_crosswalk

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| relation_id | String | PK, FK |
| type | String | FK |
| create_date | Instant |  |
| delete_date | Instant |  |
| reltio_load_date | Instant |  |
| source_table | String |  |
| update_date | Instant |  |
| uri | String |  |
| value | String |  |

### relation_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| description | String |  |
| direction | String |  |
| end_object_directional_context | Json |  |
| end_object_object_type_uri | String |  |
| end_object_uri | String |  |
| implicit | Boolean |  |
| label | String |  |
| start_object_directional_context | Json |  |
| start_object_object_type_uri | String |  |
| start_object_uri | String |  |
| type_color | String |  |
| uri | String |  |

### interaction_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tenant_id | String | PK |
| interaction_id | String | PK, FK |
| parent_attribute | String | FK |
| type | String | FK |
| ignored | String |  |
| label | String |  |
| lookup_code | String |  |
| lookup_value | String |  |
| name | String |  |
| ov | Boolean |  |
| uri | String |  |
| value | String |  |

### entity_analytics_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tenant_id | String | PK |
| entity_id | String | PK, FK |
| parent_attribute | String | FK |
| name | String |  |
| type | String |  |
| uri | String |  |
| value | String |  |

### interaction_member

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| interaction_id | String | PK, FK |
| member_id | String | PK, FK |
| type | String | PK, FK |

### interaction

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| type | String | FK |
| created_by | String |  |
| created_time | Instant |  |
| interaction_timestamp | Instant |  |
| is_favorite | Boolean |  |
| updated_by | String |  |
| updated_time | Instant |  |
| uri | String |  |

### interaction_attribute_type

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| uri | String | PK |
| interaction_type | String | PK, FK |
| parent_attribute | String | FK |
| attribute_system | Boolean |  |
| description | String |  |
| hidden | Boolean |  |
| important | Boolean |  |
| label | String |  |
| name | String |  |
| searchable | Boolean |  |
| skip_in_data_access | Boolean |  |
| type | String |  |
| values | Json |  |

### entity_tag

| Column | Type | Keys |
| --- | --- | --- |
| entity_id | String | PK |
| name | String | PK |
| tenant_id | String | PK |

### interaction_member_type

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| uri | String | PK |
| interaction_type | String | PK, FK |
| object_type_uri | String | FK |
| label | String |  |
| name | String |  |

### relation_analytics_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tenant_id | String | PK |
| relation_id | String | PK, FK |
| parent_attribute | String | FK |
| name | String |  |
| type | String |  |
| uri | String |  |
| value | String |  |

### entity_crosswalk_attribute

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| attribute | String | PK, FK |
| crosswalk_id | String | PK, FK |
| entity_id | String | PK, FK |
| update_date | Instant |  |

### relation_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tenant_id | String | PK |
| relation_id | String | PK, FK |
| parent_attribute | String | FK |
| type | String | FK |
| ignored | String |  |
| label | String |  |
| lookup_code | String |  |
| lookup_value | String |  |
| name | String |  |
| ov | Boolean |  |
| uri | String |  |
| value | String |  |

### entity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| type | String | FK |
| winner_id | String | FK |
| created_by | String |  |
| created_time | Instant |  |
| end_date | Instant |  |
| label | String |  |
| secondary_label | String |  |
| updated_by | String |  |
| updated_time | Instant |  |
| uri | String |  |

### interaction_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| has_members | Boolean |  |
| label | String |  |
| uri | String |  |

### interaction_crosswalk

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| interaction_id | String | PK, FK |
| type | String | FK |
| create_date | Instant |  |
| delete_date | Instant |  |
| reltio_load_date | Instant |  |
| source_table | String |  |
| update_date | Instant |  |
| uri | String |  |
| value | String |  |

### relation_crosswalk_attribute

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| attribute | String | PK, FK |
| crosswalk_id | String | PK, FK |
| relation_id | String | PK, FK |
| update_date | Instant |  |

### source

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| abbreviation | String |  |
| description | String |  |
| icon | String |  |
| label | String |  |
| uri | String |  |

### entity_merge

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| loser_id | String | PK, FK |
| winner_id | String | PK, FK |
| merge_reason | String |  |
| merge_rules | String |  |
| merged_by | String |  |
| time | Instant |  |

### entity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| abstract | Boolean |  |
| data_label_pattern | String |  |
| description | String |  |
| extends_type | String |  |
| label | String |  |
| secondary_label_pattern | String |  |
| type_color | String |  |
| uri | String |  |

### relation

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| end_object_entity_id | String | FK |
| start_object_entity_id | String | FK |
| type | String | FK |
| created_by | String |  |
| created_time | Instant |  |
| end_date | Instant |  |
| end_object_directional_label | String |  |
| end_ref_ignored | Boolean |  |
| end_ref_pinned | Boolean |  |
| start_object_directional_label | String |  |
| start_ref_ignored | Boolean |  |
| start_ref_pinned | Boolean |  |
| updated_by | String |  |
| updated_time | Instant |  |
| uri | String |  |

### not_match

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| entity_id | String | PK, FK |
| not_match_entity_id | String | PK, FK |

### match_group

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| entity_type | String | PK, FK |
| label | String |  |
| rule | Json |  |
| score_incremental | Double |  |
| score_standalone | Double |  |
| type | String |  |
| uri | String |  |
| use_ov_only | Boolean |  |

### entity_attribute

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| tenant_id | String | PK |
| entity_id | String | PK, FK |
| parent_attribute | String | FK |
| ref_entity | String | FK |
| ref_relation | String | FK |
| type | String | FK |
| ignored | String |  |
| label | String |  |
| lookup_code | String |  |
| lookup_value | String |  |
| name | String |  |
| ov | Boolean |  |
| relationship_label | String |  |
| uri | String |  |
| value | String |  |

### interaction_crosswalk_attribute

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | String | PK |
| attribute | String | PK, FK |
| crosswalk_id | String | PK, FK |
| interaction_id | String | PK, FK |
| update_date | Instant |  |

### entity_crosswalk

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| tenant_id | String | PK |
| entity_id | String | PK, FK |
| type | String | FK |
| create_date | Instant |  |
| delete_date | Instant |  |
| reltio_load_date | Instant |  |
| source_table | String |  |
| update_date | Instant |  |
| uri | String |  |
| value | String |  |

## Relationships

- match(entity_id) → entity(id)
- match(matched_entity_id) → entity(id)
- match(match_group_id) → match_group(id)
- relation_attribute_type(parent_attribute) → relation_attribute_type(uri)
- relation_attribute_type(relation_type) → relation_type(id)
- entity_attribute_type(parent_attribute) → entity_attribute_type(uri)
- entity_attribute_type(entity_type) → entity_type(id)
- entity_analytics_attribute_type(parent_attribute) → entity_analytics_attribute_type(uri)
- entity_analytics_attribute_type(entity_type) → entity_type(id)
- relation_crosswalk(type) → source(id)
- relation_crosswalk(relation_id) → relation(id)
- interaction_attribute(parent_attribute) → interaction_attribute(_fivetran_id)
- interaction_attribute(type) → interaction_attribute_type(uri)
- interaction_attribute(interaction_id) → interaction(id)
- entity_analytics_attribute(parent_attribute) → entity_analytics_attribute(_fivetran_id)
- entity_analytics_attribute(entity_id) → entity(id)
- interaction_member(interaction_id) → interaction(id)
- interaction_member(member_id) → entity(id)
- interaction_member(type) → interaction_member_type(interaction_type)
- interaction(type) → interaction_type(id)
- interaction_attribute_type(parent_attribute) → interaction_attribute_type(uri)
- interaction_attribute_type(interaction_type) → interaction_type(id)
- interaction_member_type(interaction_type) → interaction_type(id)
- interaction_member_type(object_type_uri) → entity_type(uri)
- relation_analytics_attribute(parent_attribute) → relation_analytics_attribute(_fivetran_id)
- relation_analytics_attribute(relation_id) → relation(id)
- entity_crosswalk_attribute(entity_id) → entity_crosswalk(entity_id)
- entity_crosswalk_attribute(crosswalk_id) → entity_crosswalk(id)
- entity_crosswalk_attribute(attribute) → entity_attribute(uri)
- relation_attribute(parent_attribute) → relation_attribute(_fivetran_id)
- relation_attribute(type) → relation_attribute_type(uri)
- relation_attribute(relation_id) → relation(id)
- entity(winner_id) → entity(id)
- entity(type) → entity_type(id)
- interaction_crosswalk(type) → source(id)
- interaction_crosswalk(interaction_id) → interaction(id)
- relation_crosswalk_attribute(relation_id) → relation_crosswalk(relation_id)
- relation_crosswalk_attribute(crosswalk_id) → relation_crosswalk(id)
- relation_crosswalk_attribute(attribute) → relation_attribute(uri)
- entity_merge(winner_id) → entity(id)
- entity_merge(loser_id) → entity(id)
- relation(type) → relation_type(id)
- relation(start_object_entity_id) → entity(id)
- relation(end_object_entity_id) → entity(id)
- not_match(entity_id) → entity(id)
- not_match(not_match_entity_id) → entity(id)
- match_group(entity_type) → entity_type(id)
- entity_attribute(parent_attribute) → entity_attribute(_fivetran_id)
- entity_attribute(type) → entity_attribute_type(uri)
- entity_attribute(entity_id) → entity(id)
- entity_attribute(ref_entity) → entity(id)
- entity_attribute(ref_relation) → relation(id)
- interaction_crosswalk_attribute(interaction_id) → interaction_crosswalk(interaction_id)
- interaction_crosswalk_attribute(crosswalk_id) → interaction_crosswalk(id)
- interaction_crosswalk_attribute(attribute) → interaction_attribute(uri)
- entity_crosswalk(type) → source(id)
- entity_crosswalk(entity_id) → entity(id)