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