Table llx product
Jump to navigation
Jump to search
+--------------------+--------------+------+-----+-------------------+----------------+ | 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 | | | | +--------------------+--------------+------+-----+-------------------+----------------+