| rowid | int(11) |
|
|
|
| statut | smallint(6) |
|
|
0
|
| titre | varchar(128) |
|
|
|
| entity | int(11) |
|
|
1
|
| sujet | varchar(128) |
|
|
|
| body | mediumtext |
|
|
|
| bgcolor | varchar(8) |
|
|
|
| bgimage | varchar(255) |
|
|
|
| cible | varchar(60) |
|
|
|
| nbemail | int(11) |
|
|
|
| email_from | varchar(160) |
|
|
|
| email_replyto | varchar(160) |
|
|
|
| email_errorsto | varchar(160) |
|
|
|
| tag | varchar(128) |
|
|
|
| date_creat | datetime |
|
|
2026-09-27 01:06:46.000000
|
| date_valid | datetime |
|
|
2026-09-27 01:06:46.000000
|
| date_appro | datetime |
|
|
2026-09-27 01:06:46.000000
|
| date_envoi | datetime |
|
|
2026-09-27 01:06:46.000000
|
| tms | timestamp |
|
|
current_timestamp()
|
| fk_user_creat | int(11) |
|
|
|
| fk_user_valid | int(11) |
|
|
|
| fk_user_appro | int(11) |
|
|
|
| extraparams | varchar(255) |
|
|
|
| joined_file1 | varchar(255) |
|
|
|
| joined_file2 | varchar(255) |
|
|
|
| joined_file3 | varchar(255) |
|
|
|
| joined_file4 | varchar(255) |
|
|
|