Table llx categorie
De Dolibarr Wiki.
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
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
Table
Version 1.1 2009/10/07
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | NO | PRI | auto_increment | technical index | |
| label | varchar(255) | YES | UNI | 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) |
Keys
Version 1.1 2009/10/07
| Key | Type | Fields |
| PRIMARY | PRIMARY | rowid |
| uk_categorie_ref | UNIQUE | label,type,entity |
| idx_categorie_type | MULTIPLE | type |
