|
id
|
char(36)
|
|
|
|
|
email
|
varchar(255)
|
|
|
|
|
display_name
|
varchar(200)
|
|
|
|
|
imap_host
|
varchar(255)
|
|
|
|
|
imap_port
|
int(11)
|
|
|
993
|
|
imap_secure
|
tinyint(1)
|
|
|
1
|
|
smtp_host
|
varchar(255)
|
|
|
|
|
smtp_port
|
int(11)
|
|
|
465
|
|
smtp_secure
|
tinyint(1)
|
|
|
1
|
|
encrypted_pass
|
text
|
|
|
|
|
assigned_user_id
|
char(36)
|
|
|
|
|
department_id
|
char(36)
|
|
|
|
|
is_active
|
tinyint(1)
|
|
|
1
|
|
last_sync_at
|
timestamp
|
|
|
|
|
last_synced_uid
|
int(11)
|
|
|
0
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|
|
auto_reply_enabled
|
tinyint(1)
|
|
|
0
|
|
auto_reply_subject
|
varchar(500)
|
|
|
|
|
auto_reply_body
|
text
|
|
|
|
|
auto_reply_only_once
|
tinyint(1)
|
|
|
1
|
|
auto_reply_active_from
|
date
|
|
|
|
|
auto_reply_active_until
|
date
|
|
|
|