--
-- Host: localhost    Database: ferme
-- ------------------------------------------------------


--
-- Table structure for table `actionnaire`
--

CREATE TABLE `actionnaire` (
  `id` int NOT NULL AUTO_INCREMENT,
  `utilisateur_id` int NOT NULL,
  `parts` float NOT NULL,
  `bande_id` int NOT NULL,
  `montant_investi` float NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `actionnaire_utilisateur_id_foreign` (`utilisateur_id`),
  KEY `actionnaire_bande_id_foreign` (`bande_id`),
  CONSTRAINT `actionnaire_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `actionnaire_utilisateur_id_foreign` FOREIGN KEY (`utilisateur_id`) REFERENCES `utilisateur` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `actionnaire`
--


--
-- Table structure for table `aliment`
--

CREATE TABLE `aliment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` text COLLATE utf8mb4_general_ci NOT NULL,
  `prix_unitaire` float NOT NULL,
  `quantite` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `fournisseur` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `statut` enum('active','terminer','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `ferme_id` int NOT NULL,
  `id_bande` int DEFAULT '1',
  `type_aliment` enum('démarrage','croissance','finition') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'démarrage',
  `nbre_sac` float NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `aliment_ferme_id_foreign` (`ferme_id`),
  CONSTRAINT `aliment_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `aliment`
--

INSERT INTO `aliment` VALUES (1,'06 février 2026',400,50,20000,'Skab','terminer',2,2,'démarrage',1,'2026-02-12 17:55:01','2026-02-16 21:05:09','2026-02-12 18:55:01'),(2,'50 Kg Demarrage',400,50,20000,'Skap','terminer',1,1,'démarrage',1,'2026-02-12 18:14:26','2026-02-18 08:38:32','2026-02-12 19:14:26'),(3,'105 kg Aliment',239.29,105,25125,'Cyrusien','terminer',3,3,'démarrage',2.1,'2026-02-12 19:56:50','2026-02-12 19:57:39','2026-02-12 20:56:50'),(4,'112 Kg aliment',223.21,112,25000,'Cyrusien','terminer',3,3,'croissance',2.24,'2026-02-12 19:57:18','2026-03-03 17:58:23','2026-02-12 20:57:18'),(5,'16 février 2026',303.1,250,75775,'Kam mélangeur','terminer',2,2,'démarrage',5,'2026-02-16 20:58:03','2026-03-03 05:32:03','2026-02-16 21:58:03'),(6,'250 kg démarrage',316,250,79000,'Moi même','terminer',1,1,'démarrage',5,'2026-02-20 06:06:42','2026-03-02 13:24:27','2026-02-20 07:06:42'),(7,'03 mars 2026',298,250,74500,'Kam','terminer',2,2,'finition',5,'2026-03-04 05:18:11','2026-03-15 15:22:58','2026-03-04 06:18:11'),(8,'100 Kg Aliment croissance',320,145,46400,'Sir Cyrusien','terminer',1,1,'croissance',2.9,'2026-03-04 08:28:04','2026-03-09 06:56:59','2026-03-04 09:28:04'),(9,'2 sacs aliment',212.96,108,23000,'Sir CYRUSIEN','terminer',3,3,'croissance',2.16,'2026-03-05 18:57:57','2026-03-19 08:14:52','2026-03-05 19:57:57'),(10,'274 KG aliment croissance',293.8,274,80500,'cyrusien','terminer',1,1,'croissance',5.48,'2026-03-10 07:44:59','2026-03-18 08:14:05','2026-03-10 08:44:59'),(11,'190 kg aliment',286.84,190,54500,'Cyrusien','terminer',1,1,'croissance',3.8,'2026-03-16 16:29:33','2026-03-22 07:12:18','2026-03-16 17:29:33'),(12,'16 mars',287.4,225,64665,'Kam','active',2,2,'finition',4.5,'2026-03-16 18:39:59','2026-03-16 18:39:59','2026-03-16 19:39:59'),(13,'174 kg aliment',183.91,174,32000,'Moi même','terminer',3,3,'croissance',3.48,'2026-03-20 21:12:07','2026-04-07 14:22:13','2026-03-20 22:12:07'),(14,'343 kg finition',276.97,343,95000,'Moi même','terminer',1,1,'finition',6.86,'2026-03-22 07:12:54','2026-04-07 09:28:11','2026-03-22 08:12:54'),(16,'50 Kg Aliment',280,50,14000,'Sir','active',1,1,'finition',1,'2026-03-31 09:38:29','2026-03-31 09:38:29','2026-03-31 10:38:29'),(17,'Aliment croissance',176.47,170,30000,'Cyrusien','terminer',3,3,'finition',3.4,'2026-04-15 18:45:20','2026-05-07 18:41:48','2026-04-15 19:45:20');

--
-- Table structure for table `bande`
--

CREATE TABLE `bande` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `prix_unitaire` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `ferme_id` int NOT NULL,
  `entreprise` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `souche` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nb_initial` int NOT NULL,
  `nb_mort` int NOT NULL,
  `poids_moyen` decimal(10,0) NOT NULL,
  `date_debut` datetime DEFAULT NULL,
  `date_fin` datetime DEFAULT NULL,
  `statut` enum('active','en cours','terminer','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `bande_ferme_id_foreign` (`ferme_id`),
  CONSTRAINT `bande_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `bande`
--

INSERT INTO `bande` VALUES (1,'BANDE DU 13 Février 2026',550,192500,1,'SKAP','Hubbard Efficient',364,0,45,'2026-02-13 00:00:00','2026-04-14 12:06:11','terminer','2026-02-09 08:54:24','2026-04-14 12:06:11','2026-02-09 09:54:24'),(2,'06 février 2026',550,110000,2,'Skab','Hubbard',210,7,1,'2026-02-06 00:00:00',NULL,'active','2026-02-12 17:53:04','2026-02-12 17:53:04','2026-02-12 18:53:04'),(3,'Porc',22000,66000,3,'Inconnu','Inconnu',3,0,15,'2026-01-15 00:00:00',NULL,'active','2026-02-12 19:55:36','2026-02-12 19:55:36','2026-02-12 20:55:36'),(4,'PORC DE RACE',22000,66000,5,'RASO','LARGE WHITE',3,0,20,'2026-01-15 00:00:00',NULL,'active','2026-03-06 11:55:39','2026-03-06 11:55:39','2026-03-06 12:55:39'),(5,'BD-22-Mai 2026',650,227500,1,'SKAP','Hubbard',364,0,40,'2026-05-22 00:00:00',NULL,'active','2026-04-28 08:27:13','2026-04-28 08:27:13','2026-04-28 09:27:13');

--
-- Table structure for table `benefice`
--

CREATE TABLE `benefice` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `actionnaire_id` int NOT NULL,
  `montant_benefice` float NOT NULL,
  `pourcentage_part` float NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `benefice_bande_id_foreign` (`bande_id`),
  KEY `benefice_actionnaire_id_foreign` (`actionnaire_id`),
  CONSTRAINT `benefice_actionnaire_id_foreign` FOREIGN KEY (`actionnaire_id`) REFERENCES `actionnaire` (`id`),
  CONSTRAINT `benefice_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `benefice`
--


--
-- Table structure for table `benefice_vente_bande`
--

CREATE TABLE `benefice_vente_bande` (
  `id` int NOT NULL AUTO_INCREMENT,
  `vente_id` int NOT NULL,
  `ferme_id` int NOT NULL,
  `bande_id` int NOT NULL,
  `date_vente` date NOT NULL,
  `montant_vente` decimal(10,2) NOT NULL DEFAULT '0.00',
  `prix_unitaire` int NOT NULL DEFAULT '0',
  `benefice_unitaire` decimal(10,2) DEFAULT '0.00',
  `quantite` int NOT NULL DEFAULT '0',
  `cout_production` decimal(10,2) DEFAULT NULL,
  `benefice` decimal(10,2) DEFAULT NULL,
  `note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vente_id` (`vente_id`),
  KEY `benefice_vente_bande_ferme_id_foreign` (`ferme_id`),
  KEY `bande_id` (`bande_id`),
  CONSTRAINT `benefice_vente_bande_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `benefice_vente_bande_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`),
  CONSTRAINT `benefice_vente_bande_vente_id_foreign` FOREIGN KEY (`vente_id`) REFERENCES `vente` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `benefice_vente_bande`
--

INSERT INTO `benefice_vente_bande` VALUES (1,1,2,2,'2026-02-27',34500.00,1500,535.62,23,964.38,12319.26,NULL,'2026-03-01 13:28:48','2026-03-01 13:28:48',NULL),(2,2,1,1,'2026-03-04',54400.00,1600,588.42,34,1011.58,20006.28,NULL,'2026-03-04 08:29:59','2026-03-04 08:29:59',NULL),(3,3,1,1,'2026-03-04',8000.00,1600,567.23,5,1032.77,2836.15,NULL,'2026-03-04 11:22:13','2026-03-04 11:22:13',NULL),(4,4,1,1,'2026-03-05',24000.00,1600,541.51,15,1058.49,8122.65,NULL,'2026-03-05 18:51:00','2026-03-05 18:51:00',NULL),(5,5,1,1,'2026-03-06',16000.00,1600,539.91,10,1060.09,5399.10,NULL,'2026-03-06 08:25:15','2026-03-06 08:25:15',NULL),(6,6,1,1,'2026-03-11',18500.00,1850,579.61,10,1270.39,5796.10,NULL,'2026-03-11 16:25:37','2026-03-11 16:25:37',NULL),(7,7,2,2,'2026-03-09',22000.00,2200,1050.04,10,1149.96,10500.40,NULL,'2026-03-12 09:58:38','2026-03-12 09:58:38',NULL),(8,8,1,1,'2026-03-27',260000.00,2600,638.13,100,1961.87,63813.00,NULL,'2026-03-27 07:12:40','2026-03-27 07:12:40',NULL),(10,10,1,1,'2026-03-27',5400.00,2700,672.43,2,2027.57,1344.86,NULL,'2026-03-27 18:00:19','2026-03-27 18:00:19',NULL),(11,11,1,1,'2026-03-30',22400.00,2800,664.43,8,2135.57,5315.44,NULL,'2026-03-30 21:01:26','2026-03-30 21:01:26',NULL),(12,12,1,1,'2026-03-31',270000.00,2700,538.85,100,2161.15,53885.00,NULL,'2026-03-31 09:45:14','2026-03-31 09:45:14',NULL),(14,14,1,1,'2026-04-01',2303.00,2303,0.55,1,2302.45,0.55,NULL,'2026-04-01 09:20:10','2026-04-01 09:20:10',NULL),(15,15,1,1,'2026-04-01',5600.00,2800,497.54,2,2302.46,995.08,NULL,'2026-04-01 09:21:00','2026-04-01 09:21:00',NULL),(16,16,1,1,'2026-04-05',3300.00,3300,719.84,1,2580.16,719.84,NULL,'2026-04-05 14:08:45','2026-04-05 14:08:45',NULL),(17,17,1,1,'2026-04-05',12800.00,3200,619.84,4,2580.16,2479.36,NULL,'2026-04-05 14:08:58','2026-04-05 14:08:58',NULL),(18,18,1,1,'2026-04-08',81198.00,3123,364.00,26,2759.00,9464.00,NULL,'2026-04-07 17:54:30','2026-04-07 17:54:30',NULL),(19,19,1,1,'2026-04-10',32000.00,3200,341.00,10,2859.00,3410.00,NULL,'2026-04-10 07:32:32','2026-04-10 07:32:32',NULL),(20,20,1,1,'2026-04-10',11440.00,2860,1.00,4,2859.00,4.00,NULL,'2026-04-10 07:33:38','2026-04-10 07:33:38',NULL);

--
-- Table structure for table `cout_production_bande`
--

CREATE TABLE `cout_production_bande` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `ferme_id` int NOT NULL,
  `date_jour` date NOT NULL,
  `cout_production` decimal(10,2) NOT NULL DEFAULT '0.00',
  `age_jours` int DEFAULT NULL,
  `note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cout_production_bande_bande_id_foreign` (`bande_id`),
  KEY `cout_production_bande_ferme_id_foreign` (`ferme_id`),
  CONSTRAINT `cout_production_bande_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `cout_production_bande_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `cout_production_bande`
--

INSERT INTO `cout_production_bande` VALUES (1,1,1,'2026-02-09',542.65,1,NULL,'2026-02-09 08:54:34','2026-02-09 08:59:48',NULL),(2,1,1,'2026-02-12',559.49,2,NULL,'2026-02-12 10:16:50','2026-02-12 19:09:29',NULL),(3,3,3,'2026-02-12',30747.02,1,NULL,'2026-02-12 19:59:02','2026-02-12 20:15:22',NULL),(4,3,3,'2026-02-13',30747.02,2,NULL,'2026-02-13 07:02:03','2026-02-13 07:02:03',NULL),(5,1,1,'2026-02-13',564.61,3,NULL,'2026-02-13 07:02:25','2026-02-13 18:43:59',NULL),(6,1,1,'2026-02-14',571.93,4,NULL,'2026-02-14 09:02:49','2026-02-14 09:04:12',NULL),(7,1,1,'2026-02-15',624.45,5,NULL,'2026-02-15 06:28:33','2026-02-15 19:50:44',NULL),(8,1,1,'2026-02-16',633.50,6,NULL,'2026-02-16 08:34:19','2026-02-16 16:18:49',NULL),(9,2,2,'2026-02-16',640.39,1,NULL,'2026-02-16 20:34:30','2026-02-16 21:20:12',NULL),(10,1,1,'2026-02-17',655.94,7,NULL,'2026-02-17 07:47:18','2026-02-17 18:29:20',NULL),(11,1,1,'2026-02-18',680.18,8,NULL,'2026-02-18 08:20:03','2026-02-18 20:05:26',NULL),(12,1,1,'2026-02-19',706.43,9,NULL,'2026-02-19 08:40:02','2026-02-19 08:46:19',NULL),(13,1,1,'2026-02-20',720.29,10,NULL,'2026-02-20 06:05:14','2026-02-20 19:50:58',NULL),(14,3,3,'2026-02-20',33499.94,3,NULL,'2026-02-20 09:30:18','2026-02-20 09:33:31',NULL),(15,1,1,'2026-02-21',735.50,11,NULL,'2026-02-21 04:40:37','2026-02-21 04:43:15',NULL),(16,1,1,'2026-02-22',768.29,12,NULL,'2026-02-22 10:18:31','2026-02-22 15:15:01',NULL),(17,1,1,'2026-02-23',773.69,13,NULL,'2026-02-23 07:05:31','2026-02-23 10:19:49',NULL),(18,1,1,'2026-02-24',811.02,14,NULL,'2026-02-24 08:18:35','2026-02-24 19:07:57',NULL),(19,2,2,'2026-02-24',964.38,2,NULL,'2026-02-24 18:58:19','2026-02-24 19:36:30',NULL),(20,1,1,'2026-02-25',837.18,15,NULL,'2026-02-25 03:17:37','2026-02-25 19:12:10',NULL),(21,1,1,'2026-02-26',864.75,16,NULL,'2026-02-26 07:16:15','2026-02-26 12:34:29',NULL),(22,2,2,'2026-02-26',964.38,3,NULL,'2026-02-26 13:10:06','2026-02-26 18:31:09',NULL),(23,1,1,'2026-02-27',893.21,17,NULL,'2026-02-27 08:47:09','2026-02-27 08:59:37',NULL),(24,2,2,'2026-02-27',964.38,4,NULL,'2026-02-27 11:09:01','2026-02-27 11:09:01',NULL),(25,1,1,'2026-02-28',949.99,18,NULL,'2026-02-28 06:16:30','2026-02-28 16:08:54',NULL),(26,2,2,'2026-03-01',964.38,5,NULL,'2026-03-01 13:26:36','2026-03-01 18:57:47',NULL),(27,1,1,'2026-03-02',1002.96,19,NULL,'2026-03-02 08:25:10','2026-03-02 21:20:39',NULL),(28,2,2,'2026-03-02',964.38,6,NULL,'2026-03-02 18:42:26','2026-03-02 18:42:26',NULL),(29,2,2,'2026-03-03',1149.96,7,NULL,'2026-03-03 05:30:29','2026-03-03 09:21:10',NULL),(30,1,1,'2026-03-03',1010.09,20,NULL,'2026-03-03 10:11:44','2026-03-03 18:37:21',NULL),(31,3,3,'2026-03-03',38708.33,4,NULL,'2026-03-03 17:57:48','2026-03-03 17:58:29',NULL),(32,2,2,'2026-03-04',1149.96,8,NULL,'2026-03-04 05:16:46','2026-03-04 05:16:46',NULL),(33,1,1,'2026-03-04',1032.77,21,NULL,'2026-03-04 07:54:59','2026-03-04 11:27:50',NULL),(34,3,3,'2026-03-05',38921.29,5,NULL,'2026-03-05 06:26:23','2026-03-05 18:58:34',NULL),(35,1,1,'2026-03-05',1059.77,22,NULL,'2026-03-05 06:26:43','2026-03-05 20:12:40',NULL),(36,1,1,'2026-03-06',1089.72,23,NULL,'2026-03-06 05:14:42','2026-03-06 16:34:25',NULL),(37,3,3,'2026-03-06',38921.29,6,NULL,'2026-03-06 11:55:12','2026-03-06 16:31:11',NULL),(38,4,5,'2026-03-06',77920.00,1,NULL,'2026-03-06 16:29:57','2026-03-06 16:30:15',NULL),(39,1,1,'2026-03-07',1127.06,24,NULL,'2026-03-07 05:51:11','2026-03-07 19:45:54',NULL),(40,1,1,'2026-03-08',1158.46,25,NULL,'2026-03-08 09:13:49','2026-03-08 09:21:19',NULL),(41,1,1,'2026-03-09',1194.61,26,NULL,'2026-03-09 06:56:40','2026-03-09 20:31:12',NULL),(42,4,5,'2026-03-09',87360.00,2,NULL,'2026-03-09 10:43:10','2026-03-09 10:43:13',NULL),(43,1,1,'2026-03-10',1235.63,27,NULL,'2026-03-10 07:41:21','2026-03-10 17:27:05',NULL),(44,1,1,'2026-03-11',1281.69,28,NULL,'2026-03-11 16:23:26','2026-03-11 18:48:29',NULL),(45,1,1,'2026-03-12',1319.92,29,NULL,'2026-03-12 02:19:26','2026-03-12 18:42:23',NULL),(46,3,3,'2026-03-12',42637.29,7,NULL,'2026-03-12 02:20:20','2026-03-12 02:23:01',NULL),(47,2,2,'2026-03-12',1149.96,9,NULL,'2026-03-12 09:55:15','2026-03-12 09:56:14',NULL),(48,4,5,'2026-03-12',98472.93,3,NULL,'2026-03-12 14:37:14','2026-03-12 18:07:20',NULL),(49,1,1,'2026-03-13',1356.08,30,NULL,'2026-03-13 03:51:36','2026-03-13 12:22:19',NULL),(50,1,1,'2026-03-14',1399.33,31,NULL,'2026-03-14 02:54:13','2026-03-14 10:25:44',NULL),(51,1,1,'2026-03-15',1440.84,32,NULL,'2026-03-15 07:49:52','2026-03-15 13:55:21',NULL),(52,2,2,'2026-03-15',1598.75,10,NULL,'2026-03-15 15:21:48','2026-03-15 16:05:07',NULL),(53,1,1,'2026-03-16',1482.41,33,NULL,'2026-03-16 04:17:37','2026-03-16 18:44:16',NULL),(54,2,2,'2026-03-16',1598.75,11,NULL,'2026-03-16 18:38:15','2026-03-16 18:42:40',NULL),(55,1,1,'2026-03-17',1530.49,34,NULL,'2026-03-17 06:34:35','2026-03-17 19:15:49',NULL),(56,2,2,'2026-03-18',1662.06,12,NULL,'2026-03-18 07:51:18','2026-03-18 13:36:21',NULL),(57,1,1,'2026-03-18',1576.62,35,NULL,'2026-03-18 08:13:01','2026-03-18 19:21:49',NULL),(58,1,1,'2026-03-19',1625.86,36,NULL,'2026-03-19 07:56:34','2026-03-19 18:24:11',NULL),(59,3,3,'2026-03-19',46541.67,8,NULL,'2026-03-19 08:14:30','2026-03-19 08:18:43',NULL),(60,2,2,'2026-03-19',1662.06,13,NULL,'2026-03-19 22:11:58','2026-03-19 22:11:58',NULL),(61,1,1,'2026-03-20',1670.72,37,NULL,'2026-03-20 06:49:51','2026-03-20 21:14:30',NULL),(62,3,3,'2026-03-20',49913.35,9,NULL,'2026-03-20 17:14:49','2026-03-20 21:13:50',NULL),(63,1,1,'2026-03-21',1716.24,38,NULL,'2026-03-21 05:21:46','2026-03-21 13:38:03',NULL),(64,1,1,'2026-03-22',1763.25,39,NULL,'2026-03-22 07:11:14','2026-03-22 07:14:15',NULL),(65,1,1,'2026-03-23',1809.81,40,NULL,'2026-03-23 07:33:45','2026-03-24 09:07:07',NULL),(66,2,2,'2026-03-23',1954.65,14,NULL,'2026-03-23 10:10:33','2026-03-23 16:14:26',NULL),(67,2,2,'2026-03-24',1954.65,15,NULL,'2026-03-24 07:56:20','2026-03-24 07:56:20',NULL),(68,1,1,'2026-03-24',1855.65,41,NULL,'2026-03-24 08:07:36','2026-03-24 08:18:52',NULL),(69,1,1,'2026-03-25',1912.53,42,NULL,'2026-03-25 15:38:59','2026-03-25 18:53:31',NULL),(70,1,1,'2026-03-26',1960.72,43,NULL,'2026-03-26 08:34:19','2026-03-26 17:30:20',NULL),(71,2,2,'2026-03-27',1954.65,16,NULL,'2026-03-27 06:52:10','2026-03-27 06:52:10',NULL),(72,1,1,'2026-03-27',2027.57,44,NULL,'2026-03-27 07:11:47','2026-03-27 18:39:27',NULL),(73,1,1,'2026-03-28',2056.41,45,NULL,'2026-03-28 11:03:18','2026-03-28 17:12:58',NULL),(74,1,1,'2026-03-29',2111.92,46,NULL,'2026-03-29 05:28:43','2026-03-29 17:55:55',NULL),(75,1,1,'2026-03-30',2159.58,47,NULL,'2026-03-30 05:58:06','2026-03-30 21:03:56',NULL),(76,1,1,'2026-03-31',2302.45,48,NULL,'2026-03-31 04:03:50','2026-03-31 18:16:18',NULL),(77,3,3,'2026-03-31',53285.03,10,NULL,'2026-03-31 12:20:57','2026-03-31 13:08:13',NULL),(78,1,1,'2026-04-01',2353.63,49,NULL,'2026-04-01 09:19:00','2026-04-01 13:50:46',NULL),(79,2,2,'2026-04-01',1954.65,17,NULL,'2026-04-01 09:35:20','2026-04-01 09:36:25',NULL),(80,3,3,'2026-04-01',53285.03,11,NULL,'2026-04-01 11:33:42','2026-04-01 11:54:14',NULL),(81,1,1,'2026-04-02',2386.62,50,NULL,'2026-04-02 08:21:06','2026-04-02 08:32:30',NULL),(82,1,1,'2026-04-03',2481.17,51,NULL,'2026-04-03 05:17:09','2026-04-03 19:55:22',NULL),(83,1,1,'2026-04-04',2514.17,52,NULL,'2026-04-04 05:16:32','2026-04-04 05:17:21',NULL),(84,1,1,'2026-04-05',2580.15,53,NULL,'2026-04-05 06:01:18','2026-04-05 14:09:19',NULL),(85,4,5,'2026-04-05',169531.72,4,NULL,'2026-04-05 10:39:32','2026-04-05 10:39:33',NULL),(86,1,1,'2026-04-06',2651.90,54,NULL,'2026-04-06 08:28:42','2026-04-06 16:22:08',NULL),(87,1,1,'2026-04-07',2759.00,55,NULL,'2026-04-07 09:12:29','2026-04-07 20:07:17',NULL),(88,3,3,'2026-04-07',57208.33,12,NULL,'2026-04-07 14:21:24','2026-04-07 14:23:51',NULL),(89,1,1,'2026-04-08',2859.00,56,NULL,'2026-04-08 10:06:17','2026-04-08 11:05:12',NULL),(90,1,1,'2026-04-09',2859.00,57,NULL,'2026-04-09 09:16:50','2026-04-09 12:58:09',NULL),(91,1,1,'2026-04-10',0.00,58,NULL,'2026-04-10 07:32:16','2026-04-10 07:34:24',NULL),(92,3,3,'2026-04-10',57208.33,13,NULL,'2026-04-10 12:53:47','2026-04-10 14:11:14',NULL),(93,1,1,'2026-04-13',0.00,59,NULL,'2026-04-13 18:39:47','2026-04-13 18:46:36',NULL),(94,1,1,'2026-04-14',0.00,60,NULL,'2026-04-14 12:02:54','2026-04-14 12:05:31',NULL),(95,3,3,'2026-04-15',58237.74,14,NULL,'2026-04-15 09:28:43','2026-04-15 20:57:06',NULL),(96,3,3,'2026-04-19',60737.73,15,NULL,'2026-04-19 01:31:03','2026-04-19 01:31:58',NULL),(97,3,3,'2026-04-27',64173.02,16,NULL,'2026-04-27 18:24:10','2026-04-27 18:26:09',NULL),(98,5,1,'2026-04-28',1864.70,1,NULL,'2026-04-28 08:27:48','2026-04-28 10:02:50',NULL),(99,3,3,'2026-05-07',67408.33,17,NULL,'2026-05-07 18:41:07','2026-05-07 18:44:56',NULL),(100,5,1,'2026-05-08',1864.70,2,NULL,'2026-05-08 13:36:41','2026-05-08 14:01:03',NULL),(101,4,5,'2026-05-08',172416.33,5,NULL,'2026-05-08 14:00:51','2026-05-08 14:00:53',NULL);

--
-- Table structure for table `distribution_aliment`
--

CREATE TABLE `distribution_aliment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `aliment_id` int NOT NULL,
  `date` datetime DEFAULT NULL,
  `quantite` float NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `distribution_aliment_bande_id_foreign` (`bande_id`),
  KEY `distribution_aliment_aliment_id_foreign` (`aliment_id`),
  CONSTRAINT `distribution_aliment_aliment_id_foreign` FOREIGN KEY (`aliment_id`) REFERENCES `aliment` (`id`),
  CONSTRAINT `distribution_aliment_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `distribution_aliment`
--

INSERT INTO `distribution_aliment` VALUES (1,1,2,'2026-02-12 00:00:00',5,'active','2026-02-12 19:08:29','2026-02-12 19:08:29','2026-02-12 20:08:29'),(2,3,3,'2026-02-11 00:00:00',105,'active','2026-02-12 19:57:39','2026-02-12 19:57:39','2026-02-12 20:57:39'),(3,3,4,'2026-02-12 00:00:00',5,'active','2026-02-12 19:57:58','2026-02-12 19:57:58','2026-02-12 20:57:58'),(4,1,2,'2026-02-14 00:00:00',5,'active','2026-02-15 06:35:31','2026-02-15 06:35:31','2026-02-15 07:35:31'),(5,1,2,'2026-02-15 00:00:00',5,'active','2026-02-15 17:17:11','2026-02-15 17:17:11','2026-02-15 18:17:11'),(6,1,2,'2026-02-16 00:00:00',5,'active','2026-02-16 08:35:09','2026-02-16 08:35:09','2026-02-16 09:35:09'),(7,2,1,'2026-02-16 00:00:00',50,'active','2026-02-16 21:05:09','2026-02-16 21:05:09','2026-02-16 22:05:09'),(8,1,2,'2026-02-17 00:00:00',5,'active','2026-02-17 07:51:39','2026-02-17 07:51:39','2026-02-17 08:51:39'),(9,1,2,'2026-02-17 00:00:00',5,'active','2026-02-17 16:11:49','2026-02-17 16:11:49','2026-02-17 17:11:49'),(10,1,2,'2026-02-18 00:00:00',5,'active','2026-02-18 08:25:58','2026-02-18 08:25:58','2026-02-18 09:25:58'),(11,1,2,'2026-02-19 00:00:00',15,'active','2026-02-18 08:38:32','2026-02-18 08:38:32','2026-02-18 09:38:32'),(12,1,6,'2026-02-20 00:00:00',10,'active','2026-02-20 06:06:58','2026-02-20 06:06:58','2026-02-20 07:06:58'),(13,3,4,'2026-02-20 00:00:00',37,'active','2026-02-20 09:33:23','2026-02-20 09:33:23','2026-02-20 10:33:23'),(14,1,6,'2026-02-20 00:00:00',2.5,'active','2026-02-20 19:50:54','2026-02-20 19:50:54','2026-02-20 20:50:54'),(15,1,6,'2026-02-21 00:00:00',12.5,'active','2026-02-21 04:41:04','2026-02-21 04:41:04','2026-02-21 05:41:04'),(16,1,6,'2026-02-22 00:00:00',25,'active','2026-02-22 10:18:53','2026-02-22 10:18:53','2026-02-22 11:18:53'),(17,1,6,'2026-02-24 00:00:00',25,'active','2026-02-24 08:21:42','2026-02-24 08:21:42','2026-02-24 09:21:42'),(18,2,5,'2026-02-24 00:00:00',150,'active','2026-02-24 18:59:21','2026-02-24 18:59:21','2026-02-24 19:59:21'),(19,1,6,'2026-02-24 00:00:00',12.5,'active','2026-02-24 19:07:54','2026-02-24 19:07:54','2026-02-24 20:07:54'),(20,1,6,'2026-02-25 00:00:00',12.5,'active','2026-02-25 03:24:01','2026-02-25 03:24:01','2026-02-25 04:24:01'),(21,1,6,'2026-02-26 00:00:00',25,'active','2026-02-26 07:18:22','2026-02-26 07:18:22','2026-02-26 08:18:22'),(22,1,6,'2026-02-27 00:00:00',25,'active','2026-02-27 08:47:32','2026-02-27 08:47:32','2026-02-27 09:47:32'),(23,1,6,'2026-02-28 00:00:00',25,'active','2026-02-28 10:04:04','2026-02-28 10:04:04','2026-02-28 11:04:04'),(24,1,6,'2026-03-01 00:00:00',25,'active','2026-02-28 10:06:55','2026-02-28 10:06:55','2026-02-28 11:06:55'),(25,1,6,'2026-03-02 00:00:00',25,'active','2026-03-02 08:25:31','2026-03-02 08:25:31','2026-03-02 09:25:31'),(26,1,6,'2026-03-02 00:00:00',25,'active','2026-03-02 13:24:26','2026-03-02 13:24:26','2026-03-02 14:24:26'),(27,2,5,'2026-03-02 00:00:00',100,'active','2026-03-03 05:32:03','2026-03-03 05:32:03','2026-03-03 06:32:03'),(28,3,4,'2026-03-03 00:00:00',70,'active','2026-03-03 17:58:23','2026-03-03 17:58:23','2026-03-03 18:58:23'),(29,1,8,'2026-03-04 00:00:00',20,'active','2026-03-04 08:33:35','2026-03-04 08:33:35','2026-03-04 09:33:35'),(30,1,8,'2026-03-05 00:00:00',15,'active','2026-03-05 06:27:37','2026-03-05 06:27:37','2026-03-05 07:27:37'),(31,3,9,'2026-03-05 00:00:00',3,'active','2026-03-05 18:58:28','2026-03-05 18:58:28','2026-03-05 19:58:28'),(32,1,8,'2026-03-06 00:00:00',25,'active','2026-03-06 08:25:39','2026-03-06 08:25:39','2026-03-06 09:25:39'),(33,1,8,'2026-03-07 00:00:00',30,'active','2026-03-07 05:51:38','2026-03-07 05:51:38','2026-03-07 06:51:38'),(34,1,8,'2026-03-08 00:00:00',25,'active','2026-03-08 09:15:53','2026-03-08 09:15:53','2026-03-08 10:15:53'),(35,1,8,'2026-03-09 00:00:00',30,'active','2026-03-09 06:56:59','2026-03-09 06:56:59','2026-03-09 07:56:59'),(36,1,10,'2026-03-10 00:00:00',24,'active','2026-03-10 07:46:25','2026-03-10 07:46:25','2026-03-10 08:46:25'),(37,1,10,'2026-03-11 00:00:00',30,'active','2026-03-11 16:25:11','2026-03-11 16:25:11','2026-03-11 17:25:11'),(38,1,10,'2026-03-11 00:00:00',10,'active','2026-03-11 18:02:09','2026-03-11 18:02:09','2026-03-11 19:02:09'),(39,3,9,'2026-03-12 00:00:00',50,'active','2026-03-12 02:21:28','2026-03-12 02:21:28','2026-03-12 03:21:28'),(40,1,10,'2026-03-12 00:00:00',32,'active','2026-03-12 08:19:32','2026-03-12 08:19:32','2026-03-12 09:19:32'),(41,1,10,'2026-03-13 00:00:00',32,'active','2026-03-13 03:52:04','2026-03-13 03:52:04','2026-03-13 04:52:04'),(42,1,10,'2026-03-14 00:00:00',35,'active','2026-03-14 06:58:18','2026-03-14 06:58:18','2026-03-14 07:58:18'),(43,1,10,'2026-03-15 00:00:00',30,'active','2026-03-15 07:51:16','2026-03-15 07:51:16','2026-03-15 08:51:16'),(44,2,7,'2026-03-15 00:00:00',250,'active','2026-03-15 15:22:58','2026-03-15 15:22:58','2026-03-15 16:22:58'),(45,1,10,'2026-03-16 00:00:00',15.5,'active','2026-03-16 04:18:19','2026-03-16 04:18:19','2026-03-16 05:18:19'),(46,1,10,'2026-03-16 00:00:00',15.5,'active','2026-03-16 18:05:58','2026-03-16 18:05:58','2026-03-16 19:05:58'),(47,1,10,'2026-03-17 00:00:00',40,'active','2026-03-17 06:35:28','2026-03-17 06:35:28','2026-03-17 07:35:28'),(48,1,10,'2026-03-18 00:00:00',10,'active','2026-03-18 08:14:05','2026-03-18 08:14:05','2026-03-18 09:14:05'),(49,1,11,'2026-03-18 00:00:00',30,'active','2026-03-18 08:14:15','2026-03-18 08:14:15','2026-03-18 09:14:15'),(50,2,12,'2026-03-17 00:00:00',25,'active','2026-03-18 10:43:27','2026-03-18 10:43:27','2026-03-18 11:43:27'),(51,1,11,'2026-03-19 00:00:00',40,'active','2026-03-19 08:02:52','2026-03-19 08:02:52','2026-03-19 09:02:52'),(52,3,9,'2026-03-19 00:00:00',55,'active','2026-03-19 08:14:52','2026-03-19 08:14:52','2026-03-19 09:14:52'),(53,1,11,'2026-03-20 00:00:00',40,'active','2026-03-20 06:50:41','2026-03-20 06:50:41','2026-03-20 07:50:41'),(54,3,13,'2026-03-20 00:00:00',55,'active','2026-03-20 21:12:46','2026-03-20 21:12:46','2026-03-20 22:12:46'),(55,1,11,'2026-03-21 00:00:00',40,'active','2026-03-21 05:22:19','2026-03-21 05:22:19','2026-03-21 06:22:19'),(56,1,11,'2026-03-22 00:00:00',40,'active','2026-03-22 07:12:18','2026-03-22 07:12:18','2026-03-22 08:12:18'),(57,1,14,'2026-03-23 00:00:00',40,'active','2026-03-23 07:34:50','2026-03-23 07:34:50','2026-03-23 08:34:50'),(58,2,12,'2026-03-23 00:00:00',150,'active','2026-03-23 10:20:00','2026-03-23 10:20:00','2026-03-23 11:20:00'),(59,1,14,'2026-03-24 00:00:00',40,'active','2026-03-24 08:10:38','2026-03-24 08:10:38','2026-03-24 09:10:38'),(60,1,14,'2026-03-25 00:00:00',40,'active','2026-03-25 15:40:16','2026-03-25 15:40:16','2026-03-25 16:40:16'),(61,1,14,'2026-03-26 00:00:00',40,'active','2026-03-26 09:05:28','2026-03-26 09:05:28','2026-03-26 10:05:28'),(62,1,14,'2026-03-27 00:00:00',24.5,'active','2026-03-27 07:13:30','2026-03-27 07:13:30','2026-03-27 08:13:30'),(63,1,14,'2026-03-27 00:00:00',10,'active','2026-03-27 17:59:54','2026-03-27 17:59:54','2026-03-27 18:59:54'),(64,1,14,'2026-03-28 00:00:00',12.5,'active','2026-03-28 11:04:33','2026-03-28 11:04:33','2026-03-28 12:04:33'),(65,1,14,'2026-03-28 00:00:00',12.5,'active','2026-03-29 05:30:11','2026-03-29 05:30:11','2026-03-29 06:30:11'),(66,1,14,'2026-03-29 00:00:00',12.5,'active','2026-03-29 06:11:54','2026-03-29 06:11:54','2026-03-29 07:11:54'),(67,1,14,'2026-03-29 00:00:00',11,'active','2026-03-29 16:08:02','2026-03-29 16:08:02','2026-03-29 17:08:02'),(68,1,14,'2026-03-30 00:00:00',12.5,'active','2026-03-30 05:58:49','2026-03-30 05:58:49','2026-03-30 06:58:49'),(70,1,14,'2026-03-30 00:00:00',12.5,'active','2026-03-31 09:41:23','2026-03-31 09:41:23','2026-03-31 10:41:23'),(71,1,14,'2026-03-31 00:00:00',12.5,'active','2026-03-31 09:50:30','2026-03-31 09:50:30','2026-03-31 10:50:30'),(72,1,14,'2026-03-31 00:00:00',12.5,'active','2026-03-31 09:53:21','2026-03-31 09:53:21','2026-03-31 10:53:21'),(73,3,13,'2026-03-30 00:00:00',55,'active','2026-03-31 12:22:36','2026-03-31 12:22:36','2026-03-31 13:22:36'),(74,1,14,'2026-04-02 00:00:00',5,'active','2026-04-02 08:22:13','2026-04-02 08:22:13','2026-04-02 09:22:13'),(75,1,14,'2026-04-02 00:00:00',5,'active','2026-04-03 05:17:51','2026-04-03 05:17:51','2026-04-03 06:17:51'),(76,1,14,'2026-04-03 00:00:00',5,'active','2026-04-03 05:18:14','2026-04-03 05:18:14','2026-04-03 06:18:14'),(77,1,14,'2026-04-03 00:00:00',5,'active','2026-04-03 19:53:19','2026-04-03 19:53:19','2026-04-03 20:53:22'),(78,1,14,'2026-04-04 00:00:00',5,'active','2026-04-04 05:17:17','2026-04-04 05:17:17','2026-04-04 06:17:17'),(79,1,14,'2026-04-05 00:00:00',5,'active','2026-04-05 06:02:05','2026-04-05 06:02:05','2026-04-05 07:02:05'),(80,1,14,'2026-04-05 00:00:00',5,'active','2026-04-05 06:02:19','2026-04-05 06:02:19','2026-04-05 07:02:19'),(81,1,14,'2026-04-06 00:00:00',5,'active','2026-04-06 08:29:15','2026-04-06 08:29:15','2026-04-06 09:29:15'),(82,1,14,'2026-04-06 00:00:00',5,'active','2026-04-06 12:18:22','2026-04-06 12:18:22','2026-04-06 13:18:22'),(83,1,14,'2026-04-07 00:00:00',5,'active','2026-04-07 09:28:11','2026-04-07 09:28:11','2026-04-07 10:28:11'),(84,3,13,'2026-04-06 00:00:00',64,'active','2026-04-07 14:22:13','2026-04-07 14:22:13','2026-04-07 15:22:13'),(85,1,16,'2026-04-07 00:00:00',5,'active','2026-04-07 17:52:43','2026-04-07 17:52:43','2026-04-07 18:52:43'),(86,1,16,'2026-04-07 00:00:00',5,'active','2026-04-07 17:53:20','2026-04-07 17:53:20','2026-04-07 18:53:20'),(87,1,16,'2026-04-08 00:00:00',5,'active','2026-04-08 10:06:49','2026-04-08 10:06:49','2026-04-08 11:06:49'),(88,3,17,'2026-04-15 00:00:00',17.5,'active','2026-04-15 18:47:07','2026-04-15 18:47:07','2026-04-15 19:47:07'),(89,3,17,'2026-04-19 00:00:00',42.5,'active','2026-04-19 01:31:45','2026-04-19 01:31:45','2026-04-19 02:31:45'),(90,3,17,'2026-04-27 00:00:00',55,'active','2026-04-27 18:26:04','2026-04-27 18:26:04','2026-04-27 19:26:04'),(91,3,17,'2026-05-07 00:00:00',55,'active','2026-05-07 18:41:48','2026-05-07 18:41:48','2026-05-07 19:41:48');

--
-- Table structure for table `distribution_medicament`
--

CREATE TABLE `distribution_medicament` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `medicament_id` int NOT NULL,
  `dose` float NOT NULL,
  `date` datetime DEFAULT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `distribution_medicament_bande_id_foreign` (`bande_id`),
  KEY `distribution_medicament_medicament_id_foreign` (`medicament_id`),
  CONSTRAINT `distribution_medicament_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `distribution_medicament_medicament_id_foreign` FOREIGN KEY (`medicament_id`) REFERENCES `medicament` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `distribution_medicament`
--

INSERT INTO `distribution_medicament` VALUES (1,1,3,6,'2026-02-08 00:00:00','active','2026-02-09 09:58:28','2026-02-09 09:58:28','2026-02-09 09:58:28'),(2,1,1,1,'2026-02-08 00:00:00','active','2026-02-09 09:58:54','2026-02-09 09:58:54','2026-02-09 09:58:54'),(3,1,2,400,'2026-02-08 00:00:00','active','2026-02-09 09:59:07','2026-02-09 09:59:07','2026-02-09 09:59:07'),(4,1,4,1,'2026-02-11 00:00:00','active','2026-02-12 11:42:18','2026-02-12 11:42:18','2026-02-12 11:42:18'),(5,1,9,72,'2026-02-12 00:00:00','active','2026-02-12 20:09:25','2026-02-12 20:09:25','2026-02-12 20:09:25'),(6,1,12,10,'2026-02-13 00:00:00','active','2026-02-13 19:06:19','2026-02-13 19:06:19','2026-02-13 19:06:19'),(7,1,5,4,'2026-02-13 00:00:00','active','2026-02-13 19:06:35','2026-02-13 19:06:35','2026-02-13 19:06:35'),(8,1,12,15,'2026-02-14 00:00:00','active','2026-02-14 10:03:28','2026-02-14 10:03:28','2026-02-14 10:03:28'),(9,1,8,6,'2026-02-14 00:00:00','active','2026-02-14 10:03:49','2026-02-14 10:03:49','2026-02-14 10:03:49'),(10,1,5,5,'2026-02-14 00:00:00','active','2026-02-14 10:04:09','2026-02-14 10:04:09','2026-02-14 10:04:09'),(11,1,8,8,'2026-02-15 00:00:00','active','2026-02-15 07:31:09','2026-02-15 07:31:09','2026-02-15 07:31:09'),(12,1,5,6,'2026-02-15 00:00:00','active','2026-02-15 07:31:26','2026-02-15 07:31:26','2026-02-15 07:31:26'),(13,1,7,30,'2026-02-15 00:00:00','active','2026-02-15 07:31:48','2026-02-15 07:31:48','2026-02-15 07:31:48'),(14,1,14,1,'2026-02-14 00:00:00','active','2026-02-15 07:33:31','2026-02-15 07:33:31','2026-02-15 07:33:31'),(15,1,8,8,'2026-02-16 00:00:00','active','2026-02-16 09:37:44','2026-02-16 09:37:44','2026-02-16 09:37:44'),(16,1,5,6,'2026-02-16 00:00:00','active','2026-02-16 09:37:57','2026-02-16 09:37:57','2026-02-16 09:37:57'),(17,1,7,30,'2026-02-16 00:00:00','active','2026-02-16 09:38:09','2026-02-16 09:38:09','2026-02-16 09:38:09'),(18,1,11,16,'2026-02-17 00:00:00','active','2026-02-17 08:52:00','2026-02-17 08:52:00','2026-02-17 08:52:00'),(19,1,20,20,'2026-02-17 00:00:00','active','2026-02-17 18:54:27','2026-02-17 18:54:27','2026-02-17 18:54:27'),(20,1,18,6,'2026-02-18 00:00:00','active','2026-02-17 18:54:46','2026-02-17 18:54:46','2026-02-17 18:54:46'),(21,1,20,10,'2026-02-18 00:00:00','active','2026-02-18 09:26:39','2026-02-18 09:26:39','2026-02-18 09:26:39'),(22,1,18,3,'2026-02-18 00:00:00','active','2026-02-18 09:28:03','2026-02-18 09:28:03','2026-02-18 09:28:03'),(23,1,21,1,'2026-02-19 00:00:00','active','2026-02-19 09:42:18','2026-02-19 09:42:18','2026-02-19 09:42:18'),(24,1,20,20,'2026-02-18 00:00:00','active','2026-02-19 09:44:51','2026-02-19 09:44:51','2026-02-19 09:44:51'),(25,1,20,20,'2026-02-19 00:00:00','active','2026-02-19 09:45:04','2026-02-19 09:45:04','2026-02-19 09:45:04'),(26,1,18,6,'2026-02-19 00:00:00','active','2026-02-19 09:45:19','2026-02-19 09:45:19','2026-02-19 09:45:19'),(27,1,20,20,'2026-02-20 00:00:00','active','2026-02-20 07:05:40','2026-02-20 07:05:40','2026-02-20 07:05:40'),(28,1,18,7,'2026-02-20 00:00:00','active','2026-02-20 07:05:52','2026-02-20 07:05:52','2026-02-20 07:05:52'),(29,1,12,20,'2026-02-20 00:00:00','active','2026-02-20 20:49:04','2026-02-20 20:49:04','2026-02-20 20:49:04'),(30,1,4,1,'2026-02-21 00:00:00','active','2026-02-21 05:42:25','2026-02-21 05:42:25','2026-02-21 05:42:25'),(31,1,12,35,'2026-02-22 00:00:00','active','2026-02-22 11:19:17','2026-02-22 11:19:17','2026-02-22 11:19:17'),(32,1,24,1,'2026-02-22 00:00:00','active','2026-02-22 11:20:26','2026-02-22 11:20:26','2026-02-22 11:20:26'),(33,1,8,8,'2026-02-23 00:00:00','active','2026-02-23 08:06:29','2026-02-23 08:06:29','2026-02-23 08:06:29'),(34,1,5,7,'2026-02-23 00:00:00','active','2026-02-23 08:06:44','2026-02-23 08:06:44','2026-02-23 08:06:44'),(35,1,8,16,'2026-02-23 00:00:00','active','2026-02-24 09:27:22','2026-02-24 09:27:22','2026-02-24 09:27:22'),(36,1,5,12,'2026-02-23 00:00:00','active','2026-02-24 09:27:47','2026-02-24 09:27:47','2026-02-24 09:27:47'),(37,1,8,8,'2026-02-24 00:00:00','active','2026-02-24 20:07:17','2026-02-24 20:07:17','2026-02-24 20:07:17'),(38,1,5,6,'2026-02-24 00:00:00','active','2026-02-24 20:07:32','2026-02-24 20:07:32','2026-02-24 20:07:32'),(39,2,17,1,'2026-02-16 00:00:00','active','2026-02-24 20:08:14','2026-02-24 20:08:14','2026-02-24 20:08:14'),(40,2,25,1,'2026-02-19 00:00:00','active','2026-02-24 20:08:48','2026-02-24 20:08:48','2026-02-24 20:08:48'),(41,2,16,25,'2026-02-23 00:00:00','active','2026-02-24 20:09:27','2026-02-24 20:09:27','2026-02-24 20:09:27'),(42,2,15,25,'2026-02-10 00:00:00','active','2026-02-24 20:10:11','2026-02-24 20:10:11','2026-02-24 20:10:11'),(43,2,26,1,'2026-02-21 00:00:00','active','2026-02-24 20:13:34','2026-02-24 20:13:34','2026-02-24 20:13:34'),(44,2,28,1,'2026-02-24 00:00:00','active','2026-02-24 20:33:21','2026-02-24 20:33:21','2026-02-24 20:33:21'),(45,2,27,1,'2026-02-19 00:00:00','active','2026-02-24 20:33:41','2026-02-24 20:33:41','2026-02-24 20:33:41'),(46,1,29,1,'2026-02-25 00:00:00','active','2026-02-25 20:11:27','2026-02-25 20:11:27','2026-02-25 20:11:27'),(47,1,12,30,'2026-02-25 00:00:00','active','2026-02-25 20:11:47','2026-02-25 20:11:47','2026-02-25 20:11:47'),(48,1,8,4,'2026-02-25 00:00:00','active','2026-02-26 08:16:56','2026-02-26 08:16:56','2026-02-26 08:16:56'),(49,1,5,3,'2026-02-25 00:00:00','active','2026-02-26 08:17:14','2026-02-26 08:17:14','2026-02-26 08:17:14'),(50,1,19,24,'2026-02-26 00:00:00','active','2026-02-26 08:17:28','2026-02-26 08:17:28','2026-02-26 08:17:28'),(51,1,8,16,'2026-02-26 00:00:00','active','2026-02-26 08:17:41','2026-02-26 08:17:41','2026-02-26 08:17:41'),(52,1,5,12,'2026-02-26 00:00:00','active','2026-02-26 08:18:05','2026-02-26 08:18:05','2026-02-26 08:18:05'),(53,1,19,40,'2026-02-27 00:00:00','active','2026-02-27 09:48:27','2026-02-27 09:48:27','2026-02-27 09:48:27'),(54,1,8,16,'2026-02-27 00:00:00','active','2026-02-27 09:48:46','2026-02-27 09:48:46','2026-02-27 09:48:46'),(55,1,5,10,'2026-02-27 00:00:00','active','2026-02-27 09:49:03','2026-02-27 09:49:03','2026-02-27 09:49:03'),(56,1,19,36,'2026-02-28 00:00:00','active','2026-02-28 11:04:40','2026-02-28 11:04:40','2026-02-28 11:04:40'),(57,1,7,15,'2026-02-27 00:00:00','active','2026-02-28 11:04:59','2026-02-28 11:04:59','2026-02-28 11:04:59'),(58,1,8,6,'2026-02-27 00:00:00','active','2026-02-28 11:05:12','2026-02-28 11:05:12','2026-02-28 11:05:12'),(59,1,8,8,'2026-02-28 00:00:00','active','2026-02-28 11:05:32','2026-02-28 11:05:32','2026-02-28 11:05:32'),(60,1,7,20,'2026-02-28 00:00:00','active','2026-02-28 11:05:49','2026-02-28 11:05:49','2026-02-28 11:05:49'),(61,1,8,16,'2026-02-28 00:00:00','active','2026-02-28 17:08:13','2026-02-28 17:08:13','2026-02-28 17:08:13'),(62,1,7,40,'2026-02-28 00:00:00','active','2026-02-28 17:08:35','2026-02-28 17:08:35','2026-02-28 17:08:35'),(63,1,5,10,'2026-02-28 00:00:00','active','2026-02-28 17:08:51','2026-02-28 17:08:51','2026-02-28 17:08:51'),(64,1,7,40,'2026-03-02 00:00:00','active','2026-03-02 09:26:11','2026-03-02 09:26:11','2026-03-02 09:26:11'),(65,1,5,10,'2026-03-02 00:00:00','active','2026-03-02 09:26:25','2026-03-02 09:26:25','2026-03-02 09:26:25'),(66,1,8,16,'2026-03-02 00:00:00','active','2026-03-02 09:26:41','2026-03-02 09:26:41','2026-03-02 09:26:41'),(67,1,7,60,'2026-03-02 00:00:00','active','2026-03-02 22:17:13','2026-03-02 22:17:13','2026-03-02 22:17:13'),(68,1,5,15,'2026-03-02 00:00:00','active','2026-03-02 22:20:16','2026-03-02 22:20:16','2026-03-02 22:20:16'),(69,1,8,24,'2026-03-02 00:00:00','active','2026-03-02 22:20:35','2026-03-02 22:20:35','2026-03-02 22:20:35'),(70,2,31,30,'2026-03-03 00:00:00','active','2026-03-03 09:34:03','2026-03-03 09:34:03','2026-03-03 09:34:03'),(71,2,32,10,'2026-03-03 00:00:00','active','2026-03-03 09:34:26','2026-03-03 09:34:26','2026-03-03 09:34:26'),(72,1,8,22,'2026-03-03 00:00:00','active','2026-03-03 19:36:48','2026-03-03 19:36:48','2026-03-03 19:36:48'),(73,1,7,55,'2026-03-03 00:00:00','active','2026-03-03 19:37:03','2026-03-03 19:37:03','2026-03-03 19:37:03'),(74,1,5,27,'2026-03-03 00:00:00','active','2026-03-03 19:37:17','2026-03-03 19:37:17','2026-03-03 19:37:17'),(75,1,8,25,'2026-03-04 00:00:00','active','2026-03-04 09:05:06','2026-03-04 09:05:06','2026-03-04 09:05:06'),(76,1,12,40,'2026-03-04 00:00:00','active','2026-03-05 07:28:02','2026-03-05 07:28:02','2026-03-05 07:28:02'),(77,1,12,20,'2026-03-05 00:00:00','active','2026-03-05 10:08:56','2026-03-05 10:08:56','2026-03-05 10:08:56'),(78,1,12,20,'2026-03-04 00:00:00','active','2026-03-05 10:09:20','2026-03-05 10:09:20','2026-03-05 10:09:20'),(79,1,12,40,'2026-03-05 00:00:00','active','2026-03-05 19:53:38','2026-03-05 19:53:38','2026-03-05 19:53:38'),(80,1,12,10,'2026-03-06 00:00:00','active','2026-03-06 09:24:52','2026-03-06 09:24:52','2026-03-06 09:24:52'),(81,1,8,24,'2026-03-07 00:00:00','active','2026-03-07 20:45:49','2026-03-07 20:45:49','2026-03-07 20:45:49'),(82,1,8,24,'2026-03-07 00:00:00','active','2026-03-08 10:15:25','2026-03-08 10:15:25','2026-03-08 10:15:25'),(83,1,8,8,'2026-03-09 00:00:00','active','2026-03-09 07:57:38','2026-03-09 07:57:38','2026-03-09 07:57:38'),(84,1,6,218,'2026-03-09 00:00:00','active','2026-03-10 08:44:00','2026-03-10 08:44:00','2026-03-10 08:44:00'),(85,1,10,60,'2026-03-09 00:00:00','active','2026-03-10 08:44:18','2026-03-10 08:44:18','2026-03-10 08:44:18'),(86,1,10,60,'2026-03-10 00:00:00','active','2026-03-10 17:34:36','2026-03-10 17:34:36','2026-03-10 17:34:36'),(87,1,10,30,'2026-03-11 00:00:00','active','2026-03-11 17:23:51','2026-03-11 17:23:51','2026-03-11 17:23:51'),(88,3,23,2,'2026-03-10 00:00:00','active','2026-03-12 03:22:35','2026-03-12 03:22:35','2026-03-12 03:22:35'),(89,1,12,60,'2026-03-12 00:00:00','active','2026-03-12 19:06:37','2026-03-12 19:06:37','2026-03-12 19:06:37'),(90,1,13,24,'2026-03-14 00:00:00','active','2026-03-14 07:57:47','2026-03-14 07:57:47','2026-03-14 07:57:47'),(91,1,8,24,'2026-03-14 00:00:00','active','2026-03-15 08:50:40','2026-03-15 08:50:40','2026-03-15 08:50:40'),(92,1,33,1,'2026-03-15 00:00:00','active','2026-03-15 13:19:22','2026-03-15 13:19:22','2026-03-15 13:19:22'),(93,1,7,60,'2026-03-16 00:00:00','active','2026-03-16 08:22:48','2026-03-16 08:22:48','2026-03-16 08:22:48'),(94,1,7,60,'2026-03-16 00:00:00','active','2026-03-16 19:05:31','2026-03-16 19:05:31','2026-03-16 19:05:31'),(95,1,8,40,'2026-03-15 00:00:00','active','2026-03-16 19:43:21','2026-03-16 19:43:21','2026-03-16 19:43:21'),(96,1,7,40,'2026-03-17 00:00:00','active','2026-03-17 07:34:52','2026-03-17 07:34:52','2026-03-17 07:34:52'),(97,1,7,60,'2026-03-17 00:00:00','active','2026-03-17 18:44:49','2026-03-17 18:44:49','2026-03-17 18:44:49'),(98,1,7,60,'2026-03-18 00:00:00','active','2026-03-18 09:13:29','2026-03-18 09:13:29','2026-03-18 09:13:29'),(99,1,10,70,'2026-03-19 00:00:00','active','2026-03-19 19:23:36','2026-03-19 19:23:36','2026-03-19 19:23:36'),(100,1,10,10,'2026-03-20 00:00:00','active','2026-03-20 07:50:15','2026-03-20 07:50:15','2026-03-20 07:50:15'),(101,1,34,18,'2026-03-21 00:00:00','active','2026-03-21 14:20:22','2026-03-21 14:20:22','2026-03-21 14:20:22'),(102,1,34,15,'2026-03-22 00:00:00','active','2026-03-22 08:11:31','2026-03-22 08:11:31','2026-03-22 08:11:31'),(103,1,7,60,'2026-03-22 00:00:00','active','2026-03-22 08:11:52','2026-03-22 08:11:52','2026-03-22 08:11:52'),(104,1,34,10,'2026-03-23 00:00:00','active','2026-03-23 08:34:11','2026-03-23 08:34:11','2026-03-23 08:34:11'),(105,1,7,40,'2026-03-23 00:00:00','active','2026-03-23 08:34:25','2026-03-23 08:34:25','2026-03-23 08:34:25'),(106,2,15,75,'2026-03-11 00:00:00','active','2026-03-23 11:13:28','2026-03-23 11:13:28','2026-03-23 11:13:28'),(107,2,35,50,'2026-03-22 00:00:00','active','2026-03-23 11:19:33','2026-03-23 11:19:33','2026-03-23 11:19:33'),(109,1,7,70,'2026-03-23 00:00:00','active','2026-03-23 20:47:21','2026-03-23 20:47:21','2026-03-23 20:47:21'),(110,1,34,17,'2026-03-23 00:00:00','active','2026-03-24 09:08:15','2026-03-24 09:08:15','2026-03-24 09:08:15'),(111,1,34,10,'2026-03-24 00:00:00','active','2026-03-24 09:08:56','2026-03-24 09:08:56','2026-03-24 09:08:56'),(112,1,7,40,'2026-03-24 00:00:00','active','2026-03-24 09:09:21','2026-03-24 09:09:21','2026-03-24 09:09:21'),(113,1,34,10,'2026-03-25 00:00:00','active','2026-03-25 16:39:19','2026-03-25 16:39:19','2026-03-25 16:39:19'),(114,1,7,40,'2026-03-24 00:00:00','active','2026-03-25 16:39:32','2026-03-25 16:39:32','2026-03-25 16:39:32'),(115,1,34,10,'2026-03-25 00:00:00','active','2026-03-25 16:39:47','2026-03-25 16:39:47','2026-03-25 16:39:47'),(116,1,7,40,'2026-03-25 00:00:00','active','2026-03-25 16:39:58','2026-03-25 16:39:58','2026-03-25 16:39:58'),(117,1,34,10,'2026-03-25 00:00:00','active','2026-03-25 19:53:09','2026-03-25 19:53:09','2026-03-25 19:53:09'),(118,1,7,80,'2026-03-25 00:00:00','active','2026-03-25 19:53:19','2026-03-25 19:53:19','2026-03-25 19:53:19'),(119,1,36,30,'2026-03-26 00:00:00','active','2026-03-26 10:03:50','2026-03-26 10:03:50','2026-03-26 10:03:50'),(120,1,34,15,'2026-03-26 00:00:00','active','2026-03-26 10:04:08','2026-03-26 10:04:08','2026-03-26 10:04:08'),(121,1,36,40,'2026-03-26 00:00:00','active','2026-03-26 18:14:02','2026-03-26 18:14:02','2026-03-26 18:14:02'),(122,1,34,20,'2026-03-26 00:00:00','active','2026-03-26 18:14:28','2026-03-26 18:14:28','2026-03-26 18:14:28'),(123,1,36,10,'2026-03-27 00:00:00','active','2026-03-27 08:12:05','2026-03-27 08:12:05','2026-03-27 08:12:05'),(124,1,34,10,'2026-03-27 00:00:00','active','2026-03-27 08:12:15','2026-03-27 08:12:15','2026-03-27 08:12:15'),(125,1,36,20,'2026-03-28 00:00:00','active','2026-03-27 18:59:32','2026-03-27 18:59:32','2026-03-27 18:59:32'),(126,1,34,5,'2026-03-27 00:00:00','active','2026-03-28 12:03:44','2026-03-28 12:03:44','2026-03-28 12:03:44'),(127,1,36,10,'2026-03-28 00:00:00','active','2026-03-28 12:03:57','2026-03-28 12:03:57','2026-03-28 12:03:57'),(128,1,36,10,'2026-03-28 00:00:00','active','2026-03-29 07:10:50','2026-03-29 07:10:50','2026-03-29 07:10:50'),(129,1,36,20,'2026-03-29 00:00:00','active','2026-03-29 17:03:58','2026-03-29 17:03:58','2026-03-29 17:03:58'),(130,1,36,25,'2026-03-30 00:00:00','active','2026-03-30 06:58:30','2026-03-30 06:58:30','2026-03-30 06:58:30'),(131,1,36,20,'2026-03-30 00:00:00','active','2026-03-30 22:01:58','2026-03-30 22:01:58','2026-03-30 22:01:58'),(132,1,36,15,'2026-03-30 00:00:00','active','2026-03-31 05:18:47','2026-03-31 05:18:47','2026-03-31 05:18:47'),(133,1,37,10,'2026-04-01 00:00:00','active','2026-04-02 09:21:54','2026-04-02 09:21:54','2026-04-02 09:21:54'),(134,1,37,10,'2026-04-02 00:00:00','active','2026-04-03 06:17:31','2026-04-03 06:17:31','2026-04-03 06:17:31'),(135,1,37,10,'2026-04-03 00:00:00','active','2026-04-04 06:16:53','2026-04-04 06:16:53','2026-04-04 06:16:53'),(136,1,37,10,'2026-04-04 00:00:00','active','2026-04-05 07:01:37','2026-04-05 07:01:37','2026-04-05 07:01:37'),(137,1,37,10,'2026-04-05 00:00:00','active','2026-04-05 15:08:09','2026-04-05 15:08:09','2026-04-05 15:08:09'),(138,1,37,10,'2026-04-06 00:00:00','active','2026-04-06 17:20:19','2026-04-06 17:20:19','2026-04-06 17:20:19'),(139,1,37,10,'2026-04-07 00:00:00','active','2026-04-07 18:52:25','2026-04-07 18:52:25','2026-04-07 18:52:25'),(140,3,38,300,'2026-04-23 00:00:00','active','2026-04-27 19:25:36','2026-04-27 19:25:36','2026-04-27 19:25:36');

--
-- Table structure for table `ferme`
--

CREATE TABLE `ferme` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` text COLLATE utf8mb4_general_ci NOT NULL,
  `localisation` text COLLATE utf8mb4_general_ci NOT NULL,
  `utilisateur_id` int NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `ferme_utilisateur_id_foreign` (`utilisateur_id`),
  CONSTRAINT `ferme_utilisateur_id_foreign` FOREIGN KEY (`utilisateur_id`) REFERENCES `utilisateur` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `ferme`
--

INSERT INTO `ferme` VALUES (1,'Ferme Cyrusien','Ndiengdam',1,'active','2026-02-09 08:47:29','2026-02-09 08:47:29','2026-02-09 09:47:29'),(2,'Brice simo','Melam',2,'active','2026-02-12 17:50:07','2026-02-12 17:50:07','2026-02-12 18:50:07'),(3,'Porc de race','Ndiengdam',3,'active','2026-02-12 19:22:11','2026-02-12 19:22:11','2026-02-12 20:22:11'),(4,'ma ferme','Bafoussam',4,'active','2026-02-13 17:54:45','2026-02-13 17:54:45','2026-02-13 18:54:45'),(5,'Pig Farms','Ndiengdam',1,'active','2026-03-06 11:50:53','2026-03-06 11:50:53','2026-03-06 12:50:53');

--
-- Table structure for table `investissement`
--

CREATE TABLE `investissement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `actionnaire_id` int NOT NULL,
  `montant_investi` float NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `investissement_bande_id_foreign` (`bande_id`),
  KEY `investissement_actionnaire_id_foreign` (`actionnaire_id`),
  CONSTRAINT `investissement_actionnaire_id_foreign` FOREIGN KEY (`actionnaire_id`) REFERENCES `actionnaire` (`id`),
  CONSTRAINT `investissement_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `investissement`
--


--
-- Table structure for table `materiel`
--

CREATE TABLE `materiel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` text COLLATE utf8mb4_general_ci NOT NULL,
  `cout` float NOT NULL,
  `date_acquisition` datetime DEFAULT NULL,
  `ferme_id` int NOT NULL,
  `bande_id` int NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `materiel_ferme_id_foreign` (`ferme_id`),
  KEY `materiel_bande_id_foreign` (`bande_id`),
  CONSTRAINT `materiel_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `materiel_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `materiel`
--


--
-- Table structure for table `medicament`
--

CREATE TABLE `medicament` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` text COLLATE utf8mb4_general_ci NOT NULL,
  `prix_unitaire` float NOT NULL,
  `quantite` float DEFAULT NULL,
  `total` float DEFAULT NULL,
  `type` text COLLATE utf8mb4_general_ci,
  `ferme_id` int NOT NULL,
  `id_bande` int DEFAULT '1',
  `statut` enum('active','terminer','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `medicament_ferme_id_foreign` (`ferme_id`),
  CONSTRAINT `medicament_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `medicament`
--

INSERT INTO `medicament` VALUES (1,'Javal',525,2,1050,'Désinfectant',1,1,'active','2026-02-09 09:56:23','2026-02-09 09:56:23','2026-02-09 09:56:23'),(2,'Tripuricide',10.5,1000,10500,'Désinfectant',1,1,'active','2026-02-09 09:57:02','2026-02-09 09:57:02','2026-02-09 09:57:02'),(3,'Détergent',50,10,500,'Désinfectant',1,1,'active','2026-02-09 09:57:39','2026-02-09 09:57:39','2026-02-09 09:57:39'),(4,'Copeaux',1250,2,2500,'Chauffage',1,1,'terminer','2026-02-12 11:17:41','2026-02-21 05:42:25','2026-02-12 11:17:41'),(5,'AMIN TOTAL',20,133,2660,'VITAMINE',1,1,'terminer','2026-02-12 11:24:59','2026-03-03 19:37:17','2026-02-12 11:24:59'),(6,'GREEN FEED',8,418,3344,'BOOSTER',1,1,'active','2026-02-12 11:27:36','2026-02-12 11:27:36','2026-02-12 11:27:36'),(7,'OLIGOPHOS',7.5,940,7050,'MINERAUX',1,1,'terminer','2026-02-12 11:28:27','2026-03-25 19:53:19','2026-02-12 11:28:27'),(8,'FAST GROWTH',20,327,6540,'BOOSTER',1,1,'terminer','2026-02-12 11:29:15','2026-03-16 19:43:21','2026-02-12 11:29:15'),(9,'PRODUIT ZANGO',40,72,2880,'DESINFECTANT',1,1,'terminer','2026-02-12 11:30:00','2026-02-12 20:09:25','2026-02-12 11:30:00'),(10,'KEPCOX',19,550,10450,'ANTICOCCIDIEN',1,1,'active','2026-02-12 11:30:51','2026-02-12 11:30:51','2026-02-12 11:30:51'),(11,'AMAKSIN',35,90,3150,'ANTIBIOTIQUE',1,1,'active','2026-02-12 11:31:44','2026-02-12 11:31:44','2026-02-12 11:31:44'),(12,'LIVORAL',9,300,2700,'DIURETIQUE',1,1,'terminer','2026-02-12 11:32:59','2026-03-12 19:06:37','2026-02-12 11:32:59'),(13,'LEVASOL',40,24,960,'VERMIFUGE',1,1,'terminer','2026-02-12 11:34:15','2026-03-14 07:57:47','2026-02-12 11:34:15'),(14,'1 sac charbon',8000,1,8000,'Chauffage',1,1,'terminer','2026-02-15 07:32:56','2026-02-15 07:33:31','2026-02-15 07:32:56'),(15,'Oxy',35,100,3500,'Oxytetracycline',2,2,'terminer','2026-02-16 22:00:23','2026-03-23 11:13:28','2026-02-16 22:00:23'),(16,'Cox',40,25,1000,'Anticox',2,2,'terminer','2026-02-16 22:00:56','2026-02-24 20:09:27','2026-02-16 22:00:56'),(17,'Vacc',3500,1,3500,'Vaccin Newcastle',2,2,'terminer','2026-02-16 22:02:51','2026-02-24 20:08:14','2026-02-16 22:02:51'),(18,'COLISTIN 4800 WSP',30,100,3000,'ANTIBIOTIQUE',1,1,'active','2026-02-17 08:52:41','2026-02-17 08:52:41','2026-02-17 08:52:41'),(19,'AMPROLIUM',30,100,3000,'ANTICOCCIDIEN',1,1,'terminer','2026-02-17 08:52:58','2026-02-28 11:04:40','2026-02-17 08:52:58'),(20,'Vitamine E-selenium',20,100,2000,'Antibiotique',1,1,'active','2026-02-17 17:11:32','2026-02-17 17:11:32','2026-02-17 17:11:32'),(21,'1 Sac de charbon',8000,1,8000,'Chauffage',1,1,'terminer','2026-02-18 17:10:30','2026-02-19 09:42:18','2026-02-18 17:10:30'),(23,'Vermifuge',250,2,500,'Vermifuge',3,3,'terminer','2026-02-20 10:31:52','2026-03-12 03:22:35','2026-02-20 10:31:52'),(24,'BIL Newcastle+Bronchite ',3000,1,3000,'Vaccin',1,1,'terminer','2026-02-22 11:20:05','2026-02-22 11:20:26','2026-02-22 11:20:05'),(25,'Gomboro',3000,1,3000,'Vaccin gomboro',2,2,'terminer','2026-02-24 20:06:38','2026-02-24 20:08:48','2026-02-24 20:06:38'),(26,'Charbon',4000,1,4000,'Charbon',2,2,'terminer','2026-02-24 20:12:49','2026-02-24 20:13:34','2026-02-24 20:12:49'),(27,'Elec',4500,1,4500,'Électricité',2,2,'terminer','2026-02-24 20:31:09','2026-02-24 20:33:41','2026-02-24 20:31:09'),(28,'Cop',1500,1,1500,'Copeaux',2,2,'terminer','2026-02-24 20:31:34','2026-02-24 20:33:21','2026-02-24 20:31:34'),(29,'Gumboro',3000,1,3000,'Vaccin',1,1,'terminer','2026-02-25 20:11:05','2026-02-25 20:11:27','2026-02-25 20:11:05'),(30,'Oxy tétracycline 50%',32.5,80,2600,'Antibiotique',1,1,'active','2026-02-26 13:34:25','2026-02-26 13:34:25','2026-02-26 13:34:25'),(31,'Oli',7.4,1000,7400,'Oligo phos',2,2,'active','2026-03-03 09:32:55','2026-03-03 09:32:55','2026-03-03 09:32:55'),(32,'Amin',20,150,3000,'Amin total',2,2,'active','2026-03-03 09:33:24','2026-03-03 09:33:24','2026-03-03 09:33:24'),(33,'Copeau',1500,1,1500,'Copeau',1,1,'terminer','2026-03-15 13:18:46','2026-03-15 13:19:22','2026-03-15 13:18:46'),(34,'AminTotal',20,150,3000,'Vitamine',1,1,'terminer','2026-03-21 14:19:27','2026-03-28 12:03:44','2026-03-21 14:19:27'),(35,'toux',45,100,4500,'toux',2,2,'active','2026-03-23 11:18:58','2026-03-23 11:18:58','2026-03-23 11:18:58'),(36,'BOOSTER CROISSANCE',10,200,2000,'BOOSTER',1,1,'terminer','2026-03-26 09:52:30','2026-03-31 05:18:47','2026-03-26 09:52:30'),(37,'Vitamine',10,100,1000,'Vitamine',1,1,'active','2026-04-02 09:21:32','2026-04-02 09:21:32','2026-04-02 09:21:32'),(38,'Désinfectant',2,1000,2000,'Désinfectant',3,3,'active','2026-04-27 19:25:11','2026-04-27 19:25:11','2026-04-27 19:25:11');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `version` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `class` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `group` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `namespace` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `time` int NOT NULL,
  `batch` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (75,'2025-05-28-112030','App\\Database\\Migrations\\Utilisateur','default','App',1770626232,1),(76,'2025-05-28-112040','App\\Database\\Migrations\\Ferme','default','App',1770626232,1),(77,'2025-05-28-112054','App\\Database\\Migrations\\Bande','default','App',1770626232,1),(78,'2025-05-28-112201','App\\Database\\Migrations\\Vente','default','App',1770626232,1),(79,'2025-05-28-112211','App\\Database\\Migrations\\Stock','default','App',1770626232,1),(80,'2025-05-28-112338','App\\Database\\Migrations\\Actionnaire','default','App',1770626232,1),(81,'2025-05-28-112352','App\\Database\\Migrations\\PartageBenefice','default','App',1770626233,1),(82,'2025-05-28-112403','App\\Database\\Migrations\\Materiel','default','App',1770626233,1),(83,'2025-05-28-112414','App\\Database\\Migrations\\Aliment','default','App',1770626233,1),(84,'2025-05-28-112429','App\\Database\\Migrations\\Reinvestissement','default','App',1770626233,1),(85,'2025-05-28-112445','App\\Database\\Migrations\\Medicament','default','App',1770626233,1),(86,'2025-05-28-112502','App\\Database\\Migrations\\DistributionAliment','default','App',1770626233,1),(87,'2025-05-28-112533','App\\Database\\Migrations\\StockMedicament','default','App',1770626233,1),(88,'2025-05-28-112548','App\\Database\\Migrations\\AdministrationTraitement','default','App',1770626233,1),(89,'2025-05-28-153558','App\\Database\\Migrations\\Investissement','default','App',1770626233,1),(90,'2025-06-10-110646','App\\Database\\Migrations\\AlterBande','default','App',1770626233,1),(91,'2025-06-10-112508','App\\Database\\Migrations\\AlterBande2','default','App',1770626233,1),(92,'2025-06-24-091957','App\\Database\\Migrations\\AlterAliment','default','App',1770626233,1),(93,'2025-06-24-094708','App\\Database\\Migrations\\Mortalite','default','App',1770626233,1),(94,'2025-06-24-100123','App\\Database\\Migrations\\AlterBande3','default','App',1770626233,1),(95,'2025-06-25-092334','App\\Database\\Migrations\\AlterMortalite','default','App',1770626233,1),(96,'2025-07-03-084135','App\\Database\\Migrations\\AlterMedicament','default','App',1770626233,1),(97,'2026-01-30-101200','App\\Database\\Migrations\\CoutProductionBande','default','App',1770626233,1),(98,'2026-01-30-111500','App\\Database\\Migrations\\BeneficeVenteBande','default','App',1770626233,1),(99,'2026-01-30-120500','App\\Database\\Migrations\\AlterBeneficeVenteBandeAddQuantite','default','App',1770626233,1),(100,'2026-02-04-121500','App\\Database\\Migrations\\AlterVenteAddFermeId','default','App',1770626233,1),(101,'2026-02-04-121800','App\\Database\\Migrations\\AlterBeneficeAddPrixUnitaire','default','App',1770626233,1),(102,'2026-02-04-122050','App\\Database\\Migrations\\AlterVenteAddPrixUnitaireTotalVente','default','App',1770626233,1);

--
-- Table structure for table `mortalite`
--

CREATE TABLE `mortalite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `date_mortalite` date NOT NULL,
  `nombre` int NOT NULL,
  `quantite_ancien` int DEFAULT NULL,
  `quantite_restant` int DEFAULT NULL,
  `cause` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mortalite_bande_id_foreign` (`bande_id`),
  CONSTRAINT `mortalite_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `mortalite`
--

INSERT INTO `mortalite` VALUES (1,1,'2026-02-13',1,364,363,'Chauffage','2026-02-13 08:02:46','2026-02-13 08:02:46',NULL),(2,1,'2026-02-13',1,363,362,'Frois','2026-02-13 19:05:57','2026-02-13 19:05:57',NULL),(3,1,'2026-02-13',1,363,362,'Malformations','2026-02-13 19:43:38','2026-02-13 19:43:38',NULL),(4,1,'2026-02-14',4,363,359,'Chauffage','2026-02-14 10:03:09','2026-02-14 10:03:09',NULL),(5,1,'2026-02-14',4,359,355,'Froid','2026-02-15 07:29:46','2026-02-15 07:29:46',NULL),(6,1,'2026-02-15',5,355,350,'Froid','2026-02-15 07:30:37','2026-02-15 07:30:37',NULL),(7,1,'2026-02-15',1,350,349,'Ras','2026-02-15 18:16:42','2026-02-15 18:16:42',NULL),(8,1,'2026-02-16',1,350,349,'Froid','2026-02-16 09:34:52','2026-02-16 09:34:52',NULL),(9,1,'2026-02-16',1,349,348,'Pattes','2026-02-16 17:19:04','2026-02-16 17:19:04',NULL),(10,1,'2026-02-17',1,348,347,'RAS','2026-02-17 08:51:17','2026-02-17 08:51:17',NULL),(11,1,'2026-02-17',2,347,345,'Ras','2026-02-17 17:12:08','2026-02-17 17:12:08',NULL),(12,1,'2026-02-22',2,347,345,'Inconnu','2026-02-23 08:05:55','2026-02-23 08:05:55',NULL),(13,2,'2026-02-19',2,203,201,'Ras','2026-02-24 20:01:23','2026-02-24 20:01:23',NULL),(14,1,'2026-02-24',2,345,343,'Inconnu ','2026-02-25 04:18:27','2026-02-25 04:18:27',NULL),(15,1,'2026-02-27',1,343,342,'Ras','2026-02-28 11:03:35','2026-02-28 11:03:35',NULL),(16,2,'2026-03-02',2,201,199,'Paralyzed','2026-03-03 06:34:08','2026-03-03 06:34:08',NULL),(17,1,'2026-03-02',1,342,341,'Étouffement ','2026-03-03 19:00:16','2026-03-03 19:00:16',NULL),(18,1,'2026-03-05',2,341,339,'Ras','2026-03-05 07:27:00','2026-03-05 07:27:00',NULL),(19,2,'2026-03-17',2,199,197,'raz','2026-03-18 11:43:52','2026-03-18 11:43:52',NULL),(20,1,'2026-03-25',1,339,338,'Ras','2026-03-25 19:52:35','2026-03-25 19:52:35',NULL),(21,1,'2026-03-31',1,338,337,'introuvable','2026-04-01 10:21:44','2026-04-01 10:21:44',NULL);

--
-- Table structure for table `reinvestissement`
--

CREATE TABLE `reinvestissement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `actionnaire_id` int NOT NULL,
  `montant` float NOT NULL,
  `bande_id` int NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `reinvestissement_actionnaire_id_foreign` (`actionnaire_id`),
  KEY `reinvestissement_bande_id_foreign` (`bande_id`),
  CONSTRAINT `reinvestissement_actionnaire_id_foreign` FOREIGN KEY (`actionnaire_id`) REFERENCES `actionnaire` (`id`),
  CONSTRAINT `reinvestissement_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `reinvestissement`
--


--
-- Table structure for table `stock`
--

CREATE TABLE `stock` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `ferme_id` int NOT NULL,
  `quantite` float NOT NULL,
  `type` text COLLATE utf8mb4_general_ci NOT NULL,
  `nom_produit` text COLLATE utf8mb4_general_ci NOT NULL,
  `prix_achat` float NOT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `stock_bande_id_foreign` (`bande_id`),
  KEY `stock_ferme_id_foreign` (`ferme_id`),
  CONSTRAINT `stock_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `stock_ferme_id_foreign` FOREIGN KEY (`ferme_id`) REFERENCES `ferme` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock`
--


--
-- Table structure for table `stock_medicament`
--

CREATE TABLE `stock_medicament` (
  `id` int NOT NULL AUTO_INCREMENT,
  `medicament_id` int NOT NULL,
  `bande_id` int NOT NULL,
  `quantite_initiale` float NOT NULL,
  `quantite_utilisee` float NOT NULL,
  `date_entree` datetime DEFAULT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `stock_medicament_medicament_id_foreign` (`medicament_id`),
  KEY `stock_medicament_bande_id_foreign` (`bande_id`),
  CONSTRAINT `stock_medicament_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`),
  CONSTRAINT `stock_medicament_medicament_id_foreign` FOREIGN KEY (`medicament_id`) REFERENCES `medicament` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_medicament`
--


--
-- Table structure for table `vente`
--

CREATE TABLE `vente` (
  `id` int NOT NULL AUTO_INCREMENT,
  `bande_id` int NOT NULL,
  `ferme_id` int NOT NULL,
  `quantite` int NOT NULL,
  `prix_vente` decimal(10,2) NOT NULL DEFAULT '0.00',
  `prix_unitaire` decimal(10,2) NOT NULL DEFAULT '0.00',
  `montant_total` decimal(10,2) NOT NULL DEFAULT '0.00',
  `total_vente` decimal(10,2) NOT NULL DEFAULT '0.00',
  `date` datetime DEFAULT NULL,
  `statut` enum('active','delete') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'active',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted_at` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `vente_bande_id_foreign` (`bande_id`),
  CONSTRAINT `vente_bande_id_foreign` FOREIGN KEY (`bande_id`) REFERENCES `bande` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `vente`
--

INSERT INTO `vente` VALUES (1,2,2,23,1500.00,964.38,34500.00,22180.74,'2026-02-27 00:00:00','active','2026-03-01 13:28:48','2026-03-01 13:28:48','2026-03-01 14:28:48'),(2,1,1,34,1600.00,1011.58,54400.00,34393.72,'2026-03-04 00:00:00','active','2026-03-04 08:29:59','2026-03-04 08:29:59','2026-03-04 09:29:59'),(3,1,1,5,1600.00,1032.77,8000.00,5163.85,'2026-03-04 00:00:00','active','2026-03-04 11:22:13','2026-03-04 11:22:13','2026-03-04 12:22:13'),(4,1,1,15,1600.00,1058.49,24000.00,15877.35,'2026-03-05 00:00:00','active','2026-03-05 18:51:00','2026-03-05 18:51:00','2026-03-05 19:51:00'),(5,1,1,10,1600.00,1060.09,16000.00,10600.90,'2026-03-06 00:00:00','active','2026-03-06 08:25:15','2026-03-06 08:25:15','2026-03-06 09:25:15'),(6,1,1,10,1850.00,1270.39,18500.00,12703.90,'2026-03-11 00:00:00','active','2026-03-11 16:25:37','2026-03-11 16:25:37','2026-03-11 17:25:37'),(7,2,2,10,2200.00,1149.96,22000.00,11499.60,'2026-03-09 00:00:00','active','2026-03-12 09:58:38','2026-03-12 09:58:38','2026-03-12 10:58:38'),(8,1,1,100,2600.00,1961.87,260000.00,196187.00,'2026-03-27 00:00:00','active','2026-03-27 07:12:40','2026-03-27 07:12:40','2026-03-27 08:12:40'),(10,1,1,2,2700.00,2027.57,5400.00,4055.14,'2026-03-27 00:00:00','active','2026-03-27 18:00:19','2026-03-27 18:00:19','2026-03-27 19:00:19'),(11,1,1,8,2800.00,2135.57,22400.00,17084.56,'2026-03-30 00:00:00','active','2026-03-30 21:01:26','2026-03-30 21:01:26','2026-03-30 22:01:26'),(12,1,1,100,2700.00,2161.15,270000.00,216115.00,'2026-03-31 00:00:00','active','2026-03-31 09:45:14','2026-03-31 09:45:14','2026-03-31 10:45:14'),(14,1,1,1,2303.00,2302.45,2303.00,2302.45,'2026-04-01 00:00:00','active','2026-04-01 09:20:10','2026-04-01 09:20:10','2026-04-01 10:20:10'),(15,1,1,2,2800.00,2302.46,5600.00,4604.92,'2026-04-01 00:00:00','active','2026-04-01 09:21:00','2026-04-01 09:21:00','2026-04-01 10:21:00'),(16,1,1,1,3300.00,2580.16,3300.00,2580.16,'2026-04-05 00:00:00','active','2026-04-05 14:08:45','2026-04-05 14:08:45','2026-04-05 15:08:45'),(17,1,1,4,3200.00,2580.16,12800.00,10320.64,'2026-04-05 00:00:00','active','2026-04-05 14:08:58','2026-04-05 14:08:58','2026-04-05 15:08:58'),(18,1,1,26,3123.00,2759.00,81198.00,71734.00,'2026-04-08 00:00:00','active','2026-04-07 17:54:30','2026-04-07 17:54:30','2026-04-07 18:54:30'),(19,1,1,10,3200.00,2859.00,32000.00,28590.00,'2026-04-10 00:00:00','active','2026-04-10 07:32:32','2026-04-10 07:32:32','2026-04-10 08:32:32'),(20,1,1,4,2860.00,2859.00,11440.00,11436.00,'2026-04-10 00:00:00','active','2026-04-10 07:33:38','2026-04-10 07:33:38','2026-04-10 08:33:38');


