| Campo | Tipo | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int(11) | NO | PRI | NULL | auto_increment |
| id_empresa | int(11) | NO | UNI | NULL | |
| smtp_host | varchar(255) | NO | NULL | ||
| smtp_port | int(11) | NO | 587 | ||
| smtp_username | varchar(255) | NO | NULL | ||
| smtp_password | varchar(255) | NO | NULL | ||
| smtp_from_email | varchar(255) | NO | NULL | ||
| smtp_from_name | varchar(255) | NO | Sistema de Tickets | ||
| imap_host | varchar(255) | NO | NULL | ||
| imap_port | int(11) | NO | 993 | ||
| imap_username | varchar(255) | NO | NULL | ||
| imap_password | varchar(255) | NO | NULL | ||
| imap_folder | varchar(100) | NO | INBOX | ||
| imap_encryption | varchar(50) | NO | /imap/ssl | ||
| imap_options | varchar(255) | NO | /imap/ssl/validate-cert | ||
| activo | tinyint(1) | NO | 1 | ||
| processing_enabled | tinyint(1) | NO | MUL | 1 | |
| max_emails_per_run | int(11) | NO | 50 | ||
| processing_interval_minutes | int(11) | NO | 5 | ||
| error_count | int(11) | NO | MUL | 0 | |
| last_error | text | YES | NULL | ||
| created_at | timestamp | YES | current_timestamp() | ||
| updated_at | timestamp | YES | current_timestamp() | on update current_timestamp() | |
| last_processed_at | timestamp | YES | MUL | NULL |
smtp_from_email: Tipo: varchar(255), Nullable: NO, Default: NULL
imap_username: Tipo: varchar(255), Nullable: NO, Default: NULL
imap_encryption: Tipo: varchar(50), Nullable: NO, Default: '/imap/ssl'
| ID Empresa | smtp_from_email | imap_username | imap_encryption |
|---|---|---|---|
| 2 | test@example.com (tipo: string) | test@example.com (tipo: string) | /imap/ssl (tipo: string) |
| 1 | test1@secureitmx.com (tipo: string) | test1@secureitmx.com (tipo: string) | /imap/ssl (tipo: string) |