Totango

Explore the interactive ERD

Table & Field Reference

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

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

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

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

event_informed

Column	Type	Keys
`informed`	Unknown	PK
`event_id`	Unknown	PKFK

event_participant

Column	Type	Keys
`participant`	Unknown	PK
`event_id`	Unknown	PKFK

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

account_assignment

Column	Type	Keys
`id`	Unknown	PKFK
`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

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

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

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

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_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

team_member

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	PKFK
`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	PKFK
`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_reason

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