4,395
edits
Changes
→Structure
Line 1:
Line 1:
− La documentation relative aux autres tables est disponible sur la page [[Liste des tables]]+ The documentation related to other tables is available on the tables list page: [[Liste des tables]]+
[[Catégorie: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
+|}