# SugarCRM schema ERD

Table and field reference for the Fivetran SugarCRM connector.

## Table & Field Reference

### activity_tag

| Column | Type | Keys |
| --- | --- | --- |
| activity_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### 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 | PK, FK |
| license_type | Unknown |  |

### employee_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| name | Unknown |  |
| name_2 | Unknown |  |
| primary_team | Unknown |  |
| selected | Unknown |  |

### employee_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address_id | Unknown | PK |
| employee_id | Unknown | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| name_2 | Unknown |  |
| primary_team | Unknown |  |
| selected | Unknown |  |

### meeting_tag

| Column | Type | Keys |
| --- | --- | --- |
| meeting_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### meeting_objective

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| email_address | Unknown |  |
| invalid_email | Unknown |  |
| opt_out | Unknown |  |
| primary_address | Unknown |  |
| reply_to_address | Unknown |  |

### lead_tag

| Column | Type | Keys |
| --- | --- | --- |
| lead_id | Unknown | PK, FK |
| tag_id | Unknown | PK, FK |

### lead_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lead_id | Unknown | PK, FK |
| 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 | PK, FK |
| license_type | Unknown |  |

### user_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| name | Unknown |  |
| name_2 | Unknown |  |
| primary_team | Unknown |  |
| selected | Unknown |  |

### user_email

| Column | Type | Keys |
| --- | --- | --- |
| email_address_id | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| name_2 | Unknown |  |
| primary_team | Unknown |  |
| selected | Unknown |  |

### call_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | Unknown | PK |
| call_id | Unknown | PK, FK |

### 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 | PK, FK |
| name | Unknown |  |
| name_2 | Unknown |  |
| primary_team | Unknown |  |
| selected | Unknown |  |

### account_tag

| Column | Type | Keys |
| --- | --- | --- |
| tag_id | Unknown | PK |
| account_id | Unknown | PK, FK |

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

## Relationships

- activity_tag(tag_id) → account(id)
- activity_tag(activity_id) → activity(id)
- activity(created_by_id) → users(id)
- activity(modified_user_id) → users(id)
- activity(parent_id) → account(id)
- employee_license(employee_id) → employee(id)
- employee_team(employee_id) → employee(id)
- employee_email(employee_id) → employee(id)
- employee(created_by_id) → users(id)
- employee(report_to_id) → users(id)
- employee(modified_user_id) → users(id)
- currency(created_by_id) → users(id)
- meeting_team(meeting_id) → meeting(id)
- meeting_tag(tag_id) → users(id)
- meeting_tag(meeting_id) → meeting(id)
- meeting_objective(meeting_id) → meeting(id)
- meeting(assigned_user_id) → users(id)
- meeting(created_by_id) → users(id)
- meeting(modified_user_id) → users(id)
- pmse_case(assigned_user_id) → users(id)
- pmse_case(created_by_id) → users(id)
- pmse_case(modified_user_id) → users(id)
- opportunity_team(opportunity_id) → opportunity(id)
- opportunity(assigned_user_id) → users(id)
- opportunity(created_by_id) → users(id)
- opportunity(modified_user_id) → users(id)
- opportunity(account_id) → account(id)
- opportunity(user_id) → users(id)
- lead_web_email(lead_id) → lead(id)
- lead_tag(tag_id) → users(id)
- lead_tag(lead_id) → lead(id)
- lead_team(lead_id) → lead(id)
- lead(opportunity_id) → opportunity(id)
- lead(assigned_user_id) → users(id)
- lead(created_by_id) → users(id)
- lead(report_to_id) → users(id)
- lead(modified_user_id) → users(id)
- lead(call_id) → call(id)
- lead(account_id) → account(id)
- lead(meeting_id) → meeting(id)
- user_license_type(user_id) → users(id)
- user_team(user_id) → users(id)
- user_email(user_id) → users(id)
- users(created_by_id) → users(id)
- users(report_to_id) → users(id)
- users(modified_user_id) → users(id)
- users(call_id) → call(id)
- users(meeting_id) → lead(id)
- call_team(call_id) → call(id)
- call_tag(call_id) → call(id)
- call(lead_id) → lead(id)
- call(assigned_user_id) → users(id)
- call(modified_user_id) → users(id)
- call(parent_id) → account(id)
- account_team(account_id) → account(id)
- account_tag(account_id) → account(id)
- account(assigned_user_id) → users(id)
- account(modified_user_id) → users(id)