# Gong schema ERD

Table and field reference for the Fivetran Gong connector.

## Table & Field Reference

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| description | String |  |
| name | String |  |

### call_in_folder

| Column | Type | Keys |
| --- | --- | --- |
| call_id | String | PK, FK |
| library_folder_id | String | PK, FK |
| added_by | String | FK |
| created | Instant |  |
| note | String |  |
| snippet_from_second | Int |  |
| snippet_to_second | Int |  |

### account_entity_schema

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| integration_id | String | PK, FK |
| is_deleted | Boolean |  |
| label | String |  |
| last_modified | Instant |  |
| reference_to | String |  |
| type | String |  |

### entity_value

| Column | Type | Keys |
| --- | --- | --- |
| entity | Unknown | PK |
| name | Unknown | PK |
| integration_id | Unknown | PK, FK |
| value | Unknown |  |

### user_email_alias

| Column | Type | Keys |
| --- | --- | --- |
| email | String | PK |
| user_id | String | PK, FK |

### user_meeting_url

| Column | Type | Keys |
| --- | --- | --- |
| url | String | PK |
| user_id | String | PK, FK |

### user_spoken_language

| Column | Type | Keys |
| --- | --- | --- |
| languages | String | PK |
| user_id | String | PK, FK |
| is_primary | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| manager_id | String | FK |
| active | Boolean |  |
| created | Unknown |  |
| email_address | String |  |
| emails_imported | Boolean |  |
| extension | String |  |
| first_name | String |  |
| gong_connect_enabled | Boolean |  |
| last_name | String |  |
| meeting_consent_page_url | String |  |
| non_recorded_meetings_imported | Boolean |  |
| phone_number | String |  |
| prevent_email_import | Boolean |  |
| prevent_web_conference_recording | Boolean |  |
| telephony_calls_imported | Boolean |  |
| title | String |  |
| web_conferences_recorded | Boolean |  |

### contact_entity_schema

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| integration_id | String | PK, FK |
| is_deleted | Boolean |  |
| label | String |  |
| last_modified | Instant |  |
| reference_to | String |  |
| type | String |  |

### lead_entity_schema

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| integration_id | String | PK, FK |
| is_deleted | Boolean |  |
| label | String |  |
| last_modified | Instant |  |
| reference_to | String |  |
| type | String |  |

### permission_call_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_library_folder_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_deal_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_forecast_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_forecast_edit_submission_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_forecast_edit_target_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_coaching_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_insight_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_email_access

| Column | Type | Keys |
| --- | --- | --- |
| permission_profile_id | String | PK, FK |
| user_id | String | PK, FK |

### permission_profile

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account | Boolean |  |
| activity | Boolean |  |
| calls_access_permission_level | String |  |
| calls_and_search | Boolean |  |
| coaching | Boolean |  |
| create_edit_and_delete_deals_boards | Boolean |  |
| crm_data_import | Boolean |  |
| crm_data_inline_editing | Boolean |  |
| deal_access_permission_level | String |  |
| deals | Boolean |  |
| deals_inline_editing | Boolean |  |
| delete_calls | Boolean |  |
| delete_emails | Boolean |  |
| description | String |  |
| download_call_media | Boolean |  |
| emails_access_permission_level | String |  |
| engage_manage_company_sequences | Boolean |  |
| engage_manage_company_templates | Boolean |  |
| export_calls_and_coaching_data_to_csv | Boolean |  |
| forecast | Boolean |  |
| forecast_access_permission_level | String |  |
| forecast_edit_submissions_access_permission_level | String |  |
| forecast_edit_targets_access_permission_level | String |  |
| forecast_manage | Boolean |  |
| initiatives | Boolean |  |
| insights_access_permission_level | String |  |
| library | Boolean |  |
| library_folder_access_permission_level | String |  |
| manage_general_business_settings | Boolean |  |
| manage_scorecards | Boolean |  |
| manually_schedule_and_upload_calls | Boolean |  |
| market | Boolean |  |
| name | String |  |
| private_calls | Boolean |  |
| score_calls | Boolean |  |
| share_calls_with_customers | Boolean |  |
| team_stats | Boolean |  |
| trim_calls | Boolean |  |
| workspace_id | String |  |

### manual_call_integration

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| account_crm_id | String | FK |
| deal_crm_id | String | FK |
| manual_call_id | String | FK |
| manual_user_id | String | FK |

### manual_call

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| user_id | String | PK, FK |
| created | Unknown |  |

### library_folder

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | Unknown | FK |
| parent_folder_id | String | FK |
| name | String |  |
| updated | Unknown |  |
| workspace_id | String |  |

### engage_flow

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_email_address | String | PK |
| folder_id | String | FK |
| creation_date | Instant |  |
| name | String |  |
| visibility | String |  |

### deal_entity_schema

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| integration_id | String | PK, FK |
| is_deleted | Boolean |  |
| label | String |  |
| last_modified | Instant |  |
| reference_to | String |  |
| type | String |  |

### user_setting_history

| Column | Type | Keys |
| --- | --- | --- |
| setting | String | PK |
| time | Unknown | PK |
| user_id | String | PK, FK |
| value | Boolean |  |

### scorecard_question

| Column | Type | Keys |
| --- | --- | --- |
| question_id | String | PK |
| scorecard_id | String | FK |
| updater_user_id | String | FK |
| created | Unknown |  |
| is_overall | Boolean |  |
| question_revision_id | String |  |
| question_text | String |  |
| updated | Unknown |  |

### scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| updater_user_id | String | FK |
| workspace_id | String | FK |
| created | Instant |  |
| enabled | Boolean |  |
| name | String |  |
| review_method | String |  |
| updated | Instant |  |

### language_keywords

| Column | Type | Keys |
| --- | --- | --- |
| keyword | String | PK |
| tracker_language | String | PK, FK |

### tracker_language

| Column | Type | Keys |
| --- | --- | --- |
| tracker_language | String | PK |
| tracker_id | String | PK, FK |
| include_related_forms | String |  |

### tracker_said_in_topic

| Column | Type | Keys |
| --- | --- | --- |
| keyword | String | PK |
| tracker_id | String | PK, FK |

### tracker_said_in_call_parts

| Column | Type | Keys |
| --- | --- | --- |
| keyword | String | PK |
| tracker_id | String | PK, FK |

### tracker

| Column | Type | Keys |
| --- | --- | --- |
| tracker_id | String | PK |
| creator_user_id | String | FK |
| updater_user_id | String | FK |
| workspace_id | String | FK |
| affiliation | String |  |
| created | Instant |  |
| filter_query | String |  |
| part_of_question | String |  |
| said_at | String |  |
| said_at_interval | Long |  |
| tracker_name | String |  |
| updated | Instant |  |

### crm

| Column | Type | Keys |
| --- | --- | --- |
| integration_id | String | PK |
| owner_email | String | FK |
| name | String |  |

### transcript

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workspace_id | String | PK |
| call_id | String | PK, FK |
| sentence | Json |  |
| speaker_id | String |  |
| topic | String |  |

### call_public_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | String | PK, FK |
| commenter_user_id | Unknown | FK |
| in_reply_to | Unknown | FK |
| audio_end_time | Unknown |  |
| audio_start_time | Unknown |  |
| comment | Unknown |  |
| during_call | Unknown |  |
| posted | Unknown |  |

### call_content_action_item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | String | FK |
| snippet | Unknown |  |
| snippet_end_time | Unknown |  |
| snippet_start_time | Unknown |  |
| speaker_id | Unknown |  |

### call_structure

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | String | FK |
| duration | Unknown |  |
| name | Unknown |  |

### call_topic

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | String | FK |
| duration | Unknown |  |
| name | Unknown |  |

### call_context_integration

| Column | Type | Keys |
| --- | --- | --- |
| call_id | String | PK |
| context_index | Unknown | PK |
| name | Unknown | PK |
| systems | Unknown | PK |
| workspace_id | Unknown | PK |
| object_id | Unknown |  |
| object_type | Unknown |  |
| timing | Unknown |  |
| value | Json |  |

### call_interaction

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| call_id | String | PK, FK |
| value | Unknown |  |

### call_participant_integration

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| object_id | Unknown | PK |
| call_id | String | PK, FK |
| call_participant_id | Unknown | FK |
| object_type | Unknown |  |
| systems | Unknown |  |
| timing | Unknown |  |
| value | Unknown |  |

### call_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| index | Unknown | PK |
| call_id | String | PK, FK |
| user_id | Unknown | FK |
| affiliation | Unknown |  |
| email_address | Unknown |  |
| methods | Json |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| speaker_id | Unknown |  |
| title | Unknown |  |

### call_speaker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | String | PK, FK |
| user_id | Unknown | FK |
| talk_time | Unknown |  |

### call_video

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | String | FK |
| duration | Unknown |  |
| name | Unknown |  |

### call_outline_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | String | PK, FK |
| call_outline_index | Unknown | PK, FK |
| workspace_id | Unknown | PK, FK |
| start_time | Unknown |  |
| text | Unknown |  |

### call_outline

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | String | PK, FK |
| workspace_id | Unknown | PK, FK |
| duration | Unknown |  |
| section | Unknown |  |
| start_time | Unknown |  |

### call_highlight_item

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_highlight_index | Unknown | PK, FK |
| call_id | String | PK, FK |
| workspace_id | Unknown | PK, FK |
| start_time | Json |  |
| text | Unknown |  |

### call_highlight

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | String | PK, FK |
| workspace_id | Unknown | PK, FK |
| title | Unknown |  |

### call_key_point

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| call_id | String | PK, FK |
| workspace_id | Unknown | PK, FK |
| text | Unknown |  |

### call

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| workspace_id | Unknown | PK, FK |
| primary_user_id | String | FK |
| brief | Unknown |  |
| calendar_event_id | String |  |
| call_outcome_category | Unknown |  |
| call_outcome_id | Unknown |  |
| call_outcome_name | Unknown |  |
| client_unique_id | String |  |
| company_question_count | Unknown |  |
| custom_data | String |  |
| direction | String |  |
| duration | Int |  |
| is_private | Boolean |  |
| languages | String |  |
| media | String |  |
| media_audio_url | Unknown |  |
| media_video_url | Unknown |  |
| meeting_url | String |  |
| non_company_question_count | Unknown |  |
| purpose | String |  |
| scheduled | Unknown |  |
| scope | String |  |
| sdr_disposition | String |  |
| started | Instant |  |
| systems | String |  |
| title | String |  |
| url | String |  |

### call_tracker

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| call_id | Unknown | FK |
| id | Unknown | FK |
| count | Unknown |  |
| name | Unknown |  |
| phrase | Unknown |  |
| speaker_id | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |

### answered_scorecard_answer

| Column | Type | Keys |
| --- | --- | --- |
| answered_scorecard_id | Unknown | PK, FK |
| question_id | String | PK, FK |
| answer_text | String |  |
| is_overall | Boolean |  |
| not_applicable | Unknown |  |
| question_revision_id | String |  |
| score | Unknown |  |

### answered_scorecard

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | String | PK, FK |
| scorecard_id | Unknown | PK, FK |
| reviewed_user_id | Unknown | FK |
| reviewer_user_id | Unknown | FK |
| call_start_time | Unknown |  |
| review_time | Unknown |  |
| visibility_type | Unknown |  |

## Relationships

- call_in_folder(call_id) → call(id)
- call_in_folder(added_by) → users(id)
- call_in_folder(library_folder_id) → library_folder(id)
- account_entity_schema(integration_id) → crm(integration_id)
- entity_value(integration_id) → crm(integration_id)
- user_email_alias(user_id) → users(id)
- user_meeting_url(user_id) → users(id)
- user_spoken_language(user_id) → users(id)
- users(manager_id) → users(id)
- contact_entity_schema(integration_id) → crm(integration_id)
- lead_entity_schema(integration_id) → crm(integration_id)
- permission_call_access(user_id) → users(id)
- permission_call_access(permission_profile_id) → permission_profile(id)
- permission_library_folder_access(user_id) → users(id)
- permission_library_folder_access(permission_profile_id) → permission_profile(id)
- permission_deal_access(user_id) → users(id)
- permission_deal_access(permission_profile_id) → permission_profile(id)
- permission_forecast_access(user_id) → users(id)
- permission_forecast_access(permission_profile_id) → permission_profile(id)
- permission_forecast_edit_submission_access(user_id) → users(id)
- permission_forecast_edit_submission_access(permission_profile_id) → permission_profile(id)
- permission_forecast_edit_target_access(user_id) → users(id)
- permission_forecast_edit_target_access(permission_profile_id) → permission_profile(id)
- permission_coaching_access(user_id) → users(id)
- permission_coaching_access(permission_profile_id) → permission_profile(id)
- permission_insight_access(user_id) → users(id)
- permission_insight_access(permission_profile_id) → permission_profile(id)
- permission_email_access(user_id) → users(id)
- permission_email_access(permission_profile_id) → permission_profile(id)
- manual_call_integration(account_crm_id) → call_context_integration(name)
- manual_call_integration(deal_crm_id) → call_context_integration(name)
- manual_call_integration(manual_call_id) → manual_call(id)
- manual_call_integration(manual_user_id) → manual_call(user_id)
- manual_call(id) → call(id)
- manual_call(user_id) → users(id)
- library_folder(created_by) → users(id)
- library_folder(parent_folder_id) → library_folder(id)
- engage_flow(folder_id) → library_folder(id)
- deal_entity_schema(integration_id) → crm(integration_id)
- user_setting_history(user_id) → users(id)
- scorecard_question(updater_user_id) → users(id)
- scorecard_question(scorecard_id) → scorecard(id)
- scorecard(updater_user_id) → users(id)
- scorecard(workspace_id) → workspace(id)
- language_keywords(tracker_language) → tracker_language(tracker_language)
- tracker_language(tracker_id) → tracker(tracker_id)
- tracker_said_in_topic(tracker_id) → tracker(tracker_id)
- tracker_said_in_call_parts(tracker_id) → tracker(tracker_id)
- tracker(workspace_id) → workspace(id)
- tracker(creator_user_id) → users(id)
- tracker(updater_user_id) → users(id)
- crm(owner_email) → users(id)
- transcript(call_id) → call(id)
- call_public_comment(commenter_user_id) → users(id)
- call_public_comment(in_reply_to) → call_public_comment(id)
- call_public_comment(call_id) → call(id)
- call_content_action_item(call_id) → call(id)
- call_structure(call_id) → call(id)
- call_topic(call_id) → call(id)
- call_interaction(call_id) → call(id)
- call_participant_integration(call_participant_id) → call_participant(id)
- call_participant_integration(call_id) → call(id)
- call_participant(user_id) → users(id)
- call_participant(call_id) → call(id)
- call_speaker(user_id) → users(id)
- call_speaker(call_id) → call(id)
- call_video(call_id) → call(id)
- call_outline_item(call_id) → call_outline(call_id)
- call_outline_item(call_outline_index) → call_outline(index)
- call_outline_item(workspace_id) → call_outline(workspace_id)
- call_outline(call_id) → call(id)
- call_outline(workspace_id) → call(workspace_id)
- call_highlight_item(call_id) → call_highlight(call_id)
- call_highlight_item(workspace_id) → call_highlight(workspace_id)
- call_highlight_item(call_highlight_index) → call_highlight(index)
- call_highlight(call_id) → call(id)
- call_highlight(workspace_id) → call(workspace_id)
- call_key_point(call_id) → call(id)
- call_key_point(workspace_id) → call(workspace_id)
- call(workspace_id) → workspace(id)
- call(primary_user_id) → users(id)
- call_tracker(call_id) → call(id)
- call_tracker(id) → tracker(tracker_id)
- answered_scorecard_answer(question_id) → scorecard_question(question_id)
- answered_scorecard_answer(answered_scorecard_id) → answered_scorecard(id)
- answered_scorecard(scorecard_id) → scorecard(id)
- answered_scorecard(call_id) → call(id)
- answered_scorecard(reviewed_user_id) → users(id)
- answered_scorecard(reviewer_user_id) → users(id)