SugarCRM

Explore the interactive ERD

Table & Field Reference

activity_tag

Column	Type	Keys
`activity_id`	Unknown	PKFK
`tag_id`	Unknown	PKFK

activity

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`parent_id`	Unknown	FK
`activity_type`	Unknown
`comment_count`	Unknown
`created_by_name`	Unknown
`data_embed`	Json
`data_value`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`deleted`	Unknown
`description`	Unknown
`following`	Unknown
`last_comment_data`	Json
`locked_fields`	Json
`modified_by_name`	Unknown
`name`	Unknown
`parent_type`	Unknown
`preview_disabled_reason`	Unknown
`preview_enabled`	Unknown
`sync_key`	Unknown
`custom_`

employee_license

Column	Type	Keys
`index`	Unknown	PK
`employee_id`	Unknown	PKFK
`license_type`	Unknown

employee_team

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

employee_email

Column	Type	Keys
`email_address_id`	Unknown	PK
`employee_id`	Unknown	PKFK
`email_address`	Unknown
`invalid_email`	Unknown
`opt_out`	Unknown
`primary_address`	Unknown
`reply_to_address`	Unknown

employee

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`report_to_id`	Unknown	FK
`accept_status_calls`	Unknown
`accept_status_id`	Unknown
`accept_status_meetings`	Unknown
`accept_status_messages`	Unknown
`accept_status_name`	Unknown
`acl_role_set_id`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_postalcode`	Unknown
`address_state`	Unknown
`address_street`	Unknown
`appearance`	Unknown
`authenticate_id`	Unknown
`business_center_id`	Unknown
`business_center_name`	Unknown
`c_accept_status_fields`	Unknown
`calendar_ical_subscription_url`	Unknown
`calendar_publish_key`	Unknown
`calendar_publish_location`	Unknown
`calendar_search_location`	Unknown
`cookie_consent`	Unknown
`cookie_consent_received_on`	Unknown
`created_by_name`	Unknown
`currency`	Unknown
`currency_create_in_preferred`	Unknown
`currency_show_preferred`	Unknown
`customer_journey_access`	Unknown
`customer_journey_last_active`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`dec_sep`	Unknown
`default_currency_significant_digits`	Unknown
`default_export_charset`	Unknown
`default_locale_name_format`	Unknown
`default_team`	Unknown
`deleted`	Unknown
`department`	Unknown
`description`	Unknown
`email_1`	Unknown
`email_link_type`	Unknown
`email_reminder_time`	Unknown
`employee_status`	Unknown
`export_delimiter`	Unknown
`external_auth_only`	Unknown
`fdow`	Unknown
`field_name_placement`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`is_admin`	Unknown
`is_group`	Unknown
`last_login`	Unknown
`last_name`	Unknown
`m_accept_status_fields`	Unknown
`mail_credentials`	Unknown
`messenger_id`	Unknown
`messenger_type`	Unknown
`modified_by_name`	Unknown
`num_grp_sep`	Unknown
`number_pinned_modules`	Unknown
`opportunities`	Json
`phone_fax`	Unknown
`phone_home`	Unknown
`phone_mobile`	Unknown
`phone_other`	Unknown
`phone_work`	Unknown
`picture`	Unknown
`portal_only`	Unknown
`portal_user_password`	Unknown
`preferred_language`	Unknown
`pwd_last_changed`	Unknown
`receive_notification`	Unknown
`reminder_time`	Unknown
`reports_to_name`	Unknown
`send_email_on_mention`	Unknown
`show_on_employees`	Unknown
`site_url`	Unknown
`site_user_id`	Unknown
`status`	Unknown
`sugar_login`	Unknown
`sugarpdf_pdf_font_name_data`	Unknown
`sugarpdf_pdf_font_name_main`	Unknown
`sugarpdf_pdf_font_size_data`	Unknown
`sugarpdf_pdf_font_size_main`	Unknown
`sync_key`	Unknown
`system_generated_password`	Unknown
`team_count`	Unknown
`timezone`	Unknown
`title`	Unknown
`use_real_names`	Unknown
`user_hash`	Unknown
`user_name`	Unknown
`user_tabs`	Unknown
`user_type`	Unknown
`custom_`

currency

Column	Type	Keys
`_fivetran_id`	String	PK
`created_by_id`	Unknown	FK
`conversion_rate`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`deleted`	Unknown
`id`	Unknown
`iso_4217`	Unknown
`name`	Unknown
`status`	Unknown
`symbol`	Unknown
`sync_key`	Unknown
`custom_`

meeting_team

Column	Type	Keys
`id`	Unknown	PK
`meeting_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

meeting_tag

Column	Type	Keys
`meeting_id`	Unknown	PKFK
`tag_id`	Unknown	PKFK

meeting_objective

Column	Type	Keys
`index`	Unknown	PK
`meeting_id`	Unknown	PKFK
`objectives`	Unknown

meeting

Column	Type	Keys
`id`	Unknown	PK
`assigned_user_id`	Unknown	FK
`created_by_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`accept_status`	Unknown
`accept_status_users`	Unknown
`assigned_user_name`	Unknown
`base_rate`	Unknown
`cj_activity_tpl_id`	Unknown
`cj_activity_tpl_name`	Unknown
`cj_actual_sort_order`	Unknown
`cj_allow_activity_by`	Unknown
`cj_blocked_by_stage`	Unknown
`cj_momentum_end_date`	Unknown
`cj_momentum_points`	Unknown
`cj_momentum_ratio`	Unknown
`cj_momentum_score`	Unknown
`cj_momentum_start_date`	Unknown
`cj_parent_activity_id`	Unknown
`cj_parent_activity_type`	Unknown
`cj_url`	Unknown
`contact_id`	Unknown
`created_by_name`	Unknown
`creator`	Unknown
`currency_id`	Unknown
`customer_journey_blocked_by`	Unknown
`customer_journey_points`	Unknown
`customer_journey_progress`	Unknown
`customer_journey_score`	Unknown
`date_end`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`date_start`	Unknown
`deleted`	Unknown
`description`	Unknown
`direction`	Unknown
`displayed_url`	Unknown
`dri_subworkflow_id`	Unknown
`dri_subworkflow_name`	Unknown
`dri_subworkflow_template_id`	Unknown
`dri_subworkflow_template_name`	Unknown
`dri_workflow_id`	Unknown
`dri_workflow_name`	Unknown
`dri_workflow_sort_order`	Unknown
`dri_workflow_task_template_id`	Unknown
`dri_workflow_template_id`	Unknown
`dri_workflow_template_name`	Unknown
`duration_hours`	Unknown
`duration_minutes`	Unknown
`email_reminder_checked`	Unknown
`email_reminder_sent`	Unknown
`email_reminder_time`	Unknown
`event_type`	Unknown
`external_id`	Unknown
`following`	Unknown
`host_url`	Unknown
`ical_uid`	Unknown
`internal_notes`	Unknown
`is_cj_parent_activity`	Unknown
`is_customer_journey_activity`	Unknown
`join_url`	Unknown
`location`	Unknown
`locked_fields`	Json
`modified_by_name`	Unknown
`name`	Unknown
`original_start_date`	Unknown
`outlook_id`	Unknown
`parent_id`	Unknown
`parent_name`	Unknown
`parent_type`	Unknown
`password`	Unknown
`recurrence_id`	Unknown
`recurring_source`	Unknown
`reminder_checked`	Unknown
`reminder_time`	Unknown
`repeat_count`	Unknown
`repeat_days`	Unknown
`repeat_dow`	Unknown
`repeat_interval`	Unknown
`repeat_ordinal`	Unknown
`repeat_parent_id`	Unknown
`repeat_selector`	Unknown
`repeat_type`	Unknown
`repeat_unit`	Unknown
`repeat_until`	Unknown
`rset`	Unknown
`sequence`	Unknown
`set_accept_links`	Unknown
`start_next_journey_id`	Unknown
`status`	Unknown
`sync_key`	Unknown
`team_count`	Unknown
`type`	Unknown
`custom_`

pmse_case

Column	Type	Keys
`id`	Unknown	PK
`assigned_user_id`	Unknown	FK
`created_by_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`assigned_user_full_name`	Unknown
`cas_assigned_status`	Unknown
`cas_create_date`	Unknown
`cas_custom_status`	Unknown
`cas_finish_date`	Unknown
`cas_id`	Unknown
`cas_init_user`	Unknown
`cas_module`	Unknown
`cas_parent`	Unknown
`cas_pin`	Unknown
`cas_status`	Unknown
`cas_sugar_module`	Unknown
`cas_sugar_object_id`	Unknown
`cas_title`	Unknown
`cas_update_date`	Unknown
`cas_user_id_full_name`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`deleted`	Unknown
`erased_field`	Unknown
`first_name`	Unknown
`is_a_person`	Unknown
`last_name`	Unknown
`modified_user_name`	Unknown
`name`	Unknown
`prj_created_by`	Unknown
`prj_deleted`	Unknown
`prj_id`	Unknown
`prj_module`	Unknown
`prj_run_order`	Unknown
`prj_user_id_full_name`	Unknown
`pro_id`	Unknown
`pro_title`	Unknown
`salutation`	Unknown
`team_id`	Unknown
`team_set_id`	Unknown

opportunity_team

Column	Type	Keys
`id`	Unknown	PK
`opportunity_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

opportunity

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`assigned_user_id`	Unknown	FK
`created_by_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`user_id`	Unknown	FK
`ai_opp_close_week_scores`	Unknown
`ai_opp_conv_bin_accuracy`	Unknown
`ai_opp_conv_multiplier`	Unknown
`ai_opp_conv_score_absolute`	Unknown
`ai_opp_conv_score_enum`	Unknown
`amount`	Unknown
`amount_usdollar`	Unknown
`assigned_user_name`	Unknown
`base_rate`	Unknown
`best_case`	Unknown
`campaign_id`	Unknown
`campaign_name`	Unknown
`campaign_opportunity_id`	Unknown
`campaign_opportunity_name`	Unknown
`closed_revenue_line_items`	Unknown
`closed_won_revenue_line_items`	Unknown
`commit_stage`	Unknown
`commit_stage_cascade`	Unknown
`contact_role`	Unknown
`created_by_name`	Unknown
`currency_id`	Unknown
`currency_name`	Unknown
`currency_symbol`	Unknown
`date_closed`	Unknown
`date_closed_cascade`	Unknown
`date_closed_timestamp`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`deleted`	Unknown
`denorm_account_name`	Unknown
`description`	Unknown
`dri_workflow_template_id`	Unknown
`dri_workflow_template_name`	Unknown
`following`	Unknown
`forecasted_likely`	Unknown
`geocode_status`	Unknown
`included_revenue_line_items`	Unknown
`is_escalated`	Unknown
`lead_source`	Unknown
`locked_fields`	Json
`lost`	Unknown
`mkto_id`	Unknown
`mkto_sync`	Unknown
`modified_by_name`	Unknown
`name`	Unknown
`next_step`	Unknown
`opportunity_type`	Unknown
`parent`	Json
`parent_id`	Unknown
`parent_name`	Unknown
`parent_type`	Unknown
`perform_sugar_action`	Unknown
`probability`	Unknown
`renewal`	Unknown
`renewal_parent_id`	Unknown
`renewal_parent_name`	Unknown
`sales_stage`	Unknown
`sales_stage_cascade`	Unknown
`sales_status`	Unknown
`service_duration_unit`	Unknown
`service_duration_unit_cascade`	Unknown
`service_duration_value`	Unknown
`service_duration_value_cascade`	Unknown
`service_open_flex_duration_rlis`	Unknown
`service_open_revenue_line_items`	Unknown
`service_start_date`	Unknown
`service_start_date_cascade`	Unknown
`sync_key`	Unknown
`tags`	Json
`total_revenue_line_items`	Unknown
`widget_amount`	Unknown
`widget_date_closed`	Unknown
`widget_sales_stage`	Unknown
`worst_case`	Unknown
`custom_`

lead_web_email

Column	Type	Keys
`email_address_id`	Unknown	PK
`lead_id`	Unknown	PKFK
`email_address`	Unknown
`invalid_email`	Unknown
`opt_out`	Unknown
`primary_address`	Unknown
`reply_to_address`	Unknown

lead_tag

Column	Type	Keys
`lead_id`	Unknown	PKFK
`tag_id`	Unknown	PKFK

lead_team

Column	Type	Keys
`id`	Unknown	PK
`lead_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

lead

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`assigned_user_id`	Unknown	FK
`call_id`	Unknown	FK
`created_by_id`	Unknown	FK
`meeting_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`opportunity_id`	Unknown	FK
`report_to_id`	Unknown	FK
`accept_status_call`	Unknown
`accept_status_id`	Unknown
`accept_status_meetings`	Unknown
`accept_status_messages`	Unknown
`accept_status_name`	Unknown
`account_description`	Unknown
`account_to_lead`	Unknown
`ai_conv_bin_accuracy`	Unknown
`ai_conv_multiplier`	Unknown
`ai_conv_score_absolute`	Unknown
`ai_conv_score_classification`	Unknown
`ai_icp_fit_bin_accuracy`	Unknown
`ai_icp_fit_multiplier`	Unknown
`ai_icp_fit_score_absolute`	Unknown
`ai_icp_fit_score_classification`	Unknown
`alt_address_city`	Unknown
`alt_address_country`	Unknown
`alt_address_postalcode`	Unknown
`alt_address_state`	Unknown
`alt_address_street`	Unknown
`alt_address_street_2`	Unknown
`alt_address_street_3`	Unknown
`assigned_user_name`	Unknown
`assistant`	Unknown
`assistant_phone`	Unknown
`birth_date`	Unknown
`business_center_id`	Unknown
`business_center_name`	Unknown
`c_accept_status_field`	Unknown
`campaign_id`	Unknown
`campaign_lead_id`	Unknown
`campaign_lead_name`	Unknown
`campaign_name`	Unknown
`contact_id`	Unknown
`converted`	Unknown
`converted_opp_name`	Unknown
`created_by_name`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`deleted`	Unknown
`department`	Unknown
`description`	Unknown
`dnb_principal_id`	Unknown
`do_not_call`	Unknown
`do_not_email`	Unknown
`dp_business_purpose`	Json
`dp_consent_last_updated`	Unknown
`dri_workflow_template_id`	Unknown
`dri_workflow_template_name`	Unknown
`email_2`	Unknown
`email_addresses_non_primary`	Unknown
`email_opt_out`	Unknown
`external_user_id`	Unknown
`facebook`	Unknown
`first_name`	Unknown
`following`	Unknown
`full_name`	Unknown
`geocode_status`	Unknown
`googleplus`	Unknown
`hint_account_annual_revenue`	Unknown
`hint_account_description`	Unknown
`hint_account_sic_code_label`	Unknown
`hint_account_twitter_handle`	Unknown
`hint_account_website`	Unknown
`hint_contact_pic`	Unknown
`hint_education`	Unknown
`hint_education_2`	Unknown
`hint_facebook`	Unknown
`hint_job_2`	Unknown
`hint_phone_1`	Unknown
`hint_phone_2`	Unknown
`hint_photo`	Unknown
`hint_twitter`	Unknown
`invalid_email`	Unknown
`last_name`	Unknown
`lead_source`	Unknown
`lead_source_description`	Unknown
`locked_fields`	Json
`m_accept_status_field`	Unknown
`market_interest_prediction_score`	Unknown
`market_score`	Unknown
`mkto_id`	Unknown
`mkto_lead_score`	Unknown
`mkto_sync`	Unknown
`modified_by_name`	Unknown
`name`	Unknown
`perform_sugar_action`	Unknown
`phone_fax`	Unknown
`phone_home`	Unknown
`phone_mobile`	Unknown
`phone_other`	Unknown
`phone_work`	Unknown
`picture`	Unknown
`portal_app`	Unknown
`portal_name`	Unknown
`preferred_language`	Unknown
`primary_address_city`	Unknown
`primary_address_country`	Unknown
`primary_address_postalcode`	Unknown
`primary_address_state`	Unknown
`primary_address_street`	Unknown
`primary_address_street_2`	Unknown
`primary_address_street_3`	Unknown
`refered_by`	Unknown
`report_to_name`	Unknown
`salutation`	Unknown
`status`	Unknown
`status_description`	Unknown
`sync_key`	Unknown
`title`	Unknown
`twitter`	Unknown
`web_to_lead_email_opt_out`	Unknown
`web_to_lead_invalid_email`	Unknown
`website`	Unknown
`custom_`

user_license_type

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`license_type`	Unknown

user_team

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

user_email

Column	Type	Keys
`email_address_id`	Unknown	PK
`user_id`	Unknown	PKFK
`email_address`	Unknown
`invalid_email`	Unknown
`opt_out`	Unknown
`primary_address`	Unknown
`reply_to_address`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`call_id`	Unknown	FK
`created_by_id`	Unknown	FK
`meeting_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`report_to_id`	Unknown	FK
`accept_status_calls`	Unknown
`accept_status_id`	Unknown
`accept_status_meetings`	Unknown
`accept_status_messages`	Unknown
`accept_status_name`	Unknown
`acl_role_set_id`	Unknown
`address_city`	Unknown
`address_country`	Unknown
`address_postalcode`	Unknown
`address_state`	Unknown
`address_street`	Unknown
`appearance`	Unknown
`authenticate_id`	Unknown
`business_center_id`	Unknown
`business_center_name`	Unknown
`c_accept_status_fields`	Unknown
`calendar_ical_subscription_url`	Unknown
`calendar_publish_key`	Unknown
`calendar_publish_location`	Unknown
`calendar_search_location`	Unknown
`cookie_consent`	Unknown
`cookie_consent_received_on`	Unknown
`created_by_name`	Unknown
`currency`	Unknown
`currency_create_in_preferred`	Unknown
`currency_show_preferred`	Unknown
`customer_journey_access`	Unknown
`customer_journey_last_active`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`dec_sep`	Unknown
`default_currency_significant_digits`	Unknown
`default_export_charset`	Unknown
`default_locale_name_format`	Unknown
`default_team`	Unknown
`deleted`	Unknown
`department`	Unknown
`description`	Unknown
`email_link_type`	Unknown
`email_reminder_time`	Unknown
`employee_status`	Unknown
`export_delimiter`	Unknown
`external_auth_only`	Unknown
`fdow`	Unknown
`field_name_placement`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`hash`	Unknown
`is_admin`	Unknown
`is_group`	Unknown
`last_login`	Unknown
`last_name`	Unknown
`m_accept_status_fields`	Unknown
`mail_credentials`	Unknown
`messenger_id`	Unknown
`messenger_type`	Unknown
`modified_by_name`	Unknown
`num_grp_sep`	Unknown
`number_pinned_modules`	Unknown
`opportunities`	Json
`phone_fax`	Unknown
`phone_home`	Unknown
`phone_mobile`	Unknown
`phone_other`	Unknown
`phone_work`	Unknown
`picture`	Unknown
`portal_only`	Unknown
`portal_user_password`	Unknown
`preferred_language`	Unknown
`pwd_last_changed`	Unknown
`receive_notification`	Unknown
`reminder_time`	Unknown
`report_to_name`	Unknown
`send_email_on_mention`	Unknown
`show_on_employees`	Unknown
`site_url`	Unknown
`site_user_id`	Unknown
`status`	Unknown
`sugar_login`	Unknown
`sugarpdf_pdf_font_name_data`	Unknown
`sugarpdf_pdf_font_name_main`	Unknown
`sugarpdf_pdf_font_size_data`	Unknown
`sugarpdf_pdf_font_size_main`	Unknown
`sync_key`	Unknown
`system_generated_password`	Unknown
`tab`	Unknown
`timezone`	Unknown
`title`	Unknown
`type`	Unknown
`user_name`	Unknown
`custom_`

call_team

Column	Type	Keys
`id`	Unknown	PK
`call_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

call_tag

Column	Type	Keys
`tag_id`	Unknown	PK
`call_id`	Unknown	PKFK

call

Column	Type	Keys
`id`	Unknown	PK
`assigned_user_id`	Unknown	FK
`lead_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`parent_id`	Unknown	FK
`accept_status`	Unknown
`accept_status_users`	Unknown
`assigned_user_name`	Unknown
`aws_contact_id`	Unknown
`aws_lens_data`	Unknown
`call_recording`	Unknown
`call_recording_url`	Unknown
`cj_activity_tpl_name`	Unknown
`cj_actual_sort_order`	Unknown
`cj_allow_activity_by`	Unknown
`cj_momentum_end_date`	Unknown
`cj_momentum_points`	Unknown
`cj_momentum_ratio`	Unknown
`cj_momentum_score`	Unknown
`cj_momentum_start_date`	Unknown
`cj_parent_activity_id`	Unknown
`cj_parent_activity_type`	Unknown
`cj_url`	Unknown
`contact_id`	Unknown
`contact_name`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`customer_journey_blocked_by`	Unknown
`customer_journey_points`	Unknown
`customer_journey_progress`	Unknown
`customer_journey_score`	Unknown
`date_end`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`date_start`	Unknown
`deleted`	Unknown
`description`	Unknown
`direction`	Unknown
`dri_subworkflow_id`	Unknown
`dri_subworkflow_name`	Unknown
`dri_subworkflow_template_id`	Unknown
`dri_subworkflow_template_name`	Unknown
`dri_workflow_id`	Unknown
`dri_workflow_name`	Unknown
`dri_workflow_sort_order`	Unknown
`dri_workflow_task_template_id`	Unknown
`dri_workflow_template_id`	Unknown
`dri_workflow_template_name`	Unknown
`duration_hours`	Unknown
`duration_minutes`	Unknown
`email_reminder_checked`	Unknown
`email_reminder_sent`	Unknown
`email_reminder_time`	Unknown
`event_type`	Unknown
`following`	Unknown
`ical_uid`	Unknown
`internal_notes`	Unknown
`is_cj_parent_activity`	Unknown
`is_customer_journey_activity`	Unknown
`lead_name`	Unknown
`locked_fields`	Json
`modified_by_name`	Unknown
`name`	Unknown
`original_start_date`	Unknown
`outlook_id`	Unknown
`parent_type`	Unknown
`recurrence_id`	Unknown
`recurring_source`	Unknown
`reminder_checked`	Unknown
`reminder_time`	Unknown
`repeat_count`	Unknown
`repeat_days`	Unknown
`repeat_dow`	Unknown
`repeat_interval`	Unknown
`repeat_ordinal`	Unknown
`repeat_parent_id`	Unknown
`repeat_selector`	Unknown
`repeat_type`	Unknown
`repeat_unit`	Unknown
`repeat_until`	Unknown
`rset`	Unknown
`sentiment_score_agent`	Unknown
`sentiment_score_agent_first_quarter`	Unknown
`sentiment_score_agent_fourth_quarter`	Unknown
`sentiment_score_agent_second_quarter`	Unknown
`sentiment_score_agent_string`	Unknown
`sentiment_score_agent_third_quarter`	Unknown
`sentiment_score_customer`	Unknown
`sentiment_score_customer_first_quarter`	Unknown
`sentiment_score_customer_fourth_quarter`	Unknown
`sentiment_score_customer_second_quarter`	Unknown
`sentiment_score_customer_string`	Unknown
`sentiment_score_customer_third_quarter`	Unknown
`set_accept_links`	Unknown
`start_next_journey_id`	Unknown
`status`	Unknown
`sync_key`	Unknown
`transcript`	Unknown
`custom_`

account_team

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`name`	Unknown
`name_2`	Unknown
`primary_team`	Unknown
`selected`	Unknown

account_tag

Column	Type	Keys
`tag_id`	Unknown	PK
`account_id`	Unknown	PKFK

account

Column	Type	Keys
`id`	Unknown	PK
`assigned_user_id`	Unknown	FK
`modified_user_id`	Unknown	FK
`accounts_w_020_account_reporting_teams_1_name`	Unknown
`accounts_w_4156_ng_teams_idb`	Unknown
`annual_revenue`	Unknown
`assigned_user_name`	Unknown
`base_rate`	Unknown
`billing_address_city`	Unknown
`billing_address_country`	Unknown
`billing_address_postalcode`	Unknown
`billing_address_state`	Unknown
`billing_address_street`	Unknown
`billing_address_street_2`	Unknown
`billing_address_street_3`	Unknown
`billing_address_street_4`	Unknown
`business_center_id`	Unknown
`business_center_name`	Unknown
`campaign_id`	Unknown
`campaign_name`	Unknown
`cases_account_id`	Unknown
`cases_account_name`	Unknown
`cases_accounts_1_cases_ida`	Unknown
`cases_accounts_1_name`	Unknown
`created_by_id`	Unknown
`created_by_name`	Unknown
`currency_id`	Unknown
`date_entered`	Unknown
`date_modified`	Unknown
`deleted`	Unknown
`description`	Unknown
`dri_workflow_template_id`	Unknown
`dri_workflow_template_name`	Unknown
`duns_num`	Unknown
`email`	Json
`email_1`	Unknown
`email_2`	Unknown
`email_addresses_non_primary`	Unknown
`email_opt_out`	Unknown
`employees`	Unknown
`facebook`	Unknown
`following`	Unknown
`geocode_status`	Unknown
`googleplus`	Unknown
`hint_account_facebook_handle`	Unknown
`hint_account_fiscal_year_end`	Unknown
`hint_account_founded_year`	Unknown
`hint_account_industry`	Unknown
`hint_account_industry_tags`	Unknown
`hint_account_location`	Unknown
`hint_account_logo`	Unknown
`hint_account_naics_code_lbl`	Unknown
`hint_account_pic`	Unknown
`hint_account_size`	Unknown
`industry`	Unknown
`invalid_email`	Unknown
`is_escalated`	Unknown
`locked_fields`	Json
`main_contact`	Unknown
`member_of_id`	Unknown
`member_of_name`	Unknown
`modified_by_name`	Unknown
`name`	Unknown
`next_renewal_date`	Unknown
`ownership`	Unknown
`parent_id`	Unknown
`parent_name`	Unknown
`perform_sugar_action`	Unknown
`phone_alternate`	Unknown
`phone_fax`	Unknown
`phone_office`	Unknown
`rating`	Unknown
`service_level`	Unknown
`shipping_address_city`	Unknown
`shipping_address_country`	Unknown
`shipping_address_postalcode`	Unknown
`shipping_address_state`	Unknown
`shipping_address_street`	Unknown
`shipping_address_street_2`	Unknown
`shipping_address_street_3`	Unknown
`shipping_address_street_4`	Unknown
`sic_code`	Unknown
`sync_key`	Unknown
`ticker_symbol`	Unknown
`twitter`	Unknown
`type`	Unknown
`website`	Unknown
`widget_next_renewal_date`	Unknown
`custom_`