Difference between revisions of "Table llx mailing cibles"

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
Visual
m
 
(9 intermediate revisions by 2 users not shown)
Line 4: Line 4:
  
  
−
= Contenu =
+
= Content/Contenu/Contenido =
  
 +
{{Flag en}} Contains the list of addressees defined for one mailing and the send status of the shipment by the addressee. This table is linked to [[Table llx_mailing]].
 +
 +
{{Flag fr}} Contient la liste des destinataires définis pour un mailing et le statut de l'envoi par destinataire. Cette table est liée avec la [[Table llx_mailing]].
 +
 +
{{Flag sp}} Contiene la lista de los destinatarios definidos para un mailing y el estado de envío por destinatario. Esta tabla está vinculada con la [[Table llx_mailing]].
  
 
= 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
 +
|-
 +
| fk_mailing
 +
| int(11)
 +
| NO
 +
| UNI
 +
|
 +
|
 +
| ID of related mailing ([[Table llx_mailing|llx_mailing]]->rowid)
 +
|-
 +
| fk_contact
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid). 0 if record not linked to a contact.
 +
|-
 +
| nom
 +
| varchar(160)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| name
 +
|-
 +
| prenom
 +
| varchar(160)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| first name
 +
|-
 +
| email
 +
| varchar(160)
 +
| NO
 +
| UNI
 +
|
 +
|
 +
| e-mail for the send
 +
|-
 +
| other
 +
| varchar(255)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
|
 +
|-
 +
| tag
 +
| varchar(128)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| ???
 +
|-
 +
| statut
 +
| smallint(6)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| status of send
 +
|-
 +
| source_url
 +
| varchar(160)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| url
 +
|-
 +
| source_id
 +
| integer
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| id
 +
|-
 +
| source_type
 +
| varchar(16)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| type of source element
 +
|-
 +
| date_envoi
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of send
 +
|}&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
 +
|-
 +
| uk_mailing_cibles
 +
| UNIQUE
 +
| fk_mailing,email
 +
|-
 +
| idx_mailing_cibles_email
 +
| MULTIPLE
 +
| email
 +
|}&nbsp;

Latest revision as of 22:24, 1 March 2012


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 list of addressees defined for one mailing and the send status of the shipment by the addressee. This table is linked to Table llx_mailing.

Fr verysmall.png Contient la liste des destinataires définis pour un mailing et le statut de l'envoi par destinataire. Cette table est liée avec la Table llx_mailing.

Es verysmall.png Contiene la lista de los destinatarios definidos para un mailing y el estado de envío por destinatario. Esta tabla está vinculada con la Table llx_mailing.

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
fk_mailing int(11) NO UNI ID of related mailing (llx_mailing->rowid)
fk_contact int(11) NO ID of contact (llx_socpeople->rowid). 0 if record not linked to a contact.
nom varchar(160) YES NULL name
prenom varchar(160) YES NULL first name
email varchar(160) NO UNI e-mail for the send
other varchar(255) YES NULL
tag varchar(128) YES NULL ???
statut smallint(6) NO 0 status of send
source_url varchar(160) YES NULL url
source_id integer YES NULL id
source_type varchar(16) YES NULL type of source element
date_envoi datetime YES NULL date of send

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid
uk_mailing_cibles UNIQUE fk_mailing,email
idx_mailing_cibles_email MULTIPLE email

 

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