Difference between revisions of "Table llx mailing"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
m
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
[[Category:Table SQL]]
 
[[Category:Table SQL]]
 
[[Category:Mailing]]
 
[[Category:Mailing]]
−
 
 
−
La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
 
  
−
= Contenu =
+
{{ListOfTables}}
  
 +
 +
= Content/Contenu/Contenido =
 +
 +
{{Flag en}} Contains the e-mailing info. The target adresses list of e-mailing are in [[Table llx_mailing_cibles]]
 +
 +
{{Flag fr}} Contient les e-mailing info. La liste des destinataires est dans la [[Table llx_mailing_cibles]]
 +
 +
{{Flag sp}} Contiene la información de e-mailing. La lista de direcciones de los e-mmailing se encuentra en la [[Table llx_mailing_cibles]]
  
 
= Structure =
 
= Structure =
 +
== Table ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Field</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Null</b>
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Default</b>
 +
|style="background-color: #e9e9ef"| <b>Extra</b>
 +
|style="background-color: #e9e9ef"| <b>Description</b>
 +
|-
 +
| 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 ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_valid
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID validator user ([[Table llx_user|llx_user]]->rowid)
 +
|-
 +
| fk_user_appro
 +
| int(11)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ID approval user ([[Table llx_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
 +
|}&nbsp;
 +
 +
== Keys ==
 +
{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
 +
|style="background-color: #e9e9ef"| <b>Key</b>
 +
|style="background-color: #e9e9ef"| <b>Type</b>
 +
|style="background-color: #e9e9ef"| <b>Fields</b>
 +
|-
 +
| PRIMARY
 +
| PRIMARY
 +
| rowid
 +
|}&nbsp;

Latest revision as of 15:32, 19 July 2011


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

Return to developer
documentation index

File Doc dev.png

Retour index
Documentation développeur

File Doc dev.png

Volver al índice
Documentación desarrolladores

File Doc dev.png

返回
开发文档

File Doc dev.png


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

 

Retrieved from "https://wiki.dolibarr.org/index.php?title=Table_llx_mailing&oldid=22511"