Table llx document: Difference between revisions
Jump to navigation
Jump to search
mNo edit summary |
|||
| Line 11: | Line 11: | ||
= Structure = | = Structure = | ||
== Table == | |||
'''Version 1.1 2009/10/07''' | |||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | {| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | ||
|style="background-color: #e9e9ef"| <b>Field</b> | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| Line 22: | Line 24: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| NULL | | NULL | ||
| Line 30: | Line 32: | ||
| name | | name | ||
| varchar(255) | | varchar(255) | ||
| | | NO | ||
| | | | ||
| | | | ||
| Line 38: | Line 40: | ||
| file_name | | file_name | ||
| varchar(255) | | varchar(255) | ||
| | | NO | ||
| | | | ||
| | | | ||
| Line 46: | Line 48: | ||
| file_extension | | file_extension | ||
| varchar(5) | | varchar(5) | ||
| | | NO | ||
| | | | ||
| | | | ||
| Line 83: | Line 85: | ||
| | | | ||
| access permissions | | access permissions | ||
|} | |} | ||
== Keys == | |||
'''Version 1.1 2009/10/07''' | |||
{| align="left" width="100%" border="0" rules="all" cellpadding="1" cellspacing="0" style="margin: 0 0 1px 1px; border: 1px solid #dddddd; border-right-width: 2px; border-bottom-width: 2px; background-color: #f3f3f5" | |||
|style="background-color: #e9e9ef"| <b>Key</b> | |||
|style="background-color: #e9e9ef"| <b>Type</b> | |||
|style="background-color: #e9e9ef"| <b>Fields</b> | |||
|- | |||
| PRIMARY | |||
| PRIMARY | |||
| rowid | |||
|} | |||
Revision as of 09:15, 20 October 2009
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 information of documents built by module paper mailing
Contient les informations des documents générés par le module publipostage
contiene la información de documentos
Structure
Table
Version 1.1 2009/10/07
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | NULL | auto_increment | technical index |
| name | varchar(255) | NO | name of document | |||
| file_name | varchar(255) | NO | file name of document | |||
| file_extension | varchar(5) | NO | file extension of document | |||
| date_generation | datetime | YES | NULL | date of document generation | ||
| fk_owner | int(11) | YES | NULL | ID owner of document (llx_user->rowid) | ||
| fk_group | int(11) | YES | NULL | ID of group (llx_usergroup->rowid) | ||
| permissions | char(9) | YES | rw-rw-rw | access permissions |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |