Line 29:
Line 29:
| auto_increment
| auto_increment
| technical index
| technical index
+
|-
+
| tms
+
| timestamp
+
| NO
+
|
+
| CURRENT_TIMESTAMP
+
|
+
| last update date
+
|-
+
| 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
|}
|}