Dolibarr ERP CRM Wiki

Changes

Table llx mailing (view source)

Revision as of 14:32, 29 July 2009

1,443 bytes added ,  15 years ago
→‎Structure
Line 30: Line 30:  
| auto_increment  
 
| auto_increment  
 
| technical index
 
| 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)
 +
|  
 +
|
 +
| 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)
 
|}
 
|}
Retrieved from "https://wiki.dolibarr.org/index.php?title=Special:MobileDiff/13285"