CREATE TABLE `travaux_ag` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `id_exercice` INT NOT NULL COMMENT '→ exercices.id',
  `id_decision` INT NOT NULL COMMENT '→ pv_decisions.id',
  `id_resolution` INT NOT NULL COMMENT '→ pv_resolutions.id',
  `fournisseur` VARCHAR(255) DEFAULT NULL,
  `montant` DECIMAL(10,2) NOT NULL,
  `description` TEXT,
  `file_path` VARCHAR(255) DEFAULT NULL,
  `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_trav_exercice` (`id_exercice`),
  KEY `idx_trav_decision` (`id_decision`),
  KEY `idx_trav_resolution` (`id_resolution`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
