Changes

Jump to navigation Jump to search

Table llx mailing (view source)

Revision as of 15:32, 19 July 2011

2,756 bytes added ,  13 years ago
→‎Structure
Line 1: Line 1: −
[[Catégorie:Table SQL]]
+
[[Category:Table SQL]]
−
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
+
[[Category:Mailing]]
−
  The documentation related to other tables is available on the tables list 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;
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/4615...22511"

Navigation menu