Table llx categorie: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| Line 7: | Line 7: | ||
= Contenu = | = Contenu = | ||
La table '''llx_categorie''' contient les différentes catégories des différents "objets" de Dolibarr (fournisseurs, produits, clients, ...) | {{flag fr}} La table '''llx_categorie''' contient les différentes catégories des différents "objets" de Dolibarr (fournisseurs, produits, clients, ...) | ||
Contains the categories used for the various objects of Dolibarr (providers, products, clients, ...) | {{flag en}} Contains the categories used for the various objects of Dolibarr (providers, products, clients, ...) | ||
Contiene las diferentes categorías de los diferentes "objetos" de Dolibarr (proveedores, productos, clientes, etc) | {{flag sp}} Contiene las diferentes categorías de los diferentes "objetos" de Dolibarr (proveedores, productos, clientes, etc) | ||
= Structure = | = Structure = | ||
| Line 29: | Line 29: | ||
| NULL | | NULL | ||
| auto_increment | | auto_increment | ||
| index | | technical index | ||
|- | |- | ||
| label | | label | ||
| Line 37: | Line 37: | ||
| NULL | | NULL | ||
| | | | ||
| | | label (name) | ||
|- | |- | ||
| description | | description | ||
| Line 45: | Line 45: | ||
| NULL | | NULL | ||
| | | | ||
| description | | description a little longer. May contain HTML Code | ||
|- | |- | ||
| visible | | visible | ||
| Line 53: | Line 53: | ||
| 1 | | 1 | ||
| | | | ||
| | | visibility (0=hidden, 1=visible) | ||
|- | |- | ||
| type | | type | ||
| Line 61: | Line 61: | ||
| 1 | | 1 | ||
| | | | ||
| type | | type of object of this category (0=products, suppliers=2 ,...) | ||
|} | |} | ||
Revision as of 16:43, 12 May 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
Contenu
La table llx_categorie contient les différentes catégories des différents "objets" de Dolibarr (fournisseurs, produits, clients, ...)
Contains the categories used for the various objects of Dolibarr (providers, products, clients, ...)
Contiene las diferentes categorías de los diferentes "objetos" de Dolibarr (proveedores, productos, clientes, etc)
Structure
| Field | Type | Null | Key | Default | Extra | Description |
| rowid | int(11) | PRI | NULL | auto_increment | technical index | |
| label | varchar(255) | YES | MUL | NULL | label (name) | |
| description | text | YES | NULL | description a little longer. May contain HTML Code | ||
| visible | tinyint(4) | NO | 1 | visibility (0=hidden, 1=visible) | ||
| type | tinyint(4) | NO | 1 | type of object of this category (0=products, suppliers=2 ,...) |