Table llx blockedlog
Jump to navigation
Jump to search
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
Content/Contenu/Contenido
Contains the list of inalterable logs (BlockedLog)
Contient la liste des logs inaltérables (BlockedLog)
Contiene la lista de registros inalterables (BlockedLog)
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int | NO | PRI | NULL | auto_increment | Technical unique ID |
| entity | int | NO | 1 | Entity (multi-company support) | ||
| date_creation | datetime | YES | NULL | Date of creation (included in signature) | ||
| action | varchar(50) | YES | NULL | Type of action logged (included in signature) | ||
| amounts | double(24,8) | NO | NULL | Amount concerned by the action (included in signature) | ||
| ref_object | varchar(255) | YES | NULL | Reference of the object concerned (included in signature) | ||
| date_object | datetime | YES | NULL | Date associated with the object (included in signature) | ||
| user_fullname | varchar(255) | YES | NULL | Full name of the user (included in signature) | ||
| object_data | mediumtext | YES | NULL | Serialized data of the object (included in signature) | ||
| signature | varchar(100) | NO | NULL | Signature hash with previous hash (chain signature) | ||
| element | varchar(50) | YES | NULL | Module or business object concerned (debug only) | ||
| fk_user | int | YES | NULL | ID of user who triggered the action (llx_user->rowid) (debug only) | ||
| fk_object | int | YES | NULL | ID of the object concerned (debug only) | ||
| signature_line | varchar(100) | NO | NULL | Signature of line only (without chaining; for debug only) | ||
| object_version | varchar(32) | YES | (empty string) | Version when line was recorded | ||
| certified | int | YES | NULL | Certification status (0 = no, 1 = yes). Not used. Reserved if using a remote chain validator. | ||
| tms | timestamp | NO | CURRENT_TIMESTAMP | auto update | Date of last modification. See page | |
| tms | timestamp | NO | Current date | Date of last modification. See page Field Tms. | ||
| debuginfo | mediumtext | YES | NULL | Additional debug information |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| signature | INDEX | signature |
| fk_object_element | INDEX | fk_object, element |
| entity | INDEX | entity |
| fk_user | INDEX | fk_user |
| entity_action_certified | INDEX | entity, action, certified |
| entity_rowid | INDEX | entity, rowid |