Fivetran documentation

Search the docs

/

Reltio

Explore the interactive ERD

Table & Field Reference

match

Column	Type	Keys
`tenant_id`	String	PK
`entity_id`	String	PKFK
`match_group_id`	String	PKFK
`matched_entity_id`	String	PKFK
`type`	String

relation_attribute_type

Column	Type	Keys
`tenant_id`	String	PK
`uri`	String	PK
`relation_type`	String	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`parent_attribute`	String	FK
`name`	String
`type`	String
`uri`	String
`value`	String

interaction_member

Column	Type	Keys
`tenant_id`	String	PK
`interaction_id`	String	PKFK
`member_id`	String	PKFK
`type`	String	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`parent_attribute`	String	FK
`name`	String
`type`	String
`uri`	String
`value`	String

entity_crosswalk_attribute

Column	Type	Keys
`tenant_id`	String	PK
`attribute`	String	PKFK
`crosswalk_id`	String	PKFK
`entity_id`	String	PKFK
`update_date`	Instant

relation_attribute

Column	Type	Keys
`_fivetran_id`	String	PK
`tenant_id`	String	PK
`relation_id`	String	PKFK
`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	PKFK
`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	PKFK
`crosswalk_id`	String	PKFK
`relation_id`	String	PKFK
`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	PKFK
`winner_id`	String	PKFK
`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	PKFK
`not_match_entity_id`	String	PKFK

match_group

Column	Type	Keys
`id`	String	PK
`tenant_id`	String	PK
`entity_type`	String	PKFK
`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	PKFK
`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	PKFK
`crosswalk_id`	String	PKFK
`interaction_id`	String	PKFK
`update_date`	Instant

entity_crosswalk

Column	Type	Keys
`id`	String	PK
`tenant_id`	String	PK
`entity_id`	String	PKFK
`type`	String	FK
`create_date`	Instant
`delete_date`	Instant
`reltio_load_date`	Instant
`source_table`	String
`update_date`	Instant
`uri`	String
`value`	String