SchemaSpy Analysis of ad5369ce - Columnsgenerated | Generated by SchemaSpy |
Generated on Mon Sep 28 07:45 UTC 2020 |
| ||||||
|
ad5369ce contains 4252 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 | char | 36 | √ | null | ||
accounts_cases | account_id | char | 36 | √ | null | ||
accounts_contacts | account_id | char | 36 | √ | null | ||
accounts_dataprivacy | account_id | char | 36 | √ | null | ||
accounts_opportunities | account_id | char | 36 | √ | null | ||
accounts_purchases | account_id | char | 36 | √ | null | ||
cases | account_id | char | 36 | √ | null | ||
contracts | account_id | char | 36 | √ | null | ||
documents_accounts | account_id | char | 36 | √ | null | ||
forecast_worksheets | account_id | char | 36 | √ | null | ||
leads | account_id | char | 36 | √ | null | ||
products | account_id | char | 36 | √ | null | ||
projects_accounts | account_id | char | 36 | √ | null | ||
purchased_line_items | account_id | char | 36 | √ | null | ||
purchases | account_id | char | 36 | √ | null | ||
quotes_accounts | account_id | char | 36 | √ | null | ||
revenue_line_items | account_id | char | 36 | √ | null | ||
forecast_worksheets | account_name | varchar | 255 | √ | 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_role_sets_acl_roles | acl_role_id | char | 36 | √ | null | ||
acl_role_sets_acl_roles | acl_role_set_id | char | 36 | √ | null | ||
users | acl_role_set_id | char | 36 | √ | null | ||
accounts | acl_team_set_id | char | 36 | √ | null | ||
bugs | acl_team_set_id | char | 36 | √ | null | ||
business_centers | acl_team_set_id | char | 36 | √ | null | ||
calls | acl_team_set_id | char | 36 | √ | null | ||
campaigns | acl_team_set_id | char | 36 | √ | null | ||
cases | acl_team_set_id | char | 36 | √ | null | ||
contacts | acl_team_set_id | char | 36 | √ | null | ||
contracts | acl_team_set_id | char | 36 | √ | null | ||
custom_queries | acl_team_set_id | char | 36 | √ | null | ||
dashboards | acl_team_set_id | char | 36 | √ | null | ||
data_privacy | acl_team_set_id | char | 36 | √ | null | ||
data_sets | acl_team_set_id | char | 36 | √ | null | ||
documents | acl_team_set_id | char | 36 | √ | null | ||
email_templates | acl_team_set_id | char | 36 | √ | null | ||
emails | acl_team_set_id | char | 36 | √ | null | ||
filters | acl_team_set_id | char | 36 | √ | null | ||
folders | acl_team_set_id | char | 36 | √ | null | ||
forecast_manager_worksheets | acl_team_set_id | char | 36 | √ | null | ||
forecast_worksheets | acl_team_set_id | char | 36 | √ | null | ||
inbound_email | acl_team_set_id | char | 36 | √ | null | ||
kbarticles | acl_team_set_id | char | 36 | √ | null | ||
kbcontent_templates | acl_team_set_id | char | 36 | √ | null | ||
kbcontents | acl_team_set_id | char | 36 | √ | null | ||
kbdocuments | acl_team_set_id | char | 36 | √ | null | ||
leads | acl_team_set_id | char | 36 | √ | null | ||
meetings | acl_team_set_id | char | 36 | √ | null | ||
messages | acl_team_set_id | char | 36 | √ | null | ||
notes | acl_team_set_id | char | 36 | √ | null | ||
opportunities | acl_team_set_id | char | 36 | √ | null | ||
outbound_email | acl_team_set_id | char | 36 | √ | null | ||
pdfmanager | acl_team_set_id | char | 36 | √ | null | ||
pmse_business_rules | acl_team_set_id | char | 36 | √ | null | ||
pmse_emails_templates | acl_team_set_id | char | 36 | √ | null | ||
pmse_inbox | acl_team_set_id | char | 36 | √ | null | ||
pmse_project | acl_team_set_id | char | 36 | √ | null | ||
product_bundles | acl_team_set_id | char | 36 | √ | null | ||
product_templates | acl_team_set_id | char | 36 | √ | null | ||
products | acl_team_set_id | char | 36 | √ | null | ||
project | acl_team_set_id | char | 36 | √ | null | ||
project_task | acl_team_set_id | char | 36 | √ | null | ||
prospect_lists | acl_team_set_id | char | 36 | √ | null | ||
prospects | acl_team_set_id | char | 36 | √ | null | ||
purchased_line_items | acl_team_set_id | char | 36 | √ | null | ||
purchases | acl_team_set_id | char | 36 | √ | null | ||
quotes | acl_team_set_id | char | 36 | √ | null | ||
report_maker | acl_team_set_id | char | 36 | √ | null | ||
report_schedules | acl_team_set_id | char | 36 | √ | null | ||
revenue_line_items | acl_team_set_id | char | 36 | √ | null | ||
saved_reports | acl_team_set_id | char | 36 | √ | null | ||
saved_search | acl_team_set_id | char | 36 | √ | null | ||
shift_exceptions | acl_team_set_id | char | 36 | √ | null | ||
shifts | acl_team_set_id | char | 36 | √ | null | ||
tasks | acl_team_set_id | char | 36 | √ | null | ||
team_notices | acl_team_set_id | char | 36 | √ | null | ||
users | acl_team_set_id | char | 36 | √ | null | ||
acl_actions | aclaccess | int | 3 | √ | null | ||
acl_fields | aclaccess | int | 3 | √ | null | ||
acl_actions | acltype | varchar | 100 | √ | null | ||
pmse_bpm_activity_definition | act_adhoc | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_adhoc_behavior | varchar | 40 | √ | |||
pmse_bpm_activity_definition | act_adhoc_team | varchar | 40 | √ | |||
pmse_bpm_activity_definition | act_assign_team | varchar | 40 | √ | |||
pmse_bpm_activity_definition | act_assign_user | varchar | 40 | √ | |||
pmse_bpm_activity_definition | act_assignment_method | varchar | 32 | √ | balanced | ||
pmse_bpm_activity_definition | act_avl_before_type | varchar | 40 | √ | null | ||
pmse_bpm_activity_definition | act_avl_count | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_avl_type | varchar | 40 | √ | null | ||
pmse_bpmn_activity | act_cancel_remaining_instances | int | 4 | √ | 1 | ||
pmse_bpmn_activity | act_completion_condition | varchar | 255 | √ | |||
pmse_bpmn_activity | act_completion_quantity | int | 4 | √ | 1 | ||
pmse_bpm_activity_step | act_criteria | text | 65535 | √ | null | ||
pmse_bpmn_activity | act_default_flow | int | 4 | √ | null | ||
pmse_bpm_activity_definition | act_duration | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_duration_unit | varchar | 32 | √ | DAYS | ||
pmse_bpm_activity_definition | act_expected_time | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_field_module | varchar | 100 | √ | |||
pmse_bpm_activity_definition | act_fields | text | 65535 | √ | null | ||
pmse_bpm_activity_user | act_group_id | varchar | 40 | √ | |||
pmse_bpm_form_action | act_id | varchar | 36 | √ | |||
pmse_bpmn_activity | act_implementation | text | 65535 | √ | null | ||
pmse_bpmn_activity | act_instantiate | int | 4 | √ | 0 | ||
pmse_bpmn_activity | act_is_adhoc | int | 4 | √ | 0 | ||
pmse_bpmn_activity | act_is_collapsed | int | 4 | √ | 1 | ||
pmse_bpmn_activity | act_is_for_compensation | int | 4 | √ | 0 | ||
pmse_bpmn_activity | act_is_global | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_last_user_assigned | varchar | 40 | √ | |||
pmse_bpmn_activity | act_loop_behavior | varchar | 20 | √ | NONE | ||
pmse_bpmn_activity | act_loop_cardinality | int | 4 | √ | 0 | ||
pmse_bpmn_activity | act_loop_condition | varchar | 100 | √ | |||
pmse_bpmn_activity | act_loop_maximum | int | 4 | √ | 0 | ||
pmse_bpmn_activity | act_loop_type | varchar | 20 | √ | NONE | ||
pmse_bpmn_activity | act_master_diagram | int | 4 | √ | null | ||
pmse_bpmn_activity | act_method | varchar | 255 | √ | |||
pmse_bpmn_activity | act_ordering | varchar | 20 | √ | PARALLEL | ||
pmse_bpm_activity_definition | act_params | text | 65535 | √ | null | ||
pmse_bpmn_activity | act_protocol | varchar | 255 | √ | |||
pmse_bpm_activity_definition | act_readonly_fields | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_reassign | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_reassign_team | varchar | 40 | √ | |||
pmse_bpmn_activity | act_referer | int | 4 | √ | null | ||
pmse_bpm_activity_definition | act_related_modules | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_required_fields | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_reserve_user | varchar | 36 | √ | |||
pmse_bpm_activity_definition | act_response_buttons | varchar | 40 | √ | |||
pmse_bpmn_activity | act_script | text | 65535 | √ | null | ||
pmse_bpmn_activity | act_script_type | varchar | 255 | √ | |||
pmse_bpm_activity_definition | act_send_notification | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_service_method | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_service_params | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_service_url | text | 65535 | √ | null | ||
pmse_bpm_activity_definition | act_set_by_avl | bit | 1 | √ | 0 | ||
pmse_bpmn_activity | act_start_quantity | int | 4 | √ | 1 | ||
pmse_bpm_activity_step | act_step_form | varchar | 255 | √ | |||
pmse_bpm_activity_step | act_step_script | text | 65535 | √ | null | ||
pmse_bpm_activity_step | act_step_type | varchar | 30 | √ | START | ||
pmse_bpmn_activity | act_task_type | varchar | 20 | √ | EMPTY | ||
pmse_bpmn_activity | act_test_before | int | 4 | √ | 0 | ||
pmse_bpm_activity_definition | act_type | varchar | 32 | √ | TASK | ||
pmse_bpmn_activity | act_type | varchar | 30 | √ | TASK | ||
pmse_bpmn_activity | act_uid | varchar | 36 | √ | |||
pmse_bpm_activity_definition | act_update_record_owner | int | 4 | √ | 0 | ||
pmse_bpm_activity_user | act_user_id | varchar | 40 | √ | |||
pmse_bpm_activity_user | act_user_type | varchar | 32 | √ | |||
pmse_bpm_activity_definition | act_value_based_assignment | varchar | 255 | √ | |||
team_set_events | action | varchar | 100 | √ | null | ||
tracker | action | varchar | 255 | √ | null | ||
acl_roles_actions | action_id | char | 36 | √ | null | ||
workflow_actionshells | action_module | varchar | 255 | √ | null | ||
workflow_actionshells | action_type | varchar | 100 | √ | null | ||
report_schedules | active | bit | 1 | √ | 1 | ||
tracker_sessions | active | bit | 1 | √ | 1 | ||
documents | active_date | date | 10 | √ | null | ||
kbcontents | active_date | date | 10 | √ | null | ||
kbcontents | active_rev | tinyint | 4 | √ | 0 | ||
campaign_log | activity_date | datetime | 19 | √ | null | ||
activities_users | activity_id | char | 36 | ||||
activities | activity_type | varchar | 100 | √ | null | ||
campaign_log | activity_type | varchar | 100 | √ | null | ||
campaigns | actual_cost | decimal | 26,6 | √ | null | ||
project_task | actual_duration | int | 11 | √ | null | ||
project_task | actual_effort | int | 11 | √ | null | ||
products | add_on_to_id | char | 36 | √ | null | ||
revenue_line_items | add_on_to_id | char | 36 | √ | null | ||
business_centers | address_city | varchar | 100 | √ | null | ||
users | address_city | varchar | 100 | √ | null | ||
business_centers | address_country | varchar | 255 | √ | null | ||
users | address_country | varchar | 100 | √ | null | ||
business_centers | address_postalcode | varchar | 20 | √ | null | ||
users | address_postalcode | varchar | 20 | √ | null | ||
business_centers | address_state | varchar | 100 | √ | null | ||
users | address_state | varchar | 100 | √ | null | ||
business_centers | address_street | varchar | 150 | √ | 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 | ||
business_centers_audit | after_value_string | varchar | 255 | √ | null | ||
calls_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 | ||
data_privacy_audit | after_value_string | varchar | 255 | √ | null | ||
email_addresses_audit | after_value_string | varchar | 255 | √ | null | ||
forecast_manager_worksheets_audit | after_value_string | varchar | 255 | √ | null | ||
kbcontent_templates_audit | after_value_string | varchar | 255 | √ | null | ||
kbcontents_audit | after_value_string | varchar | 255 | √ | null | ||
leads_audit | after_value_string | varchar | 255 | √ | null | ||
meetings_audit | after_value_string | varchar | 255 | √ | null | ||
messages_audit | after_value_string | varchar | 255 | √ | null | ||
notes_audit | after_value_string | varchar | 255 | √ | null | ||
opportunities_audit | after_value_string | varchar | 255 | √ | null | ||
product_templates_audit | after_value_string | varchar | 255 | √ | null | ||
products_audit | after_value_string | varchar | 255 | √ | null | ||
project_task_audit | after_value_string | varchar | 255 | √ | null | ||
prospects_audit | after_value_string | varchar | 255 | √ | null | ||
purchased_line_items_audit | after_value_string | varchar | 255 | √ | null | ||
purchases_audit | after_value_string | varchar | 255 | √ | null | ||
quotas_audit | after_value_string | varchar | 255 | √ | null | ||
quotes_audit | after_value_string | varchar | 255 | √ | null | ||
report_schedules_audit | after_value_string | varchar | 255 | √ | null | ||
revenue_line_items_audit | after_value_string | varchar | 255 | √ | null | ||
shift_exceptions_audit | after_value_string | varchar | 255 | √ | null | ||
shifts_audit | after_value_string | varchar | 255 | √ | null | ||
tags_audit | after_value_string | varchar | 255 | √ | null | ||
tasks_audit | after_value_string | varchar | 255 | √ | null | ||
accounts_audit | after_value_text | text | 65535 | √ | null | ||
bugs_audit | after_value_text | text | 65535 | √ | null | ||
business_centers_audit | after_value_text | text | 65535 | √ | null | ||
calls_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 | ||
data_privacy_audit | after_value_text | text | 65535 | √ | null | ||
email_addresses_audit | after_value_text | text | 65535 | √ | null | ||
forecast_manager_worksheets_audit | after_value_text | text | 65535 | √ | null | ||
kbcontent_templates_audit | after_value_text | text | 65535 | √ | null | ||
kbcontents_audit | after_value_text | text | 65535 | √ | null | ||
leads_audit | after_value_text | text | 65535 | √ | null | ||
meetings_audit | after_value_text | text | 65535 | √ | null | ||
messages_audit | after_value_text | text | 65535 | √ | null | ||
notes_audit | after_value_text | text | 65535 | √ | null | ||
opportunities_audit | after_value_text | text | 65535 | √ | null | ||
product_templates_audit | after_value_text | text | 65535 | √ | null | ||
products_audit | after_value_text | text | 65535 | √ | null | ||
project_task_audit | after_value_text | text | 65535 | √ | null | ||
prospects_audit | after_value_text | text | 65535 | √ | null | ||
purchased_line_items_audit | after_value_text | text | 65535 | √ | null | ||
purchases_audit | after_value_text | text | 65535 | √ | null | ||
quotas_audit | after_value_text | text | 65535 | √ | null | ||
quotes_audit | after_value_text | text | 65535 | √ | null | ||
report_schedules_audit | after_value_text | text | 65535 | √ | null | ||
revenue_line_items_audit | after_value_text | text | 65535 | √ | null | ||
shift_exceptions_audit | after_value_text | text | 65535 | √ | null | ||
shifts_audit | after_value_text | text | 65535 | √ | null | ||
tags_audit | after_value_text | text | 65535 | √ | null | ||
tasks_audit | after_value_text | text | 65535 | √ | null | ||
workflow_alertshells | alert_text | text | 65535 | √ | null | ||
workflow_alertshells | alert_type | varchar | 100 | √ | null | ||
shift_exceptions | all_day | bit | 1 | √ | 1 | ||
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 | ||
styleguide | 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 | ||
styleguide | 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 | ||
styleguide | 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 | ||
styleguide | 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 | ||
styleguide | 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 | ||
purchased_line_items | annual_revenue | decimal | 26,6 | √ | null | ||
email_cache | answered | tinyint | 4 | √ | null | ||
eapm | api_data | text | 65535 | √ | null | ||
eapm | application | varchar | 100 | √ | webex | ||
kbcontents | approved | bit | 1 | √ | 0 | ||
campaign_log | archived | bit | 1 | √ | 0 | ||
workflow_alerts | array_type | varchar | 100 | √ | null | ||
pmse_bpmn_artifact | art_category_ref | varchar | 32 | √ | |||
pmse_bpmn_artifact | art_type | varchar | 15 | √ | |||
pmse_bpmn_artifact | art_uid | varchar | 36 | √ | |||
products | asset_number | varchar | 50 | √ | null | ||
purchased_line_items | asset_number | varchar | 50 | √ | null | ||
revenue_line_items | 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 | ||
business_centers | 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 | ||
dashboards | assigned_user_id | char | 36 | √ | null | ||
data_privacy | 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 | ||
filters | 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 | ||
import_maps | assigned_user_id | char | 36 | √ | null | ||
job_queue | assigned_user_id | char | 36 | √ | null | ||
kbarticles | assigned_user_id | char | 36 | √ | null | ||
kbcontents | 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 | ||
messages | 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 | ||
opportunities | assigned_user_id | char | 36 | √ | null | ||
pdfmanager | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_activity_definition | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_activity_step | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_activity_user | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_config | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_dynamic_forms | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_event_definition | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_flow | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_form_action | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_gateway_definition | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_group | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_group_user | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_notes | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_process_definition | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_related_dependency | assigned_user_id | char | 36 | √ | null | ||
pmse_bpm_thread | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_activity | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_artifact | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_bound | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_data | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_diagram | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_documentation | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_event | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_extension | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_flow | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_gateway | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_lane | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_laneset | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_participant | assigned_user_id | char | 36 | √ | null | ||
pmse_bpmn_process | assigned_user_id | char | 36 | √ | null | ||
pmse_business_rules | assigned_user_id | char | 36 | √ | null | ||
pmse_emails_templates | assigned_user_id | char | 36 | √ | null | ||
pmse_inbox | assigned_user_id | char | 36 | √ | null | ||
pmse_project | assigned_user_id | char | 36 | √ | null | ||
product_categories | assigned_user_id | char | 36 | √ | null | ||
product_templates | assigned_user_id | char | 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 | ||
purchased_line_items | assigned_user_id | char | 36 | √ | null | ||
purchases | assigned_user_id | char | 36 | √ | null | ||
quotas | assigned_user_id | char | 36 | √ | null | ||
quotes | assigned_user_id | char | 36 | √ | null | ||
record_list | assigned_user_id | char | 36 | ||||
report_cache | assigned_user_id | char | 36 | ||||
report_schedules | assigned_user_id | char | 36 | √ | null | ||
revenue_line_items | assigned_user_id | char | 36 | √ | null | ||
saved_reports | assigned_user_id | char | 36 | √ | null | ||
saved_search | assigned_user_id | char | 36 | √ | null | ||
shift_exceptions | assigned_user_id | char | 36 | √ | null | ||
shifts | assigned_user_id | char | 36 | √ | null | ||
styleguide | assigned_user_id | char | 36 | √ | null | ||
sugarfavorites | assigned_user_id | char | 36 | √ | null | ||
tags | 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 | ||
styleguide | assistant | varchar | 75 | √ | null | ||
contacts | assistant_phone | varchar | 100 | √ | null | ||
leads | assistant_phone | varchar | 100 | √ | null | ||
prospects | assistant_phone | varchar | 100 | √ | null | ||
styleguide | assistant_phone | varchar | 100 | √ | null | ||
teams | associated_user_id | char | 36 | √ | null | ||
dataset_attributes | attribute_type | varchar | 8 | √ | null | ||
fields_meta_data | audited | bit | 1 | √ | 0 | ||
inbound_email | auth_type | varchar | 10 | √ | null | ||
users | authenticate_id | varchar | 100 | √ | null | ||
pdfmanager | author | varchar | 255 | √ | SugarCRM | ||
inbound_email | authorized_account | varchar | 255 | √ | null | ||
outbound_email | authorized_account | varchar | 255 | √ | null | ||
fields_meta_data | autoinc_next | int | 11 | √ | null | ||
inbound_email_autoreply | autoreplied_to | varchar | 100 | √ | null | ||
visual_pipeline | available_columns | text | 65535 | √ | null | ||
email_templates | base_module | varchar | 50 | √ | null | ||
pdfmanager | base_module | varchar | 100 | √ | |||
pmse_emails_templates | base_module | varchar | 100 | √ | null | ||
workflow | base_module | varchar | 50 | √ | null | ||
campaigns | base_rate | decimal | 26,6 | √ | null | ||
contracts | base_rate | decimal | 26,6 | √ | null | ||
forecast_manager_worksheets | base_rate | decimal | 26,6 | √ | null | ||
forecast_worksheets | base_rate | decimal | 26,6 | √ | null | ||
forecasts | base_rate | decimal | 26,6 | √ | null | ||
opportunities | base_rate | decimal | 26,6 | √ | null | ||
product_bundles | base_rate | decimal | 26,6 | √ | null | ||
product_templates | base_rate | decimal | 26,6 | √ | null | ||
products | base_rate | decimal | 26,6 | √ | null | ||
purchased_line_items | base_rate | decimal | 26,6 | √ | null | ||
quotas | base_rate | decimal | 26,6 | √ | null | ||
quotes | base_rate | decimal | 26,6 | √ | null | ||
revenue_line_items | base_rate | decimal | 26,6 | √ | null | ||
emails_text | bcc_addrs | text | 65535 | √ | null | ||
pmse_email_message | 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 | ||||
custom_fields | bean_id | char | 36 | √ | null | ||
email_addr_bean_rel | bean_id | char | 36 | ||||
emails_beans | bean_id | char | 36 | √ | null | ||
erased_fields | bean_id | char | 36 | ||||
fts_queue | bean_id | char | 36 | √ | null | ||
locked_field_bean_rel | bean_id | char | 36 | ||||
tag_bean_rel | bean_id | char | 36 | ||||
users_last_import | bean_id | char | 36 | √ | null | ||
users_password_link | 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 | ||
locked_field_bean_rel | bean_module | varchar | 100 | √ | null | ||
tag_bean_rel | bean_module | varchar | 100 | √ | null | ||
users_last_import | bean_type | varchar | 36 | √ | null | ||
users_password_link | bean_type | varchar | 36 | √ | User | ||
accounts_audit | before_value_string | varchar | 255 | √ | null | ||
bugs_audit | before_value_string | varchar | 255 | √ | null | ||
business_centers_audit | before_value_string | varchar | 255 | √ | null | ||
calls_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 | ||
data_privacy_audit | before_value_string | varchar | 255 | √ | null | ||
email_addresses_audit | before_value_string | varchar | 255 | √ | null | ||
forecast_manager_worksheets_audit | before_value_string | varchar | 255 | √ | null | ||
kbcontent_templates_audit | before_value_string | varchar | 255 | √ | null | ||
kbcontents_audit | before_value_string | varchar | 255 | √ | null | ||
leads_audit | before_value_string | varchar | 255 | √ | null | ||
meetings_audit | before_value_string | varchar | 255 | √ | null | ||
messages_audit | before_value_string | varchar | 255 | √ | null | ||
notes_audit | before_value_string | varchar | 255 | √ | null | ||
opportunities_audit | before_value_string | varchar | 255 | √ | null | ||
product_templates_audit | before_value_string | varchar | 255 | √ | null | ||
products_audit | before_value_string | varchar | 255 | √ | null | ||
project_task_audit | before_value_string | varchar | 255 | √ | null | ||
prospects_audit | before_value_string | varchar | 255 | √ | null | ||
purchased_line_items_audit | before_value_string | varchar | 255 | √ | null | ||
purchases_audit | before_value_string | varchar | 255 | √ | null | ||
quotas_audit | before_value_string | varchar | 255 | √ | null | ||
quotes_audit | before_value_string | varchar | 255 | √ | null | ||
report_schedules_audit | before_value_string | varchar | 255 | √ | null | ||
revenue_line_items_audit | before_value_string | varchar | 255 | √ | null | ||
shift_exceptions_audit | before_value_string | varchar | 255 | √ | null | ||
shifts_audit | before_value_string | varchar | 255 | √ | null | ||
tags_audit | before_value_string | varchar | 255 | √ | null | ||
tasks_audit | before_value_string | varchar | 255 | √ | null | ||
accounts_audit | before_value_text | text | 65535 | √ | null | ||
bugs_audit | before_value_text | text | 65535 | √ | null | ||
business_centers_audit | before_value_text | text | 65535 | √ | null | ||
calls_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 | ||
data_privacy_audit | before_value_text | text | 65535 | √ | null | ||
email_addresses_audit | before_value_text | text | 65535 | √ | null | ||
forecast_manager_worksheets_audit | before_value_text | text | 65535 | √ | null | ||
kbcontent_templates_audit | before_value_text | text | 65535 | √ | null | ||
kbcontents_audit | before_value_text | text | 65535 | √ | null | ||
leads_audit | before_value_text | text | 65535 | √ | null | ||
meetings_audit | before_value_text | text | 65535 | √ | null | ||
messages_audit | before_value_text | text | 65535 | √ | null | ||
notes_audit | before_value_text | text | 65535 | √ | null | ||
opportunities_audit | before_value_text | text | 65535 | √ | null | ||
product_templates_audit | before_value_text | text | 65535 | √ | null | ||
products_audit | before_value_text | text | 65535 | √ | null | ||
project_task_audit | before_value_text | text | 65535 | √ | null | ||
prospects_audit | before_value_text | text | 65535 | √ | null | ||
purchased_line_items_audit | before_value_text | text | 65535 | √ | null | ||
purchases_audit | before_value_text | text | 65535 | √ | null | ||
quotas_audit | before_value_text | text | 65535 | √ | null | ||
quotes_audit | before_value_text | text | 65535 | √ | null | ||
report_schedules_audit | before_value_text | text | 65535 | √ | null | ||
revenue_line_items_audit | before_value_text | text | 65535 | √ | null | ||
shift_exceptions_audit | before_value_text | text | 65535 | √ | null | ||
shifts_audit | before_value_text | text | 65535 | √ | null | ||
tags_audit | before_value_text | text | 65535 | √ | null | ||
tasks_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 | ||
revenue_line_items | best_case | decimal | 26,6 | √ | null | ||
forecast_manager_worksheets | best_case_adjusted | decimal | 26,6 | √ | null | ||
dataset_attributes | bg_color | varchar | 25 | √ | 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 | ||
styleguide | birthdate | date | 10 | √ | null | ||
email_templates | body | text | 65535 | √ | null | ||
kbcontent_templates | body | longtext | 2147483647 | √ | null | ||
pmse_email_message | body | longtext | 2147483647 | √ | null | ||
pmse_emails_templates | body | text | 65535 | √ | null | ||
data_sets | body_back_color | varchar | 100 | √ | null | ||
email_templates | body_html | text | 65535 | √ | null | ||
pdfmanager | body_html | text | 65535 | √ | null | ||
pmse_email_message | body_html | longtext | 2147483647 | √ | null | ||
pmse_emails_templates | body_html | text | 65535 | √ | null | ||
data_sets | body_text_color | varchar | 100 | √ | null | ||
products | book_value | decimal | 26,6 | √ | null | ||
purchased_line_items | book_value | decimal | 26,6 | √ | null | ||
revenue_line_items | book_value | decimal | 26,6 | √ | null | ||
products | book_value_date | date | 10 | √ | null | ||
purchased_line_items | book_value_date | date | 10 | √ | null | ||
revenue_line_items | book_value_date | date | 10 | √ | null | ||
products | book_value_usdollar | decimal | 26,6 | √ | null | ||
purchased_line_items | book_value_usdollar | decimal | 26,6 | √ | null | ||
revenue_line_items | book_value_usdollar | decimal | 26,6 | √ | null | ||
pmse_bpmn_bound | bou_container | varchar | 30 | √ | |||
pmse_bpmn_bound | bou_element | varchar | 36 | √ | |||
pmse_bpmn_bound | bou_element_type | varchar | 32 | √ | |||
pmse_bpmn_bound | bou_height | int | 4 | √ | 0 | ||
pmse_bpmn_bound | bou_rel_position | int | 4 | √ | 0 | ||
pmse_bpmn_bound | bou_size_identical | int | 4 | √ | 0 | ||
pmse_bpmn_bound | bou_uid | varchar | 36 | √ | |||
pmse_bpmn_bound | bou_width | int | 4 | √ | 0 | ||
pmse_bpmn_bound | bou_x | int | 4 | √ | 0 | ||
pmse_bpmn_bound | bou_y | int | 4 | √ | 0 | ||
pmse_bpm_flow | bpmn_id | varchar | 36 | √ | |||
pmse_bpm_flow | bpmn_type | varchar | 32 | √ | |||
campaigns | budget | decimal | 26,6 | √ | null | ||
accounts_bugs | bug_id | char | 36 | √ | null | ||
cases_bugs | bug_id | char | 36 | √ | null | ||
contacts_bugs | bug_id | char | 36 | √ | null | ||
documents_bugs | bug_id | char | 36 | √ | null | ||
projects_bugs | bug_id | char | 36 | √ | null | ||
bugs | bug_number | int | 11 | √ | |||
product_bundle_note | bundle_id | char | 36 | √ | null | ||
product_bundle_product | bundle_id | char | 36 | √ | null | ||
product_bundle_quote | bundle_id | char | 36 | √ | null | ||
product_bundle_quote | bundle_index | int | 11 | √ | 0 | ||
product_bundles | bundle_stage | varchar | 255 | √ | null | ||
accounts | business_center_id | char | 36 | √ | null | ||
business_centers_holidays | business_center_id | char | 36 | √ | null | ||
cases | business_center_id | char | 36 | √ | null | ||
contacts | business_center_id | char | 36 | √ | null | ||
leads | business_center_id | char | 36 | √ | null | ||
users | business_center_id | char | 36 | √ | null | ||
changetimers | business_hours | decimal | 12,2 | √ | null | ||
bugs | business_hours_to_resolution | decimal | 12,2 | √ | null | ||
cases | business_hours_to_resolution | decimal | 12,2 | √ | null | ||
data_privacy | business_hours_to_resolution | decimal | 12,2 | √ | null | ||
cases | business_hrs_to_first_response | decimal | 12,2 | √ | null | ||
data_privacy | business_purpose | text | 65535 | √ | null | ||
oauth_consumer | c_key | varchar | 255 | √ | null | ||
oauth_consumer | c_secret | varchar | 255 | √ | null | ||
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 | ||
forecast_worksheets | campaign_id | char | 36 | √ | null | ||
leads | campaign_id | char | 36 | √ | null | ||
opportunities | campaign_id | char | 36 | √ | null | ||
products | campaign_id | char | 36 | √ | null | ||
prospect_list_campaigns | campaign_id | char | 36 | √ | null | ||
prospects | campaign_id | char | 36 | √ | null | ||
revenue_line_items | campaign_id | char | 36 | √ | null | ||
forecast_worksheets | campaign_name | varchar | 255 | √ | null | ||
campaigns | campaign_type | varchar | 100 | √ | null | ||
pmse_bpm_flow | cas_adhoc_actions | varchar | 255 | √ | |||
pmse_bpm_flow | cas_adhoc_parent_id | varchar | 40 | √ | |||
pmse_bpm_flow | cas_adhoc_type | varchar | 40 | √ | |||
pmse_inbox | cas_assigned_status | varchar | 12 | √ | UNASSIGNED | ||
pmse_bpm_flow | cas_assignment_method | varchar | 32 | √ | |||
pmse_inbox | cas_create_date | datetime | 19 | √ | null | ||
pmse_inbox | cas_custom_status | varchar | 32 | √ | null | ||
pmse_bpm_flow | cas_delay_duration | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_delayed | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_delegate_date | datetime | 19 | √ | null | ||
pmse_bpm_flow | cas_due_date | datetime | 19 | √ | null | ||
pmse_bpm_flow | cas_duration | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_finish_date | datetime | 19 | √ | null | ||
pmse_inbox | cas_finish_date | datetime | 19 | √ | null | ||
pmse_bpm_flow | cas_finished | int | 4 | √ | 0 | ||
pmse_bpm_thread | cas_flow_index | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_flow_status | varchar | 32 | √ | OPEN | ||
pmse_bpm_flow | cas_id | int | 4 | √ | null | ||
pmse_bpm_form_action | cas_id | int | 4 | √ | null | ||
pmse_bpm_notes | cas_id | varchar | 36 | √ | |||
pmse_bpm_thread | cas_id | int | 4 | √ | 0 | ||
pmse_inbox | cas_id | int | 11 | √ | |||
pmse_bpm_flow | cas_index | int | 4 | √ | null | ||
pmse_bpm_notes | cas_index | int | 4 | √ | null | ||
pmse_inbox | cas_init_user | varchar | 36 | √ | null | ||
pmse_inbox | cas_module | varchar | 100 | √ | null | ||
pmse_inbox | cas_parent | int | 11 | √ | null | ||
pmse_inbox | cas_pin | varchar | 10 | √ | 0000 | ||
pmse_bpm_flow | cas_previous | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_queue_duration | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_reassign_level | int | 4 | √ | 0 | ||
pmse_bpm_flow | cas_start_date | datetime | 19 | √ | null | ||
pmse_bpm_flow | cas_started | int | 4 | √ | 0 | ||
pmse_inbox | cas_status | varchar | 32 | √ | IN PROGRESS | ||
pmse_bpm_flow | cas_sugar_action | varchar | 40 | √ | DetailView | ||
pmse_bpm_flow | cas_sugar_module | varchar | 128 | √ | |||
pmse_bpm_flow | cas_sugar_object_id | varchar | 40 | √ | |||
pmse_bpm_flow | cas_task_start_date | datetime | 19 | √ | null | ||
pmse_bpm_flow | cas_thread | int | 4 | √ | 0 | ||
pmse_bpm_thread | cas_thread_index | int | 4 | √ | 0 | ||
pmse_bpm_thread | cas_thread_parent | int | 4 | √ | 0 | ||
pmse_bpm_thread | cas_thread_passes | int | 4 | √ | 0 | ||
pmse_bpm_thread | cas_thread_status | varchar | 32 | √ | OPEN | ||
pmse_bpm_thread | cas_thread_tokens | int | 4 | √ | 0 | ||
pmse_inbox | cas_title | varchar | 255 | √ | null | ||
pmse_inbox | cas_update_date | datetime | 19 | √ | null | ||
pmse_bpm_flow | cas_user_id | varchar | 40 | √ | |||
accounts_cases | case_id | char | 36 | √ | null | ||
cases_bugs | case_id | char | 36 | √ | null | ||
cases_purchases | case_id | char | 36 | √ | null | ||
contacts_cases | case_id | char | 36 | √ | null | ||
documents_cases | case_id | char | 36 | √ | null | ||
projects_cases | case_id | char | 36 | √ | null | ||
cases | case_number | int | 11 | √ | |||
products | catalog_service_duration_unit | varchar | 50 | √ | null | ||
purchased_line_items | catalog_service_duration_unit | varchar | 50 | √ | null | ||
revenue_line_items | catalog_service_duration_unit | varchar | 50 | √ | null | ||
products | catalog_service_duration_value | int | 5 | √ | null | ||
purchased_line_items | catalog_service_duration_value | int | 5 | √ | null | ||
revenue_line_items | catalog_service_duration_value | int | 5 | √ | null | ||
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 | ||
forecast_worksheets | category_id | char | 36 | √ | null | ||
kbcontents | category_id | char | 36 | √ | null | ||
product_templates | category_id | char | 36 | √ | null | ||
products | category_id | char | 36 | √ | null | ||
purchased_line_items | category_id | char | 36 | √ | null | ||
purchases | category_id | char | 36 | √ | null | ||
revenue_line_items | category_id | char | 36 | √ | null | ||
forecast_worksheets | category_name | varchar | 255 | √ | null | ||
emails_text | cc_addrs | text | 65535 | √ | null | ||
pmse_email_message | cc_addrs | text | 65535 | √ | null | ||
dataset_attributes | cell_size | varchar | 3 | √ | null | ||
pmse_bpm_config | cfg_status | varchar | 20 | √ | ACTIVE | ||
pmse_bpm_config | cfg_value | text | 65535 | √ | null | ||
document_revisions | change_log | varchar | 255 | √ | null | ||
messages | channel_type | varchar | 50 | √ | null | ||
saved_reports | chart_type | varchar | 36 | √ | none | ||
product_product | child_id | char | 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 | ||
opportunities | closed_revenue_line_items | int | 11 | √ | null | ||
activities | comment_count | int | 11 | √ | 0 | ||
commentlog_rel | commentlog_id | char | 36 | ||||
fields_meta_data | comments | varchar | 255 | √ | null | ||
forecast_worksheets | commit_stage | varchar | 50 | √ | null | ||
opportunities | commit_stage | varchar | 50 | √ | null | ||
revenue_line_items | commit_stage | varchar | 50 | √ | exclude | ||
quotas | committed | bit | 1 | √ | 0 | ||
contracts | company_signed_date | date | 10 | √ | null | ||
email_addresses | confirmation_requested_on | datetime | 19 | √ | 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 | char | 36 | √ | null | ||
calls_contacts | contact_id | char | 36 | √ | null | ||
contacts_bugs | contact_id | char | 36 | √ | null | ||
contacts_cases | contact_id | char | 36 | √ | null | ||
contacts_dataprivacy | contact_id | char | 36 | √ | null | ||
contacts_purchases | contact_id | char | 36 | √ | null | ||
contacts_users | contact_id | char | 36 | √ | null | ||
contracts_contacts | contact_id | char | 36 | √ | null | ||
documents_contacts | contact_id | char | 36 | √ | null | ||
kbusefulness | contact_id | char | 36 | √ | null | ||
leads | contact_id | char | 36 | √ | null | ||
meetings_contacts | contact_id | char | 36 | √ | null | ||
messages | contact_id | char | 36 | √ | null | ||
notes | contact_id | char | 36 | √ | null | ||
oauth_tokens | contact_id | char | 36 | √ | null | ||
opportunities_contacts | contact_id | char | 36 | √ | null | ||
products | contact_id | char | 36 | √ | null | ||
projects_contacts | contact_id | char | 36 | √ | null | ||
quotes_contacts | contact_id | char | 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 | char | 36 | √ | null | ||
contracts_opportunities | contract_id | char | 36 | √ | null | ||
contracts_products | contract_id | char | 36 | √ | null | ||
contracts_quotes | contract_id | char | 36 | √ | null | ||
messages | conversation | longtext | 2147483647 | √ | null | ||
messages | conversation_link | varchar | 512 | √ | null | ||
currencies | conversion_rate | decimal | 26,6 | √ | 0.000000 | ||
leads | converted | bit | 1 | √ | 0 | ||
contacts | cookie_consent | bit | 1 | √ | 0 | ||
users | cookie_consent | bit | 1 | √ | 0 | ||
contacts | cookie_consent_received_on | datetime | 19 | √ | null | ||
users | cookie_consent_received_on | datetime | 19 | √ | null | ||
forecast_worksheets | cost_price | decimal | 26,6 | √ | null | ||
product_templates | cost_price | decimal | 26,6 | √ | null | ||
products | cost_price | decimal | 26,6 | √ | null | ||
purchased_line_items | cost_price | decimal | 26,6 | √ | null | ||
revenue_line_items | cost_price | decimal | 26,6 | √ | null | ||
product_templates | cost_usdollar | decimal | 26,6 | √ | null | ||
products | cost_usdollar | decimal | 26,6 | √ | null | ||
purchased_line_items | cost_usdollar | decimal | 26,6 | √ | null | ||
revenue_line_items | 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_role_sets | created_by | char | 36 | √ | null | ||
acl_roles | created_by | char | 36 | √ | null | ||
activities | created_by | char | 36 | √ | null | ||
bugs | created_by | char | 36 | √ | null | ||
bugs_audit | created_by | char | 36 | √ | null | ||
business_centers | created_by | char | 36 | √ | null | ||
business_centers_audit | created_by | char | 36 | √ | null | ||
calls | created_by | char | 36 | √ | null | ||
calls_audit | 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 | ||
categories | created_by | char | 36 | √ | null | ||
changetimers | created_by | char | 36 | √ | null | ||
commentlog | created_by | char | 36 | √ | null | ||
comments | created_by | char | 36 | √ | null | ||
console_configuration | 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 | ||||
custom_queries | created_by | char | 36 | √ | null | ||
dashboards | created_by | char | 36 | √ | null | ||
data_privacy | created_by | char | 36 | √ | null | ||
data_privacy_audit | created_by | char | 36 | √ | null | ||
data_sets | created_by | char | 36 | √ | null | ||
dataset_attributes | created_by | char | 36 | √ | null | ||
dataset_layouts | created_by | char | 36 | √ | null | ||
document_revisions | created_by | char | 36 | √ | null | ||
documents | created_by | char | 36 | √ | null | ||
eapm | created_by | char | 36 | √ | null | ||
email_addresses_audit | created_by | char | 36 | √ | null | ||
email_marketing | created_by | char | 36 | √ | null | ||
email_templates | created_by | char | 36 | √ | null | ||
emails | created_by | char | 36 | √ | null | ||
embedded_files | created_by | char | 36 | √ | null | ||
expressions | created_by | char | 36 | √ | null | ||
filters | created_by | char | 36 | √ | null | ||
folders | created_by | char | 36 | ||||
forecast_manager_worksheets | created_by | char | 36 | √ | null | ||
forecast_manager_worksheets_audit | created_by | char | 36 | √ | null | ||
forecast_worksheets | created_by | char | 36 | √ | null | ||
holidays | created_by | char | 36 | √ | null | ||
inbound_email | created_by | char | 36 | √ | null | ||
kbarticles | created_by | char | 36 | √ | null | ||
kbcontent_templates | created_by | char | 36 | √ | null | ||
kbcontent_templates_audit | created_by | char | 36 | √ | null | ||
kbcontents | created_by | char | 36 | √ | null | ||
kbcontents_audit | created_by | char | 36 | √ | null | ||
kbdocuments | 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 | ||
meetings_audit | created_by | char | 36 | √ | null | ||
messages | created_by | char | 36 | √ | null | ||
messages_audit | created_by | char | 36 | √ | null | ||
notes | created_by | char | 36 | √ | null | ||
notes_audit | created_by | char | 36 | √ | null | ||
notifications | created_by | char | 36 | √ | null | ||
oauth_consumer | created_by | char | 36 | √ | null | ||
opportunities | created_by | char | 36 | √ | null | ||
opportunities_audit | created_by | char | 36 | √ | null | ||
pdfmanager | created_by | char | 36 | √ | null | ||
pmse_bpm_activity_definition | created_by | char | 36 | √ | null | ||
pmse_bpm_activity_step | created_by | char | 36 | √ | null | ||
pmse_bpm_activity_user | created_by | char | 36 | √ | null | ||
pmse_bpm_config | created_by | char | 36 | √ | null | ||
pmse_bpm_dynamic_forms | created_by | char | 36 | √ | null | ||
pmse_bpm_event_definition | created_by | char | 36 | √ | null | ||
pmse_bpm_flow | created_by | char | 36 | √ | null | ||
pmse_bpm_form_action | created_by | char | 36 | √ | null | ||
pmse_bpm_gateway_definition | created_by | char | 36 | √ | null | ||
pmse_bpm_group | created_by | char | 36 | √ | null | ||
pmse_bpm_group_user | created_by | char | 36 | √ | null | ||
pmse_bpm_notes | created_by | char | 36 | √ | null | ||
pmse_bpm_process_definition | created_by | char | 36 | √ | null | ||
pmse_bpm_related_dependency | created_by | char | 36 | √ | null | ||
pmse_bpm_thread | created_by | char | 36 | √ | null | ||
pmse_bpmn_activity | created_by | char | 36 | √ | null | ||
pmse_bpmn_artifact | created_by | char | 36 | √ | null | ||
pmse_bpmn_bound | created_by | char | 36 | √ | null | ||
pmse_bpmn_data | created_by | char | 36 | √ | null | ||
pmse_bpmn_diagram | created_by | char | 36 | √ | null | ||
pmse_bpmn_documentation | created_by | char | 36 | √ | null | ||
pmse_bpmn_event | created_by | char | 36 | √ | null | ||
pmse_bpmn_extension | created_by | char | 36 | √ | null | ||
pmse_bpmn_flow | created_by | char | 36 | √ | null | ||
pmse_bpmn_gateway | created_by | char | 36 | √ | null | ||
pmse_bpmn_lane | created_by | char | 36 | √ | null | ||
pmse_bpmn_laneset | created_by | char | 36 | √ | null | ||
pmse_bpmn_participant | created_by | char | 36 | √ | null | ||
pmse_bpmn_process | created_by | char | 36 | √ | null | ||
pmse_business_rules | created_by | char | 36 | √ | null | ||
pmse_email_message | created_by | char | 36 | √ | null | ||
pmse_emails_templates | created_by | char | 36 | √ | null | ||
pmse_inbox | created_by | char | 36 | √ | null | ||
pmse_project | 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_templates_audit | 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 | ||
prospects_audit | created_by | char | 36 | √ | null | ||
purchased_line_items | created_by | char | 36 | √ | null | ||
purchased_line_items_audit | created_by | char | 36 | √ | null | ||
purchases | created_by | char | 36 | √ | null | ||
purchases_audit | created_by | char | 36 | √ | null | ||
quotas | created_by | char | 36 | √ | null | ||
quotas_audit | created_by | char | 36 | √ | null | ||
quotes | created_by | char | 36 | √ | null | ||
quotes_audit | created_by | char | 36 | √ | null | ||
releases | created_by | char | 36 | √ | null | ||
report_maker | created_by | char | 36 | √ | null | ||
report_schedules | created_by | char | 36 | √ | null | ||
report_schedules_audit | created_by | char | 36 | √ | null | ||
revenue_line_items | created_by | char | 36 | √ | null | ||
revenue_line_items_audit | created_by | char | 36 | √ | null | ||
roles | created_by | char | 36 | √ | null | ||
saved_reports | created_by | char | 36 | √ | null | ||
schedulers | created_by | char | 36 | √ | null | ||
shift_exceptions | created_by | char | 36 | √ | null | ||
shift_exceptions_audit | created_by | char | 36 | √ | null | ||
shifts | created_by | char | 36 | √ | null | ||
shifts_audit | created_by | char | 36 | √ | null | ||
shippers | created_by | char | 36 | √ | null | ||
styleguide | created_by | char | 36 | √ | null | ||
subscriptions | created_by | char | 36 | √ | null | ||
sugarfavorites | created_by | char | 36 | √ | null | ||
tags | created_by | char | 36 | √ | null | ||
tags_audit | created_by | char | 36 | √ | null | ||
tasks | created_by | char | 36 | √ | null | ||
tasks_audit | 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 | char | 36 | √ | null | ||
users | created_by | char | 36 | √ | null | ||
users_signatures | created_by | char | 36 | √ | null | ||
versions | created_by | char | 36 | √ | null | ||
visual_pipeline | created_by | char | 36 | √ | null | ||
weblogichooks | 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 | ||
campaigns | currency_id | char | 36 | √ | -99 | ||
contracts | currency_id | char | 36 | √ | -99 | ||
forecast_manager_worksheets | currency_id | char | 36 | √ | -99 | ||
forecast_worksheets | currency_id | char | 36 | √ | -99 | ||
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 | ||
purchased_line_items | currency_id | char | 36 | √ | -99 | ||
quotas | currency_id | char | 36 | √ | -99 | ||
quotes | currency_id | char | 36 | √ | -99 | ||
revenue_line_items | currency_id | char | 36 | √ | -99 | ||
styleguide | currency_id | char | 36 | √ | -99 | ||
data_sets | custom_layout | varchar | 10 | √ | null | ||
fields_meta_data | custom_module | varchar | 255 | √ | null | ||
custom_queries | custom_query | text | 65535 | √ | null | ||
workflow_alertshells | custom_template_id | char | 36 | √ | null | ||
contracts | customer_signed_date | date | 10 | √ | null | ||
dashboards | dashboard_module | varchar | 100 | √ | null | ||
pmse_bpmn_data | dat_capacity | int | 4 | √ | 0 | ||
pmse_bpmn_data | dat_is_collection | int | 4 | √ | 0 | ||
pmse_bpmn_data | dat_is_global | int | 4 | √ | 0 | ||
pmse_bpmn_data | dat_is_unlimited | int | 4 | √ | 0 | ||
pmse_bpmn_data | dat_item_kind | varchar | 20 | √ | INFORMATION | ||
pmse_bpmn_data | dat_object_ref | int | 4 | √ | null | ||
pmse_bpmn_data | dat_state | varchar | 255 | √ | |||
pmse_bpmn_data | dat_type | varchar | 20 | √ | |||
pmse_bpmn_data | dat_uid | varchar | 36 | √ | |||
activities | data | longtext | 2147483647 | √ | null | ||
comments | data | longtext | 2147483647 | √ | null | ||
erased_fields | data | text | 65535 | √ | null | ||
job_queue | data | longtext | 2147483647 | √ | null | ||
metadata_cache | data | longblob | 2147483647 | √ | null | ||
product_definition | data | text | 65535 | √ | null | ||
accounts_audit | data_type | varchar | 100 | √ | null | ||
bugs_audit | data_type | varchar | 100 | √ | null | ||
business_centers_audit | data_type | varchar | 100 | √ | null | ||
calls_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 | ||
data_privacy_audit | data_type | varchar | 100 | √ | null | ||
email_addresses_audit | data_type | varchar | 100 | √ | null | ||
forecast_manager_worksheets_audit | data_type | varchar | 100 | √ | null | ||
kbcontent_templates_audit | data_type | varchar | 100 | √ | null | ||
kbcontents_audit | data_type | varchar | 100 | √ | null | ||
leads_audit | data_type | varchar | 100 | √ | null | ||
meetings_audit | data_type | varchar | 100 | √ | null | ||
messages_audit | data_type | varchar | 100 | √ | null | ||
notes_audit | data_type | varchar | 100 | √ | null | ||
opportunities_audit | data_type | varchar | 100 | √ | null | ||
product_templates_audit | data_type | varchar | 100 | √ | null | ||
products_audit | data_type | varchar | 100 | √ | null | ||
project_task_audit | data_type | varchar | 100 | √ | null | ||
prospects_audit | data_type | varchar | 100 | √ | null | ||
purchased_line_items_audit | data_type | varchar | 100 | √ | null | ||
purchases_audit | data_type | varchar | 100 | √ | null | ||
quotas_audit | data_type | varchar | 100 | √ | null | ||
quotes_audit | data_type | varchar | 100 | √ | null | ||
report_schedules_audit | data_type | varchar | 100 | √ | null | ||
revenue_line_items_audit | data_type | varchar | 100 | √ | null | ||
shift_exceptions_audit | data_type | varchar | 100 | √ | null | ||
shifts_audit | data_type | varchar | 100 | √ | null | ||
tags_audit | data_type | varchar | 100 | √ | null | ||
tasks_audit | data_type | varchar | 100 | √ | null | ||
accounts_dataprivacy | dataprivacy_id | char | 36 | √ | null | ||
contacts_dataprivacy | dataprivacy_id | char | 36 | √ | null | ||
leads_dataprivacy | dataprivacy_id | char | 36 | √ | null | ||
prospects_dataprivacy | dataprivacy_id | char | 36 | √ | null | ||
data_privacy | dataprivacy_number | int | 11 | √ | |||
product_templates | date_available | date | 10 | √ | null | ||
data_privacy | date_closed | date | 10 | √ | null | ||
forecast_worksheets | date_closed | date | 10 | √ | null | ||
opportunities | date_closed | date | 10 | √ | null | ||
products | date_closed | date | 10 | √ | null | ||
purchased_line_items | date_closed | date | 10 | √ | null | ||
revenue_line_items | date_closed | date | 10 | √ | null | ||
forecast_worksheets | date_closed_timestamp | bigint unsigned | 20 | √ | null | ||
opportunities | date_closed_timestamp | bigint unsigned | 20 | √ | null | ||
products | date_closed_timestamp | bigint unsigned | 20 | √ | null | ||
purchased_line_items | date_closed_timestamp | bigint unsigned | 20 | √ | null | ||
revenue_line_items | date_closed_timestamp | bigint unsigned | 20 | √ | null | ||
product_templates | date_cost_price | date | 10 | √ | null | ||
accounts_audit | date_created | datetime | 19 | √ | null | ||
audit_events | date_created | datetime | 19 | √ | null | ||
bugs_audit | date_created | datetime | 19 | √ | null | ||
business_centers_audit | date_created | datetime | 19 | √ | null | ||
calls_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 | ||
data_privacy_audit | date_created | datetime | 19 | √ | null | ||
email_addr_bean_rel | date_created | datetime | 19 | √ | null | ||
email_addresses | date_created | datetime | 19 | √ | null | ||
email_addresses_audit | date_created | datetime | 19 | √ | null | ||
forecast_manager_worksheets_audit | date_created | datetime | 19 | √ | null | ||
fts_queue | date_created | datetime | 19 | √ | null | ||
kbcontent_templates_audit | date_created | datetime | 19 | √ | null | ||
kbcontents_audit | date_created | datetime | 19 | √ | null | ||
leads_audit | date_created | datetime | 19 | √ | null | ||
meetings_audit | date_created | datetime | 19 | √ | null | ||
messages_audit | date_created | datetime | 19 | √ | null | ||
notes_audit | date_created | datetime | 19 | √ | null | ||
opportunities_audit | date_created | datetime | 19 | √ | null | ||
product_templates_audit | date_created | datetime | 19 | √ | null | ||
products_audit | date_created | datetime | 19 | √ | null | ||
project_task_audit | date_created | datetime | 19 | √ | null | ||
prospects_audit | date_created | datetime | 19 | √ | null | ||
purchased_line_items_audit | date_created | datetime | 19 | √ | null | ||
purchases_audit | date_created | datetime | 19 | √ | null | ||
quotas_audit | date_created | datetime | 19 | √ | null | ||
quotes_audit | date_created | datetime | 19 | √ | null | ||
report_schedules_audit | date_created | datetime | 19 | √ | null | ||
revenue_line_items_audit | date_created | datetime | 19 | √ | null | ||
shift_exceptions_audit | date_created | datetime | 19 | √ | null | ||
shifts_audit | date_created | datetime | 19 | √ | null | ||
tags_audit | date_created | datetime | 19 | √ | null | ||
tasks_audit | date_created | datetime | 19 | √ | null | ||
team_set_events | date_created | datetime | 19 | √ | null | ||
data_privacy | date_due | date | 10 | √ | 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 | ||
messages | date_end | datetime | 19 | √ | null | ||
shifts | date_end | date | 10 | √ | 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_role_sets | date_entered | datetime | 19 | √ | null | ||
acl_roles | date_entered | datetime | 19 | √ | null | ||
activities | date_entered | datetime | 19 | √ | null | ||
bugs | date_entered | datetime | 19 | √ | null | ||
business_centers | 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 | ||
categories | date_entered | datetime | 19 | √ | null | ||
changetimers | date_entered | datetime | 19 | √ | null | ||
commentlog | date_entered | datetime | 19 | √ | null | ||
comments | date_entered | datetime | 19 | √ | null | ||
console_configuration | 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 | ||
custom_queries | date_entered | datetime | 19 | √ | null | ||
dashboards | date_entered | datetime | 19 | √ | null | ||
data_privacy | date_entered | datetime | 19 | √ | null | ||
data_sets | date_entered | datetime | 19 | √ | null | ||
dataset_attributes | date_entered | datetime | 19 | √ | null | ||
dataset_layouts | 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 | ||
emails_email_addr_rel | date_entered | datetime | 19 | √ | null | ||
embedded_files | date_entered | datetime | 19 | √ | null | ||
expressions | date_entered | datetime | 19 | √ | null | ||
filters | date_entered | datetime | 19 | √ | null | ||
forecast_manager_worksheets | 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 | ||
kbarticles | date_entered | datetime | 19 | √ | null | ||
kbcontent_templates | date_entered | datetime | 19 | √ | null | ||
kbcontents | date_entered | datetime | 19 | √ | null | ||
kbdocuments | date_entered | datetime | 19 | √ | null | ||
leads | date_entered | datetime | 19 | √ | null | ||
manufacturers | date_entered | datetime | 19 | √ | null | ||
meetings | date_entered | datetime | 19 | √ | null | ||
messages | 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 | ||
pmse_bpm_activity_definition | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_activity_step | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_activity_user | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_config | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_dynamic_forms | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_event_definition | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_flow | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_form_action | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_gateway_definition | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_group | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_group_user | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_notes | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_process_definition | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_related_dependency | date_entered | datetime | 19 | √ | null | ||
pmse_bpm_thread | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_activity | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_artifact | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_bound | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_data | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_diagram | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_documentation | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_event | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_extension | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_flow | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_gateway | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_lane | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_laneset | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_participant | date_entered | datetime | 19 | √ | null | ||
pmse_bpmn_process | date_entered | datetime | 19 | √ | null | ||
pmse_business_rules | date_entered | datetime | 19 | √ | null | ||
pmse_email_message | date_entered | datetime | 19 | √ | null | ||
pmse_emails_templates | date_entered | datetime | 19 | √ | null | ||
pmse_inbox | date_entered | datetime | 19 | √ | null | ||
pmse_project | 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 | ||
purchased_line_items | date_entered | datetime | 19 | √ | null | ||
purchases | 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 | ||
report_maker | date_entered | datetime | 19 | √ | null | ||
report_schedules | date_entered | datetime | 19 | √ | null | ||
revenue_line_items | 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 | ||
shift_exceptions | date_entered | datetime | 19 | √ | null | ||
shifts | date_entered | datetime | 19 | √ | null | ||
shippers | date_entered | datetime | 19 | √ | null | ||
styleguide | date_entered | datetime | 19 | √ | null | ||
subscriptions | date_entered | datetime | 19 | √ | null | ||
sugarfavorites | date_entered | datetime | 19 | √ | null | ||
tags | 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 | ||
visual_pipeline | date_entered | datetime | 19 | √ | null | ||
weblogichooks | 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_dataprivacy | date_modified | datetime | 19 | √ | null | ||
accounts_opportunities | date_modified | datetime | 19 | √ | null | ||
accounts_purchases | date_modified | datetime | 19 | √ | null | ||
acl_actions | date_modified | datetime | 19 | √ | null | ||
acl_fields | date_modified | datetime | 19 | √ | null | ||
acl_role_sets | date_modified | datetime | 19 | √ | null | ||
acl_role_sets_acl_roles | 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 | ||
activities | date_modified | datetime | 19 | √ | null | ||
activities_users | date_modified | datetime | 19 | √ | null | ||
bugs | date_modified | datetime | 19 | √ | null | ||
business_centers | date_modified | datetime | 19 | √ | null | ||
business_centers_holidays | 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 | ||
cases_purchases | date_modified | datetime | 19 | √ | null | ||
categories | date_modified | datetime | 19 | √ | null | ||
changetimers | date_modified | datetime | 19 | √ | null | ||
commentlog | date_modified | datetime | 19 | √ | null | ||
comments | date_modified | datetime | 19 | √ | null | ||
console_configuration | 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_dataprivacy | date_modified | datetime | 19 | √ | null | ||
contacts_purchases | 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 | ||
currencies | date_modified | datetime | 19 | √ | null | ||
custom_queries | date_modified | datetime | 19 | √ | null | ||
dashboards | date_modified | datetime | 19 | √ | null | ||
data_privacy | date_modified | datetime | 19 | √ | null | ||
data_sets | date_modified | datetime | 19 | √ | null | ||
dataset_attributes | date_modified | datetime | 19 | √ | null | ||
dataset_layouts | 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_purchasedlineitems | date_modified | datetime | 19 | √ | null | ||
documents_purchases | date_modified | datetime | 19 | √ | null | ||
documents_quotes | date_modified | datetime | 19 | √ | null | ||
documents_revenuelineitems | 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 | ||
emails_email_addr_rel | date_modified | datetime | 19 | √ | null | ||
embedded_files | date_modified | datetime | 19 | √ | null | ||
expressions | date_modified | datetime | 19 | √ | null | ||
fields_meta_data | date_modified | datetime | 19 | √ | null | ||
filters | date_modified | datetime | 19 | √ | null | ||
forecast_manager_worksheets | 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 | ||
kbarticles | date_modified | datetime | 19 | √ | null | ||
kbcontent_templates | date_modified | datetime | 19 | √ | null | ||
kbcontents | date_modified | datetime | 19 | √ | null | ||
kbdocuments | date_modified | datetime | 19 | √ | null | ||
kbusefulness | date_modified | datetime | 19 | √ | null | ||
leads | date_modified | datetime | 19 | √ | null | ||
leads_dataprivacy | date_modified | datetime | 19 | √ | null | ||
linked_documents | date_modified | datetime | 19 | √ | null | ||
locked_field_bean_rel | 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 | ||
messages | date_modified | datetime | 19 | √ | null | ||
metadata_cache | 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 | ||
pmse_bpm_activity_definition | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_activity_step | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_activity_user | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_config | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_dynamic_forms | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_event_definition | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_flow | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_form_action | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_gateway_definition | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_group | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_group_user | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_notes | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_process_definition | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_related_dependency | date_modified | datetime | 19 | √ | null | ||
pmse_bpm_thread | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_activity | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_artifact | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_bound | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_data | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_diagram | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_documentation | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_event | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_extension | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_flow | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_gateway | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_lane | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_laneset | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_participant | date_modified | datetime | 19 | √ | null | ||
pmse_bpmn_process | date_modified | datetime | 19 | √ | null | ||
pmse_business_rules | date_modified | datetime | 19 | √ | null | ||
pmse_email_message | date_modified | datetime | 19 | √ | null | ||
pmse_emails_templates | date_modified | datetime | 19 | √ | null | ||
pmse_inbox | date_modified | datetime | 19 | √ | null | ||
pmse_project | 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 | ||
projects_revenue_line_items | 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 | ||
prospects_dataprivacy | date_modified | datetime | 19 | √ | null | ||
purchased_line_items | date_modified | datetime | 19 | √ | null | ||
purchases | 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 | ||
record_list | date_modified | datetime | 19 | √ | null | ||
releases | date_modified | datetime | 19 | √ | null | ||
report_cache | date_modified | datetime | 19 | √ | null | ||
report_maker | date_modified | datetime | 19 | √ | null | ||
report_schedules | date_modified | datetime | 19 | √ | null | ||
reportschedules_users | date_modified | datetime | 19 | √ | null | ||
revenue_line_items | 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 | ||
shift_exceptions | date_modified | datetime | 19 | √ | null | ||
shift_exceptions_users | date_modified | datetime | 19 | √ | null | ||
shifts | date_modified | datetime | 19 | √ | null | ||
shifts_users | date_modified | datetime | 19 | √ | null | ||
shippers | date_modified | datetime | 19 | √ | null | ||
styleguide | date_modified | datetime | 19 | √ | null | ||
subscriptions | date_modified | datetime | 19 | √ | null | ||
sugarfavorites | date_modified | datetime | 19 | √ | null | ||
tag_bean_rel | date_modified | datetime | 19 | √ | null | ||
tags | 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 | ||
upgrade_history | date_modified | datetime | 19 | √ | null | ||
user_preferences | date_modified | datetime | 19 | √ | null | ||
users | 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 | ||
visual_pipeline | date_modified | datetime | 19 | √ | null | ||
weblogichooks | 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 | ||
data_privacy | date_opened | date | 10 | √ | null | ||
quotes | date_order_shipped | date | 10 | √ | null | ||
products | date_purchased | date | 10 | √ | null | ||
purchased_line_items | date_purchased | date | 10 | √ | null | ||
revenue_line_items | 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 | ||
messages | date_start | datetime | 19 | √ | null | ||
project_task | date_start | date | 10 | √ | null | ||
report_schedules | date_start | datetime | 19 | √ | null | ||
shifts | date_start | date | 10 | √ | null | ||
styleguide | 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 | ||
purchased_line_items | date_support_expires | date | 10 | √ | null | ||
revenue_line_items | date_support_expires | date | 10 | √ | null | ||
products | date_support_starts | date | 10 | √ | null | ||
purchased_line_items | date_support_starts | date | 10 | √ | null | ||
revenue_line_items | date_support_starts | date | 10 | √ | null | ||
schedulers | date_time_end | datetime | 19 | √ | null | ||
schedulers | date_time_start | datetime | 19 | √ | null | ||
accounts_audit | date_updated | datetime | 19 | √ | null | ||
bugs_audit | date_updated | datetime | 19 | √ | null | ||
business_centers_audit | date_updated | datetime | 19 | √ | null | ||
calls_audit | date_updated | datetime | 19 | √ | null | ||
campaigns_audit | date_updated | datetime | 19 | √ | null | ||
cases_audit | date_updated | datetime | 19 | √ | null | ||
contacts_audit | date_updated | datetime | 19 | √ | null | ||
contracts_audit | date_updated | datetime | 19 | √ | null | ||
data_privacy_audit | date_updated | datetime | 19 | √ | null | ||
email_addresses_audit | date_updated | datetime | 19 | √ | null | ||
forecast_manager_worksheets_audit | date_updated | datetime | 19 | √ | null | ||
kbcontent_templates_audit | date_updated | datetime | 19 | √ | null | ||
kbcontents_audit | date_updated | datetime | 19 | √ | null | ||
leads_audit | date_updated | datetime | 19 | √ | null | ||
meetings_audit | date_updated | datetime | 19 | √ | null | ||
messages_audit | date_updated | datetime | 19 | √ | null | ||
notes_audit | date_updated | datetime | 19 | √ | null | ||
opportunities_audit | date_updated | datetime | 19 | √ | null | ||
product_templates_audit | date_updated | datetime | 19 | √ | null | ||
products_audit | date_updated | datetime | 19 | √ | null | ||
project_task_audit | date_updated | datetime | 19 | √ | null | ||
prospects_audit | date_updated | datetime | 19 | √ | null | ||
purchased_line_items_audit | date_updated | datetime | 19 | √ | null | ||
purchases_audit | date_updated | datetime | 19 | √ | null | ||
quotas_audit | date_updated | datetime | 19 | √ | null | ||
quotes_audit | date_updated | datetime | 19 | √ | null | ||
report_schedules_audit | date_updated | datetime | 19 | √ | null | ||
revenue_line_items_audit | date_updated | datetime | 19 | √ | null | ||
shift_exceptions_audit | date_updated | datetime | 19 | √ | null | ||
shifts_audit | date_updated | datetime | 19 | √ | null | ||
tags_audit | date_updated | datetime | 19 | √ | null | ||
tasks_audit | date_updated | datetime | 19 | √ | null | ||
tracker_perf | db_round_trips | int | 6 | √ | null | ||
versions | db_version | varchar | 255 | √ | null | ||
products | deal_calc | decimal | 26,6 | √ | null | ||
purchased_line_items | deal_calc | decimal | 26,6 | √ | null | ||
revenue_line_items | deal_calc | decimal | 26,6 | √ | null | ||
products | deal_calc_usdollar | decimal | 26,6 | √ | null | ||
purchased_line_items | deal_calc_usdollar | decimal | 26,6 | √ | null | ||
revenue_line_items | deal_calc_usdollar | decimal | 26,6 | √ | null | ||
product_bundles | deal_tot | decimal | 26,6 | √ | null | ||
quotes | deal_tot | decimal | 26,2 | √ | null | ||
quotes | deal_tot_discount_percentage | decimal | 26,2 | √ | 0.00 | ||
product_bundles | deal_tot_usdollar | decimal | 26,6 | √ | null | ||
quotes | deal_tot_usdollar | decimal | 26,2 | √ | null | ||
shippers | default_cost | decimal | 26,6 | √ | null | ||
shippers | default_cost_usdollar | decimal | 26,6 | √ | null | ||
dashboards | default_dashboard | bit | 1 | √ | 0 | ||
product_bundles | default_group | bit | 1 | √ | 0 | ||
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_dataprivacy | deleted | bit | 1 | √ | 0 | ||
accounts_opportunities | deleted | bit | 1 | √ | 0 | ||
accounts_purchases | deleted | bit | 1 | √ | 0 | ||
acl_actions | deleted | bit | 1 | √ | 0 | ||
acl_fields | deleted | bit | 1 | √ | 0 | ||
acl_role_sets | deleted | bit | 1 | √ | 0 | ||
acl_role_sets_acl_roles | deleted | bit | 1 | √ | 0 | ||
acl_roles | deleted | bit | 1 | √ | 0 | ||
acl_roles_actions | deleted | bit | 1 | √ | 0 | ||
acl_roles_users | deleted | bit | 1 | √ | 0 | ||
activities | deleted | bit | 1 | √ | 0 | ||
activities_users | deleted | bit | 1 | √ | 0 | ||
bugs | deleted | bit | 1 | √ | 0 | ||
business_centers | deleted | bit | 1 | √ | 0 | ||
business_centers_holidays | 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 | √ | 0 | ||
campaign_trkrs | deleted | bit | 1 | √ | 0 | ||
campaigns | deleted | bit | 1 | √ | 0 | ||
cases | deleted | bit | 1 | √ | 0 | ||
cases_bugs | deleted | bit | 1 | √ | 0 | ||
cases_purchases | deleted | bit | 1 | √ | 0 | ||
categories | deleted | bit | 1 | √ | 0 | ||
changetimers | deleted | bit | 1 | √ | 0 | ||
commentlog | deleted | bit | 1 | √ | 0 | ||
commentlog_rel | deleted | bit | 1 | √ | 0 | ||
comments | deleted | bit | 1 | √ | 0 | ||
console_configuration | deleted | bit | 1 | √ | 0 | ||
contacts | deleted | bit | 1 | √ | 0 | ||
contacts_bugs | deleted | bit | 1 | √ | 0 | ||
contacts_cases | deleted | bit | 1 | √ | 0 | ||
contacts_dataprivacy | deleted | bit | 1 | √ | 0 | ||
contacts_purchases | 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 | √ | 0 | ||
custom_fields | deleted | bit | 1 | √ | 0 | ||
custom_queries | deleted | bit | 1 | √ | 0 | ||
dashboards | deleted | bit | 1 | √ | 0 | ||
data_privacy | deleted | bit | 1 | √ | 0 | ||
data_sets | deleted | bit | 1 | √ | 0 | ||
dataset_attributes | deleted | bit | 1 | √ | 0 | ||
dataset_layouts | 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_purchasedlineitems | deleted | bit | 1 | √ | 0 | ||
documents_purchases | deleted | bit | 1 | √ | 0 | ||
documents_quotes | deleted | bit | 1 | √ | 0 | ||
documents_revenuelineitems | 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 | √ | 0 | ||
email_marketing_prospect_lists | deleted | bit | 1 | √ | 0 | ||
email_templates | deleted | bit | 1 | √ | 0 | ||
emailman | deleted | bit | 1 | √ | 0 | ||
emails | deleted | bit | 1 | √ | 0 | ||
emails_beans | deleted | bit | 1 | √ | 0 | ||
emails_email_addr_rel | deleted | bit | 1 | √ | 0 | ||
emails_text | deleted | bit | 1 | √ | 0 | ||
embedded_files | deleted | bit | 1 | √ | 0 | ||
expressions | deleted | bit | 1 | √ | 0 | ||
fields_meta_data | deleted | bit | 1 | √ | 0 | ||
filters | deleted | bit | 1 | √ | 0 | ||
folders | deleted | bit | 1 | √ | 0 | ||
folders_rel | deleted | bit | 1 | √ | 0 | ||
forecast_manager_worksheets | deleted | bit | 1 | √ | 0 | ||
forecast_worksheets | deleted | bit | 1 | √ | 0 | ||
forecasts | deleted | bit | 1 | √ | 0 | ||
holidays | deleted | bit | 1 | √ | 0 | ||
import_maps | deleted | bit | 1 | √ | 0 | ||
inbound_email | deleted | bit | 1 | √ | 0 | ||
inbound_email_autoreply | deleted | bit | 1 | √ | 0 | ||
job_queue | deleted | bit | 1 | √ | 0 | ||
kbarticles | deleted | bit | 1 | √ | 0 | ||
kbcontent_templates | deleted | bit | 1 | √ | 0 | ||
kbcontents | deleted | bit | 1 | √ | 0 | ||
kbdocuments | deleted | bit | 1 | √ | 0 | ||
kbusefulness | deleted | bit | 1 | √ | 0 | ||
leads | deleted | bit | 1 | √ | 0 | ||
leads_dataprivacy | deleted | bit | 1 | √ | 0 | ||
linked_documents | deleted | bit | 1 | √ | 0 | ||
locked_field_bean_rel | deleted | bit | 1 | √ | 0 | ||
manufacturers | deleted | bit | 1 | √ | 0 | ||
meetings | deleted | bit | 1 | √ | 0 | ||
meetings_contacts | deleted | bit | 1 | √ | 0 | ||
meetings_leads | deleted | bit | 1 | √ | 0 | ||
meetings_users | deleted | bit | 1 | √ | 0 | ||
messages | deleted | bit | 1 | √ | 0 | ||
metadata_cache | 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 | ||
outbound_email | deleted | bit | 1 | √ | 0 | ||
pdfmanager | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_activity_definition | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_activity_step | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_activity_user | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_config | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_dynamic_forms | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_event_definition | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_flow | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_form_action | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_gateway_definition | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_group | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_group_user | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_notes | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_process_definition | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_related_dependency | deleted | bit | 1 | √ | 0 | ||
pmse_bpm_thread | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_activity | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_artifact | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_bound | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_data | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_diagram | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_documentation | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_event | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_extension | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_flow | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_gateway | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_lane | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_laneset | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_participant | deleted | bit | 1 | √ | 0 | ||
pmse_bpmn_process | deleted | bit | 1 | √ | 0 | ||
pmse_business_rules | deleted | bit | 1 | √ | 0 | ||
pmse_email_message | deleted | bit | 1 | √ | 0 | ||
pmse_emails_templates | deleted | bit | 1 | √ | 0 | ||
pmse_inbox | deleted | bit | 1 | √ | 0 | ||
pmse_project | 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 | ||
projects_revenue_line_items | deleted | bit | 1 | √ | 0 | ||
prospect_list_campaigns | deleted | bit | 1 | √ | 0 | ||
prospect_lists | deleted | bit | 1 | √ | 0 | ||
prospect_lists_prospects | deleted | bit | 1 | √ | 0 | ||
prospects | deleted | bit | 1 | √ | 0 | ||
prospects_dataprivacy | deleted | bit | 1 | √ | 0 | ||
purchased_line_items | deleted | bit | 1 | √ | 0 | ||
purchases | deleted | bit | 1 | √ | 0 | ||
quotas | deleted | bit | 1 | √ | 0 | ||
quotes | deleted | bit | 1 | √ | 0 | ||
quotes_accounts | deleted | bit | 1 | √ | 0 | ||
quotes_contacts | deleted | bit | 1 | √ | 0 | ||
quotes_opportunities | deleted | bit | 1 | √ | 0 | ||
releases | deleted | bit | 1 | √ | 0 | ||
report_cache | deleted | varchar | 1 | √ | null | ||
report_maker | deleted | bit | 1 | √ | 0 | ||
report_schedules | deleted | bit | 1 | √ | 0 | ||
reportschedules_users | deleted | bit | 1 | √ | 0 | ||
revenue_line_items | deleted | bit | 1 | √ | 0 | ||
roles | deleted | bit | 1 | √ | 0 | ||
roles_modules | deleted | bit | 1 | √ | 0 | ||
roles_users | deleted | bit | 1 | √ | 0 | ||
saved_reports | deleted | bit | 1 | √ | 0 | ||
saved_search | deleted | bit | 1 | √ | 0 | ||
schedulers | deleted | bit | 1 | √ | 0 | ||
schedulers_times | deleted | bit | 1 | √ | 0 | ||
session_active | deleted | bit | 1 | √ | 0 | ||
session_history | deleted | bit | 1 | √ | 0 | ||
shift_exceptions | deleted | bit | 1 | √ | 0 | ||
shift_exceptions_users | deleted | bit | 1 | √ | 0 | ||
shifts | deleted | bit | 1 | √ | 0 | ||
shifts_users | deleted | bit | 1 | √ | 0 | ||
shippers | deleted | bit | 1 | √ | 0 | ||
styleguide | deleted | bit | 1 | √ | 0 | ||
subscriptions | deleted | bit | 1 | √ | 0 | ||
sugarfavorites | deleted | bit | 1 | √ | 0 | ||
tag_bean_rel | deleted | bit | 1 | √ | 0 | ||
tags | deleted | bit | 1 | √ | 0 | ||
tasks | deleted | bit | 1 | √ | 0 | ||
taxrates | deleted | bit | 1 | √ | 0 | ||
team_memberships | deleted | bit | 1 | √ | 0 | ||
team_notices | deleted | bit | 1 | √ | 0 | ||
team_sets | deleted | bit | 1 | √ | 0 | ||
team_sets_modules | deleted | bit | 1 | √ | 0 | ||
team_sets_teams | deleted | bit | 1 | √ | 0 | ||
teams | deleted | bit | 1 | √ | 0 | ||
timeperiods | deleted | bit | 1 | √ | 0 | ||
tracker | deleted | bit | 1 | √ | 0 | ||
tracker_perf | deleted | bit | 1 | √ | 0 | ||
tracker_queries | deleted | bit | 1 | √ | 0 | ||
tracker_sessions | deleted | bit | 1 | √ | 0 | ||
upgrade_history | deleted | bit | 1 | √ | 0 | ||
user_preferences | deleted | bit | 1 | √ | 0 | ||
users | deleted | bit | 1 | √ | 0 | ||
users_holidays | deleted | bit | 1 | √ | 0 | ||
users_last_import | deleted | bit | 1 | √ | 0 | ||
users_password_link | deleted | bit | 1 | √ | 0 | ||
users_signatures | deleted | bit | 1 | √ | 0 | ||
vcals | deleted | bit | 1 | √ | 0 | ||
versions | deleted | bit | 1 | √ | 0 | ||
visual_pipeline | deleted | bit | 1 | √ | 0 | ||
weblogichooks | deleted | bit | 1 | √ | 0 | ||
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 | ||
import_maps | delimiter | varchar | 1 | √ | , | ||
contacts | department | varchar | 255 | √ | null | ||
leads | department | varchar | 100 | √ | null | ||
prospects | department | varchar | 255 | √ | null | ||
styleguide | department | varchar | 255 | √ | null | ||
users | department | varchar | 50 | √ | null | ||
accounts | description | text | 65535 | √ | null | ||
acl_role_sets | description | text | 65535 | √ | null | ||
acl_roles | description | text | 65535 | √ | null | ||
bugs | description | text | 65535 | √ | null | ||
business_centers | description | text | 65535 | √ | null | ||
calls | description | text | 65535 | √ | null | ||
cases | description | longtext | 2147483647 | √ | null | ||
categories | description | text | 65535 | √ | null | ||
changetimers | description | text | 65535 | √ | null | ||
commentlog | description | text | 65535 | √ | null | ||
console_configuration | description | text | 65535 | √ | null | ||
contacts | description | text | 65535 | √ | null | ||
contract_types | description | text | 65535 | √ | null | ||
contracts | description | text | 65535 | √ | null | ||
custom_queries | description | text | 65535 | √ | null | ||
dashboards | description | text | 65535 | √ | null | ||
data_privacy | description | text | 65535 | √ | null | ||
data_sets | 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 | ||
embedded_files | description | text | 65535 | √ | null | ||
filters | description | text | 65535 | √ | null | ||
forecast_manager_worksheets | description | text | 65535 | √ | null | ||
forecast_worksheets | description | text | 65535 | √ | null | ||
holidays | description | text | 65535 | √ | null | ||
kbarticles | description | text | 65535 | √ | null | ||
kbcontent_templates | description | text | 65535 | √ | null | ||
kbcontents | description | text | 65535 | √ | null | ||
kbdocuments | description | text | 65535 | √ | null | ||
leads | description | text | 65535 | √ | null | ||
manufacturers | description | text | 65535 | √ | null | ||
meetings | description | text | 65535 | √ | null | ||
messages | 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 | ||
pmse_bpm_activity_definition | description | text | 65535 | √ | null | ||
pmse_bpm_activity_step | description | text | 65535 | √ | null | ||
pmse_bpm_activity_user | description | text | 65535 | √ | null | ||
pmse_bpm_config | description | text | 65535 | √ | null | ||
pmse_bpm_dynamic_forms | description | text | 65535 | √ | null | ||
pmse_bpm_event_definition | description | text | 65535 | √ | null | ||
pmse_bpm_flow | description | text | 65535 | √ | null | ||
pmse_bpm_form_action | description | text | 65535 | √ | null | ||
pmse_bpm_gateway_definition | description | text | 65535 | √ | null | ||
pmse_bpm_group | description | text | 65535 | √ | null | ||
pmse_bpm_group_user | description | text | 65535 | √ | null | ||
pmse_bpm_notes | description | text | 65535 | √ | null | ||
pmse_bpm_process_definition | description | text | 65535 | √ | null | ||
pmse_bpm_related_dependency | description | text | 65535 | √ | null | ||
pmse_bpm_thread | description | text | 65535 | √ | null | ||
pmse_bpmn_activity | description | text | 65535 | √ | null | ||
pmse_bpmn_artifact | description | text | 65535 | √ | null | ||
pmse_bpmn_bound | description | text | 65535 | √ | null | ||
pmse_bpmn_data | description | text | 65535 | √ | null | ||
pmse_bpmn_diagram | description | text | 65535 | √ | null | ||
pmse_bpmn_documentation | description | text | 65535 | √ | null | ||
pmse_bpmn_event | description | text | 65535 | √ | null | ||
pmse_bpmn_extension | description | text | 65535 | √ | null | ||
pmse_bpmn_flow | description | text | 65535 | √ | null | ||
pmse_bpmn_gateway | description | text | 65535 | √ | null | ||
pmse_bpmn_lane | description | text | 65535 | √ | null | ||
pmse_bpmn_laneset | description | text | 65535 | √ | null | ||
pmse_bpmn_participant | description | text | 65535 | √ | null | ||
pmse_bpmn_process | description | text | 65535 | √ | null | ||
pmse_business_rules | description | text | 65535 | √ | null | ||
pmse_email_message | description | text | 65535 | √ | null | ||
pmse_emails_templates | description | text | 65535 | √ | null | ||
pmse_inbox | description | text | 65535 | √ | null | ||
pmse_project | 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 | ||
purchased_line_items | description | text | 65535 | √ | null | ||
purchases | description | text | 65535 | √ | null | ||
quotas | description | text | 65535 | √ | null | ||
quotes | description | text | 65535 | √ | null | ||
report_maker | description | text | 65535 | √ | null | ||
report_schedules | description | text | 65535 | √ | null | ||
revenue_line_items | description | text | 65535 | √ | null | ||
roles | description | text | 65535 | √ | null | ||
saved_reports | description | text | 65535 | √ | null | ||
saved_search | description | text | 65535 | √ | null | ||
schedulers | description | text | 65535 | √ | null | ||
shift_exceptions | description | text | 65535 | √ | null | ||
shifts | description | text | 65535 | √ | null | ||
shippers | description | text | 65535 | √ | null | ||
styleguide | description | text | 65535 | √ | null | ||
sugarfavorites | description | varchar | 50 | √ | null | ||
tags | description | text | 65535 | √ | null | ||
tasks | description | text | 65535 | √ | null | ||
taxrates | 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 | ||
users_signatures | description | text | 65535 | √ | null | ||
visual_pipeline | description | text | 65535 | √ | null | ||
weblogichooks | description | text | 65535 | √ | null | ||
workflow | description | text | 65535 | √ | null | ||
emails_text | description_html | longtext | 2147483647 | √ | null | ||
pmse_bpmn_bound | dia_id | varchar | 36 | √ | |||
pmse_bpmn_flow | dia_id | varchar | 36 | √ | |||
pmse_bpmn_process | dia_id | varchar | 36 | √ | |||
pmse_bpmn_diagram | dia_is_closable | int | 4 | √ | 0 | ||
pmse_bpmn_diagram | dia_uid | varchar | 36 | √ | |||
calls | direction | varchar | 100 | √ | null | ||
emails | direction | varchar | 20 | Unknown | |||
messages | direction | varchar | 50 | √ | null | ||
quotes | discount | decimal | 26,6 | √ | 0.000000 | ||
forecast_worksheets | discount_amount | decimal | 26,6 | √ | null | ||
products | discount_amount | decimal | 26,6 | √ | 0.000000 | ||
purchased_line_items | discount_amount | decimal | 26,6 | √ | 0.000000 | ||
revenue_line_items | discount_amount | decimal | 26,6 | √ | 0.000000 | ||
products | discount_amount_signed | decimal | 26,6 | √ | 0.000000 | ||
purchased_line_items | discount_amount_signed | decimal | 26,6 | √ | 0.000000 | ||
revenue_line_items | discount_amount_signed | decimal | 26,6 | √ | 0.000000 | ||
products | discount_amount_usdollar | decimal | 26,6 | √ | null | ||
purchased_line_items | discount_amount_usdollar | decimal | 26,6 | √ | null | ||
revenue_line_items | discount_amount_usdollar | decimal | 26,6 | √ | null | ||
forecast_worksheets | discount_price | decimal | 26,6 | √ | null | ||
product_templates | discount_price | decimal | 26,6 | √ | null | ||
products | discount_price | decimal | 26,6 | √ | 0.000000 | ||
purchased_line_items | discount_price | decimal | 26,6 | √ | null | ||
revenue_line_items | discount_price | decimal | 26,6 | √ | null | ||
products | discount_rate_percent | decimal | 26,2 | √ | null | ||
revenue_line_items | discount_rate_percent | decimal | 26,2 | √ | null | ||
products | discount_select | bit | 1 | √ | 1 | ||
purchased_line_items | discount_select | bit | 1 | √ | 0 | ||
revenue_line_items | discount_select | bit | 1 | √ | 1 | ||
product_templates | discount_usdollar | decimal | 26,6 | √ | null | ||
products | discount_usdollar | decimal | 26,6 | √ | null | ||
purchased_line_items | discount_usdollar | decimal | 26,6 | √ | null | ||
revenue_line_items | discount_usdollar | decimal | 26,6 | √ | null | ||
dataset_attributes | display_name | varchar | 50 | √ | null | ||
dataset_attributes | display_type | varchar | 25 | √ | null | ||
meetings | displayed_url | varchar | 400 | √ | null | ||
contacts | dnb_principal_id | varchar | 30 | √ | null | ||
leads | dnb_principal_id | varchar | 30 | √ | null | ||
prospects | dnb_principal_id | varchar | 30 | √ | null | ||
contacts | do_not_call | bit | 1 | √ | 0 | ||
leads | do_not_call | bit | 1 | √ | 0 | ||
prospects | do_not_call | bit | 1 | √ | 0 | ||
styleguide | do_not_call | bit | 1 | √ | 0 | ||
pmse_bpmn_documentation | doc_documentation | text | 65535 | √ | null | ||
pmse_bpmn_documentation | doc_element | varchar | 36 | √ | |||
pmse_bpmn_documentation | doc_element_type | varchar | 45 | √ | |||
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 | ||
pmse_bpmn_documentation | doc_uid | varchar | 36 | √ | |||
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_purchasedlineitems | document_id | char | 36 | √ | null | ||
documents_purchases | document_id | char | 36 | √ | null | ||
documents_quotes | document_id | char | 36 | √ | null | ||
documents_revenuelineitems | document_id | char | 36 | √ | null | ||
linked_documents | document_id | char | 36 | √ | null | ||
documents | document_name | varchar | 255 | √ | null | ||
documents | document_revision_id | char | 36 | √ | null | ||
linked_documents | document_revision_id | char | 36 | √ | null | ||
prospect_lists | domain_name | varchar | 255 | √ | null | ||
oauth_tokens | download_token | varchar | 36 | √ | null | ||
contacts | dp_business_purpose | text | 65535 | √ | null | ||
leads | dp_business_purpose | text | 65535 | √ | null | ||
prospects | dp_business_purpose | text | 65535 | √ | null | ||
contacts | dp_consent_last_updated | date | 10 | √ | null | ||
leads | dp_consent_last_updated | date | 10 | √ | null | ||
prospects | dp_consent_last_updated | date | 10 | √ | null | ||
email_cache | draft | tinyint | 4 | √ | null | ||
forecast_manager_worksheets | draft | bit | 1 | √ | 0 | ||
forecast_worksheets | draft | int | 11 | √ | 0 | ||
accounts | duns_num | varchar | 15 | √ | null | ||
fields_meta_data | duplicate_merge | smallint | 6 | √ | 0 | ||
project_task | duration | int | 11 | √ | null | ||
calls | duration_hours | int | 11 | √ | 0 | ||
meetings | duration_hours | int | 11 | √ | 0 | ||
calls | duration_minutes | int | 2 | √ | null | ||
meetings | duration_minutes | int | 2 | √ | 0 | ||
project_task | duration_unit | text | 65535 | √ | null | ||
pmse_bpm_dynamic_forms | dyn_module | varchar | 255 | √ | |||
pmse_bpm_dynamic_forms | dyn_uid | varchar | 32 | √ | |||
pmse_bpm_dynamic_forms | dyn_view_defs | text | 65535 | √ | null | ||
folders | dynamic_query | text | 65535 | √ | null | ||
inbound_email | eapm_id | char | 36 | √ | null | ||
outbound_email | eapm_id | char | 36 | √ | null | ||
pmse_bpmn_bound | element_id | varchar | 36 | √ | |||
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 | √ | null | ||
outbound_email | email_address_id | char | 36 | √ | null | ||
emails_beans | email_id | char | 36 | √ | null | ||
emails_email_addr_rel | email_id | char | 36 | √ | null | ||
emails_text | email_id | char | 36 | ||||
notes | email_id | char | 36 | √ | null | ||
email_marketing_prospect_lists | email_marketing_id | char | 36 | √ | null | ||
inbound_email | email_password | varchar | 100 | √ | null | ||
inbound_email | email_provider | varchar | 20 | √ | other | ||
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 | ||
notes | email_type | varchar | 255 | √ | null | ||
inbound_email | email_user | varchar | 100 | √ | null | ||
notes | embed_flag | bit | 1 | √ | 0 | ||
users | employee_status | varchar | 100 | √ | null | ||
accounts | employees | varchar | 10 | √ | null | ||
shift_exceptions | enabled | bit | 1 | √ | 0 | ||
upgrade_history | enabled | bit | 1 | √ | 1 | ||
visual_pipeline | enabled_module | varchar | 255 | √ | |||
console_configuration | enabled_modules | varchar | 255 | √ | null | ||
import_maps | enclosure | varchar | 1 | √ | |||
campaigns | end_date | date | 10 | √ | null | ||
contracts | end_date | date | 10 | √ | null | ||
purchases | end_date | date | 10 | √ | null | ||
shift_exceptions | end_date | date | 10 | √ | null | ||
timeperiods | end_date | date | 10 | √ | null | ||
timeperiods | end_date_timestamp | int | 14 | √ | null | ||
shift_exceptions | end_hour | varchar | 2 | √ | null | ||
shift_exceptions | end_minutes | varchar | 2 | √ | null | ||
commentlog | entry | text | 65535 | √ | null | ||
contacts | entry_source | varchar | 255 | √ | internal | ||
notes | entry_source | varchar | 255 | √ | internal | ||
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 | ||
accounts_audit | event_id | char | 36 | ||||
bugs_audit | event_id | char | 36 | ||||
business_centers_audit | event_id | char | 36 | ||||
calls_audit | event_id | char | 36 | ||||
campaigns_audit | event_id | char | 36 | ||||
cases_audit | event_id | char | 36 | ||||
contacts_audit | event_id | char | 36 | ||||
contracts_audit | event_id | char | 36 | ||||
data_privacy_audit | event_id | char | 36 | ||||
email_addresses_audit | event_id | char | 36 | ||||
forecast_manager_worksheets_audit | event_id | char | 36 | ||||
kbcontent_templates_audit | event_id | char | 36 | ||||
kbcontents_audit | event_id | char | 36 | ||||
leads_audit | event_id | char | 36 | ||||
meetings_audit | event_id | char | 36 | ||||
messages_audit | event_id | char | 36 | ||||
notes_audit | event_id | char | 36 | ||||
opportunities_audit | event_id | char | 36 | ||||
product_templates_audit | event_id | char | 36 | ||||
products_audit | event_id | char | 36 | ||||
project_task_audit | event_id | char | 36 | ||||
prospects_audit | event_id | char | 36 | ||||
purchased_line_items_audit | event_id | char | 36 | ||||
purchases_audit | event_id | char | 36 | ||||
quotas_audit | event_id | char | 36 | ||||
quotes_audit | event_id | char | 36 | ||||
report_schedules_audit | event_id | char | 36 | ||||
revenue_line_items_audit | event_id | char | 36 | ||||
shift_exceptions_audit | event_id | char | 36 | ||||
shifts_audit | event_id | char | 36 | ||||
tags_audit | event_id | char | 36 | ||||
tasks_audit | event_id | char | 36 | ||||
pmse_bpm_related_dependency | evn_activity_ref | varchar | 36 | √ | |||
pmse_bpmn_event | evn_activity_ref | int | 4 | √ | null | ||
pmse_bpm_related_dependency | evn_attached_to | varchar | 36 | √ | |||
pmse_bpmn_event | evn_attached_to | int | 4 | √ | null | ||
pmse_bpm_related_dependency | evn_behavior | varchar | 36 | √ | |||
pmse_bpmn_event | evn_behavior | varchar | 20 | √ | CATCH | ||
pmse_bpm_related_dependency | evn_cancel_activity | varchar | 36 | √ | |||
pmse_bpmn_event | evn_cancel_activity | int | 4 | √ | 0 | ||
pmse_bpm_related_dependency | evn_condition | varchar | 36 | √ | |||
pmse_bpmn_event | evn_condition | varchar | 255 | √ | |||
pmse_bpm_event_definition | evn_criteria | text | 65535 | √ | null | ||
pmse_bpm_related_dependency | evn_criteria | text | 65535 | √ | null | ||
pmse_bpm_related_dependency | evn_error_code | varchar | 36 | √ | |||
pmse_bpmn_event | evn_error_code | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_error_name | varchar | 36 | √ | |||
pmse_bpmn_event | evn_error_name | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_escalation_code | varchar | 36 | √ | |||
pmse_bpmn_event | evn_escalation_code | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_escalation_name | varchar | 36 | √ | |||
pmse_bpmn_event | evn_escalation_name | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_id | varchar | 36 | √ | |||
pmse_bpm_related_dependency | evn_is_interrupting | varchar | 36 | √ | |||
pmse_bpmn_event | evn_is_interrupting | int | 4 | √ | 1 | ||
pmse_bpm_related_dependency | evn_marker | varchar | 36 | √ | |||
pmse_bpmn_event | evn_marker | varchar | 30 | √ | EMPTY | ||
pmse_bpm_related_dependency | evn_message | varchar | 36 | √ | |||
pmse_bpmn_event | evn_message | text | 65535 | √ | null | ||
pmse_bpm_event_definition | evn_module | varchar | 128 | √ | Leads | ||
pmse_bpm_related_dependency | evn_module | varchar | 36 | √ | |||
pmse_bpm_related_dependency | evn_operation_implementation | varchar | 36 | √ | |||
pmse_bpmn_event | evn_operation_implementation | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_operation_name | varchar | 36 | √ | |||
pmse_bpmn_event | evn_operation_name | varchar | 255 | √ | |||
pmse_bpm_event_definition | evn_params | text | 65535 | √ | null | ||
pmse_bpm_related_dependency | evn_params | text | 65535 | √ | null | ||
pmse_bpm_event_definition | evn_script | text | 65535 | √ | null | ||
pmse_bpm_related_dependency | evn_script | text | 65535 | √ | null | ||
pmse_bpm_event_definition | evn_status | varchar | 32 | √ | ACTIVE | ||
pmse_bpm_related_dependency | evn_status | varchar | 36 | √ | |||
pmse_bpm_related_dependency | evn_time_cycle | varchar | 36 | √ | |||
pmse_bpmn_event | evn_time_cycle | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_time_date | varchar | 36 | √ | |||
pmse_bpmn_event | evn_time_date | varchar | 255 | √ | |||
pmse_bpm_related_dependency | evn_time_duration | varchar | 36 | √ | |||
pmse_bpmn_event | evn_time_duration | varchar | 255 | √ | |||
pmse_bpm_event_definition | evn_type | varchar | 30 | √ | START | ||
pmse_bpm_related_dependency | evn_type | varchar | 36 | √ | |||
pmse_bpmn_event | evn_type | varchar | 30 | √ | |||
pmse_bpm_related_dependency | evn_uid | varchar | 36 | √ | |||
pmse_bpmn_event | evn_uid | varchar | 36 | √ | |||
pmse_bpm_related_dependency | evn_wait_for_completion | varchar | 36 | √ | |||
pmse_bpmn_event | evn_wait_for_completion | int | 4 | √ | 1 | ||
job_queue | execute_time | datetime | 19 | √ | null | ||
schedulers_times | execute_time | datetime | 19 | √ | null | ||
pmse_bpm_activity_definition | execution_mode | varchar | 10 | √ | DEFAULT | ||
pmse_bpm_event_definition | execution_mode | varchar | 10 | √ | DEFAULT | ||
pmse_bpm_gateway_definition | execution_mode | varchar | 10 | √ | DEFAULT | ||
pmse_bpm_process_definition | execution_mode | varchar | 10 | √ | SYNC | ||
documents | exp_date | date | 10 | √ | null | ||
kbcontents | exp_date | date | 10 | √ | null | ||
expressions | exp_order | int | 4 | √ | null | ||
expressions | exp_type | varchar | 100 | √ | null | ||
campaigns | expected_cost | decimal | 26,6 | √ | null | ||
campaigns | expected_revenue | decimal | 26,6 | √ | null | ||
contracts | expiration_notice | datetime | 19 | √ | null | ||
oauth_tokens | expire_ts | bigint | 20 | √ | -1 | ||
team_memberships | explicit_assign | bit | 1 | √ | 0 | ||
data_sets | exportable | varchar | 3 | √ | 0 | ||
expressions | ext1 | varchar | 50 | √ | null | ||
fields_meta_data | ext1 | varchar | 255 | √ | |||
workflow_actions | ext1 | varchar | 50 | √ | null | ||
expressions | ext2 | varchar | 50 | √ | null | ||
fields_meta_data | ext2 | varchar | 255 | √ | |||
workflow_actions | ext2 | varchar | 50 | √ | null | ||
expressions | ext3 | varchar | 50 | √ | null | ||
fields_meta_data | ext3 | varchar | 255 | √ | |||
workflow_actions | ext3 | varchar | 50 | √ | null | ||
fields_meta_data | ext4 | text | 65535 | √ | null | ||
pmse_bpmn_extension | ext_element | varchar | 36 | √ | |||
pmse_bpmn_extension | ext_element_type | varchar | 45 | √ | |||
pmse_bpmn_extension | ext_extension | text | 65535 | √ | null | ||
pmse_bpmn_extension | ext_uid | varchar | 36 | √ | |||
users | external_auth_only | bit | 1 | √ | 0 | ||
meetings | external_id | varchar | 50 | √ | null | ||
accounts | varchar | 100 | √ | null | |||
contacts | varchar | 100 | √ | null | |||
leads | varchar | 100 | √ | null | |||
prospects | varchar | 100 | √ | null | |||
styleguide | varchar | 100 | √ | null | |||
job_queue | failure_count | tinyint | 4 | √ | null | ||
job_queue | fallible | bit | 1 | √ | 0 | ||
saved_reports | favorite | bit | 1 | √ | 0 | ||
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 | ||
business_centers_audit | field_name | varchar | 100 | √ | null | ||
calls_audit | field_name | varchar | 100 | √ | null | ||
campaigns_audit | field_name | varchar | 100 | √ | null | ||
cases_audit | field_name | varchar | 100 | √ | null | ||
changetimers | field_name | varchar | 100 | √ | null | ||
contacts_audit | field_name | varchar | 100 | √ | null | ||
contracts_audit | field_name | varchar | 100 | √ | null | ||
data_privacy_audit | field_name | varchar | 100 | √ | null | ||
email_addresses_audit | field_name | varchar | 100 | √ | null | ||
forecast_manager_worksheets_audit | field_name | varchar | 100 | √ | null | ||
kbcontent_templates_audit | field_name | varchar | 100 | √ | null | ||
kbcontents_audit | field_name | varchar | 100 | √ | null | ||
leads_audit | field_name | varchar | 100 | √ | null | ||
meetings_audit | field_name | varchar | 100 | √ | null | ||
messages_audit | field_name | varchar | 100 | √ | null | ||
notes_audit | field_name | varchar | 100 | √ | null | ||
opportunities_audit | field_name | varchar | 100 | √ | null | ||
product_templates_audit | field_name | varchar | 100 | √ | null | ||
products_audit | field_name | varchar | 100 | √ | null | ||
project_task_audit | field_name | varchar | 100 | √ | null | ||
prospects_audit | field_name | varchar | 100 | √ | null | ||
purchased_line_items_audit | field_name | varchar | 100 | √ | null | ||
purchases_audit | field_name | varchar | 100 | √ | null | ||
quotas_audit | field_name | varchar | 100 | √ | null | ||
quotes_audit | field_name | varchar | 100 | √ | null | ||
report_schedules_audit | field_name | varchar | 100 | √ | null | ||
revenue_line_items_audit | field_name | varchar | 100 | √ | null | ||
shift_exceptions_audit | field_name | varchar | 100 | √ | null | ||
shifts_audit | field_name | varchar | 100 | √ | null | ||
tags_audit | field_name | varchar | 100 | √ | null | ||
tasks_audit | field_name | varchar | 100 | √ | null | ||
workflow_alerts | field_value | varchar | 50 | √ | null | ||
activities_users | fields | longtext | 2147483647 | √ | null | ||
data_privacy | fields_to_erase | text | 65535 | √ | null | ||
document_revisions | file_ext | varchar | 100 | √ | null | ||
notes | file_ext | varchar | 100 | √ | null | ||
document_revisions | file_mime_type | varchar | 100 | √ | null | ||
embedded_files | file_mime_type | varchar | 100 | √ | null | ||
notes | file_mime_type | varchar | 100 | √ | null | ||
styleguide | file_mime_type | varchar | 100 | √ | null | ||
document_revisions | file_size | int | 11 | √ | null | ||
notes | file_size | int | 11 | √ | 0 | ||
notes | file_source | varchar | 32 | √ | null | ||
versions | file_version | varchar | 255 | √ | null | ||
document_revisions | filename | varchar | 255 | √ | null | ||
embedded_files | filename | varchar | 255 | √ | null | ||
notes | filename | varchar | 255 | √ | null | ||
styleguide | filename | varchar | 255 | √ | null | ||
upgrade_history | filename | varchar | 255 | √ | null | ||
tracker_perf | files_opened | int | 6 | √ | null | ||
console_configuration | filter_def | text | 65535 | √ | null | ||
filters | filter_definition | longtext | 2147483647 | √ | null | ||
filters | filter_template | longtext | 2147483647 | √ | 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 | ||
styleguide | first_name | varchar | 100 | √ | null | ||
users | first_name | varchar | 30 | √ | null | ||
cases | first_response_actual_datetime | datetime | 19 | √ | null | ||
cases | first_response_sent | bit | 1 | √ | 0 | ||
cases | first_response_sla_met | varchar | 100 | √ | null | ||
cases | first_response_target_datetime | datetime | 19 | √ | null | ||
cases | first_response_user_id | char | 36 | √ | null | ||
cases | first_response_var_from_target | decimal | 12,2 | √ | null | ||
bugs | fixed_in_release | varchar | 255 | √ | null | ||
email_cache | flagged | tinyint | 4 | √ | null | ||
emails | flagged | bit | 1 | √ | 0 | ||
pmse_bpmn_flow | flo_condition | text | 65535 | √ | null | ||
pmse_bpmn_flow | flo_element_dest | varchar | 36 | √ | |||
pmse_bpmn_flow | flo_element_dest_port | int | 4 | √ | 0 | ||
pmse_bpmn_flow | flo_element_dest_type | varchar | 32 | √ | |||
pmse_bpmn_flow | flo_element_origin | varchar | 36 | √ | |||
pmse_bpmn_flow | flo_element_origin_port | int | 4 | √ | 0 | ||
pmse_bpmn_flow | flo_element_origin_type | varchar | 32 | √ | |||
pmse_bpmn_flow | flo_eval_priority | int | 4 | √ | 0 | ||
pmse_bpmn_flow | flo_is_inmediate | int | 4 | √ | null | ||
pmse_bpmn_flow | flo_state | text | 65535 | √ | null | ||
pmse_bpmn_flow | flo_type | varchar | 20 | √ | |||
pmse_bpmn_flow | flo_uid | varchar | 36 | √ | |||
pmse_bpmn_flow | flo_x1 | int | 4 | √ | 0 | ||
pmse_bpmn_flow | flo_x2 | int | 4 | √ | 0 | ||
pmse_bpmn_flow | flo_y1 | int | 4 | √ | 0 | ||
pmse_bpmn_flow | flo_y2 | int | 4 | √ | 0 | ||
pmse_email_message | flow_id | char | 36 | √ | null | ||
folders_rel | folder_id | char | 36 | ||||
folders_subscriptions | folder_id | char | 36 | ||||
folders | folder_type | varchar | 25 | √ | null | ||
bugs | follow_up_datetime | datetime | 19 | √ | null | ||
cases | follow_up_datetime | datetime | 19 | √ | null | ||
data_privacy | follow_up_datetime | datetime | 19 | √ | null | ||
dataset_attributes | font_color | varchar | 25 | √ | null | ||
data_sets | font_size | varchar | 8 | √ | 0 | ||
dataset_attributes | font_size | varchar | 8 | √ | 0 | ||
pdfmanager | footer_text | varchar | 255 | √ | null | ||
forecasts | forecast_type | varchar | 100 | √ | null | ||
dataset_attributes | format_type | varchar | 25 | √ | null | ||
bugs | found_in_release | varchar | 255 | √ | null | ||
workflow_triggershells | frame_type | varchar | 15 | √ | null | ||
campaigns | frequency | varchar | 100 | √ | null | ||
business_centers | friday_close_hour | varchar | 2 | √ | null | ||
shifts | friday_close_hour | varchar | 2 | √ | null | ||
business_centers | friday_close_minutes | varchar | 2 | √ | null | ||
shifts | friday_close_minutes | varchar | 2 | √ | null | ||
business_centers | friday_open_hour | varchar | 2 | √ | null | ||
shifts | friday_open_hour | varchar | 2 | √ | null | ||
business_centers | friday_open_minutes | varchar | 2 | √ | null | ||
shifts | friday_open_minutes | varchar | 2 | √ | null | ||
pmse_bpm_form_action | frm_action | varchar | 255 | √ | ROUTE | ||
pmse_bpm_form_action | frm_comment | text | 65535 | √ | null | ||
pmse_bpm_form_action | frm_date | datetime | 19 | √ | null | ||
pmse_bpm_form_action | frm_index | int | 4 | √ | null | ||
pmse_bpm_form_action | frm_last | int | 4 | √ | null | ||
pmse_bpm_form_action | frm_user_id | varchar | 255 | √ | |||
pmse_bpm_form_action | frm_user_name | varchar | 255 | √ | |||
email_marketing | from_addr | varchar | 100 | √ | null | ||
emails_text | from_addr | varchar | 255 | √ | null | ||
pmse_email_message | from_addr | varchar | 255 | √ | null | ||
email_templates | from_address | varchar | 255 | √ | null | ||
pmse_emails_templates | from_address | varchar | 255 | √ | null | ||
changetimers | from_datetime | datetime | 19 | √ | null | ||
email_marketing | from_name | varchar | 100 | √ | null | ||
email_templates | from_name | varchar | 255 | √ | null | ||
pmse_email_message | from_name | varchar | 255 | √ | null | ||
pmse_emails_templates | from_name | varchar | 255 | √ | null | ||
email_cache | fromaddr | varchar | 100 | √ | null | ||
pmse_bpmn_gateway | gat_activation_count | int | 4 | √ | 0 | ||
pmse_bpmn_gateway | gat_default_flow | varchar | 36 | √ | |||
pmse_bpmn_gateway | gat_direction | varchar | 30 | √ | UNSPECIFIED | ||
pmse_bpmn_gateway | gat_event_gateway_type | varchar | 20 | √ | NONE | ||
pmse_bpmn_gateway | gat_instantiate | int | 4 | √ | 0 | ||
pmse_bpmn_gateway | gat_type | varchar | 30 | √ | |||
pmse_bpmn_gateway | gat_uid | varchar | 36 | √ | |||
pmse_bpmn_gateway | gat_waiting_for_start | int | 4 | √ | 1 | ||
revenue_line_items | generate_purchase | varchar | 25 | √ | null | ||
accounts | googleplus | varchar | 100 | √ | null | ||
contacts | googleplus | varchar | 100 | √ | null | ||
leads | googleplus | varchar | 100 | √ | null | ||
prospects | googleplus | varchar | 100 | √ | null | ||
styleguide | googleplus | varchar | 100 | √ | null | ||
inbound_email | group_id | char | 36 | √ | null | ||
inbound_email | groupfolder_id | char | 36 | √ | null | ||
pmse_bpm_group | grp_parent_group | int | 4 | √ | 0 | ||
pmse_bpm_group | grp_uid | varchar | 36 | √ | |||
folders | has_child | bit | 1 | √ | 0 | ||
import_maps | has_header | bit | 1 | √ | 1 | ||
email_templates | has_variables | bit | 1 | √ | 0 | ||
acl_role_sets | hash | varchar | 32 | √ | null | ||
data_sets | header | varchar | 3 | √ | 0 | ||
data_sets | header_back_color | varchar | 100 | √ | null | ||
pdfmanager | header_logo | varchar | 255 | √ | null | ||
pdfmanager | header_text | varchar | 255 | √ | null | ||
data_sets | header_text_color | varchar | 100 | √ | null | ||
pdfmanager | header_title | varchar | 255 | √ | null | ||
fields_meta_data | help | varchar | 255 | √ | null | ||
visual_pipeline | hidden_values | text | 65535 | √ | null | ||
dataset_layouts | hide_column | varchar | 3 | √ | null | ||
forecast_tree | hierarchy_type | varchar | 25 | √ | null | ||
campaign_log | hits | int | 11 | √ | 0 | ||
holidays | holiday_date | date | 10 | √ | null | ||
business_centers_holidays | holiday_id | char | 36 | √ | null | ||
users_holidays | holiday_id | char | 36 | √ | null | ||
meetings | host_url | varchar | 600 | √ | null | ||
changetimers | hours | decimal | 12,2 | √ | null | ||
cases | hours_to_first_response | decimal | 12,2 | √ | null | ||
bugs | hours_to_resolution | decimal | 12,2 | √ | null | ||
cases | hours_to_resolution | decimal | 12,2 | √ | null | ||
data_privacy | hours_to_resolution | decimal | 12,2 | √ | null | ||
accounts | id | char | 36 | ||||
accounts_audit | id | char | 36 | ||||
accounts_bugs | id | char | 36 | ||||
accounts_cases | id | char | 36 | ||||
accounts_contacts | id | char | 36 | ||||
accounts_dataprivacy | id | char | 36 | ||||
accounts_opportunities | id | char | 36 | ||||
accounts_purchases | id | char | 36 | ||||
acl_actions | id | char | 36 | ||||
acl_fields | id | char | 36 | ||||
acl_role_sets | id | char | 36 | ||||
acl_role_sets_acl_roles | id | char | 36 | ||||
acl_roles | id | char | 36 | ||||
acl_roles_actions | id | char | 36 | ||||
acl_roles_users | id | char | 36 | ||||
activities | id | char | 36 | ||||
activities_users | id | char | 36 | ||||
address_book_lists | id | char | 36 | ||||
audit_events | id | char | 36 | ||||
bugs | id | char | 36 | ||||
bugs_audit | id | char | 36 | ||||
business_centers | id | char | 36 | ||||
business_centers_audit | id | char | 36 | ||||
business_centers_holidays | id | char | 36 | ||||
calls | id | char | 36 | ||||
calls_audit | 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 | char | 36 | ||||
cases_purchases | id | char | 36 | ||||
categories | id | char | 36 | ||||
changetimers | id | char | 36 | ||||
commentlog | id | char | 36 | ||||
commentlog_rel | id | char | 36 | ||||
comments | id | char | 36 | ||||
console_configuration | id | char | 36 | ||||
contacts | id | char | 36 | ||||
contacts_audit | id | char | 36 | ||||
contacts_bugs | id | char | 36 | ||||
contacts_cases | id | char | 36 | ||||
contacts_dataprivacy | id | char | 36 | ||||
contacts_purchases | id | char | 36 | ||||
contacts_users | id | char | 36 | ||||
contract_types | id | char | 36 | ||||
contracts | id | char | 36 | ||||
contracts_audit | id | char | 36 | ||||
contracts_contacts | id | char | 36 | ||||
contracts_opportunities | id | char | 36 | ||||
contracts_products | id | char | 36 | ||||
contracts_quotes | id | char | 36 | ||||
currencies | id | char | 36 | ||||
custom_queries | id | char | 36 | ||||
dashboards | id | char | 36 | ||||
data_privacy | id | char | 36 | ||||
data_privacy_audit | id | char | 36 | ||||
data_sets | id | char | 36 | ||||
dataset_attributes | id | char | 36 | ||||
dataset_layouts | 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_purchasedlineitems | id | char | 36 | ||||
documents_purchases | id | char | 36 | ||||
documents_quotes | id | char | 36 | ||||
documents_revenuelineitems | id | char | 36 | ||||
eapm | id | char | 36 | ||||
email_addr_bean_rel | id | char | 36 | ||||
email_addresses | id | char | 36 | ||||
email_addresses_audit | id | char | 36 | ||||
email_marketing | id | char | 36 | ||||
email_marketing_prospect_lists | id | char | 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 | ||||
embedded_files | id | char | 36 | ||||
expressions | id | char | 36 | ||||
fields_meta_data | id | char | 36 | ||||
filters | id | char | 36 | ||||
folders | id | char | 36 | ||||
folders_rel | id | char | 36 | ||||
folders_subscriptions | id | char | 36 | ||||
forecast_manager_worksheets | id | char | 36 | ||||
forecast_manager_worksheets_audit | id | char | 36 | ||||
forecast_tree | id | char | 36 | ||||
forecast_worksheets | id | char | 36 | ||||
forecasts | id | char | 36 | ||||
fts_queue | id | char | 36 | ||||
holidays | id | char | 36 | ||||
import_maps | id | char | 36 | ||||
inbound_email | id | varchar | 255 | ||||
inbound_email_autoreply | id | char | 36 | ||||
inbound_email_cache_ts | id | varchar | 255 | ||||
job_queue | id | char | 36 | ||||
kbarticles | id | char | 36 | ||||
kbcontent_templates | id | char | 36 | ||||
kbcontent_templates_audit | id | char | 36 | ||||
kbcontents | id | char | 36 | ||||
kbcontents_audit | id | char | 36 | ||||
kbdocuments | id | char | 36 | ||||
kbusefulness | id | char | 36 | ||||
leads | id | char | 36 | ||||
leads_audit | id | char | 36 | ||||
leads_dataprivacy | id | char | 36 | ||||
linked_documents | id | char | 36 | ||||
locked_field_bean_rel | id | char | 36 | ||||
manufacturers | id | char | 36 | ||||
meetings | id | char | 36 | ||||
meetings_audit | id | char | 36 | ||||
meetings_contacts | id | char | 36 | ||||
meetings_leads | id | char | 36 | ||||
meetings_users | id | char | 36 | ||||
messages | id | char | 36 | ||||
messages_audit | id | char | 36 | ||||
metadata_cache | id | char | 36 | ||||
notes | id | char | 36 | ||||
notes_audit | id | char | 36 | ||||
notifications | 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 | char | 36 | ||||
outbound_email | id | char | 36 | ||||
pdfmanager | id | char | 36 | ||||
pmse_bpm_activity_definition | id | char | 36 | ||||
pmse_bpm_activity_step | id | char | 36 | ||||
pmse_bpm_activity_user | id | char | 36 | ||||
pmse_bpm_config | id | char | 36 | ||||
pmse_bpm_dynamic_forms | id | char | 36 | ||||
pmse_bpm_event_definition | id | char | 36 | ||||
pmse_bpm_flow | id | char | 36 | ||||
pmse_bpm_form_action | id | char | 36 | ||||
pmse_bpm_gateway_definition | id | char | 36 | ||||
pmse_bpm_group | id | char | 36 | ||||
pmse_bpm_group_user | id | char | 36 | ||||
pmse_bpm_notes | id | char | 36 | ||||
pmse_bpm_process_definition | id | char | 36 | ||||
pmse_bpm_related_dependency | id | char | 36 | ||||
pmse_bpm_thread | id | char | 36 | ||||
pmse_bpmn_activity | id | char | 36 | ||||
pmse_bpmn_artifact | id | char | 36 | ||||
pmse_bpmn_bound | id | char | 36 | ||||
pmse_bpmn_data | id | char | 36 | ||||
pmse_bpmn_diagram | id | char | 36 | ||||
pmse_bpmn_documentation | id | char | 36 | ||||
pmse_bpmn_event | id | char | 36 | ||||
pmse_bpmn_extension | id | char | 36 | ||||
pmse_bpmn_flow | id | char | 36 | ||||
pmse_bpmn_gateway | id | char | 36 | ||||
pmse_bpmn_lane | id | char | 36 | ||||
pmse_bpmn_laneset | id | char | 36 | ||||
pmse_bpmn_participant | id | char | 36 | ||||
pmse_bpmn_process | id | char | 36 | ||||
pmse_business_rules | id | char | 36 | ||||
pmse_email_message | id | char | 36 | ||||
pmse_emails_templates | id | char | 36 | ||||
pmse_inbox | id | char | 36 | ||||
pmse_project | id | char | 36 | ||||
product_bundle_note | id | char | 36 | ||||
product_bundle_notes | id | char | 36 | ||||
product_bundle_product | id | char | 36 | ||||
product_bundle_quote | id | char | 36 | ||||
product_bundles | id | char | 36 | ||||
product_categories | id | char | 36 | ||||
product_product | id | char | 36 | ||||
product_templates | id | char | 36 | ||||
product_templates_audit | 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 | char | 36 | ||||
projects_bugs | id | char | 36 |