Table llx categorie: Difference between revisions
Jump to navigation
Jump to search
| Line 14: | Line 14: | ||
= Structure = | = Structure = | ||
'''Version 1.11 2009/04/28''' | |||
{| 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 25: | Line 27: | ||
| rowid | | rowid | ||
| int(11) | | int(11) | ||
| | | NO | ||
| PRI | | PRI | ||
| NULL | | NULL | ||
| Line 34: | Line 36: | ||
| varchar(255) | | varchar(255) | ||
| YES | | YES | ||
| MUL | | MUL | ||
| NULL | | NULL | ||
| | | | ||
| label (name) | | label (name) | ||
|- | |||
| type | |||
| tinyint(4) | |||
| NO | |||
| UNI | |||
| 1 | |||
| | |||
| type of object of this category (0=products, suppliers=2 ,...) | |||
|- | |||
| entity | |||
| int(11) | |||
| NO | |||
| UNI | |||
| 1 | |||
| | |||
| multi company id | |||
|- | |- | ||
| description | | description | ||
| Line 46: | Line 64: | ||
| | | | ||
| description a little longer. May contain HTML Code | | description a little longer. May contain HTML Code | ||
|- | |||
| fk_soc | |||
| int(11) | |||
| YES | |||
| | |||
| NULL | |||
| | |||
| ID society ([[Table llx_societe|llx_societe]]->rowid) | |||
|- | |- | ||
| visible | | visible | ||
| Line 54: | Line 80: | ||
| | | | ||
| visibility (0=hidden, 1=visible) | | visibility (0=hidden, 1=visible) | ||
|} | |||
|} | |||
Revision as of 14:36, 8 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 categories used for the various objects of Dolibarr (providers, products, clients, ...)
Contient les différentes catégories des différents "objets" de Dolibarr (fournisseurs, produits, clients, ...)
Contiene las diferentes categorías de los diferentes "objetos" de Dolibarr (proveedores, productos, clientes, etc)
Structure
Version 1.11 2009/04/28
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | NULL | auto_increment | technical index |
| label | varchar(255) | YES | MUL | NULL | label (name) | |
| type | tinyint(4) | NO | UNI | 1 | type of object of this category (0=products, suppliers=2 ,...) | |
| entity | int(11) | NO | UNI | 1 | multi company id | |
| description | text | YES | NULL | description a little longer. May contain HTML Code | ||
| fk_soc | int(11) | YES | NULL | ID society (llx_societe->rowid) | ||
| visible | tinyint(4) | NO | 1 | visibility (0=hidden, 1=visible) |