SchemaSpy Analysis of a9b66e78 - Columnsgenerated Generated by
SchemaSpy
Generated on Tue Apr 28 07:32 UTC 2020
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

a9b66e78 contains 3802 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default
accounts account_type varchar 50  √  null
accounts acl_team_set_id char 36  √  null
accounts annual_revenue varchar 100  √  null
accounts assigned_user_id char 36  √  null
accounts billing_address_city varchar 100  √  null
accounts billing_address_country varchar 255  √  null
accounts billing_address_postalcode varchar 20  √  null
accounts billing_address_state varchar 100  √  null
accounts billing_address_street varchar 150  √  null
accounts business_center_id char 36  √  null
accounts campaign_id char 36  √  null
accounts created_by char 36  √  null
accounts date_entered datetime 19  √  null
accounts date_modified datetime 19  √  null
accounts deleted bit 1  √  0
accounts description text 65535  √  null
accounts duns_num varchar 15  √  null
accounts employees varchar 10  √  null
accounts facebook varchar 100  √  null
accounts googleplus varchar 100  √  null
accounts id char 36
accounts industry varchar 50  √  null
accounts modified_user_id char 36  √  null
accounts name varchar 150  √  null
accounts next_renewal_date date 10  √  null
accounts ownership varchar 100  √  null
accounts parent_id char 36  √  null
accounts phone_alternate varchar 100  √  null
accounts phone_fax varchar 100  √  null
accounts phone_office varchar 100  √  null
accounts rating varchar 100  √  null
accounts service_level varchar 255  √  null
accounts shipping_address_city varchar 100  √  null
accounts shipping_address_country varchar 255  √  null
accounts shipping_address_postalcode varchar 20  √  null
accounts shipping_address_state varchar 100  √  null
accounts shipping_address_street varchar 150  √  null
accounts sic_code varchar 10  √  null
accounts team_id char 36  √  null
accounts team_set_id char 36  √  null
accounts ticker_symbol varchar 10  √  null
accounts twitter varchar 100  √  null
accounts website varchar 255  √  null
accounts_audit after_value_string varchar 255  √  null
accounts_audit after_value_text text 65535  √  null
accounts_audit before_value_string varchar 255  √  null
accounts_audit before_value_text text 65535  √  null
accounts_audit created_by char 36  √  null
accounts_audit data_type varchar 100  √  null
accounts_audit date_created datetime 19  √  null
accounts_audit date_updated datetime 19  √  null
accounts_audit event_id char 36
accounts_audit field_name varchar 100  √  null
accounts_audit id char 36
accounts_audit parent_id char 36
accounts_bugs account_id char 36  √  null
accounts_bugs bug_id char 36  √  null
accounts_bugs date_modified datetime 19  √  null
accounts_bugs deleted bit 1  √  0
accounts_bugs id char 36
accounts_cases account_id char 36  √  null
accounts_cases case_id char 36  √  null
accounts_cases date_modified datetime 19  √  null
accounts_cases deleted bit 1  √  0
accounts_cases id char 36
accounts_contacts account_id char 36  √  null
accounts_contacts contact_id char 36  √  null
accounts_contacts date_modified datetime 19  √  null
accounts_contacts deleted bit 1  √  0
accounts_contacts id char 36
accounts_contacts primary_account bit 1  √  0
accounts_dataprivacy account_id char 36  √  null
accounts_dataprivacy dataprivacy_id char 36  √  null
accounts_dataprivacy date_modified datetime 19  √  null
accounts_dataprivacy deleted bit 1  √  0
accounts_dataprivacy id char 36
accounts_opportunities account_id char 36  √  null
accounts_opportunities date_modified datetime 19  √  null
accounts_opportunities deleted bit 1  √  0
accounts_opportunities id char 36
accounts_opportunities opportunity_id char 36  √  null
acl_actions aclaccess int 3  √  null
acl_actions acltype varchar 100  √  null
acl_actions category varchar 100  √  null
acl_actions created_by char 36  √  null
acl_actions date_entered datetime 19  √  null
acl_actions date_modified datetime 19  √  null
acl_actions deleted bit 1  √  0
acl_actions id char 36
acl_actions modified_user_id char 36  √  null
acl_actions name varchar 150  √  null
acl_fields aclaccess int 3  √  null
acl_fields category varchar 100  √  null
acl_fields created_by char 36  √  null
acl_fields date_entered datetime 19  √  null
acl_fields date_modified datetime 19  √  null
acl_fields deleted bit 1  √  0
acl_fields id char 36
acl_fields modified_user_id char 36  √  null
acl_fields name varchar 150  √  null
acl_fields role_id char 36
acl_role_sets created_by char 36  √  null
acl_role_sets date_entered datetime 19  √  null
acl_role_sets date_modified datetime 19  √  null
acl_role_sets deleted bit 1  √  0
acl_role_sets description text 65535  √  null
acl_role_sets hash varchar 32  √  null
acl_role_sets id char 36
acl_role_sets modified_user_id char 36  √  null
acl_role_sets name varchar 255  √  null
acl_role_sets_acl_roles acl_role_id char 36  √  null
acl_role_sets_acl_roles acl_role_set_id char 36  √  null
acl_role_sets_acl_roles date_modified datetime 19  √  null
acl_role_sets_acl_roles deleted bit 1  √  0
acl_role_sets_acl_roles id char 36
acl_roles created_by char 36  √  null
acl_roles date_entered datetime 19  √  null
acl_roles date_modified datetime 19  √  null
acl_roles deleted bit 1  √  0
acl_roles description text 65535  √  null
acl_roles id char 36
acl_roles modified_user_id char 36  √  null
acl_roles name varchar 150  √  null
acl_roles_actions access_override int 3  √  null
acl_roles_actions action_id char 36  √  null
acl_roles_actions date_modified datetime 19  √  null
acl_roles_actions deleted bit 1  √  0
acl_roles_actions id char 36
acl_roles_actions role_id char 36  √  null
acl_roles_users date_modified datetime 19  √  null
acl_roles_users deleted bit 1  √  0
acl_roles_users id char 36
acl_roles_users role_id char 36  √  null
acl_roles_users user_id char 36  √  null
activities activity_type varchar 100  √  null
activities comment_count int 11  √  0
activities created_by char 36  √  null
activities data longtext 2147483647  √  null
activities date_entered datetime 19  √  null
activities date_modified datetime 19  √  null
activities deleted bit 1  √  0
activities id char 36
activities last_comment longtext 2147483647  √  null
activities modified_user_id char 36  √  null
activities parent_id char 36  √  null
activities parent_type varchar 100  √  null
activities_users activity_id char 36
activities_users date_modified datetime 19  √  null
activities_users deleted bit 1  √  0
activities_users fields longtext 2147483647  √  null
activities_users id char 36
activities_users parent_id char 36  √  null
activities_users parent_type varchar 100  √  null
address_book assigned_user_id char 36
address_book bean varchar 50  √  null
address_book bean_id char 36
address_book_list_items bean_id char 36
address_book_list_items list_id char 36
address_book_lists assigned_user_id char 36
address_book_lists id char 36
address_book_lists list_name varchar 100  √  null
audit_events date_created datetime 19  √  null
audit_events id char 36
audit_events module_name varchar 100  √  null
audit_events parent_id char 36
audit_events source text 65535  √  null
audit_events type char 10  √  null
bugs acl_team_set_id char 36  √  null
bugs assigned_user_id char 36  √  null
bugs bug_number int 11  √ 
bugs business_hours_to_resolution decimal 12,2  √  null
bugs created_by char 36  √  null
bugs date_entered datetime 19  √  null
bugs date_modified datetime 19  √  null
bugs deleted bit 1  √  0
bugs description text 65535  √  null
bugs fixed_in_release varchar 255  √  null
bugs follow_up_datetime datetime 19  √  null
bugs found_in_release varchar 255  √  null
bugs hours_to_resolution decimal 12,2  √  null
bugs id char 36
bugs modified_user_id char 36  √  null
bugs name varchar 255  √  null
bugs pending_processing bit 1  √  0
bugs portal_viewable bit 1  √  1
bugs priority varchar 100  √  null
bugs product_category varchar 255  √  null
bugs resolution varchar 255  √  null
bugs resolved_datetime datetime 19  √  null
bugs source varchar 255  √  null
bugs status varchar 100  √  null
bugs team_id char 36  √  null
bugs team_set_id char 36  √  null
bugs type varchar 255  √  null
bugs work_log text 65535  √  null
bugs_audit after_value_string varchar 255  √  null
bugs_audit after_value_text text 65535  √  null
bugs_audit before_value_string varchar 255  √  null
bugs_audit before_value_text text 65535  √  null
bugs_audit created_by char 36  √  null
bugs_audit data_type varchar 100  √  null
bugs_audit date_created datetime 19  √  null
bugs_audit date_updated datetime 19  √  null
bugs_audit event_id char 36
bugs_audit field_name varchar 100  √  null
bugs_audit id char 36
bugs_audit parent_id char 36
business_centers acl_team_set_id char 36  √  null
business_centers address_city varchar 100  √  null
business_centers address_country varchar 255  √  null
business_centers address_postalcode varchar 20  √  null
business_centers address_state varchar 100  √  null
business_centers address_street varchar 150  √  null
business_centers assigned_user_id char 36  √  null
business_centers created_by char 36  √  null
business_centers date_entered datetime 19  √  null
business_centers date_modified datetime 19  √  null
business_centers deleted bit 1  √  0
business_centers description text 65535  √  null
business_centers friday_close_hour varchar 2  √  null
business_centers friday_close_minutes varchar 2  √  null
business_centers friday_open_hour varchar 2  √  null
business_centers friday_open_minutes varchar 2  √  null
business_centers id char 36
business_centers is_open_friday bit 1  √  1
business_centers is_open_monday bit 1  √  1
business_centers is_open_saturday bit 1  √  0
business_centers is_open_sunday bit 1  √  0
business_centers is_open_thursday bit 1  √  1
business_centers is_open_tuesday bit 1  √  1
business_centers is_open_wednesday bit 1  √  1
business_centers modified_user_id char 36  √  null
business_centers monday_close_hour varchar 2  √  null
business_centers monday_close_minutes varchar 2  √  null
business_centers monday_open_hour varchar 2  √  null
business_centers monday_open_minutes varchar 2  √  null
business_centers name varchar 255  √  null
business_centers saturday_close_hour varchar 2  √  null
business_centers saturday_close_minutes varchar 2  √  null
business_centers saturday_open_hour varchar 2  √  null
business_centers saturday_open_minutes varchar 2  √  null
business_centers sunday_close_hour varchar 2  √  null
business_centers sunday_close_minutes varchar 2  √  null
business_centers sunday_open_hour varchar 2  √  null
business_centers sunday_open_minutes varchar 2  √  null
business_centers team_id char 36  √  null
business_centers team_set_id char 36  √  null
business_centers thursday_close_hour varchar 2  √  null
business_centers thursday_close_minutes varchar 2  √  null
business_centers thursday_open_hour varchar 2  √  null
business_centers thursday_open_minutes varchar 2  √  null
business_centers timezone varchar 255  √  null
business_centers tuesday_close_hour varchar 2  √  null
business_centers tuesday_close_minutes varchar 2  √  null
business_centers tuesday_open_hour varchar 2  √  null
business_centers tuesday_open_minutes varchar 2  √  null
business_centers wednesday_close_hour varchar 2  √  null
business_centers wednesday_close_minutes varchar 2  √  null
business_centers wednesday_open_hour varchar 2  √  null
business_centers wednesday_open_minutes varchar 2  √  null
business_centers_audit after_value_string varchar 255  √  null
business_centers_audit after_value_text text 65535  √  null
business_centers_audit before_value_string varchar 255  √  null
business_centers_audit before_value_text text 65535  √  null
business_centers_audit created_by char 36  √  null
business_centers_audit data_type varchar 100  √  null
business_centers_audit date_created datetime 19  √  null
business_centers_audit date_updated datetime 19  √  null
business_centers_audit event_id char 36
business_centers_audit field_name varchar 100  √  null
business_centers_audit id char 36
business_centers_audit parent_id char 36
business_centers_holidays business_center_id char 36  √  null
business_centers_holidays date_modified datetime 19  √  null
business_centers_holidays deleted bit 1  √  0
business_centers_holidays holiday_id char 36  √  null
business_centers_holidays id char 36
calls acl_team_set_id char 36  √  null
calls assigned_user_id char 36  √  null
calls created_by char 36  √  null
calls date_end datetime 19  √  null
calls date_entered datetime 19  √  null
calls date_modified datetime 19  √  null
calls date_start datetime 19  √  null
calls deleted bit 1  √  0
calls description text 65535  √  null
calls direction varchar 100  √  null
calls duration_hours int 11  √  0
calls duration_minutes int 2  √  null
calls email_reminder_sent bit 1  √  0
calls email_reminder_time int 11  √  -1
calls id char 36
calls modified_user_id char 36  √  null
calls name varchar 50  √  null
calls outlook_id varchar 255  √  null
calls parent_id char 36  √  null
calls parent_type varchar 255  √  null
calls recurrence_id datetime 19  √  null
calls recurring_source varchar 36  √  null
calls reminder_time int 11  √  -1
calls repeat_count int 7  √  null
calls repeat_days varchar 128  √  null
calls repeat_dow varchar 7  √  null
calls repeat_interval int 3  √  1
calls repeat_ordinal varchar 36  √  null
calls repeat_parent_id char 36  √  null
calls repeat_selector varchar 36  √  null
calls repeat_type varchar 36  √  null
calls repeat_unit varchar 36  √  null
calls repeat_until date 10  √  null
calls status varchar 100  √  Planned
calls team_id char 36  √  null
calls team_set_id char 36  √  null
calls_contacts accept_status varchar 25  √  none
calls_contacts call_id char 36  √  null
calls_contacts contact_id char 36  √  null
calls_contacts date_modified datetime 19  √  null
calls_contacts deleted bit 1  √  0
calls_contacts id char 36
calls_contacts required varchar 1  √  1
calls_leads accept_status varchar 25  √  none
calls_leads call_id char 36  √  null
calls_leads date_modified datetime 19  √  null
calls_leads deleted bit 1  √  0
calls_leads id char 36
calls_leads lead_id char 36  √  null
calls_leads required varchar 1  √  1
calls_users accept_status varchar 25  √  none
calls_users call_id char 36  √  null
calls_users date_modified datetime 19  √  null
calls_users deleted bit 1  √  0
calls_users id char 36
calls_users required varchar 1  √  1
calls_users user_id char 36  √  null
campaign_log activity_date datetime 19  √  null
campaign_log activity_type varchar 100  √  null
campaign_log archived bit 1  √  0
campaign_log campaign_id char 36  √  null
campaign_log date_modified datetime 19  √  null
campaign_log deleted bit 1  √  0
campaign_log hits int 11  √  0
campaign_log id char 36
campaign_log list_id char 36  √  null
campaign_log marketing_id char 36  √  null
campaign_log more_information varchar 100  √  null
campaign_log related_id char 36  √  null
campaign_log related_type varchar 100  √  null
campaign_log target_id char 36  √  null
campaign_log target_tracker_key varchar 36  √  null
campaign_log target_type varchar 100  √  null
campaign_trkrs campaign_id char 36  √  null
campaign_trkrs created_by char 36  √  null
campaign_trkrs date_entered datetime 19  √  null
campaign_trkrs date_modified datetime 19  √  null
campaign_trkrs deleted bit 1  √  0
campaign_trkrs id char 36
campaign_trkrs is_optout bit 1  √  0
campaign_trkrs modified_user_id char 36  √  null
campaign_trkrs tracker_key int 11  √ 
campaign_trkrs tracker_name varchar 30  √  null
campaign_trkrs tracker_url varchar 255  √  http://
campaigns acl_team_set_id char 36  √  null
campaigns actual_cost decimal 26,6  √  null
campaigns assigned_user_id char 36  √  null
campaigns base_rate decimal 26,6  √  null
campaigns budget decimal 26,6  √  null
campaigns campaign_type varchar 100  √  null
campaigns content text 65535  √  null
campaigns created_by char 36  √  null
campaigns currency_id char 36  √  -99
campaigns date_entered datetime 19  √  null
campaigns date_modified datetime 19  √  null
campaigns deleted bit 1  √  0
campaigns end_date date 10  √  null
campaigns expected_cost decimal 26,6  √  null
campaigns expected_revenue decimal 26,6  √  null
campaigns frequency varchar 100  √  null
campaigns id char 36
campaigns impressions int 11  √  0
campaigns modified_user_id char 36  √  null
campaigns name varchar 50  √  null
campaigns objective text 65535  √  null
campaigns refer_url varchar 255  √  http://
campaigns start_date date 10  √  null
campaigns status varchar 100  √  null
campaigns team_id char 36  √  null
campaigns team_set_id char 36  √  null
campaigns tracker_count int 11  √  0
campaigns tracker_key int 11  √ 
campaigns tracker_text varchar 255  √  null
campaigns_audit after_value_string varchar 255  √  null
campaigns_audit after_value_text text 65535  √  null
campaigns_audit before_value_string varchar 255  √  null
campaigns_audit before_value_text text 65535  √  null
campaigns_audit created_by char 36  √  null
campaigns_audit data_type varchar 100  √  null
campaigns_audit date_created datetime 19  √  null
campaigns_audit date_updated datetime 19  √  null
campaigns_audit event_id char 36
campaigns_audit field_name varchar 100  √  null
campaigns_audit id char 36
campaigns_audit parent_id char 36
cases account_id char 36  √  null
cases acl_team_set_id char 36  √  null
cases assigned_user_id char 36  √  null
cases business_center_id char 36  √  null
cases business_hours_to_resolution decimal 12,2  √  null
cases business_hrs_to_first_response decimal 12,2  √  null
cases case_number int 11  √ 
cases created_by char 36  √  null
cases date_entered datetime 19  √  null
cases date_modified datetime 19  √  null
cases deleted bit 1  √  0
cases description longtext 2147483647  √  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
cases follow_up_datetime datetime 19  √  null
cases hours_to_first_response decimal 12,2  √  null
cases hours_to_resolution decimal 12,2  √  null
cases id char 36
cases modified_user_id char 36  √  null
cases name varchar 255  √  null
cases pending_processing bit 1  √  0
cases portal_viewable bit 1  √  1
cases primary_contact_id char 36  √  null
cases priority varchar 100  √  null
cases resolution text 65535  √  null
cases resolved_datetime datetime 19  √  null
cases source varchar 255  √  null
cases status varchar 100  √  null
cases team_id char 36  √  null
cases team_set_id char 36  √  null
cases type varchar 255  √  null
cases work_log text 65535  √  null
cases_audit after_value_string varchar 255  √  null
cases_audit after_value_text text 65535  √  null
cases_audit before_value_string varchar 255  √  null
cases_audit before_value_text text 65535  √  null
cases_audit created_by char 36  √  null
cases_audit data_type varchar 100  √  null
cases_audit date_created datetime 19  √  null
cases_audit date_updated datetime 19  √  null
cases_audit event_id char 36
cases_audit field_name varchar 100  √  null
cases_audit id char 36
cases_audit parent_id char 36
cases_bugs bug_id char 36  √  null
cases_bugs case_id char 36  √  null
cases_bugs date_modified datetime 19  √  null
cases_bugs deleted bit 1  √  0
cases_bugs id char 36
categories created_by char 36  √  null
categories date_entered datetime 19  √  null
categories date_modified datetime 19  √  null
categories deleted bit 1  √  0
categories description text 65535  √  null
categories id char 36
categories is_external bit 1  √  0
categories lft int 11
categories lvl int 11
categories modified_user_id char 36  √  null
categories name varchar 255  √  null
categories rgt int 11
categories root char 36  √  null
categories source_id varchar 255  √  null
categories source_meta text 65535  √  null
categories source_type varchar 255  √  null
category_tree node_id int 11  √ 
category_tree parent_node_id int 11  √  0
category_tree self_id char 36  √  null
category_tree type varchar 36  √  null
changetimers business_hours decimal 12,2  √  null
changetimers created_by char 36  √  null
changetimers date_entered datetime 19  √  null
changetimers date_modified datetime 19  √  null
changetimers deleted bit 1  √  0
changetimers description text 65535  √  null
changetimers field_name varchar 100  √  null
changetimers from_datetime datetime 19  √  null
changetimers hours decimal 12,2  √  null
changetimers id char 36
changetimers modified_user_id char 36  √  null
changetimers name varchar 255  √  null
changetimers parent_id char 36  √  null
changetimers parent_type varchar 255  √  null
changetimers to_datetime datetime 19  √  null
changetimers value_string varchar 255  √  null
commentlog created_by char 36  √  null
commentlog date_entered datetime 19  √  null
commentlog date_modified datetime 19  √  null
commentlog deleted bit 1  √  0
commentlog description text 65535  √  null
commentlog entry text 65535  √  null
commentlog id char 36
commentlog modified_user_id char 36  √  null
commentlog name varchar 255  √  null
commentlog_rel commentlog_id char 36
commentlog_rel deleted bit 1  √  0
commentlog_rel id char 36
commentlog_rel module varchar 100  √  null
commentlog_rel record_id char 36
comments created_by char 36  √  null
comments data longtext 2147483647  √  null
comments date_entered datetime 19  √  null
comments date_modified datetime 19  √  null
comments deleted bit 1  √  0
comments id char 36
comments modified_user_id char 36  √  null
comments parent_id char 36
config category varchar 32  √  null
config name varchar 32  √  null
config platform varchar 32  √  null
config value text 65535  √  null
console_configuration created_by char 36  √  null
console_configuration date_entered datetime 19  √  null
console_configuration date_modified datetime 19  √  null
console_configuration deleted bit 1  √  0
console_configuration description text 65535  √  null
console_configuration enabled_modules varchar 255  √  null
console_configuration filter_def text 65535  √  null
console_configuration id char 36
console_configuration modified_user_id char 36  √  null
console_configuration name varchar 255  √  null
console_configuration order_by_primary varchar 255  √  null
console_configuration order_by_secondary varchar 255  √  null
contacts acl_team_set_id char 36  √  null
contacts alt_address_city varchar 100  √  null
contacts alt_address_country varchar 255  √  null
contacts alt_address_postalcode varchar 20  √  null
contacts alt_address_state varchar 100  √  null
contacts alt_address_street varchar 150  √  null
contacts assigned_user_id char 36  √  null
contacts assistant varchar 75  √  null
contacts assistant_phone varchar 100  √  null
contacts birthdate date 10  √  null
contacts business_center_id char 36  √  null
contacts campaign_id char 36  √  null
contacts cookie_consent bit 1  √  0
contacts cookie_consent_received_on datetime 19  √  null
contacts created_by char 36  √  null
contacts date_entered datetime 19  √  null
contacts date_modified datetime 19  √  null
contacts deleted bit 1  √  0
contacts department varchar 255  √  null
contacts description text 65535  √  null
contacts dnb_principal_id varchar 30  √  null
contacts do_not_call bit 1  √  0
contacts dp_business_purpose text 65535  √  null
contacts dp_consent_last_updated date 10  √  null
contacts entry_source varchar 255  √  internal
contacts facebook varchar 100  √  null
contacts first_name varchar 100  √  null
contacts googleplus varchar 100  √  null
contacts id char 36
contacts last_name varchar 100  √  null
contacts lead_source varchar 255  √  null
contacts mkto_id int 11  √  null
contacts mkto_lead_score int 11  √  null
contacts mkto_sync bit 1  √  0
contacts modified_user_id char 36  √  null
contacts phone_fax varchar 100  √  null
contacts phone_home varchar 100  √  null
contacts phone_mobile varchar 100  √  null
contacts phone_other varchar 100  √  null
contacts phone_work varchar 100  √  null
contacts picture varchar 255  √  null
contacts portal_active bit 1  √  0
contacts portal_app varchar 255  √  null
contacts portal_name varchar 255  √  null
contacts portal_password varchar 255  √  null
contacts portal_user_company_name varchar 255  √  null
contacts preferred_language varchar 255  √  null
contacts primary_address_city varchar 100  √  null
contacts primary_address_country varchar 255  √  null
contacts primary_address_postalcode varchar 20  √  null
contacts primary_address_state varchar 100  √  null
contacts primary_address_street varchar 150  √  null
contacts reports_to_id char 36  √  null
contacts salutation varchar 255  √  null
contacts site_user_id varchar 64  √  null
contacts team_id char 36  √  null
contacts team_set_id char 36  √  null
contacts title varchar 100  √  null
contacts twitter varchar 100  √  null
contacts_audit after_value_string varchar 255  √  null
contacts_audit after_value_text text 65535  √  null
contacts_audit before_value_string varchar 255  √  null
contacts_audit before_value_text text 65535  √  null
contacts_audit created_by char 36  √  null
contacts_audit data_type varchar 100  √  null
contacts_audit date_created datetime 19  √  null
contacts_audit date_updated datetime 19  √  null
contacts_audit event_id char 36
contacts_audit field_name varchar 100  √  null
contacts_audit id char 36
contacts_audit parent_id char 36
contacts_bugs bug_id char 36  √  null
contacts_bugs contact_id char 36  √  null
contacts_bugs contact_role varchar 50  √  null
contacts_bugs date_modified datetime 19  √  null
contacts_bugs deleted bit 1  √  0
contacts_bugs id char 36
contacts_cases case_id char 36  √  null
contacts_cases contact_id char 36  √  null
contacts_cases contact_role varchar 50  √  null
contacts_cases date_modified datetime 19  √  null
contacts_cases deleted bit 1  √  0
contacts_cases id char 36
contacts_dataprivacy contact_id char 36  √  null
contacts_dataprivacy dataprivacy_id char 36  √  null
contacts_dataprivacy date_modified datetime 19  √  null
contacts_dataprivacy deleted bit 1  √  0
contacts_dataprivacy id char 36
contacts_users contact_id char 36  √  null
contacts_users date_modified datetime 19  √  null
contacts_users deleted bit 1  √  0
contacts_users id char 36
contacts_users user_id char 36  √  null
contract_types created_by char 36  √  null
contract_types date_entered datetime 19  √  null
contract_types date_modified datetime 19  √  null
contract_types deleted bit 1  √  0
contract_types description text 65535  √  null
contract_types id char 36
contract_types list_order int 4  √  null
contract_types modified_user_id char 36  √  null
contract_types name varchar 255  √  null
contracts account_id char 36  √  null
contracts acl_team_set_id char 36  √  null
contracts assigned_user_id char 36  √  null
contracts base_rate decimal 26,6  √  null
contracts company_signed_date date 10  √  null
contracts created_by char 36  √  null
contracts currency_id char 36  √  -99
contracts customer_signed_date date 10  √  null
contracts date_entered datetime 19  √  null
contracts date_modified datetime 19  √  null
contracts deleted bit 1  √  0
contracts description text 65535  √  null
contracts end_date date 10  √  null
contracts expiration_notice datetime 19  √  null
contracts id char 36
contracts modified_user_id char 36  √  null
contracts name varchar 255  √  null
contracts reference_code varchar 255  √  null
contracts start_date date 10  √  null
contracts status varchar 100  √  null
contracts team_id char 36  √  null
contracts team_set_id char 36  √  null
contracts total_contract_value decimal 26,6  √  null
contracts total_contract_value_usdollar decimal 26,6  √  null
contracts type varchar 255  √  null
contracts_audit after_value_string varchar 255  √  null
contracts_audit after_value_text text 65535  √  null
contracts_audit before_value_string varchar 255  √  null
contracts_audit before_value_text text 65535  √  null
contracts_audit created_by char 36  √  null
contracts_audit data_type varchar 100  √  null
contracts_audit date_created datetime 19  √  null
contracts_audit date_updated datetime 19  √  null
contracts_audit event_id char 36
contracts_audit field_name varchar 100  √  null
contracts_audit id char 36
contracts_audit parent_id char 36
contracts_contacts contact_id char 36  √  null
contracts_contacts contract_id char 36  √  null
contracts_contacts date_modified datetime 19  √  null
contracts_contacts deleted bit 1  √  0
contracts_contacts id char 36
contracts_opportunities contract_id char 36  √  null
contracts_opportunities date_modified datetime 19  √  null
contracts_opportunities deleted bit 1  √  0
contracts_opportunities id char 36
contracts_opportunities opportunity_id char 36  √  null
contracts_products contract_id char 36  √  null
contracts_products date_modified datetime 19  √  null
contracts_products deleted bit 1  √  0
contracts_products id char 36
contracts_products product_id char 36  √  null
contracts_quotes contract_id char 36  √  null
contracts_quotes date_modified datetime 19  √  null
contracts_quotes deleted bit 1  √  0
contracts_quotes id char 36
contracts_quotes quote_id char 36  √  null
currencies conversion_rate decimal 26,6  √  0.000000
currencies created_by char 36
currencies date_entered datetime 19  √  null
currencies date_modified datetime 19  √  null
currencies deleted bit 1  √  0
currencies id char 36
currencies iso4217 varchar 3  √  null
currencies name varchar 36  √  null
currencies status varchar 100  √  null
currencies symbol varchar 36  √  null
custom_fields bean_id char 36  √  null
custom_fields deleted bit 1  √  0
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
custom_fields set_num int 11  √  0
custom_queries acl_team_set_id char 36  √  null
custom_queries created_by char 36  √  null
custom_queries custom_query text 65535  √  null
custom_queries date_entered datetime 19  √  null
custom_queries date_modified datetime 19  √  null
custom_queries deleted bit 1  √  0
custom_queries description text 65535  √  null
custom_queries id char 36
custom_queries list_order int 4  √  null
custom_queries modified_user_id char 36  √  null
custom_queries name varchar 50  √  null
custom_queries query_locked varchar 3  √  0
custom_queries query_type varchar 50  √  null
custom_queries team_id char 36  √  null
custom_queries team_set_id char 36  √  null
dashboards acl_team_set_id char 36  √  null
dashboards assigned_user_id char 36  √  null
dashboards created_by char 36  √  null
dashboards dashboard_module varchar 100  √  null
dashboards date_entered datetime 19  √  null
dashboards date_modified datetime 19  √  null
dashboards default_dashboard bit 1  √  0
dashboards deleted bit 1  √  0
dashboards description text 65535  √  null
dashboards id char 36
dashboards metadata text 65535  √  null
dashboards modified_user_id char 36  √  null
dashboards name varchar 255  √  null
dashboards team_id char 36  √  null
dashboards team_set_id char 36  √  null
dashboards view_name varchar 100  √  null
data_privacy acl_team_set_id char 36  √  null
data_privacy assigned_user_id char 36  √  null
data_privacy business_hours_to_resolution decimal 12,2  √  null
data_privacy business_purpose text 65535  √  null
data_privacy created_by char 36  √  null
data_privacy dataprivacy_number int 11  √ 
data_privacy date_closed date 10  √  null
data_privacy date_due date 10  √  null
data_privacy date_entered datetime 19  √  null
data_privacy date_modified datetime 19  √  null
data_privacy date_opened date 10  √  null
data_privacy deleted bit 1  √  0
data_privacy description text 65535  √  null
data_privacy fields_to_erase text 65535  √  null
data_privacy follow_up_datetime datetime 19  √  null
data_privacy hours_to_resolution decimal 12,2  √  null
data_privacy id char 36
data_privacy modified_user_id char 36  √  null
data_privacy name varchar 255  √  null
data_privacy pending_processing bit 1  √  0
data_privacy priority varchar 100  √  null
data_privacy requested_by varchar 255  √  null
data_privacy resolution text 65535  √  null
data_privacy resolved_datetime datetime 19  √  null
data_privacy source varchar 255  √  null
data_privacy status varchar 100  √  Open
data_privacy team_id char 36  √  null
data_privacy team_set_id char 36  √  null
data_privacy type varchar 255  √  null
data_privacy work_log text 65535  √  null
data_privacy_audit after_value_string varchar 255  √  null
data_privacy_audit after_value_text text 65535  √  null
data_privacy_audit before_value_string varchar 255  √  null
data_privacy_audit before_value_text text 65535  √  null
data_privacy_audit created_by char 36  √  null
data_privacy_audit data_type varchar 100  √  null
data_privacy_audit date_created datetime 19  √  null
data_privacy_audit date_updated datetime 19  √  null
data_privacy_audit event_id char 36
data_privacy_audit field_name varchar 100  √  null
data_privacy_audit id char 36
data_privacy_audit parent_id char 36
data_sets acl_team_set_id char 36  √  null
data_sets body_back_color varchar 100  √  null
data_sets body_text_color varchar 100  √  null
data_sets created_by char 36  √  null
data_sets custom_layout varchar 10  √  null
data_sets date_entered datetime 19  √  null
data_sets date_modified datetime 19  √  null
data_sets deleted bit 1  √  0
data_sets description text 65535  √  null
data_sets exportable varchar 3  √  0
data_sets font_size varchar 8  √  0
data_sets header varchar 3  √  0
data_sets header_back_color varchar 100  √  null
data_sets header_text_color varchar 100  √  null
data_sets id char 36
data_sets list_order_y int 3  √  0
data_sets modified_user_id char 36  √  null
data_sets name varchar 50  √  null
data_sets output_default varchar 100  √  null
data_sets parent_id char 36  √  null
data_sets prespace_y varchar 3  √  0
data_sets query_id char 36
data_sets report_id char 36  √  null
data_sets table_width varchar 3  √  0
data_sets table_width_type varchar 3  √  null
data_sets team_id char 36  √  null
data_sets team_set_id char 36  √  null
data_sets use_prev_header varchar 3  √  0
dataset_attributes attribute_type varchar 8  √  null
dataset_attributes bg_color varchar 25  √  null
dataset_attributes cell_size varchar 3  √  null
dataset_attributes created_by char 36  √  null
dataset_attributes date_entered datetime 19  √  null
dataset_attributes date_modified datetime 19  √  null
dataset_attributes deleted bit 1  √  0
dataset_attributes display_name varchar 50  √  null
dataset_attributes display_type varchar 25  √  null
dataset_attributes font_color varchar 25  √  null
dataset_attributes font_size varchar 8  √  0
dataset_attributes format_type varchar 25  √  null
dataset_attributes id char 36
dataset_attributes modified_user_id char 36  √  null
dataset_attributes parent_id char 36  √  null
dataset_attributes size_type varchar 3  √  null
dataset_attributes style varchar 25  √  null
dataset_attributes wrap varchar 3  √  null
dataset_layouts created_by char 36  √  null
dataset_layouts date_entered datetime 19  √  null
dataset_layouts date_modified datetime 19  √  null
dataset_layouts deleted bit 1  √  0
dataset_layouts hide_column varchar 3  √  null
dataset_layouts id char 36
dataset_layouts layout_type varchar 25  √  null
dataset_layouts list_order_x int 4  √  null
dataset_layouts list_order_z int 4  √  null
dataset_layouts modified_user_id char 36  √  null
dataset_layouts parent_id char 36  √  null
dataset_layouts parent_value varchar 50  √  null
dataset_layouts row_header_id char 36  √  null
document_revisions change_log varchar 255  √  null
document_revisions created_by char 36  √  null
document_revisions date_entered datetime 19  √  null
document_revisions date_modified datetime 19  √  null
document_revisions deleted bit 1  √  0
document_revisions doc_id varchar 100  √  null
document_revisions doc_type varchar 100  √  null
document_revisions doc_url varchar 255  √  null
document_revisions document_id char 36  √  null
document_revisions file_ext varchar 100  √  null
document_revisions file_mime_type varchar 100  √  null
document_revisions file_size int 11  √  null
document_revisions filename varchar 255  √  null
document_revisions id char 36
document_revisions revision varchar 100  √  null
documents acl_team_set_id char 36  √  null
documents active_date date 10  √  null
documents assigned_user_id char 36  √  null
documents category_id varchar 100  √  null
documents created_by char 36  √  null
documents date_entered datetime 19  √  null
documents date_modified datetime 19  √  null
documents deleted bit 1  √  0
documents description text 65535  √  null
documents doc_id varchar 100  √  null
documents doc_type varchar 100  √  Sugar
documents doc_url varchar 255  √  null
documents document_name varchar 255  √  null
documents document_revision_id char 36  √  null
documents exp_date date 10  √  null
documents id char 36
documents is_template bit 1  √  0
documents modified_user_id char 36  √  null
documents related_doc_id char 36  √  null
documents related_doc_rev_id char 36  √  null
documents status_id varchar 100  √  null
documents subcategory_id varchar 100  √  null
documents team_id char 36  √  null
documents team_set_id char 36  √  null
documents template_type varchar 100  √  null
documents_accounts account_id char 36  √  null
documents_accounts date_modified datetime 19  √  null
documents_accounts deleted bit 1  √  0
documents_accounts document_id char 36  √  null
documents_accounts id char 36
documents_bugs bug_id char 36  √  null
documents_bugs date_modified datetime 19  √  null
documents_bugs deleted bit 1  √  0
documents_bugs document_id char 36  √  null
documents_bugs id char 36
documents_cases case_id char 36  √  null
documents_cases date_modified datetime 19  √  null
documents_cases deleted bit 1  √  0
documents_cases document_id char 36  √  null
documents_cases id char 36
documents_contacts contact_id char 36  √  null
documents_contacts date_modified datetime 19  √  null
documents_contacts deleted bit 1  √  0
documents_contacts document_id char 36  √  null
documents_contacts id char 36
documents_opportunities date_modified datetime 19  √  null
documents_opportunities deleted bit 1  √  0
documents_opportunities document_id char 36  √  null
documents_opportunities id char 36
documents_opportunities opportunity_id char 36  √  null
documents_products date_modified datetime 19  √  null
documents_products deleted bit 1  √  0
documents_products document_id char 36  √  null
documents_products id char 36
documents_products product_id char 36  √  null
documents_quotes date_modified datetime 19  √  null
documents_quotes deleted bit 1  √  0
documents_quotes document_id char 36  √  null
documents_quotes id char 36
documents_quotes quote_id char 36  √  null
documents_revenuelineitems date_modified datetime 19  √  null
documents_revenuelineitems deleted bit 1  √  0
documents_revenuelineitems document_id char 36  √  null
documents_revenuelineitems id char 36
documents_revenuelineitems rli_id char 36  √  null
eapm api_data text 65535  √  null
eapm application varchar 100  √  webex
eapm assigned_user_id char 36  √  null
eapm consumer_key varchar 255  √  null
eapm consumer_secret varchar 255  √  null
eapm created_by char 36  √  null
eapm date_entered datetime 19  √  null
eapm date_modified datetime 19  √  null
eapm deleted bit 1  √  0
eapm description text 65535  √  null
eapm id char 36
eapm modified_user_id char 36  √  null
eapm name varchar 255  √  null
eapm oauth_secret varchar 255  √  null
eapm oauth_token varchar 255  √  null
eapm password varchar 255  √  null
eapm url varchar 255  √  null
eapm validated bit 1  √  0
email_addr_bean_rel bean_id char 36
email_addr_bean_rel bean_module varchar 100  √  null
email_addr_bean_rel date_created datetime 19  √  null
email_addr_bean_rel date_modified datetime 19  √  null
email_addr_bean_rel deleted bit 1  √  0
email_addr_bean_rel email_address_id char 36
email_addr_bean_rel id char 36
email_addr_bean_rel primary_address bit 1  √  0
email_addr_bean_rel reply_to_address bit 1  √  0
email_addresses confirmation_requested_on datetime 19  √  null
email_addresses date_created datetime 19  √  null
email_addresses date_modified datetime 19  √  null
email_addresses deleted bit 1  √  0
email_addresses email_address varchar 255  √  null
email_addresses email_address_caps varchar 255  √  null
email_addresses id char 36
email_addresses invalid_email bit 1  √  0
email_addresses opt_out bit 1  √  0
email_addresses_audit after_value_string varchar 255  √  null
email_addresses_audit after_value_text text 65535  √  null
email_addresses_audit before_value_string varchar 255  √  null
email_addresses_audit before_value_text text 65535  √  null
email_addresses_audit created_by char 36  √  null
email_addresses_audit data_type varchar 100  √  null
email_addresses_audit date_created datetime 19  √  null
email_addresses_audit date_updated datetime 19  √  null
email_addresses_audit event_id char 36
email_addresses_audit field_name varchar 100  √  null
email_addresses_audit id char 36
email_addresses_audit parent_id char 36
email_cache answered tinyint 4  √  null
email_cache deleted tinyint 4  √  null
email_cache draft tinyint 4  √  null
email_cache flagged tinyint 4  √  null
email_cache fromaddr varchar 100  √  null
email_cache ie_id char 36  √  null
email_cache imap_uid int unsigned 10  √  null
email_cache mailsize int unsigned 10  √  null
email_cache mbox varchar 60  √  null
email_cache message_id varchar 255  √  null
email_cache msgno int unsigned 10  √  null
email_cache recent tinyint 4  √  null
email_cache seen tinyint 4  √  null
email_cache senddate datetime 19  √  null
email_cache subject varchar 255  √  null
email_cache toaddr varchar 255  √  null
email_marketing all_prospect_lists bit 1  √  0
email_marketing campaign_id char 36  √  null
email_marketing created_by char 36  √  null
email_marketing date_entered datetime 19  √  null
email_marketing date_modified datetime 19  √  null
email_marketing date_start datetime 19  √  null
email_marketing deleted bit 1  √  0
email_marketing from_addr varchar 100  √  null
email_marketing from_name varchar 100  √  null
email_marketing id char 36
email_marketing inbound_email_id char 36  √  null
email_marketing modified_user_id char 36  √  null
email_marketing name varchar 255  √  null
email_marketing reply_to_addr varchar 100  √  null
email_marketing reply_to_name varchar 100  √  null
email_marketing status varchar 100  √  null
email_marketing template_id char 36
email_marketing_prospect_lists date_modified datetime 19  √  null
email_marketing_prospect_lists deleted bit 1  √  0
email_marketing_prospect_lists email_marketing_id char 36  √  null
email_marketing_prospect_lists id char 36
email_marketing_prospect_lists prospect_list_id char 36  √  null
email_templates acl_team_set_id char 36  √  null
email_templates assigned_user_id char 36  √  null
email_templates base_module varchar 50  √  null
email_templates body text 65535  √  null
email_templates body_html text 65535  √  null
email_templates created_by char 36  √  null
email_templates date_entered datetime 19  √  null
email_templates date_modified datetime 19  √  null
email_templates deleted bit 1  √  0
email_templates description text 65535  √  null
email_templates from_address varchar 255  √  null
email_templates from_name varchar 255  √  null
email_templates has_variables bit 1  √  0
email_templates id char 36
email_templates modified_user_id char 36  √  null
email_templates name varchar 255  √  null
email_templates published varchar 3  √  null
email_templates subject varchar 255  √  null
email_templates team_id char 36  √  null
email_templates team_set_id char 36  √  null
email_templates text_only bit 1  √  0
email_templates type varchar 255  √  email
emailman campaign_id char 36  √  null
emailman date_entered datetime 19  √  null
emailman date_modified datetime 19  √  null
emailman deleted bit 1  √  0
emailman id int 11  √ 
emailman in_queue bit 1  √  0
emailman in_queue_date datetime 19  √  null
emailman list_id char 36  √  null
emailman marketing_id char 36  √  null
emailman modified_user_id char 36  √  null
emailman related_id char 36  √  null
emailman related_type varchar 100  √  null
emailman send_attempts int 11  √  0
emailman send_date_time datetime 19  √  null
emailman user_id char 36  √  null
emails acl_team_set_id char 36  √  null
emails assigned_user_id char 36  √  null
emails created_by char 36  √  null
emails date_entered datetime 19  √  null
emails date_modified datetime 19  √  null
emails date_sent datetime 19  √  null
emails deleted bit 1  √  0
emails direction varchar 20 Unknown
emails flagged bit 1  √  0
emails id char 36
emails intent varchar 100  √  pick
emails mailbox_id char 36  √  null
emails message_id varchar 255  √  null
emails message_uid varchar 64  √  null
emails modified_user_id char 36  √  null
emails name varchar 255  √  null
emails outbound_email_id char 36  √  null
emails parent_id char 36  √  null
emails parent_type varchar 255  √  null
emails reply_to_id char 36  √  null
emails reply_to_status bit 1  √  0
emails state varchar 100 Archived
emails status varchar 100  √  null
emails team_id char 36  √  null
emails team_set_id char 36  √  null
emails total_attachments int 11  √  null
emails type varchar 100  √  null
emails_beans bean_id char 36  √  null
emails_beans bean_module varchar 100  √  null
emails_beans campaign_data text 65535  √  null
emails_beans date_modified datetime 19  √  null
emails_beans deleted bit 1  √  0
emails_beans email_id char 36  √  null
emails_beans id char 36
emails_email_addr_rel address_type varchar 4  √  null
emails_email_addr_rel date_entered datetime 19  √  null
emails_email_addr_rel date_modified datetime 19  √  null
emails_email_addr_rel deleted bit 1  √  0
emails_email_addr_rel email_address_id char 36  √  null
emails_email_addr_rel email_id char 36  √  null
emails_email_addr_rel id char 36
emails_email_addr_rel parent_id char 36  √  null
emails_email_addr_rel parent_type varchar 255  √  null
emails_text bcc_addrs text 65535  √  null
emails_text cc_addrs text 65535  √  null
emails_text deleted bit 1  √  0
emails_text description longtext 2147483647  √  null
emails_text description_html longtext 2147483647  √  null
emails_text email_id char 36
emails_text from_addr varchar 255  √  null
emails_text raw_source longtext 2147483647  √  null
emails_text reply_to_addr varchar 255  √  null
emails_text to_addrs text 65535  √  null
embedded_files created_by char 36  √  null
embedded_files date_entered datetime 19  √  null
embedded_files date_modified datetime 19  √  null
embedded_files deleted bit 1  √  0
embedded_files description text 65535  √  null
embedded_files file_mime_type varchar 100  √  null
embedded_files filename varchar 255  √  null
embedded_files id char 36
embedded_files modified_user_id char 36  √  null
embedded_files name varchar 255  √  null
erased_fields bean_id char 36
erased_fields data text 65535  √  null
erased_fields table_name varchar 128
expressions created_by char 36  √  null
expressions date_entered datetime 19  √  null
expressions date_modified datetime 19  √  null
expressions deleted bit 1  √  0
expressions exp_order int 4  √  null
expressions exp_type varchar 100  √  null
expressions ext1 varchar 50  √  null
expressions ext2 varchar 50  √  null
expressions ext3 varchar 50  √  null
expressions id char 36
expressions lhs_field varchar 50  √  null
expressions lhs_group_type varchar 10  √  null
expressions lhs_module varchar 50  √  null
expressions lhs_type varchar 15  √  null
expressions lhs_value varchar 100  √  null
expressions modified_user_id char 36  √  null
expressions operator varchar 15  √  null
expressions parent_exp_id char 36  √  null
expressions parent_exp_side int 8  √  null
expressions parent_id char 36
expressions parent_type varchar 255  √  null
expressions rhs_field varchar 50  √  null
expressions rhs_group_type varchar 10  √  null
expressions rhs_module varchar 50  √  null
expressions rhs_type varchar 15  √  null
expressions rhs_value varchar 255  √  null
fields_meta_data audited bit 1  √  0
fields_meta_data comments varchar 255  √  null
fields_meta_data custom_module varchar 255  √  null
fields_meta_data date_modified datetime 19  √  null
fields_meta_data default_value varchar 255  √  null
fields_meta_data deleted bit 1  √  0
fields_meta_data duplicate_merge smallint 6  √  0
fields_meta_data ext1 varchar 255  √ 
fields_meta_data ext2 varchar 255  √ 
fields_meta_data ext3 varchar 255  √ 
fields_meta_data ext4 text 65535  √  null
fields_meta_data help varchar 255  √  null
fields_meta_data id varchar 255
fields_meta_data importable varchar 255  √  null
fields_meta_data len int 11  √  null
fields_meta_data massupdate bit 1  √  0
fields_meta_data name varchar 255  √  null
fields_meta_data reportable bit 1  √  1
fields_meta_data required bit 1  √  0
fields_meta_data type varchar 255  √  null
fields_meta_data vname varchar 255  √  null
filters acl_team_set_id char 36  √  null
filters assigned_user_id char 36  √  null
filters created_by char 36  √  null
filters date_entered datetime 19  √  null
filters date_modified datetime 19  √  null
filters deleted bit 1  √  0
filters description text 65535  √  null
filters filter_definition longtext 2147483647  √  null
filters filter_template longtext 2147483647  √  null
filters id char 36
filters modified_user_id char 36  √  null
filters module_name varchar 100  √  null
filters name varchar 255  √  null
filters team_id char 36  √  null
filters team_set_id char 36  √  null
folders acl_team_set_id char 36  √  null
folders assign_to_id char 36  √  null
folders created_by char 36
folders deleted bit 1  √  0
folders dynamic_query text 65535  √  null
folders folder_type varchar 25  √  null
folders has_child bit 1  √  0
folders id char 36
folders is_dynamic bit 1  √  0
folders is_group bit 1  √  0
folders modified_by char 36
folders name varchar 25  √  null
folders parent_folder char 36  √  null
folders team_id char 36  √  null
folders team_set_id char 36  √  null
folders_rel deleted bit 1  √  0
folders_rel folder_id char 36
folders_rel id char 36
folders_rel polymorphic_id char 36
folders_rel polymorphic_module varchar 25  √  null
folders_subscriptions assigned_user_id char 36
folders_subscriptions folder_id char 36
folders_subscriptions id char 36
forecast_manager_worksheets acl_team_set_id char 36  √  null
forecast_manager_worksheets assigned_user_id char 36  √  null
forecast_manager_worksheets base_rate decimal 26,6  √  null
forecast_manager_worksheets best_case decimal 26,6  √  null
forecast_manager_worksheets best_case_adjusted decimal 26,6  √  null
forecast_manager_worksheets closed_amount decimal 26,6  √  0.000000
forecast_manager_worksheets created_by char 36  √  null
forecast_manager_worksheets currency_id char 36  √  -99
forecast_manager_worksheets date_entered datetime 19  √  null
forecast_manager_worksheets date_modified datetime 19  √  null
forecast_manager_worksheets deleted bit 1  √  0
forecast_manager_worksheets description text 65535  √  null
forecast_manager_worksheets draft bit 1  √  0
forecast_manager_worksheets id char 36
forecast_manager_worksheets likely_case decimal 26,6  √  null
forecast_manager_worksheets likely_case_adjusted decimal 26,6  √  null
forecast_manager_worksheets manager_saved bit 1  √  0
forecast_manager_worksheets modified_user_id char 36  √  null
forecast_manager_worksheets name varchar 255  √  null
forecast_manager_worksheets opp_count int 5  √  null
forecast_manager_worksheets pipeline_amount decimal 26,6  √  0.000000
forecast_manager_worksheets pipeline_opp_count int 5  √  0
forecast_manager_worksheets quota decimal 26,6  √  null
forecast_manager_worksheets team_id char 36  √  null
forecast_manager_worksheets team_set_id char 36  √  null
forecast_manager_worksheets timeperiod_id char 36  √  null
forecast_manager_worksheets user_id char 36  √  null
forecast_manager_worksheets worst_case decimal 26,6  √  null
forecast_manager_worksheets worst_case_adjusted decimal 26,6  √  null
forecast_manager_worksheets_audit after_value_string varchar 255  √  null
forecast_manager_worksheets_audit after_value_text text 65535  √  null
forecast_manager_worksheets_audit before_value_string varchar 255  √  null
forecast_manager_worksheets_audit before_value_text text 65535  √  null
forecast_manager_worksheets_audit created_by char 36  √  null
forecast_manager_worksheets_audit data_type varchar 100  √  null
forecast_manager_worksheets_audit date_created datetime 19  √  null
forecast_manager_worksheets_audit date_updated datetime 19  √  null
forecast_manager_worksheets_audit event_id char 36
forecast_manager_worksheets_audit field_name varchar 100  √  null
forecast_manager_worksheets_audit id char 36
forecast_manager_worksheets_audit parent_id char 36
forecast_tree hierarchy_type varchar 25  √  null
forecast_tree id char 36
forecast_tree name varchar 50  √  null
forecast_tree parent_id char 36  √  null
forecast_tree user_id char 36  √  null
forecast_worksheets account_id char 36  √  null
forecast_worksheets account_name varchar 255  √  null
forecast_worksheets acl_team_set_id char 36  √  null
forecast_worksheets assigned_user_id char 36  √  null
forecast_worksheets base_rate decimal 26,6  √  null
forecast_worksheets best_case decimal 26,6  √  null
forecast_worksheets campaign_id char 36  √  null
forecast_worksheets campaign_name varchar 255  √  null
forecast_worksheets category_id char 36  √  null
forecast_worksheets category_name varchar 255  √  null
forecast_worksheets commit_stage varchar 50  √  null
forecast_worksheets cost_price decimal 26,6  √  null
forecast_worksheets created_by char 36  √  null
forecast_worksheets currency_id char 36  √  -99
forecast_worksheets date_closed date 10  √  null
forecast_worksheets date_closed_timestamp bigint unsigned 20  √  null
forecast_worksheets date_entered datetime 19  √  null
forecast_worksheets date_modified datetime 19  √  null
forecast_worksheets deleted bit 1  √  0
forecast_worksheets description text 65535  √  null
forecast_worksheets discount_amount decimal 26,6  √  null
forecast_worksheets discount_price decimal 26,6  √  null
forecast_worksheets draft int 11  √  0
forecast_worksheets id char 36
forecast_worksheets lead_source varchar 50  √  null
forecast_worksheets likely_case decimal 26,6  √  null
forecast_worksheets list_price decimal 26,6  √  null
forecast_worksheets modified_user_id char 36  √  null
forecast_worksheets name varchar 255  √  null
forecast_worksheets next_step varchar 100  √  null
forecast_worksheets opportunity_id char 36  √  null
forecast_worksheets opportunity_name varchar 255  √  null
forecast_worksheets parent_id char 36  √  null
forecast_worksheets parent_type varchar 255  √  null
forecast_worksheets probability double 22  √  null
forecast_worksheets product_template_id char 36  √  null
forecast_worksheets product_template_name varchar 255  √  null
forecast_worksheets product_type varchar 255  √  null
forecast_worksheets quantity int 5  √  1
forecast_worksheets sales_stage varchar 255  √  null
forecast_worksheets sales_status varchar 255  √  null
forecast_worksheets team_id char 36  √  null
forecast_worksheets team_set_id char 36  √  null
forecast_worksheets total_amount decimal 26,6  √  null
forecast_worksheets worst_case decimal 26,6  √  null
forecasts base_rate decimal 26,6  √  null
forecasts best_case decimal 26,6  √  null
forecasts closed_amount decimal 26,6  √  0.000000
forecasts currency_id char 36  √  -99
forecasts date_entered datetime 19  √  null
forecasts date_modified datetime 19  √  null
forecasts deleted bit 1  √  0
forecasts forecast_type varchar 100  √  null
forecasts id char 36
forecasts likely_case decimal 26,6  √  null
forecasts opp_count int 5  √  null
forecasts opp_weigh_value int 11  √  null
forecasts pipeline_amount decimal 26,6  √  0.000000
forecasts pipeline_opp_count int 5  √  0
forecasts timeperiod_id char 36  √  null
forecasts user_id char 36  √  null
forecasts worst_case decimal 26,6  √  null
fts_queue bean_id char 36  √  null
fts_queue bean_module varchar 100  √  null
fts_queue date_created datetime 19  √  null
fts_queue date_modified datetime 19  √  null
fts_queue id char 36
fts_queue processed bit 1  √  0
holidays created_by char 36  √  null
holidays date_entered datetime 19  √  null
holidays date_modified datetime 19  √  null
holidays deleted bit 1  √  0
holidays description text 65535  √  null
holidays holiday_date date 10  √  null
holidays id char 36
holidays modified_user_id char 36  √  null
holidays name varchar 255  √  null
holidays person_id char 36  √  null
holidays person_type varchar 255  √  null
holidays related_module varchar 255  √  null
holidays related_module_id char 36  √  null
holidays resource_name varchar 255  √  null
import_maps assigned_user_id char 36  √  null
import_maps content text 65535  √  null
import_maps date_entered datetime 19  √  null
import_maps date_modified datetime 19  √  null
import_maps default_values text 65535  √  null
import_maps deleted bit 1  √  0
import_maps delimiter varchar 1  √  ,
import_maps enclosure varchar 1  √ 
import_maps has_header bit 1  √  1
import_maps id char 36
import_maps is_published varchar 3  √  no
import_maps module varchar 36  √  null
import_maps name varchar 254  √  null
import_maps source varchar 36  √  null
inbound_email acl_team_set_id char 36  √  null
inbound_email created_by char 36  √  null
inbound_email date_entered datetime 19  √  null
inbound_email date_modified datetime 19  √  null
inbound_email delete_seen bit 1  √  0
inbound_email deleted bit 1  √  0
inbound_email email_password varchar 100  √  null
inbound_email email_user varchar 100  √  null
inbound_email group_id char 36  √  null
inbound_email groupfolder_id char 36  √  null
inbound_email id varchar 255
inbound_email is_personal bit 1  √  0
inbound_email mailbox text 65535  √  null
inbound_email mailbox_type varchar 10  √  null
inbound_email modified_user_id char 36  √  null
inbound_email name varchar 255  √  null
inbound_email port int 5  √  null
inbound_email server_url varchar 100  √  null
inbound_email service varchar 50  √  null
inbound_email status varchar 100  √  Active
inbound_email stored_options text 65535  √  null
inbound_email team_id char 36  √  null
inbound_email team_set_id char 36  √  null
inbound_email template_id char 36  √  null
inbound_email_autoreply autoreplied_to varchar 100  √  null
inbound_email_autoreply date_entered datetime 19  √  null
inbound_email_autoreply date_modified datetime 19  √  null
inbound_email_autoreply deleted bit 1  √  0
inbound_email_autoreply id char 36
inbound_email_autoreply ie_id char 36
inbound_email_cache_ts id varchar 255
inbound_email_cache_ts ie_timestamp int unsigned 10  √  null
job_queue assigned_user_id char 36  √  null
job_queue client varchar 255  √  null
job_queue data longtext 2147483647  √  null
job_queue date_entered datetime 19  √  null
job_queue date_modified datetime 19  √  null
job_queue deleted bit 1  √  0
job_queue execute_time datetime 19  √  null
job_queue failure_count tinyint 4  √  null
job_queue fallible bit 1  √  0
job_queue id char 36
job_queue interface bit 1  √  0
job_queue job_delay int 11  √  null
job_queue job_group varchar 255  √  null
job_queue message text 65535  √  null
job_queue module varchar 255  √  null
job_queue name varchar 255  √  null
job_queue percent_complete int 11  √  null
job_queue requeue bit 1  √  0
job_queue rerun bit 1  √  0
job_queue resolution varchar 20  √  null
job_queue retry_count tinyint 4  √  null
job_queue scheduler_id char 36  √  null
job_queue status varchar 20  √  null
job_queue target varchar 255  √  null
kbarticles acl_team_set_id char 36  √  null
kbarticles assigned_user_id char 36  √  null
kbarticles created_by char 36  √  null
kbarticles date_entered datetime 19  √  null
kbarticles date_modified datetime 19  √  null
kbarticles deleted bit 1  √  0
kbarticles description text 65535  √  null
kbarticles id char 36
kbarticles kbdocument_id char 36  √  null
kbarticles modified_user_id char 36  √  null
kbarticles name varchar 255  √  null
kbarticles team_id char 36  √  null
kbarticles team_set_id char 36  √  null
kbcontent_templates acl_team_set_id char 36  √  null
kbcontent_templates body longtext 2147483647  √  null
kbcontent_templates created_by char 36  √  null
kbcontent_templates date_entered datetime 19  √  null
kbcontent_templates date_modified datetime 19  √  null
kbcontent_templates deleted bit 1  √  0
kbcontent_templates description text 65535  √  null
kbcontent_templates id char 36
kbcontent_templates modified_user_id char 36  √  null
kbcontent_templates name varchar 255  √  null
kbcontent_templates team_id char 36  √  null
kbcontent_templates team_set_id char 36  √  null
kbcontent_templates_audit after_value_string varchar 255  √  null
kbcontent_templates_audit after_value_text text 65535  √  null
kbcontent_templates_audit before_value_string varchar 255  √  null
kbcontent_templates_audit before_value_text text 65535  √  null
kbcontent_templates_audit created_by char 36  √  null
kbcontent_templates_audit data_type varchar 100  √  null
kbcontent_templates_audit date_created datetime 19  √  null
kbcontent_templates_audit date_updated datetime 19  √  null
kbcontent_templates_audit event_id char 36
kbcontent_templates_audit field_name varchar 100  √  null
kbcontent_templates_audit id char 36
kbcontent_templates_audit parent_id char 36
kbcontents acl_team_set_id char 36  √  null
kbcontents active_date date 10  √  null
kbcontents active_rev tinyint 4  √  0
kbcontents approved bit 1  √  0
kbcontents assigned_user_id char 36  √  null
kbcontents category_id char 36  √  null
kbcontents created_by char 36  √  null
kbcontents date_entered datetime 19  √  null
kbcontents date_modified datetime 19  √  null
kbcontents deleted bit 1  √  0
kbcontents description text 65535  √  null
kbcontents exp_date date 10  √  null
kbcontents id char 36
kbcontents is_external tinyint 4  √  0
kbcontents kbarticle_id char 36  √  null
kbcontents kbdocument_body longtext 2147483647  √  null
kbcontents kbdocument_id char 36  √  null
kbcontents kbsapprover_id char 36  √  null
kbcontents kbscase_id char 36  √  null
kbcontents language varchar 2  √  null
kbcontents modified_user_id char 36  √  null
kbcontents name varchar 255  √  null
kbcontents notuseful int 11  √  0
kbcontents revision int 11  √  0
kbcontents status varchar 100  √  draft
kbcontents team_id char 36  √  null
kbcontents team_set_id char 36  √  null
kbcontents useful int 11  √  0
kbcontents viewcount int 11  √  0
kbcontents_audit after_value_string varchar 255  √  null
kbcontents_audit after_value_text text 65535  √  null
kbcontents_audit before_value_string varchar 255  √  null
kbcontents_audit before_value_text text 65535  √  null
kbcontents_audit created_by char 36  √  null
kbcontents_audit data_type varchar 100  √  null
kbcontents_audit date_created datetime 19  √  null
kbcontents_audit date_updated datetime 19  √  null
kbcontents_audit event_id char 36
kbcontents_audit field_name varchar 100  √  null
kbcontents_audit id char 36
kbcontents_audit parent_id char 36
kbdocuments acl_team_set_id char 36  √  null
kbdocuments assigned_user_id char 36  √  null
kbdocuments created_by char 36  √  null
kbdocuments date_entered datetime 19  √  null
kbdocuments date_modified datetime 19  √  null
kbdocuments deleted bit 1  √  0
kbdocuments description text 65535  √  null
kbdocuments id char 36
kbdocuments modified_user_id char 36  √  null
kbdocuments name varchar 255  √  null
kbdocuments team_id char 36  √  null
kbdocuments team_set_id char 36  √  null
kbusefulness contact_id char 36  √  null
kbusefulness date_modified datetime 19  √  null
kbusefulness deleted bit 1  √  0
kbusefulness id char 36
kbusefulness kbarticle_id char 36
kbusefulness ssid char 36  √  null
kbusefulness user_id char 36
kbusefulness vote smallint 6  √  null
kbusefulness zeroflag tinyint 4  √  null
leads account_description text 65535  √  null
leads account_id char 36  √  null
leads account_name varchar 255  √  null
leads acl_team_set_id char 36  √  null
leads alt_address_city varchar 100  √  null
leads alt_address_country varchar 255  √  null
leads alt_address_postalcode varchar 20  √  null
leads alt_address_state varchar 100  √  null
leads alt_address_street varchar 150  √  null
leads assigned_user_id char 36  √  null
leads assistant varchar 75  √  null
leads assistant_phone varchar 100  √  null
leads birthdate date 10  √  null
leads business_center_id char 36  √  null
leads campaign_id char 36  √  null
leads contact_id char 36  √  null
leads converted bit 1  √  0
leads created_by char 36  √  null
leads date_entered datetime 19  √  null
leads date_modified datetime 19  √  null
leads deleted bit 1  √  0
leads department varchar 100  √  null
leads description text 65535  √  null
leads dnb_principal_id varchar 30  √  null
leads do_not_call bit 1  √  0
leads dp_business_purpose text 65535  √  null
leads dp_consent_last_updated date 10  √  null
leads facebook varchar 100  √  null
leads first_name varchar 100  √  null
leads googleplus varchar 100  √  null
leads id char 36
leads last_name varchar 100  √  null
leads lead_source varchar 100  √  null
leads lead_source_description text 65535  √  null
leads mkto_id int 11  √  null
leads mkto_lead_score int 11  √  null
leads mkto_sync bit 1  √  0
leads modified_user_id char 36  √  null
leads opportunity_amount varchar 50  √  null
leads opportunity_id char 36  √  null
leads opportunity_name varchar 255  √  null
leads phone_fax varchar 100  √  null
leads phone_home varchar 100  √  null
leads phone_mobile varchar 100  √  null
leads phone_other varchar 100  √  null
leads phone_work varchar 100  √  null
leads picture varchar 255  √  null
leads portal_app varchar 255  √  null
leads portal_name varchar 255  √  null
leads preferred_language varchar 255  √  null
leads primary_address_city varchar 100  √  null
leads primary_address_country varchar 255  √  null
leads primary_address_postalcode varchar 20  √  null
leads primary_address_state varchar 100  √  null
leads primary_address_street varchar 150  √  null
leads refered_by varchar 100  √  null
leads reports_to_id char 36  √  null
leads salutation varchar 255  √  null
leads status varchar 100  √  New
leads status_description text 65535  √  null
leads team_id char 36  √  null
leads team_set_id char 36  √  null
leads title varchar 100  √  null
leads twitter varchar 100  √  null
leads website varchar 255  √  null
leads_audit after_value_string varchar 255  √  null
leads_audit after_value_text text 65535  √  null
leads_audit before_value_string varchar 255  √  null
leads_audit before_value_text text 65535  √  null
leads_audit created_by char 36  √  null
leads_audit data_type varchar 100  √  null
leads_audit date_created datetime 19  √  null
leads_audit date_updated datetime 19  √  null
leads_audit event_id char 36
leads_audit field_name varchar 100  √  null
leads_audit id char 36
leads_audit parent_id char 36
leads_dataprivacy dataprivacy_id char 36  √  null
leads_dataprivacy date_modified datetime 19  √  null
leads_dataprivacy deleted bit 1  √  0
leads_dataprivacy id char 36
leads_dataprivacy lead_id char 36  √  null
linked_documents date_modified datetime 19  √  null
linked_documents deleted bit 1  √  0
linked_documents document_id char 36  √  null
linked_documents document_revision_id char 36  √  null
linked_documents id char 36
linked_documents parent_id char 36  √  null
linked_documents parent_type varchar 25  √  null
locked_field_bean_rel bean_id char 36
locked_field_bean_rel bean_module varchar 100  √  null
locked_field_bean_rel date_modified datetime 19  √  null
locked_field_bean_rel deleted bit 1  √  0
locked_field_bean_rel id char 36
locked_field_bean_rel pd_id char 36
manufacturers created_by char 36  √  null
manufacturers date_entered datetime 19  √  null
manufacturers date_modified datetime 19  √  null
manufacturers deleted bit 1  √  0
manufacturers description text 65535  √  null
manufacturers id char 36
manufacturers list_order int 4  √  null
manufacturers modified_user_id char 36  √  null
manufacturers name varchar 255  √  null
manufacturers status varchar 100  √  null
meetings acl_team_set_id char 36  √  null
meetings assigned_user_id char 36  √  null
meetings created_by char 36  √  null
meetings creator varchar 50  √  null
meetings date_end datetime 19  √  null
meetings date_entered datetime 19  √  null
meetings date_modified datetime 19  √  null
meetings date_start datetime 19  √  null
meetings deleted bit 1  √  0
meetings description text 65535  √  null
meetings displayed_url varchar 400  √  null
meetings duration_hours int 11  √  0
meetings duration_minutes int 2  √  0
meetings email_reminder_sent bit 1  √  0
meetings email_reminder_time int 11  √  -1
meetings external_id varchar 50  √  null
meetings host_url varchar 600  √  null
meetings id char 36
meetings join_url varchar 600  √  null
meetings location varchar 50  √  null
meetings modified_user_id char 36  √  null
meetings name varchar 50  √  null
meetings outlook_id varchar 255  √  null
meetings parent_id char 36  √  null
meetings parent_type varchar 100  √  null
meetings password varchar 50  √  null
meetings recurrence_id datetime 19  √  null
meetings recurring_source varchar 36  √  null
meetings reminder_time int 11  √  -1
meetings repeat_count int 7  √  null
meetings repeat_days varchar 128  √  null
meetings repeat_dow varchar 7  √  null
meetings repeat_interval int 3  √  1
meetings repeat_ordinal varchar 36  √  null
meetings repeat_parent_id char 36  √  null
meetings repeat_selector varchar 36  √  null
meetings repeat_type varchar 36  √  null
meetings repeat_unit varchar 36  √  null
meetings repeat_until date 10  √  null
meetings sequence int 11  √  0
meetings status varchar 100  √  Planned
meetings team_id char 36  √  null
meetings team_set_id char 36  √  null
meetings type varchar 255  √  Sugar
meetings_contacts accept_status varchar 25  √  none
meetings_contacts contact_id char 36  √  null
meetings_contacts date_modified datetime 19  √  null
meetings_contacts deleted bit 1  √  0
meetings_contacts id char 36
meetings_contacts meeting_id char 36  √  null
meetings_contacts required varchar 1  √  1
meetings_leads accept_status varchar 25  √  none
meetings_leads date_modified datetime 19  √  null
meetings_leads deleted bit 1  √  0
meetings_leads id char 36
meetings_leads lead_id char 36  √  null
meetings_leads meeting_id char 36  √  null
meetings_leads required varchar 1  √  1
meetings_users accept_status varchar 25  √  none
meetings_users date_modified datetime 19  √  null
meetings_users deleted bit 1  √  0
meetings_users id char 36
meetings_users meeting_id char 36  √  null
meetings_users required varchar 1  √  1
meetings_users user_id char 36  √  null
metadata_cache data longblob 2147483647  √  null
metadata_cache date_modified datetime 19  √  null
metadata_cache deleted bit 1  √  0
metadata_cache id char 36
metadata_cache type varchar 255  √  null
notes acl_team_set_id char 36  √  null
notes assigned_user_id char 36  √  null
notes contact_id char 36  √  null
notes created_by char 36  √  null
notes date_entered datetime 19  √  null
notes date_modified datetime 19  √  null
notes deleted bit 1  √  0
notes description text 65535  √  null
notes email_id char 36  √  null
notes email_type varchar 255  √  null
notes embed_flag bit 1  √  0
notes entry_source varchar 255  √  internal
notes file_ext varchar 100  √  null
notes file_mime_type varchar 100  √  null
notes file_size int 11  √  0
notes file_source varchar 32  √  null
notes filename varchar 255  √  null
notes id char 36
notes modified_user_id char 36  √  null
notes name varchar 255  √  null
notes parent_id char 36  √  null
notes parent_type varchar 255  √  null
notes portal_flag bit 1  √  1
notes team_id char 36  √  null
notes team_set_id char 36  √  null
notes upload_id char 36  √  null
notifications assigned_user_id char 36  √  null
notifications created_by char 36  √  null
notifications date_entered datetime 19  √  null
notifications date_modified datetime 19  √  null
notifications deleted bit 1  √  0
notifications description text 65535  √  null
notifications id char 36
notifications is_read bit 1  √  0
notifications modified_user_id char 36  √  null
notifications name varchar 255  √  null
notifications parent_id char 36  √  null
notifications parent_type varchar 100  √  null
notifications severity varchar 15  √  null
oauth_consumer assigned_user_id char 36  √  null
oauth_consumer c_key varchar 255  √  null
oauth_consumer c_secret varchar 255  √  null
oauth_consumer client_type varchar 50  √  user
oauth_consumer created_by char 36  √  null
oauth_consumer date_entered datetime 19  √  null
oauth_consumer date_modified datetime 19  √  null
oauth_consumer deleted bit 1  √  0
oauth_consumer description text 65535  √  null
oauth_consumer id char 36
oauth_consumer modified_user_id char 36  √  null
oauth_consumer name varchar 255  √  null
oauth_consumer oauth_type varchar 50  √  oauth1
oauth_nonce conskey varchar 32
oauth_nonce nonce varchar 32
oauth_nonce nonce_ts bigint 20  √  null
oauth_tokens assigned_user_id char 36  √  null
oauth_tokens callback_url varchar 255  √  null
oauth_tokens consumer char 36
oauth_tokens contact_id char 36  √  null
oauth_tokens deleted bit 1 0
oauth_tokens download_token varchar 36  √  null
oauth_tokens expire_ts bigint 20  √  -1
oauth_tokens id char 36
oauth_tokens platform varchar 255  √  base
oauth_tokens secret varchar 32  √  null
oauth_tokens token_ts bigint 20  √  null
oauth_tokens tstate varchar 1  √  null
oauth_tokens verify varchar 32  √  null
opportunities acl_team_set_id char 36  √  null
opportunities amount decimal 26,6  √  null
opportunities amount_usdollar decimal 26,6  √  null
opportunities assigned_user_id char 36  √  null
opportunities base_rate decimal 26,6  √  null
opportunities best_case decimal 26,6  √  null
opportunities campaign_id char 36  √  null
opportunities closed_revenue_line_items int 11  √  null
opportunities commit_stage varchar 50  √  null
opportunities created_by char 36  √  null
opportunities currency_id char 36  √  -99
opportunities date_closed date 10  √  null
opportunities date_closed_timestamp bigint unsigned 20  √  null
opportunities date_entered datetime 19  √  null
opportunities date_modified datetime 19  √  null
opportunities deleted bit 1  √  0
opportunities description text 65535  √  null
opportunities id char 36
opportunities included_revenue_line_items int 11  √  null
opportunities lead_source varchar 50  √  null
opportunities mkto_id int 11  √  null
opportunities mkto_sync bit 1  √  0
opportunities modified_user_id char 36  √  null
opportunities name varchar 50  √  null
opportunities next_step varchar 100  √  null
opportunities opportunity_type varchar 255  √  null
opportunities probability double 22  √  null
opportunities renewal bit 1  √  0
opportunities renewal_parent_id char 36  √  null
opportunities sales_stage varchar 255  √  Prospecting
opportunities sales_status varchar 255  √  New
opportunities team_id char 36  √  null
opportunities team_set_id char 36  √  null
opportunities total_revenue_line_items int 11  √  null
opportunities worst_case decimal 26,6  √  null
opportunities_audit after_value_string varchar 255  √  null
opportunities_audit after_value_text text 65535  √  null
opportunities_audit before_value_string varchar 255  √  null
opportunities_audit before_value_text text 65535  √  null
opportunities_audit created_by char 36  √  null
opportunities_audit data_type varchar 100  √  null
opportunities_audit date_created datetime 19  √  null
opportunities_audit date_updated datetime 19  √  null
opportunities_audit event_id char 36
opportunities_audit field_name varchar 100  √  null
opportunities_audit id char 36
opportunities_audit parent_id char 36
opportunities_contacts contact_id char 36  √  null
opportunities_contacts contact_role varchar 50  √  null
opportunities_contacts date_modified datetime 19  √  null
opportunities_contacts deleted bit 1  √  0
opportunities_contacts id char 36
opportunities_contacts opportunity_id char 36  √  null
outbound_email acl_team_set_id char 36  √  null
outbound_email deleted bit 1  √  0
outbound_email email_address_id char 36  √  null
outbound_email id char 36
outbound_email mail_sendtype varchar 8  √  SMTP
outbound_email mail_smtpauth_req bit 1  √  0
outbound_email mail_smtppass varchar 100  √  null
outbound_email mail_smtpport int 5  √  465
outbound_email mail_smtpserver varchar 100  √  null
outbound_email mail_smtpssl int 1  √  1
outbound_email mail_smtptype varchar 20  √  other
outbound_email mail_smtpuser varchar 100  √  null
outbound_email name varchar 255  √  null
outbound_email reply_to_email_address_id char 36  √  null
outbound_email reply_to_name varchar 255  √  null
outbound_email team_id char 36  √  null
outbound_email team_set_id char 36  √  null
outbound_email type varchar 15  √  user
outbound_email user_id char 36
pdfmanager acl_team_set_id char 36  √  null
pdfmanager assigned_user_id char 36  √  null
pdfmanager author varchar 255  √  SugarCRM
pdfmanager base_module varchar 100  √ 
pdfmanager body_html text 65535  √  null
pdfmanager created_by char 36  √  null
pdfmanager date_entered datetime 19  √  null
pdfmanager date_modified datetime 19  √  null
pdfmanager deleted bit 1  √  0
pdfmanager description text 65535  √  null
pdfmanager field varchar 100  √  0
pdfmanager footer_text varchar 255  √  null
pdfmanager header_logo varchar 255  √  null
pdfmanager header_text varchar 255  √  null
pdfmanager header_title varchar 255  √  null
pdfmanager id char 36
pdfmanager keywords varchar 255  √  null
pdfmanager modified_user_id char 36  √  null
pdfmanager name varchar 255  √  null
pdfmanager published varchar 100  √  yes
pdfmanager subject varchar 255  √  null
pdfmanager team_id char 36  √  null
pdfmanager team_set_id char 36  √  null
pdfmanager template_name varchar 255  √  null
pdfmanager title varchar 255  √  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_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_definition act_last_user_assigned varchar 40  √ 
pmse_bpm_activity_definition act_params text 65535  √  null
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_bpm_activity_definition act_related_modules text 65535  √  null
pmse_bpm_activity_definition act_required_fields text 65535  √  null
pmse_bpm_activity_definition act_response_buttons varchar 40  √ 
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_type varchar 32  √  TASK
pmse_bpm_activity_definition act_update_record_owner int 4  √  0
pmse_bpm_activity_definition act_value_based_assignment varchar 255  √ 
pmse_bpm_activity_definition assigned_user_id char 36  √  null
pmse_bpm_activity_definition created_by char 36  √  null
pmse_bpm_activity_definition date_entered datetime 19  √  null
pmse_bpm_activity_definition date_modified datetime 19  √  null
pmse_bpm_activity_definition deleted bit 1  √  0
pmse_bpm_activity_definition description text 65535  √  null
pmse_bpm_activity_definition execution_mode varchar 10  √  DEFAULT
pmse_bpm_activity_definition id char 36
pmse_bpm_activity_definition modified_user_id char 36  √  null
pmse_bpm_activity_definition name varchar 255  √  null
pmse_bpm_activity_definition pro_id varchar 36  √ 
pmse_bpm_activity_step act_criteria text 65535  √  null
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_bpm_activity_step assigned_user_id char 36  √  null
pmse_bpm_activity_step created_by char 36  √  null
pmse_bpm_activity_step date_entered datetime 19  √  null
pmse_bpm_activity_step date_modified datetime 19  √  null
pmse_bpm_activity_step deleted bit 1  √  0
pmse_bpm_activity_step description text 65535  √  null
pmse_bpm_activity_step id char 36
pmse_bpm_activity_step modified_user_id char 36  √  null
pmse_bpm_activity_step name varchar 255  √  null
pmse_bpm_activity_step pro_id varchar 36  √ 
pmse_bpm_activity_user act_group_id varchar 40  √ 
pmse_bpm_activity_user act_user_id varchar 40  √ 
pmse_bpm_activity_user act_user_type varchar 32  √ 
pmse_bpm_activity_user assigned_user_id char 36  √  null
pmse_bpm_activity_user created_by char 36  √  null
pmse_bpm_activity_user date_entered datetime 19  √  null
pmse_bpm_activity_user date_modified datetime 19  √  null
pmse_bpm_activity_user deleted bit 1  √  0
pmse_bpm_activity_user description text 65535  √  null
pmse_bpm_activity_user id char 36
pmse_bpm_activity_user modified_user_id char 36  √  null
pmse_bpm_activity_user name varchar 255  √  null
pmse_bpm_activity_user pro_id varchar 36  √ 
pmse_bpm_config assigned_user_id char 36  √  null
pmse_bpm_config cfg_status varchar 20  √  ACTIVE
pmse_bpm_config cfg_value text 65535  √  null
pmse_bpm_config created_by char 36  √  null
pmse_bpm_config date_entered datetime 19  √  null
pmse_bpm_config date_modified datetime 19  √  null
pmse_bpm_config deleted bit 1  √  0
pmse_bpm_config description text 65535  √  null
pmse_bpm_config id char 36
pmse_bpm_config modified_user_id char 36  √  null
pmse_bpm_config name varchar 255  √  null
pmse_bpm_dynamic_forms assigned_user_id char 36  √  null
pmse_bpm_dynamic_forms created_by char 36  √  null
pmse_bpm_dynamic_forms date_entered datetime 19  √  null
pmse_bpm_dynamic_forms date_modified datetime 19  √  null
pmse_bpm_dynamic_forms deleted bit 1  √  0
pmse_bpm_dynamic_forms description 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
pmse_bpm_dynamic_forms id char 36
pmse_bpm_dynamic_forms modified_user_id char 36  √  null
pmse_bpm_dynamic_forms name varchar 255  √  null
pmse_bpm_dynamic_forms prj_id varchar 36  √ 
pmse_bpm_dynamic_forms pro_id varchar 36  √ 
pmse_bpm_event_definition assigned_user_id char 36  √  null
pmse_bpm_event_definition created_by char 36  √  null
pmse_bpm_event_definition date_entered datetime 19  √  null
pmse_bpm_event_definition date_modified datetime 19  √  null
pmse_bpm_event_definition deleted bit 1  √  0
pmse_bpm_event_definition description text 65535  √  null
pmse_bpm_event_definition evn_criteria text 65535  √  null
pmse_bpm_event_definition evn_module varchar 128  √  Leads
pmse_bpm_event_definition evn_params text 65535  √  null
pmse_bpm_event_definition evn_script text 65535  √  null
pmse_bpm_event_definition evn_status varchar 32  √  ACTIVE
pmse_bpm_event_definition evn_type varchar 30  √  START
pmse_bpm_event_definition execution_mode varchar 10  √  DEFAULT
pmse_bpm_event_definition id char 36
pmse_bpm_event_definition modified_user_id char 36  √  null
pmse_bpm_event_definition name varchar 255  √  null
pmse_bpm_event_definition prj_id varchar 36  √ 
pmse_bpm_event_definition pro_id varchar 36  √ 
pmse_bpm_flow assigned_user_id char 36  √  null
pmse_bpm_flow bpmn_id varchar 36  √ 
pmse_bpm_flow bpmn_type varchar 32  √ 
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_bpm_flow cas_assignment_method varchar 32  √ 
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_bpm_flow cas_finished int 4  √  0
pmse_bpm_flow cas_flow_status varchar 32  √  OPEN
pmse_bpm_flow cas_id int 4  √  null
pmse_bpm_flow cas_index int 4  √  null
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_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_flow cas_user_id varchar 40  √ 
pmse_bpm_flow created_by char 36  √  null
pmse_bpm_flow date_entered datetime 19  √  null
pmse_bpm_flow date_modified datetime 19  √  null
pmse_bpm_flow deleted bit 1  √  0
pmse_bpm_flow description text 65535  √  null
pmse_bpm_flow id char 36
pmse_bpm_flow modified_user_id char 36  √  null
pmse_bpm_flow name varchar 255  √  null
pmse_bpm_flow pro_id varchar 36  √ 
pmse_bpm_form_action act_id varchar 36  √ 
pmse_bpm_form_action assigned_user_id char 36  √  null
pmse_bpm_form_action cas_id int 4  √  null
pmse_bpm_form_action created_by char 36  √  null
pmse_bpm_form_action date_entered datetime 19  √  null
pmse_bpm_form_action date_modified datetime 19  √  null
pmse_bpm_form_action deleted bit 1  √  0
pmse_bpm_form_action description text 65535  √  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  √ 
pmse_bpm_form_action id char 36
pmse_bpm_form_action modified_user_id char 36  √  null
pmse_bpm_form_action name varchar 255  √  null
pmse_bpm_form_action pro_id varchar 36  √ 
pmse_bpm_form_action user_id varchar 36  √ 
pmse_bpm_gateway_definition assigned_user_id char 36  √  null
pmse_bpm_gateway_definition created_by char 36  √  null
pmse_bpm_gateway_definition date_entered datetime 19  √  null
pmse_bpm_gateway_definition date_modified datetime 19  √  null
pmse_bpm_gateway_definition deleted bit 1  √  0
pmse_bpm_gateway_definition description text 65535  √  null
pmse_bpm_gateway_definition execution_mode varchar 10  √  DEFAULT
pmse_bpm_gateway_definition id char 36
pmse_bpm_gateway_definition modified_user_id char 36  √  null
pmse_bpm_gateway_definition name varchar 255  √  null
pmse_bpm_gateway_definition prj_id varchar 36  √ 
pmse_bpm_gateway_definition pro_id varchar 36  √ 
pmse_bpm_group assigned_user_id char 36  √  null
pmse_bpm_group created_by char 36  √  null
pmse_bpm_group date_entered datetime 19  √  null
pmse_bpm_group date_modified datetime 19  √  null
pmse_bpm_group deleted bit 1  √  0
pmse_bpm_group description text 65535  √  null
pmse_bpm_group grp_parent_group int 4  √  0
pmse_bpm_group grp_uid varchar 36  √ 
pmse_bpm_group id char 36
pmse_bpm_group modified_user_id char 36  √  null
pmse_bpm_group name varchar 255  √  null
pmse_bpm_group_user assigned_user_id char 36  √  null
pmse_bpm_group_user created_by char 36  √  null
pmse_bpm_group_user date_entered datetime 19  √  null
pmse_bpm_group_user date_modified datetime 19  √  null
pmse_bpm_group_user deleted bit 1  √  0
pmse_bpm_group_user description text 65535  √  null
pmse_bpm_group_user id char 36
pmse_bpm_group_user modified_user_id char 36  √  null
pmse_bpm_group_user name varchar 255  √  null
pmse_bpm_group_user user_id varchar 36  √ 
pmse_bpm_notes assigned_user_id char 36  √  null
pmse_bpm_notes cas_id varchar 36  √ 
pmse_bpm_notes cas_index int 4  √  null
pmse_bpm_notes created_by char 36  √  null
pmse_bpm_notes date_entered datetime 19  √  null
pmse_bpm_notes date_modified datetime 19  √  null
pmse_bpm_notes deleted bit 1  √  0
pmse_bpm_notes description text 65535  √  null
pmse_bpm_notes id char 36
pmse_bpm_notes modified_user_id char 36  √  null
pmse_bpm_notes name varchar 255  √  null
pmse_bpm_notes not_availability varchar 32  √ 
pmse_bpm_notes not_content text 65535  √  null
pmse_bpm_notes not_date datetime 19  √  null
pmse_bpm_notes not_recipients text 65535  √  null
pmse_bpm_notes not_status varchar 10  √  ACTIVE
pmse_bpm_notes not_type varchar 32  √  GENERAL
pmse_bpm_notes not_user_id varchar 40  √ 
pmse_bpm_notes not_user_recipient_id varchar 40  √ 
pmse_bpm_process_definition assigned_user_id char 36  √  null
pmse_bpm_process_definition created_by char 36  √  null
pmse_bpm_process_definition date_entered datetime 19  √  null
pmse_bpm_process_definition date_modified datetime 19  √  null
pmse_bpm_process_definition deleted bit 1  √  0
pmse_bpm_process_definition description text 65535  √  null
pmse_bpm_process_definition execution_mode varchar 10  √  SYNC
pmse_bpm_process_definition id char 36
pmse_bpm_process_definition modified_user_id char 36  √  null
pmse_bpm_process_definition name varchar 255  √  null
pmse_bpm_process_definition prj_id varchar 36  √ 
pmse_bpm_process_definition pro_locked_variables text 65535  √  null
pmse_bpm_process_definition pro_module varchar 255  √ 
pmse_bpm_process_definition pro_status varchar 255  √ 
pmse_bpm_process_definition pro_terminate_variables text 65535  √  null
pmse_bpm_related_dependency assigned_user_id char 36  √  null
pmse_bpm_related_dependency created_by char 36  √  null
pmse_bpm_related_dependency date_entered datetime 19  √  null
pmse_bpm_related_dependency date_modified datetime 19  √  null
pmse_bpm_related_dependency deleted bit 1  √  0
pmse_bpm_related_dependency description text 65535  √  null
pmse_bpm_related_dependency evn_activity_ref varchar 36  √ 
pmse_bpm_related_dependency evn_attached_to varchar 36  √ 
pmse_bpm_related_dependency evn_behavior varchar 36  √ 
pmse_bpm_related_dependency evn_cancel_activity varchar 36  √ 
pmse_bpm_related_dependency evn_condition varchar 36  √ 
pmse_bpm_related_dependency evn_criteria text 65535  √  null
pmse_bpm_related_dependency evn_error_code varchar 36  √ 
pmse_bpm_related_dependency evn_error_name varchar 36  √ 
pmse_bpm_related_dependency evn_escalation_code varchar 36  √ 
pmse_bpm_related_dependency evn_escalation_name varchar 36  √ 
pmse_bpm_related_dependency evn_id varchar 36  √ 
pmse_bpm_related_dependency evn_is_interrupting varchar 36  √ 
pmse_bpm_related_dependency evn_marker varchar 36  √ 
pmse_bpm_related_dependency evn_message varchar 36  √ 
pmse_bpm_related_dependency evn_module varchar 36  √ 
pmse_bpm_related_dependency evn_operation_implementation varchar 36  √ 
pmse_bpm_related_dependency evn_operation_name varchar 36  √ 
pmse_bpm_related_dependency evn_params text 65535  √  null
pmse_bpm_related_dependency evn_script text 65535  √  null
pmse_bpm_related_dependency evn_status varchar 36  √ 
pmse_bpm_related_dependency evn_time_cycle varchar 36  √ 
pmse_bpm_related_dependency evn_time_date varchar 36  √ 
pmse_bpm_related_dependency evn_time_duration varchar 36  √ 
pmse_bpm_related_dependency evn_type varchar 36  √ 
pmse_bpm_related_dependency evn_uid varchar 36  √ 
pmse_bpm_related_dependency evn_wait_for_completion varchar 36  √ 
pmse_bpm_related_dependency id char 36
pmse_bpm_related_dependency modified_user_id char 36  √  null
pmse_bpm_related_dependency name varchar 255  √  null
pmse_bpm_related_dependency prj_id varchar 36  √ 
pmse_bpm_related_dependency pro_id varchar 36  √ 
pmse_bpm_related_dependency pro_locked_variables text 65535  √  null
pmse_bpm_related_dependency pro_module varchar 36  √ 
pmse_bpm_related_dependency pro_status varchar 36  √ 
pmse_bpm_related_dependency pro_terminate_variables text 65535  √  null
pmse_bpm_related_dependency rel_element_id varchar 40  √ 
pmse_bpm_related_dependency rel_element_module varchar 32  √ 
pmse_bpm_related_dependency rel_element_relationship varchar 255  √ 
pmse_bpm_related_dependency rel_element_type varchar 32  √ 
pmse_bpm_related_dependency rel_process_module varchar 32  √ 
pmse_bpm_thread assigned_user_id char 36  √  null
pmse_bpm_thread cas_flow_index int 4  √  0
pmse_bpm_thread cas_id 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_bpm_thread created_by char 36  √  null
pmse_bpm_thread date_entered datetime 19  √  null
pmse_bpm_thread date_modified datetime 19  √  null
pmse_bpm_thread deleted bit 1  √  0
pmse_bpm_thread description text 65535  √  null
pmse_bpm_thread id char 36
pmse_bpm_thread modified_user_id char 36  √  null
pmse_bpm_thread name varchar 255  √  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_bpmn_activity act_default_flow int 4  √  null
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_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_bpmn_activity act_protocol varchar 255  √ 
pmse_bpmn_activity act_referer int 4  √  null
pmse_bpmn_activity act_script text 65535  √  null
pmse_bpmn_activity act_script_type varchar 255  √ 
pmse_bpmn_activity act_start_quantity int 4  √  1
pmse_bpmn_activity act_task_type varchar 20  √  EMPTY
pmse_bpmn_activity act_test_before int 4  √  0
pmse_bpmn_activity act_type varchar 30  √  TASK
pmse_bpmn_activity act_uid varchar 36  √ 
pmse_bpmn_activity assigned_user_id char 36  √  null
pmse_bpmn_activity created_by char 36  √  null
pmse_bpmn_activity date_entered datetime 19  √  null
pmse_bpmn_activity date_modified datetime 19  √  null
pmse_bpmn_activity deleted bit 1  √  0
pmse_bpmn_activity description text 65535  √  null
pmse_bpmn_activity id char 36
pmse_bpmn_activity modified_user_id char 36  √  null
pmse_bpmn_activity name varchar 255  √  null
pmse_bpmn_activity prj_id varchar 36  √ 
pmse_bpmn_activity pro_id varchar 36  √ 
pmse_bpmn_artifact art_category_ref varchar 32  √ 
pmse_bpmn_artifact art_type varchar 15  √ 
pmse_bpmn_artifact art_uid varchar 36  √ 
pmse_bpmn_artifact assigned_user_id char 36  √  null
pmse_bpmn_artifact created_by char 36  √  null
pmse_bpmn_artifact date_entered datetime 19  √  null
pmse_bpmn_artifact date_modified datetime 19  √  null
pmse_bpmn_artifact deleted bit 1  √  0
pmse_bpmn_artifact description text 65535  √  null
pmse_bpmn_artifact id char 36
pmse_bpmn_artifact modified_user_id char 36  √  null
pmse_bpmn_artifact name varchar 255  √  null
pmse_bpmn_artifact prj_id varchar 36  √ 
pmse_bpmn_artifact pro_id varchar 36  √ 
pmse_bpmn_bound assigned_user_id char 36  √  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_bpmn_bound created_by char 36  √  null
pmse_bpmn_bound date_entered datetime 19  √  null
pmse_bpmn_bound date_modified datetime 19  √  null
pmse_bpmn_bound deleted bit 1  √  0
pmse_bpmn_bound description text 65535  √  null
pmse_bpmn_bound dia_id varchar 36  √ 
pmse_bpmn_bound element_id varchar 36  √ 
pmse_bpmn_bound id char 36
pmse_bpmn_bound modified_user_id char 36  √  null
pmse_bpmn_bound name varchar 255  √  null
pmse_bpmn_bound prj_id varchar 36  √ 
pmse_bpmn_data assigned_user_id char 36  √  null
pmse_bpmn_data created_by char 36  √  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  √ 
pmse_bpmn_data date_entered datetime 19  √  null
pmse_bpmn_data date_modified datetime 19  √  null
pmse_bpmn_data deleted bit 1  √  0
pmse_bpmn_data description text 65535  √  null
pmse_bpmn_data id char 36
pmse_bpmn_data modified_user_id char 36  √  null
pmse_bpmn_data name varchar 255  √  null
pmse_bpmn_data prj_id varchar 36  √ 
pmse_bpmn_data pro_id varchar 36  √ 
pmse_bpmn_diagram assigned_user_id char 36  √  null
pmse_bpmn_diagram created_by char 36  √  null
pmse_bpmn_diagram date_entered datetime 19  √  null
pmse_bpmn_diagram date_modified datetime 19  √  null
pmse_bpmn_diagram deleted bit 1  √  0
pmse_bpmn_diagram description text 65535  √  null
pmse_bpmn_diagram dia_is_closable int 4  √  0
pmse_bpmn_diagram dia_uid varchar 36  √ 
pmse_bpmn_diagram id char 36
pmse_bpmn_diagram modified_user_id char 36  √  null
pmse_bpmn_diagram name varchar 255  √  null
pmse_bpmn_diagram prj_id varchar 36  √ 
pmse_bpmn_documentation assigned_user_id char 36  √  null
pmse_bpmn_documentation created_by char 36  √  null
pmse_bpmn_documentation date_entered datetime 19  √  null
pmse_bpmn_documentation date_modified datetime 19  √  null
pmse_bpmn_documentation deleted bit 1  √  0
pmse_bpmn_documentation description text 65535  √  null
pmse_bpmn_documentation doc_documentation text 65535  √  null
pmse_bpmn_documentation doc_element varchar 36  √ 
pmse_bpmn_documentation doc_element_type varchar 45  √ 
pmse_bpmn_documentation doc_uid varchar 36  √ 
pmse_bpmn_documentation id char 36
pmse_bpmn_documentation modified_user_id char 36  √  null
pmse_bpmn_documentation name varchar 255  √  null
pmse_bpmn_documentation prj_id varchar 36  √ 
pmse_bpmn_event assigned_user_id char 36  √  null
pmse_bpmn_event created_by char 36  √  null
pmse_bpmn_event date_entered datetime 19  √  null
pmse_bpmn_event date_modified datetime 19  √  null
pmse_bpmn_event deleted bit 1  √  0
pmse_bpmn_event description text 65535  √  null
pmse_bpmn_event evn_activity_ref int 4  √  null
pmse_bpmn_event evn_attached_to int 4  √  null
pmse_bpmn_event evn_behavior varchar 20  √  CATCH
pmse_bpmn_event evn_cancel_activity int 4  √  0
pmse_bpmn_event evn_condition varchar 255  √ 
pmse_bpmn_event evn_error_code varchar 255  √ 
pmse_bpmn_event evn_error_name varchar 255  √ 
pmse_bpmn_event evn_escalation_code varchar 255  √ 
pmse_bpmn_event evn_escalation_name varchar 255  √ 
pmse_bpmn_event evn_is_interrupting int 4  √  1
pmse_bpmn_event evn_marker varchar 30  √  EMPTY
pmse_bpmn_event evn_message text 65535  √  null
pmse_bpmn_event evn_operation_implementation varchar 255  √ 
pmse_bpmn_event evn_operation_name varchar 255  √ 
pmse_bpmn_event evn_time_cycle varchar 255  √ 
pmse_bpmn_event evn_time_date varchar 255  √ 
pmse_bpmn_event evn_time_duration varchar 255  √ 
pmse_bpmn_event evn_type varchar 30  √ 
pmse_bpmn_event evn_uid varchar 36  √ 
pmse_bpmn_event evn_wait_for_completion int 4  √  1
pmse_bpmn_event id char 36
pmse_bpmn_event modified_user_id char 36  √  null
pmse_bpmn_event name varchar 255  √  null
pmse_bpmn_event prj_id varchar 36  √ 
pmse_bpmn_event pro_id varchar 36  √ 
pmse_bpmn_extension assigned_user_id char 36  √  null
pmse_bpmn_extension created_by char 36  √  null
pmse_bpmn_extension date_entered datetime 19  √  null
pmse_bpmn_extension date_modified datetime 19  √  null
pmse_bpmn_extension deleted bit 1  √  0
pmse_bpmn_extension description 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  √ 
pmse_bpmn_extension id char 36
pmse_bpmn_extension modified_user_id char 36  √  null
pmse_bpmn_extension name varchar 255  √  null
pmse_bpmn_extension prj_id varchar 36  √ 
pmse_bpmn_flow assigned_user_id char 36  √  null
pmse_bpmn_flow created_by char 36  √  null
pmse_bpmn_flow date_entered datetime 19  √  null
pmse_bpmn_flow date_modified datetime 19  √  null
pmse_bpmn_flow deleted bit 1  √  0
pmse_bpmn_flow description text 65535  √  null
pmse_bpmn_flow dia_id varchar 36  √ 
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_bpmn_flow id char 36
pmse_bpmn_flow modified_user_id char 36  √  null
pmse_bpmn_flow name varchar 255  √  null
pmse_bpmn_flow prj_id varchar 36  √ 
pmse_bpmn_gateway assigned_user_id char 36  √  null
pmse_bpmn_gateway created_by char 36  √  null
pmse_bpmn_gateway date_entered datetime 19  √  null
pmse_bpmn_gateway date_modified datetime 19  √  null
pmse_bpmn_gateway deleted bit 1  √  0
pmse_bpmn_gateway description text 65535  √  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
pmse_bpmn_gateway id char 36
pmse_bpmn_gateway modified_user_id char 36  √  null
pmse_bpmn_gateway name varchar 255  √  null
pmse_bpmn_gateway prj_id varchar 36  √ 
pmse_bpmn_gateway pro_id varchar 36  √ 
pmse_bpmn_lane assigned_user_id char 36  √  null
pmse_bpmn_lane created_by char 36  √  null
pmse_bpmn_lane date_entered datetime 19  √  null
pmse_bpmn_lane date_modified datetime 19  √  null
pmse_bpmn_lane deleted bit 1  √  0
pmse_bpmn_lane description text 65535  √  null
pmse_bpmn_lane id char 36
pmse_bpmn_lane lan_child_laneset varchar 36  √ 
pmse_bpmn_lane lan_is_horizontal int 4  √  1
pmse_bpmn_lane lan_uid varchar 36  √ 
pmse_bpmn_lane lns_id varchar 36  √ 
pmse_bpmn_lane modified_user_id char 36  √  null
pmse_bpmn_lane name varchar 255  √  null
pmse_bpmn_lane prj_id varchar 36  √ 
pmse_bpmn_laneset assigned_user_id char 36  √  null
pmse_bpmn_laneset created_by char 36  √  null
pmse_bpmn_laneset date_entered datetime 19  √  null
pmse_bpmn_laneset date_modified datetime 19  √  null
pmse_bpmn_laneset deleted bit 1  √  0
pmse_bpmn_laneset description text 65535  √  null
pmse_bpmn_laneset id char 36
pmse_bpmn_laneset lns_is_horizontal int 4  √  1
pmse_bpmn_laneset lns_parent_lane varchar 36  √ 
pmse_bpmn_laneset lns_state text 65535  √  null
pmse_bpmn_laneset lns_uid varchar 36  √ 
pmse_bpmn_laneset modified_user_id char 36  √  null
pmse_bpmn_laneset name varchar 255  √  null
pmse_bpmn_laneset prj_id varchar 36  √ 
pmse_bpmn_laneset pro_id varchar 36  √ 
pmse_bpmn_participant assigned_user_id char 36  √  null
pmse_bpmn_participant created_by char 36  √  null
pmse_bpmn_participant date_entered datetime 19  √  null
pmse_bpmn_participant date_modified datetime 19  √  null
pmse_bpmn_participant deleted bit 1  √  0
pmse_bpmn_participant description text 65535  √  null
pmse_bpmn_participant id char 36
pmse_bpmn_participant lns_id varchar 36  √ 
pmse_bpmn_participant modified_user_id char 36  √  null
pmse_bpmn_participant name varchar 255  √  null
pmse_bpmn_participant par_is_horizontal int 4  √  1
pmse_bpmn_participant par_maximum int 4  √  1
pmse_bpmn_participant par_minimum int 4  √  0
pmse_bpmn_participant par_num_participants int 4  √  1
pmse_bpmn_participant par_uid varchar 36  √ 
pmse_bpmn_participant prj_id varchar 36  √ 
pmse_bpmn_participant pro_id varchar 36  √ 
pmse_bpmn_process assigned_user_id char 36  √  null
pmse_bpmn_process created_by char 36  √  null
pmse_bpmn_process date_entered datetime 19  √  null
pmse_bpmn_process date_modified datetime 19  √  null
pmse_bpmn_process deleted bit 1  √  0
pmse_bpmn_process description text 65535  √  null
pmse_bpmn_process dia_id varchar 36  √ 
pmse_bpmn_process id char 36
pmse_bpmn_process modified_user_id char 36  √  null
pmse_bpmn_process name varchar 255  √  null
pmse_bpmn_process prj_id varchar 36  √ 
pmse_bpmn_process pro_is_closed int 4  √  0
pmse_bpmn_process pro_is_executable int 4  √  0
pmse_bpmn_process pro_is_subprocess int 4  √  0
pmse_bpmn_process pro_type varchar 10  √  NONE
pmse_bpmn_process pro_uid varchar 36  √ 
pmse_business_rules acl_team_set_id char 36  √  null
pmse_business_rules assigned_user_id char 36  √  null
pmse_business_rules created_by char 36  √  null
pmse_business_rules date_entered datetime 19  √  null
pmse_business_rules date_modified datetime 19  √  null
pmse_business_rules deleted bit 1  √  0
pmse_business_rules description text 65535  √  null
pmse_business_rules id char 36
pmse_business_rules modified_user_id char 36  √  null
pmse_business_rules name varchar 255  √  null
pmse_business_rules rst_create_date datetime 19  √  null
pmse_business_rules rst_definition text 65535  √  null
pmse_business_rules rst_editable int 4  √  0
pmse_business_rules rst_filename varchar 255  √  null
pmse_business_rules rst_module varchar 100  √  null
pmse_business_rules rst_source varchar 255  √  null
pmse_business_rules rst_source_definition longtext 2147483647  √  null
pmse_business_rules rst_type varchar 100  √  single
pmse_business_rules rst_uid varchar 36  √  null
pmse_business_rules rst_update_date datetime 19  √  null
pmse_business_rules team_id char 36  √  null
pmse_business_rules team_set_id char 36  √  null
pmse_email_message bcc_addrs text 65535  √  null
pmse_email_message body longtext 2147483647  √  null
pmse_email_message body_html longtext 2147483647  √  null
pmse_email_message cc_addrs text 65535  √  null
pmse_email_message created_by char 36  √  null
pmse_email_message date_entered datetime 19  √  null
pmse_email_message date_modified datetime 19  √  null
pmse_email_message deleted bit 1  √  0
pmse_email_message description text 65535  √  null
pmse_email_message flow_id char 36  √  null
pmse_email_message from_addr varchar 255  √  null
pmse_email_message from_name varchar 255  √  null
pmse_email_message id char 36
pmse_email_message modified_user_id char 36  √  null
pmse_email_message name varchar 255  √  null
pmse_email_message outbound_email_id char 36  √  null
pmse_email_message reply_to_addr varchar 255  √  null
pmse_email_message reply_to_name varchar 255  √  null
pmse_email_message subject varchar 255  √  null
pmse_email_message to_addrs text 65535  √  null
pmse_emails_templates acl_team_set_id char 36  √  null
pmse_emails_templates assigned_user_id char 36  √  null
pmse_emails_templates base_module varchar 100  √  null
pmse_emails_templates body text 65535  √  null
pmse_emails_templates body_html text 65535  √  null
pmse_emails_templates created_by char 36  √  null
pmse_emails_templates date_entered datetime 19  √  null
pmse_emails_templates date_modified datetime 19  √  null
pmse_emails_templates deleted bit 1  √  0
pmse_emails_templates description text 65535  √  null
pmse_emails_templates from_address varchar 255  √  null
pmse_emails_templates from_name varchar 255  √  null
pmse_emails_templates id char 36
pmse_emails_templates modified_user_id char 36  √  null
pmse_emails_templates name varchar 255  √  null
pmse_emails_templates published varchar 3  √  null
pmse_emails_templates subject varchar 255  √  null
pmse_emails_templates team_id char 36  √  null
pmse_emails_templates team_set_id char 36  √  null
pmse_emails_templates text_only tinyint 4  √  null
pmse_emails_templates type varchar 255  √  null
pmse_inbox acl_team_set_id char 36  √  null
pmse_inbox assigned_user_id char 36  √  null
pmse_inbox cas_assigned_status varchar 12  √  UNASSIGNED
pmse_inbox cas_create_date datetime 19  √  null
pmse_inbox cas_custom_status varchar 32  √  null
pmse_inbox cas_finish_date datetime 19  √  null
pmse_inbox cas_id int 11  √ 
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_inbox cas_status varchar 32  √  IN PROGRESS
pmse_inbox cas_title varchar 255  √  null
pmse_inbox cas_update_date datetime 19  √  null
pmse_inbox created_by char 36  √  null
pmse_inbox date_entered datetime 19  √  null
pmse_inbox date_modified datetime 19  √  null
pmse_inbox deleted bit 1  √  0
pmse_inbox description text 65535  √  null
pmse_inbox id char 36
pmse_inbox modified_user_id char 36  √  null
pmse_inbox name varchar 255  √  null
pmse_inbox pro_id varchar 36  √  null
pmse_inbox pro_title varchar 255  √  null
pmse_inbox team_id char 36  √  null
pmse_inbox team_set_id char 36  √  null
pmse_project acl_team_set_id char 36  √  null
pmse_project assigned_user_id char 36  √  null
pmse_project created_by char 36  √  null
pmse_project date_entered datetime 19  √  null
pmse_project date_modified datetime 19  √  null
pmse_project deleted bit 1  √  0
pmse_project description text 65535  √  null
pmse_project id char 36
pmse_project modified_user_id char 36  √  null
pmse_project name varchar 255  √  null
pmse_project prj_author varchar 255  √  null
pmse_project prj_author_version varchar 255  √  null
pmse_project prj_exporter varchar 255  √  null
pmse_project prj_exporter_version varchar 255  √  null
pmse_project prj_expression_language varchar 255  √  null
pmse_project prj_module varchar 100  √  null
pmse_project prj_original_source varchar 255  √  null
pmse_project prj_run_order int 11  √  1
pmse_project prj_status varchar 10  √  INACTIVE
pmse_project prj_target_namespace varchar 255  √  null
pmse_project prj_type_language varchar 255  √  null
pmse_project prj_uid varchar 36  √  null
pmse_project team_id char 36  √  null
pmse_project team_set_id char 36  √  null
product_bundle_note bundle_id char 36  √  null
product_bundle_note date_modified datetime 19  √  null
product_bundle_note deleted bit 1  √  0
product_bundle_note id char 36
product_bundle_note note_id char 36  √  null