Table llx notify: Difference between revisions

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search
 
(6 intermediate revisions by one other user not shown)
Line 4: Line 4:
{{ListOfTables}}
{{ListOfTables}}


= Contenu =
= Content/Contenu/Contenido =


{{Flag en}} Contains the e-mail notifications.
{{Flag fr}} Contient les e-mail notifications.
{{Flag sp}} Contiene las notificaciones por e-mail.


= Structure =
= 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>Field</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
  |style="background-color: #e9e9ef"| <b>Type</b>
Line 19: Line 25:
| rowid  
| rowid  
| int(11)  
| int(11)  
| &nbsp;
| NO
| PRI
| PRI
| NULL
|  
| auto_increment  
| auto_increment  
| technical index
| technical index
|}
{{FieldTms}}
|-
| daten
| datetime
| YES
|
| NULL
|
| notification date
|-
| fk_action
| int(11)
| NO
|
|
|
| ID of action ([[Table llx_c_actioncomm|llx_c_actioncomm]]->id)
|-
| fk_contact
| int(11)
| NO
|
|
|
| ID of contact ([[Table llx_socpeople|llx_socpeople]]->rowid)
|-
| object_type
| varchar(24)
| NO
|
|
|
| type of related entity
|-
| object_id
| int(11)
| NO
|
|
|
| Id of related entity (any table_of_entity->rowid)
|-
| email
| varchar(255)
| YES
|
|
|
| notification e-mail
|}&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
|}&nbsp;

Latest revision as of 12:45, 10 August 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


Content/Contenu/Contenido

En verysmall.png Contains the e-mail notifications.

Fr verysmall.png Contient les e-mail notifications.

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

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
tms timestamp NO Current date Date of last modification. See page Field Tms.
daten datetime YES NULL notification date
fk_action int(11) NO ID of action (llx_c_actioncomm->id)
fk_contact int(11) NO ID of contact (llx_socpeople->rowid)
object_type varchar(24) NO type of related entity
object_id int(11) NO Id of related entity (any table_of_entity->rowid)
email varchar(255) YES notification e-mail

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid