afad8983 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