id🔑
cta ➤ CALL_TO_ACTION
created_by ➤ USER
success_plan ➤ SUCCESS_PLAN
tesk ➤ CS_TASK
linked_object ➤ COMPANY_PERSON
modified_by ➤ USER
created_date
deleted
external_object
external_object_id
modified_date
context_date
id 🔑
company_id ➤ COMPANY
created_date
dynamic_resolution
external_Id
first_name
gs_created_by
gs_ingestion_source
gs_modified_by
gainsight_license_enabled
last_name
license_type
locale
master_avatart_type_code
master_record_id
modified_date
name
preferred_notification_source
sfdc_user_id
super_admin
system_type
timezone
user_title
username
is_active
manager
profile_picture
USER ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
comments
created_date
dynamic_resolution_key
country_iso_code
email_opt-out
linkedIn_url
external_id
first_name
last_name
location
master_avatar_type_coe
master_record_id
middle_name
modified_date
name
timezone
PERSON ⇱
id 🔑
modified_By ➤ USER
csm➤ USER
parent_company ➤ COMPANY
relationship_id ➤ RELATIONSHIP
created_by ➤ USER
type_id ➤RELATIONSHIP_TYPE
scoredcard_id ➤ SCORECARD_MASTER
arr
average_nps
biling_address
company_type
created_date
current_score
customer_lifetime_In_months
employees
lifecycle_in_weeks
nps_last_updated
overall_score_comments
renewal_date
current_score
mrr
name
nps
onetime_revenue
original_contract_date
previous_score
stage
status
trend
tags
ticker_synbol
users
csat
csat_last_updated
industry
managed_as
modified_date
name
sfdc_account_id
status
summary
testing
COMPANY ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
created_date
deleted
description
modified_date
name
relationship_type_category
sfdc_relationship_type_id
RELATIONSHIP_TYPE ⇱
RELATIONSHIP ⇱
id 🔑
company_id ➤ COMPANY
created_by ➤ USER
modified_by ➤ USER
arr
csat
csat_last_updated
csm
comments
created_date
lifetime_in_months
mrr
modified_date
nps
nps_last_updated
name
onetime_revenue
original_contract_date
overall_score_comments
previous_score
sfdc_relationship_id
scorecard_id
stage
status
current_score
trend
type_id
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
created_by ➤ USER
modified_by ➤ USER
relatonship_id ➤ RELATIONSHIP
relationship_type_id ➤ RELATIONSHIP_TYPE
person_id ➤ PERSON
active
created_date
external_accoount_id
external_contract_id
manager
modified_date
primary_Company
role
title
RELATIONSHIP_PERSON ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
company_id ➤ COMPANY
person_id ➤ PERSON
active
created_date
external_account_id
external_contact_id
manager
modified_date
primary_company
role
title
COMPANY_PERSON ⇱
PEOPLE_MAP_INFLUENCERS ⇱
id 🔑
creatd_by ➤ USER
modified_by ➤ USER
company_person_id ➤ COMPANY_PERSON
Influencer_Id ➤ COMPANY_PERSON
created_date
modified_date
sentiment
type
notes
PRICEBOOK ⇱
id 🔑
modified_by ➤ USER
created_by ➤ USER
created_date
modified_date
deleted
description
external_id
is_active
is_standard
name
CALL_TO_ACTION ⇱
ID🔑
company ➤ Company
owner ➤ USER
relationship ➤ RELATIONSHIP
success_plan ➤ SUCCESS_PLAN
created_by ➤ USER
modified_by ➤ USER
relationship_type ➤ RELATIONSHIP_TYPE
objective_category ➤ DA_PICKLIST
playbook ➤ PLAYBOOK
close_source
close_date
cloased_task_count
comments
due_date
entity_type
event_properties
is_closed
is_draft
is_importantIs_recurring
name
next_action_due_date
open_task_count
original_due_date
parent_id
sharing_type
start_date
age
created_date
created_date_in_user_timezone
days_allocated
days_due
days_past_due_date
due_date_variance
is_closed_overdue
is_overdue
is_snoozed
modified_date
priority
reason
rule_action_id
snooze_reason
snoozed_on
snoozed_until
source
status
success_criteria
template_display_order
type
dependency_meta
overdue_type
percent_complete
total_task_count
id🔑
owner ➤ USER
playBook ➤ PLAYBOOK
relationship ➤ RELATIONSHIP
relationship_type ➤ RELATIONSHIP_TYPE
created_by ➤ USER
Modified_by ➤ USER
company ➤ COMPANY
cta ➤ CALL_TO_ACTION
status ➤ DA_PICKLIST
timeline_activity_id ➤ ACTIVITY_TIMELINE
close_source
closed_date
description
display_order
due_date
dynamic_metadata
entity_type
is_closed
is_important
name
original_due_date
parent_task
playbook_task
priority
source
start_date
sync_status
created_date
days_allocated
days_due
days_past_due_date
dependency_meta
due_date_variance
is_closed_overdue
s_email_sent
is_overdue
last_update_source
modified_date
overdue_type
to_email_type
type
id🔑
created_by ➤ USER
relationship_type ➤ RELATIONSHIP_TYPE
cta_type ➤ DA_PICKLIST
modified_by ➤ USER
created_date
description
entity_type
is_active
is_auto_sync_enabled
modified_date
name
task_count
used_count
SUCCESS_PLAN ⇱
id🔑
company ➤ COMPANY
owner ➤ USER
created_by ➤ USER
relationship ➤ RELATIONSHIP
relationship_type ➤ RELATIONSHIP_TYPE
modified_by ➤ USER
cta_type ➤ DA_PICKLIST
action_plan
active_date
cta_group_category
close_source
closed_lost_objective_count
closed_task_count
closed_won_objective_count
description
due_date
entity_type
highlights
is_closd
name
open_objective_count
open_task_count
sharing_type
source
start_date
status
type
closed_date
created_date
days_allocated
days_due
days_past_due_date
due_date_variance
is_closed_overdue
is_overdue
modified_date
original_due_date
overdue_type
percent_complete
total_objective_count
ACTIVITY_ATTENDEE ⇱
activity_id ➤ ACTIVITY_TIMELINE
external_attendee_id ➤ COMPANY_PERSON
internal_attendes_id ➤ USER
external_attendee_sfdc_id ➤ COMPANY_PERSON.extrtnal_contact_id
internal_attendee_sfdc_id ➤ USER.external_id
attendee_type
id 🔑
account_id ➤ COMPANY
relationship_id ➤ RELATIONSHIP
author_id ➤ USER
company_id ➤ COMPANY
created_by_user_id ➤ USER
lastModified_by_user_id ➤ USER
relationship_id ➤ RELATIONSHIP
relationship_type_id ➤ RELATIONSHIP_TYPE
context_id ➤ RELATIONSHIP_TYPE/COMPANY
relationship_type_id ➤ RELATIONSHIP_TYPE
user_id ➤ USER.sfdc_user_id
activity_date
context_name
created_by
created_date
doc_version
duration
external_attendees
internal_attendees
last_modified_by
last_modified_date
notes
reporting_category
source
subject
type
type_name
user_email
user_name
user_profile
external_id
milestone_type
mlestone_type_name
sfdc_cta_id
score_details
scorecard
scorecard_measure
ACTIVITY_TIMELINE ⇱
id 🔑
relationship_type_id ➤ RELATIONSHIP_TYPE
survey_id ➤ SURVEY_VIEW
modified_by ➤ USER
created_by ➤ USER
advanced_outreach_code
advanced_outreach_model
advanced_outreach_model_process_key
advanced_outreach_model_process_type
advanced_outreach_name
advanced_outreach_start_date
advanced_outreach_type
advanced_outreach_configuration
bpmn_file_aame
display_name_mapping
log_emails_to_salesforceE
relationship_type_name
send_unique_email
step_json
survey_closed_date
survey_name
svg_nml
unique_criteria
xdays
created_at
default_account_id
default_account_nme
deleted
exclusion_list_identifier
exclusion_list_urll
favourite
folder_id
modified_at
paused_on
ADVANCED_OUTREACH ⇱
id 🔑
advanced_outreach_id ➤ ADVANCED_OUTREACH
cta_id ➤ ADVANCED_OUTREACH_CTA
partcipant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
step_id ➤ ADVANCED_OUTREACH_PARTICIPANT_ACTIVITY
created_at
deleted
modified_at
ADVANCED_OUTREACH_CTA_MAPPING ⇱
Id 🔑
relationship_id ➤ RELATIONSHIP
relationship_type_id ➤ RELATIONSHIP_TYPE
user_id ➤ USER
account_id
account_name
address_type
batch_id
batch_name
clicked
contact_id
delayed
email_address
external_email_id
marked_spam
opened
parent_id
person_name
rejected
sent
soft_bounced
template_name
triggered_on
unsubscribed
use_case
user_name
click_count
clicked_ip
clicked_on
clicked_url
created_date
delayed_on
event_message
execustion_instance_id
hard_bounce_on
marked_spam_on
metadata
open_count
rejected_on
relationship_contact_id
relationship_contact_name
relationship_name
relationship_type_name
soft_bounce_on
template_id
triggered_date
unsubscribed_on
associated_field
associated_objet
associated_value
case_senstive_email_address
id 🔑
created_by ➤ USER
modified_by ➤ USER
created_date
dynamic_resolution_key
external_id
first_name
last_name
master_avatar_type_cose
master_record_Id
modified_date
name
ANONYMOUS_PERSON ⇱
id 🔑
modified_by ➤ USER
created_by ➤ USER
internal_question_submitted_by➤ USER
ao_participant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
company_Id ➤ COMPANY
Ianguage_id ➤ LANGUAGE
relationship_id ➤ RELATIONSHIP
person_id ➤ PERSON
responded_by ➤ USER
source_id ➤ COMPANY_PERSON
survey_id ➤ SURVEY_VIEW
distribution_channel
first_name
full_nmae
internal_question_submission_date
internal_question_submitted
last_name
last_response_record_time
responded
responded_date
role
survey_opened_date
survey_sent_date
survey_opened
test_partcipant
token
created_aate
deleted
external_association_id
external_id
external_source
group_id
link_id
modified_date
response_status
response_url
SURVEY_PARTICIPANT ⇱
id 🔑
modified_by ➤ USER
owner_id ➤ USER
created_by ➤ USER
relationship_type_id ➤ RELATIONSHIP_TYPE
allow_internal_submission
category
created_date
description
end_date
entity_type
external_id
external_source
last_response_tracked_at
link_expiry_days
modified_date
nps_survey
name
partial_submit_days
published_date
published_url
question_count
start_date
status
title
type
user_responded_count
code
deleted
folder_id
SURVEY_VIEW ⇱
action_type
created_by ➤ USER
modified_by ➤ USER
log_id ➤ PERSON’
person_Id ➤ PERSON
survey_id ➤ SURVEY_VIEW
participant_id ➤ SURVEY_PARTICIPANT
created_by_name
created_date
deleted
modified_by_name
modified_date
SURVEY_AUDIT_LOG ⇱
id 🔑
created_by ➤ USER
opportunity_owner ➤ USER
modified_by ➤ USER
record_type ➤ RECORD_TYPE
relationship ➤ RELATIONSHIP
pricebook ➤ PRICEBOOK
change_amount
close_date
ds_forecast_amount
ds_likelihood_amount
description
due_date
external_id
final_amount
forecast_amount
forecast_category
booking_type
has_line_item
inferred_booking_type
modified_date
name
next_step
opportunity_currency
stage
target_amount
type
booking_type_value
churn_notes
churn_reason
churn_total
ds_scoew_updated_at
deleted
expected_forecast
inferred_booking_type_value
opportunity_source
probability
OPPORTUNITY ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
active
apiName
closed
created_date
default_probability
deleted
description
external_id
forecast_category
forecast_category_id
master_label
modified_date
sort_order
stage_picklist_id
won
OPPORTUNITY_STAGE ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
opportunity ➤ OPPORTUNITY
price_book_entry ➤ PRICEBOOK_ENTRY
product ➤ PRODUCT
created_date
deleted
modified_date
description
external_id
name
opportunity_line_item_source
quality
sales_price
total_price
OPPORTUNITY_LINE_ITEM ⇱
id 🔑
modified_by ➤ USER
created_by ➤ USER
active
created_date
deleted
description
object_name
modified_date
name
sobject_type
RECORD_TYPE ⇱
id 🔑
company_id ➤ COMPANY
person_id ➤ PERSON
relationship_id ➤ RELATIONSHIP
changed
changed_info
contact_id
created_at
deleted
entity_eype
last_change_details
last_change_modified_by
last_change_modified_date
linkedin_urll
modified_at
photo_url
sfdc_account_id
sfdc_id
sfdc_relationship_id
social_profile
source_type
sponsor_full_name
status
SPONSOR_TRACKING ⇱
id 🔑
company_id ➤ COMPANY
person_id ➤ PERSON
relationship_id ➤ RELATIONSHIP
changed_attribute
contact_value
created_at
current_value
deleted
entity_type
modified_at
previous_value
sfdc_acoount_id
sfdc_id
sfdc_relationship_id
source_type
sponsor_tracking_id
SPONSOR_TRACKING_LOG ⇱
id 🔑
company_id ➤ COMPANY
shared_with_user_id ➤ USER
shared_by_user_id ➤ USER
relationship_id ➤ RELATIONSHIP
comments
created_at
deleted
distribution_type
link_send_status
llnk_viewed
modified_at
service_type
shared_setting_Id
token_expiry
token_status
USER_SHARED_DETAIL ⇱
id 🔑
company_id ➤ COMPANY
current__score_id ➤SCORING_SCHEME_DEFINITION
scorecard_id ➤ SCORECARD_MASTER
measure_id ➤ SCORECARD_MASTER
previous_score_id ➤ SCORING_SCHEME_DEFINITION
score_modified_by ➤ USER
modified_date
created_date
trend
SCORECARD_FACT ⇱
id 🔑
modified_by ➤ USER
created_by ➤ USER
active
created_date
entity_type
Is_Default
modified_date
name
SCORECARD_MASTER ⇱
id 🔑
modified_by ➤ USER
created_by ➤ USER
active
colorcreated_date
deleted
label
modified_date
name
range_from
range_to
score
SCORING_SCHEME_DEFINITION ⇱
id 🔑
created_by_id ➤ USER
company_id ➤ COMPANY
current_score_id ➤SCORING_SCHEME_DEFINITION
previous_score_Id ➤SCORING_SCHEME_DEFINITION
scorecard_id ➤ SCORECARD_MASTER
modified_by_id ➤ USER
measure_id ➤SCORECARD_MEASURE
score_modified_by_id ➤ USER
active
comments
created_date
modified_datye
score_modified_at
trend
UNIFIED_SCORECARD_FACT_COMPANY ⇱
CS_TASK ⇱
id 🔑
lead_contact ➤ COMPANY_PERSON
company ➤ COMPANY
created_by ➤ USER
lead_owner ➤ USER
modified_by ➤ USER
opportunity ➤ OPPORTUNITY
amount
contact_email
contact_first_name
contact_last_name
contact_phone
converted_date
created_date
deleted
description
external_id
is_converted
lead_status
modified_date
name
source
LEAD ⇱
Id
Modified_by ➤ USER
Pricebook ➤ PRICEBOOK
created_by ➤ USER
product ➤ PRODUCT
modified_date
created_date
deleted
external_id
is_active
list_price
name
user_standatd
PRICEBOOK_ENTRY ⇱
Id 🔑
is_configured
platform_name
COMPANY_INTELLIGENCE_PLATFORM ⇱
COMPANY_INTELLIGENCE_CONFIGURATION_HISTORY ⇱
Id 🔑
opt_in_id ➤ COMPANY_INTELLIGENCE_CONFIGURATION
created_by ➤ USER
companies_added
companies_removed
companies_resolved
created_date
event_name
save_status
total_companies
Id 🔑
cta_id ➤ CALL_TO_ACTION
activity_id ➤ ACTIVITY_TIMELINE
created_by ➤ USER
modified_by ➤ USER
action_type
created_date
modified_date
source
COMPANY_INTELLIGENCE_ACTIONS_OBJECT ⇱
COMPANY_INTELLIGENCE_MAPPING ⇱
company_id ➤ COMPANY
opt_in_id ➤ COMPANY_INTELLIGENCE_CONFIGURATION
company_domain
mapping_status
not_found_reason
opt_in_notes
COMPANY_INTELLIGENCE_CONFIGURATION ⇱
Id 🔑
created_by ➤ USER
modified_by ➤ USER
companies_type
created_date
description
modified_date
name
url_field
companies
signales
Id 🔑
created_by ➤ USER
modified_by ➤ USER
contant
created_date
is_pulled
link
modified_date
published_date
publisher
title
actions
companies
signals
COMPANY_INTELLIGENCE_NEWS_POSTS ⇱
Id 🔑
Opportunity ➤ OPPORTUNITY
created_by ➤ USER
modified_by ➤ USER
created_date
ds_forecast_amount
ds_likelihood_score
deleted
description
ds_likelihood_color
modified_date
OPPORTUNITY_PREDICTION ⇱
id 🔑
Answer_id ➤ SURVEY_ALLOWED_ANSWER
Participant_id ➤ SURVEY_PARTCIPANT
Question_id ➤ SURVEY_QUESTION
Survey_id ➤ SURVEY_VIEW
Created_by ➤ USER
Modified_by ➤ USER
answer_rank
answer_text
created_date
deleted
modified_date
responded_date
SURVEY_USER_ANSWER ⇱
id 🔑
Answer_id ➤ SURVEY_ALLOWED_ANSWER
Survey_id ➤ SURVEY_VIEW
language_id ➤ LANGUAGE
library_question_id ➤ SURVEY_QUESTION_LIBRARY
page_id ➤ SURVEY_PAGE
survey_question_id ➤ SURVEY_QUESTION
Created_by ➤ USER
Modified_by ➤ USER
created_date
deleted
modified_date
category
code
display_order
translation
SURVEY_TRANSLATION ⇱
id 🔑
Created_by ➤ USER
Modified_by ➤ USER
active
allow_comment
comment_label
external_id
external_source
group_type
reporting_label
created_date
deleted
modified_date
display_order
selector
title
type
SURVEY_QUESTION_LIBRARY ⇱
id 🔑
Created_by ➤ USER
Modified_by ➤ USER
comment_label
created_date
deleted
modified_date
display_order
title
SURVEY_PAGE ⇱
id 🔑
survey_id ➤ SURVEY_VIEW
page_id ➤ SURVEY_PAGE
Created_by ➤ USER
Modified_by ➤ USER
active
allow_comment
comment_label
external_id
external_source
group_type
reporting_label
created_date
deleted
modified_date
title
type
display_order
formatted_text
selector
SURVEY_QUESTION ⇱
id 🔑
Created_by ➤ USER
Modified_by ➤ USER
description
namel
created_date
deleted
modified_date
SURVEY_FOLDER ⇱
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
language_id ➤ LANGUAGE
participant_id ➤ SURVEY_PARTCIPANT
relationship_person_id ➤ RELATIONSHIP_PERSON
person_id ➤ PERSON
survey_id ➤ SURVEY_VIEW
relationship_id ➤ RELATIONSHIP
Created_by ➤ USER
Modified_by ➤ USER
batch_id
comment
nps
name
responded_date
role
score_type
sentiment
true_nps
external_id
external_source
created_date
deleted
modified_date
score_type
NPS_SURVEY_RESPONSE ⇱
id 🔑
survey_id ➤ SURVEY_VIEW
survey_question_id ➤ SURVEY_QUESTION
Created_by ➤ USER
Modified_by ➤ USER
link_id
answer_score
active
default_answer
external_id
external_source
reporting_label
created_date
deleted
modified_date
title
display_order
other_option
SURVEY_ALLOWED_ANSWER ⇱
id 🔑
Created_by ➤ USER
Modified_by ➤ USER
engagement_id
error_message
event_date
event_id
event_name
event_type
execution_id
px_user_id
payload
question_added
question_failed
request_id
retry_count
status
SURVEY_PX_EXECUTION_LOG ⇱
id 🔑
Created_by ➤ USER
Modified_by ➤ USER
active
code
iso_code
name
source
created_date
deleted
modified_date
display_order
LANGUAGE ⇱
id 🔑
survey_id ➤ SURVEY_VIEW
language_id ➤ LANGUAGE
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
participant_id ➤ SURVEY_PARTCIPANT
person_id ➤ PERSON’
question_id ➤ SURVEY_QUESTION
relationship_id ➤ RELATIONSHIP
relationship_person_id ➤ RELATIONSHIP_PERSON
user_answer_id ➤ SURVEY_USER_ANSWER
Created_by ➤ USER
Modified_by ➤ USER
external_id
external_source
created_date
score_type
role
modified_date
responded_date
name
comment
csat_score
csat_percent
CSAT_SURVEY_RESPONSE ⇱
id 🔑
company_id ➤ COMPANY
relationship_id ➤ RELATIONSHIP
modified_by ➤ USER
created_by ➤ USER
created_date
modified_date
overall_score
RELATIONSHIP_SCORECARD_HISTORY ⇱
id 🔑
company_id ➤ COMPANY
modified_by ➤ USER
created_by ➤ USER
created_date
modified_date
overall_score
ACCOUNT_SCORECARD_HISTORY ⇱
id 🔑
company_id ➤ COMPANY
current_score_id ➤SCORING_SCHEME_DEFINITION
measure_id ➤SCORECARD_MEASURE
previous_score_id ➤SCORING_SCHEME_DEFINITION
scoreard_id ➤ SCORECARD_MASTER
relationship_id ➤ RELATIONSHIP
modified_by ➤ USER
created_by ➤ USER
score_modified_by ➤ USER
active
comments
score_modified_at
trend
created_date
modified_date
UNIFIED_SCORECARD_FACT_RELATIONSHIP ⇱
id 🔑
measure_id ➤SCORECARD_MEASURE
modified_by ➤ USER
created_by ➤ USER
relationship_id ➤ RELATIONSHIP
score_id ➤SCORING_SCHEME_DEFINITIO
scorecard_id ➤ SCORECARD_MASTER
account_id ➤ COMPANY
activity_id ➤ ACTIVITY_TIMELINE
score_modified_by ➤ USER
automated
comments
created_date
deleted
fact_id
modified_date
score_modified_at
SCORECARD_TIMELINE_MAPPING ⇱
COCKPIT_ASSOCIATED_RECORD ⇱
id🔑
display_order
name
type
REPORTING_CATEGORY ⇱
id🔑
relationship_type ➤ RELATIONSHIP_TYPE
reporting_category ➤ REPORTING_CATEGORY
access_allow
access_ids
category
color
cta_type
display_order
entity_type
is_active
is_for_Success_plan
is_open
is_recurring
name
plural_label
reporting_category
sp_type
system_defined
system_name
DA_PICKLIST ⇱
id🔑
playbook_id ➤ PLAYBOOK
relatonship_type ➤ RELATIONSHIP_TYPE
created_by ➤ USER
modified_by ➤ USER
context_id
created_date
deleted
display_order
entity_type
is_active
modified_date
name
parent_id
template_json
template_type
COCKPIT_TEMPLATE ⇱
Id 🔑
relationship_id ➤ RELATIONSHIP
relationship_person_id ➤ RELATIONSHIP_PERSON
relationship_type_id ➤ RELATIONSHIP_TYPE
user_id ➤ USER
person_id ➤ PERSON
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
category_ids ➤ OPT_OUT_PAGE
source_id ➤ADVANCED_OUTREACH_PARTICIPANT
address_type
bounced
email_id
email_template_id
email_template_name
email_template_version
email_in_lower_case
first_opened_date
from_email_id
from_name
latest_open_date
name
number_of_opens
opened
rejected
rejected_date
reply_to_email_id
reply_to_name
sent
sent_date
source
source_name
triggered_date
bounce_type
bounced_date
bounced_reason
external_company_id
external_company_person_id
external_relationship_id
external_relationship_person_id
external_relationship_type_id
external_user_id
link_click_date
link_clicked_count
link_clicked_json
person_type
recipient_id
spam
spam_marked_date
unsubscribed
unsubscribed_date
created_date
email_content_id
email_group_id
group_email
modified_date
page_id
parent_recipient_id
record_external_id
record_external_name
record_id
request_id
sent_by
EMAIL_LOG_V2 ⇱
id 🔑
user_id ➤ USER
api_version
asset_name
asset_type
event_count
event_type
last_used_timestamp
request_source
source_type
ASSET_USAGE_TRACKING ⇱
Id 🔑
advanced_outreach_id ➤ ADVANCED_OUTREACH
person_id ➤ PERSON
company_id ➤ COMPANY
user_id participant_id ➤ USER
conatct_id
first_name
last_name
full_name
context_id
last_email_sent
last_email_clicked
last_email_status
manager_first_name
manager_last_name
manager_full_name
manager_email_address
participant_state
recipient_email_address
recipient_contatc_name
relationship_name
relationship_status
relationship_type_name
sender_first_name
sender_full_name
sender_last_name
sender_email_address
survey_page_open_count
survey_page_opened
survey_responded
survey_responded_date
survey_responded_status
survey_score
survey_send_date
total_email_sent
person_type
source_type
ADVANCED_OUTREACH_PARTICIPANT ⇱
Id 🔑
advanced_outreach_id ➤ ADVANCED_OUTREACH
participant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
bounce_date
bounce_type
email_clicked
email_clicked_date
email_id
address_type
bounced
email_open_count
email_opened
email_sent
email_template_id
email_template_name
from_address
last_emaik_opened_date
link_clicked_count
page_open_count
rejected
rejected_date
spam
spam_date
to_address
undelivered
undelivered_reason
unsubscribed
unsubscribed_date
ADVANCED_OUTREACH_EMAIL ⇱
Id 🔑
advanced_outreach_id ➤ ADVANCED_OUTREACH
particiapnt_id ➤ ADVANCED_OUTREACH_PARTICIPANT
created_at
current_step_id
current_step_name
modified_at
particiapnt_activity_id
previous_step_id
previous_step_name
ADVANCED_OUTREACH_PARTICIPANT_ACTIVITY ⇱
Id 🔑
advanced_outreach_id ➤ ADVANCED_OUTREACH
csv_headers
created_at
csv_name
deleted
event_meta_data
event_name
event_version
mapping_infornation
modified_at
participant_operation_type
participant_source_collection_id
participant_source_configuration_id
participant_source_name
participant_source_type
refresh_powerlist_flag
rule_id
s3_url
topic_name
ADVANCED_OUTREACH_PARTICIPANT_SOURCE_CONFIGURATION ⇱
Id 🔑
advanced_outreach_model_id
advanced_outreach_model_name
advanced_outreach_model_type
bpmn_file_name
bpmn_process_id
created_at
deleted
modified_at
svg_xml
ADVANCED_OUTREACH_PREDEFINED_MODEL ⇱
id 🔑
cta_id ➤ ADVANCED_OUTREACH_CTA_EVENTS
source_step_id ➤ ADVANCED_OUTREACH_PARTICIPANT_ACTIVITY
relationship_id ➤ RELATIONSHIP
account
action_type
area_name
cta_name
cta_status
created_at
deleted
entity_type
is_name_identifier
modified_at
ADVANCED_OUTREACH_CTA ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
code
created_at
deleted
description
disabled
last_updated_date
type
OPT_OUT_CATEGORIES ⇱
id 🔑
category_id ➤ OPT_OUT_CATEGORIES
page_id ➤ OPT_OUT_PAGE
company_id ➤ COMPANY
created_by ➤ USER
modified_by ➤ USER
entity_id ➤ COMPANY/RELATIONSHIP
person_id ➤ PERSON
language_id ➤ LANGUAGE
created_at
deleted
email_address
email_log_id
entity_name
entity_type
fullname
last_updated_date
person_type
reason
reason_text
reason_type
OPT_OUT_EMAIL ⇱
id 🔑
created_by ➤ USER
modified_by ➤ USER
category_ids
created_at
deleted
description
language_ids
last_updated_date
name
page_type
OPT_OUT_PAGE ⇱
Id 🔑
account_name
advanced_outreach_id ➤ ADVANCED_OUTREACH
company_id ➤ COMPANY
relationship_person_id ➤ RELATIONSHIP_PERSON
relationship_id ➤ RELATIONSHIP
relationship_type_id ➤ RELATIONSHIP_TYPE
user_id ➤ USER
person_id ➤ PERSON
context_attribute_boolean
context_attribute_date
context_attribute_decimal
context_attribute_email
context_attribute_integer
context_attribute_string
context_display_name
context_id
context_name
context_object_source
context_url
created_at
deleted
external_id
failure_reason
failure_reason_jspn
first_name
full_name
manager_user_id
source_id
last_name
last_updated_date
manager_emsil_address
manager_first_name
manager_full_name
manager_last_name
ouccurence_count
partcipant_created_by
partcipant_json
partcipant_source_name
person_type
recepient_emsil_address
relationship_contact_id
relationship_contact_name
relationship_contact_name
relationship_status
relationship_type_name
sender_emil_address
sender_full_name
sender_last_name
sfdc_account_id
sfdc_contact_id
sfdc_relationship_id
sfdc_relationship_type_id
sfdc_user_id
source_type
unique_criteria
ADVANCED_OUTREACH_FAILED_PARTICIPANT ⇱
Id 🔑
advanced_outrech_id ➤ ADVANCED_OUTREACH
participant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
step_id ➤ ADVANCED_OUTREACH_PARTICIPANT_ACTIVITY
completed_date
created_at
deleted
engagement_event_type
engagement_id
engagement_name
engagement_type
last_viewed_date
modified_at
parent_event_id
parent_external_id
px_user_id
status
triggered_date
viewed_count
viewed_date
ADVANCED_OUTREACH_ENGAGMENT_MAPPING ⇱
id🔑
cta_id ➤ CALL_TO_ACTION
created_at
deleted
event_name
event_time
event_type
modified_at
ADVANCED_OUTREACH_CTA_EVENTS ⇱
Id 🔑
relationship_id ➤ RELATIONSHIP
company_id ➤ COMPANY
account_id
address_type
batch_id
batch_name
clicked_url
created_date
email_address
email_log_id
event_date
event_message
external_email_id
ip_address
metadata
parent_gsid
parent_name
template_id
template_name
use_case
variant_id
variant_name
EMAIL_RAW_EVENTS ⇱
id 🔑
entity_id ➤ COMPANY/RELATIONSHIP
area_name
created_date
entity_type
error_count
exception_type
last_modified_date
messag
name
ERROR_LOG ⇱
id 🔑
advanced_outreach_id ➤ ADVANCED_OUTREACH
participant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
step_id step_id ➤ ADVANCED_OUTREACH_PARTICIPANT_ACTIVITY
config_id
config_name
created_at
deleted
execution_date
execution_id
failure_reason
last_response_date
modified_at
response_s3_id
status
status_code
type
PROGRAM_EXTERNAL_API_LOGS ⇱
failed_participant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
created_at
failure_reason
participant_source_name
participant_source_type
ADVANCED_OUTREACH_FAILED_PARTICIPANT_HISTORY ⇱
id 🔑
user ➤ USER
application
location
login_time
login_type
message
source_ip_address
source_session
status
USER_LOGIN_HISTORY ⇱
activity_id ➤ ACTIVITY_TIMELINE
associated_record
created_by
created_date
is_primary_context
ACTIVITY_ASSOCIATED_RECORD ⇱
activity_id ➤ ACTIVITY_TIMELINE
modified_by_user_id ➤ USER
created_by_user_id ➤ USER
comment
comment_id
created_date
modified_date
ACTIVITY_COMMENTS ⇱
activity_id ➤ ACTIVITY_TIMELINE
associated_record
created_by
created_date
is_primary_context
ALL_ACTIVITY_ASSOCIATED_RECORD ⇱
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
created_by ➤ USER
person_id ➤ PERSON
modified_by ➤ USER
created_date
modified_date
map_name
map_type
NAMEDMAP_DETAILS ⇱
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
namedmap_details_id ➤ NAMEDMAP_DETAILS
namedmap_hierarchy_parent_id ➤ NAMEDMAP_HIERARCHY_DATA
created_by ➤ USER
person_id ➤ PERSON
modified_by ➤ USER
created_date
modified_date
namedmap_hierarchy_relationship_type
NAMEDMAP_HIERARCHY_DATA ⇱
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
person_id ➤ PERSON
relationship_id ➤ RELATIONSHIP
relationship_person_id ➤ RELATIONSHIP_PERSON
survey_id ➤ SURVEY_VIEW
survey_participant_id ➤ SURVEY_PARTICIPANT
survey_question_id ➤ SURVEY_QUESTION
user_id ➤ USER
activity_id
activity_type
created_date
keyword
language_code
raw_data_id
recorded_time
sentiment
sentiment_score
source
text
topic
translated_text
XC_CUSTOM_TOPIC_ANA_VIEW ⇱
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
person_id ➤ PERSON
relationship_id ➤ RELATIONSHIP
relationship_person_id ➤ RELATIONSHIP_PERSON
survey_id ➤ SURVEY_VIEW
survey_participant_id ➤ SURVEY_PARTICIPANT
survey_question_id ➤ SURVEY_QUESTION
user_id ➤ USER
activity_id
activity_type
created_date
language_code
raw_data_id
recorded_time
sentiment
sentiment_score
source
text
translated_text
XC_OVERALL_TEXT_ANA_VIEW ⇱
id 🔑
company_id ➤ COMPANY
company_person_id ➤ COMPANY_PERSON
person_id ➤ PERSON
relationship_id ➤ RELATIONSHIP
relationship_person_id ➤ RELATIONSHIP_PERSON
survey_id ➤ SURVEY_VIEW
survey_participant_id ➤ SURVEY_PARTICIPANT
survey_question_id ➤ SURVEY_QUESTION
user_id ➤ USER
activity_id
keyword
activity_type
created_date
language_code
raw_data_id
recorded_time
sentiment
sentiment_score
source
text
translated_text
XC_SYSTEM_KEYWORD_ANA_VIEW ⇱
id 🔑
modified_by ➤ USER
created_by ➤ USER
active
created_date
entity_type
input_type
level_type
modified_date
name
SCORECARD_MEASURE ⇱
Id 🔑
participant_id ➤ ADVANCED_OUTREACH_PARTICIPANT
a_data
b_data
c_data
d_data
e_data
f_data
g_data
h_data
codition_a
codition_b
codition_c
codition_d
codition_e
codition_f
codition_g
codition_h
codition_i
codition_j
created_at
modified_at
step_id
step_name
PARTCIPANT_CRITERIA_STEP_EXECUTION ⇱
PLAYBOOK ⇱
EMAIL_LOG ⇱
id 🔑
associateed_case_id ➤ CASE
parent_case_id ➤ CASE
source_associated_id
source_parent_id
resolved
source_instance_id
modified_date
source_type
created_date
CASE_ASSOCIATIONS ⇱
id 🔑
cta_id ➤ CALL_TO_ACTION
case_id ➤ CASE
external_ticket_id
source_instance_id
Modified_date
created_date
CASE_LEVEL_CTA ⇱
id 🔑
assignee_id ➤ USER
relationship_id ➤ RELATIONSHIP
company_id ➤ COMPANY
case_resolution_date
case_type
case_priority
case_parent_id
case_description
modified_date_at_source
source_id
external_system_id
requester_id
has_linked_issues
source_instance_id
created_date
created_date_at_source
ticket_url
source_org_id
external_id
case_status
source_type
modified_date
case_subject
CASE ⇱
id 🔑
company_id ➤ COMPANY
user_id ➤ USER
created_by ➤ USER
modified_by ➤ USER
company_access_level
created_at
modified_at
Deleted
user_manager_role_1
user_manager_role_2
user_manager_role_3
team_role
user_source
COMPANY_TEAMS ⇱
id 🔑
company_id ➤ COMPANY
relationship_id ➤ RELATIONSHIP
relationship_type_id ➤ RELATIONSHIP_TYPE
created_by ➤ USER
modified_by ➤ USER
record_group_id
error_code
state
request_id
relationship_identifier_hash
source_identifier
modified_date
company_sfdc_account_id
company_name
company_industry
company_status
company_arr
company_mrr
relationship_names
company_type
UNIFIED_COMPANY ⇱
id 🔑
company_id ➤ COMPANY
created_by ➤ USER
modified_by ➤ USER
record_group_id
state
request_id
created_date
modified_date
confidence_factor
is_automated
UNIFIED_COMPANY_REGISTERY ⇱
Note : This is not complete Entity Relationship Diagram. This Shows Relationships for some central Entities.Custom entities are that are delivered by the Fivetran connector are omitted for brevity
LEGEND
🔑 = Primary Key
➤ = Foreign Key Relation
⇱ = External Link