Gainsight Product Experience

Explore the interactive ERD

Table & Field Reference

kcbot_environment

Column	Type	Keys
`index`	Unknown	PK
`kcbot_id`	Unknown	PKFK
`environment`	Unknown

kcbot_language

Column	Type	Keys
`index`	Unknown	PK
`kcbot_id`	Unknown	PKFK
`language_code`	Unknown
`translated`	Unknown

kcbot

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown
`created_by_name`	Unknown
`created_date`	Unknown
`default_language`	Unknown
`description`	Unknown
`languages`	Json
`modified_by_id`	Unknown
`modified_by_name`	Unknown
`modified_date`	Unknown
`name`	Unknown
`priority`	Unknown
`product_id`	Unknown
`product_name`	Unknown
`status`	Unknown

account_property_key

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`key`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`create_date`	Unknown
`duns_number`	Unknown
`industry`	Unknown
`last_modified_date`	Instant
`last_seen_date`	Unknown
`location_city`	Unknown
`location_continent`	Unknown
`location_coordinate_latitude`	Unknown
`location_coordinate_longitude`	Unknown
`location_country_code`	Unknown
`location_country_name`	Unknown
`location_postal_code`	Unknown
`location_region_name`	Unknown
`location_state_code`	Unknown
`location_state_name`	Unknown
`location_street`	Unknown
`location_time_zone`	Unknown
`naics_code`	Unknown
`name`	Unknown
`number_of_employees`	Unknown
`number_of_user`	Unknown
`parent_group_id`	Unknown
`plan`	Unknown
`sfdc_id`	Unknown
`sic_code`	Unknown
`tracked_subscription_id`	Unknown
`website`	Unknown
`custom_`

engagement_property_key

Column	Type	Keys
`index`	Unknown	PK
`engagement_id`	Unknown	PKFK
`key`	Unknown
`type`	Unknown

engagement_envs

Column	Type	Keys
`index`	Unknown	PK
`engagement_id`	Unknown	PKFK
`envs`	Unknown

engagement

Column	Type	Keys
`id`	Unknown	PK
`default_language`	Unknown
`description`	Unknown
`name`	Unknown
`state`	Unknown
`translation_state`	Unknown
`type`	Unknown

segment

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown

subscription_product_key

Column	Type	Keys
`key`	Unknown	PK
`subscription_id`	Unknown	PKFK
`subscription_product_name`	Unknown	PKFK
`channel`	Unknown
`url`	Unknown

subscription_product

Column	Type	Keys
`name`	Unknown	PK
`subscription_id`	Unknown	PKFK
`description`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`icon_url`	Unknown
`name`	Unknown
`timezone`	Unknown
`website`	Unknown

article_kcbot

Column	Type	Keys
`article_id`	Unknown	PKFK
`kcbot_id`	Unknown	PKFK

article_language

Column	Type	Keys
`index`	Unknown	PK
`article_id`	Unknown	PKFK
`code`	Unknown
`translated`	Unknown

article

Column	Type	Keys
`id`	Unknown	PK
`author`	Unknown
`created_date`	Unknown
`default_language`	Unknown
`modified_by_id`	Unknown
`modified_by_name`	Unknown
`modified_date`	Unknown
`name`	Unknown
`product_id`	Unknown
`product_name`	Unknown
`release_date`	Unknown
`translation_state`	Unknown
`view_type`	Unknown

integration

Column	Type	Keys
`_fivetran_id`	String	PK
`current_status`	Unknown
`last_error`	Unknown
`last_successful_date`	Unknown
`number_of_records_processed`	Unknown
`sync_name`	Unknown

engagement_error_detail

Column	Type	Keys
`engagement_id`	Unknown	PKFK
`browser`	Unknown
`error_count`	Unknown
`error_type`	Unknown
`step_name`	Unknown
`step_number`	Unknown
`value`	Unknown

feature_label

Column	Type	Keys
`id`	Unknown	PK
`feature_id`	Unknown	PKFK
`color`	Unknown
`name`	Unknown

feature

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`parent_id`	Unknown
`property_key`	Unknown
`status`	Unknown
`type`	Unknown

pageview_event

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`event_type`	Unknown
`global_context`	Json
`hash`	Unknown
`host`	Unknown
`languages`	Json
`page_title`	Unknown
`path`	Unknown
`property_key`	Unknown
`query_params`	Unknown
`query_string`	Unknown
`referrer`	Unknown
`remote_host`	Unknown
`scheme`	Unknown
`screen_height`	Unknown
`screen_width`	Unknown
`user_type`	Unknown

email_event

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`attempt`	Unknown
`bounce_type`	Unknown
`date`	Unknown
`email`	Unknown
`engagement_id`	Unknown
`event_type`	Unknown
`global_context`	Json
`link_index`	Unknown
`link_type`	Unknown
`link_url`	Unknown
`location_city`	Unknown
`location_continent`	Unknown
`location_coordinates_latitude`	Unknown
`location_coordinates_longitude`	Unknown
`location_country_code`	Unknown
`location_country_name`	Unknown
`location_postal_code`	Unknown
`location_region_name`	Unknown
`location_state_code`	Unknown
`location_state_name`	Unknown
`location_street`	Unknown
`location_time_zone`	Unknown
`mta_response`	Unknown
`property_key`	Unknown
`reason`	Unknown
`status`	Unknown
`track_type`	Unknown
`user_type`	Unknown

custom_event

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`global_context`	Json
`name`	Unknown
`property_key`	Unknown
`referrer`	Unknown
`remote_host`	Unknown
`type`	Unknown
`url`	Unknown
`user_type`	Unknown
`attributes_`

feature_match_event

Column	Type	Keys
`id`	Unknown	PK
`feature_id`	Unknown	PKFK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`event_type`	Unknown
`global_context`	Json
`property_key`	Unknown
`user_type`	Unknown

survey_response_selection_info

Column	Type	Keys
`index`	Unknown	PK
`survey_response_event_id`	Unknown	PKFK
`selection_id`	Unknown

survey_response

Column	Type	Keys
`event_id`	Unknown	PK
`account_id`	Unknown	FK
`engagement_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`view_event_id`	Unknown	FK
`carousel_state`	Unknown
`comment`	Unknown
`contact_me_allowed`	Unknown
`content_id`	Unknown
`content_type`	Unknown
`date`	Unknown
`engagement_track_type`	Unknown
`event_type`	Unknown
`execution_date`	Unknown
`execution_id`	Unknown
`global_context`	Json
`guide_state`	Unknown
`link_url`	Unknown
`path`	Unknown
`property_key`	Unknown
`question_type`	Unknown
`score`	Unknown
`sequence_number`	Unknown
`slide_id`	Unknown
`step_id`	Unknown
`survey_state`	Unknown
`user_type`	Unknown

form_submit_event

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`event_type`	Unknown
`form_data`	Unknown
`global_context`	Json
`hash`	Unknown
`host`	Unknown
`languages`	Json
`page_title`	Unknown
`path`	Unknown
`property_key`	Unknown
`query_params`	Json
`query_string`	Unknown
`referrer`	Unknown
`remote_host`	Unknown
`scheme`	Unknown
`screen_height`	Unknown
`screen_width`	Unknown
`user_type`	Unknown

segment_match_event

Column	Type	Keys
`id`	Unknown	PK
`segment_id`	Unknown	PKFK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`event_type`	Unknown
`global_context`	Json
`property_key`	Unknown
`user_type`	Unknown

event_identification

Column	Type	Keys
`event_id`	Unknown	PK
`identify_id`	Unknown	PK
`account_id`	Unknown	FK
`email`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`event_type`	Unknown
`property_key`	Unknown
`user_type`	Unknown

engagement_view_event

Column	Type	Keys
`id`	Unknown	PK
`engagement_id`	Unknown	PKFK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`carousel_state`	Unknown
`comment`	Unknown
`contact_me_allowed`	Unknown
`content_id`	Unknown
`content_type`	Unknown
`date`	Unknown
`engagement_track_type`	Unknown
`event_type`	Unknown
`execution_date`	Unknown
`execution_id`	Unknown
`global_context`	Json
`guide_state`	Unknown
`link_url`	Unknown
`path`	Unknown
`property_key`	Unknown
`question_type`	Unknown
`score`	Unknown
`selection_ids`	Json
`sequence_number`	Unknown
`slide_id`	Unknown
`step_id`	Unknown
`survey_state`	Unknown
`user_type`	Unknown
`view_event_id`	Unknown

lead_event

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`session_id`	Unknown	FK
`date`	Unknown
`email`	Unknown
`event_type`	Unknown
`global_context`	Json
`property_key`	Unknown
`user_type`	Unknown

session_event

Column	Type	Keys
`id`	Unknown	PK
`session_id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`coordinate_latitude`	Unknown
`coordinate_longitude`	Unknown
`date`	Unknown
`event_type`	Unknown
`global_context`	Json
`inferred_location_city`	Unknown
`inferred_location_continent`	Unknown
`inferred_location_country_code`	Unknown
`inferred_location_country_name`	Unknown
`inferred_location_postal_code`	Unknown
`inferred_location_region_name`	Unknown
`inferred_location_state_code`	Unknown
`inferred_location_state_name`	Unknown
`inferred_location_street`	Unknown
`inferred_location_time_zone`	Unknown
`property_key`	Unknown
`remote_host`	Unknown
`user_type`	Unknown

user_property_key

Column	Type	Keys
`index`	Unknown	PK
`users_aptrinsic_id`	Unknown	PKFK
`key`	Unknown

last_visited_user_agent_data

Column	Type	Keys
`index`	Unknown	PK
`users_aptrinsic_id`	Unknown	PKFK
`property_key`	Unknown
`useragent_browsertype`	Unknown
`useragent_browserversion`	Unknown
`useragent_device`	Unknown
`useragent_platformtype`	Unknown
`useragent_platformversion`	Unknown
`useragent_rawuseragent`	Unknown

users

Column	Type	Keys
`aptrinsic_id`	Unknown	PK
`account_id`	Unknown	FK
`identify_id`	Unknown	FK
`create_date`	Unknown
`email`	Unknown
`first_name`	Unknown
`first_visit_date`	Unknown
`gender`	Unknown
`global_unsubscribe`	Unknown
`id`	Unknown
`inferred_location_coordinate_latitude`	Unknown
`inferred_location_coordinate_longitude`	Unknown
`last_inferred_location_city`	Unknown
`last_inferred_location_continent`	Unknown
`last_inferred_location_country_code`	Unknown
`last_inferred_location_country_name`	Unknown
`last_inferred_location_postal_code`	Unknown
`last_inferred_location_region_name`	Unknown
`last_inferred_location_state_code`	Unknown
`last_inferred_location_state_name`	Unknown
`last_inferred_location_street`	Unknown
`last_inferred_location_time_zone`	Unknown
`last_modified_date`	Instant
`last_name`	Unknown
`last_seen_date`	Unknown
`location_city`	Unknown
`location_continent`	Unknown
`location_coordinate_latitude`	Unknown
`location_coordinate_longitude`	Unknown
`location_country_code`	Unknown
`location_country_name`	Unknown
`location_postal_code`	Unknown
`location_region_name`	Unknown
`location_state_code`	Unknown
`location_state_name`	Unknown
`location_street`	Unknown
`location_time_zone`	Unknown
`number_of_visit`	Unknown
`phone`	Unknown
`role`	Unknown
`score_bigger`	Unknown
`sfdc_contact_id`	Unknown
`sign_up_date`	Unknown
`subscription_id`	Unknown
`title`	Unknown
`type`	Unknown
`custom_`

user_preference

Column	Type	Keys
`_fivetran_id`	String	PK
`guided_tour`	Unknown
`onboarding_bot`	Unknown
`product_update`	Unknown
`survey`	Unknown
`track_usage`	Unknown
`users_id`	Unknown