+---------------------+-------------+------+-----+-------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+-------------+------+-----+-------------------+----------------+
| rowid | int(11) | NO | PRI | NULL | auto_increment |
| tms | timestamp | NO | | CURRENT_TIMESTAMP | |
| fk_soc | int(11) | NO | MUL | | |
| fk_projet | int(11) | YES | | 0 | |
| ref | varchar(30) | NO | UNI | | |
| date_creation | datetime | YES | | NULL | |
| date_valid | datetime | YES | | NULL | |
| date_cloture | datetime | YES | | NULL | |
| date_commande | date | YES | | NULL | |
| fk_user_author | int(11) | YES | | NULL | |
| fk_user_valid | int(11) | YES | | NULL | |
| fk_user_cloture | int(11) | YES | | NULL | |
| source | smallint(6) | NO | | | |
| fk_statut | smallint(6) | YES | | 0 | | 0 pour brouillon, 1 pour validée, 2 pour "approuvée", 5 pour "reçu complètement"
| amount_ht | double | YES | | 0 | |
| remise_percent | double | YES | | 0 | |
| remise | double | YES | | 0 | |
| tva | double | YES | | 0 | |
| total_ht | double | YES | | 0 | |
| total_ttc | double | YES | | 0 | |
| note | text | YES | | NULL | |
| note_public | text | YES | | NULL | |
| model_pdf | varchar(50) | YES | | NULL | |
| fk_methode_commande | int(11) | YES | | 0 | |
+---------------------+-------------+------+-----+-------------------+----------------+