Changes

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
 
|}
 
|}