MySQL accounts Definitions:
nametypelen
idchar36
namevarchar150
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
account_typevarchar50
industryvarchar50
annual_revenuevarchar100
phone_faxvarchar100
billing_address_streetvarchar150
billing_address_cityvarchar100
billing_address_statevarchar100
billing_address_postalcodevarchar20
billing_address_countryvarchar255
ratingvarchar100
phone_officevarchar100
phone_alternatevarchar100
websitevarchar255
ownershipvarchar100
employeesvarchar10
ticker_symbolvarchar10
shipping_address_streetvarchar150
shipping_address_cityvarchar100
shipping_address_statevarchar100
shipping_address_postalcodevarchar20
shipping_address_countryvarchar255
parent_idchar36
sic_codevarchar10
campaign_idchar36
MySQL accounts Keys:
nametypefields
primaryprimaryid
idx_accnt_id_delindexid,deleted
idx_accnt_name_delindexname,deleted
idx_accnt_assigned_delindexdeleted,assigned_user_id
idx_accnt_parent_idindexparent_id


MySQL accounts_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL accounts_audit Keys:
nametypefields
primaryprimaryid
idx_accounts_parent_idindexparent_id


MySQL accounts_bugs Definitions:
nametypelen
idvarchar36
account_idvarchar36
bug_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL accounts_bugs Keys:
nametypefields
primaryprimaryid
idx_acc_bug_accindexaccount_id
idx_acc_bug_bugindexbug_id
idx_account_bugindexaccount_id,bug_id


MySQL accounts_cases Definitions:
nametypelen
idvarchar36
account_idvarchar36
case_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL accounts_cases Keys:
nametypefields
primaryprimaryid
idx_acc_case_accindexaccount_id
idx_acc_acc_caseindexcase_id


MySQL accounts_contacts Definitions:
nametypelen
idvarchar36
contact_idvarchar36
account_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL accounts_contacts Keys:
nametypefields
primaryprimaryid
idx_account_contactindexaccount_id,contact_id
idx_contid_del_accidindexcontact_id,deleted,account_id


MySQL accounts_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL accounts_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL accounts_opportunities Definitions:
nametypelen
idvarchar36
opportunity_idvarchar36
account_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL accounts_opportunities Keys:
nametypefields
primaryprimaryid
idx_account_opportunityindexaccount_id,opportunity_id
idx_oppid_del_accidindexopportunity_id,deleted,account_id


MySQL acl_actions Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar150
categoryvarchar100
acltypevarchar100
aclaccessint3
deletedtinyint
MySQL acl_actions Keys:
nametypefields
primaryprimaryid
idx_aclaction_id_delindexid,deleted
idx_category_nameindexcategory,name


MySQL acl_roles Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar150
descriptiontext
deletedtinyint
MySQL acl_roles Keys:
nametypefields
primaryprimaryid
idx_aclrole_id_delindexid,deleted


MySQL acl_roles_actions Definitions:
nametypelen
idvarchar36
role_idvarchar36
action_idvarchar36
access_overrideint3
date_modifieddatetime
deletedtinyint
MySQL acl_roles_actions Keys:
nametypefields
primaryprimaryid
idx_acl_role_idindexrole_id
idx_acl_action_idindexaction_id
idx_aclrole_actionindexrole_id,action_id


MySQL acl_roles_users Definitions:
nametypelen
idvarchar36
role_idvarchar36
user_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL acl_roles_users Keys:
nametypefields
primaryprimaryid
idx_aclrole_idindexrole_id
idx_acluser_idindexuser_id
idx_aclrole_userindexrole_id,user_id


MySQL adb01_aldibo Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
aldibovarchar255
accountvarchar255
MySQL adb01_aldibo Keys:
nametypefields
primaryprimaryid


MySQL adb01_aldibo_accounts_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
adb01_aldibo_accounts_1adb01_aldibo_idavarchar36
adb01_aldibo_accounts_1accounts_idbvarchar36
MySQL adb01_aldibo_accounts_1_c Keys:
nametypefields
primaryprimaryid
adb01_aldibo_accounts_1_ida1indexadb01_aldibo_accounts_1adb01_aldibo_ida
adb01_aldibo_accounts_1_idb2indexadb01_aldibo_accounts_1accounts_idb


MySQL adb01_aldibo_accounts_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
adb01_aldibo_accountsadb01_aldibo_idavarchar36
adb01_aldibo_accountsaccounts_idbvarchar36
MySQL adb01_aldibo_accounts_c Keys:
nametypefields
primaryprimaryid
adb01_aldibo_accounts_ida1indexadb01_aldibo_accountsadb01_aldibo_ida
adb01_aldibo_accounts_idb2indexadb01_aldibo_accountsaccounts_idb


MySQL adb01_aldibo_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL adb01_aldibo_audit Keys:
nametypefields
primaryprimaryid
idx_adb01_aldibo_parent_idindexparent_id


MySQL adb01_aldibo_cstm Definitions:
nametypelen
id_cchar36
accoount_cvarchar255
MySQL adb01_aldibo_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL address_book Definitions:
nametypelenrequired
assigned_user_idchar36true
beanvarchar50
bean_idchar36true
MySQL address_book Keys:
nametypefields
ab_user_bean_idxindexassigned_user_id,bean


MySQL alerts Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
is_readtinyint
target_modulevarchar255
typevarchar255
url_redirectvarchar255
reminder_idchar36
MySQL alerts Keys:
nametypefields
primaryprimaryid


MySQL am_projecttemplates Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
statusvarchar100Draft
priorityvarchar100High
override_business_hourstinyint
MySQL am_projecttemplates Keys:
nametypefields
primaryprimaryid


MySQL am_projecttemplates_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL am_projecttemplates_audit Keys:
nametypefields
primaryprimaryid
idx_am_projecttemplates_parent_idindexparent_id


MySQL am_projecttemplates_contacts_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
am_projecttemplates_idavarchar36
contacts_idbvarchar36
MySQL am_projecttemplates_contacts_1_c Keys:
nametypefields
primaryprimaryid
am_projecttemplates_contacts_1_altindexam_projecttemplates_ida,contacts_idb


MySQL am_projecttemplates_project_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
am_projecttemplates_project_1am_projecttemplates_idavarchar36
am_projecttemplates_project_1project_idbvarchar36
MySQL am_projecttemplates_project_1_c Keys:
nametypefields
primaryprimaryid
am_projecttemplates_project_1_ida1indexam_projecttemplates_project_1am_projecttemplates_ida
am_projecttemplates_project_1_altindexam_projecttemplates_project_1project_idb


MySQL am_projecttemplates_users_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
am_projecttemplates_idavarchar36
users_idbvarchar36
MySQL am_projecttemplates_users_1_c Keys:
nametypefields
primaryprimaryid
am_projecttemplates_users_1_altindexam_projecttemplates_ida,users_idb


MySQL am_tasktemplates Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
statusvarchar100Not Started
priorityvarchar100High
percent_completeint255
predecessorsint255
milestone_flagtinyint
relationship_typevarchar100FS
task_numberint255
order_numberint255
estimated_effortint255
utilizationvarchar100
durationint255
MySQL am_tasktemplates Keys:
nametypefields
primaryprimaryid


MySQL am_tasktemplates_am_projecttemplates_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
am_tasktemplates_am_projecttemplatesam_projecttemplates_idavarchar36
am_tasktemplates_am_projecttemplatesam_tasktemplates_idbvarchar36
MySQL am_tasktemplates_am_projecttemplates_c Keys:
nametypefields
primaryprimaryid
am_tasktemplates_am_projecttemplates_ida1indexam_tasktemplates_am_projecttemplatesam_projecttemplates_ida
am_tasktemplates_am_projecttemplates_altindexam_tasktemplates_am_projecttemplatesam_tasktemplates_idb


MySQL am_tasktemplates_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL am_tasktemplates_audit Keys:
nametypefields
primaryprimaryid
idx_am_tasktemplates_parent_idindexparent_id


MySQL aobh_businesshours Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
opening_hoursvarchar1001
closing_hoursvarchar1001
open_statustinyint
dayvarchar100monday
MySQL aobh_businesshours Keys:
nametypefields
primaryprimaryid


MySQL aod_index Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
last_optimiseddatetime
locationvarchar255
MySQL aod_index Keys:
nametypefields
primaryprimaryid


MySQL aod_index_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aod_index_audit Keys:
nametypefields
primaryprimaryid
idx_aod_index_parent_idindexparent_id


MySQL aod_indexevent Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
errorvarchar255
successtinyint
record_idchar36
record_modulevarchar255
MySQL aod_indexevent Keys:
nametypefields
primaryprimaryid
idx_record_moduleindexrecord_module
idx_record_idindexrecord_id


MySQL aod_indexevent_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aod_indexevent_audit Keys:
nametypefields
primaryprimaryid
idx_aod_indexevent_parent_idindexparent_id


MySQL aok_knowledge_base_categories Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
MySQL aok_knowledge_base_categories Keys:
nametypefields
primaryprimaryid


MySQL aok_knowledge_base_categories_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aok_knowledge_base_categories_audit Keys:
nametypefields
primaryprimaryid
idx_aok_knowledge_base_categories_parent_idindexparent_id


MySQL aok_knowledgebase Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
statusvarchar100Draft
revisionvarchar255
additional_infotext
user_id_cchar36
user_id1_cchar36
MySQL aok_knowledgebase Keys:
nametypefields
primaryprimaryid


MySQL aok_knowledgebase_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aok_knowledgebase_audit Keys:
nametypefields
primaryprimaryid
idx_aok_knowledgebase_parent_idindexparent_id


MySQL aok_knowledgebase_categories Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
aok_knowledgebase_idvarchar36
aok_knowledge_base_categories_idvarchar36
MySQL aok_knowledgebase_categories Keys:
nametypefields
primaryprimaryid
aok_knowledgebase_categories_altindexaok_knowledgebase_id,aok_knowledge_base_categories_id


MySQL aop_case_events Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
case_idchar36
MySQL aop_case_events Keys:
nametypefields
primaryprimaryid


MySQL aop_case_events_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aop_case_events_audit Keys:
nametypefields
primaryprimaryid
idx_aop_case_events_parent_idindexparent_id


MySQL aop_case_updates Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
case_idchar36
contact_idchar36
internaltinyint
MySQL aop_case_updates Keys:
nametypefields
primaryprimaryid


MySQL aop_case_updates_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aop_case_updates_audit Keys:
nametypefields
primaryprimaryid
idx_aop_case_updates_parent_idindexparent_id


MySQL aor_charts Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
aor_report_idchar36
typevarchar100
x_fieldint11
y_fieldint11
MySQL aor_charts Keys:
nametypefields
primaryprimaryid


MySQL aor_conditions Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
aor_report_idchar36
condition_orderint255
logic_opvarchar255
parenthesisvarchar255
module_pathlongtext
fieldvarchar100
operatorvarchar100
value_typevarchar100
valuevarchar255
parametertinyint
MySQL aor_conditions Keys:
nametypefields
primaryprimaryid
aor_conditions_index_report_idindexaor_report_id


MySQL aor_fields Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
aor_report_idchar36
field_orderint255
module_pathlongtext
fieldvarchar100
displaytinyint
linktinyint
labelvarchar255
field_functionvarchar100
sort_byvarchar100
formatvarchar100
totalvarchar100
sort_ordervarchar100
group_bytinyint
group_ordervarchar100
group_displayint11
MySQL aor_fields Keys:
nametypefields
primaryprimaryid
aor_fields_index_report_idindexaor_report_id


MySQL aor_reports Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
report_modulevarchar100
graphs_per_rowint112
MySQL aor_reports Keys:
nametypefields
primaryprimaryid


MySQL aor_reports_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aor_reports_audit Keys:
nametypefields
primaryprimaryid
idx_aor_reports_parent_idindexparent_id


MySQL aor_scheduled_reports Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
schedulevarchar100
last_rundatetime
statusvarchar100
email_recipientslongtext
aor_report_idchar36
MySQL aor_scheduled_reports Keys:
nametypefields
primaryprimaryid


MySQL aos_contracts Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
reference_codevarchar255
start_datedate
end_datedate
total_contract_valuedecimal26,6
total_contract_value_usdollardecimal26,6
currency_idchar36
statusvarchar100Not Started
customer_signed_datedate
company_signed_datedate
renewal_reminder_datedatetime
contract_typevarchar100Type
contract_account_idchar36
opportunity_idchar36
contact_idchar36
call_idchar36
total_amtdecimal26,6
total_amt_usdollardecimal26,6
subtotal_amountdecimal26,6
subtotal_amount_usdollardecimal26,6
discount_amountdecimal26,6
discount_amount_usdollardecimal26,6
tax_amountdecimal26,6
tax_amount_usdollardecimal26,6
shipping_amountdecimal26,6
shipping_amount_usdollardecimal26,6
shipping_taxvarchar100
shipping_tax_amtdecimal26,6
shipping_tax_amt_usdollardecimal26,6
total_amountdecimal26,6
total_amount_usdollardecimal26,6
MySQL aos_contracts Keys:
nametypefields
primaryprimaryid


MySQL aos_contracts_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_contracts_audit Keys:
nametypefields
primaryprimaryid
idx_aos_contracts_parent_idindexparent_id


MySQL aos_contracts_documents Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
aos_contracts_idvarchar36
documents_idvarchar36
document_revision_idvarchar36
MySQL aos_contracts_documents Keys:
nametypefields
primaryprimaryid
aos_contracts_documents_altindexaos_contracts_id,documents_id


MySQL aos_invoices Definitions:
nametypelenrequired
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
billing_account_idchar36
billing_contact_idchar36
billing_address_streetvarchar150
billing_address_cityvarchar100
billing_address_statevarchar100
billing_address_postalcodevarchar20
billing_address_countryvarchar255
shipping_address_streetvarchar150
shipping_address_cityvarchar100
shipping_address_statevarchar100
shipping_address_postalcodevarchar20
shipping_address_countryvarchar255
numberint11true
total_amtdecimal26,6
total_amt_usdollardecimal26,6
subtotal_amountdecimal26,6
subtotal_amount_usdollardecimal26,6
discount_amountdecimal26,6
discount_amount_usdollardecimal26,6
tax_amountdecimal26,6
tax_amount_usdollardecimal26,6
shipping_amountdecimal26,6
shipping_amount_usdollardecimal26,6
shipping_taxvarchar100
shipping_tax_amtdecimal26,6
shipping_tax_amt_usdollardecimal26,6
total_amountdecimal26,6
total_amount_usdollardecimal26,6
currency_idchar36
quote_numberint11
quote_datedate
invoice_datedate
due_datedate
statusvarchar100
template_ddown_ctext
subtotal_tax_amountdecimal26,6
subtotal_tax_amount_usdollardecimal26,6
MySQL aos_invoices Keys:
nametypefields
primaryprimaryid


MySQL aos_invoices_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_invoices_audit Keys:
nametypefields
primaryprimaryid
idx_aos_invoices_parent_idindexparent_id


MySQL aos_line_item_groups Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
total_amtdecimal26,6
total_amt_usdollardecimal26,6
discount_amountdecimal26,6
discount_amount_usdollardecimal26,6
subtotal_amountdecimal26,6
subtotal_amount_usdollardecimal26,6
tax_amountdecimal26,6
tax_amount_usdollardecimal26,6
subtotal_tax_amountdecimal26,6
subtotal_tax_amount_usdollardecimal26,6
total_amountdecimal26,6
total_amount_usdollardecimal26,6
parent_typevarchar100
parent_idchar36
numberint11
currency_idchar36
MySQL aos_line_item_groups Keys:
nametypefields
primaryprimaryid


MySQL aos_line_item_groups_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_line_item_groups_audit Keys:
nametypefields
primaryprimaryid
idx_aos_line_item_groups_parent_idindexparent_id


MySQL aos_pdf_templates Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptionlongtext
deletedtinyint
assigned_user_idchar36
activetinyint1
typevarchar100
pdfheadertext
pdffootertext
margin_leftint25515
margin_rightint25515
margin_topint25516
margin_bottomint25516
margin_headerint2559
margin_footerint2559
page_sizevarchar100
orientationvarchar100
MySQL aos_pdf_templates Keys:
nametypefields
primaryprimaryid


MySQL aos_pdf_templates_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_pdf_templates_audit Keys:
nametypefields
primaryprimaryid
idx_aos_pdf_templates_parent_idindexparent_id


MySQL aos_product_categories Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
is_parenttinyint
parent_category_idchar36
MySQL aos_product_categories Keys:
nametypefields
primaryprimaryid


MySQL aos_product_categories_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_product_categories_audit Keys:
nametypefields
primaryprimaryid
idx_aos_product_categories_parent_idindexparent_id


MySQL aos_products Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
maincodevarchar100XXXX
part_numbervarchar25
categoryvarchar100
typevarchar100Good
costdecimal26,6
cost_usdollardecimal26,6
currency_idchar36
pricedecimal26,6
price_usdollardecimal26,6
urlvarchar255
contact_idchar36
product_imagevarchar255
aos_product_category_idchar36
MySQL aos_products Keys:
nametypefields
primaryprimaryid


MySQL aos_products_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_products_audit Keys:
nametypefields
primaryprimaryid
idx_aos_products_parent_idindexparent_id


MySQL aos_products_quotes Definitions:
nametypelendefault
idchar36
nametext
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
currency_idchar36
part_numbervarchar255
item_descriptiontext
numberint11
product_qtydecimal18,4
product_cost_pricedecimal26,6
product_cost_price_usdollardecimal26,6
product_list_pricedecimal26,6
product_list_price_usdollardecimal26,6
product_discountdecimal26,6
product_discount_usdollardecimal26,6
product_discount_amountdecimal26,6
product_discount_amount_usdollardecimal26,6
discountvarchar255Percentage
product_unit_pricedecimal26,6
product_unit_price_usdollardecimal26,6
vat_amtdecimal26,6
vat_amt_usdollardecimal26,6
product_total_pricedecimal26,6
product_total_price_usdollardecimal26,6
vatvarchar1005.0
parent_typevarchar100
parent_idchar36
product_idchar36
group_idchar36
MySQL aos_products_quotes Keys:
nametypefields
primaryprimaryid
idx_aospq_par_delindexparent_id,parent_type,deleted


MySQL aos_products_quotes_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_products_quotes_audit Keys:
nametypefields
primaryprimaryid
idx_aos_products_quotes_parent_idindexparent_id


MySQL aos_quotes Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
approval_issuetext
billing_account_idchar36
billing_contact_idchar36
billing_address_streetvarchar150
billing_address_cityvarchar100
billing_address_statevarchar100
billing_address_postalcodevarchar20
billing_address_countryvarchar255
shipping_address_streetvarchar150
shipping_address_cityvarchar100
shipping_address_statevarchar100
shipping_address_postalcodevarchar20
shipping_address_countryvarchar255
expirationdate
numberint11
opportunity_idchar36
template_ddown_ctext
total_amtdecimal26,6
total_amt_usdollardecimal26,6
subtotal_amountdecimal26,6
subtotal_amount_usdollardecimal26,6
discount_amountdecimal26,6
discount_amount_usdollardecimal26,6
tax_amountdecimal26,6
tax_amount_usdollardecimal26,6
shipping_amountdecimal26,6
shipping_amount_usdollardecimal26,6
shipping_taxvarchar100
shipping_tax_amtdecimal26,6
shipping_tax_amt_usdollardecimal26,6
total_amountdecimal26,6
total_amount_usdollardecimal26,6
currency_idchar36
stagevarchar100Draft
termvarchar100
terms_ctext
approval_statusvarchar100
invoice_statusvarchar100Not Invoiced
subtotal_tax_amountdecimal26,6
subtotal_tax_amount_usdollardecimal26,6
MySQL aos_quotes Keys:
nametypefields
primaryprimaryid


MySQL aos_quotes_aos_invoices_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
aos_quotes77d9_quotes_idavarchar36
aos_quotes6b83nvoices_idbvarchar36
MySQL aos_quotes_aos_invoices_c Keys:
nametypefields
primaryprimaryid
aos_quotes_aos_invoices_altindexaos_quotes77d9_quotes_ida,aos_quotes6b83nvoices_idb


MySQL aos_quotes_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aos_quotes_audit Keys:
nametypefields
primaryprimaryid
idx_aos_quotes_parent_idindexparent_id


MySQL aos_quotes_os_contracts_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
aos_quotese81e_quotes_idavarchar36
aos_quotes4dc0ntracts_idbvarchar36
MySQL aos_quotes_os_contracts_c Keys:
nametypefields
primaryprimaryid
aos_quotes_aos_contracts_altindexaos_quotese81e_quotes_ida,aos_quotes4dc0ntracts_idb


MySQL aos_quotes_project_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
aos_quotes1112_quotes_idavarchar36
aos_quotes7207project_idbvarchar36
MySQL aos_quotes_project_c Keys:
nametypefields
primaryprimaryid
aos_quotes_project_altindexaos_quotes1112_quotes_ida,aos_quotes7207project_idb


MySQL aow_actions Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
aow_workflow_idchar36
action_orderint255
actionvarchar100
parameterslongtext
MySQL aow_actions Keys:
nametypefields
primaryprimaryid
aow_action_index_workflow_idindexaow_workflow_id


MySQL aow_conditions Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
aow_workflow_idchar36
condition_orderint255
module_pathlongtext
fieldvarchar100
operatorvarchar100
value_typevarchar255
valuevarchar255
MySQL aow_conditions Keys:
nametypefields
primaryprimaryid
aow_conditions_index_workflow_idindexaow_workflow_id


MySQL aow_processed Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
aow_workflow_idchar36
parent_idchar36
parent_typevarchar100
statusvarchar100Pending
MySQL aow_processed Keys:
nametypefields
primaryprimaryid
aow_processed_index_workflowindexaow_workflow_id,status,parent_id,deleted
aow_processed_index_statusindexstatus
aow_processed_index_workflow_idindexaow_workflow_id


MySQL aow_processed_aow_actions Definitions:
nametypelendefault
idvarchar36
aow_processed_idvarchar36
aow_action_idvarchar36
statusvarchar36Pending
date_modifieddatetime
deletedtinyint
MySQL aow_processed_aow_actions Keys:
nametypefields
primaryprimaryid
idx_aow_processed_aow_actionsindexaow_processed_id,aow_action_id
idx_actid_del_freidindexaow_action_id,deleted,aow_processed_id


MySQL aow_workflow Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
flow_modulevarchar100
flow_run_onvarchar100
statusvarchar100Active
run_whenvarchar100Always
multiple_runstinyint
MySQL aow_workflow Keys:
nametypefields
primaryprimaryid
aow_workflow_index_statusindexstatus


MySQL aow_workflow_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL aow_workflow_audit Keys:
nametypefields
primaryprimaryid
idx_aow_workflow_parent_idindexparent_id


MySQL bugs Definitions:
nametypelenauto_incrementrequired
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
bug_numberint111true
typevarchar255
statusvarchar100
priorityvarchar100
resolutionvarchar255
work_logtext
found_in_releasevarchar255
fixed_in_releasevarchar255
sourcevarchar255
product_categoryvarchar255
MySQL bugs Keys:
nametypefields
primaryprimaryid
bugsnumkuniquebug_number
bug_numberindexbug_number
idx_bug_nameindexname
idx_bugs_assigned_userindexassigned_user_id


MySQL bugs_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL bugs_audit Keys:
nametypefields
primaryprimaryid
idx_bugs_parent_idindexparent_id


MySQL calls Definitions:
nametypelendefault
idchar36
namevarchar50
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
duration_hoursint2
duration_minutesint2
date_startdatetime
date_enddatetime
parent_typevarchar255
statusvarchar100Planned
directionvarchar100
parent_idchar36
reminder_timeint11-1
email_reminder_timeint11-1
email_reminder_senttinyint
outlook_idvarchar255
repeat_typevarchar36
repeat_intervalint31
repeat_dowvarchar7
repeat_untildate
repeat_countint7
repeat_parent_idchar36
recurring_sourcevarchar36
MySQL calls Keys:
nametypefields
primaryprimaryid
idx_call_nameindexname
idx_statusindexstatus
idx_calls_date_startindexdate_start
idx_calls_par_delindexparent_id,parent_type,deleted
idx_calls_assigned_delindexdeleted,assigned_user_id


MySQL calls_contacts Definitions:
nametypelendefault
idvarchar36
call_idvarchar36
contact_idvarchar36
requiredvarchar11
accept_statusvarchar25none
date_modifieddatetime
deletedtinyint
MySQL calls_contacts Keys:
nametypefields
primaryprimaryid
idx_con_call_callindexcall_id
idx_con_call_conindexcontact_id
idx_call_contactindexcall_id,contact_id


MySQL calls_leads Definitions:
nametypelendefault
idvarchar36
call_idvarchar36
lead_idvarchar36
requiredvarchar11
accept_statusvarchar25none
date_modifieddatetime
deletedtinyint
MySQL calls_leads Keys:
nametypefields
primaryprimaryid
idx_lead_call_callindexcall_id
idx_lead_call_leadindexlead_id
idx_call_leadindexcall_id,lead_id


MySQL calls_reschedule Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
reasonvarchar100
call_idchar36
MySQL calls_reschedule Keys:
nametypefields
primaryprimaryid


MySQL calls_reschedule_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL calls_reschedule_audit Keys:
nametypefields
primaryprimaryid
idx_calls_reschedule_parent_idindexparent_id


MySQL calls_users Definitions:
nametypelendefault
idvarchar36
call_idvarchar36
user_idvarchar36
requiredvarchar11
accept_statusvarchar25none
date_modifieddatetime
deletedtinyint
MySQL calls_users Keys:
nametypefields
primaryprimaryid
idx_usr_call_callindexcall_id
idx_usr_call_usrindexuser_id
idx_call_usersindexcall_id,user_id


MySQL campaign_log Definitions:
nametypelen
idchar36
campaign_idchar36
target_tracker_keyvarchar36
target_idvarchar36
target_typevarchar100
activity_typevarchar100
activity_datedatetime
related_idvarchar36
related_typevarchar100
archivedtinyint
hitsint11
list_idchar36
deletedtinyint
date_modifieddatetime
more_informationvarchar100
marketing_idchar36
MySQL campaign_log Keys:
nametypefields
primaryprimaryid
idx_camp_trackerindextarget_tracker_key
idx_camp_campaign_idindexcampaign_id
idx_camp_more_infoindexmore_information
idx_target_idindextarget_id
idx_target_id_deletedindextarget_id,deleted


MySQL campaign_trkrs Definitions:
nametypelendefaultrequired
idchar36
tracker_namevarchar255
tracker_urlvarchar255http://
tracker_keyint111true
campaign_idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
is_optouttinyint
deletedtinyint
MySQL campaign_trkrs Keys:
nametypefields
primaryprimaryid
campaign_tracker_key_idxindextracker_key


MySQL campaigns Definitions:
nametypelenauto_incrementrequired
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
deletedtinyint
assigned_user_idchar36
tracker_keyint111true
tracker_countint11
refer_urlvarchar255http://
tracker_textvarchar255
start_datedate
end_datedate
statusvarchar100
impressionsint11
currency_idchar36
budgetdouble
expected_costdouble
actual_costdouble
expected_revenuedouble
campaign_typevarchar100
objectivetext
contenttext
frequencyvarchar100
survey_idchar36
MySQL campaigns Keys:
nametypefields
primaryprimaryid
camp_auto_tracker_keyindextracker_key
idx_campaign_nameindexname
idx_survey_idindexsurvey_id


MySQL campaigns_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL campaigns_audit Keys:
nametypefields
primaryprimaryid
idx_campaigns_parent_idindexparent_id


MySQL cases Definitions:
nametypelenauto_incrementrequired
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
case_numberint111true
typevarchar255
statusvarchar100
priorityvarchar100
resolutiontext
work_logtext
account_idchar36
statevarchar100Open
contact_created_by_idchar36
MySQL cases Keys:
nametypefields
primaryprimaryid
casesnumkuniquecase_number
case_numberindexcase_number
idx_case_nameindexname
idx_account_idindexaccount_id
idx_cases_stat_delindexassigned_user_id,status,deleted


MySQL cases_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL cases_audit Keys:
nametypefields
primaryprimaryid
idx_cases_parent_idindexparent_id


MySQL cases_bugs Definitions:
nametypelen
idvarchar36
case_idvarchar36
bug_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL cases_bugs Keys:
nametypefields
primaryprimaryid
idx_cas_bug_casindexcase_id
idx_cas_bug_bugindexbug_id
idx_case_bugindexcase_id,bug_id


MySQL cases_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL cases_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL config Definitions:
nametypelen
categoryvarchar32
namevarchar32
valuetext
MySQL config Keys:
nametypefields
idx_config_catindexcategory


MySQL contacts Definitions:
nametypelendefault
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
salutationvarchar255
first_namevarchar100
last_namevarchar100
titlevarchar100
photovarchar255
departmentvarchar255
do_not_calltinyint
phone_homevarchar100
phone_mobilevarchar100
phone_workvarchar100
phone_othervarchar100
phone_faxvarchar100
lawful_basistext
date_revieweddate
lawful_basis_sourcevarchar100
primary_address_streetvarchar150
primary_address_cityvarchar100
primary_address_statevarchar100
primary_address_postalcodevarchar20
primary_address_countryvarchar255
alt_address_streetvarchar150
alt_address_cityvarchar100
alt_address_statevarchar100
alt_address_postalcodevarchar20
alt_address_countryvarchar255
assistantvarchar75
assistant_phonevarchar100
lead_sourcevarchar255
reports_to_idchar36
birthdatedate
campaign_idchar36
joomla_account_idvarchar255
portal_account_disabledtinyint
portal_user_typevarchar100Single
MySQL contacts Keys:
nametypefields
primaryprimaryid
idx_cont_last_firstindexlast_name,first_name,deleted
idx_contacts_del_lastindexdeleted,last_name
idx_cont_del_reportsindexdeleted,reports_to_id,last_name
idx_reports_to_idindexreports_to_id
idx_del_id_userindexdeleted,id,assigned_user_id
idx_cont_assignedindexassigned_user_id


MySQL contacts_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL contacts_audit Keys:
nametypefields
primaryprimaryid
idx_contacts_parent_idindexparent_id


MySQL contacts_bugs Definitions:
nametypelen
idvarchar36
contact_idvarchar36
bug_idvarchar36
contact_rolevarchar50
date_modifieddatetime
deletedtinyint
MySQL contacts_bugs Keys:
nametypefields
primaryprimaryid
idx_con_bug_conindexcontact_id
idx_con_bug_bugindexbug_id
idx_contact_bugindexcontact_id,bug_id


MySQL contacts_cases Definitions:
nametypelen
idvarchar36
contact_idvarchar36
case_idvarchar36
contact_rolevarchar50
date_modifieddatetime
deletedtinyint
MySQL contacts_cases Keys:
nametypefields
primaryprimaryid
idx_con_case_conindexcontact_id
idx_con_case_caseindexcase_id
idx_contacts_casesindexcontact_id,case_id


MySQL contacts_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL contacts_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL contacts_users Definitions:
nametypelen
idvarchar36
contact_idvarchar36
user_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL contacts_users Keys:
nametypefields
primaryprimaryid
idx_con_users_conindexcontact_id
idx_con_users_userindexuser_id
idx_contacts_usersindexcontact_id,user_id


MySQL cron_remove_documents Definitions:
nametypelen
idvarchar36
bean_idvarchar36
modulevarchar25
date_modifieddatetime
MySQL cron_remove_documents Keys:
nametypefields
primaryprimaryid
idx_cron_remove_document_bean_idindexbean_id
idx_cron_remove_document_stampindexdate_modified


MySQL currencies Definitions:
nametypelenrequired
idchar36
namevarchar36
symbolvarchar36
iso4217varchar3
conversion_ratedouble
statusvarchar100
deletedtinyint
date_entereddatetime
date_modifieddatetime
created_bychar36true
MySQL currencies Keys:
nametypefields
primaryprimaryid
idx_currency_nameindexname,deleted


MySQL custom_fields Definitions:
nametypelen
bean_idvarchar36
set_numint11
field0varchar255
field1varchar255
field2varchar255
field3varchar255
field4varchar255
field5varchar255
field6varchar255
field7varchar255
field8varchar255
field9varchar255
deletedtinyint
MySQL custom_fields Keys:
nametypefields
idx_beanid_set_numindexbean_id,set_num


MySQL d1_detail Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
nb_contdecimal18,0
aos_products_id_cchar36
nb_testingdecimal18,0
ventesdecimal18,0
tx_transdecimal18,0
prix_habdecimal18,2
prix_negdecimal18,2
nb_boutdecimal18,0
kit_visvarchar255
MySQL d1_detail Keys:
nametypefields
primaryprimaryid


MySQL d1_detail_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL d1_detail_audit Keys:
nametypefields
primaryprimaryid
idx_d1_detail_parent_idindexparent_id


MySQL d1_detail_h1_header_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
d1_detail_h1_headerd1_detail_idavarchar36
d1_detail_h1_headerh1_header_idbvarchar36
MySQL d1_detail_h1_header_c Keys:
nametypefields
primaryprimaryid
d1_detail_h1_header_ida1indexd1_detail_h1_headerd1_detail_ida
d1_detail_h1_header_idb2indexd1_detail_h1_headerh1_header_idb


MySQL document_revisions Definitions:
nametypelen
idvarchar36
change_logvarchar255
document_idvarchar36
doc_idvarchar100
doc_typevarchar100
doc_urlvarchar255
date_entereddatetime
created_bychar36
filenamevarchar255
file_extvarchar100
file_mime_typevarchar100
revisionvarchar100
deletedtinyint
date_modifieddatetime
MySQL document_revisions Keys:
nametypefields
primaryprimaryid
documentrevision_mimetypeindexfile_mime_type


MySQL documents Definitions:
nametypelendefault
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
document_namevarchar255
doc_idvarchar100
doc_typevarchar100Sugar
doc_urlvarchar255
active_datedate
exp_datedate
category_idvarchar100
subcategory_idvarchar100
status_idvarchar100
document_revision_idvarchar36
related_doc_idchar36
related_doc_rev_idchar36
is_templatetinyint
template_typevarchar100
MySQL documents Keys:
nametypefields
primaryprimaryid
idx_doc_catindexcategory_id,subcategory_id


MySQL documents_accounts Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
document_idvarchar36
account_idvarchar36
MySQL documents_accounts Keys:
nametypefields
primaryprimaryid
documents_accounts_account_idindexaccount_id,document_id
documents_accounts_document_idindexdocument_id,account_id


MySQL documents_bugs Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
document_idvarchar36
bug_idvarchar36
MySQL documents_bugs Keys:
nametypefields
primaryprimaryid
documents_bugs_bug_idindexbug_id,document_id
documents_bugs_document_idindexdocument_id,bug_id


MySQL documents_cases Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
document_idvarchar36
case_idvarchar36
MySQL documents_cases Keys:
nametypefields
primaryprimaryid
documents_cases_case_idindexcase_id,document_id
documents_cases_document_idindexdocument_id,case_id


MySQL documents_contacts Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
document_idvarchar36
contact_idvarchar36
MySQL documents_contacts Keys:
nametypefields
primaryprimaryid
documents_contacts_contact_idindexcontact_id,document_id
documents_contacts_document_idindexdocument_id,contact_id


MySQL documents_opportunities Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
document_idvarchar36
opportunity_idvarchar36
MySQL documents_opportunities Keys:
nametypefields
primaryprimaryid
idx_docu_opps_oppo_idindexopportunity_id,document_id
idx_docu_oppo_docu_idindexdocument_id,opportunity_id


MySQL eapm Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
passwordvarchar255
urlvarchar255
applicationvarchar100webex
api_datatext
consumer_keyvarchar255
consumer_secretvarchar255
oauth_tokenvarchar255
oauth_secretvarchar255
validatedtinyint
MySQL eapm Keys:
nametypefields
primaryprimaryid
idx_app_activeindexassigned_user_id,application,validated


MySQL email_addr_bean_rel Definitions:
nametypelenrequired
idchar36
email_address_idchar36true
bean_idchar36true
bean_modulevarchar100
primary_addresstinyint
reply_to_addresstinyint
date_createddatetime
date_modifieddatetime
deletedtinyint
MySQL email_addr_bean_rel Keys:
nametypefields
primaryprimaryid
idx_email_address_idindexemail_address_id
idx_bean_idindexbean_id,bean_module


MySQL email_addresses Definitions:
nametypelendefault
idchar36
email_addressvarchar255
email_address_capsvarchar255
invalid_emailtinyint
opt_outtinyint
confirm_opt_invarchar255not-opt-in
confirm_opt_in_datedatetime
confirm_opt_in_sent_datedatetime
confirm_opt_in_fail_datedatetime
confirm_opt_in_tokenvarchar255
date_createddatetime
date_modifieddatetime
deletedtinyint
MySQL email_addresses Keys:
nametypefields
primaryprimaryid
idx_ea_caps_opt_out_invalidindexemail_address_caps,opt_out,invalid_email
idx_ea_opt_out_invalidindexemail_address,opt_out,invalid_email


MySQL email_addresses_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL email_addresses_audit Keys:
nametypefields
primaryprimaryid
idx_email_addresses_parent_idindexparent_id


MySQL email_cache Definitions:
nametypelen
ie_idchar36
mboxvarchar60
subjectvarchar255
fromaddrvarchar100
toaddrvarchar255
senddatedatetime
message_idvarchar255
mailsizeint10
imap_uidint10
msgnoint10
recenttinyint
flaggedtinyint
answeredtinyint
deletedtinyint
seentinyint
drafttinyint
MySQL email_cache Keys:
nametypefields
idx_ie_idindexie_id
idx_mail_dateindexie_id,mbox,senddate
idx_mail_fromindexie_id,mbox,fromaddr
idx_mail_subjindexsubject
idx_mail_toindextoaddr


MySQL email_marketing Definitions:
nametypelenrequired
idchar36
deletedtinyint
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar255
from_namevarchar100
from_addrvarchar100
reply_to_namevarchar100
reply_to_addrvarchar100
inbound_email_idvarchar36
date_startdatetime
template_idchar36true
statusvarchar100
campaign_idchar36
outbound_email_idchar36
all_prospect_liststinyint
MySQL email_marketing Keys:
nametypefields
primaryprimaryid
idx_emmkt_nameindexname
idx_emmkit_delindexdeleted


MySQL email_marketing_prospect_lists Definitions:
nametypelen
idvarchar36
prospect_list_idvarchar36
email_marketing_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL email_marketing_prospect_lists Keys:
nametypefields
primaryprimaryid
email_mp_prospectsindexemail_marketing_id,prospect_list_id


MySQL email_templates Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_byvarchar36
publishedvarchar3
namevarchar255
descriptiontext
subjectvarchar255
bodylongtext
body_htmllongtext
deletedtinyint
assigned_user_idchar36
text_onlytinyint
typevarchar255
MySQL email_templates Keys:
nametypefields
primaryprimaryid
idx_email_template_nameindexname


MySQL emailman Definitions:
nametypelenauto_increment
date_entereddatetime
date_modifieddatetime
user_idchar36
idint111
campaign_idchar36
marketing_idchar36
list_idchar36
send_date_timedatetime
modified_user_idchar36
in_queuetinyint
in_queue_datedatetime
send_attemptsint11
deletedtinyint
related_idchar36
related_typevarchar100
related_confirm_opt_intinyint
MySQL emailman Keys:
nametypefields
primaryprimaryid
idx_eman_listindexlist_id,user_id,deleted
idx_eman_campaign_idindexcampaign_id
idx_eman_relid_reltype_idindexrelated_id,related_type,campaign_id


MySQL emails Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
deletedtinyint
assigned_user_idchar36
orphanedtinyint
last_synceddatetime
date_sent_receiveddatetime
message_idvarchar255
typevarchar100
statusvarchar100
flaggedtinyint
reply_to_statustinyint
intentvarchar100pick
mailbox_idchar36
parent_typevarchar100
parent_idchar36
uidvarchar255
category_idvarchar100
MySQL emails Keys:
nametypefields
primaryprimaryid
idx_email_nameindexname
idx_message_idindexmessage_id
idx_email_parent_idindexparent_id
idx_email_assignedindexassigned_user_id,type,status
idx_email_catindexcategory_id


MySQL emails_beans Definitions:
nametypelen
idchar36
email_idchar36
bean_idchar36
bean_modulevarchar100
campaign_datatext
date_modifieddatetime
deletedtinyint
MySQL emails_beans Keys:
nametypefields
primaryprimaryid
idx_emails_beans_bean_idindexbean_id
idx_emails_beans_email_beanindexemail_id,bean_id,deleted


MySQL emails_email_addr_rel Definitions:
nametypelenrequired
idchar36
email_idchar36true
address_typevarchar4
email_address_idchar36true
deletedtinyint
MySQL emails_email_addr_rel Keys:
nametypefields
primaryprimaryid
idx_eearl_email_idindexemail_id,address_type
idx_eearl_address_idindexemail_address_id


MySQL emails_text Definitions:
nametypelen
email_idchar36
from_addrvarchar250
reply_to_addrvarchar250
to_addrstext
cc_addrstext
bcc_addrstext
descriptionlongtext
description_htmllongtext
raw_sourcelongtext
deletedtinyint
MySQL emails_text Keys:
nametypefields
primaryprimaryemail_id
emails_textfromaddrindexfrom_addr


MySQL favorites Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
parent_idchar36
parent_typevarchar255
MySQL favorites Keys:
nametypefields
primaryprimaryid


MySQL fields_meta_data Definitions:
nametypelen
idvarchar255
namevarchar255
vnamevarchar255
commentsvarchar255
helpvarchar255
custom_modulevarchar255
typevarchar255
lenint11
requiredtinyint
default_valuevarchar255
date_modifieddatetime
deletedtinyint
auditedtinyint
massupdatetinyint
duplicate_mergesmallint
reportabletinyint1
importablevarchar255
ext1varchar255
ext2varchar255
ext3varchar255
ext4text
MySQL fields_meta_data Keys:
nametypefields
primaryprimaryid
idx_meta_id_delindexid,deleted
idx_meta_cm_delindexcustom_module,deleted


MySQL folders Definitions:
nametypelenrequired
idchar36
namevarchar255
folder_typevarchar25
parent_folderchar36
has_childtinyint
is_grouptinyint
is_dynamictinyint
dynamic_querytext
assign_to_idchar36
created_bychar36true
modified_bychar36true
deletedtinyint
MySQL folders Keys:
nametypefields
primaryprimaryid
idx_parent_folderindexparent_folder


MySQL folders_rel Definitions:
nametypelenrequired
idchar36
folder_idchar36true
polymorphic_modulevarchar25
polymorphic_idchar36true
deletedtinyint
MySQL folders_rel Keys:
nametypefields
primaryprimaryid
idx_poly_module_poly_idindexpolymorphic_module,polymorphic_id
idx_fr_id_deleted_polyindexfolder_id,deleted,polymorphic_id


MySQL folders_subscriptions Definitions:
nametypelenrequired
idchar36
folder_idchar36true
assigned_user_idchar36true
MySQL folders_subscriptions Keys:
nametypefields
primaryprimaryid
idx_folder_id_assigned_user_idindexfolder_id,assigned_user_id


MySQL fp_event_locations Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
addressvarchar255
address_cityvarchar100
address_countryvarchar100
address_postalcodevarchar20
address_statevarchar100
capacityvarchar255
MySQL fp_event_locations Keys:
nametypefields
primaryprimaryid


MySQL fp_event_locations_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL fp_event_locations_audit Keys:
nametypefields
primaryprimaryid
idx_fp_event_locations_parent_idindexparent_id


MySQL fp_event_locations_fp_events_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
fp_event_locations_fp_events_1fp_event_locations_idavarchar36
fp_event_locations_fp_events_1fp_events_idbvarchar36
MySQL fp_event_locations_fp_events_1_c Keys:
nametypefields
primaryprimaryid
fp_event_locations_fp_events_1_ida1indexfp_event_locations_fp_events_1fp_event_locations_ida
fp_event_locations_fp_events_1_altindexfp_event_locations_fp_events_1fp_events_idb


MySQL fp_events Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
duration_hoursint3
duration_minutesint2
date_startdatetime
date_enddatetime
budgetdecimal26,6
currency_idchar36
invite_templatesvarchar100
accept_redirectvarchar255
decline_redirectvarchar255
activity_status_typevarchar255
MySQL fp_events Keys:
nametypefields
primaryprimaryid


MySQL fp_events_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL fp_events_audit Keys:
nametypefields
primaryprimaryid
idx_fp_events_parent_idindexparent_id


MySQL fp_events_contacts_c Definitions:
nametypelendefault
idvarchar36
date_modifieddatetime
deletedtinyint
fp_events_contactsfp_events_idavarchar36
fp_events_contactscontacts_idbvarchar36
invite_statusvarchar25Not Invited
accept_statusvarchar25No Response
email_respondedint2
MySQL fp_events_contacts_c Keys:
nametypefields
primaryprimaryid
fp_events_contacts_altindexfp_events_contactsfp_events_ida,fp_events_contactscontacts_idb


MySQL fp_events_fp_event_delegates_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
fp_events_fp_event_delegates_1fp_events_idavarchar36
fp_events_fp_event_delegates_1fp_event_delegates_idbvarchar36
MySQL fp_events_fp_event_delegates_1_c Keys:
nametypefields
primaryprimaryid
fp_events_fp_event_delegates_1_ida1indexfp_events_fp_event_delegates_1fp_events_ida
fp_events_fp_event_delegates_1_altindexfp_events_fp_event_delegates_1fp_event_delegates_idb


MySQL fp_events_fp_event_locations_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
fp_events_fp_event_locations_1fp_events_idavarchar36
fp_events_fp_event_locations_1fp_event_locations_idbvarchar36
MySQL fp_events_fp_event_locations_1_c Keys:
nametypefields
primaryprimaryid
fp_events_fp_event_locations_1_altindexfp_events_fp_event_locations_1fp_events_ida,fp_events_fp_event_locations_1fp_event_locations_idb


MySQL fp_events_leads_1_c Definitions:
nametypelendefault
idvarchar36
date_modifieddatetime
deletedtinyint
fp_events_leads_1fp_events_idavarchar36
fp_events_leads_1leads_idbvarchar36
invite_statusvarchar25Not Invited
accept_statusvarchar25No Response
email_respondedint2
MySQL fp_events_leads_1_c Keys:
nametypefields
primaryprimaryid
fp_events_leads_1_altindexfp_events_leads_1fp_events_ida,fp_events_leads_1leads_idb


MySQL fp_events_prospects_1_c Definitions:
nametypelendefault
idvarchar36
date_modifieddatetime
deletedtinyint
fp_events_prospects_1fp_events_idavarchar36
fp_events_prospects_1prospects_idbvarchar36
invite_statusvarchar25Not Invited
accept_statusvarchar25No Response
email_respondedint2
MySQL fp_events_prospects_1_c Keys:
nametypefields
primaryprimaryid
fp_events_prospects_1_altindexfp_events_prospects_1fp_events_ida,fp_events_prospects_1prospects_idb


MySQL h1_header Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
account_id_cchar36
type_actionvarchar100
h_debdatetime
h_findatetime
cap_etabdecimal18,0
nb_persdecimal18,0
tx_rempdecimal18,0
pct_hfdecimal18,0
moy_agedecimal18,0
MySQL h1_header Keys:
nametypefields
primaryprimaryid


MySQL h1_header_am_projecttemplates_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
h1_header_am_projecttemplatesh1_header_idavarchar36
h1_header_am_projecttemplatesam_projecttemplates_idbvarchar36
MySQL h1_header_am_projecttemplates_c Keys:
nametypefields
primaryprimaryid
h1_header_am_projecttemplates_altindexh1_header_am_projecttemplatesh1_header_ida,h1_header_am_projecttemplatesam_projecttemplates_idb


MySQL h1_header_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL h1_header_audit Keys:
nametypefields
primaryprimaryid
idx_h1_header_parent_idindexparent_id


MySQL h1_header_d1_detail_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
h1_header_d1_detailh1_header_idavarchar36
h1_header_d1_detaild1_detail_idbvarchar36
MySQL h1_header_d1_detail_c Keys:
nametypefields
primaryprimaryid
h1_header_d1_detail_altindexh1_header_d1_detailh1_header_ida,h1_header_d1_detaild1_detail_idb


MySQL import_maps Definitions:
nametypelendefault
idchar36
namevarchar254
sourcevarchar36
enclosurevarchar1
delimitervarchar1,
modulevarchar36
contenttext
default_valuestext
has_headertinyint1
deletedtinyint
date_entereddatetime
date_modifieddatetime
assigned_user_idchar36
is_publishedvarchar3no
MySQL import_maps Keys:
nametypefields
primaryprimaryid
idx_owner_module_nameindexassigned_user_id,module,name,deleted


MySQL inbound_email Definitions:
nametypelendefault
idvarchar36
deletedtinyint
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar255
statusvarchar100Active
server_urlvarchar100
email_uservarchar100
email_passwordvarchar100
portint5
servicevarchar50
mailboxtext
delete_seentinyint
mailbox_typevarchar10
template_idchar36
stored_optionstext
group_idchar36
is_personaltinyint
groupfolder_idchar36
MySQL inbound_email Keys:
nametypefields
primaryprimaryid


MySQL inbound_email_autoreply Definitions:
nametypelenrequired
idchar36
deletedtinyint
date_entereddatetime
date_modifieddatetime
autoreplied_tovarchar100
ie_idchar36true
MySQL inbound_email_autoreply Keys:
nametypefields
primaryprimaryid
idx_ie_autoreplied_toindexautoreplied_to


MySQL inbound_email_cache_ts Definitions:
nametypelen
idvarchar255
ie_timestampint10
MySQL inbound_email_cache_ts Keys:
nametypefields
primaryprimaryid


MySQL jjwg_address_cache Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
latfloat10,8
lngfloat11,8
MySQL jjwg_address_cache Keys:
nametypefields
primaryprimaryid


MySQL jjwg_address_cache_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL jjwg_address_cache_audit Keys:
nametypefields
primaryprimaryid
idx_jjwg_address_cache_parent_idindexparent_id


MySQL jjwg_areas Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
cityvarchar255
statevarchar255
countryvarchar255
coordinatestext
MySQL jjwg_areas Keys:
nametypefields
primaryprimaryid


MySQL jjwg_areas_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL jjwg_areas_audit Keys:
nametypefields
primaryprimaryid
idx_jjwg_areas_parent_idindexparent_id


MySQL jjwg_maps Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
distancefloat9,4
unit_typevarchar100mi
module_typevarchar100Accounts
parent_typevarchar255
parent_idchar36
MySQL jjwg_maps Keys:
nametypefields
primaryprimaryid


MySQL jjwg_maps_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL jjwg_maps_audit Keys:
nametypefields
primaryprimaryid
idx_jjwg_maps_parent_idindexparent_id


MySQL jjwg_maps_jjwg_areas_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
jjwg_maps_5304wg_maps_idavarchar36
jjwg_maps_41f2g_areas_idbvarchar36
MySQL jjwg_maps_jjwg_areas_c Keys:
nametypefields
primaryprimaryid
jjwg_maps_jjwg_areas_altindexjjwg_maps_5304wg_maps_ida,jjwg_maps_41f2g_areas_idb


MySQL jjwg_maps_jjwg_markers_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
jjwg_maps_b229wg_maps_idavarchar36
jjwg_maps_2e31markers_idbvarchar36
MySQL jjwg_maps_jjwg_markers_c Keys:
nametypefields
primaryprimaryid
jjwg_maps_jjwg_markers_altindexjjwg_maps_b229wg_maps_ida,jjwg_maps_2e31markers_idb


MySQL jjwg_markers Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
cityvarchar255
statevarchar255
countryvarchar255
jjwg_maps_latfloat10,80.00000000
jjwg_maps_lngfloat11,80.00000000
marker_imagevarchar100company
MySQL jjwg_markers Keys:
nametypefields
primaryprimaryid


MySQL jjwg_markers_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL jjwg_markers_audit Keys:
nametypefields
primaryprimaryid
idx_jjwg_markers_parent_idindexparent_id


MySQL job_queue Definitions:
nametypelen
assigned_user_idchar36
idchar36
namevarchar255
deletedtinyint
date_entereddatetime
date_modifieddatetime
scheduler_idchar36
execute_timedatetime
statusvarchar20
resolutionvarchar20
messagetext
targetvarchar255
datatext
requeuetinyint
retry_counttinyint
failure_counttinyint
job_delayint11
clientvarchar255
percent_completeint11
MySQL job_queue Keys:
nametypefields
primaryprimaryid
idx_status_schedulerindexstatus,scheduler_id
idx_status_timeindexstatus,execute_time,date_entered
idx_status_enteredindexstatus,date_entered
idx_status_modifiedindexstatus,date_modified


MySQL leads Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
salutationvarchar255
first_namevarchar100
last_namevarchar100
titlevarchar100
photovarchar255
departmentvarchar100
do_not_calltinyint
phone_homevarchar100
phone_mobilevarchar100
phone_workvarchar100
phone_othervarchar100
phone_faxvarchar100
lawful_basistext
date_revieweddate
lawful_basis_sourcevarchar100
primary_address_streetvarchar150
primary_address_cityvarchar100
primary_address_statevarchar100
primary_address_postalcodevarchar20
primary_address_countryvarchar255
alt_address_streetvarchar150
alt_address_cityvarchar100
alt_address_statevarchar100
alt_address_postalcodevarchar20
alt_address_countryvarchar255
assistantvarchar75
assistant_phonevarchar100
convertedtinyint
refered_byvarchar100
lead_sourcevarchar100
lead_source_descriptiontext
statusvarchar100
status_descriptiontext
reports_to_idchar36
account_namevarchar255
account_descriptiontext
contact_idchar36
account_idchar36
opportunity_idchar36
opportunity_namevarchar255
opportunity_amountvarchar50
campaign_idchar36
birthdatedate
portal_namevarchar255
portal_appvarchar255
websitevarchar255
MySQL leads Keys:
nametypefields
primaryprimaryid
idx_lead_acct_name_firstindexaccount_name,deleted
idx_lead_last_firstindexlast_name,first_name,deleted
idx_lead_del_statindexlast_name,status,deleted,first_name
idx_lead_opp_delindexopportunity_id,deleted
idx_leads_acct_delindexaccount_id,deleted
idx_del_userindexdeleted,assigned_user_id
idx_lead_assignedindexassigned_user_id
idx_lead_contactindexcontact_id
idx_reports_toindexreports_to_id
idx_lead_phone_workindexphone_work
idx_leads_id_delindexid,deleted


MySQL leads_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL leads_audit Keys:
nametypefields
primaryprimaryid
idx_leads_parent_idindexparent_id


MySQL leads_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL leads_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL linked_documents Definitions:
nametypelen
idvarchar36
parent_idvarchar36
parent_typevarchar25
document_idvarchar36
document_revision_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL linked_documents Keys:
nametypefields
primaryprimaryid
idx_parent_documentindexparent_type,parent_id,document_id


MySQL meetings Definitions:
nametypelendefault
idchar36
namevarchar50
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
locationvarchar50
passwordvarchar50
join_urlvarchar200
host_urlvarchar400
displayed_urlvarchar400
creatorvarchar50
external_idvarchar50
duration_hoursint3
duration_minutesint2
date_startdatetime
date_enddatetime
parent_typevarchar100
statusvarchar100Planned
typevarchar255Sugar
parent_idchar36
reminder_timeint11-1
email_reminder_timeint11-1
email_reminder_senttinyint
outlook_idvarchar255
sequenceint11
repeat_typevarchar36
repeat_intervalint31
repeat_dowvarchar7
repeat_untildate
repeat_countint7
repeat_parent_idchar36
recurring_sourcevarchar36
gsync_idvarchar1024
gsync_lastsyncint11
MySQL meetings Keys:
nametypefields
primaryprimaryid
idx_mtg_nameindexname
idx_meet_par_delindexparent_id,parent_type,deleted
idx_meet_stat_delindexassigned_user_id,status,deleted
idx_meet_date_startindexdate_start


MySQL meetings_contacts Definitions:
nametypelendefault
idvarchar36
meeting_idvarchar36
contact_idvarchar36
requiredvarchar11
accept_statusvarchar25none
date_modifieddatetime
deletedtinyint
MySQL meetings_contacts Keys:
nametypefields
primaryprimaryid
idx_con_mtg_mtgindexmeeting_id
idx_con_mtg_conindexcontact_id
idx_meeting_contactindexmeeting_id,contact_id


MySQL meetings_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL meetings_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL meetings_leads Definitions:
nametypelendefault
idvarchar36
meeting_idvarchar36
lead_idvarchar36
requiredvarchar11
accept_statusvarchar25none
date_modifieddatetime
deletedtinyint
MySQL meetings_leads Keys:
nametypefields
primaryprimaryid
idx_lead_meeting_meetingindexmeeting_id
idx_lead_meeting_leadindexlead_id
idx_meeting_leadindexmeeting_id,lead_id


MySQL meetings_users Definitions:
nametypelendefault
idvarchar36
meeting_idvarchar36
user_idvarchar36
requiredvarchar11
accept_statusvarchar25none
date_modifieddatetime
deletedtinyint
MySQL meetings_users Keys:
nametypefields
primaryprimaryid
idx_usr_mtg_mtgindexmeeting_id
idx_usr_mtg_usrindexuser_id
idx_meeting_usersindexmeeting_id,user_id


MySQL notes Definitions:
nametypelen
assigned_user_idchar36
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar255
file_mime_typevarchar100
filenamevarchar255
parent_typevarchar255
parent_idchar36
contact_idchar36
portal_flagtinyint
embed_flagtinyint
descriptiontext
deletedtinyint
MySQL notes Keys:
nametypefields
primaryprimaryid
idx_note_nameindexname
idx_notes_parentindexparent_id,parent_type
idx_note_contactindexcontact_id
idx_notes_assigned_delindexdeleted,assigned_user_id


MySQL oauth2clients Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
secretvarchar4000
redirect_urlvarchar255
is_confidentialtinyint1
allowed_grant_typevarchar255password
duration_valueint11
duration_amountint11
duration_unitvarchar255Duration Unit
assigned_user_idchar36
MySQL oauth2clients Keys:
nametypefields
primaryprimaryid


MySQL oauth2tokens Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
token_is_revokedtinyint
token_typevarchar255
access_token_expiresdatetime
access_tokenvarchar4000
refresh_tokenvarchar4000
refresh_token_expiresdatetime
grant_typevarchar255
statevarchar1024
clientchar36
assigned_user_idchar36
MySQL oauth2tokens Keys:
nametypefields
primaryprimaryid


MySQL oauth_consumer Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
c_keyvarchar255
c_secretvarchar255
MySQL oauth_consumer Keys:
nametypefields
primaryprimaryid
ckeyuniquec_key


MySQL oauth_nonce Definitions:
nametypelen
conskeyvarchar32
noncevarchar32
nonce_tsbigint
MySQL oauth_nonce Keys:
nametypefields
primaryprimaryconskey,nonce
oauth_nonce_keytsindexconskey,nonce_ts


MySQL oauth_tokens Definitions:
nametypelenrequired
idchar36
secretvarchar32
tstatevarchar1
consumerchar36true
token_tsbigint
verifyvarchar32
deletedtinyint
callback_urlvarchar255
assigned_user_idchar36
MySQL oauth_tokens Keys:
nametypefields
primaryprimaryid,deleted
oauth_state_tsindextstate,token_ts
constoken_keyindexconsumer


MySQL opportunities Definitions:
nametypelen
idchar36
namevarchar50
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
opportunity_typevarchar255
campaign_idchar36
lead_sourcevarchar50
amountdouble
amount_usdollardouble
currency_idchar36
date_closeddate
next_stepvarchar100
sales_stagevarchar255
probabilitydouble
MySQL opportunities Keys:
nametypefields
primaryprimaryid
idx_opp_nameindexname
idx_opp_assignedindexassigned_user_id
idx_opp_id_deletedindexid,deleted


MySQL opportunities_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL opportunities_audit Keys:
nametypefields
primaryprimaryid
idx_opportunities_parent_idindexparent_id


MySQL opportunities_contacts Definitions:
nametypelen
idvarchar36
contact_idvarchar36
opportunity_idvarchar36
contact_rolevarchar50
date_modifieddatetime
deletedtinyint
MySQL opportunities_contacts Keys:
nametypefields
primaryprimaryid
idx_con_opp_conindexcontact_id
idx_con_opp_oppindexopportunity_id
idx_opportunities_contactsindexopportunity_id,contact_id


MySQL opportunities_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL opportunities_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL outbound_email Definitions:
nametypelendefault
idchar36
namevarchar255
typevarchar15user
user_idchar36true
smtp_from_namevarchar255
smtp_from_addrvarchar255
mail_sendtypevarchar8smtp
mail_smtptypevarchar20other
mail_smtpservervarchar100
mail_smtpportvarchar5
mail_smtpuservarchar100
mail_smtppassvarchar100
mail_smtpauth_reqtinyint
mail_smtpsslvarchar1
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
deletedtinyint
assigned_user_idchar36
MySQL outbound_email Keys:
nametypefields
primaryprimaryid


MySQL outbound_email_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL outbound_email_audit Keys:
nametypefields
primaryprimaryid
idx_outbound_email_parent_idindexparent_id


MySQL project Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
assigned_user_idchar36
modified_user_idchar36
created_bychar36
namevarchar50
descriptiontext
deletedtinyint
estimated_start_datedate
estimated_end_datedate
statusvarchar255
priorityvarchar255
override_business_hourstinyint
MySQL project Keys:
nametypefields
primaryprimaryid


MySQL project_contacts_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
project_contacts_1project_idavarchar36
project_contacts_1contacts_idbvarchar36
MySQL project_contacts_1_c Keys:
nametypefields
primaryprimaryid
project_contacts_1_altindexproject_contacts_1project_ida,project_contacts_1contacts_idb


MySQL project_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL project_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL project_task Definitions:
nametypelenrequired
idchar36
date_entereddatetime
date_modifieddatetime
project_idchar36true
project_task_idint11
namevarchar50
statusvarchar255
relationship_typevarchar255
descriptiontext
predecessorstext
date_startdate
time_startint11
time_finishint11
date_finishdate
durationint11
duration_unittext
actual_durationint11
percent_completeint11
date_duedate
time_duetime
parent_task_idint11
assigned_user_idchar36
modified_user_idchar36
priorityvarchar255
created_bychar36
milestone_flagtinyint
order_numberint111
task_numberint11
estimated_effortint11
actual_effortint11
deletedtinyint
utilizationint11100
MySQL project_task Keys:
nametypefields
primaryprimaryid


MySQL project_task_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL project_task_audit Keys:
nametypefields
primaryprimaryid
idx_project_task_parent_idindexparent_id


MySQL project_users_1_c Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
project_users_1project_idavarchar36
project_users_1users_idbvarchar36
MySQL project_users_1_c Keys:
nametypefields
primaryprimaryid
project_users_1_altindexproject_users_1project_ida,project_users_1users_idb


MySQL projects_accounts Definitions:
nametypelen
idvarchar36
account_idvarchar36
project_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL projects_accounts Keys:
nametypefields
primaryprimaryid
idx_proj_acct_projindexproject_id
idx_proj_acct_acctindexaccount_id
projects_accounts_altindexproject_id,account_id


MySQL projects_bugs Definitions:
nametypelen
idvarchar36
bug_idvarchar36
project_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL projects_bugs Keys:
nametypefields
primaryprimaryid
idx_proj_bug_projindexproject_id
idx_proj_bug_bugindexbug_id
projects_bugs_altindexproject_id,bug_id


MySQL projects_cases Definitions:
nametypelen
idvarchar36
case_idvarchar36
project_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL projects_cases Keys:
nametypefields
primaryprimaryid
idx_proj_case_projindexproject_id
idx_proj_case_caseindexcase_id
projects_cases_altindexproject_id,case_id


MySQL projects_contacts Definitions:
nametypelen
idvarchar36
contact_idvarchar36
project_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL projects_contacts Keys:
nametypefields
primaryprimaryid
idx_proj_con_projindexproject_id
idx_proj_con_conindexcontact_id
projects_contacts_altindexproject_id,contact_id


MySQL projects_opportunities Definitions:
nametypelen
idvarchar36
opportunity_idvarchar36
project_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL projects_opportunities Keys:
nametypefields
primaryprimaryid
idx_proj_opp_projindexproject_id
idx_proj_opp_oppindexopportunity_id
projects_opportunities_altindexproject_id,opportunity_id


MySQL projects_products Definitions:
nametypelen
idvarchar36
product_idvarchar36
project_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL projects_products Keys:
nametypefields
primaryprimaryid
idx_proj_prod_projectindexproject_id
idx_proj_prod_productindexproduct_id
projects_products_altindexproject_id,product_id


MySQL prospect_list_campaigns Definitions:
nametypelen
idvarchar36
prospect_list_idvarchar36
campaign_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL prospect_list_campaigns Keys:
nametypefields
primaryprimaryid
idx_pro_idindexprospect_list_id
idx_cam_idindexcampaign_id
idx_prospect_list_campaignsindexprospect_list_id,campaign_id


MySQL prospect_lists Definitions:
nametypelen
assigned_user_idchar36
idchar36
namevarchar255
list_typevarchar100
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
deletedtinyint
descriptiontext
domain_namevarchar255
MySQL prospect_lists Keys:
nametypefields
primaryprimaryid
idx_prospect_list_nameindexname


MySQL prospect_lists_prospects Definitions:
nametypelen
idvarchar36
prospect_list_idvarchar36
related_idvarchar36
related_typevarchar25
date_modifieddatetime
deletedtinyint
MySQL prospect_lists_prospects Keys:
nametypefields
primaryprimaryid
idx_plp_pro_idindexprospect_list_id
idx_plp_rel_idindexrelated_id,related_type,prospect_list_id


MySQL prospects Definitions:
nametypelenauto_incrementrequired
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
salutationvarchar255
first_namevarchar100
last_namevarchar100
titlevarchar100
photovarchar255
departmentvarchar255
do_not_calltinyint
phone_homevarchar100
phone_mobilevarchar100
phone_workvarchar100
phone_othervarchar100
phone_faxvarchar100
lawful_basistext
date_revieweddate
lawful_basis_sourcevarchar100
primary_address_streetvarchar150
primary_address_cityvarchar100
primary_address_statevarchar100
primary_address_postalcodevarchar20
primary_address_countryvarchar255
alt_address_streetvarchar150
alt_address_cityvarchar100
alt_address_statevarchar100
alt_address_postalcodevarchar20
alt_address_countryvarchar255
assistantvarchar75
assistant_phonevarchar100
tracker_keyint111true
birthdatedate
lead_idchar36
account_namevarchar150
campaign_idchar36
MySQL prospects Keys:
nametypefields
primaryprimaryid
prospect_auto_tracker_keyindextracker_key
idx_prospects_last_firstindexlast_name,first_name,deleted
idx_prospecs_del_lastindexlast_name,deleted
idx_prospects_id_delindexid,deleted
idx_prospects_assignedindexassigned_user_id


MySQL prospects_cstm Definitions:
nametypelendefault
id_cchar36
jjwg_maps_lng_cfloat11,80.00000000
jjwg_maps_lat_cfloat10,80.00000000
jjwg_maps_geocode_status_cvarchar255
jjwg_maps_address_cvarchar255
MySQL prospects_cstm Keys:
nametypefields
primaryprimaryid_c


MySQL relationships Definitions:
nametypelen
idchar36
relationship_namevarchar150
lhs_modulevarchar100
lhs_tablevarchar64
lhs_keyvarchar64
rhs_modulevarchar100
rhs_tablevarchar64
rhs_keyvarchar64
join_tablevarchar64
join_key_lhsvarchar64
join_key_rhsvarchar64
relationship_typevarchar64
relationship_role_columnvarchar64
relationship_role_column_valuevarchar50
reversetinyint
deletedtinyint
MySQL relationships Keys:
nametypefields
primaryprimaryid
idx_rel_nameindexrelationship_name


MySQL releases Definitions:
nametypelen
idchar36
deletedtinyint
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar50
list_orderint4
statusvarchar100
MySQL releases Keys:
nametypefields
primaryprimaryid
idx_releasesindexname,deleted


MySQL reminders Definitions:
nametypelenrequired
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
popuptinyint
emailtinyint
email_senttinyint
timer_popupvarchar32
timer_emailvarchar32
related_event_modulevarchar32
related_event_module_idchar36true
date_willexecuteint60-1
popup_viewedtinyint
MySQL reminders Keys:
nametypefields
primaryprimaryid
idx_reminder_nameindexname
idx_reminder_deletedindexdeleted
idx_reminder_related_event_moduleindexrelated_event_module
idx_reminder_related_event_module_idindexrelated_event_module_id


MySQL reminders_invitees Definitions:
nametypelenrequired
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
reminder_idchar36true
related_invitee_modulevarchar32
related_invitee_module_idchar36true
MySQL reminders_invitees Keys:
nametypefields
primaryprimaryid
idx_reminder_invitee_nameindexname
idx_reminder_invitee_assigned_user_idindexassigned_user_id
idx_reminder_invitee_reminder_idindexreminder_id
idx_reminder_invitee_related_invitee_moduleindexrelated_invitee_module
idx_reminder_invitee_related_invitee_module_idindexrelated_invitee_module_id


MySQL roles Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
namevarchar150
descriptiontext
modulestext
deletedtinyint
MySQL roles Keys:
nametypefields
primaryprimaryid
idx_role_id_delindexid,deleted


MySQL roles_modules Definitions:
nametypelen
idvarchar36
role_idvarchar36
module_idvarchar36
allowtinyint
date_modifieddatetime
deletedtinyint
MySQL roles_modules Keys:
nametypefields
primaryprimaryid
idx_role_idindexrole_id
idx_module_idindexmodule_id


MySQL roles_users Definitions:
nametypelen
idvarchar36
role_idvarchar36
user_idvarchar36
date_modifieddatetime
deletedtinyint
MySQL roles_users Keys:
nametypefields
primaryprimaryid
idx_ru_role_idindexrole_id
idx_ru_user_idindexuser_id


MySQL saved_search Definitions:
nametypelen
idchar36
namevarchar150
search_modulevarchar150
deletedtinyint
date_entereddatetime
date_modifieddatetime
assigned_user_idchar36
contentstext
descriptiontext
MySQL saved_search Keys:
nametypefields
primaryprimaryid
idx_descindexname,deleted


MySQL schedulers Definitions:
nametypelen
idvarchar36
deletedtinyint
date_entereddatetime
date_modifieddatetime
created_bychar36
modified_user_idchar36
namevarchar255
jobvarchar255
date_time_startdatetime
date_time_enddatetime
job_intervalvarchar100
time_fromtime
time_totime
last_rundatetime
statusvarchar100
catch_uptinyint1
MySQL schedulers Keys:
nametypefields
primaryprimaryid
idx_scheduleindexdate_time_start,deleted


MySQL securitygroups Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
noninheritabletinyint
MySQL securitygroups Keys:
nametypefields
primaryprimaryid


MySQL securitygroups_acl_roles Definitions:
nametypelen
idchar36
securitygroup_idchar36
role_idchar36
date_modifieddatetime
deletedtinyint
MySQL securitygroups_acl_roles Keys:
nametypefields
primaryprimaryid


MySQL securitygroups_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL securitygroups_audit Keys:
nametypefields
primaryprimaryid
idx_securitygroups_parent_idindexparent_id


MySQL securitygroups_default Definitions:
nametypelen
idchar36
securitygroup_idchar36
modulevarchar50
date_modifieddatetime
deletedtinyint
MySQL securitygroups_default Keys:
nametypefields
primaryprimaryid


MySQL securitygroups_records Definitions:
nametypelen
idchar36
securitygroup_idchar36
record_idchar36
modulechar36
date_modifieddatetime
modified_user_idchar36
created_bychar36
deletedtinyint
MySQL securitygroups_records Keys:
nametypefields
primaryprimaryid
idx_securitygroups_records_modindexmodule,deleted,record_id,securitygroup_id
idx_securitygroups_records_delindexdeleted,record_id,module,securitygroup_id


MySQL securitygroups_users Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
securitygroup_idvarchar36
user_idvarchar36
primary_grouptinyint
noninheritabletinyint
MySQL securitygroups_users Keys:
nametypefields
primaryprimaryid
securitygroups_users_idxaindexsecuritygroup_id
securitygroups_users_idxbindexuser_id
securitygroups_users_idxcindexuser_id,deleted,securitygroup_id,id
securitygroups_users_idxdindexuser_id,deleted,securitygroup_id


MySQL spots Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
configlongtext
typevarchar255
MySQL spots Keys:
nametypefields
primaryprimaryid


MySQL sugarfeed Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
related_modulevarchar100
related_idchar36
link_urlvarchar255
link_typevarchar30
MySQL sugarfeed Keys:
nametypefields
primaryprimaryid
sgrfeed_dateindexdate_entered,deleted


MySQL surveyquestionoptions Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
sort_orderint255
survey_question_idchar36
MySQL surveyquestionoptions Keys:
nametypefields
primaryprimaryid


MySQL surveyquestionoptions_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL surveyquestionoptions_audit Keys:
nametypefields
primaryprimaryid
idx_surveyquestionoptions_parent_idindexparent_id


MySQL surveyquestionoptions_surveyquestionresponses Definitions:
nametypelen
idvarchar36
date_modifieddatetime
deletedtinyint
surveyq72c7options_idavarchar36
surveyq10d4sponses_idbvarchar36
MySQL surveyquestionoptions_surveyquestionresponses Keys:
nametypefields
primaryprimaryid
surveyquestionoptions_surveyquestionresponses_altindexsurveyq72c7options_ida,surveyq10d4sponses_idb


MySQL surveyquestionresponses Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
answertext
answer_booltinyint
answer_datetimedatetime
surveyquestion_idchar36
surveyresponse_idchar36
MySQL surveyquestionresponses Keys:
nametypefields
primaryprimaryid


MySQL surveyquestionresponses_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL surveyquestionresponses_audit Keys:
nametypefields
primaryprimaryid
idx_surveyquestionresponses_parent_idindexparent_id


MySQL surveyquestions Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
sort_orderint255
typevarchar100
happiness_questiontinyint
survey_idchar36
MySQL surveyquestions Keys:
nametypefields
primaryprimaryid


MySQL surveyquestions_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL surveyquestions_audit Keys:
nametypefields
primaryprimaryid
idx_surveyquestions_parent_idindexparent_id


MySQL surveyresponses Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
happinessint11
email_response_senttinyint
account_idchar36
campaign_idchar36
contact_idchar36
survey_idchar36
MySQL surveyresponses Keys:
nametypefields
primaryprimaryid


MySQL surveyresponses_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL surveyresponses_audit Keys:
nametypefields
primaryprimaryid
idx_surveyresponses_parent_idindexparent_id


MySQL surveys Definitions:
nametypelendefault
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
statusvarchar100Draft
submit_textvarchar255Submit
satisfied_textvarchar255Satisfied
neither_textvarchar255Neither Satisfied nor Dissatisfied
dissatisfied_textvarchar255Dissatisfied
MySQL surveys Keys:
nametypefields
primaryprimaryid


MySQL surveys_audit Definitions:
nametypelenrequired
idchar36
parent_idchar36true
date_createddatetime
created_byvarchar36
field_namevarchar100
data_typevarchar100
before_value_stringvarchar255
after_value_stringvarchar255
before_value_texttext
after_value_texttext
MySQL surveys_audit Keys:
nametypefields
primaryprimaryid
idx_surveys_parent_idindexparent_id


MySQL tasks Definitions:
nametypelendefault
idchar36
namevarchar50
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
assigned_user_idchar36
statusvarchar100Not Started
date_due_flagtinyint
date_duedatetime
date_start_flagtinyint
date_startdatetime
parent_typevarchar255
parent_idchar36
contact_idchar36
priorityvarchar100
MySQL tasks Keys:
nametypefields
primaryprimaryid
idx_tsk_nameindexname
idx_task_con_delindexcontact_id,deleted
idx_task_par_delindexparent_id,parent_type,deleted
idx_task_assignedindexassigned_user_id
idx_task_statusindexstatus


MySQL templatesectionline Definitions:
nametypelen
idchar36
namevarchar255
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
descriptiontext
deletedtinyint
thumbnailvarchar255
grpvarchar255
ordint11
MySQL templatesectionline Keys:
nametypefields
primaryprimaryid


MySQL tracker Definitions:
nametypelenauto_increment
idint111
monitor_idchar36true
user_idvarchar36
module_namevarchar255
item_idvarchar36
item_summaryvarchar255
date_modifieddatetime
actionvarchar255
session_idvarchar36
visibletinyint
deletedtinyint
MySQL tracker Keys:
nametypefields
primaryprimaryid
idx_tracker_iidindexitem_id
idx_tracker_userid_vis_idindexuser_id,visible,id
idx_tracker_userid_itemid_visindexuser_id,item_id,visible
idx_tracker_monitor_idindexmonitor_id
idx_tracker_date_modifiedindexdate_modified


MySQL upgrade_history Definitions:
nametypelen
idchar36
filenamevarchar255
md5sumvarchar32
typevarchar30
statusvarchar50
versionvarchar64
namevarchar255
descriptiontext
id_namevarchar255
manifestlongtext
date_entereddatetime
enabledtinyint1
MySQL upgrade_history Keys:
nametypefields
primaryprimaryid
upgrade_history_md5_ukuniquemd5sum


MySQL user_preferences Definitions:
nametypelen
idchar36
categoryvarchar50
deletedtinyint
date_entereddatetime
date_modifieddatetime
assigned_user_idchar36
contentslongtext
MySQL user_preferences Keys:
nametypefields
primaryprimaryid
idx_userprefnamecatindexassigned_user_id,category


MySQL users Definitions:
nametypelen
idchar36
user_namevarchar60
user_hashvarchar255
system_generated_passwordtinyint
pwd_last_changeddatetime
authenticate_idvarchar100
sugar_logintinyint1
first_namevarchar255
last_namevarchar255
is_admintinyint
external_auth_onlytinyint
receive_notificationstinyint1
descriptiontext
date_entereddatetime
date_modifieddatetime
modified_user_idchar36
created_bychar36
titlevarchar50
photovarchar255
departmentvarchar50
phone_homevarchar50
phone_mobilevarchar50
phone_workvarchar50
phone_othervarchar50
phone_faxvarchar50
statusvarchar100
address_streetvarchar150
address_cityvarchar100
address_statevarchar100
address_countryvarchar100
address_postalcodevarchar20
deletedtinyint
portal_onlytinyint
show_on_employeestinyint1
employee_statusvarchar100
messenger_idvarchar100
messenger_typevarchar100
reports_to_idchar36
is_grouptinyint
factor_authtinyint
factor_auth_interfacevarchar255
MySQL users Keys:
nametypefields
primaryprimaryid
idx_user_nameindexuser_name,is_group,status,last_name (30),first_name (30),id


MySQL users_feeds Definitions:
nametypelen
user_idvarchar36
feed_idvarchar36
rankint11
date_modifieddatetime
deletedtinyint
MySQL users_feeds Keys:
nametypefields
idx_ud_user_idindexuser_id,feed_id


MySQL users_last_import Definitions:
nametypelen
idchar36
assigned_user_idchar36
import_modulevarchar36
bean_typevarchar36
bean_idchar36
deletedtinyint
MySQL users_last_import Keys:
nametypefields
primaryprimaryid
idx_user_idindexassigned_user_id


MySQL users_password_link Definitions:
nametypelen
idchar36
usernamevarchar36
date_generateddatetime
deletedtinyint
MySQL users_password_link Keys:
nametypefields
primaryprimaryid
idx_usernameindexusername


MySQL users_signatures Definitions:
nametypelen
idchar36
date_entereddatetime
date_modifieddatetime
deletedtinyint
user_idvarchar36
namevarchar255
signaturetext
signature_htmltext
MySQL users_signatures Keys:
nametypefields
primaryprimaryid
idx_usersig_uidindexuser_id


MySQL vcals Definitions:
nametypelenrequired
idchar36
deletedtinyint
date_entereddatetime
date_modifieddatetime
user_idchar36true
typevarchar100
sourcevarchar100
contenttext
MySQL vcals Keys:
nametypefields
primaryprimaryid
idx_vcalindextype,user_id