|
id
|
varchar(36)
|
|
|
|
|
deleted
|
tinyint(1)
|
|
|
0
|
|
date_entered
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
|
last_import_run_datetime
|
datetime
|
|
|
|
|
mailbox_last_imported_days
|
text
|
|
|
|
|
email_import_per_run_threshold
|
int(11)
|
|
|
|
|
email_import_timeframe_start
|
varchar(255)
|
|
|
|
|
email_import_unread_only
|
tinyint(1)
|
|
|
|
|
modified_user_id
|
char(36)
|
|
|
|
|
created_by
|
char(36)
|
|
|
|
|
name
|
varchar(255)
|
|
|
|
|
status
|
varchar(100)
|
|
|
Active
|
|
email_body_filtering
|
varchar(255)
|
|
|
multi
|
|
server_url
|
varchar(100)
|
|
|
|
|
connection_string
|
varchar(255)
|
|
|
|
|
email_user
|
varchar(100)
|
|
|
|
|
email_password
|
varchar(100)
|
|
|
|
|
port
|
int(5)
|
|
|
143
|
|
service
|
varchar(50)
|
|
|
|
|
mailbox
|
text
|
|
|
|
|
sentFolder
|
varchar(255)
|
|
|
|
|
trashFolder
|
varchar(255)
|
|
|
|
|
delete_seen
|
tinyint(1)
|
|
|
0
|
|
move_messages_to_trash_after_import
|
tinyint(1)
|
|
|
0
|
|
mailbox_type
|
varchar(10)
|
|
|
|
|
template_id
|
char(36)
|
|
|
|
|
stored_options
|
text
|
|
|
|
|
group_id
|
char(36)
|
|
|
|
|
is_personal
|
tinyint(1)
|
|
|
0
|
|
groupfolder_id
|
char(36)
|
|
|
|
|
type
|
varchar(255)
|
|
|
|
|
auth_type
|
varchar(255)
|
|
|
basic
|
|
protocol
|
varchar(255)
|
|
|
imap
|
|
is_ssl
|
tinyint(1)
|
|
|
0
|
|
distribution_user_id
|
char(36)
|
|
|
|
|
outbound_email_id
|
char(36)
|
|
|
|
|
create_case_template_id
|
char(36)
|
|
|
|
|
external_oauth_connection_id
|
char(36)
|
|
|
|