SchemaSpy Analysis of ss676co - Columnsgenerated | Generated by SchemaSpy |
Generated on Wed Jul 02 08:05 UTC 2014 |
| ||||||
|
ss676co contains 2270 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | |
---|---|---|---|---|---|---|---|
calls_contacts | accept_status | varchar | 25 | √ | none | ||
calls_leads | accept_status | varchar | 25 | √ | none | ||
calls_users | accept_status | varchar | 25 | √ | none | ||
meetings_contacts | accept_status | varchar | 25 | √ | none | ||
meetings_leads | accept_status | varchar | 25 | √ | none | ||
meetings_users | accept_status | varchar | 25 | √ | none | ||
acl_roles_actions | access_override | int | 3 | √ | null | ||
leads | account_description | text | 65535 | √ | null | ||
accounts_bugs | account_id | varchar | 36 | √ | null | ||
accounts_cases | account_id | varchar | 36 | √ | null | ||
accounts_contacts | account_id | varchar | 36 | √ | null | ||
accounts_opportunities | account_id | varchar | 36 | √ | null | ||
cases | account_id | char | 36 | √ | null | ||
contracts | account_id | char | 36 | √ | null | ||
documents_accounts | account_id | char | 36 | √ | null | ||
leads | account_id | char | 36 | √ | null | ||
products | account_id | char | 36 | √ | null | ||
projects_accounts | account_id | varchar | 36 | √ | null | ||
quotes_accounts | account_id | varchar | 36 | √ | null | ||
leads | account_name | varchar | 255 | √ | null | ||
prospects | account_name | varchar | 150 | √ | null | ||
quotes_accounts | account_role | varchar | 20 | √ | null | ||
accounts | account_type | varchar | 50 | √ | null | ||
acl_actions | aclaccess | int | 3 | √ | null | ||
acl_fields | aclaccess | int | 3 | √ | null | ||
acl_actions | acltype | varchar | 100 | √ | null | ||
tracker | action | varchar | 255 | √ | null | ||
acl_roles_actions | action_id | varchar | 36 | √ | null | ||
workflow_actionshells | action_module | varchar | 255 | √ | null | ||
workflow_actionshells | action_type | varchar | 100 | √ | null | ||
report_schedules | active | bit | 1 | √ | 0 | ||
tracker_sessions | active | bit | 1 | √ | 1 | ||
documents | active_date | date | 10 | √ | null | ||
kbdocuments | active_date | date | 10 | √ | null | ||
campaign_log | activity_date | datetime | 19 | √ | null | ||
campaign_log | activity_type | varchar | 100 | √ | null | ||
campaigns | actual_cost | double | 22 | √ | null | ||
project_task | actual_duration | int | 11 | √ | null | ||
project_task | actual_effort | int | 11 | √ | null | ||
users | address_city | varchar | 100 | √ | null | ||
users | address_country | varchar | 100 | √ | null | ||
users | address_postalcode | varchar | 20 | √ | null | ||
users | address_state | varchar | 100 | √ | null | ||
users | address_street | varchar | 150 | √ | null | ||
emails_email_addr_rel | address_type | varchar | 4 | √ | null | ||
workflow_alerts | address_type | varchar | 100 | √ | null | ||
workflow_actions | adv_type | varchar | 10 | √ | null | ||
accounts_audit | after_value_string | varchar | 255 | √ | null | ||
bugs_audit | after_value_string | varchar | 255 | √ | null | ||
campaigns_audit | after_value_string | varchar | 255 | √ | null | ||
cases_audit | after_value_string | varchar | 255 | √ | null | ||
contacts_audit | after_value_string | varchar | 255 | √ | null | ||
contracts_audit | after_value_string | varchar | 255 | √ | null | ||
kbcontents_audit | after_value_string | varchar | 255 | √ | null | ||
leads_audit | after_value_string | varchar | 255 | √ | null | ||
notifications_audit | after_value_string | varchar | 255 | √ | null | ||
opportunities_audit | after_value_string | varchar | 255 | √ | null | ||
products_audit | after_value_string | varchar | 255 | √ | null | ||
project_task_audit | after_value_string | varchar | 255 | √ | null | ||
quotes_audit | after_value_string | varchar | 255 | √ | null | ||
accounts_audit | after_value_text | text | 65535 | √ | null | ||
bugs_audit | after_value_text | text | 65535 | √ | null | ||
campaigns_audit | after_value_text | text | 65535 | √ | null | ||
cases_audit | after_value_text | text | 65535 | √ | null | ||
contacts_audit | after_value_text | text | 65535 | √ | null | ||
contracts_audit | after_value_text | text | 65535 | √ | null | ||
kbcontents_audit | after_value_text | text | 65535 | √ | null | ||
leads_audit | after_value_text | text | 65535 | √ | null | ||
notifications_audit | after_value_text | text | 65535 | √ | null | ||
opportunities_audit | after_value_text | text | 65535 | √ | null | ||
products_audit | after_value_text | text | 65535 | √ | null | ||
project_task_audit | after_value_text | text | 65535 | √ | null | ||
quotes_audit | after_value_text | text | 65535 | √ | null | ||
workflow_alertshells | alert_text | text | 65535 | √ | null | ||
workflow_alertshells | alert_type | varchar | 100 | √ | null | ||
email_marketing | all_prospect_lists | bit | 1 | √ | 0 | ||
roles_modules | allow | bit | 1 | √ | 0 | ||
contacts | alt_address_city | varchar | 100 | √ | null | ||
leads | alt_address_city | varchar | 100 | √ | null | ||
prospects | alt_address_city | varchar | 100 | √ | null | ||
contacts | alt_address_country | varchar | 255 | √ | null | ||
leads | alt_address_country | varchar | 255 | √ | null | ||
prospects | alt_address_country | varchar | 255 | √ | null | ||
contacts | alt_address_postalcode | varchar | 20 | √ | null | ||
leads | alt_address_postalcode | varchar | 20 | √ | null | ||
prospects | alt_address_postalcode | varchar | 20 | √ | null | ||
contacts | alt_address_state | varchar | 100 | √ | null | ||
leads | alt_address_state | varchar | 100 | √ | null | ||
prospects | alt_address_state | varchar | 100 | √ | null | ||
contacts | alt_address_street | varchar | 150 | √ | null | ||
leads | alt_address_street | varchar | 150 | √ | null | ||
prospects | alt_address_street | varchar | 150 | √ | null | ||
opportunities | amount | decimal | 26,6 | √ | null | ||
quotas | amount | decimal | 26,6 | √ | null | ||
quotas | amount_base_currency | decimal | 26,6 | √ | null | ||
opportunities | amount_usdollar | decimal | 26,6 | √ | null | ||
accounts | annual_revenue | varchar | 100 | √ | null | ||
email_cache | answered | tinyint | 4 | √ | null | ||
eapm | api_data | text | 65535 | √ | null | ||
eapm | application | varchar | 100 | √ | webex | ||
campaign_log | archived | bit | 1 | √ | 0 | ||
workflow_alerts | array_type | varchar | 100 | √ | null | ||
products | asset_number | varchar | 50 | √ | null | ||
folders | assign_to_id | char | 36 | √ | null | ||
accounts | assigned_user_id | char | 36 | √ | null | ||
address_book | assigned_user_id | char | 36 | ||||
address_book_lists | assigned_user_id | char | 36 | ||||
bugs | assigned_user_id | char | 36 | √ | null | ||
calls | assigned_user_id | char | 36 | √ | null | ||
campaigns | assigned_user_id | char | 36 | √ | null | ||
cases | assigned_user_id | char | 36 | √ | null | ||
contacts | assigned_user_id | char | 36 | √ | null | ||
contracts | assigned_user_id | char | 36 | √ | null | ||
documents | assigned_user_id | char | 36 | √ | null | ||
eapm | assigned_user_id | char | 36 | √ | null | ||
email_templates | assigned_user_id | char | 36 | √ | null | ||
emails | assigned_user_id | char | 36 | √ | null | ||
folders_subscriptions | assigned_user_id | char | 36 | ||||
forecast_manager_worksheets | assigned_user_id | char | 36 | √ | null | ||
forecast_worksheets | assigned_user_id | char | 36 | √ | null | ||
forecastmanagerworksheets | assigned_user_id | unknown | 0 | ||||
forecastworksheets | assigned_user_id | unknown | 0 | ||||
import_maps | assigned_user_id | char | 36 | √ | null | ||
job_queue | assigned_user_id | char | 36 | √ | null | ||
kbdocuments | assigned_user_id | char | 36 | √ | null | ||
leads | assigned_user_id | char | 36 | √ | null | ||
meetings | assigned_user_id | char | 36 | √ | null | ||
notes | assigned_user_id | char | 36 | √ | null | ||
notifications | assigned_user_id | char | 36 | √ | null | ||
oauth_consumer | assigned_user_id | char | 36 | √ | null | ||
oauth_tokens | assigned_user_id | char | 36 | √ | null | ||
oauthkeys | assigned_user_id | unknown | 0 | ||||
opportunities | assigned_user_id | char | 36 | √ | null | ||
pdfmanager | assigned_user_id | char | 36 | √ | null | ||
product_categories | assigned_user_id | varchar | 36 | √ | null | ||
products | assigned_user_id | char | 36 | √ | null | ||
project | assigned_user_id | char | 36 | √ | null | ||
project_task | assigned_user_id | char | 36 | √ | null | ||
prospect_lists | assigned_user_id | char | 36 | √ | null | ||
prospects | assigned_user_id | char | 36 | √ | null | ||
quotes | assigned_user_id | char | 36 | √ | null | ||
report_cache | assigned_user_id | char | 36 | ||||
saved_reports | assigned_user_id | char | 36 | √ | null | ||
saved_search | assigned_user_id | char | 36 | √ | null | ||
schedulersjobs | assigned_user_id | unknown | 0 | ||||
sugarfavorites | assigned_user_id | char | 36 | √ | null | ||
sugarfeed | assigned_user_id | char | 36 | √ | null | ||
tasks | assigned_user_id | char | 36 | √ | null | ||
user_preferences | assigned_user_id | char | 36 | ||||
users_last_import | assigned_user_id | char | 36 | √ | null | ||
contacts | assistant | varchar | 75 | √ | null | ||
leads | assistant | varchar | 75 | √ | null | ||
prospects | assistant | varchar | 75 | √ | null | ||
contacts | assistant_phone | varchar | 100 | √ | null | ||
leads | assistant_phone | varchar | 100 | √ | null | ||
prospects | assistant_phone | varchar | 100 | √ | null | ||
teams | associated_user_id | char | 36 | √ | null | ||
fields_meta_data | audited | bit | 1 | √ | 0 | ||
users | authenticate_id | varchar | 100 | √ | null | ||
pdfmanager | author | varchar | 255 | √ | SugarCRM | ||
inbound_email_autoreply | autoreplied_to | varchar | 100 | √ | null | ||
email_templates | base_module | varchar | 50 | √ | null | ||
pdfmanager | base_module | varchar | 100 | √ | null | ||
workflow | base_module | varchar | 50 | √ | null | ||
forecast_manager_worksheets | base_rate | double | 22 | √ | null | ||
forecast_worksheets | base_rate | double | 22 | √ | null | ||
forecasts | base_rate | double | 22 | √ | null | ||
opportunities | base_rate | double | 22 | √ | null | ||
products | base_rate | double | 22 | √ | null | ||
quotas | base_rate | double | 22 | √ | null | ||
quotes | base_rate | double | 22 | √ | null | ||
worksheet | base_rate | double | 22 | √ | null | ||
emails_text | bcc_addrs | text | 65535 | √ | null | ||
address_book | bean | varchar | 50 | √ | null | ||
address_book | bean_id | char | 36 | ||||
address_book_list_items | bean_id | char | 36 | ||||
cron_remove_documents | bean_id | varchar | 36 | √ | null | ||
custom_fields | bean_id | char | 36 | √ | null | ||
email_addr_bean_rel | bean_id | char | 36 | ||||
emails_beans | bean_id | char | 36 | √ | null | ||
fts_queue | bean_id | char | 36 | √ | null | ||
users_last_import | bean_id | char | 36 | √ | null | ||
workflow_schedules | bean_id | char | 36 | √ | null | ||
email_addr_bean_rel | bean_module | varchar | 100 | √ | null | ||
emails_beans | bean_module | varchar | 100 | √ | null | ||
fts_queue | bean_module | varchar | 100 | √ | null | ||
users_last_import | bean_type | varchar | 36 | √ | null | ||
accounts_audit | before_value_string | varchar | 255 | √ | null | ||
bugs_audit | before_value_string | varchar | 255 | √ | null | ||
campaigns_audit | before_value_string | varchar | 255 | √ | null | ||
cases_audit | before_value_string | varchar | 255 | √ | null | ||
contacts_audit | before_value_string | varchar | 255 | √ | null | ||
contracts_audit | before_value_string | varchar | 255 | √ | null | ||
kbcontents_audit | before_value_string | varchar | 255 | √ | null | ||
leads_audit | before_value_string | varchar | 255 | √ | null | ||
notifications_audit | before_value_string | varchar | 255 | √ | null | ||
opportunities_audit | before_value_string | varchar | 255 | √ | null | ||
products_audit | before_value_string | varchar | 255 | √ | null | ||
project_task_audit | before_value_string | varchar | 255 | √ | null | ||
quotes_audit | before_value_string | varchar | 255 | √ | null | ||
accounts_audit | before_value_text | text | 65535 | √ | null | ||
bugs_audit | before_value_text | text | 65535 | √ | null | ||
campaigns_audit | before_value_text | text | 65535 | √ | null | ||
cases_audit | before_value_text | text | 65535 | √ | null | ||
contacts_audit | before_value_text | text | 65535 | √ | null | ||
contracts_audit | before_value_text | text | 65535 | √ | null | ||
kbcontents_audit | before_value_text | text | 65535 | √ | null | ||
leads_audit | before_value_text | text | 65535 | √ | null | ||
notifications_audit | before_value_text | text | 65535 | √ | null | ||
opportunities_audit | before_value_text | text | 65535 | √ | null | ||
products_audit | before_value_text | text | 65535 | √ | null | ||
project_task_audit | before_value_text | text | 65535 | √ | null | ||
quotes_audit | before_value_text | text | 65535 | √ | null | ||
forecast_manager_worksheets | best_case | decimal | 26,6 | √ | null | ||
forecast_worksheets | best_case | decimal | 26,6 | √ | null | ||
forecasts | best_case | decimal | 26,6 | √ | null | ||
opportunities | best_case | decimal | 26,6 | √ | null | ||
products | best_case | decimal | 26,6 | √ | null | ||
worksheet | best_case | decimal | 26,6 | √ | null | ||
forecast_manager_worksheets | best_case_adjusted | decimal | 26,6 | √ | null | ||
accounts | billing_address_city | varchar | 100 | √ | null | ||
quotes | billing_address_city | varchar | 100 | √ | null | ||
accounts | billing_address_country | varchar | 255 | √ | null | ||
quotes | billing_address_country | varchar | 100 | √ | null | ||
accounts | billing_address_postalcode | varchar | 20 | √ | null | ||
quotes | billing_address_postalcode | varchar | 20 | √ | null | ||
accounts | billing_address_state | varchar | 100 | √ | null | ||
quotes | billing_address_state | varchar | 100 | √ | null | ||
accounts | billing_address_street | varchar | 150 | √ | null | ||
quotes | billing_address_street | varchar | 150 | √ | null | ||
contacts | birthdate | date | 10 | √ | null | ||
leads | birthdate | date | 10 | √ | null | ||
prospects | birthdate | date | 10 | √ | null | ||
email_templates | body | text | 65535 | √ | null | ||
email_templates | body_html | text | 65535 | √ | null | ||
pdfmanager | body_html | text | 65535 | √ | null | ||
products | book_value | decimal | 26,6 | √ | null | ||
products | book_value_date | date | 10 | √ | null | ||
products | book_value_usdollar | decimal | 26,6 | √ | null | ||
campaigns | budget | double | 22 | √ | null | ||
accounts_bugs | bug_id | varchar | 36 | √ | null | ||
cases_bugs | bug_id | varchar | 36 | √ | null | ||
contacts_bugs | bug_id | varchar | 36 | √ | null | ||
documents_bugs | bug_id | char | 36 | √ | null | ||
projects_bugs | bug_id | varchar | 36 | √ | null | ||
bugs | bug_number | int | 11 | √ | |||
product_bundle_note | bundle_id | varchar | 36 | √ | null | ||
product_bundle_product | bundle_id | varchar | 36 | √ | null | ||
product_bundle_quote | bundle_id | varchar | 36 | √ | null | ||
product_bundle_quote | bundle_index | int | 11 | √ | 0 | ||
product_bundles | bundle_stage | varchar | 255 | √ | null | ||
oauth_consumer | c_key | varchar | 255 | √ | null | ||
oauth_consumer | c_secret | varchar | 255 | √ | null | ||
quotes | calc_grand_total | bit | 1 | √ | 1 | ||
calls_contacts | call_id | char | 36 | √ | null | ||
calls_leads | call_id | char | 36 | √ | null | ||
calls_users | call_id | char | 36 | √ | null | ||
oauth_tokens | callback_url | varchar | 255 | √ | null | ||
emails_beans | campaign_data | text | 65535 | √ | null | ||
accounts | campaign_id | char | 36 | √ | null | ||
campaign_log | campaign_id | char | 36 | √ | null | ||
campaign_trkrs | campaign_id | char | 36 | √ | null | ||
contacts | campaign_id | char | 36 | √ | null | ||
email_marketing | campaign_id | char | 36 | √ | null | ||
emailman | campaign_id | char | 36 | √ | null | ||
leads | campaign_id | char | 36 | √ | null | ||
opportunities | campaign_id | char | 36 | √ | null | ||
prospect_list_campaigns | campaign_id | varchar | 36 | √ | null | ||
prospects | campaign_id | char | 36 | √ | null | ||
campaigns | campaign_type | varchar | 100 | √ | null | ||
forecast_schedule | cascade_hierarchy | bit | 1 | √ | null | ||
accounts_cases | case_id | varchar | 36 | √ | null | ||
cases_bugs | case_id | varchar | 36 | √ | null | ||
contacts_cases | case_id | varchar | 36 | √ | null | ||
documents_cases | case_id | char | 36 | √ | null | ||
kbdocuments | case_id | char | 36 | √ | null | ||
projects_cases | case_id | varchar | 36 | √ | null | ||
cases | case_number | int | 11 | √ | |||
schedulers | catch_up | bit | 1 | √ | 1 | ||
acl_actions | category | varchar | 100 | √ | null | ||
acl_fields | category | varchar | 100 | √ | null | ||
config | category | varchar | 32 | √ | null | ||
user_preferences | category | varchar | 50 | √ | null | ||
documents | category_id | varchar | 100 | √ | null | ||
product_templates | category_id | char | 36 | √ | null | ||
products | category_id | char | 36 | √ | null | ||
emails_text | cc_addrs | text | 65535 | √ | null | ||
document_revisions | change_log | varchar | 255 | √ | null | ||
kbdocument_revisions | change_log | varchar | 255 | √ | null | ||
saved_reports | chart_type | varchar | 36 | √ | none | ||
product_product | child_id | varchar | 36 | √ | null | ||
job_queue | client | varchar | 255 | √ | null | ||
tracker_sessions | client_ip | varchar | 45 | √ | null | ||
oauth_consumer | client_type | varchar | 50 | √ | user | ||
forecast_manager_worksheets | closed_amount | decimal | 26,6 | √ | 0.000000 | ||
forecasts | closed_amount | decimal | 26,6 | √ | 0.000000 | ||
fields_meta_data | comments | varchar | 255 | √ | null | ||
forecast_worksheets | commit_stage | varchar | 20 | √ | null | ||
opportunities | commit_stage | varchar | 20 | √ | null | ||
products | commit_stage | varchar | 20 | √ | null | ||
worksheet | commit_stage | varchar | 20 | √ | null | ||
quotas | committed | bit | 1 | √ | 0 | ||
contracts | company_signed_date | date | 10 | √ | null | ||
oauth_nonce | conskey | varchar | 32 | ||||
oauth_tokens | consumer | char | 36 | ||||
eapm | consumer_key | varchar | 255 | √ | null | ||
eapm | consumer_secret | varchar | 255 | √ | null | ||
accounts_contacts | contact_id | varchar | 36 | √ | null | ||
calls_contacts | contact_id | char | 36 | √ | null | ||
contacts_bugs | contact_id | varchar | 36 | √ | null | ||
contacts_cases | contact_id | varchar | 36 | √ | null | ||
contacts_users | contact_id | varchar | 36 | √ | null | ||
contracts_contacts | contact_id | varchar | 36 | √ | null | ||
documents_contacts | contact_id | char | 36 | √ | null | ||
leads | contact_id | char | 36 | √ | null | ||
meetings_contacts | contact_id | char | 36 | √ | null | ||
notes | contact_id | char | 36 | √ | null | ||
oauth_tokens | contact_id | char | 36 | √ | null | ||
opportunities_contacts | contact_id | varchar | 36 | √ | null | ||
products | contact_id | char | 36 | √ | null | ||
projects_contacts | contact_id | varchar | 36 | √ | null | ||
quotes_contacts | contact_id | varchar | 36 | √ | null | ||
tasks | contact_id | char | 36 | √ | null | ||
contacts_bugs | contact_role | varchar | 50 | √ | null | ||
contacts_cases | contact_role | varchar | 50 | √ | null | ||
opportunities_contacts | contact_role | varchar | 50 | √ | null | ||
quotes_contacts | contact_role | varchar | 20 | √ | null | ||
campaigns | content | text | 65535 | √ | null | ||
import_maps | content | text | 65535 | √ | null | ||
saved_reports | content | longtext | 2147483647 | √ | null | ||
vcals | content | text | 65535 | √ | null | ||
report_cache | contents | text | 65535 | √ | null | ||
saved_search | contents | text | 65535 | √ | null | ||
user_preferences | contents | longtext | 2147483647 | √ | null | ||
contracts_contacts | contract_id | varchar | 36 | √ | null | ||
contracts_opportunities | contract_id | varchar | 36 | √ | null | ||
contracts_products | contract_id | varchar | 36 | √ | null | ||
contracts_quotes | contract_id | varchar | 36 | √ | null | ||
currencies | conversion_rate | double | 22 | √ | 0 | ||
leads | converted | bit | 1 | √ | 0 | ||
product_templates | cost_price | decimal | 26,6 | √ | null | ||
products | cost_price | decimal | 26,6 | √ | null | ||
product_templates | cost_usdollar | decimal | 26,6 | √ | null | ||
products | cost_usdollar | decimal | 26,6 | √ | null | ||
accounts | created_by | char | 36 | √ | null | ||
accounts_audit | created_by | char | 36 | √ | null | ||
acl_actions | created_by | char | 36 | √ | null | ||
acl_fields | created_by | char | 36 | √ | null | ||
acl_roles | created_by | char | 36 | √ | null | ||
bugs | created_by | char | 36 | √ | null | ||
bugs_audit | created_by | char | 36 | √ | null | ||
calls | created_by | char | 36 | √ | null | ||
campaign_trkrs | created_by | char | 36 | √ | null | ||
campaigns | created_by | char | 36 | √ | null | ||
campaigns_audit | created_by | char | 36 | √ | null | ||
cases | created_by | char | 36 | √ | null | ||
cases_audit | created_by | char | 36 | √ | null | ||
contacts | created_by | char | 36 | √ | null | ||
contacts_audit | created_by | char | 36 | √ | null | ||
contract_types | created_by | char | 36 | √ | null | ||
contracts | created_by | char | 36 | √ | null | ||
contracts_audit | created_by | char | 36 | √ | null | ||
currencies | created_by | char | 36 | ||||
document_revisions | created_by | char | 36 | √ | null | ||
documents | created_by | char | 36 | √ | null | ||
eapm | created_by | char | 36 | √ | null | ||
email_marketing | created_by | char | 36 | √ | null | ||
email_templates | created_by | varchar | 36 | √ | null | ||
emails | created_by | char | 36 | √ | null | ||
expressions | created_by | char | 36 | √ | null | ||
folders | created_by | char | 36 | ||||
forecast_manager_worksheets | created_by | char | 36 | √ | null | ||
forecast_schedule | created_by | char | 36 | √ | null | ||
forecast_worksheets | created_by | char | 36 | √ | null | ||
forecastmanagerworksheets | created_by | unknown | 0 | ||||
forecastworksheets | created_by | unknown | 0 | ||||
holidays | created_by | char | 36 | √ | null | ||
inbound_email | created_by | char | 36 | √ | null | ||
kbcontents_audit | created_by | char | 36 | √ | null | ||
kbdocument_revisions | created_by | char | 36 | √ | null | ||
kbdocuments | created_by | char | 36 | √ | null | ||
kbdocuments_kbtags | created_by | char | 36 | √ | null | ||
kbtags | created_by | char | 36 | √ | null | ||
leads | created_by | char | 36 | √ | null | ||
leads_audit | created_by | char | 36 | √ | null | ||
manufacturers | created_by | char | 36 | √ | null | ||
meetings | created_by | char | 36 | √ | null | ||
notes | created_by | char | 36 | √ | null | ||
notifications | created_by | char | 36 | √ | null | ||
notifications_audit | created_by | char | 36 | √ | null | ||
oauth_consumer | created_by | char | 36 | √ | null | ||
oauthkeys | created_by | unknown | 0 | ||||
opportunities | created_by | char | 36 | √ | null | ||
opportunities_audit | created_by | char | 36 | √ | null | ||
pdfmanager | created_by | char | 36 | √ | null | ||
product_bundle_notes | created_by | char | 36 | √ | null | ||
product_bundles | created_by | char | 36 | √ | null | ||
product_categories | created_by | char | 36 | √ | null | ||
product_templates | created_by | char | 36 | √ | null | ||
product_types | created_by | char | 36 | √ | null | ||
products | created_by | char | 36 | √ | null | ||
products_audit | created_by | char | 36 | √ | null | ||
project | created_by | char | 36 | √ | null | ||
project_resources | created_by | char | 36 | √ | null | ||
project_task | created_by | char | 36 | √ | null | ||
project_task_audit | created_by | char | 36 | √ | null | ||
prospect_lists | created_by | char | 36 | √ | null | ||
prospects | created_by | char | 36 | √ | null | ||
quotas | created_by | varchar | 36 | √ | null | ||
quotes | created_by | char | 36 | √ | null | ||
quotes_audit | created_by | char | 36 | √ | null | ||
releases | created_by | char | 36 | √ | null | ||
roles | created_by | char | 36 | √ | null | ||
saved_reports | created_by | char | 36 | √ | null | ||
schedulers | created_by | char | 36 | √ | null | ||
shippers | created_by | char | 36 | √ | null | ||
sugarfavorites | created_by | char | 36 | √ | null | ||
sugarfeed | created_by | char | 36 | √ | null | ||
tasks | created_by | char | 36 | √ | null | ||
taxrates | created_by | char | 36 | √ | null | ||
team_notices | created_by | char | 36 | √ | null | ||
team_sets | created_by | char | 36 | √ | null | ||
teams | created_by | char | 36 | √ | null | ||
timeperiods | created_by | varchar | 36 | √ | null | ||
users | created_by | char | 36 | √ | null | ||
versions | created_by | char | 36 | √ | null | ||
workflow | created_by | char | 36 | √ | null | ||
workflow_actions | created_by | char | 36 | √ | null | ||
workflow_actionshells | created_by | char | 36 | √ | null | ||
workflow_alerts | created_by | char | 36 | √ | null | ||
workflow_alertshells | created_by | char | 36 | √ | null | ||
workflow_schedules | created_by | char | 36 | √ | null | ||
workflow_triggershells | created_by | char | 36 | √ | null | ||
meetings | creator | varchar | 50 | √ | null | ||
product_templates | currency | varchar | 255 | √ | null | ||
campaigns | currency_id | char | 36 | √ | -99 | ||
contracts | currency_id | char | 36 | √ | -99 | ||
forecast_manager_worksheets | currency_id | char | 36 | √ | null | ||
forecast_worksheets | currency_id | char | 36 | √ | null | ||
forecasts | currency_id | char | 36 | √ | -99 | ||
opportunities | currency_id | char | 36 | √ | -99 | ||
product_bundles | currency_id | char | 36 | √ | -99 | ||
product_templates | currency_id | char | 36 | √ | -99 | ||
products | currency_id | char | 36 | √ | -99 | ||
quotas | currency_id | char | 36 | √ | -99 | ||
quotes | currency_id | char | 36 | √ | -99 | ||
worksheet | currency_id | char | 36 | ||||
fields_meta_data | custom_module | varchar | 255 | √ | null | ||
workflow_alertshells | custom_template_id | char | 36 | √ | null | ||
contracts | customer_signed_date | date | 10 | √ | null | ||
job_queue | data | text | 65535 | √ | null | ||
accounts_audit | data_type | varchar | 100 | √ | null | ||
bugs_audit | data_type | varchar | 100 | √ | null | ||
campaigns_audit | data_type | varchar | 100 | √ | null | ||
cases_audit | data_type | varchar | 100 | √ | null | ||
contacts_audit | data_type | varchar | 100 | √ | null | ||
contracts_audit | data_type | varchar | 100 | √ | null | ||
kbcontents_audit | data_type | varchar | 100 | √ | null | ||
leads_audit | data_type | varchar | 100 | √ | null | ||
notifications_audit | data_type | varchar | 100 | √ | null | ||
opportunities_audit | data_type | varchar | 100 | √ | null | ||
products_audit | data_type | varchar | 100 | √ | null | ||
project_task_audit | data_type | varchar | 100 | √ | null | ||
quotes_audit | data_type | varchar | 100 | √ | null | ||
product_templates | date_available | date | 10 | √ | null | ||
forecast_worksheets | date_closed | date | 10 | √ | null | ||
opportunities | date_closed | date | 10 | √ | null | ||
products | date_closed | date | 10 | √ | null | ||
forecast_worksheets | date_closed_timestamp | int | 11 | √ | null | ||
opportunities | date_closed_timestamp | int | 11 | √ | null | ||
products | date_closed_timestamp | int | 11 | √ | null | ||
product_templates | date_cost_price | date | 10 | √ | null | ||
accounts_audit | date_created | datetime | 19 | √ | null | ||
bugs_audit | date_created | datetime | 19 | √ | null | ||
campaigns_audit | date_created | datetime | 19 | √ | null | ||
cases_audit | date_created | datetime | 19 | √ | null | ||
contacts_audit | date_created | datetime | 19 | √ | null | ||
contracts_audit | date_created | datetime | 19 | √ | null | ||
email_addr_bean_rel | date_created | datetime | 19 | √ | null | ||
email_addresses | date_created | datetime | 19 | √ | null | ||
kbcontents_audit | date_created | datetime | 19 | √ | null | ||
leads_audit | date_created | datetime | 19 | √ | null | ||
notifications_audit | date_created | datetime | 19 | √ | null | ||
opportunities_audit | date_created | datetime | 19 | √ | null | ||
products_audit | date_created | datetime | 19 | √ | null | ||
project_task_audit | date_created | datetime | 19 | √ | null | ||
quotes_audit | date_created | datetime | 19 | √ | null | ||
project_task | date_due | date | 10 | √ | null | ||
tasks | date_due | datetime | 19 | √ | null | ||
tasks | date_due_flag | bit | 1 | √ | 0 | ||
calls | date_end | datetime | 19 | √ | null | ||
meetings | date_end | datetime | 19 | √ | null | ||
team_notices | date_end | date | 10 | √ | null | ||
tracker_sessions | date_end | datetime | 19 | √ | null | ||
accounts | date_entered | datetime | 19 | √ | null | ||
acl_actions | date_entered | datetime | 19 | √ | null | ||
acl_fields | date_entered | datetime | 19 | √ | null | ||
acl_roles | date_entered | datetime | 19 | √ | null | ||
bugs | date_entered | datetime | 19 | √ | null | ||
calls | date_entered | datetime | 19 | √ | null | ||
campaign_trkrs | date_entered | datetime | 19 | √ | null | ||
campaigns | date_entered | datetime | 19 | √ | null | ||
cases | date_entered | datetime | 19 | √ | null | ||
contacts | date_entered | datetime | 19 | √ | null | ||
contract_types | date_entered | datetime | 19 | √ | null | ||
contracts | date_entered | datetime | 19 | √ | null | ||
currencies | date_entered | datetime | 19 | √ | null | ||
document_revisions | date_entered | datetime | 19 | √ | null | ||
documents | date_entered | datetime | 19 | √ | null | ||
eapm | date_entered | datetime | 19 | √ | null | ||
email_marketing | date_entered | datetime | 19 | √ | null | ||
email_templates | date_entered | datetime | 19 | √ | null | ||
emailman | date_entered | datetime | 19 | √ | null | ||
emails | date_entered | datetime | 19 | √ | null | ||
expressions | date_entered | datetime | 19 | √ | null | ||
forecast_manager_worksheets | date_entered | datetime | 19 | √ | null | ||
forecast_schedule | date_entered | datetime | 19 | √ | null | ||
forecast_worksheets | date_entered | datetime | 19 | √ | null | ||
forecasts | date_entered | datetime | 19 | √ | null | ||
holidays | date_entered | datetime | 19 | √ | null | ||
import_maps | date_entered | datetime | 19 | √ | null | ||
inbound_email | date_entered | datetime | 19 | √ | null | ||
inbound_email_autoreply | date_entered | datetime | 19 | √ | null | ||
job_queue | date_entered | datetime | 19 | √ | null | ||
kbcontents | date_entered | datetime | 19 | √ | null | ||
kbdocument_revisions | date_entered | datetime | 19 | √ | null | ||
kbdocuments | date_entered | datetime | 19 | √ | null | ||
kbdocuments_kbtags | date_entered | datetime | 19 | √ | null | ||
kbtags | date_entered | datetime | 19 | √ | null | ||
leads | date_entered | datetime | 19 | √ | null | ||
manufacturers | date_entered | datetime | 19 | √ | null | ||
meetings | date_entered | datetime | 19 | √ | null | ||
notes | date_entered | datetime | 19 | √ | null | ||
notifications | date_entered | datetime | 19 | √ | null | ||
oauth_consumer | date_entered | datetime | 19 | √ | null | ||
opportunities | date_entered | datetime | 19 | √ | null | ||
pdfmanager | date_entered | datetime | 19 | √ | null | ||
product_bundle_notes | date_entered | datetime | 19 | √ | null | ||
product_bundles | date_entered | datetime | 19 | √ | null | ||
product_categories | date_entered | datetime | 19 | √ | null | ||
product_templates | date_entered | datetime | 19 | √ | null | ||
product_types | date_entered | datetime | 19 | √ | null | ||
products | date_entered | datetime | 19 | √ | null | ||
project | date_entered | datetime | 19 | √ | null | ||
project_task | date_entered | datetime | 19 | √ | null | ||
prospect_lists | date_entered | datetime | 19 | √ | null | ||
prospects | date_entered | datetime | 19 | √ | null | ||
quotas | date_entered | datetime | 19 | √ | null | ||
quotes | date_entered | datetime | 19 | √ | null | ||
releases | date_entered | datetime | 19 | √ | null | ||
report_cache | date_entered | datetime | 19 | √ | null | ||
roles | date_entered | datetime | 19 | √ | null | ||
saved_reports | date_entered | datetime | 19 | √ | null | ||
saved_search | date_entered | datetime | 19 | √ | null | ||
schedulers | date_entered | datetime | 19 | √ | null | ||
schedulers_times | date_entered | datetime | 19 | √ | null | ||
session_active | date_entered | datetime | 19 | √ | null | ||
session_history | date_entered | datetime | 19 | √ | null | ||
shippers | date_entered | datetime | 19 | √ | null | ||
sugarfavorites | date_entered | datetime | 19 | √ | null | ||
sugarfeed | date_entered | datetime | 19 | √ | null | ||
systems | date_entered | datetime | 19 | √ | null | ||
tasks | date_entered | datetime | 19 | √ | null | ||
taxrates | date_entered | datetime | 19 | √ | null | ||
team_notices | date_entered | datetime | 19 | √ | null | ||
teams | date_entered | datetime | 19 | √ | null | ||
timeperiods | date_entered | datetime | 19 | √ | null | ||
upgrade_history | date_entered | datetime | 19 | √ | null | ||
user_preferences | date_entered | datetime | 19 | √ | null | ||
users | date_entered | datetime | 19 | √ | null | ||
users_signatures | date_entered | datetime | 19 | √ | null | ||
vcals | date_entered | datetime | 19 | √ | null | ||
versions | date_entered | datetime | 19 | √ | null | ||
workflow | date_entered | datetime | 19 | √ | null | ||
workflow_actions | date_entered | datetime | 19 | √ | null | ||
workflow_actionshells | date_entered | datetime | 19 | √ | null | ||
workflow_alerts | date_entered | datetime | 19 | √ | null | ||
workflow_alertshells | date_entered | datetime | 19 | √ | null | ||
workflow_schedules | date_entered | datetime | 19 | √ | null | ||
workflow_triggershells | date_entered | datetime | 19 | √ | null | ||
workflow_schedules | date_expired | datetime | 19 | √ | null | ||
project_task | date_finish | date | 10 | √ | null | ||
users_password_link | date_generated | datetime | 19 | √ | null | ||
accounts | date_modified | datetime | 19 | √ | null | ||
accounts_bugs | date_modified | datetime | 19 | √ | null | ||
accounts_cases | date_modified | datetime | 19 | √ | null | ||
accounts_contacts | date_modified | datetime | 19 | √ | null | ||
accounts_opportunities | date_modified | datetime | 19 | √ | null | ||
acl_actions | date_modified | datetime | 19 | √ | null | ||
acl_fields | date_modified | datetime | 19 | √ | null | ||
acl_roles | date_modified | datetime | 19 | √ | null | ||
acl_roles_actions | date_modified | datetime | 19 | √ | null | ||
acl_roles_users | date_modified | datetime | 19 | √ | null | ||
bugs | date_modified | datetime | 19 | √ | null | ||
calls | date_modified | datetime | 19 | √ | null | ||
calls_contacts | date_modified | datetime | 19 | √ | null | ||
calls_leads | date_modified | datetime | 19 | √ | null | ||
calls_users | date_modified | datetime | 19 | √ | null | ||
campaign_log | date_modified | datetime | 19 | √ | null | ||
campaign_trkrs | date_modified | datetime | 19 | √ | null | ||
campaigns | date_modified | datetime | 19 | √ | null | ||
cases | date_modified | datetime | 19 | √ | null | ||
cases_bugs | date_modified | datetime | 19 | √ | null | ||
contacts | date_modified | datetime | 19 | √ | null | ||
contacts_bugs | date_modified | datetime | 19 | √ | null | ||
contacts_cases | date_modified | datetime | 19 | √ | null | ||
contacts_users | date_modified | datetime | 19 | √ | null | ||
contract_types | date_modified | datetime | 19 | √ | null | ||
contracts | date_modified | datetime | 19 | √ | null | ||
contracts_contacts | date_modified | datetime | 19 | √ | null | ||
contracts_opportunities | date_modified | datetime | 19 | √ | null | ||
contracts_products | date_modified | datetime | 19 | √ | null | ||
contracts_quotes | date_modified | datetime | 19 | √ | null | ||
cron_remove_documents | date_modified | datetime | 19 | √ | null | ||
currencies | date_modified | datetime | 19 | √ | null | ||
document_revisions | date_modified | datetime | 19 | √ | null | ||
documents | date_modified | datetime | 19 | √ | null | ||
documents_accounts | date_modified | datetime | 19 | √ | null | ||
documents_bugs | date_modified | datetime | 19 | √ | null | ||
documents_cases | date_modified | datetime | 19 | √ | null | ||
documents_contacts | date_modified | datetime | 19 | √ | null | ||
documents_opportunities | date_modified | datetime | 19 | √ | null | ||
documents_products | date_modified | datetime | 19 | √ | null | ||
documents_quotes | date_modified | datetime | 19 | √ | null | ||
eapm | date_modified | datetime | 19 | √ | null | ||
email_addr_bean_rel | date_modified | datetime | 19 | √ | null | ||
email_addresses | date_modified | datetime | 19 | √ | null | ||
email_marketing | date_modified | datetime | 19 | √ | null | ||
email_marketing_prospect_lists | date_modified | datetime | 19 | √ | null | ||
email_templates | date_modified | datetime | 19 | √ | null | ||
emailman | date_modified | datetime | 19 | √ | null | ||
emails | date_modified | datetime | 19 | √ | null | ||
emails_beans | date_modified | datetime | 19 | √ | null | ||
expressions | date_modified | datetime | 19 | √ | null | ||
fields_meta_data | date_modified | datetime | 19 | √ | null | ||
forecast_manager_worksheets | date_modified | datetime | 19 | √ | null | ||
forecast_schedule | date_modified | datetime | 19 | √ | null | ||
forecast_worksheets | date_modified | datetime | 19 | √ | null | ||
forecasts | date_modified | datetime | 19 | √ | null | ||
fts_queue | date_modified | datetime | 19 | √ | null | ||
holidays | date_modified | datetime | 19 | √ | null | ||
import_maps | date_modified | datetime | 19 | √ | null | ||
inbound_email | date_modified | datetime | 19 | √ | null | ||
inbound_email_autoreply | date_modified | datetime | 19 | √ | null | ||
job_queue | date_modified | datetime | 19 | √ | null | ||
kbcontents | date_modified | datetime | 19 | √ | null | ||
kbdocument_revisions | date_modified | datetime | 19 | √ | null | ||
kbdocuments | date_modified | datetime | 19 | √ | null | ||
kbdocuments_kbtags | date_modified | datetime | 19 | √ | null | ||
kbdocuments_views_ratings | date_modified | datetime | 19 | √ | null | ||
kbtags | date_modified | datetime | 19 | √ | null | ||
leads | date_modified | datetime | 19 | √ | null | ||
linked_documents | date_modified | datetime | 19 | √ | null | ||
manufacturers | date_modified | datetime | 19 | √ | null | ||
meetings | date_modified | datetime | 19 | √ | null | ||
meetings_contacts | date_modified | datetime | 19 | √ | null | ||
meetings_leads | date_modified | datetime | 19 | √ | null | ||
meetings_users | date_modified | datetime | 19 | √ | null | ||
notes | date_modified | datetime | 19 | √ | null | ||
notifications | date_modified | datetime | 19 | √ | null | ||
oauth_consumer | date_modified | datetime | 19 | √ | null | ||
opportunities | date_modified | datetime | 19 | √ | null | ||
opportunities_contacts | date_modified | datetime | 19 | √ | null | ||
pdfmanager | date_modified | datetime | 19 | √ | null | ||
product_bundle_note | date_modified | datetime | 19 | √ | null | ||
product_bundle_notes | date_modified | datetime | 19 | √ | null | ||
product_bundle_product | date_modified | datetime | 19 | √ | null | ||
product_bundle_quote | date_modified | datetime | 19 | √ | null | ||
product_bundles | date_modified | datetime | 19 | √ | null | ||
product_categories | date_modified | datetime | 19 | √ | null | ||
product_product | date_modified | datetime | 19 | √ | null | ||
product_templates | date_modified | datetime | 19 | √ | null | ||
product_types | date_modified | datetime | 19 | √ | null | ||
products | date_modified | datetime | 19 | √ | null | ||
project | date_modified | datetime | 19 | √ | null | ||
project_resources | date_modified | datetime | 19 | √ | null | ||
project_task | date_modified | datetime | 19 | √ | null | ||
projects_accounts | date_modified | datetime | 19 | √ | null | ||
projects_bugs | date_modified | datetime | 19 | √ | null | ||
projects_cases | date_modified | datetime | 19 | √ | null | ||
projects_contacts | date_modified | datetime | 19 | √ | null | ||
projects_opportunities | date_modified | datetime | 19 | √ | null | ||
projects_products | date_modified | datetime | 19 | √ | null | ||
projects_quotes | date_modified | datetime | 19 | √ | null | ||
prospect_list_campaigns | date_modified | datetime | 19 | √ | null | ||
prospect_lists | date_modified | datetime | 19 | √ | null | ||
prospect_lists_prospects | date_modified | datetime | 19 | √ | null | ||
prospects | date_modified | datetime | 19 | √ | null | ||
quotas | date_modified | datetime | 19 | √ | null | ||
quotes | date_modified | datetime | 19 | √ | null | ||
quotes_accounts | date_modified | datetime | 19 | √ | null | ||
quotes_contacts | date_modified | datetime | 19 | √ | null | ||
quotes_opportunities | date_modified | datetime | 19 | √ | null | ||
releases | date_modified | datetime | 19 | √ | null | ||
report_cache | date_modified | datetime | 19 | √ | null | ||
report_schedules | date_modified | datetime | 19 | √ | null | ||
roles | date_modified | datetime | 19 | √ | null | ||
roles_modules | date_modified | datetime | 19 | √ | null | ||
roles_users | date_modified | datetime | 19 | √ | null | ||
saved_reports | date_modified | datetime | 19 | √ | null | ||
saved_search | date_modified | datetime | 19 | √ | null | ||
schedulers | date_modified | datetime | 19 | √ | null | ||
schedulers_times | date_modified | datetime | 19 | √ | null | ||
session_active | date_modified | datetime | 19 | √ | null | ||
session_history | date_modified | datetime | 19 | √ | null | ||
shippers | date_modified | datetime | 19 | √ | null | ||
sugarfavorites | date_modified | datetime | 19 | √ | null | ||
sugarfeed | date_modified | datetime | 19 | √ | null | ||
systems | date_modified | datetime | 19 | √ | null | ||
tasks | date_modified | datetime | 19 | √ | null | ||
taxrates | date_modified | datetime | 19 | √ | null | ||
team_memberships | date_modified | datetime | 19 | √ | null | ||
team_notices | date_modified | datetime | 19 | √ | null | ||
team_sets | date_modified | datetime | 19 | √ | null | ||
team_sets_teams | date_modified | datetime | 19 | √ | null | ||
teams | date_modified | datetime | 19 | √ | null | ||
timeperiods | date_modified | datetime | 19 | √ | null | ||
tracker | date_modified | datetime | 19 | √ | null | ||
tracker_perf | date_modified | datetime | 19 | √ | null | ||
tracker_queries | date_modified | datetime | 19 | √ | null | ||
tracker_tracker_queries | date_modified | datetime | 19 | √ | null | ||
user_preferences | date_modified | datetime | 19 | √ | null | ||
users | date_modified | datetime | 19 | √ | null | ||
users_feeds | date_modified | datetime | 19 | √ | null | ||
users_holidays | date_modified | datetime | 19 | √ | null | ||
users_signatures | date_modified | datetime | 19 | √ | null | ||
vcals | date_modified | datetime | 19 | √ | null | ||
versions | date_modified | datetime | 19 | √ | null | ||
workflow | date_modified | datetime | 19 | √ | null | ||
workflow_actions | date_modified | datetime | 19 | √ | null | ||
workflow_actionshells | date_modified | datetime | 19 | √ | null | ||
workflow_alerts | date_modified | datetime | 19 | √ | null | ||
workflow_alertshells | date_modified | datetime | 19 | √ | null | ||
workflow_schedules | date_modified | datetime | 19 | √ | null | ||
workflow_triggershells | date_modified | datetime | 19 | √ | null | ||
worksheet | date_modified | datetime | 19 | √ | null | ||
quotes | date_order_shipped | date | 10 | √ | null | ||
products | date_purchased | date | 10 | √ | null | ||
quotes | date_quote_closed | date | 10 | √ | null | ||
quotes | date_quote_expected_closed | date | 10 | √ | null | ||
emails | date_sent | datetime | 19 | √ | null | ||
calls | date_start | datetime | 19 | √ | null | ||
email_marketing | date_start | datetime | 19 | √ | null | ||
meetings | date_start | datetime | 19 | √ | null | ||
project_task | date_start | date | 10 | √ | null | ||
report_schedules | date_start | datetime | 19 | √ | null | ||
tasks | date_start | datetime | 19 | √ | null | ||
team_notices | date_start | date | 10 | √ | null | ||
tracker_sessions | date_start | datetime | 19 | √ | null | ||
tasks | date_start_flag | bit | 1 | √ | 0 | ||
products | date_support_expires | date | 10 | √ | null | ||
products | date_support_starts | date | 10 | √ | null | ||
schedulers | date_time_end | datetime | 19 | √ | null | ||
schedulers | date_time_start | datetime | 19 | √ | null | ||
tracker_perf | db_round_trips | int | 6 | √ | null | ||
versions | db_version | varchar | 255 | √ | null | ||
products | deal_calc | decimal | 26,6 | √ | null | ||
products | deal_calc_usdollar | decimal | 26,6 | √ | null | ||
product_bundles | deal_tot | decimal | 26,2 | √ | null | ||
quotes | deal_tot | decimal | 26,2 | √ | null | ||
product_bundles | deal_tot_usdollar | decimal | 26,2 | √ | null | ||
quotes | deal_tot_usdollar | decimal | 26,2 | √ | null | ||
shippers | default_cost | decimal | 26,6 | √ | null | ||
shippers | default_cost_usdollar | decimal | 26,6 | √ | null | ||
users | default_team | char | 36 | √ | null | ||
fields_meta_data | default_value | varchar | 255 | √ | null | ||
import_maps | default_values | text | 65535 | √ | null | ||
inbound_email | delete_seen | bit | 1 | √ | 0 | ||
accounts | deleted | bit | 1 | √ | 0 | ||
accounts_bugs | deleted | bit | 1 | √ | 0 | ||
accounts_cases | deleted | bit | 1 | √ | 0 | ||
accounts_contacts | deleted | bit | 1 | √ | 0 | ||
accounts_opportunities | deleted | bit | 1 | √ | 0 | ||
acl_actions | deleted | bit | 1 | √ | null | ||
acl_fields | deleted | bit | 1 | √ | null | ||
acl_roles | deleted | bit | 1 | √ | null | ||
acl_roles_actions | deleted | bit | 1 | √ | 0 | ||
acl_roles_users | deleted | bit | 1 | √ | 0 | ||
bugs | deleted | bit | 1 | √ | 0 | ||
calls | deleted | bit | 1 | √ | 0 | ||
calls_contacts | deleted | bit | 1 | √ | 0 | ||
calls_leads | deleted | bit | 1 | √ | 0 | ||
calls_users | deleted | bit | 1 | √ | 0 | ||
campaign_log | deleted | bit | 1 | √ | null | ||
campaign_trkrs | deleted | bit | 1 | √ | 0 | ||
campaigns | deleted | bit | 1 | √ | 0 | ||
cases | deleted | bit | 1 | √ | 0 | ||
cases_bugs | deleted | bit | 1 | √ | 0 | ||
contacts | deleted | bit | 1 | √ | 0 | ||
contacts_bugs | deleted | bit | 1 | √ | 0 | ||
contacts_cases | deleted | bit | 1 | √ | 0 | ||
contacts_users | deleted | bit | 1 | √ | 0 | ||
contract_types | deleted | bit | 1 | √ | 0 | ||
contracts | deleted | bit | 1 | √ | 0 | ||
contracts_contacts | deleted | bit | 1 | √ | 0 | ||
contracts_opportunities | deleted | bit | 1 | √ | 0 | ||
contracts_products | deleted | bit | 1 | √ | 0 | ||
contracts_quotes | deleted | bit | 1 | √ | 0 | ||
currencies | deleted | bit | 1 | √ | null | ||
custom_fields | deleted | bit | 1 | √ | 0 | ||
document_revisions | deleted | bit | 1 | √ | 0 | ||
documents | deleted | bit | 1 | √ | 0 | ||
documents_accounts | deleted | bit | 1 | √ | 0 | ||
documents_bugs | deleted | bit | 1 | √ | 0 | ||
documents_cases | deleted | bit | 1 | √ | 0 | ||
documents_contacts | deleted | bit | 1 | √ | 0 | ||
documents_opportunities | deleted | bit | 1 | √ | 0 | ||
documents_products | deleted | bit | 1 | √ | 0 | ||
documents_quotes | deleted | bit | 1 | √ | 0 | ||
eapm | deleted | bit | 1 | √ | 0 | ||
email_addr_bean_rel | deleted | bit | 1 | √ | 0 | ||
email_addresses | deleted | bit | 1 | √ | 0 | ||
email_cache | deleted | tinyint | 4 | √ | null | ||
email_marketing | deleted | bit | 1 | √ | null | ||
email_marketing_prospect_lists | deleted | bit | 1 | √ | 0 | ||
email_templates | deleted | bit | 1 | √ | null | ||
emailman | deleted | bit | 1 | √ | 0 | ||
emails | deleted | bit | 1 | √ | null | ||
emails_beans | deleted | bit | 1 | √ | 0 | ||
emails_email_addr_rel | deleted | bit | 1 | √ | 0 | ||
emails_text | deleted | bit | 1 | √ | 0 | ||
expressions | deleted | bit | 1 | √ | 0 | ||
fields_meta_data | deleted | bit | 1 | √ | 0 | ||
folders | deleted | bit | 1 | √ | 0 | ||
folders_rel | deleted | bit | 1 | √ | 0 | ||
forecast_manager_worksheets | deleted | bit | 1 | √ | 0 | ||
forecast_schedule | deleted | bit | 1 | √ | null | ||
forecast_worksheets | deleted | bit | 1 | √ | 0 | ||
forecasts | deleted | bit | 1 | √ | null | ||
holidays | deleted | bit | 1 | √ | null | ||
import_maps | deleted | bit | 1 | √ | null | ||
inbound_email | deleted | bit | 1 | √ | 0 | ||
inbound_email_autoreply | deleted | bit | 1 | √ | 0 | ||
job_queue | deleted | bit | 1 | √ | 0 | ||
kbcontents | deleted | bit | 1 | √ | 0 | ||
kbdocument_revisions | deleted | bit | 1 | √ | 0 | ||
kbdocuments | deleted | bit | 1 | √ | 0 | ||
kbdocuments_kbtags | deleted | bit | 1 | √ | 0 | ||
kbdocuments_views_ratings | deleted | bit | 1 | √ | 0 | ||
kbtags | deleted | bit | 1 | √ | 0 | ||
leads | deleted | bit | 1 | √ | 0 | ||
linked_documents | deleted | bit | 1 | √ | 0 | ||
manufacturers | deleted | bit | 1 | √ | null | ||
meetings | deleted | bit | 1 | √ | 0 | ||
meetings_contacts | deleted | bit | 1 | √ | 0 | ||
meetings_leads | deleted | bit | 1 | √ | 0 | ||
meetings_users | deleted | bit | 1 | √ | 0 | ||
notes | deleted | bit | 1 | √ | 0 | ||
notifications | deleted | bit | 1 | √ | 0 | ||
oauth_consumer | deleted | bit | 1 | √ | 0 | ||
oauth_tokens | deleted | bit | 1 | 0 | |||
opportunities | deleted | bit | 1 | √ | 0 | ||
opportunities_contacts | deleted | bit | 1 | √ | 0 | ||
pdfmanager | deleted | bit | 1 | √ | 0 | ||
product_bundle_note | deleted | bit | 1 | √ | 0 | ||
product_bundle_notes | deleted | bit | 1 | √ | 0 | ||
product_bundle_product | deleted | bit | 1 | √ | 0 | ||
product_bundle_quote | deleted | bit | 1 | √ | 0 | ||
product_bundles | deleted | bit | 1 | √ | 0 | ||
product_categories | deleted | bit | 1 | √ | 0 | ||
product_product | deleted | bit | 1 | √ | 0 | ||
product_templates | deleted | bit | 1 | √ | 0 | ||
product_types | deleted | bit | 1 | √ | 0 | ||
products | deleted | bit | 1 | √ | 0 | ||
project | deleted | bit | 1 | √ | 0 | ||
project_resources | deleted | bit | 1 | √ | 0 | ||
project_task | deleted | bit | 1 | √ | 0 | ||
projects_accounts | deleted | bit | 1 | √ | 0 | ||
projects_bugs | deleted | bit | 1 | √ | 0 | ||
projects_cases | deleted | bit | 1 | √ | 0 | ||
projects_contacts | deleted | bit | 1 | √ | 0 | ||
projects_opportunities | deleted | bit | 1 | √ | 0 | ||
projects_products | deleted | bit | 1 | √ | 0 | ||
projects_quotes | deleted | bit | 1 | √ | 0 | ||
prospect_list_campaigns | deleted | bit | 1 | √ | 0 | ||
prospect_lists | deleted | bit | 1 | √ | null | ||
prospect_lists_prospects | deleted | bit | 1 | √ | 0 | ||
prospects | deleted | bit | 1 | √ | 0 | ||
quotas | deleted | bit | 1 | √ | null | ||
quotes | deleted | bit | 1 | √ | 0 | ||
quotes_accounts | deleted | bit | 1 | √ | 0 | ||
quotes_contacts | deleted | bit | 1 | √ | 0 | ||
quotes_opportunities | deleted | bit | 1 | √ | 0 | ||
relationships | deleted | bit | 1 | √ | 0 | ||
releases | deleted | bit | 1 | √ | null | ||
report_cache | deleted | varchar | 1 | √ | null | ||
report_schedules | deleted | bit | 1 | √ | 0 | ||
roles | deleted | bit | 1 | √ | null | ||
roles_modules | deleted | bit | 1 | √ | 0 | ||
roles_users | deleted | bit | 1 | √ | 0 | ||
saved_reports | deleted | bit | 1 | √ | null | ||
saved_search | deleted | bit | 1 | √ | null | ||
schedulers | deleted | bit | 1 | √ | 0 | ||
schedulers_times | deleted | bit | 1 | √ | 0 | ||
session_active | deleted | bit | 1 | √ | 0 | ||
session_history | deleted | bit | 1 | √ | 0 | ||
shippers | deleted | bit | 1 | √ | null | ||
sugarfavorites | deleted | bit | 1 | √ | 0 | ||
sugarfeed | deleted | bit | 1 | √ | 0 | ||
systems | deleted | bit | 1 | √ | 0 | ||
tasks | deleted | bit | 1 | √ | 0 | ||
taxrates | deleted | bit | 1 | √ | null | ||
team_memberships | deleted | bit | 1 | √ | 0 | ||
team_notices | deleted | bit | 1 | √ | null | ||
team_sets | deleted | bit | 1 | √ | 0 | ||
team_sets_modules | deleted | bit | 1 | √ | 0 | ||
team_sets_teams | deleted | bit | 1 | √ | 0 | ||
teams | deleted | bit | 1 | √ | null | ||
timeperiods | deleted | bit | 1 | √ | null | ||
tracker | deleted | bit | 1 | √ | 0 | ||
tracker_perf | deleted | bit | 1 | √ | 0 | ||
tracker_queries | deleted | bit | 1 | √ | 0 | ||
tracker_sessions | deleted | bit | 1 | √ | 0 | ||
user_preferences | deleted | bit | 1 | √ | 0 | ||
users | deleted | bit | 1 | √ | null | ||
users_feeds | deleted | bit | 1 | √ | 0 | ||
users_holidays | deleted | bit | 1 | √ | 0 | ||
users_last_import | deleted | bit | 1 | √ | null | ||
users_password_link | deleted | bit | 1 | √ | null | ||
users_signatures | deleted | bit | 1 | √ | null | ||
vcals | deleted | bit | 1 | √ | null | ||
versions | deleted | bit | 1 | √ | null | ||
workflow | deleted | bit | 1 | √ | 0 | ||
workflow_actions | deleted | bit | 1 | √ | 0 | ||
workflow_actionshells | deleted | bit | 1 | √ | 0 | ||
workflow_alerts | deleted | bit | 1 | √ | 0 | ||
workflow_alertshells | deleted | bit | 1 | √ | 0 | ||
workflow_schedules | deleted | bit | 1 | √ | 0 | ||
workflow_triggershells | deleted | bit | 1 | √ | 0 | ||
worksheet | deleted | bit | 1 | √ | 0 | ||
import_maps | delimiter | varchar | 1 | √ | , | ||
contacts | department | varchar | 255 | √ | null | ||
leads | department | varchar | 100 | √ | null | ||
prospects | department | varchar | 255 | √ | null | ||
users | department | varchar | 50 | √ | null | ||
accounts | description | text | 65535 | √ | null | ||
acl_roles | description | text | 65535 | √ | null | ||
bugs | description | text | 65535 | √ | null | ||
calls | description | text | 65535 | √ | null | ||
cases | description | text | 65535 | √ | null | ||
contacts | description | text | 65535 | √ | null | ||
contracts | description | text | 65535 | √ | null | ||
documents | description | text | 65535 | √ | null | ||
eapm | description | text | 65535 | √ | null | ||
email_templates | description | text | 65535 | √ | null | ||
emails_text | description | longtext | 2147483647 | √ | null | ||
forecast_manager_worksheets | description | text | 65535 | √ | null | ||
forecast_worksheets | description | text | 65535 | √ | null | ||
holidays | description | text | 65535 | √ | null | ||
kbdocuments | description | text | 65535 | √ | null | ||
leads | description | text | 65535 | √ | null | ||
meetings | description | text | 65535 | √ | null | ||
notes | description | text | 65535 | √ | null | ||
notifications | description | text | 65535 | √ | null | ||
oauth_consumer | description | text | 65535 | √ | null | ||
opportunities | description | text | 65535 | √ | null | ||
pdfmanager | description | text | 65535 | √ | null | ||
product_bundle_notes | description | text | 65535 | √ | null | ||
product_bundles | description | text | 65535 | √ | null | ||
product_categories | description | text | 65535 | √ | null | ||
product_templates | description | text | 65535 | √ | null | ||
product_types | description | text | 65535 | √ | null | ||
products | description | text | 65535 | √ | null | ||
project | description | text | 65535 | √ | null | ||
project_task | description | text | 65535 | √ | null | ||
prospect_lists | description | text | 65535 | √ | null | ||
prospects | description | text | 65535 | √ | null | ||
quotes | description | text | 65535 | √ | null | ||
roles | description | text | 65535 | √ | null | ||
saved_search | description | text | 65535 | √ | null | ||
schedulers | description | text | 65535 | √ | null | ||
sugarfavorites | description | varchar | 50 | √ | null | ||
sugarfeed | description | varchar | 255 | √ | null | ||
tasks | description | text | 65535 | √ | null | ||
team_notices | description | text | 65535 | √ | null | ||
teams | description | text | 65535 | √ | null | ||
upgrade_history | description | text | 65535 | √ | null | ||
users | description | text | 65535 | √ | null | ||
workflow | description | text | 65535 | √ | null | ||
emails_text | description_html | longtext | 2147483647 | √ | null | ||
calls | direction | varchar | 100 | √ | null | ||
quotes | discount | decimal | 26,6 | √ | null | ||
products | discount_amount | decimal | 26,6 | √ | null | ||
products | discount_amount_usdollar | decimal | 26,6 | √ | null | ||
product_templates | discount_price | decimal | 26,6 | √ | null | ||
products | discount_price | decimal | 26,6 | √ | null | ||
products | discount_select | bit | 1 | √ | null | ||
product_templates | discount_usdollar | decimal | 26,6 | √ | null | ||
products | discount_usdollar | decimal | 26,6 | √ | null | ||
meetings | displayed_url | varchar | 400 | √ | null | ||
contacts | do_not_call | bit | 1 | √ | 0 | ||
leads | do_not_call | bit | 1 | √ | 0 | ||
prospects | do_not_call | bit | 1 | √ | 0 | ||
document_revisions | doc_id | varchar | 100 | √ | null | ||
documents | doc_id | varchar | 100 | √ | null | ||
document_revisions | doc_type | varchar | 100 | √ | null | ||
documents | doc_type | varchar | 100 | √ | Sugar | ||
document_revisions | doc_url | varchar | 255 | √ | null | ||
documents | doc_url | varchar | 255 | √ | null | ||
document_revisions | document_id | char | 36 | √ | null | ||
documents_accounts | document_id | char | 36 | √ | null | ||
documents_bugs | document_id | char | 36 | √ | null | ||
documents_cases | document_id | char | 36 | √ | null | ||
documents_contacts | document_id | char | 36 | √ | null | ||
documents_opportunities | document_id | char | 36 | √ | null | ||
documents_products | document_id | char | 36 | √ | null | ||
documents_quotes | document_id | varchar | 36 | √ | null | ||
linked_documents | document_id | varchar | 36 | √ | null | ||
documents | document_name | varchar | 255 | √ | null | ||
documents | document_revision_id | char | 36 | √ | null | ||
kbcontents | document_revision_id | char | 36 | √ | null | ||
kbdocument_revisions | document_revision_id | varchar | 36 | √ | null | ||
linked_documents | document_revision_id | varchar | 36 | √ | null | ||
prospect_lists | domain_name | varchar | 255 | √ | null | ||
email_cache | draft | tinyint | 4 | √ | null | ||
forecast_manager_worksheets | draft | int | 11 | √ | 0 | ||
forecast_worksheets | draft | int | 11 | √ | 0 | ||
fields_meta_data | duplicate_merge | smallint | 6 | √ | 0 | ||
project_task | duration | int | 11 | √ | null | ||
calls | duration_hours | int | 2 | √ | null | ||
meetings | duration_hours | int | 3 | √ | null | ||
calls | duration_minutes | int | 2 | √ | null | ||
meetings | duration_minutes | varchar | 2 | √ | null | ||
project_task | duration_unit | text | 65535 | √ | null | ||
folders | dynamic_query | text | 65535 | √ | null | ||
email_addresses | email_address | varchar | 255 | √ | null | ||
email_addresses | email_address_caps | varchar | 255 | √ | null | ||
email_addr_bean_rel | email_address_id | char | 36 | ||||
emails_email_addr_rel | email_address_id | char | 36 | ||||
emails_beans | email_id | char | 36 | √ | null | ||
emails_email_addr_rel | email_id | char | 36 | ||||
emails_text | email_id | char | 36 | ||||
email_marketing_prospect_lists | email_marketing_id | varchar | 36 | √ | null | ||
inbound_email | email_password | varchar | 100 | √ | null | ||
calls | email_reminder_sent | bit | 1 | √ | 0 | ||
meetings | email_reminder_sent | bit | 1 | √ | 0 | ||
calls | email_reminder_time | int | 11 | √ | -1 | ||
meetings | email_reminder_time | int | 11 | √ | -1 | ||
inbound_email | email_user | varchar | 100 | √ | null | ||
notes | embed_flag | bit | 1 | √ | 0 | ||
users | employee_status | varchar | 100 | √ | null | ||
accounts | employees | varchar | 10 | √ | null | ||
upgrade_history | enabled | bit | 1 | √ | 1 | ||
import_maps | enclosure | varchar | 1 | √ | |||
campaigns | end_date | date | 10 | √ | null | ||
contracts | end_date | date | 10 | √ | null | ||
timeperiods | end_date | date | 10 | √ | null | ||
timeperiods | end_date_timestamp | int | 14 | √ | null | ||
project_task | estimated_effort | int | 11 | √ | null | ||
project | estimated_end_date | date | 10 | √ | null | ||
project | estimated_start_date | date | 10 | √ | null | ||
workflow_triggershells | eval | text | 65535 | √ | null | ||
job_queue | execute_time | datetime | 19 | √ | null | ||
schedulers_times | execute_time | datetime | 19 | √ | null | ||
documents | exp_date | date | 10 | √ | null | ||
kbdocuments | exp_date | date | 10 | √ | null | ||
expressions | exp_order | int | 4 | √ | null | ||
expressions | exp_type | varchar | 100 | √ | null | ||
campaigns | expected_cost | double | 22 | √ | null | ||
campaigns | expected_revenue | double | 22 | √ | null | ||
contracts | expiration_notice | datetime | 19 | √ | null | ||
oauth_tokens | expire_ts | bigint | 20 | √ | -1 | ||
team_memberships | explicit_assign | bit | 1 | √ | 0 | ||
expressions | ext1 | varchar | 50 | √ | null | ||
fields_meta_data | ext1 | varchar | 255 | √ | null | ||
workflow_actions | ext1 | varchar | 50 | √ | null | ||
expressions | ext2 | varchar | 50 | √ | null | ||
fields_meta_data | ext2 | varchar | 255 | √ | null | ||
workflow_actions | ext2 | varchar | 50 | √ | null | ||
expressions | ext3 | varchar | 50 | √ | null | ||
fields_meta_data | ext3 | varchar | 255 | √ | null | ||
workflow_actions | ext3 | varchar | 50 | √ | null | ||
fields_meta_data | ext4 | text | 65535 | √ | null | ||
users | external_auth_only | bit | 1 | √ | 0 | ||
meetings | external_id | varchar | 50 | √ | null | ||
job_queue | failure_count | tinyint | 4 | √ | null | ||
saved_reports | favorite | bit | 1 | √ | null | ||
users_feeds | feed_id | varchar | 36 | √ | null | ||
pdfmanager | field | varchar | 100 | √ | 0 | ||
workflow_actions | field | varchar | 50 | √ | null | ||
workflow_triggershells | field | varchar | 50 | √ | null | ||
custom_fields | field0 | varchar | 255 | √ | null | ||
custom_fields | field1 | varchar | 255 | √ | null | ||
custom_fields | field2 | varchar | 255 | √ | null | ||
custom_fields | field3 | varchar | 255 | √ | null | ||
custom_fields | field4 | varchar | 255 | √ | null | ||
custom_fields | field5 | varchar | 255 | √ | null | ||
custom_fields | field6 | varchar | 255 | √ | null | ||
custom_fields | field7 | varchar | 255 | √ | null | ||
custom_fields | field8 | varchar | 255 | √ | null | ||
custom_fields | field9 | varchar | 255 | √ | null | ||
accounts_audit | field_name | varchar | 100 | √ | null | ||
bugs_audit | field_name | varchar | 100 | √ | null | ||
campaigns_audit | field_name | varchar | 100 | √ | null | ||
cases_audit | field_name | varchar | 100 | √ | null | ||
contacts_audit | field_name | varchar | 100 | √ | null | ||
contracts_audit | field_name | varchar | 100 | √ | null | ||
kbcontents_audit | field_name | varchar | 100 | √ | null | ||
leads_audit | field_name | varchar | 100 | √ | null | ||
notifications_audit | field_name | varchar | 100 | √ | null | ||
opportunities_audit | field_name | varchar | 100 | √ | null | ||
products_audit | field_name | varchar | 100 | √ | null | ||
project_task_audit | field_name | varchar | 100 | √ | null | ||
quotes_audit | field_name | varchar | 100 | √ | null | ||
workflow_alerts | field_value | varchar | 50 | √ | null | ||
document_revisions | file_ext | varchar | 100 | √ | null | ||
kbdocument_revisions | file_ext | varchar | 100 | √ | null | ||
document_revisions | file_mime_type | varchar | 100 | √ | null | ||
kbdocument_revisions | file_mime_type | varchar | 100 | √ | null | ||
notes | file_mime_type | varchar | 100 | √ | null | ||
versions | file_version | varchar | 255 | √ | null | ||
document_revisions | filename | varchar | 255 | √ | null | ||
kbdocument_revisions | filename | varchar | 255 | √ | null | ||
notes | filename | varchar | 255 | √ | null | ||
upgrade_history | filename | varchar | 255 | √ | null | ||
tracker_perf | files_opened | int | 6 | √ | null | ||
workflow | fire_order | varchar | 100 | √ | null | ||
contacts | first_name | varchar | 100 | √ | null | ||
leads | first_name | varchar | 100 | √ | null | ||
prospects | first_name | varchar | 100 | √ | null | ||
users | first_name | varchar | 30 | √ | null | ||
bugs | fixed_in_release | varchar | 255 | √ | null | ||
email_cache | flagged | tinyint | 4 | √ | null | ||
emails | flagged | bit | 1 | √ | null | ||
folders_rel | folder_id | char | 36 | ||||
folders_subscriptions | folder_id | char | 36 | ||||
folders | folder_type | varchar | 25 | √ | null | ||
pdfmanager | footer_text | varchar | 255 | √ | null | ||
forecast_schedule | forecast_start_date | date | 10 | √ | null | ||
forecasts | forecast_type | varchar | 100 | √ | null | ||
worksheet | forecast_type | varchar | 100 | √ | null | ||
bugs | found_in_release | varchar | 255 | √ | null | ||
workflow_triggershells | frame_type | varchar | 15 | √ | null | ||
campaigns | frequency | varchar | 100 | √ | null | ||
email_marketing | from_addr | varchar | 100 | √ | null | ||
emails_text | from_addr | varchar | 255 | √ | null | ||
email_templates | from_address | varchar | 255 | √ | null | ||
email_marketing | from_name | varchar | 100 | √ | null | ||
email_templates | from_name | varchar | 255 | √ | null | ||
email_cache | fromaddr | varchar | 100 | √ | null | ||
inbound_email | group_id | char | 36 | √ | null | ||
inbound_email | groupfolder_id | char | 36 | √ | null | ||
folders | has_child | bit | 1 | √ | 0 | ||
import_maps | has_header | bit | 1 | √ | 1 | ||
pdfmanager | header_logo | varchar | 255 | √ | null | ||
pdfmanager | header_text | varchar | 255 | √ | null | ||
pdfmanager | header_title | varchar | 255 | √ | null | ||
fields_meta_data | help | varchar | 255 | √ | null | ||
forecast_tree | hierarchy_type | varchar | 25 | √ | null | ||
campaign_log | hits | int | 11 | √ | 0 | ||
holidays | holiday_date | date | 10 | √ | null | ||
users_holidays | holiday_id | varchar | 36 | √ | null | ||
meetings | host_url | varchar | 400 | √ | null | ||
accounts | id | char | 36 | ||||
accounts_audit | id | char | 36 | ||||
accounts_bugs | id | varchar | 36 | ||||
accounts_cases | id | varchar | 36 | ||||
accounts_contacts | id | varchar | 36 | ||||
accounts_opportunities | id | varchar | 36 | ||||
acl_actions | id | char | 36 | ||||
acl_fields | id | char | 36 | ||||
acl_roles | id | char | 36 | ||||
acl_roles_actions | id | varchar | 36 | ||||
acl_roles_users | id | varchar | 36 | ||||
address_book_lists | id | char | 36 | ||||
bugs | id | char | 36 | ||||
bugs_audit | id | char | 36 | ||||
calls | id | char | 36 | ||||
calls_contacts | id | char | 36 | ||||
calls_leads | id | char | 36 | ||||
calls_users | id | char | 36 | ||||
campaign_log | id | char | 36 | ||||
campaign_trkrs | id | char | 36 | ||||
campaigns | id | char | 36 | ||||
campaigns_audit | id | char | 36 | ||||
cases | id | char | 36 | ||||
cases_audit | id | char | 36 | ||||
cases_bugs | id | varchar | 36 | ||||
contacts | id | char | 36 | ||||
contacts_audit | id | char | 36 | ||||
contacts_bugs | id | varchar | 36 | ||||
contacts_cases | id | varchar | 36 | ||||
contacts_users | id | varchar | 36 | ||||
contract_types | id | char | 36 | ||||
contracts | id | char | 36 | ||||
contracts_audit | id | char | 36 | ||||
contracts_contacts | id | varchar | 36 | ||||
contracts_opportunities | id | varchar | 36 | ||||
contracts_products | id | varchar | 36 | ||||
contracts_quotes | id | varchar | 36 | ||||
cron_remove_documents | id | varchar | 36 | ||||
currencies | id | char | 36 | ||||
document_revisions | id | char | 36 | ||||
documents | id | char | 36 | ||||
documents_accounts | id | char | 36 | ||||
documents_bugs | id | char | 36 | ||||
documents_cases | id | char | 36 | ||||
documents_contacts | id | char | 36 | ||||
documents_opportunities | id | char | 36 | ||||
documents_products | id | char | 36 | ||||
documents_quotes | id | varchar | 36 | ||||
eapm | id | char | 36 | ||||
email_addr_bean_rel | id | char | 36 | ||||
email_addresses | id | char | 36 | ||||
email_marketing | id | char | 36 | ||||
email_marketing_prospect_lists | id | varchar | 36 | ||||
email_templates | id | char | 36 | ||||
emailman | id | int | 11 | √ | |||
emails | id | char | 36 | ||||
emails_beans | id | char | 36 | ||||
emails_email_addr_rel | id | char | 36 | ||||
expressions | id | char | 36 | ||||
fields_meta_data | id | varchar | 255 | ||||
folders | id | char | 36 | ||||
folders_rel | id | char | 36 | ||||
folders_subscriptions | id | char | 36 | ||||
forecast_manager_worksheets | id | char | 36 | ||||
forecast_schedule | id | char | 36 | ||||
forecast_tree | id | char | 36 | ||||
forecast_worksheets | id | char | 36 | ||||
forecasts | id | char | 36 | ||||
holidays | id | char | 36 | ||||
import_maps | id | char | 36 | ||||
inbound_email | id | varchar | 36 | ||||
inbound_email_autoreply | id | char | 36 | ||||
inbound_email_cache_ts | id | varchar | 255 | ||||
job_queue | id | char | 36 | ||||
kbcontents | id | char | 36 | ||||
kbcontents_audit | id | char | 36 | ||||
kbdocument_revisions | id | varchar | 36 | ||||
kbdocuments | id | varchar | 36 | ||||
kbdocuments_kbtags | id | varchar | 36 | ||||
kbdocuments_views_ratings | id | varchar | 36 | ||||
kbtags | id | varchar | 36 | ||||
leads | id | char | 36 | ||||
leads_audit | id | char | 36 | ||||
linked_documents | id | varchar | 36 | ||||
manufacturers | id | char | 36 | ||||
meetings | id | char | 36 | ||||
meetings_contacts | id | char | 36 | ||||
meetings_leads | id | char | 36 | ||||
meetings_users | id | char | 36 | ||||
notes | id | char | 36 | ||||
notifications | id | char | 36 | ||||
notifications_audit | id | char | 36 | ||||
oauth_consumer | id | char | 36 | ||||
oauth_tokens | id | char | 36 | ||||
opportunities | id | char | 36 | ||||
opportunities_audit | id | char | 36 | ||||
opportunities_contacts | id | varchar | 36 | ||||
outbound_email | id | char | 36 | ||||
pdfmanager | id | char | 36 | ||||
product_bundle_note | id | varchar | 36 | ||||
product_bundle_notes | id | char | 36 | ||||
product_bundle_product | id | varchar | 36 | ||||
product_bundle_quote | id | varchar | 36 | ||||
product_bundles | id | char | 36 | ||||
product_categories | id | char | 36 | ||||
product_product | id | varchar | 36 | ||||
product_templates | id | char | 36 | ||||
product_types | id | char | 36 | ||||
products | id | char | 36 | ||||
products_audit | id | char | 36 | ||||
project | id | char | 36 | ||||
project_resources | id | char | 36 | ||||
project_task | id | char | 36 | ||||
project_task_audit | id | char | 36 | ||||
projects_accounts | id | varchar | 36 | ||||
projects_bugs | id | varchar | 36 | ||||
projects_cases | id | varchar | 36 | ||||
projects_contacts | id | varchar | 36 | ||||
projects_opportunities | id | varchar | 36 | ||||
projects_products | id | varchar | 36 | ||||
projects_quotes | id | varchar | 36 | ||||
prospect_list_campaigns | id | varchar | 36 | ||||
prospect_lists | id | char | 36 | ||||
prospect_lists_prospects | id | varchar | 36 | ||||
prospects | id | char | 36 | ||||
quotas | id | char | 36 | ||||
quotes | id | char | 36 | ||||
quotes_accounts | id | varchar | 36 | ||||
quotes_audit | id | char | 36 | ||||
quotes_contacts | id | varchar | 36 | ||||
quotes_opportunities | id | varchar | 36 | ||||
relationships | id | char | 36 | ||||
releases | id | char | 36 | ||||
report_cache | id | char | 36 | ||||
report_schedules | id | char | 36 | ||||
roles | id | char | 36 | ||||
roles_modules | id | varchar | 36 | ||||
roles_users | id | varchar | 36 | ||||
saved_reports | id | char | 36 | ||||
saved_search | id | char | 36 | ||||
schedulers | id | char | 36 | ||||
schedulers_times | id | char | 36 | ||||
session_active | id | char | 36 | ||||
session_history | id | char | 36 | ||||
shippers | id | char | 36 | ||||
sugarfavorites | id | char | 36 | ||||
sugarfeed | id | char | 36 | ||||
systems | id | char | 36 | ||||
tasks | id | char | 36 | ||||
taxrates | id | char | 36 | ||||
team_memberships | id | char | 36 | ||||
team_notices | id | char | 36 | ||||
team_sets | id | char | 36 | ||||
team_sets_modules | id | char | 36 | ||||
team_sets_teams | id | char | 36 | ||||
teams | id | char | 36 | ||||
timeperiods | id | varchar | 36 | ||||
tracker | id | int | 11 | √ | |||
tracker_perf | id | int | 11 | √ | |||
tracker_queries | id | int | 11 | √ | |||
tracker_sessions | id | int | 11 | √ | |||
tracker_tracker_queries | id | int | 11 | √ | |||
upgrade_history | id | char | 36 | ||||
user_preferences | id | char | 36 | ||||
users | id | char | 36 | ||||
users_holidays | id | varchar | 36 | ||||
users_last_import | id | char | 36 | ||||
users_password_link | id | char | 36 | ||||
users_signatures | id | char | 36 | ||||
vcals | id | char | 36 | ||||
versions | id | char | 36 | ||||
workflow | id | char | 36 | ||||
workflow_actions | id | char | 36 | ||||
workflow_actionshells | id | char | 36 | ||||
workflow_alerts | id | char | 36 | ||||
workflow_alertshells | id | char | 36 | ||||
workflow_schedules | id | char | 36 | ||||
workflow_triggershells | id | char | 36 | ||||
worksheet | id | char | 36 | ||||
upgrade_history | id_name | varchar | 255 | √ | null | ||
email_cache | ie_id | char | 36 | √ | null | ||
inbound_email_autoreply | ie_id | char | 36 | ||||
inbound_email_cache_ts | ie_timestamp | int unsigned | 10 | √ | null | ||
email_cache | imap_uid | int unsigned | 10 | √ | null | ||
team_memberships | implicit_assign | bit | 1 | √ | 0 | ||
users_last_import | import_module | varchar | 36 | √ | null | ||
fields_meta_data | importable | varchar | 255 | √ | null | ||
campaigns | impressions | int | 11 | √ | 0 | ||
emailman | in_queue | bit | 1 | √ | 0 | ||
emailman | in_queue_date | datetime | 19 | √ | null | ||
email_marketing | inbound_email_id | varchar | 36 | √ | null | ||
accounts | industry | varchar | 50 | √ | null | ||
systems | install_method | varchar | 100 | √ | null | ||
emails | intent | varchar | 100 | √ | pick | ||
email_addresses | invalid_email | bit | 1 | √ | 0 | ||
users | is_admin | bit | 1 | √ | 0 | ||
folders | is_dynamic | bit | 1 | √ | 0 | ||
kbdocuments | is_external_article | bit | 1 | √ | 0 | ||
timeperiods | is_fiscal | bit | 1 | √ | 0 | ||
timeperiods | is_fiscal_year | bit | 1 | √ | 0 | ||
folders | is_group | bit | 1 | √ | 0 | ||
users | is_group | bit | 1 | √ | null | ||
campaign_trkrs | is_optout | bit | 1 | √ | 0 | ||
inbound_email | is_personal | bit | 1 | √ | 0 | ||
import_maps | is_published | varchar | 3 | √ | no | ||
saved_reports | is_published | bit | 1 | √ | 0 | ||
notifications | is_read | bit | 1 | √ | null | ||
documents | is_template | bit | 1 | √ | 0 | ||
kbdocuments | is_template | bit | 1 | √ | 0 | ||
project | is_template | bit | 1 | √ | 0 | ||
session_active | is_violation | bit | 1 | √ | 0 | ||
session_history | is_violation | bit | 1 | √ | 0 | ||
currencies | iso4217 | varchar | 3 | √ | null | ||
tracker | item_id | char | 36 | √ | null | ||
tracker | item_summary | varchar | 255 | √ | null | ||
schedulers | job | varchar | 255 | √ | null | ||
job_queue | job_delay | int | 11 | √ | null | ||
job_queue | job_group | varchar | 255 | √ | null | ||
schedulers | job_interval | varchar | 100 | √ | null | ||
relationships | join_key_lhs | varchar | 128 | √ | null | ||
relationships | join_key_rhs | varchar | 128 | √ | null | ||
relationships | join_table | varchar | 128 | √ | null | ||
meetings | join_url | varchar | 200 | √ | null | ||
kbcontents | kb_index | int | 11 | √ | |||
kbdocument_revisions | kbcontent_id | varchar | 36 | √ | null | ||
kbdocuments | kbdoc_approver_id | char | 36 | √ | null | ||
kbcontents | kbdocument_body | longtext | 2147483647 | √ | null | ||
kbdocument_revisions | kbdocument_id | varchar | 36 | √ | null | ||
kbdocuments_kbtags | kbdocument_id | varchar | 36 | √ | null | ||
kbdocuments_views_ratings | kbdocument_id | varchar | 36 | √ | null | ||
kbdocuments | kbdocument_name | varchar | 255 | √ | null | ||
kbdocuments | kbdocument_revision_id | varchar | 36 | √ | null | ||
kbdocuments | kbdocument_revision_number | varchar | 100 | √ | null | ||
kbdocuments_kbtags | kbtag_id | varchar | 36 | √ | null | ||
pdfmanager | keywords | varchar | 255 | √ | null | ||
systems | last_connect_date | datetime | 19 | √ | null | ||
contacts | last_name | varchar | 100 | √ | null | ||
leads | last_name | varchar | 100 | √ | null | ||
prospects | last_name | varchar | 100 | √ | null | ||
users | last_name | varchar | 30 | √ | null | ||
session_active | last_request_time | datetime | 19 | √ | null | ||
session_history | last_request_time | datetime | 19 | √ | null | ||
schedulers | last_run | datetime | 19 | √ | null | ||
kbdocument_revisions | latest | bit | 1 | √ | 0 | ||
calls_leads | lead_id | char | 36 | √ | null | ||
meetings_leads | lead_id | char | 36 | √ | null | ||
prospects | lead_id | char | 36 | √ | null | ||
contacts | lead_source | varchar | 255 | √ | null | ||
leads | lead_source | varchar | 100 | √ | null | ||
opportunities | lead_source | varchar | 50 | √ | null | ||
leads | lead_source_description | text | 65535 | √ | null | ||
timeperiods | leaf_cycle | int | 2 | √ | null | ||
fields_meta_data | len | int | 11 | √ | null | ||
expressions | lhs_field | varchar | 50 | √ | null | ||
expressions | lhs_group_type | varchar | 10 | √ | null | ||
relationships | lhs_key | varchar | 64 | √ | null | ||
expressions | lhs_module | varchar | 50 | √ | null | ||
relationships | lhs_module | varchar | 100 | √ | null | ||
relationships | lhs_table | varchar | 64 | √ | null | ||
expressions | lhs_type | varchar | 15 | √ | null | ||
expressions | lhs_value | varchar | 100 | √ | null | ||
forecast_manager_worksheets | likely_case | decimal | 26,6 | √ | null | ||
forecast_worksheets | likely_case | decimal | 26,6 | √ | null | ||
forecasts | likely_case | decimal | 26,6 | √ | null | ||
products | likely_case | decimal | 26,6 | √ | null | ||
worksheet | likely_case | decimal | 26,6 | √ | null | ||
forecast_manager_worksheets | likely_case_adjusted | decimal | 26,6 | √ | null | ||
sugarfeed | link_type | varchar | 30 | √ | null | ||
sugarfeed | link_url | varchar | 255 | √ | null | ||
address_book_list_items | list_id | char | 36 | ||||
campaign_log | list_id | char | 36 | √ | null | ||
emailman | list_id | char | 36 | √ | null | ||
address_book_lists | list_name | varchar | 100 | √ | null | ||
contract_types | list_order | int | 4 | √ | null | ||
manufacturers | list_order | int | 4 | √ | null | ||
product_categories | list_order | int | 4 | √ | null | ||
product_types | list_order | int | 4 | √ | null | ||
releases | list_order | int | 4 | √ | null | ||
shippers | list_order | int | 4 | √ | null | ||
taxrates | list_order | int | 4 | √ | null | ||
workflow | list_order_y | int | 3 | √ | 0 | ||
product_templates | list_price | decimal | 26,6 | √ | null | ||
products | list_price | decimal | 26,6 | √ | null | ||
prospect_lists | list_type | varchar | 100 | √ | null | ||
product_templates | list_usdollar | decimal | 26,6 | √ | null | ||
products | list_usdollar | decimal | 26,6 | √ | null | ||
meetings | location | varchar | 50 | √ | null | ||
kbdocuments | mail_merge_document | varchar | 3 | √ | off | ||
outbound_email | mail_sendtype | varchar | 8 | √ | smtp | ||
outbound_email | mail_smtpauth_req | bit | 1 | √ | 0 | ||
outbound_email | mail_smtppass | varchar | 100 | √ | null | ||
outbound_email | mail_smtpport | int | 5 | √ | 0 | ||
outbound_email | mail_smtpserver | varchar | 100 | √ | null | ||
outbound_email | mail_smtpssl | int | 1 | √ | 0 | ||
outbound_email | mail_smtptype | varchar | 20 | √ | other | ||
outbound_email | mail_smtpuser | varchar | 100 | √ | null | ||
inbound_email | mailbox | text | 65535 | √ | null | ||
emails | mailbox_id | char | 36 | √ | null | ||
inbound_email | mailbox_type | varchar | 10 | √ | null | ||
email_cache | mailsize | int unsigned | 10 | √ | null | ||
upgrade_history | manifest | longtext | 2147483647 | √ | null | ||
product_templates | manufacturer_id | char | 36 | √ | null | ||
products | manufacturer_id | char | 36 | √ | null | ||
campaign_log | marketing_id | char | 36 | √ | null | ||
emailman | marketing_id | char | 36 | √ | null | ||
fields_meta_data | massupdate | bit | 1 | √ | 0 | ||
email_cache | mbox | varchar | 60 | √ | null | ||
upgrade_history | md5sum | varchar | 32 | √ | null | ||
meetings_contacts | meeting_id | char | 36 | √ | null | ||
meetings_leads | meeting_id | char | 36 | √ | null | ||
meetings_users | meeting_id | char | 36 | √ | null | ||
tracker_perf | memory_usage | int | 12 | √ | null | ||
job_queue | message | text | 65535 | √ | null | ||
email_cache | message_id | varchar | 255 | √ | null | ||
emails | message_id | varchar | 255 | √ | null | ||
emails | message_uid | varchar | 64 | √ | null | ||
users | messenger_id | varchar | 100 | √ | null | ||
users | messenger_type | varchar | 100 | √ | null | ||
product_templates | mft_part_num | varchar | 50 | √ | null | ||
products | mft_part_num | varchar | 50 | √ | null | ||
project_task | milestone_flag | bit | 1 | √ | null | ||
folders | modified_by | char | 36 | ||||
accounts | modified_user_id | char | 36 | √ | null | ||
acl_actions | modified_user_id | char | 36 | √ | null | ||
acl_fields | modified_user_id | char | 36 | √ | null | ||
acl_roles | modified_user_id | char | 36 | √ | null | ||
bugs | modified_user_id | char | 36 | √ | null | ||
calls | modified_user_id | char | 36 | √ | null | ||
campaign_trkrs | modified_user_id | char | 36 | √ | null | ||
campaigns | modified_user_id | char | 36 | √ | null | ||
cases | modified_user_id | char | 36 | √ | null | ||
contacts | modified_user_id | char | 36 | √ | null | ||
contract_types | modified_user_id | char | 36 | √ | null | ||
contracts | modified_user_id | char | 36 | √ | null | ||
documents | modified_user_id | char | 36 | √ | null | ||
eapm | modified_user_id | char | 36 | √ | null | ||
email_marketing | modified_user_id | char | 36 | √ | null | ||
email_templates | modified_user_id | char | 36 | √ | null | ||
emailman | modified_user_id | char | 36 | √ | null | ||
emails | modified_user_id | char | 36 | √ | null | ||
expressions | modified_user_id | char | 36 | √ | null | ||
forecast_manager_worksheets | modified_user_id | char | 36 | √ | null | ||
forecast_worksheets | modified_user_id | char | 36 | √ | null | ||
forecastmanagerworksheets | modified_user_id | unknown | 0 | ||||
forecastworksheets | modified_user_id | unknown | 0 | ||||
holidays | modified_user_id | char | 36 | √ | null | ||
inbound_email | modified_user_id | char | 36 | √ | null | ||
kbcontents | modified_user_id | char | 36 | √ | null | ||
kbdocuments | modified_user_id | char | 36 | √ | null | ||
leads | modified_user_id | char | 36 | √ | null | ||
manufacturers | modified_user_id | char | 36 | √ | null | ||
meetings | modified_user_id | char | 36 | √ | null | ||
notes | modified_user_id | char | 36 | √ | null | ||
notifications | modified_user_id | char | 36 | √ | null | ||
oauth_consumer | modified_user_id | char | 36 | √ | null | ||
oauthkeys | modified_user_id | unknown | 0 | ||||
opportunities | modified_user_id | char | 36 | √ | null | ||
pdfmanager | modified_user_id | char | 36 | √ | null | ||
product_bundle_notes | modified_user_id | char | 36 | √ | null | ||
product_bundles | modified_user_id | char | 36 | √ | null | ||
product_categories | modified_user_id | char | 36 | √ | null | ||
product_templates | modified_user_id | char | 36 | √ | null | ||
product_types | modified_user_id | char | 36 | √ | null | ||
products | modified_user_id | char | 36 | √ | null | ||
project | modified_user_id | char | 36 | √ | null | ||
project_resources | modified_user_id | char | 36 | √ | null | ||
project_task | modified_user_id | char | 36 | √ | null | ||
prospect_lists | modified_user_id | char | 36 | √ | null | ||
prospects | modified_user_id | char | 36 | √ | null | ||
quotas | modified_user_id | char | 36 | √ | null | ||
quotes | modified_user_id | char | 36 | √ | null | ||
releases | modified_user_id | char | 36 | √ | null | ||
roles | modified_user_id | char | 36 | √ | null | ||
saved_reports | modified_user_id | char | 36 | √ | null | ||
schedulers | modified_user_id | char | 36 | √ | null | ||
shippers | modified_user_id | char | 36 | ||||
sugarfavorites | modified_user_id | char | 36 | √ | null | ||
sugarfeed | modified_user_id | char | 36 | √ | null | ||
tasks | modified_user_id | char | 36 | √ | null | ||
taxrates | modified_user_id | char | 36 | √ | null | ||
team_notices | modified_user_id | char | 36 | √ | null | ||
teams | modified_user_id | char | 36 | √ | null | ||
users | modified_user_id | char | 36 | √ | null | ||
versions | modified_user_id | char | 36 | √ | null | ||
workflow | modified_user_id | char | 36 | √ | null | ||
workflow_actions | modified_user_id | char | 36 | √ | null | ||
workflow_actionshells | modified_user_id | char | 36 | √ | null | ||
workflow_alerts | modified_user_id | char | 36 | √ | null | ||
workflow_alertshells | modified_user_id | char | 36 | √ | null | ||
workflow_schedules | modified_user_id | char | 36 | √ | null | ||
workflow_triggershells | modified_user_id | char | 36 | √ | null | ||
worksheet | modified_user_id | char | 36 | √ | null | ||
cron_remove_documents | module | varchar | 25 | √ | null | ||
import_maps | module | varchar | 36 | √ | null | ||
saved_reports | module | varchar | 36 | √ | null | ||
sugarfavorites | module | varchar | 50 | √ | null | ||
roles_modules | module_id | varchar | 36 | √ | null | ||
tracker | module_name | varchar | 255 | √ | null | ||
team_sets_modules | module_table_name | varchar | 128 | √ | null | ||
roles | modules | text | 65535 | √ | null | ||
tracker | monitor_id | char | 36 | ||||
tracker_perf | monitor_id | char | 36 | ||||
tracker_tracker_queries | monitor_id | char | 36 | √ | null | ||
campaign_log | more_information | varchar | 100 | √ | null | ||
email_cache | msgno | int unsigned | 10 | √ | null | ||
accounts | name | varchar | 150 | √ | null | ||
acl_actions | name | varchar | 150 | √ | null | ||
acl_fields | name | varchar | 150 | √ | null | ||
acl_roles | name | varchar | 150 | √ | null | ||
bugs | name | varchar | 255 | √ | null | ||
calls | name | varchar | 50 | √ | null | ||
campaigns | name | varchar | 50 | √ | null | ||
cases | name | varchar | 255 | √ | null | ||
config | name | varchar | 32 | √ | null | ||
contract_types | name | varchar | 30 | √ | null | ||
contracts | name | varchar | 255 | √ | null | ||
currencies | name | varchar | 36 | √ | null | ||
eapm | name | varchar | 255 | √ | null | ||
email_marketing | name | varchar | 255 | √ | null | ||
email_templates | name | varchar | 255 | √ | null | ||
emails | name | varchar | 255 | √ | null | ||
fields_meta_data | name | varchar | 255 | √ | null | ||
folders | name | varchar | 25 | √ | null | ||
forecast_manager_worksheets | name | varchar | 255 | √ | null | ||
forecast_tree | name | varchar | 50 | √ | null | ||
forecast_worksheets | name | varchar | 255 | √ | null | ||
import_maps | name | varchar | 254 | √ | null | ||
inbound_email | name | varchar | 255 | √ | null | ||
job_queue | name | varchar | 255 | √ | null | ||
manufacturers | name | varchar | 50 | √ | null | ||
meetings | name | varchar | 50 | √ | null | ||
notes | name | varchar | 255 | √ | null | ||
notifications | name | varchar | 255 | √ | null | ||
oauth_consumer | name | varchar | 255 | √ | null | ||
opportunities | name | varchar | 50 | √ | null | ||
outbound_email | name | varchar | 50 | √ | null | ||
pdfmanager | name | varchar | 255 | √ | null | ||
product_bundles | name | varchar | 255 | √ | null | ||
product_categories | name | varchar | 50 | √ | null | ||
product_templates | name | varchar | 50 | √ | null | ||
product_types | name | varchar | 50 | √ | null | ||
products | name | varchar | 50 | √ | null | ||
project | name | varchar | 50 | √ | null | ||
project_task | name | varchar | 50 | √ | null | ||
prospect_lists | name | varchar | 50 | √ | null | ||
quotes | name | varchar | 50 | √ | null | ||
releases | name | varchar | 50 | √ | null | ||
roles | name | varchar | 150 | √ | null | ||
saved_reports | name | varchar | 255 | √ | null | ||
saved_search | name | varchar | 150 | √ | null | ||
schedulers | name | varchar | 255 | √ | null | ||
shippers | name | varchar | 50 | √ | null | ||
sugarfavorites | name | varchar | 255 | √ | null | ||
sugarfeed | name | varchar | 255 | √ | null | ||
tasks | name | varchar | 50 | √ | null | ||
taxrates | name | varchar | 50 | √ | null | ||
team_notices | name | varchar | 50 | √ | null | ||
team_sets | name | varchar | 128 | √ | null | ||
teams | name | varchar | 128 | √ | null | ||
timeperiods | name | varchar | 36 | √ | null | ||
upgrade_history | name | varchar | 255 | √ | null | ||
users_signatures | name | varchar | 255 | √ | null | ||
versions | name | varchar | 255 | √ | null | ||
workflow | name | varchar | 50 | √ | null | ||
workflow_alertshells | name | varchar | 50 | √ | null | ||
teams | name_2 | varchar | 128 | √ | null | ||
product_bundles | new_sub | decimal | 26,6 | √ | null | ||
quotes | new_sub | decimal | 26,6 | √ | null | ||
product_bundles | new_sub_usdollar | decimal | 26,6 | √ | null | ||
quotes | new_sub_usdollar | decimal | 26,6 | √ | null | ||
report_schedules | next_run | datetime | 19 | √ | null | ||
opportunities | next_step | varchar | 100 | √ | null | ||
category_tree | node_id | int | 11 | √ | |||
oauth_nonce | nonce | varchar | 32 | ||||
oauth_nonce | nonce_ts | bigint | 20 | √ | null | ||
product_bundle_note | note_id | varchar | 36 | √ | null | ||
product_bundle_note | note_index | int | 11 | √ | 0 | ||
session_active | num_active_sessions | int | 11 | √ | 0 | ||
session_history | num_active_sessions | int | 11 | √ | 0 | ||
systems | num_syncs | int | 11 | √ | 0 | ||
eapm | oauth_secret | varchar | 255 | √ | null | ||
eapm | oauth_token | varchar | 255 | √ | null | ||
oauth_consumer | oauth_type | varchar | 50 | √ | oauth1 | ||
campaigns | objective | text | 65535 | √ | null | ||
worksheet | op_probability | double | 22 | √ | 0 | ||
expressions | operator | varchar | 15 | √ | null | ||
forecast_manager_worksheets | opp_count | int | 5 | √ | null | ||
forecasts | opp_count | int | 5 | √ | null | ||
forecasts | opp_weigh_value | int | 11 | √ | null | ||
leads | opportunity_amount | varchar | 50 | √ | null | ||
accounts_opportunities | opportunity_id | varchar | 36 | √ | null | ||
contracts_opportunities | opportunity_id | varchar | 36 | √ | null | ||
documents_opportunities | opportunity_id | char | 36 | √ | null | ||
leads | opportunity_id | char | 36 | √ | null | ||
opportunities_contacts | opportunity_id | varchar | 36 | √ | null | ||
products | opportunity_id | char | 36 | √ | null | ||
projects_opportunities | opportunity_id | varchar | 36 | √ | null | ||
quotes_opportunities | opportunity_id | varchar | 36 | √ | null | ||
leads | opportunity_name | varchar | 255 | √ | null | ||
opportunities | opportunity_type | varchar | 255 | √ | null | ||
email_addresses | opt_out | bit | 1 | √ | 0 | ||
project_task | order_number | int | 11 | √ | 1 | ||
quotes | order_stage | varchar | 100 | √ | null | ||
quotes | original_po_date | date | 10 | √ | null | ||
calls | outlook_id | varchar | 255 | √ | null | ||
meetings | outlook_id | varchar | 255 | √ | null | ||
accounts | ownership | varchar | 100 | √ | null | ||
workflow_actionshells | parameters | varchar | 255 | √ | null | ||
workflow_schedules | parameters | varchar | 255 | √ | null | ||
workflow_triggershells | parameters | varchar | 255 | √ | null | ||
expressions | parent_exp_id | char | 36 | √ | null | ||
expressions | parent_exp_side | int | 8 | √ | null | ||
folders | parent_folder | char | 36 | √ | null | ||
accounts | parent_id | char | 36 | √ | null | ||
accounts_audit | parent_id | char | 36 | ||||
bugs_audit | parent_id | char | 36 | ||||
calls | parent_id | char | 36 | √ | null | ||
campaigns_audit | parent_id | char | 36 | ||||
cases_audit | parent_id | char | 36 | ||||
contacts_audit | parent_id | char | 36 | ||||
contracts_audit | parent_id | char | 36 | ||||
emails | parent_id | char | 36 | √ | null | ||
expressions | parent_id | char | 36 | ||||
forecast_tree | parent_id | char | 36 | √ | null | ||
forecast_worksheets | parent_id | char | 36 | √ | null | ||
kbcontents_audit | parent_id | char | 36 | ||||
kbdocuments | parent_id | char | 36 | √ | null | ||
leads_audit | parent_id | char | 36 | ||||
linked_documents | parent_id | varchar | 36 | √ | null | ||
meetings | parent_id | char | 36 | √ | null | ||
notes | parent_id | char | 36 | √ | null | ||
notifications_audit | parent_id | char | 36 | ||||
opportunities_audit | parent_id | char | 36 | ||||
product_categories | parent_id | varchar | 36 | √ | null | ||
product_product | parent_id | varchar | 36 | √ | null | ||
products_audit | parent_id | char | 36 | ||||
project_task_audit | parent_id | char | 36 | ||||
quotes_audit | parent_id | char | 36 | ||||
tasks | parent_id | char | 36 | √ | null | ||
timeperiods | parent_id | char | 36 | √ | null | ||
workflow | parent_id | char | 36 | √ | null | ||
workflow_actions | parent_id | char | 36 | ||||
workflow_actionshells | parent_id | char | 36 | ||||
workflow_alerts | parent_id | char | 36 | ||||
workflow_alertshells | parent_id | char | 36 | ||||
workflow_triggershells | parent_id | char | 36 | ||||
category_tree | parent_node_id | int | 11 | √ | 0 | ||
kbtags | parent_tag_id | varchar | 36 | √ | null | ||
project_task | parent_task_id | int | 11 | √ | null | ||
calls | parent_type | varchar | 255 | √ | null | ||
emails | parent_type | varchar | 100 | √ | null | ||
expressions | parent_type | varchar | 255 | √ | null | ||
forecast_worksheets | parent_type | varchar | 255 | √ | null | ||
kbdocuments | parent_type | varchar | 255 | √ | null | ||
linked_documents | parent_type | varchar | 25 | √ | null | ||
meetings | parent_type | varchar | 100 | √ | null | ||
notes | parent_type | varchar | 255 | √ | null | ||
tasks | parent_type | varchar | 255 | √ | null | ||
eapm | password | varchar | 255 | √ | null | ||
meetings | password | varchar | 50 | √ | null | ||
quotes | payment_terms | varchar | 128 | √ | null | ||
job_queue | percent_complete | int | 11 | √ | null | ||
project_task | percent_complete | int | 11 | √ | null | ||
holidays | person_id | char | 36 | √ | null | ||
holidays | person_type | varchar | 255 | √ | null | ||
accounts | phone_alternate | varchar | 100 | √ | null | ||
accounts | phone_fax | varchar | 100 | √ | null | ||
contacts | phone_fax | varchar | 100 | √ | null | ||
leads | phone_fax | varchar | 100 | √ | null | ||
prospects | phone_fax | varchar | 100 | √ | null | ||
users | phone_fax | varchar | 50 | √ | null | ||
contacts | phone_home | varchar | 100 | √ | null | ||
leads | phone_home | varchar | 100 | √ | null | ||
prospects | phone_home | varchar | 100 | √ | null | ||
users | phone_home | varchar | 50 | √ | null | ||
contacts | phone_mobile | varchar | 100 | √ | null | ||
leads | phone_mobile | varchar | 100 | √ | null | ||
prospects | phone_mobile | varchar | 100 | √ | null | ||
users | phone_mobile | varchar | 50 | √ | null | ||
accounts | phone_office | varchar | 100 | √ | null | ||
contacts | phone_other | varchar | 100 | √ | null | ||
leads | phone_other | varchar | 100 | √ | null | ||
prospects | phone_other | varchar | 100 | √ | null | ||
users | phone_other | varchar | 50 | √ | null | ||
contacts | phone_work | varchar | 100 | √ | null | ||
leads | phone_work | varchar | 100 | √ | null | ||
prospects | phone_work | varchar | 100 | √ | null | ||
users | phone_work | varchar | 50 | √ | null | ||
contacts | picture | varchar | 255 | √ | null | ||
users | picture | varchar | 255 | √ | null | ||
forecast_manager_worksheets | pipeline_amount | decimal | 26,6 | √ | 0.000000 | ||
forecasts | pipeline_amount | decimal | 26,6 | √ | 0.000000 | ||
forecast_manager_worksheets | pipeline_opp_count | int | 5 | √ | 0 | ||
forecasts | pipeline_opp_count | int | 5 | √ | 0 | ||
config | platform | varchar | 32 | √ | null | ||
folders_rel | polymorphic_id | char | 36 | ||||
folders_rel | polymorphic_module | varchar | 25 | √ | null | ||
inbound_email | port | int | 5 | √ | null | ||
leads | portal_app | varchar | 255 | √ | null | ||
notes | portal_flag | bit | 1 | √ | null | ||
leads | portal_name | varchar | 255 | √ | null | ||
users | portal_only | bit | 1 | √ | 0 | ||
project_task | predecessors | text | 65535 | √ | null | ||
leads | preferred_language | varchar | 255 | √ | en_us | ||
users | preferred_language | varchar | 255 | √ | en_us | ||
product_templates | pricing_factor | decimal | 8,2 | √ | null | ||
products | pricing_factor | int | 4 | √ | null | ||
product_templates | pricing_formula | varchar | 100 | √ | null | ||
products | pricing_formula | varchar | 100 | √ | null | ||
email_addr_bean_rel | primary_address | bit | 1 | √ | 0 | ||
contacts | primary_address_city | varchar | 100 | √ | null | ||
leads | primary_address_city | varchar | 100 | √ | null | ||
prospects | primary_address_city | varchar | 100 | √ | null | ||
contacts | primary_address_country | varchar | 255 | √ | null | ||
leads | primary_address_country | varchar | 255 | √ | null | ||
prospects | primary_address_country | varchar | 255 | √ | null | ||
contacts | primary_address_postalcode | varchar | 20 | √ | null | ||
leads | primary_address_postalcode | varchar | 20 | √ | null | ||
prospects | primary_address_postalcode | varchar | 20 | √ | null | ||
contacts | primary_address_state | varchar | 100 | √ | null | ||
leads | primary_address_state | varchar | 100 | √ | null | ||
prospects | primary_address_state | varchar | 100 | √ | null | ||
contacts | primary_address_street | varchar | 150 | √ | null | ||
leads | primary_address_street | varchar | 150 | √ | null | ||
prospects | primary_address_street | varchar | 150 | √ | null | ||
bugs | priority | varchar | 100 | √ | null | ||
cases | priority | varchar | 100 | √ | null | ||
project | priority | varchar | 255 | √ | null | ||
project_task | priority | varchar | 255 | √ | null | ||
tasks | priority | varchar | 100 | √ | null | ||
teams | private | bit | 1 | √ | 0 | ||
forecast_worksheets | probability | double | 22 | √ | null | ||
opportunities | probability | double | 22 | √ | null | ||
products | probability | double | 22 | √ | null | ||
fts_queue | processed | bit | 1 | √ | 0 | ||
bugs | product_category | varchar | 255 | √ | null | ||
contracts_products | product_id | varchar | 36 | √ | null | ||
documents_products | product_id | char | 36 | √ | null | ||
product_bundle_product | product_id | varchar | 36 | √ | null | ||
projects_products | product_id | varchar | 36 | √ | null | ||
product_bundle_product | product_index | int | 11 | √ | 0 | ||
products | product_template_id | char | 36 | √ | null | ||
project_resources | project_id | char | 36 | √ | null | ||
project_task | project_id | char | 36 | ||||
projects_accounts | project_id | varchar | 36 | √ | null | ||
projects_bugs | project_id | varchar | 36 | √ | null | ||
projects_cases | project_id | varchar | 36 | √ | null | ||
projects_contacts | project_id | varchar | 36 | √ | null | ||
projects_opportunities | project_id | varchar | 36 | √ | null | ||
projects_products | project_id | varchar | 36 | √ | null | ||
projects_quotes | project_id | varchar | 36 | √ | null | ||
project_task | project_task_id | int | 11 | √ | null | ||
email_marketing_prospect_lists | prospect_list_id | varchar | 36 | √ | null | ||
prospect_list_campaigns | prospect_list_id | varchar | 36 | √ | null | ||
prospect_lists_prospects | prospect_list_id | varchar | 36 | √ | null | ||
email_templates | published | varchar | 3 | √ | null | ||
pdfmanager | published | varchar | 100 | √ | yes | ||
quotes | purchase_order_num | varchar | 50 | √ | null | ||
users | pwd_last_changed | datetime | 19 | √ | null | ||
product_templates | qty_in_stock | int | 5 | √ | null | ||
products | quantity | decimal | 12,2 | √ | null | ||
tracker_queries | query_hash | varchar | 36 | √ | null | ||
tracker_queries | query_id | char | 36 | ||||
tracker_tracker_queries | query_id | char | 36 | √ | null | ||
forecast_manager_worksheets | quota | decimal | 26,6 | √ | null | ||
worksheet | quota | decimal | 26,6 | √ | null | ||
quotas | quota_type | varchar | 100 | √ | null | ||
contracts_quotes | quote_id | varchar | 36 | √ | null | ||
documents_quotes | quote_id | varchar | 36 | √ | null | ||
product_bundle_quote | quote_id | varchar | 36 | √ | null | ||
products | quote_id | char | 36 | √ | null | ||
projects_quotes | quote_id | varchar | 36 | √ | null | ||
quotes_accounts | quote_id | varchar | 36 | √ | null | ||
quotes_contacts | quote_id | varchar | 36 | √ | null | ||
quotes_opportunities | quote_id | varchar | 36 | √ | null | ||
quotes | quote_num | int | 11 | √ | |||
quotes | quote_stage | varchar | 100 | √ | null | ||
quotes | quote_type | varchar | 100 | √ | null | ||
users_feeds | rank | int | 11 | √ | null | ||
accounts | rating | varchar | 100 | √ | null | ||
kbdocuments_views_ratings | ratings_number | int | 11 | √ | 0 | ||
emails_text | raw_source | longtext | 2147483647 | √ | null | ||
users | receive_notifications | bit | 1 | √ | 1 | ||
email_cache | recent | tinyint | 4 | √ | null | ||
sugarfavorites | record_id | varchar | 36 | √ | null | ||
workflow | record_type | varchar | 100 | √ | null | ||
calls | recurring_source | varchar | 36 | √ | null | ||
meetings | recurring_source | varchar | 36 | √ | null | ||
campaigns | refer_url | varchar | 255 | √ | http:// | ||
leads | refered_by | varchar | 100 | √ | null | ||
contracts | reference_code | varchar | 255 | √ | null | ||
workflow_alerts | rel_email_value | varchar | 50 | √ | null | ||
workflow_actionshells | rel_module | varchar | 50 | √ | null | ||
workflow_triggershells | rel_module | varchar | 255 | √ | null | ||
workflow_alerts | rel_module1 | varchar | 255 | √ | null | ||
workflow_alerts | rel_module1_type | varchar | 10 | √ | null | ||
workflow_alerts | rel_module2 | varchar | 255 | √ | null | ||
workflow_alerts | rel_module2_type | varchar | 10 | √ | null | ||
workflow_actionshells | rel_module_type | varchar | 10 | √ | null | ||
workflow_triggershells | rel_module_type | varchar | 10 | √ | null | ||
workflow_alerts | relate_type | varchar | 100 | √ | null | ||
documents | related_doc_id | char | 36 | √ | null | ||
kbdocuments | related_doc_id | char | 36 | √ | null | ||
documents | related_doc_rev_id | char | 36 | √ | null | ||
kbdocuments | related_doc_rev_id | char | 36 | √ | null | ||
worksheet | related_forecast_type | varchar | 100 | √ | null | ||
campaign_log | related_id | varchar | 36 | √ | null | ||
emailman | related_id | char | 36 | √ | null | ||
prospect_lists_prospects | related_id | varchar | 36 | √ | null | ||
sugarfeed | related_id | char | 36 | √ | null | ||
worksheet | related_id | char | 36 | √ | null | ||
holidays | related_module | varchar | 255 | √ | null | ||
sugarfeed | related_module | varchar | 100 | √ | null | ||
holidays | related_module_id | char | 36 | √ | null | ||
campaign_log | related_type | varchar | 100 | √ | null | ||
emailman | related_type | varchar | 100 | √ | null | ||
prospect_lists_prospects | related_type | varchar | 25 | √ | null | ||
relationships | relationship_name | varchar | 150 | √ | null | ||
relationships | relationship_role_column | varchar | 64 | √ | null | ||
relationships | relationship_role_column_value | varchar | 50 | √ | null | ||
relationships | relationship_type | varchar | 64 | √ | null | ||
calls | reminder_time | int | 11 | √ | -1 | ||
meetings | reminder_time | int | 11 | √ | -1 | ||
calls | repeat_count | int | 7 | √ | null | ||
meetings | repeat_count | int | 7 | √ | null | ||
calls | repeat_dow | varchar | 7 | √ | null | ||
meetings | repeat_dow | varchar | 7 | √ | null | ||
calls | repeat_interval | int | 3 | √ | 1 | ||
meetings | repeat_interval | int | 3 | √ | 1 | ||
calls | repeat_parent_id | char | 36 | √ | null | ||
meetings | repeat_parent_id | char | 36 | √ | null | ||
calls | repeat_type | varchar | 36 | √ | null | ||
meetings | repeat_type | varchar | 36 | √ | null | ||
calls | repeat_until | date | 10 | √ | null | ||
meetings | repeat_until | date | 10 | √ | null | ||
email_marketing | reply_to_addr | varchar | 100 | √ | null | ||
emails_text | reply_to_addr | varchar | 255 | √ | null | ||
email_addr_bean_rel | reply_to_address | bit | 1 | √ | 0 | ||
email_marketing | reply_to_name | varchar | 100 | √ | null | ||
emails | reply_to_status | bit | 1 | √ | null | ||
report_schedules | report_id | char | 36 | √ | null | ||
report_cache | report_options | text | 65535 | √ | null | ||
saved_reports | report_type | varchar | 36 | √ | null | ||
fields_meta_data | reportable | bit | 1 | √ | 1 | ||
contacts | reports_to_id | char | 36 | √ | null | ||
leads | reports_to_id | char | 36 | √ | null | ||
users | reports_to_id | char | 36 | √ | null | ||
job_queue | requeue | bit | 1 | √ | 0 | ||
calls_contacts | required | varchar | 1 | √ | 1 | ||
calls_leads | required | varchar | 1 | √ | 1 | ||
calls_users | required | varchar | 1 | √ | 1 | ||
fields_meta_data | required | bit | 1 | √ | 0 | ||
meetings_contacts | required | varchar | 1 | √ | 1 | ||
meetings_leads | required | varchar | 1 | √ | 1 | ||
meetings_users | required | varchar | 1 | √ | 1 | ||
bugs | resolution | varchar | 255 | √ | null | ||
cases | resolution | text | 65535 | √ | null | ||
job_queue | resolution | varchar | 20 | √ | null | ||
project_resources | resource_id | char | 36 | √ | null | ||
project_task | resource_id | text | 65535 | √ | null | ||
holidays | resource_name | varchar | 255 | √ | null | ||
project_resources | resource_type | varchar | 20 | √ | null | ||
job_queue | retry_count | tinyint | 4 | √ | null | ||
relationships | reverse | bit | 1 | √ | 0 | ||
document_revisions | revision | varchar | 100 | √ | null | ||
kbdocument_revisions | revision | varchar | 100 | √ | null | ||
kbdocuments_kbtags | revision | varchar | 100 | √ | null | ||
kbtags | revision | varchar | 100 | √ | null | ||
worksheet | revision | double | 22 | √ | 0 | ||
expressions | rhs_field | varchar | 50 | √ | null | ||
expressions | rhs_group_type | varchar | 10 | √ | null | ||
relationships | rhs_key | varchar | 64 | √ | null | ||
expressions | rhs_module | varchar | 50 | √ | null | ||
relationships | rhs_module | varchar | 100 | √ | null | ||
relationships | rhs_table | varchar | 64 | √ | null | ||
expressions | rhs_type | varchar | 15 | √ | null | ||
expressions | rhs_value | varchar | 255 | √ | null | ||
acl_fields | role_id | char | 36 | ||||
acl_roles_actions | role_id | varchar | 36 | √ | null | ||
acl_roles_users | role_id | varchar | 36 | √ | null | ||
roles_modules | role_id | varchar | 36 | √ | null | ||
roles_users | role_id | varchar | 36 | √ | null | ||
kbtags | root_tag | bit | 1 | √ | 0 | ||
tracker_sessions | round_trips | int | 5 | √ | null | ||
tracker_queries | run_count | int | 6 | √ | null | ||
forecast_worksheets | sales_stage | varchar | 255 | √ | null | ||
opportunities | sales_stage | varchar | 255 | √ | null | ||
contacts | salutation | varchar | 255 | √ | null | ||
leads | salutation | varchar | 255 | √ | null | ||
prospects | salutation | varchar | 255 | √ | null | ||
report_schedules | schedule_type | varchar | 3 | √ | null | ||
saved_reports | schedule_type | varchar | 3 | √ | pro | ||
job_queue | scheduler_id | char | 36 | √ | null | ||
schedulers_times | scheduler_id | char | 36 | ||||
saved_search | search_module | varchar | 150 | √ | null | ||
tracker_queries | sec_avg | double | 22 | √ | null | ||
tracker_queries | sec_total | double | 22 | √ | null | ||
tracker_sessions | seconds | int | 9 | √ | 0 | ||
oauth_tokens | secret | varchar | 32 | √ | null | ||
email_cache | seen | tinyint | 4 | √ | null | ||
category_tree | self_id | char | 36 | √ | null | ||
emailman | send_attempts | int | 11 | √ | 0 | ||
emailman | send_date_time | datetime | 19 | √ | null | ||
email_cache | senddate | datetime | 19 | √ | null | ||
meetings | sequence | int | 11 | √ | 0 | ||
products | serial_number | varchar | 50 | √ | null | ||
tracker_perf | server_response_time | double | 22 | √ | null | ||
inbound_email | server_url | varchar | 100 | √ | null | ||
inbound_email | service | varchar | 50 | √ | null | ||
session_active | session_id | varchar | 100 | √ | null | ||
session_history | session_id | varchar | 100 | √ | null | ||
tracker | session_id | varchar | 36 | √ | null | ||
tracker_sessions | session_id | varchar | 36 | √ | null | ||
session_active | session_type | varchar | 100 | √ | null | ||
session_history | session_type | varchar | 100 | √ | null | ||
custom_fields | set_num | int | 11 | √ | 0 | ||
workflow_actions | set_type | varchar | 10 | √ | null | ||
quotes | shipper_id | char | 36 | √ | null | ||
product_bundles | shipping | decimal | 26,6 | √ | null | ||
quotes | shipping | decimal | 26,6 | √ | null | ||
accounts | shipping_address_city | varchar | 100 | √ | null | ||
quotes | shipping_address_city | varchar | 100 | √ | null | ||
accounts | shipping_address_country | varchar | 255 | √ | null | ||
quotes | shipping_address_country | varchar | 100 | √ | null | ||
accounts | shipping_address_postalcode | varchar | 20 | √ | null | ||
quotes | shipping_address_postalcode | varchar | 20 | √ | null | ||
accounts | shipping_address_state | varchar | 100 | √ | null | ||
quotes | shipping_address_state | varchar | 100 | √ | null | ||
accounts | shipping_address_street | varchar | 150 | √ | null | ||
quotes | shipping_address_street | varchar | 150 | √ | null | ||
product_bundles | shipping_usdollar | decimal | 26,6 | √ | null | ||
quotes | shipping_usdollar | decimal | 26,6 | √ | null | ||
quotes | show_line_nums | bit | 1 | √ | 1 | ||
users | show_on_employees | bit | 1 | √ | 1 | ||
workflow_triggershells | show_past | bit | 1 | √ | 0 | ||
accounts | sic_code | varchar | 10 | √ | null | ||
users_signatures | signature | text | 65535 | √ | null | ||
users_signatures | signature_html | text | 65535 | √ | null | ||
bugs | source | varchar | 255 | √ | null | ||
import_maps | source | varchar | 36 | √ | null | ||
vcals | source | varchar | 100 | √ | null | ||
workflow_alertshells | source_type | varchar | 100 | √ | null | ||
campaigns | start_date | date | 10 | √ | null | ||
contracts | start_date | date | 10 | √ | null | ||
timeperiods | start_date | date | 10 | √ | null | ||
timeperiods | start_date_timestamp | int | 14 | √ | null | ||
bugs | status | varchar | 100 | √ | null | ||
calls | status | varchar | 100 | √ | Planned | ||
campaigns | status | varchar | 100 | √ | null | ||
cases | status | varchar | 100 | √ | null | ||
contracts | status | varchar | 100 | √ | null | ||
currencies | status | varchar | 100 | √ | null | ||
email_marketing | status | varchar | 100 | √ | null | ||
emails | status | varchar | 100 | √ | null | ||
forecast_schedule | status | varchar | 100 | √ | null | ||
inbound_email | status | varchar | 100 | √ | Active | ||
job_queue | status | varchar | 20 | √ | null | ||
leads | status | varchar | 100 | √ | null | ||
manufacturers | status | varchar | 100 | √ | null | ||
meetings | status | varchar | 100 | √ | Planned | ||
product_templates | status | varchar | 100 | √ | null | ||
products | status | varchar | 100 | √ | null | ||
project | status | varchar | 255 | √ | null | ||
project_task | status | varchar | 255 | √ | null | ||
releases | status | varchar | 100 | √ | null | ||
schedulers | status | varchar | 100 | √ | null | ||
schedulers_times | status | varchar | 25 | √ | ready | ||
shippers | status | varchar | 100 | √ | null | ||
systems | status | varchar | 255 | √ | Active | ||
tasks | status | varchar | 100 | √ | Not Started | ||
taxrates | status | varchar | 100 | √ | null | ||
team_notices | status | varchar | 100 | √ | null | ||
upgrade_history | status | varchar | 50 | √ | null | ||
users | status | varchar | 100 | √ | null | ||
workflow | status | bit | 1 | √ | 0 | ||
leads | status_description | text | 65535 | √ | null | ||
documents | status_id | varchar | 100 | √ | null | ||
kbdocuments | status_id | varchar | 100 | √ | null | ||
inbound_email | stored_options | text | 65535 | √ | null | ||
documents | subcategory_id | varchar | 100 | √ | null | ||
email_cache | subject | varchar | 255 | √ | null | ||
email_templates | subject | varchar | 255 | √ | null | ||
pdfmanager | subject | varchar | 255 | √ | null | ||
product_bundles | subtotal | decimal | 26,6 | √ | null | ||
quotes | subtotal | decimal | 26,6 | √ | null | ||
product_bundles | subtotal_usdollar | decimal | 26,6 | √ | null | ||
quotes | subtotal_usdollar | decimal | 26,6 | √ | null | ||
users | sugar_login | bit | 1 | √ | 1 | ||
product_templates | support_contact | varchar | 50 | √ | null | ||
products | support_contact | varchar | 50 | √ | null | ||
product_templates | support_description | varchar | 255 | √ | null | ||
products | support_description | varchar | 255 | √ | null | ||
product_templates | support_name | varchar | 50 | √ | null | ||
products | support_name | varchar | 50 | √ | null | ||
product_templates | support_term | varchar | 100 | √ | null | ||
products | support_term | varchar | 100 | √ | null | ||
currencies | symbol | varchar | 36 | √ | null | ||
users | system_generated_password | bit | 1 | √ | null | ||
bugs | system_id | int | 11 | √ | null | ||
cases | system_id | int | 11 | √ | null | ||
quotes | system_id | int | 11 | √ | null | ||
systems | system_id | int | 11 | √ | |||
systems | system_key | varchar | 36 | √ | null | ||
systems | system_name | varchar | 100 | √ | null | ||
kbtags | tag_name | varchar | 255 | √ | null | ||
job_queue | target | varchar | 255 | √ | null | ||
campaign_log | target_id | varchar | 36 | √ | null | ||
workflow_schedules | target_module | varchar | 50 | √ | null | ||
campaign_log | target_tracker_key | varchar | 36 | √ | null | ||
campaign_log | target_type | varchar | 100 | √ | null | ||
project_task | task_number | int | 11 | √ | null | ||
product_bundles | tax | decimal | 26,6 | √ | null | ||
quotes | tax | decimal | 26,6 | √ | null | ||
product_templates | tax_class | varchar | 100 | √ | null | ||
products | tax_class | varchar | 100 | √ | null | ||
product_bundles | tax_usdollar | decimal | 26,6 | √ | null | ||
quotes | tax_usdollar | decimal | 26,6 | √ | null | ||
quotes | taxrate_id | char | 36 | √ | null | ||
team_sets | team_count | int | 11 | √ | 0 | ||
accounts | team_id | char | 36 | √ | null | ||
bugs | team_id | char | 36 | √ | null | ||
calls | team_id | char | 36 | √ | null | ||
campaigns | team_id | char | 36 | √ | null | ||
cases | team_id | char | 36 | √ | null | ||
contacts | team_id | char | 36 | √ | null | ||
contracts | team_id | char | 36 | √ | null | ||
documents | team_id | char | 36 | √ | null | ||
email_templates | team_id | char | 36 | √ | null | ||
emails | team_id | char | 36 | √ | null | ||
folders | team_id | char | 36 | √ | null | ||
forecast_manager_worksheets | team_id | char | 36 | √ | null | ||
forecast_worksheets | team_id | char | 36 | √ | null | ||
inbound_email | team_id | char | 36 | √ | null | ||
kbcontents | team_id | char | 36 | √ | null | ||
kbdocuments | team_id | char | 36 | √ | null | ||
kbdocuments_kbtags | team_id | char | 36 | √ | null | ||
kbtags | team_id | char | 36 | √ | null | ||
leads | team_id | char | 36 | √ | null | ||
meetings | team_id | char | 36 | √ | null | ||
notes | team_id | char | 36 | √ | null | ||
opportunities | team_id | char | 36 | √ | null | ||
pdfmanager | team_id | char | 36 | √ | null | ||
product_bundles | team_id | char | 36 | √ | null | ||
products | team_id | char | 36 | √ | null | ||
project | team_id | char | 36 | √ | null | ||
project_task | team_id | char | 36 | √ | null | ||
prospect_lists | team_id | char | 36 | √ | null | ||
prospects | team_id | char | 36 | √ | null | ||
quotes | team_id | char | 36 | √ | null | ||
saved_reports | team_id | char | 36 | √ | null | ||
saved_search | team_id | char | 36 | √ | null | ||
sugarfeed | team_id | char | 36 | √ | null | ||
tasks | team_id | char | 36 | √ | null | ||
team_memberships | team_id | char | 36 | √ | null | ||
team_notices | team_id | char | 36 | √ | null | ||
team_sets_teams | team_id | char | 36 | √ | null | ||
tracker | team_id | char | 36 | √ | null | ||
team_sets | team_md5 | varchar | 32 | √ | null | ||
accounts | team_set_id | char | 36 | √ | null | ||
bugs | team_set_id | char | 36 | √ | null | ||
calls | team_set_id | char | 36 | √ | null | ||
campaigns | team_set_id | char | 36 | √ | null | ||
cases | team_set_id | char | 36 | √ | null | ||
contacts | team_set_id | char | 36 | √ | null | ||
contracts | team_set_id | char | 36 | √ | null | ||
documents | team_set_id | char | 36 | √ | null | ||
email_templates | team_set_id | char | 36 | √ | null | ||
emails | team_set_id | char | 36 | √ | null | ||
folders | team_set_id | char | 36 | √ | null | ||
forecast_manager_worksheets | team_set_id | char | 36 | √ | null | ||
forecast_worksheets | team_set_id | char | 36 | √ | null | ||
inbound_email | team_set_id | char | 36 | √ | null | ||
kbcontents | team_set_id | char | 36 | √ | null | ||
kbdocuments | team_set_id | char | 36 | √ | null | ||
kbdocuments_kbtags | team_set_id | char | 36 | √ | null | ||
kbtags | team_set_id | char | 36 | √ | null | ||
leads | team_set_id | char | 36 | √ | null | ||
meetings | team_set_id | char | 36 | √ | null | ||
notes | team_set_id | char | 36 | √ | null | ||
opportunities | team_set_id | char | 36 | √ | null | ||
pdfmanager | team_set_id | char | 36 | √ | null | ||
product_bundles | team_set_id | char | 36 | √ | null | ||
products | team_set_id | char | 36 | √ | null | ||
project | team_set_id | char | 36 | √ | null | ||
project_task | team_set_id | char | 36 | √ | null | ||
prospect_lists | team_set_id | char | 36 | √ | null | ||
prospects | team_set_id | char | 36 | √ | null | ||
quotes | team_set_id | char | 36 | √ | null | ||
saved_reports | team_set_id | char | 36 | √ | null | ||
saved_search | team_set_id | char | 36 | √ | null | ||
sugarfeed | team_set_id | char | 36 | √ | null | ||
tasks | team_set_id | char | 36 | √ | null | ||
team_notices | team_set_id | char | 36 | √ | null | ||
team_sets_modules | team_set_id | char | 36 | √ | null | ||
team_sets_teams | team_set_id | char | 36 | √ | null | ||
users | team_set_id | char | 36 | √ | null | ||
email_marketing | template_id | char | 36 | ||||
inbound_email | template_id | char | 36 | √ | null | ||
pdfmanager | template_name | varchar | 255 | √ | null | ||
documents | template_type | varchar | 100 | √ | null | ||
kbdocuments | template_type | varchar | 100 | √ | null | ||
tracker_queries | text | text | 65535 | √ | null | ||
email_templates | text_only | bit | 1 | √ | null | ||
accounts | ticker_symbol | varchar | 10 | √ | null | ||
project_task | time_due | time | 8 | √ | null | ||
project_task | time_finish | int | 11 | √ | null | ||
schedulers | time_from | time | 8 | √ | null | ||
report_schedules | time_interval | int | 11 | √ | null | ||
project_task | time_start | int | 11 | √ | null | ||
schedulers | time_to | time | 8 | √ | null | ||
forecast_manager_worksheets | timeperiod_id | char | 36 | √ | null | ||
forecast_schedule | timeperiod_id | char | 36 | √ | null | ||
forecasts | timeperiod_id | char | 36 | √ | null | ||
quotas | timeperiod_id | char | 36 | √ | null | ||
worksheet | timeperiod_id | char | 36 | √ | null | ||
contacts | title | varchar | 100 | √ | null | ||
leads | title | varchar | 100 | √ | null | ||
pdfmanager | title | varchar | 255 | √ | null | ||
prospects | title | varchar | 100 | √ | null | ||
users | title | varchar | 50 | √ | null | ||
emails_text | to_addrs | text | 65535 | √ | null | ||
email_cache | toaddr | varchar | 255 | √ | null | ||
oauth_tokens | token_ts | bigint | 20 | √ | null | ||
product_bundles | total | decimal | 26,6 | √ | null | ||
quotes | total | decimal | 26,6 | √ | null | ||
contracts | total_contract_value | decimal | 26,6 | √ | null | ||
contracts | total_contract_value_usdollar | decimal | 26,6 | √ | null | ||
product_bundles | total_usdollar | decimal | 26,6 | √ | null | ||
quotes | total_usdollar | decimal | 26,6 | √ | null | ||
campaigns | tracker_count | int | 11 | √ | 0 | ||
campaign_trkrs | tracker_key | int | 11 | √ | |||
campaigns | tracker_key | int | 11 | √ | |||
prospects | tracker_key | int | 11 | √ | |||
campaign_trkrs | tracker_name | varchar | 30 | √ | null | ||
campaigns | tracker_text | varchar | 255 | √ | null | ||
campaign_trkrs | tracker_url | varchar | 255 | √ | http:// | ||
oauth_tokens | tstate | varchar | 1 | √ | null | ||
accounts | twitter_id | varchar | 15 | √ | null | ||
contacts | twitter_id | varchar | 15 | √ | null | ||
leads | twitter_id | varchar | 15 | √ | null | ||
prospects | twitter_id | varchar | 15 | √ | null | ||
bugs | type | varchar | 255 | √ | null | ||
cases | type | varchar | 255 | √ | null | ||
category_tree | type | varchar | 36 | √ | null | ||
contracts | type | varchar | 255 | √ | null | ||
email_templates | type | varchar | 255 | √ | null | ||
emails | type | varchar | 100 | √ | null | ||
fields_meta_data | type | varchar | 255 | √ | null | ||
meetings | type | varchar | 255 | √ | Sugar | ||
outbound_email | type | varchar | 15 | √ | user | ||
timeperiods | type | varchar | 255 | √ | null | ||
upgrade_history | type | varchar | 30 | √ | null | ||
vcals | type | varchar | 100 | √ | null | ||
workflow | type | varchar | 100 | √ | null | ||
workflow_triggershells | type | varchar | 100 | √ | null | ||
product_templates | type_id | char | 36 | √ | null | ||
products | type_id | char | 36 | √ | null | ||
eapm | url | varchar | 255 | √ | null | ||
team_notices | url | varchar | 255 | √ | null | ||
team_notices | url_title | varchar | 255 | √ | null | ||
workflow_alerts | user_display_type | varchar | 100 | √ | null | ||
users | user_hash | varchar | 255 | √ | null | ||
acl_roles_users | user_id | varchar | 36 | √ | null | ||
calls_users | user_id | char | 36 | √ | null | ||
contacts_users | user_id | varchar | 36 | √ | null | ||
emailman | user_id | char | 36 | √ | null | ||
forecast_manager_worksheets | user_id | char | 36 | √ | null | ||
forecast_schedule | user_id | char | 36 | √ | null | ||
forecast_tree | user_id | char | 36 | √ | null | ||
forecasts | user_id | char | 36 | √ | null | ||
meetings_users | user_id | char | 36 | √ | null | ||
outbound_email | user_id | char | 36 | ||||
quotas | user_id | char | 36 | √ | null | ||
report_schedules | user_id | char | 36 | √ | null | ||
roles_users | user_id | varchar | 36 | √ | null | ||
systems | user_id | char | 36 | √ | null | ||
team_memberships | user_id | char | 36 | √ | null | ||
tracker | user_id | char | 36 | √ | null | ||
tracker_sessions | user_id | char | 36 | √ | null | ||
users_feeds | user_id | varchar | 36 | √ | null | ||
users_holidays | user_id | varchar | 36 | √ | null | ||
users_signatures | user_id | varchar | 36 | √ | null | ||
vcals | user_id | char | 36 | ||||
worksheet | user_id | char | 36 | √ | null | ||
users | user_name | varchar | 60 | √ | null | ||
workflow_alerts | user_type | varchar | 100 | √ | null | ||
users_password_link | username | varchar | 36 | √ | null | ||
project_task | utilization | int | 11 | √ | 100 | ||
eapm | validated | bit | 1 | √ | null | ||
config | value | text | 65535 | √ | null | ||
taxrates | value | decimal | 7,5 | √ | null | ||
workflow_actions | value | text | 65535 | √ | null | ||
product_templates | vendor_part_num | varchar | 50 | √ | null | ||
products | vendor_part_num | varchar | 50 | √ | null | ||
oauth_tokens | verify | varchar | 32 | √ | null | ||
upgrade_history | version | varchar | 64 | √ | null | ||
worksheet | version | int | 11 | √ | 1 | ||
kbdocuments_views_ratings | views_number | int | 11 | √ | 0 | ||
tracker | visible | bit | 1 | √ | 0 | ||
fields_meta_data | vname | varchar | 255 | √ | null | ||
accounts | website | varchar | 255 | √ | null | ||
leads | website | varchar | 255 | √ | null | ||
product_templates | website | varchar | 255 | √ | null | ||
products | website | varchar | 255 | √ | null | ||
product_templates | weight | decimal | 12,2 | √ | null | ||
products | weight | decimal | 12,2 | √ | null | ||
workflow_alerts | where_filter | bit | 1 | √ | 0 | ||
bugs | work_log | text | 65535 | √ | null | ||
cases | work_log | text | 65535 | √ | null | ||
workflow_schedules | workflow_id | char | 36 | √ | null | ||
forecast_manager_worksheets | worst_case | decimal | 26,6 | √ | null | ||
forecast_worksheets | worst_case | decimal | 26,6 | √ | null | ||
forecasts | worst_case | decimal | 26,6 | √ | null | ||
opportunities | worst_case | decimal | 26,6 | √ | null | ||
products | worst_case | decimal | 26,6 | √ | null | ||
worksheet | worst_case | decimal | 26,6 | √ | null | ||
forecast_manager_worksheets | worst_case_adjusted | decimal | 26,6 | √ | null |