| id |
int(10)
|
|
|
|
| reference |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| date_operation |
date
|
|
|
|
| libelle |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| pu |
decimal(30,20)
|
|
|
|
| quantite |
decimal(30,20)
|
|
|
|
| unite |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| total_ttc |
decimal(30,20)
|
|
|
|
| piece_path |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| type |
enum('CREDIT', 'DEBIT')
|
utf8mb4_general_ci
|
|
|
| montant |
decimal(30,20)
|
|
|
|
| mode_paiement |
enum('especes', 'cheque', 'mobile_money', 'virement', 'carte', 'autre')
|
utf8mb4_general_ci
|
|
|
| vehicule_id |
int(10)
|
|
|
|
| ref_cheque |
varchar(80)
|
utf8mb4_general_ci
|
|
|
| fournisseur_nom |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| motifs |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| cree_par |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| piece_original_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| piece_mime |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| piece_blob |
longblob
|
|
|
|
| piece_uploaded_at |
datetime
|
|
|
|
| temp_checked |
tinyint(1)
|
|
|
|
