| rowid |
int
|
|
|
|
| statut |
smallint
|
|
|
|
| titre |
varchar(128)
|
latin1_swedish_ci
|
|
|
| entity |
int
|
|
|
|
| sujet |
varchar(128)
|
latin1_swedish_ci
|
|
|
| body |
mediumtext
|
latin1_swedish_ci
|
|
|
| bgcolor |
varchar(8)
|
latin1_swedish_ci
|
|
|
| bgimage |
varchar(255)
|
latin1_swedish_ci
|
|
|
| cible |
varchar(60)
|
latin1_swedish_ci
|
|
|
| nbemail |
int
|
|
|
|
| email_from |
varchar(160)
|
latin1_swedish_ci
|
|
|
| email_replyto |
varchar(160)
|
latin1_swedish_ci
|
|
|
| email_errorsto |
varchar(160)
|
latin1_swedish_ci
|
|
|
| tag |
varchar(128)
|
latin1_swedish_ci
|
|
|
| date_creat |
datetime
|
|
|
|
| date_valid |
datetime
|
|
|
|
| date_appro |
datetime
|
|
|
|
| date_envoi |
datetime
|
|
|
|
| tms |
timestamp
|
|
|
|
| fk_user_creat |
int
|
|
|
|
| fk_user_valid |
int
|
|
|
|
| fk_user_appro |
int
|
|
|
|
| extraparams |
varchar(255)
|
latin1_swedish_ci
|
|
|
| joined_file1 |
varchar(255)
|
latin1_swedish_ci
|
|
|
| joined_file2 |
varchar(255)
|
latin1_swedish_ci
|
|
|
| joined_file3 |
varchar(255)
|
latin1_swedish_ci
|
|
|
| joined_file4 |
varchar(255)
|
latin1_swedish_ci
|
|
|