Table llx mailing

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档可在页面上找到:Table SQL


Content/Contenu/Contenido

En verysmall.png Contains the e-mailing info. The target adresses list of e-mailing are in Table llx_mailing_cibles

Fr verysmall.png Contient les e-mailing info. La liste des destinataires est dans la Table llx_mailing_cibles

Es verysmall.png 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