Table llx ecm files
(Redirected from Table llx ecm documents)
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 the documents of Electronic Content Management. The directories are in the Table llx ecm directories
contient la liste des documents du Gestion Electronique de Documents. Les répertoires sont a la Table llx ecm directories
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 |