(175,11,122,'oficio_entrega','submodulos/Baa7KOSu0U695FmfDNkoDowjDTrO9pnp1dAzfKHm.pdf','[BLOB]','2025-07-02 15:13:40',NULL,'2025-07-02 15:13:40','2025-07-02 15:13:40'),(177,11,55,'oficio_entrega','submodulos/d8UaxSFliPBVQqUGkdUECIHjjfgpip0WuGNZ0whm.pdf','[BLOB]','2025-07-02 19:41:35',NULL,'2025-07-02 19:41:35','2025-07-02 19:41:35'),(178,11,25,'oficio_entrega','submodulos/Vm9FKZyB5XdT0FWUPJjLYS76Zskck07AVFhZSXEm.pdf',NULL,NULL,NULL,'2025-07-02 19:57:53','2025-07-02 19:57:53'),(179,11,111,'oficio_entrega','submodulos/sqWPu3ii7icrqpEjrVPf0gcpcks9zdPFuMSqWQkL.pdf',NULL,NULL,NULL,'2025-07-02 19:58:47','2025-07-02 19:58:47'),(180,11,98,'oficio_entrega','submodulos/mdvyngSoPrybWj5DfmJzAXk7DeeLn7azATbd9Yhf.pdf',NULL,NULL,NULL,'2025-07-02 20:08:20','2025-07-02 20:08:20'),(181,11,108,'oficio_entrega','submodulos/y1sUg6r6yk7S6V2WdbBDMxW1lJTtfl8E25oiRDSX.pdf',NULL,NULL,NULL,'2025-07-03 04:11:04','2025-07-03 04:11:04'),(182,13,76,'oficio_entrega','submodulos/bKrEdgiho170fb85rXpN81gITsQN0mze3lhOFbet.pdf',NULL,NULL,NULL,'2025-07-03 05:17:27','2025-07-03 05:17:27'),(183,11,76,'oficio_entrega','submodulos/GsLxr2MAjDdV9rbQyAr8LuJENRgScc7p9rYGSOl4.pdf',NULL,NULL,NULL,'2025-07-03 05:18:08','2025-07-03 05:18:08'),(184,11,65,'oficio_entrega','submodulos/LLKAk89KtU0RBMOHn4pPIH526Q9H2uRoyieXJ6Do.pdf','[BLOB]','2025-07-03 15:43:22',NULL,'2025-07-03 15:43:22','2025-07-03 15:43:22'),(185,11,115,'oficio_entrega','submodulos/qdwDXOvPO5VsKfRPnMdb92KkGN2QuZ9xVN85YDxL.pdf',NULL,NULL,NULL,'2025-07-03 19:10:54','2025-07-03 19:10:54'),(186,11,53,'oficio_entrega','submodulos/o1GFwaZVZcNEigxPQJo0ssSW4l7fzjDvHFiYtiF0.pdf',NULL,NULL,NULL,'2025-07-03 20:37:01','2025-07-03 20:37:01'),(187,14,20,'oficio_entrega','submodulos/wUUBsv5fgkIpKH7h9uw7Y0x8x4JUqk4SAchEdyu5.pdf',NULL,NULL,NULL,'2025-07-03 21:32:46','2025-07-03 21:32:46'),(188,8,20,'oficio_entrega','submodulos/VOihUrUOSjD8SRJuXGhtZlixq5HmEiHD9J65tLlq.pdf',NULL,NULL,NULL,'2025-07-03 21:36:00','2025-07-03 21:36:00'),(189,13,20,'oficio_entrega','submodulos/mLY3CoeoJVWOuPclhn8yrHOSmx4UltN4E5ShgAeX.pdf',NULL,NULL,NULL,'2025-07-03 22:05:56','2025-07-03 22:05:56'),(190,11,20,'oficio_entrega','submodulos/AQB0RYbTbZbvTtoFL7SWTcINJ4kXCVsolry7CcSH.pdf',NULL,NULL,NULL,'2025-07-03 22:25:50','2025-07-03 22:25:50'),(191,11,112,'oficio_entrega','submodulos/TAWr1NiNrBaxvHRsdNovSSf2Y66tlm04iv68XumS.pdf',NULL,NULL,NULL,'2025-07-04 01:29:45','2025-07-04 01:29:45'),(192,11,112,'oficio_entrega','submodulos/ztuSszQCtbCOHbf2GGZGcJn1d1XleYXf0QxI3EyY.pdf',NULL,NULL,NULL,'2025-07-04 01:31:12','2025-07-04 01:31:12'),(193,11,132,'oficio_entrega','submodulos/L5eIpI0K3CbEQnFDUjhi443UFAUoUql7iZgmP7OD.pdf',NULL,NULL,NULL,'2025-07-04 01:36:52','2025-07-04 01:36:52'),(194,14,23,'oficio_entrega','submodulos/2AGDxu8fkTL3lxkJqnIJwCHGMNlgNeW24VxcNhAL.pdf',NULL,NULL,NULL,'2025-07-04 04:04:24','2025-07-04 04:04:24'),(195,8,23,'oficio_entrega','submodulos/aANw4xDnVlTCuEHeF80NQ7oQzeuxXygHkAoI7dOe.pdf',NULL,NULL,NULL,'2025-07-04 04:15:14','2025-07-04 04:15:14'),(197,11,75,'oficio_entrega','submodulos/FkG9ubso1hP7tdVqWl7CH2qmOew0GZJjEr0mFlC0.pdf',NULL,NULL,NULL,'2025-07-04 16:23:30','2025-07-04 16:23:30'),(198,11,75,'oficio_entrega','submodulos/JBnYloH73yg17eRYHjNR73RmND3dcFoTzkOQhAuK.pdf',NULL,NULL,NULL,'2025-07-04 16:23:46','2025-07-04 16:23:46'),(199,11,75,'oficio_entrega','submodulos/9r6cZ3ig3x8q0QhpxbHis4a8fDkTKRmSTz58DpYS.pdf',NULL,NULL,NULL,'2025-07-04 16:26:05','2025-07-04 16:26:05'),(200,11,75,'oficio_entrega','submodulos/kIOOT2jrVFcuoPZUyNbb1KKONJobSFsaiKxd621A.pdf',NULL,NULL,NULL,'2025-07-04 16:26:24','2025-07-04 16:26:24'),(201,11,75,'oficio_entrega','submodulos/waXbmSp7BQPS4HhaAqqyDlX3RxouxIeHLVaQWqfe.pdf',NULL,NULL,NULL,'2025-07-04 16:27:30','2025-07-04 16:27:30'),(202,8,73,'oficio_entrega','submodulos/60sbWAmaMUIpGfGQU4Mfvwu0NtbRYaw0fWXFWuGM.pdf','[BLOB]','2025-07-04 16:28:51',NULL,'2025-07-04 16:28:51','2025-07-04 16:28:51'),(203,8,25,'oficio_entrega','submodulos/3Q8Uxa3U3OeH3CUd4kslJxJlvBPHdGyw5wbyYFbm.pdf',NULL,NULL,NULL,'2025-07-04 16:34:30','2025-07-04 16:34:30'),(204,14,13,'oficio_entrega','submodulos/cZEjCBpOqqbUPxYgoKF9QIcYWvOk5LZjQY3EjcZr.pdf',NULL,NULL,NULL,'2025-07-04 16:48:04','2025-07-04 16:48:04'),(205,8,13,'oficio_entrega','submodulos/KT9hiya2nDb7EsH7yvp5XJugH57DISvxlcq3uEdn.pdf',NULL,NULL,NULL,'2025-07-04 16:48:25','2025-07-04 16:48:25'),(206,13,31,'oficio_entrega','submodulos/2BIdHIgUv1jjIfLT0SKnr1TuOfBGBXx2H6dKpNSP.pdf','[BLOB]','2025-07-04 19:16:12',NULL,'2025-07-04 19:16:12','2025-07-04 19:16:12'),(207,11,31,'oficio_entrega','submodulos/caGWJSF5AhDpZcIlHeSQ3K5N4581FbvS2vhuKWfg.pdf','[BLOB]','2025-07-04 19:19:28',NULL,'2025-07-04 19:19:28','2025-07-04 19:19:28'),(208,8,31,'oficio_entrega','submodulos/Ft5wl14rcZWPqma2PH4FWGg9bi1Q1s97T7LpdkAk.pdf','[BLOB]','2025-07-04 19:21:07',NULL,'2025-07-04 19:21:07','2025-07-04 19:21:07'),(209,14,134,'oficio_entrega','submodulos/8KMP5LmrajDaMA8vWu9oCNqNg48YjeRlXh8vklWb.pdf',NULL,NULL,NULL,'2025-07-04 19:44:53','2025-07-04 19:44:53'),(210,11,30,'oficio_entrega','submodulos/Kky0oy6tiny0F5b4ZlWrkPNT32xKsuPP6AUj1qxc.pdf',NULL,NULL,NULL,'2025-07-04 20:26:23','2025-07-04 20:26:23'),(211,11,30,'oficio_entrega','submodulos/TFDL9xr83qhUw8VgHa9lp6ntQeRWu48ymuFGPlBd.pdf',NULL,NULL,NULL,'2025-07-04 20:27:22','2025-07-04 20:27:22'),(212,11,30,'oficio_entrega','submodulos/eFIfhFhKmXyjMP9dQcsMLARfSRNA0xXjJzKhLn5e.pdf',NULL,NULL,NULL,'2025-07-04 20:27:28','2025-07-04 20:27:28'),(213,13,107,'oficio_entrega','submodulos/oROWKNxpHaMr8EiU7MRyNL7zXqh0xuV0HVGp4TPp.pdf',NULL,NULL,NULL,'2025-07-05 01:45:12','2025-07-05 01:45:12'),(214,11,13,'oficio_entrega','submodulos/atiGFPjJ30j3K9Mdze0UrGhDVMfL40mNNikkmZcL.pdf',NULL,NULL,NULL,'2025-07-05 05:10:20','2025-07-05 05:10:20'),(215,11,89,'oficio_entrega','submodulos/VAkcI1RqpCfrDsgHF1UV7aYbca0NyEWyUJH3YKK0.pdf',NULL,NULL,NULL,'2025-07-07 17:01:19','2025-07-07 17:01:19'),(216,11,57,'oficio_entrega','submodulos/5TJWkHE5lQapHr0RiCqWTwdelT7Tcy6nNSCG3DnM.pdf','[BLOB]','2025-07-07 20:22:05',NULL,'2025-07-07 20:22:05','2025-07-07 20:22:05'),(217,11,77,'oficio_entrega','submodulos/DiN063wKMnJM3fEV23r4fKTYzhPj9ZFJgrqYNcE7.pdf',NULL,NULL,NULL,'2025-07-07 21:47:32','2025-07-07 21:47:32'),(218,8,38,'oficio_entrega','submodulos/qakGwlDgRxRnxZbzk7DJT2L2z4jg7ckFuB7ui3lS.pdf',NULL,NULL,NULL,'2025-07-07 22:50:57','2025-07-07 22:50:57'),(219,11,38,'oficio_entrega','submodulos/KnB4adGe0zyqiQdLu5rv33WswKoNi7UzTr2Dr7mv.pdf',NULL,NULL,NULL,'2025-07-07 22:59:55','2025-07-07 22:59:55'),(220,11,38,'oficio_entrega','submodulos/FlOFYpLclWIAN5EKzXfBd185sRbzetYFAsBs8b85.pdf',NULL,NULL,NULL,'2025-07-07 23:00:00','2025-07-07 23:00:00'),(221,13,92,'oficio_entrega','submodulos/bctGc76Wq5EVrzrZVAqUAGGhoOSRT5h5n2oyU2kn.pdf',NULL,NULL,NULL,'2025-07-07 23:08:19','2025-07-07 23:08:19'),(222,14,38,'oficio_entrega','submodulos/ZC4VSZoTtxoqOYeqzLoArF5cGYpyBrXBuiEM5m3L.pdf',NULL,NULL,NULL,'2025-07-07 23:19:03','2025-07-07 23:19:03'),(223,11,134,'oficio_entrega','submodulos/7Cog7DFuOzuzCKb0bxED2VRbML7eNJOI3NyoK9xP.pdf',NULL,NULL,NULL,'2025-07-08 01:08:55','2025-07-08 01:08:55'),(224,11,92,'oficio_entrega','submodulos/fhbxWCSpQclUsAA9NnPP5qM4fs5XkZ9gBugH4rpT.pdf',NULL,NULL,NULL,'2025-07-08 14:56:47','2025-07-08 14:56:47'),(225,11,143,'oficio_entrega','submodulos/WyJHG7GsjBQKIG2sK4tZJDc3yI7mdokT7srCqhZ0.pdf',NULL,NULL,NULL,'2025-07-08 15:52:52','2025-07-08 15:52:52'),(226,11,60,'oficio_entrega','submodulos/qp7c8ckzTjVScALvLzNkzfK7Qsmc41rFhpPtj2zh.pdf',NULL,NULL,NULL,'2025-07-09 00:51:23','2025-07-09 00:51:23'),(227,8,60,'oficio_entrega','submodulos/pMrXKYEP6E519dylthfR7Tk7w8R9F3j0UrhITb9P.pdf',NULL,NULL,NULL,'2025-07-09 00:53:23','2025-07-09 00:53:23'),(228,14,58,'oficio_entrega','submodulos/wUktMXSgIeZunzcjL807THiv7eOoyEZmmhFsDICd.pdf',NULL,NULL,NULL,'2025-07-09 13:26:04','2025-07-09 13:26:04'),(229,8,58,'oficio_entrega','submodulos/EHO8aOv3CilxVCDQSBj49sVJTTR5rqZvs8L4jbEr.pdf',NULL,NULL,NULL,'2025-07-09 13:27:20','2025-07-09 13:27:20'),(230,11,81,'oficio_entrega','submodulos/wGrUWGKXD85JWBxYUyp5RP0xrCLY3eTRA1xkZ6iC.pdf',NULL,NULL,NULL,'2025-07-11 17:44:01','2025-07-11 17:44:01'),(231,11,110,'oficio_entrega','submodulos/IPFmdArNotT2uNVZHYpvhSJnf1RvLATxogTLPQVJ.pdf',NULL,NULL,NULL,'2025-07-12 02:57:38','2025-07-12 02:57:38'),(232,8,127,'oficio_entrega','submodulos/kdaGq8psivwQgekxmsVKHRv08ppdjZbqIY4RKSko.pdf',NULL,NULL,NULL,'2025-07-14 14:31:36','2025-07-14 14:31:36'),(233,9,127,'oficio_entrega','submodulos/l3BcRZHyNJaYveDAmsUHXWs8niAseo5KrySd8MQK.pdf',NULL,NULL,NULL,'2025-07-14 14:49:41','2025-07-14 14:49:41'),(234,11,127,'oficio_entrega','submodulos/W0qLvQOzz9YzzBkEnWjrON4DM7zNIPhXatHqeI83.pdf',NULL,NULL,NULL,'2025-07-15 15:20:37','2025-07-15 15:20:37'),(235,11,125,'oficio_entrega','submodulos/DwNId9W57YR4gXe7IHtzMdyBa4UWi1uGdzBPEJL1.pdf',NULL,NULL,NULL,'2025-07-15 17:53:50','2025-07-15 17:53:50'),(236,9,77,'oficio_entrega','submodulos/weihSlCTIF819KaWawrZ18IjMwm01KWv4Me6Unsw.pdf',NULL,NULL,NULL,'2025-07-15 18:42:42','2025-07-15 18:42:42'),(237,9,129,'oficio_entrega','submodulos/p34bNPOH8ywTZ5PYgaH8urtFbTTeEe56L49A5wag.pdf',NULL,NULL,NULL,'2025-07-15 18:50:03','2025-07-15 18:50:03'),(238,11,129,'oficio_entrega','submodulos/3gmHQXDMcRxNP7osVQIX3kPku5B460U5IJiEMXKa.pdf',NULL,NULL,NULL,'2025-07-15 19:14:34','2025-07-15 19:14:34'),(239,9,125,'oficio_entrega','submodulos/GvtVScLfKOAxa47pHXa9dovw021N8wRu3YRBxB7P.pdf',NULL,NULL,NULL,'2025-07-15 20:07:30','2025-07-15 20:07:30'),(240,9,103,'oficio_entrega','submodulos/qkt1gOjTmxBNJcyQSXWPzJFIUKS2RL3TLZxjd831.pdf',NULL,NULL,NULL,'2025-07-16 00:45:01','2025-07-16 00:45:01'),(241,11,32,'oficio_entrega','submodulos/9vxmcYMKr5yXscR5zYaXsMpJeCDOw4JeuKSqcoW5.pdf',NULL,NULL,NULL,'2025-07-16 03:09:16','2025-07-16 03:09:16'),(242,9,32,'oficio_entrega','submodulos/VOqZ5Z6eK1LdLxWemHhHeuPuTnnLHnYP91IJ1xWa.pdf',NULL,NULL,NULL,'2025-07-16 03:09:45','2025-07-16 03:09:45'),(243,9,59,'oficio_entrega','submodulos/vUZLiaNGtIuZG2XvUYvWV1Te8SrdKq8PjPPLImTk.pdf','[BLOB]','2025-07-16 04:23:36',NULL,'2025-07-16 04:23:36','2025-07-16 04:23:36'),(244,9,134,'oficio_entrega','submodulos/TGKZSJWCvOqG71RlHIZU2wCFAz71sYyDgvbh2SBm.pdf',NULL,NULL,NULL,'2025-07-16 16:25:00','2025-07-16 16:25:00'),(245,9,58,'oficio_entrega','submodulos/B0o6fc4Zj3SOxIR0BX5I7JDFM5cRWK0sZhTjA6q6.pdf',NULL,NULL,NULL,'2025-07-16 18:17:50','2025-07-16 18:17:50'),(246,9,55,'oficio_entrega','submodulos/QsZLRftTcPBBkneRVKe1ybTBbUBYvJjLNw2RMxvW.pdf','[BLOB]','2025-07-16 19:43:20',NULL,'2025-07-16 19:43:20','2025-07-16 19:43:20'),(247,9,108,'oficio_entrega','submodulos/kcqgq217GFSfoqYlhsgjD2asuNICTFEoZeauiy7s.pdf','[BLOB]','2025-07-17 04:38:08',NULL,'2025-07-17 04:38:08','2025-07-17 04:38:08'),(248,9,75,'oficio_entrega','submodulos/tX9n0npTqMD9Db3QG0gfjoLXCZ9XV9CTT1rsyNL4.pdf','[BLOB]','2025-07-17 13:21:49',NULL,'2025-07-17 13:21:49','2025-07-17 13:21:49'),(249,9,57,'oficio_entrega','submodulos/AwSXAJXg1ydeFzJdGk7VuuUGaYEgPNTLTVQmhsM2.pdf','[BLOB]','2025-07-17 15:04:09',NULL,'2025-07-17 15:04:09','2025-07-17 15:04:09'),(250,11,103,'oficio_entrega','submodulos/PC3Lr2KpnjxaquIvflVfU3HPNk2tgCSg5jFjBszU.pdf',NULL,NULL,NULL,'2025-07-17 15:17:13','2025-07-17 15:17:13'),(251,9,60,'oficio_entrega','submodulos/rcAU0SyZFRks9ioST3Mo9jYpy5NG0F0bGm7QjT4f.pdf',NULL,NULL,NULL,'2025-07-17 16:06:59','2025-07-17 16:06:59'),(252,9,122,'oficio_entrega','submodulos/MLEtEQKDjnywwzRx3vvHIak4OHSqq7VQslI6shss.pdf','[BLOB]','2025-07-17 20:42:02',NULL,'2025-07-17 20:42:02','2025-07-17 20:42:02'),(253,9,104,'oficio_entrega','submodulos/j38twWVVsjC5ZEvhKvFUbClUxQQ2ex9A8p9uDCD5.pdf',NULL,NULL,NULL,'2025-07-17 20:42:16','2025-07-17 20:42:16'),(254,9,111,'oficio_entrega','submodulos/gAinooO3E2yFtFsbWBzfqa0fER3OcSnAWeiUTnMY.pdf',NULL,NULL,NULL,'2025-07-17 20:43:51','2025-07-17 20:43:51'),(255,9,30,'oficio_entrega','submodulos/bMOIZP7CRKfaoi9hcEoZMlwc9eAqqhzaDyARyz56.pdf',NULL,NULL,NULL,'2025-07-17 22:13:45','2025-07-17 22:13:45'),(256,9,30,'oficio_entrega','submodulos/zxaeScLUTosn1emvVJI0zeOplZNZTAIrubzW2aea.pdf',NULL,NULL,NULL,'2025-07-17 22:14:03','2025-07-17 22:14:03'),(257,9,73,'oficio_entrega','submodulos/lorGVTjcQBorWK2WzqV7GN5p2fPxxfaGe6BTmNDo.pdf','[BLOB]','2025-07-18 14:57:20',NULL,'2025-07-18 14:57:20','2025-07-18 14:57:20'),(258,11,119,'oficio_entrega','submodulos/edjH4O4gO4coYbNqe6cSnVJN80uBmVPHzQnRlIrO.pdf',NULL,NULL,NULL,'2025-07-18 16:35:37','2025-07-18 16:35:37'),(259,11,119,'oficio_entrega','submodulos/NsXkCb5McViQ1Qzcd4cgNw38tYhpMwlKx7TXjbNs.pdf',NULL,NULL,NULL,'2025-07-18 16:35:59','2025-07-18 16:35:59'),(260,11,119,'oficio_entrega','submodulos/9Tl7FIItEOKeWFJS9Bw6atiACit9U8pjjdPcv4NN.pdf',NULL,NULL,NULL,'2025-07-18 16:36:31','2025-07-18 16:36:31'),(261,9,119,'oficio_entrega','submodulos/0Y8alZiwcqqWrhOIdjMw20JVMXsLQBQomJEcBDXj.pdf','[BLOB]','2025-07-18 16:45:30',NULL,'2025-07-18 16:45:30','2025-07-18 16:45:30'),(262,9,116,'oficio_entrega','submodulos/1jBNCNc6aiKKZ12lDxWFzYP4b28AZmgyA1f8fhx4.pdf',NULL,NULL,NULL,'2025-07-18 18:50:02','2025-07-18 18:50:02'),(263,9,53,'oficio_entrega','submodulos/YgMMttxHQOgvRU0YWkGgYTUWWtNUruL45rxS7sum.pdf',NULL,NULL,NULL,'2025-07-18 20:07:12','2025-07-18 20:07:12'),(264,9,142,'oficio_entrega','submodulos/XxPY1OOrFZbfG28PHVK5eq1TPpojiHOfLm19oZD0.pdf','[BLOB]','2025-07-18 20:21:54',NULL,'2025-07-18 20:21:54','2025-07-18 20:21:54'),(265,9,128,'oficio_entrega','submodulos/whmYqwfIWY0AaFzyGxdIRHQ8ou7PFVomdoNP3tIG.pdf','[BLOB]','2025-07-18 20:22:31',NULL,'2025-07-18 20:22:31','2025-07-18 20:22:31'),(266,9,98,'oficio_entrega','submodulos/Z35sih2uhgeciQUfXV0rlvfc7avuXmAl5QOzvmW6.pdf',NULL,NULL,NULL,'2025-07-18 20:30:27','2025-07-18 20:30:27'),(267,11,139,'oficio_entrega','submodulos/VXD4YMrePCWYhKjqKEf6CYXGtBPAU282k1xIOVEK.pdf',NULL,NULL,NULL,'2025-07-18 20:49:25','2025-07-18 20:49:25'),(268,9,139,'oficio_entrega','submodulos/7FWuEuqgEPtugsGNdmvxxobcEYRYyt7JZKkGGLuV.pdf',NULL,NULL,NULL,'2025-07-18 20:52:11','2025-07-18 20:52:11');

--
-- Table structure for table `submodulo_usuario`
--

CREATE TABLE `submodulo_usuario` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `submodulo_id` bigint unsigned NOT NULL,
  `estatus` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pendiente',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `submodulo_usuario_user_id_submodulo_id_unique` (`user_id`,`submodulo_id`),
  KEY `submodulo_usuario_submodulo_id_foreign` (`submodulo_id`),
  CONSTRAINT `submodulo_usuario_submodulo_id_foreign` FOREIGN KEY (`submodulo_id`) REFERENCES `submodulos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `submodulo_usuario_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `submodulo_usuario`
--

INSERT INTO `submodulo_usuario` VALUES (5,104,13,'Entregado','2025-05-30 19:43:52','2025-05-30 19:43:52'),(6,132,13,'Entregado','2025-05-30 19:48:21','2025-05-30 19:48:21'),(7,89,13,'Entregado','2025-05-30 19:50:52','2025-05-30 19:50:52'),(8,104,14,'Entregado','2025-05-30 19:55:05','2025-05-30 19:55:05'),(9,130,14,'Entregado','2025-05-30 20:55:06','2025-05-30 20:55:06'),(10,103,14,'Entregado','2025-05-30 21:02:30','2025-05-30 21:02:30'),(12,30,14,'Entregado','2025-05-30 22:08:27','2025-05-30 22:08:27'),(13,108,13,'Entregado','2025-05-31 03:19:52','2025-05-31 03:19:52'),(14,110,14,'Entregado','2025-05-31 04:05:27','2025-05-31 04:05:27'),(16,77,13,'Entregado','2025-05-31 04:45:06','2025-05-31 04:45:06'),(17,125,13,'Entregado','2025-05-31 04:46:44','2025-05-31 04:46:44'),(18,90,13,'Entregado','2025-05-31 05:51:46','2025-05-31 05:51:46'),(19,65,13,'Entregado','2025-06-01 23:46:52','2025-06-01 23:46:52'),(20,60,14,'Entregado','2025-06-02 02:46:37','2025-06-02 02:46:37'),(21,98,13,'Entregado','2025-06-02 15:21:18','2025-06-02 15:21:18'),(22,53,14,'Entregado','2025-06-02 17:00:26','2025-06-02 17:00:26'),(23,53,13,'Entregado','2025-06-02 17:04:50','2025-06-02 17:04:50'),(24,56,14,'Entregado','2025-06-02 18:34:59','2025-06-02 18:34:59'),(25,75,13,'Entregado','2025-06-02 18:44:32','2025-06-02 18:44:32'),(26,75,14,'Entregado','2025-06-02 18:50:49','2025-06-02 18:50:49'),(27,122,13,'Entregado','2025-06-02 19:21:17','2025-06-02 19:21:17'),(28,103,13,'Entregado','2025-06-02 20:24:07','2025-06-02 20:24:07'),(29,142,14,'Entregado','2025-06-02 20:39:04','2025-06-02 20:39:04'),(31,101,13,'Entregado','2025-06-02 21:03:46','2025-06-02 21:03:46'),(32,101,14,'Entregado','2025-06-02 21:04:01','2025-06-02 21:04:01'),(33,89,14,'Entregado','2025-06-02 21:32:03','2025-06-02 21:32:03'),(34,102,13,'Entregado','2025-06-02 21:51:44','2025-06-02 21:51:44'),(35,79,13,'Entregado','2025-06-03 00:08:35','2025-06-03 00:08:35'),(36,112,13,'Entregado','2025-06-03 01:13:53','2025-06-03 01:13:53'),(37,128,14,'Entregado','2025-06-03 04:56:37','2025-06-03 04:56:37'),(38,116,13,'Entregado','2025-06-03 15:09:52','2025-06-03 15:09:52'),(39,116,14,'Entregado','2025-06-03 15:10:14','2025-06-03 15:10:14'),(40,115,13,'Entregado','2025-06-03 16:16:30','2025-06-03 16:16:30'),(41,60,13,'Entregado','2025-06-03 16:17:52','2025-06-03 16:17:52'),(42,130,13,'Entregado','2025-06-03 17:00:18','2025-06-03 17:00:18'),(43,55,14,'Entregado','2025-06-03 17:30:55','2025-06-03 17:30:55'),(44,55,13,'Entregado','2025-06-03 17:36:20','2025-06-03 17:36:20'),(45,122,14,'Entregado','2025-06-03 17:38:38','2025-06-03 17:38:38'),(46,111,13,'Entregado','2025-06-03 17:42:48','2025-06-03 17:42:48'),(47,111,14,'Entregado','2025-06-03 17:53:56','2025-06-03 17:53:56'),(48,56,13,'Entregado','2025-06-03 19:04:22','2025-06-03 19:04:22'),(50,139,13,'Entregado','2025-06-03 20:26:00','2025-06-03 20:26:00'),(51,139,14,'Entregado','2025-06-03 20:26:34','2025-06-03 20:26:34'),(52,142,13,'Entregado','2025-06-03 20:52:33','2025-06-03 20:52:33'),(53,31,14,'Entregado','2025-06-03 21:09:22','2025-06-03 21:09:22'),(54,1,13,'Entregado','2025-06-03 21:26:24','2025-06-03 21:26:24'),(55,1,12,'Entregado','2025-06-03 21:31:08','2025-06-03 21:31:08'),(56,135,13,'Entregado','2025-06-03 23:33:51','2025-06-03 23:33:51'),(59,19,13,'Entregado','2025-06-04 01:07:17','2025-06-04 01:07:17'),(60,129,14,'Entregado','2025-06-04 01:17:40','2025-06-04 01:17:40'),(61,125,14,'Entregado','2025-06-04 01:22:15','2025-06-04 01:22:15'),(62,119,13,'Entregado','2025-06-04 01:28:00','2025-06-04 01:28:00'),(63,108,14,'Entregado','2025-06-04 01:29:53','2025-06-04 01:29:53'),(64,77,14,'Entregado','2025-06-04 04:00:11','2025-06-04 04:00:11'),(65,98,14,'Entregado','2025-06-04 04:16:31','2025-06-04 04:16:31'),(66,59,14,'Entregado','2025-06-04 04:36:03','2025-06-04 04:36:03'),(67,32,13,'Entregado','2025-06-04 04:39:40','2025-06-04 04:39:40'),(68,32,14,'Entregado','2025-06-04 04:49:24','2025-06-04 04:49:24'),(70,82,13,'Entregado','2025-06-04 13:50:01','2025-06-04 13:50:01'),(71,54,14,'Entregado','2025-06-04 15:11:36','2025-06-04 15:11:36'),(72,54,13,'Entregado','2025-06-04 15:13:23','2025-06-04 15:13:23'),(73,127,14,'Entregado','2025-06-04 15:27:41','2025-06-04 15:27:41'),(74,127,13,'Entregado','2025-06-04 15:27:59','2025-06-04 15:27:59'),(75,52,13,'Entregado','2025-06-04 16:00:53','2025-06-04 16:00:53'),(76,82,14,'Entregado','2025-06-04 16:07:57','2025-06-04 16:07:57'),(77,81,13,'Entregado','2025-06-04 17:54:41','2025-06-04 17:54:41'),(78,129,13,'Entregado','2025-06-04 18:05:19','2025-06-04 18:05:19'),(79,112,14,'Entregado','2025-06-04 18:19:21','2025-06-04 18:19:21'),(80,57,13,'Entregado','2025-06-04 18:57:02','2025-06-04 18:57:02'),(81,69,14,'Entregado','2025-06-05 00:22:11','2025-06-05 00:22:11'),(82,38,13,'Entregado','2025-06-05 02:02:01','2025-06-05 02:02:01'),(83,99,14,'Entregado','2025-06-05 15:08:41','2025-06-05 15:08:41'),(84,51,13,'Entregado','2025-06-06 03:16:30','2025-06-06 03:16:30'),(85,13,13,'Entregado','2025-06-06 16:51:40','2025-06-06 16:51:40'),(87,143,13,'Entregado','2025-06-06 21:00:25','2025-06-06 21:00:25'),(88,143,14,'Entregado','2025-06-06 21:00:54','2025-06-06 21:00:54'),(89,9,13,'Entregado','2025-06-06 21:34:10','2025-06-06 21:34:10'),(91,73,13,'Entregado','2025-06-07 01:48:35','2025-06-07 01:48:35'),(92,21,13,'Entregado','2025-06-07 16:25:16','2025-06-07 16:25:16'),(93,21,14,'Entregado','2025-06-07 16:34:13','2025-06-07 16:34:13'),(94,25,14,'Entregado','2025-06-08 00:09:49','2025-06-08 00:09:49'),(95,25,13,'Entregado','2025-06-08 00:34:46','2025-06-08 00:34:46'),(96,30,13,'Entregado','2025-06-09 16:53:28','2025-06-09 16:53:28'),(97,30,8,'Entregado','2025-06-09 16:54:22','2025-06-09 16:54:22'),(98,73,14,'Entregado','2025-06-09 19:55:45','2025-06-09 19:55:45'),(99,51,14,'Entregado','2025-06-09 20:04:58','2025-06-09 20:04:58'),(100,104,8,'Entregado','2025-06-09 20:37:26','2025-06-09 20:37:26'),(101,134,13,'Entregado','2025-06-09 23:18:17','2025-06-09 23:18:17'),(102,142,8,'Entregado','2025-06-10 14:37:45','2025-06-10 14:37:45'),(103,53,8,'Entregado','2025-06-10 16:44:10','2025-06-10 16:44:10'),(104,134,8,'Entregado','2025-06-10 18:14:57','2025-06-10 18:14:57'),(105,103,8,'Entregado','2025-06-10 22:27:41','2025-06-10 22:27:41'),(106,110,13,'Entregado','2025-06-11 02:16:45','2025-06-11 02:16:45'),(107,89,8,'Entregado','2025-06-11 18:26:07','2025-06-11 18:26:07'),(108,129,8,'Entregado','2025-06-12 17:03:27','2025-06-12 17:03:27'),(109,130,8,'Entregado','2025-06-12 17:35:40','2025-06-12 17:35:40'),(110,75,8,'Entregado','2025-06-12 18:39:53','2025-06-12 18:39:53'),(111,55,8,'Entregado','2025-06-12 19:38:20','2025-06-12 19:38:20'),(112,128,13,'Entregado','2025-06-13 00:16:58','2025-06-13 00:16:58'),(113,125,8,'Entregado','2025-06-13 01:53:47','2025-06-13 01:53:47'),(114,61,13,'Entregado','2025-06-13 03:13:01','2025-06-13 03:13:01'),(115,56,8,'Entregado','2025-06-13 17:55:58','2025-06-13 17:55:58'),(116,111,8,'Entregado','2025-06-13 18:12:31','2025-06-13 18:12:31'),(117,116,8,'Entregado','2025-06-13 19:43:16','2025-06-13 19:43:16'),(118,139,8,'Entregado','2025-06-13 20:58:16','2025-06-13 20:58:16'),(119,82,8,'Entregado','2025-06-13 22:18:45','2025-06-13 22:18:45'),(120,112,8,'Entregado','2025-06-14 00:47:26','2025-06-14 00:47:26'),(121,108,8,'Entregado','2025-06-14 01:31:14','2025-06-14 01:31:14'),(122,32,8,'Entregado','2025-06-14 02:50:54','2025-06-14 02:50:54'),(123,76,8,'Entregado','2025-06-14 04:28:22','2025-06-14 04:28:22'),(124,119,14,'Entregado','2025-06-14 05:05:04','2025-06-14 05:05:04'),(125,119,8,'Entregado','2025-06-14 05:06:26','2025-06-14 05:06:26'),(126,59,13,'Entregado','2025-06-14 05:22:57','2025-06-14 05:22:57'),(127,110,8,'Entregado','2025-06-14 05:29:49','2025-06-14 05:29:49'),(128,59,8,'Entregado','2025-06-14 05:37:20','2025-06-14 05:37:20'),(129,21,8,'Entregado','2025-06-14 05:49:41','2025-06-14 05:49:41'),(130,90,14,'Entregado','2025-06-14 18:13:55','2025-06-14 18:13:55'),(131,90,8,'Entregado','2025-06-14 18:16:59','2025-06-14 18:16:59'),(132,77,8,'Entregado','2025-06-17 17:36:30','2025-06-17 17:36:30'),(133,98,8,'Entregado','2025-06-17 18:12:29','2025-06-17 18:12:29'),(134,122,8,'Entregado','2025-06-17 18:14:23','2025-06-17 18:14:23'),(135,128,8,'Entregado','2025-06-18 01:13:41','2025-06-18 01:13:41'),(136,46,14,'Entregado','2025-06-18 19:01:15','2025-06-18 19:01:15'),(137,46,8,'Entregado','2025-06-18 19:03:03','2025-06-18 19:03:03'),(138,69,8,'Entregado','2025-06-19 13:55:52','2025-06-19 13:55:52'),(139,9,14,'Entregado','2025-06-20 02:10:22','2025-06-20 02:10:22'),(140,9,8,'Entregado','2025-06-20 02:10:37','2025-06-20 02:10:37'),(141,143,8,'Entregado','2025-06-20 17:24:46','2025-06-20 17:24:46'),(142,12,13,'Entregado','2025-06-30 16:44:43','2025-06-30 16:44:43'),(143,12,11,'Entregado','2025-06-30 16:45:17','2025-06-30 16:45:17'),(144,79,11,'Entregado','2025-06-30 23:02:02','2025-06-30 23:02:02'),(145,104,11,'Entregado','2025-06-30 23:06:26','2025-06-30 23:06:26'),(146,19,11,'Entregado','2025-07-01 03:57:53','2025-07-01 03:57:53'),(147,57,8,'Entregado','2025-07-01 16:46:13','2025-07-01 16:46:13'),(148,142,11,'Entregado','2025-07-01 20:35:29','2025-07-01 20:35:29'),(149,61,11,'Entregado','2025-07-02 05:59:12','2025-07-02 05:59:12'),(151,122,11,'Entregado','2025-07-02 15:13:40','2025-07-02 15:13:40'),(153,55,11,'Entregado','2025-07-02 19:41:35','2025-07-02 19:41:35'),(154,25,11,'Entregado','2025-07-02 19:57:53','2025-07-02 19:57:53'),(155,111,11,'Entregado','2025-07-02 19:58:47','2025-07-02 19:58:47'),(156,98,11,'Entregado','2025-07-02 20:08:20','2025-07-02 20:08:20'),(157,108,11,'Entregado','2025-07-03 04:11:04','2025-07-03 04:11:04'),(158,76,13,'Entregado','2025-07-03 05:17:27','2025-07-03 05:17:27'),(159,76,11,'Entregado','2025-07-03 05:18:08','2025-07-03 05:18:08'),(160,65,11,'Entregado','2025-07-03 15:43:22','2025-07-03 15:43:22'),(161,115,11,'Entregado','2025-07-03 19:10:54','2025-07-03 19:10:54'),(162,53,11,'Entregado','2025-07-03 20:37:01','2025-07-03 20:37:01'),(163,20,14,'Entregado','2025-07-03 21:32:46','2025-07-03 21:32:46'),(164,20,8,'Entregado','2025-07-03 21:36:00','2025-07-03 21:36:00'),(165,20,13,'Entregado','2025-07-03 22:05:56','2025-07-03 22:05:56'),(166,20,11,'Entregado','2025-07-03 22:25:50','2025-07-03 22:25:50'),(167,132,11,'Entregado','2025-07-04 01:36:52','2025-07-04 01:36:52'),(168,23,14,'Entregado','2025-07-04 04:04:24','2025-07-04 04:04:24'),(169,23,8,'Entregado','2025-07-04 04:15:14','2025-07-04 04:15:14'),(171,75,11,'Entregado','2025-07-04 16:27:30','2025-07-04 16:27:30'),(172,73,8,'Entregado','2025-07-04 16:28:51','2025-07-04 16:28:51'),(173,25,8,'Entregado','2025-07-04 16:34:30','2025-07-04 16:34:30'),(174,13,14,'Entregado','2025-07-04 16:48:04','2025-07-04 16:48:04'),(175,13,8,'Entregado','2025-07-04 16:48:25','2025-07-04 16:48:25'),(176,31,13,'Entregado','2025-07-04 19:16:12','2025-07-04 19:16:12'),(177,31,11,'Entregado','2025-07-04 19:19:28','2025-07-04 19:19:28'),(178,31,8,'Entregado','2025-07-04 19:21:07','2025-07-04 19:21:07'),(179,134,14,'Entregado','2025-07-04 19:44:53','2025-07-04 19:44:53'),(180,30,11,'Entregado','2025-07-04 20:27:28','2025-07-04 20:27:28'),(181,107,13,'Entregado','2025-07-05 01:45:12','2025-07-05 01:45:12'),(182,13,11,'Entregado','2025-07-05 05:10:20','2025-07-05 05:10:20'),(183,89,11,'Entregado','2025-07-07 17:01:19','2025-07-07 17:01:19'),(184,57,11,'Entregado','2025-07-07 20:22:05','2025-07-07 20:22:05'),(185,77,11,'Entregado','2025-07-07 21:47:32','2025-07-07 21:47:32'),(186,38,8,'Entregado','2025-07-07 22:50:57','2025-07-07 22:50:57'),(187,38,11,'Entregado','2025-07-07 23:00:00','2025-07-07 23:00:00'),(188,92,13,'Entregado','2025-07-07 23:08:19','2025-07-07 23:08:19'),(189,38,14,'Entregado','2025-07-07 23:19:03','2025-07-07 23:19:03'),(190,134,11,'Entregado','2025-07-08 01:08:55','2025-07-08 01:08:55'),(191,92,11,'Entregado','2025-07-08 14:56:47','2025-07-08 14:56:47'),(192,143,11,'Entregado','2025-07-08 15:52:52','2025-07-08 15:52:52'),(193,60,11,'Entregado','2025-07-09 00:51:23','2025-07-09 00:51:23'),(194,60,8,'Entregado','2025-07-09 00:53:23','2025-07-09 00:53:23'),(195,58,14,'Entregado','2025-07-09 13:26:04','2025-07-09 13:26:04'),(196,58,8,'Entregado','2025-07-09 13:27:20','2025-07-09 13:27:20'),(197,81,11,'Entregado','2025-07-11 17:44:01','2025-07-11 17:44:01'),(198,110,11,'Entregado','2025-07-12 02:57:38','2025-07-12 02:57:38'),(199,127,8,'Entregado','2025-07-14 14:31:36','2025-07-14 14:31:36'),(200,127,9,'Entregado','2025-07-14 14:49:41','2025-07-14 14:49:41'),(201,127,11,'Entregado','2025-07-15 15:20:37','2025-07-15 15:20:37'),(202,125,11,'Entregado','2025-07-15 17:53:50','2025-07-15 17:53:50'),(203,77,9,'Entregado','2025-07-15 18:42:42','2025-07-15 18:42:42'),(204,129,9,'Entregado','2025-07-15 18:50:03','2025-07-15 18:50:03'),(205,129,11,'Entregado','2025-07-15 19:14:34','2025-07-15 19:14:34'),(206,125,9,'Entregado','2025-07-15 20:07:30','2025-07-15 20:07:30'),(207,103,9,'Entregado','2025-07-16 00:45:01','2025-07-16 00:45:01'),(208,32,11,'Entregado','2025-07-16 03:09:16','2025-07-16 03:09:16'),(209,32,9,'Entregado','2025-07-16 03:09:46','2025-07-16 03:09:46'),(210,59,9,'Entregado','2025-07-16 04:23:36','2025-07-16 04:23:36'),(211,134,9,'Entregado','2025-07-16 16:25:00','2025-07-16 16:25:00'),(212,58,9,'Entregado','2025-07-16 18:17:50','2025-07-16 18:17:50'),(213,55,9,'Entregado','2025-07-16 19:43:20','2025-07-16 19:43:20'),(214,108,9,'Entregado','2025-07-17 04:38:08','2025-07-17 04:38:08'),(215,75,9,'Entregado','2025-07-17 13:21:49','2025-07-17 13:21:49'),(216,57,9,'Entregado','2025-07-17 15:04:10','2025-07-17 15:04:10'),(217,103,11,'Entregado','2025-07-17 15:17:13','2025-07-17 15:17:13'),(218,60,9,'Entregado','2025-07-17 16:06:59','2025-07-17 16:06:59'),(219,122,9,'Entregado','2025-07-17 20:42:02','2025-07-17 20:42:02'),(220,104,9,'Entregado','2025-07-17 20:42:16','2025-07-17 20:42:16'),(221,111,9,'Entregado','2025-07-17 20:43:51','2025-07-17 20:43:51'),(222,73,9,'Entregado','2025-07-18 14:57:20','2025-07-18 14:57:20'),(223,119,9,'Entregado','2025-07-18 16:45:30','2025-07-18 16:45:30'),(224,116,9,'Entregado','2025-07-18 18:50:02','2025-07-18 18:50:02'),(225,53,9,'Entregado','2025-07-18 20:07:12','2025-07-18 20:07:12'),(226,142,9,'Entregado','2025-07-18 20:21:54','2025-07-18 20:21:54'),(227,128,9,'Entregado','2025-07-18 20:22:31','2025-07-18 20:22:31'),(228,98,9,'Entregado','2025-07-18 20:30:27','2025-07-18 20:30:27'),(229,139,11,'Entregado','2025-07-18 20:49:25','2025-07-18 20:49:25'),(230,139,9,'Entregado','2025-07-18 20:52:11','2025-07-18 20:52:11');

--
-- Table structure for table `submodulos`
--

CREATE TABLE `submodulos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `subsection_id` bigint unsigned NOT NULL,
  `titulo` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` text COLLATE utf8mb4_unicode_ci,
  `documento_solicitado` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fecha_apertura` datetime DEFAULT NULL,
  `fecha_cierre` datetime DEFAULT NULL,
  `fecha_limite` datetime DEFAULT NULL,
  `estatus` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pendiente',
  `acuse_pdf` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `documento_url` varchar(125) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `orden` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submodulos_subsection_id_foreign` (`subsection_id`),
  CONSTRAINT `submodulos_subsection_id_foreign` FOREIGN KEY (`subsection_id`) REFERENCES `subsections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `submodulos`
--

INSERT INTO `submodulos` VALUES (8,1002,'1er Tutoría Grupal',NULL,'/tmp/php5KrdLJ','2025-06-09 01:00:00','2025-06-18 12:59:00','2025-06-13 23:59:00','Incumplimiento',NULL,NULL,1,'2025-05-27 03:42:05','2025-06-30 15:28:17'),(9,1002,'2da Tutoría Grupal',NULL,'/tmp/phpgMmVSL','2025-07-14 01:00:00','2025-07-23 23:59:00','2025-07-18 23:59:00','pendiente',NULL,NULL,2,'2025-05-27 03:43:44','2025-06-30 15:28:25'),(10,1002,'3er Tutoría Grupal',NULL,'/tmp/phpwxHDyT','2025-08-18 01:00:00','2025-08-22 23:59:00','2025-08-22 23:59:00','pendiente',NULL,NULL,3,'2025-05-27 03:44:38','2025-06-30 15:28:33'),(11,6,'Informe Parcial',NULL,'plantillas/YVtSOVHJWfTEKuMYOSGqQGofauXQto2FlaNtcWIW.docx','2025-06-23 01:00:00','2025-07-02 23:59:00','2025-06-27 23:59:00','pendiente',NULL,NULL,2,'2025-05-27 03:54:11','2025-06-30 15:30:16'),(12,6,'Informe Global',NULL,'plantillas/m8bj22605ChMrFxQbjV6uk59QN38iTGvFcfXObqu.docx','2025-08-18 01:00:00','2025-08-22 23:59:00','2025-08-22 23:59:00','pendiente',NULL,NULL,3,'2025-05-27 04:00:24','2025-06-30 15:30:25'),(13,6,'Registro de Proyecto Institucional',NULL,'plantillas/bE1rsAo1TLN6pcaVwAbZG07jscri8h76yn5h873w.docx','2025-05-26 01:00:00','2025-06-03 23:59:00','2025-05-30 23:59:00','Incumplimiento',NULL,NULL,1,'2025-05-29 01:58:10','2025-06-30 15:27:51'),(14,1002,'Presentación del Tutor',NULL,'plantillas/RTaNciNRe6Er1ZkJGUtEoDflqiujHROyejXeRZOg.xlsx','2025-05-06 01:00:00','2025-06-06 12:59:00','2025-06-03 23:59:00','Incumplimiento',NULL,NULL,0,'2025-05-30 02:25:38','2025-06-30 15:30:02');

--
-- Table structure for table `subsections`
--

CREATE TABLE `subsections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(125) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modulo_id` bigint unsigned NOT NULL,
  `parent_id` bigint unsigned DEFAULT NULL,
  `orden` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subsections_modulo_id_foreign` (`modulo_id`),
  KEY `subsections_parent_id_foreign` (`parent_id`),
  CONSTRAINT `subsections_modulo_id_foreign` FOREIGN KEY (`modulo_id`) REFERENCES `modulos` (`id`) ON DELETE CASCADE,
  CONSTRAINT `subsections_parent_id_foreign` FOREIGN KEY (`parent_id`) REFERENCES `subsections` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=1005 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subsections`
--

INSERT INTO `subsections` VALUES (4,'Licenciaturas',1,NULL,0,'2025-03-31 03:30:13','2025-03-31 03:30:13'),(5,'Maestrías',1,NULL,0,'2025-03-31 03:30:22','2025-03-31 03:30:22'),(6,'Proyecto Institucional',5,NULL,2,'2025-04-23 09:57:32','2025-05-29 06:11:14'),(7,'GESTIÓN ACADÉMICA',5,NULL,1,'2025-04-23 10:20:27','2025-05-29 06:11:14'),(1000,'Licenciaturas',6,NULL,1,'2025-05-20 15:12:53','2025-05-29 06:01:37'),(1001,'MAESTRÍA',6,NULL,2,'2025-05-20 15:23:07','2025-05-29 06:01:37'),(1002,'GESTIÓN TUTORIAL',5,NULL,3,'2025-05-27 03:18:19','2025-05-30 01:56:52'),(1003,'Profesor de Tiempo Completo Titular A y B',8,NULL,0,'2025-07-04 20:22:25','2025-07-04 20:25:16'),(1004,'Septiembre Diciembre 2025',9,NULL,0,'2025-07-11 21:04:37','2025-07-11 21:05:23');

--
-- Table structure for table `tutorials`
--

CREATE TABLE `tutorials` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `orden` int NOT NULL DEFAULT '0',
  `titulo` varchar(125) COLLATE utf8mb4_spanish_ci NOT NULL,
  `descripcion` text COLLATE utf8mb4_spanish_ci,
  `tipo` varchar(125) COLLATE utf8mb4_spanish_ci NOT NULL DEFAULT 'video',
  `url` varchar(125) COLLATE utf8mb4_spanish_ci DEFAULT NULL,
  `imagenes` json DEFAULT NULL,
  `activo` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_spanish_ci;

--
-- Dumping data for table `tutorials`
--



