Table llx notify def: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
No edit summary
Line 1: Line 1:
[[Category:Table SQL]]
[[Category:Table SQL]]
[[Category:Notification]]
[[Category:Notification]]
{{ListOfTables}}
{{ListOfTables}}


= Contenu =
= Content/Contenu/Contenido =
 
{{Flag en}} Contains the definitions for e-mail notifications.
 
{{Flag fr}} Contient les definitions des e-mail notifications.


{{Flag sp}} Contiene las definiciones de las notificaciones por e-mail.


= Structure =
= Structure =
Line 23: Line 29:
| auto_increment  
| auto_increment  
| technical index
| technical index
|-
| tms
| timestamp
| NO
|
| CURRENT_TIMESTAMP
|
| last update date
|-
| datec
| date
| YES
|
| NULL
|
| creation date
|-
| fk_action
| int(11)
| NO
|
|
|
| ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
|-
| fk_soc
| int(11)
| NO
|
| 
|
| ID of society ([[Table llx_societe|llx_societe]]->rowid)
|-
| fk_contact
| int(11)
| NO
|
|
|
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
|}
|}

Revision as of 15:27, 10 August 2009


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


Content/Contenu/Contenido

En verysmall.png Contains the definitions for e-mail notifications.

Fr verysmall.png Contient les definitions des e-mail notifications.

Es verysmall.png Contiene las definiciones de las notificaciones por e-mail.

Structure

Field Type Null Key Default Extra Description
rowid int(11)   PRI NULL auto_increment technical index
tms timestamp NO CURRENT_TIMESTAMP last update date
datec date YES NULL creation date
fk_action int(11) NO ID of action (llx_c_actioncomm->id)
fk_soc int(11) NO ID of society (llx_societe->rowid)
fk_contact int(11) NO ID of contact (llx_socpeople->rowid)