Warning: include_once(/vardefs.php): failed to open stream: No such file or directory in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(): Failed opening '/vardefs.php' for inclusion (include_path='/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo:/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/include/..:.:/opt/php7.3/lib/php') in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(/vardefs.php): failed to open stream: No such file or directory in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(): Failed opening '/vardefs.php' for inclusion (include_path='/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo:/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/include/..:.:/opt/php7.3/lib/php') in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(modules/Import/maps/vardefs.php): failed to open stream: No such file or directory in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(): Failed opening 'modules/Import/maps/vardefs.php' for inclusion (include_path='/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo:/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/include/..:.:/opt/php7.3/lib/php') in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(/vardefs.php): failed to open stream: No such file or directory in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(): Failed opening '/vardefs.php' for inclusion (include_path='/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo:/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/include/..:.:/opt/php7.3/lib/php') in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(/vardefs.php): failed to open stream: No such file or directory in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(): Failed opening '/vardefs.php' for inclusion (include_path='/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo:/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/include/..:.:/opt/php7.3/lib/php') in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(/vardefs.php): failed to open stream: No such file or directory in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Warning: include_once(): Failed opening '/vardefs.php' for inclusion (include_path='/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo:/home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/include/..:.:/opt/php7.3/lib/php') in /home/clients/eb44f83daa891a7df5b21b65c140f4f5/aldibo/modules/Administration/DiagnosticRun.php on line 656

Schema listing based on vardefs

Sugar version: 6.5.25 / Sugar DB version: 6.5.25 / Sugar flavor: CE

Table: accounts

Accounts are organizations or entities that are the target of selling, support, and marketing activities, or have already purchased products or services

Column Type Length Required Comment
account_type enum 50 no The Company is of this type
annual_revenue varchar 100 no Annual revenue for this company
assigned_user_id id n/a no User ID assigned to record
billing_address_city varchar 100 no The city used for billing address
billing_address_country varchar n/a no The country used for the billing address
billing_address_postalcode varchar 20 no The postal code used for billing address
billing_address_state varchar 100 no The state used for billing address
billing_address_street varchar 150 no The street address used for billing address
campaign_id id n/a no Campaign that generated Account
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
employees varchar 10 no Number of employees, varchar to accomodate for both number (100) or range (50-100)
id id n/a yes Unique identifier
industry enum 50 no The company belongs in this industry
modified_user_id id n/a no User who last modified record
name varchar 150 yes Name of the Company
ownership varchar 100 no (none)
parent_id id n/a no Account ID of the parent of this account
phone_alternate varchar 100 no An alternate phone number
phone_fax varchar 100 no The fax phone number of this company
phone_office varchar 100 no The office phone number
rating varchar 100 no An arbitrary rating for this company for use in comparisons with others
shipping_address_city varchar 100 no The city used for the shipping address
shipping_address_country varchar n/a no The country used for the shipping address
shipping_address_postalcode varchar 20 no The zip code used for the shipping address
shipping_address_state varchar 100 no The state used for the shipping address
shipping_address_street varchar 150 no The street address used for for shipping purposes
sic_code varchar 10 no SIC code of the account
ticker_symbol varchar 10 no The stock trading (ticker) symbol for the company
website varchar 255 no URL of website for the company

Table: accounts_bugs

Column Type Length Required Comment
id varchar 36 no (none)
account_id varchar 36 no (none)
bug_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: accounts_cases

Column Type Length Required Comment
id varchar 36 no (none)
account_id varchar 36 no (none)
case_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: accounts_contacts

Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
account_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: accounts_opportunities

Column Type Length Required Comment
id varchar 36 no (none)
opportunity_id varchar 36 no (none)
account_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: acl_actions

Determine the allowable actions available to users

Column Type Length Required Comment
aclaccess int 3 no Number specifying access priority; highest access "wins"
acltype varchar 100 no Specifier for Category, usually "module"
category varchar 100 no Category of the allowable action (usually the name of a module)
created_by id 36 no User ID who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
modified_user_id id 36 no User who last modified record
name varchar 150 no Name of the allowable action (view, list, delete, edit)

Table: acl_roles

ACL Role definition

Column Type Length Required Comment
created_by id 36 no User who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no The role description
id id n/a yes Unique identifier
modified_user_id id 36 no User who last modified record
name varchar 150 no The role name

Table: acl_roles_actions

Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
action_id varchar 36 no (none)
access_override int 3 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: acl_roles_users

Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
user_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: adb01_aldibo

Column Type Length Required Comment
account varchar 255 no (none)
aldibo varchar 255 no (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: adb01_aldibo_accounts_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
adb01_aldibo_accountsadb01_aldibo_ida varchar 36 no (none)
adb01_aldibo_accountsaccounts_idb varchar 36 no (none)

Table: address_book

Column Type Length Required Comment
assigned_user_id id n/a yes (none)
bean varchar 50 yes (none)
bean_id id n/a yes (none)

Table: alerts

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
is_read bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
reminder_id id n/a no The id of the reminder that created this alert
target_module varchar n/a no (none)
type varchar n/a no (none)
url_redirect varchar n/a no (none)

Table: am_projecttemplates

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
override_business_hours bool n/a no (none)
priority enum 100 no (none)
status enum 100 no (none)

Table: am_projecttemplates_contacts_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_projecttemplates_ida varchar 36 no (none)
contacts_idb varchar 36 no (none)

Table: am_projecttemplates_project_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_projecttemplates_project_1am_projecttemplates_ida varchar 36 no (none)
am_projecttemplates_project_1project_idb varchar 36 no (none)

Table: am_projecttemplates_users_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_projecttemplates_ida varchar 36 no (none)
users_idb varchar 36 no (none)

Table: am_tasktemplates

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
duration int 255 yes (none)
estimated_effort int 255 no (none)
id id n/a yes Unique identifier
milestone_flag bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
order_number int 255 no (none)
percent_complete int 255 no (none)
predecessors int 255 no (none)
priority enum 100 no (none)
relationship_type enum 100 no (none)
status enum 100 no (none)
task_number int 255 no (none)
utilization enum 100 no (none)

Table: am_tasktemplates_am_projecttemplates_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
am_tasktemplates_am_projecttemplatesam_projecttemplates_ida varchar 36 no (none)
am_tasktemplates_am_projecttemplatesam_tasktemplates_idb varchar 36 no (none)

Table: aobh_businesshours

Column Type Length Required Comment
closing_hours enum 100 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
day enum 100 no (none)
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
open_status bool n/a no (none)
opening_hours enum 100 no (none)

Table: aod_index

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
last_optimised datetime n/a no (none)
location varchar 255 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: aod_indexevent

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
error varchar 255 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
record_id id n/a no (none)
record_module varchar 255 no (none)
success bool n/a no (none)

Table: aok_knowledge_base_categories

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: aok_knowledgebase

Column Type Length Required Comment
additional_info text n/a no Full text of the note
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
revision varchar 255 no (none)
status enum 100 no (none)
user_id1_c id 36 no (none)
user_id_c id 36 no (none)

Table: aok_knowledgebase_categories

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aok_knowledgebase_id varchar 36 no (none)
aok_knowledge_base_categories_id varchar 36 no (none)

Table: aop_case_events

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
case_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: aop_case_updates

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
case_id id n/a no (none)
contact_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
internal bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: aor_charts

Column Type Length Required Comment
aor_report_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
type enum 100 no (none)
x_field int n/a no (none)
y_field int n/a no (none)

Table: aor_conditions

Column Type Length Required Comment
aor_report_id id 36 no (none)
condition_order int 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
field enum 100 no (none)
id id n/a yes Unique identifier
logic_op varchar n/a no (none)
modified_user_id id n/a no User who last modified record
module_path longtext n/a no (none)
name varchar 255 yes (none)
operator enum 100 no (none)
parameter bool n/a no (none)
parenthesis varchar n/a no (none)
value varchar 255 no (none)
value_type enum 100 no (none)

Table: aor_fields

Column Type Length Required Comment
aor_report_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
display bool n/a no (none)
field enum 100 no (none)
field_function enum 100 no (none)
field_order int 255 no (none)
format varchar 100 no (none)
group_by bool n/a no (none)
group_display int n/a no (none)
group_order enum 100 no (none)
id id n/a yes Unique identifier
label varchar 255 no (none)
link bool n/a no (none)
modified_user_id id n/a no User who last modified record
module_path longtext n/a no (none)
name varchar 255 yes (none)
sort_by enum 100 no (none)
sort_order enum 100 no (none)
total enum 100 no (none)

Table: aor_reports

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
graphs_per_row int n/a yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
report_module enum 100 yes (none)

Table: aor_scheduled_reports

Column Type Length Required Comment
aor_report_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
email_recipients longtext n/a no (none)
id id n/a yes Unique identifier
last_run readonly n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
schedule varchar 100 yes (none)
status enum 100 no (none)

Table: aos_contracts

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
call_id id 36 no (none)
company_signed_date date n/a no (none)
contact_id id 36 no (none)
contract_account_id id 36 no (none)
contract_type enum 100 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
customer_signed_date date n/a no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
end_date date n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
opportunity_id id 36 no (none)
reference_code varchar 255 no (none)
renewal_reminder_date datetime n/a no (none)
shipping_amount currency 26,6 no (none)
shipping_amount_usdollar currency 26,6 no (none)
shipping_tax enum 100 no (none)
shipping_tax_amt currency 26,6 no (none)
shipping_tax_amt_usdollar currency 26,6 no (none)
start_date date n/a no (none)
status enum 100 yes (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)
total_contract_value currency 26,6 no (none)
total_contract_value_usdollar currency 26,6 no (none)

Table: aos_contracts_documents

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_contracts_id varchar 36 no (none)
documents_id varchar 36 no (none)
document_revision_id varchar 36 no (none)

Table: aos_invoices

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
billing_account_id id 36 no (none)
billing_address_city varchar 100 no The city used for billing address
billing_address_country varchar n/a no The country used for the billing address
billing_address_postalcode varchar 20 no The postal code used for billing address
billing_address_state varchar 100 no The state used for billing address
billing_address_street varchar 150 no The street address used for billing address
billing_contact_id id 36 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
due_date date n/a no (none)
id id n/a yes Unique identifier
invoice_date date n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
number int 11 yes (none)
quote_date date n/a no (none)
quote_number int 11 no (none)
shipping_address_city varchar 100 no The city used for the shipping address
shipping_address_country varchar n/a no The country used for the shipping address
shipping_address_postalcode varchar 20 no The zip code used for the shipping address
shipping_address_state varchar 100 no The state used for the shipping address
shipping_address_street varchar 150 no The street address used for for shipping purposes
shipping_amount currency 26,6 no (none)
shipping_amount_usdollar currency 26,6 no (none)
shipping_tax enum 100 no (none)
shipping_tax_amt currency 26,6 no (none)
shipping_tax_amt_usdollar currency 26,6 no (none)
status enum 100 no (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no Formatted amount of the opportunity
subtotal_tax_amount currency 26,6 no (none)
subtotal_tax_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
template_ddown_c multienum n/a no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)

Table: aos_line_item_groups

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 no (none)
number int 11 no (none)
parent_id id 36 no (none)
parent_type varchar 100 no (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no (none)
subtotal_tax_amount currency 26,6 no (none)
subtotal_tax_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)

Table: aos_pdf_templates

Column Type Length Required Comment
active bool n/a no (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description longtext n/a no Full text of the note
id id n/a yes Unique identifier
margin_bottom int 255 no (none)
margin_footer int 255 no (none)
margin_header int 255 no (none)
margin_left int 255 no (none)
margin_right int 255 no (none)
margin_top int 255 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
orientation enum 100 no (none)
page_size enum 100 no (none)
pdffooter text n/a no (none)
pdfheader text n/a no (none)
type enum 100 yes (none)

Table: aos_product_categories

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
is_parent bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parent_category_id id n/a no (none)

Table: aos_products

Column Type Length Required Comment
aos_product_category_id id n/a no (none)
assigned_user_id id n/a no User ID assigned to record
category enum 100 no (none)
contact_id id 36 no (none)
cost currency 26,6 no (none)
cost_usdollar currency 26,6 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
maincode enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
part_number varchar 25 no (none)
price currency 26,6 yes (none)
price_usdollar currency 26,6 no (none)
product_image varchar 255 no File name associated with the note (attachment)
type enum 100 no (none)
url varchar 255 no (none)

Table: aos_products_quotes

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount enum 255 no (none)
group_id id 36 no (none)
id id n/a yes Unique identifier
item_description text n/a no (none)
modified_user_id id n/a no User who last modified record
name text n/a yes (none)
number int 11 no (none)
parent_id id 36 no (none)
parent_type varchar 100 no (none)
part_number varchar 255 no (none)
product_cost_price currency 26,6 no (none)
product_cost_price_usdollar currency 26,6 no (none)
product_discount currency 26,6 no (none)
product_discount_amount currency 26,6 no (none)
product_discount_amount_usdollar currency 26,6 no (none)
product_discount_usdollar currency 26,6 no (none)
product_id id 36 no (none)
product_list_price currency 26,6 no (none)
product_list_price_usdollar currency 26,6 no (none)
product_qty decimal 18 no (none)
product_total_price currency 26,6 yes (none)
product_total_price_usdollar currency 26,6 no (none)
product_unit_price currency 26,6 yes (none)
product_unit_price_usdollar currency 26,6 no (none)
vat enum 100 no (none)
vat_amt currency 26,6 yes (none)
vat_amt_usdollar currency 26,6 no (none)

Table: aos_quotes

Column Type Length Required Comment
approval_issue text n/a no (none)
approval_status enum 100 no (none)
assigned_user_id id n/a no User ID assigned to record
billing_account_id id 36 no (none)
billing_address_city varchar 100 no The city used for billing address
billing_address_country varchar n/a no The country used for the billing address
billing_address_postalcode varchar 20 no The postal code used for billing address
billing_address_state varchar 100 no The state used for billing address
billing_address_street varchar 150 no The street address used for billing address
billing_contact_id id 36 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
discount_amount currency 26,6 no (none)
discount_amount_usdollar currency 26,6 no (none)
expiration date n/a yes (none)
id id n/a yes Unique identifier
invoice_status enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
number int 11 no (none)
opportunity_id id 36 no (none)
shipping_address_city varchar 100 no The city used for the shipping address
shipping_address_country varchar n/a no The country used for the shipping address
shipping_address_postalcode varchar 20 no The zip code used for the shipping address
shipping_address_state varchar 100 no The state used for the shipping address
shipping_address_street varchar 150 no The street address used for for shipping purposes
shipping_amount currency 26,6 no (none)
shipping_amount_usdollar currency 26,6 no (none)
shipping_tax enum 100 no (none)
shipping_tax_amt currency 26,6 no (none)
shipping_tax_amt_usdollar currency 26,6 no (none)
stage enum 100 yes (none)
subtotal_amount currency 26,6 no (none)
subtotal_amount_usdollar currency 26,6 no (none)
subtotal_tax_amount currency 26,6 no (none)
subtotal_tax_amount_usdollar currency 26,6 no (none)
tax_amount currency 26,6 no (none)
tax_amount_usdollar currency 26,6 no (none)
template_ddown_c multienum n/a no (none)
term enum 100 no (none)
terms_c text n/a no (none)
total_amount currency 26,6 no (none)
total_amount_usdollar currency 26,6 no (none)
total_amt currency 26,6 no (none)
total_amt_usdollar currency 26,6 no (none)

Table: aos_quotes_aos_invoices_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_quotes77d9_quotes_ida varchar 36 no (none)
aos_quotes6b83nvoices_idb varchar 36 no (none)

Table: aos_quotes_os_contracts_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_quotese81e_quotes_ida varchar 36 no (none)
aos_quotes4dc0ntracts_idb varchar 36 no (none)

Table: aos_quotes_project_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
aos_quotes1112_quotes_ida varchar 36 no (none)
aos_quotes7207project_idb varchar 36 no (none)

Table: aow_actions

Column Type Length Required Comment
action enum 100 no (none)
action_order int 255 no (none)
aow_workflow_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parameters longtext n/a no (none)

Table: aow_conditions

Column Type Length Required Comment
aow_workflow_id id 36 no (none)
condition_order int 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
field enum 100 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
module_path longtext n/a no (none)
name varchar 255 yes (none)
operator enum 100 no (none)
value varchar 255 no (none)
value_type varchar 255 no (none)

Table: aow_processed

Column Type Length Required Comment
aow_workflow_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parent_id id 36 no (none)
parent_type varchar 100 no (none)
status enum 100 no (none)

Table: aow_processed_aow_actions

Column Type Length Required Comment
id varchar 36 no (none)
aow_processed_id varchar 36 no (none)
aow_action_id varchar 36 no (none)
status varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: aow_workflow

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
flow_module enum 100 yes (none)
flow_run_on enum 100 yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
multiple_runs bool n/a no (none)
name varchar 255 yes (none)
run_when enum 100 no (none)
status enum 100 no (none)

Table: bugs

Bugs are defects in products and services

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
bug_number int 11 yes Visual unique identifier
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
fixed_in_release enum n/a no The software or service release that corrected the bug
found_in_release enum n/a no The software or service release that manifested the bug
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes The short description of the bug
priority enum 100 no An indication of the priorty of the issue
product_category enum 255 no Where the bug was discovered (ex: Accounts, Contacts, Leads)
resolution enum 255 no An indication of how the issue was resolved
source enum 255 no An indicator of how the bug was entered (ex: via web, email, etc.)
status enum 100 no The status of the issue
type enum 255 no The type of issue (ex: issue, feature)
work_log text n/a no Free-form text used to denote activities of interest

Table: calls

A Call is an activity representing a phone call

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_end datetime n/a no Date is which call is scheduled to (or did) end
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a yes Date in which call is schedule to (or did) start
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
direction enum 100 no Indicates whether call is inbound or outbound
duration_hours int 2 yes Call duration, hours portion
duration_minutes int 2 no Call duration, minutes portion
email_reminder_sent bool n/a no Whether email reminder is already sent
email_reminder_time int n/a no Specifies when a email reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 50 yes Brief description of the call
outlook_id varchar 255 no When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID
parent_id id n/a no The ID of the parent Sugar object identified by parent_type
parent_type varchar 255 no The Sugar object to which the call is related
recurring_source varchar 36 no Source of recurring call
reminder_time int n/a no Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
repeat_count int 7 no Number of recurrence
repeat_dow varchar 7 no Days of week in recurrence
repeat_interval int 3 no Interval of recurrence
repeat_parent_id id 36 no Id of the first element of recurring records
repeat_type enum 36 no Type of recurrence
repeat_until date n/a no Repeat until specified date
status enum 100 yes The status of the call (Held, Not Held, etc.)

Table: calls_contacts

Column Type Length Required Comment
id varchar 36 no (none)
call_id varchar 36 no (none)
contact_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: calls_leads

Column Type Length Required Comment
id varchar 36 no (none)
call_id varchar 36 no (none)
lead_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: calls_reschedule

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
call_id id 36 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
reason enum 100 no (none)

Table: calls_users

Column Type Length Required Comment
id varchar 36 no (none)
call_id varchar 36 no (none)
user_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: campaign_log

Tracks items of interest that occurred after you send an email campaign

Column Type Length Required Comment
activity_date datetime n/a no The date the activity occurred
activity_type enum 100 no The activity that occurred (e.g., Viewed Message, Bounced, Opted out)
archived bool n/a no Indicates if item has been archived
campaign_id id n/a no Campaign identifier
date_modified datetime n/a no (none)
deleted bool n/a no Record deletion indicator
hits int n/a no Number of times the item has been invoked (e.g., multiple click-thrus)
id id n/a yes Unique identifier
list_id id 36 no The target list from which item originated
marketing_id id n/a no ID of marketing email this entry is associated with
more_information varchar 100 no (none)
related_id varchar 36 no (none)
related_type varchar 100 no (none)
target_id varchar 36 no Identifier of target record
target_tracker_key varchar 36 no Identifier of Tracker URL
target_type varchar 100 no Descriptor of the target record type (e.g., Contact, Lead)

Table: campaign_trkrs

Maintains the Tracker URLs used in campaign emails

Column Type Length Required Comment
campaign_id id n/a no The ID of the campaign
created_by id n/a no User ID who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
is_optout bool n/a yes Indicator whether tracker URL represents an opt-out link
modified_user_id id n/a no User who last modified record
tracker_key int 11 yes Internal key to uniquely identifier the tracker URL
tracker_name varchar 255 no The name of the campaign tracker
tracker_url varchar 255 no The URL that represents the landing page when the tracker URL in the campaign email is clicked

Table: campaigns

Campaigns are a series of operations undertaken to accomplish a purpose, usually acquiring leads

Column Type Length Required Comment
actual_cost double n/a no Actual cost of the campaign
assigned_user_id id n/a no User ID assigned to record
budget double n/a no Budgeted amount for the campaign
campaign_type enum 100 yes The type of campaign
content text n/a no The campaign description
created_by id n/a no User who created record
currency_id id n/a no Currency in use for the campaign
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
end_date date n/a yes Ending date of the campaign
expected_cost double n/a no Expected cost of the campaign
expected_revenue double n/a no Expected revenue stemming from the campaign
frequency enum 100 no Frequency of the campaign
id id n/a yes Unique identifier
impressions int n/a no Expected Click throughs manually entered by Campaign Manager
modified_user_id id n/a no User who last modified record
name varchar 255 yes The name of the campaign
objective text n/a no The objective of the campaign
refer_url varchar 255 no The URL referenced in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)
start_date date n/a no Starting date of the campaign
status enum 100 yes Status of the campaign
survey_id id n/a no (none)
tracker_count int 11 no The number of accesses made to the tracker URL; no longer used as of 4.2 (see campaign_trkrs)
tracker_key int 11 yes The internal ID of the tracker used in a campaign; no longer used as of 4.2 (see campaign_trkrs)
tracker_text varchar 255 no The text that appears in the tracker URL; no longer used as of 4.2 (see campaign_trkrs)

Table: cases

Cases are issues or problems that a customer asks a support representative to resolve

Column Type Length Required Comment
account_id id n/a no The account to which the case is associated
assigned_user_id id n/a no User ID assigned to record
case_number int 11 yes Visual unique identifier
contact_created_by_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the description
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes The short description of the bug
priority enum 100 no The priority of the case
resolution text n/a no The resolution of the case
state enum 100 no The state of the case (i.e. open/closed)
status dynamicenum 100 no The status of the case
type enum 255 no The type of issue (ex: issue, feature)
work_log text n/a no Free-form text used to denote activities of interest

Table: cases_bugs

Column Type Length Required Comment
id varchar 36 no (none)
case_id varchar 36 no (none)
bug_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: config

System table containing system-wide definitions

Column Type Length Required Comment
category varchar 32 no Settings are grouped under this category; arbitraily defined based on requirements
name varchar 32 no The name given to the setting
value text n/a no The value given to the setting

Table: contacts

Column Type Length Required Comment
alt_address_city varchar 100 no City for alternate address
alt_address_country varchar n/a no Country for alternate address
alt_address_postalcode varchar 20 no Postal code for alternate address
alt_address_state varchar 100 no State for alternate address
alt_address_street varchar 150 no Street address for alternate address
assigned_user_id id n/a no User ID assigned to record
assistant varchar 75 no Name of the assistant of the contact
assistant_phone varchar 100 no Phone number of the assistant of the contact
birthdate date n/a no The birthdate of the contact
campaign_id id n/a no Campaign that generated lead
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_reviewed date n/a no (none)
deleted bool n/a no Record deletion indicator
department varchar 255 no The department of the contact
description text n/a no Full text of the note
do_not_call bool n/a no An indicator of whether contact can be called
first_name varchar 100 no First name of the contact
id id n/a yes Unique identifier
joomla_account_id varchar 255 no (none)
last_name varchar 100 yes Last name of the contact
lawful_basis multienum 100 no (none)
lawful_basis_source enum 100 no (none)
lead_source enum 255 no How did the contact come about
modified_user_id id n/a no User who last modified record
phone_fax varchar 100 no Contact fax number
phone_home varchar 100 no Home phone number of the contact
phone_mobile varchar 100 no Mobile phone number of the contact
phone_other varchar 100 no Other phone number for the contact
phone_work varchar 100 no Work phone number of the contact
photo varchar 255 no (none)
portal_account_disabled bool n/a no (none)
portal_user_type enum 100 no (none)
primary_address_city varchar 100 no City for primary address
primary_address_country varchar n/a no Country for primary address
primary_address_postalcode varchar 20 no Postal code for primary address
primary_address_state varchar 100 no State for primary address
primary_address_street varchar 150 no Street address for primary address
reports_to_id id n/a no The contact this contact reports to
salutation enum 255 no Contact salutation (e.g., Mr, Ms)
title varchar 100 no The title of the contact

Table: contacts_bugs

Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
bug_id varchar 36 no (none)
contact_role varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: contacts_cases

Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
case_id varchar 36 no (none)
contact_role varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: contacts_users

Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
user_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: cron_remove_documents

Column Type Length Required Comment
id varchar 36 no (none)
bean_id varchar 36 no (none)
module varchar 25 no (none)
date_modified datetime n/a no (none)

Table: currencies

Currencies allow Sugar to store and display monetary values in various denominations

Column Type Length Required Comment
conversion_rate double n/a yes Conversion rate factor (relative to stored value)
created_by id 36 yes User ID who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifer
iso4217 varchar 3 no 3-letter identifier specified by ISO 4217 (ex: USD)
name varchar 36 yes Name of the currency
status varchar 100 no Currency status
symbol varchar 36 yes Symbol representing the currency

Table: custom_fields

Column Type Length Required Comment
bean_id varchar 36 no (none)
set_num int 11 no (none)
field0 varchar 255 no (none)
field1 varchar 255 no (none)
field2 varchar 255 no (none)
field3 varchar 255 no (none)
field4 varchar 255 no (none)
field5 varchar 255 no (none)
field6 varchar 255 no (none)
field7 varchar 255 no (none)
field8 varchar 255 no (none)
field9 varchar 255 no (none)
deleted bool 1 no (none)

Table: d1_detail

Column Type Length Required Comment
aos_products_id_c id 36 no (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
kit_vis varchar 255 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 no (none)
nb_bout decimal 18 no (none)
nb_cont decimal 18 no (none)
nb_testing decimal 18 no (none)
prix_hab decimal 18 no (none)
prix_neg decimal 18 no (none)
tx_trans decimal 18 no (none)
ventes decimal 18 no (none)

Table: d1_detail_h1_header_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
d1_detail_h1_headerd1_detail_ida varchar 36 no (none)
d1_detail_h1_headerh1_header_idb varchar 36 no (none)

Table: document_revisions

Column Type Length Required Comment
change_log varchar 255 no (none)
date_entered datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
doc_id varchar 100 no Document ID from documents web server provider
doc_type enum 100 no Document type (ex: Google, box.net, IBM SmartCloud)
doc_url varchar 255 no Document URL from documents web server provider
document_id varchar 36 no (none)
file_ext varchar 100 no (none)
file_mime_type varchar 100 no (none)
filename varchar 255 yes (none)
id varchar 36 yes (none)
revision varchar 100 no (none)

Table: documents

Column Type Length Required Comment
active_date date n/a yes (none)
assigned_user_id id n/a no User ID assigned to record
category_id enum 100 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
doc_id varchar 100 no Document ID from documents web server provider
doc_type enum 100 no Document type (ex: Google, box.net, IBM SmartCloud)
doc_url varchar 255 no Document URL from documents web server provider
document_name varchar 255 yes (none)
document_revision_id varchar 36 no (none)
exp_date date n/a no (none)
id id n/a yes Unique identifier
is_template bool n/a no (none)
modified_user_id id n/a no User who last modified record
related_doc_id id 36 no (none)
related_doc_rev_id id 36 no (none)
status_id enum 100 no (none)
subcategory_id enum 100 no (none)
template_type enum 100 no (none)

Table: documents_accounts

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
account_id varchar 36 no (none)

Table: documents_bugs

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
bug_id varchar 36 no (none)

Table: documents_cases

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
case_id varchar 36 no (none)

Table: documents_contacts

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
contact_id varchar 36 no (none)

Table: documents_opportunities

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
document_id varchar 36 no (none)
opportunity_id varchar 36 no (none)

Table: eapm

Column Type Length Required Comment
api_data text n/a no Any API data that the external API may wish to store on a per-user basis
application enum 100 yes (none)
assigned_user_id id n/a no User ID assigned to record
consumer_key varchar n/a no (none)
consumer_secret varchar n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 no (none)
oauth_secret varchar n/a no (none)
oauth_token varchar n/a no (none)
password encrypt 255 yes (none)
url varchar 255 yes (none)
validated bool n/a no (none)

Table: email_addr_bean_rel

Column Type Length Required Comment
id id n/a yes (none)
email_address_id id n/a yes (none)
bean_id id n/a yes (none)
bean_module varchar 100 yes (none)
primary_address bool n/a no (none)
reply_to_address bool n/a no (none)
date_created datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)

Table: email_addresses

Column Type Length Required Comment
confirm_opt_in enum n/a no (none)
confirm_opt_in_date datetime n/a no (none)
confirm_opt_in_fail_date datetime n/a no (none)
confirm_opt_in_sent_date datetime n/a no (none)
confirm_opt_in_token varchar 255 no (none)
date_created datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
email_address varchar n/a yes (none)
email_address_caps varchar n/a yes (none)
id id n/a yes (none)
invalid_email bool n/a no (none)
opt_out bool n/a no (none)

Table: email_addresses

Column Type Length Required Comment
confirm_opt_in enum n/a no (none)
confirm_opt_in_date datetime n/a no (none)
confirm_opt_in_fail_date datetime n/a no (none)
confirm_opt_in_sent_date datetime n/a no (none)
confirm_opt_in_token varchar 255 no (none)
date_created datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
email_address varchar n/a yes (none)
email_address_caps varchar n/a yes (none)
id id n/a yes (none)
invalid_email bool n/a no (none)
opt_out bool n/a no (none)

Table: email_cache

Column Type Length Required Comment
answered tinyint 1 yes (none)
deleted tinyint 1 no (none)
draft tinyint 1 yes (none)
flagged tinyint 1 yes (none)
fromaddr varchar 100 no (none)
ie_id id n/a no (none)
imap_uid uint 32 yes (none)
mailsize uint 16 yes (none)
mbox varchar 60 yes (none)
message_id varchar 255 no (none)
msgno uint 32 no (none)
recent tinyint 1 yes (none)
seen tinyint 1 yes (none)
senddate datetime n/a no (none)
subject varchar 255 no (none)
toaddr varchar 255 no (none)

Table: email_marketing

Column Type Length Required Comment
all_prospect_lists bool n/a no (none)
campaign_id id n/a no (none)
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
date_start datetime n/a yes (none)
deleted bool n/a no (none)
from_addr varchar 100 yes (none)
from_name varchar 100 yes (none)
id id n/a yes (none)
inbound_email_id varchar 36 no (none)
modified_user_id id n/a no (none)
name varchar 255 yes (none)
outbound_email_id id n/a no (none)
reply_to_addr varchar 100 no (none)
reply_to_name varchar 100 no (none)
status enum 100 yes (none)
template_id id n/a yes (none)

Table: email_marketing_prospect_lists

Column Type Length Required Comment
id varchar 36 no (none)
prospect_list_id varchar 36 no (none)
email_marketing_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: email_templates

Templates used in email processing

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
body longtext n/a no Plain text body to be used in resulting email
body_html longtext n/a no HTML formatted email body to be used in resulting email
created_by varchar 36 no User who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Email template description
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes Email template name
published varchar 3 no (none)
subject varchar 255 no Email subject to be used in resulting email
text_only bool n/a no Should be checked if email template is to be sent in text only
type enum n/a no Type of the email template

Table: emailman

Email campaign queue

Column Type Length Required Comment
campaign_id id n/a no ID of related campaign
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
id int 11 no Unique identifier
in_queue bool n/a no Flag indicating if item still in queue
in_queue_date datetime n/a no Datetime in which item entered queue
list_id id 36 no Associated list
marketing_id id n/a no (none)
modified_user_id id 36 no User ID who last modified record
related_confirm_opt_in bool n/a no (none)
related_id id n/a no ID of Sugar object to which this item is related
related_type varchar 100 no Descriptor of the Sugar object indicated by related_id
send_attempts int n/a no Number of attempts made to send this item
send_date_time datetime n/a no (none)
user_id id 36 no User ID representing assigned-to user

Table: emails

Contains a record of emails sent to and from the Sugar application

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
category_id enum 100 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_sent_received datetime n/a no (none)
deleted bool n/a no Record deletion indicator
flagged bool n/a no flagged status
id id n/a yes Unique identifier
intent varchar 100 no Target of action used in Inbound Email assignment
last_synced datetime n/a no The last date and time the email was synced with the server
mailbox_id id 36 no (none)
message_id varchar 255 no ID of the email item obtained from the email transport system
modified_user_id id n/a no User who last modified record
name varchar 255 no The subject of the email
orphaned bool n/a no Emails which exists in the SuiteCRM but have been deleted from the email server
parent_id id 36 no ID of Sugar object referenced by parent_type (deprecated as of 4.2)
parent_type varchar 100 no Identifier of Sugar module to which this email is associated (deprecated as of 4.2)
reply_to_status bool n/a no I you reply to an email then reply to status of original email is set
status enum 100 no (none)
type enum 100 no Type of email (ex: draft)
uid varchar n/a no (none)

Table: emails_beans

Column Type Length Required Comment
id id 36 no (none)
email_id id 36 no FK to emails table
bean_id id 36 no FK to various beans's tables
bean_module varchar 100 no bean's Module
campaign_data text n/a no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: emails_email_addr_rel

Normalization of multi-address fields such as To:, CC:, BCC

Column Type Length Required Comment
address_type varchar 4 yes Type of entry, TO, CC, or BCC
deleted bool n/a no (none)
email_address_id id n/a yes Foriegn key to emails table NOT unique
email_id id n/a yes Foriegn key to emails table NOT unique
id id n/a yes GUID

Table: emails_text

Large email text fields

Column Type Length Required Comment
bcc_addrs text n/a no Email address(es) of person(s) to receive a blind carbon copy of the email
cc_addrs text n/a no Email address(es) of person(s) to receive a carbon copy of the email
deleted bool n/a no (none)
description longtext n/a no Email body in plain text
description_html longhtml n/a no Email body in HTML format
email_id id 36 yes Foriegn key to emails table
from_addr varchar 250 no Email address of person who send the email
raw_source longtext n/a no Full raw source of email
reply_to_addr varchar 250 no reply to email address
to_addrs text n/a no Email address(es) of person(s) to receive the email

Table: emails_text

Large email text fields

Column Type Length Required Comment
bcc_addrs text n/a no Email address(es) of person(s) to receive a blind carbon copy of the email
cc_addrs text n/a no Email address(es) of person(s) to receive a carbon copy of the email
deleted bool n/a no (none)
description longtext n/a no Email body in plain text
description_html longhtml n/a no Email body in HTML format
email_id id 36 yes Foriegn key to emails table
from_addr varchar 250 no Email address of person who send the email
raw_source longtext n/a no Full raw source of email
reply_to_addr varchar 250 no reply to email address
to_addrs text n/a no Email address(es) of person(s) to receive the email

Table: favorites

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
parent_id id n/a no Favorite ID of the parent of this account
parent_type varchar 255 no The Sugar object to which the call is related

Table: fields_meta_data

Column Type Length Required Comment
audited bool n/a no (none)
comments varchar 255 no (none)
custom_module varchar 255 no (none)
date_modified datetime 255 no (none)
default_value varchar 255 no (none)
deleted bool n/a no (none)
duplicate_merge short n/a no (none)
ext1 varchar 255 no (none)
ext2 varchar 255 no (none)
ext3 varchar 255 no (none)
ext4 text n/a no (none)
help varchar 255 no (none)
id varchar 255 no (none)
importable varchar 255 no (none)
len int 11 no (none)
massupdate bool n/a no (none)
name varchar 255 no (none)
reportable bool n/a no (none)
required bool n/a no (none)
type varchar 255 no (none)
vname varchar 255 no (none)

Table: folders

Column Type Length Required Comment
id id n/a yes (none)
name varchar 255 yes (none)
folder_type varchar 25 no (none)
parent_folder id n/a no (none)
has_child bool n/a no (none)
is_group bool n/a no (none)
is_dynamic bool n/a no (none)
dynamic_query text n/a no (none)
assign_to_id id n/a no (none)
created_by id n/a yes (none)
modified_by id n/a yes (none)
deleted bool n/a no (none)

Table: folders_rel

Column Type Length Required Comment
id id n/a yes (none)
folder_id id n/a yes (none)
polymorphic_module varchar 25 yes (none)
polymorphic_id id n/a yes (none)
deleted bool n/a no (none)

Table: folders_subscriptions

Column Type Length Required Comment
id id n/a yes (none)
folder_id id n/a yes (none)
assigned_user_id id n/a yes (none)

Table: fp_event_locations

Column Type Length Required Comment
address varchar 255 yes (none)
address_city varchar 100 yes (none)
address_country varchar 100 no (none)
address_postalcode varchar 20 yes (none)
address_state varchar 100 no (none)
assigned_user_id id n/a no User ID assigned to record
capacity varchar 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: fp_event_locations_fp_events_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_event_locations_fp_events_1fp_event_locations_ida varchar 36 no (none)
fp_event_locations_fp_events_1fp_events_idb varchar 36 no (none)

Table: fp_events

Column Type Length Required Comment
accept_redirect varchar 255 no (none)
activity_status_type enum 255 no (none)
assigned_user_id id n/a no User ID assigned to record
budget currency 26 no (none)
created_by id n/a no User who created record
currency_id id 36 no (none)
date_end datetime n/a no Date meeting ends
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a yes Date of start of meeting
decline_redirect varchar 255 no (none)
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
duration_hours int 3 yes Duration (hours)
duration_minutes int 2 no Duration (minutes)
id id n/a yes Unique identifier
invite_templates enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: fp_events_contacts_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_contactsfp_events_ida varchar 36 no (none)
fp_events_contactscontacts_idb varchar 36 no (none)
invite_status varchar 25 no (none)
accept_status varchar 25 no (none)
email_responded int 2 no (none)

Table: fp_events_fp_event_delegates_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_fp_event_delegates_1fp_events_ida varchar 36 no (none)
fp_events_fp_event_delegates_1fp_event_delegates_idb varchar 36 no (none)

Table: fp_events_fp_event_locations_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_fp_event_locations_1fp_events_ida varchar 36 no (none)
fp_events_fp_event_locations_1fp_event_locations_idb varchar 36 no (none)

Table: fp_events_leads_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_leads_1fp_events_ida varchar 36 no (none)
fp_events_leads_1leads_idb varchar 36 no (none)
invite_status varchar 25 no (none)
accept_status varchar 25 no (none)
email_responded int 2 no (none)

Table: fp_events_prospects_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
fp_events_prospects_1fp_events_ida varchar 36 no (none)
fp_events_prospects_1prospects_idb varchar 36 no (none)
invite_status varchar 25 no (none)
accept_status varchar 25 no (none)
email_responded int 2 no (none)

Table: h1_header

Column Type Length Required Comment
account_id_c id 36 no (none)
assigned_user_id id n/a no User ID assigned to record
cap_etab decimal 18 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
h_deb datetime n/a no (none)
h_fin datetime n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
moy_age decimal 18 no (none)
name varchar 255 yes (none)
nb_pers decimal 18 no (none)
pct_hf decimal 18 no (none)
tx_remp decimal 18 no (none)
type_action enum 100 no (none)

Table: h1_header_am_projecttemplates_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
h1_header_am_projecttemplatesh1_header_ida varchar 36 no (none)
h1_header_am_projecttemplatesam_projecttemplates_idb varchar 36 no (none)

Table: import_maps

Import mapping control table

Column Type Length Required Comment
assigned_user_id id n/a no Assigned-to user
content text n/a no Mappings for all columns
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
default_values text n/a no Default Values for all columns
deleted bool n/a no Record deletion indicator
delimiter varchar 1 yes (none)
enclosure varchar 1 yes (none)
has_header bool n/a yes Indicator if source file contains a header row
id id n/a yes Unique identifier
is_published varchar 3 yes Indicator if mapping is published
module varchar 36 yes Module used for import
name varchar 254 yes Name of import map
source varchar 36 yes (none)

Table: inbound_email

Inbound email parameters

Column Type Length Required Comment
created_by id n/a no User who created record
date_entered datetime n/a yes Date record created
date_modified datetime n/a yes Date record last modified
delete_seen bool n/a no Delete email from server once read (seen)
deleted bool n/a no Record deltion indicator
email_password varchar 100 yes Password of user identified by email_user
email_user varchar 100 yes User name allowed access to mail server
group_id id n/a no Group ID (unused)
groupfolder_id id n/a no Unique identifier
id varchar 36 yes Unique identifier
is_personal bool n/a yes Personal account flag
mailbox text n/a yes (none)
mailbox_type varchar 10 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 no Name given to the inbound email mailbox
port int 5 yes Port used to access mail server
server_url varchar 100 yes Mail server URL
service varchar 50 yes (none)
status varchar 100 yes Status of the inbound email mailbox (ex: Active or Inactive)
stored_options text n/a no (none)
template_id id 36 no Template used for auto-reply

Table: inbound_email_autoreply

Column Type Length Required Comment
autoreplied_to varchar 100 yes (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
ie_id id 36 yes (none)

Table: inbound_email_cache_ts

Column Type Length Required Comment
id varchar 255 yes (none)
ie_timestamp uint 16 yes (none)

Table: jjwg_address_cache

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
lat float 10 yes (none)
lng float 11 yes (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: jjwg_areas

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
city varchar 255 no (none)
coordinates text n/a no (none)
country varchar 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
state varchar 255 no (none)

Table: jjwg_maps

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
distance float 9 yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
module_type enum 100 yes (none)
name varchar 255 yes (none)
parent_id id 36 no (none)
parent_type varchar 255 no (none)
unit_type enum 100 yes (none)

Table: jjwg_maps_jjwg_areas_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
jjwg_maps_5304wg_maps_ida varchar 36 no (none)
jjwg_maps_41f2g_areas_idb varchar 36 no (none)

Table: jjwg_maps_jjwg_markers_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
jjwg_maps_b229wg_maps_ida varchar 36 no (none)
jjwg_maps_2e31markers_idb varchar 36 no (none)

Table: jjwg_markers

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
city varchar 255 no (none)
country varchar 255 no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
jjwg_maps_lat float 10 no (none)
jjwg_maps_lng float 11 no (none)
marker_image enum 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
state varchar 255 no (none)

Table: job_queue

Job queue keeps the list of the jobs executed by this instance

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
client varchar 255 yes (none)
data text n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a yes (none)
execute_time datetime n/a yes (none)
failure_count tinyint n/a no (none)
id id 36 yes (none)
job_delay int n/a no (none)
message text n/a no (none)
name varchar 255 yes (none)
percent_complete int n/a no (none)
requeue bool n/a no (none)
resolution enum 20 yes (none)
retry_count tinyint n/a no (none)
scheduler_id id n/a no (none)
status enum 20 yes (none)
target varchar 255 yes (none)

Table: leads

Leads are persons of interest early in a sales cycle

Column Type Length Required Comment
account_description text n/a no Description of lead account
account_id id n/a no If converted, Account ID resulting from the conversion
account_name varchar 255 no Account name for lead
alt_address_city varchar 100 no City for alternate address
alt_address_country varchar n/a no Country for alternate address
alt_address_postalcode varchar 20 no Postal code for alternate address
alt_address_state varchar 100 no State for alternate address
alt_address_street varchar 150 no Street address for alternate address
assigned_user_id id n/a no User ID assigned to record
assistant varchar 75 no Name of the assistant of the contact
assistant_phone varchar 100 no Phone number of the assistant of the contact
birthdate date n/a no The birthdate of the contact
campaign_id id n/a no Campaign that generated lead
contact_id id n/a no If converted, Contact ID resulting from the conversion
converted bool n/a no Has Lead been converted to a Contact (and other Sugar objects)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_reviewed date n/a no (none)
deleted bool n/a no Record deletion indicator
department varchar 100 no Department the lead belongs to
description text n/a no Full text of the note
do_not_call bool n/a no An indicator of whether contact can be called
first_name varchar 100 no First name of the contact
id id n/a yes Unique identifier
last_name varchar 100 yes Last name of the contact
lawful_basis multienum 100 no (none)
lawful_basis_source enum 100 no (none)
lead_source enum 100 no Lead source (ex: Web, print)
lead_source_description text n/a no Description of the lead source
modified_user_id id n/a no User who last modified record
opportunity_amount varchar 50 no Amount of the opportunity
opportunity_id id n/a no If converted, Opportunity ID resulting from the conversion
opportunity_name varchar 255 no Opportunity name associated with lead
phone_fax varchar 100 no Contact fax number
phone_home varchar 100 no Home phone number of the contact
phone_mobile varchar 100 no Mobile phone number of the contact
phone_other varchar 100 no Other phone number for the contact
phone_work varchar 100 no Work phone number of the contact
photo varchar 255 no (none)
portal_app varchar 255 no Portal application that resulted in created of lead
portal_name varchar 255 no Portal user name when lead created via lead portal
primary_address_city varchar 100 no City for primary address
primary_address_country varchar n/a no Country for primary address
primary_address_postalcode varchar 20 no Postal code for primary address
primary_address_state varchar 100 no State for primary address
primary_address_street varchar 150 no Street address for primary address
refered_by varchar 100 no Identifies who refered the lead
reports_to_id id n/a no ID of Contact the Lead reports to
salutation enum 255 no Contact salutation (e.g., Mr, Ms)
status enum 100 no Status of the lead
status_description text n/a no Description of the status of the lead
title varchar 100 no The title of the contact
website varchar 255 no URL of website for the company

Table: linked_documents

Column Type Length Required Comment
id varchar 36 no (none)
parent_id varchar 36 no (none)
parent_type varchar 25 no (none)
document_id varchar 36 no (none)
document_revision_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: meetings

Meeting activities

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
creator varchar 50 no Meeting creator
date_end datetime n/a no Date meeting ends
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a yes Date of start of meeting
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
displayed_url url 400 no Meeting URL
duration_hours int 3 yes Duration (hours)
duration_minutes int 2 no Duration (minutes)
email_reminder_sent bool n/a no Whether email reminder is already sent
email_reminder_time int n/a no Specifies when a email reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
external_id varchar 50 no Meeting ID for external app API
gsync_id varchar 1024 no The internal Google ID of the event record
gsync_lastsync int n/a no The last time this record was synced with Google Account as unix time
host_url varchar 400 no Host URL
id id n/a yes Unique identifier
join_url varchar 200 no Join URL
location varchar 50 no Meeting location
modified_user_id id n/a no User who last modified record
name varchar 50 yes Meeting name
outlook_id varchar 255 no When the Sugar Plug-in for Microsoft Outlook syncs an Outlook appointment, this is the Outlook appointment item ID
parent_id id n/a no ID of item indicated by parent_type
parent_type varchar 100 no Module meeting is associated with
password varchar 50 no Meeting password
recurring_source varchar 36 no Source of recurring meeting
reminder_time int n/a no Specifies when a reminder alert should be issued; -1 means no alert; otherwise the number of seconds prior to the start
repeat_count int 7 no Number of recurrence
repeat_dow varchar 7 no Days of week in recurrence
repeat_interval int 3 no Interval of recurrence
repeat_parent_id id 36 no Id of the first element of recurring records
repeat_type enum 36 no Type of recurrence
repeat_until date n/a no Repeat until specified date
sequence int 11 no Meeting update sequence for meetings as per iCalendar standards
status enum 100 no Meeting status (ex: Planned, Held, Not held)
type enum 255 no Meeting type (ex: WebEx, Other)

Table: meetings_contacts

Column Type Length Required Comment
id varchar 36 no (none)
meeting_id varchar 36 no (none)
contact_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: meetings_leads

Column Type Length Required Comment
id varchar 36 no (none)
meeting_id varchar 36 no (none)
lead_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: meetings_users

Column Type Length Required Comment
id varchar 36 no (none)
meeting_id varchar 36 no (none)
user_id varchar 36 no (none)
required varchar 1 no (none)
accept_status varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: notes

Notes and Attachments

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
contact_id id n/a no Contact ID note is associated with
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
embed_flag bool n/a no Embed flag indicator determines if note embedded in email
file_mime_type varchar 100 no Attachment MIME type
filename varchar 255 no File name associated with the note (attachment)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes Name of the note
parent_id id n/a no The ID of the Sugar item specified in parent_type
parent_type varchar 255 no Sugar module the Note is associated with
portal_flag bool n/a yes Portal flag indicator determines if note created via portal

Table: oauth2clients

Provides tokens for security services

Column Type Length Required Comment
allowed_grant_type enum n/a yes (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
duration_amount int 11 yes (none)
duration_unit enum n/a yes (none)
duration_value int 11 yes (none)
id id n/a yes (none)
is_confidential bool n/a no (none)
modified_user_id id n/a no User who last modified record
name varchar n/a yes (none)
redirect_url varchar n/a no (none)
secret varchar 4000 yes (none)

Table: oauth2tokens

Provides tokens for security services

Column Type Length Required Comment
access_token varchar 4000 yes (none)
access_token_expires datetime n/a yes (none)
assigned_user_id id n/a no User ID assigned to record
client id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
grant_type enum n/a yes (none)
id id n/a yes (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
refresh_token varchar 4000 no (none)
refresh_token_expires datetime n/a no (none)
state varchar 1024 no (none)
token_is_revoked bool n/a yes (none)
token_type varchar n/a yes (none)

Table: oauth_consumer

OAuth consumer keys

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
c_key varchar n/a yes Consumer public key
c_secret varchar n/a yes Consumer secret key
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)

Table: oauth_nonce

Column Type Length Required Comment
conskey varchar 32 yes (none)
nonce varchar 32 yes (none)
nonce_ts long n/a yes (none)

Table: oauth_tokens

OAuth tokens

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
callback_url url 255 no Callback URL for Authorization
consumer id n/a yes Token related to the consumer
deleted bool n/a yes Record deletion indicator
id id n/a yes Unique identifier
secret varchar 32 yes Secret key
token_ts long n/a yes Token timestamp
tstate enum 1 yes Token state
verify varchar 32 no Token verification info

Table: opportunities

An opportunity is the target of selling activities

Column Type Length Required Comment
amount double n/a yes Unconverted amount of the opportunity
amount_usdollar double n/a no Formatted amount of the opportunity
assigned_user_id id n/a no User ID assigned to record
campaign_id id n/a no Campaign that generated lead
created_by id n/a no User who created record
currency_id id n/a no Currency used for display purposes
date_closed date n/a yes Expected or actual date the oppportunity will close
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
lead_source enum 50 no Source of the opportunity
modified_user_id id n/a no User who last modified record
name varchar 50 yes Name of the opportunity
next_step varchar 100 no The next step in the sales process
opportunity_type enum 255 no Type of opportunity (ex: Existing, New)
probability double n/a no The probability of closure
sales_stage enum 255 yes Indication of progression towards closure

Table: opportunities_contacts

Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
opportunity_id varchar 36 no (none)
contact_role varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: outbound_email

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
mail_sendtype varchar 8 yes (none)
mail_smtpauth_req bool n/a no (none)
mail_smtppass varchar 100 no (none)
mail_smtpport varchar 5 no (none)
mail_smtpserver varchar 100 no (none)
mail_smtpssl enum 1 no (none)
mail_smtptype varchar 20 yes (none)
mail_smtpuser varchar 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
smtp_from_addr varchar n/a no (none)
smtp_from_name varchar n/a no (none)
type varchar 15 yes (none)
user_id id n/a yes (none)

Table: outbound_email

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
mail_sendtype varchar 8 yes (none)
mail_smtpauth_req bool n/a no (none)
mail_smtppass varchar 100 no (none)
mail_smtpport varchar 5 no (none)
mail_smtpserver varchar 100 no (none)
mail_smtpssl enum 1 no (none)
mail_smtptype varchar 20 yes (none)
mail_smtpuser varchar 100 no (none)
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
smtp_from_addr varchar n/a no (none)
smtp_from_name varchar n/a no (none)
type varchar 15 yes (none)
user_id id n/a yes (none)

Table: project

Project

Column Type Length Required Comment
assigned_user_id id 36 no User assigned to this record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Project description
estimated_end_date date n/a yes (none)
estimated_start_date date n/a yes (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 50 yes Project name
override_business_hours bool n/a no (none)
priority enum n/a no (none)
status enum n/a no (none)

Table: project_contacts_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
project_contacts_1project_ida varchar 36 no (none)
project_contacts_1contacts_idb varchar 36 no (none)

Table: project_task

Column Type Length Required Comment
actual_duration int n/a no (none)
actual_effort int n/a no (none)
assigned_user_id id n/a no (none)
created_by id n/a no (none)
date_due date n/a no (none)
date_entered datetime n/a no (none)
date_finish date n/a no (none)
date_modified datetime n/a no (none)
date_start date n/a no (none)
deleted bool n/a no (none)
description text n/a no (none)
duration int n/a yes (none)
duration_unit text n/a no (none)
estimated_effort int n/a no (none)
id id n/a yes (none)
milestone_flag bool n/a no (none)
modified_user_id id n/a no (none)
name varchar 50 yes (none)
order_number int n/a no (none)
parent_task_id int n/a no (none)
percent_complete int n/a no (none)
predecessors text n/a no (none)
priority enum n/a no (none)
project_id id n/a yes (none)
project_task_id int n/a no (none)
relationship_type enum n/a no (none)
status enum n/a no (none)
task_number int n/a no (none)
time_due time n/a no (none)
time_finish int n/a no (none)
time_start int n/a no (none)
utilization int n/a no (none)

Table: project_users_1_c

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
project_users_1project_ida varchar 36 no (none)
project_users_1users_idb varchar 36 no (none)

Table: projects_accounts

Column Type Length Required Comment
id varchar 36 no (none)
account_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: projects_bugs

Column Type Length Required Comment
id varchar 36 no (none)
bug_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: projects_cases

Column Type Length Required Comment
id varchar 36 no (none)
case_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: projects_contacts

Column Type Length Required Comment
id varchar 36 no (none)
contact_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: projects_opportunities

Column Type Length Required Comment
id varchar 36 no (none)
opportunity_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: projects_products

Column Type Length Required Comment
id varchar 36 no (none)
product_id varchar 36 no (none)
project_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: prospect_list_campaigns

Column Type Length Required Comment
id varchar 36 no (none)
prospect_list_id varchar 36 no (none)
campaign_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: prospect_lists

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no (none)
date_entered datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
description text n/a no (none)
domain_name varchar 255 no (none)
id id n/a yes (none)
list_type enum 100 no (none)
modified_user_id id n/a no (none)
name varchar 255 no (none)

Table: prospect_lists_prospects

Column Type Length Required Comment
id varchar 36 no (none)
prospect_list_id varchar 36 no (none)
related_id varchar 36 no (none)
related_type varchar 25 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: prospects

Column Type Length Required Comment
account_name varchar 150 no (none)
alt_address_city varchar 100 no City for alternate address
alt_address_country varchar n/a no Country for alternate address
alt_address_postalcode varchar 20 no Postal code for alternate address
alt_address_state varchar 100 no State for alternate address
alt_address_street varchar 150 no Street address for alternate address
assigned_user_id id n/a no User ID assigned to record
assistant varchar 75 no Name of the assistant of the contact
assistant_phone varchar 100 no Phone number of the assistant of the contact
birthdate date n/a no (none)
campaign_id id n/a no Campaign that generated lead
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_reviewed date n/a no (none)
deleted bool n/a no Record deletion indicator
department varchar 255 no The department of the contact
description text n/a no Full text of the note
do_not_call bool n/a no (none)
first_name varchar 100 no First name of the contact
id id n/a yes Unique identifier
last_name varchar 100 yes Last name of the contact
lawful_basis multienum 100 no (none)
lawful_basis_source enum 100 no (none)
lead_id id n/a no (none)
modified_user_id id n/a no User who last modified record
phone_fax varchar 100 no Contact fax number
phone_home varchar 100 no Home phone number of the contact
phone_mobile varchar 100 no Mobile phone number of the contact
phone_other varchar 100 no Other phone number for the contact
phone_work varchar 100 no Work phone number of the contact
photo varchar 255 no (none)
primary_address_city varchar 100 no City for primary address
primary_address_country varchar n/a no Country for primary address
primary_address_postalcode varchar 20 no Postal code for primary address
primary_address_state varchar 100 no State for primary address
primary_address_street varchar 150 no Street address for primary address
salutation enum 255 no Contact salutation (e.g., Mr, Ms)
title varchar 100 no The title of the contact
tracker_key int 11 yes (none)

Table: relationships

Column Type Length Required Comment
deleted bool n/a no (none)
id id n/a yes (none)
join_key_lhs varchar 64 no (none)
join_key_rhs varchar 64 no (none)
join_table varchar 64 no (none)
lhs_key varchar 64 yes (none)
lhs_module varchar 100 yes (none)
lhs_table varchar 64 yes (none)
relationship_name varchar 150 yes (none)
relationship_role_column varchar 64 no (none)
relationship_role_column_value varchar 50 no (none)
relationship_type varchar 64 no (none)
reverse bool n/a no (none)
rhs_key varchar 64 yes (none)
rhs_module varchar 100 yes (none)
rhs_table varchar 64 yes (none)

Table: releases

Column Type Length Required Comment
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
list_order int 4 no (none)
modified_user_id id n/a no (none)
name varchar 50 yes (none)
status enum 100 no (none)

Table: reminders

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_willexecute int 60 no (none)
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
email bool n/a no (none)
email_sent bool n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
popup bool n/a no (none)
popup_viewed bool n/a no (none)
related_event_module varchar 32 yes (none)
related_event_module_id id n/a yes (none)
timer_email varchar 32 yes (none)
timer_popup varchar 32 yes (none)

Table: reminders_invitees

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
related_invitee_module varchar 32 yes (none)
related_invitee_module_id id n/a yes (none)
reminder_id id n/a yes (none)

Table: roles

Column Type Length Required Comment
created_by id 36 no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
description text n/a no (none)
id id n/a yes (none)
modified_user_id id 36 no (none)
modules text n/a no (none)
name varchar 150 no (none)

Table: roles_modules

Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
module_id varchar 36 no (none)
allow bool 1 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: roles_users

Column Type Length Required Comment
id varchar 36 no (none)
role_id varchar 36 no (none)
user_id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 no (none)

Table: saved_search

Column Type Length Required Comment
assigned_user_id id n/a no (none)
contents text n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a yes (none)
description text n/a no (none)
id id n/a yes (none)
name varchar 150 no (none)
search_module varchar 150 no (none)

Table: schedulers

Column Type Length Required Comment
catch_up bool 1 no (none)
created_by id 36 no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
date_time_end datetimecombo n/a no (none)
date_time_start datetimecombo n/a yes (none)
deleted bool 1 no (none)
id varchar 36 yes (none)
job varchar 255 yes (none)
job_interval varchar 100 yes (none)
last_run datetime n/a no (none)
modified_user_id id 36 no (none)
name varchar 255 yes (none)
status enum 100 no (none)
time_from time n/a no (none)
time_to time n/a no (none)

Table: securitygroups

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
noninheritable bool n/a no Indicator for whether a group can be inherited by a record

Table: securitygroups_acl_roles

Column Type Length Required Comment
id char 36 yes (none)
securitygroup_id char 36 no (none)
role_id char 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)

Table: securitygroups_default

Column Type Length Required Comment
id char 36 yes (none)
securitygroup_id char 36 no (none)
module varchar 50 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)

Table: securitygroups_records

Column Type Length Required Comment
id char 36 yes (none)
securitygroup_id char 36 no (none)
record_id char 36 no (none)
module char 36 no (none)
date_modified datetime n/a no (none)
modified_user_id char 36 no (none)
created_by char 36 no (none)
deleted bool 1 yes (none)

Table: securitygroups_users

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
securitygroup_id varchar 36 no (none)
user_id varchar 36 no (none)
primary_group bool n/a no Drives which custom layout to show if a user is a member of more than 1 group
noninheritable bool n/a no Indicator for whether a group can be inherited by a record

Table: spots

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
config longtext n/a yes (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
type enum 255 yes (none)

Table: sugarfeed

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text 255 no Name of the feed
id id n/a yes Unique identifier
link_type varchar 30 no Name of the feed
link_url varchar 255 no Name of the feed
modified_user_id id n/a no User who last modified record
name varchar 255 no Name of the feed
related_id id 36 no related module
related_module varchar 100 no related module

Table: surveyquestionoptions

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
sort_order int 255 no (none)
survey_question_id id n/a no (none)

Table: surveyquestionoptions_surveyquestionresponses

Column Type Length Required Comment
id varchar 36 no (none)
date_modified datetime n/a no (none)
deleted bool 1 yes (none)
surveyq72c7options_ida varchar 36 no (none)
surveyq10d4sponses_idb varchar 36 no (none)

Table: surveyquestionresponses

Column Type Length Required Comment
answer text n/a no (none)
answer_bool bool n/a no (none)
answer_datetime datetime n/a no (none)
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
surveyquestion_id id n/a no (none)
surveyresponse_id id n/a no (none)

Table: surveyquestions

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
happiness_question bool n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
sort_order int 255 no (none)
survey_id id n/a no (none)
type enum 100 no (none)

Table: surveyresponses

Column Type Length Required Comment
account_id id n/a no (none)
assigned_user_id id n/a no User ID assigned to record
campaign_id id n/a no (none)
contact_id id n/a no (none)
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
email_response_sent bool n/a no (none)
happiness int n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
survey_id id n/a no (none)

Table: surveys

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
dissatisfied_text varchar n/a no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
neither_text varchar n/a no (none)
satisfied_text varchar n/a no (none)
status enum 100 no (none)
submit_text varchar n/a no (none)

Table: tasks

Column Type Length Required Comment
assigned_user_id id n/a no User ID assigned to record
contact_id id n/a no (none)
created_by id n/a no User who created record
date_due datetime n/a no (none)
date_due_flag bool n/a no (none)
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
date_start datetime n/a no (none)
date_start_flag bool n/a no (none)
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 50 yes (none)
parent_id id n/a no (none)
parent_type varchar 255 no The Sugar object to which the call is related
priority enum 100 yes (none)
status enum 100 yes (none)

Table: templatesectionline

Column Type Length Required Comment
created_by id n/a no User who created record
date_entered datetime n/a no Date record created
date_modified datetime n/a no Date record last modified
deleted bool n/a no Record deletion indicator
description text n/a no Full text of the note
grp varchar 255 no (none)
id id n/a yes Unique identifier
modified_user_id id n/a no User who last modified record
name varchar 255 yes (none)
ord int 11 no (none)
thumbnail varchar 255 no (none)

Table: tracker

Column Type Length Required Comment
action varchar 255 no (none)
date_modified datetime n/a no (none)
deleted bool n/a no Record deletion indicator
id int 11 no (none)
item_id varchar 36 no (none)
item_summary varchar 255 no (none)
module_name varchar 255 no (none)
monitor_id id n/a yes (none)
session_id varchar 36 no (none)
user_id varchar 36 no (none)
visible bool 1 no (none)

Table: upgrade_history

Tracks Sugar upgrades made over time; used by Upgrade Wizard and Module Loader

Column Type Length Required Comment
date_entered datetime n/a yes Date of upgrade or module load
description text n/a no (none)
enabled bool 1 no (none)
filename varchar 255 no Cached filename containing the upgrade scripts and content
id id n/a yes Unique identifier
id_name varchar 255 no The unique id of the module
manifest longtext n/a no A serialized copy of the manifest file.
md5sum varchar 32 no The MD5 checksum of the upgrade file
name varchar 255 no (none)
status varchar 50 no The status of the upgrade (ex: "installed")
type varchar 30 no The upgrade type (module, patch, theme, etc)
version varchar 64 no Version as contained in manifest file

Table: user_preferences

Column Type Length Required Comment
assigned_user_id id n/a yes (none)
category varchar 50 no (none)
contents longtext n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)

Table: users

Column Type Length Required Comment
address_city varchar 100 no (none)
address_country varchar 100 no (none)
address_postalcode varchar 20 no (none)
address_state varchar 100 no (none)
address_street varchar 150 no (none)
authenticate_id varchar 100 no (none)
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
department varchar 50 no (none)
description text n/a no (none)
employee_status varchar 100 no (none)
external_auth_only bool n/a no (none)
factor_auth bool n/a no (none)
factor_auth_interface enum n/a no (none)
first_name varchar 255 no (none)
id id n/a yes (none)
is_admin bool n/a no (none)
is_group bool n/a no (none)
last_name varchar 255 yes (none)
messenger_id varchar 100 no (none)
messenger_type enum 100 no (none)
modified_user_id id n/a no (none)
phone_fax varchar 50 no (none)
phone_home varchar 50 no (none)
phone_mobile varchar 50 no (none)
phone_other varchar 50 no (none)
phone_work varchar 50 no (none)
photo varchar 255 no (none)
portal_only bool n/a no (none)
pwd_last_changed datetime n/a no (none)
receive_notifications bool n/a no (none)
reports_to_id id n/a no (none)
show_on_employees bool n/a no (none)
status enum 100 no (none)
sugar_login bool n/a no (none)
system_generated_password bool n/a yes (none)
title varchar 50 no (none)
user_hash varchar 255 no (none)
user_name varchar 60 yes (none)

Table: users

Column Type Length Required Comment
address_city varchar 100 no (none)
address_country varchar 100 no (none)
address_postalcode varchar 20 no (none)
address_state varchar 100 no (none)
address_street varchar 150 no (none)
authenticate_id varchar 100 no (none)
created_by id n/a no (none)
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
department varchar 50 no (none)
description text n/a no (none)
employee_status varchar 100 no (none)
external_auth_only bool n/a no (none)
factor_auth bool n/a no (none)
factor_auth_interface enum n/a no (none)
first_name varchar 255 no (none)
id id n/a yes (none)
is_admin bool n/a no (none)
is_group bool n/a no (none)
last_name varchar 255 yes (none)
messenger_id varchar 100 no (none)
messenger_type enum 100 no (none)
modified_user_id id n/a no (none)
phone_fax varchar 50 no (none)
phone_home varchar 50 no (none)
phone_mobile varchar 50 no (none)
phone_other varchar 50 no (none)
phone_work varchar 50 no (none)
photo varchar 255 no (none)
portal_only bool n/a no (none)
pwd_last_changed datetime n/a no (none)
receive_notifications bool n/a no (none)
reports_to_id id n/a no (none)
show_on_employees bool n/a no (none)
status enum 100 no (none)
sugar_login bool n/a no (none)
system_generated_password bool n/a yes (none)
title varchar 50 no (none)
user_hash varchar 255 no (none)
user_name varchar 60 yes (none)

Table: users_feeds

Column Type Length Required Comment
user_id varchar 36 no (none)
feed_id varchar 36 no (none)
rank int n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)

Table: users_last_import

Maintains rows last imported by user

Column Type Length Required Comment
assigned_user_id id n/a no User assigned to this record
bean_id id n/a no ID of item identified by bean_type
bean_type varchar 36 no Bean type for which import occurs
deleted bool n/a no Record deletion indicator
id id n/a yes Unique identifier
import_module varchar 36 no Module for which import occurs

Table: users_password_link

Column Type Length Required Comment
date_generated datetime n/a no (none)
deleted bool n/a no (none)
id id n/a yes (none)
username varchar 36 no (none)

Table: users_signatures

Column Type Length Required Comment
date_entered datetime n/a yes (none)
date_modified datetime n/a yes (none)
deleted bool n/a no (none)
id id n/a yes (none)
name varchar 255 no (none)
signature text n/a no (none)
signature_html text n/a no (none)
user_id varchar 36 no (none)

Table: vcals

Column Type Length Required Comment
content text n/a no (none)
date_entered datetime n/a no (none)
date_modified datetime n/a no (none)
deleted bool n/a no (none)
id id n/a yes (none)
source varchar 100 no (none)
type varchar 100 no (none)
user_id id n/a yes (none)