| id |
int(11)
|
|
|
|
| dia_no |
varchar(32)
|
utf8mb4_unicode_ci
|
|
|
| article_id |
int(11)
|
|
|
|
| code_snapshot |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| designation_snapshot |
varchar(160)
|
utf8mb4_unicode_ci
|
|
|
| categorie_snapshot |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| unite_snapshot |
varchar(20)
|
utf8mb4_unicode_ci
|
|
|
| fournisseur_suggere |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| utilisation_snapshot |
varchar(120)
|
utf8mb4_unicode_ci
|
|
|
| stock_actuel |
decimal(12,3)
|
|
|
|
| seuil_alerte |
decimal(12,3)
|
|
|
|
| quantite_demandee |
decimal(12,3)
|
|
|
|
| pu_estime |
decimal(12,2)
|
|
|
|
| total_estime |
decimal(12,2)
|
|
|
|
| priorite |
enum('basse', 'normale', 'haute', 'urgente')
|
utf8mb4_unicode_ci
|
|
|
| statut |
enum('brouillon', 'envoyee', 'validee', 'commandee', 'recue', 'annulee')
|
utf8mb4_unicode_ci
|
|
|
| motif |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| commentaire |
text
|
utf8mb4_unicode_ci
|
|
|
| requested_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| user_id |
int(11)
|
|
|
|
| requested_at |
datetime
|
|
|
|
| needed_at |
date
|
|
|
|
| approved_by |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| approved_at |
datetime
|
|
|
|
| received_movement_id |
int(11)
|
|
|
 Browse foreign values
|
| received_qty |
decimal(12,3)
|
|
|
|
| received_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
