MySQL accounts Definitions:

name	type	len
id	char	36
name	varchar	150
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
facebook	varchar	100
twitter	varchar	100
googleplus	varchar	100
account_type	varchar	100
industry	varchar	100
annual_revenue	varchar	100
phone_fax	varchar	100
billing_address_street	varchar	150
billing_address_city	varchar	100
billing_address_state	varchar	100
billing_address_postalcode	varchar	20
billing_address_country	varchar	255
rating	varchar	100
phone_office	varchar	100
phone_alternate	varchar	100
website	varchar	255
ownership	varchar	100
employees	varchar	10
ticker_symbol	varchar	10
shipping_address_street	varchar	150
shipping_address_city	varchar	100
shipping_address_state	varchar	100
shipping_address_postalcode	varchar	20
shipping_address_country	varchar	255
parent_id	char	36
sic_code	varchar	10
duns_num	varchar	15
campaign_id	char	36
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
service_level	varchar	255
acl_team_set_id	char	36
business_center_id	char	36
next_renewal_date	date
sync_key	varchar	100
hint_account_size	varchar	20
hint_account_industry	varchar	120
hint_account_location	varchar	120
hint_account_industry_tags	varchar	225
hint_account_founded_year	varchar	5
hint_account_facebook_handle	varchar	120
hint_account_logo	varchar	255
hint_account_pic	text
hint_account_naics_code_lbl	varchar	170
hint_account_fiscal_year_end	varchar	5
is_escalated	tinyint
geocode_status	varchar	255
dri_workflow_template_id	char	36

MySQL accounts Keys:

name	type	fields
idx_acc_del_l_name_dm	index	deleted,name,date_modified
idx_accnt_parent_id	index	parent_id
idx_account_billing_address_city	index	billing_address_city
idx_accounts_acl_tmst_id	index	acl_team_set_id,deleted
idx_accounts_assigned_del	index	assigned_user_id,deleted
idx_accounts_cjtpl_id	index	dri_workflow_template_id
idx_accounts_date_entered	index	date_entered
idx_accounts_date_modfied	index	date_modified
idx_accounts_del_businesscenter	index	deleted,business_center_id
idx_accounts_del_d_e	index	deleted,date_entered,id
idx_accounts_del_d_m	index	deleted,date_modified,id
idx_accounts_id_del	index	id,deleted
idx_accounts_name_del	index	name,deleted
idx_accounts_skey	unique	sync_key
idx_accounts_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL accounts_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL accounts_audit Keys:

name	type	fields
idx_accounts_audit_after_value	index	after_value_string
idx_accounts_audit_event_id	index	event_id
idx_accounts_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL accounts_bugs Definitions:

name	type	len
id	char	36
account_id	char	36
bug_id	char	36
date_modified	datetime
deleted	tinyint

MySQL accounts_bugs Keys:

name	type	fields
idx_acc_bug_bug	index	bug_id
idx_account_bug	index	account_id,bug_id
PRIMARY	primary	id

MySQL accounts_cases Definitions:

name	type	len
id	char	36
account_id	char	36
case_id	char	36
date_modified	datetime
deleted	tinyint

MySQL accounts_cases Keys:

name	type	fields
idx_acc_acc_case	index	case_id
idx_acc_case_acc	index	account_id
PRIMARY	primary	id

MySQL accounts_contacts Definitions:

name	type	len
id	char	36
contact_id	char	36
account_id	char	36
date_modified	datetime
primary_account	tinyint
deleted	tinyint

MySQL accounts_contacts Keys:

name	type	fields
idx_account_contact	index	account_id,contact_id
idx_contid_del_accid	index	contact_id,deleted,account_id
PRIMARY	primary	id

MySQL accounts_cstm Definitions:

name	type	len	default
id_c	char	36
linguasi5_c	varchar	100
settore_delfin_c	varchar	100
fonte_c	varchar	255
linea_si5_c	varchar	100
listino_c	varchar	100
sconto_c	varchar	100
spedizione_c	varchar	100
si5_code_c	varchar	50
tipo_c	varchar	100
condizioni_commerciali_parti_c	text
cond_pagamento_c	varchar	100
nazione_dd_c	varchar	100
regione_dd_c	varchar	100
provincia_dd_c	varchar	100
interesse_mktg_c	varchar	255
privacy_mktg_c	tinyint
descrizione_mktg_c	text
pagina_mktg_c	varchar	255
check_assign_c	tinyint
filiera_mktg_c	varchar	100
fonte_lead_c	varchar	100
tipo_richiesta_c	varchar	100
lingua_lead_c	varchar	255
check_tp_lead_c	varchar	255
filiera_servizio_c	varchar	255
caldo_freddo_col_c	varchar	100
check_opp_c	tinyint
check_di_salvo_c	varchar	10
check_ceciliato_c	varchar	255
check_mosso_c	varchar	5
check_dandrea_export_c	varchar	10
check_nucci_c	varchar	10
check_leonetti_it_c	varchar	10
check_d_andrea_it_c	varchar	10
check_spera_c	varchar	10
check_polidori_c	varchar	10
check_vallogini_c	varchar	10
check_gambato_c	varchar	10
funzione_azienda_c	varchar	100
macro_settore_c	varchar	100
settore_specifico_c	varchar	100
p_iva_c	varchar	80
fido_c	varchar	255
caldo_freddo_c	varchar	100	caldo
classificazione_q_c	varchar	100
in_gestione_col_c	varchar	100	diretta
account_id_c	char	36
altre_linee_c	text
linea_multi_c	text
account_id1_c	char	36
zona_c	varchar	255
fonte_specifica_c	varchar	255
check_fazio_c	varchar	10
non_cancellare_c	tinyint
lingua_lead_2_c	varchar	100	ITA
brand_si5_c	varchar	100
sconto2_c	varchar	100
stato_cliente_c	varchar	100	V
c_fiscale_c	varchar	255
sincronizza_sib_c	tinyint	1
blacklisted_c	tinyint
id_sib_c	varchar	255
check_malta_c	varchar	10
comunicazioni_commerciali_c	tinyint
classificazione_q_report_c	varchar	100
check_ahmed_houmeci_c	varchar	5
chk_assforz_c	tinyint
chk_supervisor_c	tinyint
pk_ass_dd_c	varchar	100
pk_assegnatario_dd_c	varchar	100
pk_teamtext_c	varchar	50
pk_teamtext2_c	varchar	80
pk_numoppo_c	int
pk_datareg_c	date
pk_add_email_c	varchar	100
chk_numerico_c	int
in_gestione_c	varchar	100
pk_nomeoppo_c	varchar	255
pk_gestoppo_c	varchar	100	SI
pk_opposino_c	varchar	2
pk_countoppo_c	int
pk_countof_c	int
pk_avvisa_ass_c	varchar	100	NO
aggiorna_sib_c	varchar	100	NO
pk_codfil_c	varchar	4
user_id_c	char	36
pk_codfiliale_c	varchar	8
pk_site_class_c	varchar	100	HQ
pk_apriweb_c	text
pk_txt_import_c	varchar	255
pk_oreclass_c	decimal	12,2

MySQL accounts_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL accounts_dataprivacy Definitions:

name	type	len
id	char	36
account_id	char	36
dataprivacy_id	char	36
date_modified	datetime
deleted	tinyint

MySQL accounts_dataprivacy Keys:

name	type	fields
idx_acc_dataprivacy_dataprivacy	index	dataprivacy_id
idx_accounts_dataprivacy	index	account_id,dataprivacy_id
PRIMARY	primary	id

MySQL accounts_escalations Definitions:

name	type	len
id	char	36
account_id	char	36
escalation_id	char	36
date_modified	datetime
deleted	tinyint

MySQL accounts_escalations Keys:

name	type	fields
PRIMARY	primary	id

MySQL accounts_opportunities Definitions:

name	type	len
id	char	36
opportunity_id	char	36
account_id	char	36
date_modified	datetime
deleted	tinyint

MySQL accounts_opportunities Keys:

name	type	fields
idx_account_opportunity	index	account_id,opportunity_id
idx_oppid_del_accid	index	opportunity_id,deleted,account_id
PRIMARY	primary	id

MySQL accounts_purchases Definitions:

name	type	len
id	char	36
account_id	char	36
purchase_id	char	36
date_modified	datetime
deleted	tinyint

MySQL accounts_purchases Keys:

name	type	fields
idx_acc_acc_purchase	index	purchase_id
idx_acc_purchase_acc	index	account_id
PRIMARY	primary	id

MySQL accounts_sb_liste_sib_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
accounts_sb_liste_sib_1accounts_ida	char	36
accounts_sb_liste_sib_1sb_liste_sib_idb	char	36

MySQL accounts_sb_liste_sib_1_c Keys:

name	type	fields
accounts_sb_liste_sib_1_alt	index	accounts_sb_liste_sib_1accounts_ida,accounts_sb_liste_sib_1sb_liste_sib_idb
idx_accounts_sb_liste_sib_1_ida1_deleted	index	accounts_sb_liste_sib_1accounts_ida,deleted
idx_accounts_sb_liste_sib_1_idb2_deleted	index	accounts_sb_liste_sib_1sb_liste_sib_idb,deleted
PRIMARY	primary	id

MySQL accounts_sb_stats_sib_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
accounts_sb_stats_sib_1accounts_ida	char	36
accounts_sb_stats_sib_1sb_stats_sib_idb	char	36

MySQL accounts_sb_stats_sib_1_c Keys:

name	type	fields
accounts_sb_stats_sib_1_alt	index	accounts_sb_stats_sib_1sb_stats_sib_idb
idx_accounts_sb_stats_sib_1_ida1_deleted	index	accounts_sb_stats_sib_1accounts_ida,deleted
idx_accounts_sb_stats_sib_1_idb2_deleted	index	accounts_sb_stats_sib_1sb_stats_sib_idb,deleted
PRIMARY	primary	id

MySQL acl_actions Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	150
category	varchar	100
acltype	varchar	100
aclaccess	int
deleted	tinyint

MySQL acl_actions Keys:

name	type	fields
idx_del_category_name_acltype_aclaccess	index	deleted,category,name,acltype,aclaccess
PRIMARY	primary	id

MySQL acl_fields Definitions:

name	type	len	required
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	150
category	varchar	100
aclaccess	int
deleted	tinyint
role_id	char	36	true

MySQL acl_fields Keys:

name	type	fields
idx_aclfield_role_del	index	role_id,category,deleted
idx_del_category	index	deleted,category
PRIMARY	primary	id

MySQL acl_role_sets Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
hash	varchar	32
sync_key	varchar	100

MySQL acl_role_sets Keys:

name	type	fields
idx_acl_role_sets_date_entered	index	date_entered
idx_acl_role_sets_date_modfied	index	date_modified
idx_acl_role_sets_del_d_e	index	deleted,date_entered,id
idx_acl_role_sets_del_d_m	index	deleted,date_modified,id
idx_acl_role_sets_hash	unique	hash
idx_acl_role_sets_id_del	index	id,deleted
idx_acl_role_sets_name_del	index	name,deleted
idx_acl_role_sets_skey	unique	sync_key
PRIMARY	primary	id

MySQL acl_role_sets_acl_roles Definitions:

name	type	len
id	char	36
acl_role_set_id	char	36
acl_role_id	char	36
date_modified	datetime
deleted	tinyint

MySQL acl_role_sets_acl_roles Keys:

name	type	fields
idx_rsr_role_id	index	acl_role_id
idx_rsr_set_id	index	acl_role_set_id,acl_role_id
PRIMARY	primary	id

MySQL acl_roles Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	150
description	text
deleted	tinyint

MySQL acl_roles Keys:

name	type	fields
idx_aclrole_id_del	index	id,deleted
idx_aclrole_name	index	name
PRIMARY	primary	id

MySQL acl_roles_actions Definitions:

name	type	len
id	char	36
role_id	char	36
action_id	char	36
access_override	int
date_modified	datetime
deleted	tinyint

MySQL acl_roles_actions Keys:

name	type	fields
idx_acl_action_id	index	action_id
idx_acl_role_id	index	role_id
idx_del_override	index	role_id,deleted,action_id,access_override
PRIMARY	primary	id

MySQL acl_roles_users Definitions:

name	type	len
id	char	36
role_id	char	36
user_id	char	36
date_modified	datetime
deleted	tinyint

MySQL acl_roles_users Keys:

name	type	fields
idx_aclrole_user	index	role_id,user_id
idx_acluser_id	index	user_id
PRIMARY	primary	id

MySQL activities Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
deleted	tinyint
parent_id	char	36
parent_type	varchar	100
activity_type	varchar	100
data	longtext
comment_count	int
last_comment	longtext
sync_key	varchar	100

MySQL activities Keys:

name	type	fields
activity_records	index	parent_type,parent_id
activity_type_date	index	activity_type,date_entered
idx_activities_date_entered	index	date_entered
idx_activities_date_modfied	index	date_modified
idx_activities_del_d_e	index	deleted,date_entered,id
idx_activities_del_d_m	index	deleted,date_modified,id
idx_activities_id_del	index	id,deleted
idx_activities_skey	unique	sync_key
PRIMARY	primary	id

MySQL activities_users Definitions:

name	type	len	required
id	char	36
activity_id	char	36	true
parent_type	varchar	100
parent_id	char	36
fields	longtext
date_modified	datetime
deleted	tinyint

MySQL activities_users Keys:

name	type	fields
activities_records	index	parent_type,parent_id
activities_users_parent	index	activity_id,parent_id,parent_type
PRIMARY	primary	id

MySQL address_book Definitions:

name	type	len
assigned_user_id	char	36
bean	varchar	50
bean_id	char	36

MySQL address_book Keys:

name	type	fields
ab_user_bean_idx	index	assigned_user_id,bean
PRIMARY	primary	assigned_user_id,bean_id

MySQL address_book_list_items Definitions:

name	type	len
list_id	char	36
bean_id	char	36

MySQL address_book_list_items Keys:

name	type	fields
PRIMARY	primary	list_id,bean_id

MySQL address_book_lists Definitions:

name	type	len	required
id	char	36
assigned_user_id	char	36	true
list_name	varchar	100

MySQL address_book_lists Keys:

name	type	fields
abml_user_bean_idx	index	assigned_user_id
PRIMARY	primary	id

MySQL archive_runs Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
archiver_id	char	36
date_of_archive	datetime
source_module	varchar	255
filter_def	text
num_processed	int
process_type	varchar	255
ids_processed	longtext
sync_key	varchar	100

MySQL archive_runs Keys:

name	type	fields
idx_archive_runs_del_d_e	index	deleted,date_entered,id
idx_archive_runs_del_d_m	index	deleted,date_modified,id
idx_archive_runs_id_del	index	id,deleted
idx_archive_runs_name_del	index	name,deleted
idx_archive_runs_skey	unique	sync_key
PRIMARY	primary	id

MySQL audit_events Definitions:

name	type	len	required
id	char	36
type	char	10
parent_id	char	36	true
module_name	varchar	100
source	text
date_created	datetime
impersonated_by	char	36

MySQL audit_events Keys:

name	type	fields
idx_aud_eve_ptd	index	parent_id,type,date_created
idx_modulename	index	module_name
PRIMARY	primary	id

MySQL bugs Definitions:

name	type	len	auto_increment	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
bug_number	int		1	true
type	varchar	255
status	varchar	100
priority	varchar	100
resolution	varchar	255
work_log	text
found_in_release	varchar	255
fixed_in_release	varchar	255
source	varchar	255
product_category	varchar	255
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
follow_up_datetime	datetime
portal_viewable	tinyint
acl_team_set_id	char	36
resolved_datetime	datetime
hours_to_resolution	decimal	12,2
business_hours_to_resolution	decimal	12,2
pending_processing	tinyint
sync_key	varchar	100
is_escalated	tinyint
source_id	varchar	255
source_type	varchar	255
source_meta	text

MySQL bugs Keys:

name	type	fields
bugsnumk	unique	bug_number
idx_bugs_acl_tmst_id	index	acl_team_set_id,deleted
idx_bugs_assigned_del	index	assigned_user_id,deleted
idx_bugs_date_entered	index	date_entered
idx_bugs_date_modfied	index	date_modified
idx_bugs_del_d_e	index	deleted,date_entered,id
idx_bugs_del_d_m	index	deleted,date_modified,id
idx_bugs_id_del	index	id,deleted
idx_bugs_name_del	index	name,deleted
idx_bugs_skey	unique	sync_key
idx_bugs_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL bugs_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL bugs_audit Keys:

name	type	fields
idx_bugs_audit_after_value	index	after_value_string
idx_bugs_audit_event_id	index	event_id
idx_bugs_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL business_centers Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
timezone	varchar	255
address_street	varchar	150
address_city	varchar	100
address_state	varchar	100
address_postalcode	varchar	20
address_country	varchar	255
is_open_sunday	tinyint
sunday_open_hour	varchar	2
sunday_open_minutes	varchar	2
sunday_close_hour	varchar	2
sunday_close_minutes	varchar	2
is_open_monday	tinyint	1
monday_open_hour	varchar	2
monday_open_minutes	varchar	2
monday_close_hour	varchar	2
monday_close_minutes	varchar	2
is_open_tuesday	tinyint	1
tuesday_open_hour	varchar	2
tuesday_open_minutes	varchar	2
tuesday_close_hour	varchar	2
tuesday_close_minutes	varchar	2
is_open_wednesday	tinyint	1
wednesday_open_hour	varchar	2
wednesday_open_minutes	varchar	2
wednesday_close_hour	varchar	2
wednesday_close_minutes	varchar	2
is_open_thursday	tinyint	1
thursday_open_hour	varchar	2
thursday_open_minutes	varchar	2
thursday_close_hour	varchar	2
thursday_close_minutes	varchar	2
is_open_friday	tinyint	1
friday_open_hour	varchar	2
friday_open_minutes	varchar	2
friday_close_hour	varchar	2
friday_close_minutes	varchar	2
is_open_saturday	tinyint
saturday_open_hour	varchar	2
saturday_open_minutes	varchar	2
saturday_close_hour	varchar	2
saturday_close_minutes	varchar	2
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
geocode_status	varchar	255

MySQL business_centers Keys:

name	type	fields
idx_business_centers_acl_tmst_id	index	acl_team_set_id,deleted
idx_business_centers_assigned_del	index	assigned_user_id,deleted
idx_business_centers_del_d_e	index	deleted,date_entered,id
idx_business_centers_del_d_m	index	deleted,date_modified,id
idx_business_centers_id_del	index	id,deleted
idx_business_centers_name_del	index	name,deleted
idx_business_centers_skey	unique	sync_key
idx_business_centers_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL business_centers_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL business_centers_audit Keys:

name	type	fields
idx_business_centers_audit_after_value	index	after_value_string
idx_business_centers_audit_event_id	index	event_id
idx_business_centers_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL business_centers_holidays Definitions:

name	type	len
id	char	36
business_center_id	char	36
holiday_id	char	36
date_modified	datetime
deleted	tinyint

MySQL business_centers_holidays Keys:

name	type	fields
idx_bcid_del_holid	index	business_center_id,deleted,holiday_id
idx_business_center_holiday	index	business_center_id,holiday_id
PRIMARY	primary	id

MySQL calendar Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
subject	varchar	100
calendar_module	varchar	100
event_start	varchar	100
event_end	varchar	100
duration_minutes	varchar	100
duration_hours	varchar	100
duration_days	varchar	100
calendar_type	text
color	varchar	255
dblclick_event	varchar	100
allow_create	tinyint
allow_update	tinyint
allow_delete	tinyint
event_tooltip_template	varchar	255
day_event_template	varchar	255
week_event_template	varchar	255
month_event_template	varchar	255
agenda_event_template	varchar	255
timeline_event_template	varchar	255
schedulermonth_event_template	varchar	255
ical_event_template	varchar	255
calendar_filter	text
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36

MySQL calendar Keys:

name	type	fields
idx_calendar_acl_tmst_id	index	acl_team_set_id,deleted
idx_calendar_assigned_del	index	assigned_user_id,deleted
idx_calendar_del_d_e	index	deleted,date_entered,id
idx_calendar_del_d_m	index	deleted,date_modified,id
idx_calendar_id_del	index	id,deleted
idx_calendar_name_del	index	name,deleted
idx_calendar_skey	unique	sync_key
idx_calendar_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL calendar_ical_configs Definitions:

name	type	len
id	char	36
date_entered	datetime
calendar_configurations	text

MySQL calendar_ical_configs Keys:

name	type	fields
PRIMARY	primary	id

MySQL calls Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
duration_hours	int
duration_minutes	int
date_start	datetime
date_end	datetime
parent_type	varchar	255
status	varchar	100	Planned
direction	varchar	100
parent_id	char	36
reminder_time	int		-1
email_reminder_time	int		-1
email_reminder_sent	tinyint
outlook_id	varchar	255
repeat_type	varchar	36
repeat_interval	int		1
repeat_dow	varchar	7
repeat_until	date
repeat_count	int
repeat_selector	varchar	36
repeat_days	varchar	128
repeat_ordinal	varchar	36
repeat_unit	varchar	36
repeat_parent_id	char	36
recurrence_id	datetime
recurring_source	varchar	36
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
transcript	longtext
aws_contact_id	char	36
call_recording_url	varchar	255
sync_key	varchar	100
internal_notes	text
aws_lens_data	text
sentiment_score_agent	decimal	10,2
sentiment_score_agent_string	varchar	255
sentiment_score_customer	decimal	10,2
sentiment_score_customer_string	varchar	255
sentiment_score_agent_first_quarter	decimal	10,2
sentiment_score_agent_second_quarter	decimal	10,2
sentiment_score_agent_third_quarter	decimal	10,2
sentiment_score_agent_fourth_quarter	decimal	10,2
sentiment_score_customer_first_quarter	decimal	10,2
sentiment_score_customer_second_quarter	decimal	10,2
sentiment_score_customer_third_quarter	decimal	10,2
sentiment_score_customer_fourth_quarter	decimal	10,2
dri_workflow_id	char	36
dri_subworkflow_id	char	36
dri_subworkflow_template_id	char	36
dri_workflow_template_id	char	36
dri_workflow_task_template_id	char	36
dri_workflow_sort_order	varchar	255	1
cj_actual_sort_order	varchar	255
customer_journey_score	int
cj_momentum_points	int
cj_momentum_score	int
cj_allow_activity_by	text
customer_journey_progress	float
cj_momentum_ratio	float
customer_journey_points	int		10
cj_parent_activity_type	varchar	255
customer_journey_blocked_by	text
cj_blocked_by_stages	text
is_cj_parent_activity	tinyint
is_customer_journey_activity	tinyint
cj_momentum_start_date	datetime
cj_momentum_end_date	datetime
cj_url	varchar	255
cj_parent_activity_id	char	36
start_next_journey_id	char	36

MySQL calls Keys:

name	type	fields
idx_aws_calls_contact_id	index	aws_contact_id,deleted
idx_call_cj_activity_tpl_id	index	dri_workflow_task_template_id
idx_call_cj_journey_tpl_id	index	dri_workflow_template_id
idx_call_cj_parent_activity	index	deleted,cj_parent_activity_id,cj_parent_activity_type
idx_call_cj_stage_id	index	dri_subworkflow_id
idx_call_cj_stage_tpl_id	index	dri_subworkflow_template_id
idx_call_direction	index	direction
idx_call_name	index	deleted,name,date_modified
idx_calls_acl_tmst_id	index	acl_team_set_id,deleted
idx_calls_assigned_del	index	assigned_user_id,deleted
idx_calls_date_entered	index	date_entered
idx_calls_date_modfied	index	date_modified
idx_calls_date_start_end_del	index	date_start,date_end,deleted
idx_calls_date_start_reminder	index	date_start,reminder_time
idx_calls_del_d_e	index	deleted,date_entered,id
idx_calls_del_d_m	index	deleted,date_modified,id
idx_calls_id_del	index	id,deleted
idx_calls_name_del	index	name,deleted
idx_calls_par_del	index	parent_id,parent_type,deleted
idx_calls_recurrence_id	index	recurrence_id
idx_calls_repeat_parent_id	index	repeat_parent_id,deleted
idx_calls_skey	unique	sync_key
idx_calls_tmst_id	index	team_set_id,deleted
idx_del_wf_tpl_sub_subtpl_call_name	index	deleted,dri_workflow_id,dri_workflow_template_id,dri_subworkflow_id,dri_subworkflow_template_id,dri_workflow_task_template_id,name
idx_del_wf_tpl_sub_subtpl_call_status	index	deleted,dri_workflow_id,dri_workflow_template_id,dri_subworkflow_id,dri_subworkflow_template_id,dri_workflow_task_template_id,status
idx_status	index	status
PRIMARY	primary	id

MySQL calls_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL calls_audit Keys:

name	type	fields
idx_calls_audit_after_value	index	after_value_string
idx_calls_audit_event_id	index	event_id
idx_calls_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL calls_contacts Definitions:

name	type	len	default
id	char	36
call_id	char	36
contact_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL calls_contacts Keys:

name	type	fields
idx_call_contact	index	call_id,contact_id
idx_con_call_con	index	contact_id
PRIMARY	primary	id

MySQL calls_leads Definitions:

name	type	len	default
id	char	36
call_id	char	36
lead_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL calls_leads Keys:

name	type	fields
idx_call_lead	index	call_id,lead_id
idx_lead_call_lead	index	lead_id
PRIMARY	primary	id

MySQL calls_users Definitions:

name	type	len	default
id	char	36
call_id	char	36
user_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL calls_users Keys:

name	type	fields
idx_call_users_del	index	call_id,user_id,deleted
idx_usr_call_usr	index	user_id
PRIMARY	primary	id

MySQL campaign_log Definitions:

name	type	len
id	char	36
campaign_id	char	36
target_tracker_key	varchar	36
target_id	char	36
target_type	varchar	100
activity_type	varchar	100
activity_date	datetime
related_id	char	36
related_type	varchar	100
archived	tinyint
hits	int
list_id	char	36
deleted	tinyint
date_modified	datetime
more_information	varchar	100
marketing_id	char	36

MySQL campaign_log Keys:

name	type	fields
idx_camp_campaign_id	index	campaign_id
idx_camp_more_info	index	more_information
idx_camp_tracker	index	target_tracker_key
idx_camplog_deleted	index	deleted
idx_target_id_deleted	index	target_id,deleted
PRIMARY	primary	id

MySQL campaign_trkrs Definitions:

name	type	len	default	required
id	char	36
tracker_name	varchar	30
tracker_url	varchar	255	http://
tracker_key	int		1	true
campaign_id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
is_optout	tinyint
deleted	tinyint

MySQL campaign_trkrs Keys:

name	type	fields
campaign_tracker_key_idx	index	tracker_key
PRIMARY	primary	id

MySQL campaigns Definitions:

name	type	len	auto_increment	required
id	char	36
name	varchar	50
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
deleted	tinyint
tracker_key	int		1	true
tracker_count	int
refer_url	varchar	255	http://
tracker_text	varchar	255
start_date	date
end_date	date
status	varchar	100
impressions	int
budget	decimal	26,6
expected_cost	decimal	26,6
actual_cost	decimal	26,6
expected_revenue	decimal	26,6
campaign_type	varchar	100
objective	text
content	text
frequency	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
sync_key	varchar	100

MySQL campaigns Keys:

name	type	fields
camp_auto_tracker_key	index	tracker_key
idx_campaign_campaign_type	index	campaign_type
idx_campaign_end_date	index	end_date
idx_campaign_status	index	status
idx_campaigns_acl_tmst_id	index	acl_team_set_id,deleted
idx_campaigns_assigned_del	index	assigned_user_id,deleted
idx_campaigns_date_entered	index	date_entered
idx_campaigns_date_modfied	index	date_modified
idx_campaigns_del_d_e	index	deleted,date_entered,id
idx_campaigns_del_d_m	index	deleted,date_modified,id
idx_campaigns_id_del	index	id,deleted
idx_campaigns_name_del	index	name,deleted
idx_campaigns_skey	unique	sync_key
idx_campaigns_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL campaigns_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL campaigns_audit Keys:

name	type	fields
idx_campaigns_audit_after_value	index	after_value_string
idx_campaigns_audit_event_id	index	event_id
idx_campaigns_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL cases Definitions:

name	type	len	auto_increment	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	longtext
deleted	tinyint
case_number	int		1	true
type	varchar	255
status	varchar	100
priority	varchar	100
resolution	text
work_log	text
account_id	char	36
source	varchar	255
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
follow_up_datetime	datetime
portal_viewable	tinyint
acl_team_set_id	char	36
resolved_datetime	datetime
hours_to_resolution	decimal	12,2
business_hours_to_resolution	decimal	12,2
pending_processing	tinyint
business_center_id	char	36
primary_contact_id	char	36
first_response_target_datetime	datetime
first_response_actual_datetime	datetime
hours_to_first_response	decimal	12,2
business_hrs_to_first_response	decimal	12,2
first_response_var_from_target	decimal	12,2
first_response_sla_met	varchar	100
first_response_user_id	char	36
first_response_sent	tinyint
request_close	tinyint
request_close_date	datetime
sync_key	varchar	100
is_escalated	tinyint
denorm_account_name	varchar	150
source_id	varchar	255
source_type	varchar	255
source_meta	text
dri_workflow_template_id	char	36

MySQL cases Keys:

name	type	fields
casesnumk	unique	case_number
idx_account_id	index	deleted,account_id
idx_case_del_nam_dm	index	deleted,name,date_modified,id,team_set_id
idx_case_name	index	name
idx_cases_acl_tmst_id	index	acl_team_set_id,deleted
idx_cases_assigned_del	index	assigned_user_id,deleted
idx_cases_cjtpl_id	index	dri_workflow_template_id
idx_cases_date_entered	index	date_entered
idx_cases_date_modfied	index	date_modified
idx_cases_del_businesscenter	index	deleted,business_center_id
idx_cases_del_d_e	index	deleted,date_entered,id
idx_cases_del_d_m	index	deleted,date_modified,id
idx_cases_del_prim_contact_id	index	primary_contact_id,deleted
idx_cases_first_response_del	index	first_response_user_id,deleted
idx_cases_id_del	index	id,deleted
idx_cases_name_del	index	name,deleted
idx_cases_skey	unique	sync_key
idx_cases_stat_del	index	assigned_user_id,status,deleted
idx_cases_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL cases_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL cases_audit Keys:

name	type	fields
idx_cases_audit_after_value	index	after_value_string
idx_cases_audit_event_id	index	event_id
idx_cases_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL cases_bugs Definitions:

name	type	len
id	char	36
case_id	char	36
bug_id	char	36
date_modified	datetime
deleted	tinyint

MySQL cases_bugs Keys:

name	type	fields
idx_cas_bug_bug	index	bug_id
idx_case_bug	index	case_id,bug_id
PRIMARY	primary	id

MySQL cases_cstm Definitions:

name	type	len	default
id_c	char	36
stato_interno_hl_c	varchar	100
hot_contatto_c	varchar	80
filiera_mktg_c	varchar	100
pk_emailass_c	varchar	150
pk_emailcom_c	varchar	150
pk_assdir_c	varchar	100	NO
pk_siglaut_c	varchar	8
pk_codfiliale_c	varchar	8
pk_azione_c	varchar	100	Scegli
pk_classe_case_c	varchar	100	Scegli
email_contatto_c	varchar	255
pk_teamtext_c	varchar	50
pk_dest1_c	varchar	100	Scegli
pk_dest1_email_c	varchar	120
pk_button_c	text
pk_azioni_auto_c	text
pk_dataqual_c	datetime
pk_testmess_c	text
pk_dest2_c	varchar	100	Scegli
pk_dest3_c	varchar	100	Scegli
pk_dest2_email_c	varchar	120
pk_dest3_email_c	varchar	120
pk_chiusura_c	datetime
pk_datariconf_c	datetime
pk_data_ricezione_conf_c	datetime
pk_data_inv_conf_c	datetime
pk_lastaseguendo_text_c	varchar	40
pk_competenza_c	varchar	100	Scegli
pk_competenza_email_c	varchar	120
pk_messaggio_c	varchar	100
pk_messaggio_hl_c	varchar	100
pk_phone_c	varchar	60
pk_mobile_c	varchar	80
pk_description_c	text
pk_inviocert_c	varchar	100	NO
pk_datadoc_c	datetime
pk_switch_c	varchar	100	NO
pk_dtiniz_lav_c	datetime
pk_nomecliente_c	varchar	40
pk_escalation_c	text
pk_sottoclasse_c	varchar	100
pk_competenza2_c	varchar	100	Scegli
pk_competenza2_email_c	varchar	120
pk_email_ceo_c	varchar	40	direzione@delfinvacuums.it
pk_email_manager_c	varchar	255	s.siclari@delfinvacuums.it
pk_emaildircom_c	varchar	40	d.disalvo@delfinvacuums.it
pk_datascadenza_c	datetime
pk_data_attivita_c	datetime
pk_orecalc_c	decimal	12,2
pk_assegna_temp_c	varchar	100
pk_email_ass_temp_c	varchar	120
pk_nomecom_c	varchar	60
pk_ss1_c	varchar	100
pk_ss2_c	varchar	100
pk_ss3_c	varchar	100
pk_ss1hl_c	varchar	100
pk_ss2hl_c	varchar	100
pk_ss3hl_c	varchar	100
pk_scadvercom_c	datetime
pk_initvercom_c	datetime
pk_initcodutf_c	datetime
pk_scadcodutf_c	datetime
pk_initcodspec_c	datetime
pk_scadcodspec_c	datetime
pk_initprzspec_c	datetime
pk_scadprzspec_c	datetime
pk_initprzutf_c	datetime
pk_scadprzutf_c	datetime
pk_tipord_c	varchar	100
pk_numord_c	varchar	12
close_verifica_commerciale_c	datetime
close_codspec_c	datetime
close_codeutf_c	datetime
close_verprezzispec_c	datetime
close_verprzstd_c	datetime
pk_scadregol_c	datetime
close_invregol_c	datetime
pk_datascadocum_c	datetime
pk_datachiudocum_c	datetime
pk_initordine_c	datetime
pk_dirprod_c	varchar	100	Scegli
pk_emailprod_c	varchar	40
lingua_lead_2_c	varchar	100
ore_cvisione_c	decimal	8,2
pk_report_c	text
si5_code_c	varchar	50
quote_id_c	char	36
assforz_c	tinyint
pk_aasegnazioni_c	text
pk_datacons_c	date

MySQL cases_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL cases_purchases Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
case_id	char	36
purchase_id	char	36

MySQL cases_purchases Keys:

name	type	fields
cases_purchases_case_id	index	case_id,purchase_id
cases_purchases_purchase_id	index	purchase_id,case_id
PRIMARY	primary	id

MySQL categories Definitions:

name	type	len	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
root	char	36
lft	int		true
rgt	int		true
lvl	int		true
is_external	tinyint
source_id	varchar	255
source_type	varchar	255
source_meta	text
sync_key	varchar	100

MySQL categories Keys:

name	type	fields
idx_categories_date_entered	index	date_entered
idx_categories_date_modfied	index	date_modified
idx_categories_del_d_e	index	deleted,date_entered,id
idx_categories_del_d_m	index	deleted,date_modified,id
idx_categories_id_del	index	id,deleted
idx_categories_name_del	index	name,deleted
idx_categories_skey	unique	sync_key
PRIMARY	primary	id

MySQL category_tree Definitions:

name	type	len	auto_increment
self_id	char	36
node_id	int		1
parent_node_id	int
type	varchar	36

MySQL category_tree Keys:

name	type	fields
idx_categorytree	index	self_id
PRIMARY	primary	node_id

MySQL changetimers Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
parent_type	varchar	255
parent_id	char	36
field_name	varchar	100
value_string	varchar	255
from_datetime	datetime
to_datetime	datetime
hours	decimal	12,2
business_hours	decimal	12,2
sync_key	varchar	100

MySQL changetimers Keys:

name	type	fields
idx_changetimers_del_d_e	index	deleted,date_entered,id
idx_changetimers_del_d_m	index	deleted,date_modified,id
idx_changetimers_id_del	index	id,deleted
idx_changetimers_name_del	index	name,deleted
idx_changetimers_skey	unique	sync_key
idx_parent	index	parent_id,parent_type
PRIMARY	primary	id

MySQL cj_forms Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
trigger_event	varchar	255
action_type	varchar	255
action_trigger_type	varchar	255
relationship	text
activity_module	varchar	255
active	tinyint	1
ignore_errors	tinyint
populate_fields	text
select_to_email_address	text
parent_id	char	36
parent_type	varchar	255
display_activity_rsa_icon	varchar	255	yes
dri_workflow_template_id	char	36
email_templates_id	char	36
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL cj_forms Keys:

name	type	fields
cj_forms_parent_id	index	parent_id
idx_cj_forms_acl_tmst_id	index	acl_team_set_id,deleted
idx_cj_forms_del_d_e	index	deleted,date_entered,id
idx_cj_forms_del_d_m	index	deleted,date_modified,id
idx_cj_forms_em_tem_id	index	email_templates_id
idx_cj_forms_id_del	index	id,deleted
idx_cj_forms_jry_tpl_id	index	dri_workflow_template_id
idx_cj_forms_name_del	index	name,deleted
idx_cj_forms_skey	unique	sync_key
idx_cj_forms_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL cj_forms_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL cj_forms_audit Keys:

name	type	fields
idx_cj_forms_audit_after_value	index	after_value_string
idx_cj_forms_audit_event_id	index	event_id
idx_cj_forms_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL cj_web_hooks Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
url	varchar	255
error_message_path	varchar	255	message
sort_order	int		1
request_method	varchar	255	GET
request_format	varchar	255	json
response_format	varchar	255	json
trigger_event	varchar	255
request_body	varchar	255	journey_body
headers	text
custom_post_body	text
ignore_errors	tinyint
active	tinyint	1
parent_id	char	36	true
parent_type	varchar	255	DRI_Workflow_Templates
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL cj_web_hooks Keys:

name	type	fields
cj_webhooks_parent_id	index	parent_id
idx_cj_web_hooks_acl_tmst_id	index	acl_team_set_id,deleted
idx_cj_web_hooks_del_d_e	index	deleted,date_entered,id
idx_cj_web_hooks_del_d_m	index	deleted,date_modified,id
idx_cj_web_hooks_id_del	index	id,deleted
idx_cj_web_hooks_name_del	index	name,deleted
idx_cj_web_hooks_skey	unique	sync_key
idx_cj_web_hooks_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL cloud_drive_paths Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
record_id	varchar	255
path_module	varchar	255
path	text
type	varchar	255
is_root	tinyint
is_shared	tinyint
folder_id	varchar	255
drive_id	varchar	255
sync_key	varchar	100

MySQL cloud_drive_paths Keys:

name	type	fields
idx_cloud_drive_paths_del_d_e	index	deleted,date_entered,id
idx_cloud_drive_paths_del_d_m	index	deleted,date_modified,id
idx_cloud_drive_paths_id_del	index	id,deleted
idx_cloud_drive_paths_name_del	index	name,deleted
idx_cloud_drive_paths_skey	unique	sync_key
PRIMARY	primary	id

MySQL commentlog Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
entry	text
sync_key	varchar	100

MySQL commentlog Keys:

name	type	fields
idx_commentlog_date_entered	index	date_entered
idx_commentlog_date_modfied	index	date_modified
idx_commentlog_del_d_e	index	deleted,date_entered,id
idx_commentlog_del_d_m	index	deleted,date_modified,id
idx_commentlog_id_del	index	id,deleted
idx_commentlog_name_del	index	name,deleted
idx_commentlog_skey	unique	sync_key
PRIMARY	primary	id

MySQL commentlog_rel Definitions:

name	type	len	required
id	char	36
record_id	char	36	true
commentlog_id	char	36	true
module	varchar	100
deleted	tinyint

MySQL commentlog_rel Keys:

name	type	fields
commentlog_commentlog_relpk	index	commentlog_id
commentlog_record_relpk	index	record_id
PRIMARY	primary	id

MySQL comments Definitions:

name	type	len	required
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
deleted	tinyint
parent_id	char	36	true
data	longtext
sync_key	varchar	100

MySQL comments Keys:

name	type	fields
comment_activities	index	parent_id
idx_comments_date_entered	index	date_entered
idx_comments_date_modfied	index	date_modified
idx_comments_del_d_e	index	deleted,date_entered,id
idx_comments_del_d_m	index	deleted,date_modified,id
idx_comments_id_del	index	id,deleted
idx_comments_skey	unique	sync_key
PRIMARY	primary	id

MySQL config Definitions:

name	type	len
category	varchar	32
name	varchar	32
value	text
platform	varchar	32

MySQL config Keys:

name	type	fields
idx_config_cat	index	category

MySQL console_configuration Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
enabled_modules	varchar	255
order_by_primary	varchar	255
order_by_secondary	varchar	255
filter_def	text
sync_key	varchar	100
freeze_first_column	tinyint	1

MySQL console_configuration Keys:

name	type	fields
idx_console_configuration_del_d_e	index	deleted,date_entered,id
idx_console_configuration_del_d_m	index	deleted,date_modified,id
idx_console_configuration_id_del	index	id,deleted
idx_console_configuration_name_del	index	name,deleted
idx_console_configuration_skey	unique	sync_key
PRIMARY	primary	id

MySQL contacts Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
salutation	varchar	255
first_name	varchar	255
last_name	varchar	255
title	varchar	100
facebook	varchar	100
twitter	varchar	100
googleplus	varchar	100
department	varchar	255
do_not_call	tinyint
phone_home	varchar	100
phone_mobile	varchar	100
phone_work	varchar	100
phone_other	varchar	100
phone_fax	varchar	100
primary_address_street	varchar	150
primary_address_city	varchar	100
primary_address_state	varchar	100
primary_address_postalcode	varchar	20
primary_address_country	varchar	255
alt_address_street	varchar	150
alt_address_city	varchar	100
alt_address_state	varchar	100
alt_address_postalcode	varchar	20
alt_address_country	varchar	255
assistant	varchar	75
assistant_phone	varchar	100
picture	varchar	255
lead_source	varchar	255
dnb_principal_id	varchar	30
reports_to_id	char	36
birthdate	date
dp_business_purpose	text
dp_consent_last_updated	date
campaign_id	char	36
mkto_sync	tinyint
mkto_id	int
mkto_lead_score	int
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
portal_name	varchar	255
portal_active	tinyint
portal_password	varchar	255
portal_app	varchar	255
preferred_language	varchar	255
acl_team_set_id	char	36
portal_user_company_name	varchar	255
cookie_consent	tinyint
cookie_consent_received_on	datetime
business_center_id	char	36
entry_source	varchar	255	internal
site_user_id	varchar	64
sync_key	varchar	100
hint_account_size	varchar	20
hint_account_industry	varchar	120
hint_account_location	varchar	255
hint_account_description	varchar	255
hint_job_2	varchar	255
hint_education	varchar	225
hint_education_2	varchar	225
hint_facebook	varchar	120
hint_twitter	varchar	120
hint_industry_tags	varchar	225
hint_account_founded_year	varchar	5
hint_account_facebook_handle	varchar	120
hint_account_twitter_handle	varchar	120
hint_account_logo	varchar	255
hint_contact_pic	text
hint_photo	varchar	255
hint_phone_1	varchar	15
hint_phone_2	varchar	15
hint_account_website	varchar	255
hint_account_naics_code_lbl	varchar	170
hint_account_sic_code_label	varchar	120
hint_account_fiscal_year_end	varchar	5
hint_account_annual_revenue	varchar	25
market_interest_prediction_score	varchar	255
market_score	int
denorm_account_name	varchar	150
geocode_status	varchar	255
source_id	varchar	255
source_type	varchar	255
source_meta	text
dri_workflow_template_id	char	36

MySQL contacts Keys:

name	type	fields
idx_cont_del_last_dm	index	deleted,last_name,date_modified
idx_cont_del_reports	index	deleted,reports_to_id,last_name
idx_cont_portal_active	index	portal_name,portal_active,deleted
idx_contact_mkto_id	index	mkto_id
idx_contact_title	index	title
idx_contacts_acl_tmst_id	index	acl_team_set_id,deleted
idx_contacts_assigned_del	index	assigned_user_id,deleted
idx_contacts_cjtpl_id	index	dri_workflow_template_id
idx_contacts_date_entered	index	date_entered
idx_contacts_date_modfied	index	date_modified
idx_contacts_del_businesscenter	index	deleted,business_center_id
idx_contacts_del_d_e	index	deleted,date_entered,id
idx_contacts_del_d_m	index	deleted,date_modified,id
idx_contacts_del_last	index	deleted,last_name
idx_contacts_first_last	index	first_name,last_name,deleted
idx_contacts_id_del	index	id,deleted
idx_contacts_last_first	index	last_name,first_name,deleted
idx_contacts_skey	unique	sync_key
idx_contacts_tmst_id	index	team_set_id,deleted
idx_del_id_user	index	deleted,id,assigned_user_id
idx_reports_to_id	index	deleted,reports_to_id,id
PRIMARY	primary	id

MySQL contacts_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL contacts_audit Keys:

name	type	fields
idx_contacts_audit_after_value	index	after_value_string
idx_contacts_audit_event_id	index	event_id
idx_contacts_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL contacts_bugs Definitions:

name	type	len
id	char	36
contact_id	char	36
bug_id	char	36
contact_role	varchar	50
date_modified	datetime
deleted	tinyint

MySQL contacts_bugs Keys:

name	type	fields
idx_con_bug_bug	index	bug_id
idx_contact_bug	index	contact_id,bug_id
PRIMARY	primary	id

MySQL contacts_cases Definitions:

name	type	len
id	char	36
contact_id	char	36
case_id	char	36
contact_role	varchar	50
date_modified	datetime
deleted	tinyint

MySQL contacts_cases Keys:

name	type	fields
idx_con_case_case	index	case_id
idx_contacts_cases	index	contact_id,case_id
PRIMARY	primary	id

MySQL contacts_cstm Definitions:

name	type	len	default
id_c	char	36
dipartimento_c	varchar	100
linkedin_c	varchar	255
skype_c	varchar	255
newsletter_c	tinyint	1
comunicazioni_c	tinyint
id_sib_c	varchar	255
sincronizza_sib_c	tinyint	1
blacklisted_c	tinyint
emailtext_c	varchar	60
nome_pieno_c	varchar	180
pk_azioni_cont_c	varchar	100	Scegli

MySQL contacts_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL contacts_dataprivacy Definitions:

name	type	len
id	char	36
contact_id	char	36
dataprivacy_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contacts_dataprivacy Keys:

name	type	fields
idx_con_dataprivacy_dataprivacy	index	dataprivacy_id
idx_contacts_dataprivacy	index	contact_id,dataprivacy_id
PRIMARY	primary	id

MySQL contacts_escalations Definitions:

name	type	len
id	char	36
contact_id	char	36
escalation_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contacts_escalations Keys:

name	type	fields
idx_con_escalation_escalation	index	escalation_id
idx_contacts_escalations	index	contact_id,escalation_id
PRIMARY	primary	id

MySQL contacts_purchases Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
contact_id	char	36
purchase_id	char	36

MySQL contacts_purchases Keys:

name	type	fields
contacts_purchases_contact_id	index	contact_id,purchase_id
contacts_purchases_purchase_id	index	purchase_id,contact_id
PRIMARY	primary	id

MySQL contacts_sb_liste_sib_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
contacts_sb_liste_sib_1contacts_ida	char	36
contacts_sb_liste_sib_1sb_liste_sib_idb	char	36

MySQL contacts_sb_liste_sib_1_c Keys:

name	type	fields
contacts_sb_liste_sib_1_alt	index	contacts_sb_liste_sib_1contacts_ida,contacts_sb_liste_sib_1sb_liste_sib_idb
idx_contacts_sb_liste_sib_1_ida1_deleted	index	contacts_sb_liste_sib_1contacts_ida,deleted
idx_contacts_sb_liste_sib_1_idb2_deleted	index	contacts_sb_liste_sib_1sb_liste_sib_idb,deleted
PRIMARY	primary	id

MySQL contacts_sb_stats_sib_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
contacts_sb_stats_sib_1contacts_ida	char	36
contacts_sb_stats_sib_1sb_stats_sib_idb	char	36

MySQL contacts_sb_stats_sib_1_c Keys:

name	type	fields
contacts_sb_stats_sib_1_alt	index	contacts_sb_stats_sib_1sb_stats_sib_idb
idx_contacts_sb_stats_sib_1_ida1_deleted	index	contacts_sb_stats_sib_1contacts_ida,deleted
idx_contacts_sb_stats_sib_1_idb2_deleted	index	contacts_sb_stats_sib_1sb_stats_sib_idb,deleted
PRIMARY	primary	id

MySQL contacts_users Definitions:

name	type	len
id	char	36
contact_id	char	36
user_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contacts_users Keys:

name	type	fields
idx_con_users_user	index	user_id
idx_contacts_users	index	contact_id,user_id
PRIMARY	primary	id

MySQL contract_types Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
list_order	int
sync_key	varchar	100

MySQL contract_types Keys:

name	type	fields
idx_contract_types_date_entered	index	date_entered
idx_contract_types_date_modfied	index	date_modified
idx_contract_types_del_d_e	index	deleted,date_entered,id
idx_contract_types_del_d_m	index	deleted,date_modified,id
idx_contract_types_id_del	index	id,deleted
idx_contract_types_name_del	index	name,deleted
idx_contract_types_skey	unique	sync_key
PRIMARY	primary	id

MySQL contracts Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
reference_code	varchar	255
account_id	char	36
start_date	date
end_date	date
total_contract_value	decimal	26,6
total_contract_value_usdollar	decimal	26,6
status	varchar	100
customer_signed_date	date
company_signed_date	date
expiration_notice	datetime
type	varchar	255
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
sync_key	varchar	100

MySQL contracts Keys:

name	type	fields
idx_contract_end_date	index	end_date
idx_contract_start_date	index	start_date
idx_contract_status	index	status
idx_contracts_acl_tmst_id	index	acl_team_set_id,deleted
idx_contracts_assigned_del	index	assigned_user_id,deleted
idx_contracts_date_entered	index	date_entered
idx_contracts_date_modfied	index	date_modified
idx_contracts_del_d_e	index	deleted,date_entered,id
idx_contracts_del_d_m	index	deleted,date_modified,id
idx_contracts_id_del	index	id,deleted
idx_contracts_name_del	index	name,deleted
idx_contracts_skey	unique	sync_key
idx_contracts_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL contracts_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL contracts_audit Keys:

name	type	fields
idx_contracts_audit_after_value	index	after_value_string
idx_contracts_audit_event_id	index	event_id
idx_contracts_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL contracts_contacts Definitions:

name	type	len
id	char	36
contact_id	char	36
contract_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contracts_contacts Keys:

name	type	fields
contracts_contacts_alt	index	contact_id,contract_id
PRIMARY	primary	id

MySQL contracts_opportunities Definitions:

name	type	len
id	char	36
opportunity_id	char	36
contract_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contracts_opportunities Keys:

name	type	fields
contracts_opp_alt	index	contract_id
PRIMARY	primary	id

MySQL contracts_products Definitions:

name	type	len
id	char	36
product_id	char	36
contract_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contracts_products Keys:

name	type	fields
contracts_prod_alt	index	contract_id,product_id
PRIMARY	primary	id

MySQL contracts_quotes Definitions:

name	type	len
id	char	36
quote_id	char	36
contract_id	char	36
date_modified	datetime
deleted	tinyint

MySQL contracts_quotes Keys:

name	type	fields
contracts_quot_alt	index	contract_id,quote_id
PRIMARY	primary	id

MySQL cp_condpag Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL cp_condpag Keys:

name	type	fields
idx_cp_condpag_acl_tmst_id	index	acl_team_set_id,deleted
idx_cp_condpag_assigned_del	index	assigned_user_id,deleted
idx_cp_condpag_date_entered	index	date_entered
idx_cp_condpag_date_modfied	index	date_modified
idx_cp_condpag_del_d_e	index	deleted,date_entered,id
idx_cp_condpag_del_d_m	index	deleted,date_modified,id
idx_cp_condpag_id_del	index	id,deleted
idx_cp_condpag_name_del	index	name,deleted
idx_cp_condpag_skey	unique	sync_key
idx_cp_condpag_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL cp_condpag_accounts_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
cp_condpag_accounts_1cp_condpag_ida	char	36
cp_condpag_accounts_1accounts_idb	char	36

MySQL cp_condpag_accounts_1_c Keys:

name	type	fields
cp_condpag_accounts_1_alt	index	cp_condpag_accounts_1accounts_idb
idx_cp_condpag_accounts_1_ida1_deleted	index	cp_condpag_accounts_1cp_condpag_ida,deleted
idx_cp_condpag_accounts_1_idb2_deleted	index	cp_condpag_accounts_1accounts_idb,deleted
PRIMARY	primary	id

MySQL cp_condpag_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL cp_condpag_audit Keys:

name	type	fields
idx_cp_condpag_audit_after_value	index	after_value_string
idx_cp_condpag_audit_event_id	index	event_id
idx_cp_condpag_audit_pa_ev_id	index	parent_id,event_id
idx_cp_condpag_audit_parent_id	index	parent_id
PRIMARY	primary	id

MySQL cp_condpag_cstm Definitions:

name	type	len
id_c	char	36
cod_si5_c	varchar	255
traduzione_c	varchar	50
traduzione_deu_c	varchar	50
traduzione_esp_c	varchar	50
traduzione_fra_c	varchar	50

MySQL cp_condpag_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL cp_condpag_quotes_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
cp_condpag_quotes_1cp_condpag_ida	char	36
cp_condpag_quotes_1quotes_idb	char	36

MySQL cp_condpag_quotes_1_c Keys:

name	type	fields
cp_condpag_quotes_1_alt	index	cp_condpag_quotes_1quotes_idb
idx_cp_condpag_quotes_1_ida1_deleted	index	cp_condpag_quotes_1cp_condpag_ida,deleted
idx_cp_condpag_quotes_1_idb2_deleted	index	cp_condpag_quotes_1quotes_idb,deleted
PRIMARY	primary	id

MySQL currencies Definitions:

name	type	len	default
id	char	36
name	varchar	36
symbol	varchar	36
iso4217	varchar	3
conversion_rate	decimal	26,6	0.000000
status	varchar	100
deleted	tinyint
date_entered	datetime
date_modified	datetime
created_by	char	36	true
sync_key	varchar	100

MySQL currencies Keys:

name	type	fields
idx_currencies_skey	unique	sync_key
idx_currency_name	index	name,deleted
PRIMARY	primary	id

MySQL custom_fields Definitions:

name	type	len
bean_id	char	36
set_num	int
field0	varchar	255
field1	varchar	255
field2	varchar	255
field3	varchar	255
field4	varchar	255
field5	varchar	255
field6	varchar	255
field7	varchar	255
field8	varchar	255
field9	varchar	255
deleted	tinyint

MySQL custom_fields Keys:

name	type	fields
idx_beanid_set_num	index	bean_id,set_num

MySQL custom_queries Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	50
description	text
custom_query	text
query_type	varchar	50
list_order	int
query_locked	varchar	3
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL custom_queries Keys:

name	type	fields
idx_custom_queries_acl_tmst_id	index	acl_team_set_id,deleted
idx_custom_queries_tmst_id	index	team_set_id,deleted
idx_customqueries	index	name,deleted
PRIMARY	primary	id

MySQL dashboards Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
dashboard_module	varchar	100
view_name	varchar	100
metadata	longtext
default_dashboard	tinyint
team_id	char	36
team_set_id	char	36
assigned_user_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL dashboards Keys:

name	type	fields
idx_dashboards_acl_tmst_id	index	acl_team_set_id,deleted
idx_dashboards_assigned_del	index	assigned_user_id,deleted
idx_dashboards_date_entered	index	date_entered
idx_dashboards_date_modfied	index	date_modified
idx_dashboards_del_d_e	index	deleted,date_entered,id
idx_dashboards_del_d_m	index	deleted,date_modified,id
idx_dashboards_id_del	index	id,deleted
idx_dashboards_name_del	index	name,deleted
idx_dashboards_skey	unique	sync_key
idx_dashboards_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id
user_module_view	index	assigned_user_id,dashboard_module,view_name

MySQL data_archivers Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
filter_module_name	varchar	255
filter_def	text
process_type	varchar	255
active	tinyint	1
sync_key	varchar	100

MySQL data_archivers Keys:

name	type	fields
idx_data_archivers_del_d_e	index	deleted,date_entered,id
idx_data_archivers_del_d_m	index	deleted,date_modified,id
idx_data_archivers_id_del	index	id,deleted
idx_data_archivers_name_del	index	name,deleted
idx_data_archivers_skey	unique	sync_key
PRIMARY	primary	id

MySQL data_privacy Definitions:

name	type	len	auto_increment	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
dataprivacy_number	int		1	true
type	varchar	255
status	varchar	100	Open
priority	varchar	100
resolution	text
work_log	text
business_purpose	text
source	varchar	255
requested_by	varchar	255
date_opened	date
date_due	date
date_closed	date
fields_to_erase	text
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
follow_up_datetime	datetime
acl_team_set_id	char	36
resolved_datetime	datetime
hours_to_resolution	decimal	12,2
business_hours_to_resolution	decimal	12,2
pending_processing	tinyint
sync_key	varchar	100

MySQL data_privacy Keys:

name	type	fields
dataprivacynumk	unique	dataprivacy_number
idx_data_privacy_acl_tmst_id	index	acl_team_set_id,deleted
idx_data_privacy_assigned_del	index	assigned_user_id,deleted
idx_data_privacy_date_entered	index	date_entered
idx_data_privacy_date_modfied	index	date_modified
idx_data_privacy_del_d_e	index	deleted,date_entered,id
idx_data_privacy_del_d_m	index	deleted,date_modified,id
idx_data_privacy_id_del	index	id,deleted
idx_data_privacy_name_del	index	name,deleted
idx_data_privacy_skey	unique	sync_key
idx_data_privacy_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL data_privacy_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL data_privacy_audit Keys:

name	type	fields
idx_data_privacy_audit_after_value	index	after_value_string
idx_data_privacy_audit_event_id	index	event_id
idx_data_privacy_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL data_sets Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
parent_id	char	36
report_id	char	36
query_id	char	36	true
name	varchar	50
list_order_y	int
exportable	varchar	3
header	varchar	3
description	text
table_width	varchar	3
font_size	varchar	8
output_default	varchar	100
prespace_y	varchar	3
use_prev_header	varchar	3
header_back_color	varchar	100
body_back_color	varchar	100
header_text_color	varchar	100
body_text_color	varchar	100
table_width_type	varchar	3
custom_layout	varchar	10
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL data_sets Keys:

name	type	fields
idx_data_sets_acl_tmst_id	index	acl_team_set_id,deleted
idx_data_sets_tmst_id	index	team_set_id,deleted
idx_dataset	index	name,deleted
PRIMARY	primary	id

MySQL dataset_attributes Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
display_type	varchar	25
display_name	varchar	50
attribute_type	varchar	8
parent_id	char	36
font_size	varchar	8
cell_size	varchar	3
size_type	varchar	3
bg_color	varchar	25
font_color	varchar	25
wrap	varchar	3
style	varchar	25
format_type	varchar	25

MySQL dataset_attributes Keys:

name	type	fields
idx_datasetatt	index	parent_id,deleted
PRIMARY	primary	id

MySQL dataset_layouts Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
parent_value	varchar	50
layout_type	varchar	25
parent_id	char	36
list_order_x	int
list_order_z	int
row_header_id	char	36
hide_column	varchar	3

MySQL dataset_layouts Keys:

name	type	fields
idx_datasetlayout	index	parent_value,deleted
PRIMARY	primary	id

MySQL denorm_tmp Definitions:

name	type	len	auto_increment
id	int		1
target_id	char	36
value	varchar	150

MySQL denorm_tmp Keys:

name	type	fields
denorm_tmp_target_id_idx	unique	target_id,id
PRIMARY	primary	id

MySQL denorm_tmp_Opportunities Definitions:

name	type	len	auto_increment
id	int		1
target_id	char	36
value	varchar	150

MySQL denorm_tmp_Opportunities Keys:

name	type	fields
PRIMARY	primary	id

MySQL denorm_tmp_Quotes Definitions:

name	type	len	auto_increment
id	int		1
target_id	char	36
value	varchar	150

MySQL denorm_tmp_Quotes Keys:

name	type	fields
denorm_tmp_Quotes_target_id_idx	unique	target_id,id
PRIMARY	primary	id

MySQL denorm_tmp_RevenueLineItems Definitions:

name	type	len	auto_increment
id	int		1
target_id	char	36
value	varchar	150

MySQL denorm_tmp_RevenueLineItems Keys:

name	type	fields
PRIMARY	primary	id

MySQL document_merges Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
parent_type	varchar	255
parent_id	char	36
template_id	char	36
generated_document_id	char	36
status	varchar	100	processing
merge_type	varchar	100	merge
file_type	varchar	100	DOC
message	varchar	255
seen	tinyint
dismissed	tinyint
record_ids	text
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
flow_data	longtext

MySQL document_merges Keys:

name	type	fields
idx_document_merges_acl_tmst_id	index	acl_team_set_id,deleted
idx_document_merges_assigned_del	index	assigned_user_id,deleted
idx_document_merges_del_d_e	index	deleted,date_entered,id
idx_document_merges_del_d_m	index	deleted,date_modified,id
idx_document_merges_id_del	index	id,deleted
idx_document_merges_name_del	index	name,deleted
idx_document_merges_skey	unique	sync_key
idx_document_merges_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL document_merges_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL document_merges_audit Keys:

name	type	fields
idx_document_merges_audit_after_value	index	after_value_string
idx_document_merges_audit_event_id	index	event_id
idx_document_merges_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL document_revisions Definitions:

name	type	len
id	char	36
change_log	varchar	255
document_id	char	36
doc_id	varchar	100
doc_type	varchar	100
doc_url	varchar	255
date_entered	datetime
created_by	char	36
filename	varchar	255
file_ext	varchar	100
file_mime_type	varchar	100
file_size	int
revision	varchar	100
deleted	tinyint
date_modified	datetime

MySQL document_revisions Keys:

name	type	fields
documentrevision_mimetype	index	file_mime_type
idx_document_revisions_document_id_deleted	index	document_id,deleted
PRIMARY	primary	id

MySQL document_templates Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
filename	varchar	255
file_ext	varchar	100
file_mime_type	varchar	100
file_size	int
template_module	varchar	100	Accounts
use_revisions	tinyint	1
label_merging	tinyint
prefix	varchar	120
postfix	varchar	120
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL document_templates Keys:

name	type	fields
idx_document_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_document_templates_assigned_del	index	assigned_user_id,deleted
idx_document_templates_del_d_e	index	deleted,date_entered,id
idx_document_templates_del_d_m	index	deleted,date_modified,id
idx_document_templates_id_del	index	id,deleted
idx_document_templates_name_del	index	name,deleted
idx_document_templates_skey	unique	sync_key
idx_document_templates_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL document_templates_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL document_templates_audit Keys:

name	type	fields
idx_document_templates_audit_after_value	index	after_value_string
idx_document_templates_audit_event_id	index	event_id
idx_document_templates_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL documents Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
document_name	varchar	255
doc_id	varchar	100
doc_type	varchar	100	Sugar
doc_url	varchar	255
active_date	date
exp_date	date
category_id	varchar	100
subcategory_id	varchar	100
status_id	varchar	100
document_revision_id	char	36
related_doc_id	char	36
related_doc_rev_id	char	36
is_template	tinyint
template_type	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
is_shared	tinyint

MySQL documents Keys:

name	type	fields
idx_doc_cat	index	category_id,subcategory_id
idx_document_doc_type	index	doc_type
idx_document_exp_date	index	exp_date
idx_documents_acl_tmst_id	index	acl_team_set_id,deleted
idx_documents_assigned_del	index	assigned_user_id,deleted
idx_documents_date_entered	index	date_entered
idx_documents_date_modfied	index	date_modified
idx_documents_del_d_e	index	deleted,date_entered,id
idx_documents_del_d_m	index	deleted,date_modified,id
idx_documents_id_del	index	id,deleted
idx_documents_related_doc_id_deleted	index	related_doc_id,deleted
idx_documents_skey	unique	sync_key
idx_documents_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL documents_accounts Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
account_id	char	36

MySQL documents_accounts Keys:

name	type	fields
documents_accounts_account_id	index	account_id,document_id
documents_accounts_document_id	index	document_id,account_id
PRIMARY	primary	id

MySQL documents_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL documents_audit Keys:

name	type	fields
idx_documents_audit_after_value	index	after_value_string
idx_documents_audit_event_id	index	event_id
idx_documents_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL documents_bugs Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
bug_id	char	36

MySQL documents_bugs Keys:

name	type	fields
documents_bugs_bug_id	index	bug_id,document_id
documents_bugs_document_id	index	document_id,bug_id
PRIMARY	primary	id

MySQL documents_cases Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
case_id	char	36

MySQL documents_cases Keys:

name	type	fields
documents_cases_case_id	index	case_id,document_id
documents_cases_document_id	index	document_id,case_id
PRIMARY	primary	id

MySQL documents_contacts Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
contact_id	char	36

MySQL documents_contacts Keys:

name	type	fields
documents_contacts_contact_id	index	contact_id,document_id
documents_contacts_document_id	index	document_id,contact_id
PRIMARY	primary	id

MySQL documents_escalations Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
escalation_id	char	36

MySQL documents_escalations Keys:

name	type	fields
documents_escalations_document_id	index	document_id,escalation_id
documents_escalations_escalation_id	index	escalation_id,document_id
PRIMARY	primary	id

MySQL documents_opportunities Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
opportunity_id	char	36

MySQL documents_opportunities Keys:

name	type	fields
idx_docu_oppo_docu_id	index	document_id,opportunity_id
idx_docu_opps_oppo_id	index	opportunity_id,document_id
PRIMARY	primary	id

MySQL documents_products Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
product_id	char	36

MySQL documents_products Keys:

name	type	fields
documents_products_document_id	index	document_id,product_id
documents_products_product_id	index	product_id,document_id
PRIMARY	primary	id

MySQL documents_purchasedlineitems Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
purchasedlineitem_id	char	36

MySQL documents_purchasedlineitems Keys:

name	type	fields
documents_purchasedlineitems_document_id	index	document_id,purchasedlineitem_id
documents_purchasedlineitems_purchasedlineitem_id	index	purchasedlineitem_id,document_id
PRIMARY	primary	id

MySQL documents_purchases Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
purchase_id	char	36

MySQL documents_purchases Keys:

name	type	fields
documents_purchases_document_id	index	document_id,purchase_id
documents_purchases_purchase_id	index	purchase_id,document_id
PRIMARY	primary	id

MySQL documents_quotes Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
quote_id	char	36

MySQL documents_quotes Keys:

name	type	fields
documents_quotes_document_id	index	document_id,quote_id
documents_quotes_quote_id	index	quote_id,document_id
PRIMARY	primary	id

MySQL documents_revenuelineitems Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
document_id	char	36
rli_id	char	36

MySQL documents_revenuelineitems Keys:

name	type	fields
documents_revenuelineitems_document_id	index	document_id,rli_id
documents_revenuelineitems_revenuelineitem_id	index	rli_id,document_id
PRIMARY	primary	id

MySQL docusign_envelopes Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
status	varchar	100
envelope_id	varchar	36
document_id	char	36
parent_id	char	36
parent_type	varchar	255
last_audit	datetime
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
cloud_service_type	varchar	36
cloud_path	varchar	400

MySQL docusign_envelopes Keys:

name	type	fields
idx_docusign_envelopes_acl_tmst_id	index	acl_team_set_id,deleted
idx_docusign_envelopes_assigned_del	index	assigned_user_id,deleted
idx_docusign_envelopes_del_d_e	index	deleted,date_entered,id
idx_docusign_envelopes_del_d_m	index	deleted,date_modified,id
idx_docusign_envelopes_id_del	index	id,deleted
idx_docusign_envelopes_name_del	index	name,deleted
idx_docusign_envelopes_skey	unique	sync_key
idx_docusign_envelopes_tmst_id	index	team_set_id,deleted
idx_envelope_id	index	envelope_id
idx_parent_record	index	parent_id,parent_type
PRIMARY	primary	id

MySQL docusign_envelopes_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL docusign_envelopes_audit Keys:

name	type	fields
idx_docusign_envelopes_audit_after_value	index	after_value_string
idx_docusign_envelopes_audit_event_id	index	event_id
idx_docusign_envelopes_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL dri_subworkflow_templates Definitions:

name	type	len
id	char	36
name	varchar	30
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
label	varchar	255
sort_order	int
points	int
related_activities	int
dri_workflow_template_id	char	36
start_next_journey_id	char	36
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL dri_subworkflow_templates Keys:

name	type	fields
idx_cj_stage_tpl_jry_tpl_id	index	dri_workflow_template_id
idx_cj_stg_tpl_nxt_jry_tpl_id	index	start_next_journey_id
idx_dri_subworkflow_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_dri_subworkflow_templates_del_d_e	index	deleted,date_entered,id
idx_dri_subworkflow_templates_del_d_m	index	deleted,date_modified,id
idx_dri_subworkflow_templates_id_del	index	id,deleted
idx_dri_subworkflow_templates_name_del	index	name,deleted
idx_dri_subworkflow_templates_skey	unique	sync_key
idx_dri_subworkflow_templates_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL dri_subworkflows Definitions:

name	type	len	default
id	char	36
name	varchar	30
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
label	varchar	255
state	varchar	255	not_started
start_next_journey_id	char	36
progress	float
momentum_ratio	float		1
score	int
points	int
momentum_points	int
momentum_score	int
sort_order	int		1
date_started	datetime
date_completed	datetime
is_journey_saved	tinyint
dri_subworkflow_template_id	char	36
dri_workflow_id	char	36
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36

MySQL dri_subworkflows Keys:

name	type	fields
idx_cj_stage_org_tpl_id	index	dri_subworkflow_template_id
idx_cj_stage_parent_journey_id	index	dri_workflow_id
idx_dri_subworkflows_acl_tmst_id	index	acl_team_set_id,deleted
idx_dri_subworkflows_assigned_del	index	assigned_user_id,deleted
idx_dri_subworkflows_del_d_e	index	deleted,date_entered,id
idx_dri_subworkflows_del_d_m	index	deleted,date_modified,id
idx_dri_subworkflows_id_del	index	id,deleted
idx_dri_subworkflows_name_del	index	name,deleted
idx_dri_subworkflows_skey	unique	sync_key
idx_dri_subworkflows_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL dri_workflow_task_templates Definitions:

name	type	len	default
id	char	36
name	varchar	50
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
task_start_date_type	varchar	255
task_due_date_type	varchar	255
momentum_start_type	varchar	255
start_date_module	varchar	255
due_date_module	varchar	255
start_date_field	varchar	255
due_date_field	varchar	255
due_date_criteria	varchar	255	Absolute
momentum_start_module	varchar	255
momentum_start_field	varchar	255
priority	varchar	100	Medium
type	varchar	255	customer_task
activity_type	varchar	255	Tasks
duration_minutes	varchar	2
direction	varchar	100	Outbound
points	int		10
momentum_points	int		100
send_invite_type	varchar	255	none
target_assignee	varchar	255	inherit
assignee_rule	varchar	255	inherit
populate_fields	text
select_to_guests	text
allow_activity_by	text
time_of_day	varchar	255	12:00
sort_order	varchar	255
task_start_days	int
task_due_days	int
momentum_due_days	int
momentum_due_hours	int
duration_hours	int		1
is_parent	tinyint
blocked_by	text
blocked_by_stages	text
url	varchar	255
assignee_rule_activity_id	char	36
start_date_activity_id	char	36
due_date_activity_id	char	36
momentum_start_activity_id	char	36
parent_id	char	36
dri_subworkflow_template_id	char	36
dri_workflow_template_id	char	36
start_next_journey_id	char	36
target_assignee_user_id	char	36
target_assignee_team_id	char	36
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
send_invites	varchar	255	none

MySQL dri_workflow_task_templates Keys:

name	type	fields
idx_cj_act_tpl_ass_rl_act_id	index	assignee_rule_activity_id
idx_cj_act_tpl_due_dt_act_id	index	due_date_activity_id
idx_cj_act_tpl_jry_tpl_id	index	dri_workflow_template_id
idx_cj_act_tpl_mmt_strt_act_id	index	momentum_start_activity_id
idx_cj_act_tpl_nxt_jry_tpl_id	index	start_next_journey_id
idx_cj_act_tpl_parent_id	index	parent_id
idx_cj_act_tpl_stage_tpl_id	index	dri_subworkflow_template_id
idx_cj_act_tpl_start_dt_act_id	index	start_date_activity_id
idx_cj_act_tpl_trgt_asgn_te_id	index	target_assignee_team_id
idx_cj_act_tpl_trgt_asgn_us_id	index	target_assignee_user_id
idx_dri_workflow_task_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_dri_workflow_task_templates_del_d_e	index	deleted,date_entered,id
idx_dri_workflow_task_templates_del_d_m	index	deleted,date_modified,id
idx_dri_workflow_task_templates_id_del	index	id,deleted
idx_dri_workflow_task_templates_name_del	index	name,deleted
idx_dri_workflow_task_templates_skey	unique	sync_key
idx_dri_workflow_task_templates_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL dri_workflow_templates Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
available_modules	text
disabled_stage_actions	text
disabled_activity_actions	text
active_limit	int
points	int
related_activities	int
active	tinyint	1
update_assignees	tinyint
assignee_rule	varchar	255	stage_start
target_assignee	varchar	255	current_user
cancel_action	varchar	255	set_not_applicable
not_applicable_action	varchar	255	default
copied_template_id	char	36
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL dri_workflow_templates Keys:

name	type	fields
idx_cj_jry_tpl_copied_tpl_id	index	copied_template_id
idx_dri_workflow_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_dri_workflow_templates_del_d_e	index	deleted,date_entered,id
idx_dri_workflow_templates_del_d_m	index	deleted,date_modified,id
idx_dri_workflow_templates_id_del	index	id,deleted
idx_dri_workflow_templates_name_del	index	name,deleted
idx_dri_workflow_templates_skey	unique	sync_key
idx_dri_workflow_templates_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL dri_workflows Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
available_modules	text
state	varchar	255	not_started
assignee_rule	varchar	255	stage_start
target_assignee	varchar	255	current_user
progress	float
momentum_ratio	float		1
score	int
points	int
momentum_points	int
momentum_score	int
date_started	datetime
date_completed	datetime
archived	tinyint
is_cancelled	tinyint
is_deleted	tinyint
current_stage_id	char	36
dri_workflow_template_id	char	36
parent_id	char	36
parent_type	varchar	255
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
account_id	char	36
contact_id	char	36
lead_id	char	36
opportunity_id	char	36
case_id	char	36

MySQL dri_workflows Keys:

name	type	fields
idx_cj_journey_tpl_id	index	dri_workflow_template_id
idx_cj_jry_account_id	index	account_id
idx_cj_jry_case_id	index	case_id
idx_cj_jry_contact_id	index	contact_id
idx_cj_jry_current_stage_id	index	current_stage_id
idx_cj_jry_lead_id	index	lead_id
idx_cj_jry_opportunity_id	index	opportunity_id
idx_cj_jry_parent_id	index	parent_id
idx_dri_workflows_acl_tmst_id	index	acl_team_set_id,deleted
idx_dri_workflows_assigned_del	index	assigned_user_id,deleted
idx_dri_workflows_del_d_e	index	deleted,date_entered,id
idx_dri_workflows_del_d_m	index	deleted,date_modified,id
idx_dri_workflows_id_del	index	id,deleted
idx_dri_workflows_name_del	index	name,deleted
idx_dri_workflows_skey	unique	sync_key
idx_dri_workflows_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL dri_workflows_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL dri_workflows_audit Keys:

name	type	fields
idx_dri_workflows_audit_after_value	index	after_value_string
idx_dri_workflows_audit_event_id	index	event_id
idx_dri_workflows_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL eapm Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
password	varchar	255
url	varchar	255
application	varchar	100	webex
api_data	text
consumer_key	varchar	255
consumer_secret	varchar	255
oauth_token	varchar	255
oauth_secret	varchar	255
validated	tinyint
assigned_user_id	char	36
sync_key	varchar	100

MySQL eapm Keys:

name	type	fields
idx_app_active	index	assigned_user_id,application,validated
idx_eapm_assigned_del	index	assigned_user_id,deleted
idx_eapm_date_entered	index	date_entered
idx_eapm_date_modfied	index	date_modified
idx_eapm_del_d_e	index	deleted,date_entered,id
idx_eapm_del_d_m	index	deleted,date_modified,id
idx_eapm_id_del	index	id,deleted
idx_eapm_name_del	index	name,deleted
idx_eapm_skey	unique	sync_key
PRIMARY	primary	id

MySQL email_addr_bean_rel Definitions:

name	type	len	required
id	char	36
email_address_id	char	36	true
bean_id	char	36	true
bean_module	varchar	100
primary_address	tinyint
reply_to_address	tinyint
date_created	datetime
date_modified	datetime
deleted	tinyint

MySQL email_addr_bean_rel Keys:

name	type	fields
idx_bean_id	index	bean_id,bean_module
idx_email_address_bean	index	email_address_id,bean_module,bean_id
idx_primary_address_bean	index	primary_address,deleted,bean_id
PRIMARY	primary	id

MySQL email_addresses Definitions:

name	type	len
id	char	36
email_address	varchar	255
email_address_caps	varchar	255
invalid_email	tinyint
opt_out	tinyint
date_created	datetime
date_modified	datetime
confirmation_requested_on	datetime
deleted	tinyint
id_sib	varchar	255

MySQL email_addresses Keys:

name	type	fields
idx_ea_caps_opt_out_invalid	index	email_address_caps,opt_out,invalid_email
idx_ea_del_ea_id	index	deleted,email_address,id
idx_ea_opt_out_invalid	index	email_address,opt_out,invalid_email
PRIMARY	primary	id

MySQL email_addresses_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL email_addresses_audit Keys:

name	type	fields
idx_email_addresses_audit_after_value	index	after_value_string
idx_email_addresses_audit_event_id	index	event_id
idx_email_addresses_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL email_cache Definitions:

name	type	len
ie_id	char	36
mbox	varchar	60
subject	varchar	255
fromaddr	varchar	100
toaddr	varchar	255
senddate	datetime
message_id	varchar	255
mailsize	int
imap_uid	int
msgno	int
recent	tinyint
flagged	tinyint
answered	tinyint
deleted	tinyint
seen	tinyint
draft	tinyint

MySQL email_cache Keys:

name	type	fields
idx_mail_date	index	ie_id,mbox,senddate
idx_mail_from	index	ie_id,mbox,fromaddr
idx_mail_subj	index	subject
idx_mail_to	index	toaddr

MySQL email_marketing Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	255
from_name	varchar	100
from_addr	varchar	100
reply_to_name	varchar	100
reply_to_addr	varchar	100
inbound_email_id	char	36
date_start	datetime
template_id	char	36	true
status	varchar	100
campaign_id	char	36
all_prospect_lists	tinyint

MySQL email_marketing Keys:

name	type	fields
idx_emmkit_del	index	deleted
idx_emmkt_name	index	name
PRIMARY	primary	id

MySQL email_marketing_prospect_lists Definitions:

name	type	len
id	char	36
prospect_list_id	char	36
email_marketing_id	char	36
date_modified	datetime
deleted	tinyint

MySQL email_marketing_prospect_lists Keys:

name	type	fields
email_mp_prospects	index	email_marketing_id,prospect_list_id
PRIMARY	primary	id

MySQL email_templates Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
published	varchar	3
name	varchar	255
description	text
subject	varchar	255
body	text
body_html	text
deleted	tinyint
base_module	varchar	50
from_name	varchar	255
from_address	varchar	255
text_only	tinyint
type	varchar	255	email
has_variables	tinyint
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL email_templates Keys:

name	type	fields
idx_email_template_name	index	name
idx_email_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_email_templates_assigned_del	index	assigned_user_id,deleted
idx_email_templates_tmst_id	index	team_set_id,deleted
idx_emailtemplate_date_entered	index	date_entered
idx_emailtemplate_date_modified	index	date_modified
idx_emailtemplate_type	index	type
PRIMARY	primary	id

MySQL emailman Definitions:

name	type	len	auto_increment
date_entered	datetime
date_modified	datetime
user_id	char	36
id	int		1
campaign_id	char	36
marketing_id	char	36
list_id	char	36
send_date_time	datetime
modified_user_id	char	36
in_queue	tinyint
in_queue_date	datetime
send_attempts	int
deleted	tinyint
related_id	char	36
related_type	varchar	100

MySQL emailman Keys:

name	type	fields
idx_emailman_send_attempts	index	send_attempts
idx_emailman_send_date_time	index	send_date_time
idx_eman_campaign_id	index	campaign_id
idx_eman_list	index	list_id,user_id,deleted
PRIMARY	primary	id

MySQL emails Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
assigned_user_id	char	36
modified_user_id	char	36
created_by	char	36
deleted	tinyint
date_sent	datetime
message_id	varchar	255
message_uid	varchar	64
name	varchar	255
type	varchar	100
status	varchar	100
flagged	tinyint
reply_to_status	tinyint
intent	varchar	100	pick
mailbox_id	char	36
state	varchar	100	true	Archived
reply_to_id	char	36
parent_type	varchar	255
parent_id	char	36
total_attachments	int
outbound_email_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
direction	varchar	20	true	Unknown
sync_key	varchar	100

MySQL emails Keys:

name	type	fields
idx_date_modified	index	date_modified
idx_email_assigned	index	assigned_user_id,type,status
idx_email_name	index	name
idx_email_parent_id	index	parent_id
idx_emails_acl_tmst_id	index	acl_team_set_id,deleted
idx_emails_skey	unique	sync_key
idx_emails_tmst_id	index	team_set_id,deleted
idx_mailbox_id	index	mailbox_id
idx_message_id	index	message_id
idx_state	index	state,id
PRIMARY	primary	id

MySQL emails_beans Definitions:

name	type	len
id	char	36
email_id	char	36
bean_id	char	36
bean_module	varchar	100
campaign_data	text
date_modified	datetime
deleted	tinyint

MySQL emails_beans Keys:

name	type	fields
idx_emails_beans_bean_id	index	bean_id
idx_emails_beans_email_bean	index	email_id,bean_id,deleted
PRIMARY	primary	id

MySQL emails_cstm Definitions:

name	type	len
id_c	char	36
pk_tipoinvio_c	varchar	100

MySQL emails_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL emails_email_addr_rel Definitions:

name	type	len
id	char	36
email_id	char	36
address_type	varchar	4
email_address_id	char	36
parent_type	varchar	255
parent_id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime

MySQL emails_email_addr_rel Keys:

name	type	fields
idx_eearl_email_address_deleted	index	email_address_id,deleted
idx_eearl_email_address_role	index	email_address_id,address_type,deleted
idx_eearl_email_id	index	email_id,address_type
idx_eearl_parent	index	parent_type,parent_id,deleted
idx_eearl_parent_role	index	parent_type,parent_id,address_type,deleted
PRIMARY	primary	id

MySQL emails_text Definitions:

name	type	len
email_id	char	36
from_addr	varchar	255
reply_to_addr	varchar	255
to_addrs	text
cc_addrs	text
bcc_addrs	text
description	longtext
description_html	longtext
raw_source	longtext
deleted	tinyint

MySQL emails_text Keys:

name	type	fields
emails_textfromaddr	index	from_addr
PRIMARY	primary	email_id

MySQL embedded_files Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
filename	varchar	255
file_mime_type	varchar	100
sync_key	varchar	100

MySQL embedded_files Keys:

name	type	fields
idx_embedded_files_date_entered	index	date_entered
idx_embedded_files_date_modfied	index	date_modified
idx_embedded_files_del_d_e	index	deleted,date_entered,id
idx_embedded_files_del_d_m	index	deleted,date_modified,id
idx_embedded_files_id_del	index	id,deleted
idx_embedded_files_name_del	index	name,deleted
idx_embedded_files_skey	unique	sync_key
PRIMARY	primary	id

MySQL erased_fields Definitions:

name	type	len
bean_id	char	36
table_name	varchar	128
data	text

MySQL erased_fields Keys:

name	type	fields
PRIMARY	primary	bean_id,table_name

MySQL escalations Definitions:

name	type	len	auto_increment	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
escalation_number	int		1	true
status	varchar	100
reason	varchar	100
source	varchar	100
parent_type	varchar	255
parent_id	char	36
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36

MySQL escalations Keys:

name	type	fields
escalationnumk	unique	escalation_number
idx_escalations_acl_tmst_id	index	acl_team_set_id,deleted
idx_escalations_assigned_del	index	assigned_user_id,deleted
idx_escalations_del_d_e	index	deleted,date_entered,id
idx_escalations_del_d_m	index	deleted,date_modified,id
idx_escalations_id_del	index	id,deleted
idx_escalations_name_del	index	name,deleted
idx_escalations_skey	unique	sync_key
idx_escalations_tmst_id	index	team_set_id,deleted
idx_parent_escalation	index	parent_id,parent_type
PRIMARY	primary	id

MySQL escalations_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL escalations_audit Keys:

name	type	fields
idx_escalations_audit_after_value	index	after_value_string
idx_escalations_audit_event_id	index	event_id
idx_escalations_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL escalations_cstm Definitions:

name	type	len	default
id_c	char	36
pk_operatore_c	varchar	100	Scegli
pk_emailoperatore_c	varchar	255
pk_pc1_c	varchar	100	Scegli
pk_pc2_c	varchar	100
pk_emailpc1_c	varchar	40
pk_emailpc2_c	varchar	40

MySQL escalations_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL expressions Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
lhs_type	varchar	15
lhs_field	varchar	50
lhs_module	varchar	50
lhs_value	varchar	100
lhs_group_type	varchar	10
operator	varchar	15
rhs_group_type	varchar	10
rhs_type	varchar	15
rhs_field	varchar	50
rhs_module	varchar	50
rhs_value	varchar	255
parent_id	char	36	true
exp_type	varchar	100
exp_order	int
parent_type	varchar	255
parent_exp_id	char	36
parent_exp_side	int
ext1	varchar	50
ext2	varchar	50
ext3	varchar	50

MySQL expressions Keys:

name	type	fields
idx_exp	index	parent_id,deleted
PRIMARY	primary	id

MySQL external_users Definitions:

name	type	len
salutation	varchar	255
first_name	varchar	255
last_name	varchar	255
name	varchar	255
title	varchar	100
facebook	varchar	100
twitter	varchar	100
googleplus	varchar	100
department	varchar	255
do_not_call	tinyint
phone_home	varchar	100
phone_mobile	varchar	100
phone_work	varchar	100
phone_other	varchar	100
phone_fax	varchar	100
primary_address_street	varchar	150
primary_address_city	varchar	100
primary_address_state	varchar	100
primary_address_postalcode	varchar	20
primary_address_country	varchar	255
alt_address_street	varchar	150
alt_address_city	varchar	100
alt_address_state	varchar	100
alt_address_postalcode	varchar	20
alt_address_country	varchar	255
assistant	varchar	75
assistant_phone	varchar	100
picture	varchar	255
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
user_name	varchar	255
status	varchar	100
external_app	varchar	255
external_id	varchar	255
contact_id	char	36
source_id	varchar	255
source_type	varchar	255
source_meta	text
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL external_users Keys:

name	type	fields
idx_external_users_acl_tmst_id	index	acl_team_set_id,deleted
idx_external_users_assigned_del	index	assigned_user_id,deleted
idx_external_users_del_d_e	index	deleted,date_entered,id
idx_external_users_del_d_m	index	deleted,date_modified,id
idx_external_users_external_id	index	external_id
idx_external_users_id_del	index	id,deleted
idx_external_users_name_del	index	name,deleted
idx_external_users_skey	unique	sync_key
idx_external_users_tmst_id	index	team_set_id,deleted
idx_external_users_user_name	index	user_name
idx_externalusers_first_last	index	first_name,last_name,deleted
idx_externalusers_last_first	index	last_name,first_name,deleted
PRIMARY	primary	id

MySQL external_users_accounts Definitions:

name	type	len
id	char	36
external_user_id	char	36
account_id	char	36
date_modified	datetime
deleted	tinyint

MySQL external_users_accounts Keys:

name	type	fields
idx_ext_user_acc_acc	index	account_id
idx_ext_user_acc_user	index	external_user_id,account_id
PRIMARY	primary	id

MySQL external_users_bugs Definitions:

name	type	len
id	char	36
external_user_id	char	36
bug_id	char	36
date_modified	datetime
deleted	tinyint

MySQL external_users_bugs Keys:

name	type	fields
idx_ext_user_bug_bug	index	bug_id
idx_ext_user_bug_user	index	external_user_id,bug_id
PRIMARY	primary	id

MySQL external_users_cases Definitions:

name	type	len
id	char	36
external_user_id	char	36
case_id	char	36
date_modified	datetime
deleted	tinyint

MySQL external_users_cases Keys:

name	type	fields
idx_ext_user_case_case	index	case_id
idx_ext_user_case_user	index	external_user_id,case_id
PRIMARY	primary	id

MySQL external_users_opportunities Definitions:

name	type	len
id	char	36
external_user_id	char	36
opportunity_id	char	36
date_modified	datetime
deleted	tinyint

MySQL external_users_opportunities Keys:

name	type	fields
idx_ext_user_opp_opp	index	opportunity_id
idx_ext_user_opp_user	index	external_user_id,opportunity_id
PRIMARY	primary	id

MySQL external_users_quotes Definitions:

name	type	len
id	char	36
external_user_id	char	36
quote_id	char	36
date_modified	datetime
deleted	tinyint

MySQL external_users_quotes Keys:

name	type	fields
idx_ext_user_qt_qt	index	quote_id
idx_ext_user_qt_user	index	external_user_id,quote_id
PRIMARY	primary	id

MySQL fi_fiere Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
datainiz	date
datafine	date
pk_nome_fiera	varchar	255
pk_anno	varchar	100
pk_mese	varchar	100
pk_stato	varchar	100
sync_key	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36

MySQL fi_fiere Keys:

name	type	fields
idx_fi_fiere_acl_tmst_id	index	acl_team_set_id,deleted
idx_fi_fiere_assigned_del	index	assigned_user_id,deleted
idx_fi_fiere_del_d_e	index	deleted,date_entered,id
idx_fi_fiere_del_d_m	index	deleted,date_modified,id
idx_fi_fiere_id_del	index	id,deleted
idx_fi_fiere_name_del	index	name,deleted
idx_fi_fiere_skey	unique	sync_key
idx_fi_fiere_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL fi_fiere_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL fi_fiere_audit Keys:

name	type	fields
idx_fi_fiere_audit_after_value	index	after_value_string
idx_fi_fiere_audit_event_id	index	event_id
idx_fi_fiere_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL fi_fiere_leads_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
fi_fiere_leads_1fi_fiere_ida	char	36
fi_fiere_leads_1leads_idb	char	36

MySQL fi_fiere_leads_1_c Keys:

name	type	fields
fi_fiere_leads_1_alt	index	fi_fiere_leads_1leads_idb
idx_fi_fiere_leads_1_ida1_deleted	index	fi_fiere_leads_1fi_fiere_ida,deleted
idx_fi_fiere_leads_1_idb2_deleted	index	fi_fiere_leads_1leads_idb,deleted
PRIMARY	primary	id

MySQL fields_meta_data Definitions:

name	type	len
id	char	36
name	varchar	255
vname	varchar	255
comments	varchar	255
help	varchar	255
custom_module	varchar	255
type	varchar	255
len	int
required	tinyint
default_value	varchar	255
date_modified	datetime
deleted	tinyint
audited	tinyint
massupdate	tinyint
duplicate_merge	smallint
reportable	tinyint	1
importable	varchar	255
ext1	varchar	255
ext2	varchar	255
ext3	varchar	255
ext4	text
autoinc_next	int

MySQL fields_meta_data Keys:

name	type	fields
idx_fields_meta_data_custom_module_name	unique	custom_module,name
PRIMARY	primary	id

MySQL filters Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
filter_definition	longtext
filter_template	longtext
module_name	varchar	100
team_id	char	36
team_set_id	char	36
assigned_user_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
app	varchar	36	base

MySQL filters Keys:

name	type	fields
idx_filters_acl_tmst_id	index	acl_team_set_id,deleted
idx_filters_assigned_del	index	assigned_user_id,deleted
idx_filters_date_entered	index	date_entered
idx_filters_date_modfied	index	date_modified
idx_filters_del_d_e	index	deleted,date_entered,id
idx_filters_del_d_m	index	deleted,date_modified,id
idx_filters_id_del	index	id,deleted
idx_filters_name_del	index	name,deleted
idx_filters_skey	unique	sync_key
idx_filters_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL fm_famprod Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL fm_famprod Keys:

name	type	fields
idx_fm_famprod_acl_tmst_id	index	acl_team_set_id,deleted
idx_fm_famprod_assigned_del	index	assigned_user_id,deleted
idx_fm_famprod_date_entered	index	date_entered
idx_fm_famprod_date_modfied	index	date_modified
idx_fm_famprod_del_d_e	index	deleted,date_entered,id
idx_fm_famprod_del_d_m	index	deleted,date_modified,id
idx_fm_famprod_id_del	index	id,deleted
idx_fm_famprod_name_del	index	name,deleted
idx_fm_famprod_skey	unique	sync_key
idx_fm_famprod_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL fm_famprod_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL fm_famprod_audit Keys:

name	type	fields
idx_fm_famprod_audit_after_value	index	after_value_string
idx_fm_famprod_audit_event_id	index	event_id
idx_fm_famprod_audit_pa_ev_id	index	parent_id,event_id
idx_fm_famprod_audit_parent_id	index	parent_id
PRIMARY	primary	id

MySQL fm_famprod_cstm Definitions:

name	type	len
id_c	char	36
cod_si5_c	varchar	255

MySQL fm_famprod_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL folders Definitions:

name	type	len	required
id	char	36
name	varchar	25
folder_type	varchar	25
parent_folder	char	36
has_child	tinyint
is_group	tinyint
is_dynamic	tinyint
dynamic_query	text
assign_to_id	char	36
team_id	char	36
team_set_id	char	36
created_by	char	36	true
modified_by	char	36	true
deleted	tinyint
acl_team_set_id	char	36

MySQL folders Keys:

name	type	fields
idx_parent_folder	index	parent_folder
PRIMARY	primary	id

MySQL folders_rel Definitions:

name	type	len	required
id	char	36
folder_id	char	36	true
polymorphic_module	varchar	25
polymorphic_id	char	36	true
deleted	tinyint

MySQL folders_rel Keys:

name	type	fields
idx_fr_id_deleted_poly	index	folder_id,deleted,polymorphic_id
idx_poly_module_poly_id	index	polymorphic_module,polymorphic_id
PRIMARY	primary	id

MySQL folders_subscriptions Definitions:

name	type	len	required
id	char	36
folder_id	char	36	true
assigned_user_id	char	36	true

MySQL folders_subscriptions Keys:

name	type	fields
idx_folder_id_assigned_user_id	index	folder_id,assigned_user_id
PRIMARY	primary	id

MySQL forecast_manager_worksheets Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
quota	decimal	26,6
best_case	decimal	26,6
best_case_adjusted	decimal	26,6
likely_case	decimal	26,6
likely_case_adjusted	decimal	26,6
worst_case	decimal	26,6
worst_case_adjusted	decimal	26,6
timeperiod_id	char	36
draft	tinyint
user_id	char	36
opp_count	int
pipeline_opp_count	int
pipeline_amount	decimal	26,6	0.000000
closed_amount	decimal	26,6	0.000000
manager_saved	tinyint
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
sync_key	varchar	100

MySQL forecast_manager_worksheets Keys:

name	type	fields
idx_forecast_manager_worksheets_acl_tmst_id	index	acl_team_set_id,deleted
idx_forecast_manager_worksheets_assigned_del	index	assigned_user_id,deleted
idx_forecast_manager_worksheets_date_entered	index	date_entered
idx_forecast_manager_worksheets_date_modfied	index	date_modified
idx_forecast_manager_worksheets_del_d_e	index	deleted,date_entered,id
idx_forecast_manager_worksheets_del_d_m	index	deleted,date_modified,id
idx_forecast_manager_worksheets_id_del	index	id,deleted
idx_forecast_manager_worksheets_name_del	index	name,deleted
idx_forecast_manager_worksheets_skey	unique	sync_key
idx_forecast_manager_worksheets_tmst_id	index	team_set_id,deleted
idx_manager_worksheets_user_timestamp_assigned_user	index	assigned_user_id,user_id,timeperiod_id,draft,deleted
PRIMARY	primary	id

MySQL forecast_manager_worksheets_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL forecast_manager_worksheets_audit Keys:

name	type	fields
idx_forecast_manager_worksheets_audit_after_value	index	after_value_string
idx_forecast_manager_worksheets_audit_event_id	index	event_id
idx_forecast_manager_worksheets_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL forecast_tree Definitions:

name	type	len
id	char	36
name	varchar	50
hierarchy_type	varchar	25
user_id	char	36
parent_id	char	36

MySQL forecast_tree Keys:

name	type	fields
forecast_tree_idx_user_id	index	user_id
PRIMARY	primary	id

MySQL forecast_worksheets Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
parent_id	char	36
parent_type	varchar	255
opportunity_id	char	36
opportunity_name	varchar	255
account_name	varchar	255
account_id	char	36
campaign_id	char	36
campaign_name	varchar	255
product_template_id	char	36
product_template_name	varchar	255
category_id	char	36
category_name	varchar	255
sales_status	varchar	255
likely_case	decimal	26,6
best_case	decimal	26,6
worst_case	decimal	26,6
date_closed	date
date_closed_timestamp	bigint
sales_stage	varchar	255
probability	double
commit_stage	varchar	50
draft	int
next_step	varchar	100
lead_source	varchar	50
product_type	varchar	255
list_price	decimal	26,6
cost_price	decimal	26,6
discount_price	decimal	26,6
discount_amount	decimal	26,6
quantity	int		1
total_amount	decimal	26,6
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
sync_key	varchar	100

MySQL forecast_worksheets Keys:

name	type	fields
idx_forecast_worksheets_acl_tmst_id	index	acl_team_set_id,deleted
idx_forecast_worksheets_assigned_del	index	assigned_user_id,deleted
idx_forecast_worksheets_date_entered	index	date_entered
idx_forecast_worksheets_date_modfied	index	date_modified
idx_forecast_worksheets_del_d_e	index	deleted,date_entered,id
idx_forecast_worksheets_del_d_m	index	deleted,date_modified,id
idx_forecast_worksheets_id_del	index	id,deleted
idx_forecast_worksheets_name_del	index	name,deleted
idx_forecast_worksheets_skey	unique	sync_key
idx_forecast_worksheets_tmst_id	index	team_set_id,deleted
idx_forecastworksheet_aid_del_id	index	account_id,deleted,id
idx_forecastworksheet_commit_stage	index	commit_stage
idx_forecastworksheet_oppid_del_id	index	opportunity_id,deleted,id
idx_forecastworksheet_sales_stage	index	sales_stage
idx_worksheets_assigned_del_time_draft_parent_type	index	deleted,assigned_user_id,draft,date_closed_timestamp,parent_type
idx_worksheets_parent	index	parent_id,parent_type
PRIMARY	primary	id

MySQL forecasts Definitions:

name	type	len	default
id	char	36
timeperiod_id	char	36
forecast_type	varchar	100
opp_count	int
pipeline_opp_count	int
pipeline_amount	decimal	26,6	0.000000
closed_amount	decimal	26,6	0.000000
opp_weigh_value	int
best_case	decimal	26,6
likely_case	decimal	26,6
worst_case	decimal	26,6
user_id	char	36
date_entered	datetime
date_modified	datetime
deleted	tinyint
currency_id	char	36	-99
base_rate	decimal	26,6

MySQL forecasts Keys:

name	type	fields
idx_forecast_user_tp	index	user_id,timeperiod_id,date_modified
PRIMARY	primary	id

MySQL fts_queue Definitions:

name	type	len
id	char	36
bean_id	char	36
bean_module	varchar	100
date_modified	datetime
date_created	datetime
processed	tinyint

MySQL fts_queue Keys:

name	type	fields
PRIMARY	primary	id

MySQL geocode Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
deleted	tinyint
parent_id	varchar	36
parent_type	varchar	64
parent_name	varchar	256
parent_user_name	varchar	256
address	text
status	varchar	100
postalcode	varchar	64
country	varchar	64
latitude	decimal	18,10	0.0000000000
longitude	decimal	18,10	0.0000000000
geocoded	tinyint
error_message	text

MySQL geocode Keys:

name	type	fields
idx_coords_from_record	index	parent_type,parent_id,geocoded,status
idx_coords_from_zip	index	postalcode,country,geocoded,status
idx_geocode_country	index	country
idx_geocode_del_d_e	index	deleted,date_entered,id
idx_geocode_del_d_m	index	deleted,date_modified,id
idx_geocode_geocoded	index	geocoded,id
idx_geocode_id_del	index	id,deleted
idx_geocode_p_i_id	index	parent_id,id
idx_geocode_p_t_id	index	parent_type,id
idx_geocode_postal_code	index	postalcode
idx_geocode_status	index	status
PRIMARY	primary	id

MySQL geocode_job Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
deleted	tinyint
status	varchar	64
processed_entity_success_count	varchar	64
processed_entity_failed_count	varchar	64
addresses_data	longtext
geocode_result	longtext

MySQL geocode_job Keys:

name	type	fields
idx_geocode_job_del_d_e	index	deleted,date_entered,id
idx_geocode_job_del_d_m	index	deleted,date_modified,id
idx_geocode_job_id_del	index	id,deleted
idx_geocode_job_status	index	status,id
PRIMARY	primary	id

MySQL geocode_queue Definitions:

name	type	len
id	char	36
bean_id	char	36
geocode_id	char	36
bean_module	varchar	100
date_modified	datetime
date_created	datetime

MySQL geocode_queue Keys:

name	type	fields
idx_beans_bean_id	index	bean_module,bean_id
idx_geocode_id	index	geocode_id
idx_geocode_queue_bean_id	index	bean_id
PRIMARY	primary	id

MySQL hint_accountsets Definitions:

name	type	len	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
type	varchar	20
category	varchar	128
sync_key	varchar	100
assigned_user_id	char	36	true
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL hint_accountsets Keys:

name	type	fields
idx_hint_accountsets_acl_tmst_id	index	acl_team_set_id,deleted
idx_hint_accountsets_assigned_del	index	assigned_user_id,deleted
idx_hint_accountsets_del_d_e	index	deleted,date_entered,id
idx_hint_accountsets_del_d_m	index	deleted,date_modified,id
idx_hint_accountsets_id_del	index	id,deleted
idx_hint_accountsets_name_del	index	name,deleted
idx_hint_accountsets_skey	unique	sync_key
idx_hint_accountsets_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL hint_accountsets_targets Definitions:

name	type	len
id	char	36
accountset_id	char	36
target_id	char	36
date_modified	datetime
deleted	tinyint

MySQL hint_accountsets_targets Keys:

name	type	fields
accountsets_targets_acc_idk	index	accountset_id
accountsets_targets_trg_idk	index	target_id
PRIMARY	primary	id

MySQL hint_enrich_field_config Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
config_data	text
created	datetime
synced	tinyint
sync_key	varchar	100
assigned_user_id	char	36

MySQL hint_enrich_field_config Keys:

name	type	fields
idx_hint_enrich_field_config_assigned_del	index	assigned_user_id,deleted
idx_hint_enrich_field_config_del_d_e	index	deleted,date_entered,id
idx_hint_enrich_field_config_del_d_m	index	deleted,date_modified,id
idx_hint_enrich_field_config_id_del	index	id,deleted
idx_hint_enrich_field_config_name_del	index	name,deleted
idx_hint_enrich_field_config_skey	unique	sync_key
PRIMARY	primary	id

MySQL hint_events_queue Definitions:

name	type	len	default	required
id	char	36
type	varchar	32
data	longtext
user_id	char	36
processing_instance	varchar	32
processing_start_time	datetime
group_ms	decimal	26,4	0.0000
event_number	int		1	true
created	datetime

MySQL hint_events_queue Keys:

name	type	fields
event_number_uk	unique	event_number
hint_events_queue_instance_ordered_idk	index	processing_instance,group_ms,event_number
hint_events_queue_start_time_idk	index	processing_start_time
PRIMARY	primary	id

MySQL hint_news_notifications Definitions:

name	type	len	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
category	varchar	32
title	varchar	256
article_date	datetime
photo_url	text
source_url	text
publisher	varchar	64
sync_key	varchar	100
assigned_user_id	char	36	true

MySQL hint_news_notifications Keys:

name	type	fields
idx_hint_news_notifications_assigned_del	index	assigned_user_id,deleted
idx_hint_news_notifications_del_d_e	index	deleted,date_entered,id
idx_hint_news_notifications_del_d_m	index	deleted,date_modified,id
idx_hint_news_notifications_id_del	index	id,deleted
idx_hint_news_notifications_name_del	index	name,deleted
idx_hint_news_notifications_skey	unique	sync_key
PRIMARY	primary	id

MySQL hint_notification_targets Definitions:

name	type	len	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
type	varchar	32
credentials	longtext
sync_key	varchar	100
assigned_user_id	char	36	true

MySQL hint_notification_targets Keys:

name	type	fields
idx_hint_notification_targets_assigned_del	index	assigned_user_id,deleted
idx_hint_notification_targets_assigned_type_del	index	assigned_user_id,type,deleted
idx_hint_notification_targets_del_d_e	index	deleted,date_entered,id
idx_hint_notification_targets_del_d_m	index	deleted,date_modified,id
idx_hint_notification_targets_id_del	index	id,deleted
idx_hint_notification_targets_name_del	index	name,deleted
idx_hint_notification_targets_skey	unique	sync_key
PRIMARY	primary	id

MySQL holidays Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
holiday_date	date
description	text
deleted	tinyint
person_id	char	36
person_type	varchar	255
related_module	varchar	255
related_module_id	char	36
resource_name	varchar	255
name	varchar	255

MySQL holidays Keys:

name	type	fields
idx_holiday_holiday_date	index	holiday_date
idx_holiday_id_del	index	id,deleted
idx_holiday_id_rel	index	related_module_id,related_module
PRIMARY	primary	id

MySQL import_maps Definitions:

name	type	len	default
id	char	36
name	varchar	254
source	varchar	36
enclosure	varchar	1
delimiter	varchar	1	,
module	varchar	36
content	text
default_values	text
has_header	tinyint	1
deleted	tinyint
date_entered	datetime
date_modified	datetime
assigned_user_id	char	36
is_published	varchar	3	no

MySQL import_maps Keys:

name	type	fields
idx_owner_module_name	index	assigned_user_id,module,name,deleted
PRIMARY	primary	id

MySQL inbound_email Definitions:

name	type	len	default
id	varchar	255
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	255
status	varchar	100	Active
server_url	varchar	100
email_user	varchar	100
email_password	varchar	255
port	int
service	varchar	50
mailbox	text
delete_seen	tinyint
mailbox_type	varchar	10
template_id	char	36
stored_options	text
group_id	char	36
is_personal	tinyint
groupfolder_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
eapm_id	char	36
authorized_account	varchar	255
auth_type	varchar	10
email_provider	varchar	20	other

MySQL inbound_email Keys:

name	type	fields
idx_deleted	index	deleted
idx_inbound_email_acl_tmst_id	index	acl_team_set_id,deleted
idx_inbound_email_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL inbound_email_autoreply Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
autoreplied_to	varchar	100
ie_id	char	36	true

MySQL inbound_email_autoreply Keys:

name	type	fields
idx_ie_autoreplied_to	index	autoreplied_to
PRIMARY	primary	id

MySQL inbound_email_cache_ts Definitions:

name	type	len
id	varchar	255
ie_timestamp	int

MySQL inbound_email_cache_ts Keys:

name	type	fields
PRIMARY	primary	id

MySQL job_queue Definitions:

name	type	len
id	char	36
name	varchar	255
deleted	tinyint
date_entered	datetime
date_modified	datetime
scheduler_id	char	36
execute_time	datetime
status	varchar	20
resolution	varchar	20
message	text
target	varchar	255
data	longtext
requeue	tinyint
retry_count	tinyint
failure_count	tinyint
job_delay	int
client	varchar	255
percent_complete	int
job_group	varchar	255
module	varchar	255
fallible	tinyint
rerun	tinyint
interface	tinyint
assigned_user_id	char	36

MySQL job_queue Keys:

name	type	fields
idx_del_time_status	index	deleted,execute_time,status
idx_job_queue_assigned_del	index	assigned_user_id,deleted
idx_resolution_executetime	index	resolution,execute_time
idx_status_sched_id	index	status,scheduler_id
idx_target_jobgroup	index	target,job_group,resolution
PRIMARY	primary	id

MySQL kbarticles Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
kbdocument_id	char	36
team_id	char	36
team_set_id	char	36
assigned_user_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL kbarticles Keys:

name	type	fields
idx_kbarticles_acl_tmst_id	index	acl_team_set_id,deleted
idx_kbarticles_assigned_del	index	assigned_user_id,deleted
idx_kbarticles_date_entered	index	date_entered
idx_kbarticles_date_modfied	index	date_modified
idx_kbarticles_del_d_e	index	deleted,date_entered,id
idx_kbarticles_del_d_m	index	deleted,date_modified,id
idx_kbarticles_id_del	index	id,deleted
idx_kbarticles_name_del	index	name,deleted
idx_kbarticles_skey	unique	sync_key
idx_kbarticles_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL kbcontent_templates Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
body	longtext
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL kbcontent_templates Keys:

name	type	fields
idx_kbcontent_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_kbcontent_templates_date_entered	index	date_entered
idx_kbcontent_templates_date_modfied	index	date_modified
idx_kbcontent_templates_del_d_e	index	deleted,date_entered,id
idx_kbcontent_templates_del_d_m	index	deleted,date_modified,id
idx_kbcontent_templates_id_del	index	id,deleted
idx_kbcontent_templates_name_del	index	name,deleted
idx_kbcontent_templates_skey	unique	sync_key
idx_kbcontent_templates_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL kbcontent_templates_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL kbcontent_templates_audit Keys:

name	type	fields
idx_kbcontent_templates_audit_after_value	index	after_value_string
idx_kbcontent_templates_audit_event_id	index	event_id
idx_kbcontent_templates_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL kbcontents Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
kbdocument_body	longtext
language	varchar	2
active_date	date
exp_date	date
approved	tinyint
status	varchar	100	draft
viewcount	int
revision	int
useful	int
notuseful	int
kbdocument_id	char	36
active_rev	tinyint
is_external	tinyint
kbarticle_id	char	36
kbsapprover_id	char	36
kbscase_id	char	36
category_id	char	36
team_id	char	36
team_set_id	char	36
assigned_user_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL kbcontents Keys:

name	type	fields
idx_kbcontent_del_doc_id	index	kbdocument_id,deleted
idx_kbcontents_acl_tmst_id	index	acl_team_set_id,deleted
idx_kbcontents_assigned_del	index	assigned_user_id,deleted
idx_kbcontents_date_entered	index	date_entered
idx_kbcontents_date_modfied	index	date_modified
idx_kbcontents_del_d_e	index	deleted,date_entered,id
idx_kbcontents_del_d_m	index	deleted,date_modified,id
idx_kbcontents_id_del	index	id,deleted
idx_kbcontents_name_del	index	name,deleted
idx_kbcontents_skey	unique	sync_key
idx_kbcontents_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL kbcontents_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL kbcontents_audit Keys:

name	type	fields
idx_kbcontents_audit_after_value	index	after_value_string
idx_kbcontents_audit_event_id	index	event_id
idx_kbcontents_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL kbdocuments Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
team_id	char	36
team_set_id	char	36
assigned_user_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL kbdocuments Keys:

name	type	fields
idx_kbdocuments_acl_tmst_id	index	acl_team_set_id,deleted
idx_kbdocuments_assigned_del	index	assigned_user_id,deleted
idx_kbdocuments_date_entered	index	date_entered
idx_kbdocuments_date_modfied	index	date_modified
idx_kbdocuments_del_d_e	index	deleted,date_entered,id
idx_kbdocuments_del_d_m	index	deleted,date_modified,id
idx_kbdocuments_id_del	index	id,deleted
idx_kbdocuments_name_del	index	name,deleted
idx_kbdocuments_skey	unique	sync_key
idx_kbdocuments_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL kbusefulness Definitions:

name	type	len	required
id	char	36
kbarticle_id	char	36	true
user_id	char	36	true
contact_id	char	36
vote	smallint
zeroflag	tinyint
ssid	char	36
date_modified	datetime
deleted	tinyint

MySQL kbusefulness Keys:

name	type	fields
kbusefulness_user	index	kbarticle_id,user_id
PRIMARY	primary	id

MySQL key_value_cache Definitions:

name	type	len
id	char	32
date_expires	datetime
value	longtext

MySQL key_value_cache Keys:

name	type	fields
key_value_cache_date_expires	index	date_expires
PRIMARY	primary	id

MySQL leads Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
salutation	varchar	255
first_name	varchar	255
last_name	varchar	255
title	varchar	100
facebook	varchar	100
twitter	varchar	100
googleplus	varchar	100
department	varchar	100
do_not_call	tinyint
phone_home	varchar	100
phone_mobile	varchar	100
phone_work	varchar	100
phone_other	varchar	100
phone_fax	varchar	100
primary_address_street	varchar	150
primary_address_city	varchar	100
primary_address_state	varchar	100
primary_address_postalcode	varchar	20
primary_address_country	varchar	255
alt_address_street	varchar	150
alt_address_city	varchar	100
alt_address_state	varchar	100
alt_address_postalcode	varchar	20
alt_address_country	varchar	255
assistant	varchar	75
assistant_phone	varchar	100
picture	varchar	255
converted	tinyint
refered_by	varchar	100
lead_source	varchar	100
lead_source_description	text
status	varchar	100	New
status_description	text
reports_to_id	char	36
dp_business_purpose	text
dp_consent_last_updated	date
dnb_principal_id	varchar	30
account_name	varchar	255
account_description	text
contact_id	char	36
account_id	char	36
opportunity_id	char	36
opportunity_name	varchar	255
opportunity_amount	varchar	50
campaign_id	char	36
birthdate	date
website	varchar	255
preferred_language	varchar	255
mkto_sync	tinyint
mkto_id	int
mkto_lead_score	int
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
portal_name	varchar	255
portal_app	varchar	255
acl_team_set_id	char	36
business_center_id	char	36
sync_key	varchar	100
ai_conv_score_classification	varchar	255
ai_icp_fit_score_classification	varchar	255
market_interest_prediction_score	varchar	255
market_score	int
hint_account_size	varchar	20
hint_account_industry	varchar	120
hint_account_location	varchar	255
hint_account_description	varchar	255
hint_job_2	varchar	255
hint_education	varchar	225
hint_education_2	varchar	225
hint_facebook	varchar	120
hint_twitter	varchar	120
hint_industry_tags	varchar	225
hint_account_founded_year	varchar	5
hint_account_facebook_handle	varchar	120
hint_account_twitter_handle	varchar	120
hint_account_logo	varchar	255
hint_contact_pic	text
hint_photo	varchar	255
hint_phone_1	varchar	15
hint_phone_2	varchar	15
hint_account_naics_code_lbl	varchar	170
hint_account_sic_code_label	varchar	120
hint_account_fiscal_year_end	varchar	5
hint_account_annual_revenue	varchar	25
hint_account_website	varchar	255
ai_conv_score_absolute	decimal	10,0
ai_conv_bin_accuracy	decimal	10,0
ai_conv_multiplier	decimal	10,0
ai_icp_fit_score_absolute	decimal	10,0
ai_icp_fit_bin_accuracy	decimal	10,0
ai_icp_fit_multiplier	decimal	10,0
geocode_status	varchar	255
dri_workflow_template_id	char	36

MySQL leads Keys:

name	type	fields
idx_lead_acct_name_first	index	deleted,account_name,date_modified,id,team_set_id
idx_lead_contact	index	contact_id
idx_lead_idx_del_last_name	index	deleted,last_name
idx_lead_mkto_id	index	mkto_id
idx_lead_opp_del	index	deleted,opportunity_id,id
idx_lead_phone_work	index	phone_work
idx_leads_acct_del	index	account_id,deleted
idx_leads_acl_tmst_id	index	acl_team_set_id,deleted
idx_leads_assigned_del	index	assigned_user_id,deleted
idx_leads_cjtpl_id	index	dri_workflow_template_id
idx_leads_date_entered	index	date_entered
idx_leads_date_modfied	index	date_modified
idx_leads_del_businesscenter	index	deleted,business_center_id
idx_leads_del_d_e	index	deleted,date_entered,id
idx_leads_del_d_m	index	deleted,date_modified,id
idx_leads_first_last	index	first_name,last_name,deleted
idx_leads_id_del	index	id,deleted
idx_leads_last_first	index	last_name,first_name,deleted
idx_leads_skey	unique	sync_key
idx_leads_status	index	deleted,status
idx_leads_tmst_id	index	team_set_id,deleted
idx_reports_to	index	deleted,reports_to_id,id
PRIMARY	primary	id

MySQL leads_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL leads_audit Keys:

name	type	fields
idx_leads_audit_after_value	index	after_value_string
idx_leads_audit_event_id	index	event_id
idx_leads_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL leads_cstm Definitions:

name	type	len
id_c	char	36
descrizione_mktg_c	text
filiera_mktg_c	varchar	100
fonte_specifica_c	varchar	255
fonte_lead_c	varchar	100
tipo_richiesta_c	varchar	100
macro_settore_c	varchar	100
settore_specifico_c	varchar	100
lingua_lead_2_c	varchar	100
nazione_dd_c	varchar	100
pk_biglietto_c	varchar	255
dipartimento_c	varchar	100
pk_img1_c	varchar	255
pk_img2_c	varchar	255
pk_img3_c	varchar	255
regione_dd_c	varchar	100
provincia_dd_c	varchar	100

MySQL leads_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL leads_dataprivacy Definitions:

name	type	len
id	char	36
lead_id	char	36
dataprivacy_id	char	36
date_modified	datetime
deleted	tinyint

MySQL leads_dataprivacy Keys:

name	type	fields
idx_lead_dataprivacy_dataprivacy	index	dataprivacy_id
idx_leads_dataprivacy	index	lead_id,dataprivacy_id
PRIMARY	primary	id

MySQL linked_documents Definitions:

name	type	len
id	char	36
parent_id	char	36
parent_type	varchar	25
document_id	char	36
document_revision_id	char	36
date_modified	datetime
deleted	tinyint

MySQL linked_documents Keys:

name	type	fields
idx_parent_document	index	parent_type,parent_id,document_id
PRIMARY	primary	id

MySQL locked_field_bean_rel Definitions:

name	type	len	required
id	char	36
pd_id	char	36	true
bean_id	char	36	true
bean_module	varchar	100
date_modified	datetime
deleted	tinyint

MySQL locked_field_bean_rel Keys:

name	type	fields
idx_locked_field_bean_rel_beanid_del_bean_module	index	bean_id,deleted,bean_module
idx_locked_field_bean_rel_del_bean_module_beanid	index	bean_module,deleted
idx_locked_fields_rel_pdid_beanid	index	pd_id,bean_id
PRIMARY	primary	id

MySQL manufacturers Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
list_order	int
status	varchar	100
sync_key	varchar	100

MySQL manufacturers Keys:

name	type	fields
idx_manufacturers_date_entered	index	date_entered
idx_manufacturers_date_modfied	index	date_modified
idx_manufacturers_del_d_e	index	deleted,date_entered,id
idx_manufacturers_del_d_m	index	deleted,date_modified,id
idx_manufacturers_id_del	index	id,deleted
idx_manufacturers_name_del	index	name,deleted
idx_manufacturers_skey	unique	sync_key
PRIMARY	primary	id

MySQL meetings Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
location	varchar	50
password	varchar	50
join_url	varchar	600
host_url	varchar	600
displayed_url	varchar	400
creator	varchar	50
external_id	varchar	50
duration_hours	int
duration_minutes	int
date_start	datetime
date_end	datetime
parent_type	varchar	100
status	varchar	100	Planned
type	varchar	255	Sugar
parent_id	char	36
reminder_time	int		-1
email_reminder_time	int		-1
email_reminder_sent	tinyint
outlook_id	varchar	255
sequence	int
repeat_type	varchar	36
repeat_interval	int		1
repeat_dow	varchar	7
repeat_until	date
repeat_count	int
repeat_selector	varchar	36
repeat_days	varchar	128
repeat_ordinal	varchar	36
repeat_unit	varchar	36
repeat_parent_id	char	36
recurrence_id	datetime
recurring_source	varchar	36
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
internal_notes	text
dri_workflow_id	char	36
dri_subworkflow_id	char	36
dri_subworkflow_template_id	char	36
dri_workflow_template_id	char	36
dri_workflow_task_template_id	char	36
dri_workflow_sort_order	varchar	255	1
cj_actual_sort_order	varchar	255
customer_journey_score	int
cj_momentum_points	int
cj_momentum_score	int
cj_allow_activity_by	text
customer_journey_progress	float
cj_momentum_ratio	float
customer_journey_points	int		10
cj_parent_activity_type	varchar	255
customer_journey_blocked_by	text
cj_blocked_by_stages	text
is_cj_parent_activity	tinyint
is_customer_journey_activity	tinyint
cj_momentum_start_date	datetime
cj_momentum_end_date	datetime
cj_url	varchar	255
cj_parent_activity_id	char	36
start_next_journey_id	char	36

MySQL meetings Keys:

name	type	fields
idx_del_wf_tpl_sub_subtpl_meeting_name	index	deleted,dri_workflow_id,dri_workflow_template_id,dri_subworkflow_id,dri_subworkflow_template_id,dri_workflow_task_template_id,name
idx_del_wf_tpl_sub_subtpl_meeting_status	index	deleted,dri_workflow_id,dri_workflow_template_id,dri_subworkflow_id,dri_subworkflow_template_id,dri_workflow_task_template_id,status
idx_meet_date_start_end_del	index	date_start,date_end,deleted
idx_meet_date_start_reminder	index	date_start,reminder_time
idx_meet_par_del	index	parent_id,parent_type,deleted
idx_meet_repeat_parent_id	index	repeat_parent_id,deleted
idx_meet_stat_del	index	assigned_user_id,status,deleted
idx_meeting_cj_activity_tpl_id	index	dri_workflow_task_template_id
idx_meeting_cj_journey_tpl_id	index	dri_workflow_template_id
idx_meeting_cj_parent_activity	index	deleted,cj_parent_activity_id,cj_parent_activity_type
idx_meeting_cj_stage_id	index	dri_subworkflow_id
idx_meeting_cj_stage_tpl_id	index	dri_subworkflow_template_id
idx_meetings_acl_tmst_id	index	acl_team_set_id,deleted
idx_meetings_assigned_del	index	assigned_user_id,deleted
idx_meetings_date_entered	index	date_entered
idx_meetings_date_modfied	index	date_modified
idx_meetings_del_d_e	index	deleted,date_entered,id
idx_meetings_del_d_m	index	deleted,date_modified,id
idx_meetings_id_del	index	id,deleted
idx_meetings_name_del	index	name,deleted
idx_meetings_skey	unique	sync_key
idx_meetings_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL meetings_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL meetings_audit Keys:

name	type	fields
idx_meetings_audit_after_value	index	after_value_string
idx_meetings_audit_event_id	index	event_id
idx_meetings_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL meetings_contacts Definitions:

name	type	len	default
id	char	36
meeting_id	char	36
contact_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL meetings_contacts Keys:

name	type	fields
idx_con_mtg_con	index	contact_id
idx_meeting_contact	index	meeting_id,contact_id
PRIMARY	primary	id

MySQL meetings_leads Definitions:

name	type	len	default
id	char	36
meeting_id	char	36
lead_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL meetings_leads Keys:

name	type	fields
idx_lead_meeting_lead	index	lead_id
idx_meeting_lead	index	meeting_id,lead_id
PRIMARY	primary	id

MySQL meetings_users Definitions:

name	type	len	default
id	char	36
meeting_id	char	36
user_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL meetings_users Keys:

name	type	fields
idx_meeting_users_del	index	meeting_id,user_id,deleted
idx_usr_mtg_usr	index	user_id
PRIMARY	primary	id

MySQL messages Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
date_start	datetime
date_end	datetime
parent_type	varchar	255
parent_id	char	36
contact_id	char	36
status	varchar	50
direction	varchar	50
channel_type	varchar	50
conversation_link	varchar	512
conversation	longtext
aws_contact_id	char	36
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
aws_comprehend_data	text
sentiment	varchar	36

MySQL messages Keys:

name	type	fields
idx_aws_messages_contact_id	index	aws_contact_id,deleted
idx_messages_acl_tmst_id	index	acl_team_set_id,deleted
idx_messages_assigned_del	index	assigned_user_id,deleted
idx_messages_del_d_e	index	deleted,date_entered,id
idx_messages_del_d_m	index	deleted,date_modified,id
idx_messages_id_del	index	id,deleted
idx_messages_name_del	index	name,deleted
idx_messages_skey	unique	sync_key
idx_messages_tmst_id	index	team_set_id,deleted
idx_parent_message	index	parent_id,parent_type
PRIMARY	primary	id

MySQL messages_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL messages_audit Keys:

name	type	fields
idx_messages_audit_after_value	index	after_value_string
idx_messages_audit_event_id	index	event_id
idx_messages_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL messages_contacts Definitions:

name	type	len	default
id	char	36
message_id	char	36
contact_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL messages_contacts Keys:

name	type	fields
idx_contact_message_contact	index	contact_id
idx_message_contact	index	message_id,contact_id
PRIMARY	primary	id

MySQL messages_leads Definitions:

name	type	len	default
id	char	36
message_id	char	36
lead_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL messages_leads Keys:

name	type	fields
idx_lead_message_lead	index	lead_id
idx_message_lead	index	message_id,lead_id
PRIMARY	primary	id

MySQL messages_users Definitions:

name	type	len	default
id	char	36
message_id	char	36
user_id	char	36
required	varchar	1	1
accept_status	varchar	25	none
date_modified	datetime
deleted	tinyint

MySQL messages_users Keys:

name	type	fields
idx_message_user_del	index	message_id,user_id,deleted
idx_user_message_user	index	user_id
PRIMARY	primary	id

MySQL metadata_cache Definitions:

name	type	len
id	char	36
type	varchar	255
data	longblob
date_modified	datetime
deleted	tinyint

MySQL metadata_cache Keys:

name	type	fields
idx_type_datemodified	index	type,date_modified
PRIMARY	primary	id

MySQL metrics Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
metric_module	varchar	100
metric_context	varchar	100
status	varchar	255
labels	text
viewdefs	text
filter_def	text
order_by_primary	varchar	255
order_by_secondary	varchar	255
order_by_primary_direction	varchar	255
order_by_secondary_direction	varchar	255
freeze_first_column	tinyint	1
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL metrics Keys:

name	type	fields
idx_metrics_acl_tmst_id	index	acl_team_set_id,deleted
idx_metrics_assigned_del	index	assigned_user_id,deleted
idx_metrics_del_d_e	index	deleted,date_entered,id
idx_metrics_del_d_m	index	deleted,date_modified,id
idx_metrics_id_del	index	id,deleted
idx_metrics_name_del	index	name,deleted
idx_metrics_skey	unique	sync_key
idx_metrics_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id
user_module_context	index	assigned_user_id,metric_module,metric_context

MySQL metrics_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL metrics_audit Keys:

name	type	fields
idx_metrics_audit_after_value	index	after_value_string
idx_metrics_audit_event_id	index	event_id
idx_metrics_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL mobile_devices Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
device_id	varchar	256
device_platform	varchar	32
sync_key	varchar	100
assigned_user_id	char	36

MySQL mobile_devices Keys:

name	type	fields
idx_assigned_device_id	index	assigned_user_id,device_id,device_platform,deleted
idx_mobile_devices_assigned_del	index	assigned_user_id,deleted
idx_mobile_devices_del_d_e	index	deleted,date_entered,id
idx_mobile_devices_del_d_m	index	deleted,date_modified,id
idx_mobile_devices_id_del	index	id,deleted
idx_mobile_devices_name_del	index	name,deleted
idx_mobile_devices_skey	unique	sync_key
PRIMARY	primary	id

MySQL notes Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
file_mime_type	varchar	100
file_ext	varchar	100
file_source	varchar	32
file_size	int
filename	varchar	255
upload_id	char	36
email_type	varchar	255
email_id	char	36
parent_type	varchar	255
parent_id	char	36
contact_id	char	36
portal_flag	tinyint
embed_flag	tinyint
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
entry_source	varchar	255	internal
note_parent_id	char	36
attachment_flag	tinyint
sync_key	varchar	100
external_id	char	36
source_id	varchar	255
source_type	varchar	255
source_meta	text

MySQL notes Keys:

name	type	fields
idx_note_contact	index	contact_id
idx_note_email	index	email_id,email_type
idx_note_email_type	index	email_type
idx_note_external_user	index	external_id
idx_note_name	index	deleted,name,date_modified
idx_note_parent_id	index	note_parent_id
idx_note_upload_id	index	upload_id
idx_notes_acl_tmst_id	index	acl_team_set_id,deleted
idx_notes_assigned_del	index	assigned_user_id,deleted
idx_notes_date_entered	index	date_entered
idx_notes_date_modfied	index	date_modified
idx_notes_del_d_e	index	deleted,date_entered,id
idx_notes_del_d_m	index	deleted,date_modified,id
idx_notes_id_del	index	id,deleted
idx_notes_name_del	index	name,deleted
idx_notes_parent	index	parent_id,parent_type
idx_notes_skey	unique	sync_key
idx_notes_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL notes_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL notes_audit Keys:

name	type	fields
idx_notes_audit_after_value	index	after_value_string
idx_notes_audit_event_id	index	event_id
idx_notes_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL notes_cstm Definitions:

name	type	len	default	required
id_c	char	36
pk_tiponota_c	varchar	100	NI
pk_tiponota_hl_c	varchar	100
pk_classe_nota_c	varchar	100	AUTO
pk_numero_c	int		1	true

MySQL notes_cstm Keys:

name	type	fields
pk_numero_c	unique	pk_numero_c
PRIMARY	primary	id_c

MySQL notifications Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
is_read	tinyint
severity	varchar	15
parent_type	varchar	100
parent_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL notifications Keys:

name	type	fields
idx_notifications_assigned_del	index	assigned_user_id,deleted
idx_notifications_date_entered	index	date_entered
idx_notifications_date_modfied	index	date_modified
idx_notifications_del_d_e	index	deleted,date_entered,id
idx_notifications_del_d_m	index	deleted,date_modified,id
idx_notifications_id_del	index	id,deleted
idx_notifications_my_unread_items	index	assigned_user_id,is_read,deleted
idx_notifications_name_del	index	name,deleted
idx_notifications_skey	unique	sync_key
PRIMARY	primary	id

MySQL oauth_consumer Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
c_key	varchar	255
c_secret	varchar	255
oauth_type	varchar	50	oauth1
client_type	varchar	50	user
assigned_user_id	char	36
sync_key	varchar	100

MySQL oauth_consumer Keys:

name	type	fields
ckey	unique	c_key
idx_oauth_consumer_assigned_del	index	assigned_user_id,deleted
idx_oauth_consumer_date_entered	index	date_entered
idx_oauth_consumer_date_modfied	index	date_modified
idx_oauth_consumer_del_d_e	index	deleted,date_entered,id
idx_oauth_consumer_del_d_m	index	deleted,date_modified,id
idx_oauth_consumer_id_del	index	id,deleted
idx_oauth_consumer_name_del	index	name,deleted
idx_oauth_consumer_skey	unique	sync_key
idx_oauthkey_client_type	index	client_type
PRIMARY	primary	id

MySQL oauth_nonce Definitions:

name	type	len
conskey	varchar	32
nonce	varchar	32
nonce_ts	bigint

MySQL oauth_nonce Keys:

name	type	fields
oauth_nonce_keyts	index	conskey,nonce_ts
PRIMARY	primary	conskey,nonce

MySQL oauth_tokens Definitions:

name	type	len	required
id	char	36
secret	varchar	32
tstate	varchar	1
consumer	char	36	true
token_ts	bigint
expire_ts	bigint	-1
verify	varchar	32
download_token	varchar	36
platform	varchar	255	base
deleted	tinyint
callback_url	varchar	255
contact_id	char	36
assigned_user_id	char	36

MySQL oauth_tokens Keys:

name	type	fields
constoken_key	index	consumer
idx_oauth_tstate_expire_ts	index	tstate,expire_ts
idx_platform_assigned_tstate	index	platform,assigned_user_id,tstate
oauth_state_ts	index	tstate,token_ts
PRIMARY	primary	id,deleted

MySQL opportunities Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
opportunity_type	varchar	255
campaign_id	char	36
lead_source	varchar	100
amount	decimal	26,6
amount_usdollar	decimal	26,6
date_closed	date
date_closed_timestamp	bigint
next_step	varchar	100
sales_stage	varchar	255	Da Gestire
sales_status	varchar	255	New
probability	double
best_case	decimal	26,6
worst_case	decimal	26,6
commit_stage	varchar	50
mkto_sync	tinyint
mkto_id	int
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
total_revenue_line_items	int
closed_revenue_line_items	int
included_revenue_line_items	int
acl_team_set_id	char	36
renewal_parent_id	char	36
renewal	tinyint
service_start_date	date
service_open_revenue_line_items	int
service_duration_value	int
service_duration_unit	varchar	50
service_open_flex_duration_rlis	int
sync_key	varchar	100
forecasted_likely	decimal	26,6
closed_won_revenue_line_items	int
ai_opp_conv_score_enum	varchar	255
is_escalated	tinyint
denorm_account_name	varchar	150
lost	decimal	26,6
ai_opp_conv_score_absolute	decimal	10,0
ai_opp_conv_bin_accuracy	decimal	10,0
ai_opp_conv_multiplier	decimal	10,0
geocode_status	varchar	255
ai_opp_close_week_scores	longtext
dri_workflow_template_id	char	36

MySQL opportunities Keys:

name	type	fields
idx_opp_del_renewal_pid	index	deleted,renewal_parent_id,id
idx_opp_name	index	deleted,name,date_modified
idx_opportunities_acl_tmst_id	index	acl_team_set_id,deleted
idx_opportunities_assigned_del	index	assigned_user_id,deleted
idx_opportunities_cjtpl_id	index	dri_workflow_template_id
idx_opportunities_date_entered	index	date_entered
idx_opportunities_date_modfied	index	date_modified
idx_opportunities_del_d_e	index	deleted,date_entered,id
idx_opportunities_del_d_m	index	deleted,date_modified,id
idx_opportunities_id_del	index	id,deleted
idx_opportunities_name_del	index	name,deleted
idx_opportunities_skey	unique	sync_key
idx_opportunities_tmst_id	index	team_set_id,deleted
idx_opportunity_next_step	index	deleted,next_step,date_modified
PRIMARY	primary	id

MySQL opportunities_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL opportunities_audit Keys:

name	type	fields
idx_opportunities_audit_after_value	index	after_value_string
idx_opportunities_audit_event_id	index	event_id
idx_opportunities_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL opportunities_contacts Definitions:

name	type	len
id	char	36
contact_id	char	36
opportunity_id	char	36
contact_role	varchar	50
date_modified	datetime
deleted	tinyint

MySQL opportunities_contacts Keys:

name	type	fields
idx_con_opp_con	index	contact_id
idx_del_opp_con	index	deleted,opportunity_id,contact_id
idx_opportunities_contacts	index	opportunity_id,contact_id
PRIMARY	primary	id

MySQL opportunities_cstm Definitions:

name	type	len	default
id_c	char	36
linea_c	varchar	100
stato_opp_c	varchar	100
check_wf_compiti_c	tinyint
account_id_c	char	36
tipo_richiesta_c	varchar	100
check_primo_contatto_c	tinyint
test_c	varchar	255
in_gestione_c	varchar	100	diretta
causa_opp_c	varchar	100	10
prodotto_venduto_c	varchar	255
in_gestione_colored_c	varchar	100	diretta
perc_custom_c	int
importo_vinta_c	decimal	26,6	0.000000
descrizione_richiesta_c	text
flag_in_gestione_c	tinyint
flag_gestito_da_c	tinyint
flag_assegnatario_c	tinyint
gestione_testo_c	varchar	255
chk_assforz_c	tinyint
pk_teamtext_c	varchar	255
pk_teamtext2_c	varchar	80
pk_tipocreazione_c	varchar	100	M
pk_nomeoppo_c	varchar	255
regione_dd_c	varchar	100
nazione_dd_c	varchar	100
fonte_lead_c	varchar	100

MySQL opportunities_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL outbound_email Definitions:

name	type	len	default
id	char	36
name	varchar	255
type	varchar	15	user
user_id	char	36	true
email_address_id	char	36
reply_to_name	varchar	255
reply_to_email_address_id	char	36
mail_sendtype	varchar	8	SMTP
mail_smtptype	varchar	20	other
mail_smtpserver	varchar	100
mail_smtpport	int		465
mail_smtpuser	varchar	100
mail_smtppass	varchar	255
mail_smtpauth_req	tinyint
mail_smtpssl	int		1
deleted	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
eapm_id	char	36
authorized_account	varchar	255
mail_authtype	varchar	10
preferred_sending_account	tinyint

MySQL outbound_email Keys:

name	type	fields
idx_outbound_email_acl_tmst_id	index	acl_team_set_id,deleted
idx_outbound_email_tmst_id	index	team_set_id,deleted
oe_type_idx	index	type
PRIMARY	primary	id

MySQL pdfmanager Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
base_module	varchar	100
published	varchar	100	yes
field	varchar	100
body_html	text
template_name	varchar	255
author	varchar	255	SugarCRM
title	varchar	255
subject	varchar	255
keywords	varchar	255
header_title	varchar	255
header_text	varchar	255
header_logo	varchar	255
footer_text	varchar	255
team_id	char	36
team_set_id	char	36
assigned_user_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL pdfmanager Keys:

name	type	fields
idx_pdfmanager_acl_tmst_id	index	acl_team_set_id,deleted
idx_pdfmanager_assigned_del	index	assigned_user_id,deleted
idx_pdfmanager_base_module	index	base_module
idx_pdfmanager_date_entered	index	date_entered
idx_pdfmanager_date_modfied	index	date_modified
idx_pdfmanager_del_d_e	index	deleted,date_entered,id
idx_pdfmanager_del_d_m	index	deleted,date_modified,id
idx_pdfmanager_id_del	index	id,deleted
idx_pdfmanager_name_del	index	name,deleted
idx_pdfmanager_published	index	published
idx_pdfmanager_skey	unique	sync_key
idx_pdfmanager_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL pmse_bpm_activity_definition Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
pro_id	varchar	36
act_type	varchar	32	TASK
act_duration	int
act_duration_unit	varchar	32	DAYS
act_send_notification	int
act_assignment_method	varchar	32	balanced
act_assign_team	varchar	40
act_assign_user	varchar	40
act_value_based_assignment	varchar	255
act_reassign	int
act_reassign_team	varchar	40
act_adhoc	int
act_adhoc_behavior	varchar	40
act_adhoc_team	varchar	40
act_response_buttons	varchar	40
act_last_user_assigned	varchar	40
act_field_module	varchar	100
act_fields	text
act_params	text
act_readonly_fields	text
act_expected_time	text
act_required_fields	text
act_related_modules	text
act_service_url	text
act_service_params	text
act_service_method	text
act_update_record_owner	int
execution_mode	varchar	10	DEFAULT
assigned_user_id	char	36
act_email_process_user	tinyint
act_email_template_id	text
act_set_by_avl	tinyint
act_avl_count	int
act_avl_type	varchar	40
act_avl_before_type	varchar	40
act_reserve_user	varchar	36
sync_key	varchar	100

MySQL pmse_bpm_activity_definition Keys:

name	type	fields
idx_pmse_bpm_activity_definition_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_activity_definition_date_entered	index	date_entered
idx_pmse_bpm_activity_definition_date_modfied	index	date_modified
idx_pmse_bpm_activity_definition_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_activity_definition_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_activity_definition_id_del	index	id,deleted
idx_pmse_bpm_activity_definition_name_del	index	name,deleted
idx_pmse_bpm_activity_definition_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_activity_step Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
pro_id	varchar	36
act_step_type	varchar	30	START
act_criteria	text
act_step_form	varchar	255
act_step_script	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_activity_step Keys:

name	type	fields
idx_pmse_bpm_activity_step_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_activity_step_date_entered	index	date_entered
idx_pmse_bpm_activity_step_date_modfied	index	date_modified
idx_pmse_bpm_activity_step_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_activity_step_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_activity_step_id_del	index	id,deleted
idx_pmse_bpm_activity_step_name_del	index	name,deleted
idx_pmse_bpm_activity_step_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_activity_user Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
pro_id	varchar	36
act_user_type	varchar	32
act_user_id	varchar	40
act_group_id	varchar	40
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_activity_user Keys:

name	type	fields
idx_pmse_bpm_activity_user_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_activity_user_date_entered	index	date_entered
idx_pmse_bpm_activity_user_date_modfied	index	date_modified
idx_pmse_bpm_activity_user_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_activity_user_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_activity_user_id_del	index	id,deleted
idx_pmse_bpm_activity_user_name_del	index	name,deleted
idx_pmse_bpm_activity_user_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_config Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
cfg_status	varchar	20	ACTIVE
cfg_value	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_config Keys:

name	type	fields
idx_pmse_bpm_config_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_config_date_entered	index	date_entered
idx_pmse_bpm_config_date_modfied	index	date_modified
idx_pmse_bpm_config_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_config_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_config_id_del	index	id,deleted
idx_pmse_bpm_config_name_del	index	name,deleted
idx_pmse_bpm_config_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_dynamic_forms Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
dyn_uid	varchar	32
pro_id	varchar	36
prj_id	varchar	36
dyn_module	varchar	255
dyn_view_defs	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_dynamic_forms Keys:

name	type	fields
idx_pmse_bpm_dynamic_forms_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_dynamic_forms_date_entered	index	date_entered
idx_pmse_bpm_dynamic_forms_date_modfied	index	date_modified
idx_pmse_bpm_dynamic_forms_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_dynamic_forms_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_dynamic_forms_id_del	index	id,deleted
idx_pmse_bpm_dynamic_forms_name_del	index	name,deleted
idx_pmse_bpm_dynamic_forms_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_event_definition Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
prj_id	varchar	36
pro_id	varchar	36
evn_status	varchar	32	ACTIVE
evn_type	varchar	30	START
evn_module	varchar	128	Leads
evn_criteria	text
evn_params	text
evn_script	text
execution_mode	varchar	10	DEFAULT
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_event_definition Keys:

name	type	fields
idx_pmse_bpm_event_definition_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_event_definition_date_entered	index	date_entered
idx_pmse_bpm_event_definition_date_modfied	index	date_modified
idx_pmse_bpm_event_definition_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_event_definition_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_event_definition_id_del	index	id,deleted
idx_pmse_bpm_event_definition_name_del	index	name,deleted
idx_pmse_bpm_event_definition_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_flow Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
cas_id	int
cas_index	int
pro_id	varchar	36
cas_previous	int
cas_reassign_level	int
bpmn_id	varchar	36
bpmn_type	varchar	32
cas_assignment_method	varchar	32
cas_user_id	varchar	40
cas_thread	int
cas_flow_status	varchar	32	OPEN
cas_sugar_module	varchar	128
cas_sugar_object_id	varchar	40
cas_sugar_action	varchar	40	DetailView
cas_adhoc_type	varchar	40
cas_adhoc_parent_id	varchar	40
cas_adhoc_actions	varchar	255
cas_task_start_date	datetime
cas_delegate_date	datetime
cas_start_date	datetime
cas_finish_date	datetime
cas_due_date	datetime
cas_queue_duration	int
cas_duration	int
cas_delay_duration	int
cas_started	int
cas_finished	int
cas_delayed	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_flow Keys:

name	type	fields
idx_pmse_bpm_flow_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_flow_bpmn_type_flow_status_due_date_del	index	bpmn_type,cas_flow_status,cas_due_date,deleted
idx_pmse_bpm_flow_cas_flow_status	index	bpmn_id,cas_flow_status
idx_pmse_bpm_flow_cas_flow_status_cas_obj_id_del	index	cas_flow_status,cas_sugar_object_id,deleted
idx_pmse_bpm_flow_cas_id_flow_status	index	cas_id,cas_flow_status
idx_pmse_bpm_flow_date_entered	index	date_entered
idx_pmse_bpm_flow_date_modfied	index	date_modified
idx_pmse_bpm_flow_del_cas_id	index	cas_id,deleted
idx_pmse_bpm_flow_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_flow_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_flow_id_del	index	id,deleted
idx_pmse_bpm_flow_name_del	index	name,deleted
idx_pmse_bpm_flow_parent_and_cas_id	index	cas_sugar_object_id,cas_sugar_module,cas_index
idx_pmse_bpm_flow_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_form_action Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
cas_id	int
act_id	varchar	36
pro_id	varchar	36
user_id	varchar	36
frm_index	int
frm_last	int
frm_action	varchar	255	ROUTE
frm_user_id	varchar	255
frm_user_name	varchar	255
frm_date	datetime
frm_comment	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_form_action Keys:

name	type	fields
idx_pmse_bpm_form_action_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_form_action_cas_id_frm_last	index	cas_id,frm_last,deleted
idx_pmse_bpm_form_action_date_entered	index	date_entered
idx_pmse_bpm_form_action_date_modfied	index	date_modified
idx_pmse_bpm_form_action_del_cas_id	index	cas_id,deleted
idx_pmse_bpm_form_action_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_form_action_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_form_action_id_del	index	id,deleted
idx_pmse_bpm_form_action_name_del	index	name,deleted
idx_pmse_bpm_form_action_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_gateway_definition Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
prj_id	varchar	36
pro_id	varchar	36
execution_mode	varchar	10	DEFAULT
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_gateway_definition Keys:

name	type	fields
idx_pmse_bpm_gateway_definition_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_gateway_definition_date_entered	index	date_entered
idx_pmse_bpm_gateway_definition_date_modfied	index	date_modified
idx_pmse_bpm_gateway_definition_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_gateway_definition_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_gateway_definition_id_del	index	id,deleted
idx_pmse_bpm_gateway_definition_name_del	index	name,deleted
idx_pmse_bpm_gateway_definition_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_group Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
grp_uid	varchar	36
grp_parent_group	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_group Keys:

name	type	fields
idx_pmse_bpm_group_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_group_date_entered	index	date_entered
idx_pmse_bpm_group_date_modfied	index	date_modified
idx_pmse_bpm_group_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_group_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_group_id_del	index	id,deleted
idx_pmse_bpm_group_name_del	index	name,deleted
idx_pmse_bpm_group_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_group_user Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
user_id	varchar	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_group_user Keys:

name	type	fields
idx_pmse_bpm_group_user_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_group_user_date_entered	index	date_entered
idx_pmse_bpm_group_user_date_modfied	index	date_modified
idx_pmse_bpm_group_user_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_group_user_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_group_user_id_del	index	id,deleted
idx_pmse_bpm_group_user_name_del	index	name,deleted
idx_pmse_bpm_group_user_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_notes Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
cas_id	varchar	36
cas_index	int
not_user_id	varchar	40
not_user_recipient_id	varchar	40
not_type	varchar	32	GENERAL
not_date	datetime
not_status	varchar	10	ACTIVE
not_availability	varchar	32
not_content	text
not_recipients	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_notes Keys:

name	type	fields
idx_pmse_bpm_notes_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_notes_date_entered	index	date_entered
idx_pmse_bpm_notes_date_modfied	index	date_modified
idx_pmse_bpm_notes_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_notes_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_notes_id_del	index	id,deleted
idx_pmse_bpm_notes_name_del	index	name,deleted
idx_pmse_bpm_notes_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_process_definition Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
prj_id	varchar	36
pro_module	varchar	255
pro_status	varchar	255
pro_locked_variables	text
pro_terminate_variables	text
execution_mode	varchar	10	SYNC
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_process_definition Keys:

name	type	fields
idx_pd_prj_id	index	prj_id
idx_pd_pro_status	index	pro_status
idx_pmse_bpm_process_definition_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_process_definition_date_entered	index	date_entered
idx_pmse_bpm_process_definition_date_modfied	index	date_modified
idx_pmse_bpm_process_definition_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_process_definition_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_process_definition_id_del	index	id,deleted
idx_pmse_bpm_process_definition_name_del	index	name,deleted
idx_pmse_bpm_process_definition_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpm_related_dependency Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
evn_id	varchar	36
evn_uid	varchar	36
evn_marker	varchar	36
evn_is_interrupting	varchar	36
evn_attached_to	varchar	36
evn_cancel_activity	varchar	36
evn_activity_ref	varchar	36
evn_wait_for_completion	varchar	36
evn_error_name	varchar	36
evn_error_code	varchar	36
evn_escalation_name	varchar	36
evn_escalation_code	varchar	36
evn_condition	varchar	36
evn_message	varchar	36
evn_operation_name	varchar	36
evn_operation_implementation	varchar	36
evn_time_date	varchar	36
evn_time_cycle	varchar	36
evn_time_duration	varchar	36
evn_behavior	varchar	36
evn_status	varchar	36
evn_type	varchar	36
evn_module	varchar	36
evn_criteria	text
evn_params	text
evn_script	text
prj_id	varchar	36
pro_id	varchar	36
pro_module	varchar	36
pro_status	varchar	36
pro_locked_variables	text
pro_terminate_variables	text
rel_element_id	varchar	40
rel_element_type	varchar	32
rel_process_module	varchar	32
rel_element_module	varchar	32
rel_element_relationship	varchar	255
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_related_dependency Keys:

name	type	fields
idx_pmse_bpm_related_dependency_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_related_dependency_date_entered	index	date_entered
idx_pmse_bpm_related_dependency_date_modfied	index	date_modified
idx_pmse_bpm_related_dependency_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_related_dependency_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_related_dependency_id_del	index	id,deleted
idx_pmse_bpm_related_dependency_name_del	index	name,deleted
idx_pmse_bpm_related_dependency_skey	unique	sync_key
idx_prostatus_evntype_evnmodule_evn_behavior	index	pro_status,evn_type,evn_module,evn_behavior
PRIMARY	primary	id

MySQL pmse_bpm_thread Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
cas_id	int
cas_thread_index	int
cas_thread_parent	int
cas_thread_status	varchar	32	OPEN
cas_flow_index	int
cas_thread_tokens	int
cas_thread_passes	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpm_thread Keys:

name	type	fields
idx_pmse_bpm_thread_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpm_thread_date_entered	index	date_entered
idx_pmse_bpm_thread_date_modfied	index	date_modified
idx_pmse_bpm_thread_del_cas_id	index	cas_id,deleted
idx_pmse_bpm_thread_del_d_e	index	deleted,date_entered,id
idx_pmse_bpm_thread_del_d_m	index	deleted,date_modified,id
idx_pmse_bpm_thread_id_del	index	id,deleted
idx_pmse_bpm_thread_name_del	index	name,deleted
idx_pmse_bpm_thread_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_activity Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
act_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
act_type	varchar	30	TASK
act_is_for_compensation	int
act_start_quantity	int		1
act_completion_quantity	int		1
act_task_type	varchar	20	EMPTY
act_implementation	text
act_instantiate	int
act_script_type	varchar	255
act_script	text
act_loop_type	varchar	20	NONE
act_test_before	int
act_loop_maximum	int
act_loop_condition	varchar	100
act_loop_cardinality	int
act_loop_behavior	varchar	20	NONE
act_is_adhoc	int
act_is_collapsed	int		1
act_completion_condition	varchar	255
act_ordering	varchar	20	PARALLEL
act_cancel_remaining_instances	int		1
act_protocol	varchar	255
act_method	varchar	255
act_is_global	int
act_referer	int
act_default_flow	int
act_master_diagram	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_activity Keys:

name	type	fields
idx_pmse_bpmn_activity_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_activity_date_entered	index	date_entered
idx_pmse_bpmn_activity_date_modfied	index	date_modified
idx_pmse_bpmn_activity_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_activity_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_activity_id_del	index	id,deleted
idx_pmse_bpmn_activity_name_del	index	name,deleted
idx_pmse_bpmn_activity_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_artifact Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
art_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
art_type	varchar	15
art_category_ref	varchar	32
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_artifact Keys:

name	type	fields
idx_pmse_bpmn_artifact_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_artifact_date_entered	index	date_entered
idx_pmse_bpmn_artifact_date_modfied	index	date_modified
idx_pmse_bpmn_artifact_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_artifact_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_artifact_id_del	index	id,deleted
idx_pmse_bpmn_artifact_name_del	index	name,deleted
idx_pmse_bpmn_artifact_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_bound Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
bou_uid	varchar	36
prj_id	varchar	36
dia_id	varchar	36
element_id	varchar	36
bou_element	varchar	36
bou_element_type	varchar	32
bou_x	int
bou_y	int
bou_width	int
bou_height	int
bou_rel_position	int
bou_size_identical	int
bou_container	varchar	30
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_bound Keys:

name	type	fields
idx_pmse_bpmn_bound_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_bound_date_entered	index	date_entered
idx_pmse_bpmn_bound_date_modfied	index	date_modified
idx_pmse_bpmn_bound_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_bound_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_bound_id_del	index	id,deleted
idx_pmse_bpmn_bound_name_del	index	name,deleted
idx_pmse_bpmn_bound_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_data Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
dat_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
dat_type	varchar	20
dat_is_collection	int
dat_item_kind	varchar	20	INFORMATION
dat_capacity	int
dat_is_unlimited	int
dat_state	varchar	255
dat_is_global	int
dat_object_ref	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_data Keys:

name	type	fields
idx_pmse_bpmn_data_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_data_date_entered	index	date_entered
idx_pmse_bpmn_data_date_modfied	index	date_modified
idx_pmse_bpmn_data_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_data_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_data_id_del	index	id,deleted
idx_pmse_bpmn_data_name_del	index	name,deleted
idx_pmse_bpmn_data_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_diagram Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
dia_uid	varchar	36
prj_id	varchar	36
dia_is_closable	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_diagram Keys:

name	type	fields
idx_pmse_bpmn_diagram_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_diagram_date_entered	index	date_entered
idx_pmse_bpmn_diagram_date_modfied	index	date_modified
idx_pmse_bpmn_diagram_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_diagram_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_diagram_id_del	index	id,deleted
idx_pmse_bpmn_diagram_name_del	index	name,deleted
idx_pmse_bpmn_diagram_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_documentation Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
doc_uid	varchar	36
prj_id	varchar	36
doc_element	varchar	36
doc_element_type	varchar	45
doc_documentation	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_documentation Keys:

name	type	fields
idx_pmse_bpmn_documentation_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_documentation_date_entered	index	date_entered
idx_pmse_bpmn_documentation_date_modfied	index	date_modified
idx_pmse_bpmn_documentation_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_documentation_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_documentation_id_del	index	id,deleted
idx_pmse_bpmn_documentation_name_del	index	name,deleted
idx_pmse_bpmn_documentation_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_event Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
evn_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
evn_type	varchar	30
evn_marker	varchar	30	EMPTY
evn_is_interrupting	int		1
evn_attached_to	int
evn_cancel_activity	int
evn_activity_ref	int
evn_wait_for_completion	int		1
evn_error_name	varchar	255
evn_error_code	varchar	255
evn_escalation_name	varchar	255
evn_escalation_code	varchar	255
evn_condition	varchar	255
evn_message	text
evn_operation_name	varchar	255
evn_operation_implementation	varchar	255
evn_time_date	varchar	255
evn_time_cycle	varchar	255
evn_time_duration	varchar	255
evn_behavior	varchar	20	CATCH
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_event Keys:

name	type	fields
idx_pmse_bpmn_event_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_event_date_entered	index	date_entered
idx_pmse_bpmn_event_date_modfied	index	date_modified
idx_pmse_bpmn_event_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_event_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_event_id_del	index	id,deleted
idx_pmse_bpmn_event_name_del	index	name,deleted
idx_pmse_bpmn_event_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_extension Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
ext_uid	varchar	36
prj_id	varchar	36
ext_element	varchar	36
ext_element_type	varchar	45
ext_extension	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_extension Keys:

name	type	fields
idx_pmse_bpmn_extension_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_extension_date_entered	index	date_entered
idx_pmse_bpmn_extension_date_modfied	index	date_modified
idx_pmse_bpmn_extension_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_extension_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_extension_id_del	index	id,deleted
idx_pmse_bpmn_extension_name_del	index	name,deleted
idx_pmse_bpmn_extension_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_flow Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
flo_uid	varchar	36
prj_id	varchar	36
dia_id	varchar	36
flo_type	varchar	20
flo_element_origin	varchar	36
flo_element_origin_type	varchar	32
flo_element_origin_port	int
flo_element_dest	varchar	36
flo_element_dest_type	varchar	32
flo_element_dest_port	int
flo_is_inmediate	int
flo_condition	text
flo_eval_priority	int
flo_x1	int
flo_y1	int
flo_x2	int
flo_y2	int
flo_state	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_flow Keys:

name	type	fields
idx_pmse_bpmn_flow_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_flow_date_entered	index	date_entered
idx_pmse_bpmn_flow_date_modfied	index	date_modified
idx_pmse_bpmn_flow_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_flow_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_flow_id_del	index	id,deleted
idx_pmse_bpmn_flow_name_del	index	name,deleted
idx_pmse_bpmn_flow_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_gateway Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
gat_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
gat_type	varchar	30
gat_direction	varchar	30	UNSPECIFIED
gat_instantiate	int
gat_event_gateway_type	varchar	20	NONE
gat_activation_count	int
gat_waiting_for_start	int		1
gat_default_flow	varchar	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_gateway Keys:

name	type	fields
idx_pmse_bpmn_gateway_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_gateway_date_entered	index	date_entered
idx_pmse_bpmn_gateway_date_modfied	index	date_modified
idx_pmse_bpmn_gateway_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_gateway_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_gateway_id_del	index	id,deleted
idx_pmse_bpmn_gateway_name_del	index	name,deleted
idx_pmse_bpmn_gateway_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_lane Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
lan_uid	varchar	36
prj_id	varchar	36
lns_id	varchar	36
lan_child_laneset	varchar	36
lan_is_horizontal	int		1
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_lane Keys:

name	type	fields
idx_pmse_bpmn_lane_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_lane_date_entered	index	date_entered
idx_pmse_bpmn_lane_date_modfied	index	date_modified
idx_pmse_bpmn_lane_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_lane_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_lane_id_del	index	id,deleted
idx_pmse_bpmn_lane_name_del	index	name,deleted
idx_pmse_bpmn_lane_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_laneset Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
lns_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
lns_parent_lane	varchar	36
lns_is_horizontal	int		1
lns_state	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_laneset Keys:

name	type	fields
idx_pmse_bpmn_laneset_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_laneset_date_entered	index	date_entered
idx_pmse_bpmn_laneset_date_modfied	index	date_modified
idx_pmse_bpmn_laneset_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_laneset_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_laneset_id_del	index	id,deleted
idx_pmse_bpmn_laneset_name_del	index	name,deleted
idx_pmse_bpmn_laneset_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_participant Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
par_uid	varchar	36
prj_id	varchar	36
pro_id	varchar	36
lns_id	varchar	36
par_minimum	int
par_maximum	int		1
par_num_participants	int		1
par_is_horizontal	int		1
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_participant Keys:

name	type	fields
idx_pmse_bpmn_participant_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_participant_date_entered	index	date_entered
idx_pmse_bpmn_participant_date_modfied	index	date_modified
idx_pmse_bpmn_participant_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_participant_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_participant_id_del	index	id,deleted
idx_pmse_bpmn_participant_name_del	index	name,deleted
idx_pmse_bpmn_participant_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_bpmn_process Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
pro_uid	varchar	36
prj_id	varchar	36
dia_id	varchar	36
pro_type	varchar	10	NONE
pro_is_executable	int
pro_is_closed	int
pro_is_subprocess	int
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_bpmn_process Keys:

name	type	fields
idx_pmse_bpmn_process_assigned_del	index	assigned_user_id,deleted
idx_pmse_bpmn_process_date_entered	index	date_entered
idx_pmse_bpmn_process_date_modfied	index	date_modified
idx_pmse_bpmn_process_del_d_e	index	deleted,date_entered,id
idx_pmse_bpmn_process_del_d_m	index	deleted,date_modified,id
idx_pmse_bpmn_process_id_del	index	id,deleted
idx_pmse_bpmn_process_name_del	index	name,deleted
idx_pmse_bpmn_process_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_business_rules Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
rst_uid	varchar	36
rst_type	varchar	100	single
rst_definition	text
rst_editable	int
rst_source	varchar	255
rst_source_definition	longtext
rst_module	varchar	100
rst_filename	varchar	255
rst_create_date	datetime
rst_update_date	datetime
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_business_rules Keys:

name	type	fields
idx_pmse_business_rules_acl_tmst_id	index	acl_team_set_id,deleted
idx_pmse_business_rules_assigned_del	index	assigned_user_id,deleted
idx_pmse_business_rules_date_entered	index	date_entered
idx_pmse_business_rules_date_modfied	index	date_modified
idx_pmse_business_rules_del_d_e	index	deleted,date_entered,id
idx_pmse_business_rules_del_d_m	index	deleted,date_modified,id
idx_pmse_business_rules_id_del	index	id,deleted
idx_pmse_business_rules_name_del	index	name,deleted
idx_pmse_business_rules_skey	unique	sync_key
idx_pmse_business_rules_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL pmse_email_message Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
from_addr	varchar	255
from_name	varchar	255
to_addrs	text
cc_addrs	text
bcc_addrs	text
body	longtext
body_html	longtext
subject	varchar	255
flow_id	char	36
reply_to_addr	varchar	255
reply_to_name	varchar	255
outbound_email_id	char	36
sync_key	varchar	100
doc_merge_attach_id	char	36

MySQL pmse_email_message Keys:

name	type	fields
idx_pmse_email_message_date_entered	index	date_entered
idx_pmse_email_message_date_modfied	index	date_modified
idx_pmse_email_message_del_d_e	index	deleted,date_entered,id
idx_pmse_email_message_del_d_m	index	deleted,date_modified,id
idx_pmse_email_message_id_del	index	id,deleted
idx_pmse_email_message_name_del	index	name,deleted
idx_pmse_email_message_skey	unique	sync_key
PRIMARY	primary	id

MySQL pmse_emails_templates Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
from_name	varchar	255
from_address	varchar	255
subject	varchar	255
body	text
body_html	text
type	varchar	255
base_module	varchar	100
text_only	tinyint
published	varchar	3
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_emails_templates Keys:

name	type	fields
idx_pmse_emails_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_pmse_emails_templates_assigned_del	index	assigned_user_id,deleted
idx_pmse_emails_templates_date_entered	index	date_entered
idx_pmse_emails_templates_date_modfied	index	date_modified
idx_pmse_emails_templates_del_d_e	index	deleted,date_entered,id
idx_pmse_emails_templates_del_d_m	index	deleted,date_modified,id
idx_pmse_emails_templates_id_del	index	id,deleted
idx_pmse_emails_templates_name_del	index	name,deleted
idx_pmse_emails_templates_skey	unique	sync_key
idx_pmse_emails_templates_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL pmse_inbox Definitions:

name	type	len	auto_increment	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
cas_id	int		1	true
cas_parent	int
cas_status	varchar	32	IN PROGRESS
pro_id	varchar	36
cas_title	varchar	255
pro_title	varchar	255
cas_custom_status	varchar	32
cas_init_user	varchar	36
cas_create_date	datetime
cas_update_date	datetime
cas_finish_date	datetime
cas_pin	varchar	10	0000
cas_assigned_status	varchar	12	UNASSIGNED
cas_module	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL pmse_inbox Keys:

name	type	fields
idx_pmse_inbox_acl_tmst_id	index	acl_team_set_id,deleted
idx_pmse_inbox_assigned_del	index	assigned_user_id,deleted
idx_pmse_inbox_case_id	index	cas_id
idx_pmse_inbox_date_entered	index	date_entered
idx_pmse_inbox_date_modfied	index	date_modified
idx_pmse_inbox_del_d_e	index	deleted,date_entered,id
idx_pmse_inbox_del_d_m	index	deleted,date_modified,id
idx_pmse_inbox_id_del	index	id,deleted
idx_pmse_inbox_name_del	index	name,deleted
idx_pmse_inbox_skey	unique	sync_key
idx_pmse_inbox_tmst_id	index	team_set_id,deleted
idx_proid_status_del	index	pro_id,cas_status,deleted
PRIMARY	primary	id

MySQL pmse_project Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
prj_uid	varchar	36
prj_target_namespace	varchar	255
prj_expression_language	varchar	255
prj_type_language	varchar	255
prj_exporter	varchar	255
prj_exporter_version	varchar	255
prj_author	varchar	255
prj_author_version	varchar	255
prj_original_source	varchar	255
prj_status	varchar	10	INACTIVE
prj_module	varchar	100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
prj_run_order	int		1
sync_key	varchar	100

MySQL pmse_project Keys:

name	type	fields
idx_pmse_project_acl_tmst_id	index	acl_team_set_id,deleted
idx_pmse_project_assigned_del	index	assigned_user_id,deleted
idx_pmse_project_date_entered	index	date_entered
idx_pmse_project_date_modfied	index	date_modified
idx_pmse_project_del_d_e	index	deleted,date_entered,id
idx_pmse_project_del_d_m	index	deleted,date_modified,id
idx_pmse_project_id_del	index	id,deleted
idx_pmse_project_name_del	index	name,deleted
idx_pmse_project_skey	unique	sync_key
idx_pmse_project_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL product_bundle_note Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
bundle_id	char	36
note_id	char	36
note_index	int

MySQL product_bundle_note Keys:

name	type	fields
idx_pbn_bundle	index	bundle_id
idx_pbn_pb_nb	index	note_id,bundle_id
PRIMARY	primary	id

MySQL product_bundle_notes Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text

MySQL product_bundle_notes Keys:

name	type	fields
PRIMARY	primary	id

MySQL product_bundle_product Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
bundle_id	char	36
product_id	char	36
product_index	int

MySQL product_bundle_product Keys:

name	type	fields
idx_pbp_bq	index	product_id,bundle_id
idx_pbp_bundle	index	bundle_id
PRIMARY	primary	id

MySQL product_bundle_quote Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
bundle_id	char	36
quote_id	char	36
bundle_index	int

MySQL product_bundle_quote Keys:

name	type	fields
bundle_index_idx	index	bundle_index
idx_pbq_bq	index	quote_id,bundle_id
idx_pbq_bundle	index	bundle_id
PRIMARY	primary	id

MySQL product_bundles Definitions:

name	type	len	default
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	255
bundle_stage	varchar	255
description	text
taxrate_id	char	36
tax	decimal	26,6
tax_usdollar	decimal	26,6
total	decimal	26,6
total_usdollar	decimal	26,6
subtotal_usdollar	decimal	26,6
shipping_usdollar	decimal	26,6
deal_tot	decimal	26,6
deal_tot_usdollar	decimal	26,6
new_sub	decimal	26,6
new_sub_usdollar	decimal	26,6
subtotal	decimal	26,6
taxable_subtotal	decimal	26,6
shipping	decimal	26,6
default_group	tinyint
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
sync_key	varchar	100

MySQL product_bundles Keys:

name	type	fields
idx_product_bundles_acl_tmst_id	index	acl_team_set_id,deleted
idx_product_bundles_skey	unique	sync_key
idx_product_bundles_tmst_id	index	team_set_id,deleted
idx_products_bundles	index	name,deleted
PRIMARY	primary	id

MySQL product_categories Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
list_order	int
parent_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL product_categories Keys:

name	type	fields
idx_id_name_list_order	index	id,name,list_order
idx_product_categories_assigned_del	index	assigned_user_id,deleted
idx_product_categories_date_entered	index	date_entered
idx_product_categories_date_modfied	index	date_modified
idx_product_categories_del_d_e	index	deleted,date_entered,id
idx_product_categories_del_d_m	index	deleted,date_modified,id
idx_product_categories_id_del	index	id,deleted
idx_product_categories_name_del	index	name,deleted
idx_product_categories_skey	unique	sync_key
idx_producttemplate_id_parent_name	index	id,parent_id,name,deleted
PRIMARY	primary	id

MySQL product_definition Definitions:

name	type
data	text

MySQL product_definition Keys:

MySQL product_product Definitions:

name	type	len
id	char	36
parent_id	char	36
child_id	char	36
date_modified	datetime
deleted	tinyint

MySQL product_product Keys:

name	type	fields
idx_pp_child	index	child_id
idx_pp_parent	index	parent_id
PRIMARY	primary	id

MySQL product_templates Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
type_id	char	36
manufacturer_id	char	36
category_id	char	36
mft_part_num	varchar	50
vendor_part_num	varchar	50
date_cost_price	date
cost_price	decimal	26,6
discount_price	decimal	26,6
list_price	decimal	26,6
cost_usdollar	decimal	26,6
discount_usdollar	decimal	26,6
list_usdollar	decimal	26,6
status	varchar	100
tax_class	varchar	100
date_available	date
website	varchar	255
weight	decimal	12,2
qty_in_stock	int
support_name	varchar	50
support_description	varchar	255
support_contact	varchar	50
support_term	varchar	100
pricing_formula	varchar	100
pricing_factor	decimal	8,2
assigned_user_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
service_duration_value	int
service_duration_unit	varchar	50
renewable	tinyint
service	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
lock_duration	tinyint
sync_key	varchar	100
active_status	varchar	100	Active

MySQL product_templates Keys:

name	type	fields
idx_id_name	index	id,name
idx_product_templates_acl_tmst_id	index	acl_team_set_id,deleted
idx_product_templates_assigned_del	index	assigned_user_id,deleted
idx_product_templates_date_entered	index	date_entered
idx_product_templates_date_modfied	index	date_modified
idx_product_templates_del_d_e	index	deleted,date_entered,id
idx_product_templates_del_d_m	index	deleted,date_modified,id
idx_product_templates_id_del	index	id,deleted
idx_product_templates_name_del	index	name,deleted
idx_product_templates_skey	unique	sync_key
idx_product_templates_tmst_id	index	team_set_id,deleted
idx_producttemplate_category	index	category_id,active_status,deleted
idx_producttemplate_qty_in_stock	index	qty_in_stock
PRIMARY	primary	id

MySQL product_templates_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL product_templates_audit Keys:

name	type	fields
idx_product_templates_audit_after_value	index	after_value_string
idx_product_templates_audit_event_id	index	event_id
idx_product_templates_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL product_templates_cstm Definitions:

name	type	len	default
id_c	char	36
si5_cod_c	varchar	255
eng_description_c	text
multi_lang_desc_c	text
product_img_c	varchar	255
fm_famprod_id_c	char	36
immagine_prodotto_c	varchar	255
listino_c	varchar	255
img_c	int		10
eng_c	int		10

MySQL product_templates_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL product_types Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
list_order	int
sync_key	varchar	100

MySQL product_types Keys:

name	type	fields
idx_product_types_date_entered	index	date_entered
idx_product_types_date_modfied	index	date_modified
idx_product_types_del_d_e	index	deleted,date_entered,id
idx_product_types_del_d_m	index	deleted,date_modified,id
idx_product_types_id_del	index	id,deleted
idx_product_types_name_del	index	name,deleted
idx_product_types_skey	unique	sync_key
PRIMARY	primary	id

MySQL products Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
revenuelineitem_id	char	36
product_template_id	char	36
account_id	char	36
contact_id	char	36
subtotal	decimal	26,6	0.000000
total_amount	decimal	26,6	0.000000
type_id	char	36
quote_id	char	36
manufacturer_id	char	36
category_id	char	36
mft_part_num	varchar	50
vendor_part_num	varchar	50
date_purchased	date
cost_price	decimal	26,6
discount_price	decimal	26,6	0.000000
discount_amount	decimal	26,6	0.000000
discount_rate_percent	decimal	26,2
discount_amount_usdollar	decimal	26,6
discount_select	tinyint	1
deal_calc	decimal	26,6
deal_calc_usdollar	decimal	26,6
list_price	decimal	26,6
cost_usdollar	decimal	26,6
discount_usdollar	decimal	26,6
list_usdollar	decimal	26,6
status	varchar	100
tax_class	varchar	100	Taxable
website	varchar	255
weight	decimal	12,2
quantity	decimal	12,2	1.00
support_name	varchar	50
support_description	varchar	255
support_contact	varchar	50
support_term	varchar	100
date_support_expires	date
date_support_starts	date
pricing_formula	varchar	100
pricing_factor	int
serial_number	varchar	50
asset_number	varchar	50
book_value	decimal	26,6
book_value_usdollar	decimal	26,6
book_value_date	date
date_closed	date
date_closed_timestamp	bigint
next_step	varchar	100
campaign_id	char	36
opportunity_id	char	36
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
renewable	tinyint
service	tinyint
service_duration_value	int
service_duration_unit	varchar	50
service_end_date	date
service_start_date	date
lock_duration	tinyint
discount_amount_signed	decimal	26,6	0.000000
parent_rli_id	char	36
add_on_to_id	char	36
sync_key	varchar	100
catalog_service_duration_value	int
catalog_service_duration_unit	varchar	50
service_duration_multiplier	decimal	10,0
renewal	tinyint

MySQL products Keys:

name	type	fields
idx_del_p_rli_id	index	deleted,parent_rli_id
idx_prod_user_dc_timestamp	index	id,assigned_user_id,date_closed_timestamp
idx_product_account	index	account_id
idx_product_contact	index	contact_id
idx_product_del_created_by_pt_id	index	deleted,created_by,product_template_id
idx_product_opp	index	opportunity_id
idx_product_quantity	index	quantity
idx_product_quote	index	quote_id
idx_product_rli	index	revenuelineitem_id
idx_products_acl_tmst_id	index	acl_team_set_id,deleted
idx_products_assigned_del	index	assigned_user_id,deleted
idx_products_date_entered	index	date_entered
idx_products_date_modfied	index	date_modified
idx_products_del_d_e	index	deleted,date_entered,id
idx_products_del_d_m	index	deleted,date_modified,id
idx_products_id_del	index	id,deleted
idx_products_name_del	index	name,deleted
idx_products_skey	unique	sync_key
idx_products_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL products_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL products_audit Keys:

name	type	fields
idx_products_audit_after_value	index	after_value_string
idx_products_audit_event_id	index	event_id
idx_products_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL products_cstm Definitions:

name	type	len	default
id_c	char	36
multi_lang_desc_c	text
product_cod_c	varchar	255
eng_description_c	text
sconto_fisso_c	int
sconto_2_c	int
immagine_prodotto_c	varchar	255
descrizione_dettaglio_c	text
eng_c	int
img_prodotto_c	varchar	255
discount_price2_c	decimal	26,6	0.000000
pk_commenti_c	text

MySQL products_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL project Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
assigned_user_id	char	36
modified_user_id	char	36
created_by	char	36
name	varchar	50
description	text
deleted	tinyint
estimated_start_date	date
estimated_end_date	date
status	varchar	255
priority	varchar	255
is_template	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL project Keys:

name	type	fields
idx_project_acl_tmst_id	index	acl_team_set_id,deleted
idx_project_estimated_end_date	index	estimated_end_date
idx_project_estimated_start_date	index	estimated_start_date
idx_project_name	index	name
idx_project_status	index	status
idx_project_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL project_resources Definitions:

name	type	len
id	char	36
date_modified	datetime
modified_user_id	char	36
created_by	char	36
project_id	char	36
resource_id	char	36
resource_type	varchar	20
deleted	tinyint

MySQL project_resources Keys:

name	type	fields
PRIMARY	primary	id

MySQL project_task Definitions:

name	type	len	required
id	char	36
date_entered	datetime
date_modified	datetime
project_id	char	36	true
project_task_id	int
name	varchar	50
status	varchar	255
description	text
resource_id	text
predecessors	text
date_start	date
time_start	int
time_finish	int
date_finish	date
duration	int
duration_unit	text
actual_duration	int
percent_complete	int
date_due	date
time_due	time
parent_task_id	int
assigned_user_id	char	36
modified_user_id	char	36
priority	varchar	255
created_by	char	36
milestone_flag	tinyint
order_number	int		1
task_number	int
estimated_effort	int
actual_effort	int
deleted	tinyint
utilization	int		100
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL project_task Keys:

name	type	fields
idx_project_task_acl_tmst_id	index	acl_team_set_id,deleted
idx_project_task_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL project_task_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL project_task_audit Keys:

name	type	fields
idx_project_task_audit_after_value	index	after_value_string
idx_project_task_audit_event_id	index	event_id
idx_project_task_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL projects_accounts Definitions:

name	type	len
id	char	36
account_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_accounts Keys:

name	type	fields
idx_proj_acct_acct	index	account_id
PRIMARY	primary	id
projects_accounts_alt	index	project_id,account_id

MySQL projects_bugs Definitions:

name	type	len
id	char	36
bug_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_bugs Keys:

name	type	fields
idx_proj_bug_bug	index	bug_id
PRIMARY	primary	id
projects_bugs_alt	index	project_id,bug_id

MySQL projects_cases Definitions:

name	type	len
id	char	36
case_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_cases Keys:

name	type	fields
idx_proj_case_case	index	case_id
PRIMARY	primary	id
projects_cases_alt	index	project_id,case_id

MySQL projects_contacts Definitions:

name	type	len
id	char	36
contact_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_contacts Keys:

name	type	fields
idx_proj_con_con	index	contact_id
PRIMARY	primary	id
projects_contacts_alt	index	project_id,contact_id

MySQL projects_opportunities Definitions:

name	type	len
id	char	36
opportunity_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_opportunities Keys:

name	type	fields
idx_proj_opp_opp	index	opportunity_id
PRIMARY	primary	id
projects_opportunities_alt	index	project_id,opportunity_id

MySQL projects_products Definitions:

name	type	len
id	char	36
product_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_products Keys:

name	type	fields
idx_proj_prod_product	index	product_id
PRIMARY	primary	id
projects_products_alt	index	project_id,product_id

MySQL projects_quotes Definitions:

name	type	len
id	char	36
quote_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_quotes Keys:

name	type	fields
idx_proj_quote_quote	index	quote_id
PRIMARY	primary	id
projects_quotes_alt	index	project_id,quote_id

MySQL projects_revenue_line_items Definitions:

name	type	len
id	char	36
rli_id	char	36
project_id	char	36
date_modified	datetime
deleted	tinyint

MySQL projects_revenue_line_items Keys:

name	type	fields
idx_proj_rli_product	index	rli_id
PRIMARY	primary	id
projects_rli_alt	index	project_id,rli_id

MySQL prospect_list_campaigns Definitions:

name	type	len
id	char	36
prospect_list_id	char	36
campaign_id	char	36
date_modified	datetime
deleted	tinyint

MySQL prospect_list_campaigns Keys:

name	type	fields
idx_cam_id	index	campaign_id
idx_prospect_list_campaigns	index	prospect_list_id,campaign_id
PRIMARY	primary	id

MySQL prospect_lists Definitions:

name	type	len
id	char	36
name	varchar	255
list_type	varchar	100
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
deleted	tinyint
description	text
domain_name	varchar	255
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL prospect_lists Keys:

name	type	fields
idx_prospect_list_date_entered	index	date_entered
idx_prospect_list_list_type	index	list_type
idx_prospect_list_name	index	name
idx_prospect_lists_acl_tmst_id	index	acl_team_set_id,deleted
idx_prospect_lists_assigned_del	index	assigned_user_id,deleted
idx_prospect_lists_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL prospect_lists_prospects Definitions:

name	type	len
id	char	36
prospect_list_id	char	36
related_id	char	36
related_type	varchar	25
date_modified	datetime
deleted	tinyint

MySQL prospect_lists_prospects Keys:

name	type	fields
idx_plp_pro_id	index	prospect_list_id,deleted
idx_plp_rel_id	index	related_id,related_type,prospect_list_id
PRIMARY	primary	id

MySQL prospects Definitions:

name	type	len	auto_increment	required
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
salutation	varchar	255
first_name	varchar	255
last_name	varchar	255
title	varchar	100
facebook	varchar	100
twitter	varchar	100
googleplus	varchar	100
department	varchar	255
do_not_call	tinyint
phone_home	varchar	100
phone_mobile	varchar	100
phone_work	varchar	100
phone_other	varchar	100
phone_fax	varchar	100
primary_address_street	varchar	150
primary_address_city	varchar	100
primary_address_state	varchar	100
primary_address_postalcode	varchar	20
primary_address_country	varchar	255
alt_address_street	varchar	150
alt_address_city	varchar	100
alt_address_state	varchar	100
alt_address_postalcode	varchar	20
alt_address_country	varchar	255
assistant	varchar	75
assistant_phone	varchar	100
picture	varchar	255
tracker_key	int		1	true
birthdate	date
lead_id	char	36
account_name	varchar	150
campaign_id	char	36
dp_business_purpose	text
dp_consent_last_updated	date
dnb_principal_id	varchar	30
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
geocode_status	varchar	255

MySQL prospects Keys:

name	type	fields
idx_prospecs_del_last	index	last_name,deleted
idx_prospect_title	index	title
idx_prospects_acl_tmst_id	index	acl_team_set_id,deleted
idx_prospects_assigned_del	index	assigned_user_id,deleted
idx_prospects_date_entered	index	date_entered
idx_prospects_date_modfied	index	date_modified
idx_prospects_del_d_e	index	deleted,date_entered,id
idx_prospects_del_d_m	index	deleted,date_modified,id
idx_prospects_first_last	index	first_name,last_name,deleted
idx_prospects_id_del	index	id,deleted
idx_prospects_last_first	index	last_name,first_name,deleted
idx_prospects_skey	unique	sync_key
idx_prospects_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id
prospect_auto_tracker_key	index	tracker_key

MySQL prospects_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL prospects_audit Keys:

name	type	fields
idx_prospects_audit_after_value	index	after_value_string
idx_prospects_audit_event_id	index	event_id
idx_prospects_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL prospects_dataprivacy Definitions:

name	type	len
id	char	36
prospect_id	char	36
dataprivacy_id	char	36
date_modified	datetime
deleted	tinyint

MySQL prospects_dataprivacy Keys:

name	type	fields
idx_prospect_dataprivacy_dataprivacy	index	dataprivacy_id
idx_prospects_dataprivacy	index	prospect_id,dataprivacy_id
PRIMARY	primary	id

MySQL pubsub_moduleevent_pushsubs Definitions:

name	type	len	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
expiration_date	datetime	true
target_module	varchar	255	true
token	varchar	255	true
webhook_url	varchar	255	true
sync_key	varchar	100

MySQL pubsub_moduleevent_pushsubs Keys:

name	type	fields
idx_pubsub_moduleevent_pushsubs_del_d_e	index	deleted,date_entered,id
idx_pubsub_moduleevent_pushsubs_del_d_m	index	deleted,date_modified,id
idx_pubsub_moduleevent_pushsubs_id_del	index	id,deleted
idx_pubsub_moduleevent_pushsubs_name_del	index	name,deleted
idx_pubsub_moduleevent_pushsubs_skey	unique	sync_key
idx_pubsub_moduleevent_pushsubs_target_module_expiration_date	index	target_module,expiration_date
PRIMARY	primary	id

MySQL purchased_line_items Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
annual_revenue	decimal	26,6
book_value_usdollar	decimal	26,6
cost_price	decimal	26,6
cost_usdollar	decimal	26,6
date_closed	date
date_closed_timestamp	bigint
deal_calc	decimal	26,6
deal_calc_usdollar	decimal	26,6
discount_amount	decimal	26,6	0.000000
discount_amount_signed	decimal	26,6	0.000000
discount_amount_usdollar	decimal	26,6
discount_price	decimal	26,6
discount_select	tinyint
discount_usdollar	decimal	26,6
list_usdollar	decimal	26,6
mft_part_num	varchar	50
revenue	decimal	26,6
revenue_usdollar	decimal	26,6
total_amount	decimal	26,6
subtotal	decimal	26,6
category_id	char	36
manufacturer_id	char	36
product_template_id	char	36
lock_duration	tinyint
product_type_id	char	36
purchase_id	char	36
revenuelineitem_id	char	36
renewal_opp_id	char	36
account_id	char	36
status	varchar	255
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
asset_number	varchar	50
book_value	decimal	26,6
book_value_date	date
date_purchased	date
date_support_expires	date
date_support_starts	date
list_price	decimal	26,6
pricing_factor	int
pricing_formula	varchar	100
quantity	decimal	12,2	1.00
serial_number	varchar	50
renewable	tinyint
service	tinyint
service_duration_value	int
service_duration_unit	varchar	50
catalog_service_duration_value	int
catalog_service_duration_unit	varchar	50
service_duration_multiplier	decimal	10,0
service_end_date	date
service_start_date	date
support_contact	varchar	50
support_description	varchar	255
support_name	varchar	50
support_term	varchar	100
tax_class	varchar	100	Taxable
vendor_part_num	varchar	50
website	varchar	255
weight	decimal	12,2
renewal	tinyint
currency_id	char	36	-99
base_rate	decimal	26,6
denorm_account_name	varchar	150

MySQL purchased_line_items Keys:

name	type	fields
idx_pli_catid_del	index	deleted,category_id,id
idx_pli_dclose_del	index	deleted,date_closed,id
idx_pli_dclose_name_del	index	deleted,date_closed,name,id
idx_pli_del_accountid	index	deleted,account_id
idx_pli_dent_name_del	index	deleted,date_entered,name,id
idx_pli_manid_del	index	deleted,manufacturer_id,id
idx_pli_purchaseid_del	index	deleted,purchase_id,id
idx_purchased_line_items_acl_tmst_id	index	acl_team_set_id,deleted
idx_purchased_line_items_assigned_del	index	assigned_user_id,deleted
idx_purchased_line_items_del_d_e	index	deleted,date_entered,id
idx_purchased_line_items_del_d_m	index	deleted,date_modified,id
idx_purchased_line_items_denorm_account_name	index	denorm_account_name,id,deleted
idx_purchased_line_items_id_del	index	id,deleted
idx_purchased_line_items_name_del	index	name,deleted
idx_purchased_line_items_skey	unique	sync_key
idx_purchased_line_items_tmst_id	index	team_set_id,deleted
idx_purchaseid_del	index	purchase_id,deleted
PRIMARY	primary	id

MySQL purchased_line_items_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL purchased_line_items_audit Keys:

name	type	fields
idx_purchased_line_items_audit_after_value	index	after_value_string
idx_purchased_line_items_audit_event_id	index	event_id
idx_purchased_line_items_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL purchases Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
start_date	date
end_date	date
service	tinyint
total_revenue	decimal	26,6
total_quantity	decimal	18,2
pli_count	int
renewable	tinyint
product_template_id	char	36
account_id	char	36
type_id	char	36
category_id	char	36
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6

MySQL purchases Keys:

name	type	fields
idx_purch_del_accountid	index	deleted,account_id
idx_purchases_acl_tmst_id	index	acl_team_set_id,deleted
idx_purchases_assigned_del	index	assigned_user_id,deleted
idx_purchases_del_d_e	index	deleted,date_entered,id
idx_purchases_del_d_m	index	deleted,date_modified,id
idx_purchases_id_del	index	id,deleted
idx_purchases_name_del	index	name,deleted
idx_purchases_skey	unique	sync_key
idx_purchases_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL purchases_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL purchases_audit Keys:

name	type	fields
idx_purchases_audit_after_value	index	after_value_string
idx_purchases_audit_event_id	index	event_id
idx_purchases_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL push_notifications Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
is_sent	tinyint
notification_type	varchar	255
parent_type	varchar	100
parent_id	char	36
extra_data	text
sync_key	varchar	100
assigned_user_id	char	36

MySQL push_notifications Keys:

name	type	fields
idx_push_notifications_assigned_del	index	assigned_user_id,deleted
idx_push_notifications_del_d_e	index	deleted,date_entered,id
idx_push_notifications_del_d_m	index	deleted,date_modified,id
idx_push_notifications_id_del	index	id,deleted
idx_push_notifications_name_del	index	name,deleted
idx_push_notifications_skey	unique	sync_key
PRIMARY	primary	id

MySQL quotas Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
user_id	char	36
timeperiod_id	char	36
quota_type	varchar	100
amount	decimal	26,6
amount_base_currency	decimal	26,6
committed	tinyint
assigned_user_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
sync_key	varchar	100

MySQL quotas Keys:

name	type	fields
idx_quota_user_tp	index	user_id,timeperiod_id
idx_quotas_assigned_del	index	assigned_user_id,deleted
idx_quotas_date_entered	index	date_entered
idx_quotas_date_modfied	index	date_modified
idx_quotas_del_d_e	index	deleted,date_entered,id
idx_quotas_del_d_m	index	deleted,date_modified,id
idx_quotas_id_del	index	id,deleted
idx_quotas_name_del	index	name,deleted
idx_quotas_skey	unique	sync_key
PRIMARY	primary	id

MySQL quotas_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL quotas_audit Keys:

name	type	fields
idx_quotas_audit_after_value	index	after_value_string
idx_quotas_audit_event_id	index	event_id
idx_quotas_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL quotes Definitions:

name	type	len	default	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
shipper_id	char	36
taxrate_id	char	36
taxrate_value	decimal	26,6	0.000000
show_line_nums	tinyint	1
quote_type	varchar	255
date_quote_expected_closed	date
original_po_date	date
payment_terms	varchar	128
date_quote_closed	date
date_order_shipped	date
order_stage	varchar	100
quote_stage	varchar	100
purchase_order_num	varchar	50
quote_num	int		1	true
subtotal	decimal	26,6
subtotal_usdollar	decimal	26,6
shipping	decimal	26,6	0.000000
shipping_usdollar	decimal	26,6
discount	decimal	26,6	0.000000
deal_tot	decimal	26,2
deal_tot_discount_percentage	decimal	26,2	0.00
deal_tot_usdollar	decimal	26,2
new_sub	decimal	26,6
new_sub_usdollar	decimal	26,6
taxable_subtotal	decimal	26,6
tax	decimal	26,6	0.000000
tax_usdollar	decimal	26,6
total	decimal	26,6
total_usdollar	decimal	26,6
billing_address_street	varchar	150
billing_address_city	varchar	100
billing_address_state	varchar	100
billing_address_postalcode	varchar	20
billing_address_country	varchar	100
shipping_address_street	varchar	150
shipping_address_city	varchar	100
shipping_address_state	varchar	100
shipping_address_postalcode	varchar	20
shipping_address_country	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
renewal	tinyint
sync_key	varchar	100
geocode_status	varchar	255
denorm_billing_account_name	varchar	150

MySQL quotes Keys:

name	type	fields
idx_quote_date_quote_expected_closed	index	date_quote_expected_closed
idx_quote_quote_stage	index	quote_stage
idx_quotes_acl_tmst_id	index	acl_team_set_id,deleted
idx_quotes_assigned_del	index	assigned_user_id,deleted
idx_quotes_date_entered	index	date_entered
idx_quotes_date_modfied	index	date_modified
idx_quotes_del_d_e	index	deleted,date_entered,id
idx_quotes_del_d_m	index	deleted,date_modified,id
idx_quotes_id_del	index	id,deleted
idx_quotes_name_del	index	name,deleted
idx_quotes_skey	unique	sync_key
idx_quotes_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id
quote_num	unique	quote_num

MySQL quotes_accounts Definitions:

name	type	len
id	char	36
quote_id	char	36
account_id	char	36
account_role	varchar	20
date_modified	datetime
deleted	tinyint

MySQL quotes_accounts Keys:

name	type	fields
idx_acc_qte_acc	index	account_id
idx_quote_account_role	index	quote_id,account_role
PRIMARY	primary	id

MySQL quotes_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL quotes_audit Keys:

name	type	fields
idx_quotes_audit_after_value	index	after_value_string
idx_quotes_audit_event_id	index	event_id
idx_quotes_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL quotes_contacts Definitions:

name	type	len
id	char	36
contact_id	char	36
quote_id	char	36
contact_role	varchar	20
date_modified	datetime
deleted	tinyint

MySQL quotes_contacts Keys:

name	type	fields
idx_con_qte_con	index	contact_id
idx_quote_contact_role	index	quote_id,contact_role
PRIMARY	primary	id

MySQL quotes_cstm Definitions:

name	type	len	default
id_c	char	36
causa_perdita_c	varchar	100
azione_c	varchar	100	scegli
extracee_c	tinyint
garanzia_c	varchar	255	Secondo condizioni generali di fornitura
imballo_c	varchar	255	Incluso
listino_c	varchar	100
no_sconto_2_c	tinyint
no_sconto_fisso_c	tinyint
per_conto_di_c	varchar	100
sales_assistant_c	tinyint
resa_c	varchar	100	01
revisione_c	int
sconto_2_c	int
sconto_fisso_c	int
spedizioniere_c	varchar	100
tempo_sped_c	varchar	255
validita_c	date
resa_eng_c	varchar	255
pdf_dettaglio_c	tinyint	1
pk_teamtext_c	varchar	80
pk_teamtext2_c	varchar	80
pk_causa_perdi_c	varchar	100
pk_qrating_c	int		10
pk_classe_rating_c	varchar	100
assistant_c	varchar	100
pk_numlinee_c	int
nazione_dd_c	varchar	100
regione_dd_c	varchar	100
pk_tipo_stampa_c	varchar	100	3
pk_filiera_odv_c	varchar	100
pk_note_aggiuntive_fornitura_c	text
pdf_foto_c	tinyint	1
pk_garanzia_new_c	varchar	100	00
pk_imballo_new_c	varchar	100	00

MySQL quotes_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL quotes_opportunities Definitions:

name	type	len
id	char	36
opportunity_id	char	36
quote_id	char	36
date_modified	datetime
deleted	tinyint

MySQL quotes_opportunities Keys:

name	type	fields
idx_opp_qte_opp	index	opportunity_id
idx_quote_oportunities	index	quote_id
PRIMARY	primary	id

MySQL record_list Definitions:

name	type	len	required
id	char	36
assigned_user_id	char	36	true
module_name	varchar	50
records	longtext
date_modified	datetime

MySQL record_list Keys:

name	type	fields
PRIMARY	primary	id

MySQL releases Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	50
list_order	int
status	varchar	100

MySQL releases Keys:

name	type	fields
idx_releases	index	name,deleted
PRIMARY	primary	id

MySQL report_cache Definitions:

name	type	len
id	char	36
assigned_user_id	char	36
contents	text
report_options	text
deleted	varchar	1
date_entered	datetime
date_modified	datetime

MySQL report_cache Keys:

name	type	fields
PRIMARY	primary	id,assigned_user_id

MySQL report_maker Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	50
title	varchar	50
report_align	varchar	8
description	text
scheduled	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL report_maker Keys:

name	type	fields
idx_report_maker_acl_tmst_id	index	acl_team_set_id,deleted
idx_report_maker_tmst_id	index	team_set_id,deleted
idx_rmaker	index	name,deleted
PRIMARY	primary	id

MySQL report_schedules Definitions:

name	type	len	required
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
user_id	char	36
report_id	char	36	true
date_start	datetime
time_interval	int		604800
next_run	datetime
active	tinyint	1
schedule_type	varchar	3
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
file_type	varchar	32	PDF
embed_report	varchar	32

MySQL report_schedules Keys:

name	type	fields
idx_del_active	index	deleted,active
idx_report_schedules_acl_tmst_id	index	acl_team_set_id,deleted
idx_report_schedules_assigned_del	index	assigned_user_id,deleted
idx_report_schedules_date_entered	index	date_entered
idx_report_schedules_date_modfied	index	date_modified
idx_report_schedules_del_d_e	index	deleted,date_entered,id
idx_report_schedules_del_d_m	index	deleted,date_modified,id
idx_report_schedules_id_del	index	id,deleted
idx_report_schedules_name_del	index	name,deleted
idx_report_schedules_skey	unique	sync_key
idx_report_schedules_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL report_schedules_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL report_schedules_audit Keys:

name	type	fields
idx_report_schedules_audit_after_value	index	after_value_string
idx_report_schedules_audit_event_id	index	event_id
idx_report_schedules_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL reports_panels Definitions:

name	type	len
id	char	36
report_id	char	36
user_id	char	36
contents	text
default_panel	tinyint
report_type	varchar	25
date_entered	datetime
date_modified	datetime
deleted	tinyint

MySQL reports_panels Keys:

name	type	fields
idx_report_id_user_id	index	report_id,user_id
PRIMARY	primary	id

MySQL reportschedules_users Definitions:

name	type	len
id	char	36
reportschedule_id	char	36
user_id	char	36
date_modified	datetime
deleted	tinyint

MySQL reportschedules_users Keys:

name	type	fields
idx_reportschedule_users_del	index	reportschedule_id,user_id,deleted
idx_usr_rs_usr	index	user_id
PRIMARY	primary	id

MySQL revenue_line_items Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
product_template_id	char	36
account_id	char	36
total_amount	decimal	26,6
type_id	char	36
quote_id	char	36
manufacturer_id	char	36
category_id	char	36
mft_part_num	varchar	50
vendor_part_num	varchar	50
date_purchased	date
cost_price	decimal	26,6
discount_price	decimal	26,6
discount_amount	decimal	26,6
discount_rate_percent	decimal	26,2
discount_amount_usdollar	decimal	26,6
discount_select	tinyint
deal_calc	decimal	26,6
deal_calc_usdollar	decimal	26,6
list_price	decimal	26,6
cost_usdollar	decimal	26,6
discount_usdollar	decimal	26,6
list_usdollar	decimal	26,6
status	varchar	100
tax_class	varchar	100
website	varchar	255
weight	decimal	12,2
quantity	decimal	12,2	1.00
support_name	varchar	50
support_description	varchar	255
support_contact	varchar	50
support_term	varchar	100
date_support_expires	date
date_support_starts	date
pricing_formula	varchar	100
pricing_factor	int
serial_number	varchar	50
asset_number	varchar	50
book_value	decimal	26,6
book_value_usdollar	decimal	26,6
book_value_date	date
best_case	decimal	26,6
likely_case	decimal	26,6
worst_case	decimal	26,6
date_closed	date
date_closed_timestamp	bigint
next_step	varchar	100
commit_stage	varchar	50	exclude
sales_stage	varchar	255	Prospecting
probability	double
lead_source	varchar	50
campaign_id	char	36
opportunity_id	char	36
product_type	varchar	255
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
currency_id	char	36	-99
base_rate	decimal	26,6
acl_team_set_id	char	36
renewable	tinyint
service	tinyint
service_duration_value	int
service_duration_unit	varchar	50
service_end_date	date
service_start_date	date
lock_duration	tinyint
subtotal	decimal	26,6
discount_amount_signed	decimal	26,6	0.000000
generate_purchase	varchar	25
purchasedlineitem_id	char	36
add_on_to_id	char	36
renewal_rli_id	char	36
sync_key	varchar	100
catalog_service_duration_value	int
catalog_service_duration_unit	varchar	50
service_duration_multiplier	decimal	10,0
renewal	tinyint
forecasted_likely	decimal	26,6
denorm_account_name	varchar	150

MySQL revenue_line_items Keys:

name	type	fields
idx_accountid_type_ren_dateclosed	index	account_id,product_type,renewable,date_closed
idx_del_addontoid	index	deleted,add_on_to_id
idx_renewal_rli_id_del	index	deleted,renewal_rli_id,id
idx_revenue_line_items_acl_tmst_id	index	acl_team_set_id,deleted
idx_revenue_line_items_assigned_del	index	assigned_user_id,deleted
idx_revenue_line_items_date_entered	index	date_entered
idx_revenue_line_items_date_modfied	index	date_modified
idx_revenue_line_items_del_d_e	index	deleted,date_entered,id
idx_revenue_line_items_del_d_m	index	deleted,date_modified,id
idx_revenue_line_items_id_del	index	id,deleted
idx_revenue_line_items_name_del	index	name,deleted
idx_revenue_line_items_skey	unique	sync_key
idx_revenue_line_items_tmst_id	index	team_set_id,deleted
idx_revenuelineitem_oppid	index	opportunity_id
idx_revenuelineitem_sales_stage	index	sales_stage
idx_rli_account_id_del	index	deleted,account_id,id
idx_rli_del_created_by_pt_id	index	deleted,created_by,product_template_id
idx_rli_name_dm	index	deleted,name,date_modified
idx_rli_quote_id_del	index	deleted,quote_id,id
PRIMARY	primary	id

MySQL revenue_line_items_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL revenue_line_items_audit Keys:

name	type	fields
idx_revenue_line_items_audit_after_value	index	after_value_string
idx_revenue_line_items_audit_event_id	index	event_id
idx_revenue_line_items_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL roles Definitions:

name	type	len
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	150
description	text
modules	text
deleted	tinyint

MySQL roles Keys:

name	type	fields
idx_role_name	index	name
PRIMARY	primary	id

MySQL roles_modules Definitions:

name	type	len
id	char	36
role_id	char	36
module_id	char	36
allow	tinyint
date_modified	datetime
deleted	tinyint

MySQL roles_modules Keys:

name	type	fields
idx_module_id	index	module_id
PRIMARY	primary	id

MySQL roles_users Definitions:

name	type	len
id	char	36
role_id	char	36
user_id	char	36
date_modified	datetime
deleted	tinyint

MySQL roles_users Keys:

name	type	fields
idx_ru_role_id	index	role_id
idx_ru_user_id	index	user_id
PRIMARY	primary	id

MySQL saved_reports Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
module	varchar	255
report_type	varchar	255
content	longtext
is_published	tinyint
chart_type	varchar	36	none
schedule_type	varchar	3	pro
favorite	tinyint
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100

MySQL saved_reports Keys:

name	type	fields
idx_saved_reports_acl_tmst_id	index	acl_team_set_id,deleted
idx_saved_reports_assigned_del	index	assigned_user_id,deleted
idx_saved_reports_date_entered	index	date_entered
idx_saved_reports_date_modfied	index	date_modified
idx_saved_reports_del_d_e	index	deleted,date_entered,id
idx_saved_reports_del_d_m	index	deleted,date_modified,id
idx_saved_reports_id_del	index	id,deleted
idx_saved_reports_name_del	index	name,deleted
idx_saved_reports_skey	unique	sync_key
idx_saved_reports_tmst_id	index	team_set_id,deleted
idx_savedreport_module	index	module
PRIMARY	primary	id

MySQL saved_search Definitions:

name	type	len
id	char	36
name	varchar	150
search_module	varchar	150
deleted	tinyint
date_entered	datetime
date_modified	datetime
assigned_user_id	char	36
contents	text
description	text
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL saved_search Keys:

name	type	fields
idx_desc	index	name,deleted
idx_saved_search_acl_tmst_id	index	acl_team_set_id,deleted
idx_saved_search_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL sb_campagne_sib Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL sb_campagne_sib Keys:

name	type	fields
idx_sb_campagne_sib_acl_tmst_id	index	acl_team_set_id,deleted
idx_sb_campagne_sib_assigned_del	index	assigned_user_id,deleted
idx_sb_campagne_sib_del_d_e	index	deleted,date_entered,id
idx_sb_campagne_sib_del_d_m	index	deleted,date_modified,id
idx_sb_campagne_sib_id_del	index	id,deleted
idx_sb_campagne_sib_name_del	index	name,deleted
idx_sb_campagne_sib_skey	unique	sync_key
idx_sb_campagne_sib_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL sb_campagne_sib_accounts_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
sb_campagne_sib_accounts_1sb_campagne_sib_ida	char	36
sb_campagne_sib_accounts_1accounts_idb	char	36

MySQL sb_campagne_sib_accounts_1_c Keys:

name	type	fields
idx_sb_campagne_sib_accounts_1_ida1_deleted	index	sb_campagne_sib_accounts_1sb_campagne_sib_ida,deleted
idx_sb_campagne_sib_accounts_1_idb2_deleted	index	sb_campagne_sib_accounts_1accounts_idb,deleted
PRIMARY	primary	id
sb_campagne_sib_accounts_1_alt	index	sb_campagne_sib_accounts_1sb_campagne_sib_ida,sb_campagne_sib_accounts_1accounts_idb

MySQL sb_campagne_sib_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL sb_campagne_sib_audit Keys:

name	type	fields
idx_sb_campagne_sib_audit_after_value	index	after_value_string
idx_sb_campagne_sib_audit_event_id	index	event_id
idx_sb_campagne_sib_audit_pa_ev_id	index	parent_id,event_id
idx_sb_campagne_sib_audit_parent_id	index	parent_id
PRIMARY	primary	id

MySQL sb_campagne_sib_contacts_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
sb_campagne_sib_contacts_1sb_campagne_sib_ida	char	36
sb_campagne_sib_contacts_1contacts_idb	char	36

MySQL sb_campagne_sib_contacts_1_c Keys:

name	type	fields
idx_sb_campagne_sib_contacts_1_ida1_deleted	index	sb_campagne_sib_contacts_1sb_campagne_sib_ida,deleted
idx_sb_campagne_sib_contacts_1_idb2_deleted	index	sb_campagne_sib_contacts_1contacts_idb,deleted
PRIMARY	primary	id
sb_campagne_sib_contacts_1_alt	index	sb_campagne_sib_contacts_1sb_campagne_sib_ida,sb_campagne_sib_contacts_1contacts_idb

MySQL sb_campagne_sib_cstm Definitions:

name	type	len
id_c	char	36
campaign_type_c	varchar	255
id_sib_c	varchar	255
sender_email_c	varchar	255
status_c	varchar	255
subject_c	varchar	255

MySQL sb_campagne_sib_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL sb_campagne_sib_sb_liste_sib_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
sb_campagne_sib_sb_liste_sib_1sb_campagne_sib_ida	char	36
sb_campagne_sib_sb_liste_sib_1sb_liste_sib_idb	char	36

MySQL sb_campagne_sib_sb_liste_sib_1_c Keys:

name	type	fields
idx_sb_campagne_sib_sb_liste_sib_1_ida1_deleted	index	sb_campagne_sib_sb_liste_sib_1sb_campagne_sib_ida,deleted
idx_sb_campagne_sib_sb_liste_sib_1_idb2_deleted	index	sb_campagne_sib_sb_liste_sib_1sb_liste_sib_idb,deleted
PRIMARY	primary	id
sb_campagne_sib_sb_liste_sib_1_alt	index	sb_campagne_sib_sb_liste_sib_1sb_campagne_sib_ida,sb_campagne_sib_sb_liste_sib_1sb_liste_sib_idb

MySQL sb_campagne_sib_sb_stats_sib_1_c Definitions:

name	type	len
id	char	36
date_modified	datetime
deleted	tinyint
sb_campagne_sib_sb_stats_sib_1sb_campagne_sib_ida	char	36
sb_campagne_sib_sb_stats_sib_1sb_stats_sib_idb	char	36

MySQL sb_campagne_sib_sb_stats_sib_1_c Keys:

name	type	fields
idx_sb_campagne_sib_sb_stats_sib_1_ida1_deleted	index	sb_campagne_sib_sb_stats_sib_1sb_campagne_sib_ida,deleted
idx_sb_campagne_sib_sb_stats_sib_1_idb2_deleted	index	sb_campagne_sib_sb_stats_sib_1sb_stats_sib_idb,deleted
PRIMARY	primary	id
sb_campagne_sib_sb_stats_sib_1_alt	index	sb_campagne_sib_sb_stats_sib_1sb_stats_sib_idb

MySQL sb_liste_sib Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL sb_liste_sib Keys:

name	type	fields
idx_sb_liste_sib_acl_tmst_id	index	acl_team_set_id,deleted
idx_sb_liste_sib_assigned_del	index	assigned_user_id,deleted
idx_sb_liste_sib_del_d_e	index	deleted,date_entered,id
idx_sb_liste_sib_del_d_m	index	deleted,date_modified,id
idx_sb_liste_sib_id_del	index	id,deleted
idx_sb_liste_sib_name_del	index	name,deleted
idx_sb_liste_sib_skey	unique	sync_key
idx_sb_liste_sib_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL sb_liste_sib_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL sb_liste_sib_audit Keys:

name	type	fields
idx_sb_liste_sib_audit_after_value	index	after_value_string
idx_sb_liste_sib_audit_event_id	index	event_id
idx_sb_liste_sib_audit_pa_ev_id	index	parent_id,event_id
idx_sb_liste_sib_audit_parent_id	index	parent_id
PRIMARY	primary	id

MySQL sb_liste_sib_cstm Definitions:

name	type	len
id_c	char	36
email_c	varchar	255
id_sib_c	varchar	255

MySQL sb_liste_sib_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL sb_stats_sib Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL sb_stats_sib Keys:

name	type	fields
idx_sb_stats_sib_acl_tmst_id	index	acl_team_set_id,deleted
idx_sb_stats_sib_assigned_del	index	assigned_user_id,deleted
idx_sb_stats_sib_del_d_e	index	deleted,date_entered,id
idx_sb_stats_sib_del_d_m	index	deleted,date_modified,id
idx_sb_stats_sib_id_del	index	id,deleted
idx_sb_stats_sib_name_del	index	name,deleted
idx_sb_stats_sib_skey	unique	sync_key
idx_sb_stats_sib_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL sb_stats_sib_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL sb_stats_sib_audit Keys:

name	type	fields
idx_sb_stats_sib_audit_after_value	index	after_value_string
idx_sb_stats_sib_audit_event_id	index	event_id
idx_sb_stats_sib_audit_pa_ev_id	index	parent_id,event_id
idx_sb_stats_sib_audit_parent_id	index	parent_id
PRIMARY	primary	id

MySQL sb_stats_sib_cstm Definitions:

name	type	len
id_c	char	36
data_ora_evento_c	varchar	255
email_c	varchar	255
id_sib_c	varchar	255
qta_c	varchar	255
tipo_evento_c	varchar	255
url_cliccato_c	varchar	255

MySQL sb_stats_sib_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL schedulers Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
job	varchar	255
date_time_start	datetime
date_time_end	datetime
job_interval	varchar	100
time_from	time
time_to	time
last_run	datetime
status	varchar	100
catch_up	tinyint	1
system_job	tinyint
sync_key	varchar	100

MySQL schedulers Keys:

name	type	fields
idx_schedule	index	date_time_start,deleted
idx_scheduler_job_interval	index	job_interval
idx_scheduler_status	index	status
idx_schedulers_date_entered	index	date_entered
idx_schedulers_date_modfied	index	date_modified
idx_schedulers_del_d_e	index	deleted,date_entered,id
idx_schedulers_del_d_m	index	deleted,date_modified,id
idx_schedulers_id_del	index	id,deleted
idx_schedulers_name_del	index	name,deleted
idx_schedulers_skey	unique	sync_key
PRIMARY	primary	id

MySQL schedulers_times Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
scheduler_id	char	36	true
execute_time	datetime
status	varchar	25	ready

MySQL schedulers_times Keys:

name	type	fields
idx_scheduler_id	index	scheduler_id,execute_time
PRIMARY	primary	id

MySQL session_active Definitions:

name	type	len
id	char	36
session_id	varchar	100
last_request_time	datetime
session_type	varchar	100
is_violation	tinyint
num_active_sessions	int
date_entered	datetime
date_modified	datetime
deleted	tinyint

MySQL session_active Keys:

name	type	fields
idx_session_id	unique	session_id
PRIMARY	primary	id

MySQL session_history Definitions:

name	type	len
id	char	36
session_id	varchar	100
date_entered	datetime
date_modified	datetime
last_request_time	datetime
session_type	varchar	100
is_violation	tinyint
num_active_sessions	int
deleted	tinyint

MySQL session_history Keys:

name	type	fields
PRIMARY	primary	id

MySQL shift_exceptions Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
timezone	varchar	255
shift_exception_type	varchar	50
all_day	tinyint	1
start_date	date
start_hour	varchar	2
start_minutes	varchar	2
end_date	date
end_hour	varchar	2
end_minutes	varchar	2
enabled	tinyint
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL shift_exceptions Keys:

name	type	fields
idx_shift_exceptions_acl_tmst_id	index	acl_team_set_id,deleted
idx_shift_exceptions_assigned_del	index	assigned_user_id,deleted
idx_shift_exceptions_del_d_e	index	deleted,date_entered,id
idx_shift_exceptions_del_d_m	index	deleted,date_modified,id
idx_shift_exceptions_id_del	index	id,deleted
idx_shift_exceptions_name_del	index	name,deleted
idx_shift_exceptions_skey	unique	sync_key
idx_shift_exceptions_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL shift_exceptions_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL shift_exceptions_audit Keys:

name	type	fields
idx_shift_exceptions_audit_after_value	index	after_value_string
idx_shift_exceptions_audit_event_id	index	event_id
idx_shift_exceptions_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL shift_exceptions_users Definitions:

name	type	len
id	char	36
shift_exception_id	char	36
user_id	char	36
date_modified	datetime
deleted	tinyint

MySQL shift_exceptions_users Keys:

name	type	fields
PRIMARY	primary	id
shift_exceptions_idx_user_id	index	shift_exception_id,user_id

MySQL shifts Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
timezone	varchar	255
date_start	date
date_end	date
sync_key	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
is_open_sunday	tinyint
sunday_open_hour	varchar	2
sunday_open_minutes	varchar	2
sunday_close_hour	varchar	2
sunday_close_minutes	varchar	2
is_open_monday	tinyint	1
monday_open_hour	varchar	2
monday_open_minutes	varchar	2
monday_close_hour	varchar	2
monday_close_minutes	varchar	2
is_open_tuesday	tinyint	1
tuesday_open_hour	varchar	2
tuesday_open_minutes	varchar	2
tuesday_close_hour	varchar	2
tuesday_close_minutes	varchar	2
is_open_wednesday	tinyint	1
wednesday_open_hour	varchar	2
wednesday_open_minutes	varchar	2
wednesday_close_hour	varchar	2
wednesday_close_minutes	varchar	2
is_open_thursday	tinyint	1
thursday_open_hour	varchar	2
thursday_open_minutes	varchar	2
thursday_close_hour	varchar	2
thursday_close_minutes	varchar	2
is_open_friday	tinyint	1
friday_open_hour	varchar	2
friday_open_minutes	varchar	2
friday_close_hour	varchar	2
friday_close_minutes	varchar	2
is_open_saturday	tinyint
saturday_open_hour	varchar	2
saturday_open_minutes	varchar	2
saturday_close_hour	varchar	2
saturday_close_minutes	varchar	2

MySQL shifts Keys:

name	type	fields
idx_shifts_acl_tmst_id	index	acl_team_set_id,deleted
idx_shifts_assigned_del	index	assigned_user_id,deleted
idx_shifts_del_d_e	index	deleted,date_entered,id
idx_shifts_del_d_m	index	deleted,date_modified,id
idx_shifts_id_del	index	id,deleted
idx_shifts_name_del	index	name,deleted
idx_shifts_skey	unique	sync_key
idx_shifts_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL shifts_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL shifts_audit Keys:

name	type	fields
idx_shifts_audit_after_value	index	after_value_string
idx_shifts_audit_event_id	index	event_id
idx_shifts_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL shifts_users Definitions:

name	type	len
id	char	36
shift_id	char	36
user_id	char	36
date_modified	datetime
deleted	tinyint

MySQL shifts_users Keys:

name	type	fields
PRIMARY	primary	id
shift_idx_user_id	index	shift_id,user_id

MySQL shippers Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
list_order	int
default_cost	decimal	26,6
default_cost_usdollar	decimal	26,6
status	varchar	100
sync_key	varchar	100

MySQL shippers Keys:

name	type	fields
idx_shippers_date_entered	index	date_entered
idx_shippers_date_modfied	index	date_modified
idx_shippers_del_d_e	index	deleted,date_entered,id
idx_shippers_del_d_m	index	deleted,date_modified,id
idx_shippers_id_del	index	id,deleted
idx_shippers_name_del	index	name,deleted
idx_shippers_skey	unique	sync_key
PRIMARY	primary	id

MySQL styleguide Definitions:

name	type	len	default
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
salutation	varchar	255
first_name	varchar	255
last_name	varchar	255
title	varchar	255
facebook	varchar	100
twitter	varchar	100
googleplus	varchar	100
department	varchar	255
do_not_call	tinyint
phone_home	varchar	100
phone_mobile	varchar	100
phone_work	varchar	100
phone_other	varchar	100
phone_fax	varchar	100
primary_address_street	varchar	150
primary_address_city	varchar	100
primary_address_state	varchar	100
primary_address_postalcode	varchar	20
primary_address_country	varchar	255
alt_address_street	varchar	150
alt_address_city	varchar	100
alt_address_state	varchar	100
alt_address_postalcode	varchar	20
alt_address_country	varchar	255
assistant	varchar	75
assistant_phone	varchar	100
picture	varchar	255
parent_type	varchar	255
parent_id	char	36
file_mime_type	varchar	100
filename	varchar	255
currency_id	char	36	-99
list_price	decimal	26,6
website	varchar	255
birthdate	date
secret_password	varchar	255
user_email	varchar	100
date_start	datetime
radio_button_group	varchar	255
assigned_user_id	char	36
sync_key	varchar	100

MySQL styleguide Keys:

name	type	fields
idx_styleguide_assigned_del	index	assigned_user_id,deleted
idx_styleguide_date_entered	index	date_entered
idx_styleguide_date_modfied	index	date_modified
idx_styleguide_del_d_e	index	deleted,date_entered,id
idx_styleguide_del_d_m	index	deleted,date_modified,id
idx_styleguide_first_last	index	first_name,last_name,deleted
idx_styleguide_id_del	index	id,deleted
idx_styleguide_last_first	index	last_name,first_name,deleted
idx_styleguide_skey	unique	sync_key
PRIMARY	primary	id

MySQL subscriptions Definitions:

name	type	len	required
id	char	36
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
deleted	tinyint
parent_type	varchar	100
parent_id	char	36	true
sync_key	varchar	100

MySQL subscriptions Keys:

name	type	fields
idx_subscriptions_date_entered	index	date_entered
idx_subscriptions_date_modfied	index	date_modified
idx_subscriptions_del_d_e	index	deleted,date_entered,id
idx_subscriptions_del_d_m	index	deleted,date_modified,id
idx_subscriptions_id_del	index	id,deleted
idx_subscriptions_skey	unique	sync_key
PRIMARY	primary	id
subscription_parent	index	parent_id

MySQL sugar_live Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
enabled_modules	varchar	255
sync_key	varchar	100

MySQL sugar_live Keys:

name	type	fields
idx_sugar_live_del_d_e	index	deleted,date_entered,id
idx_sugar_live_del_d_m	index	deleted,date_modified,id
idx_sugar_live_id_del	index	id,deleted
idx_sugar_live_name_del	index	name,deleted
idx_sugar_live_skey	unique	sync_key
PRIMARY	primary	id

MySQL sugarfavorites Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	varchar	50
deleted	tinyint
module	varchar	50
record_id	char	36
assigned_user_id	char	36
sync_key	varchar	100

MySQL sugarfavorites Keys:

name	type	fields
idx_favs_date_entered	index	date_entered,deleted
idx_favs_id_record_id	index	record_id,id
idx_favs_module_record_deleted	index	module,record_id,deleted
idx_favs_user_module	index	modified_user_id,module,deleted
idx_sugarfavorites_assigned_del	index	assigned_user_id,deleted
idx_sugarfavorites_date_entered	index	date_entered
idx_sugarfavorites_date_modfied	index	date_modified
idx_sugarfavorites_del_d_e	index	deleted,date_entered,id
idx_sugarfavorites_del_d_m	index	deleted,date_modified,id
idx_sugarfavorites_id_del	index	id,deleted
idx_sugarfavorites_name_del	index	name,deleted
idx_sugarfavorites_skey	unique	sync_key
PRIMARY	primary	id

MySQL system_process_lock Definitions:

name	type	len
unique_id	varchar	255
additional_key	varchar	255
date_expires	datetime

MySQL system_process_lock Keys:

name	type	fields
PRIMARY	primary	unique_id,additional_key

MySQL tag_bean_rel Definitions:

name	type	len	required
id	char	36
tag_id	char	36	true
bean_id	char	36	true
bean_module	varchar	100
date_modified	datetime
deleted	tinyint

MySQL tag_bean_rel Keys:

name	type	fields
idx_bid_tid_bm_del	index	bean_id,tag_id,bean_module,deleted
idx_del_tagid_beanid	index	deleted,tag_id,bean_id
idx_tag_bean_rel_del_bean_module_beanid	index	deleted,bean_module,bean_id
idx_tagsrel_tagid_beanid	index	tag_id,bean_id
PRIMARY	primary	id

MySQL tags Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
name_lower	varchar	255
source_id	varchar	255
source_type	varchar	255
source_meta	text
assigned_user_id	char	36
sync_key	varchar	100

MySQL tags Keys:

name	type	fields
idx_tag_name	index	name
idx_tag_name_lower	index	name_lower
idx_tags_assigned_del	index	assigned_user_id,deleted
idx_tags_date_entered	index	date_entered
idx_tags_date_modfied	index	date_modified
idx_tags_del_d_e	index	deleted,date_entered,id
idx_tags_del_d_m	index	deleted,date_modified,id
idx_tags_id_del	index	id,deleted
idx_tags_name_del	index	name,deleted
idx_tags_skey	unique	sync_key
PRIMARY	primary	id

MySQL tags_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL tags_audit Keys:

name	type	fields
idx_tags_audit_after_value	index	after_value_string
idx_tags_audit_event_id	index	event_id
idx_tags_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL tasks Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
status	varchar	100	Not Started
date_due_flag	tinyint
date_due	datetime
date_start_flag	tinyint
date_start	datetime
parent_type	varchar	255
parent_id	char	36
contact_id	char	36
priority	varchar	100
assigned_user_id	char	36
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36
sync_key	varchar	100
dri_workflow_id	char	36
dri_subworkflow_id	char	36
dri_subworkflow_template_id	char	36
dri_workflow_template_id	char	36
dri_workflow_task_template_id	char	36
dri_workflow_sort_order	varchar	255	1
cj_actual_sort_order	varchar	255
customer_journey_score	int
cj_momentum_points	int
cj_momentum_score	int
cj_allow_activity_by	text
customer_journey_progress	float
cj_momentum_ratio	float
customer_journey_points	int		10
cj_parent_activity_type	varchar	255
customer_journey_blocked_by	text
cj_blocked_by_stages	text
is_cj_parent_activity	tinyint
is_customer_journey_activity	tinyint
cj_momentum_start_date	datetime
cj_momentum_end_date	datetime
cj_url	varchar	255
cj_parent_activity_id	char	36
start_next_journey_id	char	36
customer_journey_type	varchar	255
cj_activity_start_date	datetime
cj_activity_completion_date	datetime
cj_days_to_complete	varchar	255

MySQL tasks Keys:

name	type	fields
idx_del_wf_tpl_sub_subtpl_task_name	index	deleted,dri_workflow_id,dri_workflow_template_id,dri_subworkflow_id,dri_subworkflow_template_id,dri_workflow_task_template_id,name
idx_del_wf_tpl_sub_subtpl_task_status	index	deleted,dri_workflow_id,dri_workflow_template_id,dri_subworkflow_id,dri_subworkflow_template_id,dri_workflow_task_template_id,status
idx_task_cj_activity_tpl_id	index	dri_workflow_task_template_id
idx_task_cj_journey_tpl_id	index	dri_workflow_template_id
idx_task_cj_parent_activity	index	deleted,cj_parent_activity_id,cj_parent_activity_type
idx_task_cj_stage_id	index	dri_subworkflow_id
idx_task_cj_stage_tpl_id	index	dri_subworkflow_template_id
idx_task_con_del	index	contact_id,deleted
idx_task_date_due	index	date_due
idx_task_par_del	index	parent_id,parent_type,deleted
idx_task_status	index	status
idx_tasks_acl_tmst_id	index	acl_team_set_id,deleted
idx_tasks_assigned_del	index	assigned_user_id,deleted
idx_tasks_date_entered	index	date_entered
idx_tasks_date_modfied	index	date_modified
idx_tasks_del_d_e	index	deleted,date_entered,id
idx_tasks_del_d_m	index	deleted,date_modified,id
idx_tasks_id_del	index	id,deleted
idx_tasks_name_del	index	name,deleted
idx_tasks_skey	unique	sync_key
idx_tasks_tmst_id	index	team_set_id,deleted
idx_tsk_name	index	deleted,name,date_modified
PRIMARY	primary	id

MySQL tasks_audit Definitions:

name	type	len	required
id	char	36
parent_id	char	36	true
event_id	char	36	true
date_created	datetime
created_by	char	36
date_updated	datetime
field_name	varchar	100
data_type	varchar	100
before_value_string	varchar	255
after_value_string	varchar	255
before_value_text	text
after_value_text	text

MySQL tasks_audit Keys:

name	type	fields
idx_tasks_audit_after_value	index	after_value_string
idx_tasks_audit_event_id	index	event_id
idx_tasks_audit_pa_ev_id	index	parent_id,event_id
PRIMARY	primary	id

MySQL tasks_cstm Definitions:

name	type	len
id_c	char	36
tipologia_task_c	varchar	100
esito_c	varchar	100
creato_automaticamente_c	tinyint
pk_linea_c	varchar	4

MySQL tasks_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL taxrates Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
value	decimal	26,6
list_order	int
status	varchar	100
sync_key	varchar	100

MySQL taxrates Keys:

name	type	fields
idx_taxrates_date_entered	index	date_entered
idx_taxrates_date_modfied	index	date_modified
idx_taxrates_del_d_e	index	deleted,date_entered,id
idx_taxrates_del_d_m	index	deleted,date_modified,id
idx_taxrates_id_del	index	id,deleted
idx_taxrates_name_del	index	name,deleted
idx_taxrates_skey	unique	sync_key
PRIMARY	primary	id

MySQL team_memberships Definitions:

name	type	len
id	char	36
team_id	char	36
user_id	char	36
explicit_assign	tinyint
implicit_assign	tinyint
date_modified	datetime
deleted	tinyint

MySQL team_memberships Keys:

name	type	fields
idx_del_team_user	index	deleted,team_id,user_id
idx_team_membership	index	user_id,team_id
idx_teammemb_team_user	index	team_id,user_id
PRIMARY	primary	id

MySQL team_notices Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
date_start	date
date_end	date
modified_user_id	char	36
created_by	char	36
name	varchar	50
description	text
status	varchar	100
url	varchar	255
url_title	varchar	255
team_id	char	36
team_set_id	char	36
acl_team_set_id	char	36

MySQL team_notices Keys:

name	type	fields
idx_team_notice	index	name,deleted
idx_team_notices_acl_tmst_id	index	acl_team_set_id,deleted
idx_team_notices_tmst_id	index	team_set_id,deleted
PRIMARY	primary	id

MySQL team_set_events Definitions:

name	type	len	required
id	char	36	true
action	varchar	100
params	text
date_created	datetime

MySQL team_set_events Keys:

MySQL team_sets Definitions:

name	type	len
id	char	36
name	varchar	128
team_md5	varchar	32
team_count	int
date_modified	datetime
deleted	tinyint
created_by	char	36

MySQL team_sets Keys:

name	type	fields
idx_team_sets_md5	index	team_md5
PRIMARY	primary	id

MySQL team_sets_modules Definitions:

name	type	len	required
id	char	36
team_set_id	char	36	true
module_table_name	varchar	128	true
deleted	tinyint

MySQL team_sets_modules Keys:

name	type	fields
idx_team_sets_modules	index	team_set_id
PRIMARY	primary	id

MySQL team_sets_teams Definitions:

name	type	len	required
id	char	36
team_set_id	char	36	true
team_id	char	36	true
date_modified	datetime
deleted	tinyint

MySQL team_sets_teams Keys:

name	type	fields
idx_ud_set_id	unique	team_set_id,team_id
idx_ud_team_id	index	team_id
idx_ud_team_id_team_set_id	index	team_id,team_set_id
idx_ud_team_set_id	index	team_set_id
PRIMARY	primary	id

MySQL team_sets_users_1 Definitions:

name	type	len
team_set_id	char	36
user_id	char	36

MySQL team_sets_users_1 Keys:

name	type	fields
idx_tud1_user_id	index	user_id
PRIMARY	primary	team_set_id,user_id

MySQL team_sets_users_2 Definitions:

name	type	len
team_set_id	char	36
user_id	char	36

MySQL team_sets_users_2 Keys:

name	type	fields
idx_tud2_user_id	index	user_id
PRIMARY	primary	team_set_id,user_id

MySQL teams Definitions:

name	type	len
id	char	36
name	varchar	128
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
name_2	varchar	128
associated_user_id	char	36
private	tinyint
sync_key	varchar	100

MySQL teams Keys:

name	type	fields
idx_team_del	index	name
idx_team_del_name	index	deleted,name
idx_teams_date_entered	index	date_entered
idx_teams_date_modfied	index	date_modified
idx_teams_del_d_e	index	deleted,date_entered,id
idx_teams_del_d_m	index	deleted,date_modified,id
idx_teams_id_del	index	id,deleted
idx_teams_name_del	index	name,deleted
idx_teams_skey	unique	sync_key
PRIMARY	primary	id

MySQL time_aware_schedules Definitions:

name	type	len
id	char	36
next_run	datetime
type	varchar	255
module	varchar	255
bean_id	char	36
deleted	tinyint

MySQL time_aware_schedules Keys:

name	type	fields
PRIMARY	primary	id

MySQL timeperiods Definitions:

name	type	len
id	char	36
name	varchar	36
parent_id	char	36
start_date	date
start_date_timestamp	int
end_date	date
end_date_timestamp	int
created_by	char	36
date_entered	datetime
date_modified	datetime
deleted	tinyint
is_fiscal	tinyint
is_fiscal_year	tinyint
leaf_cycle	int
type	varchar	255

MySQL timeperiods Keys:

name	type	fields
idx_del_type_startdate_enddate	index	deleted,type,start_date,end_date
PRIMARY	primary	id

MySQL tracker Definitions:

name	type	len	auto_increment
id	int		1
monitor_id	char	36	true
user_id	char	36
module_name	varchar	255
item_id	char	36
item_summary	varchar	255
team_id	char	36
date_modified	datetime
action	varchar	255
session_id	char	36
visible	tinyint
deleted	tinyint

MySQL tracker Keys:

name	type	fields
idx_tracker_date_modified	index	date_modified
idx_tracker_iid	index	item_id
idx_tracker_monitor_id	index	monitor_id
idx_tracker_userid_del_vis	index	user_id,deleted,visible
idx_tracker_userid_itemid_vis	index	user_id,item_id,visible
idx_tracker_userid_vis_id	index	user_id,visible,id
idx_trckr_mod_uid_dtmod_item	index	module_name,user_id,date_modified,item_id
PRIMARY	primary	id

MySQL tracker_perf Definitions:

name	type	len	auto_increment
id	int		1
monitor_id	char	36	true
server_response_time	double
db_round_trips	int
files_opened	int
memory_usage	int
deleted	tinyint
date_modified	datetime

MySQL tracker_perf Keys:

name	type	fields
idx_tracker_perf_mon_id	index	monitor_id
PRIMARY	primary	id

MySQL tracker_queries Definitions:

name	type	len	auto_increment
id	int		1
query_id	char	36	true
text	text
query_hash	varchar	36
sec_total	double
sec_avg	double
run_count	int
deleted	tinyint
date_modified	datetime

MySQL tracker_queries Keys:

name	type	fields
idx_tracker_queries_query_hash	index	query_hash
idx_tracker_queries_query_id	index	query_id
PRIMARY	primary	id

MySQL tracker_sessions Definitions:

name	type	len	auto_increment
id	int		1
session_id	char	36
date_start	datetime
date_end	datetime
seconds	int
client_ip	varchar	45
user_id	char	36
active	tinyint	1
deleted	tinyint

MySQL tracker_sessions Keys:

name	type	fields
idx_tracker_sessions_active_date	index	active,date_end
idx_tracker_sessions_s_id	index	session_id
idx_tracker_sessions_uas_id	index	user_id,active,session_id
PRIMARY	primary	id

MySQL tracker_tracker_queries Definitions:

name	type	len	auto_increment
id	int		1
monitor_id	char	36
query_id	char	36
date_modified	datetime

MySQL tracker_tracker_queries Keys:

name	type	fields
idx_tracker_tq_monitor	index	monitor_id
idx_tracker_tq_query	index	query_id
PRIMARY	primary	id

MySQL upgrade_history Definitions:

name	type	len
id	char	36
filename	varchar	255
md5sum	varchar	32
type	varchar	30
status	varchar	50
version	varchar	64
name	varchar	255
description	text
id_name	varchar	255
manifest	longtext
patch	text
date_entered	datetime
enabled	tinyint	1
date_modified	datetime
published_date	varchar	50
uninstallable	tinyint	1
deleted	tinyint
process_status	text

MySQL upgrade_history Keys:

name	type	fields
PRIMARY	primary	id
upgrade_history_md5_uk	unique	md5sum

MySQL user_preferences Definitions:

name	type	len	required
id	char	36
category	varchar	50
deleted	tinyint
date_entered	datetime
date_modified	datetime
assigned_user_id	char	36	true
contents	longtext

MySQL user_preferences Keys:

name	type	fields
idx_userprefnamecat	index	assigned_user_id,category
PRIMARY	primary	id

MySQL users Definitions:

name	type	len
id	char	36
user_name	varchar	60
user_hash	varchar	255
system_generated_password	tinyint
pwd_last_changed	datetime
authenticate_id	varchar	100
sugar_login	tinyint	1
picture	varchar	255
first_name	varchar	30
last_name	varchar	30
is_admin	tinyint
external_auth_only	tinyint
receive_notifications	tinyint	1
description	text
date_entered	datetime
date_modified	datetime
last_login	datetime
modified_user_id	char	36
created_by	char	36
title	varchar	50
department	varchar	50
phone_home	varchar	50
phone_mobile	varchar	50
phone_work	varchar	50
phone_other	varchar	50
phone_fax	varchar	50
status	varchar	100
address_street	varchar	150
address_city	varchar	100
address_state	varchar	100
address_country	varchar	100
address_postalcode	varchar	20
default_team	char	36
team_set_id	char	36
deleted	tinyint
portal_only	tinyint
show_on_employees	tinyint	1
employee_status	varchar	100
messenger_id	varchar	100
messenger_type	varchar	100
reports_to_id	char	36
is_group	tinyint
preferred_language	varchar	255
acl_role_set_id	char	36
site_user_id	varchar	64
acl_team_set_id	char	36
license_type	text
business_center_id	char	36
cookie_consent	tinyint
cookie_consent_received_on	datetime
send_email_on_mention	tinyint
sync_key	varchar	100
customer_journey_access	tinyint
customer_journey_last_active	datetime

MySQL users Keys:

name	type	fields
idx_user_cjp_access	index	customer_journey_access,deleted,user_name,is_group,portal_only,status
idx_user_cjp_last_active	index	customer_journey_access,customer_journey_last_active,deleted,user_name,is_group,portal_only,status
idx_user_first_last	index	first_name,last_name,deleted
idx_user_name	index	user_name,is_group,status,last_name,first_name,id
idx_user_type_status	index	status,is_admin,deleted
idx_users_del_businesscenter	index	deleted,business_center_id
idx_users_reports_to_id	index	reports_to_id,id
idx_users_skey	unique	sync_key
PRIMARY	primary	id

MySQL users_cstm Definitions:

name	type	len
id_c	char	36
codice_si5_c	varchar	255
filiera_mktg_c	varchar	100
pk_prezzo_basso_c	varchar	100
pk_email_operativa_c	varchar	180
pk_siglaut_c	varchar	8

MySQL users_cstm Keys:

name	type	fields
PRIMARY	primary	id_c

MySQL users_holidays Definitions:

name	type	len
id	char	36
user_id	char	36
holiday_id	char	36
date_modified	datetime
deleted	tinyint

MySQL users_holidays Keys:

name	type	fields
idx_user_holi_holi	index	holiday_id
PRIMARY	primary	id
users_quotes_alt	index	user_id,holiday_id

MySQL users_last_import Definitions:

name	type	len
id	char	36
assigned_user_id	char	36
import_module	varchar	36
bean_type	varchar	36
bean_id	char	36
deleted	tinyint

MySQL users_last_import Keys:

name	type	fields
idx_user_id	index	assigned_user_id
PRIMARY	primary	id

MySQL users_last_states Definitions:

name	type	len
id	char	36
user_id	char	36
last_state	longtext
platform	varchar	255
deleted	tinyint

MySQL users_last_states Keys:

name	type	fields
idx_users_last_states	index	user_id,platform
PRIMARY	primary	id

MySQL users_password_link Definitions:

name	type	len	default
id	char	36
username	varchar	36
date_generated	datetime
deleted	tinyint
bean_id	char	36
bean_type	varchar	36	User
platform	varchar	36	base

MySQL users_password_link Keys:

name	type	fields
idx_bean_id_users_password_link	index	bean_id
idx_id_deleted_platform	index	id,deleted,platform
idx_username	index	username
PRIMARY	primary	id

MySQL users_signatures Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
user_id	char	36
signature	text
signature_html	text
sync_key	varchar	100

MySQL users_signatures Keys:

name	type	fields
idx_users_signatures_date_entered	index	date_entered
idx_users_signatures_date_modfied	index	date_modified
idx_users_signatures_del_d_e	index	deleted,date_entered,id
idx_users_signatures_del_d_m	index	deleted,date_modified,id
idx_users_signatures_id_del	index	id,deleted
idx_users_signatures_name_del	index	name,deleted
idx_users_signatures_skey	unique	sync_key
idx_usersig_created_by	index	created_by
idx_usersig_uid	index	user_id
PRIMARY	primary	id

MySQL vcals Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
user_id	char	36	true
type	varchar	100
source	varchar	100
content	text

MySQL vcals Keys:

name	type	fields
idx_vcal	index	type,user_id,source
PRIMARY	primary	id

MySQL versions Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	255
file_version	varchar	255
db_version	varchar	255

MySQL versions Keys:

name	type	fields
idx_version	index	name,deleted
PRIMARY	primary	id

MySQL visual_pipeline Definitions:

name	type	len
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
enabled_module	varchar	255
table_header	text
hidden_values	text
tile_header	varchar	50
tile_body_fields	text
records_per_column	varchar	255
available_columns	text
sync_key	varchar	100

MySQL visual_pipeline Keys:

name	type	fields
idx_visual_pipeline_del_d_e	index	deleted,date_entered,id
idx_visual_pipeline_del_d_m	index	deleted,date_modified,id
idx_visual_pipeline_id_del	index	id,deleted
idx_visual_pipeline_name_del	index	name,deleted
idx_visual_pipeline_skey	unique	sync_key
PRIMARY	primary	id

MySQL weblogichooks Definitions:

name	type	len	default
id	char	36
name	varchar	255
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
description	text
deleted	tinyint
webhook_target_module	varchar	255
request_method	varchar	255	POST
url	varchar	255
trigger_event	varchar	255
sync_key	varchar	100

MySQL weblogichooks Keys:

name	type	fields
idx_weblogichooks_date_entered	index	date_entered
idx_weblogichooks_date_modfied	index	date_modified
idx_weblogichooks_del_d_e	index	deleted,date_entered,id
idx_weblogichooks_del_d_m	index	deleted,date_modified,id
idx_weblogichooks_id_del	index	id,deleted
idx_weblogichooks_name_del	index	name,deleted
idx_weblogichooks_skey	unique	sync_key
PRIMARY	primary	id

MySQL workflow Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	50
base_module	varchar	50
status	tinyint
description	text
type	varchar	100
fire_order	varchar	100
parent_id	char	36
record_type	varchar	100
list_order_y	int

MySQL workflow Keys:

name	type	fields
idx_workflow	index	name,deleted
idx_workflow_base_module	index	base_module
idx_workflow_type	index	type
PRIMARY	primary	id

MySQL workflow_actions Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
field	varchar	50
value	text
set_type	varchar	10
adv_type	varchar	10
parent_id	char	36	true
ext1	varchar	50
ext2	varchar	50
ext3	varchar	50

MySQL workflow_actions Keys:

name	type	fields
idx_action	index	deleted
PRIMARY	primary	id

MySQL workflow_actionshells Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
action_type	varchar	100
parent_id	char	36	true
parameters	varchar	255
rel_module	varchar	50
rel_module_type	varchar	10
action_module	varchar	255

MySQL workflow_actionshells Keys:

name	type	fields
idx_actionshell	index	deleted
PRIMARY	primary	id

MySQL workflow_alerts Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
field_value	varchar	50
rel_email_value	varchar	50
rel_module1	varchar	255
rel_module2	varchar	255
rel_module1_type	varchar	10
rel_module2_type	varchar	10
where_filter	tinyint
user_type	varchar	100
array_type	varchar	100
relate_type	varchar	100
address_type	varchar	100
parent_id	char	36	true
user_display_type	varchar	100

MySQL workflow_alerts Keys:

name	type	fields
PRIMARY	primary	id

MySQL workflow_alertshells Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
name	varchar	50
alert_text	text
alert_type	varchar	100
source_type	varchar	100
parent_id	char	36	true
custom_template_id	char	36

MySQL workflow_alertshells Keys:

name	type	fields
PRIMARY	primary	id

MySQL workflow_schedules Definitions:

name	type	len
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
date_expired	datetime
workflow_id	char	36
target_module	varchar	50
bean_id	char	36
parameters	varchar	255

MySQL workflow_schedules Keys:

name	type	fields
PRIMARY	primary	id

MySQL workflow_triggershells Definitions:

name	type	len	required
id	char	36
deleted	tinyint
date_entered	datetime
date_modified	datetime
modified_user_id	char	36
created_by	char	36
field	varchar	50
type	varchar	100
frame_type	varchar	15
eval	text
parent_id	char	36	true
show_past	tinyint
rel_module	varchar	255
rel_module_type	varchar	10
parameters	varchar	255

MySQL workflow_triggershells Keys:

name	type	fields
PRIMARY	primary	id