Difference between revisions of "Table llx product"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
| − | [[Catégorie: Table SQL]] | + | [[Catégorie:Table SQL]] |
| + | 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]] | ||
| − | Cette table contient les produits. | + | = Contenu = |
| + | |||
| + | Cette table contient les produits et services. | ||
| + | |||
| + | Contains the list of products and services. | ||
| + | |||
| + | = Structure = | ||
<pre> | <pre> | ||
Revision as of 03:02, 6 August 2007
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
Contenu
Cette table contient les produits et services.
Contains the list of products and services.
Structure
+--------------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+--------------+------+-----+-------------------+----------------+ | rowid | int(11) | NO | PRI | NULL | auto_increment | | datec | datetime | YES | | NULL | | | tms | timestamp | NO | | CURRENT_TIMESTAMP | | | ref | varchar(32) | NO | UNI | | | | label | varchar(255) | NO | | | | | description | text | YES | | NULL | | | note | text | YES | | NULL | | | price | double(16,8) | YES | | NULL | | | price_ttc | double(16,8) | YES | | 0.00000000 | | | price_base_type | varchar(3) | YES | | HT | | | tva_tx | double(6,3) | YES | | NULL | | | fk_user_author | int(11) | YES | | NULL | | | envente | tinyint(4) | YES | | 1 | | | nbvente | int(11) | YES | | 0 | | | fk_product_type | int(11) | YES | | 0 | | | duration | varchar(6) | YES | | NULL | | | stock_propale | int(11) | YES | | 0 | | | stock_commande | int(11) | YES | | 0 | | | seuil_stock_alerte | int(11) | YES | | 0 | | | stock_loc | varchar(10) | YES | | NULL | | | gencode | varchar(255) | YES | | NULL | | | weight | float | YES | | NULL | | | weight_units | tinyint(4) | YES | | NULL | | | volume | float | YES | | NULL | | | volume_units | tinyint(4) | YES | | NULL | | | canvas | varchar(15) | YES | | | | +--------------------+--------------+------+-----+-------------------+----------------+