Difference between revisions of "Table llx document model"
Jump to navigation
Jump to search
m |
|||
| (11 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
[[Category:Table SQL]] | [[Category:Table SQL]] | ||
| − | + | [[Category:Core]] | |
| − | + | [[Category:Noyau]] | |
| + | [[Category:Básico]] | ||
| + | {{ListOfTables}} | ||
| − | = Contenu = | + | = Content/Contenu/Contenido = |
| + | {{flag en}} Contains the list of document templates activated by user from a module setup page. | ||
| + | {{flag fr}} Contient la liste des modèles de document activé par l'utilisateur depuis une page de configuration de module. | ||
| + | |||
| + | {{flag sp}} contiene la lista de los modelos de documentos disponibles | ||
= Structure = | = Structure = | ||
| + | == Table == | ||
| + | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
| + | |style="background-color: #e9e9ef"| <b>Field</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Null</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Key</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Default</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Extra</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Description</b> | ||
| + | |- | ||
| + | | rowid | ||
| + | | int(11) | ||
| + | | NO | ||
| + | | PRI | ||
| + | | | ||
| + | | auto_increment | ||
| + | | technical index | ||
| + | |- | ||
| + | | nom | ||
| + | | varchar(50) | ||
| + | | YES | ||
| + | | UNI | ||
| + | | NULL | ||
| + | | | ||
| + | | name of document model | ||
| + | |- | ||
| + | | entity | ||
| + | | int(11) | ||
| + | | NO | ||
| + | | | ||
| + | | 1 | ||
| + | | | ||
| + | | multi company id | ||
| + | |- | ||
| + | | type | ||
| + | | varchar(20) | ||
| + | | NO | ||
| + | | UNI | ||
| + | | | ||
| + | | | ||
| + | | type of document model | ||
| + | |- | ||
| + | | libelle | ||
| + | | varchar(255) | ||
| + | | YES | ||
| + | | | ||
| + | | NULL | ||
| + | | | ||
| + | | label of document model | ||
| + | |- | ||
| + | | description | ||
| + | | text | ||
| + | | YES | ||
| + | | | ||
| + | | NULL | ||
| + | | | ||
| + | | description of document model | ||
| + | |} | ||
| + | |||
| + | == Keys == | ||
| + | {| align="left" width="100%" border="0" cellpadding="1" cellspacing="0" class="dolbox" | ||
| + | |style="background-color: #e9e9ef"| <b>Key</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Type</b> | ||
| + | |style="background-color: #e9e9ef"| <b>Fields</b> | ||
| + | |- | ||
| + | | PRIMARY | ||
| + | | PRIMARY | ||
| + | | rowid | ||
| + | |- | ||
| + | | uk_document_model | ||
| + | | UNIQUE | ||
| + | | nom,type,entity | ||
| + | |} | ||
Latest revision as of 14:46, 19 July 2011
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 document templates activated by user from a module setup page.
Contient la liste des modèles de document activé par l'utilisateur depuis une page de configuration de module.
contiene la lista de los modelos de documentos disponibles
Structure
Table
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| nom | varchar(50) | YES | UNI | NULL | name of document model | |
| entity | int(11) | NO | 1 | multi company id | ||
| type | varchar(20) | NO | UNI | type of document model | ||
| libelle | varchar(255) | YES | NULL | label of document model | ||
| description | text | YES | NULL | description of document model |
Keys
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_document_model | UNIQUE | nom,type,entity |