--
-- Host: 127.0.0.1    Database: baseqcm
-- ------------------------------------------------------


--
-- Table structure for table `answer`
--

CREATE TABLE `answer` (
  `id` int NOT NULL AUTO_INCREMENT,
  `question_id` int NOT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_correct` tinyint(1) NOT NULL,
  `ai_generated` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_DADD4A251E27F6BF` (`question_id`),
  CONSTRAINT `FK_DADD4A251E27F6BF` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `answer`
--


--
-- Table structure for table `nl_articles`
--

CREATE TABLE `nl_articles` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `article` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `editeur` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `nl_monthnewsletter_id` int DEFAULT NULL,
  `origine` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `journaliste` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `texte` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `date` datetime NOT NULL,
  `file_attach` varchar(500) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `niveau_id` int DEFAULT NULL,
  `publier` tinyint(1) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `IDX_D5EA888AB6CA4401` (`nl_monthnewsletter_id`),
  KEY `IDX_D5EA888AB3E9C81` (`niveau_id`),
  CONSTRAINT `FK_D5EA888AB3E9C81` FOREIGN KEY (`niveau_id`) REFERENCES `nl_niveau` (`id`),
  CONSTRAINT `FK_D5EA888AB6CA4401` FOREIGN KEY (`nl_monthnewsletter_id`) REFERENCES `nl_monthnewsletters` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=503 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `nl_articles`
--



--
-- Table structure for table `nl_articles_nl_themes`
--

CREATE TABLE `nl_articles_nl_themes` (
  `id` int NOT NULL,
  `nl_article_id` int DEFAULT NULL,
  `nl_theme_id` int DEFAULT NULL,
  KEY `IDX_E2C7E86AC6176ED` (`nl_article_id`),
  KEY `IDX_E2C7E863335CD65` (`nl_theme_id`),
  CONSTRAINT `FK_E2C7E863335CD65` FOREIGN KEY (`nl_theme_id`) REFERENCES `nl_themes` (`id`),
  CONSTRAINT `FK_E2C7E86AC6176ED` FOREIGN KEY (`nl_article_id`) REFERENCES `nl_articles` (`ID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `nl_articles_nl_themes`
--

INSERT INTO `nl_articles_nl_themes` (`id`, `nl_article_id`, `nl_theme_id`) VALUES (2,159,2),(3,160,1),(4,161,3),(5,162,1),(6,163,2),(7,164,3),(8,165,1),(9,166,1),(10,192,2),(11,193,1),(12,194,2),(13,195,1),(14,196,4),(15,197,3),(16,198,2),(17,199,2),(18,200,4),(19,201,4),(20,202,4),(71,356,3),(79,263,1),(80,264,4),(81,265,4),(82,266,7),(83,267,1),(84,273,3),(85,274,3),(86,275,4),(87,276,4),(88,277,1),(89,279,4),(90,280,1),(91,281,1),(92,282,6),(93,283,1),(94,295,1),(95,296,1),(96,297,3),(97,298,1),(98,299,1),(104,320,8),(105,321,8),(106,322,1),(107,323,1),(108,324,1),(109,325,1),(110,340,5),(111,326,6),(112,341,2),(113,327,1),(114,342,1),(115,328,4),(116,343,6),(117,329,1),(118,344,1),(119,330,1),(120,331,1),(121,332,2),(122,333,3),(123,334,7),(124,335,7),(125,336,1),(126,337,1),(127,338,6),(128,339,6),(129,300,1),(130,301,6),(131,302,4),(132,303,8),(133,304,1),(134,305,1),(135,306,5),(136,307,6),(137,308,8),(138,309,1),(139,310,1),(140,311,1),(141,312,7),(142,313,4),(143,314,4),(144,315,4),(145,316,1),(146,317,4),(147,318,3),(148,319,2),(149,223,2),(150,224,1),(151,225,1),(152,226,1),(153,227,1),(154,228,7),(155,229,4),(156,230,1),(157,231,1),(158,232,1),(159,233,1),(160,234,1),(161,235,1),(162,236,1),(163,237,1),(164,238,4),(165,239,1),(166,240,8),(167,241,1),(168,242,1),(169,243,4),(170,244,6),(171,245,1),(172,246,1),(173,247,1),(174,248,1),(175,249,1),(176,250,1),(177,251,7),(178,252,4),(179,253,8),(180,254,4),(181,255,1),(182,256,7),(183,257,1),(184,258,4),(185,259,8),(186,260,4),(187,261,7),(188,262,1),(189,203,1),(190,204,1),(191,205,5),(192,206,4),(193,207,4),(194,208,2),(195,209,4),(196,210,5),(197,211,1),(198,212,5),(199,213,1),(200,214,3),(201,215,4),(202,216,1),(203,217,6),(204,218,5),(205,219,3),(206,220,7),(207,221,1),(208,222,1),(220,406,1),(273,412,1),(384,158,1),(385,413,4),(386,415,8),(387,415,4),(388,415,5),(403,414,1),(404,414,4),(405,411,8),(406,411,4),(407,411,5),(408,410,3),(409,410,10),(410,409,1),(411,409,4),(412,408,1),(413,408,4),(414,407,3),(415,407,10),(416,405,3),(417,405,1),(418,404,3),(419,404,1),(420,403,7),(421,403,8),(422,403,1),(423,402,2),(424,402,8),(425,402,5),(426,401,7),(427,401,9),(428,400,3),(429,400,1),(430,399,9),(431,399,4),(432,398,9),(433,398,1),(434,392,9),(435,392,4),(436,393,3),(437,393,1),(438,397,7),(439,397,3),(440,396,3),(441,396,1),(442,395,4),(443,395,10),(444,394,2),(445,394,8),(446,382,3),(447,382,1),(448,382,10),(449,383,3),(450,383,8),(451,384,7),(452,384,8),(453,384,6),(454,385,3),(455,385,1),(456,385,10),(457,386,2),(458,386,4),(459,387,3),(460,387,6),(461,381,10),(462,381,6),(463,380,3),(464,380,10),(465,380,6),(466,379,3),(467,379,8),(468,379,5),(469,378,1),(470,378,4),(471,377,8),(472,377,1),(473,377,4),(474,376,2),(475,376,4),(476,376,10),(477,375,3),(478,375,1),(479,374,3),(480,374,9),(481,374,10),(482,373,7),(483,373,1),(484,373,4),(485,372,3),(486,372,4),(487,371,2),(488,371,8),(489,371,4),(490,370,9),(491,370,2),(492,369,9),(493,369,2),(494,369,10),(495,368,2),(496,368,8),(497,367,3),(498,367,8),(499,367,4),(500,366,3),(501,366,9),(502,366,10),(503,365,2),(504,365,8),(505,364,3),(506,364,1),(507,346,3),(508,346,4),(509,346,10),(510,345,9),(511,345,2),(512,345,8),(513,347,3),(514,347,8),(515,347,1),(516,348,7),(517,348,1),(518,348,4),(519,349,3),(520,349,9),(521,349,1),(522,350,3),(523,350,10),(524,351,3),(525,351,1),(526,352,1),(527,352,4),(528,353,3),(529,353,8),(530,353,1),(531,354,2),(532,354,8),(533,354,4),(534,355,3),(535,355,2),(536,355,8),(537,357,2),(538,357,4),(539,358,10),(540,358,6),(541,359,3),(542,359,1),(543,359,4),(544,360,3),(545,360,1),(546,360,10),(547,362,3),(548,362,1),(549,362,4),(550,363,9),(551,363,1),(555,418,4),(556,417,9),(557,416,4),(561,420,1),(562,420,4),(563,419,1),(564,419,4),(565,421,9),(566,421,4),(567,421,10),(568,422,6),(569,423,NULL),(570,424,NULL),(571,423,NULL),(572,424,NULL),(575,426,1),(576,426,4),(577,425,3),(578,425,9),(579,425,10),(580,427,8),(581,423,NULL),(582,424,NULL),(586,429,3),(587,429,1),(588,430,7),(589,430,3),(590,428,9),(591,428,8),(592,423,NULL),(593,424,NULL),(594,423,NULL),(595,424,NULL),(596,423,NULL),(597,424,NULL),(598,423,NULL),(599,424,NULL),(600,431,9),(601,432,3),(602,433,9),(603,423,NULL),(604,424,NULL),(605,423,NULL),(606,424,NULL),(607,423,NULL),(608,424,NULL),(609,423,NULL),(610,424,NULL),(611,423,NULL),(612,424,NULL),(613,423,NULL),(614,424,NULL),(615,423,NULL),(616,424,NULL),(617,423,NULL),(618,424,NULL),(619,423,NULL),(620,424,NULL),(627,423,NULL),(628,423,NULL),(630,423,NULL),(631,424,NULL),(632,423,NULL),(633,424,NULL),(634,436,7),(635,436,8),(636,436,4),(637,435,9),(638,435,2),(639,435,8),(640,435,1),(641,435,4),(642,434,3),(643,434,9),(644,434,4),(645,423,NULL),(646,424,NULL),(647,423,NULL),(648,424,NULL),(649,423,NULL),(650,424,NULL),(651,437,1),(652,437,4),(655,423,NULL),(656,424,NULL),(657,438,3),(658,438,1),(659,439,4),(660,439,10),(661,423,NULL),(662,424,NULL),(667,442,3),(668,442,8),(669,442,1),(670,442,4),(671,441,3),(672,441,9),(673,441,1),(674,441,4),(675,440,3),(676,440,8),(677,440,4),(684,445,3),(685,445,1),(686,444,3),(687,444,8),(688,444,4),(689,444,6),(690,443,2),(691,443,8),(692,443,1),(693,443,4),(694,423,NULL),(695,424,NULL),(696,423,NULL),(697,424,NULL),(698,423,NULL),(699,424,NULL),(700,423,NULL),(701,424,NULL),(703,447,3),(704,447,9),(705,448,3),(706,448,9),(707,423,NULL),(708,424,NULL),(709,446,3),(710,423,NULL),(711,424,NULL),(712,449,10),(713,449,6),(714,450,3),(715,451,7),(716,451,3),(717,423,NULL),(718,424,NULL),(722,454,3),(723,454,1),(724,453,3),(725,453,1),(726,453,5),(727,452,3),(728,452,2),(729,452,1),(730,423,NULL),(731,424,NULL),(732,423,NULL),(733,424,NULL),(734,423,NULL),(735,424,NULL),(736,423,NULL),(737,424,NULL),(738,455,4),(739,455,5),(740,456,3),(741,457,8),(742,423,NULL),(743,424,NULL),(744,423,NULL),(745,424,NULL),(750,460,8),(751,460,4),(752,460,10),(753,459,3),(754,459,1),(755,458,3),(756,458,9),(757,458,1),(758,423,NULL),(759,424,NULL),(760,461,10),(761,423,NULL),(762,424,NULL),(763,462,3),(764,463,3),(765,423,NULL),(766,424,NULL),(767,423,NULL),(768,424,NULL),(769,423,NULL),(770,424,NULL),(771,423,NULL),(772,424,NULL),(777,465,8),(778,465,4),(779,465,10),(780,466,3),(781,466,8),(782,466,4),(783,464,9),(784,464,10),(785,423,NULL),(786,424,NULL),(787,423,NULL),(788,424,NULL),(789,423,NULL),(790,424,NULL),(795,467,3),(796,467,4),(797,468,3),(798,468,1),(799,468,4),(800,469,9),(801,469,10),(802,423,NULL),(803,424,NULL),(804,423,NULL),(805,424,NULL),(806,423,NULL),(807,424,NULL),(808,423,NULL),(809,424,NULL),(818,470,2),(819,470,8),(820,470,4),(821,470,10),(822,471,9),(823,471,2),(824,471,4),(825,472,3),(826,472,4),(827,472,10),(828,423,NULL),(829,424,NULL),(830,423,NULL),(831,424,NULL),(837,473,3),(838,473,8),(839,473,4),(840,474,7),(841,474,3),(842,474,4),(843,474,10),(844,475,7),(845,475,3),(846,475,8),(847,475,1),(848,475,6),(849,423,NULL),(850,424,NULL),(851,423,NULL),(852,424,NULL),(853,423,NULL),(854,424,NULL),(855,423,NULL),(856,424,NULL),(857,423,NULL),(858,424,NULL),(859,423,NULL),(860,424,NULL),(861,423,NULL),(862,424,NULL),(866,476,7),(867,476,8),(868,477,2),(869,477,4),(870,477,10),(871,478,3),(872,478,8),(873,478,4),(874,423,NULL),(875,424,NULL),(876,423,NULL),(877,424,NULL),(878,423,NULL),(879,424,NULL),(880,423,NULL),(881,424,NULL),(882,423,NULL),(883,424,NULL),(888,423,NULL),(889,424,NULL),(890,423,NULL),(891,424,NULL),(892,479,3),(893,479,8),(894,480,3),(895,480,8),(896,480,4),(899,481,1),(900,481,4),(901,423,NULL),(902,424,NULL),(903,423,NULL),(904,424,NULL),(905,423,NULL),(906,424,NULL),(907,423,NULL),(908,424,NULL),(909,423,NULL),(910,424,NULL),(911,423,NULL),(912,424,NULL),(913,423,NULL),(914,424,NULL),(927,423,NULL),(928,424,NULL),(937,423,NULL),(938,424,NULL),(939,423,NULL),(940,424,NULL),(941,484,3),(942,484,8),(943,484,4),(946,483,1),(947,483,4),(948,482,3),(949,482,8),(950,482,1),(951,423,NULL),(952,424,NULL),(954,423,NULL),(955,424,NULL),(957,423,NULL),(958,424,NULL),(959,423,NULL),(960,424,NULL),(967,486,3),(968,486,2),(969,486,8),(970,486,4),(971,485,9),(972,485,4),(973,485,10),(974,423,NULL),(975,424,NULL),(976,423,NULL),(977,424,NULL),(978,423,NULL),(979,424,NULL),(980,487,3),(981,487,9),(982,487,2),(983,487,10),(984,423,NULL),(985,424,NULL),(986,423,NULL),(987,424,NULL),(988,423,NULL),(989,424,NULL),(990,423,NULL),(991,424,NULL),(992,423,NULL),(993,424,NULL),(994,423,NULL),(995,424,NULL),(996,423,NULL),(997,424,NULL),(998,488,3),(999,423,NULL),(1000,424,NULL),(1001,489,7),(1002,490,3),(1003,423,NULL),(1004,424,NULL),(1005,423,NULL),(1006,424,NULL),(1007,423,NULL),(1008,424,NULL),(1009,423,NULL),(1010,424,NULL),(1011,423,NULL),(1012,424,NULL),(1013,423,NULL),(1014,424,NULL),(1015,423,NULL),(1016,424,NULL),(1017,423,NULL),(1018,424,NULL),(1019,423,NULL),(1020,424,NULL),(1025,493,3),(1026,493,9),(1027,493,10),(1028,492,3),(1029,492,9),(1030,492,10),(1031,492,4),(1032,491,7),(1033,491,3),(1034,491,8),(1035,423,NULL),(1036,424,NULL),(1037,423,NULL),(1038,424,NULL),(1039,423,NULL),(1040,424,NULL),(1041,423,NULL),(1042,424,NULL),(1046,423,NULL),(1047,424,NULL),(1048,423,NULL),(1049,424,NULL),(1050,423,NULL),(1051,424,NULL),(1052,423,NULL),(1053,424,NULL),(1054,423,NULL),(1055,424,NULL),(1056,423,NULL),(1057,424,NULL),(1058,423,NULL),(1059,424,NULL),(1060,423,NULL),(1061,424,NULL),(1062,423,NULL),(1063,424,NULL),(1064,423,NULL),(1065,424,NULL),(1066,423,NULL),(1067,424,NULL),(1068,494,8),(1069,494,1),(1070,494,4),(1071,495,9),(1072,495,10),(1073,496,7),(1074,496,3),(1075,496,8),(1076,423,NULL),(1077,424,NULL),(1078,423,NULL),(1079,424,NULL),(1080,497,10),(1081,498,7),(1082,499,8),(1083,499,1),(1084,423,NULL),(1085,424,NULL),(1086,423,NULL),(1087,424,NULL),(1088,423,NULL),(1089,424,NULL),(1090,423,NULL),(1091,424,NULL),(1092,423,NULL),(1093,424,NULL),(1094,423,NULL),(1095,424,NULL),(1100,500,2),(1101,500,1),(1102,500,10),(1103,501,3),(1104,501,10),(1105,501,4),(1106,502,7),(1107,502,8),(1108,502,4);

--
-- Table structure for table `nl_monthnewsletters`
--

CREATE TABLE `nl_monthnewsletters` (
  `id` int NOT NULL AUTO_INCREMENT,
  `monthNewsletter` varchar(255) COLLATE utf8mb3_unicode_ci NOT NULL,
  `created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `nl_monthnewsletters`
--

INSERT INTO `nl_monthnewsletters` (`id`, `monthNewsletter`, `created`, `modified`) VALUES (56,'January 2022','2021-12-29 06:53:12','2021-12-29 06:53:12'),(57,'February 2022','2022-01-25 11:13:47','2022-01-25 11:13:47'),(58,'March 2022','2022-03-01 11:07:43','2022-03-01 11:07:43'),(59,'April 2022','2022-04-01 13:58:13','2022-04-01 13:58:13'),(60,'May 2022','2022-04-27 06:40:42','2022-04-27 06:40:42'),(61,'June 2022','2022-06-02 09:36:31','2022-06-02 09:36:31'),(62,'July 2022','2022-07-04 06:04:40','2022-07-04 07:36:19'),(63,'testpzzz','2022-08-30 15:52:59','2022-08-30 15:52:59'),(64,'September 2022','2022-09-03 16:58:26','2022-09-03 16:58:26'),(65,'October 2022','2022-10-02 14:26:18','2022-10-02 14:26:18'),(66,'November 2022','2022-11-01 10:32:30','2022-11-01 10:32:30'),(67,'December 2022','2022-12-01 07:42:36','2022-12-01 07:42:36'),(68,'Jan 2023','2023-01-03 07:27:39','2023-01-03 07:27:39'),(69,'Feb 2023','2023-01-31 16:27:02','2023-01-31 16:27:02'),(70,'March 2023','2023-03-05 06:35:54','2023-03-05 06:35:54'),(71,'April 2023','2023-04-04 09:50:17','2023-04-04 09:50:17'),(72,'May 2023','2023-05-10 19:50:17','2023-05-10 19:50:17'),(73,'June 2023','2023-06-05 08:45:45','2023-06-05 08:45:45'),(74,'July 2023','2023-07-09 14:25:42','2023-07-09 14:25:42'),(75,'September 2023','2023-09-05 06:00:03','2023-09-05 06:00:03'),(76,'October 2023','2023-10-02 06:04:49','2023-10-02 06:04:49'),(77,'November 2023','2023-10-30 11:06:14','2023-10-30 11:06:14'),(78,'December 2023','2023-12-01 09:03:20','2023-12-18 11:02:24'),(79,'January 2024','2024-01-07 11:36:15','2024-01-07 11:36:15'),(80,'Feb2024','2024-02-03 16:50:40','2024-02-03 16:50:40'),(81,'March 2024','2024-03-03 11:47:34','2024-03-03 11:47:34'),(82,'April 2024','2024-03-31 13:24:07','2024-03-31 13:24:07'),(83,'May 2024','2024-04-29 10:41:33','2024-04-29 10:41:33'),(84,'June 2024','2024-05-30 09:28:51','2024-05-30 09:28:51'),(85,'July 2024','2024-06-23 14:33:07','2024-06-23 14:33:07'),(86,'September 2024','2024-08-31 14:51:00','2024-08-31 14:51:00'),(87,'October 2024','2024-09-30 14:26:39','2024-09-30 14:26:39'),(88,'November 2024','2024-11-01 17:38:13','2024-11-01 17:38:13'),(89,'December 2024','2024-12-01 14:26:14','2024-12-01 14:26:14'),(90,'January 2025','2025-01-02 14:01:10','2025-01-02 14:01:10'),(91,'February 2025','2025-02-02 15:11:34','2025-02-02 15:11:34'),(92,'March 2025','2025-03-03 01:20:00','2025-03-03 01:20:00'),(93,'April 2025','2025-03-30 17:29:16','2025-03-30 17:29:16'),(94,'May2025','2025-04-27 18:57:28','2025-04-27 18:57:28'),(95,'June 2025','2025-06-01 17:00:38','2025-06-01 17:00:38'),(96,'July 2025','2025-06-29 17:02:05','2025-06-29 17:02:05'),(97,'September 2025','2025-08-30 17:38:25','2025-08-30 17:38:25'),(98,'October 2025','2025-10-10 10:28:35','2025-10-10 10:28:35'),(99,'November 2025','2025-11-03 11:30:04','2025-11-03 11:30:04'),(100,'December 2025','2025-11-30 18:53:14','2025-11-30 18:53:14'),(101,'January 2026','2026-01-04 15:19:55','2026-01-04 15:19:55');

--
-- Table structure for table `nl_niveau`
--

CREATE TABLE `nl_niveau` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `date_create` date NOT NULL,
  `created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `nl_niveau`
--

INSERT INTO `nl_niveau` (`id`, `name`, `date_create`, `created`, `modified`) VALUES (1,'PREINTERMEDIATE','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'INTERMEDIATE','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'ADVANCED','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `nl_selection`
--

CREATE TABLE `nl_selection` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `ID_article` int NOT NULL,
  `terme_article` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `ID_terme` int NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `nl_selection`
--


--
-- Table structure for table `nl_termes`
--

CREATE TABLE `nl_termes` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `article_id` int NOT NULL,
  `terme` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `traduction_fr` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `definition` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `eg` longtext COLLATE utf8mb3_unicode_ci NOT NULL,
  `date_create` date NOT NULL,
  `modified` datetime NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `IDX_B1AF5AD87294869C` (`article_id`),
  CONSTRAINT `FK_B1AF5AD87294869C` FOREIGN KEY (`article_id`) REFERENCES `nl_articles` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=2850 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `nl_termes`
--



--
-- Table structure for table `nl_themes`
--

CREATE TABLE `nl_themes` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `date_create` date NOT NULL,
  `created` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  `modified` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `nl_themes`
--

INSERT INTO `nl_themes` (`id`, `name`, `date_create`, `created`, `modified`) VALUES (1,'Politics','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(2,'Health','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(3,'Business & Economy','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(4,'Society','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(5,'Sport','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(6,'Travel','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(7,'Art & Culture','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(8,'Lifestyle','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(9,'Environment','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(10,'Science & technology','0000-00-00','0000-00-00 00:00:00','0000-00-00 00:00:00');

--
-- Table structure for table `question`
--

CREATE TABLE `question` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quiz_id` int NOT NULL,
  `text` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `difficulty` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ai_generated` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B6F7494E853CD175` (`quiz_id`),
  CONSTRAINT `FK_B6F7494E853CD175` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `question`
--


--
-- Table structure for table `quiz`
--

CREATE TABLE `quiz` (
  `id` int NOT NULL AUTO_INCREMENT,
  `article_id` int NOT NULL,
  `type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_A412FA927294869C` (`article_id`),
  CONSTRAINT `FK_A412FA927294869C` FOREIGN KEY (`article_id`) REFERENCES `nl_articles` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quiz`
--


--
-- Table structure for table `quiz_review`
--

CREATE TABLE `quiz_review` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quiz_id` int NOT NULL,
  `user_id` int NOT NULL,
  `changes` json NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_9407719F853CD175` (`quiz_id`),
  CONSTRAINT `FK_9407719F853CD175` FOREIGN KEY (`quiz_id`) REFERENCES `quiz` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quiz_review`
--


--
-- Table structure for table `speaking_prompt`
--

CREATE TABLE `speaking_prompt` (
  `id` int NOT NULL AUTO_INCREMENT,
  `question_id` int NOT NULL,
  `sentence_starter` longtext COLLATE utf8mb4_unicode_ci,
  `support_phrase` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9C8ED0CA1E27F6BF` (`question_id`),
  CONSTRAINT `FK_9C8ED0CA1E27F6BF` FOREIGN KEY (`question_id`) REFERENCES `question` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `speaking_prompt`
--



