ab4d5264 contains 3320 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
contracts	account_id	char	36	√		null
documents_accounts	account_id	char	36	√		null
forecast_worksheets	account_id	char	36	√		null
leads	account_id	char	36	√		null
products	account_id	char	36	√		null
projects_accounts	account_id	varchar	36	√		null
quotes_accounts	account_id	varchar	36	√		null
revenue_line_items	account_id	char	36	√		null
forecast_worksheets	account_name	varchar	255	√		null
leads	account_name	varchar	255	√		null
prospects	account_name	varchar	150	√		null
quotes_accounts	account_role	varchar	20	√		null
accounts	account_type	varchar	50	√		null
acl_role_sets_acl_roles	acl_role_id	char	36	√		null
acl_role_sets_acl_roles	acl_role_set_id	char	36	√		null
users	acl_role_set_id	char	36	√		null
acl_actions	aclaccess	int	3	√		null
acl_fields	aclaccess	int	3	√		null
acl_actions	acltype	varchar	100	√		null
pmse_bpm_access_management	acm_activation_data	text	65535	√		null
pmse_bpm_access_management	acm_data	text	65535	√		null
pmse_bpm_access_management	acm_expiration_date	datetime	19	√		null
pmse_bpm_access_management	acm_key	varchar	30	√
pmse_bpm_access_management	acm_status	varchar	10	√
pmse_bpm_access_management	acm_type	varchar	64	√
pmse_bpm_access_management	acm_uid	varchar	36	√
pmse_bpm_activity_definition	act_adhoc	int	4	√		0
pmse_bpm_activity_definition	act_adhoc_behavior	varchar	40	√
pmse_bpm_activity_definition	act_adhoc_team	varchar	40	√
pmse_bpm_activity_definition	act_assign_team	varchar	40	√
pmse_bpm_activity_definition	act_assign_user	varchar	40	√
pmse_bpm_activity_definition	act_assignment_method	varchar	32	√		BALANCED
pmse_bpmn_activity	act_cancel_remaining_instances	int	4	√		1
pmse_bpmn_activity	act_completion_condition	varchar	255	√
pmse_bpmn_activity	act_completion_quantity	int	4	√		1
pmse_bpm_activity_step	act_criteria	text	65535	√		null
pmse_bpmn_activity	act_default_flow	int	4	√		null
pmse_bpm_activity_definition	act_duration	int	4	√		0
pmse_bpm_activity_definition	act_duration_unit	varchar	32	√		DAYS
pmse_bpm_activity_definition	act_expected_time	text	65535	√		null
pmse_bpm_activity_definition	act_field_module	varchar	100	√
pmse_bpm_activity_definition	act_fields	text	65535	√		null
pmse_bpm_activity_user	act_group_id	varchar	40	√
pmse_bpm_form_action	act_id	varchar	36	√
pmse_bpmn_activity	act_implementation	text	65535	√		null
pmse_bpmn_activity	act_instantiate	int	4	√		0
pmse_bpmn_activity	act_is_adhoc	int	4	√		0
pmse_bpmn_activity	act_is_collapsed	int	4	√		1
pmse_bpmn_activity	act_is_for_compensation	int	4	√		0
pmse_bpmn_activity	act_is_global	int	4	√		0
pmse_bpm_activity_definition	act_last_user_assigned	varchar	40	√
pmse_bpmn_activity	act_loop_behavior	varchar	20	√		NONE
pmse_bpmn_activity	act_loop_cardinality	int	4	√		0
pmse_bpmn_activity	act_loop_condition	varchar	100	√
pmse_bpmn_activity	act_loop_maximum	int	4	√		0
pmse_bpmn_activity	act_loop_type	varchar	20	√		NONE
pmse_bpmn_activity	act_master_diagram	int	4	√		null
pmse_bpmn_activity	act_method	varchar	255	√
pmse_bpmn_activity	act_ordering	varchar	20	√		PARALLEL
pmse_bpmn_activity	act_protocol	varchar	255	√
pmse_bpm_activity_definition	act_readonly_fields	text	65535	√		null
pmse_bpm_activity_definition	act_reassign	int	4	√		0
pmse_bpm_activity_definition	act_reassign_team	varchar	40	√
pmse_bpmn_activity	act_referer	int	4	√		null
pmse_bpm_activity_definition	act_related_modules	text	65535	√		null
pmse_bpm_activity_definition	act_required_fields	text	65535	√		null
pmse_bpm_activity_definition	act_response_buttons	varchar	40	√
pmse_bpmn_activity	act_script	text	65535	√		null
pmse_bpmn_activity	act_script_type	varchar	255	√
pmse_bpm_activity_definition	act_send_notification	int	4	√		0
pmse_bpm_activity_definition	act_service_method	text	65535	√		null
pmse_bpm_activity_definition	act_service_params	text	65535	√		null
pmse_bpm_activity_definition	act_service_url	text	65535	√		null
pmse_bpmn_activity	act_start_quantity	int	4	√		1
pmse_bpm_activity_step	act_step_form	varchar	255	√
pmse_bpm_activity_step	act_step_script	text	65535	√		null
pmse_bpm_activity_step	act_step_type	varchar	30	√		START
pmse_bpmn_activity	act_task_type	varchar	20	√		EMPTY
pmse_bpmn_activity	act_test_before	int	4	√		0
pmse_bpm_activity_definition	act_type	varchar	32	√		TASK
pmse_bpmn_activity	act_type	varchar	30	√		TASK
pmse_bpmn_activity	act_uid	varchar	36	√
pmse_bpm_activity_definition	act_update_record_owner	int	4	√		0
pmse_bpm_activity_user	act_user_id	varchar	40	√
pmse_bpm_activity_user	act_user_type	varchar	32	√
pmse_bpm_activity_definition	act_value_based_assignment	varchar	255	√
tracker	action	varchar	255	√		null
acl_roles_actions	action_id	varchar	36	√		null
workflow_actionshells	action_module	varchar	255	√		null
workflow_actionshells	action_type	varchar	100	√		null
report_schedules	active	bit	1	√		0
tracker_sessions	active	bit	1	√		1
documents	active_date	date	10	√		null
kbdocuments	active_date	date	10	√		null
campaign_log	activity_date	datetime	19	√		null
activities_users	activity_id	char	36
activities	activity_type	varchar	100	√		null
campaign_log	activity_type	varchar	100	√		null
campaigns	actual_cost	decimal	26,6	√		null
project_task	actual_duration	int	11	√		null
project_task	actual_effort	int	11	√		null
users	address_city	varchar	100	√		null
users	address_country	varchar	100	√		null
users	address_postalcode	varchar	20	√		null
users	address_state	varchar	100	√		null
users	address_street	varchar	150	√		null
emails_email_addr_rel	address_type	varchar	4	√		null
workflow_alerts	address_type	varchar	100	√		null
workflow_actions	adv_type	varchar	10	√		null
accounts_audit	after_value_string	varchar	255	√		null
bugs_audit	after_value_string	varchar	255	√		null
campaigns_audit	after_value_string	varchar	255	√		null
cases_audit	after_value_string	varchar	255	√		null
contacts_audit	after_value_string	varchar	255	√		null
contracts_audit	after_value_string	varchar	255	√		null
forecast_manager_worksheets_audit	after_value_string	varchar	255	√		null
kbcontents_audit	after_value_string	varchar	255	√		null
leads_audit	after_value_string	varchar	255	√		null
notifications_audit	after_value_string	varchar	255	√		null
opportunities_audit	after_value_string	varchar	255	√		null
product_templates_audit	after_value_string	varchar	255	√		null
products_audit	after_value_string	varchar	255	√		null
project_task_audit	after_value_string	varchar	255	√		null
quotas_audit	after_value_string	varchar	255	√		null
quotes_audit	after_value_string	varchar	255	√		null
revenue_line_items_audit	after_value_string	varchar	255	√		null
accounts_audit	after_value_text	text	65535	√		null
bugs_audit	after_value_text	text	65535	√		null
campaigns_audit	after_value_text	text	65535	√		null
cases_audit	after_value_text	text	65535	√		null
contacts_audit	after_value_text	text	65535	√		null
contracts_audit	after_value_text	text	65535	√		null
forecast_manager_worksheets_audit	after_value_text	text	65535	√		null
kbcontents_audit	after_value_text	text	65535	√		null
leads_audit	after_value_text	text	65535	√		null
notifications_audit	after_value_text	text	65535	√		null
opportunities_audit	after_value_text	text	65535	√		null
product_templates_audit	after_value_text	text	65535	√		null
products_audit	after_value_text	text	65535	√		null
project_task_audit	after_value_text	text	65535	√		null
quotas_audit	after_value_text	text	65535	√		null
quotes_audit	after_value_text	text	65535	√		null
revenue_line_items_audit	after_value_text	text	65535	√		null
workflow_alertshells	alert_text	text	65535	√		null
workflow_alertshells	alert_type	varchar	100	√		null
email_marketing	all_prospect_lists	bit	1	√		0
roles_modules	allow	bit	1	√		0
contacts	alt_address_city	varchar	100	√		null
leads	alt_address_city	varchar	100	√		null
prospects	alt_address_city	varchar	100	√		null
styleguide	alt_address_city	varchar	100	√		null
contacts	alt_address_country	varchar	255	√		null
leads	alt_address_country	varchar	255	√		null
prospects	alt_address_country	varchar	255	√		null
styleguide	alt_address_country	varchar	255	√		null
contacts	alt_address_postalcode	varchar	20	√		null
leads	alt_address_postalcode	varchar	20	√		null
prospects	alt_address_postalcode	varchar	20	√		null
styleguide	alt_address_postalcode	varchar	20	√		null
contacts	alt_address_state	varchar	100	√		null
leads	alt_address_state	varchar	100	√		null
prospects	alt_address_state	varchar	100	√		null
styleguide	alt_address_state	varchar	100	√		null
contacts	alt_address_street	varchar	150	√		null
leads	alt_address_street	varchar	150	√		null
prospects	alt_address_street	varchar	150	√		null
styleguide	alt_address_street	varchar	150	√		null
opportunities	amount	decimal	26,6	√		null
quotas	amount	decimal	26,6	√		null
quotas	amount_base_currency	decimal	26,6	√		null
opportunities	amount_usdollar	decimal	26,6	√		null
accounts	annual_revenue	varchar	100	√		null
email_cache	answered	tinyint	4	√		null
eapm	api_data	text	65535	√		null
eapm	application	varchar	100	√		webex
campaign_log	archived	bit	1	√		0
workflow_alerts	array_type	varchar	100	√		null
pmse_bpmn_artifact	art_category_ref	varchar	32	√
pmse_bpmn_artifact	art_type	varchar	15	√
pmse_bpmn_artifact	art_uid	varchar	36	√
products	asset_number	varchar	50	√		null
revenue_line_items	asset_number	varchar	50	√		null
folders	assign_to_id	char	36	√		null
accounts	assigned_user_id	char	36	√		null
address_book	assigned_user_id	char	36
address_book_lists	assigned_user_id	char	36
bugs	assigned_user_id	char	36	√		null
calls	assigned_user_id	char	36	√		null
campaigns	assigned_user_id	char	36	√		null
cases	assigned_user_id	char	36	√		null
contacts	assigned_user_id	char	36	√		null
contracts	assigned_user_id	char	36	√		null
dashboards	assigned_user_id	char	36	√		null
documents	assigned_user_id	char	36	√		null
eapm	assigned_user_id	char	36	√		null
email_templates	assigned_user_id	char	36	√		null
emails	assigned_user_id	char	36	√		null
filters	assigned_user_id	char	36	√		null
folders_subscriptions	assigned_user_id	char	36
forecast_manager_worksheets	assigned_user_id	char	36	√		null
forecast_worksheets	assigned_user_id	char	36	√		null
import_maps	assigned_user_id	char	36	√		null
job_queue	assigned_user_id	char	36	√		null
kbdocuments	assigned_user_id	char	36	√		null
leads	assigned_user_id	char	36	√		null
meetings	assigned_user_id	char	36	√		null
notes	assigned_user_id	char	36	√		null
notifications	assigned_user_id	char	36	√		null
oauth_consumer	assigned_user_id	char	36	√		null
oauth_tokens	assigned_user_id	char	36	√		null
opportunities	assigned_user_id	char	36	√		null
pdfmanager	assigned_user_id	char	36	√		null
pmse_bpm_access_management	assigned_user_id	char	36	√		null
pmse_bpm_activity_definition	assigned_user_id	char	36	√		null
pmse_bpm_activity_step	assigned_user_id	char	36	√		null
pmse_bpm_activity_user	assigned_user_id	char	36	√		null
pmse_bpm_case_data	assigned_user_id	char	36	√		null
pmse_bpm_config	assigned_user_id	char	36	√		null
pmse_bpm_dynamic_forms	assigned_user_id	char	36	√		null
pmse_bpm_event_definition	assigned_user_id	char	36	√		null
pmse_bpm_flow	assigned_user_id	char	36	√		null
pmse_bpm_form_action	assigned_user_id	char	36	√		null
pmse_bpm_gateway_definition	assigned_user_id	char	36	√		null
pmse_bpm_group	assigned_user_id	char	36	√		null
pmse_bpm_group_user	assigned_user_id	char	36	√		null
pmse_bpm_notes	assigned_user_id	char	36	√		null
pmse_bpm_process_definition	assigned_user_id	char	36	√		null
pmse_bpm_related_dependency	assigned_user_id	char	36	√		null
pmse_bpm_thread	assigned_user_id	char	36	√		null
pmse_bpmn_activity	assigned_user_id	char	36	√		null
pmse_bpmn_artifact	assigned_user_id	char	36	√		null
pmse_bpmn_bound	assigned_user_id	char	36	√		null
pmse_bpmn_data	assigned_user_id	char	36	√		null
pmse_bpmn_diagram	assigned_user_id	char	36	√		null
pmse_bpmn_documentation	assigned_user_id	char	36	√		null
pmse_bpmn_event	assigned_user_id	char	36	√		null
pmse_bpmn_extension	assigned_user_id	char	36	√		null
pmse_bpmn_flow	assigned_user_id	char	36	√		null
pmse_bpmn_gateway	assigned_user_id	char	36	√		null
pmse_bpmn_lane	assigned_user_id	char	36	√		null
pmse_bpmn_laneset	assigned_user_id	char	36	√		null
pmse_bpmn_participant	assigned_user_id	char	36	√		null
pmse_bpmn_process	assigned_user_id	char	36	√		null
pmse_business_rules	assigned_user_id	char	36	√		null
pmse_emails_templates	assigned_user_id	char	36	√		null
pmse_inbox	assigned_user_id	char	36	√		null
pmse_project	assigned_user_id	char	36	√		null
product_categories	assigned_user_id	char	36	√		null
product_templates	assigned_user_id	char	36	√		null
products	assigned_user_id	char	36	√		null
project	assigned_user_id	char	36	√		null
project_task	assigned_user_id	char	36	√		null
prospect_lists	assigned_user_id	char	36	√		null
prospects	assigned_user_id	char	36	√		null
quotas	assigned_user_id	char	36	√		null
quotes	assigned_user_id	char	36	√		null
record_list	assigned_user_id	char	36
report_cache	assigned_user_id	char	36
revenue_line_items	assigned_user_id	char	36	√		null
saved_reports	assigned_user_id	char	36	√		null
saved_search	assigned_user_id	char	36	√		null
styleguide	assigned_user_id	char	36	√		null
sugarfavorites	assigned_user_id	char	36	√		null
tasks	assigned_user_id	char	36	√		null
user_preferences	assigned_user_id	char	36
users_last_import	assigned_user_id	char	36	√		null
contacts	assistant	varchar	75	√		null
leads	assistant	varchar	75	√		null
prospects	assistant	varchar	75	√		null
styleguide	assistant	varchar	75	√		null
contacts	assistant_phone	varchar	100	√		null
leads	assistant_phone	varchar	100	√		null
prospects	assistant_phone	varchar	100	√		null
styleguide	assistant_phone	varchar	100	√		null
teams	associated_user_id	char	36	√		null
dataset_attributes	attribute_type	varchar	8	√		null
fields_meta_data	audited	bit	1	√		0
users	authenticate_id	varchar	100	√		null
pdfmanager	author	varchar	255	√		SugarCRM
inbound_email_autoreply	autoreplied_to	varchar	100	√		null
email_templates	base_module	varchar	50	√		null
pdfmanager	base_module	varchar	100	√
pmse_emails_templates	base_module	varchar	100	√		null
workflow	base_module	varchar	50	√		null
campaigns	base_rate	decimal	26,6	√		null
contracts	base_rate	decimal	26,6	√		null
forecast_manager_worksheets	base_rate	decimal	26,6	√		null
forecast_worksheets	base_rate	decimal	26,6	√		null
forecasts	base_rate	decimal	26,6	√		null
opportunities	base_rate	decimal	26,6	√		null
product_bundles	base_rate	decimal	26,6	√		null
product_templates	base_rate	decimal	26,6	√		null
products	base_rate	decimal	26,6	√		null
quotas	base_rate	decimal	26,6	√		null
quotes	base_rate	decimal	26,6	√		null
revenue_line_items	base_rate	decimal	26,6	√		null
emails_text	bcc_addrs	text	65535	√		null
address_book	bean	varchar	50	√		null
address_book	bean_id	char	36
address_book_list_items	bean_id	char	36
custom_fields	bean_id	char	36	√		null
email_addr_bean_rel	bean_id	char	36
emails_beans	bean_id	char	36	√		null
fts_queue	bean_id	char	36	√		null
users_last_import	bean_id	char	36	√		null
workflow_schedules	bean_id	char	36	√		null
email_addr_bean_rel	bean_module	varchar	100	√		null
emails_beans	bean_module	varchar	100	√		null
fts_queue	bean_module	varchar	100	√		null
users_last_import	bean_type	varchar	36	√		null
accounts_audit	before_value_string	varchar	255	√		null
bugs_audit	before_value_string	varchar	255	√		null
campaigns_audit	before_value_string	varchar	255	√		null
cases_audit	before_value_string	varchar	255	√		null
contacts_audit	before_value_string	varchar	255	√		null
contracts_audit	before_value_string	varchar	255	√		null
forecast_manager_worksheets_audit	before_value_string	varchar	255	√		null
kbcontents_audit	before_value_string	varchar	255	√		null
leads_audit	before_value_string	varchar	255	√		null
notifications_audit	before_value_string	varchar	255	√		null
opportunities_audit	before_value_string	varchar	255	√		null
product_templates_audit	before_value_string	varchar	255	√		null
products_audit	before_value_string	varchar	255	√		null
project_task_audit	before_value_string	varchar	255	√		null
quotas_audit	before_value_string	varchar	255	√		null
quotes_audit	before_value_string	varchar	255	√		null
revenue_line_items_audit	before_value_string	varchar	255	√		null
accounts_audit	before_value_text	text	65535	√		null
bugs_audit	before_value_text	text	65535	√		null
campaigns_audit	before_value_text	text	65535	√		null
cases_audit	before_value_text	text	65535	√		null
contacts_audit	before_value_text	text	65535	√		null
contracts_audit	before_value_text	text	65535	√		null
forecast_manager_worksheets_audit	before_value_text	text	65535	√		null
kbcontents_audit	before_value_text	text	65535	√		null
leads_audit	before_value_text	text	65535	√		null
notifications_audit	before_value_text	text	65535	√		null
opportunities_audit	before_value_text	text	65535	√		null
product_templates_audit	before_value_text	text	65535	√		null
products_audit	before_value_text	text	65535	√		null
project_task_audit	before_value_text	text	65535	√		null
quotas_audit	before_value_text	text	65535	√		null
quotes_audit	before_value_text	text	65535	√		null
revenue_line_items_audit	before_value_text	text	65535	√		null
forecast_manager_worksheets	best_case	decimal	26,6	√		null
forecast_worksheets	best_case	decimal	26,6	√		null
forecasts	best_case	decimal	26,6	√		null
opportunities	best_case	decimal	26,6	√		null
revenue_line_items	best_case	decimal	26,6	√		null
forecast_manager_worksheets	best_case_adjusted	decimal	26,6	√		null
dataset_attributes	bg_color	varchar	25	√		null
accounts	billing_address_city	varchar	100	√		null
quotes	billing_address_city	varchar	100	√		null
accounts	billing_address_country	varchar	255	√		null
quotes	billing_address_country	varchar	100	√		null
accounts	billing_address_postalcode	varchar	20	√		null
quotes	billing_address_postalcode	varchar	20	√		null
accounts	billing_address_state	varchar	100	√		null
quotes	billing_address_state	varchar	100	√		null
accounts	billing_address_street	varchar	150	√		null
quotes	billing_address_street	varchar	150	√		null
contacts	birthdate	date	10	√		null
leads	birthdate	date	10	√		null
prospects	birthdate	date	10	√		null
styleguide	birthdate	date	10	√		null
email_templates	body	text	65535	√		null
pmse_emails_templates	body	text	65535	√		null
data_sets	body_back_color	varchar	100	√		null
email_templates	body_html	text	65535	√		null
pdfmanager	body_html	text	65535	√		null
pmse_emails_templates	body_html	text	65535	√		null
data_sets	body_text_color	varchar	100	√		null
products	book_value	decimal	26,6	√		null
revenue_line_items	book_value	decimal	26,6	√		null
products	book_value_date	date	10	√		null
revenue_line_items	book_value_date	date	10	√		null
products	book_value_usdollar	decimal	26,6	√		null
revenue_line_items	book_value_usdollar	decimal	26,6	√		null
pmse_bpmn_bound	bou_container	varchar	30	√
pmse_bpmn_bound	bou_element	varchar	36	√
pmse_bpmn_bound	bou_element_type	varchar	32	√
pmse_bpmn_bound	bou_height	int	4	√		0
pmse_bpmn_bound	bou_rel_position	int	4	√		0
pmse_bpmn_bound	bou_size_identical	int	4	√		0
pmse_bpmn_bound	bou_uid	varchar	36	√
pmse_bpmn_bound	bou_width	int	4	√		0
pmse_bpmn_bound	bou_x	int	4	√		0
pmse_bpmn_bound	bou_y	int	4	√		0
pmse_bpm_flow	bpmn_id	varchar	36	√
pmse_bpm_flow	bpmn_type	varchar	32	√
campaigns	budget	decimal	26,6	√		null
accounts_bugs	bug_id	varchar	36	√		null
cases_bugs	bug_id	varchar	36	√		null
contacts_bugs	bug_id	varchar	36	√		null
documents_bugs	bug_id	char	36	√		null
projects_bugs	bug_id	varchar	36	√		null
bugs	bug_number	int	11		√
product_bundle_note	bundle_id	varchar	36	√		null
product_bundle_product	bundle_id	varchar	36	√		null
product_bundle_quote	bundle_id	varchar	36	√		null
product_bundle_quote	bundle_index	int	11	√		0
product_bundles	bundle_stage	varchar	255	√		null
oauth_consumer	c_key	varchar	255	√		null
oauth_consumer	c_secret	varchar	255	√		null
quotes	calc_grand_total	bit	1	√		1
calls_contacts	call_id	char	36	√		null
calls_leads	call_id	char	36	√		null
calls_users	call_id	char	36	√		null
oauth_tokens	callback_url	varchar	255	√		null
emails_beans	campaign_data	text	65535	√		null
accounts	campaign_id	char	36	√		null
campaign_log	campaign_id	char	36	√		null
campaign_trkrs	campaign_id	char	36	√		null
contacts	campaign_id	char	36	√		null
email_marketing	campaign_id	char	36	√		null
emailman	campaign_id	char	36	√		null
forecast_worksheets	campaign_id	char	36	√		null
leads	campaign_id	char	36	√		null
opportunities	campaign_id	char	36	√		null
products	campaign_id	char	36	√		null
prospect_list_campaigns	campaign_id	varchar	36	√		null
prospects	campaign_id	char	36	√		null
revenue_line_items	campaign_id	char	36	√		null
forecast_worksheets	campaign_name	varchar	255	√		null
campaigns	campaign_type	varchar	100	√		null
pmse_bpm_flow	cas_adhoc_actions	varchar	255	√
pmse_bpm_flow	cas_adhoc_parent_id	varchar	40	√
pmse_bpm_flow	cas_adhoc_type	varchar	40	√
pmse_inbox	cas_assigned_status	varchar	12	√		UNASSIGNED
pmse_inbox	cas_create_date	datetime	19	√		null
pmse_inbox	cas_custom_status	varchar	32	√		null
pmse_bpm_case_data	cas_data	text	65535	√		null
pmse_bpm_form_action	cas_data	text	65535	√		null
pmse_bpm_flow	cas_delay_duration	int	4	√		0
pmse_bpm_flow	cas_delayed	int	4	√		0
pmse_bpm_flow	cas_delegate_date	datetime	19	√		null
pmse_bpm_flow	cas_due_date	datetime	19	√		null
pmse_bpm_flow	cas_duration	int	4	√		0
pmse_bpm_flow	cas_finish_date	datetime	19	√		null
pmse_inbox	cas_finish_date	datetime	19	√		null
pmse_bpm_flow	cas_finished	int	4	√		0
pmse_bpm_thread	cas_flow_index	int	4	√		0
pmse_bpm_flow	cas_flow_status	varchar	32	√		OPEN
pmse_bpm_case_data	cas_id	int	4	√		0
pmse_bpm_flow	cas_id	int	4	√		null
pmse_bpm_form_action	cas_id	int	4	√		null
pmse_bpm_notes	cas_id	varchar	36	√
pmse_bpm_thread	cas_id	int	4	√		0
pmse_inbox	cas_id	int	255		√
pmse_bpm_flow	cas_index	int	4	√		null
pmse_bpm_notes	cas_index	int	4	√		null
pmse_inbox	cas_init_user	varchar	36	√		null
pmse_inbox	cas_module	varchar	100	√		null
pmse_inbox	cas_parent	int	255	√		null
pmse_inbox	cas_pin	varchar	10	√		0000
pmse_bpm_form_action	cas_pre_data	text	65535	√		null
pmse_bpm_flow	cas_previous	int	4	√		0
pmse_bpm_flow	cas_queue_duration	int	4	√		0
pmse_bpm_flow	cas_reassign_level	int	4	√		0
pmse_bpm_flow	cas_start_date	datetime	19	√		null
pmse_bpm_flow	cas_started	int	4	√		0
pmse_inbox	cas_status	varchar	32	√		IN PROGRESS
pmse_bpm_flow	cas_sugar_action	varchar	40	√		DetailView
pmse_bpm_flow	cas_sugar_module	varchar	128	√		ProcessMaker
pmse_bpm_flow	cas_sugar_object_id	varchar	40	√
pmse_bpm_flow	cas_task_start_date	datetime	19	√		null
pmse_bpm_flow	cas_thread	int	4	√		0
pmse_bpm_thread	cas_thread_index	int	4	√		0
pmse_bpm_thread	cas_thread_parent	int	4	√		0
pmse_bpm_thread	cas_thread_passes	int	4	√		0
pmse_bpm_thread	cas_thread_status	varchar	32	√		OPEN
pmse_bpm_thread	cas_thread_tokens	int	4	√		0
pmse_inbox	cas_title	varchar	255	√		null
pmse_inbox	cas_update_date	datetime	19	√		null
pmse_bpm_flow	cas_user_id	varchar	40	√
accounts_cases	case_id	varchar	36	√		null
cases_bugs	case_id	varchar	36	√		null
contacts_cases	case_id	varchar	36	√		null
documents_cases	case_id	char	36	√		null
kbdocuments	case_id	char	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
acl_fields	category	varchar	100	√		null
config	category	varchar	32	√		null
user_preferences	category	varchar	50	√		null
documents	category_id	varchar	100	√		null
forecast_worksheets	category_id	char	36	√		null
product_templates	category_id	char	36	√		null
products	category_id	char	36	√		null
revenue_line_items	category_id	char	36	√		null
forecast_worksheets	category_name	varchar	255	√		null
emails_text	cc_addrs	text	65535	√		null
dataset_attributes	cell_size	varchar	3	√		null
pmse_bpm_config	cfg_status	varchar	20	√		ACTIVE
pmse_bpm_config	cfg_value	text	65535	√		null
document_revisions	change_log	varchar	255	√		null
kbdocument_revisions	change_log	varchar	255	√		null
saved_reports	chart_type	varchar	36	√		none
product_product	child_id	varchar	36	√		null
job_queue	client	varchar	255	√		null
tracker_sessions	client_ip	varchar	45	√		null
oauth_consumer	client_type	varchar	50	√		user
forecast_manager_worksheets	closed_amount	decimal	26,6	√		0.000000
forecasts	closed_amount	decimal	26,6	√		0.000000
opportunities	closed_revenue_line_items	int	11	√		null
activities	comment_count	int	11	√		0
fields_meta_data	comments	varchar	255	√		null
forecast_worksheets	commit_stage	varchar	50	√		null
opportunities	commit_stage	varchar	50	√		null
revenue_line_items	commit_stage	varchar	50	√		exclude
quotas	committed	bit	1	√		0
contracts	company_signed_date	date	10	√		null
oauth_nonce	conskey	varchar	32
oauth_tokens	consumer	char	36
eapm	consumer_key	varchar	255	√		null
eapm	consumer_secret	varchar	255	√		null
accounts_contacts	contact_id	varchar	36	√		null
calls_contacts	contact_id	char	36	√		null
contacts_bugs	contact_id	varchar	36	√		null
contacts_cases	contact_id	varchar	36	√		null
contacts_users	contact_id	varchar	36	√		null
contracts_contacts	contact_id	varchar	36	√		null
documents_contacts	contact_id	char	36	√		null
leads	contact_id	char	36	√		null
meetings_contacts	contact_id	char	36	√		null
notes	contact_id	char	36	√		null
oauth_tokens	contact_id	char	36	√		null
opportunities_contacts	contact_id	varchar	36	√		null
products	contact_id	char	36	√		null
projects_contacts	contact_id	varchar	36	√		null
quotes_contacts	contact_id	varchar	36	√		null
tasks	contact_id	char	36	√		null
contacts_bugs	contact_role	varchar	50	√		null
contacts_cases	contact_role	varchar	50	√		null
opportunities_contacts	contact_role	varchar	50	√		null
quotes_contacts	contact_role	varchar	20	√		null
campaigns	content	text	65535	√		null
import_maps	content	text	65535	√		null
saved_reports	content	longtext	2147483647	√		null
vcals	content	text	65535	√		null
report_cache	contents	text	65535	√		null
saved_search	contents	text	65535	√		null
user_preferences	contents	longtext	2147483647	√		null
contracts_contacts	contract_id	varchar	36	√		null
contracts_opportunities	contract_id	varchar	36	√		null
contracts_products	contract_id	varchar	36	√		null
contracts_quotes	contract_id	varchar	36	√		null
currencies	conversion_rate	decimal	26,6	√		0.000000
leads	converted	bit	1	√		0
forecast_worksheets	cost_price	decimal	26,6	√		null
product_templates	cost_price	decimal	26,6	√		null
products	cost_price	decimal	26,6	√		null
revenue_line_items	cost_price	decimal	26,6	√		null
product_templates	cost_usdollar	decimal	26,6	√		null
products	cost_usdollar	decimal	26,6	√		null
revenue_line_items	cost_usdollar	decimal	26,6	√		null
accounts	created_by	char	36	√		null
accounts_audit	created_by	char	36	√		null
acl_actions	created_by	char	36	√		null
acl_fields	created_by	char	36	√		null
acl_role_sets	created_by	char	36	√		null
acl_roles	created_by	char	36	√		null
activities	created_by	char	36	√		null
bugs	created_by	char	36	√		null
bugs_audit	created_by	char	36	√		null
calls	created_by	char	36	√		null
campaign_trkrs	created_by	char	36	√		null
campaigns	created_by	char	36	√		null
campaigns_audit	created_by	char	36	√		null
cases	created_by	char	36	√		null
cases_audit	created_by	char	36	√		null
comments	created_by	char	36	√		null
contacts	created_by	char	36	√		null
contacts_audit	created_by	char	36	√		null
contract_types	created_by	char	36	√		null
contracts	created_by	char	36	√		null
contracts_audit	created_by	char	36	√		null
currencies	created_by	char	36
custom_queries	created_by	char	36	√		null
dashboards	created_by	char	36	√		null
data_sets	created_by	char	36	√		null
dataset_attributes	created_by	char	36	√		null
dataset_layouts	created_by	char	36	√		null
document_revisions	created_by	char	36	√		null
documents	created_by	char	36	√		null
eapm	created_by	char	36	√		null
email_marketing	created_by	char	36	√		null
email_templates	created_by	char	36	√		null
emails	created_by	char	36	√		null
expressions	created_by	char	36	√		null
filters	created_by	char	36	√		null
folders	created_by	char	36
forecast_manager_worksheets	created_by	char	36	√		null
forecast_manager_worksheets_audit	created_by	char	36	√		null
forecast_worksheets	created_by	char	36	√		null
holidays	created_by	char	36	√		null
inbound_email	created_by	char	36	√		null
kbcontents_audit	created_by	char	36	√		null
kbdocument_revisions	created_by	char	36	√		null
kbdocuments	created_by	char	36	√		null
kbdocuments_kbtags	created_by	char	36	√		null
kbtags	created_by	char	36	√		null
leads	created_by	char	36	√		null
leads_audit	created_by	char	36	√		null
manufacturers	created_by	char	36	√		null
meetings	created_by	char	36	√		null
notes	created_by	char	36	√		null
notifications	created_by	char	36	√		null
notifications_audit	created_by	char	36	√		null
oauth_consumer	created_by	char	36	√		null
opportunities	created_by	char	36	√		null
opportunities_audit	created_by	char	36	√		null
pdfmanager	created_by	char	36	√		null
pmse_bpm_access_management	created_by	char	36	√		null
pmse_bpm_activity_definition	created_by	char	36	√		null
pmse_bpm_activity_step	created_by	char	36	√		null
pmse_bpm_activity_user	created_by	char	36	√		null
pmse_bpm_case_data	created_by	char	36	√		null
pmse_bpm_config	created_by	char	36	√		null
pmse_bpm_dynamic_forms	created_by	char	36	√		null
pmse_bpm_event_definition	created_by	char	36	√		null
pmse_bpm_flow	created_by	char	36	√		null
pmse_bpm_form_action	created_by	char	36	√		null
pmse_bpm_gateway_definition	created_by	char	36	√		null
pmse_bpm_group	created_by	char	36	√		null
pmse_bpm_group_user	created_by	char	36	√		null
pmse_bpm_notes	created_by	char	36	√		null
pmse_bpm_process_definition	created_by	char	36	√		null
pmse_bpm_related_dependency	created_by	char	36	√		null
pmse_bpm_thread	created_by	char	36	√		null
pmse_bpmn_activity	created_by	char	36	√		null
pmse_bpmn_artifact	created_by	char	36	√		null
pmse_bpmn_bound	created_by	char	36	√		null
pmse_bpmn_data	created_by	char	36	√		null
pmse_bpmn_diagram	created_by	char	36	√		null
pmse_bpmn_documentation	created_by	char	36	√		null
pmse_bpmn_event	created_by	char	36	√		null
pmse_bpmn_extension	created_by	char	36	√		null
pmse_bpmn_flow	created_by	char	36	√		null
pmse_bpmn_gateway	created_by	char	36	√		null
pmse_bpmn_lane	created_by	char	36	√		null
pmse_bpmn_laneset	created_by	char	36	√		null
pmse_bpmn_participant	created_by	char	36	√		null
pmse_bpmn_process	created_by	char	36	√		null
pmse_business_rules	created_by	char	36	√		null
pmse_emails_templates	created_by	char	36	√		null
pmse_inbox	created_by	char	36	√		null
pmse_project	created_by	char	36	√		null
product_bundle_notes	created_by	char	36	√		null
product_bundles	created_by	char	36	√		null
product_categories	created_by	char	36	√		null
product_templates	created_by	char	36	√		null
product_templates_audit	created_by	char	36	√		null
product_types	created_by	char	36	√		null
products	created_by	char	36	√		null
products_audit	created_by	char	36	√		null
project	created_by	char	36	√		null
project_resources	created_by	char	36	√		null
project_task	created_by	char	36	√		null
project_task_audit	created_by	char	36	√		null
prospect_lists	created_by	char	36	√		null
prospects	created_by	char	36	√		null
quotas	created_by	char	36	√		null
quotas_audit	created_by	char	36	√		null
quotes	created_by	char	36	√		null
quotes_audit	created_by	char	36	√		null
releases	created_by	char	36	√		null
report_maker	created_by	char	36	√		null
revenue_line_items	created_by	char	36	√		null
revenue_line_items_audit	created_by	char	36	√		null
roles	created_by	char	36	√		null
saved_reports	created_by	char	36	√		null
schedulers	created_by	char	36	√		null
shippers	created_by	char	36	√		null
styleguide	created_by	char	36	√		null
subscriptions	created_by	char	36	√		null
sugarfavorites	created_by	char	36	√		null
tasks	created_by	char	36	√		null
taxrates	created_by	char	36	√		null
team_notices	created_by	char	36	√		null
team_sets	created_by	char	36	√		null
teams	created_by	char	36	√		null
timeperiods	created_by	char	36	√		null
users	created_by	char	36	√		null
users_signatures	created_by	char	36	√		null
versions	created_by	char	36	√		null
weblogichooks	created_by	char	36	√		null
workflow	created_by	char	36	√		null
workflow_actions	created_by	char	36	√		null
workflow_actionshells	created_by	char	36	√		null
workflow_alerts	created_by	char	36	√		null
workflow_alertshells	created_by	char	36	√		null
workflow_schedules	created_by	char	36	√		null
workflow_triggershells	created_by	char	36	√		null
meetings	creator	varchar	50	√		null
product_templates	currency	varchar	255	√		null
campaigns	currency_id	char	36	√		-99
contracts	currency_id	char	36	√		-99
forecast_manager_worksheets	currency_id	char	36	√		null
forecast_worksheets	currency_id	char	36	√		null
forecasts	currency_id	char	36	√		-99
opportunities	currency_id	char	36	√		-99
product_bundles	currency_id	char	36	√		-99
product_templates	currency_id	char	36	√		-99
products	currency_id	char	36	√		-99
quotas	currency_id	char	36	√		-99
quotes	currency_id	char	36	√		-99
revenue_line_items	currency_id	char	36	√		-99
styleguide	currency_id	char	36	√		-99
data_sets	custom_layout	varchar	10	√		null
fields_meta_data	custom_module	varchar	255	√		null
custom_queries	custom_query	text	65535	√		null
workflow_alertshells	custom_template_id	char	36	√		null
contracts	customer_signed_date	date	10	√		null
dashboards	dashboard_module	varchar	100	√		null
dashboards	dashboard_type	varchar	100	√		dashboard
pmse_bpmn_data	dat_capacity	int	4	√		0
pmse_bpmn_data	dat_is_collection	int	4	√		0
pmse_bpmn_data	dat_is_global	int	4	√		0
pmse_bpmn_data	dat_is_unlimited	int	4	√		0
pmse_bpmn_data	dat_item_kind	varchar	20	√		INFORMATION
pmse_bpmn_data	dat_object_ref	int	4	√		null
pmse_bpmn_data	dat_state	varchar	255	√
pmse_bpmn_data	dat_type	varchar	20	√
pmse_bpmn_data	dat_uid	varchar	36	√
activities	data	longtext	2147483647	√		null
comments	data	longtext	2147483647	√		null
job_queue	data	longtext	2147483647	√		null
metadata_cache	data	longblob	2147483647	√		null
accounts_audit	data_type	varchar	100	√		null
bugs_audit	data_type	varchar	100	√		null
campaigns_audit	data_type	varchar	100	√		null
cases_audit	data_type	varchar	100	√		null
contacts_audit	data_type	varchar	100	√		null
contracts_audit	data_type	varchar	100	√		null
forecast_manager_worksheets_audit	data_type	varchar	100	√		null
kbcontents_audit	data_type	varchar	100	√		null
leads_audit	data_type	varchar	100	√		null
notifications_audit	data_type	varchar	100	√		null
opportunities_audit	data_type	varchar	100	√		null
product_templates_audit	data_type	varchar	100	√		null
products_audit	data_type	varchar	100	√		null
project_task_audit	data_type	varchar	100	√		null
quotas_audit	data_type	varchar	100	√		null
quotes_audit	data_type	varchar	100	√		null
revenue_line_items_audit	data_type	varchar	100	√		null
product_templates	date_available	date	10	√		null
forecast_worksheets	date_closed	date	10	√		null
opportunities	date_closed	date	10	√		null
products	date_closed	date	10	√		null
revenue_line_items	date_closed	date	10	√		null
forecast_worksheets	date_closed_timestamp	int	11	√		null
opportunities	date_closed_timestamp	int	11	√		null
products	date_closed_timestamp	int	11	√		null
revenue_line_items	date_closed_timestamp	int	11	√		null
product_templates	date_cost_price	date	10	√		null
accounts_audit	date_created	datetime	19	√		null
bugs_audit	date_created	datetime	19	√		null
campaigns_audit	date_created	datetime	19	√		null
cases_audit	date_created	datetime	19	√		null
contacts_audit	date_created	datetime	19	√		null
contracts_audit	date_created	datetime	19	√		null
email_addr_bean_rel	date_created	datetime	19	√		null
email_addresses	date_created	datetime	19	√		null
forecast_manager_worksheets_audit	date_created	datetime	19	√		null
fts_queue	date_created	datetime	19	√		null
kbcontents_audit	date_created	datetime	19	√		null
leads_audit	date_created	datetime	19	√		null
notifications_audit	date_created	datetime	19	√		null
opportunities_audit	date_created	datetime	19	√		null
product_templates_audit	date_created	datetime	19	√		null
products_audit	date_created	datetime	19	√		null
project_task_audit	date_created	datetime	19	√		null
quotas_audit	date_created	datetime	19	√		null
quotes_audit	date_created	datetime	19	√		null
revenue_line_items_audit	date_created	datetime	19	√		null
project_task	date_due	date	10	√		null
tasks	date_due	datetime	19	√		null
tasks	date_due_flag	bit	1	√		0
calls	date_end	datetime	19	√		null
meetings	date_end	datetime	19	√		null
team_notices	date_end	date	10	√		null
tracker_sessions	date_end	datetime	19	√		null
accounts	date_entered	datetime	19	√		null
acl_actions	date_entered	datetime	19	√		null
acl_fields	date_entered	datetime	19	√		null
acl_role_sets	date_entered	datetime	19	√		null
acl_roles	date_entered	datetime	19	√		null
activities	date_entered	datetime	19	√		null
bugs	date_entered	datetime	19	√		null
calls	date_entered	datetime	19	√		null
campaign_trkrs	date_entered	datetime	19	√		null
campaigns	date_entered	datetime	19	√		null
cases	date_entered	datetime	19	√		null
comments	date_entered	datetime	19	√		null
contacts	date_entered	datetime	19	√		null
contract_types	date_entered	datetime	19	√		null
contracts	date_entered	datetime	19	√		null
currencies	date_entered	datetime	19	√		null
custom_queries	date_entered	datetime	19	√		null
dashboards	date_entered	datetime	19	√		null
data_sets	date_entered	datetime	19	√		null
dataset_attributes	date_entered	datetime	19	√		null
dataset_layouts	date_entered	datetime	19	√		null
document_revisions	date_entered	datetime	19	√		null
documents	date_entered	datetime	19	√		null
eapm	date_entered	datetime	19	√		null
email_marketing	date_entered	datetime	19	√		null
email_templates	date_entered	datetime	19	√		null
emailman	date_entered	datetime	19	√		null
emails	date_entered	datetime	19	√		null
expressions	date_entered	datetime	19	√		null
filters	date_entered	datetime	19	√		null
forecast_manager_worksheets	date_entered	datetime	19	√		null
forecast_worksheets	date_entered	datetime	19	√		null
forecasts	date_entered	datetime	19	√		null
holidays	date_entered	datetime	19	√		null
import_maps	date_entered	datetime	19	√		null
inbound_email	date_entered	datetime	19	√		null
inbound_email_autoreply	date_entered	datetime	19	√		null
job_queue	date_entered	datetime	19	√		null
kbcontents	date_entered	datetime	19	√		null
kbdocument_revisions	date_entered	datetime	19	√		null
kbdocuments	date_entered	datetime	19	√		null
kbdocuments_kbtags	date_entered	datetime	19	√		null
kbtags	date_entered	datetime	19	√		null
leads	date_entered	datetime	19	√		null
manufacturers	date_entered	datetime	19	√		null
meetings	date_entered	datetime	19	√		null
notes	date_entered	datetime	19	√		null
notifications	date_entered	datetime	19	√		null
oauth_consumer	date_entered	datetime	19	√		null
opportunities	date_entered	datetime	19	√		null
pdfmanager	date_entered	datetime	19	√		null
pmse_bpm_access_management	date_entered	datetime	19	√		null
pmse_bpm_activity_definition	date_entered	datetime	19	√		null
pmse_bpm_activity_step	date_entered	datetime	19	√		null
pmse_bpm_activity_user	date_entered	datetime	19	√		null
pmse_bpm_case_data	date_entered	datetime	19	√		null
pmse_bpm_config	date_entered	datetime	19	√		null
pmse_bpm_dynamic_forms	date_entered	datetime	19	√		null
pmse_bpm_event_definition	date_entered	datetime	19	√		null
pmse_bpm_flow	date_entered	datetime	19	√		null
pmse_bpm_form_action	date_entered	datetime	19	√		null
pmse_bpm_gateway_definition	date_entered	datetime	19	√		null
pmse_bpm_group	date_entered	datetime	19	√		null
pmse_bpm_group_user	date_entered	datetime	19	√		null
pmse_bpm_notes	date_entered	datetime	19	√		null
pmse_bpm_process_definition	date_entered	datetime	19	√		null
pmse_bpm_related_dependency	date_entered	datetime	19	√		null
pmse_bpm_thread	date_entered	datetime	19	√		null
pmse_bpmn_activity	date_entered	datetime	19	√		null
pmse_bpmn_artifact	date_entered	datetime	19	√		null
pmse_bpmn_bound	date_entered	datetime	19	√		null
pmse_bpmn_data	date_entered	datetime	19	√		null
pmse_bpmn_diagram	date_entered	datetime	19	√		null
pmse_bpmn_documentation	date_entered	datetime	19	√		null
pmse_bpmn_event	date_entered	datetime	19	√		null
pmse_bpmn_extension	date_entered	datetime	19	√		null
pmse_bpmn_flow	date_entered	datetime	19	√		null
pmse_bpmn_gateway	date_entered	datetime	19	√		null
pmse_bpmn_lane	date_entered	datetime	19	√		null
pmse_bpmn_laneset	date_entered	datetime	19	√		null
pmse_bpmn_participant	date_entered	datetime	19	√		null
pmse_bpmn_process	date_entered	datetime	19	√		null
pmse_business_rules	date_entered	datetime	19	√		null
pmse_emails_templates	date_entered	datetime	19	√		null
pmse_inbox	date_entered	datetime	19	√		null
pmse_project	date_entered	datetime	19	√		null
product_bundle_notes	date_entered	datetime	19	√		null
product_bundles	date_entered	datetime	19	√		null
product_categories	date_entered	datetime	19	√		null
product_templates	date_entered	datetime	19	√		null
product_types	date_entered	datetime	19	√		null
products	date_entered	datetime	19	√		null
project	date_entered	datetime	19	√		null
project_task	date_entered	datetime	19	√		null
prospect_lists	date_entered	datetime	19	√		null
prospects	date_entered	datetime	19	√		null
quotas	date_entered	datetime	19	√		null
quotes	date_entered	datetime	19	√		null
releases	date_entered	datetime	19	√		null
report_cache	date_entered	datetime	19	√		null
report_maker	date_entered	datetime	19	√		null
revenue_line_items	date_entered	datetime	19	√		null
roles	date_entered	datetime	19	√		null
saved_reports	date_entered	datetime	19	√		null
saved_search	date_entered	datetime	19	√		null
schedulers	date_entered	datetime	19	√		null
schedulers_times	date_entered	datetime	19	√		null
session_active	date_entered	datetime	19	√		null
session_history	date_entered	datetime	19	√		null
shippers	date_entered	datetime	19	√		null
styleguide	date_entered	datetime	19	√		null
subscriptions	date_entered	datetime	19	√		null
sugarfavorites	date_entered	datetime	19	√		null
systems	date_entered	datetime	19	√		null
tasks	date_entered	datetime	19	√		null
taxrates	date_entered	datetime	19	√		null
team_notices	date_entered	datetime	19	√		null
teams	date_entered	datetime	19	√		null
timeperiods	date_entered	datetime	19	√		null
upgrade_history	date_entered	datetime	19	√		null
user_preferences	date_entered	datetime	19	√		null
users	date_entered	datetime	19	√		null
users_signatures	date_entered	datetime	19	√		null
vcals	date_entered	datetime	19	√		null
versions	date_entered	datetime	19	√		null
weblogichooks	date_entered	datetime	19	√		null
workflow	date_entered	datetime	19	√		null
workflow_actions	date_entered	datetime	19	√		null
workflow_actionshells	date_entered	datetime	19	√		null
workflow_alerts	date_entered	datetime	19	√		null
workflow_alertshells	date_entered	datetime	19	√		null
workflow_schedules	date_entered	datetime	19	√		null
workflow_triggershells	date_entered	datetime	19	√		null
workflow_schedules	date_expired	datetime	19	√		null
project_task	date_finish	date	10	√		null
users_password_link	date_generated	datetime	19	√		null
accounts	date_modified	datetime	19	√		null
accounts_bugs	date_modified	datetime	19	√		null
accounts_cases	date_modified	datetime	19	√		null
accounts_contacts	date_modified	datetime	19	√		null
accounts_opportunities	date_modified	datetime	19	√		null
acl_actions	date_modified	datetime	19	√		null
acl_fields	date_modified	datetime	19	√		null
acl_role_sets	date_modified	datetime	19	√		null
acl_role_sets_acl_roles	date_modified	datetime	19	√		null
acl_roles	date_modified	datetime	19	√		null
acl_roles_actions	date_modified	datetime	19	√		null
acl_roles_users	date_modified	datetime	19	√		null
activities	date_modified	datetime	19	√		null
activities_users	date_modified	datetime	19	√		null
bugs	date_modified	datetime	19	√		null
calls	date_modified	datetime	19	√		null
calls_contacts	date_modified	datetime	19	√		null
calls_leads	date_modified	datetime	19	√		null
calls_users	date_modified	datetime	19	√		null
campaign_log	date_modified	datetime	19	√		null
campaign_trkrs	date_modified	datetime	19	√		null
campaigns	date_modified	datetime	19	√		null
cases	date_modified	datetime	19	√		null
cases_bugs	date_modified	datetime	19	√		null
comments	date_modified	datetime	19	√		null
contacts	date_modified	datetime	19	√		null
contacts_bugs	date_modified	datetime	19	√		null
contacts_cases	date_modified	datetime	19	√		null
contacts_users	date_modified	datetime	19	√		null
contract_types	date_modified	datetime	19	√		null
contracts	date_modified	datetime	19	√		null
contracts_contacts	date_modified	datetime	19	√		null
contracts_opportunities	date_modified	datetime	19	√		null
contracts_products	date_modified	datetime	19	√		null
contracts_quotes	date_modified	datetime	19	√		null
currencies	date_modified	datetime	19	√		null
custom_queries	date_modified	datetime	19	√		null
dashboards	date_modified	datetime	19	√		null
data_sets	date_modified	datetime	19	√		null
dataset_attributes	date_modified	datetime	19	√		null
dataset_layouts	date_modified	datetime	19	√		null
document_revisions	date_modified	datetime	19	√		null
documents	date_modified	datetime	19	√		null
documents_accounts	date_modified	datetime	19	√		null
documents_bugs	date_modified	datetime	19	√		null
documents_cases	date_modified	datetime	19	√		null
documents_contacts	date_modified	datetime	19	√		null
documents_opportunities	date_modified	datetime	19	√		null
documents_products	date_modified	datetime	19	√		null
documents_quotes	date_modified	datetime	19	√		null
documents_revenuelineitems	date_modified	datetime	19	√		null
eapm	date_modified	datetime	19	√		null
email_addr_bean_rel	date_modified	datetime	19	√		null
email_addresses	date_modified	datetime	19	√		null
email_marketing	date_modified	datetime	19	√		null
email_marketing_prospect_lists	date_modified	datetime	19	√		null
email_templates	date_modified	datetime	19	√		null
emailman	date_modified	datetime	19	√		null
emails	date_modified	datetime	19	√		null
emails_beans	date_modified	datetime	19	√		null
expressions	date_modified	datetime	19	√		null
fields_meta_data	date_modified	datetime	19	√		null
filters	date_modified	datetime	19	√		null
forecast_manager_worksheets	date_modified	datetime	19	√		null
forecast_worksheets	date_modified	datetime	19	√		null
forecasts	date_modified	datetime	19	√		null
fts_queue	date_modified	datetime	19	√		null
holidays	date_modified	datetime	19	√		null
import_maps	date_modified	datetime	19	√		null
inbound_email	date_modified	datetime	19	√		null
inbound_email_autoreply	date_modified	datetime	19	√		null
job_queue	date_modified	datetime	19	√		null
kbcontents	date_modified	datetime	19	√		null
kbdocument_revisions	date_modified	datetime	19	√		null
kbdocuments	date_modified	datetime	19	√		null
kbdocuments_kbtags	date_modified	datetime	19	√		null
kbdocuments_views_ratings	date_modified	datetime	19	√		null
kbtags	date_modified	datetime	19	√		null
leads	date_modified	datetime	19	√		null
linked_documents	date_modified	datetime	19	√		null
manufacturers	date_modified	datetime	19	√		null
meetings	date_modified	datetime	19	√		null
meetings_contacts	date_modified	datetime	19	√		null
meetings_leads	date_modified	datetime	19	√		null
meetings_users	date_modified	datetime	19	√		null
metadata_cache	date_modified	datetime	19	√		null
notes	date_modified	datetime	19	√		null
notifications	date_modified	datetime	19	√		null
oauth_consumer	date_modified	datetime	19	√		null
opportunities	date_modified	datetime	19	√		null
opportunities_contacts	date_modified	datetime	19	√		null
pdfmanager	date_modified	datetime	19	√		null
pmse_bpm_access_management	date_modified	datetime	19	√		null
pmse_bpm_activity_definition	date_modified	datetime	19	√		null
pmse_bpm_activity_step	date_modified	datetime	19	√		null
pmse_bpm_activity_user	date_modified	datetime	19	√		null
pmse_bpm_case_data	date_modified	datetime	19	√		null
pmse_bpm_config	date_modified	datetime	19	√		null
pmse_bpm_dynamic_forms	date_modified	datetime	19	√		null
pmse_bpm_event_definition	date_modified	datetime	19	√		null
pmse_bpm_flow	date_modified	datetime	19	√		null
pmse_bpm_form_action	date_modified	datetime	19	√		null
pmse_bpm_gateway_definition	date_modified	datetime	19	√		null
pmse_bpm_group	date_modified	datetime	19	√		null
pmse_bpm_group_user	date_modified	datetime	19	√		null
pmse_bpm_notes	date_modified	datetime	19	√		null
pmse_bpm_process_definition	date_modified	datetime	19	√		null
pmse_bpm_related_dependency	date_modified	datetime	19	√		null
pmse_bpm_thread	date_modified	datetime	19	√		null
pmse_bpmn_activity	date_modified	datetime	19	√		null
pmse_bpmn_artifact	date_modified	datetime	19	√		null
pmse_bpmn_bound	date_modified	datetime	19	√		null
pmse_bpmn_data	date_modified	datetime	19	√		null
pmse_bpmn_diagram	date_modified	datetime	19	√		null
pmse_bpmn_documentation	date_modified	datetime	19	√		null
pmse_bpmn_event	date_modified	datetime	19	√		null
pmse_bpmn_extension	date_modified	datetime	19	√		null
pmse_bpmn_flow	date_modified	datetime	19	√		null
pmse_bpmn_gateway	date_modified	datetime	19	√		null
pmse_bpmn_lane	date_modified	datetime	19	√		null
pmse_bpmn_laneset	date_modified	datetime	19	√		null
pmse_bpmn_participant	date_modified	datetime	19	√		null
pmse_bpmn_process	date_modified	datetime	19	√		null
pmse_business_rules	date_modified	datetime	19	√		null
pmse_emails_templates	date_modified	datetime	19	√		null
pmse_inbox	date_modified	datetime	19	√		null
pmse_project	date_modified	datetime	19	√		null
product_bundle_note	date_modified	datetime	19	√		null
product_bundle_notes	date_modified	datetime	19	√		null
product_bundle_product	date_modified	datetime	19	√		null
product_bundle_quote	date_modified	datetime	19	√		null
product_bundles	date_modified	datetime	19	√		null
product_categories	date_modified	datetime	19	√		null
product_product	date_modified	datetime	19	√		null
product_templates	date_modified	datetime	19	√		null
product_types	date_modified	datetime	19	√		null
products	date_modified	datetime	19	√		null
project	date_modified	datetime	19	√		null
project_resources	date_modified	datetime	19	√		null
project_task	date_modified	datetime	19	√		null
projects_accounts	date_modified	datetime	19	√		null
projects_bugs	date_modified	datetime	19	√		null
projects_cases	date_modified	datetime	19	√		null
projects_contacts	date_modified	datetime	19	√		null
projects_opportunities	date_modified	datetime	19	√		null
projects_products	date_modified	datetime	19	√		null
projects_quotes	date_modified	datetime	19	√		null
projects_revenue_line_items	date_modified	datetime	19	√		null
prospect_list_campaigns	date_modified	datetime	19	√		null
prospect_lists	date_modified	datetime	19	√		null
prospect_lists_prospects	date_modified	datetime	19	√		null
prospects	date_modified	datetime	19	√		null
quotas	date_modified	datetime	19	√		null
quotes	date_modified	datetime	19	√		null
quotes_accounts	date_modified	datetime	19	√		null
quotes_contacts	date_modified	datetime	19	√		null
quotes_opportunities	date_modified	datetime	19	√		null
record_list	date_modified	datetime	19	√		null
releases	date_modified	datetime	19	√		null
report_cache	date_modified	datetime	19	√		null
report_maker	date_modified	datetime	19	√		null
report_schedules	date_modified	datetime	19	√		null
revenue_line_items	date_modified	datetime	19	√		null
roles	date_modified	datetime	19	√		null
roles_modules	date_modified	datetime	19	√		null
roles_users	date_modified	datetime	19	√		null
saved_reports	date_modified	datetime	19	√		null
saved_search	date_modified	datetime	19	√		null
schedulers	date_modified	datetime	19	√		null
schedulers_times	date_modified	datetime	19	√		null
session_active	date_modified	datetime	19	√		null
session_history	date_modified	datetime	19	√		null
shippers	date_modified	datetime	19	√		null
styleguide	date_modified	datetime	19	√		null
subscriptions	date_modified	datetime	19	√		null
sugarfavorites	date_modified	datetime	19	√		null
systems	date_modified	datetime	19	√		null
tasks	date_modified	datetime	19	√		null
taxrates	date_modified	datetime	19	√		null
team_memberships	date_modified	datetime	19	√		null
team_notices	date_modified	datetime	19	√		null
team_sets	date_modified	datetime	19	√		null
team_sets_teams	date_modified	datetime	19	√		null
teams	date_modified	datetime	19	√		null
timeperiods	date_modified	datetime	19	√		null
tracker	date_modified	datetime	19	√		null
tracker_perf	date_modified	datetime	19	√		null
tracker_queries	date_modified	datetime	19	√		null
tracker_tracker_queries	date_modified	datetime	19	√		null
user_preferences	date_modified	datetime	19	√		null
users	date_modified	datetime	19	√		null
users_feeds	date_modified	datetime	19	√		null
users_holidays	date_modified	datetime	19	√		null
users_signatures	date_modified	datetime	19	√		null
vcals	date_modified	datetime	19	√		null
versions	date_modified	datetime	19	√		null
weblogichooks	date_modified	datetime	19	√		null
workflow	date_modified	datetime	19	√		null
workflow_actions	date_modified	datetime	19	√		null
workflow_actionshells	date_modified	datetime	19	√		null
workflow_alerts	date_modified	datetime	19	√		null
workflow_alertshells	date_modified	datetime	19	√		null
workflow_schedules	date_modified	datetime	19	√		null
workflow_triggershells	date_modified	datetime	19	√		null
quotes	date_order_shipped	date	10	√		null
products	date_purchased	date	10	√		null
revenue_line_items	date_purchased	date	10	√		null
quotes	date_quote_closed	date	10	√		null
quotes	date_quote_expected_closed	date	10	√		null
emails	date_sent	datetime	19	√		null
calls	date_start	datetime	19	√		null
email_marketing	date_start	datetime	19	√		null
meetings	date_start	datetime	19	√		null
project_task	date_start	date	10	√		null
report_schedules	date_start	datetime	19	√		null
styleguide	date_start	datetime	19	√		null
tasks	date_start	datetime	19	√		null
team_notices	date_start	date	10	√		null
tracker_sessions	date_start	datetime	19	√		null
tasks	date_start_flag	bit	1	√		0
products	date_support_expires	date	10	√		null
revenue_line_items	date_support_expires	date	10	√		null
products	date_support_starts	date	10	√		null
revenue_line_items	date_support_starts	date	10	√		null
schedulers	date_time_end	datetime	19	√		null
schedulers	date_time_start	datetime	19	√		null
tracker_perf	db_round_trips	int	6	√		null
versions	db_version	varchar	255	√		null
products	deal_calc	decimal	26,6	√		null
revenue_line_items	deal_calc	decimal	26,6	√		null
products	deal_calc_usdollar	decimal	26,6	√		null
revenue_line_items	deal_calc_usdollar	decimal	26,6	√		null
product_bundles	deal_tot	decimal	26,2	√		null
quotes	deal_tot	decimal	26,2	√		null
product_bundles	deal_tot_usdollar	decimal	26,2	√		null
quotes	deal_tot_usdollar	decimal	26,2	√		null
shippers	default_cost	decimal	26,6	√		null
shippers	default_cost_usdollar	decimal	26,6	√		null
users	default_team	char	36	√		null
fields_meta_data	default_value	varchar	255	√		null
import_maps	default_values	text	65535	√		null
inbound_email	delete_seen	bit	1	√		0
accounts	deleted	bit	1	√		0
accounts_bugs	deleted	bit	1	√		0
accounts_cases	deleted	bit	1	√		0
accounts_contacts	deleted	bit	1	√		0
accounts_opportunities	deleted	bit	1	√		0
acl_actions	deleted	bit	1	√		null
acl_fields	deleted	bit	1	√		null
acl_role_sets	deleted	bit	1	√		0
acl_role_sets_acl_roles	deleted	bit	1	√		null
acl_roles	deleted	bit	1	√		null
acl_roles_actions	deleted	bit	1	√		0
acl_roles_users	deleted	bit	1	√		0
activities	deleted	bit	1	√		0
activities_users	deleted	bit	1	√		0
bugs	deleted	bit	1	√		0
calls	deleted	bit	1	√		0
calls_contacts	deleted	bit	1	√		0
calls_leads	deleted	bit	1	√		0
calls_users	deleted	bit	1	√		0
campaign_log	deleted	bit	1	√		null
campaign_trkrs	deleted	bit	1	√		0
campaigns	deleted	bit	1	√		0
cases	deleted	bit	1	√		0
cases_bugs	deleted	bit	1	√		0
comments	deleted	bit	1	√		0
contacts	deleted	bit	1	√		0
contacts_bugs	deleted	bit	1	√		0
contacts_cases	deleted	bit	1	√		0
contacts_users	deleted	bit	1	√		0
contract_types	deleted	bit	1	√		0
contracts	deleted	bit	1	√		0
contracts_contacts	deleted	bit	1	√		0
contracts_opportunities	deleted	bit	1	√		0
contracts_products	deleted	bit	1	√		0
contracts_quotes	deleted	bit	1	√		0
currencies	deleted	bit	1	√		null
custom_fields	deleted	bit	1	√		0
custom_queries	deleted	bit	1	√		0
dashboards	deleted	bit	1	√		0
data_sets	deleted	bit	1	√		0
dataset_attributes	deleted	bit	1	√		0
dataset_layouts	deleted	bit	1	√		0
document_revisions	deleted	bit	1	√		0
documents	deleted	bit	1	√		0
documents_accounts	deleted	bit	1	√		0
documents_bugs	deleted	bit	1	√		0
documents_cases	deleted	bit	1	√		0
documents_contacts	deleted	bit	1	√		0
documents_opportunities	deleted	bit	1	√		0
documents_products	deleted	bit	1	√		0
documents_quotes	deleted	bit	1	√		0
documents_revenuelineitems	deleted	bit	1	√		0
eapm	deleted	bit	1	√		0
email_addr_bean_rel	deleted	bit	1	√		0
email_addresses	deleted	bit	1	√		0
email_cache	deleted	tinyint	4	√		null
email_marketing	deleted	bit	1	√		null
email_marketing_prospect_lists	deleted	bit	1	√		0
email_templates	deleted	bit	1	√		null
emailman	deleted	bit	1	√		0
emails	deleted	bit	1	√		null
emails_beans	deleted	bit	1	√		0
emails_email_addr_rel	deleted	bit	1	√		0
emails_text	deleted	bit	1	√		0
expressions	deleted	bit	1	√		0
fields_meta_data	deleted	bit	1	√		0
filters	deleted	bit	1	√		0
folders	deleted	bit	1	√		0
folders_rel	deleted	bit	1	√		0
forecast_manager_worksheets	deleted	bit	1	√		0
forecast_worksheets	deleted	bit	1	√		0
forecasts	deleted	bit	1	√		null
holidays	deleted	bit	1	√		null
import_maps	deleted	bit	1	√		null
inbound_email	deleted	bit	1	√		0
inbound_email_autoreply	deleted	bit	1	√		0
job_queue	deleted	bit	1	√		0
kbcontents	deleted	bit	1	√		0
kbdocument_revisions	deleted	bit	1	√		0
kbdocuments	deleted	bit	1	√		0
kbdocuments_kbtags	deleted	bit	1	√		0
kbdocuments_views_ratings	deleted	bit	1	√		0
kbtags	deleted	bit	1	√		0
leads	deleted	bit	1	√		0
linked_documents	deleted	bit	1	√		0
manufacturers	deleted	bit	1	√		null
meetings	deleted	bit	1	√		0
meetings_contacts	deleted	bit	1	√		0
meetings_leads	deleted	bit	1	√		0
meetings_users	deleted	bit	1	√		0
metadata_cache	deleted	bit	1	√		0
notes	deleted	bit	1	√		0
notifications	deleted	bit	1	√		0
oauth_consumer	deleted	bit	1	√		0
oauth_tokens	deleted	bit	1			0
opportunities	deleted	bit	1	√		0
opportunities_contacts	deleted	bit	1	√		0
pdfmanager	deleted	bit	1	√		0
pmse_bpm_access_management	deleted	bit	1	√		0
pmse_bpm_activity_definition	deleted	bit	1	√		0
pmse_bpm_activity_step	deleted	bit	1	√		0
pmse_bpm_activity_user	deleted	bit	1	√		0
pmse_bpm_case_data	deleted	bit	1	√		0
pmse_bpm_config	deleted	bit	1	√		0
pmse_bpm_dynamic_forms	deleted	bit	1	√		0
pmse_bpm_event_definition	deleted	bit	1	√		0
pmse_bpm_flow	deleted	bit	1	√		0
pmse_bpm_form_action	deleted	bit	1	√		0
pmse_bpm_gateway_definition	deleted	bit	1	√		0
pmse_bpm_group	deleted	bit	1	√		0
pmse_bpm_group_user	deleted	bit	1	√		0
pmse_bpm_notes	deleted	bit	1	√		0
pmse_bpm_process_definition	deleted	bit	1	√		0
pmse_bpm_related_dependency	deleted	bit	1	√		0
pmse_bpm_thread	deleted	bit	1	√		0
pmse_bpmn_activity	deleted	bit	1	√		0
pmse_bpmn_artifact	deleted	bit	1	√		0
pmse_bpmn_bound	deleted	bit	1	√		0
pmse_bpmn_data	deleted	bit	1	√		0
pmse_bpmn_diagram	deleted	bit	1	√		0
pmse_bpmn_documentation	deleted	bit	1	√		0
pmse_bpmn_event	deleted	bit	1	√		0
pmse_bpmn_extension	deleted	bit	1	√		0
pmse_bpmn_flow	deleted	bit	1	√		0
pmse_bpmn_gateway	deleted	bit	1	√		0
pmse_bpmn_lane	deleted	bit	1	√		0
pmse_bpmn_laneset	deleted	bit	1	√		0
pmse_bpmn_participant	deleted	bit	1	√		0
pmse_bpmn_process	deleted	bit	1	√		0
pmse_business_rules	deleted	bit	1	√		0
pmse_emails_templates	deleted	bit	1	√		0
pmse_inbox	deleted	bit	1	√		0
pmse_project	deleted	bit	1	√		0
product_bundle_note	deleted	bit	1	√		0
product_bundle_notes	deleted	bit	1	√		0
product_bundle_product	deleted	bit	1	√		0
product_bundle_quote	deleted	bit	1	√		0
product_bundles	deleted	bit	1	√		0
product_categories	deleted	bit	1	√		0
product_product	deleted	bit	1	√		0
product_templates	deleted	bit	1	√		0
product_types	deleted	bit	1	√		0
products	deleted	bit	1	√		0
project	deleted	bit	1	√		0
project_resources	deleted	bit	1	√		0
project_task	deleted	bit	1	√		0
projects_accounts	deleted	bit	1	√		0
projects_bugs	deleted	bit	1	√		0
projects_cases	deleted	bit	1	√		0
projects_contacts	deleted	bit	1	√		0
projects_opportunities	deleted	bit	1	√		0
projects_products	deleted	bit	1	√		0
projects_quotes	deleted	bit	1	√		0
projects_revenue_line_items	deleted	bit	1	√		0
prospect_list_campaigns	deleted	bit	1	√		0
prospect_lists	deleted	bit	1	√		null
prospect_lists_prospects	deleted	bit	1	√		0
prospects	deleted	bit	1	√		0
quotas	deleted	bit	1	√		0
quotes	deleted	bit	1	√		0
quotes_accounts	deleted	bit	1	√		0
quotes_contacts	deleted	bit	1	√		0
quotes_opportunities	deleted	bit	1	√		0
relationships	deleted	bit	1	√		0
releases	deleted	bit	1	√		null
report_cache	deleted	varchar	1	√		null
report_maker	deleted	bit	1	√		0
report_schedules	deleted	bit	1	√		0
revenue_line_items	deleted	bit	1	√		0
roles	deleted	bit	1	√		null
roles_modules	deleted	bit	1	√		0
roles_users	deleted	bit	1	√		0
saved_reports	deleted	bit	1	√		null
saved_search	deleted	bit	1	√		null
schedulers	deleted	bit	1	√		0
schedulers_times	deleted	bit	1	√		0
session_active	deleted	bit	1	√		0
session_history	deleted	bit	1	√		0
shippers	deleted	bit	1	√		null
styleguide	deleted	bit	1	√		0
subscriptions	deleted	bit	1	√		0
sugarfavorites	deleted	bit	1	√		0
systems	deleted	bit	1	√		0
tasks	deleted	bit	1	√		0
taxrates	deleted	bit	1	√		null
team_memberships	deleted	bit	1	√		0
team_notices	deleted	bit	1	√		null
team_sets	deleted	bit	1	√		0
team_sets_modules	deleted	bit	1	√		0
team_sets_teams	deleted	bit	1	√		0
teams	deleted	bit	1	√		0
timeperiods	deleted	bit	1	√		null
tracker	deleted	bit	1	√		0
tracker_perf	deleted	bit	1	√		0
tracker_queries	deleted	bit	1	√		0
tracker_sessions	deleted	bit	1	√		0
user_preferences	deleted	bit	1	√		0
users	deleted	bit	1	√		null
users_feeds	deleted	bit	1	√		0
users_holidays	deleted	bit	1	√		0
users_last_import	deleted	bit	1	√		null
users_password_link	deleted	bit	1	√		null
users_signatures	deleted	bit	1	√		0
vcals	deleted	bit	1	√		null
versions	deleted	bit	1	√		null
weblogichooks	deleted	bit	1	√		0
workflow	deleted	bit	1	√		0
workflow_actions	deleted	bit	1	√		0
workflow_actionshells	deleted	bit	1	√		0
workflow_alerts	deleted	bit	1	√		0
workflow_alertshells	deleted	bit	1	√		0
workflow_schedules	deleted	bit	1	√		0
workflow_triggershells	deleted	bit	1	√		0
import_maps	delimiter	varchar	1	√		,
contacts	department	varchar	255	√		null
leads	department	varchar	100	√		null
prospects	department	varchar	255	√		null
styleguide	department	varchar	255	√		null
users	department	varchar	50	√		null
accounts	description	text	65535	√		null
acl_role_sets	description	text	65535	√		null
acl_roles	description	text	65535	√		null
bugs	description	text	65535	√		null
calls	description	text	65535	√		null
cases	description	text	65535	√		null
contacts	description	text	65535	√		null
contracts	description	text	65535	√		null
custom_queries	description	text	65535	√		null
dashboards	description	text	65535	√		null
data_sets	description	text	65535	√		null
documents	description	text	65535	√		null
eapm	description	text	65535	√		null
email_templates	description	text	65535	√		null
emails_text	description	longtext	2147483647	√		null
filters	description	text	65535	√		null
forecast_manager_worksheets	description	text	65535	√		null
forecast_worksheets	description	text	65535	√		null
holidays	description	text	65535	√		null
kbdocuments	description	text	65535	√		null
leads	description	text	65535	√		null
meetings	description	text	65535	√		null
notes	description	text	65535	√		null
notifications	description	text	65535	√		null
oauth_consumer	description	text	65535	√		null
opportunities	description	text	65535	√		null
pdfmanager	description	text	65535	√		null
pmse_bpm_access_management	description	text	65535	√		null
pmse_bpm_activity_definition	description	text	65535	√		null
pmse_bpm_activity_step	description	text	65535	√		null
pmse_bpm_activity_user	description	text	65535	√		null
pmse_bpm_case_data	description	text	65535	√		null
pmse_bpm_config	description	text	65535	√		null
pmse_bpm_dynamic_forms	description	text	65535	√		null
pmse_bpm_event_definition	description	text	65535	√		null
pmse_bpm_flow	description	text	65535	√		null
pmse_bpm_form_action	description	text	65535	√		null
pmse_bpm_gateway_definition	description	text	65535	√		null
pmse_bpm_group	description	text	65535	√		null
pmse_bpm_group_user	description	text	65535	√		null
pmse_bpm_notes	description	text	65535	√		null
pmse_bpm_process_definition	description	text	65535	√		null
pmse_bpm_related_dependency	description	text	65535	√		null
pmse_bpm_thread	description	text	65535	√		null
pmse_bpmn_activity	description	text	65535	√		null
pmse_bpmn_artifact	description	text	65535	√		null
pmse_bpmn_bound	description	text	65535	√		null
pmse_bpmn_data	description	text	65535	√		null
pmse_bpmn_diagram	description	text	65535	√		null
pmse_bpmn_documentation	description	text	65535	√		null
pmse_bpmn_event	description	text	65535	√		null
pmse_bpmn_extension	description	text	65535	√		null
pmse_bpmn_flow	description	text	65535	√		null
pmse_bpmn_gateway	description	text	65535	√		null
pmse_bpmn_lane	description	text	65535	√		null
pmse_bpmn_laneset	description	text	65535	√		null
pmse_bpmn_participant	description	text	65535	√		null
pmse_bpmn_process	description	text	65535	√		null
pmse_business_rules	description	text	65535	√		null
pmse_emails_templates	description	text	65535	√		null
pmse_inbox	description	text	65535	√		null
pmse_project	description	text	65535	√		null
product_bundle_notes	description	text	65535	√		null
product_bundles	description	text	65535	√		null
product_categories	description	text	65535	√		null
product_templates	description	text	65535	√		null
product_types	description	text	65535	√		null
products	description	text	65535	√		null
project	description	text	65535	√		null
project_task	description	text	65535	√		null
prospect_lists	description	text	65535	√		null
prospects	description	text	65535	√		null
quotas	description	text	65535	√		null
quotes	description	text	65535	√		null
report_maker	description	text	65535	√		null
revenue_line_items	description	text	65535	√		null
roles	description	text	65535	√		null
saved_search	description	text	65535	√		null
schedulers	description	text	65535	√		null
styleguide	description	text	65535	√		null
sugarfavorites	description	varchar	50	√		null
tasks	description	text	65535	√		null
team_notices	description	text	65535	√		null
teams	description	text	65535	√		null
upgrade_history	description	text	65535	√		null
users	description	text	65535	√		null
users_signatures	description	text	65535	√		null
weblogichooks	description	text	65535	√		null
workflow	description	text	65535	√		null
emails_text	description_html	longtext	2147483647	√		null
pmse_bpmn_bound	dia_id	varchar	36	√
pmse_bpmn_flow	dia_id	varchar	36	√
pmse_bpmn_process	dia_id	varchar	36	√
pmse_bpmn_diagram	dia_is_closable	int	4	√		0
pmse_bpmn_diagram	dia_uid	varchar	36	√
calls	direction	varchar	100	√		null
quotes	discount	decimal	26,6	√		null
forecast_worksheets	discount_amount	decimal	26,6	√		null
products	discount_amount	decimal	26,6	√		null
revenue_line_items	discount_amount	decimal	26,6	√		null
products	discount_amount_usdollar	decimal	26,6	√		null
revenue_line_items	discount_amount_usdollar	decimal	26,6	√		null
forecast_worksheets	discount_price	decimal	26,6	√		null
product_templates	discount_price	decimal	26,6	√		null
products	discount_price	decimal	26,6	√		null
revenue_line_items	discount_price	decimal	26,6	√		null
products	discount_rate_percent	decimal	26,2	√		null
revenue_line_items	discount_rate_percent	decimal	26,2	√		null
products	discount_select	bit	1	√		null
revenue_line_items	discount_select	bit	1	√		null
product_templates	discount_usdollar	decimal	26,6	√		null
products	discount_usdollar	decimal	26,6	√		null
revenue_line_items	discount_usdollar	decimal	26,6	√		null
dataset_attributes	display_name	varchar	50	√		null
dataset_attributes	display_type	varchar	25	√		null
meetings	displayed_url	varchar	400	√		null
contacts	dnb_principal_id	varchar	30	√		null
leads	dnb_principal_id	varchar	30	√		null
prospects	dnb_principal_id	varchar	30	√		null
contacts	do_not_call	bit	1	√		0
leads	do_not_call	bit	1	√		0
prospects	do_not_call	bit	1	√		0
styleguide	do_not_call	bit	1	√		0
pmse_bpmn_documentation	doc_documentation	text	65535	√		null
pmse_bpmn_documentation	doc_element	varchar	36	√
pmse_bpmn_documentation	doc_element_type	varchar	45	√
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
pmse_bpmn_documentation	doc_uid	varchar	36	√
document_revisions	doc_url	varchar	255	√		null
documents	doc_url	varchar	255	√		null
document_revisions	document_id	char	36	√		null
documents_accounts	document_id	char	36	√		null
documents_bugs	document_id	char	36	√		null
documents_cases	document_id	char	36	√		null
documents_contacts	document_id	char	36	√		null
documents_opportunities	document_id	char	36	√		null
documents_products	document_id	char	36	√		null
documents_quotes	document_id	varchar	36	√		null
documents_revenuelineitems	document_id	varchar	36	√		null
linked_documents	document_id	varchar	36	√		null
documents	document_name	varchar	255	√		null
documents	document_revision_id	char	36	√		null
kbcontents	document_revision_id	char	36	√		null
kbdocument_revisions	document_revision_id	char	36	√		null
linked_documents	document_revision_id	varchar	36	√		null
prospect_lists	domain_name	varchar	255	√		null
oauth_tokens	download_token	varchar	36	√		null
email_cache	draft	tinyint	4	√		null
forecast_manager_worksheets	draft	bit	1	√		0
forecast_worksheets	draft	int	11	√		0
accounts	duns_num	varchar	15	√		null
fields_meta_data	duplicate_merge	smallint	6	√		0
project_task	duration	int	11	√		null
calls	duration_hours	int	2	√		0
meetings	duration_hours	int	2	√		0
calls	duration_minutes	int	2	√		null
meetings	duration_minutes	int	2	√		0
project_task	duration_unit	text	65535	√		null
pmse_bpm_dynamic_forms	dyn_module	varchar	255	√
pmse_bpm_dynamic_forms	dyn_uid	varchar	32	√
pmse_bpm_dynamic_forms	dyn_view_defs	text	65535	√		null
folders	dynamic_query	text	65535	√		null
pmse_bpmn_bound	element_id	varchar	36	√
email_addresses	email_address	varchar	255	√		null
email_addresses	email_address_caps	varchar	255	√		null
email_addr_bean_rel	email_address_id	char	36
emails_email_addr_rel	email_address_id	char	36
emails_beans	email_id	char	36	√		null
emails_email_addr_rel	email_id	char	36
emails_text	email_id	char	36
email_marketing_prospect_lists	email_marketing_id	varchar	36	√		null
inbound_email	email_password	varchar	100	√		null
calls	email_reminder_sent	bit	1	√		0
meetings	email_reminder_sent	bit	1	√		0
calls	email_reminder_time	int	11	√		-1
meetings	email_reminder_time	int	11	√		-1
inbound_email	email_user	varchar	100	√		null
notes	embed_flag	bit	1	√		0
users	employee_status	varchar	100	√		null
accounts	employees	varchar	10	√		null
upgrade_history	enabled	bit	1	√		1
import_maps	enclosure	varchar	1	√
campaigns	end_date	date	10	√		null
contracts	end_date	date	10	√		null
timeperiods	end_date	date	10	√		null
timeperiods	end_date_timestamp	int	14	√		null
project_task	estimated_effort	int	11	√		null
project	estimated_end_date	date	10	√		null
project	estimated_start_date	date	10	√		null
workflow_triggershells	eval	text	65535	√		null
pmse_bpm_related_dependency	evn_activity_ref	varchar	36	√
pmse_bpmn_event	evn_activity_ref	int	4	√		null
pmse_bpm_related_dependency	evn_attached_to	varchar	36	√
pmse_bpmn_event	evn_attached_to	int	4	√		null
pmse_bpm_related_dependency	evn_behavior	varchar	36	√
pmse_bpmn_event	evn_behavior	varchar	20	√		CATCH
pmse_bpm_related_dependency	evn_cancel_activity	varchar	36	√
pmse_bpmn_event	evn_cancel_activity	int	4	√		0
pmse_bpm_related_dependency	evn_condition	varchar	36	√
pmse_bpmn_event	evn_condition	varchar	255	√
pmse_bpm_event_definition	evn_criteria	text	65535	√		null
pmse_bpm_related_dependency	evn_criteria	text	65535	√		null
pmse_bpm_related_dependency	evn_error_code	varchar	36	√
pmse_bpmn_event	evn_error_code	varchar	255	√
pmse_bpm_related_dependency	evn_error_name	varchar	36	√
pmse_bpmn_event	evn_error_name	varchar	255	√
pmse_bpm_related_dependency	evn_escalation_code	varchar	36	√
pmse_bpmn_event	evn_escalation_code	varchar	255	√
pmse_bpm_related_dependency	evn_escalation_name	varchar	36	√
pmse_bpmn_event	evn_escalation_name	varchar	255	√
pmse_bpm_related_dependency	evn_id	varchar	36	√
pmse_bpm_related_dependency	evn_is_interrupting	varchar	36	√
pmse_bpmn_event	evn_is_interrupting	int	4	√		1
pmse_bpm_related_dependency	evn_marker	varchar	36	√
pmse_bpmn_event	evn_marker	varchar	30	√		EMPTY
pmse_bpm_related_dependency	evn_message	varchar	36	√
pmse_bpmn_event	evn_message	text	65535	√		null
pmse_bpm_event_definition	evn_module	varchar	128	√		Leads
pmse_bpm_related_dependency	evn_module	varchar	36	√
pmse_bpm_related_dependency	evn_operation_implementation	varchar	36	√
pmse_bpmn_event	evn_operation_implementation	varchar	255	√
pmse_bpm_related_dependency	evn_operation_name	varchar	36	√
pmse_bpmn_event	evn_operation_name	varchar	255	√
pmse_bpm_event_definition	evn_params	text	65535	√		null
pmse_bpm_related_dependency	evn_params	text	65535	√		null
pmse_bpm_event_definition	evn_script	text	65535	√		null
pmse_bpm_related_dependency	evn_script	text	65535	√		null
pmse_bpm_event_definition	evn_status	varchar	32	√		ACTIVE
pmse_bpm_related_dependency	evn_status	varchar	36	√
pmse_bpm_related_dependency	evn_time_cycle	varchar	36	√
pmse_bpmn_event	evn_time_cycle	varchar	255	√
pmse_bpm_related_dependency	evn_time_date	varchar	36	√
pmse_bpmn_event	evn_time_date	varchar	255	√
pmse_bpm_related_dependency	evn_time_duration	varchar	36	√
pmse_bpmn_event	evn_time_duration	varchar	255	√
pmse_bpm_event_definition	evn_type	varchar	30	√		START
pmse_bpm_related_dependency	evn_type	varchar	36	√
pmse_bpmn_event	evn_type	varchar	30	√
pmse_bpm_related_dependency	evn_uid	varchar	36	√
pmse_bpmn_event	evn_uid	varchar	36	√
pmse_bpm_related_dependency	evn_wait_for_completion	varchar	36	√
pmse_bpmn_event	evn_wait_for_completion	int	4	√		1
job_queue	execute_time	datetime	19	√		null
schedulers_times	execute_time	datetime	19	√		null
pmse_bpm_activity_definition	execution_mode	varchar	10	√		DEFAULT
pmse_bpm_event_definition	execution_mode	varchar	10	√		DEFAULT
pmse_bpm_gateway_definition	execution_mode	varchar	10	√		DEFAULT
pmse_bpm_process_definition	execution_mode	varchar	10	√		SYNC
documents	exp_date	date	10	√		null
kbdocuments	exp_date	date	10	√		null
expressions	exp_order	int	4	√		null
expressions	exp_type	varchar	100	√		null
campaigns	expected_cost	decimal	26,6	√		null
campaigns	expected_revenue	decimal	26,6	√		null
contracts	expiration_notice	datetime	19	√		null
oauth_tokens	expire_ts	bigint	20	√		-1
team_memberships	explicit_assign	bit	1	√		0
data_sets	exportable	varchar	3	√		0
expressions	ext1	varchar	50	√		null
fields_meta_data	ext1	varchar	255	√
workflow_actions	ext1	varchar	50	√		null
expressions	ext2	varchar	50	√		null
fields_meta_data	ext2	varchar	255	√
workflow_actions	ext2	varchar	50	√		null
expressions	ext3	varchar	50	√		null
fields_meta_data	ext3	varchar	255	√
workflow_actions	ext3	varchar	50	√		null
fields_meta_data	ext4	text	65535	√		null
pmse_bpmn_extension	ext_element	varchar	36	√
pmse_bpmn_extension	ext_element_type	varchar	45	√
pmse_bpmn_extension	ext_extension	text	65535	√		null
pmse_bpmn_extension	ext_uid	varchar	36	√
users	external_auth_only	bit	1	√		0
meetings	external_id	varchar	50	√		null
accounts	facebook	varchar	100	√		null
contacts	facebook	varchar	100	√		null
leads	facebook	varchar	100	√		null
prospects	facebook	varchar	100	√		null
styleguide	facebook	varchar	100	√		null
job_queue	failure_count	tinyint	4	√		null
saved_reports	favorite	bit	1	√		null
users_feeds	feed_id	varchar	36	√		null
pdfmanager	field	varchar	100	√		0
workflow_actions	field	varchar	50	√		null
workflow_triggershells	field	varchar	50	√		null
custom_fields	field0	varchar	255	√		null
custom_fields	field1	varchar	255	√		null
custom_fields	field2	varchar	255	√		null
custom_fields	field3	varchar	255	√		null
custom_fields	field4	varchar	255	√		null
custom_fields	field5	varchar	255	√		null
custom_fields	field6	varchar	255	√		null
custom_fields	field7	varchar	255	√		null
custom_fields	field8	varchar	255	√		null
custom_fields	field9	varchar	255	√		null
accounts_audit	field_name	varchar	100	√		null
bugs_audit	field_name	varchar	100	√		null
campaigns_audit	field_name	varchar	100	√		null
cases_audit	field_name	varchar	100	√		null
contacts_audit	field_name	varchar	100	√		null
contracts_audit	field_name	varchar	100	√		null
forecast_manager_worksheets_audit	field_name	varchar	100	√		null
kbcontents_audit	field_name	varchar	100	√		null
leads_audit	field_name	varchar	100	√		null
notifications_audit	field_name	varchar	100	√		null
opportunities_audit	field_name	varchar	100	√		null
product_templates_audit	field_name	varchar	100	√		null
products_audit	field_name	varchar	100	√		null
project_task_audit	field_name	varchar	100	√		null
quotas_audit	field_name	varchar	100	√		null
quotes_audit	field_name	varchar	100	√		null
revenue_line_items_audit	field_name	varchar	100	√		null
workflow_alerts	field_value	varchar	50	√		null
activities_users	fields	longtext	2147483647	√		null
document_revisions	file_ext	varchar	100	√		null
kbdocument_revisions	file_ext	varchar	100	√		null
document_revisions	file_mime_type	varchar	100	√		null
kbdocument_revisions	file_mime_type	varchar	100	√		null
notes	file_mime_type	varchar	100	√		null
styleguide	file_mime_type	varchar	100	√		null
versions	file_version	varchar	255	√		null
document_revisions	filename	varchar	255	√		null
kbdocument_revisions	filename	varchar	255	√		null
notes	filename	varchar	255	√		null
styleguide	filename	varchar	255	√		null
upgrade_history	filename	varchar	255	√		null
tracker_perf	files_opened	int	6	√		null
filters	filter_definition	longtext	2147483647	√		null
filters	filter_template	longtext	2147483647	√		null
workflow	fire_order	varchar	100	√		null
contacts	first_name	varchar	100	√		null
leads	first_name	varchar	100	√		null
prospects	first_name	varchar	100	√		null
styleguide	first_name	varchar	100	√		null
users	first_name	varchar	30	√		null
bugs	fixed_in_release	varchar	255	√		null
email_cache	flagged	tinyint	4	√		null
emails	flagged	bit	1	√		null
pmse_bpmn_flow	flo_condition	text	65535	√		null
pmse_bpmn_flow	flo_element_dest	varchar	36	√
pmse_bpmn_flow	flo_element_dest_port	int	4	√		0
pmse_bpmn_flow	flo_element_dest_type	varchar	32	√
pmse_bpmn_flow	flo_element_origin	varchar	36	√
pmse_bpmn_flow	flo_element_origin_port	int	4	√		0
pmse_bpmn_flow	flo_element_origin_type	varchar	32	√
pmse_bpmn_flow	flo_eval_priority	int	4	√		0
pmse_bpmn_flow	flo_is_inmediate	int	4	√		null
pmse_bpmn_flow	flo_state	text	65535	√		null
pmse_bpmn_flow	flo_type	varchar	20	√
pmse_bpmn_flow	flo_uid	varchar	36	√
pmse_bpmn_flow	flo_x1	int	4	√		0
pmse_bpmn_flow	flo_x2	int	4	√		0
pmse_bpmn_flow	flo_y1	int	4	√		0
pmse_bpmn_flow	flo_y2	int	4	√		0
folders_rel	folder_id	char	36
folders_subscriptions	folder_id	char	36
folders	folder_type	varchar	25	√		null
dataset_attributes	font_color	varchar	25	√		null
data_sets	font_size	varchar	8	√		0
dataset_attributes	font_size	varchar	8	√		0
pdfmanager	footer_text	varchar	255	√		null
forecasts	forecast_type	varchar	100	√		null
dataset_attributes	format_type	varchar	25	√		null
bugs	found_in_release	varchar	255	√		null
workflow_triggershells	frame_type	varchar	15	√		null
campaigns	frequency	varchar	100	√		null
pmse_bpm_form_action	frm_action	varchar	255	√		ROUTE
pmse_bpm_form_action	frm_comment	text	65535	√		null
pmse_bpm_form_action	frm_date	datetime	19	√		null
pmse_bpm_form_action	frm_index	int	4	√		null
pmse_bpm_form_action	frm_last	int	4	√		null
pmse_bpm_form_action	frm_user_id	varchar	255	√
pmse_bpm_form_action	frm_user_name	varchar	255	√
email_marketing	from_addr	varchar	100	√		null
emails_text	from_addr	varchar	255	√		null
email_templates	from_address	varchar	255	√		null
pmse_emails_templates	from_address	varchar	255	√		null
email_marketing	from_name	varchar	100	√		null
email_templates	from_name	varchar	255	√		null
pmse_emails_templates	from_name	varchar	255	√		null
email_cache	fromaddr	varchar	100	√		null
pmse_bpmn_gateway	gat_activation_count	int	4	√		0
pmse_bpmn_gateway	gat_default_flow	varchar	36	√
pmse_bpmn_gateway	gat_direction	varchar	30	√		UNSPECIFIED
pmse_bpmn_gateway	gat_event_gateway_type	varchar	20	√		NONE
pmse_bpmn_gateway	gat_instantiate	int	4	√		0
pmse_bpmn_gateway	gat_type	varchar	30	√
pmse_bpmn_gateway	gat_uid	varchar	36	√
pmse_bpmn_gateway	gat_waiting_for_start	int	4	√		1
accounts	googleplus	varchar	100	√		null
contacts	googleplus	varchar	100	√		null
leads	googleplus	varchar	100	√		null
prospects	googleplus	varchar	100	√		null
styleguide	googleplus	varchar	100	√		null
inbound_email	group_id	char	36	√		null
inbound_email	groupfolder_id	char	36	√		null
pmse_bpm_group	grp_parent_group	int	4	√		0
pmse_bpm_group	grp_uid	varchar	36	√
folders	has_child	bit	1	√		0
import_maps	has_header	bit	1	√		1
acl_role_sets	hash	varchar	32	√		null
data_sets	header	varchar	3	√		0
data_sets	header_back_color	varchar	100	√		null
pdfmanager	header_logo	varchar	255	√		null
pdfmanager	header_text	varchar	255	√		null
data_sets	header_text_color	varchar	100	√		null
pdfmanager	header_title	varchar	255	√		null
fields_meta_data	help	varchar	255	√		null
dataset_layouts	hide_column	varchar	3	√		null
forecast_tree	hierarchy_type	varchar	25	√		null
campaign_log	hits	int	11	√		0
holidays	holiday_date	date	10	√		null
users_holidays	holiday_id	varchar	36	√		null
meetings	host_url	varchar	600	√		null
accounts	id	char	36
accounts_audit	id	char	36
accounts_bugs	id	varchar	36
accounts_cases	id	varchar	36
accounts_contacts	id	varchar	36
accounts_opportunities	id	varchar	36
acl_actions	id	char	36
acl_fields	id	char	36
acl_role_sets	id	char	36
acl_role_sets_acl_roles	id	char	36
acl_roles	id	char	36
acl_roles_actions	id	varchar	36
acl_roles_users	id	varchar	36
activities	id	char	36
activities_users	id	char	36
address_book_lists	id	char	36
bugs	id	char	36
bugs_audit	id	char	36
calls	id	char	36
calls_contacts	id	char	36
calls_leads	id	char	36
calls_users	id	char	36
campaign_log	id	char	36
campaign_trkrs	id	char	36
campaigns	id	char	36
campaigns_audit	id	char	36
cases	id	char	36
cases_audit	id	char	36
cases_bugs	id	varchar	36
comments	id	char	36
contacts	id	char	36
contacts_audit	id	char	36
contacts_bugs	id	varchar	36
contacts_cases	id	varchar	36
contacts_users	id	varchar	36
contract_types	id	char	36
contracts	id	char	36
contracts_audit	id	char	36
contracts_contacts	id	varchar	36
contracts_opportunities	id	varchar	36
contracts_products	id	varchar	36
contracts_quotes	id	varchar	36
currencies	id	char	36
custom_queries	id	char	36
dashboards	id	char	36
data_sets	id	char	36
dataset_attributes	id	char	36
dataset_layouts	id	char	36
document_revisions	id	char	36
documents	id	char	36
documents_accounts	id	char	36
documents_bugs	id	char	36
documents_cases	id	char	36
documents_contacts	id	char	36
documents_opportunities	id	char	36
documents_products	id	char	36
documents_quotes	id	varchar	36
documents_revenuelineitems	id	varchar	36
eapm	id	char	36
email_addr_bean_rel	id	char	36
email_addresses	id	char	36
email_marketing	id	char	36
email_marketing_prospect_lists	id	varchar	36
email_templates	id	char	36
emailman	id	int	11		√
emails	id	char	36
emails_beans	id	char	36
emails_email_addr_rel	id	char	36
expressions	id	char	36
fields_meta_data	id	varchar	255
filters	id	char	36
folders	id	char	36
folders_rel	id	char	36
folders_subscriptions	id	char	36
forecast_manager_worksheets	id	char	36
forecast_manager_worksheets_audit	id	char	36
forecast_tree	id	char	36
forecast_worksheets	id	char	36
forecasts	id	char	36
fts_queue	id	char	36
holidays	id	char	36
import_maps	id	char	36
inbound_email	id	varchar	36
inbound_email_autoreply	id	char	36
inbound_email_cache_ts	id	varchar	255
job_queue	id	char	36
kbcontents	id	char	36
kbcontents_audit	id	char	36
kbdocument_revisions	id	char	36
kbdocuments	id	char	36
kbdocuments_kbtags	id	char	36
kbdocuments_views_ratings	id	varchar	36
kbtags	id	char	36
leads	id	char	36
leads_audit	id	char	36
linked_documents	id	varchar	36
manufacturers	id	char	36
meetings	id	char	36
meetings_contacts	id	char	36
meetings_leads	id	char	36
meetings_users	id	char	36
metadata_cache	id	varchar	36
notes	id	char	36
notifications	id	char	36
notifications_audit	id	char	36
oauth_consumer	id	char	36
oauth_tokens	id	char	36
opportunities	id	char	36
opportunities_audit	id	char	36
opportunities_contacts	id	varchar	36
outbound_email	id	char	36
pdfmanager	id	char	36
pmse_bpm_access_management	id	char	36
pmse_bpm_activity_definition	id	char	36
pmse_bpm_activity_step	id	char	36
pmse_bpm_activity_user	id	char	36
pmse_bpm_case_data	id	char	36
pmse_bpm_config	id	char	36
pmse_bpm_dynamic_forms	id	char	36
pmse_bpm_event_definition	id	char	36
pmse_bpm_flow	id	char	36
pmse_bpm_form_action	id	char	36
pmse_bpm_gateway_definition	id	char	36
pmse_bpm_group	id	char	36
pmse_bpm_group_user	id	char	36
pmse_bpm_notes	id	char	36
pmse_bpm_process_definition	id	char	36
pmse_bpm_related_dependency	id	char	36
pmse_bpm_thread	id	char	36
pmse_bpmn_activity	id	char	36
pmse_bpmn_artifact	id	char	36
pmse_bpmn_bound	id	char	36
pmse_bpmn_data	id	char	36
pmse_bpmn_diagram	id	char	36
pmse_bpmn_documentation	id	char	36
pmse_bpmn_event	id	char	36
pmse_bpmn_extension	id	char	36
pmse_bpmn_flow	id	char	36
pmse_bpmn_gateway	id	char	36
pmse_bpmn_lane	id	char	36
pmse_bpmn_laneset	id	char	36
pmse_bpmn_participant	id	char	36
pmse_bpmn_process	id	char	36
pmse_business_rules	id	char	36
pmse_emails_templates	id	char	36
pmse_inbox	id	char	36
pmse_project	id	char	36
product_bundle_note	id	varchar	36
product_bundle_notes	id	char	36
product_bundle_product	id	varchar	36
product_bundle_quote	id	varchar	36
product_bundles	id	char	36
product_categories	id	char	36
product_product	id	varchar	36
product_templates	id	char	36
product_templates_audit	id	char	36
product_types	id	char	36
products	id	char	36
products_audit	id	char	36
project	id	char	36
project_resources	id	char	36
project_task	id	char	36
project_task_audit	id	char	36
projects_accounts	id	varchar	36
projects_bugs	id	varchar	36
projects_cases	id	varchar	36
projects_contacts	id	varchar	36
projects_opportunities	id	varchar	36
projects_products	id	varchar	36
projects_quotes	id	varchar	36
projects_revenue_line_items	id	varchar	36
prospect_list_campaigns	id	varchar	36
prospect_lists	id	char	36
prospect_lists_prospects	id	varchar	36
prospects	id	char	36
quotas	id	char	36
quotas_audit	id	char	36
quotes	id	char	36
quotes_accounts	id	varchar	36
quotes_audit	id	char	36
quotes_contacts	id	varchar	36
quotes_opportunities	id	varchar	36
record_list	id	char	36
relationships	id	char	36
releases	id	char	36
report_cache	id	char	36
report_maker	id	char	36
report_schedules	id	char	36
revenue_line_items	id	char	36
revenue_line_items_audit	id	char	36
roles	id	char	36
roles_modules	id	varchar	36
roles_users	id	varchar	36
saved_reports	id	char	36
saved_search	id	char	36
schedulers	id	char	36
schedulers_times	id	char	36
session_active	id	char	36
session_history	id	char	36
shippers	id	char	36
styleguide	id	char	36
subscriptions	id	char	36
sugarfavorites	id	char	36
systems	id	char	36
tasks	id	char	36
taxrates	id	char	36
team_memberships	id	char	36
team_notices	id	char	36
team_sets	id	char	36
team_sets_modules	id	char	36
team_sets_teams	id	char	36
teams	id	char	36
timeperiods	id	char	36
tracker	id	int	11		√
tracker_perf	id	int	11		√
tracker_queries	id	int	11		√
tracker_sessions	id	int	11		√
tracker_tracker_queries	id	int	11		√
upgrade_history	id	char	36
user_preferences	id	char	36
users	id	char	36
users_holidays	id	varchar	36
users_last_import	id	char	36
users_password_link	id	char	36
users_signatures	id	char	36
vcals	id	char	36
versions	id	char	36
weblogichooks	id	char	36
workflow	id	char	36
workflow_actions	id	char	36
workflow_actionshells	id	char	36
workflow_alerts	id	char	36
workflow_alertshells	id	char	36
workflow_schedules	id	char	36
workflow_triggershells	id	char	36
upgrade_history	id_name	varchar	255	√		null
email_cache	ie_id	char	36	√		null
inbound_email_autoreply	ie_id	char	36
inbound_email_cache_ts	ie_timestamp	int unsigned	10	√		null
email_cache	imap_uid	int unsigned	10	√		null
team_memberships	implicit_assign	bit	1	√		0
users_last_import	import_module	varchar	36	√		null
fields_meta_data	importable	varchar	255	√		null
campaigns	impressions	int	11	√		0
emailman	in_queue	bit	1	√		0
emailman	in_queue_date	datetime	19	√		null
email_marketing	inbound_email_id	char	36	√		null
accounts	industry	varchar	50	√		null
systems	install_method	varchar	100	√		null
emails	intent	varchar	100	√		pick
email_addresses	invalid_email	bit	1	√		0
users	is_admin	bit	1	√		0
folders	is_dynamic	bit	1	√		0
kbdocuments	is_external_article	bit	1	√		0
timeperiods	is_fiscal	bit	1	√		0
timeperiods	is_fiscal_year	bit	1	√		0
folders	is_group	bit	1	√		0
users	is_group	bit	1	√		null
campaign_trkrs	is_optout	bit	1	√		0
inbound_email	is_personal	bit	1	√		0
import_maps	is_published	varchar	3	√		no
saved_reports	is_published	bit	1	√		0
notifications	is_read	bit	1	√		0
documents	is_template	bit	1	√		0
kbdocuments	is_template	bit	1	√		0
project	is_template	bit	1	√		0
session_active	is_violation	bit	1	√		0
session_history	is_violation	bit	1	√		0
currencies	iso4217	varchar	3	√		null
tracker	item_id	char	36	√		null
tracker	item_summary	varchar	255	√		null
schedulers	job	varchar	255	√		null
job_queue	job_delay	int	11	√		null
job_queue	job_group	varchar	255	√		null
schedulers	job_interval	varchar	100	√		null
relationships	join_key_lhs	varchar	128	√		null
relationships	join_key_rhs	varchar	128	√		null
relationships	join_table	varchar	128	√		null
meetings	join_url	varchar	600	√		null
kbcontents	kb_index	int	11		√
kbdocument_revisions	kbcontent_id	char	36	√		null
kbdocuments	kbdoc_approver_id	char	36	√		null
kbcontents	kbdocument_body	longtext	2147483647	√		null
kbdocument_revisions	kbdocument_id	char	36	√		null
kbdocuments_kbtags	kbdocument_id	char	36	√		null
kbdocuments_views_ratings	kbdocument_id	varchar	36	√		null
kbdocuments	kbdocument_name	varchar	255	√		null
kbdocuments	kbdocument_revision_id	char	36	√		null
kbdocuments	kbdocument_revision_number	varchar	100	√		null
kbdocuments_kbtags	kbtag_id	char	36	√		null
pdfmanager	keywords	varchar	255	√		null
pmse_bpmn_lane	lan_child_laneset	varchar	36	√
pmse_bpmn_lane	lan_is_horizontal	int	4	√		1
pmse_bpmn_lane	lan_uid	varchar	36	√
activities	last_comment	longtext	2147483647	√		null
systems	last_connect_date	datetime	19	√		null
users	last_login	datetime	19	√		null
contacts	last_name	varchar	100	√		null
leads	last_name	varchar	100	√		null
prospects	last_name	varchar	100	√		null
styleguide	last_name	varchar	100	√		null
users	last_name	varchar	30	√		null
session_active	last_request_time	datetime	19	√		null
session_history	last_request_time	datetime	19	√		null
schedulers	last_run	datetime	19	√		null
kbdocument_revisions	latest	bit	1	√		0
dataset_layouts	layout_type	varchar	25	√		null
calls_leads	lead_id	char	36	√		null
meetings_leads	lead_id	char	36	√		null
prospects	lead_id	char	36	√		null
contacts	lead_source	varchar	255	√		null
forecast_worksheets	lead_source	varchar	50	√		null
leads	lead_source	varchar	100	√		null
opportunities	lead_source	varchar	50	√		null
revenue_line_items	lead_source	varchar	50	√		null
leads	lead_source_description	text	65535	√		null
timeperiods	leaf_cycle	int	2	√		null
fields_meta_data	len	int	11	√		null
expressions	lhs_field	varchar	50	√		null
expressions	lhs_group_type	varchar	10	√		null
relationships	lhs_key	varchar	64	√		null
expressions	lhs_module	varchar	50	√		null
relationships	lhs_module	varchar	100	√		null
relationships	lhs_table	varchar	64	√		null
expressions	lhs_type	varchar	15	√		null
expressions	lhs_value	varchar	100	√		null
relationships	lhs_vname	varchar	64	√		null
forecast_manager_worksheets	likely_case	decimal	26,6	√		null
forecast_worksheets	likely_case	decimal	26,6	√		null
forecasts	likely_case	decimal	26,6	√		null
revenue_line_items	likely_case	decimal	26,6	√		null
forecast_manager_worksheets	likely_case_adjusted	decimal	26,6	√		null
address_book_list_items	list_id	char	36
campaign_log	list_id	char	36	√		null
emailman	list_id	char	36	√		null
address_book_lists	list_name	varchar	100	√		null
contract_types	list_order	int	4	√		null
custom_queries	list_order	int	4	√		null
manufacturers	list_order	int	4	√		null
product_categories	list_order	int	4	√		null
product_types	list_order	int	4	√		null
releases	list_order	int	4	√		null
shippers	list_order	int	4	√		null
taxrates	list_order	int	4	√		null
dataset_layouts	list_order_x	int	4	√		null
data_sets	list_order_y	int	3	√		0
workflow	list_order_y	int	3	√		0
dataset_layouts	list_order_z	int	4	√		null
forecast_worksheets	list_price	decimal	26,6	√		null
product_templates	list_price	decimal	26,6	√		null
products	list_price	decimal	26,6	√		null
revenue_line_items	list_price	decimal	26,6	√		null
styleguide	list_price	decimal	26,6	√		null
prospect_lists	list_type	varchar	100	√		null
product_templates	list_usdollar	decimal	26,6	√		null
products	list_usdollar	decimal	26,6	√		null
revenue_line_items	list_usdollar	decimal	26,6	√		null
pmse_bpmn_lane	lns_id	varchar	36	√
pmse_bpmn_participant	lns_id	varchar	36	√
pmse_bpmn_laneset	lns_is_horizontal	int	4	√		1
pmse_bpmn_laneset	lns_parent_lane	varchar	36	√
pmse_bpmn_laneset	lns_state	text	65535	√		null
pmse_bpmn_laneset	lns_uid	varchar	36	√
meetings	location	varchar	50	√		null
kbdocuments	mail_merge_document	varchar	3	√		off
outbound_email	mail_sendtype	varchar	8	√		smtp
outbound_email	mail_smtpauth_req	bit	1	√		0
outbound_email	mail_smtppass	varchar	100	√		null
outbound_email	mail_smtpport	int	5	√		0
outbound_email	mail_smtpserver	varchar	100	√		null
outbound_email	mail_smtpssl	int	1	√		0
outbound_email	mail_smtptype	varchar	20	√		other
outbound_email	mail_smtpuser	varchar	100	√		null
inbound_email	mailbox	text	65535	√		null
emails	mailbox_id	char	36	√		null
inbound_email	mailbox_type	varchar	10	√		null
email_cache	mailsize	int unsigned	10	√		null
forecast_manager_worksheets	manager_saved	bit	1	√		0
upgrade_history	manifest	longtext	2147483647	√		null
product_templates	manufacturer_id	char	36	√		null
products	manufacturer_id	char	36	√		null
revenue_line_items	manufacturer_id	char	36	√		null
campaign_log	marketing_id	char	36	√		null
emailman	marketing_id	char	36	√		null
fields_meta_data	massupdate	bit	1	√		0
email_cache	mbox	varchar	60	√		null
upgrade_history	md5sum	varchar	32	√		null
meetings_contacts	meeting_id	char	36	√		null
meetings_leads	meeting_id	char	36	√		null
meetings_users	meeting_id	char	36	√		null
tracker_perf	memory_usage	int	12	√		null
job_queue	message	text	65535	√		null
email_cache	message_id	varchar	255	√		null
emails	message_id	varchar	255	√		null
emails	message_uid	varchar	64	√		null
users	messenger_id	varchar	100	√		null
users	messenger_type	varchar	100	√		null
dashboards	metadata	text	65535	√		null
product_templates	mft_part_num	varchar	50	√		null
products	mft_part_num	varchar	50	√		null
revenue_line_items	mft_part_num	varchar	50	√		null
project_task	milestone_flag	bit	1	√		null
contacts	mkto_id	int	11	√		null
leads	mkto_id	int	11	√		null
opportunities	mkto_id	int	11	√		null
contacts	mkto_lead_score	int	11	√		null
leads	mkto_lead_score	int	11	√		null
contacts	mkto_sync	bit	1	√		0
leads	mkto_sync	bit	1	√		0
opportunities	mkto_sync	bit	1	√		0
folders	modified_by	char	36
accounts	modified_user_id	char	36	√		null
acl_actions	modified_user_id	char	36	√		null
acl_fields	modified_user_id	char	36	√		null
acl_role_sets	modified_user_id	char	36	√		null
acl_roles	modified_user_id	char	36	√		null
activities	modified_user_id	char	36	√		null
bugs	modified_user_id	char	36	√		null
calls	modified_user_id	char	36	√		null
campaign_trkrs	modified_user_id	char	36	√		null
campaigns	modified_user_id	char	36	√		null
cases	modified_user_id	char	36	√		null
comments	modified_user_id	char	36	√		null
contacts	modified_user_id	char	36	√		null
contract_types	modified_user_id	char	36	√		null
contracts	modified_user_id	char	36	√		null
custom_queries	modified_user_id	char	36	√		null
dashboards	modified_user_id	char	36	√		null
data_sets	modified_user_id	char	36	√		null
dataset_attributes	modified_user_id	char	36	√		null
dataset_layouts	modified_user_id	char	36	√		null
documents	modified_user_id	char	36	√		null
eapm	modified_user_id	char	36	√		null
email_marketing	modified_user_id	char	36	√		null
email_templates	modified_user_id	char	36	√		null
emailman	modified_user_id	char	36	√		null
emails	modified_user_id	char	36	√		null
expressions	modified_user_id	char	36	√		null
filters	modified_user_id	char	36	√		null
forecast_manager_worksheets	modified_user_id	char	36	√		null
forecast_worksheets	modified_user_id	char	36	√		null
holidays	modified_user_id	char	36	√		null
inbound_email	modified_user_id	char	36	√		null
kbcontents	modified_user_id	char	36	√		null
kbdocuments	modified_user_id	char	36	√		null
leads	modified_user_id	char	36	√		null
manufacturers	modified_user_id	char	36	√		null
meetings	modified_user_id	char	36	√		null
notes	modified_user_id	char	36	√		null
notifications	modified_user_id	char	36	√		null
oauth_consumer	modified_user_id	char	36	√		null
opportunities	modified_user_id	char	36	√		null
pdfmanager	modified_user_id	char	36	√		null
pmse_bpm_access_management	modified_user_id	char	36	√		null
pmse_bpm_activity_definition	modified_user_id	char	36	√		null
pmse_bpm_activity_step	modified_user_id	char	36	√		null
pmse_bpm_activity_user	modified_user_id	char	36	√		null
pmse_bpm_case_data	modified_user_id	char	36	√		null
pmse_bpm_config	modified_user_id	char	36	√		null
pmse_bpm_dynamic_forms	modified_user_id	char	36	√		null
pmse_bpm_event_definition	modified_user_id	char	36	√		null
pmse_bpm_flow	modified_user_id	char	36	√		null
pmse_bpm_form_action	modified_user_id	char	36	√		null
pmse_bpm_gateway_definition	modified_user_id	char	36	√		null
pmse_bpm_group	modified_user_id	char	36	√		null
pmse_bpm_group_user	modified_user_id	char	36	√		null
pmse_bpm_notes	modified_user_id	char	36	√		null
pmse_bpm_process_definition	modified_user_id	char	36	√		null
pmse_bpm_related_dependency	modified_user_id	char	36	√		null
pmse_bpm_thread	modified_user_id	char	36	√		null
pmse_bpmn_activity	modified_user_id	char	36	√		null
pmse_bpmn_artifact	modified_user_id	char	36	√		null
pmse_bpmn_bound	modified_user_id	char	36	√		null
pmse_bpmn_data	modified_user_id	char	36	√		null
pmse_bpmn_diagram	modified_user_id	char	36	√		null
pmse_bpmn_documentation	modified_user_id	char	36	√		null
pmse_bpmn_event	modified_user_id	char	36	√		null
pmse_bpmn_extension	modified_user_id	char	36	√		null
pmse_bpmn_flow	modified_user_id	char	36	√		null
pmse_bpmn_gateway	modified_user_id	char	36	√		null
pmse_bpmn_lane	modified_user_id	char	36	√		null
pmse_bpmn_laneset	modified_user_id	char	36	√		null
pmse_bpmn_participant	modified_user_id	char	36	√		null
pmse_bpmn_process	modified_user_id	char	36	√		null
pmse_business_rules	modified_user_id	char	36	√		null
pmse_emails_templates	modified_user_id	char	36	√		null
pmse_inbox	modified_user_id	char	36	√		null
pmse_project	modified_user_id	char	36	√		null
product_bundle_notes	modified_user_id	char	36	√		null
product_bundles	modified_user_id	char	36	√		null
product_categories	modified_user_id	char	36	√		null
product_templates	modified_user_id	char	36	√		null
product_types	modified_user_id	char	36	√		null
products	modified_user_id	char	36	√		null
project	modified_user_id	char	36	√		null
project_resources	modified_user_id	char	36	√		null
project_task	modified_user_id	char	36	√		null
prospect_lists	modified_user_id	char	36	√		null
prospects	modified_user_id	char	36	√		null
quotas	modified_user_id	char	36	√		null
quotes	modified_user_id	char	36	√		null
releases	modified_user_id	char	36	√		null
report_maker	modified_user_id	char	36	√		null
revenue_line_items	modified_user_id	char	36	√		null
roles	modified_user_id	char	36	√		null
saved_reports	modified_user_id	char	36	√		null
schedulers	modified_user_id	char	36	√		null
shippers	modified_user_id	char	36
styleguide	modified_user_id	char	36	√		null
subscriptions	modified_user_id	char	36	√		null
sugarfavorites	modified_user_id	char	36	√		null
tasks	modified_user_id	char	36	√		null
taxrates	modified_user_id	char	36	√		null
team_notices	modified_user_id	char	36	√		null
teams	modified_user_id	char	36	√		null
users	modified_user_id	char	36	√		null
users_signatures	modified_user_id	char	36	√		null
versions	modified_user_id	char	36	√		null
weblogichooks	modified_user_id	char	36	√		null
workflow	modified_user_id	char	36	√		null
workflow_actions	modified_user_id	char	36	√		null
workflow_actionshells	modified_user_id	char	36	√		null
workflow_alerts	modified_user_id	char	36	√		null
workflow_alertshells	modified_user_id	char	36	√		null
workflow_schedules	modified_user_id	char	36	√		null
workflow_triggershells	modified_user_id	char	36	√		null
import_maps	module	varchar	36	√		null
saved_reports	module	varchar	255	√		null
sugarfavorites	module	varchar	50	√		null
roles_modules	module_id	varchar	36	√		null
filters	module_name	varchar	100	√		null
record_list	module_name	varchar	50	√		null
tracker	module_name	varchar	255	√		null
team_sets_modules	module_table_name	varchar	128	√		null
roles	modules	text	65535	√		null
tracker	monitor_id	char	36
tracker_perf	monitor_id	char	36
tracker_tracker_queries	monitor_id	char	36	√		null
campaign_log	more_information	varchar	100	√		null
email_cache	msgno	int unsigned	10	√		null
accounts	name	varchar	150	√		null
acl_actions	name	varchar	150	√		null
acl_fields	name	varchar	150	√		null
acl_role_sets	name	varchar	255	√		null
acl_roles	name	varchar	150	√		null
bugs	name	varchar	255	√		null
calls	name	varchar	50	√		null
campaigns	name	varchar	50	√		null
cases	name	varchar	255	√		null
config	name	varchar	32	√		null
contract_types	name	varchar	30	√		null
contracts	name	varchar	255	√		null
currencies	name	varchar	36	√		null
custom_queries	name	varchar	50	√		null
dashboards	name	varchar	255	√		null
data_sets	name	varchar	50	√		null
eapm	name	varchar	255	√		null
email_marketing	name	varchar	255	√		null
email_templates	name	varchar	255	√		null
emails	name	varchar	255	√		null
fields_meta_data	name	varchar	255	√		null
filters	name	varchar	255	√		null
folders	name	varchar	25	√		null
forecast_manager_worksheets	name	varchar	255	√		null
forecast_tree	name	varchar	50	√		null
forecast_worksheets	name	varchar	255	√		null
import_maps	name	varchar	254	√		null
inbound_email	name	varchar	255	√		null
job_queue	name	varchar	255	√		null
manufacturers	name	varchar	50	√		null
meetings	name	varchar	50	√		null
notes	name	varchar	255	√		null
notifications	name	varchar	255	√		null
oauth_consumer	name	varchar	255	√		null
opportunities	name	varchar	50	√		null
outbound_email	name	varchar	50	√		null
pdfmanager	name	varchar	255	√		null
pmse_bpm_access_management	name	varchar	255	√		null
pmse_bpm_activity_definition	name	varchar	255	√		null
pmse_bpm_activity_step	name	varchar	255	√		null
pmse_bpm_activity_user	name	varchar	255	√		null
pmse_bpm_case_data	name	varchar	255	√		null
pmse_bpm_config	name	varchar	255	√		null
pmse_bpm_dynamic_forms	name	varchar	255	√		null
pmse_bpm_event_definition	name	varchar	255	√		null
pmse_bpm_flow	name	varchar	255	√		null
pmse_bpm_form_action	name	varchar	255	√		null
pmse_bpm_gateway_definition	name	varchar	255	√		null
pmse_bpm_group	name	varchar	255	√		null
pmse_bpm_group_user	name	varchar	255	√		null
pmse_bpm_notes	name	varchar	255	√		null
pmse_bpm_process_definition	name	varchar	255	√		null
pmse_bpm_related_dependency	name	varchar	255	√		null
pmse_bpm_thread	name	varchar	255	√		null
pmse_bpmn_activity	name	varchar	255	√		null
pmse_bpmn_artifact	name	varchar	255	√		null
pmse_bpmn_bound	name	varchar	255	√		null
pmse_bpmn_data	name	varchar	255	√		null
pmse_bpmn_diagram	name	varchar	255	√		null
pmse_bpmn_documentation	name	varchar	255	√		null
pmse_bpmn_event	name	varchar	255	√		null
pmse_bpmn_extension	name	varchar	255	√		null
pmse_bpmn_flow	name	varchar	255	√		null
pmse_bpmn_gateway	name	varchar	255	√		null
pmse_bpmn_lane	name	varchar	255	√		null
pmse_bpmn_laneset	name	varchar	255	√		null
pmse_bpmn_participant	name	varchar	255	√		null
pmse_bpmn_process	name	varchar	255	√		null
pmse_business_rules	name	varchar	255	√		null
pmse_emails_templates	name	varchar	255	√		null
pmse_inbox	name	varchar	255	√		null
pmse_project	name	varchar	255	√		null
product_bundles	name	varchar	255	√		null
product_categories	name	varchar	255	√		null
product_templates	name	varchar	255	√		null
product_types	name	varchar	50	√		null
products	name	varchar	50	√		null
project	name	varchar	50	√		null
project_task	name	varchar	50	√		null
prospect_lists	name	varchar	50	√		null
quotas	name	varchar	255	√		null
quotes	name	varchar	50	√		null
releases	name	varchar	50	√		null
report_maker	name	varchar	50	√		null
revenue_line_items	name	varchar	50	√		null
roles	name	varchar	150	√		null
saved_reports	name	varchar	255	√		null
saved_search	name	varchar	150	√		null
schedulers	name	varchar	255	√		null
shippers	name	varchar	50	√		null
styleguide	name	varchar	255	√		null
sugarfavorites	name	varchar	255	√		null
tasks	name	varchar	50	√		null
taxrates	name	varchar	50	√		null
team_notices	name	varchar	50	√		null
team_sets	name	varchar	128	√		null
teams	name	varchar	128	√		null
timeperiods	name	varchar	36	√		null
upgrade_history	name	varchar	255	√		null
users_signatures	name	varchar	255	√		null
versions	name	varchar	255	√		null
weblogichooks	name	varchar	255	√		null
workflow	name	varchar	50	√		null
workflow_alertshells	name	varchar	50	√		null
teams	name_2	varchar	128	√		null
product_bundles	new_sub	decimal	26,6	√		null
quotes	new_sub	decimal	26,6	√		null
product_bundles	new_sub_usdollar	decimal	26,6	√		null
quotes	new_sub_usdollar	decimal	26,6	√		null
report_schedules	next_run	datetime	19	√		null
forecast_worksheets	next_step	varchar	100	√		null
opportunities	next_step	varchar	100	√		null
products	next_step	varchar	100	√		null
revenue_line_items	next_step	varchar	100	√		null
category_tree	node_id	int	11		√
oauth_nonce	nonce	varchar	32
oauth_nonce	nonce_ts	bigint	20	√		null
pmse_bpm_notes	not_availability	varchar	32	√
pmse_bpm_notes	not_content	text	65535	√		null
pmse_bpm_notes	not_date	datetime	19	√		null
pmse_bpm_notes	not_recipients	text	65535	√		null
pmse_bpm_notes	not_status	varchar	10	√		ACTIVE
pmse_bpm_notes	not_type	varchar	32	√		GENERAL
pmse_bpm_notes	not_user_id	varchar	40	√
pmse_bpm_notes	not_user_recipient_id	varchar	40	√
product_bundle_note	note_id	varchar	36	√		null
product_bundle_note	note_index	int	11	√		0
session_active	num_active_sessions	int	11	√		0
session_history	num_active_sessions	int	11	√		0
systems	num_syncs	int	11	√		0
eapm	oauth_secret	varchar	255	√		null
eapm	oauth_token	varchar	255	√		null
oauth_consumer	oauth_type	varchar	50	√		oauth1
campaigns	objective	text	65535	√		null
expressions	operator	varchar	15	√		null
forecast_manager_worksheets	opp_count	int	5	√		null
forecasts	opp_count	int	5	√		null
forecasts	opp_weigh_value	int	11	√		null
leads	opportunity_amount	varchar	50	√		null
accounts_opportunities	opportunity_id	varchar	36	√		null
contracts_opportunities	opportunity_id	varchar	36	√		null
documents_opportunities	opportunity_id	char	36	√		null
forecast_worksheets	opportunity_id	char	36	√		null
leads	opportunity_id	char	36	√		null
opportunities_contacts	opportunity_id	varchar	36	√		null
products	opportunity_id	char	36	√		null
projects_opportunities	opportunity_id	varchar	36	√		null
quotes_opportunities	opportunity_id	varchar	36	√		null
revenue_line_items	opportunity_id	char	36	√		null
forecast_worksheets	opportunity_name	varchar	255	√		null
leads	opportunity_name	varchar	255	√		null
opportunities	opportunity_type	varchar	255	√		null
email_addresses	opt_out	bit	1	√		0
project_task	order_number	int	11	√		1
quotes	order_stage	varchar	100	√		null
quotes	original_po_date	date	10	√		null
calls	outlook_id	varchar	255	√		null
meetings	outlook_id	varchar	255	√		null
data_sets	output_default	varchar	100	√		null
accounts	ownership	varchar	100	√		null
pmse_bpmn_participant	par_is_horizontal	int	4	√		1
pmse_bpmn_participant	par_maximum	int	4	√		1
pmse_bpmn_participant	par_minimum	int	4	√		0
pmse_bpmn_participant	par_num_participants	int	4	√		1
pmse_bpmn_participant	par_uid	varchar	36	√
workflow_actionshells	parameters	varchar	255	√		null
workflow_schedules	parameters	varchar	255	√		null
workflow_triggershells	parameters	varchar	255	√		null
expressions	parent_exp_id	char	36	√		null
expressions	parent_exp_side	int	8	√		null
folders	parent_folder	char	36	√		null
accounts	parent_id	char	36	√		null
accounts_audit	parent_id	char	36
activities	parent_id	char	36	√		null
activities_users	parent_id	char	36	√		null
bugs_audit	parent_id	char	36
calls	parent_id	char	36	√		null
campaigns_audit	parent_id	char	36
cases_audit	parent_id	char	36
comments	parent_id	char	36
contacts_audit	parent_id	char	36
contracts_audit	parent_id	char	36
data_sets	parent_id	char	36	√		null
dataset_attributes	parent_id	char	36	√		null
dataset_layouts	parent_id	char	36	√		null
emails	parent_id	char	36	√		null
expressions	parent_id	char	36
forecast_manager_worksheets_audit	parent_id	char	36
forecast_tree	parent_id	char	36	√		null
forecast_worksheets	parent_id	char	36	√		null
kbcontents_audit	parent_id	char	36
kbdocuments	parent_id	char	36	√		null
leads_audit	parent_id	char	36
linked_documents	parent_id	varchar	36	√		null
meetings	parent_id	char	36	√		null
notes	parent_id	char	36	√		null
notifications	parent_id	char	36	√		null
notifications_audit	parent_id	char	36
opportunities_audit	parent_id	char	36
product_categories	parent_id	char	36	√		null
product_product	parent_id	varchar	36	√		null
product_templates_audit	parent_id	char	36
products_audit	parent_id	char	36
project_task_audit	parent_id	char	36
quotas_audit	parent_id	char	36
quotes_audit	parent_id	char	36
revenue_line_items_audit	parent_id	char	36
styleguide	parent_id	char	36	√		null
subscriptions	parent_id	char	36
tasks	parent_id	char	36	√		null
timeperiods	parent_id	char	36	√		null
workflow	parent_id	char	36	√		null
workflow_actions	parent_id	char	36
workflow_actionshells	parent_id	char	36
workflow_alerts	parent_id	char	36
workflow_alertshells	parent_id	char	36
workflow_triggershells	parent_id	char	36
category_tree	parent_node_id	int	11	√		0
kbtags	parent_tag_id	char	36	√		null
project_task	parent_task_id	int	11	√		null
activities	parent_type	varchar	100	√		null
activities_users	parent_type	varchar	100	√		null
calls	parent_type	varchar	255	√		null
emails	parent_type	varchar	100	√		null
expressions	parent_type	varchar	255	√		null
forecast_worksheets	parent_type	varchar	255	√		null
kbdocuments	parent_type	varchar	255	√		null
linked_documents	parent_type	varchar	25	√		null
meetings	parent_type	varchar	100	√		null
notes	parent_type	varchar	255	√		null
notifications	parent_type	varchar	100	√		null
styleguide	parent_type	varchar	255	√		null
subscriptions	parent_type	varchar	100	√		null
tasks	parent_type	varchar	255	√		null
dataset_layouts	parent_value	varchar	50	√		null
eapm	password	varchar	255	√		null
meetings	password	varchar	50	√		null
upgrade_history	patch	text	65535	√		null
quotes	payment_terms	varchar	128	√		null
job_queue	percent_complete	int	11	√		null
project_task	percent_complete	int	11	√		null
holidays	person_id	char	36	√		null
holidays	person_type	varchar	255	√		null
accounts	phone_alternate	varchar	100	√		null
accounts	phone_fax	varchar	100	√		null
contacts	phone_fax	varchar	100	√		null
leads	phone_fax	varchar	100	√		null
prospects	phone_fax	varchar	100	√		null
styleguide	phone_fax	varchar	100	√		null
users	phone_fax	varchar	50	√		null
contacts	phone_home	varchar	100	√		null
leads	phone_home	varchar	100	√		null
prospects	phone_home	varchar	100	√		null
styleguide	phone_home	varchar	100	√		null
users	phone_home	varchar	50	√		null
contacts	phone_mobile	varchar	100	√		null
leads	phone_mobile	varchar	100	√		null
prospects	phone_mobile	varchar	100	√		null
styleguide	phone_mobile	varchar	100	√		null
users	phone_mobile	varchar	50	√		null
accounts	phone_office	varchar	100	√		null
contacts	phone_other	varchar	100	√		null
leads	phone_other	varchar	100	√		null
prospects	phone_other	varchar	100	√		null
styleguide	phone_other	varchar	100	√		null
users	phone_other	varchar	50	√		null
contacts	phone_work	varchar	100	√		null
leads	phone_work	varchar	100	√		null
prospects	phone_work	varchar	100	√		null
styleguide	phone_work	varchar	100	√		null
users	phone_work	varchar	50	√		null
contacts	picture	varchar	255	√		null
leads	picture	varchar	255	√		null
prospects	picture	varchar	255	√		null
styleguide	picture	varchar	255	√		null
users	picture	varchar	255	√		null
forecast_manager_worksheets	pipeline_amount	decimal	26,6	√		0.000000
forecasts	pipeline_amount	decimal	26,6	√		0.000000
forecast_manager_worksheets	pipeline_opp_count	int	5	√		0
forecasts	pipeline_opp_count	int	5	√		0
config	platform	varchar	32	√		null
oauth_tokens	platform	varchar	255	√		base
folders_rel	polymorphic_id	char	36
folders_rel	polymorphic_module	varchar	25	√		null
inbound_email	port	int	5	√		null
contacts	portal_active	bit	1	√		0
contacts	portal_app	varchar	255	√		null
leads	portal_app	varchar	255	√		null
notes	portal_flag	bit	1	√		0
contacts	portal_name	varchar	255	√		null
leads	portal_name	varchar	255	√		null
users	portal_only	bit	1	√		0
contacts	portal_password	varchar	255	√		null
bugs	portal_viewable	bit	1	√		0
cases	portal_viewable	bit	1	√		0
project_task	predecessors	text	65535	√		null
contacts	preferred_language	varchar	255	√		null
leads	preferred_language	varchar	255	√		null
users	preferred_language	varchar	255	√		null
data_sets	prespace_y	varchar	3	√		0
product_templates	pricing_factor	decimal	8,2	√		null
products	pricing_factor	int	4	√		null
revenue_line_items	pricing_factor	int	4	√		null
product_templates	pricing_formula	varchar	100	√		null
products	pricing_formula	varchar	100	√		null
revenue_line_items	pricing_formula	varchar	100	√		null
accounts_contacts	primary_account	bit	1	√		0
email_addr_bean_rel	primary_address	bit	1	√		0
contacts	primary_address_city	varchar	100	√		null
leads	primary_address_city	varchar	100	√		null
prospects	primary_address_city	varchar	100	√		null
styleguide	primary_address_city	varchar	100	√		null
contacts	primary_address_country	varchar	255	√		null
leads	primary_address_country	varchar	255	√		null
prospects	primary_address_country	varchar	255	√		null
styleguide	primary_address_country	varchar	255	√		null
contacts	primary_address_postalcode	varchar	20	√		null
leads	primary_address_postalcode	varchar	20	√		null
prospects	primary_address_postalcode	varchar	20	√		null
styleguide	primary_address_postalcode	varchar	20	√		null
contacts	primary_address_state	varchar	100	√		null
leads	primary_address_state	varchar	100	√		null
prospects	primary_address_state	varchar	100	√		null
styleguide	primary_address_state	varchar	100	√		null
contacts	primary_address_street	varchar	150	√		null
leads	primary_address_street	varchar	150	√		null
prospects	primary_address_street	varchar	150	√		null
styleguide	primary_address_street	varchar	150	√		null
bugs	priority	varchar	100	√		null
cases	priority	varchar	100	√		null
project	priority	varchar	255	√		null
project_task	priority	varchar	255	√		null
tasks	priority	varchar	100	√		null
teams	private	bit	1	√		0
pmse_project	prj_author	varchar	255	√		null
pmse_project	prj_author_version	varchar	255	√		null
pmse_project	prj_exporter	varchar	255	√		null
pmse_project	prj_exporter_version	varchar	255	√		null
pmse_project	prj_expression_language	varchar	255	√		null
pmse_bpm_dynamic_forms	prj_id	varchar	36	√
pmse_bpm_event_definition	prj_id	varchar	36	√
pmse_bpm_gateway_definition	prj_id	varchar	36	√
pmse_bpm_process_definition	prj_id	varchar	36	√
pmse_bpm_related_dependency	prj_id	varchar	36	√
pmse_bpmn_activity	prj_id	varchar	36	√
pmse_bpmn_artifact	prj_id	varchar	36	√
pmse_bpmn_bound	prj_id	varchar	36	√
pmse_bpmn_data	prj_id	varchar	36	√
pmse_bpmn_diagram	prj_id	varchar	36	√
pmse_bpmn_documentation	prj_id	varchar	36	√
pmse_bpmn_event	prj_id	varchar	36	√
pmse_bpmn_extension	prj_id	varchar	36	√
pmse_bpmn_flow	prj_id	varchar	36	√
pmse_bpmn_gateway	prj_id	varchar	36	√
pmse_bpmn_lane	prj_id	varchar	36	√
pmse_bpmn_laneset	prj_id	varchar	36	√
pmse_bpmn_participant	prj_id	varchar	36	√
pmse_bpmn_process	prj_id	varchar	36	√
pmse_project	prj_module	varchar	100	√		null
pmse_project	prj_original_source	varchar	255	√		null
pmse_project	prj_status	varchar	10	√		INACTIVE
pmse_project	prj_target_namespace	varchar	255	√		null
pmse_project	prj_type_language	varchar	255	√		null
pmse_project	prj_uid	varchar	36	√		null
pmse_bpm_activity_definition	pro_id	varchar	36	√
pmse_bpm_activity_step	pro_id	varchar	36	√
pmse_bpm_activity_user	pro_id	varchar	36	√
pmse_bpm_dynamic_forms	pro_id	varchar	36	√
pmse_bpm_event_definition	pro_id	varchar	36	√
pmse_bpm_flow	pro_id	varchar	36	√
pmse_bpm_form_action	pro_id	varchar	36	√
pmse_bpm_gateway_definition	pro_id	varchar	36	√
pmse_bpm_related_dependency	pro_id	varchar	36	√
pmse_bpmn_activity	pro_id	varchar	36	√
pmse_bpmn_artifact	pro_id	varchar	36	√
pmse_bpmn_data	pro_id	varchar	36	√
pmse_bpmn_event	pro_id	varchar	36	√
pmse_bpmn_gateway	pro_id	varchar	36	√
pmse_bpmn_laneset	pro_id	varchar	36	√
pmse_bpmn_participant	pro_id	varchar	36	√
pmse_inbox	pro_id	varchar	36	√		null
pmse_bpmn_process	pro_is_closed	int	4	√		0
pmse_bpmn_process	pro_is_executable	int	4	√		0
pmse_bpmn_process	pro_is_subprocess	int	4	√		0
pmse_bpm_process_definition	pro_locked_variables	text	65535	√		null
pmse_bpm_related_dependency	pro_locked_variables	text	65535	√		null
pmse_bpm_process_definition	pro_module	varchar	255	√
pmse_bpm_related_dependency	pro_module	varchar	36	√
pmse_bpm_process_definition	pro_status	varchar	255	√
pmse_bpm_related_dependency	pro_status	varchar	36	√
pmse_bpm_process_definition	pro_terminate_variables	text	65535	√		null
pmse_bpm_related_dependency	pro_terminate_variables	text	65535	√		null
pmse_inbox	pro_title	varchar	255	√		null
pmse_bpmn_process	pro_type	varchar	10	√		NONE
pmse_bpmn_process	pro_uid	varchar	36	√
forecast_worksheets	probability	double	22	√		null
opportunities	probability	double	22	√		null
revenue_line_items	probability	double	22	√		null
fts_queue	processed	bit	1	√		0
bugs	product_category	varchar	255	√		null
contracts_products	product_id	varchar	36	√		null
documents_products	product_id	char	36	√		null
product_bundle_product	product_id	varchar	36	√		null
projects_products	product_id	varchar	36	√		null
product_bundle_product	product_index	int	11	√		0
forecast_worksheets	product_template_id	char	36	√		null
products	product_template_id	char	36	√		null
revenue_line_items	product_template_id	char	36	√		null
forecast_worksheets	product_template_name	varchar	255	√		null
forecast_worksheets	product_type	varchar	255	√		null
revenue_line_items	product_type	varchar	255	√		null
project_resources	project_id	char	36	√		null
project_task	project_id	char	36
projects_accounts	project_id	varchar	36	√		null
projects_bugs	project_id	varchar	36	√		null
projects_cases	project_id	varchar	36	√		null
projects_contacts	project_id	varchar	36	√		null
projects_opportunities	project_id	varchar	36	√		null
projects_products	project_id	varchar	36	√		null
projects_quotes	project_id	varchar	36	√		null
projects_revenue_line_items	project_id	varchar	36	√		null
project_task	project_task_id	int	11	√		null
email_marketing_prospect_lists	prospect_list_id	varchar	36	√		null
prospect_list_campaigns	prospect_list_id	varchar	36	√		null
prospect_lists_prospects	prospect_list_id	varchar	36	√		null
email_templates	published	varchar	3	√		null
pdfmanager	published	varchar	100	√		yes
pmse_emails_templates	published	varchar	3	√		null
quotes	purchase_order_num	varchar	50	√		null
users	pwd_last_changed	datetime	19	√		null
product_templates	qty_in_stock	int	5	√		null
forecast_worksheets	quantity	int	5	√		1
products	quantity	decimal	12,2	√		1.00
revenue_line_items	quantity	decimal	12,2	√		1.00
tracker_queries	query_hash	varchar	36	√		null
data_sets	query_id	char	36
tracker_queries	query_id	char	36
tracker_tracker_queries	query_id	char	36	√		null
custom_queries	query_locked	varchar	3	√		0
custom_queries	query_type	varchar	50	√		null
forecast_manager_worksheets	quota	decimal	26,6	√		null
quotas	quota_type	varchar	100	√		null
contracts_quotes	quote_id	varchar	36	√		null
documents_quotes	quote_id	varchar	36	√		null
product_bundle_quote	quote_id	varchar	36	√		null
products	quote_id	char	36	√		null
projects_quotes	quote_id	varchar	36	√		null
quotes_accounts	quote_id	varchar	36	√		null
quotes_contacts	quote_id	varchar	36	√		null
quotes_opportunities	quote_id	varchar	36	√		null
revenue_line_items	quote_id	char	36	√		null
quotes	quote_num	int	11		√
quotes	quote_stage	varchar	100	√		null
quotes	quote_type	varchar	100	√		null
styleguide	radio_button_group	varchar	255	√		null
users_feeds	rank	int	11	√		null
accounts	rating	varchar	100	√		null
kbdocuments_views_ratings	ratings_number	int	11	√		0
emails_text	raw_source	longtext	2147483647	√		null
users	receive_notifications	bit	1	√		1
email_cache	recent	tinyint	4	√		null
sugarfavorites	record_id	varchar	36	√		null
workflow	record_type	varchar	100	√		null
record_list	records	longtext	2147483647	√		null
calls	recurring_source	varchar	36	√		null
meetings	recurring_source	varchar	36	√		null
campaigns	refer_url	varchar	255	√		http://
leads	refered_by	varchar	100	√		null
contracts	reference_code	varchar	255	√		null
pmse_bpm_related_dependency	rel_element_id	varchar	40	√
pmse_bpm_related_dependency	rel_element_module	varchar	32	√
pmse_bpm_related_dependency	rel_element_relationship	varchar	32	√
pmse_bpm_related_dependency	rel_element_type	varchar	32	√
workflow_alerts	rel_email_value	varchar	50	√		null
workflow_actionshells	rel_module	varchar	50	√		null
workflow_triggershells	rel_module	varchar	255	√		null
workflow_alerts	rel_module1	varchar	255	√		null
workflow_alerts	rel_module1_type	varchar	10	√		null
workflow_alerts	rel_module2	varchar	255	√		null
workflow_alerts	rel_module2_type	varchar	10	√		null
workflow_actionshells	rel_module_type	varchar	10	√		null
workflow_triggershells	rel_module_type	varchar	10	√		null
pmse_bpm_related_dependency	rel_process_module	varchar	32	√
workflow_alerts	relate_type	varchar	100	√		null
documents	related_doc_id	char	36	√		null
kbdocuments	related_doc_id	char	36	√		null
documents	related_doc_rev_id	char	36	√		null
kbdocuments	related_doc_rev_id	char	36	√		null
campaign_log	related_id	char	36	√		null
emailman	related_id	char	36	√		null
prospect_lists_prospects	related_id	varchar	36	√		null
holidays	related_module	varchar	255	√		null
holidays	related_module_id	char	36	√		null
campaign_log	related_type	varchar	100	√		null
emailman	related_type	varchar	100	√		null
prospect_lists_prospects	related_type	varchar	25	√		null
relationships	relationship_name	varchar	150	√		null
relationships	relationship_role_column	varchar	64	√		null
relationships	relationship_role_column_value	varchar	50	√		null
relationships	relationship_type	varchar	64	√		null
calls	reminder_time	int	11	√		-1
meetings	reminder_time	int	11	√		-1
calls	repeat_count	int	7	√		null
meetings	repeat_count	int	7	√		null
calls	repeat_dow	varchar	7	√		null
meetings	repeat_dow	varchar	7	√		null
calls	repeat_interval	int	3	√		1
meetings	repeat_interval	int	3	√		1
calls	repeat_parent_id	char	36	√		null
meetings	repeat_parent_id	char	36	√		null
calls	repeat_type	varchar	36	√		null
meetings	repeat_type	varchar	36	√		null
calls	repeat_until	date	10	√		null
meetings	repeat_until	date	10	√		null
email_marketing	reply_to_addr	varchar	100	√		null
emails_text	reply_to_addr	varchar	255	√		null
email_addr_bean_rel	reply_to_address	bit	1	√		0
email_marketing	reply_to_name	varchar	100	√		null
emails	reply_to_status	bit	1	√		null
report_maker	report_align	varchar	8	√		null
data_sets	report_id	char	36	√		null
report_schedules	report_id	char	36	√		null
report_cache	report_options	text	65535	√		null
saved_reports	report_type	varchar	255	√		null
fields_meta_data	reportable	bit	1	√		1
contacts	reports_to_id	char	36	√		null
leads	reports_to_id	char	36	√		null
users	reports_to_id	char	36	√		null
weblogichooks	request_method	varchar	255	√		POST
job_queue	requeue	bit	1	√		0
calls_contacts	required	varchar	1	√		1
calls_leads	required	varchar	1	√		1
calls_users	required	varchar	1	√		1
fields_meta_data	required	bit	1	√		0
meetings_contacts	required	varchar	1	√		1
meetings_leads	required	varchar	1	√		1
meetings_users	required	varchar	1	√		1
bugs	resolution	varchar	255	√		null
cases	resolution	text	65535	√		null
job_queue	resolution	varchar	20	√		null
project_resources	resource_id	char	36	√		null
project_task	resource_id	text	65535	√		null
holidays	resource_name	varchar	255	√		null
project_resources	resource_type	varchar	20	√		null
job_queue	retry_count	tinyint	4	√		null
products	revenuelineitem_id	char	36	√		null
relationships	reverse	bit	1	√		0
document_revisions	revision	varchar	100	√		null
kbdocument_revisions	revision	varchar	100	√		null
kbdocuments_kbtags	revision	varchar	100	√		null
kbtags	revision	varchar	100	√		null
expressions	rhs_field	varchar	50	√		null
expressions	rhs_group_type	varchar	10	√		null
relationships	rhs_key	varchar	64	√		null
expressions	rhs_module	varchar	50	√		null
relationships	rhs_module	varchar	100	√		null
relationships	rhs_table	varchar	64	√		null
expressions	rhs_type	varchar	15	√		null
expressions	rhs_value	varchar	255	√		null
relationships	rhs_vname	varchar	64	√		null
documents_revenuelineitems	rli_id	varchar	36	√		null
projects_revenue_line_items	rli_id	varchar	36	√		null
acl_fields	role_id	char	36
acl_roles_actions	role_id	varchar	36	√		null
acl_roles_users	role_id	varchar	36	√		null
roles_modules	role_id	varchar	36	√		null
roles_users	role_id	varchar	36	√		null
kbtags	root_tag	bit	1	√		0
tracker_sessions	round_trips	int	5	√		null
dataset_layouts	row_header_id	varchar	36	√		null
pmse_business_rules	rst_create_date	datetime	19	√		null
pmse_business_rules	rst_definition	text	65535	√		null
pmse_business_rules	rst_editable	int	4	√		0
pmse_business_rules	rst_filename	varchar	255	√		null
pmse_business_rules	rst_module	varchar	100	√		null
pmse_business_rules	rst_source	varchar	255	√		null
pmse_business_rules	rst_source_definition	text	65535	√		null
pmse_business_rules	rst_type	varchar	100	√		single
pmse_business_rules	rst_uid	varchar	36	√		null
pmse_business_rules	rst_update_date	datetime	19	√		null
tracker_queries	run_count	int	6	√		null
forecast_worksheets	sales_stage	varchar	255	√		null
opportunities	sales_stage	varchar	255	√		Prospecting
revenue_line_items	sales_stage	varchar	255	√		Prospecting
forecast_worksheets	sales_status	varchar	255	√		null
opportunities	sales_status	varchar	255	√		null
contacts	salutation	varchar	255	√		null
leads	salutation	varchar	255	√		null
prospects	salutation	varchar	255	√		null
styleguide	salutation	varchar	255	√		null
report_schedules	schedule_type	varchar	3	√		null
saved_reports	schedule_type	varchar	3	√		pro
report_maker	scheduled	bit	1	√		0
job_queue	scheduler_id	char	36	√		null
schedulers_times	scheduler_id	char	36
saved_search	search_module	varchar	150	√		null
tracker_queries	sec_avg	double	22	√		null
tracker_queries	sec_total	double	22	√		null
tracker_sessions	seconds	int	9	√		0
oauth_tokens	secret	varchar	32	√		null
styleguide	secret_password	varchar	255	√		null
email_cache	seen	tinyint	4	√		null
category_tree	self_id	char	36	√		null
emailman	send_attempts	int	11	√		0
emailman	send_date_time	datetime	19	√		null
email_cache	senddate	datetime	19	√		null
meetings	sequence	int	11	√		0
products	serial_number	varchar	50	√		null
revenue_line_items	serial_number	varchar	50	√		null
tracker_perf	server_response_time	double	22	√		null
inbound_email	server_url	varchar	100	√		null
inbound_email	service	varchar	50	√		null
session_active	session_id	varchar	100	√		null
session_history	session_id	varchar	100	√		null
tracker	session_id	varchar	36	√		null
tracker_sessions	session_id	varchar	36	√		null
session_active	session_type	varchar	100	√		null
session_history	session_type	varchar	100	√		null
custom_fields	set_num	int	11	√		0
workflow_actions	set_type	varchar	10	√		null
notifications	severity	varchar	15	√		null
quotes	shipper_id	char	36	√		null
product_bundles	shipping	decimal	26,6	√		null
quotes	shipping	decimal	26,6	√		null
accounts	shipping_address_city	varchar	100	√		null
quotes	shipping_address_city	varchar	100	√		null
accounts	shipping_address_country	varchar	255	√		null
quotes	shipping_address_country	varchar	100	√		null
accounts	shipping_address_postalcode	varchar	20	√		null
quotes	shipping_address_postalcode	varchar	20	√		null
accounts	shipping_address_state	varchar	100	√		null
quotes	shipping_address_state	varchar	100	√		null
accounts	shipping_address_street	varchar	150	√		null
quotes	shipping_address_street	varchar	150	√		null
product_bundles	shipping_usdollar	decimal	26,6	√		null
quotes	shipping_usdollar	decimal	26,6	√		null
quotes	show_line_nums	bit	1	√		1
users	show_on_employees	bit	1	√		1
workflow_triggershells	show_past	bit	1	√		0
accounts	sic_code	varchar	10	√		null
users_signatures	signature	text	65535	√		null
users_signatures	signature_html	text	65535	√		null
dataset_attributes	size_type	varchar	3	√		null
bugs	source	varchar	255	√		null
cases	source	varchar	255	√		null
import_maps	source	varchar	36	√		null
vcals	source	varchar	100	√		null
workflow_alertshells	source_type	varchar	100	√		null
campaigns	start_date	date	10	√		null
contracts	start_date	date	10	√		null
timeperiods	start_date	date	10	√		null
timeperiods	start_date_timestamp	int	14	√		null
bugs	status	varchar	100	√		null
calls	status	varchar	100	√		Planned
campaigns	status	varchar	100	√		null
cases	status	varchar	100	√		null
contracts	status	varchar	100	√		null
currencies	status	varchar	100	√		null
email_marketing	status	varchar	100	√		null
emails	status	varchar	100	√		null
inbound_email	status	varchar	100	√		Active
job_queue	status	varchar	20	√		null
leads	status	varchar	100	√		null
manufacturers	status	varchar	100	√		null
meetings	status	varchar	100	√		Planned
product_templates	status	varchar	100	√		null
products	status	varchar	100	√
project	status	varchar	255	√		null
project_task	status	varchar	255	√		null
releases	status	varchar	100	√		null
revenue_line_items	status	varchar	100	√
schedulers	status	varchar	100	√		null
schedulers_times	status	varchar	25	√		ready
shippers	status	varchar	100	√		null
systems	status	varchar	255	√		Active
tasks	status	varchar	100	√		Not Started
taxrates	status	varchar	100	√		null
team_notices	status	varchar	100	√		null
upgrade_history	status	varchar	50	√		null
users	status	varchar	100	√		null
workflow	status	bit	1	√		0
leads	status_description	text	65535	√		null
documents	status_id	varchar	100	√		null
kbdocuments	status_id	varchar	100	√		null
inbound_email	stored_options	text	65535	√		null
dataset_attributes	style	varchar	25	√		null
documents	subcategory_id	varchar	100	√		null
email_cache	subject	varchar	255	√		null
email_templates	subject	varchar	255	√		null
pdfmanager	subject	varchar	255	√		null
pmse_emails_templates	subject	varchar	255	√		null
product_bundles	subtotal	decimal	26,6	√		null
products	subtotal	decimal	26,6	√		null
quotes	subtotal	decimal	26,6	√		null
product_bundles	subtotal_usdollar	decimal	26,6	√		null
quotes	subtotal_usdollar	decimal	26,6	√		null
users	sugar_login	bit	1	√		1
product_templates	support_contact	varchar	50	√		null
products	support_contact	varchar	50	√		null
revenue_line_items	support_contact	varchar	50	√		null
product_templates	support_description	varchar	255	√		null
products	support_description	varchar	255	√		null
revenue_line_items	support_description	varchar	255	√		null
product_templates	support_name	varchar	50	√		null
products	support_name	varchar	50	√		null
revenue_line_items	support_name	varchar	50	√		null
product_templates	support_term	varchar	100	√		null
products	support_term	varchar	100	√		null
revenue_line_items	support_term	varchar	100	√		null
currencies	symbol	varchar	36	√		null
users	system_generated_password	bit	1	√		null
bugs	system_id	int	11	√		null
cases	system_id	int	11	√		null
quotes	system_id	int	11	√		null
systems	system_id	int	11		√
systems	system_key	varchar	36	√		null
systems	system_name	varchar	100	√		null
data_sets	table_width	varchar	3	√		0
data_sets	table_width_type	varchar	3	√		null
kbtags	tag_name	varchar	255	√		null
job_queue	target	varchar	255	√		null
campaign_log	target_id	char	36	√		null
workflow_schedules	target_module	varchar	50	√		null
campaign_log	target_tracker_key	varchar	36	√		null
campaign_log	target_type	varchar	100	√		null
project_task	task_number	int	11	√		null
product_bundles	tax	decimal	26,6	√		null
quotes	tax	decimal	26,6	√		null
product_templates	tax_class	varchar	100	√		null
products	tax_class	varchar	100	√		null
revenue_line_items	tax_class	varchar	100	√		null
product_bundles	tax_usdollar	decimal	26,6	√		null
quotes	tax_usdollar	decimal	26,6	√		null
product_bundles	taxrate_id	char	36	√		null
quotes	taxrate_id	char	36	√		null
team_sets	team_count	int	11	√		0
accounts	team_id	char	36	√		null
bugs	team_id	char	36	√		null
calls	team_id	char	36	√		null
campaigns	team_id	char	36	√		null
cases	team_id	char	36	√		null
contacts	team_id	char	36	√		null
contracts	team_id	char	36	√		null
custom_queries	team_id	char	36	√		null
data_sets	team_id	char	36	√		null
documents	team_id	char	36	√		null
email_templates	team_id	char	36	√		null
emails	team_id	char	36	√		null
filters	team_id	char	36	√		null
folders	team_id	char	36	√		null
forecast_manager_worksheets	team_id	char	36	√		null
forecast_worksheets	team_id	char	36	√		null
inbound_email	team_id	char	36	√		null
kbcontents	team_id	char	36	√		null
kbdocuments	team_id	char	36	√		null
kbdocuments_kbtags	team_id	char	36	√		null
kbtags	team_id	char	36	√		null
leads	team_id	char	36	√		null
meetings	team_id	char	36	√		null
notes	team_id	char	36	√		null
opportunities	team_id	char	36	√		null
pdfmanager	team_id	char	36	√		null
pmse_business_rules	team_id	char	36	√		null
pmse_emails_templates	team_id	char	36	√		null
pmse_inbox	team_id	char	36	√		null
pmse_project	team_id	char	36	√		null
product_bundles	team_id	char	36	√		null
products	team_id	char	36	√		null
project	team_id	char	36	√		null
project_task	team_id	char	36	√		null
prospect_lists	team_id	char	36	√		null
prospects	team_id	char	36	√		null
quotes	team_id	char	36	√		null
report_maker	team_id	char	36	√		null
revenue_line_items	team_id	char	36	√		null
saved_reports	team_id	char	36	√		null
saved_search	team_id	char	36	√		null
tasks	team_id	char	36	√		null
team_memberships	team_id	char	36	√		null
team_notices	team_id	char	36	√		null
team_sets_teams	team_id	char	36	√		null
tracker	team_id	char	36	√		null
team_sets	team_md5	varchar	32	√		null
accounts	team_set_id	char	36	√		null
bugs	team_set_id	char	36	√		null
calls	team_set_id	char	36	√		null
campaigns	team_set_id	char	36	√		null
cases	team_set_id	char	36	√		null
contacts	team_set_id	char	36	√		null
contracts	team_set_id	char	36	√		null
custom_queries	team_set_id	char	36	√		null
data_sets	team_set_id	char	36	√		null
documents	team_set_id	char	36	√		null
email_templates	team_set_id	char	36	√		null
emails	team_set_id	char	36	√		null
filters	team_set_id	char	36	√		null
folders	team_set_id	char	36	√		null
forecast_manager_worksheets	team_set_id	char	36	√		null
forecast_worksheets	team_set_id	char	36	√		null
inbound_email	team_set_id	char	36	√		null
kbcontents	team_set_id	char	36	√		null
kbdocuments	team_set_id	char	36	√		null
kbdocuments_kbtags	team_set_id	char	36	√		null
kbtags	team_set_id	char	36	√		null
leads	team_set_id	char	36	√		null
meetings	team_set_id	char	36	√		null
notes	team_set_id	char	36	√		null
opportunities	team_set_id	char	36	√		null
pdfmanager	team_set_id	char	36	√		null
pmse_business_rules	team_set_id	char	36	√		null
pmse_emails_templates	team_set_id	char	36	√		null
pmse_inbox	team_set_id	char	36	√		null
pmse_project	team_set_id	char	36	√		null
product_bundles	team_set_id	char	36	√		null
products	team_set_id	char	36	√		null
project	team_set_id	char	36	√		null
project_task	team_set_id	char	36	√		null
prospect_lists	team_set_id	char	36	√		null
prospects	team_set_id	char	36	√		null
quotes	team_set_id	char	36	√		null
report_maker	team_set_id	char	36	√		null
revenue_line_items	team_set_id	char	36	√		null
saved_reports	team_set_id	char	36	√		null
saved_search	team_set_id	char	36	√		null
tasks	team_set_id	char	36	√		null
team_notices	team_set_id	char	36	√		null
team_sets_modules	team_set_id	char	36	√		null
team_sets_teams	team_set_id	char	36	√		null
users	team_set_id	char	36	√		null
email_marketing	template_id	char	36
inbound_email	template_id	char	36	√		null
pdfmanager	template_name	varchar	255	√		null
documents	template_type	varchar	100	√		null
kbdocuments	template_type	varchar	100	√		null
tracker_queries	text	text	65535	√		null
email_templates	text_only	bit	1	√		null
pmse_emails_templates	text_only	int	255	√		null
accounts	ticker_symbol	varchar	10	√		null
project_task	time_due	time	8	√		null
project_task	time_finish	int	11	√		null
schedulers	time_from	time	8	√		null
report_schedules	time_interval	int	11	√		null
project_task	time_start	int	11	√		null
schedulers	time_to	time	8	√		null
forecast_manager_worksheets	timeperiod_id	char	36	√		null
forecasts	timeperiod_id	char	36	√		null
quotas	timeperiod_id	char	36	√		null
contacts	title	varchar	100	√		null
leads	title	varchar	100	√		null
pdfmanager	title	varchar	255	√		null
prospects	title	varchar	100	√		null
report_maker	title	varchar	50	√		null
styleguide	title	varchar	255	√		null
users	title	varchar	50	√		null
emails_text	to_addrs	text	65535	√		null
email_cache	toaddr	varchar	255	√		null
oauth_tokens	token_ts	bigint	20	√		null
product_bundles	total	decimal	26,6	√		null
quotes	total	decimal	26,6	√		null
forecast_worksheets	total_amount	decimal	26,6	√		null
products	total_amount	decimal	26,6	√		0.000000
revenue_line_items	total_amount	decimal	26,6	√		null
contracts	total_contract_value	decimal	26,6	√		null
contracts	total_contract_value_usdollar	decimal	26,6	√		null
opportunities	total_revenue_line_items	int	11	√		null
product_bundles	total_usdollar	decimal	26,6	√		null
quotes	total_usdollar	decimal	26,6	√		null
campaigns	tracker_count	int	11	√		0
campaign_trkrs	tracker_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://
weblogichooks	trigger_event	varchar	255	√		null
oauth_tokens	tstate	varchar	1	√		null
accounts	twitter	varchar	100	√		null
contacts	twitter	varchar	100	√		null
leads	twitter	varchar	100	√		null
prospects	twitter	varchar	100	√		null
styleguide	twitter	varchar	100	√		null
bugs	type	varchar	255	√		null
cases	type	varchar	255	√		null
category_tree	type	varchar	36	√		null
contracts	type	varchar	255	√		null
email_templates	type	varchar	255	√		null
emails	type	varchar	100	√		null
fields_meta_data	type	varchar	255	√		null
meetings	type	varchar	255	√		Sugar
metadata_cache	type	varchar	255	√		null
outbound_email	type	varchar	15	√		user
pmse_emails_templates	type	varchar	255	√		null
timeperiods	type	varchar	255	√
upgrade_history	type	varchar	30	√		null
vcals	type	varchar	100	√		null
workflow	type	varchar	100	√		null
workflow_triggershells	type	varchar	100	√		null
product_templates	type_id	char	36	√		null
products	type_id	char	36	√		null
revenue_line_items	type_id	char	36	√		null
eapm	url	varchar	255	√		null
team_notices	url	varchar	255	√		null
weblogichooks	url	varchar	255	√		null
team_notices	url_title	varchar	255	√		null
data_sets	use_prev_header	varchar	3	√		0
workflow_alerts	user_display_type	varchar	100	√		null
styleguide	user_email	varchar	100	√		null
users	user_hash	varchar	255	√		null
acl_roles_users	user_id	varchar	36	√		null
calls_users	user_id	char	36	√		null
contacts_users	user_id	varchar	36	√		null
emailman	user_id	char	36	√		null
forecast_manager_worksheets	user_id	char	36	√		null
forecast_tree	user_id	char	36	√		null
forecasts	user_id	char	36	√		null
meetings_users	user_id	char	36	√		null
outbound_email	user_id	char	36
pmse_bpm_form_action	user_id	varchar	36	√
pmse_bpm_group_user	user_id	varchar	36	√
quotas	user_id	char	36	√		null
report_schedules	user_id	char	36	√		null
roles_users	user_id	varchar	36	√		null
systems	user_id	char	36	√		null
team_memberships	user_id	char	36	√		null
tracker	user_id	char	36	√		null
tracker_sessions	user_id	char	36	√		null
users_feeds	user_id	varchar	36	√		null
users_holidays	user_id	varchar	36	√		null
users_signatures	user_id	char	36	√		null
vcals	user_id	char	36
users	user_name	varchar	60	√		null
workflow_alerts	user_type	varchar	100	√		null
users_password_link	username	varchar	36	√		null
project_task	utilization	int	11	√		100
eapm	validated	bit	1	√		0
config	value	text	65535	√		null
taxrates	value	decimal	7,5	√		null
workflow_actions	value	text	65535	√		null
product_templates	vendor_part_num	varchar	50	√		null
products	vendor_part_num	varchar	50	√		null
revenue_line_items	vendor_part_num	varchar	50	√		null
oauth_tokens	verify	varchar	32	√		null
upgrade_history	version	varchar	64	√		null
dashboards	view_name	varchar	100	√		null
kbdocuments_views_ratings	views_number	int	11	√		0
tracker	visible	bit	1	√		0
fields_meta_data	vname	varchar	255	√		null
weblogichooks	webhook_target_module	varchar	255	√		null
accounts	website	varchar	255	√		null
leads	website	varchar	255	√		null
product_templates	website	varchar	255	√		null
products	website	varchar	255	√		null
revenue_line_items	website	varchar	255	√		null
styleguide	website	varchar	255	√		null
product_templates	weight	decimal	12,2	√		null
products	weight	decimal	12,2	√		null
revenue_line_items	weight	decimal	12,2	√		null
workflow_alerts	where_filter	bit	1	√		0
bugs	work_log	text	65535	√		null
cases	work_log	text	65535	√		null
workflow_schedules	workflow_id	char	36	√		null
forecast_manager_worksheets	worst_case	decimal	26,6	√		null
forecast_worksheets	worst_case	decimal	26,6	√		null
forecasts	worst_case	decimal	26,6	√		null
opportunities	worst_case	decimal	26,6	√		null
revenue_line_items	worst_case	decimal	26,6	√		null
forecast_manager_worksheets	worst_case_adjusted	decimal	26,6	√		null
dataset_attributes	wrap	varchar	3	√		null