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) |