Table llx notify: Difference between revisions

mNo edit summary
 
(8 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[Category:Table SQL]]
[[Category:Table SQL]]
  La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]
[[Category:Notification]]
  The documentation related to other tables is available on the tables list page: [[Liste des tables]]


= Contenu =
{{ListOfTables}}


= 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 =
== 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>
|style="background-color: #e9e9ef"| <b>Null</b>
|style="background-color: #e9e9ef"| <b>Key</b>
|style="background-color: #e9e9ef"| <b>Default</b>
|style="background-color: #e9e9ef"| <b>Extra</b>
|style="background-color: #e9e9ef"| <b>Description</b>
|-
| rowid
| int(11)
| NO
| PRI
|
| auto_increment
| 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;