Gong schema and ERD

63 tables

Loading diagram…

account_entity_schema

answered_scorecard

call

contact_entity_schema

deal_entity_schema

lead_entity_schema

manual_call

permission_profile

scorecard

tracker

transcript

user

account_entity_schema

unique_name

string

integration_id

string

is_deleted

boolean

label

string

last_modified

date

reference_to

string

type

string

_weld_synced

date

account_entity_value

index

int

integration_id

string

unique_name

string

value

string

_weld_synced

date

answered_scorecard

answered_scorecard_id

string

call_id

string

scorecard_id

string

call_start_time

date

review_time

date

reviewed_user_id

string

reviewer_user_id

string

scorecard_name

string

visibility_type

string

_weld_synced

date

answered_scorecard_answer

answered_scorecard_id

string

index

int

question_id

string

answer_text

string

is_overall

boolean

not_applicable

boolean

question_revision_id

string

score

int

_weld_synced

date

answered_scorecard_answer_option

answered_scorecard_id

string

index

int

question_id

string

option_id

string

_weld_synced

date

call

string

workspace_id

string

calendar_event_id

string

client_unique_id

string

custom_data

string

direction

string

duration

long

is_private

boolean

language

string

media

string

call_participant

string

call_id

string

user_id

string

index

int

affiliation

string

email_address

string

name

string

phone_number

string

speaker_id

string

title

string

_weld_synced

date

call_participant_method

call_id

string

call_participant_id

string

index

int

call_participant_index

int

method

string

_weld_synced

date

call_participant_integration

call_id

string

call_participant_id

string

index

int

call_participant_index

int

name

string

object_id

string

object_type

string

systems

string

timing

string

value

string

_weld_synced

date

call_context_integration

call_id

string

workspace_id

string

index

int

name

string

object_id

string

object_type

string

systems

string

timing

string

value

string

_weld_synced

date

call_speaker

string

call_id

string

user_id

string

index

int

talk_time

double

_weld_synced

date

call_topic

call_id

string

index

int

name

string

duration

int

_weld_synced

date

call_structure

call_id

string

index

int

name

string

duration

int

_weld_synced

date

call_video

call_id

string

index

int

name

string

duration

float

_weld_synced

date

call_interaction

call_id

string

index

int

name

string

value

double

_weld_synced

date

call_tracker

string

call_id

string

index

int

count

int

name

string

phrase

string

speaker_id

string

start_time

double

type

string

_weld_synced

date

call_public_comment

string

call_id

string

index

int

audio_end_time

float

audio_start_time

float

comment

string

commenter_user_id

string

during_call

boolean

in_reply_to

string

posted

date

_weld_synced

date

call_content_action_item

call_id

string

index

int

snippet

string

snippet_end_time

double

snippet_start_time

double

speaker_id

string

_weld_synced

date

call_outline

call_id

string

workspace_id

string

index

int

duration

double

section

string

start_time

double

_weld_synced

date

call_outline_item

call_id

string

workspace_id

string

index

int

call_outline_index

int

start_time

double

text

string

_weld_synced

date

call_highlight

call_id

string

workspace_id

string

index

int

title

string

_weld_synced

date

call_highlight_item

call_id

string

workspace_id

string

index

int

call_highlight_index

int

text

string

_weld_synced

date

call_highlight_item_start_time

call_id

string

workspace_id

string

index

int

call_highlight_index

int

call_highlight_item_index

int

start_time

double

_weld_synced

date

call_key_point

call_id

string

workspace_id

string

index

int

text

string

_weld_synced

date

call_in_folder

call_id

string

library_folder_id

string

added_by

string

created

date

note

string

snippet_from_sec

int

snippet_to_sec

int

title

string

url

string

_weld_synced

date

contact_entity_schema

unique_name

string

integration_id

string

is_deleted

boolean

label

string

last_modified

date

reference_to

string

type

string

_weld_synced

date

contact_entity_value

index

int

integration_id

string

unique_name

string

value

string

_weld_synced

date

crm

integration_id

string

name

string

owner_email

string

_weld_synced

date

deal_entity_schema

unique_name

string

integration_id

string

is_deleted

boolean

label

string

last_modified

date

reference_to

string

type

string

_weld_synced

date

deal_entity_value

index

int

integration_id

string

unique_name

string

value

string

_weld_synced

date

engage_flow

string

creation_date

date

exclusive

boolean

folder_id

string

folder_name

string

name

string

visibility

string

_weld_synced

date

lead_entity_schema

unique_name

string

integration_id

string

is_deleted

boolean

label

string

last_modified

date

reference_to

string

type

string

_weld_synced

date

lead_entity_value

index

int

integration_id

string

unique_name

string

value

string

_weld_synced

date

library_folder

string

workspace_id

string

created_by

string

name

string

parent_folder_id

string

updated

date

_weld_synced

date

manual_call

call_id

string

user_id

string

created

date

_weld_synced

date

manual_call_integration

call_id

string

user_id

string

index

int

created

date

account_crm_id

string

deal_crm_id

string

_weld_synced

date

permission_profile

string

workspace_id

string

description

string

name

string

calls_access_permission_level

string

coaching_access_permission_level

string

deals_access_permission_level

string

emails_access_permission_level

string

forecast_permissions_forecast_access_permission_level

string

forecast_permissions_forecast_edit_submissions_permission_level

string

permission_call_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_coaching_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_deal_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_email_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_forecast_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_forecast_edit_submission_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_forecast_edit_target_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_insight_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_usage_access

permission_profile_id

string

user_id

string

index

int

_weld_synced

date

permission_library_folder_access

permission_profile_id

string

library_folder_id

string

index

int

_weld_synced

date

scorecard

scorecard_id

string

workspace_id

string

created

date

enabled

boolean

review_method

string

scorecard_name

string

updated

date

updater_user_id

string

_weld_synced

date

scorecard_question

scorecard_id

string

index

int

question_id

string

answer_guide

string

created

date

is_overall

boolean

max_range

int

min_range

int

question_revision_id

string

scorecard_question_option

string

scorecard_id

string

index

int

question_id

string

text

string

_weld_synced

date

tracker

tracker_id

string

workspace_id

string

affiliation

string

created

date

creator_user_id

string

filter_query

string

part_of_question

boolean

said_at

string

said_at_interval

int

said_at_unit

string

tracker_name

string

updated

date

updater_user_id

string

_weld_synced

date

tracker_language

tracker_id

string

index

int

include_related_forms

boolean

language

string

_weld_synced

date

language_keywords

tracker_id

string

index

int

tracker_language

string

keyword

string

_weld_synced

date

tracker_said_in_topic

tracker_id

string

index

int

keyword

string

_weld_synced

date

tracker_said_in_call_parts

tracker_id

string

index

int

keyword

string

_weld_synced

date

transcript

call_id

string

index

int

speaker_id

string

topic

string

_weld_synced

date

transcript_sentence

call_id

string

index

int

transcript_index

int

start

long

end

long

text

string

_weld_synced

date

user

string

active

boolean

created

date

email_address

string

extension

string

first_name

string

last_name

string

manager_id

string

meeting_consent_page_url

string

user_email_alias

user_id

string

index

int

string

_weld_synced

date

user_meeting_url

user_id

string

index

int

url

string

_weld_synced

date

user_spoken_language

user_id

string

index

int

language

string

primary

boolean

_weld_synced

date

user_setting_history

user_id

string

setting

string

time

date

value

boolean

_weld_synced

date

workspace

string

name

string

description

string

_weld_synced

date