Gong

Explore the interactive ERD

Table & Field Reference

workspace

Column	Type	Keys
`id`	String	PK
`description`	String
`name`	String

call_in_folder

Column	Type	Keys
`call_id`	String	PKFK
`library_folder_id`	String	PKFK
`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	PKFK
`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	PKFK
`value`	Unknown

user_email_alias

Column	Type	Keys
`email`	String	PK
`user_id`	String	PKFK

user_meeting_url

Column	Type	Keys
`url`	String	PK
`user_id`	String	PKFK

user_spoken_language

Column	Type	Keys
`languages`	String	PK
`user_id`	String	PKFK
`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

task_contact_opt_out_channel

Column	Type	Keys
`index`	Unknown	PK
`task_id`	Unknown	PKFK
`opt_out_channel`	Unknown

task_contact_phone

Column	Type	Keys
`index`	Unknown	PK
`task_id`	Unknown	PKFK
`country_code`	Unknown
`extension`	Unknown
`is_verified`	Unknown
`label`	Unknown
`normalized`	Unknown
`raws`	Unknown

task_contact_email

Column	Type	Keys
`index`	Unknown	PK
`task_id`	Unknown	PKFK
`email`	Unknown

task_action

Column	Type	Keys
`index`	Unknown	PK
`task_id`	Unknown	PKFK
`action`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`flow_id`	Unknown	FK
`flow_step_id`	Unknown	FK
`account_crm_id`	Unknown
`account_crm_url`	Unknown
`account_name`	Unknown
`contact_affiliation`	Unknown
`contact_city`	Unknown
`contact_company_name`	Unknown
`contact_country`	Unknown
`contact_crm_id`	Unknown
`contact_crm_url`	Instant
`contact_first_name`	Unknown
`contact_last_name`	Unknown
`contact_linkedin_profile`	Unknown
`contact_state`	Unknown
`contact_timezone`	Unknown
`contact_title`	Unknown
`contact_type`	Unknown
`contact_zipcode`	Unknown
`created`	Instant
`due_date`	Instant
`flow_name`	Unknown
`flow_step_name`	Unknown
`flow_step_step_number`	Unknown
`has_specific_time`	Boolean
`opportunity_amount`	Unknown
`opportunity_close_date`	Unknown
`opportunity_crm_id`	Unknown
`opportunity_crm_url`	Unknown
`opportunity_name`	Unknown
`opportunity_probability`	Unknown
`opportunity_stage`	Unknown
`opportunity_status`	Unknown
`priority_id`	Unknown
`priority_name`	Unknown
`priority_weight`	Unknown
`status`	Unknown
`title`	Unknown
`type`	Unknown
`updated`	Unknown
`user_id`	Unknown

contact_entity_schema

Column	Type	Keys
`name`	String	PK
`integration_id`	String	PKFK
`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	PKFK
`is_deleted`	Boolean
`label`	String
`last_modified`	Instant
`reference_to`	String
`type`	String

permission_call_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_library_folder_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_deal_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_forecast_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_forecast_edit_submission_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_forecast_edit_target_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_coaching_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_insight_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

permission_email_access

Column	Type	Keys
`permission_profile_id`	String	PKFK
`user_id`	String	PKFK

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	PKFK
`user_id`	String	PKFK
`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	PKFK
`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	PKFK
`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

engage_flow_prospect_assignment

Column	Type	Keys
`id`	String	PK
`flow_id`	String	FK
`workspace_id`	String	FK
`created`	Instant
`crm_prospect_id`	String
`exclusive`	Boolean
`flow_instance_owner_email`	String
`flow_instance_owner_full_name`	String
`flow_instance_status`	String
`flow_name`	String

language_keywords

Column	Type	Keys
`keyword`	String	PK
`tracker_language`	String	PKFK

tracker_language

Column	Type	Keys
`tracker_language`	String	PK
`tracker_id`	String	PKFK
`include_related_forms`	String

tracker_said_in_topic

Column	Type	Keys
`keyword`	String	PK
`tracker_id`	String	PKFK

tracker_said_in_call_parts

Column	Type	Keys
`keyword`	String	PK
`tracker_id`	String	PKFK

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

engage_flow_step

Column	Type	Keys
`id`	String	PK
`flow_id`	String	PKFK
`action`	String
`body`	String
`days_from_previous_step`	Unknown
`is_reply`	Boolean
`step_order`	Int
`subject`	Unknown

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	PKFK
`sentence`	Json
`speaker_id`	String
`topic`	String

call_public_comment

Column	Type	Keys
`id`	Unknown	PK
`call_id`	String	PKFK
`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	PKFK
`value`	Unknown

call_participant_integration

Column	Type	Keys
`name`	Unknown	PK
`object_id`	Unknown	PK
`call_id`	String	PKFK
`call_participant_id`	Unknown	FK
`object_type`	Unknown
`systems`	Unknown
`timing`	Unknown
`value`	Unknown

call_participant

Column	Type	Keys
`id`	Unknown	PK
`call_id`	String	PKFK
`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	PKFK
`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	PKFK
`call_outline_index`	Unknown	PKFK
`workspace_id`	Unknown	PKFK
`start_time`	Unknown
`text`	Unknown

call_outline

Column	Type	Keys
`index`	Unknown	PK
`call_id`	String	PKFK
`workspace_id`	Unknown	PKFK
`duration`	Unknown
`section`	Unknown
`start_time`	Unknown

call_highlight_item

Column	Type	Keys
`index`	Unknown	PK
`call_highlight_index`	Unknown	PKFK
`call_id`	String	PKFK
`workspace_id`	Unknown	PKFK
`start_time`	Json
`text`	Unknown

call_highlight

Column	Type	Keys
`index`	Unknown	PK
`call_id`	String	PKFK
`workspace_id`	Unknown	PKFK
`title`	Unknown

call_key_point

Column	Type	Keys
`index`	Unknown	PK
`call_id`	String	PKFK
`workspace_id`	Unknown	PKFK
`text`	Unknown

call

Column	Type	Keys
`id`	String	PK
`workspace_id`	Unknown	PKFK
`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	PKFK
`question_id`	String	PKFK
`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	PKFK
`scorecard_id`	Unknown	PKFK
`reviewed_user_id`	Unknown	FK
`reviewer_user_id`	Unknown	FK
`call_start_time`	Unknown
`review_time`	Unknown
`visibility_type`	Unknown