Table llx mailing
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅:Table SQL
Content/Contenu/Contenido
Contains the e-mailing info. The target adresses list of e-mailing are in Table llx_mailing_cibles
Contient les e-mailing info. La liste des destinataires est dans la Table llx_mailing_cibles
Contiene la información de e-mailing. La lista de direcciones de los e-mmailing se encuentra en la Table llx_mailing_cibles
Structure
Table
Field | Type | Null | Key | Default | Extra | Description |
rowid | int(11) | NO | PRI | auto_increment | technical index | |
statut | smallint(6) | YES | 0 | status of e-mailing (0=redacted, 1=validated, 2=approvated, 3=sent) | ||
titre | varchar(60) | YES | NULL | e-mailing reference | ||
entity | int(11) | NO | 1 | multi company id | ||
sujet | varchar(60) | YES | NULL | sujet of mailing | ||
body | text | YES | NULL | e-mailing body message | ||
bgcolor | varchar(8) | YES | NULL | backgroud color of mailing | ||
bgimage | varchar(255) | YES | NULL | backgroud image of mailing | ||
cible | varchar(60) | YES | NULL | tarjet of mailing | ||
nbemail | integer(11) | YES | NULL | number of mailings | ||
email_from | varchar(160) | YES | NULL | email address of sender | ||
email_replyto | varchar(160) | YES | NULL | email address for reply | ||
email_errorsto | varchar(160) | YES | NULL | email address for errors | ||
date_create | datetime | YES | NULL | creation date | ||
date_valid | datetime | YES | NULL | validation date | ||
date_appro | datetime | YES | NULL | approval date | ||
date_envoi | datetime | YES | NULL | sending date | ||
fk_user_creat | int(11) | YES | NULL | ID creator user (llx_user->rowid) | ||
fk_user_valid | int(11) | YES | NULL | ID validator user (llx_user->rowid) | ||
fk_user_appro | int(11) | YES | NULL | ID approval user (llx_user->rowid) | ||
joined_file1 | varchar(255) | YES | NULL | joined file | ||
joined_file2 | varchar(255) | YES | NULL | joined file | ||
joined_file3 | varchar(255) | YES | NULL | joined file | ||
joined_file4 | varchar(255) | YES | NULL | joined file |
Keys
Key | Type | Fields |
PRIMARY | PRIMARY | rowid |