SchemaSpy Analysis of ss721en - Columnsgenerated Generated by
SchemaSpy
Generated on Mon Jun 16 08:14 UTC 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ss721en contains 2606 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
bugs bug_number int 11  √ 
cases case_number int 11  √ 
emailman id int 11  √ 
tracker id int 11  √ 
tracker_perf id int 11  √ 
tracker_queries id int 11  √ 
tracker_sessions id int 11  √ 
tracker_tracker_queries id int 11  √ 
kbcontents kb_index int 11  √ 
category_tree node_id int 11  √ 
quotes quote_num int 11  √ 
systems system_id int 11  √ 
campaign_trkrs tracker_key int 11  √ 
campaigns tracker_key int 11  √ 
prospects tracker_key int 11  √ 
calls_contacts accept_status varchar 25  √  none
calls_leads accept_status varchar 25  √  none
calls_users accept_status varchar 25  √  none
meetings_contacts accept_status varchar 25  √  none
meetings_leads accept_status varchar 25  √  none
meetings_users accept_status varchar 25  √  none
acl_roles_actions access_override int 3  √  null
leads account_description text 65535  √  null
accounts_bugs account_id varchar 36  √  null
accounts_cases account_id varchar 36  √  null
accounts_contacts account_id varchar 36  √  null
accounts_opportunities account_id varchar 36  √  null
cases account_id char 36  √  null
contracts account_id char 36  √  null
documents_accounts account_id char 36  √  null
forecast_worksheets account_id char 36  √  null
leads account_id char 36  √  null
products account_id char 36  √  null
projects_accounts account_id varchar 36  √  null
quotes_accounts account_id varchar 36  √  null
revenue_line_items account_id char 36  √  null
forecast_worksheets account_name varchar 255  √  null
leads account_name varchar 255  √  null
prospects account_name varchar 150  √  null
quotes_accounts account_role varchar 20  √  null
accounts account_type varchar 50  √  null
acl_actions aclaccess int 3  √  null
acl_fields aclaccess int 3  √  null
acl_actions acltype varchar 100  √  null
tracker action varchar 255  √  null
acl_roles_actions action_id varchar 36  √  null
workflow_actionshells action_module varchar 255  √  null
workflow_actionshells action_type varchar 100  √  null
report_schedules active bit 1  √  0
tracker_sessions active bit 1  √  1
documents active_date date 10  √  null
kbdocuments active_date date 10  √  null
campaign_log activity_date datetime 19  √  null
activities_users activity_id char 36
activities activity_type varchar 100  √  null
campaign_log activity_type varchar 100  √  null
campaigns actual_cost decimal 26,6  √  null
project_task actual_duration int 11  √  null
project_task actual_effort int 11  √  null
users address_city varchar 100  √  null
users address_country varchar 100  √  null
users address_postalcode varchar 20  √  null
users address_state varchar 100  √  null
users address_street varchar 150  √  null
emails_email_addr_rel address_type varchar 4  √  null
workflow_alerts address_type varchar 100  √  null
workflow_actions adv_type varchar 10  √  null
accounts_audit after_value_string varchar 255  √  null
bugs_audit after_value_string varchar 255  √  null
campaigns_audit after_value_string varchar 255  √  null
cases_audit after_value_string varchar 255  √  null
contacts_audit after_value_string varchar 255  √  null
contracts_audit after_value_string varchar 255  √  null
forecast_manager_worksheets_audit after_value_string varchar 255  √  null
kbcontents_audit after_value_string varchar 255  √  null
leads_audit after_value_string varchar 255  √  null
notifications_audit after_value_string varchar 255  √  null
opportunities_audit after_value_string varchar 255  √  null
product_templates_audit after_value_string varchar 255  √  null
products_audit after_value_string varchar 255  √  null
project_task_audit after_value_string varchar 255  √  null
quotes_audit after_value_string varchar 255  √  null
revenue_line_items_audit after_value_string varchar 255  √  null
accounts_audit after_value_text text 65535  √  null
bugs_audit after_value_text text 65535  √  null
campaigns_audit after_value_text text 65535  √  null
cases_audit after_value_text text 65535  √  null
contacts_audit after_value_text text 65535  √  null
contracts_audit after_value_text text 65535  √  null
forecast_manager_worksheets_audit after_value_text text 65535  √  null
kbcontents_audit after_value_text text 65535  √  null
leads_audit after_value_text text 65535  √  null
notifications_audit after_value_text text 65535  √  null
opportunities_audit after_value_text text 65535  √  null
product_templates_audit after_value_text text 65535  √  null
products_audit after_value_text text 65535  √  null
project_task_audit after_value_text text 65535  √  null
quotes_audit after_value_text text 65535  √  null
revenue_line_items_audit after_value_text text 65535  √  null
workflow_alertshells alert_text text 65535  √  null
workflow_alertshells alert_type varchar 100  √  null
email_marketing all_prospect_lists bit 1  √  0
roles_modules allow bit 1  √  0
contacts alt_address_city varchar 100  √  null
leads alt_address_city varchar 100  √  null
prospects alt_address_city varchar 100  √  null
styleguide alt_address_city varchar 100  √  null
contacts alt_address_country varchar 255  √  null
leads alt_address_country varchar 255  √  null
prospects alt_address_country varchar 255  √  null
styleguide alt_address_country varchar 255  √  null
contacts alt_address_postalcode varchar 20  √  null
leads alt_address_postalcode varchar 20  √  null
prospects alt_address_postalcode varchar 20  √  null
styleguide alt_address_postalcode varchar 20  √  null
contacts alt_address_state varchar 100  √  null
leads alt_address_state varchar 100  √  null
prospects alt_address_state varchar 100  √  null
styleguide alt_address_state varchar 100  √  null
contacts alt_address_street varchar 150  √  null
leads alt_address_street varchar 150  √  null
prospects alt_address_street varchar 150  √  null
styleguide alt_address_street varchar 150  √  null
opportunities amount decimal 26,6  √  null
quotas amount decimal 26,6  √  null
quotas amount_base_currency decimal 26,6  √  null
opportunities amount_usdollar decimal 26,6  √  null
accounts annual_revenue varchar 100  √  null
email_cache answered tinyint 4  √  null
eapm api_data text 65535  √  null
eapm application varchar 100  √  webex
campaign_log archived bit 1  √  0
workflow_alerts array_type varchar 100  √  null
products asset_number varchar 50  √  null
revenue_line_items asset_number varchar 50  √  null
folders assign_to_id char 36  √  null
accounts assigned_user_id char 36  √  null
address_book assigned_user_id char 36
address_book_lists assigned_user_id char 36
bugs assigned_user_id char 36  √  null
calls assigned_user_id char 36  √  null
campaigns assigned_user_id char 36  √  null
cases assigned_user_id char 36  √  null
contacts assigned_user_id char 36  √  null
contracts assigned_user_id char 36  √  null
dashboards assigned_user_id char 36  √  null
documents assigned_user_id char 36  √  null
eapm assigned_user_id char 36  √  null
email_templates assigned_user_id char 36  √  null
emails assigned_user_id char 36  √  null
filters assigned_user_id char 36  √  null
folders_subscriptions assigned_user_id char 36
forecast_manager_worksheets assigned_user_id char 36  √  null
forecast_worksheets assigned_user_id char 36  √  null
import_maps assigned_user_id char 36  √  null
job_queue assigned_user_id char 36  √  null
kbdocuments assigned_user_id char 36  √  null
leads assigned_user_id char 36  √  null
meetings assigned_user_id char 36  √  null
notes assigned_user_id char 36  √  null
notifications assigned_user_id char 36  √  null
oauth_consumer assigned_user_id char 36  √  null
oauth_tokens assigned_user_id char 36  √  null
opportunities assigned_user_id char 36  √  null
pdfmanager assigned_user_id char 36  √  null
product_categories assigned_user_id char 36  √  null
products assigned_user_id char 36  √  null
project assigned_user_id char 36  √  null
project_task assigned_user_id char 36  √  null
prospect_lists assigned_user_id char 36  √  null
prospects assigned_user_id char 36  √  null
quotes assigned_user_id char 36  √  null
record_list assigned_user_id char 36
report_cache assigned_user_id char 36
revenue_line_items assigned_user_id char 36  √  null
saved_reports assigned_user_id char 36  √  null
saved_search assigned_user_id char 36  √  null
styleguide assigned_user_id char 36  √  null
sugarfavorites assigned_user_id char 36  √  null
tasks assigned_user_id char 36  √  null
user_preferences assigned_user_id char 36  √  null
users_last_import assigned_user_id char 36  √  null
contacts assistant varchar 75  √  null
leads assistant varchar 75  √  null
prospects assistant varchar 75  √  null
styleguide assistant varchar 75  √  null
contacts assistant_phone varchar 100  √  null
leads assistant_phone varchar 100  √  null
prospects assistant_phone varchar 100  √  null
styleguide assistant_phone varchar 100  √  null
teams associated_user_id char 36  √  null
dataset_attributes attribute_type varchar 8  √  null
fields_meta_data audited bit 1  √  0
users authenticate_id varchar 100  √  null
pdfmanager author varchar 255  √  SugarCRM
inbound_email_autoreply autoreplied_to varchar 100  √  null
email_templates base_module varchar 50  √  null
pdfmanager base_module varchar 100  √  null
workflow base_module varchar 50  √  null
campaigns base_rate decimal 26,6  √  null
contracts base_rate decimal 26,6  √  null
forecast_manager_worksheets base_rate decimal 26,6  √  null
forecast_worksheets base_rate decimal 26,6  √  null
forecasts base_rate decimal 26,6  √  null
opportunities base_rate decimal 26,6  √  null
product_bundles base_rate decimal 26,6  √  null
product_templates base_rate decimal 26,6  √  null
products base_rate decimal 26,6  √  null
quotas base_rate decimal 26,6  √  null
quotes base_rate decimal 26,6  √  null
revenue_line_items base_rate decimal 26,6  √  null
emails_text bcc_addrs text 65535  √  null
address_book bean varchar 50  √  null
address_book bean_id char 36
address_book_list_items bean_id char 36
custom_fields bean_id char 36  √  null
email_addr_bean_rel bean_id char 36
emails_beans bean_id char 36  √  null
fts_queue bean_id char 36  √  null
users_last_import bean_id char 36  √  null
workflow_schedules bean_id char 36  √  null
email_addr_bean_rel bean_module varchar 100  √  null
emails_beans bean_module varchar 100  √  null
fts_queue bean_module varchar 100  √  null
users_last_import bean_type varchar 36  √  null
accounts_audit before_value_string varchar 255  √  null
bugs_audit before_value_string varchar 255  √  null
campaigns_audit before_value_string varchar 255  √  null
cases_audit before_value_string varchar 255  √  null
contacts_audit before_value_string varchar 255  √  null
contracts_audit before_value_string varchar 255  √  null
forecast_manager_worksheets_audit before_value_string varchar 255  √  null
kbcontents_audit before_value_string varchar 255  √  null
leads_audit before_value_string varchar 255  √  null
notifications_audit before_value_string varchar 255  √  null
opportunities_audit before_value_string varchar 255  √  null
product_templates_audit before_value_string varchar 255  √  null
products_audit before_value_string varchar 255  √  null
project_task_audit before_value_string varchar 255  √  null
quotes_audit before_value_string varchar 255  √  null
revenue_line_items_audit before_value_string varchar 255  √  null
accounts_audit before_value_text text 65535  √  null
bugs_audit before_value_text text 65535  √  null
campaigns_audit before_value_text text 65535  √  null
cases_audit before_value_text text 65535  √  null
contacts_audit before_value_text text 65535  √  null
contracts_audit before_value_text text 65535  √  null
forecast_manager_worksheets_audit before_value_text text 65535  √  null
kbcontents_audit before_value_text text 65535  √  null
leads_audit before_value_text text 65535  √  null
notifications_audit before_value_text text 65535  √  null
opportunities_audit before_value_text text 65535  √  null
product_templates_audit before_value_text text 65535  √  null
products_audit before_value_text text 65535  √  null
project_task_audit before_value_text text 65535  √  null
quotes_audit before_value_text text 65535  √  null
revenue_line_items_audit before_value_text text 65535  √  null
forecast_manager_worksheets best_case decimal 26,6  √  null
forecast_worksheets best_case decimal 26,6  √  null
forecasts best_case decimal 26,6  √  null
opportunities best_case decimal 26,6  √  null
revenue_line_items best_case decimal 26,6  √  null
forecast_manager_worksheets best_case_adjusted decimal 26,6  √  null
dataset_attributes bg_color varchar 25  √  null
accounts billing_address_city varchar 100  √  null
quotes billing_address_city varchar 100  √  null
accounts billing_address_country varchar 255  √  null
quotes billing_address_country varchar 100  √  null
accounts billing_address_postalcode varchar 20  √  null
quotes billing_address_postalcode varchar 20  √  null
accounts billing_address_state varchar 100  √  null
quotes billing_address_state varchar 100  √  null
accounts billing_address_street varchar 150  √  null
quotes billing_address_street varchar 150  √  null
contacts birthdate date 10  √  null
leads birthdate date 10  √  null
prospects birthdate date 10  √  null
styleguide birthdate datetime 19  √  null
email_templates body text 65535  √  null
data_sets body_back_color varchar 100  √  null
email_templates body_html text 65535  √  null
pdfmanager body_html text 65535  √  null
data_sets body_text_color varchar 100  √  null
products book_value decimal 26,6  √  null
revenue_line_items book_value decimal 26,6  √  null
products book_value_date date 10  √  null
revenue_line_items book_value_date date 10  √  null
products book_value_usdollar decimal 26,6  √  null
revenue_line_items book_value_usdollar decimal 26,6  √  null
campaigns budget decimal 26,6  √  null
accounts_bugs bug_id varchar 36  √  null
cases_bugs bug_id varchar 36  √  null
contacts_bugs bug_id varchar 36  √  null
documents_bugs bug_id char 36  √  null
projects_bugs bug_id varchar 36  √  null
product_bundle_note bundle_id varchar 36  √  null
product_bundle_product bundle_id varchar 36  √  null
product_bundle_quote bundle_id varchar 36  √  null
product_bundle_quote bundle_index int 11  √  0
product_bundles bundle_stage varchar 255  √  null
oauth_consumer c_key varchar 255  √  null
oauth_consumer c_secret varchar 255  √  null
quotes calc_grand_total bit 1  √  1
calls_contacts call_id char 36  √  null
calls_leads call_id char 36  √  null
calls_users call_id char 36  √  null
oauth_tokens callback_url varchar 255  √  null
emails_beans campaign_data text 65535  √  null
accounts campaign_id char 36  √  null
campaign_log campaign_id char 36  √  null
campaign_trkrs campaign_id char 36  √  null
contacts campaign_id char 36  √  null
email_marketing campaign_id char 36  √  null
emailman campaign_id char 36  √  null
forecast_worksheets campaign_id char 36  √  null
leads campaign_id char 36  √  null
opportunities campaign_id char 36  √  null
products campaign_id char 36  √  null
prospect_list_campaigns campaign_id varchar 36  √  null
prospects campaign_id char 36  √  null
revenue_line_items campaign_id char 36  √  null
forecast_worksheets campaign_name varchar 255  √  null
campaigns campaign_type varchar 100  √  null
forecast_schedule cascade_hierarchy bit 1  √  null
accounts_cases case_id varchar 36  √  null
cases_bugs case_id varchar 36  √  null
contacts_cases case_id varchar 36  √  null
documents_cases case_id char 36  √  null
projects_cases case_id varchar 36  √  null
schedulers catch_up bit 1  √  1
acl_actions category varchar 100  √  null
acl_fields category varchar 100  √  null
config category varchar 32  √  null
user_preferences category varchar 50  √  null
documents category_id varchar 100  √  null
forecast_worksheets category_id char 36  √  null
product_templates category_id char 36  √  null
products category_id char 36  √  null
revenue_line_items category_id char 36  √  null
forecast_worksheets category_name varchar 255  √  null
emails_text cc_addrs text 65535  √  null
dataset_attributes cell_size varchar 3  √  null
document_revisions change_log varchar 255  √  null
kbdocument_revisions change_log varchar 255  √  null
saved_reports chart_type varchar 36  √  none
product_product child_id varchar 36  √  null
job_queue client varchar 255  √  null
tracker_sessions client_ip varchar 45  √  null
oauth_consumer client_type varchar 50  √  user
forecast_manager_worksheets closed_amount decimal 26,6  √  0.000000
forecasts closed_amount decimal 26,6  √  0.000000
opportunities closed_revenue_line_items int 11  √  null
activities comment_count int 11  √  0
fields_meta_data comments varchar 255  √  null
forecast_worksheets commit_stage varchar 50  √  null
opportunities commit_stage varchar 50  √  null
revenue_line_items commit_stage varchar 50  √  exclude
quotas committed bit 1  √  0
contracts company_signed_date date 10  √  null
oauth_nonce conskey varchar 32
oauth_tokens consumer char 36
eapm consumer_key varchar 255  √  null
eapm consumer_secret varchar 255  √  null
accounts_contacts contact_id varchar 36  √  null
calls_contacts contact_id char 36  √  null
contacts_bugs contact_id varchar 36  √  null
contacts_cases contact_id varchar 36  √  null
contacts_users contact_id varchar 36  √  null
contracts_contacts contact_id varchar 36  √  null
documents_contacts contact_id char 36  √  null
leads contact_id char 36  √  null
meetings_contacts contact_id char 36  √  null
notes contact_id char 36  √  null
oauth_tokens contact_id char 36  √  null
opportunities_contacts contact_id varchar 36  √  null
products contact_id char 36  √  null
projects_contacts contact_id varchar 36  √  null
quotes_contacts contact_id varchar 36  √  null
tasks contact_id char 36  √  null
contacts_bugs contact_role varchar 50  √  null
contacts_cases contact_role varchar 50  √  null
opportunities_contacts contact_role varchar 50  √  null
quotes_contacts contact_role varchar 20  √  null
campaigns content text 65535  √  null
import_maps content text 65535  √  null
saved_reports content longtext 2147483647  √  null
vcals content text 65535  √  null
report_cache contents text 65535  √  null
saved_search contents text 65535  √  null
user_preferences contents longtext 2147483647  √  null
contracts_contacts contract_id varchar 36  √  null
contracts_opportunities contract_id varchar 36  √  null
contracts_products contract_id varchar 36  √  null
contracts_quotes contract_id varchar 36  √  null
currencies conversion_rate decimal 26,6  √  0.000000
leads converted bit 1  √  0
forecast_worksheets cost_price decimal 26,6  √  null
product_templates cost_price decimal 26,6  √  null
products cost_price decimal 26,6  √  null
revenue_line_items cost_price decimal 26,6  √  null
product_templates cost_usdollar decimal 26,6  √  null
products cost_usdollar decimal 26,6  √  null
revenue_line_items cost_usdollar decimal 26,6  √  null
accounts created_by char 36  √  null
accounts_audit created_by char 36  √  null
acl_actions created_by char 36  √  null
acl_fields created_by char 36  √  null
acl_roles created_by char 36  √  null
activities created_by char 36  √  null
bugs created_by char 36  √  null
bugs_audit created_by char 36  √  null
calls created_by char 36  √  null
campaign_trkrs created_by char 36  √  null
campaigns created_by char 36  √  null
campaigns_audit created_by char 36  √  null
cases created_by char 36  √  null
cases_audit created_by char 36  √  null
comments created_by char 36  √  null
contacts created_by char 36  √  null
contacts_audit created_by char 36  √  null
contract_types created_by char 36  √  null
contracts created_by char 36  √  null
contracts_audit created_by char 36  √  null
currencies created_by char 36
custom_queries created_by char 36  √  null
dashboards created_by char 36  √  null
data_sets created_by char 36  √  null
dataset_attributes created_by char 36  √  null
dataset_layouts created_by char 36  √  null
document_revisions created_by char 36  √  null
documents created_by char 36  √  null
eapm created_by char 36  √  null
email_marketing created_by char 36  √  null
email_templates created_by char 36  √  null
emails created_by char 36  √  null
expressions created_by char 36  √  null
filters created_by char 36  √  null
folders created_by char 36
forecast_manager_worksheets created_by char 36  √  null
forecast_manager_worksheets_audit created_by char 36  √  null
forecast_schedule created_by char 36  √  null
forecast_worksheets created_by char 36  √  null
holidays created_by char 36  √  null
inbound_email created_by char 36  √  null
kbcontents_audit created_by char 36  √  null
kbdocument_revisions created_by char 36  √  null
kbdocuments created_by char 36  √  null
kbdocuments_kbtags created_by char 36  √  null
kbtags created_by char 36  √  null
leads created_by char 36  √  null
leads_audit created_by char 36  √  null
manufacturers created_by char 36  √  null
meetings created_by char 36  √  null
notes created_by char 36  √  null
notifications created_by char 36  √  null
notifications_audit created_by char 36  √  null
oauth_consumer created_by char 36  √  null
opportunities created_by char 36  √  null
opportunities_audit created_by char 36  √  null
pdfmanager created_by char 36  √  null
product_bundle_notes created_by char 36  √  null
product_bundles created_by char 36  √  null
product_categories created_by char 36  √  null
product_templates created_by char 36  √  null
product_templates_audit created_by char 36  √  null
product_types created_by char 36  √  null
products created_by char 36  √  null
products_audit created_by char 36  √  null
project created_by char 36  √  null
project_resources created_by char 36  √  null
project_task created_by char 36  √  null
project_task_audit created_by char 36  √  null
prospect_lists created_by char 36  √  null
prospects created_by char 36  √  null
quotas created_by char 36  √  null
quotes created_by char 36  √  null
quotes_audit created_by char 36  √  null
releases created_by char 36  √  null
report_maker created_by char 36  √  null
revenue_line_items created_by char 36  √  null
revenue_line_items_audit created_by char 36  √  null
roles created_by char 36  √  null
saved_reports created_by char 36  √  null
schedulers created_by char 36  √  null
shippers created_by char 36  √  null
styleguide created_by char 36  √  null
subscriptions created_by char 36  √  null
sugarfavorites created_by char 36  √  null
tasks created_by char 36  √  null
taxrates created_by char 36  √  null
team_notices created_by char 36  √  null
team_sets created_by char 36  √  null
teams created_by char 36  √  null
timeperiods created_by char 36  √  null
users created_by char 36  √  null
users_signatures created_by char 36  √  null
versions created_by char 36  √  null
weblogichooks created_by char 36  √  null
workflow created_by char 36  √  null
workflow_actions created_by char 36  √  null
workflow_actionshells created_by char 36  √  null
workflow_alerts created_by char 36  √  null
workflow_alertshells created_by char 36  √  null
workflow_schedules created_by char 36  √  null
workflow_triggershells created_by char 36  √  null
meetings creator varchar 50  √  null
product_templates currency varchar 255  √  null
campaigns currency_id char 36  √  -99
contracts currency_id char 36  √  -99
forecast_manager_worksheets currency_id char 36  √  null
forecast_worksheets currency_id char 36  √  null
forecasts currency_id char 36  √  -99
opportunities currency_id char 36  √  -99
product_bundles currency_id char 36  √  -99
product_templates currency_id char 36  √  -99
products currency_id char 36  √  -99
quotas currency_id char 36  √  -99
quotes currency_id char 36  √  -99
revenue_line_items currency_id char 36  √  -99
styleguide currency_id char 36  √  -99
data_sets custom_layout varchar 10  √  null
fields_meta_data custom_module varchar 255  √  null
custom_queries custom_query text 65535  √  null
workflow_alertshells custom_template_id char 36  √  null
contracts customer_signed_date date 10  √  null
dashboards dashboard_module varchar 100  √  null
dashboards dashboard_type varchar 100  √  dashboard
activities data longtext 2147483647  √  null
comments data longtext 2147483647  √  null
job_queue data longtext 2147483647  √  null
accounts_audit data_type varchar 100  √  null
bugs_audit data_type varchar 100  √  null
campaigns_audit data_type varchar 100  √  null
cases_audit data_type varchar 100  √  null
contacts_audit data_type varchar 100  √  null
contracts_audit data_type varchar 100  √  null
forecast_manager_worksheets_audit data_type varchar 100  √  null
kbcontents_audit data_type varchar 100  √  null
leads_audit data_type varchar 100  √  null
notifications_audit data_type varchar 100  √  null
opportunities_audit data_type varchar 100  √  null
product_templates_audit data_type varchar 100  √  null
products_audit data_type varchar 100  √  null
project_task_audit data_type varchar 100  √  null
quotes_audit data_type varchar 100  √  null
revenue_line_items_audit data_type varchar 100  √  null
product_templates date_available date 10  √  null
forecast_worksheets date_closed date 10  √  null
opportunities date_closed date 10  √  null
products date_closed date 10  √  null
revenue_line_items date_closed date 10  √  null
forecast_worksheets date_closed_timestamp int 11  √  null
opportunities date_closed_timestamp int 11  √  null
products date_closed_timestamp int 11  √  null
revenue_line_items date_closed_timestamp int 11  √  null
product_templates date_cost_price date 10  √  null
accounts_audit date_created datetime 19  √  null
bugs_audit date_created datetime 19  √  null
campaigns_audit date_created datetime 19  √  null
cases_audit date_created datetime 19  √  null
contacts_audit date_created datetime 19  √  null
contracts_audit date_created datetime 19  √  null
email_addr_bean_rel date_created datetime 19  √  null
email_addresses date_created datetime 19  √  null
forecast_manager_worksheets_audit date_created datetime 19  √  null
fts_queue date_created datetime 19  √  null
kbcontents_audit date_created datetime 19  √  null
leads_audit date_created datetime 19  √  null
notifications_audit date_created datetime 19  √  null
opportunities_audit date_created datetime 19  √  null
product_templates_audit date_created datetime 19  √  null
products_audit date_created datetime 19  √  null
project_task_audit date_created datetime 19  √  null
quotes_audit date_created datetime 19  √  null
revenue_line_items_audit date_created datetime 19  √  null
project_task date_due date 10  √  null
tasks date_due datetime 19  √  null
tasks date_due_flag bit 1  √  0
calls date_end datetime 19  √  null
meetings date_end datetime 19  √  null
team_notices date_end date 10  √  null
tracker_sessions date_end datetime 19  √  null
accounts date_entered datetime 19  √  null
acl_actions date_entered datetime 19  √  null
acl_fields date_entered datetime 19  √  null
acl_roles date_entered datetime 19  √  null
activities date_entered datetime 19  √  null
bugs date_entered datetime 19  √  null
calls date_entered datetime 19  √  null
campaign_trkrs date_entered datetime 19  √  null
campaigns date_entered datetime 19  √  null
cases date_entered datetime 19  √  null
comments date_entered datetime 19  √  null
contacts date_entered datetime 19  √  null
contract_types date_entered datetime 19  √  null
contracts date_entered datetime 19  √  null
currencies date_entered datetime 19  √  null
custom_queries date_entered datetime 19  √  null
dashboards date_entered datetime 19  √  null
data_sets date_entered datetime 19  √  null
dataset_attributes date_entered datetime 19  √  null
dataset_layouts date_entered datetime 19  √  null
document_revisions date_entered datetime 19  √  null
documents date_entered datetime 19  √  null
eapm date_entered datetime 19  √  null
email_marketing date_entered datetime 19  √  null
email_templates date_entered datetime 19  √  null
emailman date_entered datetime 19  √  null
emails date_entered datetime 19  √  null
expressions date_entered datetime 19  √  null
filters date_entered datetime 19  √  null
forecast_manager_worksheets date_entered datetime 19  √  null
forecast_schedule date_entered datetime 19  √  null
forecast_worksheets date_entered datetime 19  √  null
forecasts date_entered datetime 19  √  null
holidays date_entered datetime 19  √  null
import_maps date_entered datetime 19  √  null
inbound_email date_entered datetime 19  √  null
inbound_email_autoreply date_entered datetime 19  √  null
job_queue date_entered datetime 19  √  null
kbcontents date_entered datetime 19  √  null
kbdocument_revisions date_entered datetime 19  √  null
kbdocuments date_entered datetime 19  √  null
kbdocuments_kbtags date_entered datetime 19  √  null
kbtags date_entered datetime 19  √  null
leads date_entered datetime 19  √  null
manufacturers date_entered datetime 19  √  null
meetings date_entered datetime 19  √  null
notes date_entered datetime 19  √  null
notifications date_entered datetime 19  √  null
oauth_consumer date_entered datetime 19  √  null
opportunities date_entered datetime 19  √  null
pdfmanager date_entered datetime 19  √  null
product_bundle_notes date_entered datetime 19  √  null
product_bundles date_entered datetime 19  √  null
product_categories date_entered datetime 19  √  null
product_templates date_entered datetime 19  √  null
product_types date_entered datetime 19  √  null
products date_entered datetime 19  √  null
project date_entered datetime 19  √  null
project_task date_entered datetime 19  √  null
prospect_lists date_entered datetime 19  √  null
prospects date_entered datetime 19  √  null
quotas date_entered datetime 19  √  null
quotes date_entered datetime 19  √  null
releases date_entered datetime 19  √  null
report_cache date_entered datetime 19  √  null
report_maker date_entered datetime 19  √  null
revenue_line_items date_entered datetime 19  √  null
roles date_entered datetime 19  √  null
saved_reports date_entered datetime 19  √  null
saved_search date_entered datetime 19  √  null
schedulers date_entered datetime 19  √  null
schedulers_times date_entered datetime 19  √  null
session_active date_entered datetime 19  √  null
session_history date_entered datetime 19  √  null
shippers date_entered datetime 19  √  null
styleguide date_entered datetime 19  √  null
subscriptions date_entered datetime 19  √  null
sugarfavorites date_entered datetime 19  √  null
systems date_entered datetime 19  √  null
tasks date_entered datetime 19  √  null
taxrates date_entered datetime 19  √  null
team_notices date_entered datetime 19  √  null
teams date_entered datetime 19  √  null
timeperiods date_entered datetime 19  √  null
upgrade_history date_entered datetime 19  √  null
user_preferences date_entered datetime 19  √  null
users date_entered datetime 19  √  null
users_signatures date_entered datetime 19  √  null
vcals date_entered datetime 19  √  null
versions date_entered datetime 19  √  null
weblogichooks date_entered datetime 19  √  null
workflow date_entered datetime 19  √  null
workflow_actions date_entered datetime 19  √  null
workflow_actionshells date_entered datetime 19  √  null
workflow_alerts date_entered datetime 19  √  null
workflow_alertshells date_entered datetime 19  √  null
workflow_schedules date_entered datetime 19  √  null
workflow_triggershells date_entered datetime 19  √  null
workflow_schedules date_expired datetime 19  √  null
project_task date_finish date 10  √  null
users_password_link date_generated datetime 19  √  null
accounts date_modified datetime 19  √  null
accounts_bugs date_modified datetime 19  √  null
accounts_cases date_modified datetime 19  √  null
accounts_contacts date_modified datetime 19  √  null
accounts_opportunities date_modified datetime 19  √  null
acl_actions date_modified datetime 19  √  null
acl_fields date_modified datetime 19  √  null
acl_roles date_modified datetime 19  √  null
acl_roles_actions date_modified datetime 19  √  null
acl_roles_users date_modified datetime 19  √  null
activities date_modified datetime 19  √  null
activities_users date_modified datetime 19  √  null
bugs date_modified datetime 19  √  null
calls date_modified datetime 19  √  null
calls_contacts date_modified datetime 19  √  null
calls_leads date_modified datetime 19  √  null
calls_users date_modified datetime 19  √  null
campaign_log date_modified datetime 19  √  null
campaign_trkrs date_modified datetime 19  √  null
campaigns date_modified datetime 19  √  null
cases date_modified datetime 19  √  null
cases_bugs date_modified datetime 19  √  null
comments date_modified datetime 19  √  null
contacts date_modified datetime 19  √  null
contacts_bugs date_modified datetime 19  √  null
contacts_cases date_modified datetime 19  √  null
contacts_users date_modified datetime 19  √  null
contract_types date_modified datetime 19  √  null
contracts date_modified datetime 19  √  null
contracts_contacts date_modified datetime 19  √  null
contracts_opportunities date_modified datetime 19  √  null
contracts_products date_modified datetime 19  √  null
contracts_quotes date_modified datetime 19  √  null
currencies date_modified datetime 19  √  null
custom_queries date_modified datetime 19  √  null
dashboards date_modified datetime 19  √  null
data_sets date_modified datetime 19  √  null
dataset_attributes date_modified datetime 19  √  null
dataset_layouts date_modified datetime 19  √  null
document_revisions date_modified datetime 19  √  null
documents date_modified datetime 19  √  null
documents_accounts date_modified datetime 19  √  null
documents_bugs date_modified datetime 19  √  null
documents_cases date_modified datetime 19  √  null
documents_contacts date_modified datetime 19  √  null
documents_opportunities date_modified datetime 19  √  null
documents_products date_modified datetime 19  √  null
documents_quotes date_modified datetime 19  √  null
documents_revenuelineitems date_modified datetime 19  √  null
eapm date_modified datetime 19  √  null
email_addr_bean_rel date_modified datetime 19  √  null
email_addresses date_modified datetime 19  √  null
email_marketing date_modified datetime 19  √  null
email_marketing_prospect_lists date_modified datetime 19  √  null
email_templates date_modified datetime 19  √  null
emailman date_modified datetime 19  √  null
emails date_modified datetime 19  √  null
emails_beans date_modified datetime 19  √  null
expressions date_modified datetime 19  √  null
fields_meta_data date_modified datetime 19  √  null
filters date_modified datetime 19  √  null
forecast_manager_worksheets date_modified datetime 19  √  null
forecast_schedule date_modified datetime 19  √  null
forecast_worksheets date_modified datetime 19  √  null
forecasts date_modified datetime 19  √  null
fts_queue date_modified datetime 19  √  null
holidays date_modified datetime 19  √  null
import_maps date_modified datetime 19  √  null
inbound_email date_modified datetime 19  √  null
inbound_email_autoreply date_modified datetime 19  √  null
job_queue date_modified datetime 19  √  null
kbcontents date_modified datetime 19  √  null
kbdocument_revisions date_modified datetime 19  √  null
kbdocuments date_modified datetime 19  √  null
kbdocuments_kbtags date_modified datetime 19  √  null
kbdocuments_views_ratings date_modified datetime 19  √  null
kbtags date_modified datetime 19  √  null
leads date_modified datetime 19  √  null
linked_documents date_modified datetime 19  √  null
manufacturers date_modified datetime 19  √  null
meetings date_modified datetime 19  √  null
meetings_contacts date_modified datetime 19  √  null
meetings_leads date_modified datetime 19  √  null
meetings_users date_modified datetime 19  √  null
notes date_modified datetime 19  √  null
notifications date_modified datetime 19  √  null
oauth_consumer date_modified datetime 19  √  null
opportunities date_modified datetime 19  √  null
opportunities_contacts date_modified datetime 19  √  null
pdfmanager date_modified datetime 19  √  null
product_bundle_note date_modified datetime 19  √  null
product_bundle_notes date_modified datetime 19  √  null
product_bundle_product date_modified datetime 19  √  null
product_bundle_quote date_modified datetime 19  √  null
product_bundles date_modified datetime 19  √  null
product_categories date_modified datetime 19  √  null
product_product date_modified datetime 19  √  null
product_templates date_modified datetime 19  √  null
product_types date_modified datetime 19  √  null
products date_modified datetime 19  √  null
project date_modified datetime 19  √  null
project_resources date_modified datetime 19  √  null
project_task date_modified datetime 19  √  null
projects_accounts date_modified datetime 19  √  null
projects_bugs date_modified datetime 19  √  null
projects_cases date_modified datetime 19  √  null
projects_contacts date_modified datetime 19  √  null
projects_opportunities date_modified datetime 19  √  null
projects_products date_modified datetime 19  √  null
projects_quotes date_modified datetime 19  √  null
projects_revenue_line_items date_modified datetime 19  √  null
prospect_list_campaigns date_modified datetime 19  √  null
prospect_lists date_modified datetime 19  √  null
prospect_lists_prospects date_modified datetime 19  √  null
prospects date_modified datetime 19  √  null
quotas date_modified datetime 19  √  null
quotes date_modified datetime 19  √  null
quotes_accounts date_modified datetime 19  √  null
quotes_contacts date_modified datetime 19  √  null
quotes_opportunities date_modified datetime 19  √  null
record_list date_modified datetime 19  √  null
releases date_modified datetime 19  √  null
report_cache date_modified datetime 19  √  null
report_maker date_modified datetime 19  √  null
report_schedules date_modified datetime 19  √  null
revenue_line_items date_modified datetime 19  √  null
roles date_modified datetime 19  √  null
roles_modules date_modified datetime 19  √  null
roles_users date_modified datetime 19  √  null
saved_reports date_modified datetime 19  √  null
saved_search date_modified datetime 19  √  null
schedulers date_modified datetime 19  √  null
schedulers_times date_modified datetime 19  √  null
session_active date_modified datetime 19  √  null
session_history date_modified datetime 19  √  null
shippers date_modified datetime 19  √  null
styleguide date_modified datetime 19  √  null
subscriptions date_modified datetime 19  √  null
sugarfavorites date_modified datetime 19  √  null
systems date_modified datetime 19  √  null
tasks date_modified datetime 19  √  null
taxrates date_modified datetime 19  √  null
team_memberships date_modified datetime 19  √  null
team_notices date_modified datetime 19  √  null
team_sets date_modified datetime 19  √  null
team_sets_teams date_modified datetime 19  √  null
teams date_modified datetime 19  √  null
timeperiods date_modified datetime 19  √  null
tracker date_modified datetime 19  √  null
tracker_perf date_modified datetime 19  √  null
tracker_queries date_modified datetime 19  √  null
tracker_tracker_queries date_modified datetime 19  √  null
user_preferences date_modified datetime 19  √  null
users date_modified datetime 19  √  null
users_feeds date_modified datetime 19  √  null
users_holidays date_modified datetime 19  √  null
users_signatures date_modified datetime 19  √  null
vcals date_modified datetime 19  √  null
versions date_modified datetime 19  √  null
weblogichooks date_modified datetime 19  √  null
workflow date_modified datetime 19  √  null
workflow_actions date_modified datetime 19  √  null
workflow_actionshells date_modified datetime 19  √  null
workflow_alerts date_modified datetime 19  √  null
workflow_alertshells date_modified datetime 19  √  null
workflow_schedules date_modified datetime 19  √  null
workflow_triggershells date_modified datetime 19  √  null
quotes date_order_shipped date 10  √  null
products date_purchased date 10  √  null
revenue_line_items date_purchased date 10  √  null
quotes date_quote_closed date 10  √  null
quotes date_quote_expected_closed date 10  √  null
emails date_sent datetime 19  √  null
calls date_start datetime 19  √  null
email_marketing date_start datetime 19  √  null
meetings date_start datetime 19  √  null
project_task date_start date 10  √  null
report_schedules date_start datetime 19  √  null
styleguide date_start datetime 19  √  null
tasks date_start datetime 19  √  null
team_notices date_start date 10  √  null
tracker_sessions date_start datetime 19  √  null
tasks date_start_flag bit 1  √  0
products date_support_expires date 10  √  null
revenue_line_items date_support_expires date 10  √  null
products date_support_starts date 10  √  null
revenue_line_items date_support_starts date 10  √  null
schedulers date_time_end datetime 19  √  null
schedulers date_time_start datetime 19  √  null
tracker_perf db_round_trips int 6  √  null
versions db_version varchar 255  √  null
products deal_calc decimal 26,6  √  null
revenue_line_items deal_calc decimal 26,6  √  null
products deal_calc_usdollar decimal 26,6  √  null
revenue_line_items deal_calc_usdollar decimal 26,6  √  null
product_bundles deal_tot decimal 26,2  √  null
quotes deal_tot decimal 26,2  √  null
product_bundles deal_tot_usdollar decimal 26,2  √  null
quotes deal_tot_usdollar decimal 26,2  √  null
shippers default_cost decimal 26,6  √  null
shippers default_cost_usdollar decimal 26,6  √  null
users default_team char 36  √  null
fields_meta_data default_value varchar 255  √  null
import_maps default_values text 65535  √  null
inbound_email delete_seen bit 1  √  0
accounts deleted bit 1  √  0
accounts_bugs deleted bit 1  √  0
accounts_cases deleted bit 1  √  0
accounts_contacts deleted bit 1  √  0
accounts_opportunities deleted bit 1  √  0
acl_actions deleted bit 1  √  null
acl_fields deleted bit 1  √  null
acl_roles deleted bit 1  √  null
acl_roles_actions deleted bit 1  √  0
acl_roles_users deleted bit 1  √  0
activities deleted bit 1  √  0
activities_users deleted bit 1  √  0
bugs deleted bit 1  √  0
calls deleted bit 1  √  0
calls_contacts deleted bit 1  √  0
calls_leads deleted bit 1  √  0
calls_users deleted bit 1  √  0
campaign_log deleted bit 1  √  null
campaign_trkrs deleted bit 1  √  0
campaigns deleted bit 1  √  0
cases deleted bit 1  √  0
cases_bugs deleted bit 1  √  0
comments deleted bit 1  √  0
contacts deleted bit 1  √  0
contacts_bugs deleted bit 1  √  0
contacts_cases deleted bit 1  √  0
contacts_users deleted bit 1  √  0
contract_types deleted bit 1  √  0
contracts deleted bit 1  √  0
contracts_contacts deleted bit 1  √  0
contracts_opportunities deleted bit 1  √  0
contracts_products deleted bit 1  √  0
contracts_quotes deleted bit 1  √  0
currencies deleted bit 1  √  null
custom_fields deleted bit 1  √  0
custom_queries deleted bit 1  √  0
dashboards deleted bit 1  √  0
data_sets deleted bit 1  √  0
dataset_attributes deleted bit 1  √  0
dataset_layouts deleted bit 1  √  0
document_revisions deleted bit 1  √  0
documents deleted bit 1  √  0
documents_accounts deleted bit 1  √  0
documents_bugs deleted bit 1  √  0
documents_cases deleted bit 1  √  0
documents_contacts deleted bit 1  √  0
documents_opportunities deleted bit 1  √  0
documents_products deleted bit 1  √  0
documents_quotes deleted bit 1  √  0
documents_revenuelineitems deleted bit 1  √  0
eapm deleted bit 1  √  0
email_addr_bean_rel deleted bit 1  √  0
email_addresses deleted bit 1  √  0
email_cache deleted tinyint 4  √  null
email_marketing deleted bit 1  √  null
email_marketing_prospect_lists deleted bit 1  √  0
email_templates deleted bit 1  √  null
emailman deleted bit 1  √  0
emails deleted bit 1  √  null
emails_beans deleted bit 1  √  0
emails_email_addr_rel deleted bit 1  √  0
emails_text deleted bit 1  √  0
expressions deleted bit 1  √  0
fields_meta_data deleted bit 1  √  0
filters deleted bit 1  √  0
folders deleted bit 1  √  0
folders_rel deleted bit 1  √  0
forecast_manager_worksheets deleted bit 1  √  0
forecast_schedule deleted bit 1  √  null
forecast_worksheets deleted bit 1  √  0
forecasts deleted bit 1  √  null
holidays deleted bit 1  √  null
import_maps deleted bit 1  √  null
inbound_email deleted bit 1  √  0
inbound_email_autoreply deleted bit 1  √  0
job_queue deleted bit 1  √  0
kbcontents deleted bit 1  √  0
kbdocument_revisions deleted bit 1  √  0
kbdocuments deleted bit 1  √  0
kbdocuments_kbtags deleted bit 1  √  0
kbdocuments_views_ratings deleted bit 1  √  0
kbtags deleted bit 1  √  0
leads deleted bit 1  √  0
linked_documents deleted bit 1  √  0
manufacturers deleted bit 1  √  null
meetings deleted bit 1  √  0
meetings_contacts deleted bit 1  √  0
meetings_leads deleted bit 1  √  0
meetings_users deleted bit 1  √  0
notes deleted bit 1  √  0
notifications deleted bit 1  √  0
oauth_consumer deleted bit 1  √  0
oauth_tokens deleted bit 1 0
opportunities deleted bit 1  √  0
opportunities_contacts deleted bit 1  √  0
pdfmanager deleted bit 1  √  0
product_bundle_note deleted bit 1  √  0
product_bundle_notes deleted bit 1  √  0
product_bundle_product deleted bit 1  √  0
product_bundle_quote deleted bit 1  √  0
product_bundles deleted bit 1  √  0
product_categories deleted bit 1  √  0
product_product deleted bit 1  √  0
product_templates deleted bit 1  √  0
product_types deleted bit 1  √  0
products deleted bit 1  √  0
project deleted bit 1  √  0
project_resources deleted bit 1  √  0
project_task deleted bit 1  √  0
projects_accounts deleted bit 1  √  0
projects_bugs deleted bit 1  √  0
projects_cases deleted bit 1  √  0
projects_contacts deleted bit 1  √  0
projects_opportunities deleted bit 1  √  0
projects_products deleted bit 1  √  0
projects_quotes deleted bit 1  √  0
projects_revenue_line_items deleted bit 1  √  0
prospect_list_campaigns deleted bit 1  √  0
prospect_lists deleted bit 1  √  null
prospect_lists_prospects deleted bit 1  √  0
prospects deleted bit 1  √  0
quotas deleted bit 1  √  null
quotes deleted bit 1  √  0
quotes_accounts deleted bit 1  √  0
quotes_contacts deleted bit 1  √  0
quotes_opportunities deleted bit 1  √  0
relationships deleted bit 1  √  0
releases deleted bit 1  √  null
report_cache deleted varchar 1  √  null
report_maker deleted bit 1  √  0
report_schedules deleted bit 1  √  0
revenue_line_items deleted bit 1  √  0
roles deleted bit 1  √  null
roles_modules deleted bit 1  √  0
roles_users deleted bit 1  √  0
saved_reports deleted bit 1  √  null
saved_search deleted bit 1  √  null
schedulers deleted bit 1  √  0
schedulers_times deleted bit 1  √  0
session_active deleted bit 1  √  0
session_history deleted bit 1  √  0
shippers deleted bit 1  √  null
styleguide deleted bit 1  √  0
subscriptions deleted bit 1  √  0
sugarfavorites deleted bit 1  √  0
systems deleted bit 1  √  0
tasks deleted bit 1  √  0
taxrates deleted bit 1  √  null
team_memberships deleted bit 1  √  0
team_notices deleted bit 1  √  null
team_sets deleted bit 1  √  0
team_sets_modules deleted bit 1  √  0
team_sets_teams deleted bit 1  √  0
teams deleted bit 1  √  0
timeperiods deleted bit 1  √  null
tracker deleted bit 1  √  0
tracker_perf deleted bit 1  √  0
tracker_queries deleted bit 1  √  0
tracker_sessions deleted bit 1  √  0
user_preferences deleted bit 1  √  0
users deleted bit 1  √  null
users_feeds deleted bit 1  √  0
users_holidays deleted bit 1  √  0
users_last_import deleted bit 1  √  null
users_password_link deleted bit 1  √  null
users_signatures deleted bit 1  √  0
vcals deleted bit 1  √  null
versions deleted bit 1  √  null
weblogichooks deleted bit 1  √  0
workflow deleted bit 1  √  0
workflow_actions deleted bit 1  √  0
workflow_actionshells deleted bit 1  √  0
workflow_alerts deleted bit 1  √  0
workflow_alertshells deleted bit 1  √  0
workflow_schedules deleted bit 1  √  0
workflow_triggershells deleted bit 1  √  0
import_maps delimiter varchar 1  √  ,
contacts department varchar 255  √  null
leads department varchar 100  √  null
prospects department varchar 255  √  null
styleguide department varchar 255  √  null
users department varchar 50  √  null
accounts description text 65535  √  null
acl_roles description text 65535  √  null
bugs description text 65535  √  null
calls description text 65535  √  null
cases description text 65535  √  null
contacts description text 65535  √  null
contracts description text 65535  √  null
custom_queries description text 65535  √  null
dashboards description text 65535  √  null
data_sets description text 65535  √  null
documents description text 65535  √  null
eapm description text 65535  √  null
email_templates description text 65535  √  null
emails_text description longtext 2147483647  √  null
filters description text 65535  √  null
forecast_manager_worksheets description text 65535  √  null
forecast_worksheets description text 65535  √  null
holidays description text 65535  √  null
kbdocuments description text 65535  √  null
leads description text 65535  √  null
meetings description text 65535  √  null
notes description text 65535  √  null
notifications description text 65535  √  null
oauth_consumer description text 65535  √  null
opportunities description text 65535  √  null
pdfmanager description text 65535  √  null
product_bundle_notes description text 65535  √  null
product_bundles description text 65535  √  null
product_categories description text 65535  √  null
product_templates description text 65535  √  null
product_types description text 65535  √  null
products description text 65535  √  null
project description text 65535  √  null
project_task description text 65535  √  null
prospect_lists description text 65535  √  null
prospects description text 65535  √  null
quotes description text 65535  √  null
report_maker description text 65535  √  null
revenue_line_items description text 65535  √  null
roles description text 65535  √  null
saved_search description text 65535  √  null
schedulers description text 65535  √  null
styleguide description text 65535  √  null
sugarfavorites description varchar 50  √  null
tasks description text 65535  √  null
team_notices description text 65535  √  null
teams description text 65535  √  null
upgrade_history description text 65535  √  null
users description text 65535  √  null
users_signatures description text 65535  √  null
weblogichooks description text 65535  √  null
workflow description text 65535  √  null
emails_text description_html longtext 2147483647  √  null
calls direction varchar 100  √  null
quotes discount decimal 26,6  √  null
forecast_worksheets discount_amount decimal 26,6  √  null
products discount_amount decimal 26,6  √  null
revenue_line_items discount_amount decimal 26,6  √  null
products discount_amount_usdollar decimal 26,6  √  null
revenue_line_items discount_amount_usdollar decimal 26,6  √  null
forecast_worksheets discount_price decimal 26,6  √  null
product_templates discount_price decimal 26,6  √  null
products discount_price decimal 26,6  √  null
revenue_line_items discount_price decimal 26,6  √  null
products discount_rate_percent decimal 4,2  √  null
revenue_line_items discount_rate_percent decimal 27,2  √  null
products discount_select bit 1  √  null
revenue_line_items discount_select bit 1  √  null
product_templates discount_usdollar decimal 26,6  √  null
products discount_usdollar decimal 26,6  √  null
revenue_line_items discount_usdollar decimal 26,6  √  null
dataset_attributes display_name varchar 50  √  null
dataset_attributes display_type varchar 25  √  null
meetings displayed_url varchar 400  √  null
contacts dnb_principal_id varchar 30  √  null
contacts do_not_call bit 1  √  0
leads do_not_call bit 1  √  0
prospects do_not_call bit 1  √  0
styleguide do_not_call bit 1  √  0
document_revisions doc_id varchar 100  √  null
documents doc_id varchar 100  √  null
document_revisions doc_type varchar 100  √  null
documents doc_type varchar 100  √  Sugar
document_revisions doc_url varchar 255  √  null
documents doc_url varchar 255  √  null
document_revisions document_id char 36  √  null
documents_accounts document_id char 36  √  null
documents_bugs document_id char 36  √  null
documents_cases document_id char 36  √  null
documents_contacts document_id char 36  √  null
documents_opportunities document_id char 36  √  null
documents_products document_id char 36  √  null
documents_quotes document_id varchar 36  √  null
documents_revenuelineitems document_id varchar 36  √  null
linked_documents document_id varchar 36  √  null
documents document_name varchar 255  √  null
documents document_revision_id char 36  √  null
kbcontents document_revision_id char 36  √  null
kbdocument_revisions document_revision_id char 36  √  null
linked_documents document_revision_id varchar 36  √  null
prospect_lists domain_name varchar 255  √  null
oauth_tokens download_token varchar 36  √  null
email_cache draft tinyint 4  √  null
forecast_manager_worksheets draft bit 1  √  0
forecast_worksheets draft int 11  √  0
accounts duns_num varchar 15  √  null
fields_meta_data duplicate_merge smallint 6  √  0
project_task duration int 11  √  null
calls duration_hours int 2  √  null
meetings duration_hours int 3  √  null
calls duration_minutes int 2  √  null
meetings duration_minutes varchar 2  √  null
project_task duration_unit text 65535  √  null
folders dynamic_query text 65535  √  null
email_addresses email_address varchar 255  √  null
email_addresses email_address_caps varchar 255  √  null
email_addr_bean_rel email_address_id char 36
emails_email_addr_rel email_address_id char 36
emails_beans email_id char 36  √  null
emails_email_addr_rel email_id char 36
emails_text email_id char 36
email_marketing_prospect_lists email_marketing_id varchar 36  √  null
inbound_email email_password varchar 100  √  null
calls email_reminder_sent bit 1  √  0
meetings email_reminder_sent bit 1  √  0
calls email_reminder_time int 11  √  -1
meetings email_reminder_time int 11  √  -1
inbound_email email_user varchar 100  √  null
notes embed_flag bit 1  √  0
users employee_status varchar 100  √  null
accounts employees varchar 10  √  null
upgrade_history enabled bit 1  √  1
import_maps enclosure varchar 1  √ 
campaigns end_date date 10  √  null
contracts end_date date 10  √  null
timeperiods end_date date 10  √  null
timeperiods end_date_timestamp int 14  √  null
project_task estimated_effort int 11  √  null
project estimated_end_date date 10  √  null
project estimated_start_date date 10  √  null
workflow_triggershells eval text 65535  √  null
job_queue execute_time datetime 19  √  null
schedulers_times execute_time datetime 19  √  null
documents exp_date date 10  √  null
kbdocuments exp_date date 10  √  null
expressions exp_order int 4  √  null
expressions exp_type varchar 100  √  null
campaigns expected_cost decimal 26,6  √  null
campaigns expected_revenue decimal 26,6  √  null
contracts expiration_notice datetime 19  √  null
oauth_tokens expire_ts bigint 20  √  -1
team_memberships explicit_assign bit 1  √  0
data_sets exportable varchar 3  √  0
expressions ext1 varchar 50  √  null
fields_meta_data ext1 varchar 255  √  null
workflow_actions ext1 varchar 50  √  null
expressions ext2 varchar 50  √  null
fields_meta_data ext2 varchar 255  √  null
workflow_actions ext2 varchar 50  √  null
expressions ext3 varchar 50  √  null
fields_meta_data ext3 varchar 255  √  null
workflow_actions ext3 varchar 50  √  null
fields_meta_data ext4 text 65535  √  null
users external_auth_only bit 1  √  0
meetings external_id varchar 50  √  null
accounts facebook varchar 100  √  null
contacts facebook varchar 100  √  null
leads facebook varchar 100  √  null
prospects facebook varchar 100  √  null
styleguide facebook varchar 100  √  null
job_queue failure_count tinyint 4  √  null
saved_reports favorite bit 1  √  null
users_feeds feed_id varchar 36  √  null
pdfmanager field varchar 100  √  0
workflow_actions field varchar 50  √  null
workflow_triggershells field varchar 50  √  null
custom_fields field0 varchar 255  √  null
custom_fields field1 varchar 255  √  null
custom_fields field2 varchar 255  √  null
custom_fields field3 varchar 255  √  null
custom_fields field4 varchar 255  √  null
custom_fields field5 varchar 255  √  null
custom_fields field6 varchar 255  √  null
custom_fields field7 varchar 255  √  null
custom_fields field8 varchar 255  √  null
custom_fields field9 varchar 255  √  null
accounts_audit field_name varchar 100  √  null
bugs_audit field_name varchar 100  √  null
campaigns_audit field_name varchar 100  √  null
cases_audit field_name varchar 100  √  null
contacts_audit field_name varchar 100  √  null
contracts_audit field_name varchar 100  √  null
forecast_manager_worksheets_audit field_name varchar 100  √  null
kbcontents_audit field_name varchar 100  √  null
leads_audit field_name varchar 100  √  null
notifications_audit field_name varchar 100  √  null
opportunities_audit field_name varchar 100  √  null
product_templates_audit field_name varchar 100  √  null
products_audit field_name varchar 100  √  null
project_task_audit field_name varchar 100  √  null
quotes_audit field_name varchar 100  √  null
revenue_line_items_audit field_name varchar 100  √  null
workflow_alerts field_value varchar 50  √  null
activities_users fields longtext 2147483647  √  null
document_revisions file_ext varchar 100  √  null
kbdocument_revisions file_ext varchar 100  √  null
document_revisions file_mime_type varchar 100  √  null
kbdocument_revisions file_mime_type varchar 100  √  null
notes file_mime_type varchar 100  √  null
styleguide file_mime_type varchar 100  √  null
versions file_version varchar 255  √  null
document_revisions filename varchar 255  √  null
kbdocument_revisions filename varchar 255  √  null
notes filename varchar 255  √  null
styleguide filename varchar 255  √  null
upgrade_history filename varchar 255  √  null
tracker_perf files_opened int 6  √  null
filters filter_definition longtext 2147483647  √  null
filters filter_template longtext 2147483647  √  null
workflow fire_order varchar 100  √  null
contacts first_name varchar 100  √  null
leads first_name varchar 100  √  null
prospects first_name varchar 100  √  null
styleguide first_name varchar 100  √  null
users first_name varchar 30  √  null
bugs fixed_in_release varchar 255  √  null
email_cache flagged tinyint 4  √  null
emails flagged bit 1  √  null
folders_rel folder_id char 36
folders_subscriptions folder_id char 36
folders folder_type varchar 25  √  null
dataset_attributes font_color varchar 25  √  null
data_sets font_size varchar 8  √  0
dataset_attributes font_size varchar 8  √  0
pdfmanager footer_text varchar 255  √  null
forecast_schedule forecast_start_date date 10  √  null
forecasts forecast_type varchar 100  √  null
dataset_attributes format_type varchar 25  √  null
bugs found_in_release varchar 255  √  null
workflow_triggershells frame_type varchar 15  √  null
campaigns frequency varchar 100  √  null
email_marketing from_addr varchar 100  √  null
emails_text from_addr varchar 255  √  null
email_templates from_address varchar 255  √  null
email_marketing from_name varchar 100  √  null
email_templates from_name varchar 255  √  null
email_cache fromaddr varchar 100  √  null
accounts googleplus varchar 100  √  null
contacts googleplus varchar 100  √  null
leads googleplus varchar 100  √  null
prospects googleplus varchar 100  √  null
styleguide googleplus varchar 100  √  null
inbound_email group_id char 36  √  null
inbound_email groupfolder_id char 36  √  null
folders has_child bit 1  √  0
import_maps has_header bit 1  √  1
data_sets header varchar 3  √  0
data_sets header_back_color varchar 100  √  null
pdfmanager header_text varchar 255  √  null
data_sets header_text_color varchar 100  √  null
pdfmanager header_title varchar 255  √  null
fields_meta_data help varchar 255  √  null
dataset_layouts hide_column varchar 3  √  null
forecast_tree hierarchy_type varchar 25  √  null
campaign_log hits int 11  √  0
holidays holiday_date date 10  √  null
users_holidays holiday_id varchar 36  √  null
meetings host_url varchar 400  √  null
accounts id char 36
accounts_audit id char 36
accounts_bugs id varchar 36
accounts_cases id varchar 36
accounts_contacts id varchar 36
accounts_opportunities id varchar 36
acl_actions id char 36
acl_fields id char 36
acl_roles id char 36
acl_roles_actions id varchar 36
acl_roles_users id varchar 36
activities id char 36
activities_users id char 36
address_book_lists id char 36
bugs id char 36
bugs_audit id char 36
calls id char 36
calls_contacts id char 36
calls_leads id char 36
calls_users id char 36
campaign_log id char 36
campaign_trkrs id char 36
campaigns id char 36
campaigns_audit id char 36
cases id char 36
cases_audit id char 36
cases_bugs id varchar 36
comments id char 36
contacts id char 36
contacts_audit id char 36
contacts_bugs id varchar 36
contacts_cases id varchar 36
contacts_users id varchar 36
contract_types id char 36
contracts id char 36
contracts_audit id char 36
contracts_contacts id varchar 36
contracts_opportunities id varchar 36
contracts_products id varchar 36
contracts_quotes id varchar 36
currencies id char 36
custom_queries id char 36
dashboards id char 36
data_sets id char 36
dataset_attributes id char 36
dataset_layouts id char 36
document_revisions id char 36
documents id char 36
documents_accounts id char 36
documents_bugs id char 36
documents_cases id char 36
documents_contacts id char 36
documents_opportunities id char 36
documents_products id char 36
documents_quotes id varchar 36
documents_revenuelineitems id varchar 36
eapm id char 36
email_addr_bean_rel id char 36
email_addresses id char 36
email_marketing id char 36
email_marketing_prospect_lists id varchar 36
email_templates id char 36
emails id char 36
emails_beans id char 36
emails_email_addr_rel id char 36
expressions id char 36
fields_meta_data id varchar 255
filters id char 36
folders id char 36
folders_rel id char 36
folders_subscriptions id char 36
forecast_manager_worksheets id char 36
forecast_manager_worksheets_audit id char 36
forecast_schedule id char 36
forecast_tree id char 36
forecast_worksheets id char 36
forecasts id char 36
fts_queue id char 36
holidays id char 36
import_maps id char 36
inbound_email id varchar 36
inbound_email_autoreply id char 36
inbound_email_cache_ts id varchar 255
job_queue id char 36
kbcontents id char 36
kbcontents_audit id char 36
kbdocument_revisions id char 36
kbdocuments id char 36
kbdocuments_kbtags id char 36
kbdocuments_views_ratings id varchar 36
kbtags id char 36
leads id char 36
leads_audit id char 36
linked_documents id varchar 36
manufacturers id char 36
meetings id char 36
meetings_contacts id char 36
meetings_leads id char 36
meetings_users id char 36
notes id char 36
notifications id char 36
notifications_audit id char 36
oauth_consumer id char 36
oauth_tokens id char 36
opportunities id char 36
opportunities_audit id char 36
opportunities_contacts id varchar 36
outbound_email id char 36
pdfmanager id char 36
product_bundle_note id varchar 36
product_bundle_notes id char 36
product_bundle_product id varchar 36
product_bundle_quote id varchar 36
product_bundles id char 36
product_categories id char 36
product_product id varchar 36
product_templates id char 36
product_templates_audit id char 36
product_types id char 36
products id char 36
products_audit id char 36
project id char 36
project_resources id char 36
project_task id char 36
project_task_audit id char 36
projects_accounts id varchar 36
projects_bugs id varchar 36
projects_cases id varchar 36
projects_contacts id varchar 36
projects_opportunities id varchar 36
projects_products id varchar 36
projects_quotes id varchar 36
projects_revenue_line_items id varchar 36
prospect_list_campaigns id varchar 36
prospect_lists id char 36
prospect_lists_prospects id varchar 36
prospects id char 36
quotas id char 36
quotes id char 36
quotes_accounts id varchar 36
quotes_audit id char 36
quotes_contacts id varchar 36
quotes_opportunities id varchar 36
record_list id char 36
relationships id char 36
releases id char 36
report_cache id char 36
report_maker id char 36
report_schedules id char 36
revenue_line_items id char 36
revenue_line_items_audit id char 36
roles id char 36
roles_modules id varchar 36
roles_users id varchar 36
saved_reports id char 36
saved_search id char 36
schedulers id char 36
schedulers_times id char 36
session_active id char 36
session_history id char 36
shippers id char 36
styleguide id char 36
subscriptions id char 36
sugarfavorites id char 36
systems id char 36
tasks id char 36
taxrates id char 36
team_memberships id char 36
team_notices id char 36
team_sets id char 36
team_sets_modules id char 36
team_sets_teams id char 36
teams id char 36
timeperiods id char 36
upgrade_history id char 36
user_preferences id char 36
users id char 36
users_holidays id varchar 36
users_last_import id char 36
users_password_link id char 36
users_signatures id char 36
vcals id char 36
versions id char 36
weblogichooks id char 36
workflow id char 36
workflow_actions id char 36
workflow_actionshells id char 36
workflow_alerts id char 36
workflow_alertshells id char 36
workflow_schedules id char 36
workflow_triggershells id char 36
upgrade_history id_name varchar 255  √  null
email_cache ie_id char 36  √  null
inbound_email_autoreply ie_id char 36
inbound_email_cache_ts ie_timestamp int unsigned 10  √  null
email_cache imap_uid int unsigned 10  √  null
team_memberships implicit_assign bit 1  √  0
users_last_import import_module varchar 36  √  null
fields_meta_data importable varchar 255  √  null
campaigns impressions int 11  √  0
emailman in_queue bit 1  √  0
emailman in_queue_date datetime 19  √  null
email_marketing inbound_email_id char 36  √  null
accounts industry varchar 50  √  null
systems install_method varchar 100  √  null
emails intent varchar 100  √  pick
email_addresses invalid_email bit 1  √  0
users is_admin bit 1  √  0
folders is_dynamic bit 1  √  0
kbdocuments is_external_article bit 1  √  0
timeperiods is_fiscal bit 1  √  0
timeperiods is_fiscal_year bit 1  √  0
folders is_group bit 1  √  0
users is_group bit 1  √  null
campaign_trkrs is_optout bit 1  √  0
inbound_email is_personal bit 1  √  0
import_maps is_published varchar 3  √  no
saved_reports is_published bit 1  √  0
notifications is_read bit 1  √  0
documents is_template bit 1  √  0
kbdocuments is_template bit 1  √  0
project is_template bit 1  √  0
session_active is_violation bit 1  √  0
session_history is_violation bit 1  √  0
currencies iso4217 varchar 3  √  null
tracker item_id char 36  √  null
tracker item_summary varchar 255  √  null
schedulers job varchar 255  √  null
job_queue job_delay int 11  √  null
job_queue job_group varchar 255  √  null
schedulers job_interval varchar 100  √  null
relationships join_key_lhs varchar 128  √  null
relationships join_key_rhs varchar 128  √  null
relationships join_table varchar 128  √  null
meetings join_url varchar 200  √  null
kbdocument_revisions kbcontent_id char 36  √  null
kbdocuments kbdoc_approver_id char 36  √  null
kbcontents kbdocument_body longtext 2147483647  √  null
kbdocument_revisions kbdocument_id char 36  √  null
kbdocuments_kbtags kbdocument_id char 36  √  null
kbdocuments_views_ratings kbdocument_id varchar 36  √  null
kbdocuments kbdocument_name varchar 255  √  null
kbdocuments kbdocument_revision_id char 36  √  null
kbdocuments kbdocument_revision_number varchar 100  √  null
kbdocuments_kbtags kbtag_id char 36  √  null
pdfmanager keywords varchar 255  √  null
activities last_comment longtext 2147483647  √  null
systems last_connect_date datetime 19  √  null
contacts last_name varchar 100  √  null
leads last_name varchar 100  √  null
prospects last_name varchar 100  √  null
styleguide last_name varchar 100  √  null
users last_name varchar 30  √  null
session_active last_request_time datetime 19  √  null
session_history last_request_time datetime 19  √  null
schedulers last_run datetime 19  √  null
kbdocument_revisions latest bit 1  √  0
dataset_layouts layout_type varchar 25  √  null
calls_leads lead_id char 36  √  null
meetings_leads lead_id char 36  √  null
prospects lead_id char 36  √  null
contacts lead_source varchar 255  √  null
forecast_worksheets lead_source varchar 50  √  null
leads lead_source varchar 100  √  null
opportunities lead_source varchar 50  √  null
revenue_line_items lead_source varchar 50  √  null
leads lead_source_description text 65535  √  null
timeperiods leaf_cycle int 2  √  null
fields_meta_data len int 11  √  null
expressions lhs_field varchar 50  √  null
expressions lhs_group_type varchar 10  √  null
relationships lhs_key varchar 64  √  null
expressions lhs_module varchar 50  √  null
relationships lhs_module varchar 100  √  null
relationships lhs_table varchar 64  √  null
expressions lhs_type varchar 15  √  null
expressions lhs_value varchar 100  √  null
relationships lhs_vname varchar 64  √  null
forecast_manager_worksheets likely_case decimal 26,6  √  null
forecast_worksheets likely_case decimal 26,6  √  null
forecasts likely_case decimal 26,6  √  null
revenue_line_items likely_case decimal 26,6  √  null
forecast_manager_worksheets likely_case_adjusted decimal 26,6  √  null
address_book_list_items list_id char 36
campaign_log list_id char 36  √  null
emailman list_id char 36  √  null
address_book_lists list_name varchar 100  √  null
contract_types list_order int 4  √  null
custom_queries list_order int 4  √  null
manufacturers list_order int 4  √  null
product_categories list_order int 4  √  null
product_types list_order int 4  √  null
releases list_order int 4  √  null
shippers list_order int 4  √  null
taxrates list_order int 4  √  null
dataset_layouts list_order_x int 4  √  null
data_sets list_order_y int 3  √  0
workflow list_order_y int 3  √  0
dataset_layouts list_order_z int 4  √  null
forecast_worksheets list_price decimal 26,6  √  null
product_templates list_price decimal 26,6  √  null
products list_price decimal 26,6  √  null
revenue_line_items list_price decimal 26,6  √  null
styleguide list_price decimal 26,6  √  null
prospect_lists list_type varchar 100  √  null
product_templates list_usdollar decimal 26,6  √  null
products list_usdollar decimal 26,6  √  null
revenue_line_items list_usdollar decimal 26,6  √  null
meetings location varchar 50  √  null
kbdocuments mail_merge_document varchar 3  √  off
outbound_email mail_sendtype varchar 8  √  smtp
outbound_email mail_smtpauth_req bit 1  √  0
outbound_email mail_smtppass varchar 100  √  null
outbound_email mail_smtpport int 5  √  0
outbound_email mail_smtpserver varchar 100  √  null
outbound_email mail_smtpssl int 1  √  0
outbound_email mail_smtptype varchar 20  √  other
outbound_email mail_smtpuser varchar 100  √  null
inbound_email mailbox text 65535  √  null
emails mailbox_id char 36  √  null
inbound_email mailbox_type varchar 10  √  null
email_cache mailsize int unsigned 10  √  null
forecast_manager_worksheets manager_saved bit 1  √  0
upgrade_history manifest longtext 2147483647  √  null
product_templates manufacturer_id char 36  √  null
products manufacturer_id char 36  √  null
revenue_line_items manufacturer_id char 36  √  null
campaign_log marketing_id char 36  √  null
emailman marketing_id char 36  √  null
fields_meta_data massupdate bit 1  √  0
email_cache mbox varchar 60  √  null
upgrade_history md5sum varchar 32  √  null
meetings_contacts meeting_id char 36  √  null
meetings_leads meeting_id char 36  √  null
meetings_users meeting_id char 36  √  null
tracker_perf memory_usage int 12  √  null
job_queue message text 65535  √  null
email_cache message_id varchar 255  √  null
emails message_id varchar 255  √  null
emails message_uid varchar 64  √  null
users messenger_id varchar 100  √  null
users messenger_type varchar 100  √  null
dashboards metadata text 65535  √  null
product_templates mft_part_num varchar 50  √  null
products mft_part_num varchar 50  √  null
revenue_line_items mft_part_num varchar 50  √  null
project_task milestone_flag bit 1  √  null
contacts mkto_id int 11  √  null
leads mkto_id int 11  √  null
opportunities mkto_id int 11  √  null
contacts mkto_lead_score int 11  √  null
leads mkto_lead_score int 11  √  null
contacts mkto_sync bit 1  √  0
leads mkto_sync bit 1  √  0
opportunities mkto_sync bit 1  √  0
folders modified_by char 36
accounts modified_user_id char 36  √  null
acl_actions modified_user_id char 36  √  null
acl_fields modified_user_id char 36  √  null
acl_roles modified_user_id char 36  √  null
activities modified_user_id char 36  √  null
bugs modified_user_id char 36  √  null
calls modified_user_id char 36  √  null
campaign_trkrs modified_user_id char 36  √  null
campaigns modified_user_id char 36  √  null
cases modified_user_id char 36  √  null
comments modified_user_id char 36  √  null
contacts modified_user_id char 36  √  null
contract_types modified_user_id char 36  √  null
contracts modified_user_id char 36  √  null
custom_queries modified_user_id char 36  √  null
dashboards modified_user_id char 36  √  null
data_sets modified_user_id char 36  √  null
dataset_attributes modified_user_id char 36  √  null
dataset_layouts modified_user_id char 36  √  null
documents modified_user_id char 36  √  null
eapm modified_user_id char 36  √  null
email_marketing modified_user_id char 36  √  null
email_templates modified_user_id char 36  √  null
emailman modified_user_id char 36  √  null
emails modified_user_id char 36  √  null
expressions modified_user_id char 36  √  null
filters modified_user_id char 36  √  null
forecast_manager_worksheets modified_user_id char 36  √  null
forecast_worksheets modified_user_id char 36  √  null
holidays modified_user_id char 36  √  null
inbound_email modified_user_id char 36  √  null
kbcontents modified_user_id char 36  √  null
kbdocuments modified_user_id char 36  √  null
leads modified_user_id char 36  √  null
manufacturers modified_user_id char 36  √  null
meetings modified_user_id char 36  √  null
notes modified_user_id char 36  √  null
notifications modified_user_id char 36  √  null
oauth_consumer modified_user_id char 36  √  null
opportunities modified_user_id char 36  √  null
pdfmanager modified_user_id char 36  √  null
product_bundle_notes modified_user_id char 36  √  null
product_bundles modified_user_id char 36  √  null
product_categories modified_user_id char 36  √  null
product_templates modified_user_id char 36  √  null
product_types modified_user_id char 36  √  null
products modified_user_id char 36  √  null
project modified_user_id char 36  √  null
project_resources modified_user_id char 36  √  null
project_task modified_user_id char 36  √  null
prospect_lists modified_user_id char 36  √  null
prospects modified_user_id char 36  √  null
quotas modified_user_id char 36  √  null
quotes modified_user_id char 36  √  null
releases modified_user_id char 36  √  null
report_maker modified_user_id char 36  √  null
revenue_line_items modified_user_id char 36  √  null
roles modified_user_id char 36  √  null
saved_reports modified_user_id char 36  √  null
schedulers modified_user_id char 36  √  null
shippers modified_user_id char 36
styleguide modified_user_id char 36  √  null
subscriptions modified_user_id char 36  √  null
sugarfavorites modified_user_id char 36  √  null
tasks modified_user_id char 36  √  null
taxrates modified_user_id char 36  √  null
team_notices modified_user_id char 36  √  null
teams modified_user_id char 36  √  null
users modified_user_id char 36  √  null
users_signatures modified_user_id char 36  √  null
versions modified_user_id char 36  √  null
weblogichooks modified_user_id char 36  √  null
workflow modified_user_id char 36  √  null
workflow_actions modified_user_id char 36  √  null
workflow_actionshells modified_user_id char 36  √  null
workflow_alerts modified_user_id char 36  √  null
workflow_alertshells modified_user_id char 36  √  null
workflow_schedules modified_user_id char 36  √  null
workflow_triggershells modified_user_id char 36  √  null
import_maps module varchar 36  √  null
saved_reports module varchar 255  √  null
sugarfavorites module varchar 50  √  null
roles_modules module_id varchar 36  √  null
filters module_name varchar 100  √  null
record_list module_name varchar 50  √  null
tracker module_name varchar 255  √  null
team_sets_modules module_table_name varchar 128  √  null
roles modules text 65535  √  null
tracker monitor_id char 36
tracker_perf monitor_id char 36
tracker_tracker_queries monitor_id char 36  √  null
campaign_log more_information varchar 100  √  null
email_cache msgno int unsigned 10  √  null
accounts name varchar 150  √  null
acl_actions name varchar 150  √  null
acl_fields name varchar 150  √  null
acl_roles name varchar 150  √  null
bugs name varchar 255  √  null
calls name varchar 50  √  null
campaigns name varchar 50  √  null
cases name varchar 255  √  null
config name varchar 32  √  null
contract_types name varchar 30  √  null
contracts name varchar 255  √  null
currencies name varchar 36  √  null
custom_queries name varchar 50  √  null
dashboards name varchar 255  √  null
data_sets name varchar 50  √  null
eapm name varchar 255  √  null
email_marketing name varchar 255  √  null
email_templates name varchar 255  √  null
emails name varchar 255  √  null
fields_meta_data name varchar 255  √  null
filters name varchar 255  √  null
folders name varchar 25  √  null
forecast_manager_worksheets name varchar 255  √  null
forecast_tree name varchar 50  √  null
forecast_worksheets name varchar 255  √  null
import_maps name varchar 254  √  null
inbound_email name varchar 255  √  null
job_queue name varchar 255  √  null
manufacturers name varchar 50  √  null
meetings name varchar 50  √  null
notes name varchar 255  √  null
notifications name varchar 255  √  null
oauth_consumer name varchar 255  √  null
opportunities name varchar 50  √  null
outbound_email name varchar 50  √  null
pdfmanager name varchar 255  √  null
product_bundles name varchar 255  √  null
product_categories name varchar 50  √  null
product_templates name varchar 50  √  null
product_types name varchar 50  √  null
products name varchar 50  √  null
project name varchar 50  √  null
project_task name varchar 50  √  null
prospect_lists name varchar 50  √  null
quotes name varchar 50  √  null
releases name varchar 50  √  null
report_maker name varchar 50  √  null
revenue_line_items name varchar 50  √  null
roles name varchar 150  √  null
saved_reports name varchar 255  √  null
saved_search name varchar 150  √  null
schedulers name varchar 255  √  null
shippers name varchar 50  √  null
styleguide name varchar 255  √  null
sugarfavorites name varchar 255  √  null
tasks name varchar 50  √  null
taxrates name varchar 50  √  null
team_notices name varchar 50  √  null
team_sets name varchar 128  √  null
teams name varchar 128  √  null
timeperiods name varchar 36  √  null
upgrade_history name varchar 255  √  null
users_signatures name varchar 255  √  null
versions name varchar 255  √  null
weblogichooks name varchar 255  √  null
workflow name varchar 50  √  null
workflow_alertshells name varchar 50  √  null
teams name_2 varchar 128  √  null
product_bundles new_sub decimal 26,6  √  null
quotes new_sub decimal 26,6  √  null
product_bundles new_sub_usdollar decimal 26,6  √  null
quotes new_sub_usdollar decimal 26,6  √  null
report_schedules next_run datetime 19  √  null
forecast_worksheets next_step varchar 100  √  null
opportunities next_step varchar 100  √  null
products next_step varchar 100  √  null
revenue_line_items next_step varchar 100  √  null
oauth_nonce nonce varchar 32
oauth_nonce nonce_ts bigint 20  √  null
product_bundle_note note_id varchar 36  √  null
product_bundle_note note_index int 11  √  0
session_active num_active_sessions int 11  √  0
session_history num_active_sessions int 11  √  0
systems num_syncs int 11  √  0
eapm oauth_secret varchar 255  √  null
eapm oauth_token varchar 255  √  null
oauth_consumer oauth_type varchar 50  √  oauth1
campaigns objective text 65535  √  null
expressions operator varchar 15  √  null
forecast_manager_worksheets opp_count int 5  √  null
forecasts opp_count int 5  √  null
forecasts opp_weigh_value int 11  √  null
leads opportunity_amount varchar 50  √  null
accounts_opportunities opportunity_id varchar 36  √  null
contracts_opportunities opportunity_id varchar 36  √  null
documents_opportunities opportunity_id char 36  √  null
forecast_worksheets opportunity_id char 36  √  null
leads opportunity_id char 36  √  null
opportunities_contacts opportunity_id varchar 36  √  null
products opportunity_id char 36  √  null
projects_opportunities opportunity_id varchar 36  √  null
quotes_opportunities opportunity_id varchar 36  √  null
revenue_line_items opportunity_id char 36  √  null
forecast_worksheets opportunity_name varchar 255  √  null
leads opportunity_name varchar 255  √  null
opportunities opportunity_type varchar 255  √  null
email_addresses opt_out bit 1  √  0
project_task order_number int 11  √  1
quotes order_stage varchar 100  √  null
quotes original_po_date date 10  √  null
calls outlook_id varchar 255  √  null
meetings outlook_id varchar 255  √  null
data_sets output_default varchar 100  √  null
accounts ownership varchar 100  √  null
workflow_actionshells parameters varchar 255  √  null
workflow_schedules parameters varchar 255  √  null
workflow_triggershells parameters varchar 255  √  null
expressions parent_exp_id char 36  √  null
expressions parent_exp_side int 8  √  null
folders parent_folder char 36  √  null
accounts parent_id char 36  √  null
accounts_audit parent_id char 36
activities parent_id char 36  √  null
activities_users parent_id char 36  √  null
bugs_audit parent_id char 36
calls parent_id char 36  √  null
campaigns_audit parent_id char 36
cases_audit parent_id char 36
comments parent_id char 36
contacts_audit parent_id char 36
contracts_audit parent_id char 36
data_sets parent_id char 36  √  null
dataset_attributes parent_id char 36  √  null
dataset_layouts parent_id char 36  √  null
emails parent_id char 36  √  null
expressions parent_id char 36
forecast_manager_worksheets_audit parent_id char 36
forecast_tree parent_id char 36  √  null
forecast_worksheets parent_id char 36  √  null
kbcontents_audit parent_id char 36
kbdocuments parent_id char 36  √  null
leads_audit parent_id char 36
linked_documents parent_id varchar 36  √  null
meetings parent_id char 36  √  null
notes parent_id char 36  √  null
notifications parent_id char 36  √  null
notifications_audit parent_id char 36
opportunities_audit parent_id char 36
product_categories parent_id char 36  √  null
product_product parent_id varchar 36  √  null
product_templates_audit parent_id char 36
products_audit parent_id char 36
project_task_audit parent_id char 36
quotes_audit parent_id char 36
revenue_line_items_audit parent_id char 36
styleguide parent_id char 36  √  null
subscriptions parent_id char 36
tasks parent_id char 36  √  null
timeperiods parent_id char 36  √  null
workflow parent_id char 36  √  null
workflow_actions parent_id char 36
workflow_actionshells parent_id char 36
workflow_alerts parent_id char 36
workflow_alertshells parent_id char 36
workflow_triggershells parent_id char 36
category_tree parent_node_id int 11  √  0
kbtags parent_tag_id char 36  √  null
project_task parent_task_id int 11  √  null
activities parent_type varchar 100  √  null
activities_users parent_type varchar 100  √  null
calls parent_type varchar 255  √  null
emails parent_type varchar 100  √  null
expressions parent_type varchar 255  √  null
forecast_worksheets parent_type varchar 255  √  null
kbdocuments parent_type varchar 255  √  null
linked_documents parent_type varchar 25  √  null
meetings parent_type varchar 100  √  null
notes parent_type varchar 255  √  null
notifications parent_type varchar 100  √  null
styleguide parent_type varchar 255  √  null
subscriptions parent_type varchar 100  √  null
tasks parent_type varchar 255  √  null
dataset_layouts parent_value varchar 50  √  null
eapm password varchar 255  √  null
meetings password varchar 50  √  null
quotes payment_terms varchar 128  √  null
job_queue percent_complete int 11  √  null
project_task percent_complete int 11  √  null
holidays person_id char 36  √  null
holidays person_type varchar 255  √  null
accounts phone_alternate varchar 100  √  null
accounts phone_fax varchar 100  √  null
contacts phone_fax varchar 100  √  null
leads phone_fax varchar 100  √  null
prospects phone_fax varchar 100  √  null
styleguide phone_fax varchar 100  √  null
users phone_fax varchar 50  √  null
contacts phone_home varchar 100  √  null
leads phone_home varchar 100  √  null
prospects phone_home varchar 100  √  null
styleguide phone_home varchar 100  √  null
users phone_home varchar 50  √  null
contacts phone_mobile varchar 100  √  null
leads phone_mobile varchar 100  √  null
prospects phone_mobile varchar 100  √  null
styleguide phone_mobile varchar 100  √  null
users phone_mobile varchar 50  √  null
accounts phone_office varchar 100  √  null
contacts phone_other varchar 100  √  null
leads phone_other varchar 100  √  null
prospects phone_other varchar 100  √  null
styleguide phone_other varchar 100  √  null
users phone_other varchar 50  √  null
contacts phone_work varchar 100  √  null
leads phone_work varchar 100  √  null
prospects phone_work varchar 100  √  null
styleguide phone_work varchar 100  √  null
users phone_work varchar 50  √  null
contacts picture varchar 255  √  null
leads picture varchar 255  √  null
prospects picture varchar 255  √  null
styleguide picture varchar 255  √  null
users picture varchar 255  √  null
forecast_manager_worksheets pipeline_amount decimal 26,6  √  0.000000
forecasts pipeline_amount decimal 26,6  √  0.000000
forecast_manager_worksheets pipeline_opp_count int 5  √  0
forecasts pipeline_opp_count int 5  √  0
config platform varchar 32  √  null
oauth_tokens platform varchar 255  √  base
folders_rel polymorphic_id char 36
folders_rel polymorphic_module varchar 25  √  null
inbound_email port int 5  √  null
contacts portal_active bit 1  √  0
contacts portal_app varchar 255  √  null
leads portal_app varchar 255  √  null
notes portal_flag bit 1  √  0
contacts portal_name varchar 255  √  null
leads portal_name varchar 255  √  null
users portal_only bit 1  √  0
contacts portal_password varchar 255  √  null
bugs portal_viewable bit 1  √  0
cases portal_viewable bit 1  √  0
project_task predecessors text 65535  √  null
contacts preferred_language varchar 255  √  null
leads preferred_language varchar 255  √  null
users preferred_language varchar 255  √  null
data_sets prespace_y varchar 3  √  0
product_templates pricing_factor decimal 8,2  √  null
products pricing_factor int 4  √  null
revenue_line_items pricing_factor int 4  √  null
product_templates pricing_formula varchar 100  √  null
products pricing_formula varchar 100  √  null
revenue_line_items pricing_formula varchar 100  √  null
accounts_contacts primary_account bit 1  √  0
email_addr_bean_rel primary_address bit 1  √  0
contacts primary_address_city varchar 100  √  null
leads primary_address_city varchar 100  √  null
prospects primary_address_city varchar 100  √  null
styleguide primary_address_city varchar 100  √  null
contacts primary_address_country varchar 255  √  null
leads primary_address_country varchar 255  √  null
prospects primary_address_country varchar 255  √  null
styleguide primary_address_country varchar 255  √  null
contacts primary_address_postalcode varchar 20  √  null
leads primary_address_postalcode varchar 20  √  null
prospects primary_address_postalcode varchar 20  √  null
styleguide primary_address_postalcode varchar 20  √  null
contacts primary_address_state varchar 100  √  null
leads primary_address_state varchar 100  √  null
prospects primary_address_state varchar 100  √  null
styleguide primary_address_state varchar 100  √  null
contacts primary_address_street varchar 150  √  null
leads primary_address_street varchar 150  √  null
prospects primary_address_street varchar 150  √  null
styleguide primary_address_street varchar 150  √  null
bugs priority varchar 100  √  null
cases priority varchar 100  √  null
project priority varchar 255  √  null
project_task priority varchar 255  √  null
tasks priority varchar 100  √  null
teams private bit 1  √  0
forecast_worksheets probability double 22  √  null
opportunities probability double 22  √  null
revenue_line_items probability double 22  √  null
fts_queue processed bit 1  √  0
bugs product_category varchar 255  √  null
contracts_products product_id varchar 36  √  null
documents_products product_id char 36  √  null
product_bundle_product product_id varchar 36  √  null
projects_products product_id varchar 36  √  null
product_bundle_product product_index int 11  √  0
forecast_worksheets product_template_id char 36  √  null
products product_template_id char 36  √  null
revenue_line_items product_template_id char 36  √  null
forecast_worksheets product_template_name varchar 255  √  null
forecast_worksheets product_type varchar 255  √  null
revenue_line_items product_type varchar 255  √  null
project_resources project_id char 36  √  null
project_task project_id char 36
projects_accounts project_id varchar 36  √  null
projects_bugs project_id varchar 36  √  null
projects_cases project_id varchar 36  √  null
projects_contacts project_id varchar 36  √  null
projects_opportunities project_id varchar 36  √  null
projects_products project_id varchar 36  √  null
projects_quotes project_id varchar 36  √  null
projects_revenue_line_items project_id varchar 36  √  null
project_task project_task_id int 11  √  null
email_marketing_prospect_lists prospect_list_id varchar 36  √  null
prospect_list_campaigns prospect_list_id varchar 36  √  null
prospect_lists_prospects prospect_list_id varchar 36  √  null
email_templates published varchar 3  √  null
pdfmanager published varchar 100  √  yes
quotes purchase_order_num varchar 50  √  null
users pwd_last_changed datetime 19  √  null
product_templates qty_in_stock int 5  √  null
forecast_worksheets quantity int 5  √  1
products quantity decimal 12,2  √  1.00
revenue_line_items quantity decimal 12,2  √  1.00
tracker_queries query_hash varchar 36  √  null
data_sets query_id char 36
tracker_queries query_id char 36
tracker_tracker_queries query_id char 36  √  null
custom_queries query_locked varchar 3  √  0
custom_queries query_type varchar 50  √  null
forecast_manager_worksheets quota decimal 26,6  √  null
quotas quota_type varchar 100  √  null
contracts_quotes quote_id varchar 36  √  null
documents_quotes quote_id varchar 36  √  null
product_bundle_quote quote_id varchar 36  √  null
products quote_id char 36  √  null
projects_quotes quote_id varchar 36  √  null
quotes_accounts quote_id varchar 36  √  null
quotes_contacts quote_id varchar 36  √  null
quotes_opportunities quote_id varchar 36  √  null
revenue_line_items quote_id char 36  √  null
quotes quote_stage varchar 100  √  null
quotes quote_type varchar 100  √  null
styleguide radio_button_group varchar 255  √  null
users_feeds rank int 11  √  null
accounts rating varchar 100  √  null
kbdocuments_views_ratings ratings_number int 11  √  0
emails_text raw_source longtext 2147483647  √  null
users receive_notifications bit 1  √  1
email_cache recent tinyint 4  √  null
sugarfavorites record_id varchar 36  √  null
workflow record_type varchar 100  √  null
record_list records longtext 2147483647  √  null
calls recurring_source varchar 36  √  null
meetings recurring_source varchar 36  √  null
campaigns refer_url varchar 255  √  http://
leads refered_by varchar 100  √  null
contracts reference_code varchar 255  √  null
workflow_alerts rel_email_value varchar 50  √  null
workflow_actionshells rel_module varchar 50  √  null
workflow_triggershells rel_module varchar 255  √  null
workflow_alerts rel_module1 varchar 255  √  null
workflow_alerts rel_module1_type varchar 10  √  null
workflow_alerts rel_module2 varchar 255  √  null
workflow_alerts rel_module2_type varchar 10  √  null
workflow_actionshells rel_module_type varchar 10  √  null
workflow_triggershells rel_module_type varchar 10  √  null
workflow_alerts relate_type varchar 100  √  null
documents related_doc_id char 36  √  null
kbdocuments related_doc_id char 36  √  null
documents related_doc_rev_id char 36  √  null
kbdocuments related_doc_rev_id char 36  √  null
campaign_log related_id char 36  √  null
emailman related_id char 36  √  null
prospect_lists_prospects related_id varchar 36  √  null
holidays related_module varchar 255  √  null
holidays related_module_id char 36  √  null
campaign_log related_type varchar 100  √  null
emailman related_type varchar 100  √  null
prospect_lists_prospects related_type varchar 25  √  null
relationships relationship_name varchar 150  √  null
relationships relationship_role_column varchar 64  √  null
relationships relationship_role_column_value varchar 50  √  null
relationships relationship_type varchar 64  √  null
calls reminder_time int 11  √  -1
meetings reminder_time int 11  √  -1
calls repeat_count int 7  √  null
meetings repeat_count int 7  √  null
calls repeat_dow varchar 7  √  null
meetings repeat_dow varchar 7  √  null
calls repeat_interval int 3  √  1
meetings repeat_interval int 3  √  1
calls repeat_parent_id char 36  √  null
meetings repeat_parent_id char 36  √  null
calls repeat_type varchar 36  √  null
meetings repeat_type varchar 36  √  null
calls repeat_until date 10  √  null
meetings repeat_until date 10  √  null
email_marketing reply_to_addr varchar 100  √  null
emails_text reply_to_addr varchar 255  √  null
email_addr_bean_rel reply_to_address bit 1  √  0
email_marketing reply_to_name varchar 100  √  null
emails reply_to_status bit 1  √  null
report_maker report_align varchar 8  √  null
data_sets report_id char 36  √  null
report_schedules report_id char 36  √  null
report_cache report_options text 65535  √  null
saved_reports report_type varchar 36  √  null
fields_meta_data reportable bit 1  √  1
contacts reports_to_id char 36  √  null
leads reports_to_id char 36  √  null
users reports_to_id char 36  √  null
weblogichooks request_method varchar 255  √  POST
job_queue requeue bit 1  √  0
calls_contacts required varchar 1  √  1
calls_leads required varchar 1  √  1
calls_users required varchar 1  √  1
fields_meta_data required bit 1  √  0
meetings_contacts required varchar 1  √  1
meetings_leads required varchar 1  √  1
meetings_users required varchar 1  √  1
bugs resolution varchar 255  √  null
cases resolution text 65535  √  null
job_queue resolution varchar 20  √  null
project_resources resource_id char 36  √  null
project_task resource_id text 65535  √  null
holidays resource_name varchar 255  √  null
project_resources resource_type varchar 20  √  null
job_queue retry_count tinyint 4  √  null
products revenuelineitem_id char 36  √  null
relationships reverse bit 1  √  0
document_revisions revision varchar 100  √  null
kbdocument_revisions revision varchar 100  √  null
kbdocuments_kbtags revision varchar 100  √  null
kbtags revision varchar 100  √  null
expressions rhs_field varchar 50  √  null
expressions rhs_group_type varchar 10  √  null
relationships rhs_key varchar 64  √  null
expressions rhs_module varchar 50  √  null
relationships rhs_module varchar 100  √  null
relationships rhs_table varchar 64  √  null
expressions rhs_type varchar 15  √  null
expressions rhs_value varchar 255  √  null
relationships rhs_vname varchar 64  √  null
documents_revenuelineitems rli_id varchar 36  √  null
projects_revenue_line_items rli_id varchar 36  √  null
acl_fields role_id char 36
acl_roles_actions role_id varchar 36  √  null
acl_roles_users role_id varchar 36  √  null
roles_modules role_id varchar 36  √  null
roles_users role_id varchar 36  √  null
kbtags root_tag bit 1  √  0
tracker_sessions round_trips int 5  √  null
dataset_layouts row_header_id varchar 36  √  null
tracker_queries run_count int 6  √  null
forecast_worksheets sales_stage varchar 255  √  null
opportunities sales_stage varchar 255  √  Prospecting
revenue_line_items sales_stage varchar 255  √  Prospecting
forecast_worksheets sales_status varchar 255  √  null
opportunities sales_status varchar 255  √  null
contacts salutation varchar 255  √  null
leads salutation varchar 255  √  null
prospects salutation varchar 255  √  null
styleguide salutation varchar 255  √  null
report_schedules schedule_type varchar 3  √  null
saved_reports schedule_type varchar 3  √  pro
report_maker scheduled bit 1  √  0
job_queue scheduler_id char 36  √  null
schedulers_times scheduler_id char 36
saved_search search_module varchar 150  √  null
tracker_queries sec_avg double 22  √  null
tracker_queries sec_total double 22  √  null
tracker_sessions seconds int 9  √  0
oauth_tokens secret varchar 32  √  null
styleguide secret_password varchar 255  √  null
email_cache seen tinyint 4  √  null
category_tree self_id char 36  √  null
emailman send_attempts int 11  √  0
emailman send_date_time datetime 19  √  null
email_cache senddate datetime 19  √  null
meetings sequence int 11  √  0
products serial_number varchar 50  √  null
revenue_line_items serial_number varchar 50  √  null
tracker_perf server_response_time double 22  √  null
inbound_email server_url varchar 100  √  null
inbound_email service varchar 50  √  null
session_active session_id varchar 100  √  null
session_history session_id varchar 100  √  null
tracker session_id varchar 36  √  null
tracker_sessions session_id varchar 36  √  null
session_active session_type varchar 100  √  null
session_history session_type varchar 100  √  null
custom_fields set_num int 11  √  0
workflow_actions set_type varchar 10  √  null
notifications severity varchar 15  √  null
quotes shipper_id char 36  √  null
product_bundles shipping decimal 26,6  √  null
quotes shipping decimal 26,6  √  null
accounts shipping_address_city varchar 100  √  null
quotes shipping_address_city varchar 100  √  null
accounts shipping_address_country varchar 255  √  null
quotes shipping_address_country varchar 100  √  null
accounts shipping_address_postalcode varchar 20  √  null
quotes shipping_address_postalcode varchar 20  √  null
accounts shipping_address_state varchar 100  √  null
quotes shipping_address_state varchar 100  √  null
accounts shipping_address_street varchar 150  √  null
quotes shipping_address_street varchar 150  √  null
product_bundles shipping_usdollar decimal 26,6  √  null
quotes shipping_usdollar decimal 26,6  √  null
quotes show_line_nums bit 1  √  1
users show_on_employees bit 1  √  1
workflow_triggershells show_past bit 1  √  0
accounts sic_code varchar 10  √  null
users_signatures signature text 65535  √  null
users_signatures signature_html text 65535  √  null
dataset_attributes size_type varchar 3  √  null
bugs source varchar 255  √  null
import_maps source varchar 36  √  null
vcals source varchar 100  √  null
workflow_alertshells source_type varchar 100  √  null
campaigns start_date date 10  √  null
contracts start_date date 10  √  null
timeperiods start_date date 10  √  null
timeperiods start_date_timestamp int 14  √  null
bugs status varchar 100  √  null
calls status varchar 100  √  Planned
campaigns status varchar 100  √  null
cases status varchar 100  √  null
contracts status varchar 100  √  null
currencies status varchar 100  √  null
email_marketing status varchar 100  √  null
emails status varchar 100  √  null
forecast_schedule status varchar 100  √  null
inbound_email status varchar 100  √  Active
job_queue status varchar 20  √  null
leads status varchar 100  √  null
manufacturers status varchar 100  √  null
meetings status varchar 100  √  Planned
product_templates status varchar 100  √  null
products status varchar 100  √  null
project status varchar 255  √  null
project_task status varchar 255  √  null
releases status varchar 100  √  null
revenue_line_items status varchar 100  √  null
schedulers status varchar 100  √  null
schedulers_times status varchar 25  √  ready
shippers status varchar 100  √  null
systems status varchar 255  √  Active
tasks status varchar 100  √  Not Started
taxrates status varchar 100  √  null
team_notices status varchar 100  √  null
upgrade_history status varchar 50  √  null
users status varchar 100  √  null
workflow status bit 1  √  0
leads status_description text 65535  √  null
documents status_id varchar 100  √  null
kbdocuments status_id varchar 100  √  null
inbound_email stored_options text 65535  √  null
dataset_attributes style varchar 25  √  null
documents subcategory_id varchar 100  √  null
email_cache subject varchar 255  √  null
email_templates subject varchar 255  √  null
pdfmanager subject varchar 255  √  null
product_bundles subtotal decimal 26,6  √  null
quotes subtotal decimal 26,6  √  null
product_bundles subtotal_usdollar decimal 26,6  √  null
quotes subtotal_usdollar decimal 26,6  √  null
users sugar_login bit 1  √  1
product_templates support_contact varchar 50  √  null
products support_contact varchar 50  √  null
revenue_line_items support_contact varchar 50  √  null
product_templates support_description varchar 255  √  null
products support_description varchar 255  √  null
revenue_line_items support_description varchar 255  √  null
product_templates support_name varchar 50  √  null
products support_name varchar 50  √  null
revenue_line_items support_name varchar 50  √  null
product_templates support_term varchar 100  √  null
products support_term varchar 100  √  null
revenue_line_items support_term varchar 100  √  null
currencies symbol varchar 36  √  null
users system_generated_password bit 1  √  null
bugs system_id int 11  √  null
cases system_id int 11  √  null
quotes system_id int 11  √  null
systems system_key varchar 36  √  null
systems system_name varchar 100  √  null
data_sets table_width varchar 3  √  0
data_sets table_width_type varchar 3  √  null
kbtags tag_name varchar 255  √  null
job_queue target varchar 255  √  null
campaign_log target_id char 36  √  null
workflow_schedules target_module varchar 50  √  null
campaign_log target_tracker_key varchar 36  √  null
campaign_log target_type varchar 100  √  null
project_task task_number int 11  √  null
product_bundles tax decimal 26,6  √  null
quotes tax decimal 26,6  √  null
product_templates tax_class varchar 100  √  null
products tax_class varchar 100  √  null
revenue_line_items tax_class varchar 100  √  null
product_bundles tax_usdollar decimal 26,6  √  null
quotes tax_usdollar decimal 26,6  √  null
quotes taxrate_id char 36  √  null
team_sets team_count int 11  √  0
accounts team_id char 36  √  null
bugs team_id char 36  √  null
calls team_id char 36  √  null
campaigns team_id char 36  √  null
cases team_id char 36  √  null
contacts team_id char 36  √  null
contracts team_id char 36  √  null
custom_queries team_id char 36  √  null
data_sets team_id char 36  √  null
documents team_id char 36  √  null
email_templates team_id char 36  √  null
emails team_id char 36  √  null
filters team_id char 36  √  null
folders team_id char 36  √  null
forecast_manager_worksheets team_id char 36  √  null
forecast_worksheets team_id char 36  √  null
inbound_email team_id char 36  √  null
kbcontents team_id char 36  √  null
kbdocuments team_id char 36  √  null
kbdocuments_kbtags team_id char 36  √  null
kbtags team_id char 36  √  null
leads team_id char 36  √  null
meetings team_id char 36  √  null
notes team_id char 36  √  null
opportunities team_id char 36  √  null
pdfmanager team_id char 36  √  null
product_bundles team_id char 36  √  null
products team_id char 36  √  null
project team_id char 36  √  null
project_task team_id char 36  √  null
prospect_lists team_id char 36  √  null
prospects team_id char 36  √  null
quotes team_id char 36  √  null
report_maker team_id char 36  √  null
revenue_line_items team_id char 36  √  null
saved_reports team_id char 36  √  null
saved_search team_id char 36  √  null
tasks team_id char 36  √  null
team_memberships team_id char 36  √  null
team_notices team_id char 36  √  null
team_sets_teams team_id char 36  √  null
tracker team_id char 36  √  null
team_sets team_md5 varchar 32  √  null
accounts team_set_id char 36  √  null
bugs team_set_id char 36  √  null
calls team_set_id char 36  √  null
campaigns team_set_id char 36  √  null
cases team_set_id char 36  √  null
contacts team_set_id char 36  √  null
contracts team_set_id char 36  √  null
custom_queries team_set_id char 36  √  null
data_sets team_set_id char 36  √  null
documents team_set_id char 36  √  null
email_templates team_set_id char 36  √  null
emails team_set_id char 36  √  null
filters team_set_id char 36  √  null
folders team_set_id char 36  √  null
forecast_manager_worksheets team_set_id char 36  √  null
forecast_worksheets team_set_id char 36  √  null
inbound_email team_set_id char 36  √  null
kbcontents team_set_id char 36  √  null
kbdocuments team_set_id char 36  √  null
kbdocuments_kbtags team_set_id char 36  √  null
kbtags team_set_id char 36  √  null
leads team_set_id char 36  √  null
meetings team_set_id char 36  √  null
notes team_set_id char 36  √  null
opportunities team_set_id char 36  √  null
pdfmanager team_set_id char 36  √  null
product_bundles team_set_id char 36  √  null
products team_set_id char 36  √  null
project team_set_id char 36  √  null
project_task team_set_id char 36  √  null
prospect_lists team_set_id char 36  √  null
prospects team_set_id char 36  √  null
quotes team_set_id char 36  √  null
report_maker team_set_id char 36  √  null
revenue_line_items team_set_id char 36  √  null
saved_reports team_set_id char 36  √  null
saved_search team_set_id char 36  √  null
tasks team_set_id char 36  √  null
team_notices team_set_id char 36  √  null
team_sets_modules team_set_id char 36  √  null
team_sets_teams team_set_id char 36  √  null
users team_set_id char 36  √  null
email_marketing template_id char 36
inbound_email template_id char 36  √  null
pdfmanager template_name varchar 255  √  null
documents template_type varchar 100  √  null
kbdocuments template_type varchar 100  √  null
tracker_queries text text 65535  √  null
email_templates text_only bit 1  √  null
accounts ticker_symbol varchar 10  √  null
project_task time_due time 8  √  null
project_task time_finish int 11  √  null
schedulers time_from time 8  √  null
report_schedules time_interval int 11  √  null
project_task time_start int 11  √  null
schedulers time_to time 8  √  null
forecast_manager_worksheets timeperiod_id char 36  √  null
forecast_schedule timeperiod_id char 36  √  null
forecasts timeperiod_id char 36  √  null
quotas timeperiod_id char 36  √  null
contacts title varchar 100  √  null
leads title varchar 100  √  null
pdfmanager title varchar 255  √  null
prospects title varchar 100  √  null
report_maker title varchar 50  √  null
styleguide title varchar 255  √  null
users title varchar 50  √  null
emails_text to_addrs text 65535  √  null
email_cache toaddr varchar 255  √  null
oauth_tokens token_ts bigint 20  √  null
product_bundles total decimal 26,6  √  null
quotes total decimal 26,6  √  null
forecast_worksheets total_amount decimal 26,6  √  null
products total_amount decimal 26,6  √  0.000000
revenue_line_items total_amount decimal 26,6  √  null
contracts total_contract_value decimal 26,6  √  null
contracts total_contract_value_usdollar decimal 26,6  √  null
opportunities total_revenue_line_items int 11  √  null
product_bundles total_usdollar decimal 26,6  √  null
quotes total_usdollar decimal 26,6  √  null
campaigns tracker_count int 11  √  0
campaign_trkrs tracker_name varchar 30  √  null
campaigns tracker_text varchar 255  √  null
campaign_trkrs tracker_url varchar 255  √  http://
weblogichooks trigger_event varchar 255  √  null
oauth_tokens tstate varchar 1  √  null
accounts twitter varchar 100  √  null
contacts twitter varchar 100  √  null
leads twitter varchar 100  √  null
prospects twitter varchar 100  √  null
styleguide twitter varchar 100  √  null
bugs type varchar 255  √  null
cases type varchar 255  √  null
category_tree type varchar 36  √  null
contracts type varchar 255  √  null
email_templates type varchar 255  √  null
emails type varchar 100  √  null
fields_meta_data type varchar 255  √  null
meetings type varchar 255  √  Sugar
outbound_email type varchar 15  √  user
timeperiods type varchar 255  √  null
upgrade_history type varchar 30  √  null
vcals type varchar 100  √  null
workflow type varchar 100  √  null
workflow_triggershells type varchar 100  √  null
product_templates type_id char 36  √  null
products type_id char 36  √  null
revenue_line_items type_id char 36  √  null
eapm url varchar 255  √  null
team_notices url varchar 255  √  null
weblogichooks url varchar 255  √  null
team_notices url_title varchar 255  √  null
data_sets use_prev_header varchar 3  √  0
workflow_alerts user_display_type varchar 100  √  null
styleguide user_email varchar 100  √  null
users user_hash varchar 255  √  null
acl_roles_users user_id varchar 36  √  null
calls_users user_id char 36  √  null
contacts_users user_id varchar 36  √  null
emailman user_id char 36  √  null
forecast_manager_worksheets user_id char 36  √  null
forecast_schedule user_id char 36  √  null
forecast_tree user_id char 36  √  null
forecasts user_id char 36  √  null
meetings_users user_id char 36  √  null
outbound_email user_id char 36
quotas user_id char 36  √  null
report_schedules user_id char 36  √  null
roles_users user_id varchar 36  √  null
systems user_id char 36  √  null
team_memberships user_id char 36  √  null
tracker user_id char 36  √  null
tracker_sessions user_id char 36  √  null
users_feeds user_id varchar 36  √  null
users_holidays user_id varchar 36  √  null
users_signatures user_id char 36  √  null
vcals user_id char 36
users user_name varchar 60  √  null
workflow_alerts user_type varchar 100  √  null
users_password_link username varchar 36  √  null
project_task utilization int 11  √  100
eapm validated bit 1  √  null
config value text 65535  √  null
taxrates value decimal 7,5  √  null
workflow_actions value text 65535  √  null
product_templates vendor_part_num varchar 50  √  null
products vendor_part_num varchar 50  √  null
revenue_line_items vendor_part_num varchar 50  √  null
oauth_tokens verify varchar 32  √  null
upgrade_history version varchar 64  √  null
dashboards view_name varchar 100  √  null
kbdocuments_views_ratings views_number int 11  √  0
tracker visible bit 1  √  0
fields_meta_data vname varchar 255  √  null
weblogichooks webhook_target_module varchar 255  √  null
accounts website varchar 255  √  null
leads website varchar 255  √  null
product_templates website varchar 255  √  null
products website varchar 255  √  null
revenue_line_items website varchar 255  √  null
styleguide website varchar 255  √  null
product_templates weight decimal 12,2  √  null
products weight decimal 12,2  √  null
revenue_line_items weight decimal 12,2  √  null
workflow_alerts where_filter bit 1  √  0
bugs work_log text 65535  √  null
cases work_log text 65535  √  null
workflow_schedules workflow_id char 36  √  null
forecast_manager_worksheets worst_case decimal 26,6  √  null
forecast_worksheets worst_case decimal 26,6  √  null
forecasts worst_case decimal 26,6  √  null
opportunities worst_case decimal 26,6  √  null
revenue_line_items worst_case decimal 26,6  √  null
forecast_manager_worksheets worst_case_adjusted decimal 26,6  √  null
dataset_attributes wrap varchar 3  √  null