Difference between revisions of "Table llx mailing cibles"

Latest revision as of 22:24, 1 March 2012

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

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

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.

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.

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

@@ Line 13: / Line 13: @@
 = Structure =
-{|  align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0"  style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5"
+== 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>
@@ Line 24: / Line 25: @@
 | rowid
 | int(11)
-| &nbsp;
+| NO
 | PRI
-| NULL
+|
 | auto_increment
 | technical index
@@ Line 33: / Line 34: @@
 | int(11)
 | NO
-|
+| UNI
 |
 |
@@ Line 65: / Line 66: @@
 | varchar(160)
 | NO
-|
+| UNI
 |
 |
@@ Line 77: / Line 78: @@
 |
 |
+|-
+| tag
+| varchar(128)
+| YES
+|
+| NULL
+|
+| ???
 |-
 | statut
@@ Line 86: / Line 95: @@
 | status of send
 |-
-| url
+| source_url
 | varchar(160)
 | YES
@@ Line 93: / Line 102: @@
 |
 | url
+|-
+| source_id
+| integer
+| YES
+|
+| NULL
+|
+| id
+|-
+| source_type
+| varchar(16)
+| YES
+|
+| NULL
+|
+| type of source element
 |-
 | date_envoi
@@ Line 101: / Line 126: @@
 |
 | 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;