aok_knowledgebase
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
status
VARCHAR(100)
revision
VARCHAR(255)
additional_info
TEXT
user_id_c
CHAR(36)
user_id1_c
CHAR(36)
KEY
PRIMARY
bugs
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
AK
bug_number
INT(11)
NN
type
VARCHAR(255)
status
VARCHAR(100)
priority
VARCHAR(100)
resolution
VARCHAR(255)
work_log
TEXT
found_in_release
VARCHAR(255)
fixed_in_release
VARCHAR(255)
source
VARCHAR(255)
product_category
VARCHAR(255)
KEY
PRIMARY
KEY
bugsnumk
IX
bug_number
IX
idx_bug_name
IX
idx_bugs_assigned_user
outbound_email_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_outbound_email_parent_id
aos_line_item_groups_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_line_item_groups_parent_id
accounts_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_accounts_parent_id
aor_reports_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aor_reports_parent_id
templatesectionline
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
thumbnail
VARCHAR(255)
grp
VARCHAR(255)
ord
INT(11)
KEY
PRIMARY
aos_contracts_documents
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
aos_contracts_id
VARCHAR(36)
documents_id
VARCHAR(36)
document_revision_id
VARCHAR(36)
KEY
PRIMARY
IX
aos_contracts_documents_alt
project
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
assigned_user_id
CHAR(36)
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(50)
description
TEXT
deleted
TINYINT(1)
estimated_start_date
DATE
estimated_end_date
DATE
status
VARCHAR(255)
priority
VARCHAR(255)
override_business_hours
TINYINT(1)
KEY
PRIMARY
surveyquestions
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
sort_order
INT(255)
type
VARCHAR(100)
happiness_question
TINYINT(1)
survey_id
CHAR(36)
KEY
PRIMARY
accounts_contacts
PK
id
VARCHAR(36)
NN
contact_id
VARCHAR(36)
account_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_account_contact
IX
idx_contid_del_accid
fp_events_fp_event_locations_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
fp_events_fp_event_locations_1fp_events_ida
VARCHAR(36)
fp_events_fp_event_locations_1fp_event_locations_idb
VARCHAR(36)
KEY
PRIMARY
IX
fp_events_fp_event_locations_1_alt
aos_product_categories_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_product_categories_parent_id
meetings_users
PK
id
VARCHAR(36)
NN
meeting_id
VARCHAR(36)
user_id
VARCHAR(36)
required
VARCHAR(1)
accept_status
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_usr_mtg_mtg
IX
idx_usr_mtg_usr
IX
idx_meeting_users
accounts_cases
PK
id
VARCHAR(36)
NN
account_id
VARCHAR(36)
case_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_acc_case_acc
IX
idx_acc_acc_case
aok_knowledge_base_categories
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
KEY
PRIMARY
securitygroups_records
PK
id
CHAR(36)
NN
securitygroup_id
CHAR(36)
record_id
CHAR(36)
module
CHAR(36)
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_securitygroups_records_mod
IX
idx_securitygroups_records_del
surveyquestionoptions
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
sort_order
INT(255)
survey_question_id
CHAR(36)
KEY
PRIMARY
acl_actions
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(150)
category
VARCHAR(100)
acltype
VARCHAR(100)
aclaccess
INT(3)
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_aclaction_id_del
IX
idx_category_name
am_projecttemplates
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
status
VARCHAR(100)
priority
VARCHAR(100)
override_business_hours
TINYINT(1)
KEY
PRIMARY
users_signatures
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
deleted
TINYINT(1)
user_id
VARCHAR(36)
name
VARCHAR(255)
signature
TEXT
signature_html
TEXT
KEY
PRIMARY
IX
idx_usersig_uid
project_task
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
project_id
CHAR(36)
NN
project_task_id
INT(11)
name
VARCHAR(50)
status
VARCHAR(255)
relationship_type
VARCHAR(255)
description
TEXT
predecessors
TEXT
date_start
DATE
time_start
INT(11)
time_finish
INT(11)
date_finish
DATE
duration
INT(11)
duration_unit
TEXT
actual_duration
INT(11)
percent_complete
INT(11)
date_due
DATE
time_due
TIME
parent_task_id
INT(11)
assigned_user_id
CHAR(36)
modified_user_id
CHAR(36)
priority
VARCHAR(255)
created_by
CHAR(36)
milestone_flag
TINYINT(1)
order_number
INT(11)
task_number
INT(11)
estimated_effort
INT(11)
actual_effort
INT(11)
deleted
TINYINT(1)
utilization
INT(11)
KEY
PRIMARY
fp_event_locations_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_fp_event_locations_parent_id
aos_products_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_products_parent_id
surveyresponses
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
happiness
INT(11)
email_response_sent
TINYINT(1)
account_id
CHAR(36)
campaign_id
CHAR(36)
contact_id
CHAR(36)
survey_id
CHAR(36)
KEY
PRIMARY
accounts_bugs
PK
id
VARCHAR(36)
NN
account_id
VARCHAR(36)
bug_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_acc_bug_acc
IX
idx_acc_bug_bug
IX
idx_account_bug
jjwg_maps
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
distance
FLOAT(9,4)
unit_type
VARCHAR(100)
module_type
VARCHAR(100)
parent_type
VARCHAR(255)
parent_id
CHAR(36)
KEY
PRIMARY
fp_events
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
duration_hours
INT(3)
duration_minutes
INT(2)
date_start
DATETIME
date_end
DATETIME
budget
DECIMAL(26,6)
currency_id
CHAR(36)
invite_templates
VARCHAR(100)
accept_redirect
VARCHAR(255)
decline_redirect
VARCHAR(255)
activity_status_type
VARCHAR(255)
KEY
PRIMARY
aos_invoices_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_invoices_parent_id
campaigns_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_campaigns_parent_id
favorites
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
parent_id
CHAR(36)
parent_type
VARCHAR(255)
KEY
PRIMARY
aos_contracts_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_contracts_parent_id
users_feeds
user_id
VARCHAR(36)
feed_id
VARCHAR(36)
rank
INT(11)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
Primary key
IX
idx_ud_user_id
campaigns
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
tracker_key
INT(11)
NN
tracker_count
INT(11)
refer_url
VARCHAR(255)
tracker_text
VARCHAR(255)
start_date
DATE
end_date
DATE
status
VARCHAR(100)
impressions
INT(11)
currency_id
CHAR(36)
budget
DOUBLE
expected_cost
DOUBLE
actual_cost
DOUBLE
expected_revenue
DOUBLE
campaign_type
VARCHAR(100)
objective
TEXT
content
TEXT
frequency
VARCHAR(100)
survey_id
CHAR(36)
KEY
PRIMARY
IX
camp_auto_tracker_key
IX
idx_campaign_name
IX
idx_survey_id
aod_indexevent_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aod_indexevent_parent_id
opportunities_contacts
PK
id
VARCHAR(36)
NN
contact_id
VARCHAR(36)
opportunity_id
VARCHAR(36)
contact_role
VARCHAR(50)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_con_opp_con
IX
idx_con_opp_opp
IX
idx_opportunities_contacts
documents_accounts
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
document_id
VARCHAR(36)
account_id
VARCHAR(36)
KEY
PRIMARY
IX
documents_accounts_account_id
IX
documents_accounts_document_id
email_cache
ie_id
CHAR(36)
mbox
VARCHAR(60)
subject
VARCHAR(255)
fromaddr
VARCHAR(100)
toaddr
VARCHAR(255)
senddate
DATETIME
message_id
VARCHAR(255)
mailsize
INT(10)
imap_uid
INT(10)
msgno
INT(10)
recent
TINYINT(4)
flagged
TINYINT(4)
answered
TINYINT(4)
deleted
TINYINT(4)
seen
TINYINT(4)
draft
TINYINT(4)
KEY
Primary key
IX
idx_ie_id
IX
idx_mail_date
IX
idx_mail_from
IX
idx_mail_subj
IX
idx_mail_to
aos_quotes_aos_invoices_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
aos_quotes77d9_quotes_ida
VARCHAR(36)
aos_quotes6b83nvoices_idb
VARCHAR(36)
KEY
PRIMARY
IX
aos_quotes_aos_invoices_alt
acl_roles
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(150)
description
TEXT
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_aclrole_id_del
jjwg_areas
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
city
VARCHAR(255)
state
VARCHAR(255)
country
VARCHAR(255)
coordinates
TEXT
KEY
PRIMARY
fp_events_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_fp_events_parent_id
surveyquestionresponses
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
answer
TEXT
answer_bool
TINYINT(1)
answer_datetime
DATETIME
surveyquestion_id
CHAR(36)
surveyresponse_id
CHAR(36)
KEY
PRIMARY
jjwg_markers
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
city
VARCHAR(255)
state
VARCHAR(255)
country
VARCHAR(255)
jjwg_maps_lat
FLOAT(10,8)
jjwg_maps_lng
FLOAT(11,8)
marker_image
VARCHAR(100)
KEY
PRIMARY
opportunities
PK
id
CHAR(36)
NN
name
VARCHAR(50)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
opportunity_type
VARCHAR(255)
campaign_id
CHAR(36)
lead_source
VARCHAR(50)
amount
DOUBLE
amount_usdollar
DOUBLE
currency_id
CHAR(36)
date_closed
DATE
next_step
VARCHAR(100)
sales_stage
VARCHAR(255)
probability
DOUBLE
KEY
PRIMARY
IX
idx_opp_name
IX
idx_opp_assigned
IX
idx_opp_id_deleted
email_marketing
PK
id
CHAR(36)
NN
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(255)
from_name
VARCHAR(100)
from_addr
VARCHAR(100)
reply_to_name
VARCHAR(100)
reply_to_addr
VARCHAR(100)
inbound_email_id
VARCHAR(36)
date_start
DATETIME
template_id
CHAR(36)
NN
status
VARCHAR(100)
campaign_id
CHAR(36)
outbound_email_id
CHAR(36)
all_prospect_lists
TINYINT(1)
KEY
PRIMARY
IX
idx_emmkt_name
IX
idx_emmkit_del
oauth_nonce
PK
conskey
VARCHAR(32)
NN
PK
nonce
VARCHAR(32)
NN
nonce_ts
BIGINT(20)
KEY
PRIMARY
IX
oauth_nonce_keyts
aod_index_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aod_index_parent_id
accounts_opportunities
PK
id
VARCHAR(36)
NN
opportunity_id
VARCHAR(36)
account_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_account_opportunity
IX
idx_oppid_del_accid
am_projecttemplates_users_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
am_projecttemplates_ida
VARCHAR(36)
users_idb
VARCHAR(36)
KEY
PRIMARY
IX
am_projecttemplates_users_1_alt
bugs_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_bugs_parent_id
calls_reschedule_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_calls_reschedule_parent_id
opportunities_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_opportunities_parent_id
aow_processed_aow_actions
PK
id
VARCHAR(36)
NN
aow_processed_id
VARCHAR(36)
aow_action_id
VARCHAR(36)
status
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_aow_processed_aow_actions
IX
idx_actid_del_freid
document_revisions
PK
id
VARCHAR(36)
NN
change_log
VARCHAR(255)
document_id
VARCHAR(36)
doc_id
VARCHAR(100)
doc_type
VARCHAR(100)
doc_url
VARCHAR(255)
date_entered
DATETIME
created_by
CHAR(36)
filename
VARCHAR(255)
file_ext
VARCHAR(100)
file_mime_type
VARCHAR(100)
revision
VARCHAR(100)
deleted
TINYINT(1)
date_modified
DATETIME
KEY
PRIMARY
IX
documentrevision_mimetype
job_queue
assigned_user_id
CHAR(36)
PK
id
CHAR(36)
NN
name
VARCHAR(255)
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
scheduler_id
CHAR(36)
execute_time
DATETIME
status
VARCHAR(20)
resolution
VARCHAR(20)
message
TEXT
target
VARCHAR(255)
data
TEXT
requeue
TINYINT(1)
retry_count
TINYINT(4)
failure_count
TINYINT(4)
job_delay
INT(11)
client
VARCHAR(255)
percent_complete
INT(11)
KEY
PRIMARY
IX
idx_status_scheduler
IX
idx_status_time
IX
idx_status_entered
IX
idx_status_modified
opportunities_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
cases
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
AK
case_number
INT(11)
NN
type
VARCHAR(255)
status
VARCHAR(100)
priority
VARCHAR(100)
resolution
TEXT
work_log
TEXT
account_id
CHAR(36)
state
VARCHAR(100)
contact_created_by_id
CHAR(36)
KEY
PRIMARY
KEY
casesnumk
IX
case_number
IX
idx_case_name
IX
idx_account_id
IX
idx_cases_stat_del
import_maps
PK
id
CHAR(36)
NN
name
VARCHAR(254)
source
VARCHAR(36)
enclosure
VARCHAR(1)
delimiter
VARCHAR(1)
module
VARCHAR(36)
content
TEXT
default_values
TEXT
has_header
TINYINT(1)
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
assigned_user_id
CHAR(36)
is_published
VARCHAR(3)
KEY
PRIMARY
IX
idx_owner_module_name
tasks
PK
id
CHAR(36)
NN
name
VARCHAR(50)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
status
VARCHAR(100)
date_due_flag
TINYINT(1)
date_due
DATETIME
date_start_flag
TINYINT(1)
date_start
DATETIME
parent_type
VARCHAR(255)
parent_id
CHAR(36)
contact_id
CHAR(36)
priority
VARCHAR(100)
KEY
PRIMARY
IX
idx_tsk_name
IX
idx_task_con_del
IX
idx_task_par_del
IX
idx_task_assigned
IX
idx_task_status
email_addresses
PK
id
CHAR(36)
NN
email_address
VARCHAR(255)
email_address_caps
VARCHAR(255)
invalid_email
TINYINT(1)
opt_out
TINYINT(1)
confirm_opt_in
VARCHAR(255)
confirm_opt_in_date
DATETIME
confirm_opt_in_sent_date
DATETIME
confirm_opt_in_fail_date
DATETIME
confirm_opt_in_token
VARCHAR(255)
date_created
DATETIME
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_ea_caps_opt_out_invalid
IX
idx_ea_opt_out_invalid
prospect_list_campaigns
PK
id
VARCHAR(36)
NN
prospect_list_id
VARCHAR(36)
campaign_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_pro_id
IX
idx_cam_id
IX
idx_prospect_list_campaigns
projects_cases
PK
id
VARCHAR(36)
NN
case_id
VARCHAR(36)
project_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_proj_case_proj
IX
idx_proj_case_case
IX
projects_cases_alt
documents
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
document_name
VARCHAR(255)
doc_id
VARCHAR(100)
doc_type
VARCHAR(100)
doc_url
VARCHAR(255)
active_date
DATE
exp_date
DATE
category_id
VARCHAR(100)
subcategory_id
VARCHAR(100)
status_id
VARCHAR(100)
document_revision_id
VARCHAR(36)
related_doc_id
CHAR(36)
related_doc_rev_id
CHAR(36)
is_template
TINYINT(1)
template_type
VARCHAR(100)
KEY
PRIMARY
IX
idx_doc_cat
securitygroups_acl_roles
PK
id
CHAR(36)
NN
securitygroup_id
CHAR(36)
role_id
CHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
acl_roles_users
PK
id
VARCHAR(36)
NN
role_id
VARCHAR(36)
user_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_aclrole_id
IX
idx_acluser_id
IX
idx_aclrole_user
folders_rel
PK
id
CHAR(36)
NN
folder_id
CHAR(36)
NN
polymorphic_module
VARCHAR(25)
polymorphic_id
CHAR(36)
NN
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_poly_module_poly_id
IX
idx_fr_id_deleted_poly
contacts
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
salutation
VARCHAR(255)
first_name
VARCHAR(100)
last_name
VARCHAR(100)
title
VARCHAR(100)
photo
VARCHAR(255)
department
VARCHAR(255)
do_not_call
TINYINT(1)
phone_home
VARCHAR(100)
phone_mobile
VARCHAR(100)
phone_work
VARCHAR(100)
phone_other
VARCHAR(100)
phone_fax
VARCHAR(100)
lawful_basis
TEXT
date_reviewed
DATE
lawful_basis_source
VARCHAR(100)
primary_address_street
VARCHAR(150)
primary_address_city
VARCHAR(100)
primary_address_state
VARCHAR(100)
primary_address_postalcode
VARCHAR(20)
primary_address_country
VARCHAR(255)
alt_address_street
VARCHAR(150)
alt_address_city
VARCHAR(100)
alt_address_state
VARCHAR(100)
alt_address_postalcode
VARCHAR(20)
alt_address_country
VARCHAR(255)
assistant
VARCHAR(75)
assistant_phone
VARCHAR(100)
lead_source
VARCHAR(255)
reports_to_id
CHAR(36)
birthdate
DATE
campaign_id
CHAR(36)
joomla_account_id
VARCHAR(255)
portal_account_disabled
TINYINT(1)
portal_user_type
VARCHAR(100)
KEY
PRIMARY
IX
idx_cont_last_first
IX
idx_contacts_del_last
IX
idx_cont_del_reports
IX
idx_reports_to_id
IX
idx_del_id_user
IX
idx_cont_assigned
aor_reports
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
report_module
VARCHAR(100)
graphs_per_row
INT(11)
KEY
PRIMARY
eapm
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
password
VARCHAR(255)
url
VARCHAR(255)
application
VARCHAR(100)
api_data
TEXT
consumer_key
VARCHAR(255)
consumer_secret
VARCHAR(255)
oauth_token
VARCHAR(255)
oauth_secret
VARCHAR(255)
validated
TINYINT(1)
KEY
PRIMARY
IX
idx_app_active
cases_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
aos_products
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
maincode
VARCHAR(100)
part_number
VARCHAR(25)
category
VARCHAR(100)
type
VARCHAR(100)
cost
DECIMAL(26,6)
cost_usdollar
DECIMAL(26,6)
currency_id
CHAR(36)
price
DECIMAL(26,6)
price_usdollar
DECIMAL(26,6)
url
VARCHAR(255)
contact_id
CHAR(36)
product_image
VARCHAR(255)
aos_product_category_id
CHAR(36)
KEY
PRIMARY
aop_case_events_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aop_case_events_parent_id
roles_users
PK
id
VARCHAR(36)
NN
role_id
VARCHAR(36)
user_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_ru_role_id
IX
idx_ru_user_id
aos_products_quotes
PK
id
CHAR(36)
NN
name
TEXT
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
currency_id
CHAR(36)
part_number
VARCHAR(255)
item_description
TEXT
number
INT(11)
product_qty
DECIMAL(18,4)
product_cost_price
DECIMAL(26,6)
product_cost_price_usdollar
DECIMAL(26,6)
product_list_price
DECIMAL(26,6)
product_list_price_usdollar
DECIMAL(26,6)
product_discount
DECIMAL(26,6)
product_discount_usdollar
DECIMAL(26,6)
product_discount_amount
DECIMAL(26,6)
product_discount_amount_usdollar
DECIMAL(26,6)
discount
VARCHAR(255)
product_unit_price
DECIMAL(26,6)
product_unit_price_usdollar
DECIMAL(26,6)
vat_amt
DECIMAL(26,6)
vat_amt_usdollar
DECIMAL(26,6)
product_total_price
DECIMAL(26,6)
product_total_price_usdollar
DECIMAL(26,6)
vat
VARCHAR(100)
parent_type
VARCHAR(100)
parent_id
CHAR(36)
product_id
CHAR(36)
group_id
CHAR(36)
KEY
PRIMARY
IX
idx_aospq_par_del
surveys
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
status
VARCHAR(100)
submit_text
VARCHAR(255)
satisfied_text
VARCHAR(255)
neither_text
VARCHAR(255)
dissatisfied_text
VARCHAR(255)
KEY
PRIMARY
inbound_email_cache_ts
PK
id
VARCHAR(255)
NN
ie_timestamp
INT(10)
KEY
PRIMARY
email_templates
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
VARCHAR(36)
published
VARCHAR(3)
name
VARCHAR(255)
description
TEXT
subject
VARCHAR(255)
body
LONGTEXT
body_html
LONGTEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
text_only
TINYINT(1)
type
VARCHAR(255)
KEY
PRIMARY
IX
idx_email_template_name
aos_quotes_os_contracts_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
aos_quotese81e_quotes_ida
VARCHAR(36)
aos_quotes4dc0ntracts_idb
VARCHAR(36)
KEY
PRIMARY
IX
aos_quotes_aos_contracts_alt
calls_users
PK
id
VARCHAR(36)
NN
call_id
VARCHAR(36)
user_id
VARCHAR(36)
required
VARCHAR(1)
accept_status
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_usr_call_call
IX
idx_usr_call_usr
IX
idx_call_users
cron_remove_documents
PK
id
VARCHAR(36)
NN
bean_id
VARCHAR(36)
module
VARCHAR(25)
date_modified
DATETIME
KEY
PRIMARY
IX
idx_cron_remove_document_bean_id
IX
idx_cron_remove_document_stamp
vcals
PK
id
CHAR(36)
NN
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
user_id
CHAR(36)
NN
type
VARCHAR(100)
source
VARCHAR(100)
content
TEXT
KEY
PRIMARY
IX
idx_vcal
config
category
VARCHAR(32)
name
VARCHAR(32)
value
TEXT
KEY
Primary key
IX
idx_config_cat
users_password_link
PK
id
CHAR(36)
NN
username
VARCHAR(36)
date_generated
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_username
user_preferences
PK
id
CHAR(36)
NN
category
VARCHAR(50)
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
assigned_user_id
CHAR(36)
contents
LONGTEXT
KEY
PRIMARY
IX
idx_userprefnamecat
am_projecttemplates_project_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
am_projecttemplates_project_1am_projecttemplates_ida
VARCHAR(36)
am_projecttemplates_project_1project_idb
VARCHAR(36)
KEY
PRIMARY
IX
am_projecttemplates_project_1_ida1
IX
am_projecttemplates_project_1_alt
surveyresponses_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_surveyresponses_parent_id
securitygroups_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_securitygroups_parent_id
aor_scheduled_reports
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
schedule
VARCHAR(100)
last_run
DATETIME
status
VARCHAR(100)
email_recipients
LONGTEXT
aor_report_id
CHAR(36)
KEY
PRIMARY
oauth2tokens
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
token_is_revoked
TINYINT(1)
token_type
VARCHAR(255)
access_token_expires
DATETIME
access_token
VARCHAR(4000)
refresh_token
VARCHAR(4000)
refresh_token_expires
DATETIME
grant_type
VARCHAR(255)
state
VARCHAR(1024)
client
CHAR(36)
assigned_user_id
CHAR(36)
KEY
PRIMARY
campaign_log
PK
id
CHAR(36)
NN
campaign_id
CHAR(36)
target_tracker_key
VARCHAR(36)
target_id
VARCHAR(36)
target_type
VARCHAR(100)
activity_type
VARCHAR(100)
activity_date
DATETIME
related_id
VARCHAR(36)
related_type
VARCHAR(100)
archived
TINYINT(1)
hits
INT(11)
list_id
CHAR(36)
deleted
TINYINT(1)
date_modified
DATETIME
more_information
VARCHAR(100)
marketing_id
CHAR(36)
KEY
PRIMARY
IX
idx_camp_tracker
IX
idx_camp_campaign_id
IX
idx_camp_more_info
IX
idx_target_id
IX
idx_target_id_deleted
project_task_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_project_task_parent_id
users_last_import
PK
id
CHAR(36)
NN
assigned_user_id
CHAR(36)
import_module
VARCHAR(36)
bean_type
VARCHAR(36)
bean_id
CHAR(36)
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_user_id
prospects_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
saved_search
PK
id
CHAR(36)
NN
name
VARCHAR(150)
search_module
VARCHAR(150)
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
assigned_user_id
CHAR(36)
contents
TEXT
description
TEXT
KEY
PRIMARY
IX
idx_desc
aok_knowledge_base_categories_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aok_knowledge_base_categories_parent_id
leads_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_leads_parent_id
tracker
PK
id
INT(11)
NN
monitor_id
CHAR(36)
NN
user_id
VARCHAR(36)
module_name
VARCHAR(255)
item_id
VARCHAR(36)
item_summary
VARCHAR(255)
date_modified
DATETIME
action
VARCHAR(255)
session_id
VARCHAR(36)
visible
TINYINT(1)
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_tracker_iid
IX
idx_tracker_userid_vis_id
IX
idx_tracker_userid_itemid_vis
IX
idx_tracker_monitor_id
IX
idx_tracker_date_modified
folders_subscriptions
PK
id
CHAR(36)
NN
folder_id
CHAR(36)
NN
assigned_user_id
CHAR(36)
NN
KEY
PRIMARY
IX
idx_folder_id_assigned_user_id
leads
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
salutation
VARCHAR(255)
first_name
VARCHAR(100)
last_name
VARCHAR(100)
title
VARCHAR(100)
photo
VARCHAR(255)
department
VARCHAR(100)
do_not_call
TINYINT(1)
phone_home
VARCHAR(100)
phone_mobile
VARCHAR(100)
phone_work
VARCHAR(100)
phone_other
VARCHAR(100)
phone_fax
VARCHAR(100)
lawful_basis
TEXT
date_reviewed
DATE
lawful_basis_source
VARCHAR(100)
primary_address_street
VARCHAR(150)
primary_address_city
VARCHAR(100)
primary_address_state
VARCHAR(100)
primary_address_postalcode
VARCHAR(20)
primary_address_country
VARCHAR(255)
alt_address_street
VARCHAR(150)
alt_address_city
VARCHAR(100)
alt_address_state
VARCHAR(100)
alt_address_postalcode
VARCHAR(20)
alt_address_country
VARCHAR(255)
assistant
VARCHAR(75)
assistant_phone
VARCHAR(100)
converted
TINYINT(1)
refered_by
VARCHAR(100)
lead_source
VARCHAR(100)
lead_source_description
TEXT
status
VARCHAR(100)
status_description
TEXT
reports_to_id
CHAR(36)
account_name
VARCHAR(255)
account_description
TEXT
contact_id
CHAR(36)
account_id
CHAR(36)
opportunity_id
CHAR(36)
opportunity_name
VARCHAR(255)
opportunity_amount
VARCHAR(50)
campaign_id
CHAR(36)
birthdate
DATE
portal_name
VARCHAR(255)
portal_app
VARCHAR(255)
website
VARCHAR(255)
KEY
PRIMARY
IX
idx_lead_acct_name_first
IX
idx_lead_last_first
IX
idx_lead_del_stat
IX
idx_lead_opp_del
IX
idx_leads_acct_del
IX
idx_del_user
IX
idx_lead_assigned
IX
idx_lead_contact
IX
idx_reports_to
IX
idx_lead_phone_work
IX
idx_leads_id_del
contacts_bugs
PK
id
VARCHAR(36)
NN
contact_id
VARCHAR(36)
bug_id
VARCHAR(36)
contact_role
VARCHAR(50)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_con_bug_con
IX
idx_con_bug_bug
IX
idx_contact_bug
email_marketing_prospect_lists
PK
id
VARCHAR(36)
NN
prospect_list_id
VARCHAR(36)
email_marketing_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
email_mp_prospects
aow_workflow_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aow_workflow_parent_id
projects_accounts
PK
id
VARCHAR(36)
NN
account_id
VARCHAR(36)
project_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_proj_acct_proj
IX
idx_proj_acct_acct
IX
projects_accounts_alt
prospects
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
salutation
VARCHAR(255)
first_name
VARCHAR(100)
last_name
VARCHAR(100)
title
VARCHAR(100)
photo
VARCHAR(255)
department
VARCHAR(255)
do_not_call
TINYINT(1)
phone_home
VARCHAR(100)
phone_mobile
VARCHAR(100)
phone_work
VARCHAR(100)
phone_other
VARCHAR(100)
phone_fax
VARCHAR(100)
lawful_basis
TEXT
date_reviewed
DATE
lawful_basis_source
VARCHAR(100)
primary_address_street
VARCHAR(150)
primary_address_city
VARCHAR(100)
primary_address_state
VARCHAR(100)
primary_address_postalcode
VARCHAR(20)
primary_address_country
VARCHAR(255)
alt_address_street
VARCHAR(150)
alt_address_city
VARCHAR(100)
alt_address_state
VARCHAR(100)
alt_address_postalcode
VARCHAR(20)
alt_address_country
VARCHAR(255)
assistant
VARCHAR(75)
assistant_phone
VARCHAR(100)
tracker_key
INT(11)
NN
birthdate
DATE
lead_id
CHAR(36)
account_name
VARCHAR(150)
campaign_id
CHAR(36)
KEY
PRIMARY
IX
prospect_auto_tracker_key
IX
idx_prospects_last_first
IX
idx_prospecs_del_last
IX
idx_prospects_id_del
IX
idx_prospects_assigned
aos_line_item_groups
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
total_amt
DECIMAL(26,6)
total_amt_usdollar
DECIMAL(26,6)
discount_amount
DECIMAL(26,6)
discount_amount_usdollar
DECIMAL(26,6)
subtotal_amount
DECIMAL(26,6)
subtotal_amount_usdollar
DECIMAL(26,6)
tax_amount
DECIMAL(26,6)
tax_amount_usdollar
DECIMAL(26,6)
subtotal_tax_amount
DECIMAL(26,6)
subtotal_tax_amount_usdollar
DECIMAL(26,6)
total_amount
DECIMAL(26,6)
total_amount_usdollar
DECIMAL(26,6)
parent_type
VARCHAR(100)
parent_id
CHAR(36)
number
INT(11)
currency_id
CHAR(36)
KEY
PRIMARY
aow_processed
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
aow_workflow_id
CHAR(36)
parent_id
CHAR(36)
parent_type
VARCHAR(100)
status
VARCHAR(100)
KEY
PRIMARY
IX
aow_processed_index_workflow
IX
aow_processed_index_status
IX
aow_processed_index_workflow_id
address_book
assigned_user_id
CHAR(36)
NN
bean
VARCHAR(50)
bean_id
CHAR(36)
NN
KEY
Primary key
IX
ab_user_bean_idx
project_users_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
project_users_1project_ida
VARCHAR(36)
project_users_1users_idb
VARCHAR(36)
KEY
PRIMARY
IX
project_users_1_alt
aos_pdf_templates
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
LONGTEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
active
TINYINT(1)
type
VARCHAR(100)
pdfheader
TEXT
pdffooter
TEXT
margin_left
INT(255)
margin_right
INT(255)
margin_top
INT(255)
margin_bottom
INT(255)
margin_header
INT(255)
margin_footer
INT(255)
page_size
VARCHAR(100)
orientation
VARCHAR(100)
KEY
PRIMARY
aos_quotes
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
approval_issue
TEXT
billing_account_id
CHAR(36)
billing_contact_id
CHAR(36)
billing_address_street
VARCHAR(150)
billing_address_city
VARCHAR(100)
billing_address_state
VARCHAR(100)
billing_address_postalcode
VARCHAR(20)
billing_address_country
VARCHAR(255)
shipping_address_street
VARCHAR(150)
shipping_address_city
VARCHAR(100)
shipping_address_state
VARCHAR(100)
shipping_address_postalcode
VARCHAR(20)
shipping_address_country
VARCHAR(255)
expiration
DATE
number
INT(11)
opportunity_id
CHAR(36)
template_ddown_c
TEXT
total_amt
DECIMAL(26,6)
total_amt_usdollar
DECIMAL(26,6)
subtotal_amount
DECIMAL(26,6)
subtotal_amount_usdollar
DECIMAL(26,6)
discount_amount
DECIMAL(26,6)
discount_amount_usdollar
DECIMAL(26,6)
tax_amount
DECIMAL(26,6)
tax_amount_usdollar
DECIMAL(26,6)
shipping_amount
DECIMAL(26,6)
shipping_amount_usdollar
DECIMAL(26,6)
shipping_tax
VARCHAR(100)
shipping_tax_amt
DECIMAL(26,6)
shipping_tax_amt_usdollar
DECIMAL(26,6)
total_amount
DECIMAL(26,6)
total_amount_usdollar
DECIMAL(26,6)
currency_id
CHAR(36)
stage
VARCHAR(100)
term
VARCHAR(100)
terms_c
TEXT
approval_status
VARCHAR(100)
invoice_status
VARCHAR(100)
subtotal_tax_amount
DECIMAL(26,6)
subtotal_tax_amount_usdollar
DECIMAL(26,6)
KEY
PRIMARY
securitygroups
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
noninheritable
TINYINT(1)
KEY
PRIMARY
am_tasktemplates_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_am_tasktemplates_parent_id
surveyquestionoptions_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_surveyquestionoptions_parent_id
fp_event_locations_fp_events_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
fp_event_locations_fp_events_1fp_event_locations_ida
VARCHAR(36)
fp_event_locations_fp_events_1fp_events_idb
VARCHAR(36)
KEY
PRIMARY
IX
fp_event_locations_fp_events_1_ida1
IX
fp_event_locations_fp_events_1_alt
documents_opportunities
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
document_id
VARCHAR(36)
opportunity_id
VARCHAR(36)
KEY
PRIMARY
IX
idx_docu_opps_oppo_id
IX
idx_docu_oppo_docu_id
fp_events_contacts_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
fp_events_contactsfp_events_ida
VARCHAR(36)
fp_events_contactscontacts_idb
VARCHAR(36)
invite_status
VARCHAR(25)
accept_status
VARCHAR(25)
email_responded
INT(2)
KEY
PRIMARY
IX
fp_events_contacts_alt
am_projecttemplates_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_am_projecttemplates_parent_id
am_tasktemplates_am_projecttemplates_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
am_tasktemplates_am_projecttemplatesam_projecttemplates_ida
VARCHAR(36)
am_tasktemplates_am_projecttemplatesam_tasktemplates_idb
VARCHAR(36)
KEY
PRIMARY
IX
am_tasktemplates_am_projecttemplates_ida1
IX
am_tasktemplates_am_projecttemplates_alt
emails_email_addr_rel
PK
id
CHAR(36)
NN
email_id
CHAR(36)
NN
address_type
VARCHAR(4)
email_address_id
CHAR(36)
NN
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_eearl_email_id
IX
idx_eearl_address_id
project_contacts_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
project_contacts_1project_ida
VARCHAR(36)
project_contacts_1contacts_idb
VARCHAR(36)
KEY
PRIMARY
IX
project_contacts_1_alt
aop_case_events
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
case_id
CHAR(36)
KEY
PRIMARY
documents_contacts
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
document_id
VARCHAR(36)
contact_id
VARCHAR(36)
KEY
PRIMARY
IX
documents_contacts_contact_id
IX
documents_contacts_document_id
aor_conditions
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
aor_report_id
CHAR(36)
condition_order
INT(255)
logic_op
VARCHAR(255)
parenthesis
VARCHAR(255)
module_path
LONGTEXT
field
VARCHAR(100)
operator
VARCHAR(100)
value_type
VARCHAR(100)
value
VARCHAR(255)
parameter
TINYINT(1)
KEY
PRIMARY
IX
aor_conditions_index_report_id
documents_bugs
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
document_id
VARCHAR(36)
bug_id
VARCHAR(36)
KEY
PRIMARY
IX
documents_bugs_bug_id
IX
documents_bugs_document_id
aor_charts
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
aor_report_id
CHAR(36)
type
VARCHAR(100)
x_field
INT(11)
y_field
INT(11)
KEY
PRIMARY
acl_roles_actions
PK
id
VARCHAR(36)
NN
role_id
VARCHAR(36)
action_id
VARCHAR(36)
access_override
INT(3)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_acl_role_id
IX
idx_acl_action_id
IX
idx_aclrole_action
calls_contacts
PK
id
VARCHAR(36)
NN
call_id
VARCHAR(36)
contact_id
VARCHAR(36)
required
VARCHAR(1)
accept_status
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_con_call_call
IX
idx_con_call_con
IX
idx_call_contact
prospect_lists
assigned_user_id
CHAR(36)
PK
id
CHAR(36)
NN
name
VARCHAR(255)
list_type
VARCHAR(100)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
deleted
TINYINT(1)
description
TEXT
domain_name
VARCHAR(255)
KEY
PRIMARY
IX
idx_prospect_list_name
aod_index
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
last_optimised
DATETIME
location
VARCHAR(255)
KEY
PRIMARY
linked_documents
PK
id
VARCHAR(36)
NN
parent_id
VARCHAR(36)
parent_type
VARCHAR(25)
document_id
VARCHAR(36)
document_revision_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_parent_document
spots
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
config
LONGTEXT
type
VARCHAR(255)
KEY
PRIMARY
oauth_consumer
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
AK
c_key
VARCHAR(255)
c_secret
VARCHAR(255)
KEY
PRIMARY
KEY
ckey
aos_products_quotes_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_products_quotes_parent_id
project_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
prospect_lists_prospects
PK
id
VARCHAR(36)
NN
prospect_list_id
VARCHAR(36)
related_id
VARCHAR(36)
related_type
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_plp_pro_id
IX
idx_plp_rel_id
releases
PK
id
CHAR(36)
NN
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(50)
list_order
INT(4)
status
VARCHAR(100)
KEY
PRIMARY
IX
idx_releases
roles_modules
PK
id
VARCHAR(36)
NN
role_id
VARCHAR(36)
module_id
VARCHAR(36)
allow
TINYINT(1)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_role_id
IX
idx_module_id
aod_indexevent
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
error
VARCHAR(255)
success
TINYINT(1)
record_id
CHAR(36)
record_module
VARCHAR(255)
KEY
PRIMARY
IX
idx_record_module
IX
idx_record_id
aos_product_categories
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
is_parent
TINYINT(1)
parent_category_id
CHAR(36)
KEY
PRIMARY
jjwg_maps_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_jjwg_maps_parent_id
am_projecttemplates_contacts_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
am_projecttemplates_ida
VARCHAR(36)
contacts_idb
VARCHAR(36)
KEY
PRIMARY
IX
am_projecttemplates_contacts_1_alt
projects_bugs
PK
id
VARCHAR(36)
NN
bug_id
VARCHAR(36)
project_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_proj_bug_proj
IX
idx_proj_bug_bug
IX
projects_bugs_alt
custom_fields
bean_id
VARCHAR(36)
set_num
INT(11)
field0
VARCHAR(255)
field1
VARCHAR(255)
field2
VARCHAR(255)
field3
VARCHAR(255)
field4
VARCHAR(255)
field5
VARCHAR(255)
field6
VARCHAR(255)
field7
VARCHAR(255)
field8
VARCHAR(255)
field9
VARCHAR(255)
deleted
TINYINT(1)
KEY
Primary key
IX
idx_beanid_set_num
contacts_cases
PK
id
VARCHAR(36)
NN
contact_id
VARCHAR(36)
case_id
VARCHAR(36)
contact_role
VARCHAR(50)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_con_case_con
IX
idx_con_case_case
IX
idx_contacts_cases
securitygroups_users
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
securitygroup_id
VARCHAR(36)
user_id
VARCHAR(36)
primary_group
TINYINT(1)
noninheritable
TINYINT(1)
KEY
PRIMARY
IX
securitygroups_users_idxa
IX
securitygroups_users_idxb
IX
securitygroups_users_idxc
IX
securitygroups_users_idxd
calls
PK
id
CHAR(36)
NN
name
VARCHAR(50)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
duration_hours
INT(2)
duration_minutes
INT(2)
date_start
DATETIME
date_end
DATETIME
parent_type
VARCHAR(255)
status
VARCHAR(100)
direction
VARCHAR(100)
parent_id
CHAR(36)
reminder_time
INT(11)
email_reminder_time
INT(11)
email_reminder_sent
TINYINT(1)
outlook_id
VARCHAR(255)
repeat_type
VARCHAR(36)
repeat_interval
INT(3)
repeat_dow
VARCHAR(7)
repeat_until
DATE
repeat_count
INT(7)
repeat_parent_id
CHAR(36)
recurring_source
VARCHAR(36)
KEY
PRIMARY
IX
idx_call_name
IX
idx_status
IX
idx_calls_date_start
IX
idx_calls_par_del
IX
idx_calls_assigned_del
reminders_invitees
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
reminder_id
CHAR(36)
NN
related_invitee_module
VARCHAR(32)
related_invitee_module_id
CHAR(36)
NN
KEY
PRIMARY
IX
idx_reminder_invitee_name
IX
idx_reminder_invitee_assigned_user_id
IX
idx_reminder_invitee_reminder_id
IX
idx_reminder_invitee_related_invitee_module
IX
idx_reminder_invitee_related_invitee_module_id
outbound_email
PK
id
CHAR(36)
NN
name
VARCHAR(255)
type
VARCHAR(15)
user_id
CHAR(36)
NN
smtp_from_name
VARCHAR(255)
smtp_from_addr
VARCHAR(255)
mail_sendtype
VARCHAR(8)
mail_smtptype
VARCHAR(20)
mail_smtpserver
VARCHAR(100)
mail_smtpport
VARCHAR(5)
mail_smtpuser
VARCHAR(100)
mail_smtppass
VARCHAR(100)
mail_smtpauth_req
TINYINT(1)
mail_smtpssl
VARCHAR(1)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
KEY
PRIMARY
inbound_email_autoreply
PK
id
CHAR(36)
NN
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
autoreplied_to
VARCHAR(100)
ie_id
CHAR(36)
NN
KEY
PRIMARY
IX
idx_ie_autoreplied_to
currencies
PK
id
CHAR(36)
NN
name
VARCHAR(36)
symbol
VARCHAR(36)
iso4217
VARCHAR(3)
conversion_rate
DOUBLE
status
VARCHAR(100)
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
created_by
CHAR(36)
NN
KEY
PRIMARY
IX
idx_currency_name
oauth2clients
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
secret
VARCHAR(4000)
redirect_url
VARCHAR(255)
is_confidential
TINYINT(1)
allowed_grant_type
VARCHAR(255)
duration_value
INT(11)
duration_amount
INT(11)
duration_unit
VARCHAR(255)
assigned_user_id
CHAR(36)
KEY
PRIMARY
surveys_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_surveys_parent_id
roles
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(150)
description
TEXT
modules
TEXT
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_role_id_del
leads_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
folders
PK
id
CHAR(36)
NN
name
VARCHAR(255)
folder_type
VARCHAR(25)
parent_folder
CHAR(36)
has_child
TINYINT(1)
is_group
TINYINT(1)
is_dynamic
TINYINT(1)
dynamic_query
TEXT
assign_to_id
CHAR(36)
created_by
CHAR(36)
NN
modified_by
CHAR(36)
NN
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_parent_folder
meetings
PK
id
CHAR(36)
NN
name
VARCHAR(50)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
location
VARCHAR(50)
password
VARCHAR(50)
join_url
VARCHAR(200)
host_url
VARCHAR(400)
displayed_url
VARCHAR(400)
creator
VARCHAR(50)
external_id
VARCHAR(50)
duration_hours
INT(3)
duration_minutes
INT(2)
date_start
DATETIME
date_end
DATETIME
parent_type
VARCHAR(100)
status
VARCHAR(100)
type
VARCHAR(255)
parent_id
CHAR(36)
reminder_time
INT(11)
email_reminder_time
INT(11)
email_reminder_sent
TINYINT(1)
outlook_id
VARCHAR(255)
sequence
INT(11)
repeat_type
VARCHAR(36)
repeat_interval
INT(3)
repeat_dow
VARCHAR(7)
repeat_until
DATE
repeat_count
INT(7)
repeat_parent_id
CHAR(36)
recurring_source
VARCHAR(36)
gsync_id
VARCHAR(1024)
gsync_lastsync
INT(11)
KEY
PRIMARY
IX
idx_mtg_name
IX
idx_meet_par_del
IX
idx_meet_stat_del
IX
idx_meet_date_start
fp_events_fp_event_delegates_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
fp_events_fp_event_delegates_1fp_events_ida
VARCHAR(36)
fp_events_fp_event_delegates_1fp_event_delegates_idb
VARCHAR(36)
KEY
PRIMARY
IX
fp_events_fp_event_delegates_1_ida1
IX
fp_events_fp_event_delegates_1_alt
aop_case_updates_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aop_case_updates_parent_id
surveyquestionoptions_surveyquestionresponses
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
surveyq72c7options_ida
VARCHAR(36)
surveyq10d4sponses_idb
VARCHAR(36)
KEY
PRIMARY
IX
surveyquestionoptions_surveyquestionresponses_alt
accounts_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
aos_contracts
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
reference_code
VARCHAR(255)
start_date
DATE
end_date
DATE
total_contract_value
DECIMAL(26,6)
total_contract_value_usdollar
DECIMAL(26,6)
currency_id
CHAR(36)
status
VARCHAR(100)
customer_signed_date
DATE
company_signed_date
DATE
renewal_reminder_date
DATETIME
contract_type
VARCHAR(100)
contract_account_id
CHAR(36)
opportunity_id
CHAR(36)
contact_id
CHAR(36)
call_id
CHAR(36)
total_amt
DECIMAL(26,6)
total_amt_usdollar
DECIMAL(26,6)
subtotal_amount
DECIMAL(26,6)
subtotal_amount_usdollar
DECIMAL(26,6)
discount_amount
DECIMAL(26,6)
discount_amount_usdollar
DECIMAL(26,6)
tax_amount
DECIMAL(26,6)
tax_amount_usdollar
DECIMAL(26,6)
shipping_amount
DECIMAL(26,6)
shipping_amount_usdollar
DECIMAL(26,6)
shipping_tax
VARCHAR(100)
shipping_tax_amt
DECIMAL(26,6)
shipping_tax_amt_usdollar
DECIMAL(26,6)
total_amount
DECIMAL(26,6)
total_amount_usdollar
DECIMAL(26,6)
KEY
PRIMARY
emailman
date_entered
DATETIME
date_modified
DATETIME
user_id
CHAR(36)
PK
id
INT(11)
NN
campaign_id
CHAR(36)
marketing_id
CHAR(36)
list_id
CHAR(36)
send_date_time
DATETIME
modified_user_id
CHAR(36)
in_queue
TINYINT(1)
in_queue_date
DATETIME
send_attempts
INT(11)
deleted
TINYINT(1)
related_id
CHAR(36)
related_type
VARCHAR(100)
related_confirm_opt_in
TINYINT(1)
KEY
PRIMARY
IX
idx_eman_list
IX
idx_eman_campaign_id
IX
idx_eman_relid_reltype_id
meetings_leads
PK
id
VARCHAR(36)
NN
meeting_id
VARCHAR(36)
lead_id
VARCHAR(36)
required
VARCHAR(1)
accept_status
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_lead_meeting_meeting
IX
idx_lead_meeting_lead
IX
idx_meeting_lead
schedulers
PK
id
VARCHAR(36)
NN
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
created_by
CHAR(36)
modified_user_id
CHAR(36)
name
VARCHAR(255)
job
VARCHAR(255)
date_time_start
DATETIME
date_time_end
DATETIME
job_interval
VARCHAR(100)
time_from
TIME
time_to
TIME
last_run
DATETIME
status
VARCHAR(100)
catch_up
TINYINT(1)
KEY
PRIMARY
IX
idx_schedule
cases_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_cases_parent_id
reminders
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
popup
TINYINT(1)
email
TINYINT(1)
email_sent
TINYINT(1)
timer_popup
VARCHAR(32)
timer_email
VARCHAR(32)
related_event_module
VARCHAR(32)
related_event_module_id
CHAR(36)
NN
date_willexecute
INT(60)
popup_viewed
TINYINT(1)
KEY
PRIMARY
IX
idx_reminder_name
IX
idx_reminder_deleted
IX
idx_reminder_related_event_module
IX
idx_reminder_related_event_module_id
aok_knowledgebase_categories
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
aok_knowledgebase_id
VARCHAR(36)
aok_knowledge_base_categories_id
VARCHAR(36)
KEY
PRIMARY
IX
aok_knowledgebase_categories_alt
securitygroups_default
PK
id
CHAR(36)
NN
securitygroup_id
CHAR(36)
module
VARCHAR(50)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
contacts_users
PK
id
VARCHAR(36)
NN
contact_id
VARCHAR(36)
user_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_con_users_con
IX
idx_con_users_user
IX
idx_contacts_users
email_addresses_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_email_addresses_parent_id
jjwg_maps_jjwg_areas_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
jjwg_maps_5304wg_maps_ida
VARCHAR(36)
jjwg_maps_41f2g_areas_idb
VARCHAR(36)
KEY
PRIMARY
IX
jjwg_maps_jjwg_areas_alt
am_tasktemplates
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
status
VARCHAR(100)
priority
VARCHAR(100)
percent_complete
INT(255)
predecessors
INT(255)
milestone_flag
TINYINT(1)
relationship_type
VARCHAR(100)
task_number
INT(255)
order_number
INT(255)
estimated_effort
INT(255)
utilization
VARCHAR(100)
duration
INT(255)
KEY
PRIMARY
jjwg_address_cache
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
lat
FLOAT(10,8)
lng
FLOAT(11,8)
KEY
PRIMARY
accounts
PK
id
CHAR(36)
NN
name
VARCHAR(150)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
account_type
VARCHAR(50)
industry
VARCHAR(50)
annual_revenue
VARCHAR(100)
phone_fax
VARCHAR(100)
billing_address_street
VARCHAR(150)
billing_address_city
VARCHAR(100)
billing_address_state
VARCHAR(100)
billing_address_postalcode
VARCHAR(20)
billing_address_country
VARCHAR(255)
rating
VARCHAR(100)
phone_office
VARCHAR(100)
phone_alternate
VARCHAR(100)
website
VARCHAR(255)
ownership
VARCHAR(100)
employees
VARCHAR(10)
ticker_symbol
VARCHAR(10)
shipping_address_street
VARCHAR(150)
shipping_address_city
VARCHAR(100)
shipping_address_state
VARCHAR(100)
shipping_address_postalcode
VARCHAR(20)
shipping_address_country
VARCHAR(255)
parent_id
CHAR(36)
sic_code
VARCHAR(10)
campaign_id
CHAR(36)
KEY
PRIMARY
IX
idx_accnt_id_del
IX
idx_accnt_name_del
IX
idx_accnt_assigned_del
IX
idx_accnt_parent_id
email_addr_bean_rel
PK
id
CHAR(36)
NN
email_address_id
CHAR(36)
NN
bean_id
CHAR(36)
NN
bean_module
VARCHAR(100)
primary_address
TINYINT(1)
reply_to_address
TINYINT(1)
date_created
DATETIME
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_email_address_id
IX
idx_bean_id
notes
assigned_user_id
CHAR(36)
PK
id
CHAR(36)
NN
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(255)
file_mime_type
VARCHAR(100)
filename
VARCHAR(255)
parent_type
VARCHAR(255)
parent_id
CHAR(36)
contact_id
CHAR(36)
portal_flag
TINYINT(1)
embed_flag
TINYINT(1)
description
TEXT
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_note_name
IX
idx_notes_parent
IX
idx_note_contact
IX
idx_notes_assigned_del
jjwg_address_cache_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_jjwg_address_cache_parent_id
fp_event_locations
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
address
VARCHAR(255)
address_city
VARCHAR(100)
address_country
VARCHAR(100)
address_postalcode
VARCHAR(20)
address_state
VARCHAR(100)
capacity
VARCHAR(255)
KEY
PRIMARY
aok_knowledgebase_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aok_knowledgebase_parent_id
sugarfeed
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
related_module
VARCHAR(100)
related_id
CHAR(36)
link_url
VARCHAR(255)
link_type
VARCHAR(30)
KEY
PRIMARY
IX
sgrfeed_date
emails
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
orphaned
TINYINT(1)
last_synced
DATETIME
date_sent_received
DATETIME
message_id
VARCHAR(255)
type
VARCHAR(100)
status
VARCHAR(100)
flagged
TINYINT(1)
reply_to_status
TINYINT(1)
intent
VARCHAR(100)
mailbox_id
CHAR(36)
parent_type
VARCHAR(100)
parent_id
CHAR(36)
uid
VARCHAR(255)
category_id
VARCHAR(100)
KEY
PRIMARY
IX
idx_email_name
IX
idx_message_id
IX
idx_email_parent_id
IX
idx_email_assigned
IX
idx_email_cat
projects_contacts
PK
id
VARCHAR(36)
NN
contact_id
VARCHAR(36)
project_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_proj_con_proj
IX
idx_proj_con_con
IX
projects_contacts_alt
calls_leads
PK
id
VARCHAR(36)
NN
call_id
VARCHAR(36)
lead_id
VARCHAR(36)
required
VARCHAR(1)
accept_status
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_lead_call_call
IX
idx_lead_call_lead
IX
idx_call_lead
upgrade_history
PK
id
CHAR(36)
NN
filename
VARCHAR(255)
AK
md5sum
VARCHAR(32)
type
VARCHAR(30)
status
VARCHAR(50)
version
VARCHAR(64)
name
VARCHAR(255)
description
TEXT
id_name
VARCHAR(255)
manifest
LONGTEXT
date_entered
DATETIME
enabled
TINYINT(1)
KEY
PRIMARY
KEY
upgrade_history_md5_uk
aos_quotes_project_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
aos_quotes1112_quotes_ida
VARCHAR(36)
aos_quotes7207project_idb
VARCHAR(36)
KEY
PRIMARY
IX
aos_quotes_project_alt
alerts
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
is_read
TINYINT(1)
target_module
VARCHAR(255)
type
VARCHAR(255)
url_redirect
VARCHAR(255)
reminder_id
CHAR(36)
KEY
PRIMARY
emails_beans
PK
id
CHAR(36)
NN
email_id
CHAR(36)
bean_id
CHAR(36)
bean_module
VARCHAR(100)
campaign_data
TEXT
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_emails_beans_bean_id
IX
idx_emails_beans_email_bean
aow_actions
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
aow_workflow_id
CHAR(36)
action_order
INT(255)
action
VARCHAR(100)
parameters
LONGTEXT
KEY
PRIMARY
IX
aow_action_index_workflow_id
jjwg_maps_jjwg_markers_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
jjwg_maps_b229wg_maps_ida
VARCHAR(36)
jjwg_maps_2e31markers_idb
VARCHAR(36)
KEY
PRIMARY
IX
jjwg_maps_jjwg_markers_alt
aow_workflow
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
flow_module
VARCHAR(100)
flow_run_on
VARCHAR(100)
status
VARCHAR(100)
run_when
VARCHAR(100)
multiple_runs
TINYINT(1)
KEY
PRIMARY
IX
aow_workflow_index_status
aos_quotes_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_quotes_parent_id
fp_events_prospects_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
fp_events_prospects_1fp_events_ida
VARCHAR(36)
fp_events_prospects_1prospects_idb
VARCHAR(36)
invite_status
VARCHAR(25)
accept_status
VARCHAR(25)
email_responded
INT(2)
KEY
PRIMARY
IX
fp_events_prospects_1_alt
fp_events_leads_1_c
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
fp_events_leads_1fp_events_ida
VARCHAR(36)
fp_events_leads_1leads_idb
VARCHAR(36)
invite_status
VARCHAR(25)
accept_status
VARCHAR(25)
email_responded
INT(2)
KEY
PRIMARY
IX
fp_events_leads_1_alt
jjwg_areas_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_jjwg_areas_parent_id
projects_products
PK
id
VARCHAR(36)
NN
product_id
VARCHAR(36)
project_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_proj_prod_project
IX
idx_proj_prod_product
IX
projects_products_alt
oauth_tokens
PK
id
CHAR(36)
NN
secret
VARCHAR(32)
tstate
VARCHAR(1)
consumer
CHAR(36)
NN
token_ts
BIGINT(20)
verify
VARCHAR(32)
PK
deleted
TINYINT(1)
NN
callback_url
VARCHAR(255)
assigned_user_id
CHAR(36)
KEY
PRIMARY
IX
oauth_state_ts
IX
constoken_key
relationships
PK
id
CHAR(36)
NN
relationship_name
VARCHAR(150)
lhs_module
VARCHAR(100)
lhs_table
VARCHAR(64)
lhs_key
VARCHAR(64)
rhs_module
VARCHAR(100)
rhs_table
VARCHAR(64)
rhs_key
VARCHAR(64)
join_table
VARCHAR(64)
join_key_lhs
VARCHAR(64)
join_key_rhs
VARCHAR(64)
relationship_type
VARCHAR(64)
relationship_role_column
VARCHAR(64)
relationship_role_column_value
VARCHAR(50)
reverse
TINYINT(1)
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_rel_name
documents_cases
PK
id
VARCHAR(36)
NN
date_modified
DATETIME
deleted
TINYINT(1)
document_id
VARCHAR(36)
case_id
VARCHAR(36)
KEY
PRIMARY
IX
documents_cases_case_id
IX
documents_cases_document_id
emails_text
PK
email_id
CHAR(36)
NN
from_addr
VARCHAR(250)
reply_to_addr
VARCHAR(250)
to_addrs
TEXT
cc_addrs
TEXT
bcc_addrs
TEXT
description
LONGTEXT
description_html
LONGTEXT
raw_source
LONGTEXT
deleted
TINYINT(1)
KEY
PRIMARY
IX
emails_textfromaddr
inbound_email
PK
id
VARCHAR(36)
NN
deleted
TINYINT(1)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
name
VARCHAR(255)
status
VARCHAR(100)
server_url
VARCHAR(100)
email_user
VARCHAR(100)
email_password
VARCHAR(100)
port
INT(5)
service
VARCHAR(50)
mailbox
TEXT
delete_seen
TINYINT(1)
mailbox_type
VARCHAR(10)
template_id
CHAR(36)
stored_options
TEXT
group_id
CHAR(36)
is_personal
TINYINT(1)
groupfolder_id
CHAR(36)
KEY
PRIMARY
meetings_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
jjwg_markers_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_jjwg_markers_parent_id
aor_fields
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
aor_report_id
CHAR(36)
field_order
INT(255)
module_path
LONGTEXT
field
VARCHAR(100)
display
TINYINT(1)
link
TINYINT(1)
label
VARCHAR(255)
field_function
VARCHAR(100)
sort_by
VARCHAR(100)
format
VARCHAR(100)
total
VARCHAR(100)
sort_order
VARCHAR(100)
group_by
TINYINT(1)
group_order
VARCHAR(100)
group_display
INT(11)
KEY
PRIMARY
IX
aor_fields_index_report_id
aos_pdf_templates_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_aos_pdf_templates_parent_id
aow_conditions
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
aow_workflow_id
CHAR(36)
condition_order
INT(255)
module_path
LONGTEXT
field
VARCHAR(100)
operator
VARCHAR(100)
value_type
VARCHAR(255)
value
VARCHAR(255)
KEY
PRIMARY
IX
aow_conditions_index_workflow_id
aobh_businesshours
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
opening_hours
VARCHAR(100)
closing_hours
VARCHAR(100)
open_status
TINYINT(1)
day
VARCHAR(100)
KEY
PRIMARY
meetings_contacts
PK
id
VARCHAR(36)
NN
meeting_id
VARCHAR(36)
contact_id
VARCHAR(36)
required
VARCHAR(1)
accept_status
VARCHAR(25)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_con_mtg_mtg
IX
idx_con_mtg_con
IX
idx_meeting_contact
campaign_trkrs
PK
id
CHAR(36)
NN
tracker_name
VARCHAR(255)
tracker_url
VARCHAR(255)
tracker_key
INT(11)
NN
campaign_id
CHAR(36)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
is_optout
TINYINT(1)
deleted
TINYINT(1)
KEY
PRIMARY
IX
campaign_tracker_key_idx
contacts_cstm
PK
id_c
CHAR(36)
NN
jjwg_maps_lng_c
FLOAT(11,8)
jjwg_maps_lat_c
FLOAT(10,8)
jjwg_maps_geocode_status_c
VARCHAR(255)
jjwg_maps_address_c
VARCHAR(255)
KEY
PRIMARY
contacts_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_contacts_parent_id
cases_bugs
PK
id
VARCHAR(36)
NN
case_id
VARCHAR(36)
bug_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_cas_bug_cas
IX
idx_cas_bug_bug
IX
idx_case_bug
surveyquestionresponses_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_surveyquestionresponses_parent_id
fields_meta_data
PK
id
VARCHAR(255)
NN
name
VARCHAR(255)
vname
VARCHAR(255)
comments
VARCHAR(255)
help
VARCHAR(255)
custom_module
VARCHAR(255)
type
VARCHAR(255)
len
INT(11)
required
TINYINT(1)
default_value
VARCHAR(255)
date_modified
DATETIME
deleted
TINYINT(1)
audited
TINYINT(1)
massupdate
TINYINT(1)
duplicate_merge
SMALLINT(6)
reportable
TINYINT(1)
importable
VARCHAR(255)
ext1
VARCHAR(255)
ext2
VARCHAR(255)
ext3
VARCHAR(255)
ext4
TEXT
KEY
PRIMARY
IX
idx_meta_id_del
IX
idx_meta_cm_del
calls_reschedule
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
reason
VARCHAR(100)
call_id
CHAR(36)
KEY
PRIMARY
aop_case_updates
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
case_id
CHAR(36)
contact_id
CHAR(36)
internal
TINYINT(1)
KEY
PRIMARY
aos_invoices
PK
id
CHAR(36)
NN
name
VARCHAR(255)
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
description
TEXT
deleted
TINYINT(1)
assigned_user_id
CHAR(36)
billing_account_id
CHAR(36)
billing_contact_id
CHAR(36)
billing_address_street
VARCHAR(150)
billing_address_city
VARCHAR(100)
billing_address_state
VARCHAR(100)
billing_address_postalcode
VARCHAR(20)
billing_address_country
VARCHAR(255)
shipping_address_street
VARCHAR(150)
shipping_address_city
VARCHAR(100)
shipping_address_state
VARCHAR(100)
shipping_address_postalcode
VARCHAR(20)
shipping_address_country
VARCHAR(255)
number
INT(11)
NN
total_amt
DECIMAL(26,6)
total_amt_usdollar
DECIMAL(26,6)
subtotal_amount
DECIMAL(26,6)
subtotal_amount_usdollar
DECIMAL(26,6)
discount_amount
DECIMAL(26,6)
discount_amount_usdollar
DECIMAL(26,6)
tax_amount
DECIMAL(26,6)
tax_amount_usdollar
DECIMAL(26,6)
shipping_amount
DECIMAL(26,6)
shipping_amount_usdollar
DECIMAL(26,6)
shipping_tax
VARCHAR(100)
shipping_tax_amt
DECIMAL(26,6)
shipping_tax_amt_usdollar
DECIMAL(26,6)
total_amount
DECIMAL(26,6)
total_amount_usdollar
DECIMAL(26,6)
currency_id
CHAR(36)
quote_number
INT(11)
quote_date
DATE
invoice_date
DATE
due_date
DATE
status
VARCHAR(100)
template_ddown_c
TEXT
subtotal_tax_amount
DECIMAL(26,6)
subtotal_tax_amount_usdollar
DECIMAL(26,6)
KEY
PRIMARY
projects_opportunities
PK
id
VARCHAR(36)
NN
opportunity_id
VARCHAR(36)
project_id
VARCHAR(36)
date_modified
DATETIME
deleted
TINYINT(1)
KEY
PRIMARY
IX
idx_proj_opp_proj
IX
idx_proj_opp_opp
IX
projects_opportunities_alt
surveyquestions_audit
PK
id
CHAR(36)
NN
parent_id
CHAR(36)
NN
date_created
DATETIME
created_by
VARCHAR(36)
field_name
VARCHAR(100)
data_type
VARCHAR(100)
before_value_string
VARCHAR(255)
after_value_string
VARCHAR(255)
before_value_text
TEXT
after_value_text
TEXT
KEY
PRIMARY
IX
idx_surveyquestions_parent_id
users
PK
id
CHAR(36)
NN
user_name
VARCHAR(60)
user_hash
VARCHAR(255)
system_generated_password
TINYINT(1)
pwd_last_changed
DATETIME
authenticate_id
VARCHAR(100)
sugar_login
TINYINT(1)
first_name
VARCHAR(255)
last_name
VARCHAR(255)
is_admin
TINYINT(1)
external_auth_only
TINYINT(1)
receive_notifications
TINYINT(1)
description
TEXT
date_entered
DATETIME
date_modified
DATETIME
modified_user_id
CHAR(36)
created_by
CHAR(36)
title
VARCHAR(50)
photo
VARCHAR(255)
department
VARCHAR(50)
phone_home
VARCHAR(50)
phone_mobile
VARCHAR(50)
phone_work
VARCHAR(50)
phone_other
VARCHAR(50)
phone_fax
VARCHAR(50)
status
VARCHAR(100)
address_street
VARCHAR(150)
address_city
VARCHAR(100)
address_state
VARCHAR(100)
address_country
VARCHAR(100)
address_postalcode
VARCHAR(20)
deleted
TINYINT(1)
portal_only
TINYINT(1)
show_on_employees
TINYINT(1)
employee_status
VARCHAR(100)
messenger_id
VARCHAR(100)
messenger_type
VARCHAR(100)
reports_to_id
CHAR(36)
is_group
TINYINT(1)
factor_auth
TINYINT(1)
factor_auth_interface
VARCHAR(255)
KEY
PRIMARY
IX
idx_user_name