# Gainsight Product Experience schema ERD

Table and field reference for the Fivetran Gainsight Product Experience connector.

## Table & Field Reference

### kcbot_environment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| kcbot_id | Unknown | PK, FK |
| environment | Unknown |  |

### kcbot_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| kcbot_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| key | Unknown |  |
| type | Unknown |  |

### engagement_envs

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| engagement_id | Unknown | PK, FK |
| 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 | PK, FK |
| subscription_product_name | Unknown | PK, FK |
| channel | Unknown |  |
| url | Unknown |  |

### subscription_product

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| subscription_id | Unknown | PK, FK |
| 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 | PK, FK |
| kcbot_id | Unknown | PK, FK |

### article_language

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| article_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| key | Unknown |  |

### last_visited_user_agent_data

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_aptrinsic_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- kcbot_environment(kcbot_id) → kcbot(id)
- kcbot_language(kcbot_id) → kcbot(id)
- account_property_key(account_id) → account(id)
- engagement_property_key(engagement_id) → engagement(id)
- engagement_envs(engagement_id) → engagement(id)
- subscription_product_key(subscription_product_name) → subscription_product(name)
- subscription_product_key(subscription_id) → subscription_product(subscription_id)
- subscription_product(subscription_id) → subscription(id)
- article_kcbot(kcbot_id) → kcbot(id)
- article_kcbot(article_id) → article(id)
- article_language(article_id) → article(id)
- engagement_error_detail(engagement_id) → engagement(id)
- feature_label(feature_id) → feature(id)
- pageview_event(identify_id) → event_identification(identify_id)
- pageview_event(session_id) → session_event(session_id)
- pageview_event(account_id) → account(id)
- email_event(identify_id) → event_identification(identify_id)
- email_event(account_id) → account(id)
- custom_event(identify_id) → event_identification(identify_id)
- custom_event(session_id) → session_event(session_id)
- custom_event(account_id) → account(id)
- feature_match_event(identify_id) → event_identification(identify_id)
- feature_match_event(feature_id) → feature(id)
- feature_match_event(session_id) → session_event(session_id)
- feature_match_event(account_id) → account(id)
- survey_response_selection_info(survey_response_event_id) → survey_response(event_id)
- survey_response(identify_id) → event_identification(identify_id)
- survey_response(view_event_id) → engagement_view_event(view_event_id)
- survey_response(engagement_id) → engagement(id)
- survey_response(session_id) → session_event(session_id)
- survey_response(account_id) → account(id)
- form_submit_event(identify_id) → event_identification(identify_id)
- form_submit_event(session_id) → session_event(session_id)
- form_submit_event(account_id) → account(id)
- segment_match_event(segment_id) → segment(id)
- segment_match_event(identify_id) → event_identification(identify_id)
- segment_match_event(session_id) → session_event(session_id)
- segment_match_event(account_id) → account(id)
- event_identification(email) → users(email)
- event_identification(session_id) → session_event(session_id)
- event_identification(account_id) → account(id)
- engagement_view_event(identify_id) → event_identification(identify_id)
- engagement_view_event(engagement_id) → engagement(id)
- engagement_view_event(session_id) → session_event(session_id)
- engagement_view_event(account_id) → account(id)
- lead_event(identify_id) → event_identification(identify_id)
- lead_event(session_id) → session_event(session_id)
- lead_event(account_id) → account(id)
- session_event(identify_id) → event_identification(identify_id)
- session_event(account_id) → account(id)
- user_property_key(users_aptrinsic_id) → users(aptrinsic_id)
- last_visited_user_agent_data(users_aptrinsic_id) → users(aptrinsic_id)
- users(identify_id) → event_identification(identify_id)
- users(account_id) → account(id)