name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 150 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_accnt_id_del | index | id,deleted |
idx_accnt_name_del | index | name,deleted |
idx_accnt_assigned_del | index | deleted,assigned_user_id |
idx_accnt_parent_id | index | parent_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_accounts_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
account_id | varchar | 36 |
bug_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_acc_bug_acc | index | account_id |
idx_acc_bug_bug | index | bug_id |
idx_account_bug | index | account_id,bug_id |
name | type | len |
---|---|---|
id | varchar | 36 |
account_id | varchar | 36 |
case_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_acc_case_acc | index | account_id |
idx_acc_acc_case | index | case_id |
name | type | len |
---|---|---|
id | varchar | 36 |
contact_id | varchar | 36 |
account_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_account_contact | index | account_id,contact_id |
idx_contid_del_accid | index | contact_id,deleted,account_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len |
---|---|---|
id | varchar | 36 |
opportunity_id | varchar | 36 |
account_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_account_opportunity | index | account_id,opportunity_id |
idx_oppid_del_accid | index | opportunity_id,deleted,account_id |
name | type | len |
---|---|---|
id | char | 36 |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aclaction_id_del | index | id,deleted |
idx_category_name | index | category,name |
name | type | len |
---|---|---|
id | char | 36 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
name | varchar | 150 |
description | text | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aclrole_id_del | index | id,deleted |
name | type | len |
---|---|---|
id | varchar | 36 |
role_id | varchar | 36 |
action_id | varchar | 36 |
access_override | int | 3 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_acl_role_id | index | role_id |
idx_acl_action_id | index | action_id |
idx_aclrole_action | index | role_id,action_id |
name | type | len |
---|---|---|
id | varchar | 36 |
role_id | varchar | 36 |
user_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aclrole_id | index | role_id |
idx_acluser_id | index | user_id |
idx_aclrole_user | index | role_id,user_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
aldibo | varchar | 255 |
account | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
adb01_aldibo_accounts_1adb01_aldibo_ida | varchar | 36 |
adb01_aldibo_accounts_1accounts_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
adb01_aldibo_accounts_1_ida1 | index | adb01_aldibo_accounts_1adb01_aldibo_ida |
adb01_aldibo_accounts_1_idb2 | index | adb01_aldibo_accounts_1accounts_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
adb01_aldibo_accountsadb01_aldibo_ida | varchar | 36 |
adb01_aldibo_accountsaccounts_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
adb01_aldibo_accounts_ida1 | index | adb01_aldibo_accountsadb01_aldibo_ida |
adb01_aldibo_accounts_idb2 | index | adb01_aldibo_accountsaccounts_idb |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_adb01_aldibo_parent_id | index | parent_id |
name | type | len |
---|---|---|
id_c | char | 36 |
accoount_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len | required |
---|---|---|---|
assigned_user_id | char | 36 | true |
bean | varchar | 50 | |
bean_id | char | 36 | true |
name | type | fields |
---|---|---|
ab_user_bean_idx | index | assigned_user_id,bean |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
is_read | tinyint | |
target_module | varchar | 255 |
type | varchar | 255 |
url_redirect | varchar | 255 |
reminder_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
status | varchar | 100 | Draft |
priority | varchar | 100 | High |
override_business_hours | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_am_projecttemplates_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
am_projecttemplates_ida | varchar | 36 |
contacts_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
am_projecttemplates_contacts_1_alt | index | am_projecttemplates_ida,contacts_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
am_projecttemplates_project_1am_projecttemplates_ida | varchar | 36 |
am_projecttemplates_project_1project_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
am_projecttemplates_project_1_ida1 | index | am_projecttemplates_project_1am_projecttemplates_ida |
am_projecttemplates_project_1_alt | index | am_projecttemplates_project_1project_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
am_projecttemplates_ida | varchar | 36 |
users_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
am_projecttemplates_users_1_alt | index | am_projecttemplates_ida,users_idb |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
status | varchar | 100 | Not Started |
priority | varchar | 100 | High |
percent_complete | int | 255 | |
predecessors | int | 255 | |
milestone_flag | tinyint | ||
relationship_type | varchar | 100 | FS |
task_number | int | 255 | |
order_number | int | 255 | |
estimated_effort | int | 255 | |
utilization | varchar | 100 | |
duration | int | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
am_tasktemplates_am_projecttemplatesam_projecttemplates_ida | varchar | 36 |
am_tasktemplates_am_projecttemplatesam_tasktemplates_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
am_tasktemplates_am_projecttemplates_ida1 | index | am_tasktemplates_am_projecttemplatesam_projecttemplates_ida |
am_tasktemplates_am_projecttemplates_alt | index | am_tasktemplates_am_projecttemplatesam_tasktemplates_idb |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_am_tasktemplates_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
opening_hours | varchar | 100 | 1 |
closing_hours | varchar | 100 | 1 |
open_status | tinyint | ||
day | varchar | 100 | monday |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
last_optimised | datetime | |
location | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aod_index_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
error | varchar | 255 |
success | tinyint | |
record_id | char | 36 |
record_module | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_record_module | index | record_module |
idx_record_id | index | record_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aod_indexevent_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aok_knowledge_base_categories_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
status | varchar | 100 | Draft |
revision | varchar | 255 | |
additional_info | text | ||
user_id_c | char | 36 | |
user_id1_c | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aok_knowledgebase_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
aok_knowledgebase_id | varchar | 36 |
aok_knowledge_base_categories_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
aok_knowledgebase_categories_alt | index | aok_knowledgebase_id,aok_knowledge_base_categories_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
case_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aop_case_events_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
case_id | char | 36 |
contact_id | char | 36 |
internal | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aop_case_updates_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
aor_report_id | char | 36 |
type | varchar | 100 |
x_field | int | 11 |
y_field | int | 11 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
aor_conditions_index_report_id | index | aor_report_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
aor_report_id | char | 36 |
field_order | int | 255 |
module_path | longtext | |
field | varchar | 100 |
display | tinyint | |
link | tinyint | |
label | varchar | 255 |
field_function | varchar | 100 |
sort_by | varchar | 100 |
format | varchar | 100 |
total | varchar | 100 |
sort_order | varchar | 100 |
group_by | tinyint | |
group_order | varchar | 100 |
group_display | int | 11 |
name | type | fields |
---|---|---|
primary | primary | id |
aor_fields_index_report_id | index | aor_report_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
report_module | varchar | 100 | |
graphs_per_row | int | 11 | 2 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aor_reports_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
schedule | varchar | 100 |
last_run | datetime | |
status | varchar | 100 |
email_recipients | longtext | |
aor_report_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | Not Started |
customer_signed_date | date | ||
company_signed_date | date | ||
renewal_reminder_date | datetime | ||
contract_type | varchar | 100 | Type |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_contracts_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
aos_contracts_id | varchar | 36 |
documents_id | varchar | 36 |
document_revision_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
aos_contracts_documents_alt | index | aos_contracts_id,documents_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_invoices_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_line_item_groups_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | longtext | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
active | tinyint | 1 | |
type | varchar | 100 | |
pdfheader | text | ||
pdffooter | text | ||
margin_left | int | 255 | 15 |
margin_right | int | 255 | 15 |
margin_top | int | 255 | 16 |
margin_bottom | int | 255 | 16 |
margin_header | int | 255 | 9 |
margin_footer | int | 255 | 9 |
page_size | varchar | 100 | |
orientation | varchar | 100 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_pdf_templates_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
is_parent | tinyint | |
parent_category_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_product_categories_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
maincode | varchar | 100 | XXXX |
part_number | varchar | 25 | |
category | varchar | 100 | |
type | varchar | 100 | Good |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_products_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | text | ||
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | Percentage |
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 | 5.0 |
parent_type | varchar | 100 | |
parent_id | char | 36 | |
product_id | char | 36 | |
group_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aospq_par_del | index | parent_id,parent_type,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_products_quotes_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | Draft |
term | varchar | 100 | |
terms_c | text | ||
approval_status | varchar | 100 | |
invoice_status | varchar | 100 | Not Invoiced |
subtotal_tax_amount | decimal | 26,6 | |
subtotal_tax_amount_usdollar | decimal | 26,6 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
aos_quotes77d9_quotes_ida | varchar | 36 |
aos_quotes6b83nvoices_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
aos_quotes_aos_invoices_alt | index | aos_quotes77d9_quotes_ida,aos_quotes6b83nvoices_idb |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aos_quotes_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
aos_quotese81e_quotes_ida | varchar | 36 |
aos_quotes4dc0ntracts_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
aos_quotes_aos_contracts_alt | index | aos_quotese81e_quotes_ida,aos_quotes4dc0ntracts_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
aos_quotes1112_quotes_ida | varchar | 36 |
aos_quotes7207project_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
aos_quotes_project_alt | index | aos_quotes1112_quotes_ida,aos_quotes7207project_idb |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
aow_workflow_id | char | 36 |
action_order | int | 255 |
action | varchar | 100 |
parameters | longtext |
name | type | fields |
---|---|---|
primary | primary | id |
aow_action_index_workflow_id | index | aow_workflow_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
aow_conditions_index_workflow_id | index | aow_workflow_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
aow_workflow_id | char | 36 | |
parent_id | char | 36 | |
parent_type | varchar | 100 | |
status | varchar | 100 | Pending |
name | type | fields |
---|---|---|
primary | primary | id |
aow_processed_index_workflow | index | aow_workflow_id,status,parent_id,deleted |
aow_processed_index_status | index | status |
aow_processed_index_workflow_id | index | aow_workflow_id |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
aow_processed_id | varchar | 36 | |
aow_action_id | varchar | 36 | |
status | varchar | 36 | Pending |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aow_processed_aow_actions | index | aow_processed_id,aow_action_id |
idx_actid_del_freid | index | aow_action_id,deleted,aow_processed_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
flow_module | varchar | 100 | |
flow_run_on | varchar | 100 | |
status | varchar | 100 | Active |
run_when | varchar | 100 | Always |
multiple_runs | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
aow_workflow_index_status | index | status |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_aow_workflow_parent_id | index | parent_id |
name | type | len | auto_increment | required |
---|---|---|---|---|
id | char | 36 | ||
name | varchar | 255 | ||
date_entered | datetime | |||
date_modified | datetime | |||
modified_user_id | char | 36 | ||
created_by | char | 36 | ||
description | text | |||
deleted | tinyint | |||
assigned_user_id | char | 36 | ||
bug_number | int | 11 | 1 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
bugsnumk | unique | bug_number |
bug_number | index | bug_number |
idx_bug_name | index | name |
idx_bugs_assigned_user | index | assigned_user_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_bugs_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 50 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | Planned |
direction | varchar | 100 | |
parent_id | char | 36 | |
reminder_time | int | 11 | -1 |
email_reminder_time | int | 11 | -1 |
email_reminder_sent | tinyint | ||
outlook_id | varchar | 255 | |
repeat_type | varchar | 36 | |
repeat_interval | int | 3 | 1 |
repeat_dow | varchar | 7 | |
repeat_until | date | ||
repeat_count | int | 7 | |
repeat_parent_id | char | 36 | |
recurring_source | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_call_name | index | name |
idx_status | index | status |
idx_calls_date_start | index | date_start |
idx_calls_par_del | index | parent_id,parent_type,deleted |
idx_calls_assigned_del | index | deleted,assigned_user_id |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
call_id | varchar | 36 | |
contact_id | varchar | 36 | |
required | varchar | 1 | 1 |
accept_status | varchar | 25 | none |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_con_call_call | index | call_id |
idx_con_call_con | index | contact_id |
idx_call_contact | index | call_id,contact_id |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
call_id | varchar | 36 | |
lead_id | varchar | 36 | |
required | varchar | 1 | 1 |
accept_status | varchar | 25 | none |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_lead_call_call | index | call_id |
idx_lead_call_lead | index | lead_id |
idx_call_lead | index | call_id,lead_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
reason | varchar | 100 |
call_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_calls_reschedule_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
call_id | varchar | 36 | |
user_id | varchar | 36 | |
required | varchar | 1 | 1 |
accept_status | varchar | 25 | none |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_usr_call_call | index | call_id |
idx_usr_call_usr | index | user_id |
idx_call_users | index | call_id,user_id |
name | type | len |
---|---|---|
id | char | 36 |
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 | |
hits | int | 11 |
list_id | char | 36 |
deleted | tinyint | |
date_modified | datetime | |
more_information | varchar | 100 |
marketing_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_camp_tracker | index | target_tracker_key |
idx_camp_campaign_id | index | campaign_id |
idx_camp_more_info | index | more_information |
idx_target_id | index | target_id |
idx_target_id_deleted | index | target_id,deleted |
name | type | len | default | required |
---|---|---|---|---|
id | char | 36 | ||
tracker_name | varchar | 255 | ||
tracker_url | varchar | 255 | http:// | |
tracker_key | int | 11 | 1 | true |
campaign_id | char | 36 | ||
date_entered | datetime | |||
date_modified | datetime | |||
modified_user_id | char | 36 | ||
created_by | char | 36 | ||
is_optout | tinyint | |||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
campaign_tracker_key_idx | index | tracker_key |
name | type | len | auto_increment | required |
---|---|---|---|---|
id | char | 36 | ||
name | varchar | 255 | ||
date_entered | datetime | |||
date_modified | datetime | |||
modified_user_id | char | 36 | ||
created_by | char | 36 | ||
deleted | tinyint | |||
assigned_user_id | char | 36 | ||
tracker_key | int | 11 | 1 | true |
tracker_count | int | 11 | ||
refer_url | varchar | 255 | http:// | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
camp_auto_tracker_key | index | tracker_key |
idx_campaign_name | index | name |
idx_survey_id | index | survey_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_campaigns_parent_id | index | parent_id |
name | type | len | auto_increment | required |
---|---|---|---|---|
id | char | 36 | ||
name | varchar | 255 | ||
date_entered | datetime | |||
date_modified | datetime | |||
modified_user_id | char | 36 | ||
created_by | char | 36 | ||
description | text | |||
deleted | tinyint | |||
assigned_user_id | char | 36 | ||
case_number | int | 11 | 1 | true |
type | varchar | 255 | ||
status | varchar | 100 | ||
priority | varchar | 100 | ||
resolution | text | |||
work_log | text | |||
account_id | char | 36 | ||
state | varchar | 100 | Open | |
contact_created_by_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
casesnumk | unique | case_number |
case_number | index | case_number |
idx_case_name | index | name |
idx_account_id | index | account_id |
idx_cases_stat_del | index | assigned_user_id,status,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_cases_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
case_id | varchar | 36 |
bug_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_cas_bug_cas | index | case_id |
idx_cas_bug_bug | index | bug_id |
idx_case_bug | index | case_id,bug_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len |
---|---|---|
category | varchar | 32 |
name | varchar | 32 |
value | text |
name | type | fields |
---|---|---|
idx_config_cat | index | category |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | ||
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 | ||
portal_user_type | varchar | 100 | Single |
name | type | fields |
---|---|---|
primary | primary | id |
idx_cont_last_first | index | last_name,first_name,deleted |
idx_contacts_del_last | index | deleted,last_name |
idx_cont_del_reports | index | deleted,reports_to_id,last_name |
idx_reports_to_id | index | reports_to_id |
idx_del_id_user | index | deleted,id,assigned_user_id |
idx_cont_assigned | index | assigned_user_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_contacts_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
contact_id | varchar | 36 |
bug_id | varchar | 36 |
contact_role | varchar | 50 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_con_bug_con | index | contact_id |
idx_con_bug_bug | index | bug_id |
idx_contact_bug | index | contact_id,bug_id |
name | type | len |
---|---|---|
id | varchar | 36 |
contact_id | varchar | 36 |
case_id | varchar | 36 |
contact_role | varchar | 50 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_con_case_con | index | contact_id |
idx_con_case_case | index | case_id |
idx_contacts_cases | index | contact_id,case_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len |
---|---|---|
id | varchar | 36 |
contact_id | varchar | 36 |
user_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_con_users_con | index | contact_id |
idx_con_users_user | index | user_id |
idx_contacts_users | index | contact_id,user_id |
name | type | len |
---|---|---|
id | varchar | 36 |
bean_id | varchar | 36 |
module | varchar | 25 |
date_modified | datetime |
name | type | fields |
---|---|---|
primary | primary | id |
idx_cron_remove_document_bean_id | index | bean_id |
idx_cron_remove_document_stamp | index | date_modified |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
name | varchar | 36 | |
symbol | varchar | 36 | |
iso4217 | varchar | 3 | |
conversion_rate | double | ||
status | varchar | 100 | |
deleted | tinyint | ||
date_entered | datetime | ||
date_modified | datetime | ||
created_by | char | 36 | true |
name | type | fields |
---|---|---|
primary | primary | id |
idx_currency_name | index | name,deleted |
name | type | len |
---|---|---|
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 |
name | type | fields |
---|---|---|
idx_beanid_set_num | index | bean_id,set_num |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
nb_cont | decimal | 18,0 |
aos_products_id_c | char | 36 |
nb_testing | decimal | 18,0 |
ventes | decimal | 18,0 |
tx_trans | decimal | 18,0 |
prix_hab | decimal | 18,2 |
prix_neg | decimal | 18,2 |
nb_bout | decimal | 18,0 |
kit_vis | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_d1_detail_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
d1_detail_h1_headerd1_detail_ida | varchar | 36 |
d1_detail_h1_headerh1_header_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
d1_detail_h1_header_ida1 | index | d1_detail_h1_headerd1_detail_ida |
d1_detail_h1_header_idb2 | index | d1_detail_h1_headerh1_header_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
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 | |
date_modified | datetime |
name | type | fields |
---|---|---|
primary | primary | id |
documentrevision_mimetype | index | file_mime_type |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
document_name | varchar | 255 | |
doc_id | varchar | 100 | |
doc_type | varchar | 100 | Sugar |
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 | ||
template_type | varchar | 100 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_doc_cat | index | category_id,subcategory_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
document_id | varchar | 36 |
account_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
documents_accounts_account_id | index | account_id,document_id |
documents_accounts_document_id | index | document_id,account_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
document_id | varchar | 36 |
bug_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
documents_bugs_bug_id | index | bug_id,document_id |
documents_bugs_document_id | index | document_id,bug_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
document_id | varchar | 36 |
case_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
documents_cases_case_id | index | case_id,document_id |
documents_cases_document_id | index | document_id,case_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
document_id | varchar | 36 |
contact_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
documents_contacts_contact_id | index | contact_id,document_id |
documents_contacts_document_id | index | document_id,contact_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
document_id | varchar | 36 |
opportunity_id | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_docu_opps_oppo_id | index | opportunity_id,document_id |
idx_docu_oppo_docu_id | index | document_id,opportunity_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
password | varchar | 255 | |
url | varchar | 255 | |
application | varchar | 100 | webex |
api_data | text | ||
consumer_key | varchar | 255 | |
consumer_secret | varchar | 255 | |
oauth_token | varchar | 255 | |
oauth_secret | varchar | 255 | |
validated | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_app_active | index | assigned_user_id,application,validated |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
email_address_id | char | 36 | true |
bean_id | char | 36 | true |
bean_module | varchar | 100 | |
primary_address | tinyint | ||
reply_to_address | tinyint | ||
date_created | datetime | ||
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_email_address_id | index | email_address_id |
idx_bean_id | index | bean_id,bean_module |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
email_address | varchar | 255 | |
email_address_caps | varchar | 255 | |
invalid_email | tinyint | ||
opt_out | tinyint | ||
confirm_opt_in | varchar | 255 | not-opt-in |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_ea_caps_opt_out_invalid | index | email_address_caps,opt_out,invalid_email |
idx_ea_opt_out_invalid | index | email_address,opt_out,invalid_email |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_email_addresses_parent_id | index | parent_id |
name | type | len |
---|---|---|
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 | |
flagged | tinyint | |
answered | tinyint | |
deleted | tinyint | |
seen | tinyint | |
draft | tinyint |
name | type | fields |
---|---|---|
idx_ie_id | index | ie_id |
idx_mail_date | index | ie_id,mbox,senddate |
idx_mail_from | index | ie_id,mbox,fromaddr |
idx_mail_subj | index | subject |
idx_mail_to | index | toaddr |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
deleted | tinyint | ||
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 | true |
status | varchar | 100 | |
campaign_id | char | 36 | |
outbound_email_id | char | 36 | |
all_prospect_lists | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_emmkt_name | index | name |
idx_emmkit_del | index | deleted |
name | type | len |
---|---|---|
id | varchar | 36 |
prospect_list_id | varchar | 36 |
email_marketing_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
email_mp_prospects | index | email_marketing_id,prospect_list_id |
name | type | len |
---|---|---|
id | char | 36 |
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 | |
assigned_user_id | char | 36 |
text_only | tinyint | |
type | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_email_template_name | index | name |
name | type | len | auto_increment |
---|---|---|---|
date_entered | datetime | ||
date_modified | datetime | ||
user_id | char | 36 | |
id | int | 11 | 1 |
campaign_id | char | 36 | |
marketing_id | char | 36 | |
list_id | char | 36 | |
send_date_time | datetime | ||
modified_user_id | char | 36 | |
in_queue | tinyint | ||
in_queue_date | datetime | ||
send_attempts | int | 11 | |
deleted | tinyint | ||
related_id | char | 36 | |
related_type | varchar | 100 | |
related_confirm_opt_in | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_eman_list | index | list_id,user_id,deleted |
idx_eman_campaign_id | index | campaign_id |
idx_eman_relid_reltype_id | index | related_id,related_type,campaign_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
deleted | tinyint | ||
assigned_user_id | char | 36 | |
orphaned | tinyint | ||
last_synced | datetime | ||
date_sent_received | datetime | ||
message_id | varchar | 255 | |
type | varchar | 100 | |
status | varchar | 100 | |
flagged | tinyint | ||
reply_to_status | tinyint | ||
intent | varchar | 100 | pick |
mailbox_id | char | 36 | |
parent_type | varchar | 100 | |
parent_id | char | 36 | |
uid | varchar | 255 | |
category_id | varchar | 100 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_email_name | index | name |
idx_message_id | index | message_id |
idx_email_parent_id | index | parent_id |
idx_email_assigned | index | assigned_user_id,type,status |
idx_email_cat | index | category_id |
name | type | len |
---|---|---|
id | char | 36 |
email_id | char | 36 |
bean_id | char | 36 |
bean_module | varchar | 100 |
campaign_data | text | |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_emails_beans_bean_id | index | bean_id |
idx_emails_beans_email_bean | index | email_id,bean_id,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
email_id | char | 36 | true |
address_type | varchar | 4 | |
email_address_id | char | 36 | true |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_eearl_email_id | index | email_id,address_type |
idx_eearl_address_id | index | email_address_id |
name | type | len |
---|---|---|
email_id | char | 36 |
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 |
name | type | fields |
---|---|---|
primary | primary | email_id |
emails_textfromaddr | index | from_addr |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
parent_id | char | 36 |
parent_type | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | varchar | 255 |
name | varchar | 255 |
vname | varchar | 255 |
comments | varchar | 255 |
help | varchar | 255 |
custom_module | varchar | 255 |
type | varchar | 255 |
len | int | 11 |
required | tinyint | |
default_value | varchar | 255 |
date_modified | datetime | |
deleted | tinyint | |
audited | tinyint | |
massupdate | tinyint | |
duplicate_merge | smallint | |
reportable | tinyint | 1 |
importable | varchar | 255 |
ext1 | varchar | 255 |
ext2 | varchar | 255 |
ext3 | varchar | 255 |
ext4 | text |
name | type | fields |
---|---|---|
primary | primary | id |
idx_meta_id_del | index | id,deleted |
idx_meta_cm_del | index | custom_module,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
folder_type | varchar | 25 | |
parent_folder | char | 36 | |
has_child | tinyint | ||
is_group | tinyint | ||
is_dynamic | tinyint | ||
dynamic_query | text | ||
assign_to_id | char | 36 | |
created_by | char | 36 | true |
modified_by | char | 36 | true |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_parent_folder | index | parent_folder |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
folder_id | char | 36 | true |
polymorphic_module | varchar | 25 | |
polymorphic_id | char | 36 | true |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_poly_module_poly_id | index | polymorphic_module,polymorphic_id |
idx_fr_id_deleted_poly | index | folder_id,deleted,polymorphic_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
folder_id | char | 36 | true |
assigned_user_id | char | 36 | true |
name | type | fields |
---|---|---|
primary | primary | id |
idx_folder_id_assigned_user_id | index | folder_id,assigned_user_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_fp_event_locations_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
fp_event_locations_fp_events_1fp_event_locations_ida | varchar | 36 |
fp_event_locations_fp_events_1fp_events_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
fp_event_locations_fp_events_1_ida1 | index | fp_event_locations_fp_events_1fp_event_locations_ida |
fp_event_locations_fp_events_1_alt | index | fp_event_locations_fp_events_1fp_events_idb |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_fp_events_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
date_modified | datetime | ||
deleted | tinyint | ||
fp_events_contactsfp_events_ida | varchar | 36 | |
fp_events_contactscontacts_idb | varchar | 36 | |
invite_status | varchar | 25 | Not Invited |
accept_status | varchar | 25 | No Response |
email_responded | int | 2 |
name | type | fields |
---|---|---|
primary | primary | id |
fp_events_contacts_alt | index | fp_events_contactsfp_events_ida,fp_events_contactscontacts_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
fp_events_fp_event_delegates_1fp_events_ida | varchar | 36 |
fp_events_fp_event_delegates_1fp_event_delegates_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
fp_events_fp_event_delegates_1_ida1 | index | fp_events_fp_event_delegates_1fp_events_ida |
fp_events_fp_event_delegates_1_alt | index | fp_events_fp_event_delegates_1fp_event_delegates_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
fp_events_fp_event_locations_1fp_events_ida | varchar | 36 |
fp_events_fp_event_locations_1fp_event_locations_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
fp_events_fp_event_locations_1_alt | index | fp_events_fp_event_locations_1fp_events_ida,fp_events_fp_event_locations_1fp_event_locations_idb |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
date_modified | datetime | ||
deleted | tinyint | ||
fp_events_leads_1fp_events_ida | varchar | 36 | |
fp_events_leads_1leads_idb | varchar | 36 | |
invite_status | varchar | 25 | Not Invited |
accept_status | varchar | 25 | No Response |
email_responded | int | 2 |
name | type | fields |
---|---|---|
primary | primary | id |
fp_events_leads_1_alt | index | fp_events_leads_1fp_events_ida,fp_events_leads_1leads_idb |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
date_modified | datetime | ||
deleted | tinyint | ||
fp_events_prospects_1fp_events_ida | varchar | 36 | |
fp_events_prospects_1prospects_idb | varchar | 36 | |
invite_status | varchar | 25 | Not Invited |
accept_status | varchar | 25 | No Response |
email_responded | int | 2 |
name | type | fields |
---|---|---|
primary | primary | id |
fp_events_prospects_1_alt | index | fp_events_prospects_1fp_events_ida,fp_events_prospects_1prospects_idb |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
account_id_c | char | 36 |
type_action | varchar | 100 |
h_deb | datetime | |
h_fin | datetime | |
cap_etab | decimal | 18,0 |
nb_pers | decimal | 18,0 |
tx_remp | decimal | 18,0 |
pct_hf | decimal | 18,0 |
moy_age | decimal | 18,0 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
h1_header_am_projecttemplatesh1_header_ida | varchar | 36 |
h1_header_am_projecttemplatesam_projecttemplates_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
h1_header_am_projecttemplates_alt | index | h1_header_am_projecttemplatesh1_header_ida,h1_header_am_projecttemplatesam_projecttemplates_idb |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_h1_header_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
h1_header_d1_detailh1_header_ida | varchar | 36 |
h1_header_d1_detaild1_detail_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
h1_header_d1_detail_alt | index | h1_header_d1_detailh1_header_ida,h1_header_d1_detaild1_detail_idb |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
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 | ||
date_entered | datetime | ||
date_modified | datetime | ||
assigned_user_id | char | 36 | |
is_published | varchar | 3 | no |
name | type | fields |
---|---|---|
primary | primary | id |
idx_owner_module_name | index | assigned_user_id,module,name,deleted |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
deleted | tinyint | ||
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
name | varchar | 255 | |
status | varchar | 100 | Active |
server_url | varchar | 100 | |
email_user | varchar | 100 | |
email_password | varchar | 100 | |
port | int | 5 | |
service | varchar | 50 | |
mailbox | text | ||
delete_seen | tinyint | ||
mailbox_type | varchar | 10 | |
template_id | char | 36 | |
stored_options | text | ||
group_id | char | 36 | |
is_personal | tinyint | ||
groupfolder_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
deleted | tinyint | ||
date_entered | datetime | ||
date_modified | datetime | ||
autoreplied_to | varchar | 100 | |
ie_id | char | 36 | true |
name | type | fields |
---|---|---|
primary | primary | id |
idx_ie_autoreplied_to | index | autoreplied_to |
name | type | len |
---|---|---|
id | varchar | 255 |
ie_timestamp | int | 10 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
lat | float | 10,8 |
lng | float | 11,8 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_jjwg_address_cache_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
city | varchar | 255 |
state | varchar | 255 |
country | varchar | 255 |
coordinates | text |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_jjwg_areas_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
distance | float | 9,4 | |
unit_type | varchar | 100 | mi |
module_type | varchar | 100 | Accounts |
parent_type | varchar | 255 | |
parent_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_jjwg_maps_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
jjwg_maps_5304wg_maps_ida | varchar | 36 |
jjwg_maps_41f2g_areas_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
jjwg_maps_jjwg_areas_alt | index | jjwg_maps_5304wg_maps_ida,jjwg_maps_41f2g_areas_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
jjwg_maps_b229wg_maps_ida | varchar | 36 |
jjwg_maps_2e31markers_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
jjwg_maps_jjwg_markers_alt | index | jjwg_maps_b229wg_maps_ida,jjwg_maps_2e31markers_idb |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
city | varchar | 255 | |
state | varchar | 255 | |
country | varchar | 255 | |
jjwg_maps_lat | float | 10,8 | 0.00000000 |
jjwg_maps_lng | float | 11,8 | 0.00000000 |
marker_image | varchar | 100 | company |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_jjwg_markers_parent_id | index | parent_id |
name | type | len |
---|---|---|
assigned_user_id | char | 36 |
id | char | 36 |
name | varchar | 255 |
deleted | tinyint | |
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 | |
retry_count | tinyint | |
failure_count | tinyint | |
job_delay | int | 11 |
client | varchar | 255 |
percent_complete | int | 11 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_status_scheduler | index | status,scheduler_id |
idx_status_time | index | status,execute_time,date_entered |
idx_status_entered | index | status,date_entered |
idx_status_modified | index | status,date_modified |
name | type | len |
---|---|---|
id | char | 36 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 | |
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 | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_lead_acct_name_first | index | account_name,deleted |
idx_lead_last_first | index | last_name,first_name,deleted |
idx_lead_del_stat | index | last_name,status,deleted,first_name |
idx_lead_opp_del | index | opportunity_id,deleted |
idx_leads_acct_del | index | account_id,deleted |
idx_del_user | index | deleted,assigned_user_id |
idx_lead_assigned | index | assigned_user_id |
idx_lead_contact | index | contact_id |
idx_reports_to | index | reports_to_id |
idx_lead_phone_work | index | phone_work |
idx_leads_id_del | index | id,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_leads_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len |
---|---|---|
id | varchar | 36 |
parent_id | varchar | 36 |
parent_type | varchar | 25 |
document_id | varchar | 36 |
document_revision_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_parent_document | index | parent_type,parent_id,document_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 50 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
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 | Planned |
type | varchar | 255 | Sugar |
parent_id | char | 36 | |
reminder_time | int | 11 | -1 |
email_reminder_time | int | 11 | -1 |
email_reminder_sent | tinyint | ||
outlook_id | varchar | 255 | |
sequence | int | 11 | |
repeat_type | varchar | 36 | |
repeat_interval | int | 3 | 1 |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_mtg_name | index | name |
idx_meet_par_del | index | parent_id,parent_type,deleted |
idx_meet_stat_del | index | assigned_user_id,status,deleted |
idx_meet_date_start | index | date_start |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
meeting_id | varchar | 36 | |
contact_id | varchar | 36 | |
required | varchar | 1 | 1 |
accept_status | varchar | 25 | none |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_con_mtg_mtg | index | meeting_id |
idx_con_mtg_con | index | contact_id |
idx_meeting_contact | index | meeting_id,contact_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
meeting_id | varchar | 36 | |
lead_id | varchar | 36 | |
required | varchar | 1 | 1 |
accept_status | varchar | 25 | none |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_lead_meeting_meeting | index | meeting_id |
idx_lead_meeting_lead | index | lead_id |
idx_meeting_lead | index | meeting_id,lead_id |
name | type | len | default |
---|---|---|---|
id | varchar | 36 | |
meeting_id | varchar | 36 | |
user_id | varchar | 36 | |
required | varchar | 1 | 1 |
accept_status | varchar | 25 | none |
date_modified | datetime | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_usr_mtg_mtg | index | meeting_id |
idx_usr_mtg_usr | index | user_id |
idx_meeting_users | index | meeting_id,user_id |
name | type | len |
---|---|---|
assigned_user_id | char | 36 |
id | char | 36 |
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 | |
embed_flag | tinyint | |
description | text | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_note_name | index | name |
idx_notes_parent | index | parent_id,parent_type |
idx_note_contact | index | contact_id |
idx_notes_assigned_del | index | deleted,assigned_user_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
secret | varchar | 4000 | |
redirect_url | varchar | 255 | |
is_confidential | tinyint | 1 | |
allowed_grant_type | varchar | 255 | password |
duration_value | int | 11 | |
duration_amount | int | 11 | |
duration_unit | varchar | 255 | Duration Unit |
assigned_user_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
token_is_revoked | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
c_key | varchar | 255 |
c_secret | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
ckey | unique | c_key |
name | type | len |
---|---|---|
conskey | varchar | 32 |
nonce | varchar | 32 |
nonce_ts | bigint |
name | type | fields |
---|---|---|
primary | primary | conskey,nonce |
oauth_nonce_keyts | index | conskey,nonce_ts |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
secret | varchar | 32 | |
tstate | varchar | 1 | |
consumer | char | 36 | true |
token_ts | bigint | ||
verify | varchar | 32 | |
deleted | tinyint | ||
callback_url | varchar | 255 | |
assigned_user_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id,deleted |
oauth_state_ts | index | tstate,token_ts |
constoken_key | index | consumer |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 50 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_opp_name | index | name |
idx_opp_assigned | index | assigned_user_id |
idx_opp_id_deleted | index | id,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_opportunities_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
contact_id | varchar | 36 |
opportunity_id | varchar | 36 |
contact_role | varchar | 50 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_con_opp_con | index | contact_id |
idx_con_opp_opp | index | opportunity_id |
idx_opportunities_contacts | index | opportunity_id,contact_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
type | varchar | 15 | user |
user_id | char | 36 | true |
smtp_from_name | varchar | 255 | |
smtp_from_addr | varchar | 255 | |
mail_sendtype | varchar | 8 | smtp |
mail_smtptype | varchar | 20 | other |
mail_smtpserver | varchar | 100 | |
mail_smtpport | varchar | 5 | |
mail_smtpuser | varchar | 100 | |
mail_smtppass | varchar | 100 | |
mail_smtpauth_req | tinyint | ||
mail_smtpssl | varchar | 1 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
deleted | tinyint | ||
assigned_user_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_outbound_email_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
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 | |
estimated_start_date | date | |
estimated_end_date | date | |
status | varchar | 255 |
priority | varchar | 255 |
override_business_hours | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
project_contacts_1project_ida | varchar | 36 |
project_contacts_1contacts_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
project_contacts_1_alt | index | project_contacts_1project_ida,project_contacts_1contacts_idb |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
date_entered | datetime | ||
date_modified | datetime | ||
project_id | char | 36 | true |
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 | ||
order_number | int | 11 | 1 |
task_number | int | 11 | |
estimated_effort | int | 11 | |
actual_effort | int | 11 | |
deleted | tinyint | ||
utilization | int | 11 | 100 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_project_task_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
project_users_1project_ida | varchar | 36 |
project_users_1users_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
project_users_1_alt | index | project_users_1project_ida,project_users_1users_idb |
name | type | len |
---|---|---|
id | varchar | 36 |
account_id | varchar | 36 |
project_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_proj_acct_proj | index | project_id |
idx_proj_acct_acct | index | account_id |
projects_accounts_alt | index | project_id,account_id |
name | type | len |
---|---|---|
id | varchar | 36 |
bug_id | varchar | 36 |
project_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_proj_bug_proj | index | project_id |
idx_proj_bug_bug | index | bug_id |
projects_bugs_alt | index | project_id,bug_id |
name | type | len |
---|---|---|
id | varchar | 36 |
case_id | varchar | 36 |
project_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_proj_case_proj | index | project_id |
idx_proj_case_case | index | case_id |
projects_cases_alt | index | project_id,case_id |
name | type | len |
---|---|---|
id | varchar | 36 |
contact_id | varchar | 36 |
project_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_proj_con_proj | index | project_id |
idx_proj_con_con | index | contact_id |
projects_contacts_alt | index | project_id,contact_id |
name | type | len |
---|---|---|
id | varchar | 36 |
opportunity_id | varchar | 36 |
project_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_proj_opp_proj | index | project_id |
idx_proj_opp_opp | index | opportunity_id |
projects_opportunities_alt | index | project_id,opportunity_id |
name | type | len |
---|---|---|
id | varchar | 36 |
product_id | varchar | 36 |
project_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_proj_prod_project | index | project_id |
idx_proj_prod_product | index | product_id |
projects_products_alt | index | project_id,product_id |
name | type | len |
---|---|---|
id | varchar | 36 |
prospect_list_id | varchar | 36 |
campaign_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_pro_id | index | prospect_list_id |
idx_cam_id | index | campaign_id |
idx_prospect_list_campaigns | index | prospect_list_id,campaign_id |
name | type | len |
---|---|---|
assigned_user_id | char | 36 |
id | char | 36 |
name | varchar | 255 |
list_type | varchar | 100 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
deleted | tinyint | |
description | text | |
domain_name | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_prospect_list_name | index | name |
name | type | len |
---|---|---|
id | varchar | 36 |
prospect_list_id | varchar | 36 |
related_id | varchar | 36 |
related_type | varchar | 25 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_plp_pro_id | index | prospect_list_id |
idx_plp_rel_id | index | related_id,related_type,prospect_list_id |
name | type | len | auto_increment | required |
---|---|---|---|---|
id | char | 36 | ||
date_entered | datetime | |||
date_modified | datetime | |||
modified_user_id | char | 36 | ||
created_by | char | 36 | ||
description | text | |||
deleted | tinyint | |||
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 | |||
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 | 1 | true |
birthdate | date | |||
lead_id | char | 36 | ||
account_name | varchar | 150 | ||
campaign_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
prospect_auto_tracker_key | index | tracker_key |
idx_prospects_last_first | index | last_name,first_name,deleted |
idx_prospecs_del_last | index | last_name,deleted |
idx_prospects_id_del | index | id,deleted |
idx_prospects_assigned | index | assigned_user_id |
name | type | len | default |
---|---|---|---|
id_c | char | 36 | |
jjwg_maps_lng_c | float | 11,8 | 0.00000000 |
jjwg_maps_lat_c | float | 10,8 | 0.00000000 |
jjwg_maps_geocode_status_c | varchar | 255 | |
jjwg_maps_address_c | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id_c |
name | type | len |
---|---|---|
id | char | 36 |
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 | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_rel_name | index | relationship_name |
name | type | len |
---|---|---|
id | char | 36 |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_releases | index | name,deleted |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
popup | tinyint | ||
tinyint | |||
email_sent | tinyint | ||
timer_popup | varchar | 32 | |
timer_email | varchar | 32 | |
related_event_module | varchar | 32 | |
related_event_module_id | char | 36 | true |
date_willexecute | int | 60 | -1 |
popup_viewed | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_reminder_name | index | name |
idx_reminder_deleted | index | deleted |
idx_reminder_related_event_module | index | related_event_module |
idx_reminder_related_event_module_id | index | related_event_module_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
reminder_id | char | 36 | true |
related_invitee_module | varchar | 32 | |
related_invitee_module_id | char | 36 | true |
name | type | fields |
---|---|---|
primary | primary | id |
idx_reminder_invitee_name | index | name |
idx_reminder_invitee_assigned_user_id | index | assigned_user_id |
idx_reminder_invitee_reminder_id | index | reminder_id |
idx_reminder_invitee_related_invitee_module | index | related_invitee_module |
idx_reminder_invitee_related_invitee_module_id | index | related_invitee_module_id |
name | type | len |
---|---|---|
id | char | 36 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
name | varchar | 150 |
description | text | |
modules | text | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_role_id_del | index | id,deleted |
name | type | len |
---|---|---|
id | varchar | 36 |
role_id | varchar | 36 |
module_id | varchar | 36 |
allow | tinyint | |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_role_id | index | role_id |
idx_module_id | index | module_id |
name | type | len |
---|---|---|
id | varchar | 36 |
role_id | varchar | 36 |
user_id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_ru_role_id | index | role_id |
idx_ru_user_id | index | user_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 150 |
search_module | varchar | 150 |
deleted | tinyint | |
date_entered | datetime | |
date_modified | datetime | |
assigned_user_id | char | 36 |
contents | text | |
description | text |
name | type | fields |
---|---|---|
primary | primary | id |
idx_desc | index | name,deleted |
name | type | len |
---|---|---|
id | varchar | 36 |
deleted | tinyint | |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_schedule | index | date_time_start,deleted |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
noninheritable | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
securitygroup_id | char | 36 |
role_id | char | 36 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_securitygroups_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
securitygroup_id | char | 36 |
module | varchar | 50 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_securitygroups_records_mod | index | module,deleted,record_id,securitygroup_id |
idx_securitygroups_records_del | index | deleted,record_id,module,securitygroup_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
securitygroup_id | varchar | 36 |
user_id | varchar | 36 |
primary_group | tinyint | |
noninheritable | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
securitygroups_users_idxa | index | securitygroup_id |
securitygroups_users_idxb | index | user_id |
securitygroups_users_idxc | index | user_id,deleted,securitygroup_id,id |
securitygroups_users_idxd | index | user_id,deleted,securitygroup_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
config | longtext | |
type | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
related_module | varchar | 100 |
related_id | char | 36 |
link_url | varchar | 255 |
link_type | varchar | 30 |
name | type | fields |
---|---|---|
primary | primary | id |
sgrfeed_date | index | date_entered,deleted |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
sort_order | int | 255 |
survey_question_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_surveyquestionoptions_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | varchar | 36 |
date_modified | datetime | |
deleted | tinyint | |
surveyq72c7options_ida | varchar | 36 |
surveyq10d4sponses_idb | varchar | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
surveyquestionoptions_surveyquestionresponses_alt | index | surveyq72c7options_ida,surveyq10d4sponses_idb |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
answer | text | |
answer_bool | tinyint | |
answer_datetime | datetime | |
surveyquestion_id | char | 36 |
surveyresponse_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_surveyquestionresponses_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
sort_order | int | 255 |
type | varchar | 100 |
happiness_question | tinyint | |
survey_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_surveyquestions_parent_id | index | parent_id |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
assigned_user_id | char | 36 |
happiness | int | 11 |
email_response_sent | tinyint | |
account_id | char | 36 |
campaign_id | char | 36 |
contact_id | char | 36 |
survey_id | char | 36 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_surveyresponses_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 255 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
status | varchar | 100 | Draft |
submit_text | varchar | 255 | Submit |
satisfied_text | varchar | 255 | Satisfied |
neither_text | varchar | 255 | Neither Satisfied nor Dissatisfied |
dissatisfied_text | varchar | 255 | Dissatisfied |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
parent_id | char | 36 | true |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_surveys_parent_id | index | parent_id |
name | type | len | default |
---|---|---|---|
id | char | 36 | |
name | varchar | 50 | |
date_entered | datetime | ||
date_modified | datetime | ||
modified_user_id | char | 36 | |
created_by | char | 36 | |
description | text | ||
deleted | tinyint | ||
assigned_user_id | char | 36 | |
status | varchar | 100 | Not Started |
date_due_flag | tinyint | ||
date_due | datetime | ||
date_start_flag | tinyint | ||
date_start | datetime | ||
parent_type | varchar | 255 | |
parent_id | char | 36 | |
contact_id | char | 36 | |
priority | varchar | 100 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_tsk_name | index | name |
idx_task_con_del | index | contact_id,deleted |
idx_task_par_del | index | parent_id,parent_type,deleted |
idx_task_assigned | index | assigned_user_id |
idx_task_status | index | status |
name | type | len |
---|---|---|
id | char | 36 |
name | varchar | 255 |
date_entered | datetime | |
date_modified | datetime | |
modified_user_id | char | 36 |
created_by | char | 36 |
description | text | |
deleted | tinyint | |
thumbnail | varchar | 255 |
grp | varchar | 255 |
ord | int | 11 |
name | type | fields |
---|---|---|
primary | primary | id |
name | type | len | auto_increment |
---|---|---|---|
id | int | 11 | 1 |
monitor_id | char | 36 | true |
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 | ||
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_tracker_iid | index | item_id |
idx_tracker_userid_vis_id | index | user_id,visible,id |
idx_tracker_userid_itemid_vis | index | user_id,item_id,visible |
idx_tracker_monitor_id | index | monitor_id |
idx_tracker_date_modified | index | date_modified |
name | type | len |
---|---|---|
id | char | 36 |
filename | varchar | 255 |
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 |
name | type | fields |
---|---|---|
primary | primary | id |
upgrade_history_md5_uk | unique | md5sum |
name | type | len |
---|---|---|
id | char | 36 |
category | varchar | 50 |
deleted | tinyint | |
date_entered | datetime | |
date_modified | datetime | |
assigned_user_id | char | 36 |
contents | longtext |
name | type | fields |
---|---|---|
primary | primary | id |
idx_userprefnamecat | index | assigned_user_id,category |
name | type | len |
---|---|---|
id | char | 36 |
user_name | varchar | 60 |
user_hash | varchar | 255 |
system_generated_password | tinyint | |
pwd_last_changed | datetime | |
authenticate_id | varchar | 100 |
sugar_login | tinyint | 1 |
first_name | varchar | 255 |
last_name | varchar | 255 |
is_admin | tinyint | |
external_auth_only | tinyint | |
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 | |
portal_only | tinyint | |
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 | |
factor_auth | tinyint | |
factor_auth_interface | varchar | 255 |
name | type | fields |
---|---|---|
primary | primary | id |
idx_user_name | index | user_name,is_group,status,last_name (30),first_name (30),id |
name | type | len |
---|---|---|
user_id | varchar | 36 |
feed_id | varchar | 36 |
rank | int | 11 |
date_modified | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
idx_ud_user_id | index | user_id,feed_id |
name | type | len |
---|---|---|
id | char | 36 |
assigned_user_id | char | 36 |
import_module | varchar | 36 |
bean_type | varchar | 36 |
bean_id | char | 36 |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_user_id | index | assigned_user_id |
name | type | len |
---|---|---|
id | char | 36 |
username | varchar | 36 |
date_generated | datetime | |
deleted | tinyint |
name | type | fields |
---|---|---|
primary | primary | id |
idx_username | index | username |
name | type | len |
---|---|---|
id | char | 36 |
date_entered | datetime | |
date_modified | datetime | |
deleted | tinyint | |
user_id | varchar | 36 |
name | varchar | 255 |
signature | text | |
signature_html | text |
name | type | fields |
---|---|---|
primary | primary | id |
idx_usersig_uid | index | user_id |
name | type | len | required |
---|---|---|---|
id | char | 36 | |
deleted | tinyint | ||
date_entered | datetime | ||
date_modified | datetime | ||
user_id | char | 36 | true |
type | varchar | 100 | |
source | varchar | 100 | |
content | text |
name | type | fields |
---|---|---|
primary | primary | id |
idx_vcal | index | type,user_id |