# Gainsight Customer Success schema ERD

Table and field reference for the Fivetran Gainsight Customer Success connector.

## Table & Field Reference

### activity_timeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| account_id | String | FK |
| author_id | String | FK |
| company_id | String | FK |
| created_by_user_id | String | FK |
| last_modified_by_user_id | String | FK |
| relationship_id | String | FK |
| relationship_type_id | String | FK |
| user_id | String | FK |
| activity_date | Instant |  |
| subject | String |  |
| type | String |  |

### reporting_category

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

### advanced_outreach_participant_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advanced_outreach_id | String | FK |
| participant_id | String | FK |
| current_step_id | String |  |
| current_step_name | String |  |

### activity_associated_record

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activity_id | String | FK |
| associated_record | String |  |
| is_primary_context | Boolean |  |

### company_intelligence_mapping

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| opt_in_id | String | FK |
| company_domain | String |  |
| mapping_status | String |  |

### relationship_person

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| relationship_type_id | String | FK |
| active | Boolean |  |
| role | String |  |
| title | String |  |

### activity_attendee

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activity_id | String | FK |
| external_attendee_id | String | FK |
| internal_attendee_id | String | FK |
| attendee_type | String |  |

### da_picklist

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| relationship_type | String | FK |
| reporting_category | String | FK |
| category | String |  |
| entity_type | String |  |
| name | String |  |

### pricebook_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| pricebook | String | FK |
| product | String | FK |
| is_active | Boolean |  |
| list_price | Double |  |

### advanced_outreach_cta

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cta_id | String | FK |
| relationship_id | String | FK |
| source_step_id | String | FK |
| cta_name | String |  |
| cta_status | String |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| csm | String | FK |
| modified_by | String | FK |
| parent_company | String | FK |
| relationship_id | String | FK |
| scorecard_id | String | FK |
| type_id | String | FK |
| arr | Double |  |
| mrr | Double |  |
| name | String |  |
| stage | String |  |
| status | String |  |

### opt_out_categories

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| code | String |  |
| type | String |  |

### unified_company

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| relationship_id | String | FK |
| relationship_type_id | String | FK |
| state | String |  |

### company_teams

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| user_id | String | FK |
| team_role | String |  |

### activity_comments

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activity_id | String | FK |
| created_by_user_id | String | FK |
| modified_by_user_id | String | FK |
| comment | String |  |

### sponsor_tracking_log

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| sponsor_tracking_id | String | FK |

### opt_out_email

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| category_id | String | FK |
| company_id | String | FK |
| created_by | String | FK |
| language_id | String | FK |
| modified_by | String | FK |
| page_id | String | FK |
| person_id | String | FK |
| email_address | String |  |

### email_raw_events

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| relationship_id | String | FK |
| email_address | String |  |
| event_type | String |  |

### relationship_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| name | String |  |
| relationship_type_category | String |  |

### cs_task

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company | String | FK |
| created_by | String | FK |
| cta | String | FK |
| modified_by | String | FK |
| owner | String | FK |
| playbook | String | FK |
| relationship | String | FK |
| relationship_type | String | FK |
| status | String | FK |
| timeline_activity_id | String | FK |
| due_date | Instant |  |
| is_closed | Boolean |  |
| name | String |  |

### people_map_influencers

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_person_id | String | FK |
| created_by | String | FK |
| influencer_id | String | FK |
| modified_by | String | FK |
| sentiment | String |  |
| type | String |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| opportunity_owner | String | FK |
| pricebook | String | FK |
| record_type | String | FK |
| relationship | String | FK |
| close_date | Instant |  |
| forecast_amount | Double |  |
| name | String |  |
| probability | Double |  |
| stage | String |  |

### survey_allowed_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| survey_id | String | FK |
| survey_question_id | String | FK |
| answer_score | Double |  |
| title | String |  |

### unified_company_registery

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| confidence_factor | Double |  |

### case

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| assignee_id | String | FK |
| company_id | String | FK |
| relationship_id | String | FK |
| case_priority | String |  |
| case_status | String |  |
| case_subject | String |  |
| case_type | String |  |

### nps_survey_response

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| participant_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| relationship_person_id | String | FK |
| survey_id | String | FK |
| nps | Double |  |
| sentiment | String |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company | String | FK |
| created_by | String | FK |
| lead_contact | String | FK |
| lead_owner | String | FK |
| modified_by | String | FK |
| opportunity | String | FK |
| is_converted | Boolean |  |
| lead_status | String |  |
| name | String |  |

### language

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| code | String |  |
| iso_code | String |  |
| name | String |  |

### cockpit_template

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| playbook_id | String | FK |
| relationship_type | String | FK |
| name | String |  |

### case_associations

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| associated_case_id | String | FK |
| parent_case_id | String | FK |

### company_intelligence_actions_object

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activity_id | String | FK |
| created_by | String | FK |
| cta_id | String | FK |
| modified_by | String | FK |

### advanced_outreach

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| relationship_type_id | String | FK |
| survey_id | String | FK |
| advanced_outreach_name | String |  |
| survey_name | String |  |

### relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| scorecard_id | String | FK |
| type_id | String | FK |
| arr | Double |  |
| mrr | Double |  |
| name | String |  |
| stage | String |  |
| status | String |  |

### unified_scorecard_fact_company

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| current_score_id | String | FK |
| measure_id | String | FK |
| previous_score_id | String | FK |
| score_modified_by_id | String | FK |
| scorecard_id | String | FK |

### xc_custom_topic_ana_view

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| survey_id | String | FK |
| survey_participant_id | String | FK |
| survey_question_id | String | FK |
| user_id | String | FK |
| sentiment | String |  |
| topic | String |  |

### xc_system_keyword_ana_view

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| survey_id | String | FK |
| keyword | String |  |
| sentiment | String |  |

### call_to_action

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| objective_category | String | FK |
| owner | String | FK |
| playbook | String | FK |
| relationship | String | FK |
| relationship_type | String | FK |
| success_plan | String | FK |
| is_closed | Boolean |  |
| name | String |  |
| priority | String |  |
| status | String |  |

### opportunity_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| default_probability | Double |  |
| forecast_category | String |  |
| master_label | String |  |

### advanced_outreach_cta_mapping

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advanced_outreach_id | String | FK |
| cta_id | String | FK |
| participant_id | String | FK |
| step_id | String | FK |

### company_intelligence_news_posts

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| publisher | String |  |
| title | String |  |

### survey_user_answer

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| answer_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| participant_id | String | FK |
| question_id | String | FK |
| survey_id | String | FK |
| answer_text | String |  |

### advanced_outreach_cta_events

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| cta_id | String | FK |
| event_name | String |  |
| event_type | String |  |

### survey_question

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| page_id | String | FK |
| survey_id | String | FK |
| title | String |  |
| type | String |  |

### product

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

### scorecard_measure

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| entity_type | String |  |
| name | String |  |

### scorecard_master

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| is_default | Boolean |  |
| name | String |  |

### company_intelligence_configuration_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| opt_in_id | String | FK |
| event_name | String |  |

### unified_scorecard_fact_relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| current_score_id | String | FK |
| measure_id | String | FK |
| previous_score_id | String | FK |
| relationship_id | String | FK |
| score_modified_by | String | FK |
| scorecard_id | String | FK |

### company_intelligence_configuration

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| companies_type | String |  |
| name | String |  |

### scorecard_fact

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| current_score_id | String | FK |
| measure_id | String | FK |
| previous_score_id | String | FK |
| score_modified_by | String | FK |
| scorecard_id | String | FK |
| trend | String |  |

### namedmap_details

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| person_id | String | FK |
| map_name | String |  |
| map_type | String |  |

### csat_survey_response

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| language_id | String | FK |
| participant_id | String | FK |
| person_id | String | FK |
| question_id | String | FK |
| relationship_id | String | FK |
| survey_id | String | FK |
| user_answer_id | String | FK |
| csat_percent | Double |  |
| csat_score | Double |  |

### survey_view

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| owner_id | String | FK |
| relationship_type_id | String | FK |
| name | String |  |
| status | String |  |
| title | String |  |
| type | String |  |

### opportunity_prediction

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| opportunity | String | FK |
| ds_forecast_amount | Double |  |
| ds_likelihood_score | Double |  |

### all_activity_associated_record

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activity_id | String | FK |
| associated_record | String |  |
| is_primary_context | Boolean |  |

### case_level_cta

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| case_id | String | FK |
| cta_id | String | FK |

### email_log_v_2

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| relationship_person_id | String | FK |
| relationship_type_id | String | FK |
| source_id | String | FK |
| user_id | String | FK |
| clicked | Boolean |  |
| email_id | String |  |
| opened | Boolean |  |
| sent | Boolean |  |

### user

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| manager | String | FK |
| created_date | Instant |  |
| email | String |  |
| is_active | Boolean |  |
| modified_date | Instant |  |
| name | String |  |
| username | String |  |

### advanced_outreach_email

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advanced_outreach_id | String | FK |
| participant_id | String | FK |
| email_clicked | Boolean |  |
| email_opened | Boolean |  |
| email_sent | Boolean |  |

### company_person

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| created_by | String | FK |
| modified_by | String | FK |
| person_id | String | FK |
| active | Boolean |  |
| role | String |  |
| title | String |  |

### pricebook

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| is_active | Boolean |  |
| is_standard | Boolean |  |
| name | String |  |

### scoring_scheme_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| name | String |  |
| range_from | Double |  |
| range_to | Double |  |
| score | Double |  |

### namedmap_hierarchy_data

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| namedmap_details_id | String | FK |
| namedmap_hierarchy_parent_id | String | FK |
| person_id | String | FK |

### person

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| email | String |  |
| external_id | String |  |
| first_name | String |  |
| last_name | String |  |
| name | String |  |

### opt_out_page

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| name | String |  |
| page_type | String |  |

### user_shared_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| relationship_id | String | FK |
| shared_by_user_id | String | FK |
| shared_with_user_id | String | FK |

### survey_page

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| title | String |  |

### survey_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| ao_participant_id | String | FK |
| company_id | String | FK |
| created_by | String | FK |
| language_id | String | FK |
| modified_by | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| source_id | String | FK |
| survey_id | String | FK |
| email | String |  |
| responded | Boolean |  |

### success_plan

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company | String | FK |
| created_by | String | FK |
| cta_type | String | FK |
| modified_by | String | FK |
| owner | String | FK |
| relationship | String | FK |
| relationship_type | String | FK |
| name | String |  |
| status | String |  |
| type | String |  |

### playbook

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

### advanced_outreach_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| advanced_outreach_id | String | FK |
| company_id | String | FK |
| person_id | String | FK |
| user_id | String | FK |
| participant_state | String |  |

### sponsor_tracking

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| status | String |  |

### record_type

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| name | String |  |
| object_name | String |  |

### opportunity_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_by | String | FK |
| modified_by | String | FK |
| opportunity | String | FK |
| price_book_entry | String | FK |
| product | String | FK |
| quantity | Double |  |
| sales_price | Double |  |
| total_price | Double |  |

### xc_overall_text_ana_view

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| company_id | String | FK |
| company_person_id | String | FK |
| person_id | String | FK |
| relationship_id | String | FK |
| survey_id | String | FK |
| sentiment | String |  |

## Relationships

- activity_timeline(account_id) → company(id)
- activity_timeline(company_id) → company(id)
- activity_timeline(relationship_id) → relationship(id)
- activity_timeline(relationship_type_id) → relationship_type(id)
- activity_timeline(author_id) → user(id)
- activity_timeline(created_by_user_id) → user(id)
- activity_timeline(last_modified_by_user_id) → user(id)
- activity_timeline(user_id) → user(id)
- advanced_outreach_participant_activity(advanced_outreach_id) → advanced_outreach(id)
- advanced_outreach_participant_activity(participant_id) → advanced_outreach_participant(id)
- activity_associated_record(activity_id) → activity_timeline(id)
- company_intelligence_mapping(company_id) → company(id)
- company_intelligence_mapping(opt_in_id) → company_intelligence_configuration(id)
- relationship_person(company_id) → company(id)
- relationship_person(company_person_id) → company_person(id)
- relationship_person(relationship_id) → relationship(id)
- relationship_person(relationship_type_id) → relationship_type(id)
- relationship_person(person_id) → person(id)
- relationship_person(created_by) → user(id)
- relationship_person(modified_by) → user(id)
- activity_attendee(activity_id) → activity_timeline(id)
- activity_attendee(external_attendee_id) → company_person(id)
- activity_attendee(internal_attendee_id) → user(id)
- da_picklist(relationship_type) → relationship_type(id)
- da_picklist(reporting_category) → reporting_category(id)
- pricebook_entry(pricebook) → pricebook(id)
- pricebook_entry(product) → product(id)
- pricebook_entry(created_by) → user(id)
- pricebook_entry(modified_by) → user(id)
- advanced_outreach_cta(cta_id) → advanced_outreach_cta_events(id)
- advanced_outreach_cta(source_step_id) → advanced_outreach_participant_activity(id)
- advanced_outreach_cta(relationship_id) → relationship(id)
- company(modified_by) → user(id)
- company(csm) → user(id)
- company(parent_company) → company(id)
- company(relationship_id) → relationship(id)
- company(created_by) → user(id)
- company(type_id) → relationship_type(id)
- company(scorecard_id) → scorecard_master(id)
- opt_out_categories(created_by) → user(id)
- opt_out_categories(modified_by) → user(id)
- unified_company(company_id) → company(id)
- unified_company(relationship_id) → relationship(id)
- unified_company(relationship_type_id) → relationship_type(id)
- unified_company(created_by) → user(id)
- unified_company(modified_by) → user(id)
- company_teams(company_id) → company(id)
- company_teams(user_id) → user(id)
- company_teams(created_by) → user(id)
- company_teams(modified_by) → user(id)
- activity_comments(activity_id) → activity_timeline(id)
- activity_comments(created_by_user_id) → user(id)
- activity_comments(modified_by_user_id) → user(id)
- sponsor_tracking_log(company_id) → company(id)
- sponsor_tracking_log(person_id) → person(id)
- sponsor_tracking_log(relationship_id) → relationship(id)
- sponsor_tracking_log(sponsor_tracking_id) → sponsor_tracking(id)
- opt_out_email(category_id) → opt_out_categories(id)
- opt_out_email(page_id) → opt_out_page(id)
- opt_out_email(company_id) → company(id)
- opt_out_email(person_id) → person(id)
- opt_out_email(language_id) → language(id)
- opt_out_email(created_by) → user(id)
- opt_out_email(modified_by) → user(id)
- email_raw_events(relationship_id) → relationship(id)
- email_raw_events(company_id) → company(id)
- relationship_type(created_by) → user(id)
- relationship_type(modified_by) → user(id)
- cs_task(owner) → user(id)
- cs_task(playbook) → playbook(id)
- cs_task(relationship) → relationship(id)
- cs_task(relationship_type) → relationship_type(id)
- cs_task(company) → company(id)
- cs_task(cta) → call_to_action(id)
- cs_task(status) → da_picklist(id)
- cs_task(timeline_activity_id) → activity_timeline(id)
- cs_task(created_by) → user(id)
- cs_task(modified_by) → user(id)
- people_map_influencers(company_person_id) → company_person(id)
- people_map_influencers(influencer_id) → company_person(id)
- people_map_influencers(created_by) → user(id)
- people_map_influencers(modified_by) → user(id)
- opportunity(created_by) → user(id)
- opportunity(opportunity_owner) → user(id)
- opportunity(modified_by) → user(id)
- opportunity(record_type) → record_type(id)
- opportunity(relationship) → relationship(id)
- opportunity(pricebook) → pricebook(id)
- survey_allowed_answer(survey_id) → survey_view(id)
- survey_allowed_answer(survey_question_id) → survey_question(id)
- survey_allowed_answer(created_by) → user(id)
- survey_allowed_answer(modified_by) → user(id)
- unified_company_registery(company_id) → company(id)
- unified_company_registery(created_by) → user(id)
- unified_company_registery(modified_by) → user(id)
- case(assignee_id) → user(id)
- case(relationship_id) → relationship(id)
- case(company_id) → company(id)
- nps_survey_response(company_id) → company(id)
- nps_survey_response(company_person_id) → company_person(id)
- nps_survey_response(participant_id) → survey_participant(id)
- nps_survey_response(person_id) → person(id)
- nps_survey_response(survey_id) → survey_view(id)
- nps_survey_response(relationship_id) → relationship(id)
- nps_survey_response(relationship_person_id) → relationship_person(id)
- nps_survey_response(created_by) → user(id)
- nps_survey_response(modified_by) → user(id)
- lead(lead_contact) → company_person(id)
- lead(company) → company(id)
- lead(lead_owner) → user(id)
- lead(opportunity) → opportunity(id)
- lead(created_by) → user(id)
- lead(modified_by) → user(id)
- language(created_by) → user(id)
- language(modified_by) → user(id)
- cockpit_template(playbook_id) → playbook(id)
- cockpit_template(relationship_type) → relationship_type(id)
- cockpit_template(created_by) → user(id)
- cockpit_template(modified_by) → user(id)
- case_associations(associated_case_id) → case(id)
- case_associations(parent_case_id) → case(id)
- company_intelligence_actions_object(cta_id) → call_to_action(id)
- company_intelligence_actions_object(activity_id) → activity_timeline(id)
- company_intelligence_actions_object(created_by) → user(id)
- company_intelligence_actions_object(modified_by) → user(id)
- advanced_outreach(relationship_type_id) → relationship_type(id)
- advanced_outreach(survey_id) → survey_view(id)
- advanced_outreach(created_by) → user(id)
- advanced_outreach(modified_by) → user(id)
- relationship(company_id) → company(id)
- relationship(created_by) → user(id)
- relationship(modified_by) → user(id)
- relationship(type_id) → relationship_type(id)
- relationship(scorecard_id) → scorecard_master(id)
- unified_scorecard_fact_company(company_id) → company(id)
- unified_scorecard_fact_company(scorecard_id) → scorecard_master(id)
- unified_scorecard_fact_company(measure_id) → scorecard_measure(id)
- unified_scorecard_fact_company(current_score_id) → scoring_scheme_definition(id)
- unified_scorecard_fact_company(previous_score_id) → scoring_scheme_definition(id)
- unified_scorecard_fact_company(score_modified_by_id) → user(id)
- xc_custom_topic_ana_view(company_id) → company(id)
- xc_custom_topic_ana_view(company_person_id) → company_person(id)
- xc_custom_topic_ana_view(person_id) → person(id)
- xc_custom_topic_ana_view(relationship_id) → relationship(id)
- xc_custom_topic_ana_view(survey_id) → survey_view(id)
- xc_custom_topic_ana_view(survey_participant_id) → survey_participant(id)
- xc_custom_topic_ana_view(survey_question_id) → survey_question(id)
- xc_custom_topic_ana_view(user_id) → user(id)
- xc_system_keyword_ana_view(company_id) → company(id)
- xc_system_keyword_ana_view(company_person_id) → company_person(id)
- xc_system_keyword_ana_view(person_id) → person(id)
- xc_system_keyword_ana_view(relationship_id) → relationship(id)
- xc_system_keyword_ana_view(survey_id) → survey_view(id)
- call_to_action(company) → company(id)
- call_to_action(owner) → user(id)
- call_to_action(relationship) → relationship(id)
- call_to_action(success_plan) → success_plan(id)
- call_to_action(created_by) → user(id)
- call_to_action(modified_by) → user(id)
- call_to_action(relationship_type) → relationship_type(id)
- call_to_action(objective_category) → da_picklist(id)
- call_to_action(playbook) → playbook(id)
- opportunity_stage(created_by) → user(id)
- opportunity_stage(modified_by) → user(id)
- advanced_outreach_cta_mapping(advanced_outreach_id) → advanced_outreach(id)
- advanced_outreach_cta_mapping(cta_id) → advanced_outreach_cta(id)
- advanced_outreach_cta_mapping(participant_id) → advanced_outreach_participant(id)
- advanced_outreach_cta_mapping(step_id) → advanced_outreach_participant_activity(id)
- company_intelligence_news_posts(created_by) → user(id)
- company_intelligence_news_posts(modified_by) → user(id)
- survey_user_answer(answer_id) → survey_allowed_answer(id)
- survey_user_answer(participant_id) → survey_participant(id)
- survey_user_answer(question_id) → survey_question(id)
- survey_user_answer(survey_id) → survey_view(id)
- survey_user_answer(created_by) → user(id)
- survey_user_answer(modified_by) → user(id)
- advanced_outreach_cta_events(cta_id) → call_to_action(id)
- survey_question(survey_id) → survey_view(id)
- survey_question(page_id) → survey_page(id)
- survey_question(created_by) → user(id)
- survey_question(modified_by) → user(id)
- scorecard_measure(created_by) → user(id)
- scorecard_measure(modified_by) → user(id)
- scorecard_master(created_by) → user(id)
- scorecard_master(modified_by) → user(id)
- company_intelligence_configuration_history(opt_in_id) → company_intelligence_configuration(id)
- company_intelligence_configuration_history(created_by) → user(id)
- unified_scorecard_fact_relationship(company_id) → company(id)
- unified_scorecard_fact_relationship(relationship_id) → relationship(id)
- unified_scorecard_fact_relationship(scorecard_id) → scorecard_master(id)
- unified_scorecard_fact_relationship(measure_id) → scorecard_measure(id)
- unified_scorecard_fact_relationship(current_score_id) → scoring_scheme_definition(id)
- unified_scorecard_fact_relationship(previous_score_id) → scoring_scheme_definition(id)
- unified_scorecard_fact_relationship(score_modified_by) → user(id)
- company_intelligence_configuration(created_by) → user(id)
- company_intelligence_configuration(modified_by) → user(id)
- scorecard_fact(company_id) → company(id)
- scorecard_fact(current_score_id) → scoring_scheme_definition(id)
- scorecard_fact(previous_score_id) → scoring_scheme_definition(id)
- scorecard_fact(scorecard_id) → scorecard_master(id)
- scorecard_fact(measure_id) → scorecard_measure(id)
- scorecard_fact(score_modified_by) → user(id)
- namedmap_details(company_id) → company(id)
- namedmap_details(company_person_id) → company_person(id)
- namedmap_details(person_id) → person(id)
- namedmap_details(created_by) → user(id)
- namedmap_details(modified_by) → user(id)
- csat_survey_response(survey_id) → survey_view(id)
- csat_survey_response(language_id) → language(id)
- csat_survey_response(company_id) → company(id)
- csat_survey_response(company_person_id) → company_person(id)
- csat_survey_response(participant_id) → survey_participant(id)
- csat_survey_response(person_id) → person(id)
- csat_survey_response(question_id) → survey_question(id)
- csat_survey_response(relationship_id) → relationship(id)
- csat_survey_response(user_answer_id) → survey_user_answer(id)
- survey_view(owner_id) → user(id)
- survey_view(relationship_type_id) → relationship_type(id)
- survey_view(created_by) → user(id)
- survey_view(modified_by) → user(id)
- opportunity_prediction(opportunity) → opportunity(id)
- opportunity_prediction(created_by) → user(id)
- opportunity_prediction(modified_by) → user(id)
- all_activity_associated_record(activity_id) → activity_timeline(id)
- case_level_cta(cta_id) → call_to_action(id)
- case_level_cta(case_id) → case(id)
- email_log_v_2(relationship_id) → relationship(id)
- email_log_v_2(relationship_person_id) → relationship_person(id)
- email_log_v_2(relationship_type_id) → relationship_type(id)
- email_log_v_2(user_id) → user(id)
- email_log_v_2(person_id) → person(id)
- email_log_v_2(company_id) → company(id)
- email_log_v_2(company_person_id) → company_person(id)
- email_log_v_2(source_id) → advanced_outreach_participant(id)
- user(company_id) → company(id)
- user(manager) → user(id)
- advanced_outreach_email(advanced_outreach_id) → advanced_outreach(id)
- advanced_outreach_email(participant_id) → advanced_outreach_participant(id)
- company_person(company_id) → company(id)
- company_person(person_id) → person(id)
- company_person(created_by) → user(id)
- company_person(modified_by) → user(id)
- pricebook(created_by) → user(id)
- pricebook(modified_by) → user(id)
- scoring_scheme_definition(created_by) → user(id)
- scoring_scheme_definition(modified_by) → user(id)
- namedmap_hierarchy_data(company_id) → company(id)
- namedmap_hierarchy_data(company_person_id) → company_person(id)
- namedmap_hierarchy_data(person_id) → person(id)
- namedmap_hierarchy_data(namedmap_details_id) → namedmap_details(id)
- namedmap_hierarchy_data(namedmap_hierarchy_parent_id) → namedmap_hierarchy_data(id)
- person(created_by) → user(id)
- person(modified_by) → user(id)
- opt_out_page(created_by) → user(id)
- opt_out_page(modified_by) → user(id)
- user_shared_detail(company_id) → company(id)
- user_shared_detail(relationship_id) → relationship(id)
- user_shared_detail(shared_with_user_id) → user(id)
- user_shared_detail(shared_by_user_id) → user(id)
- survey_page(created_by) → user(id)
- survey_page(modified_by) → user(id)
- survey_participant(ao_participant_id) → advanced_outreach_participant(id)
- survey_participant(company_id) → company(id)
- survey_participant(language_id) → language(id)
- survey_participant(relationship_id) → relationship(id)
- survey_participant(person_id) → person(id)
- survey_participant(source_id) → company_person(id)
- survey_participant(survey_id) → survey_view(id)
- survey_participant(created_by) → user(id)
- survey_participant(modified_by) → user(id)
- success_plan(company) → company(id)
- success_plan(owner) → user(id)
- success_plan(relationship) → relationship(id)
- success_plan(relationship_type) → relationship_type(id)
- success_plan(cta_type) → da_picklist(id)
- success_plan(created_by) → user(id)
- success_plan(modified_by) → user(id)
- advanced_outreach_participant(advanced_outreach_id) → advanced_outreach(id)
- advanced_outreach_participant(person_id) → person(id)
- advanced_outreach_participant(company_id) → company(id)
- advanced_outreach_participant(user_id) → user(id)
- sponsor_tracking(company_id) → company(id)
- sponsor_tracking(person_id) → person(id)
- sponsor_tracking(relationship_id) → relationship(id)
- record_type(created_by) → user(id)
- record_type(modified_by) → user(id)
- opportunity_line_item(opportunity) → opportunity(id)
- opportunity_line_item(price_book_entry) → pricebook_entry(id)
- opportunity_line_item(product) → product(id)
- opportunity_line_item(created_by) → user(id)
- opportunity_line_item(modified_by) → user(id)
- xc_overall_text_ana_view(company_id) → company(id)
- xc_overall_text_ana_view(company_person_id) → company_person(id)
- xc_overall_text_ana_view(person_id) → person(id)
- xc_overall_text_ana_view(relationship_id) → relationship(id)
- xc_overall_text_ana_view(survey_id) → survey_view(id)