Collibra

Explore the interactive ERD

Table & Field Reference

scope_domain

Column	Type	Keys
`domain_id`	String	PKFK
`scope_id`	String	PKFK

scope_community

Column	Type	Keys
`community_id`	String	PKFK
`scope_id`	String	PKFK

scope

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`description`	String
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String

relation_type

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`source_type_id`	String	FK
`target_type_id`	String	FK
`co_role`	String
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String
`role`	String

status

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String

issue

Column	Type	Keys
`id`	String	PKFK
`created_by`	String	FK
`domain_id`	String	FK
`last_modified_by`	String	FK
`status_id`	String	FK
`type_id`	String	FK
`articulation_score`	Double
`avg_rating`	Double
`created_on`	Instant
`display_name`	String
`excluded_from_auto_hyperlinking`	Boolean
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`ratings_count`	Long
`resource_type`	String

community

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`parent_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`parent_name`	String
`parent_resource_type`	String
`resource_type`	String

mapping

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`mapped_resource_id`	String	FK
`created_on`	Instant
`description`	String
`external_entity_id`	String
`external_entity_url`	String
`external_system_id`	String
`is_system`	Boolean
`last_modified_on`	Instant
`last_sync_date`	Instant
`resource_type`	String
`sync_action`	String

domain_type

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`parent_id`	String	FK
`created_on`	Instant
`description`	String
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`parent_name`	String
`parent_resource_type`	String
`resource_type`	String

job

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`cancelable`	Boolean
`created_on`	Instant
`end_date`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`message`	String
`name`	String
`progress_percentage`	Double
`resource_type`	String
`result`	String
`start_date`	Instant
`state`	String
`type`	String
`visibility`	Long

attribute

Column	Type	Keys
`id`	String	PK
`asset_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`type_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String
`value`	String

search_view_aggregation

Column	Type	Keys
`index`	Unknown	PK
`search_view_id`	String	PKFK
`field`	String
`limits`	String

search_in_fields_field

Column	Type	Keys
`index`	Unknown	PK
`search_in_field_index`	Unknown	PKFK
`search_view_id`	String	PKFK
`field`	String

search_in_field

Column	Type	Keys
`index`	Unknown	PK
`search_view_id`	String	PKFK
`resource_type`	String

search_view_filter_value

Column	Type	Keys
`index`	Unknown	PK
`search_view_filter_index`	Unknown	PKFK
`search_view_id`	String	PKFK
`value`	String

search_view_filter

Column	Type	Keys
`index`	Unknown	PK
`search_view_id`	String	PKFK
`field`	String

search_view

Column	Type	Keys
`id`	String	PK
`name`	String
`search_request_keywords`	String
`search_request_sort_field`	String
`search_request_sort_order`	String

rating

Column	Type	Keys
`id`	String	PK
`asset_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`rating`	Double
`resource_type`	String
`review`	String

view_permission

Column	Type	Keys
`id`	String	PK
`base_resource_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_group_id`	String	FK
`user_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant

user_additional_email_address

Column	Type	Keys
`email_address`	String	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String

user_phone_number

Column	Type	Keys
`phone_number`	String	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String
`type`	String

user_address

Column	Type	Keys
`_fivetran_id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`user_id`	String	FK
`city`	String
`country`	String
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`number`	String
`postal_type`	String
`resource_type`	String
`state`	String
`street`	String
`type`	String

user_instant_messaging_account

Column	Type	Keys
`account`	String	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String
`type`	String

user_website

Column	Type	Keys
`url`	String	PK
`user_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String
`type`	String

users

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`activated`	Boolean
`api_user`	String
`created_on`	Instant
`email_address`	String
`enabled`	Boolean
`first_name`	String
`gender`	String
`guest_user`	String
`is_system`	Boolean
`languages`	String
`last_modified_on`	Instant
`last_name`	String
`ldap_user`	String
`license_type`	String
`resource_type`	String
`user_name`	String
`user_source`	String

domain

Column	Type	Keys
`id`	String	PK
`community_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`type_id`	String	FK
`created_on`	Instant
`description`	String
`excluded_from_auto_hyperlinking`	Boolean
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String

attachment

Column	Type	Keys
`id`	String	PK
`base_resource_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`file_content_type`	String
`file_id`	String
`file_name`	String
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

attribute_type

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`description`	String
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String
`string_type`	String

user_group

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`locally_managed`	Boolean
`name`	String
`resource_type`	String

comment_mentioned_user

Column	Type	Keys
`comment_id`	String	PKFK
`user_id`	String	PKFK
`base_resource_id`	String
`base_resource_type`	String
`parent_id`	String
`parent_resource_type`	String

comment

Column	Type	Keys
`id`	String	PK
`base_resource_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`content`	String
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

role_permission

Column	Type	Keys
`permission`	String	PK
`role_id`	String	PKFK

role

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`description`	String
`global`	Boolean
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String

import

Column	Type	Keys
`synchronization_id`	String	PK

assignment_asset_type_status

Column	Type	Keys
`assignment_asset_type_id`	String	PKFK
`status_id`	String	PKFK

assignment_asset_type_domain_type

Column	Type	Keys
`assignment_asset_type_id`	String	PKFK
`domain_type_id`	String	PKFK

assignment_asset_type_characteristic_type

Column	Type	Keys
`id`	String	PK
`assignment_asset_type_id`	String	PKFK
`attribute_type_id`	String	FK
`assigned_resource_id`	String
`assigned_resource_type`	String
`is_system`	Boolean
`maximum_occurences`	Long
`minimum_occurences`	Long
`read_only`	Boolean

assignment_asset_type_articulation_rule

Column	Type	Keys
`id`	String	PK
`assignment_asset_type_id`	String	PKFK
`created_by`	String	FK
`last_modified_by`	String	FK
`status_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`operation`	String
`resource_type`	String
`score`	Double

assignment_asset_type_data_quality_rule

Column	Type	Keys
`assignment_asset_type_id`	String	PKFK
`data_quality_rule_id`	String	PKFK

assignment_asset_type_validation_rule

Column	Type	Keys
`id`	String	PK
`assignment_asset_type_id`	String	PKFK
`name`	String
`resource_type`	String

assignment_asset_type

Column	Type	Keys
`id`	String	PK
`asset_type_id`	String	FK
`created_by`	String	FK
`default_status_id`	String	FK
`last_modified_by`	String	FK
`scope_id`	Unknown	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

asset_type

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`parent_id`	String	FK
`created_on`	Instant
`description`	String
`display_name_enabled`	Boolean
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`parent_resource`	String
`rating_enabled`	Boolean
`resource_type`	String
`symbol_data_acronym_code`	String
`symbol_data_color`	String
`symbol_data_symbol_type`	String

data_quality_rule_relation_trace_entry

Column	Type	Keys
`_fivetran_id`	String	PK
`relation_type_id`	String	FK
`out_bound_role_direction`	Boolean
`role_direction`	Boolean

data_quality_metric

Column	Type	Keys
`id`	String	PK
`attribute_type_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`count_operation`	String
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

data_quality_rule

Column	Type	Keys
`id`	String	PK
`categorization_relation_type_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`relation_trace_created_by`	Unknown	FK
`relation_trace_last_modified_by`	Unknown	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`relation_trace_created_on`	Instant
`relation_trace_id`	String
`relation_trace_is_system`	Boolean
`relation_trace_last_modified_on`	Instant
`relation_trace_resource_type`	String
`resource_type`	String

complex_relation_attribute

Column	Type	Keys
`id`	String	PK
`asset_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`type_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String
`value`	String

complex_relation_leg

Column	Type	Keys
`id`	String	PK
`asset_id`	String	FK
`asset_reference_id`	String	FK
`asset_type_id`	String	FK
`complex_relation_id`	String	FK
`co_role`	String
`is_system`	Boolean
`resource_type`	String
`role`	String

complex_relation

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`type_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

relation

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`source_id`	String	FK
`target_id`	String	FK
`type_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

asset

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`domain_id`	String	FK
`last_modified_by`	String	FK
`status_id`	String	FK
`type_id`	String	FK
`articulation_score`	Double
`avg_rating`	Double
`created_on`	Instant
`description`	String
`display_name`	String
`excluded_from_auto_hyperlinking`	Boolean
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`ratings_count`	Long
`resource_type`	String

responsibility

Column	Type	Keys
`id`	String	PK
`base_resource_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`owner_id`	String	FK
`role_id`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`resource_type`	String

complex_relation_type_attribute_type

Column	Type	Keys
`id`	String	PK
`attribute_type_id`	String	FK
`complex_relation_type_id`	String	FK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`is_system`	Boolean
`last_modified_on`	Instant
`maximum_occurences`	Long
`minimum_occurences`	Long
`read_only`	Boolean
`resource_type`	String

complex_relation_type_leg_type

Column	Type	Keys
`id`	String	PK
`asset_type_id`	String	FK
`complex_relation_type_id`	String	FK
`relation_type_id`	String	FK
`co_role`	String
`is_system`	Boolean
`maximum_occurences`	Long
`minimum_occurences`	Long
`resource_type`	String
`role`	String

complex_relation_type

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`last_modified_by`	String	FK
`created_on`	Instant
`description`	String
`is_system`	Boolean
`last_modified_on`	Instant
`name`	String
`resource_type`	String
`symbol_data_acronym_code`	String
`symbol_data_color`	String
`symbol_data_icon_code`	String
`symbol_data_symbol_type`	String

Collibra

Explore the interactive ERD

Table & Field Reference

scope_domain

scope_community

scope

relation_type

status

issue

community

mapping

domain_type

job

attribute

search_view_aggregation

search_in_fields_field

search_in_field

search_view_filter_value

search_view_filter

search_view

rating

view_permission

user_additional_email_address

user_phone_number

user_address

user_instant_messaging_account

user_website

users

tags

domain

attachment

attribute_type

user_group

comment_mentioned_user

comment

role_permission

role

import

assignment_asset_type_status

assignment_asset_type_domain_type

assignment_asset_type_characteristic_type

assignment_asset_type_articulation_rule

assignment_asset_type_data_quality_rule

assignment_asset_type_validation_rule

assignment_asset_type

asset_type

data_quality_rule_relation_trace_entry

data_quality_metric

data_quality_rule

complex_relation_attribute

complex_relation_leg

complex_relation

relation

asset

responsibility

complex_relation_type_attribute_type

complex_relation_type_leg_type

complex_relation_type