-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le : mar. 16 jan. 2024 à 12:09
-- Version du serveur : 8.2.0
-- Version de PHP : 8.2.13

START TRANSACTION;



-- --------------------------------------------------------

--
-- Structure de la table `abonnement`
--

CREATE TABLE IF NOT EXISTS `abonnement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `refAbo` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `loyer` int NOT NULL,
  `adresseVirtuelle` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `numero` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `montant` int DEFAULT NULL,
  `caution` int DEFAULT NULL,
  `dureeAbonnement` datetime DEFAULT NULL,
  `etat` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `motifResiliation` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dateAbonnement` datetime NOT NULL,
  `nombreCle` int DEFAULT NULL,
  `fraisCle` int DEFAULT NULL,
  `typeBoite` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `estResilier` int NOT NULL,
  `estMPostBox` tinyint NOT NULL DEFAULT '0',
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `bureauId` int DEFAULT NULL,
  `abonneId` int DEFAULT NULL,
  `tarifId` int DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  `boiteId` int DEFAULT NULL,
  `adressePostaleId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_7d7675b51099a94a96543d9a8f` (`refAbo`),
  UNIQUE KEY `IDX_8bb0df86a9722502537f648664` (`adresseVirtuelle`),
  UNIQUE KEY `IDX_f0d36a1b8a3028f26ccd0e6d46` (`numero`),
  KEY `FK_0e27b23ae433d3d692a52c34ac8` (`bureauId`),
  KEY `FK_8778bde533a6efacae3428d9347` (`abonneId`),
  KEY `FK_5a815acf0d126852c78d8bc15ba` (`tarifId`),
  KEY `FK_d2de8f28f69f5e391c7260f346d` (`abonnementId`),
  KEY `FK_96c5fdaad046ac6b6f84fbac554` (`boiteId`),
  KEY `FK_cc0b4ecb98fc92cfed923727e96` (`adressePostaleId`),
  KEY `FK_c7ee940b07f8e1929f88f3fbe7b` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `abonnement`
--

INSERT INTO `abonnement` (`id`, `refAbo`, `loyer`, `adresseVirtuelle`, `numero`, `montant`, `caution`, `dureeAbonnement`, `etat`, `motifResiliation`, `dateAbonnement`, `nombreCle`, `fraisCle`, `typeBoite`, `estResilier`, `estMPostBox`, `createdAt`, `updatedAt`, `deletedAt`, `bureauId`, `abonneId`, `tarifId`, `abonnementId`, `boiteId`, `adressePostaleId`, `userCreationId`) VALUES
(1, 'BT24000001', 7000, NULL, NULL, 19000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 16:35:43.412845', '2024-01-15 16:35:43.412845', NULL, 32, 78, NULL, NULL, 149, 58, NULL),
(2, 'MP24000002', 5000, '229GE3297989589', '+229 97 98 95 89', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 16:52:31.736895', '2024-01-15 16:52:31.736895', NULL, 31, 82, NULL, NULL, NULL, NULL, NULL),
(3, 'MP24000003', 5000, '229GE3497989601', '+229 97 98 96 01', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 16:53:52.127408', '2024-01-15 16:53:52.127408', NULL, 34, 81, NULL, NULL, NULL, NULL, NULL),
(4, 'MP24000004', 5000, '229GE4197989695', '+229 97 98 96 95', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 16:54:35.869158', '2024-01-15 16:54:35.869158', NULL, 41, 52, NULL, NULL, NULL, NULL, NULL),
(5, 'MP24000005', 5000, '229000297989655', '+229 97 98 96 55', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 16:56:26.470202', '2024-01-15 16:56:26.470202', NULL, 2, 83, NULL, NULL, NULL, NULL, NULL),
(6, 'MP24000006', 5000, '229GE4397989689', '+229 97 98 96 89', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 17:00:38.913976', '2024-01-15 17:00:38.913976', NULL, 43, 80, NULL, NULL, NULL, NULL, NULL),
(7, 'MP24000007', 5000, '229GE3196965569', '+229 96 96 55 69', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 18:44:50.147073', '2024-01-15 18:44:50.147073', NULL, 32, 74, NULL, NULL, NULL, NULL, NULL),
(8, 'MP24000008', 5000, '229GE3665636269', '+229 65 63 62 69', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 18:45:30.454976', '2024-01-15 18:45:30.454976', NULL, 36, 71, NULL, NULL, NULL, NULL, NULL),
(9, 'MP24000009', 5000, '229GE4596989657', '+229 96 98 96 57', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 18:45:57.885484', '2024-01-15 18:45:57.885484', NULL, 45, 67, NULL, NULL, NULL, NULL, NULL),
(10, 'MP24000010', 5000, '229GE4295898955', '+229 95 89 89 55', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 18:47:09.758685', '2024-01-15 18:47:09.758685', NULL, 42, 72, NULL, NULL, NULL, NULL, NULL),
(11, 'MP24000011', 5000, '229GE3597958696', '+229 97 95 86 96', NULL, NULL, NULL, '', NULL, '0000-00-00 00:00:00', NULL, NULL, NULL, 0, 1, '2024-01-15 18:47:54.235209', '2024-01-15 18:47:54.235209', NULL, 35, 55, NULL, NULL, NULL, NULL, NULL),
(12, 'BT24000012', 7000, NULL, NULL, 19000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 18:56:54.829763', '2024-01-15 18:56:54.829763', NULL, 31, 82, NULL, NULL, 61, 14, NULL),
(13, 'BT24000013', 10000, NULL, NULL, 22000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 18:58:10.318483', '2024-01-15 18:58:10.318483', NULL, 35, 83, NULL, NULL, 82, 23, NULL),
(14, 'BT24000014', 12000, NULL, NULL, 24000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 18:59:25.339169', '2024-01-15 18:59:25.339169', NULL, 45, 55, NULL, NULL, 147, 33, NULL),
(15, 'BT24000015', 7000, NULL, NULL, 19000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:00:17.767564', '2024-01-15 19:00:17.767564', NULL, 33, 80, NULL, NULL, 68, 6, NULL),
(16, 'BT24000016', 10000, NULL, NULL, 22000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:01:07.474989', '2024-01-15 19:01:07.474989', NULL, 37, 6, NULL, NULL, 95, 10, NULL),
(17, 'BT24000017', 12000, NULL, NULL, 24000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:02:17.151849', '2024-01-15 19:02:17.151849', NULL, 31, 8, NULL, NULL, 66, 30, NULL),
(18, 'BT24000018', 12000, NULL, NULL, 24000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:04:43.434776', '2024-01-15 19:04:43.434776', NULL, 31, 59, NULL, NULL, 65, 22, NULL),
(19, 'BT24000019', 10000, NULL, NULL, 22000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:06:45.328620', '2024-01-15 19:06:45.328620', NULL, 31, 72, NULL, NULL, 64, 18, NULL),
(20, 'BT24000020', 20000, NULL, NULL, 32000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:09:27.536464', '2024-01-15 19:09:27.536464', NULL, 34, 69, NULL, NULL, 75, 7, NULL),
(21, 'BT24000021', 40000, NULL, NULL, 52000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-15 19:09:56.288686', '2024-01-15 19:09:56.288686', NULL, 35, 66, NULL, NULL, 81, 3, NULL),
(22, 'BT24000022', 0, NULL, NULL, 0, 0, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-16 12:32:41.246677', '2024-01-16 12:34:15.000000', '2024-01-16 12:34:15.000000', 31, 84, NULL, NULL, 63, 17, NULL),
(23, 'BT24000023', 10000, NULL, NULL, 22000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-16 12:36:26.003763', '2024-01-16 12:36:26.003763', NULL, 33, 84, NULL, NULL, 70, 29, NULL),
(24, 'BT24000024', 7000, NULL, NULL, 19000, 7000, NULL, '', NULL, '0000-00-00 00:00:00', 3, 5000, 'Ordinaire', 0, 0, '2024-01-16 12:37:04.362428', '2024-01-16 12:37:04.362428', NULL, 35, 88, NULL, NULL, 79, 27, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `adresse_postale`
--

CREATE TABLE IF NOT EXISTS `adresse_postale` (
  `id` int NOT NULL AUTO_INCREMENT,
  `adresse_postale` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `etat` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Disponible',
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `agenceOrigineId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_31aa40e3b4df845582edaee907` (`adresse_postale`),
  KEY `FK_130097220f9f81424f3a31db086` (`agenceOrigineId`),
  KEY `FK_86ac0d5656a85112b0a14f275c0` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `adresse_postale`
--

INSERT INTO `adresse_postale` (`id`, `adresse_postale`, `etat`, `createdAt`, `updatedAt`, `deletedAt`, `agenceOrigineId`, `userCreationId`) VALUES
(1, '22 BP 0001', 'Disponible', '2024-01-14 06:43:44.653696', '2024-01-14 06:43:44.653696', NULL, NULL, NULL),
(2, '15 BP 0002', 'Disponible', '2024-01-14 06:43:44.819813', '2024-01-14 06:43:44.819813', NULL, NULL, NULL),
(3, '13 BP 0003', 'Louée', '2024-01-14 06:43:44.906031', '2024-01-15 19:09:56.000000', NULL, NULL, NULL),
(4, '19 BP 0004', 'Disponible', '2024-01-14 06:43:45.031950', '2024-01-14 06:43:45.031950', NULL, NULL, NULL),
(5, '06 BP 0005', 'Disponible', '2024-01-14 06:43:45.153981', '2024-01-14 06:43:45.153981', NULL, NULL, NULL),
(6, '10 BP 0006', 'Louée', '2024-01-14 06:43:45.223584', '2024-01-15 19:00:17.000000', NULL, NULL, NULL),
(7, '20 BP 0007', 'Louée', '2024-01-14 06:43:45.294283', '2024-01-15 19:09:27.000000', NULL, NULL, NULL),
(8, '25 BP 0008', 'Disponible', '2024-01-14 06:43:45.387093', '2024-01-14 06:43:45.387093', NULL, NULL, NULL),
(9, '22 BP 0009', 'Disponible', '2024-01-14 06:43:45.474723', '2024-01-14 06:43:45.474723', NULL, NULL, NULL),
(10, '08 BP 0010', 'Louée', '2024-01-14 06:43:45.540364', '2024-01-15 19:01:07.000000', NULL, NULL, NULL),
(11, '07 BP 0011', 'Disponible', '2024-01-14 06:43:45.643995', '2024-01-14 06:43:45.643995', NULL, NULL, NULL),
(12, '06 BP 0012', 'Disponible', '2024-01-14 06:43:45.834044', '2024-01-14 06:43:45.834044', NULL, NULL, NULL),
(13, '07 BP 0013', 'Disponible', '2024-01-14 06:43:45.902691', '2024-01-14 06:43:45.902691', NULL, NULL, NULL),
(14, '02 BP 0014', 'Louée', '2024-01-14 06:43:45.997053', '2024-01-15 18:56:55.000000', NULL, NULL, NULL),
(15, '18 BP 0015', 'Disponible', '2024-01-14 06:43:46.135866', '2024-01-14 06:43:46.135866', NULL, NULL, NULL),
(16, '02 BP 9595', 'Disponible', '2024-01-15 11:32:39.553289', '2024-01-15 11:32:39.553289', NULL, NULL, NULL),
(17, '02 BP 0061', 'Louée', '2024-01-15 12:30:52.329636', '2024-01-16 12:32:54.000000', NULL, NULL, NULL),
(18, '02 BP 0062', 'Louée', '2024-01-15 12:30:56.680897', '2024-01-15 19:06:45.000000', NULL, NULL, NULL),
(19, '02 BP 0063', 'Disponible', '2024-01-15 12:31:03.788834', '2024-01-15 12:31:03.788834', NULL, NULL, NULL),
(20, '02 BP 0064', 'Disponible', '2024-01-15 12:31:08.099458', '2024-01-15 12:31:08.099458', NULL, NULL, NULL),
(21, '02 BP 0065', 'Disponible', '2024-01-15 12:31:12.596618', '2024-01-15 12:31:12.596618', NULL, NULL, NULL),
(22, '03 BP 0066', 'Louée', '2024-01-15 12:31:18.379872', '2024-01-15 19:04:43.000000', NULL, NULL, NULL),
(23, '03 BP 0067', 'Louée', '2024-01-15 12:31:23.324032', '2024-01-15 18:58:10.000000', NULL, NULL, NULL),
(24, '03 BP 0068', 'Disponible', '2024-01-15 12:31:30.002448', '2024-01-15 12:31:30.002448', NULL, NULL, NULL),
(25, '03 BP 0069', 'Disponible', '2024-01-15 12:31:36.165296', '2024-01-15 12:31:36.165296', NULL, NULL, NULL),
(26, '03 BP 0070', 'Disponible', '2024-01-15 12:31:41.785317', '2024-01-15 12:31:41.785317', NULL, NULL, NULL),
(27, '04 BP 0071', 'Louée', '2024-01-15 12:31:46.124684', '2024-01-16 12:37:04.000000', NULL, NULL, NULL),
(28, '04 BP 0072', 'Disponible', '2024-01-15 12:31:52.954552', '2024-01-15 12:31:52.954552', NULL, NULL, NULL),
(29, '04 BP 0080', 'Louée', '2024-01-15 12:31:57.733143', '2024-01-16 12:36:27.000000', NULL, NULL, NULL),
(30, '04 BP 0082', 'Louée', '2024-01-15 12:32:04.688832', '2024-01-15 19:02:17.000000', NULL, NULL, NULL),
(31, '04 BP 0100', 'Disponible', '2024-01-15 12:32:11.108484', '2024-01-15 12:32:11.108484', NULL, NULL, NULL),
(32, '04 BP 0105', 'Disponible', '2024-01-15 12:32:16.555253', '2024-01-15 12:32:16.555253', NULL, NULL, NULL),
(33, '05 BP 105', 'Louée', '2024-01-15 12:36:42.342890', '2024-01-15 18:59:25.000000', NULL, NULL, NULL),
(35, '06 BP 122', 'Disponible', '2024-01-15 12:36:51.731521', '2024-01-15 12:36:51.731521', NULL, NULL, NULL),
(38, '07 BP 263', 'Disponible', '2024-01-15 12:37:27.041705', '2024-01-15 12:37:27.041705', NULL, NULL, NULL),
(39, '08 BP 164', 'Disponible', '2024-01-15 12:37:33.477772', '2024-01-15 12:37:33.477772', NULL, NULL, NULL),
(40, '09 BP 155', 'Disponible', '2024-01-15 12:37:38.979387', '2024-01-15 12:37:38.979387', NULL, NULL, NULL),
(41, '10 BP 0166', 'Disponible', '2024-01-15 12:37:44.305433', '2024-01-15 12:37:44.305433', NULL, NULL, NULL),
(42, '12 BP 0067', 'Disponible', '2024-01-15 12:37:49.356186', '2024-01-15 12:37:49.356186', NULL, NULL, NULL),
(43, '11 BP 0268', 'Disponible', '2024-01-15 12:37:55.338644', '2024-01-15 12:37:55.338644', NULL, NULL, NULL),
(44, '16 BP 469', 'Disponible', '2024-01-15 12:38:01.093262', '2024-01-15 12:38:01.093262', NULL, NULL, NULL),
(45, '15 BP 5070', 'Disponible', '2024-01-15 12:38:06.865965', '2024-01-15 12:38:06.865965', NULL, NULL, NULL),
(46, '20 BP 1071', 'Disponible', '2024-01-15 12:38:12.467179', '2024-01-15 12:38:12.467179', NULL, NULL, NULL),
(47, '26 BP 2072', 'Disponible', '2024-01-15 12:38:17.155972', '2024-01-15 12:38:17.155972', NULL, NULL, NULL),
(48, '25 BP 3080', 'Disponible', '2024-01-15 12:38:22.967864', '2024-01-15 12:38:22.967864', NULL, NULL, NULL),
(49, '14 BP 4082', 'Disponible', '2024-01-15 12:38:27.782720', '2024-01-15 12:38:27.782720', NULL, NULL, NULL),
(50, '32 BP 5100', 'Disponible', '2024-01-15 12:38:35.035643', '2024-01-15 12:38:35.035643', NULL, NULL, NULL),
(51, '36 BP 6105', 'Disponible', '2024-01-15 12:38:44.157889', '2024-01-15 12:38:44.157889', NULL, NULL, NULL),
(54, '32 BP 0120', 'Disponible', '2024-01-15 15:13:16.978755', '2024-01-15 15:13:16.978755', NULL, NULL, NULL),
(57, '32 BP 0121', 'Disponible', '2024-01-15 15:15:37.176849', '2024-01-15 15:15:37.176849', NULL, NULL, NULL),
(58, '02 BP 1010', 'Louée', '2024-01-15 16:34:43.243423', '2024-01-15 16:35:43.000000', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `attestation`
--

CREATE TABLE IF NOT EXISTS `attestation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `dateExpiration` datetime NOT NULL,
  `refAttestation` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `modeleId` int DEFAULT NULL,
  `demandeId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_324afa37be368bd710e139db9b` (`refAttestation`),
  KEY `FK_316deae72c7c7ed95165a635035` (`modeleId`),
  KEY `FK_074e408aed4a351f4eb711d186e` (`demandeId`),
  KEY `FK_c1e8f3fb6bc1c7c03d3b1f3f93b` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `boite_postale`
--

CREATE TABLE IF NOT EXISTS `boite_postale` (
  `id` int NOT NULL AUTO_INCREMENT,
  `etat` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'Disponible',
  `couleur` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `dimension` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `refBoite` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `estOfficiel` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `bureauId` int DEFAULT NULL,
  `modeleId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_28d04d38621579ae9f7d177209` (`refBoite`),
  KEY `FK_51e8142479a5219eed67ae3eac9` (`userCreationId`),
  KEY `FK_ee71ddc21eef5d68ef6406f6049` (`bureauId`),
  KEY `FK_53cdf76a2c06a273f3af9ff8a3f` (`modeleId`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `boite_postale`
--

INSERT INTO `boite_postale` (`id`, `etat`, `couleur`, `dimension`, `refBoite`, `estOfficiel`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`, `bureauId`, `modeleId`) VALUES
(1, 'Disponible', 'Rouge', '30*50*20', 'BP 0001', 'Non', '2024-01-14 06:43:37.675047', '2024-01-14 06:43:37.675047', NULL, NULL, 9, 3),
(2, 'Disponible', 'Orange', '30*50*20', 'BP 0002', 'Non', '2024-01-14 06:43:37.796119', '2024-01-14 06:43:37.796119', NULL, NULL, 4, 2),
(3, 'Disponible', 'Vert', '30*50*20', 'BP 0003', 'Non', '2024-01-14 06:43:37.903898', '2024-01-14 06:43:37.903898', NULL, NULL, 15, 3),
(4, 'Disponible', 'Orange', '30*50*20', 'BP 0004', 'Non', '2024-01-14 06:43:38.008838', '2024-01-14 06:43:38.008838', NULL, NULL, 19, 3),
(5, 'Disponible', 'Rouge', '30*50*20', 'BP 0005', 'Non', '2024-01-14 06:43:38.120351', '2024-01-14 06:43:38.120351', NULL, NULL, 17, 3),
(6, 'Disponible', 'Jaune', '30*50*20', 'BP 0006', 'Non', '2024-01-14 06:43:38.209335', '2024-01-14 06:43:38.209335', NULL, NULL, 13, 3),
(7, 'Disponible', 'Vert', '30*50*20', 'BP 0007', 'Non', '2024-01-14 06:43:38.309420', '2024-01-14 06:43:38.309420', NULL, NULL, 22, 3),
(8, 'Disponible', 'Orange', '30*50*20', 'BP 0008', 'Non', '2024-01-14 06:43:38.421174', '2024-01-14 06:43:38.421174', NULL, NULL, 24, 3),
(9, 'Disponible', 'Jaune', '30*50*20', 'BP 0009', 'Non', '2024-01-14 06:43:38.501754', '2024-01-14 06:43:38.501754', NULL, NULL, 12, 3),
(10, 'Disponible', 'Orange', '30*50*20', 'BP 0010', 'Non', '2024-01-14 06:43:38.630263', '2024-01-14 06:43:38.630263', NULL, NULL, 25, 1),
(11, 'Disponible', 'Jaune', '30*50*20', 'BP 0011', 'Non', '2024-01-14 06:43:38.746197', '2024-01-14 06:43:38.746197', NULL, NULL, 17, 2),
(12, 'Disponible', 'Vert', '30*50*20', 'BP 0012', 'Non', '2024-01-14 06:43:38.875177', '2024-01-14 06:43:38.875177', NULL, NULL, 4, 1),
(13, 'Disponible', 'Rouge', '30*50*20', 'BP 0013', 'Non', '2024-01-14 06:43:38.935143', '2024-01-14 06:43:38.935143', NULL, NULL, 23, 3),
(14, 'Disponible', 'Vert', '30*50*20', 'BP 0014', 'Non', '2024-01-14 06:43:38.992154', '2024-01-14 06:43:38.992154', NULL, NULL, 13, 1),
(15, 'Disponible', 'Vert', '30*50*20', 'BP 0015', 'Non', '2024-01-14 06:43:39.067456', '2024-01-14 06:43:39.067456', NULL, NULL, 27, 3),
(16, 'Disponible', 'Vert', '30*50*20', 'BP 0016', 'Non', '2024-01-14 06:43:39.148669', '2024-01-14 06:43:39.148669', NULL, NULL, 20, 2),
(17, 'Disponible', 'Jaune', '30*50*20', 'BP 0017', 'Non', '2024-01-14 06:43:39.234505', '2024-01-14 06:43:39.234505', NULL, NULL, 3, 2),
(18, 'Disponible', 'Orange', '30*50*20', 'BP 0018', 'Non', '2024-01-14 06:43:39.354593', '2024-01-14 06:43:39.354593', NULL, NULL, 6, 3),
(19, 'Disponible', 'Jaune', '30*50*20', 'BP 0019', 'Non', '2024-01-14 06:43:39.482434', '2024-01-14 06:43:39.482434', NULL, NULL, 1, 1),
(20, 'Disponible', 'Bleu', '30*50*20', 'BP 0020', 'Non', '2024-01-14 06:43:39.577772', '2024-01-14 06:43:39.577772', NULL, NULL, 17, 1),
(21, 'Disponible', 'Orange', '30*50*20', 'BP 0021', 'Non', '2024-01-14 06:43:39.637108', '2024-01-14 06:43:39.637108', NULL, NULL, 1, 2),
(22, 'Disponible', 'Orange', '30*50*20', 'BP 0022', 'Non', '2024-01-14 06:43:39.737068', '2024-01-14 06:43:39.737068', NULL, NULL, 23, 1),
(23, 'Disponible', 'Bleu', '30*50*20', 'BP 0023', 'Non', '2024-01-14 06:43:39.874236', '2024-01-14 06:43:39.874236', NULL, NULL, 8, 2),
(24, 'Disponible', 'Bleu', '30*50*20', 'BP 0024', 'Non', '2024-01-14 06:43:40.013528', '2024-01-14 06:43:40.013528', NULL, NULL, 5, 3),
(25, 'Disponible', 'Bleu', '30*50*20', 'BP 0025', 'Non', '2024-01-14 06:43:40.081715', '2024-01-14 06:43:40.081715', NULL, NULL, 8, 2),
(26, 'Disponible', 'Orange', '30*50*20', 'BP 0026', 'Non', '2024-01-14 06:43:40.188790', '2024-01-14 06:43:40.188790', NULL, NULL, 25, 2),
(27, 'Disponible', 'Bleu', '30*50*20', 'BP 0027', 'Non', '2024-01-14 06:43:40.318567', '2024-01-14 06:43:40.318567', NULL, NULL, 28, 1),
(28, 'Disponible', 'Bleu', '30*50*20', 'BP 0028', 'Non', '2024-01-14 06:43:40.419653', '2024-01-14 06:43:40.419653', NULL, NULL, 11, 3),
(29, 'Disponible', 'Jaune', '30*50*20', 'BP 0029', 'Non', '2024-01-14 06:43:40.554858', '2024-01-14 06:43:40.554858', NULL, NULL, 12, 2),
(30, 'Disponible', 'Jaune', '30*50*20', 'BP 0030', 'Non', '2024-01-14 06:43:40.632631', '2024-01-14 06:43:40.632631', NULL, NULL, 5, 3),
(31, 'Disponible', 'Vert', '30*50*20', 'BP 0031', 'Non', '2024-01-14 06:43:40.752079', '2024-01-14 06:43:40.752079', NULL, NULL, 25, 3),
(32, 'Disponible', 'Orange', '30*50*20', 'BP 0032', 'Non', '2024-01-14 06:43:40.849052', '2024-01-14 06:43:40.849052', NULL, NULL, 15, 2),
(33, 'Disponible', 'Rouge', '30*50*20', 'BP 0033', 'Non', '2024-01-14 06:43:40.968157', '2024-01-14 06:43:40.968157', NULL, NULL, 20, 3),
(34, 'Disponible', 'Orange', '30*50*20', 'BP 0034', 'Non', '2024-01-14 06:43:41.049257', '2024-01-14 06:43:41.049257', NULL, NULL, 17, 3),
(35, 'Disponible', 'Jaune', '30*50*20', 'BP 0035', 'Non', '2024-01-14 06:43:41.130666', '2024-01-14 06:43:41.130666', NULL, NULL, 29, 1),
(36, 'Disponible', 'Jaune', '30*50*20', 'BP 0036', 'Non', '2024-01-14 06:43:42.195064', '2024-01-14 06:43:42.195064', NULL, NULL, 10, 2),
(37, 'Disponible', 'Rouge', '30*50*20', 'BP 0037', 'Non', '2024-01-14 06:43:42.352356', '2024-01-14 06:43:42.352356', NULL, NULL, 21, 2),
(38, 'Disponible', 'Bleu', '30*50*20', 'BP 0038', 'Non', '2024-01-14 06:43:42.429690', '2024-01-14 06:43:42.429690', NULL, NULL, 25, 3),
(39, 'Disponible', 'Vert', '30*50*20', 'BP 0039', 'Non', '2024-01-14 06:43:42.562372', '2024-01-14 06:43:42.562372', NULL, NULL, 19, 2),
(40, 'Disponible', 'Rouge', '30*50*20', 'BP 0040', 'Non', '2024-01-14 06:43:42.694783', '2024-01-14 06:43:42.694783', NULL, NULL, 25, 2),
(41, 'Disponible', 'Rouge', '30*50*20', 'BP 0041', 'Non', '2024-01-14 06:43:42.770133', '2024-01-14 06:43:42.770133', NULL, NULL, 3, 2),
(42, 'Disponible', 'Jaune', '30*50*20', 'BP 0042', 'Non', '2024-01-14 06:43:42.830239', '2024-01-14 06:43:42.830239', NULL, NULL, 1, 3),
(43, 'Disponible', 'Bleu', '30*50*20', 'BP 0043', 'Non', '2024-01-14 06:43:42.946067', '2024-01-14 06:43:42.946067', NULL, NULL, 25, 3),
(44, 'Disponible', 'Vert', '30*50*20', 'BP 0044', 'Non', '2024-01-14 06:43:43.058352', '2024-01-14 06:43:43.058352', NULL, NULL, 21, 3),
(45, 'Disponible', 'Orange', '30*50*20', 'BP 0045', 'Non', '2024-01-14 06:43:43.209434', '2024-01-14 06:43:43.209434', NULL, NULL, 15, 3),
(46, 'Disponible', 'Vert', '30*50*20', 'BP 0046', 'Non', '2024-01-14 06:43:43.318177', '2024-01-14 06:43:43.318177', NULL, NULL, 4, 2),
(47, 'Disponible', 'Orange', '30*50*20', 'BP 0047', 'Non', '2024-01-14 06:43:43.384000', '2024-01-14 06:43:43.384000', NULL, NULL, 18, 1),
(48, 'Disponible', 'Orange', '30*50*20', 'BP 0048', 'Non', '2024-01-14 06:43:43.459615', '2024-01-14 06:43:43.459615', NULL, NULL, 4, 1),
(49, 'Disponible', 'Bleu', '30*50*20', 'BP 0049', 'Non', '2024-01-14 06:43:43.509923', '2024-01-14 06:43:43.509923', NULL, NULL, 20, 3),
(50, 'Disponible', 'Orange', '30*50*20', 'BP 0050', 'Non', '2024-01-14 06:43:43.617998', '2024-01-14 06:43:43.617998', NULL, NULL, 12, 2),
(51, 'Disponible', 'Rouge', '30*50*20', 'BP 0051', 'Non', '2024-01-14 06:43:43.714626', '2024-01-14 06:43:43.714626', NULL, NULL, 7, 3),
(52, 'Disponible', 'Bleu', '30*50*20', 'BP 0052', 'Non', '2024-01-14 06:43:43.839266', '2024-01-14 06:43:43.839266', NULL, NULL, 3, 2),
(53, 'Disponible', 'Rouge', '30*50*20', 'BP 0053', 'Non', '2024-01-14 06:43:43.954167', '2024-01-14 06:43:43.954167', NULL, NULL, 25, 2),
(54, 'Disponible', 'Rouge', '30*50*20', 'BP 0054', 'Non', '2024-01-14 06:43:44.074810', '2024-01-14 06:43:44.074810', NULL, NULL, 25, 3),
(55, 'Disponible', 'Vert', '30*50*20', 'BP 0055', 'Non', '2024-01-14 06:43:44.174037', '2024-01-15 10:25:36.000000', NULL, NULL, 33, 1),
(56, 'Disponible', 'Vert', '30*50*20', 'BP 0056', 'Non', '2024-01-14 06:43:44.234450', '2024-01-14 06:43:44.234450', NULL, NULL, 22, 3),
(57, 'Disponible', 'Vert', '30*50*20', 'BP 0057', 'Non', '2024-01-14 06:43:44.348434', '2024-01-14 06:43:44.348434', NULL, NULL, 2, 3),
(58, 'Disponible', 'Orange', '30*50*20', 'BP 0058', 'Non', '2024-01-14 06:43:44.400686', '2024-01-14 06:43:44.400686', NULL, NULL, 3, 1),
(59, 'Disponible', 'Vert', '30*50*20', 'BP 0059', 'Non', '2024-01-14 06:43:44.465425', '2024-01-14 06:43:44.465425', NULL, NULL, 16, 3),
(60, 'Disponible', 'Jaune', '30*50*20', 'BP 0060', 'Non', '2024-01-14 06:43:44.588829', '2024-01-14 06:43:44.588829', NULL, NULL, 29, 1),
(61, 'Louée', 'Bleu', '30*50*20', 'BP 0061', '', '2024-01-15 11:14:20.576663', '2024-01-15 18:56:55.000000', NULL, NULL, 31, 1),
(62, 'Disponible', 'Jaune', '30*50*20', 'BP 0062', '', '2024-01-15 11:14:38.962465', '2024-01-15 16:29:37.000000', NULL, NULL, 31, 1),
(63, 'Louée', 'Bleu', '30*50*20', 'BP 0063', '', '2024-01-15 11:14:55.010102', '2024-01-16 12:32:59.000000', NULL, NULL, 31, 2),
(64, 'Louée', 'Bleu', '30*50*20', 'BP 0064', '', '2024-01-15 11:15:16.570474', '2024-01-15 19:06:45.000000', NULL, NULL, 31, 2),
(65, 'Louée', 'Noir', '30*50*20', 'BP 0065', '', '2024-01-15 11:15:29.938406', '2024-01-15 19:04:43.000000', NULL, NULL, 31, 3),
(66, 'Louée', 'Violet', '30*50*20', 'BP 0066', '', '2024-01-15 11:15:40.357747', '2024-01-15 19:02:17.000000', NULL, NULL, 31, 3),
(67, 'Disponible', 'Bleu', '30*50*20', 'BP 0067', '', '2024-01-15 11:15:59.915556', '2024-01-15 16:47:19.892666', NULL, NULL, 33, 1),
(68, 'Louée', 'Rouge', '30*50*20', 'BP 0068', '', '2024-01-15 11:16:17.335522', '2024-01-15 19:00:17.000000', NULL, NULL, 33, 1),
(69, 'Disponible', 'Marron', '30*50*20', 'BP 0069', '', '2024-01-15 11:16:30.248647', '2024-01-15 16:33:44.000000', NULL, NULL, 33, 2),
(70, 'Louée', 'Noir', '30*50*20', 'BP 0070', '', '2024-01-15 11:16:47.863888', '2024-01-16 12:36:27.000000', NULL, NULL, 33, 2),
(71, 'Disponible', 'Orange', '30*50*20', 'BP 0071', '', '2024-01-15 11:17:08.691776', '2024-01-15 16:34:23.000000', NULL, NULL, 33, 3),
(72, 'Disponible', 'Noir', '30*50*20', 'BP 0072', '', '2024-01-15 11:17:17.311125', '2024-01-15 16:34:38.000000', NULL, NULL, 33, 3),
(73, 'Disponible', 'Jaune', '30*50*20', 'BP 0073', '', '2024-01-15 11:17:30.029559', '2024-01-15 16:34:53.000000', NULL, NULL, 34, 1),
(74, 'Disponible', 'Violet', '30*50*20', 'BP 0075', '', '2024-01-15 11:18:04.794517', '2024-01-15 16:35:05.000000', NULL, NULL, 34, 1),
(75, 'Louée', 'Bleu', '30*50*20', 'BP 0076', '', '2024-01-15 11:18:14.210463', '2024-01-15 19:09:27.000000', NULL, NULL, 34, 2),
(76, 'Disponible', 'Violet', '30*50*20', 'BP 0077', '', '2024-01-15 11:18:39.946062', '2024-01-15 16:35:31.000000', NULL, NULL, 34, 2),
(77, 'Disponible', 'Bleu', '30*50*20', 'BP 0078', '', '2024-01-15 11:19:00.406798', '2024-01-15 16:35:47.000000', NULL, NULL, 34, 3),
(78, 'Disponible', 'Rouge', '30*50*20', 'BP 0079', '', '2024-01-15 11:19:17.980830', '2024-01-15 16:35:59.000000', NULL, NULL, 34, 3),
(79, 'Louée', 'Rouge', '30*50*20', 'BP 0080', '', '2024-01-15 11:19:48.478671', '2024-01-16 12:37:04.000000', NULL, NULL, 35, 1),
(80, 'Disponible', 'Jaune', '30*50*20', 'BP 0081', '', '2024-01-15 11:20:03.376357', '2024-01-15 16:36:38.000000', NULL, NULL, 35, 1),
(81, 'Louée', 'Marron', '30*50*20', 'BP 0082', '', '2024-01-15 11:20:17.262413', '2024-01-15 19:09:56.000000', NULL, NULL, 35, 2),
(82, 'Louée', 'Noir', '30*50*20', 'BP 0083', '', '2024-01-15 11:20:38.835018', '2024-01-15 18:58:10.000000', NULL, NULL, 35, 2),
(83, 'Disponible', 'Jaune', '30*50*20', 'BP 0084', '', '2024-01-15 11:21:21.208711', '2024-01-15 16:37:39.000000', NULL, NULL, 35, 3),
(84, 'Disponible', 'Noir', '30*50*20', 'BP 0085', '', '2024-01-15 11:21:47.841576', '2024-01-15 16:37:50.000000', NULL, NULL, 35, 3),
(85, 'Disponible', 'Bleu', '30*50*20', 'BP 0086', '', '2024-01-15 11:22:21.389375', '2024-01-15 16:38:03.000000', NULL, NULL, 36, 1),
(86, 'Disponible', 'Noir', '30*50*20', 'BP 0087', '', '2024-01-15 11:22:34.529663', '2024-01-15 16:38:54.000000', NULL, NULL, 36, 1),
(87, 'Disponible', 'Jaune', '30*50*20', 'BP 0088', '', '2024-01-15 11:23:07.890193', '2024-01-15 16:39:05.000000', NULL, NULL, 36, 2),
(89, 'Disponible', 'Bleu', '30*50*20', 'BP 0089', '', '2024-01-15 11:23:42.935504', '2024-01-15 16:39:17.000000', NULL, NULL, 36, 2),
(90, 'Disponible', 'Violet', '30*50*20', 'BP 0090', '', '2024-01-15 11:24:22.480031', '2024-01-15 16:39:29.000000', NULL, NULL, 36, 3),
(91, 'Disponible', 'Bleu', '30*50*20', 'BP 0091', '', '2024-01-15 11:24:43.957933', '2024-01-15 16:39:54.000000', NULL, NULL, 36, 3),
(92, 'Disponible', 'Rouge', '30*50*20', 'BP 0092', '', '2024-01-15 11:31:41.238643', '2024-01-15 16:40:05.000000', NULL, NULL, 37, 1),
(93, 'Disponible', 'Violet', '30*50*20', 'BP 0093', '', '2024-01-15 11:31:54.619176', '2024-01-15 16:40:18.000000', NULL, NULL, 37, 1),
(94, 'Disponible', 'Bleu', '30*50*20', 'BP 0094', '', '2024-01-15 11:33:28.108893', '2024-01-15 16:40:30.000000', NULL, NULL, 37, 2),
(95, 'Louée', 'Violet', '30*50*20', 'BP 0095', '', '2024-01-15 11:33:41.086549', '2024-01-15 19:01:07.000000', NULL, NULL, 37, 2),
(96, 'Disponible', 'Bleu', '30*50*20', 'BP 0096', '', '2024-01-15 11:34:29.511321', '2024-01-15 16:40:53.000000', NULL, NULL, 37, 3),
(98, 'Disponible', 'Jaune', '30*50*20', 'BP 0097', '', '2024-01-15 11:34:46.125906', '2024-01-15 16:41:16.000000', NULL, NULL, 37, 3),
(99, 'Disponible', 'Violet', '30*50*20', 'BP 0098', '', '2024-01-15 11:35:50.049889', '2024-01-15 16:42:09.000000', NULL, NULL, 38, 1),
(100, 'Disponible', 'Bleu', '30*50*20', 'BP 0099', '', '2024-01-15 11:36:04.473165', '2024-01-15 16:47:19.892666', NULL, NULL, 38, 1),
(102, 'Disponible', 'Bleu', '30*50*20', 'BP 0100', '', '2024-01-15 11:36:40.772622', '2024-01-15 16:47:19.892666', NULL, NULL, 38, 2),
(103, 'Disponible', 'Bleu', '30*50*20', 'BP 0101', '', '2024-01-15 11:36:55.241705', '2024-01-15 16:47:19.892666', NULL, NULL, 38, 2),
(104, 'Disponible', 'Bleu', '30*50*20', 'BP 0102', '', '2024-01-15 11:37:41.403412', '2024-01-15 16:47:19.892666', NULL, NULL, 38, 3),
(105, 'Disponible', 'Bleu', '30*50*20', 'BP 0103', '', '2024-01-15 11:38:00.703276', '2024-01-15 16:47:19.892666', NULL, NULL, 38, 3),
(106, 'Disponible', 'Bleu', '30*50*20', 'BP 0104', '', '2024-01-15 11:38:20.150405', '2024-01-15 16:47:19.892666', NULL, NULL, 39, 1),
(107, 'Disponible', 'Bleu', '30*50*20', 'BP 0105', '', '2024-01-15 11:38:39.514891', '2024-01-15 16:47:19.892666', NULL, NULL, 39, 1),
(108, 'Disponible', 'Bleu', '30*50*20', 'BP 0106', '', '2024-01-15 11:39:10.530057', '2024-01-15 16:47:19.892666', NULL, NULL, 39, 2),
(109, 'Disponible', 'Bleu', '30*50*20', 'BP 0107', '', '2024-01-15 11:39:25.424203', '2024-01-15 16:47:19.892666', NULL, NULL, 39, 2),
(110, 'Disponible', 'Bleu', '30*50*20', 'BP 0108', '', '2024-01-15 11:39:46.734502', '2024-01-15 16:47:19.892666', NULL, NULL, 39, 3),
(111, 'Disponible', 'Bleu', '30*50*20', 'BP 0109', '', '2024-01-15 11:40:33.836862', '2024-01-15 16:47:19.892666', NULL, NULL, 39, 3),
(112, 'Disponible', 'Bleu', '30*50*20', 'BP 0110', '', '2024-01-15 11:42:26.743395', '2024-01-15 16:47:19.892666', NULL, NULL, 40, 1),
(113, 'Disponible', 'NOIR', '30*50*20', 'BP 0111', '', '2024-01-15 11:44:26.957992', '2024-01-15 11:46:44.000000', NULL, NULL, 40, 1),
(114, 'Disponible', 'Bleu', '30*50*20', 'BP 0112', '', '2024-01-15 11:44:55.925948', '2024-01-15 16:47:19.892666', NULL, NULL, 40, 2),
(115, 'Disponible', 'Bleu', '30*50*20', 'BP 0113', '', '2024-01-15 11:46:17.457270', '2024-01-15 16:47:19.892666', NULL, NULL, 40, 2),
(116, 'Disponible', 'Bleu', '30*50*20', 'BP 0114', '', '2024-01-15 11:48:06.607194', '2024-01-15 16:47:19.892666', NULL, NULL, 40, 3),
(117, 'Disponible', 'Bleu', '30*50*20', 'BP 0115', '', '2024-01-15 11:48:17.488281', '2024-01-15 16:47:19.892666', NULL, NULL, 40, 3),
(118, 'Disponible', 'Bleu', '30*50*20', 'BP 0116', '', '2024-01-15 11:48:51.729775', '2024-01-15 16:47:19.892666', NULL, NULL, 41, 1),
(119, 'Disponible', 'Bleu', '30*50*20', 'BP 0117', '', '2024-01-15 11:49:07.512580', '2024-01-15 16:47:19.892666', NULL, NULL, 41, 1),
(120, 'Disponible', 'Bleu', '30*50*20', 'BP 0118', '', '2024-01-15 11:50:00.823506', '2024-01-15 16:47:19.892666', NULL, NULL, 41, 2),
(121, 'Disponible', 'Bleu', '30*50*20', 'BP 0119', '', '2024-01-15 11:50:35.921420', '2024-01-15 16:47:19.892666', NULL, NULL, 41, 2),
(122, 'Disponible', 'Bleu', '30*50*20', 'BP 0120', '', '2024-01-15 11:51:30.976309', '2024-01-15 16:47:19.892666', NULL, NULL, 41, 3),
(123, 'Disponible', 'Bleu', '30*50*20', 'BP 0121', '', '2024-01-15 11:51:46.459762', '2024-01-15 16:47:19.892666', NULL, NULL, 41, 3),
(124, 'Disponible', 'Bleu', '30*50*20', 'BP 0122', '', '2024-01-15 11:54:29.148867', '2024-01-15 16:47:19.892666', NULL, NULL, 42, 1),
(125, 'Disponible', 'Bleu', '30*50*20', 'BP 0123', '', '2024-01-15 11:54:39.305336', '2024-01-15 16:47:19.892666', NULL, NULL, 42, 1),
(126, 'Disponible', 'Bleu', '30*50*20', 'BP 0124', '', '2024-01-15 11:55:38.416567', '2024-01-15 16:47:19.892666', NULL, NULL, 42, 2),
(127, 'Disponible', 'Bleu', '30*50*20', 'BP 0125', '', '2024-01-15 11:56:15.164721', '2024-01-15 16:47:19.892666', NULL, NULL, 42, 2),
(128, 'Disponible', 'Bleu', '30*50*20', 'BP 0126', '', '2024-01-15 11:56:30.665805', '2024-01-15 16:47:19.892666', NULL, NULL, 42, 3),
(129, 'Disponible', 'Bleu', '30*50*20', 'BP 0127', '', '2024-01-15 11:57:45.237949', '2024-01-15 16:47:19.892666', NULL, NULL, 42, 3),
(130, 'Disponible', 'Bleu', '30*50*20', 'BP 0128', '', '2024-01-15 11:59:15.127437', '2024-01-15 16:47:19.892666', NULL, NULL, 43, 1),
(131, 'Disponible', 'Bleu', '30*50*20', 'BP 0129', '', '2024-01-15 12:04:54.216343', '2024-01-15 16:47:19.892666', NULL, NULL, 43, 1),
(132, 'Disponible', 'Bleu', '30*50*20', 'BP 0130', '', '2024-01-15 12:05:04.511241', '2024-01-15 16:47:19.892666', NULL, NULL, 43, 2),
(133, 'Disponible', 'Bleu', '30*50*20', 'BP 0131', '', '2024-01-15 12:05:18.595429', '2024-01-15 16:47:19.892666', NULL, NULL, 43, 2),
(134, 'Disponible', 'Bleu', '30*50*20', 'BP 0132', '', '2024-01-15 12:05:30.051340', '2024-01-15 16:47:19.892666', NULL, NULL, 43, 3),
(135, 'Disponible', 'Bleu', '30*50*20', 'BP 0133', '', '2024-01-15 12:05:48.241942', '2024-01-15 16:47:19.892666', NULL, NULL, 43, 3),
(136, 'Disponible', 'Bleu', '30*50*20', 'BP 0134', '', '2024-01-15 12:08:25.487582', '2024-01-15 16:47:19.892666', NULL, NULL, 44, 1),
(137, 'Disponible', 'Bleu', '30*50*20', 'BP 0135', '', '2024-01-15 12:08:46.092587', '2024-01-15 16:47:19.892666', NULL, NULL, 44, 1),
(138, 'Disponible', 'Bleu', '30*50*20', 'BP 0136', '', '2024-01-15 12:09:08.359846', '2024-01-15 16:47:19.892666', NULL, NULL, 44, 2),
(139, 'Disponible', 'Bleu', '30*50*20', 'BP 0137', '', '2024-01-15 12:09:23.178920', '2024-01-15 16:47:19.892666', NULL, NULL, 44, 2),
(140, 'Disponible', 'Bleu', '30*50*20', 'BP 0138', '', '2024-01-15 12:13:39.774673', '2024-01-15 16:47:19.892666', NULL, NULL, 44, 3),
(141, 'Disponible', 'Bleu', '30*50*20', 'BP 0139', '', '2024-01-15 12:14:04.506983', '2024-01-15 16:47:19.892666', NULL, NULL, 44, 3),
(142, 'Disponible', 'Bleu', '30*50*20', 'BP 0140', '', '2024-01-15 12:15:13.189187', '2024-01-15 16:47:19.892666', NULL, NULL, 45, 1),
(143, 'Disponible', 'Bleu', '30*50*20', 'BP 0141', '', '2024-01-15 12:15:30.349416', '2024-01-15 16:47:19.892666', NULL, NULL, 45, 1),
(144, 'Disponible', 'Bleu', '30*50*20', 'BP 0142', '', '2024-01-15 12:15:52.089130', '2024-01-15 16:47:19.892666', NULL, NULL, 45, 2),
(145, 'Disponible', 'Bleu', '30*50*20', 'BP 0143', '', '2024-01-15 12:16:08.194974', '2024-01-15 16:47:19.892666', NULL, NULL, 45, 2),
(146, 'Disponible', 'Bleu', '30*50*20', 'BP 0144', '', '2024-01-15 12:16:26.841853', '2024-01-15 16:47:19.892666', NULL, NULL, 45, 3),
(147, 'Louée', 'Bleu', '30*50*20', 'BP 0145', '', '2024-01-15 12:16:36.313711', '2024-01-15 18:59:26.000000', NULL, NULL, 45, 3),
(148, 'Disponible', 'Bleu', '30*50*20', 'BP 1000', '', '2024-01-15 16:28:47.390525', '2024-01-15 16:28:47.390525', NULL, NULL, 33, 3),
(149, 'Louée', 'Bleu', '30*50*20', 'BP 1010', '', '2024-01-15 16:33:55.353258', '2024-01-15 16:47:19.892666', NULL, NULL, 32, 1);

-- --------------------------------------------------------

--
-- Structure de la table `bureau`
--

CREATE TABLE IF NOT EXISTS `bureau` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `adresse` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `telephone` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `nom` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `regionId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_e7bdffc738e742c5f73a6292f6` (`code`),
  UNIQUE KEY `IDX_e8990ab4782654c1363417ef31` (`telephone`),
  UNIQUE KEY `IDX_a3e4a0180a63d730111897ab3c` (`nom`),
  KEY `FK_e2040749b8706056d5494eea905` (`regionId`),
  KEY `FK_ae0025cb9fe0b2704191e238158` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `bureau`
--

INSERT INTO `bureau` (`id`, `code`, `adresse`, `type`, `telephone`, `nom`, `email`, `createdAt`, `updatedAt`, `deletedAt`, `regionId`, `userCreationId`) VALUES
(1, '01', 'Emmerich Cliffs', 'Relais', '215-459-9035', 'Relais 1', 'Ryan.Medhurst@yahoo.com', '2024-01-14 06:43:32.701583', '2024-01-14 06:43:32.701583', NULL, 31, NULL),
(2, '02', 'Osinski Road', 'Agence', '1-848-460-1116 x779', 'Agence 2', 'Ona.Jast@gmail.com', '2024-01-14 06:43:32.819537', '2024-01-14 06:43:32.819537', NULL, 11, NULL),
(3, '03', 'Jade Rue', 'Agence', '976-256-5349 x27124', 'Agence 3', 'Demetrius_Kuphal67@hotmail.com', '2024-01-14 06:43:32.919896', '2024-01-14 06:43:32.919896', NULL, 38, NULL),
(4, '04', 'Fahey Creek', 'Agence', '481.550.4464 x4679', 'Agence 4', 'Leopold.Stracke@hotmail.com', '2024-01-14 06:43:33.012893', '2024-01-14 06:43:33.012893', NULL, 49, NULL),
(5, '05', 'Mackenzie Plaza', 'Relais', '(317) 717-3979', 'Relais 5', 'April_Friesen11@gmail.com', '2024-01-14 06:43:33.110505', '2024-01-14 06:43:33.110505', NULL, 64, NULL),
(6, '06', 'Hillard Pike', 'Agence', '893.288.5391 x4927', 'Agence 6', 'Kamron82@yahoo.com', '2024-01-14 06:43:33.239156', '2024-01-14 06:43:33.239156', NULL, 73, NULL),
(7, '07', 'Emmitt Avenue', 'Relais', '1-780-454-9695 x97696', 'Relais 7', 'Brennan_Kassulke@gmail.com', '2024-01-14 06:43:33.339875', '2024-01-14 06:43:33.339875', NULL, 20, NULL),
(8, '08', 'Hoppe Hill', 'Agence', '(936) 477-4565 x42527', 'Agence 8', 'Izaiah_Klein33@gmail.com', '2024-01-14 06:43:33.418259', '2024-01-14 06:43:33.418259', NULL, 47, NULL),
(9, '09', 'Jessica Ramp', 'Relais', '772-725-1248', 'Relais 9', 'Cary.Kovacek34@hotmail.com', '2024-01-14 06:43:33.533944', '2024-01-14 06:43:33.533944', NULL, 38, NULL),
(10, '10', 'Korey Dale', 'Relais', '1-755-696-7647', 'Relais 10', 'Jairo67@hotmail.com', '2024-01-14 06:43:33.642170', '2024-01-14 06:43:33.642170', NULL, 25, NULL),
(11, '11', 'Mann Shores', 'Relais', '1-996-728-6185', 'Relais 11', 'Ellie_Jaskolski@hotmail.com', '2024-01-14 06:43:33.744661', '2024-01-14 06:43:33.744661', NULL, 17, NULL),
(12, '12', 'Cremin Crossroad', 'Relais', '(746) 565-5541', 'Relais 12', 'Llewellyn65@gmail.com', '2024-01-14 06:43:34.122705', '2024-01-14 06:43:34.122705', NULL, 24, NULL),
(13, '13', 'Littel Ports', 'Agence', '201-465-9003', 'Agence 13', 'Bud51@gmail.com', '2024-01-14 06:43:35.110089', '2024-01-14 06:43:35.110089', NULL, 61, NULL),
(14, '14', 'Blick Land', 'Agence', '1-412-508-5380 x9143', 'Agence 14', 'Aidan5@yahoo.com', '2024-01-14 06:43:35.209125', '2024-01-14 06:43:35.209125', NULL, 56, NULL),
(15, '15', 'Dooley Burgs', 'Agence', '(344) 774-5852', 'Agence 15', 'Janis_Hoeger82@gmail.com', '2024-01-14 06:43:35.301645', '2024-01-14 06:43:35.301645', NULL, 66, NULL),
(16, '16', 'Okuneva Cove', 'Relais', '1-556-262-0761', 'Relais 16', 'Ahmed82@hotmail.com', '2024-01-14 06:43:35.408372', '2024-01-14 06:43:35.408372', NULL, 48, NULL),
(17, '17', 'Lorenza Crossing', 'Relais', '532-540-0613', 'Relais 17', 'Dimitri90@hotmail.com', '2024-01-14 06:43:35.543222', '2024-01-14 06:43:35.543222', NULL, 72, NULL),
(18, '18', 'Oberbrunner Villages', 'Relais', '431-557-9625 x978', 'Relais 18', 'Xavier_Stark31@yahoo.com', '2024-01-14 06:43:35.687225', '2024-01-14 06:43:35.687225', NULL, 64, NULL),
(19, '19', 'Marquardt Pike', 'Agence', '729-422-4950 x03213', 'Agence 19', 'Destinee31@gmail.com', '2024-01-14 06:43:35.936502', '2024-01-14 06:43:35.936502', NULL, 28, NULL),
(20, '20', 'Joan Crossing', 'Agence', '(269) 473-1610', 'Agence 20', 'Alessandra59@gmail.com', '2024-01-14 06:43:36.391238', '2024-01-14 06:43:36.391238', NULL, 75, NULL),
(21, '21', 'Ankunding Locks', 'Relais', '908-435-4990', 'Relais 21', 'Pierce61@hotmail.com', '2024-01-14 06:43:36.551295', '2024-01-14 06:43:36.551295', NULL, 12, NULL),
(22, '22', 'Bergnaum Run', 'Agence', '1-637-725-6029 x26732', 'Agence 22', 'Maia.Jacobson@gmail.com', '2024-01-14 06:43:36.698419', '2024-01-14 06:43:36.698419', NULL, 13, NULL),
(23, '23', 'McGlynn Ports', 'Agence', '(582) 524-6488 x150', 'Agence 23', 'Tre.Heller@hotmail.com', '2024-01-14 06:43:36.860899', '2024-01-14 06:43:36.860899', NULL, 68, NULL),
(24, '24', 'Meda Track', 'Relais', '1-325-227-2899 x54319', 'Relais 24', 'Rossie.Murphy@hotmail.com', '2024-01-14 06:43:37.017600', '2024-01-14 06:43:37.017600', NULL, 36, NULL),
(25, '25', 'Lynch Grove', 'Agence', '1-319-782-9917', 'Agence 25', 'Jayde_Mitchell96@gmail.com', '2024-01-14 06:43:37.081542', '2024-01-14 06:43:37.081542', NULL, 29, NULL),
(26, '26', 'Jerde Loop', 'Relais', '(737) 392-8958 x0726', 'Relais 26', 'Oceane.Pollich@gmail.com', '2024-01-14 06:43:37.166721', '2024-01-14 06:43:37.166721', NULL, 37, NULL),
(27, '27', 'Caroline Oval', 'Agence', '(508) 414-1098 x472', 'Agence 27', 'Samara.White83@gmail.com', '2024-01-14 06:43:37.258542', '2024-01-14 06:43:37.258542', NULL, 28, NULL),
(28, '28', 'Percival Neck', 'Agence', '(311) 773-2390 x6033', 'Agence 28', 'Vivienne63@hotmail.com', '2024-01-14 06:43:37.346744', '2024-01-14 06:43:37.346744', NULL, 53, NULL),
(29, '29', 'Kuvalis Roads', 'Relais', '1-726-589-4550', 'Relais 29', 'Lonzo.McGlynn36@gmail.com', '2024-01-14 06:43:37.470136', '2024-01-14 06:43:37.470136', NULL, 15, NULL),
(30, '30', 'Abernathy Road', 'Agence', '355.852.6747', 'Agence 30', 'London54@hotmail.com', '2024-01-14 06:43:37.540266', '2024-01-14 06:43:37.540266', NULL, 34, NULL),
(31, 'AGE32', 'Calavi', 'Agence', '+229 90 90 90 02', 'AGENCE 32', 'agence32@gmail.com', '0000-00-00 00:00:00.000000', '2024-01-14 08:43:33.348286', NULL, 16, NULL),
(32, 'AGE31', 'Calavi', 'Agence', '+229 90 90 90 01', 'AGENCE 31', 'agence31@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 16, NULL),
(33, 'AGE33', 'Calavi', 'Agence', '+229 90 90 90 03', ' AGENCE 33', 'agence33@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 16, NULL),
(34, 'AGE34', 'Malanville', 'Agence', '+229 90 90 90 04', ' AGENCE 34', 'agence34@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 5, NULL),
(35, 'AGE35', 'Malanville', 'Agence', '+229 90 90 90 05', 'AGENCE 35', 'agence35@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 5, NULL),
(36, 'AGE36', 'Malanville', 'Agence', '+229 90 90 90 06', 'AGENCE 36', 'agence36@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 5, NULL),
(37, 'AGE37', 'Matéri', 'Agence', '+229 90 90 90 07', 'AGENCE 37', 'agence37@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 11, NULL),
(38, 'AGE38', 'Matéri', 'Agence', '+229 90 90 90 08', 'AGENCE 38', 'agence38@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 11, NULL),
(39, 'AGE39', 'Matéri', 'Agence', '+229 90 90 90 09', ' AGENCE 39', 'agence39@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 11, NULL),
(40, 'AGE40', 'Banikoara', 'Agence', '+229 90 90 90 10', ' AGENCE 40', 'agence40@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 1, NULL),
(41, 'AGE41', 'Banikoara', 'Agence', '+229 90 90 90 11', ' AGENCE 41', 'agence41@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 1, NULL),
(42, 'AGE42', 'Banikoara', 'Agence', '+229 90 90 90 12', ' AGENCE 42', 'agence42@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 1, NULL),
(43, 'AGE43', 'Bohicon', 'Agence', '+229 90 90 90 13', ' AGENCE 43', 'agence43@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 71, NULL),
(44, 'AGE44', 'Bohicon', 'Agence', '+229 90 90 90 14', ' AGENCE 44', 'agence44@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 71, NULL),
(45, 'AGE45', 'Bohicon', 'Agence', '+229 90 90 90 15', ' AGENCE 45', 'agence45@gmail.com', '0000-00-00 00:00:00.000000', '0000-00-00 00:00:00.000000', NULL, 71, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `campagne`
--

CREATE TABLE IF NOT EXISTS `campagne` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `dateFin` datetime NOT NULL,
  `dateDebut` datetime NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `nmbreDeFois` int NOT NULL,
  `urlImage` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `categorieAbonneId` int DEFAULT NULL,
  `typeNotificationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_0acc3b167a3439acf8d59491eb` (`code`),
  KEY `FK_adacf735b30f47129ee0cd85e20` (`userCreationId`),
  KEY `FK_a90be28f91ab111387010bb9254` (`categorieAbonneId`),
  KEY `FK_a8b2cdceb9cea9c4ae2b4f5e965` (`typeNotificationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `casier`
--

CREATE TABLE IF NOT EXISTS `casier` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `estOccupe` tinyint NOT NULL DEFAULT '0',
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `etagereId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_f3d7b9b393b7f11f0f567f7e27` (`code`),
  KEY `FK_9238466c7569e3dd18f265d6b01` (`etagereId`),
  KEY `FK_1da239a383233092a86f7052c2b` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `categorie_abonne`
--

CREATE TABLE IF NOT EXISTS `categorie_abonne` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_eb0dcdf677ca1f5ce93412e407` (`code`),
  UNIQUE KEY `IDX_fe002b8e08c0993ef4db487fd5` (`libelle`),
  KEY `FK_2c19e2bcab177a39907e4d2b99e` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `categorie_abonne`
--

INSERT INTO `categorie_abonne` (`id`, `code`, `libelle`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`) VALUES
(1, 'Catégorie 1', 'Personne Physique….', '2024-01-14 06:43:22.818354', '2024-01-14 06:43:22.818354', NULL, NULL),
(2, 'Catégorie 2', 'Etablissement Individuel, Ecoles, Collèges (CEG), Mairies, Associations, Etablissements religieux, toute organisation à but non lucratif…', '2024-01-14 06:43:22.852959', '2024-01-14 06:43:22.852959', NULL, NULL),
(3, 'Catégorie 3', 'Société a responsabilité limité (SARL), Professions libérales (Cabinets de santé, Cabinets de conseils, Notaires, Huissiers, Cliniques, etc…)', '2024-01-14 06:43:22.866591', '2024-01-14 06:43:22.866591', NULL, NULL),
(4, 'Catégorie 4', 'Sociétés Anonyme - SA, Sociétés financières (Banques, Assurances, etc.), Sociétés multinationales à but lucratif…', '2024-01-14 06:43:22.883642', '2024-01-14 06:43:22.883642', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `cle_type_notification`
--

CREATE TABLE IF NOT EXISTS `cle_type_notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `valeur` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `typeNotificationId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_a00ad69d9429749125ef11f3d5a` (`typeNotificationId`),
  KEY `FK_843d3af5bd2727756ffb96a7a09` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `cle_type_notification`
--

INSERT INTO `cle_type_notification` (`id`, `cle`, `valeur`, `createdAt`, `updatedAt`, `deletedAt`, `typeNotificationId`, `userCreationId`) VALUES
(1, '[[dateRedevance]]', 'date de la redevance', '2024-01-04 19:42:40.880763', '2024-01-04 19:42:40.880763', NULL, 1, NULL),
(2, '[[refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:43:10.393699', '2024-01-04 19:43:10.393699', NULL, 2, NULL),
(3, '[[refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:43:33.327495', '2024-01-04 19:43:33.327495', NULL, 3, NULL),
(4, '[[refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:43:52.815808', '2024-01-04 19:43:52.815808', NULL, 4, NULL),
(5, '[[id]]', 'identifiant de la demande', '2024-01-04 19:44:19.102763', '2024-01-04 19:44:19.102763', NULL, 5, NULL),
(6, '[[id]]', 'identifiant de la demande', '2024-01-04 19:44:40.974653', '2024-01-04 19:44:40.974653', NULL, 6, NULL),
(7, '[[id]]', 'identifiant de la demande', '2024-01-04 19:45:04.121343', '2024-01-04 19:45:04.121343', NULL, 7, NULL),
(8, '[[id]]', 'identifiant de la demande', '2024-01-04 19:45:24.083878', '2024-01-04 19:45:24.083878', NULL, 8, NULL),
(9, '[[id]]', 'identifiant de la demande', '2024-01-04 19:45:46.822462', '2024-01-04 19:45:46.822462', NULL, 9, NULL),
(10, '[[id]]', 'identifiant de la demande', '2024-01-04 19:46:06.580419', '2024-01-04 19:46:06.580419', NULL, 10, NULL),
(11, '[[id]]', 'identifiant de la demande', '2024-01-04 19:46:21.838674', '2024-01-04 19:46:21.838674', NULL, 11, NULL),
(12, '[[id]]', 'identifiant de la demande', '2024-01-04 19:46:34.942558', '2024-01-04 19:46:34.942558', NULL, 12, NULL),
(13, '[[id]]', 'identifiant du colis', '2024-01-04 19:47:10.326985', '2024-01-04 19:47:10.326985', NULL, 14, NULL),
(14, '[[refRedevance]]', 'reference de la redevance', '2024-01-04 19:52:52.021633', '2024-01-04 19:52:52.021633', NULL, 1, NULL),
(15, '[[annee]]', 'annee de redevance', '2024-01-04 19:53:11.726039', '2024-01-04 19:53:11.726039', NULL, 1, NULL),
(16, '[[Abonnement:refAbo]]', 'reference de l\'abonnement', '2024-01-04 19:53:36.293571', '2024-01-04 19:53:36.293571', NULL, 1, NULL),
(17, '[[arrieres]]', 'montant des arrièrés', '2024-01-04 19:55:12.846598', '2024-01-04 19:55:12.846598', NULL, 1, NULL),
(18, '[[Abonnement:loyer]]', 'le loyer annuel', '2024-01-04 19:55:45.443250', '2024-01-04 19:55:45.443250', NULL, 1, NULL),
(19, '[[Abonnement:montant]]', 'le montant de l\'abonnement', '2024-01-04 19:56:04.002182', '2024-01-04 19:56:04.002182', NULL, 1, NULL),
(20, '[[montantPaye]]', 'montant payée', '2024-01-04 19:57:15.830007', '2024-01-04 19:57:15.830007', NULL, 2, NULL),
(21, '[[montantRestant]]', 'montant restant du', '2024-01-04 19:58:05.868119', '2024-01-04 19:58:05.868119', NULL, 2, NULL),
(22, '[[montantPaye]]', 'montant payée', '2024-01-04 19:58:37.441767', '2024-01-04 19:58:37.441767', NULL, 3, NULL),
(23, '[[montantRestant]]', 'montant restant du', '2024-01-04 19:59:19.381243', '2024-01-04 19:59:19.381243', NULL, 3, NULL),
(24, '[[montantPaye]]', 'montant payée', '2024-01-04 19:59:37.315526', '2024-01-04 19:59:37.315526', NULL, 4, NULL),
(25, '[[montantRestant]]', 'montant restant du', '2024-01-04 19:59:57.904755', '2024-01-04 19:59:57.904755', NULL, 4, NULL),
(26, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:00:28.274446', '2024-01-04 20:00:28.274446', NULL, 5, NULL),
(27, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:00:42.551860', '2024-01-04 20:00:42.551860', NULL, 5, NULL),
(28, '[[status]]', 'status de la demande', '2024-01-04 20:00:57.624695', '2024-01-04 20:00:57.624695', NULL, 5, NULL),
(29, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:01:31.492971', '2024-01-04 20:01:31.492971', NULL, 5, NULL),
(30, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:01:44.662709', '2024-01-04 20:01:44.662709', NULL, 5, NULL),
(31, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:02:04.546289', '2024-01-04 20:02:04.546289', NULL, 5, NULL),
(32, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:02:19.423308', '2024-01-04 20:02:19.423308', NULL, 5, NULL),
(33, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:02:32.295563', '2024-01-04 20:02:32.295563', NULL, 5, NULL),
(34, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:02:44.352812', '2024-01-04 20:02:44.352812', NULL, 5, NULL),
(35, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:03:03.869217', '2024-01-04 20:03:03.869217', NULL, 5, NULL),
(36, '[[montant]]', 'montant de la demande', '2024-01-04 20:03:23.253920', '2024-01-04 20:03:23.253920', NULL, 5, NULL),
(37, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:03:52.350149', '2024-01-04 20:03:52.350149', NULL, 5, NULL),
(38, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:06:04.930887', '2024-01-04 20:06:04.930887', NULL, 6, NULL),
(39, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:06:19.756252', '2024-01-04 20:06:19.756252', NULL, 6, NULL),
(40, '[[status]]', 'status de la demande', '2024-01-04 20:06:37.481059', '2024-01-04 20:06:37.481059', NULL, 6, NULL),
(41, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:06:57.834100', '2024-01-04 20:06:57.834100', NULL, 6, NULL),
(42, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:07:11.060750', '2024-01-04 20:07:11.060750', NULL, 6, NULL),
(43, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:07:25.490685', '2024-01-04 20:07:25.490685', NULL, 6, NULL),
(44, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:07:40.909308', '2024-01-04 20:07:40.909308', NULL, 6, NULL),
(45, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:07:55.719979', '2024-01-04 20:07:55.719979', NULL, 6, NULL),
(46, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:08:10.659312', '2024-01-04 20:08:10.659312', NULL, 6, NULL),
(47, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:08:31.950920', '2024-01-04 20:08:31.950920', NULL, 6, NULL),
(48, '[[montant]]', 'montant de la demande', '2024-01-04 20:08:44.313817', '2024-01-04 20:08:44.313817', NULL, 6, NULL),
(49, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:09:00.044361', '2024-01-04 20:09:00.044361', NULL, 6, NULL),
(50, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:09:21.196919', '2024-01-04 20:09:21.196919', NULL, 7, NULL),
(51, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:09:35.233477', '2024-01-04 20:09:35.233477', NULL, 7, NULL),
(52, '[[status]]', 'status de la demande', '2024-01-04 20:09:48.746518', '2024-01-04 20:09:48.746518', NULL, 7, NULL),
(53, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:10:02.243980', '2024-01-04 20:10:02.243980', NULL, 7, NULL),
(54, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:10:13.450864', '2024-01-04 20:10:13.450864', NULL, 7, NULL),
(55, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:10:25.296930', '2024-01-04 20:10:25.296930', NULL, 7, NULL),
(56, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:10:41.688733', '2024-01-04 20:10:41.688733', NULL, 7, NULL),
(57, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:10:58.060437', '2024-01-04 20:10:58.060437', NULL, 7, NULL),
(58, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:11:11.517071', '2024-01-04 20:11:11.517071', NULL, 7, NULL),
(59, '[[SecteurActivite:libelle]]', 'e libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:11:33.833088', '2024-01-04 20:11:33.833088', NULL, 7, NULL),
(60, '[[montant]]', 'montant de la demande', '2024-01-04 20:11:47.237119', '2024-01-04 20:11:47.237119', NULL, 7, NULL),
(61, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:11:59.484624', '2024-01-04 20:11:59.484624', NULL, 7, NULL),
(62, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:12:17.199591', '2024-01-04 20:12:17.199591', NULL, 8, NULL),
(63, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:12:33.632419', '2024-01-04 20:12:33.632419', NULL, 8, NULL),
(64, '[[status]]', 'status de la demande', '2024-01-04 20:12:49.204690', '2024-01-04 20:12:49.204690', NULL, 8, NULL),
(65, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:13:02.209079', '2024-01-04 20:13:02.209079', NULL, 8, NULL),
(66, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:13:16.453010', '2024-01-04 20:13:16.453010', NULL, 8, NULL),
(67, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:13:30.015201', '2024-01-04 20:13:30.015201', NULL, 8, NULL),
(68, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:13:43.864398', '2024-01-04 20:13:43.864398', NULL, 8, NULL),
(69, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:14:03.569058', '2024-01-04 20:14:03.569058', NULL, 8, NULL),
(70, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:14:24.286229', '2024-01-04 20:14:24.286229', NULL, 8, NULL),
(71, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné [[montant]]: montant de la demande', '2024-01-04 20:14:39.869867', '2024-01-04 20:14:39.869867', NULL, 8, NULL),
(72, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:14:55.205568', '2024-01-04 20:14:55.205568', NULL, 8, NULL),
(73, '[[refDemande]] ', 'reference de la demande', '2024-01-04 20:15:33.757165', '2024-01-04 20:15:33.757165', NULL, 9, NULL),
(74, '[[dateDemande]]', ' date de la demande', '2024-01-04 20:16:03.290812', '2024-01-04 20:16:03.290812', NULL, 9, NULL),
(75, '[[status]]', 'status de la demande', '2024-01-04 20:16:22.777555', '2024-01-04 20:16:22.777555', NULL, 9, NULL),
(76, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:16:45.426932', '2024-01-04 20:16:45.426932', NULL, 9, NULL),
(77, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:17:05.128177', '2024-01-04 20:17:05.128177', NULL, 9, NULL),
(78, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:17:24.439635', '2024-01-04 20:17:24.439635', NULL, 9, NULL),
(79, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:17:38.562761', '2024-01-04 20:17:38.562761', NULL, 9, NULL),
(80, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:17:55.163000', '2024-01-04 20:17:55.163000', NULL, 9, NULL),
(81, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:18:08.755994', '2024-01-04 20:18:08.755994', NULL, 9, NULL),
(82, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:18:23.653907', '2024-01-04 20:18:23.653907', NULL, 9, NULL),
(83, '[[montant]]', 'montant de la demande', '2024-01-04 20:18:36.708584', '2024-01-04 20:18:36.708584', NULL, 9, NULL),
(84, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:18:52.576567', '2024-01-04 20:18:52.576567', NULL, 9, NULL),
(85, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:19:16.112121', '2024-01-04 20:19:16.112121', NULL, 10, NULL),
(86, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:19:40.143432', '2024-01-04 20:19:40.143432', NULL, 10, NULL),
(87, '[[status]]', 'status de la demande', '2024-01-04 20:20:02.928778', '2024-01-04 20:20:02.928778', NULL, 10, NULL),
(88, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:20:17.923802', '2024-01-04 20:20:17.923802', NULL, 10, NULL),
(89, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:20:36.811286', '2024-01-04 20:20:36.811286', NULL, 10, NULL),
(90, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:20:52.265126', '2024-01-04 20:20:52.265126', NULL, 10, NULL),
(91, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:21:14.472749', '2024-01-04 20:21:14.472749', NULL, 10, NULL),
(92, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:21:35.612070', '2024-01-04 20:21:35.612070', NULL, 10, NULL),
(93, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:21:56.054057', '2024-01-04 20:21:56.054057', NULL, 10, NULL),
(94, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:22:16.901567', '2024-01-04 20:22:16.901567', NULL, 10, NULL),
(95, '[[montant]]', 'montant de la demande', '2024-01-04 20:22:34.255573', '2024-01-04 20:22:34.255573', NULL, 10, NULL),
(96, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:22:50.619130', '2024-01-04 20:22:50.619130', NULL, 10, NULL),
(97, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:23:11.119285', '2024-01-04 20:23:11.119285', NULL, 11, NULL),
(98, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:23:29.662868', '2024-01-04 20:23:29.662868', NULL, 11, NULL),
(99, '[[status]]', 'status de la demande', '2024-01-04 20:23:49.316615', '2024-01-04 20:23:49.316615', NULL, 11, NULL),
(100, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:24:05.344374', '2024-01-04 20:24:28.000000', NULL, 11, NULL),
(101, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:26:17.692239', '2024-01-04 20:26:17.692239', NULL, 11, NULL),
(102, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:26:32.817803', '2024-01-04 20:26:32.817803', NULL, 11, NULL),
(103, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:26:56.448210', '2024-01-04 20:26:56.448210', NULL, 11, NULL),
(104, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:27:09.329995', '2024-01-04 20:27:09.329995', NULL, 11, NULL),
(105, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:27:24.077096', '2024-01-04 20:27:24.077096', NULL, 11, NULL),
(106, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné', '2024-01-04 20:27:46.937638', '2024-01-04 20:27:46.937638', NULL, 11, NULL),
(107, '[[montant]]', 'montant de la demande', '2024-01-04 20:28:02.819207', '2024-01-04 20:28:02.819207', NULL, 11, NULL),
(108, '[[status]] ', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:28:42.214594', '2024-01-04 20:28:42.214594', NULL, 11, NULL),
(109, '[[refDemande]]', 'reference de la demande', '2024-01-04 20:29:03.981240', '2024-01-04 20:29:03.981240', NULL, 12, NULL),
(110, '[[dateDemande]]', 'date de la demande', '2024-01-04 20:29:20.680817', '2024-01-04 20:29:20.680817', NULL, 12, NULL),
(111, '[[status]]', 'status de la demande', '2024-01-04 20:29:41.516048', '2024-01-04 20:29:41.516048', NULL, 12, NULL),
(112, '[[nom]]', 'nom de l\'agence ou de la nouvelle agence', '2024-01-04 20:29:58.520305', '2024-01-04 20:29:58.520305', NULL, 12, NULL),
(113, '[[Typedemande:libelle]]', 'libelle type demande', '2024-01-04 20:30:28.392264', '2024-01-04 20:30:28.392264', NULL, 12, NULL),
(114, '[[code]]', 'categorie d\'abonné', '2024-01-04 20:30:44.998155', '2024-01-04 20:30:44.998155', NULL, 12, NULL),
(115, '[[Abonnement:refAbo]]', 'reference d\'abonnement', '2024-01-04 20:31:04.677911', '2024-01-04 20:31:04.677911', NULL, 12, NULL),
(116, '[[nomCompletBeneficiaire]]', 'nom de l\'abonné', '2024-01-04 20:31:21.969086', '2024-01-04 20:31:21.969086', NULL, 12, NULL),
(117, '[[telephoneBeneficiaire]]', 'telephone de l\'abonné', '2024-01-04 20:31:46.349773', '2024-01-04 20:31:46.349773', NULL, 12, NULL),
(118, '[[SecteurActivite:libelle]]', 'le libelle du secteur d\'activité de l\'abonné [[montant]]: montant de la demande', '2024-01-04 20:32:03.529656', '2024-01-04 20:32:03.529656', NULL, 12, NULL),
(119, '[[status]]', 'le status de ma demande qui est accepté ou rejeté (champ a completer dans la base)', '2024-01-04 20:32:18.134571', '2024-01-04 20:32:18.134571', NULL, 12, NULL),
(120, '[[refColis]]', 'référence du colis', '2024-01-04 20:32:44.725175', '2024-01-04 20:32:44.725175', NULL, 14, NULL),
(121, '[[estLivre]]', 'statut du colis', '2024-01-04 20:32:58.639613', '2024-01-04 20:32:58.639613', NULL, 14, NULL),
(122, '[[Abonnement:Abonne:telephone]]', 'téléphone de l\'abonnement', '2024-01-04 20:33:15.536890', '2024-01-04 20:33:15.536890', NULL, 14, NULL),
(123, '[[montant]]', 'montant de la demande', '2024-01-04 20:56:07.553026', '2024-01-04 20:56:07.553026', NULL, 8, NULL),
(124, '[[montant]]', 'montant de la demande', '2024-01-04 20:57:49.052786', '2024-01-04 20:57:49.052786', NULL, 12, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `colis`
--

CREATE TABLE IF NOT EXISTS `colis` (
  `id` int NOT NULL AUTO_INCREMENT,
  `refColis` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `infoSupp` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `estLivre` tinyint NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_692b2f2649aecff5c10bc2204b` (`refColis`),
  KEY `FK_746cd037982d2979583079fcbea` (`userCreationId`),
  KEY `FK_8f716a0e94b1088bed1327c3376` (`abonnementId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `colis`
--

INSERT INTO `colis` (`id`, `refColis`, `infoSupp`, `estLivre`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`, `abonnementId`) VALUES
(1, 'COLIS001', '', 0, '2024-01-15 18:31:22.569026', '2024-01-15 18:31:22.569026', NULL, NULL, 1);

-- --------------------------------------------------------

--
-- Structure de la table `configuration`
--

CREATE TABLE IF NOT EXISTS `configuration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `valeur` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_ab9ad275b701763de11e9d72791` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `demande`
--

CREATE TABLE IF NOT EXISTS `demande` (
  `id` int NOT NULL AUTO_INCREMENT,
  `refDemande` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `dateDemande` datetime NOT NULL,
  `nomCompletBeneficiaire` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `objet` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `autreObjet` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `telephoneBeneficiaire` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'En attente',
  `montant` int NOT NULL,
  `dateAcceptation` datetime NOT NULL,
  `dateValidation` datetime NOT NULL,
  `contenu` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `abonneId` int DEFAULT NULL,
  `categorieBeneficiaireId` int DEFAULT NULL,
  `secteurActiviteBeneficiaireId` int DEFAULT NULL,
  `nouvelleAgenceId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `userValidationId` int DEFAULT NULL,
  `userAcceptationId` int DEFAULT NULL,
  `typeDemandeId` int DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  `mpostboxId` int DEFAULT NULL,
  `motif` longtext COLLATE utf8mb4_general_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_d313ddc800d2311222b82df8d4` (`refDemande`),
  KEY `FK_a1adfcd3eebb5e4c19d3f0fa1cd` (`abonneId`),
  KEY `FK_653edef8027fa6d6d3d75ee90ce` (`categorieBeneficiaireId`),
  KEY `FK_85eb851846340816fff3da1862b` (`secteurActiviteBeneficiaireId`),
  KEY `FK_9d859c5c35332e9d9daa7e2e30e` (`nouvelleAgenceId`),
  KEY `FK_b2b8b1b131924fba351b53f9e67` (`userCreationId`),
  KEY `FK_bcc68ed9a42238415977b3ef347` (`userValidationId`),
  KEY `FK_a145fb34125fd308bb01d8bc38d` (`userAcceptationId`),
  KEY `FK_3de1a8dcd0cd68ebdb3ee445e3b` (`typeDemandeId`),
  KEY `FK_ab4b4076a223e92e4a5d97ae58d` (`abonnementId`),
  KEY `FK_b54dc95388e635ce71839979408` (`mpostboxId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `envoie_lot_detail`
--

CREATE TABLE IF NOT EXISTS `envoie_lot_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `annee` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `estEnvoyer` tinyint NOT NULL,
  `nbEnvoie` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `modeleBoiteId` int DEFAULT NULL,
  `categorieAbonneId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_1df4f15bd01e1e4121e936cf1ed` (`modeleBoiteId`),
  KEY `FK_d51a66245b0177f4900eb535647` (`categorieAbonneId`),
  KEY `FK_cec36eb5ecdaa98b0dba5cdd2a5` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `etagere`
--

CREATE TABLE IF NOT EXISTS `etagere` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_9f5936dbb617ac1c309d73f7e2` (`code`),
  KEY `FK_a4d1db4efee7742eff48a0478dc` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `modele_boite`
--

CREATE TABLE IF NOT EXISTS `modele_boite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_b542db11d1e2db518e0e406c4d` (`code`),
  KEY `FK_3652155ef8dcbccc93fae67a1c6` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `modele_boite`
--

INSERT INTO `modele_boite` (`id`, `libelle`, `code`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`) VALUES
(1, 'Petit Modèle', 'PM', '2024-01-14 06:43:22.978796', '2024-01-14 06:43:22.978796', NULL, NULL),
(2, 'Moyen Modèle', 'MM', '2024-01-14 06:43:23.064141', '2024-01-14 06:43:23.064141', NULL, NULL),
(3, 'Grand Modèle', 'GM', '2024-01-14 06:43:23.092099', '2024-01-14 06:43:23.092099', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `modele_notification`
--

CREATE TABLE IF NOT EXISTS `modele_notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `contenu` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `estActif` tinyint NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `typeNotificationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_d94f351bec848bc0d85a3f6ff66` (`typeNotificationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `mode_paiement`
--

CREATE TABLE IF NOT EXISTS `mode_paiement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_d1aab0b3585d2fdc25209dda68` (`code`),
  UNIQUE KEY `IDX_a5dbfa37c6dba0f5810d4be37f` (`libelle`),
  KEY `FK_ccbbe4d17e0026ab58799c557b7` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `mode_paiement`
--

INSERT INTO `mode_paiement` (`id`, `code`, `libelle`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`) VALUES
(1, 'ESP', 'En espèces', '2024-01-15 12:18:10.862366', '2024-01-15 12:18:10.862366', NULL, NULL),
(2, 'MM', 'Mobile Money', '2024-01-15 12:18:25.027574', '2024-01-15 12:18:25.027574', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `mpostbox`
--

CREATE TABLE IF NOT EXISTS `mpostbox` (
  `id` int NOT NULL AUTO_INCREMENT,
  `adresseVirtuelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `numero` int NOT NULL,
  `fraisAbonnement` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `abonneId` int DEFAULT NULL,
  `mpostboxId` int DEFAULT NULL,
  `bureauId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_b6f8baa6ed6fd8e82314d476e7` (`adresseVirtuelle`),
  UNIQUE KEY `IDX_da5414ad39aa2a619a7f7b9bed` (`numero`),
  KEY `FK_fb1b2695499752549b81f01bdbb` (`abonneId`),
  KEY `FK_1a410b779b646b71926af4a278a` (`mpostboxId`),
  KEY `FK_9b89a229ad5bf3157037d7a2f34` (`bureauId`),
  KEY `FK_1eb01e4c83cf4ae5c42d27cafdb` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `notification`
--

CREATE TABLE IF NOT EXISTS `notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `canal` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `message` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `estEnvoyer` tinyint NOT NULL DEFAULT '0',
  `estLu` tinyint NOT NULL DEFAULT '0',
  `paiement` int NOT NULL,
  `reabonnement` int NOT NULL,
  `abonnement` int NOT NULL,
  `campagne` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `abonneId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `modeleId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_d58b1c5bf68931d298659541fe6` (`abonneId`),
  KEY `FK_3448e6a04a9093b8515d8c2f96b` (`userCreationId`),
  KEY `FK_8daac2e0b2cbe1f1d3550f5264d` (`modeleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `operation`
--

CREATE TABLE IF NOT EXISTS `operation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `statut` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `casierId` int DEFAULT NULL,
  `colisId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_e0dda25fcfc1e332eee65baac20` (`casierId`),
  KEY `FK_3e714fe2e2cea7aa150da452758` (`colisId`),
  KEY `FK_987b42f5b5e4053d43e3c41a463` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `paiement`
--

CREATE TABLE IF NOT EXISTS `paiement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `refPaiement` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `transactionId` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `datePaiement` datetime NOT NULL,
  `montantPaye` int NOT NULL,
  `montantRestant` int NOT NULL,
  `montantRecu` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  `redevanceId` int DEFAULT NULL,
  `serviceId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `modePaiementId` int DEFAULT NULL,
  `mpostboxId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_f2cd6f49ac7ac997a3201661ec2` (`abonnementId`),
  KEY `FK_60ea402d4d35a16527861742995` (`redevanceId`),
  KEY `FK_e442278e04daeff882173effa12` (`serviceId`),
  KEY `FK_d05e4697f83b8f6fec0a3dd9452` (`userCreationId`),
  KEY `FK_fe61685939535671e26808d848e` (`modePaiementId`),
  KEY `FK_7a59048c53ceebaf4c0bd56306b` (`mpostboxId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `parametre`
--

CREATE TABLE IF NOT EXISTS `parametre` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `valeur` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `designation` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_38f6e0e2817443560f5f90720e` (`cle`),
  UNIQUE KEY `IDX_91fc35b764e3829309cdbe4c02` (`valeur`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `parametre`
--

INSERT INTO `parametre` (`id`, `cle`, `valeur`, `designation`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 'AMPOSTBOX', '5000', 'Frais d\'Abonnement MPOSTBOX', '2024-01-14 06:43:23.970763', '2024-01-14 06:43:23.970763', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `permission`
--

CREATE TABLE IF NOT EXISTS `permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_d840ea68ed61afe7a0770de082` (`nom`),
  UNIQUE KEY `IDX_b690135d86d59cc689d465ac95` (`description`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `permission`
--

INSERT INTO `permission` (`id`, `nom`, `description`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 'user_add', 'Ajouter un utilisateur', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(2, 'user_update', 'Mettre à jour l\'utilisateur', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(3, 'user_get', 'Obtenir un utilisateur', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(4, 'user_get_all', 'Get All User', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(5, 'user_delete', 'Supprimer l\'utilisateur', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(6, 'role_add', 'Ajouter un rôle', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(7, 'role_update', 'Mettre à jour le rôle', '2024-01-14 07:09:07.000000', '2024-01-14 07:09:07.000000', NULL),
(8, 'role_get', 'Obtenir un rôle', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(9, 'role_get_all', 'Obtenez tous les rôles', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(10, 'role_delete', 'Supprimer le rôle', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(11, 'permissions_add', 'Ajouter une autorisation', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(12, 'permissions_update', 'Mettre à jour l\'autorisation', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(13, 'permissions_get', 'Get Permission', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(14, 'permissions_get_all', 'Obtenez toutes les autorisations', '2024-01-14 07:09:08.000000', '2024-01-14 07:09:08.000000', NULL),
(15, 'permissions_delete', 'Supprimer l\'autorisation', '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `rayon`
--

CREATE TABLE IF NOT EXISTS `rayon` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_efa0a91b058697c2b34308c7f0` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `reclamation`
--

CREATE TABLE IF NOT EXISTS `reclamation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `refRecla` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `objet` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `reclamation` longtext COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_2d2c4292878fd7b03b145a81d32` (`abonnementId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `redevance`
--

CREATE TABLE IF NOT EXISTS `redevance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `dateRedevance` datetime NOT NULL,
  `annee` int NOT NULL,
  `refRedevance` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `montant` int NOT NULL DEFAULT '0',
  `statut` varchar(255) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'En attente',
  `arrieres` int NOT NULL,
  `estGenerer` tinyint NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  `mpostboxId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_5d7e73e0e8492e3bb883061c47e` (`abonnementId`),
  KEY `FK_f76d70bfc8df5d6c335824b8e67` (`mpostboxId`),
  KEY `FK_7a1f6e92db24005d10a428e9c09` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `redevance`
--

INSERT INTO `redevance` (`id`, `dateRedevance`, `annee`, `refRedevance`, `montant`, `statut`, `arrieres`, `estGenerer`, `createdAt`, `updatedAt`, `deletedAt`, `abonnementId`, `mpostboxId`, `userCreationId`) VALUES
(1, '2024-01-15 16:37:20', 2024, 'RE1705333040432', 7000, 'En attente', 0, 0, '2024-01-15 16:37:20.915091', '2024-01-15 16:37:20.915091', NULL, 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `region`
--

CREATE TABLE IF NOT EXISTS `region` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_828795e75157bfd7a2c7182382` (`libelle`),
  UNIQUE KEY `IDX_74f7723fdff738f92929c0056c` (`code`),
  KEY `FK_760418189cda629fe21c8572d34` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `region`
--

INSERT INTO `region` (`id`, `libelle`, `code`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`) VALUES
(1, 'Banikoara', 'BKA', '2024-01-14 06:43:24.117951', '2024-01-14 06:43:24.117951', NULL, NULL),
(2, 'Gogounou', 'GOG', '2024-01-14 06:43:24.129982', '2024-01-14 06:43:24.129982', NULL, NULL),
(3, 'Kandi', 'KAN', '2024-01-14 06:43:24.138967', '2024-01-14 06:43:24.138967', NULL, NULL),
(4, 'Karimama', 'KAR:', '2024-01-14 06:43:24.147664', '2024-01-14 06:43:24.147664', NULL, NULL),
(5, 'Malanville', 'MAL', '2024-01-14 06:43:24.159117', '2024-01-14 06:43:24.159117', NULL, NULL),
(6, 'Segbana', 'SEG', '2024-01-14 06:43:24.168794', '2024-01-14 06:43:24.168794', NULL, NULL),
(7, 'Boukoumbé', 'BOU', '2024-01-14 06:43:24.178831', '2024-01-14 06:43:24.178831', NULL, NULL),
(8, 'Cobly', 'COB', '2024-01-14 06:43:24.189699', '2024-01-14 06:43:24.189699', NULL, NULL),
(9, 'Kérou', 'KER', '2024-01-14 06:43:24.198502', '2024-01-14 06:43:24.198502', NULL, NULL),
(10, 'Kouandé', 'KOU', '2024-01-14 06:43:24.208126', '2024-01-14 06:43:24.208126', NULL, NULL),
(11, 'Matéri', 'MAT', '2024-01-14 06:43:24.218812', '2024-01-14 06:43:24.218812', NULL, NULL),
(12, 'Natitingou', 'NAT', '2024-01-14 06:43:24.230676', '2024-01-14 06:43:24.230676', NULL, NULL),
(13, 'Péhunco', 'PEH', '2024-01-14 06:43:24.242499', '2024-01-14 06:43:24.242499', NULL, NULL),
(14, 'Tanguiéta', 'TAN', '2024-01-14 06:43:24.251494', '2024-01-14 06:43:24.251494', NULL, NULL),
(15, 'Toucountouna', 'TOU', '2024-01-14 06:43:24.261814', '2024-01-14 06:43:24.261814', NULL, NULL),
(16, 'Abomey-Calavi', 'ACA', '2024-01-14 06:43:24.272769', '2024-01-14 06:43:24.272769', NULL, NULL),
(17, 'Allada', 'ALL', '2024-01-14 06:43:24.280622', '2024-01-14 06:43:24.280622', NULL, NULL),
(18, 'Kpomassè', 'KPO', '2024-01-14 06:43:24.288949', '2024-01-14 06:43:24.288949', NULL, NULL),
(19, 'Ouidah', 'OUI', '2024-01-14 06:43:24.295917', '2024-01-14 06:43:24.295917', NULL, NULL),
(20, 'Sô-Ava', 'SOA', '2024-01-14 06:43:24.306520', '2024-01-14 06:43:24.306520', NULL, NULL),
(21, 'Toffo', 'TOF', '2024-01-14 06:43:24.314160', '2024-01-14 06:43:24.314160', NULL, NULL),
(22, 'Tori-Bossito', 'TOR', '2024-01-14 06:43:24.324566', '2024-01-14 06:43:24.324566', NULL, NULL),
(23, 'Zè', 'ZE', '2024-01-14 06:43:24.335863', '2024-01-14 06:43:24.335863', NULL, NULL),
(24, 'Bembéréké', 'BEM', '2024-01-14 06:43:24.345717', '2024-01-14 06:43:24.345717', NULL, NULL),
(25, 'Kalalé', 'KAL', '2024-01-14 06:43:24.355000', '2024-01-14 06:43:24.355000', NULL, NULL),
(26, 'NDali', 'NDA', '2024-01-14 06:43:24.361351', '2024-01-14 06:43:24.361351', NULL, NULL),
(27, 'Nikki', 'NIK', '2024-01-14 06:43:24.370930', '2024-01-14 06:43:24.370930', NULL, NULL),
(28, 'Parakou', 'PAR', '2024-01-14 06:43:24.380581', '2024-01-14 06:43:24.380581', NULL, NULL),
(29, 'Pèrèrè', 'PER', '2024-01-14 06:43:24.390116', '2024-01-14 06:43:24.390116', NULL, NULL),
(30, 'Sinendé', 'SIN', '2024-01-14 06:43:24.398103', '2024-01-14 06:43:24.398103', NULL, NULL),
(31, 'Tchaourou', 'TCH', '2024-01-14 06:43:24.409262', '2024-01-14 06:43:24.409262', NULL, NULL),
(32, 'Bantè', 'BAN', '2024-01-14 06:43:24.417567', '2024-01-14 06:43:24.417567', NULL, NULL),
(33, 'Dassa-Zoumé', 'DAZ', '2024-01-14 06:43:24.426742', '2024-01-14 06:43:24.426742', NULL, NULL),
(34, 'Glazoué', 'GLA', '2024-01-14 06:43:24.436593', '2024-01-14 06:43:24.436593', NULL, NULL),
(35, 'Ouèssè', 'OUE', '2024-01-14 06:43:24.445705', '2024-01-14 06:43:24.445705', NULL, NULL),
(36, 'Savalou', 'SVL', '2024-01-14 06:43:24.455297', '2024-01-14 06:43:24.455297', NULL, NULL),
(37, 'Savè', 'SAV', '2024-01-14 06:43:24.462658', '2024-01-14 06:43:24.462658', NULL, NULL),
(38, 'Aplahoué', 'APL', '2024-01-14 06:43:24.470988', '2024-01-14 06:43:24.470988', NULL, NULL),
(39, 'Djakotomey', 'DJA', '2024-01-14 06:43:24.479240', '2024-01-14 06:43:24.479240', NULL, NULL),
(40, 'Dogbo', 'DOG', '2024-01-14 06:43:24.488269', '2024-01-14 06:43:24.488269', NULL, NULL),
(41, 'Klouékanmè', 'KLO', '2024-01-14 06:43:24.497275', '2024-01-14 06:43:24.497275', NULL, NULL),
(42, 'Lalo', 'LAL', '2024-01-14 06:43:24.506946', '2024-01-14 06:43:24.506946', NULL, NULL),
(43, 'Toviklin', 'TOV', '2024-01-14 06:43:24.516290', '2024-01-14 06:43:24.516290', NULL, NULL),
(44, 'Bassila', 'BAS', '2024-01-14 06:43:24.525122', '2024-01-14 06:43:24.525122', NULL, NULL),
(45, 'Copargo', 'COP', '2024-01-14 06:43:24.532679', '2024-01-14 06:43:24.532679', NULL, NULL),
(46, 'Djougou', 'DJO', '2024-01-14 06:43:24.541101', '2024-01-14 06:43:24.541101', NULL, NULL),
(47, 'Ouaké', 'OUA', '2024-01-14 06:43:24.549636', '2024-01-14 06:43:24.549636', NULL, NULL),
(48, 'Cotonou', 'COT', '2024-01-14 06:43:24.558326', '2024-01-14 06:43:24.558326', NULL, NULL),
(49, 'Athiémé', 'ATH', '2024-01-14 06:43:24.565352', '2024-01-14 06:43:24.565352', NULL, NULL),
(50, 'Bopa', 'BOP', '2024-01-14 06:43:24.575745', '2024-01-14 06:43:24.575745', NULL, NULL),
(51, 'Comè', 'COM', '2024-01-14 06:43:24.583163', '2024-01-14 06:43:24.583163', NULL, NULL),
(52, 'Grand-Popo', 'GRA', '2024-01-14 06:43:24.590610', '2024-01-14 06:43:24.590610', NULL, NULL),
(53, 'Houéyogbé', 'HOU', '2024-01-14 06:43:24.597941', '2024-01-14 06:43:24.597941', NULL, NULL),
(54, 'Lokossa', 'LOK', '2024-01-14 06:43:24.606308', '2024-01-14 06:43:24.606308', NULL, NULL),
(55, 'Adjarra', 'AJA', '2024-01-14 06:43:24.613946', '2024-01-14 06:43:24.613946', NULL, NULL),
(56, 'Adjohoun', 'ADN', '2024-01-14 06:43:24.623379', '2024-01-14 06:43:24.623379', NULL, NULL),
(57, 'Aguégués', 'AGU', '2024-01-14 06:43:24.631183', '2024-01-14 06:43:24.631183', NULL, NULL),
(58, 'Akpro-Missérété', 'AKP', '2024-01-14 06:43:24.643178', '2024-01-14 06:43:24.643178', NULL, NULL),
(59, 'Avrankou', 'AVR', '2024-01-14 06:43:24.652434', '2024-01-14 06:43:24.652434', NULL, NULL),
(60, 'Bonou', 'BON', '2024-01-14 06:43:24.660749', '2024-01-14 06:43:24.660749', NULL, NULL),
(61, 'Dangbo', 'DAN', '2024-01-14 06:43:24.670057', '2024-01-14 06:43:24.670057', NULL, NULL),
(62, 'Porto-Novo', 'POR', '2024-01-14 06:43:24.677711', '2024-01-14 06:43:24.677711', NULL, NULL),
(63, 'Sèmè-Kpodji', 'SEM', '2024-01-14 06:43:24.686561', '2024-01-14 06:43:24.686561', NULL, NULL),
(64, 'Adja-Ouèrè', 'ADO', '2024-01-14 06:43:24.695555', '2024-01-14 06:43:24.695555', NULL, NULL),
(65, 'Ifangni', 'IFA', '2024-01-14 06:43:24.704976', '2024-01-14 06:43:24.704976', NULL, NULL),
(66, 'Kétou', 'KET', '2024-01-14 06:43:24.715402', '2024-01-14 06:43:24.715402', NULL, NULL),
(67, 'Pobè', 'POB', '2024-01-14 06:43:24.723422', '2024-01-14 06:43:24.723422', NULL, NULL),
(68, 'Sakété', 'SAK', '2024-01-14 06:43:24.731052', '2024-01-14 06:43:24.731052', NULL, NULL),
(69, 'Abomey', 'ABO', '2024-01-14 06:43:24.739448', '2024-01-14 06:43:24.739448', NULL, NULL),
(70, 'Agbangnizoun', 'AGB', '2024-01-14 06:43:24.747693', '2024-01-14 06:43:24.747693', NULL, NULL),
(71, 'Bohicon', 'BOH', '2024-01-14 06:43:24.762480', '2024-01-14 06:43:24.762480', NULL, NULL),
(72, 'Covè', 'COV', '2024-01-14 06:43:24.771025', '2024-01-14 06:43:24.771025', NULL, NULL),
(73, 'Djidja', 'DJI', '2024-01-14 06:43:24.781535', '2024-01-14 06:43:24.781535', NULL, NULL),
(74, 'Ouinhi', 'OUH', '2024-01-14 06:43:24.792002', '2024-01-14 06:43:24.792002', NULL, NULL),
(75, 'Za-Kpota', 'ZAK', '2024-01-14 06:43:24.799729', '2024-01-14 06:43:24.799729', NULL, NULL),
(76, 'Zagnanado', 'ZAG', '2024-01-14 06:43:24.809945', '2024-01-14 06:43:24.809945', NULL, NULL),
(77, 'Zogbodomey', 'ZOG', '2024-01-14 06:43:24.817101', '2024-01-14 06:43:24.817101', NULL, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `role`
--

CREATE TABLE IF NOT EXISTS `role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nom` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `privileges` text COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_bf38105dbf51728ebae7ed542a` (`nom`),
  UNIQUE KEY `IDX_c216a82ffa1e4c6d0224c34927` (`description`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `role`
--

INSERT INTO `role` (`id`, `nom`, `description`, `privileges`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 'admin', 'System Admin ', '1,2,3,4,5,6,7,8,9,10,11,12,13,14,15', '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(2, 'user', 'Utilisacteur ', '2,4,8,9,12', '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(3, 'abonne', 'Abonne', '', '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `role_permission`
--

CREATE TABLE IF NOT EXISTS `role_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `roleId` int NOT NULL,
  `permissionId` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_e3130a39c1e4a740d044e685730` (`roleId`),
  KEY `FK_72e80be86cab0e93e67ed1a7a9a` (`permissionId`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `role_permission`
--

INSERT INTO `role_permission` (`id`, `roleId`, `permissionId`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 1, 1, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(2, 1, 2, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(3, 1, 3, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(4, 1, 4, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(5, 1, 5, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(6, 1, 6, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(7, 1, 7, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(8, 1, 8, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(9, 1, 9, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(10, 1, 10, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(11, 1, 11, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(12, 1, 12, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(13, 1, 13, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(14, 1, 14, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(15, 1, 15, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(16, 2, 2, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(17, 2, 4, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(18, 2, 8, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(19, 2, 9, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL),
(20, 2, 12, '2024-01-14 07:09:09.000000', '2024-01-14 07:09:09.000000', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `secteur_activite`
--

CREATE TABLE IF NOT EXISTS `secteur_activite` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_83023442b2bed21e5ca4badcf7` (`libelle`),
  UNIQUE KEY `IDX_761f3279270ff8e57d30aa51d0` (`code`),
  KEY `FK_ecd99f3279e3d1a0ac0d387268f` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `secteur_activite`
--

INSERT INTO `secteur_activite` (`id`, `libelle`, `code`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`) VALUES
(1, 'Agriculture', 'AGR', '2024-01-14 06:43:24.997659', '2024-01-14 06:43:24.997659', NULL, NULL),
(2, 'Agroalimentaire', 'AGA', '2024-01-14 06:43:25.039453', '2024-01-14 06:43:25.039453', NULL, NULL),
(3, 'Artisanat', 'ART', '2024-01-14 06:43:25.059605', '2024-01-14 06:43:25.059605', NULL, NULL),
(4, 'BTP et matériaux de construction', 'BTP', '2024-01-14 06:43:25.072642', '2024-01-14 06:43:25.072642', NULL, NULL),
(5, 'énergie', 'ENE', '2024-01-14 06:43:25.082569', '2024-01-14 06:43:25.082569', NULL, NULL),
(6, 'élevage et la pêche', 'ELE', '2024-01-14 06:43:25.092844', '2024-01-14 06:43:25.092844', NULL, NULL),
(7, 'Finance', 'FIN', '2024-01-14 06:43:25.101547', '2024-01-14 06:43:25.101547', NULL, NULL),
(8, 'Mines et Hydrocarbures', 'MIN', '2024-01-14 06:43:25.113372', '2024-01-14 06:43:25.113372', NULL, NULL),
(9, 'Commerce', 'COM', '2024-01-14 06:43:25.125132', '2024-01-14 06:43:25.125132', NULL, NULL),
(10, 'Tourisme', 'TOU', '2024-01-14 06:43:25.134862', '2024-01-14 06:43:25.134862', NULL, NULL),
(11, 'Transport et Logistique', 'TEL', '2024-01-14 06:43:25.143778', '2024-01-14 06:43:25.143778', NULL, NULL),
(12, 'Technologies de l’Information et de la Communication', 'TIC', '2024-01-14 06:43:25.152561', '2024-01-14 06:43:25.152561', NULL, NULL),
(13, 'Industrie', 'IND', '2024-01-14 06:43:25.162104', '2024-01-14 06:43:25.162104', NULL, NULL),
(14, 'Sante', 'SAN', '2024-01-14 06:43:25.172719', '2024-01-14 06:43:25.172719', NULL, NULL),
(15, 'Education', 'EDU', '2024-01-14 06:43:25.181258', '2024-01-14 06:43:25.181258', NULL, NULL),
(16, 'kpo', 'hh', '2024-01-15 11:07:55.842376', '2024-01-15 11:08:10.000000', '2024-01-15 11:08:10.000000', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `service`
--

CREATE TABLE IF NOT EXISTS `service` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `cout` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_9bdfd14debfa10197d295f5fe0` (`libelle`),
  UNIQUE KEY `IDX_4cb3cf237c83885cc504634829` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `service`
--

INSERT INTO `service` (`id`, `libelle`, `code`, `cout`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 'Frais de changement de clef', 'FCC', 5000, '2024-01-14 06:43:23.296440', '2024-01-14 06:43:23.296440', NULL),
(2, 'Frais d\'Attestation', 'FA', 500, '2024-01-14 06:43:23.337276', '2024-01-14 06:43:23.337276', NULL),
(3, 'Frais de transfert', 'FT', 3000, '2024-01-14 06:43:23.366746', '2024-01-14 06:43:23.366746', NULL),
(4, 'Frais de cession', 'FC', 2000, '2024-01-14 06:43:23.382102', '2024-01-14 06:43:23.382102', NULL),
(5, 'Frais de Résiliation', 'FR', 0, '2024-01-14 06:43:23.398365', '2024-01-14 06:43:23.398365', NULL),
(6, 'Frais de partage d\'abonnement', 'FPA', 6000, '2024-01-14 06:43:23.458654', '2024-01-14 06:43:23.458654', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `tarif_annuel`
--

CREATE TABLE IF NOT EXISTS `tarif_annuel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `cout` int NOT NULL,
  `caution` int NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  `categorieId` int DEFAULT NULL,
  `modeleBoiteId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_82537570d983b72014f2928fb5c` (`userCreationId`),
  KEY `FK_974d40e87dcc6865687a631c929` (`categorieId`),
  KEY `FK_41b9b536cbf33553a1b16791deb` (`modeleBoiteId`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `tarif_annuel`
--

INSERT INTO `tarif_annuel` (`id`, `type`, `cout`, `caution`, `createdAt`, `updatedAt`, `deletedAt`, `userCreationId`, `categorieId`, `modeleBoiteId`) VALUES
(1, 'Ordinaire', 7000, 7000, '2024-01-14 06:43:25.426481', '2024-01-14 06:43:25.426481', NULL, NULL, 1, 1),
(2, 'Ordinaire', 15000, 7000, '2024-01-14 06:43:25.437175', '2024-01-14 06:43:25.437175', NULL, NULL, 2, 1),
(3, 'Ordinaire', 20000, 7000, '2024-01-14 06:43:25.443715', '2024-01-14 06:43:25.443715', NULL, NULL, 3, 1),
(4, 'Ordinaire', 35000, 7000, '2024-01-14 06:43:25.449330', '2024-01-14 06:43:25.449330', NULL, NULL, 4, 1),
(5, 'Ordinaire', 10000, 7000, '2024-01-14 06:43:25.458031', '2024-01-14 06:43:25.458031', NULL, NULL, 1, 2),
(6, 'Ordinaire', 20000, 7000, '2024-01-14 06:43:25.466576', '2024-01-14 06:43:25.466576', NULL, NULL, 2, 2),
(7, 'Ordinaire', 25000, 7000, '2024-01-14 06:43:25.475748', '2024-01-14 06:43:25.475748', NULL, NULL, 3, 2),
(8, 'Ordinaire', 40000, 7000, '2024-01-14 06:43:25.485073', '2024-01-14 06:43:25.485073', NULL, NULL, 4, 2),
(9, 'Ordinaire', 12000, 7000, '2024-01-14 06:43:25.492336', '2024-01-14 06:43:25.492336', NULL, NULL, 1, 3),
(10, 'Ordinaire', 25000, 7000, '2024-01-14 06:43:25.501347', '2024-01-14 06:43:25.501347', NULL, NULL, 2, 3),
(11, 'Ordinaire', 30000, 7000, '2024-01-14 06:43:25.508903', '2024-01-14 06:43:25.508903', NULL, NULL, 3, 3),
(12, 'Ordinaire', 50000, 7000, '2024-01-14 06:43:25.519801', '2024-01-15 11:25:04.000000', NULL, NULL, 4, 3);

-- --------------------------------------------------------

--
-- Structure de la table `transfert`
--

CREATE TABLE IF NOT EXISTS `transfert` (
  `id` int NOT NULL AUTO_INCREMENT,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `ancienneAgenceId` int DEFAULT NULL,
  `nouvelleAgenceId` int DEFAULT NULL,
  `abonnementId` int DEFAULT NULL,
  `boiteId` int DEFAULT NULL,
  `mpostboxId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_3389a03b1bff7e7cd27c59ab0a3` (`ancienneAgenceId`),
  KEY `FK_f3cdfbb04c2bbe19fb9458b71ce` (`nouvelleAgenceId`),
  KEY `FK_a31df0c52ffa15ad3245b7d4b88` (`abonnementId`),
  KEY `FK_cc81f32f80da88a788f3269249e` (`boiteId`),
  KEY `FK_707e5a6027d40feeb9ec3f1982c` (`mpostboxId`),
  KEY `FK_86490561311d84d2a9edaf8df50` (`userCreationId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Structure de la table `type_demande`
--

CREATE TABLE IF NOT EXISTS `type_demande` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  `serviceId` int DEFAULT NULL,
  `userCreationId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_2b40096ae0a4a934b7bc8887b7` (`code`),
  UNIQUE KEY `REL_9019dcf02633c7553285a9cfa3` (`serviceId`),
  KEY `FK_b7e2c100f9c25b994dd8fa581f4` (`userCreationId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `type_demande`
--

INSERT INTO `type_demande` (`id`, `libelle`, `code`, `createdAt`, `updatedAt`, `deletedAt`, `serviceId`, `userCreationId`) VALUES
(1, 'Abonnement', 'DAA', '2024-01-14 06:43:23.742874', '2024-01-14 06:43:23.742874', NULL, NULL, NULL),
(2, 'Transfert', 'DT', '2024-01-14 06:43:23.771990', '2024-01-15 11:16:37.000000', NULL, 3, NULL),
(3, 'Cession', 'DC', '2024-01-14 06:43:23.797513', '2024-01-15 11:16:24.000000', NULL, 4, NULL),
(4, 'Attestation', 'DA', '2024-01-14 06:43:23.820469', '2024-01-15 11:16:17.000000', NULL, 2, NULL),
(5, 'Résiliation', 'DR', '2024-01-14 06:43:23.838612', '2024-01-15 11:16:07.000000', NULL, 5, NULL),
(6, 'Changement de clef', 'DCC', '2024-01-14 06:43:23.846663', '2024-01-15 11:15:55.000000', NULL, 1, NULL),
(7, 'Partage d\'abonnement', 'DPA', '2024-01-14 06:43:23.857938', '2024-01-15 11:15:41.000000', NULL, 6, NULL);

-- --------------------------------------------------------

--
-- Structure de la table `type_notification`
--

CREATE TABLE IF NOT EXISTS `type_notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `canal` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `createdAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updatedAt` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),
  `deletedAt` datetime(6) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Déchargement des données de la table `type_notification`
--

INSERT INTO `type_notification` (`id`, `libelle`, `canal`, `createdAt`, `updatedAt`, `deletedAt`) VALUES
(1, 'Notification de redevance', 'sms', '2024-01-04 19:35:42.574686', '2024-01-04 19:35:42.574686', NULL),
(2, 'Notification de paiement abonnement', 'sms', '2024-01-04 19:35:59.545962', '2024-01-04 19:35:59.545962', NULL),
(3, 'Notification de paiement redevance', 'sms', '2024-01-04 19:36:11.328259', '2024-01-04 19:36:11.328259', NULL),
(4, 'Notification de paiement service', 'sms', '2024-01-04 19:36:23.696604', '2024-01-04 19:36:23.696604', NULL),
(5, 'Notification de demande d\'abonnement', 'sms', '2024-01-04 19:36:33.529190', '2024-01-04 19:36:33.529190', NULL),
(6, 'Notification de demande de transfert', 'sms', '2024-01-04 19:36:52.843529', '2024-01-04 19:36:52.843529', NULL),
(7, 'Notification de demande de cession', 'sms', '2024-01-04 19:37:00.699765', '2024-01-04 19:37:00.699765', NULL),
(8, 'Notification de demande d\'attestation', 'sms', '2024-01-04 19:37:08.942409', '2024-01-04 19:37:08.942409', NULL),
(9, 'Notification de demande de résiliation', 'sms', '2024-01-04 19:37:19.382193', '2024-01-04 19:37:19.382193', NULL),
(10, 'Notification de demande de partage d\'abonnement', 'sms', '2024-01-04 19:37:29.126311', '2024-01-04 19:37:29.126311', NULL),
(11, 'Notification de demande de changement de clé', 'sms', '2024-01-04 19:37:40.599110', '2024-01-04 19:37:40.599110', NULL),
(12, 'Notification de demande de réclamation', 'sms', '2024-01-04 19:37:51.599524', '2024-01-04 19:37:51.599524', NULL),
(13, 'Notification de vœux', 'sms', '2024-01-04 19:38:02.428454', '2024-01-04 19:38:54.000000', '2024-01-04 19:38:54.000000'),
(14, 'Notification d\'envoi de réception d\'un colis', 'sms', '2024-01-04 19:38:30.919401', '2024-01-04 19:38:44.000000', NULL);

--
-- Contraintes pour la table `abonnement`
--
ALTER TABLE `abonnement`
  ADD CONSTRAINT `FK_0e27b23ae433d3d692a52c34ac8` FOREIGN KEY (`bureauId`) REFERENCES `bureau` (`id`),
  ADD CONSTRAINT `FK_5a815acf0d126852c78d8bc15ba` FOREIGN KEY (`tarifId`) REFERENCES `tarif_annuel` (`id`),
  ADD CONSTRAINT `FK_8778bde533a6efacae3428d9347` FOREIGN KEY (`abonneId`) REFERENCES `abonne` (`id`),
  ADD CONSTRAINT `FK_96c5fdaad046ac6b6f84fbac554` FOREIGN KEY (`boiteId`) REFERENCES `boite_postale` (`id`),
  ADD CONSTRAINT `FK_c7ee940b07f8e1929f88f3fbe7b` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_cc0b4ecb98fc92cfed923727e96` FOREIGN KEY (`adressePostaleId`) REFERENCES `adresse_postale` (`id`),
  ADD CONSTRAINT `FK_d2de8f28f69f5e391c7260f346d` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`);

--
-- Contraintes pour la table `adresse_postale`
--
ALTER TABLE `adresse_postale`
  ADD CONSTRAINT `FK_130097220f9f81424f3a31db086` FOREIGN KEY (`agenceOrigineId`) REFERENCES `bureau` (`id`),
  ADD CONSTRAINT `FK_86ac0d5656a85112b0a14f275c0` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `attestation`
--
ALTER TABLE `attestation`
  ADD CONSTRAINT `FK_074e408aed4a351f4eb711d186e` FOREIGN KEY (`demandeId`) REFERENCES `demande` (`id`),
  ADD CONSTRAINT `FK_316deae72c7c7ed95165a635035` FOREIGN KEY (`modeleId`) REFERENCES `modele_notification` (`id`),
  ADD CONSTRAINT `FK_c1e8f3fb6bc1c7c03d3b1f3f93b` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `boite_postale`
--
ALTER TABLE `boite_postale`
  ADD CONSTRAINT `FK_51e8142479a5219eed67ae3eac9` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_53cdf76a2c06a273f3af9ff8a3f` FOREIGN KEY (`modeleId`) REFERENCES `modele_boite` (`id`),
  ADD CONSTRAINT `FK_ee71ddc21eef5d68ef6406f6049` FOREIGN KEY (`bureauId`) REFERENCES `bureau` (`id`);

--
-- Contraintes pour la table `bureau`
--
ALTER TABLE `bureau`
  ADD CONSTRAINT `FK_ae0025cb9fe0b2704191e238158` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_e2040749b8706056d5494eea905` FOREIGN KEY (`regionId`) REFERENCES `region` (`id`);

--
-- Contraintes pour la table `campagne`
--
ALTER TABLE `campagne`
  ADD CONSTRAINT `FK_a8b2cdceb9cea9c4ae2b4f5e965` FOREIGN KEY (`typeNotificationId`) REFERENCES `type_notification` (`id`),
  ADD CONSTRAINT `FK_a90be28f91ab111387010bb9254` FOREIGN KEY (`categorieAbonneId`) REFERENCES `categorie_abonne` (`id`),
  ADD CONSTRAINT `FK_adacf735b30f47129ee0cd85e20` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `casier`
--
ALTER TABLE `casier`
  ADD CONSTRAINT `FK_1da239a383233092a86f7052c2b` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_9238466c7569e3dd18f265d6b01` FOREIGN KEY (`etagereId`) REFERENCES `etagere` (`id`);

--
-- Contraintes pour la table `categorie_abonne`
--
ALTER TABLE `categorie_abonne`
  ADD CONSTRAINT `FK_2c19e2bcab177a39907e4d2b99e` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `cle_type_notification`
--
ALTER TABLE `cle_type_notification`
  ADD CONSTRAINT `FK_843d3af5bd2727756ffb96a7a09` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_a00ad69d9429749125ef11f3d5a` FOREIGN KEY (`typeNotificationId`) REFERENCES `type_notification` (`id`);

--
-- Contraintes pour la table `colis`
--
ALTER TABLE `colis`
  ADD CONSTRAINT `FK_746cd037982d2979583079fcbea` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_8f716a0e94b1088bed1327c3376` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`);

--
-- Contraintes pour la table `configuration`
--
ALTER TABLE `configuration`
  ADD CONSTRAINT `FK_ab9ad275b701763de11e9d72791` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `demande`
--
ALTER TABLE `demande`
  ADD CONSTRAINT `FK_3de1a8dcd0cd68ebdb3ee445e3b` FOREIGN KEY (`typeDemandeId`) REFERENCES `type_demande` (`id`),
  ADD CONSTRAINT `FK_653edef8027fa6d6d3d75ee90ce` FOREIGN KEY (`categorieBeneficiaireId`) REFERENCES `categorie_abonne` (`id`),
  ADD CONSTRAINT `FK_85eb851846340816fff3da1862b` FOREIGN KEY (`secteurActiviteBeneficiaireId`) REFERENCES `secteur_activite` (`id`),
  ADD CONSTRAINT `FK_9d859c5c35332e9d9daa7e2e30e` FOREIGN KEY (`nouvelleAgenceId`) REFERENCES `bureau` (`id`),
  ADD CONSTRAINT `FK_a145fb34125fd308bb01d8bc38d` FOREIGN KEY (`userAcceptationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_a1adfcd3eebb5e4c19d3f0fa1cd` FOREIGN KEY (`abonneId`) REFERENCES `abonne` (`id`),
  ADD CONSTRAINT `FK_ab4b4076a223e92e4a5d97ae58d` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`),
  ADD CONSTRAINT `FK_b2b8b1b131924fba351b53f9e67` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_b54dc95388e635ce71839979408` FOREIGN KEY (`mpostboxId`) REFERENCES `mpostbox` (`id`),
  ADD CONSTRAINT `FK_bcc68ed9a42238415977b3ef347` FOREIGN KEY (`userValidationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `envoie_lot_detail`
--
ALTER TABLE `envoie_lot_detail`
  ADD CONSTRAINT `FK_1df4f15bd01e1e4121e936cf1ed` FOREIGN KEY (`modeleBoiteId`) REFERENCES `modele_boite` (`id`),
  ADD CONSTRAINT `FK_cec36eb5ecdaa98b0dba5cdd2a5` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_d51a66245b0177f4900eb535647` FOREIGN KEY (`categorieAbonneId`) REFERENCES `categorie_abonne` (`id`);

--
-- Contraintes pour la table `etagere`
--
ALTER TABLE `etagere`
  ADD CONSTRAINT `FK_a4d1db4efee7742eff48a0478dc` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `modele_boite`
--
ALTER TABLE `modele_boite`
  ADD CONSTRAINT `FK_3652155ef8dcbccc93fae67a1c6` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `modele_notification`
--
ALTER TABLE `modele_notification`
  ADD CONSTRAINT `FK_d94f351bec848bc0d85a3f6ff66` FOREIGN KEY (`typeNotificationId`) REFERENCES `type_notification` (`id`);

--
-- Contraintes pour la table `mode_paiement`
--
ALTER TABLE `mode_paiement`
  ADD CONSTRAINT `FK_ccbbe4d17e0026ab58799c557b7` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `mpostbox`
--
ALTER TABLE `mpostbox`
  ADD CONSTRAINT `FK_1a410b779b646b71926af4a278a` FOREIGN KEY (`mpostboxId`) REFERENCES `mpostbox` (`id`),
  ADD CONSTRAINT `FK_1eb01e4c83cf4ae5c42d27cafdb` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_9b89a229ad5bf3157037d7a2f34` FOREIGN KEY (`bureauId`) REFERENCES `bureau` (`id`),
  ADD CONSTRAINT `FK_fb1b2695499752549b81f01bdbb` FOREIGN KEY (`abonneId`) REFERENCES `abonne` (`id`);

--
-- Contraintes pour la table `notification`
--
ALTER TABLE `notification`
  ADD CONSTRAINT `FK_3448e6a04a9093b8515d8c2f96b` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_8daac2e0b2cbe1f1d3550f5264d` FOREIGN KEY (`modeleId`) REFERENCES `modele_notification` (`id`),
  ADD CONSTRAINT `FK_d58b1c5bf68931d298659541fe6` FOREIGN KEY (`abonneId`) REFERENCES `abonne` (`id`);

--
-- Contraintes pour la table `operation`
--
ALTER TABLE `operation`
  ADD CONSTRAINT `FK_3e714fe2e2cea7aa150da452758` FOREIGN KEY (`colisId`) REFERENCES `colis` (`id`),
  ADD CONSTRAINT `FK_987b42f5b5e4053d43e3c41a463` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_e0dda25fcfc1e332eee65baac20` FOREIGN KEY (`casierId`) REFERENCES `casier` (`id`);

--
-- Contraintes pour la table `paiement`
--
ALTER TABLE `paiement`
  ADD CONSTRAINT `FK_60ea402d4d35a16527861742995` FOREIGN KEY (`redevanceId`) REFERENCES `redevance` (`id`),
  ADD CONSTRAINT `FK_7a59048c53ceebaf4c0bd56306b` FOREIGN KEY (`mpostboxId`) REFERENCES `mpostbox` (`id`),
  ADD CONSTRAINT `FK_d05e4697f83b8f6fec0a3dd9452` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_e442278e04daeff882173effa12` FOREIGN KEY (`serviceId`) REFERENCES `service` (`id`),
  ADD CONSTRAINT `FK_f2cd6f49ac7ac997a3201661ec2` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`),
  ADD CONSTRAINT `FK_fe61685939535671e26808d848e` FOREIGN KEY (`modePaiementId`) REFERENCES `mode_paiement` (`id`);

--
-- Contraintes pour la table `reclamation`
--
ALTER TABLE `reclamation`
  ADD CONSTRAINT `FK_2d2c4292878fd7b03b145a81d32` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`);

--
-- Contraintes pour la table `redevance`
--
ALTER TABLE `redevance`
  ADD CONSTRAINT `FK_5d7e73e0e8492e3bb883061c47e` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`),
  ADD CONSTRAINT `FK_7a1f6e92db24005d10a428e9c09` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_f76d70bfc8df5d6c335824b8e67` FOREIGN KEY (`mpostboxId`) REFERENCES `mpostbox` (`id`);

--
-- Contraintes pour la table `region`
--
ALTER TABLE `region`
  ADD CONSTRAINT `FK_760418189cda629fe21c8572d34` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `role_permission`
--
ALTER TABLE `role_permission`
  ADD CONSTRAINT `FK_72e80be86cab0e93e67ed1a7a9a` FOREIGN KEY (`permissionId`) REFERENCES `permission` (`id`),
  ADD CONSTRAINT `FK_e3130a39c1e4a740d044e685730` FOREIGN KEY (`roleId`) REFERENCES `role` (`id`);

--
-- Contraintes pour la table `secteur_activite`
--
ALTER TABLE `secteur_activite`
  ADD CONSTRAINT `FK_ecd99f3279e3d1a0ac0d387268f` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `tarif_annuel`
--
ALTER TABLE `tarif_annuel`
  ADD CONSTRAINT `FK_41b9b536cbf33553a1b16791deb` FOREIGN KEY (`modeleBoiteId`) REFERENCES `modele_boite` (`id`),
  ADD CONSTRAINT `FK_82537570d983b72014f2928fb5c` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_974d40e87dcc6865687a631c929` FOREIGN KEY (`categorieId`) REFERENCES `categorie_abonne` (`id`);

--
-- Contraintes pour la table `transfert`
--
ALTER TABLE `transfert`
  ADD CONSTRAINT `FK_3389a03b1bff7e7cd27c59ab0a3` FOREIGN KEY (`ancienneAgenceId`) REFERENCES `bureau` (`id`),
  ADD CONSTRAINT `FK_707e5a6027d40feeb9ec3f1982c` FOREIGN KEY (`mpostboxId`) REFERENCES `mpostbox` (`id`),
  ADD CONSTRAINT `FK_86490561311d84d2a9edaf8df50` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`),
  ADD CONSTRAINT `FK_a31df0c52ffa15ad3245b7d4b88` FOREIGN KEY (`abonnementId`) REFERENCES `abonnement` (`id`),
  ADD CONSTRAINT `FK_cc81f32f80da88a788f3269249e` FOREIGN KEY (`boiteId`) REFERENCES `boite_postale` (`id`),
  ADD CONSTRAINT `FK_f3cdfbb04c2bbe19fb9458b71ce` FOREIGN KEY (`nouvelleAgenceId`) REFERENCES `bureau` (`id`);

--
-- Contraintes pour la table `type_demande`
--
ALTER TABLE `type_demande`
  ADD CONSTRAINT `FK_9019dcf02633c7553285a9cfa31` FOREIGN KEY (`serviceId`) REFERENCES `service` (`id`),
  ADD CONSTRAINT `FK_b7e2c100f9c25b994dd8fa581f4` FOREIGN KEY (`userCreationId`) REFERENCES `user` (`id`);
COMMIT;

