Table llx ecm files

From Dolibarr ERP CRM Wiki
Jump to navigation Jump to search

En verysmall.png The documentation related to other tables is available on the page: Table SQL
Fr verysmall.png La documentation relative aux autres tables est disponible sur la page: Table SQL
Es verysmall.png La documentación relativa a otras tablas se encuentra disponible en la página: Table SQL
De verysmall.png Eine Dokumentation zu weiteren Tabellen ist auf dieser Seite verfügbar: Table SQL
Cn verysmall.png与其他表相关的文档可在页面上找到:Table SQL


Content/Contenu/Contenido

En verysmall.png contains the list of the documents of Electronic Content Management. The directories are in the Table llx ecm directories

Fr verysmall.png contient la liste des documents du Gestion Electronique de Documents. Les répertoires sont a la Table llx ecm directories

Es verysmall.png Contiene la lista de los documentos de la Gestión Electrónica de Documentos. Los directorios se encuentran en Table llx ecm directories

Structure

Table

Field Type Null Key Default Extra Description
rowid int(11) NO PRI auto_increment technical index
ref varchar(16) NO ref. of document
entity int(11) NO 1 multi company id
filename varchar(255) NO file name of document
filesize int(11) NO file size of document
filenime varchar(32) NO file nime of document
fullpath_dol varchar(255) NO dolibarr path of file
fullpath_orig varchar(255) NO orig. path of file
description text YES NULL description about document
manualkeyword text YES NULL keyword for document
fk_create int(11) NO ID of creator user (llx_user->rowid)
fk_update int(11) YES NULL ID of last updater user (llx_user->rowid)
date_c datetime NO creation date
date_u timestamp NO CURRENT_TIMESTAMP last update date
fk_directory int(11) YES NULL ID of related directory (llx ecm directories->rowid)
fk_status smallint(6) YES 0 ID of status
private smallint(6) YES 0 is the document private to user (0=no,1=yes)?
crc varchar(32) NO checksum
cryptkey varchar(50) NO crypt key
cipher varchar(50) NO twofish crypt cipher

 

Keys

Key Type Fields
PRIMARY PRIMARY rowid