SchemaSpy Analysis of ss6517ce - Columnsgenerated Generated by
SchemaSpy
Generated on Mon Jun 23 21:52 UTC 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ss6517ce contains 1234 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
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
documents_accounts account_id varchar 36  √  null
leads account_id char 36  √  null
projects_accounts account_id varchar 36  √  null
leads account_name varchar 255  √  null
prospects account_name varchar 150  √  null
accounts account_type varchar 50  √  null
acl_actions aclaccess int 3  √  null
acl_actions acltype varchar 100  √  null
tracker action varchar 255  √  null
acl_roles_actions action_id varchar 36  √  null
documents active_date date 10  √  null
campaign_log activity_date datetime 19  √  null
campaign_log activity_type varchar 100  √  null
campaigns actual_cost double 22  √  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
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
leads_audit after_value_string varchar 255  √  null
opportunities_audit after_value_string varchar 255  √  null
project_task_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
leads_audit after_value_text text 65535  √  null
opportunities_audit after_value_text text 65535  √  null
project_task_audit after_value_text text 65535  √  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
contacts alt_address_country varchar 255  √  null
leads alt_address_country varchar 255  √  null
prospects 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
contacts alt_address_state varchar 100  √  null
leads alt_address_state varchar 100  √  null
prospects 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
opportunities amount double 22  √  null
opportunities amount_usdollar double 22  √  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
folders assign_to_id char 36  √  null
accounts assigned_user_id char 36  √  null
address_book 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
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
folders_subscriptions assigned_user_id char 36
import_maps assigned_user_id char 36  √  null
job_queue 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
oauth_consumer assigned_user_id char 36  √  null
oauth_tokens assigned_user_id char 36  √  null
oauthkeys assigned_user_id unknown 0
opportunities 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
saved_search assigned_user_id char 36  √  null
schedulersjobs assigned_user_id unknown 0
sugarfeed 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
contacts assistant_phone varchar 100  √  null
leads assistant_phone varchar 100  √  null
prospects assistant_phone varchar 100  √  null
fields_meta_data audited bit 1  √  0
users authenticate_id varchar 100  √  null
inbound_email_autoreply autoreplied_to varchar 100  √  null
emails_text bcc_addrs text 65535  √  null
address_book bean varchar 50  √  null
address_book bean_id char 36
cron_remove_documents bean_id varchar 36  √  null
custom_fields bean_id varchar 36  √  null
email_addr_bean_rel bean_id char 36
emails_beans bean_id char 36  √  null
users_last_import bean_id char 36  √  null
email_addr_bean_rel bean_module varchar 100  √  null
emails_beans 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
leads_audit before_value_string varchar 255  √  null
opportunities_audit before_value_string varchar 255  √  null
project_task_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
leads_audit before_value_text text 65535  √  null
opportunities_audit before_value_text text 65535  √  null
project_task_audit before_value_text text 65535  √  null
accounts billing_address_city varchar 100  √  null
accounts billing_address_country varchar 255  √  null
accounts billing_address_postalcode varchar 20  √  null
accounts billing_address_state varchar 100  √  null
accounts billing_address_street varchar 150  √  null
contacts birthdate date 10  √  null
leads birthdate date 10  √  null
prospects birthdate date 10  √  null
email_templates body text 65535  √  null
email_templates body_html text 65535  √  null
campaigns budget double 22  √  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 varchar 36  √  null
projects_bugs bug_id varchar 36  √  null
bugs bug_number int 11  √ 
oauth_consumer c_key varchar 255  √  null
oauth_consumer c_secret varchar 255  √  null
calls_contacts call_id varchar 36  √  null
calls_leads call_id varchar 36  √  null
calls_users call_id varchar 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
leads campaign_id char 36  √  null
opportunities campaign_id char 36  √  null
prospect_list_campaigns campaign_id varchar 36  √  null
prospects campaign_id char 36  √  null
campaigns campaign_type varchar 100  √  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 varchar 36  √  null
projects_cases case_id varchar 36  √  null
cases case_number int 11  √ 
schedulers catch_up bit 1  √  1
acl_actions category varchar 100  √  null
config category varchar 32  √  null
user_preferences category varchar 50  √  null
documents category_id varchar 100  √  null
emails_text cc_addrs text 65535  √  null
document_revisions change_log varchar 255  √  null
job_queue client varchar 255  √  null
fields_meta_data comments varchar 255  √  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 varchar 36  √  null
contacts_bugs contact_id varchar 36  √  null
contacts_cases contact_id varchar 36  √  null
contacts_users contact_id varchar 36  √  null
documents_contacts contact_id varchar 36  √  null
leads contact_id char 36  √  null
meetings_contacts contact_id varchar 36  √  null
notes contact_id char 36  √  null
opportunities_contacts contact_id varchar 36  √  null
projects_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
campaigns content text 65535  √  null
import_maps content text 65535  √  null
vcals content text 65535  √  null
saved_search contents text 65535  √  null
user_preferences contents longtext 2147483647  √  null
currencies conversion_rate double 22  √  0
leads converted bit 1  √  0
accounts created_by char 36  √  null
accounts_audit created_by varchar 36  √  null
acl_actions created_by char 36  √  null
acl_roles created_by char 36  √  null
bugs created_by char 36  √  null
bugs_audit created_by varchar 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 varchar 36  √  null
cases created_by char 36  √  null
cases_audit created_by varchar 36  √  null
contacts created_by char 36  √  null
contacts_audit created_by varchar 36  √  null
currencies created_by char 36
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 varchar 36  √  null
emails created_by char 36  √  null
folders created_by char 36
inbound_email created_by char 36  √  null
leads created_by char 36  √  null
leads_audit created_by varchar 36  √  null
meetings created_by char 36  √  null
notes created_by char 36  √  null
oauth_consumer created_by char 36  √  null
oauthkeys created_by unknown 0
opportunities created_by char 36  √  null
opportunities_audit created_by varchar 36  √  null
project created_by char 36  √  null
project_task created_by char 36  √  null
project_task_audit created_by varchar 36  √  null
prospect_lists created_by char 36  √  null
prospects created_by char 36  √  null
releases created_by char 36  √  null
roles created_by char 36  √  null
schedulers created_by char 36  √  null
sugarfeed created_by char 36  √  null
tasks created_by char 36  √  null
users created_by char 36  √  null
versions created_by char 36  √  null
meetings creator varchar 50  √  null
campaigns currency_id char 36  √  null
opportunities currency_id char 36  √  null
fields_meta_data custom_module varchar 255  √  null
job_queue data text 65535  √  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
leads_audit data_type varchar 100  √  null
opportunities_audit data_type varchar 100  √  null
project_task_audit data_type varchar 100  √  null
opportunities date_closed 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
email_addr_bean_rel date_created datetime 19  √  null
email_addresses date_created datetime 19  √  null
leads_audit date_created datetime 19  √  null
opportunities_audit date_created datetime 19  √  null
project_task_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
accounts date_entered datetime 19  √  null
acl_actions date_entered datetime 19  √  null
acl_roles 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
contacts date_entered datetime 19  √  null
currencies 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
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
leads date_entered datetime 19  √  null
meetings date_entered datetime 19  √  null
notes date_entered datetime 19  √  null
oauth_consumer date_entered datetime 19  √  null
opportunities 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
releases date_entered datetime 19  √  null
roles date_entered datetime 19  √  null
saved_search date_entered datetime 19  √  null
schedulers date_entered datetime 19  √  null
sugarfeed date_entered datetime 19  √  null
tasks 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
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_roles date_modified datetime 19  √  null
acl_roles_actions date_modified datetime 19  √  null
acl_roles_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
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
cron_remove_documents date_modified datetime 19  √  null
currencies 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
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
fields_meta_data 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
leads date_modified datetime 19  √  null
linked_documents 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
oauth_consumer date_modified datetime 19  √  null
opportunities date_modified datetime 19  √  null
opportunities_contacts date_modified datetime 19  √  null
project 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
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
releases 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_search date_modified datetime 19  √  null
schedulers date_modified datetime 19  √  null
sugarfeed date_modified datetime 19  √  null
tasks date_modified datetime 19  √  null
tracker 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_signatures date_modified datetime 19  √  null
vcals date_modified datetime 19  √  null
versions date_modified datetime 19  √  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
tasks date_start datetime 19  √  null
tasks date_start_flag bit 1  √  0
schedulers date_time_end datetime 19  √  null
schedulers date_time_start datetime 19  √  null
versions db_version varchar 255  √  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_roles deleted bit 1  √  null
acl_roles_actions deleted bit 1  √  0
acl_roles_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
contacts deleted bit 1  √  0
contacts_bugs deleted bit 1  √  0
contacts_cases deleted bit 1  √  0
contacts_users deleted bit 1  √  0
currencies deleted bit 1  √  null
custom_fields 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
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
fields_meta_data deleted bit 1  √  0
folders deleted bit 1  √  0
folders_rel deleted bit 1  √  0
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
leads deleted bit 1  √  0
linked_documents deleted bit 1  √  0
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
oauth_consumer deleted bit 1  √  0
oauth_tokens deleted bit 1 0
opportunities deleted bit 1  √  0
opportunities_contacts deleted bit 1  √  0
project 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
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
relationships deleted bit 1  √  0
releases deleted bit 1  √  null
roles deleted bit 1  √  null
roles_modules deleted bit 1  √  0
roles_users deleted bit 1  √  0
saved_search deleted bit 1  √  null
schedulers deleted bit 1  √  0
sugarfeed deleted bit 1  √  0
tasks deleted bit 1  √  0
tracker deleted bit 1  √  0
user_preferences deleted bit 1  √  0
users deleted bit 1  √  null
users_feeds deleted bit 1  √  0
users_last_import deleted bit 1  √  null
users_password_link deleted bit 1  √  null
users_signatures deleted bit 1  √  null
vcals deleted bit 1  √  null
versions deleted bit 1  √  null
import_maps delimiter varchar 1  √  ,
contacts department varchar 255  √  null
leads department varchar 100  √  null
prospects 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
documents description text 65535  √  null
eapm description text 65535  √  null
email_templates description text 65535  √  null
emails_text description longtext 2147483647  √  null
leads description text 65535  √  null
meetings description text 65535  √  null
notes description text 65535  √  null
oauth_consumer description text 65535  √  null
opportunities 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
roles description text 65535  √  null
saved_search description text 65535  √  null
sugarfeed description varchar 255  √  null
tasks description text 65535  √  null
upgrade_history description text 65535  √  null
users description text 65535  √  null
emails_text description_html longtext 2147483647  √  null
calls direction varchar 100  √  null
meetings displayed_url varchar 400  √  null
contacts do_not_call bit 1  √  0
leads do_not_call bit 1  √  0
prospects 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 varchar 36  √  null
documents_accounts document_id varchar 36  √  null
documents_bugs document_id varchar 36  √  null
documents_cases document_id varchar 36  √  null
documents_contacts document_id varchar 36  √  null
documents_opportunities document_id varchar 36  √  null
linked_documents document_id varchar 36  √  null
documents document_name varchar 255  √  null
documents document_revision_id varchar 36  √  null
linked_documents document_revision_id varchar 36  √  null
prospect_lists domain_name varchar 255  √  null
email_cache draft tinyint 4  √  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 int 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
project_task estimated_effort int 11  √  null
project estimated_end_date date 10  √  null
project estimated_start_date date 10  √  null
job_queue execute_time datetime 19  √  null
documents exp_date date 10  √  null
campaigns expected_cost double 22  √  null
campaigns expected_revenue double 22  √  null
fields_meta_data ext1 varchar 255  √  null
fields_meta_data ext2 varchar 255  √  null
fields_meta_data ext3 varchar 255  √  null
fields_meta_data ext4 text 65535  √  null
users external_auth_only bit 1  √  0
meetings external_id varchar 50  √  null
job_queue failure_count tinyint 4  √  null
users_feeds feed_id varchar 36  √  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
leads_audit field_name varchar 100  √  null
opportunities_audit field_name varchar 100  √  null
project_task_audit field_name varchar 100  √  null
document_revisions file_ext varchar 100  √  null
document_revisions file_mime_type varchar 100  √  null
notes file_mime_type varchar 100  √  null
versions file_version varchar 255  √  null
document_revisions filename varchar 255  √  null
notes filename varchar 255  √  null
upgrade_history filename varchar 255  √  null
contacts first_name varchar 100  √  null
leads first_name varchar 100  √  null
prospects 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
bugs found_in_release varchar 255  √  null
campaigns frequency varchar 100  √  null
email_marketing from_addr varchar 100  √  null
emails_text from_addr varchar 255  √  null
email_marketing from_name varchar 100  √  null
email_cache fromaddr 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
fields_meta_data help varchar 255  √  null
campaign_log hits int 11  √  0
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_roles id char 36
acl_roles_actions id varchar 36
acl_roles_users id varchar 36
bugs id char 36
bugs_audit id char 36
calls id char 36
calls_contacts id varchar 36
calls_leads id varchar 36
calls_users id varchar 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
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 unknown 0
contracts id unknown 0
cron_remove_documents id varchar 36
currencies id char 36
document_revisions id varchar 36
documents id char 36
documents_accounts id varchar 36
documents_bugs id varchar 36
documents_cases id varchar 36
documents_contacts id varchar 36
documents_opportunities 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
emailman id int 11  √ 
emails id char 36
emails_beans id char 36
emails_email_addr_rel id char 36
fields_meta_data id varchar 255
folders id char 36
folders_rel id char 36
folders_subscriptions 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
leads id char 36
leads_audit id char 36
linked_documents id varchar 36
meetings id char 36
meetings_contacts id varchar 36
meetings_leads id varchar 36
meetings_users id varchar 36
notes 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
products id unknown 0
project 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
prospect_list_campaigns id varchar 36
prospect_lists id char 36
prospect_lists_prospects id varchar 36
prospects id char 36
quotes id unknown 0
relationships id char 36
releases id char 36
roles id char 36
roles_modules id varchar 36
roles_users id varchar 36
saved_search id char 36
schedulers id varchar 36
sugarfeed id char 36
tasks id char 36
tracker id int 11  √ 
upgrade_history id char 36
user_preferences id char 36
users id char 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
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
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 varchar 36  √  null
accounts industry varchar 50  √  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
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
documents is_template bit 1  √  0
currencies iso4217 varchar 3  √  null
tracker item_id varchar 36  √  null
tracker item_summary varchar 255  √  null
schedulers job varchar 255  √  null
job_queue job_delay int 11  √  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
contacts last_name varchar 100  √  null
leads last_name varchar 100  √  null
prospects last_name varchar 100  √  null
users last_name varchar 30  √  null
schedulers last_run datetime 19  √  null
calls_leads lead_id varchar 36  √  null
meetings_leads lead_id varchar 36  √  null
prospects lead_id char 36  √  null
contacts lead_source varchar 255  √  null
leads lead_source varchar 100  √  null
opportunities lead_source varchar 50  √  null
leads lead_source_description text 65535  √  null
fields_meta_data len int 11  √  null
relationships lhs_key varchar 64  √  null
relationships lhs_module varchar 100  √  null
relationships lhs_table varchar 64  √  null
sugarfeed link_type varchar 30  √  null
sugarfeed link_url varchar 255  √  null
campaign_log list_id char 36  √  null
emailman list_id char 36  √  null
releases list_order int 4  √  null
prospect_lists list_type varchar 100  √  null
meetings location varchar 50  √  null
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
upgrade_history manifest longtext 2147483647  √  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 varchar 36  √  null
meetings_leads meeting_id varchar 36  √  null
meetings_users meeting_id varchar 36  √  null
job_queue message text 65535  √  null
email_cache message_id varchar 255  √  null
emails message_id varchar 255  √  null
users messenger_id varchar 100  √  null
users messenger_type varchar 100  √  null
project_task milestone_flag bit 1  √  null
folders modified_by char 36
accounts modified_user_id char 36  √  null
acl_actions modified_user_id char 36  √  null
acl_roles 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
contacts 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
inbound_email modified_user_id char 36  √  null
leads modified_user_id char 36  √  null
meetings modified_user_id char 36  √  null
notes modified_user_id char 36  √  null
oauth_consumer modified_user_id char 36  √  null
oauthkeys modified_user_id unknown 0
opportunities modified_user_id char 36  √  null
project 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
releases modified_user_id char 36  √  null
roles modified_user_id char 36  √  null
schedulers modified_user_id char 36  √  null
sugarfeed modified_user_id char 36  √  null
tasks modified_user_id char 36  √  null
users modified_user_id char 36  √  null
versions modified_user_id char 36  √  null
cron_remove_documents module varchar 25  √  null
import_maps module varchar 36  √  null
roles_modules module_id varchar 36  √  null
tracker module_name varchar 255  √  null
roles modules text 65535  √  null
tracker monitor_id char 36
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_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
currencies name varchar 36  √  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
folders name varchar 25  √  null
import_maps name varchar 254  √  null
inbound_email name varchar 255  √  null
job_queue name varchar 255  √  null
meetings name varchar 50  √  null
notes name varchar 255  √  null
oauth_consumer name varchar 255  √  null
opportunities name varchar 50  √  null
outbound_email name varchar 50  √  null
project name varchar 50  √  null
project_task name varchar 50  √  null
prospect_lists name varchar 50  √  null
releases name varchar 50  √  null
roles name varchar 150  √  null
saved_search name varchar 150  √  null
schedulers name varchar 255  √  null
sugarfeed name varchar 255  √  null
tasks name varchar 50  √  null
upgrade_history name varchar 255  √  null
users_signatures name varchar 255  √  null
versions name varchar 255  √  null
opportunities next_step varchar 100  √  null
oauth_nonce nonce varchar 32
oauth_nonce nonce_ts bigint 20  √  null
eapm oauth_secret varchar 255  √  null
eapm oauth_token varchar 255  √  null
campaigns objective text 65535  √  null
leads opportunity_amount varchar 50  √  null
accounts_opportunities opportunity_id varchar 36  √  null
documents_opportunities opportunity_id varchar 36  √  null
leads opportunity_id char 36  √  null
opportunities_contacts opportunity_id varchar 36  √  null
projects_opportunities opportunity_id varchar 36  √  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
calls outlook_id varchar 255  √  null
meetings outlook_id varchar 255  √  null
accounts ownership varchar 100  √  null
folders parent_folder char 36  √  null
accounts parent_id char 36  √  null
accounts_audit parent_id char 36
bugs_audit parent_id char 36
calls parent_id char 36  √  null
campaigns_audit parent_id char 36
cases_audit parent_id char 36
contacts_audit parent_id char 36
emails 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
opportunities_audit parent_id char 36
project_task_audit parent_id char 36
tasks parent_id char 36  √  null
project_task parent_task_id int 11  √  null
calls parent_type varchar 255  √  null
emails parent_type varchar 100  √  null
linked_documents parent_type varchar 25  √  null
meetings parent_type varchar 100  √  null
notes parent_type varchar 255  √  null
tasks parent_type varchar 255  √  null
eapm password varchar 255  √  null
meetings password varchar 50  √  null
job_queue percent_complete int 11  √  null
project_task percent_complete int 11  √  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
users phone_fax varchar 50  √  null
contacts phone_home varchar 100  √  null
leads phone_home varchar 100  √  null
prospects 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
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
users phone_other varchar 50  √  null
contacts phone_work varchar 100  √  null
leads phone_work varchar 100  √  null
prospects phone_work varchar 100  √  null
users phone_work varchar 50  √  null
folders_rel polymorphic_id char 36
folders_rel polymorphic_module varchar 25  √  null
inbound_email port int 5  √  null
leads portal_app varchar 255  √  null
notes portal_flag bit 1  √  null
leads portal_name varchar 255  √  null
users portal_only bit 1  √  0
project_task predecessors text 65535  √  null
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
contacts primary_address_country varchar 255  √  null
leads primary_address_country varchar 255  √  null
prospects 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
contacts primary_address_state varchar 100  √  null
leads primary_address_state varchar 100  √  null
prospects 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
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
opportunities probability double 22  √  null
bugs product_category varchar 255  √  null
projects_products product_id varchar 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
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
users pwd_last_changed datetime 19  √  null
users_feeds rank int 11  √  null
accounts rating varchar 100  √  null
emails_text raw_source longtext 2147483647  √  null
users receive_notifications bit 1  √  1
email_cache recent tinyint 4  √  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
documents related_doc_id char 36  √  null
documents related_doc_rev_id char 36  √  null
campaign_log related_id varchar 36  √  null
emailman related_id char 36  √  null
prospect_lists_prospects related_id varchar 36  √  null
sugarfeed related_id char 36  √  null
sugarfeed related_module varchar 100  √  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
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
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
job_queue retry_count tinyint 4  √  null
relationships reverse bit 1  √  0
document_revisions revision varchar 100  √  null
relationships rhs_key varchar 64  √  null
relationships rhs_module varchar 100  √  null
relationships rhs_table varchar 64  √  null
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
opportunities sales_stage varchar 255  √  null
contacts salutation varchar 255  √  null
leads salutation varchar 255  √  null
prospects salutation varchar 255  √  null
job_queue scheduler_id char 36  √  null
saved_search search_module varchar 150  √  null
oauth_tokens secret varchar 32  √  null
email_cache seen tinyint 4  √  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
inbound_email server_url varchar 100  √  null
inbound_email service varchar 50  √  null
tracker session_id varchar 36  √  null
custom_fields set_num int 11  √  0
accounts shipping_address_city varchar 100  √  null
accounts shipping_address_country varchar 255  √  null
accounts shipping_address_postalcode varchar 20  √  null
accounts shipping_address_state varchar 100  √  null
accounts shipping_address_street varchar 150  √  null
users show_on_employees bit 1  √  1
accounts sic_code varchar 10  √  null
users_signatures signature text 65535  √  null
users_signatures signature_html text 65535  √  null
bugs source varchar 255  √  null
import_maps source varchar 36  √  null
vcals source varchar 100  √  null
campaigns start_date date 10  √  null
bugs status varchar 100  √  null
calls status varchar 100  √  Planned
campaigns status varchar 100  √  null
cases status varchar 100  √  null
currencies status varchar 100  √  null
email_marketing status varchar 100  √  null
emails status varchar 100  √  null
inbound_email status varchar 100  √  Active
job_queue status varchar 20  √  null
leads status varchar 100  √  null
meetings status varchar 100  √  Planned
project status varchar 255  √  null
project_task status varchar 255  √  null
releases status varchar 100  √  null
schedulers status varchar 100  √  null
tasks status varchar 100  √  Not Started
upgrade_history status varchar 50  √  null
users status varchar 100  √  null
leads status_description text 65535  √  null
documents status_id varchar 100  √  null
inbound_email stored_options text 65535  √  null
documents subcategory_id varchar 100  √  null
email_cache subject varchar 255  √  null
email_templates subject varchar 255  √  null
users sugar_login bit 1  √  1
currencies symbol varchar 36  √  null
users system_generated_password bit 1  √  null
job_queue target varchar 255  √  null
campaign_log target_id varchar 36  √  null
campaign_log target_tracker_key varchar 36  √  null
campaign_log target_type varchar 100  √  null
project_task task_number int 11  √  null
email_marketing template_id char 36
inbound_email template_id char 36  √  null
documents template_type varchar 100  √  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
project_task time_start int 11  √  null
schedulers time_to time 8  √  null
contacts title varchar 100  √  null
leads title varchar 100  √  null
prospects title varchar 100  √  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
campaigns tracker_count int 11  √  0
campaign_trkrs tracker_key int 11  √ 
campaigns tracker_key int 11  √ 
prospects tracker_key int 11  √ 
campaign_trkrs tracker_name varchar 30  √  null
campaigns tracker_text varchar 255  √  null
campaign_trkrs tracker_url varchar 255  √  http://
oauth_tokens tstate varchar 1  √  null
bugs type varchar 255  √  null
cases 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
upgrade_history type varchar 30  √  null
vcals type varchar 100  √  null
eapm url varchar 255  √  null
users user_hash varchar 255  √  null
acl_roles_users user_id varchar 36  √  null
calls_users user_id varchar 36  √  null
contacts_users user_id varchar 36  √  null
emailman user_id char 36  √  null
meetings_users user_id varchar 36  √  null
outbound_email user_id char 36
roles_users user_id varchar 36  √  null
tracker user_id varchar 36  √  null
users_feeds user_id varchar 36  √  null
users_signatures user_id varchar 36  √  null
vcals user_id char 36
users user_name varchar 60  √  null
users_password_link username varchar 36  √  null
project_task utilization int 11  √  100
eapm validated bit 1  √  null
config value text 65535  √  null
oauth_tokens verify varchar 32  √  null
upgrade_history version varchar 64  √  null
tracker visible bit 1  √  0
fields_meta_data vname varchar 255  √  null
accounts website varchar 255  √  null
leads website varchar 255  √  null
bugs work_log text 65535  √  null
cases work_log text 65535  √  null