Catégorie: Table SQL
+--------------------+--------------+------+-----+-------------------+----------------+
| 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 | | | |
+--------------------+--------------+------+-----+-------------------+----------------+