MySQL accounts Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 150
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
account_type | varchar | 50
industry | varchar | 50
annual_revenue | varchar | 100
phone_fax | varchar | 100
billing_address_street | varchar | 150
billing_address_city | varchar | 100
billing_address_state | varchar | 100
billing_address_postalcode | varchar | 20
billing_address_country | varchar | 255
rating | varchar | 100
phone_office | varchar | 100
phone_alternate | varchar | 100
website | varchar | 255
ownership | varchar | 100
employees | varchar | 10
ticker_symbol | varchar | 10
shipping_address_street | varchar | 150
shipping_address_city | varchar | 100
shipping_address_state | varchar | 100
shipping_address_postalcode | varchar | 20
shipping_address_country | varchar | 255
parent_id | char | 36
sic_code | varchar | 10
campaign_id | char | 36

MySQL accounts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_accnt_id_del | index | id,deleted
idx_accnt_name_del | index | name,deleted
idx_accnt_assigned_del | index | deleted,assigned_user_id
idx_accnt_parent_id | index | parent_id

MySQL accounts_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL accounts_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_accounts_parent_id | index | parent_id

MySQL accounts_bugs Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
account_id | varchar | 36
bug_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL accounts_bugs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_acc_bug_acc | index | account_id
idx_acc_bug_bug | index | bug_id
idx_account_bug | index | account_id,bug_id

MySQL accounts_cases Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
account_id | varchar | 36
case_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL accounts_cases Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_acc_case_acc | index | account_id
idx_acc_acc_case | index | case_id

MySQL accounts_contacts Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
contact_id | varchar | 36
account_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL accounts_contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_account_contact | index | account_id,contact_id
idx_contid_del_accid | index | contact_id,deleted,account_id

MySQL accounts_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL accounts_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL accounts_opportunities Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
opportunity_id | varchar | 36
account_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL accounts_opportunities Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_account_opportunity | index | account_id,opportunity_id
idx_oppid_del_accid | index | opportunity_id,deleted,account_id

MySQL acl_actions Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
name | varchar | 150
category | varchar | 100
acltype | varchar | 100
aclaccess | int | 3
deleted | tinyint

MySQL acl_actions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aclaction_id_del | index | id,deleted
idx_category_name | index | category,name

MySQL acl_roles Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
name | varchar | 150
description | text
deleted | tinyint

MySQL acl_roles Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aclrole_id_del | index | id,deleted

MySQL acl_roles_actions Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
role_id | varchar | 36
action_id | varchar | 36
access_override | int | 3
date_modified | datetime
deleted | tinyint

MySQL acl_roles_actions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_acl_role_id | index | role_id
idx_acl_action_id | index | action_id
idx_aclrole_action | index | role_id,action_id

MySQL acl_roles_users Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
role_id | varchar | 36
user_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL acl_roles_users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aclrole_id | index | role_id
idx_acluser_id | index | user_id
idx_aclrole_user | index | role_id,user_id

MySQL address_book Definitions:
name | type | len | required
--- | --- | --- | ---
assigned_user_id | char | 36 | true
bean | varchar | 50
bean_id | char | 36 | true

MySQL address_book Keys:
name | type | fields
--- | --- | ---
ab_user_bean_idx | index | assigned_user_id,bean

MySQL alerts Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
is_read | tinyint
target_module | varchar | 255
type | varchar | 255
url_redirect | varchar | 255
reminder_id | char | 36

MySQL alerts Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL am_projecttemplates Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
status | varchar | 100 | Draft
priority | varchar | 100 | High
override_business_hours | tinyint

MySQL am_projecttemplates Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL am_projecttemplates_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL am_projecttemplates_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_am_projecttemplates_parent_id | index | parent_id

MySQL am_projecttemplates_contacts_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
am_projecttemplates_ida | varchar | 36
contacts_idb | varchar | 36

MySQL am_projecttemplates_contacts_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
am_projecttemplates_contacts_1_alt | index | am_projecttemplates_ida,contacts_idb

MySQL am_projecttemplates_project_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
am_projecttemplates_project_1am_projecttemplates_ida | varchar | 36
am_projecttemplates_project_1project_idb | varchar | 36

MySQL am_projecttemplates_project_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
am_projecttemplates_project_1_ida1 | index | am_projecttemplates_project_1am_projecttemplates_ida
am_projecttemplates_project_1_alt | index | am_projecttemplates_project_1project_idb

MySQL am_projecttemplates_users_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
am_projecttemplates_ida | varchar | 36
users_idb | varchar | 36

MySQL am_projecttemplates_users_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
am_projecttemplates_users_1_alt | index | am_projecttemplates_ida,users_idb

MySQL am_tasktemplates Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
status | varchar | 100 | Not Started
priority | varchar | 100 | High
percent_complete | int | 255
predecessors | int | 255
milestone_flag | tinyint
relationship_type | varchar | 100 | FS
task_number | int | 255
order_number | int | 255
estimated_effort | int | 255
utilization | varchar | 100
duration | int | 255

MySQL am_tasktemplates Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL am_tasktemplates_am_projecttemplates_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
am_tasktemplates_am_projecttemplatesam_projecttemplates_ida | varchar | 36
am_tasktemplates_am_projecttemplatesam_tasktemplates_idb | varchar | 36

MySQL am_tasktemplates_am_projecttemplates_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
am_tasktemplates_am_projecttemplates_ida1 | index | am_tasktemplates_am_projecttemplatesam_projecttemplates_ida
am_tasktemplates_am_projecttemplates_alt | index | am_tasktemplates_am_projecttemplatesam_tasktemplates_idb

MySQL am_tasktemplates_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL am_tasktemplates_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_am_tasktemplates_parent_id | index | parent_id

MySQL aobh_businesshours Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
opening_hours | varchar | 100 | 1
closing_hours | varchar | 100 | 1
open_status | tinyint
day | varchar | 100 | monday

MySQL aobh_businesshours Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aod_index Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
last_optimised | datetime
location | varchar | 255

MySQL aod_index Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aod_index_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aod_index_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aod_index_parent_id | index | parent_id

MySQL aod_indexevent Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
error | varchar | 255
success | tinyint
record_id | char | 36
record_module | varchar | 255

MySQL aod_indexevent Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_record_module | index | record_module
idx_record_id | index | record_id

MySQL aod_indexevent_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aod_indexevent_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aod_indexevent_parent_id | index | parent_id

MySQL aok_knowledge_base_categories Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36

MySQL aok_knowledge_base_categories Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aok_knowledge_base_categories_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aok_knowledge_base_categories_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aok_knowledge_base_categories_parent_id | index | parent_id

MySQL aok_knowledgebase Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
status | varchar | 100 | Draft
revision | varchar | 255
additional_info | text
user_id_c | char | 36
user_id1_c | char | 36

MySQL aok_knowledgebase Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aok_knowledgebase_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aok_knowledgebase_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aok_knowledgebase_parent_id | index | parent_id

MySQL aok_knowledgebase_categories Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
aok_knowledgebase_id | varchar | 36
aok_knowledge_base_categories_id | varchar | 36

MySQL aok_knowledgebase_categories Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aok_knowledgebase_categories_alt | index | aok_knowledgebase_id,aok_knowledge_base_categories_id

MySQL aop_case_events Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
case_id | char | 36

MySQL aop_case_events Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aop_case_events_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aop_case_events_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aop_case_events_parent_id | index | parent_id

MySQL aop_case_updates Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
case_id | char | 36
contact_id | char | 36
internal | tinyint

MySQL aop_case_updates Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aop_case_updates_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aop_case_updates_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aop_case_updates_parent_id | index | parent_id

MySQL aor_charts Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
aor_report_id | char | 36
type | varchar | 100
x_field | int | 11
y_field | int | 11

MySQL aor_charts Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aor_conditions Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
aor_report_id | char | 36
condition_order | int | 255
logic_op | varchar | 255
parenthesis | varchar | 255
module_path | longtext
field | varchar | 100
operator | varchar | 100
value_type | varchar | 100
value | varchar | 255
parameter | tinyint

MySQL aor_conditions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aor_conditions_index_report_id | index | aor_report_id

MySQL aor_fields Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
aor_report_id | char | 36
field_order | int | 255
module_path | longtext
field | varchar | 100
display | tinyint
link | tinyint
label | varchar | 255
field_function | varchar | 100
sort_by | varchar | 100
format | varchar | 100
total | varchar | 100
sort_order | varchar | 100
group_by | tinyint
group_order | varchar | 100
group_display | int | 11

MySQL aor_fields Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aor_fields_index_report_id | index | aor_report_id

MySQL aor_reports Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
report_module | varchar | 100
graphs_per_row | int | 11 | 2

MySQL aor_reports Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aor_reports_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aor_reports_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aor_reports_parent_id | index | parent_id

MySQL aor_scheduled_reports Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
schedule | varchar | 100
last_run | datetime
status | varchar | 100
email_recipients | longtext
aor_report_id | char | 36

MySQL aor_scheduled_reports Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_contracts Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
reference_code | varchar | 255
start_date | date
end_date | date
total_contract_value | decimal | 26,6
total_contract_value_usdollar | decimal | 26,6
currency_id | char | 36
status | varchar | 100 | Not Started
customer_signed_date | date
company_signed_date | date
renewal_reminder_date | datetime
contract_type | varchar | 100 | Type
contract_account_id | char | 36
opportunity_id | char | 36
contact_id | char | 36
call_id | char | 36
total_amt | decimal | 26,6
total_amt_usdollar | decimal | 26,6
subtotal_amount | decimal | 26,6
subtotal_amount_usdollar | decimal | 26,6
discount_amount | decimal | 26,6
discount_amount_usdollar | decimal | 26,6
tax_amount | decimal | 26,6
tax_amount_usdollar | decimal | 26,6
shipping_amount | decimal | 26,6
shipping_amount_usdollar | decimal | 26,6
shipping_tax | varchar | 100
shipping_tax_amt | decimal | 26,6
shipping_tax_amt_usdollar | decimal | 26,6
total_amount | decimal | 26,6
total_amount_usdollar | decimal | 26,6

MySQL aos_contracts Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_contracts_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_contracts_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_contracts_parent_id | index | parent_id

MySQL aos_contracts_documents Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
aos_contracts_id | varchar | 36
documents_id | varchar | 36
document_revision_id | varchar | 36

MySQL aos_contracts_documents Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aos_contracts_documents_alt | index | aos_contracts_id,documents_id

MySQL aos_invoices Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
billing_account_id | char | 36
billing_contact_id | char | 36
billing_address_street | varchar | 150
billing_address_city | varchar | 100
billing_address_state | varchar | 100
billing_address_postalcode | varchar | 20
billing_address_country | varchar | 255
shipping_address_street | varchar | 150
shipping_address_city | varchar | 100
shipping_address_state | varchar | 100
shipping_address_postalcode | varchar | 20
shipping_address_country | varchar | 255
number | int | 11 | true
total_amt | decimal | 26,6
total_amt_usdollar | decimal | 26,6
subtotal_amount | decimal | 26,6
subtotal_amount_usdollar | decimal | 26,6
discount_amount | decimal | 26,6
discount_amount_usdollar | decimal | 26,6
tax_amount | decimal | 26,6
tax_amount_usdollar | decimal | 26,6
shipping_amount | decimal | 26,6
shipping_amount_usdollar | decimal | 26,6
shipping_tax | varchar | 100
shipping_tax_amt | decimal | 26,6
shipping_tax_amt_usdollar | decimal | 26,6
total_amount | decimal | 26,6
total_amount_usdollar | decimal | 26,6
currency_id | char | 36
quote_number | int | 11
quote_date | date
invoice_date | date
due_date | date
status | varchar | 100
template_ddown_c | text
subtotal_tax_amount | decimal | 26,6
subtotal_tax_amount_usdollar | decimal | 26,6

MySQL aos_invoices Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_invoices_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_invoices_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_invoices_parent_id | index | parent_id

MySQL aos_invoices_cstm Definitions:
name | type | len
--- | --- | ---
id_c | char | 36
balanced_c | decimal | 26,6

MySQL aos_invoices_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL aos_line_item_groups Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
total_amt | decimal | 26,6
total_amt_usdollar | decimal | 26,6
discount_amount | decimal | 26,6
discount_amount_usdollar | decimal | 26,6
subtotal_amount | decimal | 26,6
subtotal_amount_usdollar | decimal | 26,6
tax_amount | decimal | 26,6
tax_amount_usdollar | decimal | 26,6
subtotal_tax_amount | decimal | 26,6
subtotal_tax_amount_usdollar | decimal | 26,6
total_amount | decimal | 26,6
total_amount_usdollar | decimal | 26,6
parent_type | varchar | 100
parent_id | char | 36
number | int | 11
currency_id | char | 36

MySQL aos_line_item_groups Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_line_item_groups_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_line_item_groups_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_line_item_groups_parent_id | index | parent_id

MySQL aos_pdf_templates Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | longtext
deleted | tinyint
assigned_user_id | char | 36
active | tinyint | 1
type | varchar | 100
pdfheader | longtext
pdffooter | longtext
margin_left | int | 255 | 15
margin_right | int | 255 | 15
margin_top | int | 255 | 16
margin_bottom | int | 255 | 16
margin_header | int | 255 | 9
margin_footer | int | 255 | 9
page_size | varchar | 100
orientation | varchar | 100

MySQL aos_pdf_templates Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_pdf_templates_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_pdf_templates_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_pdf_templates_parent_id | index | parent_id

MySQL aos_product_categories Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
is_parent | tinyint
parent_category_id | char | 36

MySQL aos_product_categories Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_product_categories_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_product_categories_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_product_categories_parent_id | index | parent_id

MySQL aos_products Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
maincode | varchar | 100 | XXXX
part_number | varchar | 25
category | varchar | 100
type | varchar | 100 | Good
cost | decimal | 26,6
cost_usdollar | decimal | 26,6
currency_id | char | 36
price | decimal | 26,6
price_usdollar | decimal | 26,6
url | varchar | 255
contact_id | char | 36
product_image | varchar | 255
aos_product_category_id | char | 36

MySQL aos_products Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_products_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_products_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_products_parent_id | index | parent_id

MySQL aos_products_quotes Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | text
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
currency_id | char | 36
part_number | varchar | 255
item_description | text
number | int | 11
product_qty | decimal | 18,4
product_cost_price | decimal | 26,6
product_cost_price_usdollar | decimal | 26,6
product_list_price | decimal | 26,6
product_list_price_usdollar | decimal | 26,6
product_discount | decimal | 26,6
product_discount_usdollar | decimal | 26,6
product_discount_amount | decimal | 26,6
product_discount_amount_usdollar | decimal | 26,6
discount | varchar | 255 | Percentage
product_unit_price | decimal | 26,6
product_unit_price_usdollar | decimal | 26,6
vat_amt | decimal | 26,6
vat_amt_usdollar | decimal | 26,6
product_total_price | decimal | 26,6
product_total_price_usdollar | decimal | 26,6
vat | varchar | 100 | 5.0
parent_type | varchar | 100
parent_id | char | 36
product_id | char | 36
group_id | char | 36

MySQL aos_products_quotes Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aospq_par_del | index | parent_id,parent_type,deleted

MySQL aos_products_quotes_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_products_quotes_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_products_quotes_parent_id | index | parent_id

MySQL aos_quotes Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
approval_issue | text
billing_account_id | char | 36
billing_contact_id | char | 36
billing_address_street | varchar | 150
billing_address_city | varchar | 100
billing_address_state | varchar | 100
billing_address_postalcode | varchar | 20
billing_address_country | varchar | 255
shipping_address_street | varchar | 150
shipping_address_city | varchar | 100
shipping_address_state | varchar | 100
shipping_address_postalcode | varchar | 20
shipping_address_country | varchar | 255
expiration | date
number | int | 11
opportunity_id | char | 36
template_ddown_c | text
total_amt | decimal | 26,6
total_amt_usdollar | decimal | 26,6
subtotal_amount | decimal | 26,6
subtotal_amount_usdollar | decimal | 26,6
discount_amount | decimal | 26,6
discount_amount_usdollar | decimal | 26,6
tax_amount | decimal | 26,6
tax_amount_usdollar | decimal | 26,6
shipping_amount | decimal | 26,6
shipping_amount_usdollar | decimal | 26,6
shipping_tax | varchar | 100
shipping_tax_amt | decimal | 26,6
shipping_tax_amt_usdollar | decimal | 26,6
total_amount | decimal | 26,6
total_amount_usdollar | decimal | 26,6
currency_id | char | 36
stage | varchar | 100 | Draft
term | varchar | 100
terms_c | text
approval_status | varchar | 100
invoice_status | varchar | 100 | Not Invoiced
subtotal_tax_amount | decimal | 26,6
subtotal_tax_amount_usdollar | decimal | 26,6

MySQL aos_quotes Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL aos_quotes_aos_invoices_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
aos_quotes77d9_quotes_ida | varchar | 36
aos_quotes6b83nvoices_idb | varchar | 36

MySQL aos_quotes_aos_invoices_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aos_quotes_aos_invoices_alt | index | aos_quotes77d9_quotes_ida,aos_quotes6b83nvoices_idb

MySQL aos_quotes_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aos_quotes_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aos_quotes_parent_id | index | parent_id

MySQL aos_quotes_os_contracts_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
aos_quotese81e_quotes_ida | varchar | 36
aos_quotes4dc0ntracts_idb | varchar | 36

MySQL aos_quotes_os_contracts_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aos_quotes_aos_contracts_alt | index | aos_quotese81e_quotes_ida,aos_quotes4dc0ntracts_idb

MySQL aos_quotes_project_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
aos_quotes1112_quotes_ida | varchar | 36
aos_quotes7207project_idb | varchar | 36

MySQL aos_quotes_project_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aos_quotes_project_alt | index | aos_quotes1112_quotes_ida,aos_quotes7207project_idb

MySQL aow_actions Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
aow_workflow_id | char | 36
action_order | int | 255
action | varchar | 100
parameters | longtext

MySQL aow_actions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aow_action_index_workflow_id | index | aow_workflow_id

MySQL aow_conditions Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
aow_workflow_id | char | 36
condition_order | int | 255
module_path | longtext
field | varchar | 100
operator | varchar | 100
value_type | varchar | 255
value | varchar | 255

MySQL aow_conditions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aow_conditions_index_workflow_id | index | aow_workflow_id

MySQL aow_processed Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
aow_workflow_id | char | 36
parent_id | char | 36
parent_type | varchar | 100
status | varchar | 100 | Pending

MySQL aow_processed Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aow_processed_index_workflow | index | aow_workflow_id,status,parent_id,deleted
aow_processed_index_status | index | status
aow_processed_index_workflow_id | index | aow_workflow_id

MySQL aow_processed_aow_actions Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
aow_processed_id | varchar | 36
aow_action_id | varchar | 36
status | varchar | 36 | Pending
date_modified | datetime
deleted | tinyint

MySQL aow_processed_aow_actions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aow_processed_aow_actions | index | aow_processed_id,aow_action_id
idx_actid_del_freid | index | aow_action_id,deleted,aow_processed_id

MySQL aow_workflow Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
flow_module | varchar | 100
flow_run_on | varchar | 100
status | varchar | 100 | Active
run_when | varchar | 100 | Always
multiple_runs | tinyint

MySQL aow_workflow Keys:
name | type | fields
--- | --- | ---
primary | primary | id
aow_workflow_index_status | index | status

MySQL aow_workflow_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL aow_workflow_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_aow_workflow_parent_id | index | parent_id

MySQL bugs Definitions:
name | type | len | auto_increment | required
--- | --- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
bug_number | int | 11 | 1 | true
type | varchar | 255
status | varchar | 100
priority | varchar | 100
resolution | varchar | 255
work_log | text
found_in_release | varchar | 255
fixed_in_release | varchar | 255
source | varchar | 255
product_category | varchar | 255

MySQL bugs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
bugsnumk | unique | bug_number
bug_number | index | bug_number
idx_bug_name | index | name
idx_bugs_assigned_user | index | assigned_user_id

MySQL bugs_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL bugs_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_bugs_parent_id | index | parent_id

MySQL calls Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 50
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
duration_hours | int | 2
duration_minutes | int | 2
date_start | datetime
date_end | datetime
parent_type | varchar | 255
status | varchar | 100 | Planned
direction | varchar | 100
parent_id | char | 36
reminder_time | int | 11 | -1
email_reminder_time | int | 11 | -1
email_reminder_sent | tinyint
outlook_id | varchar | 255
repeat_type | varchar | 36
repeat_interval | int | 3 | 1
repeat_dow | varchar | 7
repeat_until | date
repeat_count | int | 7
repeat_parent_id | char | 36
recurring_source | varchar | 36

MySQL calls Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_call_name | index | name
idx_status | index | status
idx_calls_date_start | index | date_start
idx_calls_par_del | index | parent_id,parent_type,deleted
idx_calls_assigned_del | index | deleted,assigned_user_id

MySQL calls_contacts Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
call_id | varchar | 36
contact_id | varchar | 36
required | varchar | 1 | 1
accept_status | varchar | 25 | none
date_modified | datetime
deleted | tinyint

MySQL calls_contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_con_call_call | index | call_id
idx_con_call_con | index | contact_id
idx_call_contact | index | call_id,contact_id

MySQL calls_leads Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
call_id | varchar | 36
lead_id | varchar | 36
required | varchar | 1 | 1
accept_status | varchar | 25 | none
date_modified | datetime
deleted | tinyint

MySQL calls_leads Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_lead_call_call | index | call_id
idx_lead_call_lead | index | lead_id
idx_call_lead | index | call_id,lead_id

MySQL calls_reschedule Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
reason | varchar | 100
call_id | char | 36

MySQL calls_reschedule Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL calls_reschedule_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL calls_reschedule_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_calls_reschedule_parent_id | index | parent_id

MySQL calls_users Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
call_id | varchar | 36
user_id | varchar | 36
required | varchar | 1 | 1
accept_status | varchar | 25 | none
date_modified | datetime
deleted | tinyint

MySQL calls_users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_usr_call_call | index | call_id
idx_usr_call_usr | index | user_id
idx_call_users | index | call_id,user_id

MySQL campaign_log Definitions:
name | type | len
--- | --- | ---
id | char | 36
campaign_id | char | 36
target_tracker_key | varchar | 36
target_id | varchar | 36
target_type | varchar | 100
activity_type | varchar | 100
activity_date | datetime
related_id | varchar | 36
related_type | varchar | 100
archived | tinyint
hits | int | 11
list_id | char | 36
deleted | tinyint
date_modified | datetime
more_information | varchar | 100
marketing_id | char | 36

MySQL campaign_log Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_camp_tracker | index | target_tracker_key
idx_camp_campaign_id | index | campaign_id
idx_camp_more_info | index | more_information
idx_target_id | index | target_id
idx_target_id_deleted | index | target_id,deleted

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

MySQL campaign_trkrs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
campaign_tracker_key_idx | index | tracker_key

MySQL campaigns Definitions:
name | type | len | auto_increment | required
--- | --- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
deleted | tinyint
assigned_user_id | char | 36
tracker_key | int | 11 | 1 | true
tracker_count | int | 11
refer_url | varchar | 255 | http://
tracker_text | varchar | 255
start_date | date
end_date | date
status | varchar | 100
impressions | int | 11
currency_id | char | 36
budget | double
expected_cost | double
actual_cost | double
expected_revenue | double
campaign_type | varchar | 100
objective | text
content | text
frequency | varchar | 100
survey_id | char | 36

MySQL campaigns Keys:
name | type | fields
--- | --- | ---
primary | primary | id
camp_auto_tracker_key | index | tracker_key
idx_campaign_name | index | name
idx_survey_id | index | survey_id

MySQL campaigns_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL campaigns_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_campaigns_parent_id | index | parent_id

MySQL cases Definitions:
name | type | len | auto_increment | required
--- | --- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
case_number | int | 11 | 1 | true
type | varchar | 255
status | varchar | 100
priority | varchar | 100
resolution | text
work_log | text
account_id | char | 36
state | varchar | 100 | Open
contact_created_by_id | char | 36

MySQL cases Keys:
name | type | fields
--- | --- | ---
primary | primary | id
casesnumk | unique | case_number
case_number | index | case_number
idx_case_name | index | name
idx_account_id | index | account_id
idx_cases_stat_del | index | assigned_user_id,status,deleted

MySQL cases_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL cases_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_cases_parent_id | index | parent_id

MySQL cases_bugs Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
case_id | varchar | 36
bug_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL cases_bugs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_cas_bug_cas | index | case_id
idx_cas_bug_bug | index | bug_id
idx_case_bug | index | case_id,bug_id

MySQL cases_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL cases_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL config Definitions:
name | type | len
--- | --- | ---
category | varchar | 32
name | varchar | 32
value | text

MySQL config Keys:
name | type | fields
--- | --- | ---
idx_config_cat | index | category

MySQL contacts Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
salutation | varchar | 255
first_name | varchar | 100
last_name | varchar | 100
title | varchar | 100
photo | varchar | 255
department | varchar | 255
do_not_call | tinyint
phone_home | varchar | 100
phone_mobile | varchar | 100
phone_work | varchar | 100
phone_other | varchar | 100
phone_fax | varchar | 100
lawful_basis | text
date_reviewed | date
lawful_basis_source | varchar | 100
primary_address_street | varchar | 150
primary_address_city | varchar | 100
primary_address_state | varchar | 100
primary_address_postalcode | varchar | 20
primary_address_country | varchar | 255
alt_address_street | varchar | 150
alt_address_city | varchar | 100
alt_address_state | varchar | 100
alt_address_postalcode | varchar | 20
alt_address_country | varchar | 255
assistant | varchar | 75
assistant_phone | varchar | 100
lead_source | varchar | 255
reports_to_id | char | 36
birthdate | date
campaign_id | char | 36
joomla_account_id | varchar | 255
portal_account_disabled | tinyint
portal_user_type | varchar | 100 | Single

MySQL contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_cont_last_first | index | last_name,first_name,deleted
idx_contacts_del_last | index | deleted,last_name
idx_cont_del_reports | index | deleted,reports_to_id,last_name
idx_reports_to_id | index | reports_to_id
idx_del_id_user | index | deleted,id,assigned_user_id
idx_cont_assigned | index | assigned_user_id

MySQL contacts_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL contacts_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_contacts_parent_id | index | parent_id

MySQL contacts_bugs Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
contact_id | varchar | 36
bug_id | varchar | 36
contact_role | varchar | 50
date_modified | datetime
deleted | tinyint

MySQL contacts_bugs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_con_bug_con | index | contact_id
idx_con_bug_bug | index | bug_id
idx_contact_bug | index | contact_id,bug_id

MySQL contacts_cases Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
contact_id | varchar | 36
case_id | varchar | 36
contact_role | varchar | 50
date_modified | datetime
deleted | tinyint

MySQL contacts_cases Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_con_case_con | index | contact_id
idx_con_case_case | index | case_id
idx_contacts_cases | index | contact_id,case_id

MySQL contacts_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL contacts_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL contacts_users Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
contact_id | varchar | 36
user_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL contacts_users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_con_users_con | index | contact_id
idx_con_users_user | index | user_id
idx_contacts_users | index | contact_id,user_id

MySQL cron_remove_documents Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
bean_id | varchar | 36
module | varchar | 25
date_modified | datetime

MySQL cron_remove_documents Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_cron_remove_document_bean_id | index | bean_id
idx_cron_remove_document_stamp | index | date_modified

MySQL currencies Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
name | varchar | 36
symbol | varchar | 36
iso4217 | varchar | 3
conversion_rate | double
status | varchar | 100
deleted | tinyint
date_entered | datetime
date_modified | datetime
created_by | char | 36 | true

MySQL currencies Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_currency_name | index | name,deleted

MySQL custom_fields Definitions:
name | type | len
--- | --- | ---
bean_id | varchar | 36
set_num | int | 11
field0 | varchar | 255
field1 | varchar | 255
field2 | varchar | 255
field3 | varchar | 255
field4 | varchar | 255
field5 | varchar | 255
field6 | varchar | 255
field7 | varchar | 255
field8 | varchar | 255
field9 | varchar | 255
deleted | tinyint

MySQL custom_fields Keys:
name | type | fields
--- | --- | ---
idx_beanid_set_num | index | bean_id,set_num

MySQL document_revisions Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
change_log | varchar | 255
document_id | varchar | 36
doc_id | varchar | 100
doc_type | varchar | 100
doc_url | varchar | 255
date_entered | datetime
created_by | char | 36
filename | varchar | 255
file_ext | varchar | 100
file_mime_type | varchar | 100
revision | varchar | 100
deleted | tinyint
date_modified | datetime

MySQL document_revisions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
documentrevision_mimetype | index | file_mime_type

MySQL documents Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
document_name | varchar | 255
doc_id | varchar | 100
doc_type | varchar | 100 | Sugar
doc_url | varchar | 255
active_date | date
exp_date | date
category_id | varchar | 100
subcategory_id | varchar | 100
status_id | varchar | 100
document_revision_id | varchar | 36
related_doc_id | char | 36
related_doc_rev_id | char | 36
is_template | tinyint
template_type | varchar | 100

MySQL documents Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_doc_cat | index | category_id,subcategory_id

MySQL documents_accounts Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
document_id | varchar | 36
account_id | varchar | 36

MySQL documents_accounts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
documents_accounts_account_id | index | account_id,document_id
documents_accounts_document_id | index | document_id,account_id

MySQL documents_bugs Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
document_id | varchar | 36
bug_id | varchar | 36

MySQL documents_bugs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
documents_bugs_bug_id | index | bug_id,document_id
documents_bugs_document_id | index | document_id,bug_id

MySQL documents_cases Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
document_id | varchar | 36
case_id | varchar | 36

MySQL documents_cases Keys:
name | type | fields
--- | --- | ---
primary | primary | id
documents_cases_case_id | index | case_id,document_id
documents_cases_document_id | index | document_id,case_id

MySQL documents_contacts Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
document_id | varchar | 36
contact_id | varchar | 36

MySQL documents_contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
documents_contacts_contact_id | index | contact_id,document_id
documents_contacts_document_id | index | document_id,contact_id

MySQL documents_opportunities Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
document_id | varchar | 36
opportunity_id | varchar | 36

MySQL documents_opportunities Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_docu_opps_oppo_id | index | opportunity_id,document_id
idx_docu_oppo_docu_id | index | document_id,opportunity_id

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

MySQL eapm Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_app_active | index | assigned_user_id,application,validated

MySQL email_addr_bean_rel Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
email_address_id | char | 36 | true
bean_id | char | 36 | true
bean_module | varchar | 100
primary_address | tinyint
reply_to_address | tinyint
date_created | datetime
date_modified | datetime
deleted | tinyint

MySQL email_addr_bean_rel Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_email_address_id | index | email_address_id
idx_bean_id | index | bean_id,bean_module

MySQL email_addresses Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
email_address | varchar | 255
email_address_caps | varchar | 255
invalid_email | tinyint
opt_out | tinyint
confirm_opt_in | varchar | 255 | not-opt-in
confirm_opt_in_date | datetime
confirm_opt_in_sent_date | datetime
confirm_opt_in_fail_date | datetime
confirm_opt_in_token | varchar | 255
date_created | datetime
date_modified | datetime
deleted | tinyint

MySQL email_addresses Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_ea_caps_opt_out_invalid | index | email_address_caps,opt_out,invalid_email
idx_ea_opt_out_invalid | index | email_address,opt_out,invalid_email

MySQL email_addresses_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL email_addresses_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_email_addresses_parent_id | index | parent_id

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

MySQL email_cache Keys:
name | type | fields
--- | --- | ---
idx_ie_id | index | ie_id
idx_mail_date | index | ie_id,mbox,senddate
idx_mail_from | index | ie_id,mbox,fromaddr
idx_mail_subj | index | subject
idx_mail_to | index | toaddr

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

MySQL email_marketing Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_emmkt_name | index | name
idx_emmkit_del | index | deleted

MySQL email_marketing_prospect_lists Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
prospect_list_id | varchar | 36
email_marketing_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL email_marketing_prospect_lists Keys:
name | type | fields
--- | --- | ---
primary | primary | id
email_mp_prospects | index | email_marketing_id,prospect_list_id

MySQL email_templates Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | varchar | 36
published | varchar | 3
name | varchar | 255
description | text
subject | varchar | 255
body | longtext
body_html | longtext
deleted | tinyint
assigned_user_id | char | 36
text_only | tinyint
type | varchar | 255

MySQL email_templates Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_email_template_name | index | name

MySQL emailman Definitions:
name | type | len | auto_increment
--- | --- | --- | ---
date_entered | datetime
date_modified | datetime
user_id | char | 36
id | int | 11 | 1
campaign_id | char | 36
marketing_id | char | 36
list_id | char | 36
send_date_time | datetime
modified_user_id | char | 36
in_queue | tinyint
in_queue_date | datetime
send_attempts | int | 11
deleted | tinyint
related_id | char | 36
related_type | varchar | 100
related_confirm_opt_in | tinyint

MySQL emailman Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_eman_list | index | list_id,user_id,deleted
idx_eman_campaign_id | index | campaign_id
idx_eman_relid_reltype_id | index | related_id,related_type,campaign_id

MySQL emails Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
deleted | tinyint
assigned_user_id | char | 36
orphaned | tinyint
last_synced | datetime
date_sent_received | datetime
message_id | varchar | 255
type | varchar | 100
status | varchar | 100
flagged | tinyint
reply_to_status | tinyint
intent | varchar | 100 | pick
mailbox_id | char | 36
parent_type | varchar | 100
parent_id | char | 36
uid | varchar | 255
category_id | varchar | 100

MySQL emails Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_email_name | index | name
idx_message_id | index | message_id
idx_email_parent_id | index | parent_id
idx_email_assigned | index | assigned_user_id,type,status
idx_email_cat | index | category_id

MySQL emails_beans Definitions:
name | type | len
--- | --- | ---
id | char | 36
email_id | char | 36
bean_id | char | 36
bean_module | varchar | 100
campaign_data | text
date_modified | datetime
deleted | tinyint

MySQL emails_beans Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_emails_beans_bean_id | index | bean_id
idx_emails_beans_email_bean | index | email_id,bean_id,deleted

MySQL emails_email_addr_rel Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
email_id | char | 36 | true
address_type | varchar | 4
email_address_id | char | 36 | true
deleted | tinyint

MySQL emails_email_addr_rel Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_eearl_email_id | index | email_id,address_type
idx_eearl_address_id | index | email_address_id

MySQL emails_text Definitions:
name | type | len
--- | --- | ---
email_id | char | 36
from_addr | varchar | 250
reply_to_addr | varchar | 250
to_addrs | text
cc_addrs | text
bcc_addrs | text
description | longtext
description_html | longtext
raw_source | longtext
deleted | tinyint

MySQL emails_text Keys:
name | type | fields
--- | --- | ---
primary | primary | email_id
emails_textfromaddr | index | from_addr

MySQL favorites Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
parent_id | char | 36
parent_type | varchar | 255

MySQL favorites Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL fields_meta_data Definitions:
name | type | len
--- | --- | ---
id | varchar | 255
name | varchar | 255
vname | varchar | 255
comments | varchar | 255
help | varchar | 255
custom_module | varchar | 255
type | varchar | 255
len | int | 11
required | tinyint
default_value | varchar | 255
date_modified | datetime
deleted | tinyint
audited | tinyint
massupdate | tinyint
duplicate_merge | smallint
reportable | tinyint | 1
importable | varchar | 255
ext1 | varchar | 255
ext2 | varchar | 255
ext3 | varchar | 255
ext4 | text

MySQL fields_meta_data Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_meta_id_del | index | id,deleted
idx_meta_cm_del | index | custom_module,deleted

MySQL folders Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
name | varchar | 255
folder_type | varchar | 25
parent_folder | char | 36
has_child | tinyint
is_group | tinyint
is_dynamic | tinyint
dynamic_query | text
assign_to_id | char | 36
created_by | char | 36 | true
modified_by | char | 36 | true
deleted | tinyint

MySQL folders Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_parent_folder | index | parent_folder

MySQL folders_rel Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
folder_id | char | 36 | true
polymorphic_module | varchar | 25
polymorphic_id | char | 36 | true
deleted | tinyint

MySQL folders_rel Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_poly_module_poly_id | index | polymorphic_module,polymorphic_id
idx_fr_id_deleted_poly | index | folder_id,deleted,polymorphic_id

MySQL folders_subscriptions Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
folder_id | char | 36 | true
assigned_user_id | char | 36 | true

MySQL folders_subscriptions Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_folder_id_assigned_user_id | index | folder_id,assigned_user_id

MySQL fp_event_locations Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
address | varchar | 255
address_city | varchar | 100
address_country | varchar | 100
address_postalcode | varchar | 20
address_state | varchar | 100
capacity | varchar | 255

MySQL fp_event_locations Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL fp_event_locations_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL fp_event_locations_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_fp_event_locations_parent_id | index | parent_id

MySQL fp_event_locations_fp_events_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
fp_event_locations_fp_events_1fp_event_locations_ida | varchar | 36
fp_event_locations_fp_events_1fp_events_idb | varchar | 36

MySQL fp_event_locations_fp_events_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
fp_event_locations_fp_events_1_ida1 | index | fp_event_locations_fp_events_1fp_event_locations_ida
fp_event_locations_fp_events_1_alt | index | fp_event_locations_fp_events_1fp_events_idb

MySQL fp_events Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
duration_hours | int | 3
duration_minutes | int | 2
date_start | datetime
date_end | datetime
budget | decimal | 26,6
currency_id | char | 36
invite_templates | varchar | 100
accept_redirect | varchar | 255
decline_redirect | varchar | 255
activity_status_type | varchar | 255

MySQL fp_events Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL fp_events_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL fp_events_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_fp_events_parent_id | index | parent_id

MySQL fp_events_contacts_c Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
fp_events_contactsfp_events_ida | varchar | 36
fp_events_contactscontacts_idb | varchar | 36
invite_status | varchar | 25 | Not Invited
accept_status | varchar | 25 | No Response
email_responded | int | 2

MySQL fp_events_contacts_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
fp_events_contacts_alt | index | fp_events_contactsfp_events_ida,fp_events_contactscontacts_idb

MySQL fp_events_fp_event_delegates_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
fp_events_fp_event_delegates_1fp_events_ida | varchar | 36
fp_events_fp_event_delegates_1fp_event_delegates_idb | varchar | 36

MySQL fp_events_fp_event_delegates_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
fp_events_fp_event_delegates_1_ida1 | index | fp_events_fp_event_delegates_1fp_events_ida
fp_events_fp_event_delegates_1_alt | index | fp_events_fp_event_delegates_1fp_event_delegates_idb

MySQL fp_events_fp_event_locations_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
fp_events_fp_event_locations_1fp_events_ida | varchar | 36
fp_events_fp_event_locations_1fp_event_locations_idb | varchar | 36

MySQL fp_events_fp_event_locations_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
fp_events_fp_event_locations_1_alt | index | fp_events_fp_event_locations_1fp_events_ida,fp_events_fp_event_locations_1fp_event_locations_idb

MySQL fp_events_leads_1_c Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
fp_events_leads_1fp_events_ida | varchar | 36
fp_events_leads_1leads_idb | varchar | 36
invite_status | varchar | 25 | Not Invited
accept_status | varchar | 25 | No Response
email_responded | int | 2

MySQL fp_events_leads_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
fp_events_leads_1_alt | index | fp_events_leads_1fp_events_ida,fp_events_leads_1leads_idb

MySQL fp_events_prospects_1_c Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
fp_events_prospects_1fp_events_ida | varchar | 36
fp_events_prospects_1prospects_idb | varchar | 36
invite_status | varchar | 25 | Not Invited
accept_status | varchar | 25 | No Response
email_responded | int | 2

MySQL fp_events_prospects_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
fp_events_prospects_1_alt | index | fp_events_prospects_1fp_events_ida,fp_events_prospects_1prospects_idb

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

MySQL import_maps Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_owner_module_name | index | assigned_user_id,module,name,deleted

MySQL inbound_email Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
deleted | tinyint
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
name | varchar | 255
status | varchar | 100 | Active
server_url | varchar | 100
email_user | varchar | 100
email_password | varchar | 100
port | int | 5
service | varchar | 50
mailbox | text
delete_seen | tinyint
mailbox_type | varchar | 10
template_id | char | 36
stored_options | text
group_id | char | 36
is_personal | tinyint
groupfolder_id | char | 36

MySQL inbound_email Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL inbound_email_autoreply Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
deleted | tinyint
date_entered | datetime
date_modified | datetime
autoreplied_to | varchar | 100
ie_id | char | 36 | true

MySQL inbound_email_autoreply Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_ie_autoreplied_to | index | autoreplied_to

MySQL inbound_email_cache_ts Definitions:
name | type | len
--- | --- | ---
id | varchar | 255
ie_timestamp | int | 10

MySQL inbound_email_cache_ts Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL jjwg_address_cache Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
lat | float | 10,8
lng | float | 11,8

MySQL jjwg_address_cache Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL jjwg_address_cache_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL jjwg_address_cache_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_jjwg_address_cache_parent_id | index | parent_id

MySQL jjwg_areas Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
city | varchar | 255
state | varchar | 255
country | varchar | 255
coordinates | text

MySQL jjwg_areas Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL jjwg_areas_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL jjwg_areas_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_jjwg_areas_parent_id | index | parent_id

MySQL jjwg_maps Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
distance | float | 9,4
unit_type | varchar | 100 | mi
module_type | varchar | 100 | Accounts
parent_type | varchar | 255
parent_id | char | 36

MySQL jjwg_maps Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL jjwg_maps_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL jjwg_maps_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_jjwg_maps_parent_id | index | parent_id

MySQL jjwg_maps_jjwg_areas_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
jjwg_maps_5304wg_maps_ida | varchar | 36
jjwg_maps_41f2g_areas_idb | varchar | 36

MySQL jjwg_maps_jjwg_areas_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
jjwg_maps_jjwg_areas_alt | index | jjwg_maps_5304wg_maps_ida,jjwg_maps_41f2g_areas_idb

MySQL jjwg_maps_jjwg_markers_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
jjwg_maps_b229wg_maps_ida | varchar | 36
jjwg_maps_2e31markers_idb | varchar | 36

MySQL jjwg_maps_jjwg_markers_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
jjwg_maps_jjwg_markers_alt | index | jjwg_maps_b229wg_maps_ida,jjwg_maps_2e31markers_idb

MySQL jjwg_markers Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
city | varchar | 255
state | varchar | 255
country | varchar | 255
jjwg_maps_lat | float | 10,8 | 0.00000000
jjwg_maps_lng | float | 11,8 | 0.00000000
marker_image | varchar | 100 | company

MySQL jjwg_markers Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL jjwg_markers_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL jjwg_markers_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_jjwg_markers_parent_id | index | parent_id

MySQL job_queue Definitions:
name | type | len
--- | --- | ---
assigned_user_id | char | 36
id | char | 36
name | varchar | 255
deleted | tinyint
date_entered | datetime
date_modified | datetime
scheduler_id | char | 36
execute_time | datetime
status | varchar | 20
resolution | varchar | 20
message | text
target | varchar | 255
data | text
requeue | tinyint
retry_count | tinyint
failure_count | tinyint
job_delay | int | 11
client | varchar | 255
percent_complete | int | 11

MySQL job_queue Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_status_scheduler | index | status,scheduler_id
idx_status_time | index | status,execute_time,date_entered
idx_status_entered | index | status,date_entered
idx_status_modified | index | status,date_modified

MySQL leads Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
salutation | varchar | 255
first_name | varchar | 100
last_name | varchar | 100
title | varchar | 100
photo | varchar | 255
department | varchar | 100
do_not_call | tinyint
phone_home | varchar | 100
phone_mobile | varchar | 100
phone_work | varchar | 100
phone_other | varchar | 100
phone_fax | varchar | 100
lawful_basis | text
date_reviewed | date
lawful_basis_source | varchar | 100
primary_address_street | varchar | 150
primary_address_city | varchar | 100
primary_address_state | varchar | 100
primary_address_postalcode | varchar | 20
primary_address_country | varchar | 255
alt_address_street | varchar | 150
alt_address_city | varchar | 100
alt_address_state | varchar | 100
alt_address_postalcode | varchar | 20
alt_address_country | varchar | 255
assistant | varchar | 75
assistant_phone | varchar | 100
converted | tinyint
refered_by | varchar | 100
lead_source | varchar | 100
lead_source_description | text
status | varchar | 100
status_description | text
reports_to_id | char | 36
account_name | varchar | 255
account_description | text
contact_id | char | 36
account_id | char | 36
opportunity_id | char | 36
opportunity_name | varchar | 255
opportunity_amount | varchar | 50
campaign_id | char | 36
birthdate | date
portal_name | varchar | 255
portal_app | varchar | 255
website | varchar | 255

MySQL leads Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_lead_acct_name_first | index | account_name,deleted
idx_lead_last_first | index | last_name,first_name,deleted
idx_lead_del_stat | index | last_name,status,deleted,first_name
idx_lead_opp_del | index | opportunity_id,deleted
idx_leads_acct_del | index | account_id,deleted
idx_del_user | index | deleted,assigned_user_id
idx_lead_assigned | index | assigned_user_id
idx_lead_contact | index | contact_id
idx_reports_to | index | reports_to_id
idx_lead_phone_work | index | phone_work
idx_leads_id_del | index | id,deleted

MySQL leads_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL leads_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_leads_parent_id | index | parent_id

MySQL leads_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL leads_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL linked_documents Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
parent_id | varchar | 36
parent_type | varchar | 25
document_id | varchar | 36
document_revision_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL linked_documents Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_parent_document | index | parent_type,parent_id,document_id

MySQL meetings Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 50
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
location | varchar | 50
password | varchar | 50
join_url | varchar | 200
host_url | varchar | 400
displayed_url | varchar | 400
creator | varchar | 50
external_id | varchar | 50
duration_hours | int | 3
duration_minutes | int | 2
date_start | datetime
date_end | datetime
parent_type | varchar | 100
status | varchar | 100 | Planned
type | varchar | 255 | Sugar
parent_id | char | 36
reminder_time | int | 11 | -1
email_reminder_time | int | 11 | -1
email_reminder_sent | tinyint
outlook_id | varchar | 255
sequence | int | 11
repeat_type | varchar | 36
repeat_interval | int | 3 | 1
repeat_dow | varchar | 7
repeat_until | date
repeat_count | int | 7
repeat_parent_id | char | 36
recurring_source | varchar | 36
gsync_id | varchar | 1024
gsync_lastsync | int | 11

MySQL meetings Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_mtg_name | index | name
idx_meet_par_del | index | parent_id,parent_type,deleted
idx_meet_stat_del | index | assigned_user_id,status,deleted
idx_meet_date_start | index | date_start

MySQL meetings_contacts Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
meeting_id | varchar | 36
contact_id | varchar | 36
required | varchar | 1 | 1
accept_status | varchar | 25 | none
date_modified | datetime
deleted | tinyint

MySQL meetings_contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_con_mtg_mtg | index | meeting_id
idx_con_mtg_con | index | contact_id
idx_meeting_contact | index | meeting_id,contact_id

MySQL meetings_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL meetings_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL meetings_leads Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
meeting_id | varchar | 36
lead_id | varchar | 36
required | varchar | 1 | 1
accept_status | varchar | 25 | none
date_modified | datetime
deleted | tinyint

MySQL meetings_leads Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_lead_meeting_meeting | index | meeting_id
idx_lead_meeting_lead | index | lead_id
idx_meeting_lead | index | meeting_id,lead_id

MySQL meetings_users Definitions:
name | type | len | default
--- | --- | --- | ---
id | varchar | 36
meeting_id | varchar | 36
user_id | varchar | 36
required | varchar | 1 | 1
accept_status | varchar | 25 | none
date_modified | datetime
deleted | tinyint

MySQL meetings_users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_usr_mtg_mtg | index | meeting_id
idx_usr_mtg_usr | index | user_id
idx_meeting_users | index | meeting_id,user_id

MySQL notes Definitions:
name | type | len
--- | --- | ---
assigned_user_id | char | 36
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
name | varchar | 255
file_mime_type | varchar | 100
filename | varchar | 255
parent_type | varchar | 255
parent_id | char | 36
contact_id | char | 36
portal_flag | tinyint
embed_flag | tinyint
description | text
deleted | tinyint

MySQL notes Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_note_name | index | name
idx_notes_parent | index | parent_id,parent_type
idx_note_contact | index | contact_id
idx_notes_assigned_del | index | deleted,assigned_user_id

MySQL oauth2clients Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
secret | varchar | 4000
redirect_url | varchar | 255
is_confidential | tinyint | 1
allowed_grant_type | varchar | 255 | password
duration_value | int | 11
duration_amount | int | 11
duration_unit | varchar | 255 | Duration Unit
assigned_user_id | char | 36

MySQL oauth2clients Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL oauth2tokens Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
token_is_revoked | tinyint
token_type | varchar | 255
access_token_expires | datetime
access_token | varchar | 4000
refresh_token | varchar | 4000
refresh_token_expires | datetime
grant_type | varchar | 255
state | varchar | 1024
client | char | 36
assigned_user_id | char | 36

MySQL oauth2tokens Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL oauth_consumer Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
c_key | varchar | 255
c_secret | varchar | 255

MySQL oauth_consumer Keys:
name | type | fields
--- | --- | ---
primary | primary | id
ckey | unique | c_key

MySQL oauth_nonce Definitions:
name | type | len
--- | --- | ---
conskey | varchar | 32
nonce | varchar | 32
nonce_ts | bigint

MySQL oauth_nonce Keys:
name | type | fields
--- | --- | ---
primary | primary | conskey,nonce
oauth_nonce_keyts | index | conskey,nonce_ts

MySQL oauth_tokens Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
secret | varchar | 32
tstate | varchar | 1
consumer | char | 36 | true
token_ts | bigint
verify | varchar | 32
deleted | tinyint
callback_url | varchar | 255
assigned_user_id | char | 36

MySQL oauth_tokens Keys:
name | type | fields
--- | --- | ---
primary | primary | id,deleted
oauth_state_ts | index | tstate,token_ts
constoken_key | index | consumer

MySQL opportunities Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 50
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
opportunity_type | varchar | 255
campaign_id | char | 36
lead_source | varchar | 50
amount | double
amount_usdollar | double
currency_id | char | 36
date_closed | date
next_step | varchar | 100
sales_stage | varchar | 255
probability | double

MySQL opportunities Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_opp_name | index | name
idx_opp_assigned | index | assigned_user_id
idx_opp_id_deleted | index | id,deleted

MySQL opportunities_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL opportunities_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_opportunities_parent_id | index | parent_id

MySQL opportunities_contacts Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
contact_id | varchar | 36
opportunity_id | varchar | 36
contact_role | varchar | 50
date_modified | datetime
deleted | tinyint

MySQL opportunities_contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_con_opp_con | index | contact_id
idx_con_opp_opp | index | opportunity_id
idx_opportunities_contacts | index | opportunity_id,contact_id

MySQL opportunities_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL opportunities_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL outbound_email Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
type | varchar | 15 | user
user_id | char | 36 | true
smtp_from_name | varchar | 255
smtp_from_addr | varchar | 255
mail_sendtype | varchar | 8 | smtp
mail_smtptype | varchar | 20 | other
mail_smtpserver | varchar | 100
mail_smtpport | varchar | 5
mail_smtpuser | varchar | 100
mail_smtppass | varchar | 100
mail_smtpauth_req | tinyint
mail_smtpssl | varchar | 1
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
deleted | tinyint
assigned_user_id | char | 36

MySQL outbound_email Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL outbound_email_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL outbound_email_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_outbound_email_parent_id | index | parent_id

MySQL project Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
assigned_user_id | char | 36
modified_user_id | char | 36
created_by | char | 36
name | varchar | 50
description | text
deleted | tinyint
estimated_start_date | date
estimated_end_date | date
status | varchar | 255
priority | varchar | 255
override_business_hours | tinyint

MySQL project Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL project_contacts_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
project_contacts_1project_ida | varchar | 36
project_contacts_1contacts_idb | varchar | 36

MySQL project_contacts_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
project_contacts_1_alt | index | project_contacts_1project_ida,project_contacts_1contacts_idb

MySQL project_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL project_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

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

MySQL project_task Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL project_task_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL project_task_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_project_task_parent_id | index | parent_id

MySQL project_users_1_c Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
project_users_1project_ida | varchar | 36
project_users_1users_idb | varchar | 36

MySQL project_users_1_c Keys:
name | type | fields
--- | --- | ---
primary | primary | id
project_users_1_alt | index | project_users_1project_ida,project_users_1users_idb

MySQL projects_accounts Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
account_id | varchar | 36
project_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL projects_accounts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_proj_acct_proj | index | project_id
idx_proj_acct_acct | index | account_id
projects_accounts_alt | index | project_id,account_id

MySQL projects_bugs Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
bug_id | varchar | 36
project_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL projects_bugs Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_proj_bug_proj | index | project_id
idx_proj_bug_bug | index | bug_id
projects_bugs_alt | index | project_id,bug_id

MySQL projects_cases Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
case_id | varchar | 36
project_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL projects_cases Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_proj_case_proj | index | project_id
idx_proj_case_case | index | case_id
projects_cases_alt | index | project_id,case_id

MySQL projects_contacts Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
contact_id | varchar | 36
project_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL projects_contacts Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_proj_con_proj | index | project_id
idx_proj_con_con | index | contact_id
projects_contacts_alt | index | project_id,contact_id

MySQL projects_opportunities Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
opportunity_id | varchar | 36
project_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL projects_opportunities Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_proj_opp_proj | index | project_id
idx_proj_opp_opp | index | opportunity_id
projects_opportunities_alt | index | project_id,opportunity_id

MySQL projects_products Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
product_id | varchar | 36
project_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL projects_products Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_proj_prod_project | index | project_id
idx_proj_prod_product | index | product_id
projects_products_alt | index | project_id,product_id

MySQL prospect_list_campaigns Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
prospect_list_id | varchar | 36
campaign_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL prospect_list_campaigns Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_pro_id | index | prospect_list_id
idx_cam_id | index | campaign_id
idx_prospect_list_campaigns | index | prospect_list_id,campaign_id

MySQL prospect_lists Definitions:
name | type | len
--- | --- | ---
assigned_user_id | char | 36
id | char | 36
name | varchar | 255
list_type | varchar | 100
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
deleted | tinyint
description | text
domain_name | varchar | 255

MySQL prospect_lists Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_prospect_list_name | index | name

MySQL prospect_lists_prospects Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
prospect_list_id | varchar | 36
related_id | varchar | 36
related_type | varchar | 25
date_modified | datetime
deleted | tinyint

MySQL prospect_lists_prospects Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_plp_pro_id | index | prospect_list_id,deleted
idx_plp_rel_id | index | related_id,related_type,prospect_list_id

MySQL prospects Definitions:
name | type | len | auto_increment | required
--- | --- | --- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
salutation | varchar | 255
first_name | varchar | 100
last_name | varchar | 100
title | varchar | 100
photo | varchar | 255
department | varchar | 255
do_not_call | tinyint
phone_home | varchar | 100
phone_mobile | varchar | 100
phone_work | varchar | 100
phone_other | varchar | 100
phone_fax | varchar | 100
lawful_basis | text
date_reviewed | date
lawful_basis_source | varchar | 100
primary_address_street | varchar | 150
primary_address_city | varchar | 100
primary_address_state | varchar | 100
primary_address_postalcode | varchar | 20
primary_address_country | varchar | 255
alt_address_street | varchar | 150
alt_address_city | varchar | 100
alt_address_state | varchar | 100
alt_address_postalcode | varchar | 20
alt_address_country | varchar | 255
assistant | varchar | 75
assistant_phone | varchar | 100
tracker_key | int | 11 | 1 | true
birthdate | date
lead_id | char | 36
account_name | varchar | 150
campaign_id | char | 36

MySQL prospects Keys:
name | type | fields
--- | --- | ---
primary | primary | id
prospect_auto_tracker_key | index | tracker_key
idx_prospects_last_first | index | last_name,first_name,deleted
idx_prospecs_del_last | index | last_name,deleted
idx_prospects_id_del | index | id,deleted
idx_prospects_assigned | index | assigned_user_id

MySQL prospects_cstm Definitions:
name | type | len | default
--- | --- | --- | ---
id_c | char | 36
jjwg_maps_lng_c | float | 11,8 | 0.00000000
jjwg_maps_lat_c | float | 10,8 | 0.00000000
jjwg_maps_geocode_status_c | varchar | 255
jjwg_maps_address_c | varchar | 255

MySQL prospects_cstm Keys:
name | type | fields
--- | --- | ---
primary | primary | id_c

MySQL relationships Definitions:
name | type | len
--- | --- | ---
id | char | 36
relationship_name | varchar | 150
lhs_module | varchar | 100
lhs_table | varchar | 64
lhs_key | varchar | 64
rhs_module | varchar | 100
rhs_table | varchar | 64
rhs_key | varchar | 64
join_table | varchar | 64
join_key_lhs | varchar | 64
join_key_rhs | varchar | 64
relationship_type | varchar | 64
relationship_role_column | varchar | 64
relationship_role_column_value | varchar | 50
reverse | tinyint
deleted | tinyint

MySQL relationships Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_rel_name | index | relationship_name

MySQL releases Definitions:
name | type | len
--- | --- | ---
id | char | 36
deleted | tinyint
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
name | varchar | 50
list_order | int | 4
status | varchar | 100

MySQL releases Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_releases | index | name,deleted

MySQL reminders Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
popup | tinyint
email | tinyint
email_sent | tinyint
timer_popup | varchar | 32
timer_email | varchar | 32
related_event_module | varchar | 32
related_event_module_id | char | 36 | true
date_willexecute | int | 60 | -1
popup_viewed | tinyint

MySQL reminders Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_reminder_name | index | name
idx_reminder_deleted | index | deleted
idx_reminder_related_event_module | index | related_event_module
idx_reminder_related_event_module_id | index | related_event_module_id

MySQL reminders_invitees Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
reminder_id | char | 36 | true
related_invitee_module | varchar | 32
related_invitee_module_id | char | 36 | true

MySQL reminders_invitees Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_reminder_invitee_name | index | name
idx_reminder_invitee_assigned_user_id | index | assigned_user_id
idx_reminder_invitee_reminder_id | index | reminder_id
idx_reminder_invitee_related_invitee_module | index | related_invitee_module
idx_reminder_invitee_related_invitee_module_id | index | related_invitee_module_id

MySQL roles Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
name | varchar | 150
description | text
modules | text
deleted | tinyint

MySQL roles Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_role_id_del | index | id,deleted

MySQL roles_modules Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
role_id | varchar | 36
module_id | varchar | 36
allow | tinyint
date_modified | datetime
deleted | tinyint

MySQL roles_modules Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_role_id | index | role_id
idx_module_id | index | module_id

MySQL roles_users Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
role_id | varchar | 36
user_id | varchar | 36
date_modified | datetime
deleted | tinyint

MySQL roles_users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_ru_role_id | index | role_id
idx_ru_user_id | index | user_id

MySQL saved_search Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 150
search_module | varchar | 150
deleted | tinyint
date_entered | datetime
date_modified | datetime
assigned_user_id | char | 36
contents | text
description | text

MySQL saved_search Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_desc | index | name,deleted

MySQL schedulers Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
deleted | tinyint
date_entered | datetime
date_modified | datetime
created_by | char | 36
modified_user_id | char | 36
name | varchar | 255
job | varchar | 255
date_time_start | datetime
date_time_end | datetime
job_interval | varchar | 100
time_from | time
time_to | time
last_run | datetime
status | varchar | 100
catch_up | tinyint | 1

MySQL schedulers Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_schedule | index | date_time_start,deleted

MySQL securitygroups Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
noninheritable | tinyint

MySQL securitygroups Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL securitygroups_acl_roles Definitions:
name | type | len
--- | --- | ---
id | char | 36
securitygroup_id | char | 36
role_id | char | 36
date_modified | datetime
deleted | tinyint

MySQL securitygroups_acl_roles Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL securitygroups_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL securitygroups_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_securitygroups_parent_id | index | parent_id

MySQL securitygroups_default Definitions:
name | type | len
--- | --- | ---
id | char | 36
securitygroup_id | char | 36
module | varchar | 50
date_modified | datetime
deleted | tinyint

MySQL securitygroups_default Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL securitygroups_records Definitions:
name | type | len
--- | --- | ---
id | char | 36
securitygroup_id | char | 36
record_id | char | 36
module | char | 36
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
deleted | tinyint

MySQL securitygroups_records Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_securitygroups_records_mod | index | module,deleted,record_id,securitygroup_id
idx_securitygroups_records_del | index | deleted,record_id,module,securitygroup_id

MySQL securitygroups_users Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
securitygroup_id | varchar | 36
user_id | varchar | 36
primary_group | tinyint
noninheritable | tinyint

MySQL securitygroups_users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
securitygroups_users_idxa | index | securitygroup_id
securitygroups_users_idxb | index | user_id
securitygroups_users_idxc | index | user_id,deleted,securitygroup_id,id
securitygroups_users_idxd | index | user_id,deleted,securitygroup_id

MySQL spots Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
config | longtext
type | varchar | 255

MySQL spots Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL sugarfeed Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
related_module | varchar | 100
related_id | char | 36
link_url | varchar | 255
link_type | varchar | 30

MySQL sugarfeed Keys:
name | type | fields
--- | --- | ---
primary | primary | id
sgrfeed_date | index | date_entered,deleted

MySQL surveyquestionoptions Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
sort_order | int | 255
survey_question_id | char | 36

MySQL surveyquestionoptions Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL surveyquestionoptions_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL surveyquestionoptions_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_surveyquestionoptions_parent_id | index | parent_id

MySQL surveyquestionoptions_surveyquestionresponses Definitions:
name | type | len
--- | --- | ---
id | varchar | 36
date_modified | datetime
deleted | tinyint
surveyq72c7options_ida | varchar | 36
surveyq10d4sponses_idb | varchar | 36

MySQL surveyquestionoptions_surveyquestionresponses Keys:
name | type | fields
--- | --- | ---
primary | primary | id
surveyquestionoptions_surveyquestionresponses_alt | index | surveyq72c7options_ida,surveyq10d4sponses_idb

MySQL surveyquestionresponses Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
answer | text
answer_bool | tinyint
answer_datetime | datetime
surveyquestion_id | char | 36
surveyresponse_id | char | 36

MySQL surveyquestionresponses Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL surveyquestionresponses_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL surveyquestionresponses_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_surveyquestionresponses_parent_id | index | parent_id

MySQL surveyquestions Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
sort_order | int | 255
type | varchar | 100
happiness_question | tinyint
survey_id | char | 36

MySQL surveyquestions Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL surveyquestions_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL surveyquestions_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_surveyquestions_parent_id | index | parent_id

MySQL surveyresponses Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
happiness | int | 11
email_response_sent | tinyint
account_id | char | 36
campaign_id | char | 36
contact_id | char | 36
survey_id | char | 36

MySQL surveyresponses Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL surveyresponses_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL surveyresponses_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_surveyresponses_parent_id | index | parent_id

MySQL surveys Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
status | varchar | 100 | Draft
submit_text | varchar | 255 | Submit
satisfied_text | varchar | 255 | Satisfied
neither_text | varchar | 255 | Neither Satisfied nor Dissatisfied
dissatisfied_text | varchar | 255 | Dissatisfied

MySQL surveys Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL surveys_audit Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
parent_id | char | 36 | true
date_created | datetime
created_by | varchar | 36
field_name | varchar | 100
data_type | varchar | 100
before_value_string | varchar | 255
after_value_string | varchar | 255
before_value_text | text
after_value_text | text

MySQL surveys_audit Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_surveys_parent_id | index | parent_id

MySQL tasks Definitions:
name | type | len | default
--- | --- | --- | ---
id | char | 36
name | varchar | 50
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
assigned_user_id | char | 36
status | varchar | 100 | Not Started
date_due_flag | tinyint
date_due | datetime
date_start_flag | tinyint
date_start | datetime
parent_type | varchar | 255
parent_id | char | 36
contact_id | char | 36
priority | varchar | 100

MySQL tasks Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_tsk_name | index | name
idx_task_con_del | index | contact_id,deleted
idx_task_par_del | index | parent_id,parent_type,deleted
idx_task_assigned | index | assigned_user_id
idx_task_status | index | status

MySQL templatesectionline Definitions:
name | type | len
--- | --- | ---
id | char | 36
name | varchar | 255
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
description | text
deleted | tinyint
thumbnail | varchar | 255
grp | varchar | 255
ord | int | 11

MySQL templatesectionline Keys:
name | type | fields
--- | --- | ---
primary | primary | id

MySQL tracker Definitions:
name | type | len | auto_increment
--- | --- | --- | ---
id | int | 11 | 1
monitor_id | char | 36 | true
user_id | varchar | 36
module_name | varchar | 255
item_id | varchar | 36
item_summary | varchar | 255
date_modified | datetime
action | varchar | 255
session_id | varchar | 36
visible | tinyint
deleted | tinyint

MySQL tracker Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_tracker_iid | index | item_id
idx_tracker_userid_vis_id | index | user_id,visible,id
idx_tracker_userid_itemid_vis | index | user_id,item_id,visible
idx_tracker_monitor_id | index | monitor_id
idx_tracker_date_modified | index | date_modified

MySQL upgrade_history Definitions:
name | type | len
--- | --- | ---
id | char | 36
filename | varchar | 255
md5sum | varchar | 32
type | varchar | 30
status | varchar | 50
version | varchar | 64
name | varchar | 255
description | text
id_name | varchar | 255
manifest | longtext
date_entered | datetime
enabled | tinyint | 1

MySQL upgrade_history Keys:
name | type | fields
--- | --- | ---
primary | primary | id
upgrade_history_md5_uk | unique | md5sum

MySQL user_preferences Definitions:
name | type | len
--- | --- | ---
id | char | 36
category | varchar | 50
deleted | tinyint
date_entered | datetime
date_modified | datetime
assigned_user_id | char | 36
contents | longtext

MySQL user_preferences Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_userprefnamecat | index | assigned_user_id,category

MySQL users Definitions:
name | type | len
--- | --- | ---
id | char | 36
user_name | varchar | 60
user_hash | varchar | 255
system_generated_password | tinyint
pwd_last_changed | datetime
authenticate_id | varchar | 100
sugar_login | tinyint | 1
first_name | varchar | 255
last_name | varchar | 255
is_admin | tinyint
external_auth_only | tinyint
receive_notifications | tinyint | 1
description | text
date_entered | datetime
date_modified | datetime
modified_user_id | char | 36
created_by | char | 36
title | varchar | 50
photo | varchar | 255
department | varchar | 50
phone_home | varchar | 50
phone_mobile | varchar | 50
phone_work | varchar | 50
phone_other | varchar | 50
phone_fax | varchar | 50
status | varchar | 100
address_street | varchar | 150
address_city | varchar | 100
address_state | varchar | 100
address_country | varchar | 100
address_postalcode | varchar | 20
deleted | tinyint
portal_only | tinyint
show_on_employees | tinyint | 1
employee_status | varchar | 100
messenger_id | varchar | 100
messenger_type | varchar | 100
reports_to_id | char | 36
is_group | tinyint
factor_auth | tinyint
factor_auth_interface | varchar | 255

MySQL users Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_user_name | index | user_name,is_group,status,last_name,first_name,id

MySQL users_feeds Definitions:
name | type | len
--- | --- | ---
user_id | varchar | 36
feed_id | varchar | 36
rank | int | 11
date_modified | datetime
deleted | tinyint

MySQL users_feeds Keys:
name | type | fields
--- | --- | ---
idx_ud_user_id | index | user_id,feed_id

MySQL users_last_import Definitions:
name | type | len
--- | --- | ---
id | char | 36
assigned_user_id | char | 36
import_module | varchar | 36
bean_type | varchar | 36
bean_id | char | 36
deleted | tinyint

MySQL users_last_import Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_user_id | index | assigned_user_id

MySQL users_password_link Definitions:
name | type | len
--- | --- | ---
id | char | 36
username | varchar | 36
date_generated | datetime
deleted | tinyint
user_id | varchar | 36

MySQL users_password_link Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_username | index | username

MySQL users_signatures Definitions:
name | type | len
--- | --- | ---
id | char | 36
date_entered | datetime
date_modified | datetime
deleted | tinyint
user_id | varchar | 36
name | varchar | 255
signature | text
signature_html | text

MySQL users_signatures Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_usersig_uid | index | user_id

MySQL vcals Definitions:
name | type | len | required
--- | --- | --- | ---
id | char | 36
deleted | tinyint
date_entered | datetime
date_modified | datetime
user_id | char | 36 | true
type | varchar | 100
source | varchar | 100
content | text

MySQL vcals Keys:
name | type | fields
--- | --- | ---
primary | primary | id
idx_vcal | index | type,user_id