Dolibarr ERP CRM Wiki

Changes

Table llx mailing cibles (view source)

Revision as of 14:52, 29 July 2009

597 bytes added ,  15 years ago
→‎Structure
Line 29: Line 29:  
| auto_increment  
 
| auto_increment  
 
| technical index
 
| technical index
 +
|-
 +
| fk_mailing
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| ID of related mailing ([[Table llx_mailing|llx_mailing]]->rowid)
 +
|-
 +
| fk_contact
 +
| int(11)
 +
| NO
 +
|
 +
|
 +
|
 +
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
 +
|-
 +
| nom
 +
| varchar(160)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| name
 +
|-
 +
| prenom
 +
| varchar(160)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| first name
 +
|-
 +
| email
 +
| varchar(160)
 +
| NO
 +
|
 +
|
 +
|
 +
| e-mail for the send
 +
|-
 +
| other
 +
| varchar(255)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
|
 +
|-
 +
| statut
 +
| smallint(6)
 +
| NO
 +
|
 +
| 0
 +
|
 +
| status of send
 +
|-
 +
| url
 +
| varchar(160)
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| url
 +
|-
 +
| date_envoi
 +
| datetime
 +
| YES
 +
|
 +
| NULL
 +
|
 +
| date of send
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/13289"