a4d57d3a contains 4383 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default
accounts	account_type	varchar	50	√		null
accounts	acl_team_set_id	char	36	√		null
accounts	annual_revenue	varchar	100	√		null
accounts	assigned_user_id	char	36	√		null
accounts	billing_address_city	varchar	100	√		null
accounts	billing_address_country	varchar	255	√		null
accounts	billing_address_postalcode	varchar	20	√		null
accounts	billing_address_state	varchar	100	√		null
accounts	billing_address_street	varchar	150	√		null
accounts	business_center_id	char	36	√		null
accounts	campaign_id	char	36	√		null
accounts	created_by	char	36	√		null
accounts	date_entered	datetime	19	√		null
accounts	date_modified	datetime	19	√		null
accounts	deleted	bit	1	√		0
accounts	description	text	65535	√		null
accounts	duns_num	varchar	15	√		null
accounts	employees	varchar	10	√		null
accounts	facebook	varchar	100	√		null
accounts	googleplus	varchar	100	√		null
accounts	id	char	36
accounts	industry	varchar	50	√		null
accounts	modified_user_id	char	36	√		null
accounts	name	varchar	255	√		null
accounts	next_renewal_date	date	10	√		null
accounts	ownership	varchar	100	√		null
accounts	parent_id	char	36	√		null
accounts	phone_alternate	varchar	100	√		null
accounts	phone_fax	varchar	100	√		null
accounts	phone_office	varchar	100	√		null
accounts	rating	varchar	100	√		null
accounts	service_level	varchar	255	√		null
accounts	shipping_address_city	varchar	100	√		null
accounts	shipping_address_country	varchar	255	√		null
accounts	shipping_address_postalcode	varchar	20	√		null
accounts	shipping_address_state	varchar	100	√		null
accounts	shipping_address_street	varchar	150	√		null
accounts	sic_code	varchar	10	√		null
accounts	sync_key	varchar	100	√		null
accounts	team_id	char	36	√		null
accounts	team_set_id	char	36	√		null
accounts	ticker_symbol	varchar	10	√		null
accounts	twitter	varchar	100	√		null
accounts	website	varchar	255	√		null
accounts_audit	after_value_string	varchar	255	√		null
accounts_audit	after_value_text	text	65535	√		null
accounts_audit	before_value_string	varchar	255	√		null
accounts_audit	before_value_text	text	65535	√		null
accounts_audit	created_by	char	36	√		null
accounts_audit	data_type	varchar	100	√		null
accounts_audit	date_created	datetime	19	√		null
accounts_audit	date_updated	datetime	19	√		null
accounts_audit	event_id	char	36
accounts_audit	field_name	varchar	100	√		null
accounts_audit	id	char	36
accounts_audit	parent_id	char	36
accounts_bugs	account_id	char	36	√		null
accounts_bugs	bug_id	char	36	√		null
accounts_bugs	date_modified	datetime	19	√		null
accounts_bugs	deleted	bit	1	√		0
accounts_bugs	id	char	36
accounts_cases	account_id	char	36	√		null
accounts_cases	case_id	char	36	√		null
accounts_cases	date_modified	datetime	19	√		null
accounts_cases	deleted	bit	1	√		0
accounts_cases	id	char	36
accounts_contacts	account_id	char	36	√		null
accounts_contacts	contact_id	char	36	√		null
accounts_contacts	date_modified	datetime	19	√		null
accounts_contacts	deleted	bit	1	√		0
accounts_contacts	id	char	36
accounts_contacts	primary_account	bit	1	√		0
accounts_dataprivacy	account_id	char	36	√		null
accounts_dataprivacy	dataprivacy_id	char	36	√		null
accounts_dataprivacy	date_modified	datetime	19	√		null
accounts_dataprivacy	deleted	bit	1	√		0
accounts_dataprivacy	id	char	36
accounts_opportunities	account_id	char	36	√		null
accounts_opportunities	date_modified	datetime	19	√		null
accounts_opportunities	deleted	bit	1	√		0
accounts_opportunities	id	char	36
accounts_opportunities	opportunity_id	char	36	√		null
accounts_purchases	account_id	char	36	√		null
accounts_purchases	date_modified	datetime	19	√		null
accounts_purchases	deleted	bit	1	√		0
accounts_purchases	id	char	36
accounts_purchases	purchase_id	char	36	√		null
acl_actions	aclaccess	int	3	√		null
acl_actions	acltype	varchar	100	√		null
acl_actions	category	varchar	100	√		null
acl_actions	created_by	char	36	√		null
acl_actions	date_entered	datetime	19	√		null
acl_actions	date_modified	datetime	19	√		null
acl_actions	deleted	bit	1	√		0
acl_actions	id	char	36
acl_actions	modified_user_id	char	36	√		null
acl_actions	name	varchar	150	√		null
acl_fields	aclaccess	int	3	√		null
acl_fields	category	varchar	100	√		null
acl_fields	created_by	char	36	√		null
acl_fields	date_entered	datetime	19	√		null
acl_fields	date_modified	datetime	19	√		null
acl_fields	deleted	bit	1	√		0
acl_fields	id	char	36
acl_fields	modified_user_id	char	36	√		null
acl_fields	name	varchar	150	√		null
acl_fields	role_id	char	36
acl_role_sets	created_by	char	36	√		null
acl_role_sets	date_entered	datetime	19	√		null
acl_role_sets	date_modified	datetime	19	√		null
acl_role_sets	deleted	bit	1	√		0
acl_role_sets	description	text	65535	√		null
acl_role_sets	hash	varchar	32	√		null
acl_role_sets	id	char	36
acl_role_sets	modified_user_id	char	36	√		null
acl_role_sets	name	varchar	255	√		null
acl_role_sets	sync_key	varchar	100	√		null
acl_role_sets_acl_roles	acl_role_id	char	36	√		null
acl_role_sets_acl_roles	acl_role_set_id	char	36	√		null
acl_role_sets_acl_roles	date_modified	datetime	19	√		null
acl_role_sets_acl_roles	deleted	bit	1	√		0
acl_role_sets_acl_roles	id	char	36
acl_roles	created_by	char	36	√		null
acl_roles	date_entered	datetime	19	√		null
acl_roles	date_modified	datetime	19	√		null
acl_roles	deleted	bit	1	√		0
acl_roles	description	text	65535	√		null
acl_roles	id	char	36
acl_roles	modified_user_id	char	36	√		null
acl_roles	name	varchar	150	√		null
acl_roles_actions	access_override	int	3	√		null
acl_roles_actions	action_id	char	36	√		null
acl_roles_actions	date_modified	datetime	19	√		null
acl_roles_actions	deleted	bit	1	√		0
acl_roles_actions	id	char	36
acl_roles_actions	role_id	char	36	√		null
acl_roles_users	date_modified	datetime	19	√		null
acl_roles_users	deleted	bit	1	√		0
acl_roles_users	id	char	36
acl_roles_users	role_id	char	36	√		null
acl_roles_users	user_id	char	36	√		null
activities	activity_type	varchar	100	√		null
activities	comment_count	int	11	√		0
activities	created_by	char	36	√		null
activities	data	longtext	2147483647	√		null
activities	date_entered	datetime	19	√		null
activities	date_modified	datetime	19	√		null
activities	deleted	bit	1	√		0
activities	id	char	36
activities	last_comment	longtext	2147483647	√		null
activities	modified_user_id	char	36	√		null
activities	parent_id	char	36	√		null
activities	parent_type	varchar	100	√		null
activities	sync_key	varchar	100	√		null
activities_users	activity_id	char	36
activities_users	date_modified	datetime	19	√		null
activities_users	deleted	bit	1	√		0
activities_users	fields	longtext	2147483647	√		null
activities_users	id	char	36
activities_users	parent_id	char	36	√		null
activities_users	parent_type	varchar	100	√		null
address_book	assigned_user_id	char	36
address_book	bean	varchar	50	√		null
address_book	bean_id	char	36
address_book_list_items	bean_id	char	36
address_book_list_items	list_id	char	36
address_book_lists	assigned_user_id	char	36
address_book_lists	id	char	36
address_book_lists	list_name	varchar	100	√		null
archive_runs	archiver_id	char	36	√		null
archive_runs	created_by	char	36	√		null
archive_runs	date_entered	datetime	19	√		null
archive_runs	date_modified	datetime	19	√		null
archive_runs	date_of_archive	datetime	19	√		null
archive_runs	deleted	bit	1	√		0
archive_runs	description	text	65535	√		null
archive_runs	filter_def	text	65535	√		null
archive_runs	id	char	36
archive_runs	ids_processed	longtext	2147483647	√		null
archive_runs	modified_user_id	char	36	√		null
archive_runs	name	varchar	255	√		null
archive_runs	num_processed	int	11	√		null
archive_runs	process_type	varchar	255	√		null
archive_runs	source_module	varchar	255	√		null
archive_runs	sync_key	varchar	100	√		null
audit_events	date_created	datetime	19	√		null
audit_events	id	char	36
audit_events	module_name	varchar	100	√		null
audit_events	parent_id	char	36
audit_events	source	text	65535	√		null
audit_events	type	char	10	√		null
bugs	acl_team_set_id	char	36	√		null
bugs	assigned_user_id	char	36	√		null
bugs	bug_number	int	11		√
bugs	business_hours_to_resolution	decimal	12,2	√		null
bugs	created_by	char	36	√		null
bugs	date_entered	datetime	19	√		null
bugs	date_modified	datetime	19	√		null
bugs	deleted	bit	1	√		0
bugs	description	text	65535	√		null
bugs	fixed_in_release	varchar	255	√		null
bugs	follow_up_datetime	datetime	19	√		null
bugs	found_in_release	varchar	255	√		null
bugs	hours_to_resolution	decimal	12,2	√		null
bugs	id	char	36
bugs	modified_user_id	char	36	√		null
bugs	name	varchar	255	√		null
bugs	pending_processing	bit	1	√		0
bugs	portal_viewable	bit	1	√		1
bugs	priority	varchar	100	√		null
bugs	product_category	varchar	255	√		null
bugs	resolution	varchar	255	√		null
bugs	resolved_datetime	datetime	19	√		null
bugs	source	varchar	255	√		null
bugs	status	varchar	100	√		null
bugs	sync_key	varchar	100	√		null
bugs	team_id	char	36	√		null
bugs	team_set_id	char	36	√		null
bugs	type	varchar	255	√		null
bugs	work_log	text	65535	√		null
bugs_audit	after_value_string	varchar	255	√		null
bugs_audit	after_value_text	text	65535	√		null
bugs_audit	before_value_string	varchar	255	√		null
bugs_audit	before_value_text	text	65535	√		null
bugs_audit	created_by	char	36	√		null
bugs_audit	data_type	varchar	100	√		null
bugs_audit	date_created	datetime	19	√		null
bugs_audit	date_updated	datetime	19	√		null
bugs_audit	event_id	char	36
bugs_audit	field_name	varchar	100	√		null
bugs_audit	id	char	36
bugs_audit	parent_id	char	36
business_centers	acl_team_set_id	char	36	√		null
business_centers	address_city	varchar	100	√		null
business_centers	address_country	varchar	255	√		null
business_centers	address_postalcode	varchar	20	√		null
business_centers	address_state	varchar	100	√		null
business_centers	address_street	varchar	150	√		null
business_centers	assigned_user_id	char	36	√		null
business_centers	created_by	char	36	√		null
business_centers	date_entered	datetime	19	√		null
business_centers	date_modified	datetime	19	√		null
business_centers	deleted	bit	1	√		0
business_centers	description	text	65535	√		null
business_centers	friday_close_hour	varchar	2	√		null
business_centers	friday_close_minutes	varchar	2	√		null
business_centers	friday_open_hour	varchar	2	√		null
business_centers	friday_open_minutes	varchar	2	√		null
business_centers	id	char	36
business_centers	is_open_friday	bit	1	√		1
business_centers	is_open_monday	bit	1	√		1
business_centers	is_open_saturday	bit	1	√		0
business_centers	is_open_sunday	bit	1	√		0
business_centers	is_open_thursday	bit	1	√		1
business_centers	is_open_tuesday	bit	1	√		1
business_centers	is_open_wednesday	bit	1	√		1
business_centers	modified_user_id	char	36	√		null
business_centers	monday_close_hour	varchar	2	√		null
business_centers	monday_close_minutes	varchar	2	√		null
business_centers	monday_open_hour	varchar	2	√		null
business_centers	monday_open_minutes	varchar	2	√		null
business_centers	name	varchar	255	√		null
business_centers	saturday_close_hour	varchar	2	√		null
business_centers	saturday_close_minutes	varchar	2	√		null
business_centers	saturday_open_hour	varchar	2	√		null
business_centers	saturday_open_minutes	varchar	2	√		null
business_centers	sunday_close_hour	varchar	2	√		null
business_centers	sunday_close_minutes	varchar	2	√		null
business_centers	sunday_open_hour	varchar	2	√		null
business_centers	sunday_open_minutes	varchar	2	√		null
business_centers	sync_key	varchar	100	√		null
business_centers	team_id	char	36	√		null
business_centers	team_set_id	char	36	√		null
business_centers	thursday_close_hour	varchar	2	√		null
business_centers	thursday_close_minutes	varchar	2	√		null
business_centers	thursday_open_hour	varchar	2	√		null
business_centers	thursday_open_minutes	varchar	2	√		null
business_centers	timezone	varchar	255	√		null
business_centers	tuesday_close_hour	varchar	2	√		null
business_centers	tuesday_close_minutes	varchar	2	√		null
business_centers	tuesday_open_hour	varchar	2	√		null
business_centers	tuesday_open_minutes	varchar	2	√		null
business_centers	wednesday_close_hour	varchar	2	√		null
business_centers	wednesday_close_minutes	varchar	2	√		null
business_centers	wednesday_open_hour	varchar	2	√		null
business_centers	wednesday_open_minutes	varchar	2	√		null
business_centers_audit	after_value_string	varchar	255	√		null
business_centers_audit	after_value_text	text	65535	√		null
business_centers_audit	before_value_string	varchar	255	√		null
business_centers_audit	before_value_text	text	65535	√		null
business_centers_audit	created_by	char	36	√		null
business_centers_audit	data_type	varchar	100	√		null
business_centers_audit	date_created	datetime	19	√		null
business_centers_audit	date_updated	datetime	19	√		null
business_centers_audit	event_id	char	36
business_centers_audit	field_name	varchar	100	√		null
business_centers_audit	id	char	36
business_centers_audit	parent_id	char	36
business_centers_holidays	business_center_id	char	36	√		null
business_centers_holidays	date_modified	datetime	19	√		null
business_centers_holidays	deleted	bit	1	√		0
business_centers_holidays	holiday_id	char	36	√		null
business_centers_holidays	id	char	36
calls	acl_team_set_id	char	36	√		null
calls	assigned_user_id	char	36	√		null
calls	aws_contact_id	char	36	√		null
calls	aws_lens_data	text	65535	√		null
calls	call_recording_url	varchar	255	√		null
calls	created_by	char	36	√		null
calls	date_end	datetime	19	√		null
calls	date_entered	datetime	19	√		null
calls	date_modified	datetime	19	√		null
calls	date_start	datetime	19	√		null
calls	deleted	bit	1	√		0
calls	description	text	65535	√		null
calls	direction	varchar	100	√		null
calls	duration_hours	int	11	√		0
calls	duration_minutes	int	2	√		null
calls	email_reminder_sent	bit	1	√		0
calls	email_reminder_time	int	11	√		-1
calls	id	char	36
calls	modified_user_id	char	36	√		null
calls	name	varchar	255	√		null
calls	outlook_id	varchar	255	√		null
calls	parent_id	char	36	√		null
calls	parent_type	varchar	255	√		null
calls	recurrence_id	datetime	19	√		null
calls	recurring_source	varchar	36	√		null
calls	reminder_time	int	11	√		-1
calls	repeat_count	int	7	√		null
calls	repeat_days	varchar	128	√		null
calls	repeat_dow	varchar	7	√		null
calls	repeat_interval	int	3	√		1
calls	repeat_ordinal	varchar	36	√		null
calls	repeat_parent_id	char	36	√		null
calls	repeat_selector	varchar	36	√		null
calls	repeat_type	varchar	36	√		null
calls	repeat_unit	varchar	36	√		null
calls	repeat_until	date	10	√		null
calls	sentiment_score_agent	decimal	10,2	√		null
calls	sentiment_score_agent_first_quarter	decimal	10,2	√		null
calls	sentiment_score_agent_fourth_quarter	decimal	10,2	√		null
calls	sentiment_score_agent_second_quarter	decimal	10,2	√		null
calls	sentiment_score_agent_third_quarter	decimal	10,2	√		null
calls	sentiment_score_customer	decimal	10,2	√		null
calls	sentiment_score_customer_first_quarter	decimal	10,2	√		null
calls	sentiment_score_customer_fourth_quarter	decimal	10,2	√		null
calls	sentiment_score_customer_second_quarter	decimal	10,2	√		null
calls	sentiment_score_customer_third_quarter	decimal	10,2	√		null
calls	status	varchar	100	√		Planned
calls	sync_key	varchar	100	√		null
calls	team_id	char	36	√		null
calls	team_set_id	char	36	√		null
calls	transcript	longtext	2147483647	√		null
calls_audit	after_value_string	varchar	255	√		null
calls_audit	after_value_text	text	65535	√		null
calls_audit	before_value_string	varchar	255	√		null
calls_audit	before_value_text	text	65535	√		null
calls_audit	created_by	char	36	√		null
calls_audit	data_type	varchar	100	√		null
calls_audit	date_created	datetime	19	√		null
calls_audit	date_updated	datetime	19	√		null
calls_audit	event_id	char	36
calls_audit	field_name	varchar	100	√		null
calls_audit	id	char	36
calls_audit	parent_id	char	36
calls_contacts	accept_status	varchar	25	√		none
calls_contacts	call_id	char	36	√		null
calls_contacts	contact_id	char	36	√		null
calls_contacts	date_modified	datetime	19	√		null
calls_contacts	deleted	bit	1	√		0
calls_contacts	id	char	36
calls_contacts	required	varchar	1	√		1
calls_leads	accept_status	varchar	25	√		none
calls_leads	call_id	char	36	√		null
calls_leads	date_modified	datetime	19	√		null
calls_leads	deleted	bit	1	√		0
calls_leads	id	char	36
calls_leads	lead_id	char	36	√		null
calls_leads	required	varchar	1	√		1
calls_users	accept_status	varchar	25	√		none
calls_users	call_id	char	36	√		null
calls_users	date_modified	datetime	19	√		null
calls_users	deleted	bit	1	√		0
calls_users	id	char	36
calls_users	required	varchar	1	√		1
calls_users	user_id	char	36	√		null
campaign_log	activity_date	datetime	19	√		null
campaign_log	activity_type	varchar	100	√		null
campaign_log	archived	bit	1	√		0
campaign_log	campaign_id	char	36	√		null
campaign_log	date_modified	datetime	19	√		null
campaign_log	deleted	bit	1	√		0
campaign_log	hits	int	11	√		0
campaign_log	id	char	36
campaign_log	list_id	char	36	√		null
campaign_log	marketing_id	char	36	√		null
campaign_log	more_information	varchar	100	√		null
campaign_log	related_id	char	36	√		null
campaign_log	related_type	varchar	100	√		null
campaign_log	target_id	char	36	√		null
campaign_log	target_tracker_key	varchar	36	√		null
campaign_log	target_type	varchar	100	√		null
campaign_trkrs	campaign_id	char	36	√		null
campaign_trkrs	created_by	char	36	√		null
campaign_trkrs	date_entered	datetime	19	√		null
campaign_trkrs	date_modified	datetime	19	√		null
campaign_trkrs	deleted	bit	1	√		0
campaign_trkrs	id	char	36
campaign_trkrs	is_optout	bit	1	√		0
campaign_trkrs	modified_user_id	char	36	√		null
campaign_trkrs	tracker_key	int	11		√
campaign_trkrs	tracker_name	varchar	30	√		null
campaign_trkrs	tracker_url	varchar	255	√		http://
campaigns	acl_team_set_id	char	36	√		null
campaigns	actual_cost	decimal	26,6	√		null
campaigns	assigned_user_id	char	36	√		null
campaigns	base_rate	decimal	26,6	√		null
campaigns	budget	decimal	26,6	√		null
campaigns	campaign_type	varchar	100	√		null
campaigns	content	text	65535	√		null
campaigns	created_by	char	36	√		null
campaigns	currency_id	char	36	√		-99
campaigns	date_entered	datetime	19	√		null
campaigns	date_modified	datetime	19	√		null
campaigns	deleted	bit	1	√		0
campaigns	end_date	date	10	√		null
campaigns	expected_cost	decimal	26,6	√		null
campaigns	expected_revenue	decimal	26,6	√		null
campaigns	frequency	varchar	100	√		null
campaigns	id	char	36
campaigns	impressions	int	11	√		0
campaigns	modified_user_id	char	36	√		null
campaigns	name	varchar	50	√		null
campaigns	objective	text	65535	√		null
campaigns	refer_url	varchar	255	√		http://
campaigns	start_date	date	10	√		null
campaigns	status	varchar	100	√		null
campaigns	sync_key	varchar	100	√		null
campaigns	team_id	char	36	√		null
campaigns	team_set_id	char	36	√		null
campaigns	tracker_count	int	11	√		0
campaigns	tracker_key	int	11		√
campaigns	tracker_text	varchar	255	√		null
campaigns_audit	after_value_string	varchar	255	√		null
campaigns_audit	after_value_text	text	65535	√		null
campaigns_audit	before_value_string	varchar	255	√		null
campaigns_audit	before_value_text	text	65535	√		null
campaigns_audit	created_by	char	36	√		null
campaigns_audit	data_type	varchar	100	√		null
campaigns_audit	date_created	datetime	19	√		null
campaigns_audit	date_updated	datetime	19	√		null
campaigns_audit	event_id	char	36
campaigns_audit	field_name	varchar	100	√		null
campaigns_audit	id	char	36
campaigns_audit	parent_id	char	36
cases	account_id	char	36	√		null
cases	acl_team_set_id	char	36	√		null
cases	assigned_user_id	char	36	√		null
cases	business_center_id	char	36	√		null
cases	business_hours_to_resolution	decimal	12,2	√		null
cases	business_hrs_to_first_response	decimal	12,2	√		null
cases	case_number	int	11		√
cases	created_by	char	36	√		null
cases	date_entered	datetime	19	√		null
cases	date_modified	datetime	19	√		null
cases	deleted	bit	1	√		0
cases	description	longtext	2147483647	√		null
cases	first_response_actual_datetime	datetime	19	√		null
cases	first_response_sent	bit	1	√		0
cases	first_response_sla_met	varchar	100	√		null
cases	first_response_target_datetime	datetime	19	√		null
cases	first_response_user_id	char	36	√		null
cases	first_response_var_from_target	decimal	12,2	√		null
cases	follow_up_datetime	datetime	19	√		null
cases	hours_to_first_response	decimal	12,2	√		null
cases	hours_to_resolution	decimal	12,2	√		null
cases	id	char	36
cases	modified_user_id	char	36	√		null
cases	name	varchar	255	√		null
cases	pending_processing	bit	1	√		0
cases	portal_viewable	bit	1	√		1
cases	primary_contact_id	char	36	√		null
cases	priority	varchar	100	√		null
cases	request_close	bit	1	√		0
cases	request_close_date	datetime	19	√		null
cases	resolution	text	65535	√		null
cases	resolved_datetime	datetime	19	√		null
cases	source	varchar	255	√		null
cases	status	varchar	100	√		null
cases	sync_key	varchar	100	√		null
cases	team_id	char	36	√		null
cases	team_set_id	char	36	√		null
cases	type	varchar	255	√		null
cases	work_log	text	65535	√		null
cases_audit	after_value_string	varchar	255	√		null
cases_audit	after_value_text	text	65535	√		null
cases_audit	before_value_string	varchar	255	√		null
cases_audit	before_value_text	text	65535	√		null
cases_audit	created_by	char	36	√		null
cases_audit	data_type	varchar	100	√		null
cases_audit	date_created	datetime	19	√		null
cases_audit	date_updated	datetime	19	√		null
cases_audit	event_id	char	36
cases_audit	field_name	varchar	100	√		null
cases_audit	id	char	36
cases_audit	parent_id	char	36
cases_bugs	bug_id	char	36	√		null
cases_bugs	case_id	char	36	√		null
cases_bugs	date_modified	datetime	19	√		null
cases_bugs	deleted	bit	1	√		0
cases_bugs	id	char	36
cases_purchases	case_id	char	36	√		null
cases_purchases	date_modified	datetime	19	√		null
cases_purchases	deleted	bit	1	√		0
cases_purchases	id	char	36
cases_purchases	purchase_id	char	36	√		null
categories	created_by	char	36	√		null
categories	date_entered	datetime	19	√		null
categories	date_modified	datetime	19	√		null
categories	deleted	bit	1	√		0
categories	description	text	65535	√		null
categories	id	char	36
categories	is_external	bit	1	√		0
categories	lft	int	11
categories	lvl	int	11
categories	modified_user_id	char	36	√		null
categories	name	varchar	255	√		null
categories	rgt	int	11
categories	root	char	36	√		null
categories	source_id	varchar	255	√		null
categories	source_meta	text	65535	√		null
categories	source_type	varchar	255	√		null
categories	sync_key	varchar	100	√		null
category_tree	node_id	int	11		√
category_tree	parent_node_id	int	11	√		0
category_tree	self_id	char	36	√		null
category_tree	type	varchar	36	√		null
changetimers	business_hours	decimal	12,2	√		null
changetimers	created_by	char	36	√		null
changetimers	date_entered	datetime	19	√		null
changetimers	date_modified	datetime	19	√		null
changetimers	deleted	bit	1	√		0
changetimers	description	text	65535	√		null
changetimers	field_name	varchar	100	√		null
changetimers	from_datetime	datetime	19	√		null
changetimers	hours	decimal	12,2	√		null
changetimers	id	char	36
changetimers	modified_user_id	char	36	√		null
changetimers	name	varchar	255	√		null
changetimers	parent_id	char	36	√		null
changetimers	parent_type	varchar	255	√		null
changetimers	sync_key	varchar	100	√		null
changetimers	to_datetime	datetime	19	√		null
changetimers	value_string	varchar	255	√		null
commentlog	created_by	char	36	√		null
commentlog	date_entered	datetime	19	√		null
commentlog	date_modified	datetime	19	√		null
commentlog	deleted	bit	1	√		0
commentlog	description	text	65535	√		null
commentlog	entry	text	65535	√		null
commentlog	id	char	36
commentlog	modified_user_id	char	36	√		null
commentlog	name	varchar	255	√		null
commentlog	sync_key	varchar	100	√		null
commentlog_rel	commentlog_id	char	36
commentlog_rel	deleted	bit	1	√		0
commentlog_rel	id	char	36
commentlog_rel	module	varchar	100	√		null
commentlog_rel	record_id	char	36
comments	created_by	char	36	√		null
comments	data	longtext	2147483647	√		null
comments	date_entered	datetime	19	√		null
comments	date_modified	datetime	19	√		null
comments	deleted	bit	1	√		0
comments	id	char	36
comments	modified_user_id	char	36	√		null
comments	parent_id	char	36
comments	sync_key	varchar	100	√		null
config	category	varchar	32	√		null
config	name	varchar	32	√		null
config	platform	varchar	32	√		null
config	value	text	65535	√		null
console_configuration	created_by	char	36	√		null
console_configuration	date_entered	datetime	19	√		null
console_configuration	date_modified	datetime	19	√		null
console_configuration	deleted	bit	1	√		0
console_configuration	description	text	65535	√		null
console_configuration	enabled_modules	varchar	255	√		null
console_configuration	filter_def	text	65535	√		null
console_configuration	id	char	36
console_configuration	modified_user_id	char	36	√		null
console_configuration	name	varchar	255	√		null
console_configuration	order_by_primary	varchar	255	√		null
console_configuration	order_by_secondary	varchar	255	√		null
console_configuration	sync_key	varchar	100	√		null
contacts	acl_team_set_id	char	36	√		null
contacts	alt_address_city	varchar	100	√		null
contacts	alt_address_country	varchar	255	√		null
contacts	alt_address_postalcode	varchar	20	√		null
contacts	alt_address_state	varchar	100	√		null
contacts	alt_address_street	varchar	150	√		null
contacts	assigned_user_id	char	36	√		null
contacts	assistant	varchar	75	√		null
contacts	assistant_phone	varchar	100	√		null
contacts	birthdate	date	10	√		null
contacts	business_center_id	char	36	√		null
contacts	campaign_id	char	36	√		null
contacts	cookie_consent	bit	1	√		0
contacts	cookie_consent_received_on	datetime	19	√		null
contacts	created_by	char	36	√		null
contacts	date_entered	datetime	19	√		null
contacts	date_modified	datetime	19	√		null
contacts	deleted	bit	1	√		0
contacts	department	varchar	255	√		null
contacts	description	text	65535	√		null
contacts	dnb_principal_id	varchar	30	√		null
contacts	do_not_call	bit	1	√		0
contacts	dp_business_purpose	text	65535	√		null
contacts	dp_consent_last_updated	date	10	√		null
contacts	entry_source	varchar	255	√		internal
contacts	facebook	varchar	100	√		null
contacts	first_name	varchar	255	√		null
contacts	googleplus	varchar	100	√		null
contacts	id	char	36
contacts	last_name	varchar	255	√		null
contacts	lead_source	varchar	255	√		null
contacts	mkto_id	int	11	√		null
contacts	mkto_lead_score	int	11	√		null
contacts	mkto_sync	bit	1	√		0
contacts	modified_user_id	char	36	√		null
contacts	phone_fax	varchar	100	√		null
contacts	phone_home	varchar	100	√		null
contacts	phone_mobile	varchar	100	√		null
contacts	phone_other	varchar	100	√		null
contacts	phone_work	varchar	100	√		null
contacts	picture	varchar	255	√		null
contacts	portal_active	bit	1	√		0
contacts	portal_app	varchar	255	√		null
contacts	portal_name	varchar	255	√		null
contacts	portal_password	varchar	255	√		null
contacts	portal_user_company_name	varchar	255	√		null
contacts	preferred_language	varchar	255	√		null
contacts	primary_address_city	varchar	100	√		null
contacts	primary_address_country	varchar	255	√		null
contacts	primary_address_postalcode	varchar	20	√		null
contacts	primary_address_state	varchar	100	√		null
contacts	primary_address_street	varchar	150	√		null
contacts	reports_to_id	char	36	√		null
contacts	salutation	varchar	255	√		null
contacts	site_user_id	varchar	64	√		null
contacts	sync_key	varchar	100	√		null
contacts	team_id	char	36	√		null
contacts	team_set_id	char	36	√		null
contacts	title	varchar	100	√		null
contacts	twitter	varchar	100	√		null
contacts_audit	after_value_string	varchar	255	√		null
contacts_audit	after_value_text	text	65535	√		null
contacts_audit	before_value_string	varchar	255	√		null
contacts_audit	before_value_text	text	65535	√		null
contacts_audit	created_by	char	36	√		null
contacts_audit	data_type	varchar	100	√		null
contacts_audit	date_created	datetime	19	√		null
contacts_audit	date_updated	datetime	19	√		null
contacts_audit	event_id	char	36
contacts_audit	field_name	varchar	100	√		null
contacts_audit	id	char	36
contacts_audit	parent_id	char	36
contacts_bugs	bug_id	char	36	√		null
contacts_bugs	contact_id	char	36	√		null
contacts_bugs	contact_role	varchar	50	√		null
contacts_bugs	date_modified	datetime	19	√		null
contacts_bugs	deleted	bit	1	√		0
contacts_bugs	id	char	36
contacts_cases	case_id	char	36	√		null
contacts_cases	contact_id	char	36	√		null
contacts_cases	contact_role	varchar	50	√		null
contacts_cases	date_modified	datetime	19	√		null
contacts_cases	deleted	bit	1	√		0
contacts_cases	id	char	36
contacts_dataprivacy	contact_id	char	36	√		null
contacts_dataprivacy	dataprivacy_id	char	36	√		null
contacts_dataprivacy	date_modified	datetime	19	√		null
contacts_dataprivacy	deleted	bit	1	√		0
contacts_dataprivacy	id	char	36
contacts_purchases	contact_id	char	36	√		null
contacts_purchases	date_modified	datetime	19	√		null
contacts_purchases	deleted	bit	1	√		0
contacts_purchases	id	char	36
contacts_purchases	purchase_id	char	36	√		null
contacts_users	contact_id	char	36	√		null
contacts_users	date_modified	datetime	19	√		null
contacts_users	deleted	bit	1	√		0
contacts_users	id	char	36
contacts_users	user_id	char	36	√		null
contract_types	created_by	char	36	√		null
contract_types	date_entered	datetime	19	√		null
contract_types	date_modified	datetime	19	√		null
contract_types	deleted	bit	1	√		0
contract_types	description	text	65535	√		null
contract_types	id	char	36
contract_types	list_order	int	4	√		null
contract_types	modified_user_id	char	36	√		null
contract_types	name	varchar	255	√		null
contract_types	sync_key	varchar	100	√		null
contracts	account_id	char	36	√		null
contracts	acl_team_set_id	char	36	√		null
contracts	assigned_user_id	char	36	√		null
contracts	base_rate	decimal	26,6	√		null
contracts	company_signed_date	date	10	√		null
contracts	created_by	char	36	√		null
contracts	currency_id	char	36	√		-99
contracts	customer_signed_date	date	10	√		null
contracts	date_entered	datetime	19	√		null
contracts	date_modified	datetime	19	√		null
contracts	deleted	bit	1	√		0
contracts	description	text	65535	√		null
contracts	end_date	date	10	√		null
contracts	expiration_notice	datetime	19	√		null
contracts	id	char	36
contracts	modified_user_id	char	36	√		null
contracts	name	varchar	255	√		null
contracts	reference_code	varchar	255	√		null
contracts	start_date	date	10	√		null
contracts	status	varchar	100	√		null
contracts	sync_key	varchar	100	√		null
contracts	team_id	char	36	√		null
contracts	team_set_id	char	36	√		null
contracts	total_contract_value	decimal	26,6	√		null
contracts	total_contract_value_usdollar	decimal	26,6	√		null
contracts	type	varchar	255	√		null
contracts_audit	after_value_string	varchar	255	√		null
contracts_audit	after_value_text	text	65535	√		null
contracts_audit	before_value_string	varchar	255	√		null
contracts_audit	before_value_text	text	65535	√		null
contracts_audit	created_by	char	36	√		null
contracts_audit	data_type	varchar	100	√		null
contracts_audit	date_created	datetime	19	√		null
contracts_audit	date_updated	datetime	19	√		null
contracts_audit	event_id	char	36
contracts_audit	field_name	varchar	100	√		null
contracts_audit	id	char	36
contracts_audit	parent_id	char	36
contracts_contacts	contact_id	char	36	√		null
contracts_contacts	contract_id	char	36	√		null
contracts_contacts	date_modified	datetime	19	√		null
contracts_contacts	deleted	bit	1	√		0
contracts_contacts	id	char	36
contracts_opportunities	contract_id	char	36	√		null
contracts_opportunities	date_modified	datetime	19	√		null
contracts_opportunities	deleted	bit	1	√		0
contracts_opportunities	id	char	36
contracts_opportunities	opportunity_id	char	36	√		null
contracts_products	contract_id	char	36	√		null
contracts_products	date_modified	datetime	19	√		null
contracts_products	deleted	bit	1	√		0
contracts_products	id	char	36
contracts_products	product_id	char	36	√		null
contracts_quotes	contract_id	char	36	√		null
contracts_quotes	date_modified	datetime	19	√		null
contracts_quotes	deleted	bit	1	√		0
contracts_quotes	id	char	36
contracts_quotes	quote_id	char	36	√		null
currencies	conversion_rate	decimal	26,6	√		0.000000
currencies	created_by	char	36
currencies	date_entered	datetime	19	√		null
currencies	date_modified	datetime	19	√		null
currencies	deleted	bit	1	√		0
currencies	id	char	36
currencies	iso4217	varchar	3	√		null
currencies	name	varchar	36	√		null
currencies	status	varchar	100	√		null
currencies	symbol	varchar	36	√		null
currencies	sync_key	varchar	100	√		null
custom_fields	bean_id	char	36	√		null
custom_fields	deleted	bit	1	√		0
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
custom_fields	set_num	int	11	√		0
custom_queries	acl_team_set_id	char	36	√		null
custom_queries	created_by	char	36	√		null
custom_queries	custom_query	text	65535	√		null
custom_queries	date_entered	datetime	19	√		null
custom_queries	date_modified	datetime	19	√		null
custom_queries	deleted	bit	1	√		0
custom_queries	description	text	65535	√		null
custom_queries	id	char	36
custom_queries	list_order	int	4	√		null
custom_queries	modified_user_id	char	36	√		null
custom_queries	name	varchar	50	√		null
custom_queries	query_locked	varchar	3	√		0
custom_queries	query_type	varchar	50	√		null
custom_queries	team_id	char	36	√		null
custom_queries	team_set_id	char	36	√		null
dashboards	acl_team_set_id	char	36	√		null
dashboards	assigned_user_id	char	36	√		null
dashboards	created_by	char	36	√		null
dashboards	dashboard_module	varchar	100	√		null
dashboards	date_entered	datetime	19	√		null
dashboards	date_modified	datetime	19	√		null
dashboards	default_dashboard	bit	1	√		0
dashboards	deleted	bit	1	√		0
dashboards	description	text	65535	√		null
dashboards	id	char	36
dashboards	metadata	text	65535	√		null
dashboards	modified_user_id	char	36	√		null
dashboards	name	varchar	255	√		null
dashboards	sync_key	varchar	100	√		null
dashboards	team_id	char	36	√		null
dashboards	team_set_id	char	36	√		null
dashboards	view_name	varchar	100	√		null
data_archivers	active	bit	1	√		1
data_archivers	created_by	char	36	√		null
data_archivers	date_entered	datetime	19	√		null
data_archivers	date_modified	datetime	19	√		null
data_archivers	deleted	bit	1	√		0
data_archivers	description	text	65535	√		null
data_archivers	filter_def	text	65535	√		null
data_archivers	filter_module_name	varchar	255	√		null
data_archivers	id	char	36
data_archivers	modified_user_id	char	36	√		null
data_archivers	name	varchar	255	√		null
data_archivers	process_type	varchar	255	√		null
data_archivers	sync_key	varchar	100	√		null
data_privacy	acl_team_set_id	char	36	√		null
data_privacy	assigned_user_id	char	36	√		null
data_privacy	business_hours_to_resolution	decimal	12,2	√		null
data_privacy	business_purpose	text	65535	√		null
data_privacy	created_by	char	36	√		null
data_privacy	dataprivacy_number	int	11		√
data_privacy	date_closed	date	10	√		null
data_privacy	date_due	date	10	√		null
data_privacy	date_entered	datetime	19	√		null
data_privacy	date_modified	datetime	19	√		null
data_privacy	date_opened	date	10	√		null
data_privacy	deleted	bit	1	√		0
data_privacy	description	text	65535	√		null
data_privacy	fields_to_erase	text	65535	√		null
data_privacy	follow_up_datetime	datetime	19	√		null
data_privacy	hours_to_resolution	decimal	12,2	√		null
data_privacy	id	char	36
data_privacy	modified_user_id	char	36	√		null
data_privacy	name	varchar	255	√		null
data_privacy	pending_processing	bit	1	√		0
data_privacy	priority	varchar	100	√		null
data_privacy	requested_by	varchar	255	√		null
data_privacy	resolution	text	65535	√		null
data_privacy	resolved_datetime	datetime	19	√		null
data_privacy	source	varchar	255	√		null
data_privacy	status	varchar	100	√		Open
data_privacy	sync_key	varchar	100	√		null
data_privacy	team_id	char	36	√		null
data_privacy	team_set_id	char	36	√		null
data_privacy	type	varchar	255	√		null
data_privacy	work_log	text	65535	√		null
data_privacy_audit	after_value_string	varchar	255	√		null
data_privacy_audit	after_value_text	text	65535	√		null
data_privacy_audit	before_value_string	varchar	255	√		null
data_privacy_audit	before_value_text	text	65535	√		null
data_privacy_audit	created_by	char	36	√		null
data_privacy_audit	data_type	varchar	100	√		null
data_privacy_audit	date_created	datetime	19	√		null
data_privacy_audit	date_updated	datetime	19	√		null
data_privacy_audit	event_id	char	36
data_privacy_audit	field_name	varchar	100	√		null
data_privacy_audit	id	char	36
data_privacy_audit	parent_id	char	36
data_sets	acl_team_set_id	char	36	√		null
data_sets	body_back_color	varchar	100	√		null
data_sets	body_text_color	varchar	100	√		null
data_sets	created_by	char	36	√		null
data_sets	custom_layout	varchar	10	√		null
data_sets	date_entered	datetime	19	√		null
data_sets	date_modified	datetime	19	√		null
data_sets	deleted	bit	1	√		0
data_sets	description	text	65535	√		null
data_sets	exportable	varchar	3	√		0
data_sets	font_size	varchar	8	√		0
data_sets	header	varchar	3	√		0
data_sets	header_back_color	varchar	100	√		null
data_sets	header_text_color	varchar	100	√		null
data_sets	id	char	36
data_sets	list_order_y	int	3	√		0
data_sets	modified_user_id	char	36	√		null
data_sets	name	varchar	50	√		null
data_sets	output_default	varchar	100	√		null
data_sets	parent_id	char	36	√		null
data_sets	prespace_y	varchar	3	√		0
data_sets	query_id	char	36
data_sets	report_id	char	36	√		null
data_sets	table_width	varchar	3	√		0
data_sets	table_width_type	varchar	3	√		null
data_sets	team_id	char	36	√		null
data_sets	team_set_id	char	36	√		null
data_sets	use_prev_header	varchar	3	√		0
dataset_attributes	attribute_type	varchar	8	√		null
dataset_attributes	bg_color	varchar	25	√		null
dataset_attributes	cell_size	varchar	3	√		null
dataset_attributes	created_by	char	36	√		null
dataset_attributes	date_entered	datetime	19	√		null
dataset_attributes	date_modified	datetime	19	√		null
dataset_attributes	deleted	bit	1	√		0
dataset_attributes	display_name	varchar	50	√		null
dataset_attributes	display_type	varchar	25	√		null
dataset_attributes	font_color	varchar	25	√		null
dataset_attributes	font_size	varchar	8	√		0
dataset_attributes	format_type	varchar	25	√		null
dataset_attributes	id	char	36
dataset_attributes	modified_user_id	char	36	√		null
dataset_attributes	parent_id	char	36	√		null
dataset_attributes	size_type	varchar	3	√		null
dataset_attributes	style	varchar	25	√		null
dataset_attributes	wrap	varchar	3	√		null
dataset_layouts	created_by	char	36	√		null
dataset_layouts	date_entered	datetime	19	√		null
dataset_layouts	date_modified	datetime	19	√		null
dataset_layouts	deleted	bit	1	√		0
dataset_layouts	hide_column	varchar	3	√		null
dataset_layouts	id	char	36
dataset_layouts	layout_type	varchar	25	√		null
dataset_layouts	list_order_x	int	4	√		null
dataset_layouts	list_order_z	int	4	√		null
dataset_layouts	modified_user_id	char	36	√		null
dataset_layouts	parent_id	char	36	√		null
dataset_layouts	parent_value	varchar	50	√		null
dataset_layouts	row_header_id	char	36	√		null
document_revisions	change_log	varchar	255	√		null
document_revisions	created_by	char	36	√		null
document_revisions	date_entered	datetime	19	√		null
document_revisions	date_modified	datetime	19	√		null
document_revisions	deleted	bit	1	√		0
document_revisions	doc_id	varchar	100	√		null
document_revisions	doc_type	varchar	100	√		null
document_revisions	doc_url	varchar	255	√		null
document_revisions	document_id	char	36	√		null
document_revisions	file_ext	varchar	100	√		null
document_revisions	file_mime_type	varchar	100	√		null
document_revisions	file_size	int	11	√		null
document_revisions	filename	varchar	255	√		null
document_revisions	id	char	36
document_revisions	revision	varchar	100	√		null
documents	acl_team_set_id	char	36	√		null
documents	active_date	date	10	√		null
documents	assigned_user_id	char	36	√		null
documents	category_id	varchar	100	√		null
documents	created_by	char	36	√		null
documents	date_entered	datetime	19	√		null
documents	date_modified	datetime	19	√		null
documents	deleted	bit	1	√		0
documents	description	text	65535	√		null
documents	doc_id	varchar	100	√		null
documents	doc_type	varchar	100	√		Sugar
documents	doc_url	varchar	255	√		null
documents	document_name	varchar	255	√		null
documents	document_revision_id	char	36	√		null
documents	exp_date	date	10	√		null
documents	id	char	36
documents	is_template	bit	1	√		0
documents	modified_user_id	char	36	√		null
documents	related_doc_id	char	36	√		null
documents	related_doc_rev_id	char	36	√		null
documents	status_id	varchar	100	√		null
documents	subcategory_id	varchar	100	√		null
documents	sync_key	varchar	100	√		null
documents	team_id	char	36	√		null
documents	team_set_id	char	36	√		null
documents	template_type	varchar	100	√		null
documents_accounts	account_id	char	36	√		null
documents_accounts	date_modified	datetime	19	√		null
documents_accounts	deleted	bit	1	√		0
documents_accounts	document_id	char	36	√		null
documents_accounts	id	char	36
documents_bugs	bug_id	char	36	√		null
documents_bugs	date_modified	datetime	19	√		null
documents_bugs	deleted	bit	1	√		0
documents_bugs	document_id	char	36	√		null
documents_bugs	id	char	36
documents_cases	case_id	char	36	√		null
documents_cases	date_modified	datetime	19	√		null
documents_cases	deleted	bit	1	√		0
documents_cases	document_id	char	36	√		null
documents_cases	id	char	36
documents_contacts	contact_id	char	36	√		null
documents_contacts	date_modified	datetime	19	√		null
documents_contacts	deleted	bit	1	√		0
documents_contacts	document_id	char	36	√		null
documents_contacts	id	char	36
documents_opportunities	date_modified	datetime	19	√		null
documents_opportunities	deleted	bit	1	√		0
documents_opportunities	document_id	char	36	√		null
documents_opportunities	id	char	36
documents_opportunities	opportunity_id	char	36	√		null
documents_products	date_modified	datetime	19	√		null
documents_products	deleted	bit	1	√		0
documents_products	document_id	char	36	√		null
documents_products	id	char	36
documents_products	product_id	char	36	√		null
documents_purchasedlineitems	date_modified	datetime	19	√		null
documents_purchasedlineitems	deleted	bit	1	√		0
documents_purchasedlineitems	document_id	char	36	√		null
documents_purchasedlineitems	id	char	36
documents_purchasedlineitems	purchasedlineitem_id	char	36	√		null
documents_purchases	date_modified	datetime	19	√		null
documents_purchases	deleted	bit	1	√		0
documents_purchases	document_id	char	36	√		null
documents_purchases	id	char	36
documents_purchases	purchase_id	char	36	√		null
documents_quotes	date_modified	datetime	19	√		null
documents_quotes	deleted	bit	1	√		0
documents_quotes	document_id	char	36	√		null
documents_quotes	id	char	36
documents_quotes	quote_id	char	36	√		null
documents_revenuelineitems	date_modified	datetime	19	√		null
documents_revenuelineitems	deleted	bit	1	√		0
documents_revenuelineitems	document_id	char	36	√		null
documents_revenuelineitems	id	char	36
documents_revenuelineitems	rli_id	char	36	√		null
eapm	api_data	text	65535	√		null
eapm	application	varchar	100	√		webex
eapm	assigned_user_id	char	36	√		null
eapm	consumer_key	varchar	255	√		null
eapm	consumer_secret	varchar	255	√		null
eapm	created_by	char	36	√		null
eapm	date_entered	datetime	19	√		null
eapm	date_modified	datetime	19	√		null
eapm	deleted	bit	1	√		0
eapm	description	text	65535	√		null
eapm	id	char	36
eapm	modified_user_id	char	36	√		null
eapm	name	varchar	255	√		null
eapm	oauth_secret	varchar	255	√		null
eapm	oauth_token	varchar	255	√		null
eapm	password	varchar	255	√		null
eapm	sync_key	varchar	100	√		null
eapm	url	varchar	255	√		null
eapm	validated	bit	1	√		0
email_addr_bean_rel	bean_id	char	36
email_addr_bean_rel	bean_module	varchar	100	√		null
email_addr_bean_rel	date_created	datetime	19	√		null
email_addr_bean_rel	date_modified	datetime	19	√		null
email_addr_bean_rel	deleted	bit	1	√		0
email_addr_bean_rel	email_address_id	char	36
email_addr_bean_rel	id	char	36
email_addr_bean_rel	primary_address	bit	1	√		0
email_addr_bean_rel	reply_to_address	bit	1	√		0
email_addresses	confirmation_requested_on	datetime	19	√		null
email_addresses	date_created	datetime	19	√		null
email_addresses	date_modified	datetime	19	√		null
email_addresses	deleted	bit	1	√		0
email_addresses	email_address	varchar	255	√		null
email_addresses	email_address_caps	varchar	255	√		null
email_addresses	id	char	36
email_addresses	invalid_email	bit	1	√		0
email_addresses	opt_out	bit	1	√		0
email_addresses_audit	after_value_string	varchar	255	√		null
email_addresses_audit	after_value_text	text	65535	√		null
email_addresses_audit	before_value_string	varchar	255	√		null
email_addresses_audit	before_value_text	text	65535	√		null
email_addresses_audit	created_by	char	36	√		null
email_addresses_audit	data_type	varchar	100	√		null
email_addresses_audit	date_created	datetime	19	√		null
email_addresses_audit	date_updated	datetime	19	√		null
email_addresses_audit	event_id	char	36
email_addresses_audit	field_name	varchar	100	√		null
email_addresses_audit	id	char	36
email_addresses_audit	parent_id	char	36
email_cache	answered	tinyint	4	√		null
email_cache	deleted	tinyint	4	√		null
email_cache	draft	tinyint	4	√		null
email_cache	flagged	tinyint	4	√		null
email_cache	fromaddr	varchar	100	√		null
email_cache	ie_id	char	36	√		null
email_cache	imap_uid	int unsigned	10	√		null
email_cache	mailsize	int unsigned	10	√		null
email_cache	mbox	varchar	60	√		null
email_cache	message_id	varchar	255	√		null
email_cache	msgno	int unsigned	10	√		null
email_cache	recent	tinyint	4	√		null
email_cache	seen	tinyint	4	√		null
email_cache	senddate	datetime	19	√		null
email_cache	subject	varchar	255	√		null
email_cache	toaddr	varchar	255	√		null
email_marketing	all_prospect_lists	bit	1	√		0
email_marketing	campaign_id	char	36	√		null
email_marketing	created_by	char	36	√		null
email_marketing	date_entered	datetime	19	√		null
email_marketing	date_modified	datetime	19	√		null
email_marketing	date_start	datetime	19	√		null
email_marketing	deleted	bit	1	√		0
email_marketing	from_addr	varchar	100	√		null
email_marketing	from_name	varchar	100	√		null
email_marketing	id	char	36
email_marketing	inbound_email_id	char	36	√		null
email_marketing	modified_user_id	char	36	√		null
email_marketing	name	varchar	255	√		null
email_marketing	reply_to_addr	varchar	100	√		null
email_marketing	reply_to_name	varchar	100	√		null
email_marketing	status	varchar	100	√		null
email_marketing	template_id	char	36
email_marketing_prospect_lists	date_modified	datetime	19	√		null
email_marketing_prospect_lists	deleted	bit	1	√		0
email_marketing_prospect_lists	email_marketing_id	char	36	√		null
email_marketing_prospect_lists	id	char	36
email_marketing_prospect_lists	prospect_list_id	char	36	√		null
email_templates	acl_team_set_id	char	36	√		null
email_templates	assigned_user_id	char	36	√		null
email_templates	base_module	varchar	50	√		null
email_templates	body	text	65535	√		null
email_templates	body_html	text	65535	√		null
email_templates	created_by	char	36	√		null
email_templates	date_entered	datetime	19	√		null
email_templates	date_modified	datetime	19	√		null
email_templates	deleted	bit	1	√		0
email_templates	description	text	65535	√		null
email_templates	from_address	varchar	255	√		null
email_templates	from_name	varchar	255	√		null
email_templates	has_variables	bit	1	√		0
email_templates	id	char	36
email_templates	modified_user_id	char	36	√		null
email_templates	name	varchar	255	√		null
email_templates	published	varchar	3	√		null
email_templates	subject	varchar	255	√		null
email_templates	team_id	char	36	√		null
email_templates	team_set_id	char	36	√		null
email_templates	text_only	bit	1	√		0
email_templates	type	varchar	255	√		email
emailman	campaign_id	char	36	√		null
emailman	date_entered	datetime	19	√		null
emailman	date_modified	datetime	19	√		null
emailman	deleted	bit	1	√		0
emailman	id	int	11		√
emailman	in_queue	bit	1	√		0
emailman	in_queue_date	datetime	19	√		null
emailman	list_id	char	36	√		null
emailman	marketing_id	char	36	√		null
emailman	modified_user_id	char	36	√		null
emailman	related_id	char	36	√		null
emailman	related_type	varchar	100	√		null
emailman	send_attempts	int	11	√		0
emailman	send_date_time	datetime	19	√		null
emailman	user_id	char	36	√		null
emails	acl_team_set_id	char	36	√		null
emails	assigned_user_id	char	36	√		null
emails	created_by	char	36	√		null
emails	date_entered	datetime	19	√		null
emails	date_modified	datetime	19	√		null
emails	date_sent	datetime	19	√		null
emails	deleted	bit	1	√		0
emails	direction	varchar	20			Unknown
emails	flagged	bit	1	√		0
emails	id	char	36
emails	intent	varchar	100	√		pick
emails	mailbox_id	char	36	√		null
emails	message_id	varchar	255	√		null
emails	message_uid	varchar	64	√		null
emails	modified_user_id	char	36	√		null
emails	name	varchar	255	√		null
emails	outbound_email_id	char	36	√		null
emails	parent_id	char	36	√		null
emails	parent_type	varchar	255	√		null
emails	reply_to_id	char	36	√		null
emails	reply_to_status	bit	1	√		0
emails	state	varchar	100			Archived
emails	status	varchar	100	√		null
emails	sync_key	varchar	100	√		null
emails	team_id	char	36	√		null
emails	team_set_id	char	36	√		null
emails	total_attachments	int	11	√		null
emails	type	varchar	100	√		null
emails_beans	bean_id	char	36	√		null
emails_beans	bean_module	varchar	100	√		null
emails_beans	campaign_data	text	65535	√		null
emails_beans	date_modified	datetime	19	√		null
emails_beans	deleted	bit	1	√		0
emails_beans	email_id	char	36	√		null
emails_beans	id	char	36
emails_email_addr_rel	address_type	varchar	4	√		null
emails_email_addr_rel	date_entered	datetime	19	√		null
emails_email_addr_rel	date_modified	datetime	19	√		null
emails_email_addr_rel	deleted	bit	1	√		0
emails_email_addr_rel	email_address_id	char	36	√		null
emails_email_addr_rel	email_id	char	36	√		null
emails_email_addr_rel	id	char	36
emails_email_addr_rel	parent_id	char	36	√		null
emails_email_addr_rel	parent_type	varchar	255	√		null
emails_text	bcc_addrs	text	65535	√		null
emails_text	cc_addrs	text	65535	√		null
emails_text	deleted	bit	1	√		0
emails_text	description	longtext	2147483647	√		null
emails_text	description_html	longtext	2147483647	√		null
emails_text	email_id	char	36
emails_text	from_addr	varchar	255	√		null
emails_text	raw_source	longtext	2147483647	√		null
emails_text	reply_to_addr	varchar	255	√		null
emails_text	to_addrs	text	65535	√		null
embedded_files	created_by	char	36	√		null
embedded_files	date_entered	datetime	19	√		null
embedded_files	date_modified	datetime	19	√		null
embedded_files	deleted	bit	1	√		0
embedded_files	description	text	65535	√		null
embedded_files	file_mime_type	varchar	100	√		null
embedded_files	filename	varchar	255	√		null
embedded_files	id	char	36
embedded_files	modified_user_id	char	36	√		null
embedded_files	name	varchar	255	√		null
embedded_files	sync_key	varchar	100	√		null
erased_fields	bean_id	char	36
erased_fields	data	text	65535	√		null
erased_fields	table_name	varchar	128
expressions	created_by	char	36	√		null
expressions	date_entered	datetime	19	√		null
expressions	date_modified	datetime	19	√		null
expressions	deleted	bit	1	√		0
expressions	exp_order	int	4	√		null
expressions	exp_type	varchar	100	√		null
expressions	ext1	varchar	50	√		null
expressions	ext2	varchar	50	√		null
expressions	ext3	varchar	50	√		null
expressions	id	char	36
expressions	lhs_field	varchar	50	√		null
expressions	lhs_group_type	varchar	10	√		null
expressions	lhs_module	varchar	50	√		null
expressions	lhs_type	varchar	15	√		null
expressions	lhs_value	varchar	100	√		null
expressions	modified_user_id	char	36	√		null
expressions	operator	varchar	15	√		null
expressions	parent_exp_id	char	36	√		null
expressions	parent_exp_side	int	8	√		null
expressions	parent_id	char	36
expressions	parent_type	varchar	255	√		null
expressions	rhs_field	varchar	50	√		null
expressions	rhs_group_type	varchar	10	√		null
expressions	rhs_module	varchar	50	√		null
expressions	rhs_type	varchar	15	√		null
expressions	rhs_value	varchar	255	√		null
fields_meta_data	audited	bit	1	√		0
fields_meta_data	autoinc_next	int	11	√		null
fields_meta_data	comments	varchar	255	√		null
fields_meta_data	custom_module	varchar	255	√		null
fields_meta_data	date_modified	datetime	19	√		null
fields_meta_data	default_value	varchar	255	√		null
fields_meta_data	deleted	bit	1	√		0
fields_meta_data	duplicate_merge	smallint	6	√		0
fields_meta_data	ext1	varchar	255	√
fields_meta_data	ext2	varchar	255	√
fields_meta_data	ext3	varchar	255	√
fields_meta_data	ext4	text	65535	√		null
fields_meta_data	help	varchar	255	√		null
fields_meta_data	id	char	36
fields_meta_data	importable	varchar	255	√		null
fields_meta_data	len	int	11	√		null
fields_meta_data	massupdate	bit	1	√		0
fields_meta_data	name	varchar	255	√		null
fields_meta_data	reportable	bit	1	√		1
fields_meta_data	required	bit	1	√		0
fields_meta_data	type	varchar	255	√		null
fields_meta_data	vname	varchar	255	√		null
filters	acl_team_set_id	char	36	√		null
filters	app	varchar	36	√		base
filters	assigned_user_id	char	36	√		null
filters	created_by	char	36	√		null
filters	date_entered	datetime	19	√		null
filters	date_modified	datetime	19	√		null
filters	deleted	bit	1	√		0
filters	description	text	65535	√		null
filters	filter_definition	longtext	2147483647	√		null
filters	filter_template	longtext	2147483647	√		null
filters	id	char	36
filters	modified_user_id	char	36	√		null
filters	module_name	varchar	100	√		null
filters	name	varchar	255	√		null
filters	sync_key	varchar	100	√		null
filters	team_id	char	36	√		null
filters	team_set_id	char	36	√		null
folders	acl_team_set_id	char	36	√		null
folders	assign_to_id	char	36	√		null
folders	created_by	char	36
folders	deleted	bit	1	√		0
folders	dynamic_query	text	65535	√		null
folders	folder_type	varchar	25	√		null
folders	has_child	bit	1	√		0
folders	id	char	36
folders	is_dynamic	bit	1	√		0
folders	is_group	bit	1	√		0
folders	modified_by	char	36
folders	name	varchar	25	√		null
folders	parent_folder	char	36	√		null
folders	team_id	char	36	√		null
folders	team_set_id	char	36	√		null
folders_rel	deleted	bit	1	√		0
folders_rel	folder_id	char	36
folders_rel	id	char	36
folders_rel	polymorphic_id	char	36
folders_rel	polymorphic_module	varchar	25	√		null
folders_subscriptions	assigned_user_id	char	36
folders_subscriptions	folder_id	char	36
folders_subscriptions	id	char	36
forecast_manager_worksheets	acl_team_set_id	char	36	√		null
forecast_manager_worksheets	assigned_user_id	char	36	√		null
forecast_manager_worksheets	base_rate	decimal	26,6	√		null
forecast_manager_worksheets	best_case	decimal	26,6	√		null
forecast_manager_worksheets	best_case_adjusted	decimal	26,6	√		null
forecast_manager_worksheets	closed_amount	decimal	26,6	√		0.000000
forecast_manager_worksheets	created_by	char	36	√		null
forecast_manager_worksheets	currency_id	char	36	√		-99
forecast_manager_worksheets	date_entered	datetime	19	√		null
forecast_manager_worksheets	date_modified	datetime	19	√		null
forecast_manager_worksheets	deleted	bit	1	√		0
forecast_manager_worksheets	description	text	65535	√		null
forecast_manager_worksheets	draft	bit	1	√		0
forecast_manager_worksheets	id	char	36
forecast_manager_worksheets	likely_case	decimal	26,6	√		null
forecast_manager_worksheets	likely_case_adjusted	decimal	26,6	√		null
forecast_manager_worksheets	manager_saved	bit	1	√		0
forecast_manager_worksheets	modified_user_id	char	36	√		null
forecast_manager_worksheets	name	varchar	255	√		null
forecast_manager_worksheets	opp_count	int	5	√		null
forecast_manager_worksheets	pipeline_amount	decimal	26,6	√		0.000000
forecast_manager_worksheets	pipeline_opp_count	int	5	√		0
forecast_manager_worksheets	quota	decimal	26,6	√		null
forecast_manager_worksheets	sync_key	varchar	100	√		null
forecast_manager_worksheets	team_id	char	36	√		null
forecast_manager_worksheets	team_set_id	char	36	√		null
forecast_manager_worksheets	timeperiod_id	char	36	√		null
forecast_manager_worksheets	user_id	char	36	√		null
forecast_manager_worksheets	worst_case	decimal	26,6	√		null
forecast_manager_worksheets	worst_case_adjusted	decimal	26,6	√		null
forecast_manager_worksheets_audit	after_value_string	varchar	255	√		null
forecast_manager_worksheets_audit	after_value_text	text	65535	√		null
forecast_manager_worksheets_audit	before_value_string	varchar	255	√		null
forecast_manager_worksheets_audit	before_value_text	text	65535	√		null
forecast_manager_worksheets_audit	created_by	char	36	√		null
forecast_manager_worksheets_audit	data_type	varchar	100	√		null
forecast_manager_worksheets_audit	date_created	datetime	19	√		null
forecast_manager_worksheets_audit	date_updated	datetime	19	√		null
forecast_manager_worksheets_audit	event_id	char	36
forecast_manager_worksheets_audit	field_name	varchar	100	√		null
forecast_manager_worksheets_audit	id	char	36
forecast_manager_worksheets_audit	parent_id	char	36
forecast_tree	hierarchy_type	varchar	25	√		null
forecast_tree	id	char	36
forecast_tree	name	varchar	50	√		null
forecast_tree	parent_id	char	36	√		null
forecast_tree	user_id	char	36	√		null
forecast_worksheets	account_id	char	36	√		null
forecast_worksheets	account_name	varchar	255	√		null
forecast_worksheets	acl_team_set_id	char	36	√		null
forecast_worksheets	assigned_user_id	char	36	√		null
forecast_worksheets	base_rate	decimal	26,6	√		null
forecast_worksheets	best_case	decimal	26,6	√		null
forecast_worksheets	campaign_id	char	36	√		null
forecast_worksheets	campaign_name	varchar	255	√		null
forecast_worksheets	category_id	char	36	√		null
forecast_worksheets	category_name	varchar	255	√		null
forecast_worksheets	commit_stage	varchar	50	√		null
forecast_worksheets	cost_price	decimal	26,6	√		null
forecast_worksheets	created_by	char	36	√		null
forecast_worksheets	currency_id	char	36	√		-99
forecast_worksheets	date_closed	date	10	√		null
forecast_worksheets	date_closed_timestamp	bigint unsigned	20	√		null
forecast_worksheets	date_entered	datetime	19	√		null
forecast_worksheets	date_modified	datetime	19	√		null
forecast_worksheets	deleted	bit	1	√		0
forecast_worksheets	description	text	65535	√		null
forecast_worksheets	discount_amount	decimal	26,6	√		null
forecast_worksheets	discount_price	decimal	26,6	√		null
forecast_worksheets	draft	int	11	√		0
forecast_worksheets	id	char	36
forecast_worksheets	lead_source	varchar	50	√		null
forecast_worksheets	likely_case	decimal	26,6	√		null
forecast_worksheets	list_price	decimal	26,6	√		null
forecast_worksheets	modified_user_id	char	36	√		null
forecast_worksheets	name	varchar	255	√		null
forecast_worksheets	next_step	varchar	100	√		null
forecast_worksheets	opportunity_id	char	36	√		null
forecast_worksheets	opportunity_name	varchar	255	√		null
forecast_worksheets	parent_id	char	36	√		null
forecast_worksheets	parent_type	varchar	255	√		null
forecast_worksheets	probability	double	22	√		null
forecast_worksheets	product_template_id	char	36	√		null
forecast_worksheets	product_template_name	varchar	255	√		null
forecast_worksheets	product_type	varchar	255	√		null
forecast_worksheets	quantity	int	5	√		1
forecast_worksheets	sales_stage	varchar	255	√		null
forecast_worksheets	sales_status	varchar	255	√		null
forecast_worksheets	sync_key	varchar	100	√		null
forecast_worksheets	team_id	char	36	√		null
forecast_worksheets	team_set_id	char	36	√		null
forecast_worksheets	total_amount	decimal	26,6	√		null
forecast_worksheets	worst_case	decimal	26,6	√		null
forecasts	base_rate	decimal	26,6	√		null
forecasts	best_case	decimal	26,6	√		null
forecasts	closed_amount	decimal	26,6	√		0.000000
forecasts	currency_id	char	36	√		-99
forecasts	date_entered	datetime	19	√		null
forecasts	date_modified	datetime	19	√		null
forecasts	deleted	bit	1	√		0
forecasts	forecast_type	varchar	100	√		null
forecasts	id	char	36
forecasts	likely_case	decimal	26,6	√		null
forecasts	opp_count	int	5	√		null
forecasts	opp_weigh_value	int	11	√		null
forecasts	pipeline_amount	decimal	26,6	√		0.000000
forecasts	pipeline_opp_count	int	5	√		0
forecasts	timeperiod_id	char	36	√		null
forecasts	user_id	char	36	√		null
forecasts	worst_case	decimal	26,6	√		null
fts_queue	bean_id	char	36	√		null
fts_queue	bean_module	varchar	100	√		null
fts_queue	date_created	datetime	19	√		null
fts_queue	date_modified	datetime	19	√		null
fts_queue	id	char	36
fts_queue	processed	bit	1	√		0
holidays	created_by	char	36	√		null
holidays	date_entered	datetime	19	√		null
holidays	date_modified	datetime	19	√		null
holidays	deleted	bit	1	√		0
holidays	description	text	65535	√		null
holidays	holiday_date	date	10	√		null
holidays	id	char	36
holidays	modified_user_id	char	36	√		null
holidays	name	varchar	255	√		null
holidays	person_id	char	36	√		null
holidays	person_type	varchar	255	√		null
holidays	related_module	varchar	255	√		null
holidays	related_module_id	char	36	√		null
holidays	resource_name	varchar	255	√		null
import_maps	assigned_user_id	char	36	√		null
import_maps	content	text	65535	√		null
import_maps	date_entered	datetime	19	√		null
import_maps	date_modified	datetime	19	√		null
import_maps	default_values	text	65535	√		null
import_maps	deleted	bit	1	√		0
import_maps	delimiter	varchar	1	√		,
import_maps	enclosure	varchar	1	√
import_maps	has_header	bit	1	√		1
import_maps	id	char	36
import_maps	is_published	varchar	3	√		no
import_maps	module	varchar	36	√		null
import_maps	name	varchar	254	√		null
import_maps	source	varchar	36	√		null
inbound_email	acl_team_set_id	char	36	√		null
inbound_email	auth_type	varchar	10	√		null
inbound_email	authorized_account	varchar	255	√		null
inbound_email	created_by	char	36	√		null
inbound_email	date_entered	datetime	19	√		null
inbound_email	date_modified	datetime	19	√		null
inbound_email	delete_seen	bit	1	√		0
inbound_email	deleted	bit	1	√		0
inbound_email	eapm_id	char	36	√		null
inbound_email	email_password	varchar	255	√		null
inbound_email	email_provider	varchar	20	√		other
inbound_email	email_user	varchar	100	√		null
inbound_email	group_id	char	36	√		null
inbound_email	groupfolder_id	char	36	√		null
inbound_email	id	varchar	255
inbound_email	is_personal	bit	1	√		0
inbound_email	mailbox	text	65535	√		null
inbound_email	mailbox_type	varchar	10	√		null
inbound_email	modified_user_id	char	36	√		null
inbound_email	name	varchar	255	√		null
inbound_email	port	int	5	√		null
inbound_email	server_url	varchar	100	√		null
inbound_email	service	varchar	50	√		null
inbound_email	status	varchar	100	√		Active
inbound_email	stored_options	text	65535	√		null
inbound_email	team_id	char	36	√		null
inbound_email	team_set_id	char	36	√		null
inbound_email	template_id	char	36	√		null
inbound_email_autoreply	autoreplied_to	varchar	100	√		null
inbound_email_autoreply	date_entered	datetime	19	√		null
inbound_email_autoreply	date_modified	datetime	19	√		null
inbound_email_autoreply	deleted	bit	1	√		0
inbound_email_autoreply	id	char	36
inbound_email_autoreply	ie_id	char	36
inbound_email_cache_ts	id	varchar	255
inbound_email_cache_ts	ie_timestamp	int unsigned	10	√		null
job_queue	assigned_user_id	char	36	√		null
job_queue	client	varchar	255	√		null
job_queue	data	longtext	2147483647	√		null
job_queue	date_entered	datetime	19	√		null
job_queue	date_modified	datetime	19	√		null
job_queue	deleted	bit	1	√		0
job_queue	execute_time	datetime	19	√		null
job_queue	failure_count	tinyint	4	√		null
job_queue	fallible	bit	1	√		0
job_queue	id	char	36
job_queue	interface	bit	1	√		0
job_queue	job_delay	int	11	√		null
job_queue	job_group	varchar	255	√		null
job_queue	message	text	65535	√		null
job_queue	module	varchar	255	√		null
job_queue	name	varchar	255	√		null
job_queue	percent_complete	int	11	√		null
job_queue	requeue	bit	1	√		0
job_queue	rerun	bit	1	√		0
job_queue	resolution	varchar	20	√		null
job_queue	retry_count	tinyint	4	√		null
job_queue	scheduler_id	char	36	√		null
job_queue	status	varchar	20	√		null
job_queue	target	varchar	255	√		null
kbarticles	acl_team_set_id	char	36	√		null
kbarticles	assigned_user_id	char	36	√		null
kbarticles	created_by	char	36	√		null
kbarticles	date_entered	datetime	19	√		null
kbarticles	date_modified	datetime	19	√		null
kbarticles	deleted	bit	1	√		0
kbarticles	description	text	65535	√		null
kbarticles	id	char	36
kbarticles	kbdocument_id	char	36	√		null
kbarticles	modified_user_id	char	36	√		null
kbarticles	name	varchar	255	√		null
kbarticles	sync_key	varchar	100	√		null
kbarticles	team_id	char	36	√		null
kbarticles	team_set_id	char	36	√		null
kbcontent_templates	acl_team_set_id	char	36	√		null
kbcontent_templates	body	longtext	2147483647	√		null
kbcontent_templates	created_by	char	36	√		null
kbcontent_templates	date_entered	datetime	19	√		null
kbcontent_templates	date_modified	datetime	19	√		null
kbcontent_templates	deleted	bit	1	√		0
kbcontent_templates	description	text	65535	√		null
kbcontent_templates	id	char	36
kbcontent_templates	modified_user_id	char	36	√		null
kbcontent_templates	name	varchar	255	√		null
kbcontent_templates	sync_key	varchar	100	√		null
kbcontent_templates	team_id	char	36	√		null
kbcontent_templates	team_set_id	char	36	√		null
kbcontent_templates_audit	after_value_string	varchar	255	√		null
kbcontent_templates_audit	after_value_text	text	65535	√		null
kbcontent_templates_audit	before_value_string	varchar	255	√		null
kbcontent_templates_audit	before_value_text	text	65535	√		null
kbcontent_templates_audit	created_by	char	36	√		null
kbcontent_templates_audit	data_type	varchar	100	√		null
kbcontent_templates_audit	date_created	datetime	19	√		null
kbcontent_templates_audit	date_updated	datetime	19	√		null
kbcontent_templates_audit	event_id	char	36
kbcontent_templates_audit	field_name	varchar	100	√		null
kbcontent_templates_audit	id	char	36
kbcontent_templates_audit	parent_id	char	36
kbcontents	acl_team_set_id	char	36	√		null
kbcontents	active_date	date	10	√		null
kbcontents	active_rev	tinyint	4	√		0
kbcontents	approved	bit	1	√		0
kbcontents	assigned_user_id	char	36	√		null
kbcontents	category_id	char	36	√		null
kbcontents	created_by	char	36	√		null
kbcontents	date_entered	datetime	19	√		null
kbcontents	date_modified	datetime	19	√		null
kbcontents	deleted	bit	1	√		0
kbcontents	description	text	65535	√		null
kbcontents	exp_date	date	10	√		null
kbcontents	id	char	36
kbcontents	is_external	tinyint	4	√		0
kbcontents	kbarticle_id	char	36	√		null
kbcontents	kbdocument_body	longtext	2147483647	√		null
kbcontents	kbdocument_id	char	36	√		null
kbcontents	kbsapprover_id	char	36	√		null
kbcontents	kbscase_id	char	36	√		null
kbcontents	language	varchar	2	√		null
kbcontents	modified_user_id	char	36	√		null
kbcontents	name	varchar	255	√		null
kbcontents	notuseful	int	11	√		0
kbcontents	revision	int	11	√		0
kbcontents	status	varchar	100	√		draft
kbcontents	sync_key	varchar	100	√		null
kbcontents	team_id	char	36	√		null
kbcontents	team_set_id	char	36	√		null
kbcontents	useful	int	11	√		0
kbcontents	viewcount	int	11	√		0
kbcontents_audit	after_value_string	varchar	255	√		null
kbcontents_audit	after_value_text	text	65535	√		null
kbcontents_audit	before_value_string	varchar	255	√		null
kbcontents_audit	before_value_text	text	65535	√		null
kbcontents_audit	created_by	char	36	√		null
kbcontents_audit	data_type	varchar	100	√		null
kbcontents_audit	date_created	datetime	19	√		null
kbcontents_audit	date_updated	datetime	19	√		null
kbcontents_audit	event_id	char	36
kbcontents_audit	field_name	varchar	100	√		null
kbcontents_audit	id	char	36
kbcontents_audit	parent_id	char	36
kbdocuments	acl_team_set_id	char	36	√		null
kbdocuments	assigned_user_id	char	36	√		null
kbdocuments	created_by	char	36	√		null
kbdocuments	date_entered	datetime	19	√		null
kbdocuments	date_modified	datetime	19	√		null
kbdocuments	deleted	bit	1	√		0
kbdocuments	description	text	65535	√		null
kbdocuments	id	char	36
kbdocuments	modified_user_id	char	36	√		null
kbdocuments	name	varchar	255	√		null
kbdocuments	sync_key	varchar	100	√		null
kbdocuments	team_id	char	36	√		null
kbdocuments	team_set_id	char	36	√		null
kbusefulness	contact_id	char	36	√		null
kbusefulness	date_modified	datetime	19	√		null
kbusefulness	deleted	bit	1	√		0
kbusefulness	id	char	36
kbusefulness	kbarticle_id	char	36
kbusefulness	ssid	char	36	√		null
kbusefulness	user_id	char	36
kbusefulness	vote	smallint	6	√		null
kbusefulness	zeroflag	tinyint	4	√		null
leads	account_description	text	65535	√		null
leads	account_id	char	36	√		null
leads	account_name	varchar	255	√		null
leads	acl_team_set_id	char	36	√		null
leads	alt_address_city	varchar	100	√		null
leads	alt_address_country	varchar	255	√		null
leads	alt_address_postalcode	varchar	20	√		null
leads	alt_address_state	varchar	100	√		null
leads	alt_address_street	varchar	150	√		null
leads	assigned_user_id	char	36	√		null
leads	assistant	varchar	75	√		null
leads	assistant_phone	varchar	100	√		null
leads	birthdate	date	10	√		null
leads	business_center_id	char	36	√		null
leads	campaign_id	char	36	√		null
leads	contact_id	char	36	√		null
leads	converted	bit	1	√		0
leads	created_by	char	36	√		null
leads	date_entered	datetime	19	√		null
leads	date_modified	datetime	19	√		null
leads	deleted	bit	1	√		0
leads	department	varchar	100	√		null
leads	description	text	65535	√		null
leads	dnb_principal_id	varchar	30	√		null
leads	do_not_call	bit	1	√		0
leads	dp_business_purpose	text	65535	√		null
leads	dp_consent_last_updated	date	10	√		null
leads	facebook	varchar	100	√		null
leads	first_name	varchar	255	√		null
leads	googleplus	varchar	100	√		null
leads	id	char	36
leads	last_name	varchar	255	√		null
leads	lead_source	varchar	100	√		null
leads	lead_source_description	text	65535	√		null
leads	mkto_id	int	11	√		null
leads	mkto_lead_score	int	11	√		null
leads	mkto_sync	bit	1	√		0
leads	modified_user_id	char	36	√		null
leads	opportunity_amount	varchar	50	√		null
leads	opportunity_id	char	36	√		null
leads	opportunity_name	varchar	255	√		null
leads	phone_fax	varchar	100	√		null
leads	phone_home	varchar	100	√		null
leads	phone_mobile	varchar	100	√		null
leads	phone_other	varchar	100	√		null
leads	phone_work	varchar	100	√		null
leads	picture	varchar	255	√		null
leads	portal_app	varchar	255	√		null
leads	portal_name	varchar	255	√		null
leads	preferred_language	varchar	255	√		null
leads	primary_address_city	varchar	100	√		null
leads	primary_address_country	varchar	255	√		null
leads	primary_address_postalcode	varchar	20	√		null
leads	primary_address_state	varchar	100	√		null
leads	primary_address_street	varchar	150	√		null
leads	refered_by	varchar	100	√		null
leads	reports_to_id	char	36	√		null
leads	salutation	varchar	255	√		null
leads	status	varchar	100	√		New
leads	status_description	text	65535	√		null
leads	sync_key	varchar	100	√		null
leads	team_id	char	36	√		null
leads	team_set_id	char	36	√		null
leads	title	varchar	100	√		null
leads	twitter	varchar	100	√		null
leads	website	varchar	255	√		null
leads_audit	after_value_string	varchar	255	√		null
leads_audit	after_value_text	text	65535	√		null
leads_audit	before_value_string	varchar	255	√		null
leads_audit	before_value_text	text	65535	√		null
leads_audit	created_by	char	36	√		null
leads_audit	data_type	varchar	100	√		null
leads_audit	date_created	datetime	19	√		null
leads_audit	date_updated	datetime	19	√		null
leads_audit	event_id	char	36
leads_audit	field_name	varchar	100	√		null
leads_audit	id	char	36
leads_audit	parent_id	char	36
leads_dataprivacy	dataprivacy_id	char	36	√		null
leads_dataprivacy	date_modified	datetime	19	√		null
leads_dataprivacy	deleted	bit	1	√		0
leads_dataprivacy	id	char	36
leads_dataprivacy	lead_id	char	36	√		null
linked_documents	date_modified	datetime	19	√		null
linked_documents	deleted	bit	1	√		0
linked_documents	document_id	char	36	√		null
linked_documents	document_revision_id	char	36	√		null
linked_documents	id	char	36
linked_documents	parent_id	char	36	√		null
linked_documents	parent_type	varchar	25	√		null
locked_field_bean_rel	bean_id	char	36
locked_field_bean_rel	bean_module	varchar	100	√		null
locked_field_bean_rel	date_modified	datetime	19	√		null
locked_field_bean_rel	deleted	bit	1	√		0
locked_field_bean_rel	id	char	36
locked_field_bean_rel	pd_id	char	36
manufacturers	created_by	char	36	√		null
manufacturers	date_entered	datetime	19	√		null
manufacturers	date_modified	datetime	19	√		null
manufacturers	deleted	bit	1	√		0
manufacturers	description	text	65535	√		null
manufacturers	id	char	36
manufacturers	list_order	int	4	√		null
manufacturers	modified_user_id	char	36	√		null
manufacturers	name	varchar	255	√		null
manufacturers	status	varchar	100	√		null
manufacturers	sync_key	varchar	100	√		null
meetings	acl_team_set_id	char	36	√		null
meetings	assigned_user_id	char	36	√		null
meetings	created_by	char	36	√		null
meetings	creator	varchar	50	√		null
meetings	date_end	datetime	19	√		null
meetings	date_entered	datetime	19	√		null
meetings	date_modified	datetime	19	√		null
meetings	date_start	datetime	19	√		null
meetings	deleted	bit	1	√		0
meetings	description	text	65535	√		null
meetings	displayed_url	varchar	400	√		null
meetings	duration_hours	int	11	√		0
meetings	duration_minutes	int	2	√		0
meetings	email_reminder_sent	bit	1	√		0
meetings	email_reminder_time	int	11	√		-1
meetings	external_id	varchar	50	√		null
meetings	host_url	varchar	600	√		null
meetings	id	char	36
meetings	join_url	varchar	600	√		null
meetings	location	varchar	50	√		null
meetings	modified_user_id	char	36	√		null
meetings	name	varchar	255	√		null
meetings	outlook_id	varchar	255	√		null
meetings	parent_id	char	36	√		null
meetings	parent_type	varchar	100	√		null
meetings	password	varchar	50	√		null
meetings	recurrence_id	datetime	19	√		null
meetings	recurring_source	varchar	36	√		null
meetings	reminder_time	int	11	√		-1
meetings	repeat_count	int	7	√		null
meetings	repeat_days	varchar	128	√		null
meetings	repeat_dow	varchar	7	√		null
meetings	repeat_interval	int	3	√		1
meetings	repeat_ordinal	varchar	36	√		null
meetings	repeat_parent_id	char	36	√		null
meetings	repeat_selector	varchar	36	√		null
meetings	repeat_type	varchar	36	√		null
meetings	repeat_unit	varchar	36	√		null
meetings	repeat_until	date	10	√		null
meetings	sequence	int	11	√		0
meetings	status	varchar	100	√		Planned
meetings	sync_key	varchar	100	√		null
meetings	team_id	char	36	√		null
meetings	team_set_id	char	36	√		null
meetings	type	varchar	255	√		Sugar
meetings_audit	after_value_string	varchar	255	√		null
meetings_audit	after_value_text	text	65535	√		null
meetings_audit	before_value_string	varchar	255	√		null
meetings_audit	before_value_text	text	65535	√		null
meetings_audit	created_by	char	36	√		null
meetings_audit	data_type	varchar	100	√		null
meetings_audit	date_created	datetime	19	√		null
meetings_audit	date_updated	datetime	19	√		null
meetings_audit	event_id	char	36
meetings_audit	field_name	varchar	100	√		null
meetings_audit	id	char	36
meetings_audit	parent_id	char	36
meetings_contacts	accept_status	varchar	25	√		none
meetings_contacts	contact_id	char	36	√		null
meetings_contacts	date_modified	datetime	19	√		null
meetings_contacts	deleted	bit	1	√		0
meetings_contacts	id	char	36
meetings_contacts	meeting_id	char	36	√		null
meetings_contacts	required	varchar	1	√		1
meetings_leads	accept_status	varchar	25	√		none
meetings_leads	date_modified	datetime	19	√		null
meetings_leads	deleted	bit	1	√		0
meetings_leads	id	char	36
meetings_leads	lead_id	char	36	√		null
meetings_leads	meeting_id	char	36	√		null
meetings_leads	required	varchar	1	√		1
meetings_users	accept_status	varchar	25	√		none
meetings_users	date_modified	datetime	19	√		null
meetings_users	deleted	bit	1	√		0
meetings_users	id	char	36
meetings_users	meeting_id	char	36	√		null
meetings_users	required	varchar	1	√		1
meetings_users	user_id	char	36	√		null
messages	acl_team_set_id	char	36	√		null
messages	assigned_user_id	char	36	√		null
messages	aws_comprehend_data	text	65535	√		null
messages	aws_contact_id	char	36	√		null
messages	channel_type	varchar	50	√		null
messages	contact_id	char	36	√		null
messages	conversation	longtext	2147483647	√		null
messages	conversation_link	varchar	512	√		null
messages	created_by	char	36	√		null
messages	date_end	datetime	19	√		null
messages	date_entered	datetime	19	√		null
messages	date_modified	datetime	19	√		null
messages	date_start	datetime	19	√		null
messages	deleted	bit	1	√		0
messages	description	text	65535	√		null
messages	direction	varchar	50	√		null
messages	id	char	36
messages	modified_user_id	char	36	√		null
messages	name	varchar	255	√		null
messages	parent_id	char	36	√		null
messages	parent_type	varchar	255	√		null
messages	sentiment	varchar	36	√		null
messages	status	varchar	50	√		null
messages	sync_key	varchar	100	√		null
messages	team_id	char	36	√		null
messages	team_set_id	char	36	√		null
messages_audit	after_value_string	varchar	255	√		null
messages_audit	after_value_text	text	65535	√		null
messages_audit	before_value_string	varchar	255	√		null
messages_audit	before_value_text	text	65535	√		null
messages_audit	created_by	char	36	√		null
messages_audit	data_type	varchar	100	√		null
messages_audit	date_created	datetime	19	√		null
messages_audit	date_updated	datetime	19	√		null
messages_audit	event_id	char	36
messages_audit	field_name	varchar	100	√		null
messages_audit	id	char	36
messages_audit	parent_id	char	36
messages_contacts	accept_status	varchar	25	√		none
messages_contacts	contact_id	char	36	√		null
messages_contacts	date_modified	datetime	19	√		null
messages_contacts	deleted	bit	1	√		0
messages_contacts	id	char	36
messages_contacts	message_id	char	36	√		null
messages_contacts	required	varchar	1	√		1
messages_leads	accept_status	varchar	25	√		none
messages_leads	date_modified	datetime	19	√		null
messages_leads	deleted	bit	1	√		0
messages_leads	id	char	36
messages_leads	lead_id	char	36	√		null
messages_leads	message_id	char	36	√		null
messages_leads	required	varchar	1	√		1
messages_users	accept_status	varchar	25	√		none
messages_users	date_modified	datetime	19	√		null
messages_users	deleted	bit	1	√		0
messages_users	id	char	36
messages_users	message_id	char	36	√		null
messages_users	required	varchar	1	√		1
messages_users	user_id	char	36	√		null
metadata_cache	data	longblob	2147483647	√		null
metadata_cache	date_modified	datetime	19	√		null
metadata_cache	deleted	bit	1	√		0
metadata_cache	id	char	36
metadata_cache	type	varchar	255	√		null
mobile_devices	assigned_user_id	char	36	√		null
mobile_devices	created_by	char	36	√		null
mobile_devices	date_entered	datetime	19	√		null
mobile_devices	date_modified	datetime	19	√		null
mobile_devices	deleted	bit	1	√		0
mobile_devices	description	text	65535	√		null
mobile_devices	device_id	varchar	256	√		null
mobile_devices	device_platform	varchar	32	√		null
mobile_devices	id	char	36
mobile_devices	modified_user_id	char	36	√		null
mobile_devices	name	varchar	255	√		null
mobile_devices	sync_key	varchar	100	√		null
notes	acl_team_set_id	char	36	√		null
notes	assigned_user_id	char	36	√		null
notes	attachment_flag	bit	1	√		0
notes	contact_id	char	36	√		null
notes	created_by	char	36	√		null
notes	date_entered	datetime	19	√		null
notes	date_modified	datetime	19	√		null
notes	deleted	bit	1	√		0
notes	description	text	65535	√		null
notes	email_id	char	36	√		null
notes	email_type	varchar	255	√		null
notes	embed_flag	bit	1	√		0
notes	entry_source	varchar	255	√		internal
notes	file_ext	varchar	100	√		null
notes	file_mime_type	varchar	100	√		null
notes	file_size	int	11	√		0
notes	file_source	varchar	32	√		null
notes	filename	varchar	255	√		null
notes	id	char	36
notes	modified_user_id	char	36	√		null
notes	name	varchar	255	√		null
notes	note_parent_id	char	36	√		null
notes	parent_id	char	36	√		null
notes	parent_type	varchar	255	√		null
notes	portal_flag	bit	1	√		1
notes	sync_key	varchar	100	√		null
notes	team_id	char	36	√		null
notes	team_set_id	char	36	√		null
notes	upload_id	char	36	√		null
notes_audit	after_value_string	varchar	255	√		null
notes_audit	after_value_text	text	65535	√		null
notes_audit	before_value_string	varchar	255	√		null
notes_audit	before_value_text	text	65535	√		null
notes_audit	created_by	char	36	√		null
notes_audit	data_type	varchar	100	√		null
notes_audit	date_created	datetime	19	√		null
notes_audit	date_updated	datetime	19	√		null
notes_audit	event_id	char	36
notes_audit	field_name	varchar	100	√		null
notes_audit	id	char	36
notes_audit	parent_id	char	36
notifications	assigned_user_id	char	36	√		null
notifications	created_by	char	36	√		null
notifications	date_entered	datetime	19	√		null
notifications	date_modified	datetime	19	√		null
notifications	deleted	bit	1	√		0
notifications	description	text	65535	√		null
notifications	id	char	36
notifications	is_read	bit	1	√		0
notifications	modified_user_id	char	36	√		null
notifications	name	varchar	255	√		null
notifications	parent_id	char	36	√		null
notifications	parent_type	varchar	100	√		null
notifications	severity	varchar	15	√		null
notifications	sync_key	varchar	100	√		null
oauth_consumer	assigned_user_id	char	36	√		null
oauth_consumer	c_key	varchar	255	√		null
oauth_consumer	c_secret	varchar	255	√		null
oauth_consumer	client_type	varchar	50	√		user
oauth_consumer	created_by	char	36	√		null
oauth_consumer	date_entered	datetime	19	√		null
oauth_consumer	date_modified	datetime	19	√		null
oauth_consumer	deleted	bit	1	√		0
oauth_consumer	description	text	65535	√		null
oauth_consumer	id	char	36
oauth_consumer	modified_user_id	char	36	√		null
oauth_consumer	name	varchar	255	√		null
oauth_consumer	oauth_type	varchar	50	√		oauth1
oauth_consumer	sync_key	varchar	100	√		null
oauth_nonce	conskey	varchar	32
oauth_nonce	nonce	varchar	32
oauth_nonce	nonce_ts	bigint	20	√		null
oauth_tokens	assigned_user_id	char	36	√		null
oauth_tokens	callback_url	varchar	255	√		null
oauth_tokens	consumer	char	36
oauth_tokens	contact_id	char	36	√		null
oauth_tokens	deleted	bit	1			0
oauth_tokens	download_token	varchar	36	√		null
oauth_tokens	expire_ts	bigint	20	√		-1
oauth_tokens	id	char	36
oauth_tokens	platform	varchar	255	√		base
oauth_tokens	secret	varchar	32	√		null
oauth_tokens	token_ts	bigint	20	√		null
oauth_tokens	tstate	varchar	1	√		null
oauth_tokens	verify	varchar	32	√		null
opportunities	acl_team_set_id	char	36	√		null
opportunities	amount	decimal	26,6	√		null
opportunities	amount_usdollar	decimal	26,6	√		null
opportunities	assigned_user_id	char	36	√		null
opportunities	base_rate	decimal	26,6	√		null
opportunities	best_case	decimal	26,6	√		null
opportunities	campaign_id	char	36	√		null
opportunities	closed_revenue_line_items	int	11	√		null
opportunities	commit_stage	varchar	50	√		null
opportunities	created_by	char	36	√		null
opportunities	currency_id	char	36	√		-99
opportunities	date_closed	date	10	√		null
opportunities	date_closed_timestamp	bigint unsigned	20	√		null
opportunities	date_entered	datetime	19	√		null
opportunities	date_modified	datetime	19	√		null
opportunities	deleted	bit	1	√		0
opportunities	description	text	65535	√		null
opportunities	id	char	36
opportunities	included_revenue_line_items	int	11	√		null
opportunities	lead_source	varchar	50	√		null
opportunities	mkto_id	int	11	√		null
opportunities	mkto_sync	bit	1	√		0
opportunities	modified_user_id	char	36	√		null
opportunities	name	varchar	255	√		null
opportunities	next_step	varchar	100	√		null
opportunities	opportunity_type	varchar	255	√		null
opportunities	probability	double	22	√		null
opportunities	renewal	bit	1	√		0
opportunities	renewal_parent_id	char	36	√		null
opportunities	sales_stage	varchar	255	√		Prospecting
opportunities	sales_status	varchar	255	√		New
opportunities	service_duration_unit	varchar	50	√		null
opportunities	service_duration_value	int	5	√		null
opportunities	service_open_flex_duration_rlis	int	11	√		0
opportunities	service_open_revenue_line_items	int	11	√		null
opportunities	service_start_date	date	10	√		null
opportunities	sync_key	varchar	100	√		null
opportunities	team_id	char	36	√		null
opportunities	team_set_id	char	36	√		null
opportunities	total_revenue_line_items	int	11	√		null
opportunities	worst_case	decimal	26,6	√		null
opportunities_audit	after_value_string	varchar	255	√		null
opportunities_audit	after_value_text	text	65535	√		null
opportunities_audit	before_value_string	varchar	255	√		null
opportunities_audit	before_value_text	text	65535	√		null
opportunities_audit	created_by	char	36	√		null
opportunities_audit	data_type	varchar	100	√		null
opportunities_audit	date_created	datetime	19	√		null
opportunities_audit	date_updated	datetime	19	√		null
opportunities_audit	event_id	char	36
opportunities_audit	field_name	varchar	100	√		null
opportunities_audit	id	char	36
opportunities_audit	parent_id	char	36
opportunities_contacts	contact_id	char	36	√		null
opportunities_contacts	contact_role	varchar	50	√		null
opportunities_contacts	date_modified	datetime	19	√		null
opportunities_contacts	deleted	bit	1	√		0
opportunities_contacts	id	char	36
opportunities_contacts	opportunity_id	char	36	√		null
outbound_email	acl_team_set_id	char	36	√		null
outbound_email	authorized_account	varchar	255	√		null
outbound_email	deleted	bit	1	√		0
outbound_email	eapm_id	char	36	√		null
outbound_email	email_address_id	char	36	√		null
outbound_email	id	char	36
outbound_email	mail_authtype	varchar	10	√		null
outbound_email	mail_sendtype	varchar	8	√		SMTP
outbound_email	mail_smtpauth_req	bit	1	√		0
outbound_email	mail_smtppass	varchar	255	√		null
outbound_email	mail_smtpport	int	5	√		465
outbound_email	mail_smtpserver	varchar	100	√		null
outbound_email	mail_smtpssl	int	1	√		1
outbound_email	mail_smtptype	varchar	20	√		other
outbound_email	mail_smtpuser	varchar	100	√		null
outbound_email	name	varchar	255	√		null
outbound_email	reply_to_email_address_id	char	36	√		null
outbound_email	reply_to_name	varchar	255	√		null
outbound_email	team_id	char	36	√		null
outbound_email	team_set_id	char	36	√		null
outbound_email	type	varchar	15	√		user
outbound_email	user_id	char	36
pdfmanager	acl_team_set_id	char	36	√		null
pdfmanager	assigned_user_id	char	36	√		null
pdfmanager	author	varchar	255	√		SugarCRM
pdfmanager	base_module	varchar	100	√
pdfmanager	body_html	text	65535	√		null
pdfmanager	created_by	char	36	√		null
pdfmanager	date_entered	datetime	19	√		null
pdfmanager	date_modified	datetime	19	√		null
pdfmanager	deleted	bit	1	√		0
pdfmanager	description	text	65535	√		null
pdfmanager	field	varchar	100	√		0
pdfmanager	footer_text	varchar	255	√		null
pdfmanager	header_logo	varchar	255	√		null
pdfmanager	header_text	varchar	255	√		null
pdfmanager	header_title	varchar	255	√		null
pdfmanager	id	char	36
pdfmanager	keywords	varchar	255	√		null
pdfmanager	modified_user_id	char	36	√		null
pdfmanager	name	varchar	255	√		null
pdfmanager	published	varchar	100	√		yes
pdfmanager	subject	varchar	255	√		null
pdfmanager	sync_key	varchar	100	√		null
pdfmanager	team_id	char	36	√		null
pdfmanager	team_set_id	char	36	√		null
pdfmanager	template_name	varchar	255	√		null
pdfmanager	title	varchar	255	√		null
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_bpm_activity_definition	act_avl_before_type	varchar	40	√		null
pmse_bpm_activity_definition	act_avl_count	int	4	√		0
pmse_bpm_activity_definition	act_avl_type	varchar	40	√		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_email_process_user	bit	1	√		0
pmse_bpm_activity_definition	act_email_template_id	text	65535	√		null
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_definition	act_last_user_assigned	varchar	40	√
pmse_bpm_activity_definition	act_params	text	65535	√		null
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_bpm_activity_definition	act_related_modules	text	65535	√		null
pmse_bpm_activity_definition	act_required_fields	text	65535	√		null
pmse_bpm_activity_definition	act_reserve_user	varchar	36	√
pmse_bpm_activity_definition	act_response_buttons	varchar	40	√
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_bpm_activity_definition	act_set_by_avl	bit	1	√		0
pmse_bpm_activity_definition	act_type	varchar	32	√		TASK
pmse_bpm_activity_definition	act_update_record_owner	int	4	√		0
pmse_bpm_activity_definition	act_value_based_assignment	varchar	255	√
pmse_bpm_activity_definition	assigned_user_id	char	36	√		null
pmse_bpm_activity_definition	created_by	char	36	√		null
pmse_bpm_activity_definition	date_entered	datetime	19	√		null
pmse_bpm_activity_definition	date_modified	datetime	19	√		null
pmse_bpm_activity_definition	deleted	bit	1	√		0
pmse_bpm_activity_definition	description	text	65535	√		null
pmse_bpm_activity_definition	execution_mode	varchar	10	√		DEFAULT
pmse_bpm_activity_definition	id	char	36
pmse_bpm_activity_definition	modified_user_id	char	36	√		null
pmse_bpm_activity_definition	name	varchar	255	√		null
pmse_bpm_activity_definition	pro_id	varchar	36	√
pmse_bpm_activity_definition	sync_key	varchar	100	√		null
pmse_bpm_activity_step	act_criteria	text	65535	√		null
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_bpm_activity_step	assigned_user_id	char	36	√		null
pmse_bpm_activity_step	created_by	char	36	√		null
pmse_bpm_activity_step	date_entered	datetime	19	√		null
pmse_bpm_activity_step	date_modified	datetime	19	√		null
pmse_bpm_activity_step	deleted	bit	1	√		0
pmse_bpm_activity_step	description	text	65535	√		null
pmse_bpm_activity_step	id	char	36
pmse_bpm_activity_step	modified_user_id	char	36	√		null
pmse_bpm_activity_step	name	varchar	255	√		null
pmse_bpm_activity_step	pro_id	varchar	36	√
pmse_bpm_activity_step	sync_key	varchar	100	√		null
pmse_bpm_activity_user	act_group_id	varchar	40	√
pmse_bpm_activity_user	act_user_id	varchar	40	√
pmse_bpm_activity_user	act_user_type	varchar	32	√
pmse_bpm_activity_user	assigned_user_id	char	36	√		null
pmse_bpm_activity_user	created_by	char	36	√		null
pmse_bpm_activity_user	date_entered	datetime	19	√		null
pmse_bpm_activity_user	date_modified	datetime	19	√		null
pmse_bpm_activity_user	deleted	bit	1	√		0
pmse_bpm_activity_user	description	text	65535	√		null
pmse_bpm_activity_user	id	char	36
pmse_bpm_activity_user	modified_user_id	char	36	√		null
pmse_bpm_activity_user	name	varchar	255	√		null
pmse_bpm_activity_user	pro_id	varchar	36	√
pmse_bpm_activity_user	sync_key	varchar	100	√		null
pmse_bpm_config	assigned_user_id	char	36	√		null
pmse_bpm_config	cfg_status	varchar	20	√		ACTIVE
pmse_bpm_config	cfg_value	text	65535	√		null
pmse_bpm_config	created_by	char	36	√		null
pmse_bpm_config	date_entered	datetime	19	√		null
pmse_bpm_config	date_modified	datetime	19	√		null
pmse_bpm_config	deleted	bit	1	√		0
pmse_bpm_config	description	text	65535	√		null
pmse_bpm_config	id	char	36
pmse_bpm_config	modified_user_id	char	36	√		null
pmse_bpm_config	name	varchar	255	√		null
pmse_bpm_config	sync_key	varchar	100	√		null
pmse_bpm_dynamic_forms	assigned_user_id	char	36	√		null
pmse_bpm_dynamic_forms	created_by	char	36	√		null
pmse_bpm_dynamic_forms	date_entered	datetime	19	√		null
pmse_bpm_dynamic_forms	date_modified	datetime	19	√		null
pmse_bpm_dynamic_forms	deleted	bit	1	√		0
pmse_bpm_dynamic_forms	description	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
pmse_bpm_dynamic_forms	id	char	36
pmse_bpm_dynamic_forms	modified_user_id	char	36	√		null
pmse_bpm_dynamic_forms	name	varchar	255	√		null
pmse_bpm_dynamic_forms	prj_id	varchar	36	√
pmse_bpm_dynamic_forms	pro_id	varchar	36	√
pmse_bpm_dynamic_forms	sync_key	varchar	100	√		null
pmse_bpm_event_definition	assigned_user_id	char	36	√		null
pmse_bpm_event_definition	created_by	char	36	√		null
pmse_bpm_event_definition	date_entered	datetime	19	√		null
pmse_bpm_event_definition	date_modified	datetime	19	√		null
pmse_bpm_event_definition	deleted	bit	1	√		0
pmse_bpm_event_definition	description	text	65535	√		null
pmse_bpm_event_definition	evn_criteria	text	65535	√		null
pmse_bpm_event_definition	evn_module	varchar	128	√		Leads
pmse_bpm_event_definition	evn_params	text	65535	√		null
pmse_bpm_event_definition	evn_script	text	65535	√		null
pmse_bpm_event_definition	evn_status	varchar	32	√		ACTIVE
pmse_bpm_event_definition	evn_type	varchar	30	√		START
pmse_bpm_event_definition	execution_mode	varchar	10	√		DEFAULT
pmse_bpm_event_definition	id	char	36
pmse_bpm_event_definition	modified_user_id	char	36	√		null
pmse_bpm_event_definition	name	varchar	255	√		null
pmse_bpm_event_definition	prj_id	varchar	36	√
pmse_bpm_event_definition	pro_id	varchar	36	√
pmse_bpm_event_definition	sync_key	varchar	100	√		null
pmse_bpm_flow	assigned_user_id	char	36	√		null
pmse_bpm_flow	bpmn_id	varchar	36	√
pmse_bpm_flow	bpmn_type	varchar	32	√
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_bpm_flow	cas_assignment_method	varchar	32	√
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_bpm_flow	cas_finished	int	4	√		0
pmse_bpm_flow	cas_flow_status	varchar	32	√		OPEN
pmse_bpm_flow	cas_id	int	4	√		null
pmse_bpm_flow	cas_index	int	4	√		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_bpm_flow	cas_sugar_action	varchar	40	√		DetailView
pmse_bpm_flow	cas_sugar_module	varchar	128	√
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_flow	cas_user_id	varchar	40	√
pmse_bpm_flow	created_by	char	36	√		null
pmse_bpm_flow	date_entered	datetime	19	√		null
pmse_bpm_flow	date_modified	datetime	19	√		null
pmse_bpm_flow	deleted	bit	1	√		0
pmse_bpm_flow	description	text	65535	√		null
pmse_bpm_flow	id	char	36
pmse_bpm_flow	modified_user_id	char	36	√		null
pmse_bpm_flow	name	varchar	255	√		null
pmse_bpm_flow	pro_id	varchar	36	√
pmse_bpm_flow	sync_key	varchar	100	√		null
pmse_bpm_form_action	act_id	varchar	36	√
pmse_bpm_form_action	assigned_user_id	char	36	√		null
pmse_bpm_form_action	cas_id	int	4	√		null
pmse_bpm_form_action	created_by	char	36	√		null
pmse_bpm_form_action	date_entered	datetime	19	√		null
pmse_bpm_form_action	date_modified	datetime	19	√		null
pmse_bpm_form_action	deleted	bit	1	√		0
pmse_bpm_form_action	description	text	65535	√		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	√
pmse_bpm_form_action	id	char	36
pmse_bpm_form_action	modified_user_id	char	36	√		null
pmse_bpm_form_action	name	varchar	255	√		null
pmse_bpm_form_action	pro_id	varchar	36	√
pmse_bpm_form_action	sync_key	varchar	100	√		null
pmse_bpm_form_action	user_id	varchar	36	√
pmse_bpm_gateway_definition	assigned_user_id	char	36	√		null
pmse_bpm_gateway_definition	created_by	char	36	√		null
pmse_bpm_gateway_definition	date_entered	datetime	19	√		null
pmse_bpm_gateway_definition	date_modified	datetime	19	√		null
pmse_bpm_gateway_definition	deleted	bit	1	√		0
pmse_bpm_gateway_definition	description	text	65535	√		null
pmse_bpm_gateway_definition	execution_mode	varchar	10	√		DEFAULT
pmse_bpm_gateway_definition	id	char	36
pmse_bpm_gateway_definition	modified_user_id	char	36	√		null
pmse_bpm_gateway_definition	name	varchar	255	√		null
pmse_bpm_gateway_definition	prj_id	varchar	36	√
pmse_bpm_gateway_definition	pro_id	varchar	36	√
pmse_bpm_gateway_definition	sync_key	varchar	100	√		null
pmse_bpm_group	assigned_user_id	char	36	√		null
pmse_bpm_group	created_by	char	36	√		null
pmse_bpm_group	date_entered	datetime	19	√		null
pmse_bpm_group	date_modified	datetime	19	√		null
pmse_bpm_group	deleted	bit	1	√		0
pmse_bpm_group	description	text	65535	√		null
pmse_bpm_group	grp_parent_group	int	4	√		0
pmse_bpm_group	grp_uid	varchar	36	√
pmse_bpm_group	id	char	36
pmse_bpm_group	modified_user_id	char	36	√		null
pmse_bpm_group	name	varchar	255	√		null
pmse_bpm_group	sync_key	varchar	100	√		null
pmse_bpm_group_user	assigned_user_id	char	36	√		null
pmse_bpm_group_user	created_by	char	36	√		null
pmse_bpm_group_user	date_entered	datetime	19	√		null
pmse_bpm_group_user	date_modified	datetime	19	√		null
pmse_bpm_group_user	deleted	bit	1	√		0
pmse_bpm_group_user	description	text	65535	√		null
pmse_bpm_group_user	id	char	36
pmse_bpm_group_user	modified_user_id	char	36	√		null
pmse_bpm_group_user	name	varchar	255	√		null
pmse_bpm_group_user	sync_key	varchar	100	√		null
pmse_bpm_group_user	user_id	varchar	36	√
pmse_bpm_notes	assigned_user_id	char	36	√		null
pmse_bpm_notes	cas_id	varchar	36	√
pmse_bpm_notes	cas_index	int	4	√		null
pmse_bpm_notes	created_by	char	36	√		null
pmse_bpm_notes	date_entered	datetime	19	√		null
pmse_bpm_notes	date_modified	datetime	19	√		null
pmse_bpm_notes	deleted	bit	1	√		0
pmse_bpm_notes	description	text	65535	√		null
pmse_bpm_notes	id	char	36
pmse_bpm_notes	modified_user_id	char	36	√		null
pmse_bpm_notes	name	varchar	255	√		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	√
pmse_bpm_notes	sync_key	varchar	100	√		null
pmse_bpm_process_definition	assigned_user_id	char	36	√		null
pmse_bpm_process_definition	created_by	char	36	√		null
pmse_bpm_process_definition	date_entered	datetime	19	√		null
pmse_bpm_process_definition	date_modified	datetime	19	√		null
pmse_bpm_process_definition	deleted	bit	1	√		0
pmse_bpm_process_definition	description	text	65535	√		null
pmse_bpm_process_definition	execution_mode	varchar	10	√		SYNC
pmse_bpm_process_definition	id	char	36
pmse_bpm_process_definition	modified_user_id	char	36	√		null
pmse_bpm_process_definition	name	varchar	255	√		null
pmse_bpm_process_definition	prj_id	varchar	36	√
pmse_bpm_process_definition	pro_locked_variables	text	65535	√		null
pmse_bpm_process_definition	pro_module	varchar	255	√
pmse_bpm_process_definition	pro_status	varchar	255	√
pmse_bpm_process_definition	pro_terminate_variables	text	65535	√		null
pmse_bpm_process_definition	sync_key	varchar	100	√		null
pmse_bpm_related_dependency	assigned_user_id	char	36	√		null
pmse_bpm_related_dependency	created_by	char	36	√		null
pmse_bpm_related_dependency	date_entered	datetime	19	√		null
pmse_bpm_related_dependency	date_modified	datetime	19	√		null
pmse_bpm_related_dependency	deleted	bit	1	√		0
pmse_bpm_related_dependency	description	text	65535	√		null
pmse_bpm_related_dependency	evn_activity_ref	varchar	36	√
pmse_bpm_related_dependency	evn_attached_to	varchar	36	√
pmse_bpm_related_dependency	evn_behavior	varchar	36	√
pmse_bpm_related_dependency	evn_cancel_activity	varchar	36	√
pmse_bpm_related_dependency	evn_condition	varchar	36	√
pmse_bpm_related_dependency	evn_criteria	text	65535	√		null
pmse_bpm_related_dependency	evn_error_code	varchar	36	√
pmse_bpm_related_dependency	evn_error_name	varchar	36	√
pmse_bpm_related_dependency	evn_escalation_code	varchar	36	√
pmse_bpm_related_dependency	evn_escalation_name	varchar	36	√
pmse_bpm_related_dependency	evn_id	varchar	36	√
pmse_bpm_related_dependency	evn_is_interrupting	varchar	36	√
pmse_bpm_related_dependency	evn_marker	varchar	36	√
pmse_bpm_related_dependency	evn_message	varchar	36	√
pmse_bpm_related_dependency	evn_module	varchar	36	√
pmse_bpm_related_dependency	evn_operation_implementation	varchar	36	√
pmse_bpm_related_dependency	evn_operation_name	varchar	36	√
pmse_bpm_related_dependency	evn_params	text	65535	√		null
pmse_bpm_related_dependency	evn_script	text	65535	√		null
pmse_bpm_related_dependency	evn_status	varchar	36	√
pmse_bpm_related_dependency	evn_time_cycle	varchar	36	√
pmse_bpm_related_dependency	evn_time_date	varchar	36	√
pmse_bpm_related_dependency	evn_time_duration	varchar	36	√
pmse_bpm_related_dependency	evn_type	varchar	36	√
pmse_bpm_related_dependency	evn_uid	varchar	36	√
pmse_bpm_related_dependency	evn_wait_for_completion	varchar	36	√
pmse_bpm_related_dependency	id	char	36
pmse_bpm_related_dependency	modified_user_id	char	36	√		null
pmse_bpm_related_dependency	name	varchar	255	√		null
pmse_bpm_related_dependency	prj_id	varchar	36	√
pmse_bpm_related_dependency	pro_id	varchar	36	√
pmse_bpm_related_dependency	pro_locked_variables	text	65535	√		null
pmse_bpm_related_dependency	pro_module	varchar	36	√
pmse_bpm_related_dependency	pro_status	varchar	36	√
pmse_bpm_related_dependency	pro_terminate_variables	text	65535	√		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	255	√
pmse_bpm_related_dependency	rel_element_type	varchar	32	√
pmse_bpm_related_dependency	rel_process_module	varchar	32	√
pmse_bpm_related_dependency	sync_key	varchar	100	√		null
pmse_bpm_thread	assigned_user_id	char	36	√		null
pmse_bpm_thread	cas_flow_index	int	4	√		0
pmse_bpm_thread	cas_id	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_bpm_thread	created_by	char	36	√		null
pmse_bpm_thread	date_entered	datetime	19	√		null
pmse_bpm_thread	date_modified	datetime	19	√		null
pmse_bpm_thread	deleted	bit	1	√		0
pmse_bpm_thread	description	text	65535	√		null
pmse_bpm_thread	id	char	36
pmse_bpm_thread	modified_user_id	char	36	√		null
pmse_bpm_thread	name	varchar	255	√		null
pmse_bpm_thread	sync_key	varchar	100	√		null
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_bpmn_activity	act_default_flow	int	4	√		null
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_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_bpmn_activity	act_referer	int	4	√		null
pmse_bpmn_activity	act_script	text	65535	√		null
pmse_bpmn_activity	act_script_type	varchar	255	√
pmse_bpmn_activity	act_start_quantity	int	4	√		1
pmse_bpmn_activity	act_task_type	varchar	20	√		EMPTY
pmse_bpmn_activity	act_test_before	int	4	√		0
pmse_bpmn_activity	act_type	varchar	30	√		TASK
pmse_bpmn_activity	act_uid	varchar	36	√
pmse_bpmn_activity	assigned_user_id	char	36	√		null
pmse_bpmn_activity	created_by	char	36	√		null
pmse_bpmn_activity	date_entered	datetime	19	√		null
pmse_bpmn_activity	date_modified	datetime	19	√		null
pmse_bpmn_activity	deleted	bit	1	√		0
pmse_bpmn_activity	description	text	65535	√		null
pmse_bpmn_activity	id	char	36
pmse_bpmn_activity	modified_user_id	char	36	√		null
pmse_bpmn_activity	name	varchar	255	√		null
pmse_bpmn_activity	prj_id	varchar	36	√
pmse_bpmn_activity	pro_id	varchar	36	√
pmse_bpmn_activity	sync_key	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	√
pmse_bpmn_artifact	assigned_user_id	char	36	√		null
pmse_bpmn_artifact	created_by	char	36	√		null
pmse_bpmn_artifact	date_entered	datetime	19	√		null
pmse_bpmn_artifact	date_modified	datetime	19	√		null
pmse_bpmn_artifact	deleted	bit	1	√		0
pmse_bpmn_artifact	description	text	65535	√		null
pmse_bpmn_artifact	id	char	36
pmse_bpmn_artifact	modified_user_id	char	36	√		null
pmse_bpmn_artifact	name	varchar	255	√		null
pmse_bpmn_artifact	prj_id	varchar	36	√
pmse_bpmn_artifact	pro_id	varchar	36	√
pmse_bpmn_artifact	sync_key	varchar	100	√		null
pmse_bpmn_bound	assigned_user_id	char	36	√		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_bpmn_bound	created_by	char	36	√		null
pmse_bpmn_bound	date_entered	datetime	19	√		null
pmse_bpmn_bound	date_modified	datetime	19	√		null
pmse_bpmn_bound	deleted	bit	1	√		0
pmse_bpmn_bound	description	text	65535	√		null
pmse_bpmn_bound	dia_id	varchar	36	√
pmse_bpmn_bound	element_id	varchar	36	√
pmse_bpmn_bound	id	char	36
pmse_bpmn_bound	modified_user_id	char	36	√		null
pmse_bpmn_bound	name	varchar	255	√		null
pmse_bpmn_bound	prj_id	varchar	36	√
pmse_bpmn_bound	sync_key	varchar	100	√		null
pmse_bpmn_data	assigned_user_id	char	36	√		null
pmse_bpmn_data	created_by	char	36	√		null
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	√
pmse_bpmn_data	date_entered	datetime	19	√		null
pmse_bpmn_data	date_modified	datetime	19	√		null
pmse_bpmn_data	deleted	bit	1	√		0
pmse_bpmn_data	description	text	65535	√		null
pmse_bpmn_data	id	char	36
pmse_bpmn_data	modified_user_id	char	36	√		null
pmse_bpmn_data	name	varchar	255	√		null
pmse_bpmn_data	prj_id	varchar	36	√
pmse_bpmn_data	pro_id	varchar	36	√
pmse_bpmn_data	sync_key	varchar	100	√		null
pmse_bpmn_diagram	assigned_user_id	char	36	√		null
pmse_bpmn_diagram	created_by	char	36	√		null
pmse_bpmn_diagram	date_entered	datetime	19	√		null
pmse_bpmn_diagram	date_modified	datetime	19	√		null
pmse_bpmn_diagram	deleted	bit	1	√		0
pmse_bpmn_diagram	description	text	65535	√		null
pmse_bpmn_diagram	dia_is_closable	int	4	√		0
pmse_bpmn_diagram	dia_uid	varchar	36	√
pmse_bpmn_diagram	id	char	36
pmse_bpmn_diagram	modified_user_id	char	36	√		null
pmse_bpmn_diagram	name	varchar	255	√		null
pmse_bpmn_diagram	prj_id	varchar	36	√
pmse_bpmn_diagram	sync_key	varchar	100	√		null
pmse_bpmn_documentation	assigned_user_id	char	36	√		null
pmse_bpmn_documentation	created_by	char	36	√		null
pmse_bpmn_documentation	date_entered	datetime	19	√		null
pmse_bpmn_documentation	date_modified	datetime	19	√		null
pmse_bpmn_documentation	deleted	bit	1	√		0
pmse_bpmn_documentation	description	text	65535	√		null
pmse_bpmn_documentation	doc_documentation	text	65535	√		null
pmse_bpmn_documentation	doc_element	varchar	36	√
pmse_bpmn_documentation	doc_element_type	varchar	45	√
pmse_bpmn_documentation	doc_uid	varchar	36	√
pmse_bpmn_documentation	id	char	36
pmse_bpmn_documentation	modified_user_id	char	36	√		null
pmse_bpmn_documentation	name	varchar	255	√		null
pmse_bpmn_documentation	prj_id	varchar	36	√
pmse_bpmn_documentation	sync_key	varchar	100	√		null
pmse_bpmn_event	assigned_user_id	char	36	√		null
pmse_bpmn_event	created_by	char	36	√		null
pmse_bpmn_event	date_entered	datetime	19	√		null
pmse_bpmn_event	date_modified	datetime	19	√		null
pmse_bpmn_event	deleted	bit	1	√		0
pmse_bpmn_event	description	text	65535	√		null
pmse_bpmn_event	evn_activity_ref	int	4	√		null
pmse_bpmn_event	evn_attached_to	int	4	√		null
pmse_bpmn_event	evn_behavior	varchar	20	√		CATCH
pmse_bpmn_event	evn_cancel_activity	int	4	√		0
pmse_bpmn_event	evn_condition	varchar	255	√
pmse_bpmn_event	evn_error_code	varchar	255	√
pmse_bpmn_event	evn_error_name	varchar	255	√