test

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