Difference between revisions of "Table llx notify"

Latest revision as of 12:45, 10 August 2012

The documentation related to other tables is available on the page: Table SQL
La documentation relative aux autres tables est disponible sur la page: Table SQL
La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
与其他表相关的文档请参阅：Table SQL

Return to developer
documentation index

Retour index
Documentation développeur

Volver al índice
Documentación desarrolladores

返回
开发文档

Content/Contenu/Contenido

Contains the e-mail notifications.

Contient les e-mail notifications.

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

@@ Line 14: / Line 14: @@
 = Structure =
 == Table ==
-'''Version 1.1 2009/10/07'''
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-{|  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"
   |style="background-color: #e9e9ef"| <b>Field</b>
   |style="background-color: #e9e9ef"| <b>Type</b>
@@ Line 31: / Line 30: @@
 | auto_increment
 | technical index
-|-
+{{FieldTms}}
-| tms
-| timestamp
-| NO
-|
-| CURRENT_TIMESTAMP
-|
-| last update date
 |-
 | daten
@@ Line 79: / Line 71: @@
 |
 | Id of related entity (any table_of_entity->rowid)
+|-
+| email
+| varchar(255)
+| YES
+|
+|
+|
+| notification e-mail
 |}&nbsp;
 == Keys ==
-'''Version 1.1 2009/10/07'''
+{|  align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox"
-{|  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"
   |style="background-color: #e9e9ef"| <b>Key</b>
   |style="background-color: #e9e9ef"| <b>Type</b>