Fivetran documentation

Search the docs

/

Gainsight Customer Success

Explore the interactive ERD

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