# Totango schema ERD

Table and field reference for the Fivetran Totango connector.

## Table & Field Reference

### support_ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| account_name | Unknown |  |
| archived_by | Unknown |  |
| assignee | Unknown |  |
| channel | Unknown |  |
| created_date | Unknown |  |
| csat_score | Unknown |  |
| escalated | Unknown |  |
| external_id | Unknown |  |
| from_intercom | Unknown |  |
| missed_sla | Unknown |  |
| next_reply_target | Unknown |  |
| reporter | Unknown |  |
| severity | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| support_level | Unknown |  |
| support_team | Unknown |  |
| ticket_link | Unknown |  |
| time_to_resolution | Unknown |  |

### touchpoint_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| display_name | Unknown |  |
| icon | Unknown |  |
| is_default | Unknown |  |
| non_editable | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| used | Unknown |  |

### poc_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| additional_competitor | Unknown |  |
| external_id | Unknown |  |
| health_color | Unknown |  |
| health_message | Unknown |  |
| incumbent_competitor | Unknown |  |
| main_competitor | Unknown |  |
| named_account | Unknown |  |
| opportunity_closed_date | Unknown |  |
| opportunity_name | Unknown |  |
| other_additional_competitor | Unknown |  |
| other_incumbent_competitor | Unknown |  |
| other_main_competitor | Unknown |  |
| partner_on_poc | Unknown |  |
| poc_end_date | Unknown |  |
| poc_location | Unknown |  |
| poc_name | Unknown |  |
| poc_number | Unknown |  |
| poc_planned_end | Unknown |  |
| poc_planned_start | Unknown |  |
| poc_product_line | Unknown |  |
| poc_product_summary | Unknown |  |
| poc_stage | Unknown |  |
| poc_start_date | Unknown |  |
| poc_type | Unknown |  |
| se_on_poc | Unknown |  |
| second_se_on_poc | Unknown |  |
| success_project_url | Unknown |  |
| tenant_url | Unknown |  |
| third_se_on_poc | Unknown |  |

### account_assignment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| account_executive | Unknown |  |
| ace_service_manager_1 | Unknown |  |
| ace_service_manager_2 | Unknown |  |
| ace_service_manager_3 | Unknown |  |
| ace_service_named_consultant_1 | Unknown |  |
| ace_service_named_consultant_2 | Unknown |  |
| ace_service_named_consultant_3 | Unknown |  |
| customer_success_engineer | Unknown |  |
| customer_success_manager | Unknown |  |
| insight_frontline_contact_1 | Unknown |  |
| insight_frontline_contact_2 | Unknown |  |
| insight_frontline_contact_3 | Unknown |  |
| insight_manager_1 | Unknown |  |
| insight_manager_2 | Unknown |  |
| insight_manager_3 | Unknown |  |
| insight_named_consultant_1 | Unknown |  |
| insight_named_consultant_2 | Unknown |  |
| insight_named_consultant_3 | Unknown |  |
| name | Unknown |  |
| onboarding_specialist | Unknown |  |
| product_specialist | Unknown |  |
| renewal_rep | Unknown |  |
| totango_opportunity_created_by | Unknown |  |
| totango_opportunity_owner | Unknown |  |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| contract_end_date | Unknown |  |
| contract_start_date | Unknown |  |
| end_date | Unknown |  |
| external_id | Unknown |  |
| line_item_acv | Unknown |  |
| maintenance_status | Unknown |  |
| product_name | Unknown |  |
| start_date | Unknown |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| username | Unknown | FK |
| homepage | Unknown |  |
| is_admin | Unknown |  |
| is_auto_generated | Unknown |  |
| is_default | Unknown |  |
| role_id | Unknown |  |

### team_role_setting

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| can_edit_portfolio | Unknown |  |
| default_portfolio_account_types | Json |  |
| default_portfolio_data | Json |  |
| default_portfolio_selection | Unknown |  |
| role_id | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| default_manager_role_id | Unknown |  |
| default_role_id | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| extended_account_selection | Unknown |  |
| extended_search_enabled | Unknown |  |
| extended_terms | Json |  |
| goal | Unknown |  |
| icon | Unknown |  |
| include_entire_hierarchy | Unknown |  |
| member_terms | Unknown |  |
| service_default_team | Unknown |  |
| service_id | Unknown |  |
| team_type_id | Unknown |  |
| terms | Json |  |
| type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| ambassador_program_member | Unknown |  |
| bounced_campaign_date | Unknown |  |
| bounced_campaign_reason | Unknown |  |
| business_review_csat | Unknown |  |
| business_review_csat_comment | Unknown |  |
| business_review_csat_response_date | Unknown |  |
| campaign_custom | Unknown |  |
| campaign_onboarding_welcome | Unknown |  |
| campaign_outreach | Unknown |  |
| campaign_unsubscribe | Unknown |  |
| contact | Unknown |  |
| contact_account_role | Unknown |  |
| contact_address | Unknown |  |
| contact_organization | Unknown |  |
| contact_phone | Unknown |  |
| country | Unknown |  |
| crm_contact | Unknown |  |
| csat_score | Unknown |  |
| csat_score_comment | Unknown |  |
| csat_score_response_date | Unknown |  |
| device | Unknown |  |
| display_name | Unknown |  |
| email | Unknown |  |
| email_opt_out | Unknown |  |
| emergency | Unknown |  |
| first_activity_time | Unknown |  |
| first_name | Unknown |  |
| high_business_review_csat_reasons | Unknown |  |
| high_csat_score_reasons | Unknown |  |
| high_nps_response_reasons | Unknown |  |
| high_onboarding_completion_csat_survey_reasons | Unknown |  |
| high_onboarding_csat_score_reasons | Unknown |  |
| high_onboarding_midpoint_csat_survey_reasons | Unknown |  |
| high_relationship_nps_reasons | Unknown |  |
| high_training_csat_reasons | Unknown |  |
| in_app_welcome | Unknown |  |
| intercom_unsubscribe | Unknown |  |
| is_online | Unknown |  |
| key_contact | Unknown |  |
| language_preference_list | Unknown |  |
| last_activity_time | Unknown |  |
| last_campaign_sent | Unknown |  |
| last_name | Unknown |  |
| last_reference_date | Unknown |  |
| low_business_review_csat_reasons | Unknown |  |
| low_csat_score_reasons | Unknown |  |
| low_nps_response_reasons | Unknown |  |
| low_onboarding_completion_csat_survey_reasons | Unknown |  |
| low_onboarding_csat_score_reasons | Unknown |  |
| low_onboarding_midpoint_csat_survey_reasons | Unknown |  |
| low_relationship_nps_reasons | Unknown |  |
| low_training_csat_reasons | Unknown |  |
| marketing_unsubscribe | Unknown |  |
| name | Unknown |  |
| nps_feedback_category | Unknown |  |
| nps_response | Unknown |  |
| nps_response_comment | Unknown |  |
| nps_response_date | Unknown |  |
| onboarding_completion_csat_survey | Unknown |  |
| onboarding_completion_csat_survey_comment | Unknown |  |
| onboarding_completion_csat_survey_response_date | Unknown |  |
| onboarding_csat_score | Unknown |  |
| onboarding_csat_score_comment | Unknown |  |
| onboarding_csat_score_response_date | Unknown |  |
| onboarding_midpoint_csat_survey | Unknown |  |
| onboarding_midpoint_csat_survey_comment | Unknown |  |
| onboarding_midpoint_csat_survey_response_date | Unknown |  |
| os | Unknown |  |
| product_user | Unknown |  |
| reference | Unknown |  |
| referenceability | Unknown |  |
| region | Unknown |  |
| relationship_nps | Unknown |  |
| relationship_nps_comment | Unknown |  |
| relationship_nps_response_date | Unknown |  |
| sfdc_contact | Unknown |  |
| simple_first_activity_time | Unknown |  |
| simple_last_activity_time | Unknown |  |
| status_c | Unknown |  |
| sunco_external_id | Unknown |  |
| super_region_test | Unknown |  |
| timezone | Unknown |  |
| title | Unknown |  |
| training_csat | Unknown |  |
| training_csat_comment | Unknown |  |
| training_csat_response_date | Unknown |  |
| user_created_at | Unknown |  |

### opportunity_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| acv_amount_usd | Unknown |  |
| archived_by | Unknown |  |
| close_date | Unknown |  |
| collection_id | Unknown |  |
| contract_end_date | Unknown |  |
| contract_start_date | Unknown |  |
| d_1_assigned | Unknown |  |
| d_1_assigned_email | Unknown |  |
| d_1_created_opportunity | Unknown |  |
| d_1_qso_approved_date_stage_2 | Unknown |  |
| d_1_qso_approver_stage_2_email | Unknown |  |
| d_1_qso_approver_stage_2_name | Unknown |  |
| d_1_qso_comments | Unknown |  |
| d_1_qso_status_stage | Unknown |  |
| d_1_source | Unknown |  |
| end_user_account | Unknown |  |
| external_id | Unknown |  |
| is_closed | Unknown |  |
| maintenance_end_date | Unknown |  |
| opportunity_acv | Unknown |  |
| opportunity_name | Unknown |  |
| opportunity_product_acv | Unknown |  |
| opportunity_product_tcv | Unknown |  |
| opportunity_tcv | Unknown |  |
| opportunity_url | Unknown |  |
| owner_name | Unknown |  |
| partner_opportunity | Unknown |  |
| pdr_likely_procurement | Unknown |  |
| primary_partner_account | Unknown |  |
| product_acv_amount_usd | Unknown |  |
| product_tcv_amount_usd | Unknown |  |
| repeat_type | Unknown |  |
| risk_level | Unknown |  |
| stage_name | Unknown |  |
| tcv_amount_usd | Unknown |  |
| type | Unknown |  |

### touchpoint_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| properties_activity_type_id | Unknown | FK |
| alert_content_description | Unknown |  |
| alert_content_duration | Unknown |  |
| alert_content_health | Unknown |  |
| alert_content_sentiment | Unknown |  |
| alert_content_type | Unknown |  |
| enriched_users | Json |  |
| is_new | Unknown |  |
| properties_activity_type_id_is_modified | Unknown |  |
| properties_actual_effort_is_modified | Unknown |  |
| properties_automation_id | Unknown |  |
| properties_contain_formatting | Unknown |  |
| properties_customers_visibility | Unknown |  |
| properties_entity_id | Unknown |  |
| properties_entity_name | Unknown |  |
| properties_entity_type | Unknown |  |
| properties_estimated_effort_is_modified | Unknown |  |
| properties_form_id | Unknown |  |
| properties_is_associated_with_user | Unknown |  |
| properties_job_id | Unknown |  |
| properties_name | Unknown |  |
| properties_origin | Unknown |  |
| properties_request_type | Unknown |  |
| properties_request_url | Unknown |  |
| properties_status | Unknown |  |
| properties_title | Unknown |  |
| task_content_action | Unknown |  |
| task_content_assignee_current | Unknown |  |
| task_content_assignee_is_modified | Unknown |  |
| task_content_assigner_current | Unknown |  |
| task_content_assigner_is_modified | Unknown |  |
| task_content_description_current | Unknown |  |
| task_content_description_is_modified | Unknown |  |
| task_content_due_date_current | Unknown |  |
| task_content_due_date_is_modified | Unknown |  |
| task_content_last_updater_current | Unknown |  |
| task_content_last_updater_is_modified | Unknown |  |
| task_content_origin | Unknown |  |
| task_content_priority_current | Unknown |  |
| task_content_priority_is_modified | Unknown |  |
| task_content_status_current | Unknown |  |
| task_content_status_is_modified | Unknown |  |
| task_content_task_id | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |

### activity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| calculate_metric | Unknown |  |
| default_type | Unknown |  |
| disabled | Unknown |  |
| display_name | Unknown |  |
| icon_class | Unknown |  |
| metric_name | Unknown |  |
| num_of_activities_assign_to | Unknown |  |
| system_type | Unknown |  |

### touchpoint_reason

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| created_by | Unknown |  |
| display_name | Unknown |  |
| updated_at | Unknown |  |
| updated_by | Unknown |  |
| used | Unknown |  |

### success_planning

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| comments | Unknown |  |
| critical_tickets | Unknown |  |
| entry_date | Unknown |  |
| external_id | Unknown |  |
| metric_label_1 | Unknown |  |
| metric_label_2 | Unknown |  |
| metric_value_1 | Unknown |  |
| metric_value_2 | Unknown |  |
| mttr | Unknown |  |
| uptime | Unknown |  |

### task_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| assignee | Unknown |  |
| assigner | Unknown |  |
| complete_date | Unknown |  |
| created | Unknown |  |
| due_date | Unknown |  |
| external_id | Unknown |  |
| flow | Unknown |  |
| last_updated | Unknown |  |
| objective_category | Unknown |  |
| objective_created_by | Unknown |  |
| objective_created_date | Unknown |  |
| objective_description | Unknown |  |
| objective_end_date | Unknown |  |
| objective_id | Unknown |  |
| objective_instance_id | Unknown |  |
| objective_last_updated_by | Unknown |  |
| objective_last_updated_date | Unknown |  |
| objective_name | Unknown |  |
| objective_start_date | Unknown |  |
| objective_status | Unknown |  |
| origin | Unknown |  |
| priority | Unknown |  |
| status | Unknown |  |
| successplay_description | Unknown |  |
| successplay_due_date | Unknown |  |
| successplay_flow | Unknown |  |
| successplay_id | Unknown |  |
| successplay_instance_id | Unknown |  |
| successplay_name | Unknown |  |
| successplay_owner | Unknown |  |
| successplay_team_id | Unknown |  |
| title | Unknown |  |
| updated_by | Unknown |  |

### touchpoint_collection

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| contacts | Unknown |  |
| created | Unknown |  |
| creator | Unknown |  |
| external_id | Unknown |  |
| internal_users | Unknown |  |
| last_updated | Unknown |  |
| participant_roles | Unknown |  |
| reasons | Unknown |  |
| success_flow | Unknown |  |
| touchpoint_subject | Unknown |  |
| touchpoint_type | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_type | Unknown |  |
| cancellation_date | Unknown |  |
| ci_360_url | Unknown |  |
| company_contract_value | Unknown |  |
| company_domain | Unknown |  |
| company_size | Unknown |  |
| contract_renewal_date | Unknown |  |
| contract_start_date | Unknown |  |
| contract_status | Unknown |  |
| create_date | Unknown |  |
| customer_portal_account_name | Unknown |  |
| eligible_success_plan_incentive_amount | Unknown |  |
| escalation_status | Unknown |  |
| first_activity_date | Unknown |  |
| forecast_amount | Unknown |  |
| forecast_by | Unknown |  |
| forecast_contract_value | Unknown |  |
| forecast_due_date | Unknown |  |
| forecast_period | Unknown |  |
| forecast_state | Unknown |  |
| health | Unknown |  |
| health_last_change | Unknown |  |
| health_rank | Unknown |  |
| industry | Unknown |  |
| last_activity_date | Unknown |  |
| last_contract_value_change_date | Unknown |  |
| last_payment_date | Unknown |  |
| licenses | Unknown |  |
| multidimensional_health_account_rank | Unknown |  |
| multidimensional_health_account_score | Unknown |  |
| name | Unknown |  |
| next_payment_due_date | Unknown |  |
| ofid | Unknown |  |
| outstanding_balance | Unknown |  |
| parent_id | Unknown |  |
| payment_method_expiration_date | Unknown |  |
| portal_shared_date | Unknown |  |
| previous_health_rank | Unknown |  |
| product_id | Unknown |  |
| risk_reason | Unknown |  |
| risk_status | Unknown |  |
| satisfaction_score | Unknown |  |
| ticket_volume | Unknown |  |
| tier | Unknown |  |
| top_priority_satisfaction_score | Unknown |  |
| top_priority_ticket_volume | Unknown |  |
| top_priority_unsolved_tickets | Unknown |  |
| totango_opportunity_close_date | Unknown |  |
| totango_opportunity_name | Unknown |  |
| totango_opportunity_stage | Unknown |  |
| totango_opportunity_type | Unknown |  |
| totango_opportunity_value | Unknown |  |
| trial_expiration_date | Unknown |  |
| unsolved_tickets | Unknown |  |

### event_informed

| Column | Type | Keys |
| --- | --- | --- |
| informed | Unknown | PK |
| event_id | Unknown | PK, FK |

### event_totango_participant

| Column | Type | Keys |
| --- | --- | --- |
| totango_participant | Unknown | PK |
| event_id | Unknown | PK, FK |

### event_participant

| Column | Type | Keys |
| --- | --- | --- |
| participant | Unknown | PK |
| event_id | Unknown | PK, FK |

### event_account_participant

| Column | Type | Keys |
| --- | --- | --- |
| account_participant | Unknown | PK |
| event_id | Unknown | PK, FK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| properties_activity_type_id | Unknown | FK |
| is_new | Unknown |  |
| note_content_note_id | Unknown |  |
| note_content_text | Unknown |  |
| note_content_totango_user_name | Unknown |  |
| properties_campaign_description | Unknown |  |
| properties_campaign_id | Unknown |  |
| properties_campaign_schedule_type | Unknown |  |
| properties_campaign_sent_by | Unknown |  |
| properties_campaign_template_image_uid | Unknown |  |
| properties_campaign_type | Unknown |  |
| properties_creation_time | Unknown |  |
| properties_customers_visibility | Unknown |  |
| properties_description | Unknown |  |
| properties_meeting_type | Unknown |  |
| properties_name | Unknown |  |
| properties_origin | Unknown |  |
| properties_parent_id | Unknown |  |
| properties_run_timestamp | Unknown |  |
| properties_send_to_internal | Unknown |  |
| properties_start_date | Unknown |  |
| properties_subject | Unknown |  |
| properties_targeted_users_count | Unknown |  |
| timestamps | Unknown |  |
| type | Unknown |  |

## Relationships

- support_ticket(account_id) → account(id)
- poc_collection(account_id) → account(id)
- account_assignment(id) → account(id)
- subscription(account_id) → account(id)
- team_member(team_id) → team(id)
- team_member(username) → users(id)
- team_role_setting(team_id) → team(id)
- users(account_id) → account(id)
- opportunity_collection(account_id) → account(id)
- touchpoint_event(account_id) → account(id)
- touchpoint_event(properties_activity_type_id) → activity_type(id)
- success_planning(account_id) → account(id)
- task_collection(account_id) → account(id)
- touchpoint_collection(account_id) → account(id)
- event_informed(event_id) → event(id)
- event_totango_participant(event_id) → event(id)
- event_participant(event_id) → event(id)
- event_account_participant(event_id) → event(id)
- event(account_id) → account(id)
- event(properties_activity_type_id) → activity_type(id)