
--
-- Table structure for table `videos`
--

CREATE TABLE `videos` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint unsigned NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video_link` text COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `videos_category_id_foreign` (`category_id`),
  CONSTRAINT `videos_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `videos`
--

INSERT INTO `videos` (`id`, `category_id`, `name`, `video_link`, `deleted_at`, `created_at`, `updated_at`) VALUES (1,2,'first video','https://www.youtube.com/watch?v=HtgT8Zmf35c','2024-08-24 16:23:32','2024-08-16 08:19:34','2024-08-24 16:23:32'),(2,2,'Video2','https://www.youtube.com/watch?v=XPPWZlViqS4','2024-08-24 16:23:32','2024-08-16 08:22:35','2024-08-24 16:23:32'),(5,17,'الزواج السعيد','https://www.youtube.com/embed/1_oBBYS3rRs','2024-09-20 11:26:38','2024-08-25 05:52:27','2024-09-20 11:26:38'),(6,3,'مجالس القرآن -الدرس الرابع- سورة النجم','https://www.youtube.com/embed/zeMUoKB3OZ0?si=0fwh-WmDqPw8XXt8','2024-09-20 17:40:18','2024-08-25 12:16:04','2024-09-20 17:40:18'),(9,3,'عبد الله','https://youtu.be/OekUc3ezDiU?si=58w4xF0NL_IYGsQU','2024-09-20 11:26:21','2024-09-15 10:20:16','2024-09-20 11:26:21'),(11,68,'فيديو : المدرسة - بيانات المدرسة','https://www.youtube.com/watch?v=3N8vu5DdLbE',NULL,'2024-09-20 17:41:22','2024-09-21 05:52:20'),(13,70,'..00 المدرسة - طلاب المدرسة','https://www.youtube.com/watch?v=8s3waZw1as0',NULL,'2024-09-21 05:49:40','2024-10-27 09:48:33'),(14,71,'فيديو : المدرسة - معلمي المدرسة','https://www.youtube.com/watch?v=aKrXC_QdfMA','2024-09-22 10:15:23','2024-09-21 05:54:22','2024-09-22 10:15:23'),(15,90,'فيديو : المدرسة - إداري المدرسة','https://www.youtube.com/watch?v=iLyKbfr89Mc',NULL,'2024-09-21 06:20:58','2024-10-03 11:55:28'),(16,73,'فيديو : التكليفات','https://www.youtube.com/watch?v=NDiAWaODyXM',NULL,'2024-09-21 06:26:35','2024-09-21 06:31:36'),(17,74,'فيديو : اجتماعات اللجان والفرق','https://www.youtube.com/watch?v=dEiS_WpFuc0',NULL,'2024-09-21 06:48:28','2024-09-21 06:48:28'),(18,75,'فيديو : الجداول','https://www.youtube.com/watch?v=saYVbgdn3VU','2024-10-27 09:49:25','2024-09-21 06:50:41','2024-10-27 09:49:25'),(19,76,'فيديو : الزيارات الصفية','https://www.youtube.com/watch?v=CG48pSyK8GU',NULL,'2024-09-21 06:53:48','2024-09-21 06:53:48'),(20,86,'فيديو : بيانات المدرسة / بيانات عامة','https://www.youtube.com/watch?v=nvhh95cyRDw',NULL,'2024-09-21 07:12:12','2024-09-21 07:12:12'),(21,85,'فيديو : الإعدادات','https://www.youtube.com/watch?v=wE6NNKcnaPA',NULL,'2024-09-21 08:10:59','2024-09-21 08:10:59'),(22,92,'فيديو : الصفحة الرئيسية للمعلمين','https://youtu.be/ZsZNggMBQLo?si=hWYXVQ0qJnzy0jid',NULL,'2024-09-21 08:26:21','2024-10-10 10:18:19'),(23,94,'فيديو : النماذج للمعلمين','https://www.youtube.com/watch?v=tBM9Y1dgEJU',NULL,'2024-09-21 08:38:15','2024-09-21 08:38:15'),(24,96,'فيديو : لجان الإشراف للمعلمين','https://www.youtube.com/watch?v=A8pydJs-Rns&list=PLCpK4282MCT80bGKKd_Ia8-y9HzKQcyOP&index=3',NULL,'2024-09-21 08:41:45','2024-09-21 08:41:45'),(25,87,'فيديو : بيانات المدرسة / بيانات مرافق المدرسة','https://www.youtube.com/watch?v=U31q1e-JH-w',NULL,'2024-09-22 09:05:22','2024-09-22 09:05:22'),(26,88,'فيديو : إداري المدرسة / بيانات الإداريين','https://www.youtube.com/watch?v=z2YwXCjEdOM',NULL,'2024-09-22 09:19:47','2024-09-22 09:19:47'),(27,100,'فيديو : إداري المدرسة / الحضور والغياب والتأخر','https://www.youtube.com/watch?v=RaqV1XiWZuY',NULL,'2024-09-22 09:20:50','2024-09-22 09:20:50'),(28,102,'فيديو : النماذج للإداريين','https://www.youtube.com/watch?v=5CXOaQOYVrE','2024-10-03 10:22:23','2024-09-22 10:04:48','2024-10-03 10:22:23'),(29,103,'فيديو : النماذج / الأدلة واللوائح','https://www.youtube.com/watch?v=pc4aUaoq5fc',NULL,'2024-09-22 10:08:12','2024-09-22 10:08:12'),(32,77,'فيديو الإختبارات','https://www.youtube.com/watch?v=81IXLTQHy6I',NULL,'2024-09-24 06:42:14','2024-09-24 06:42:14'),(33,78,'شسيشسي','شسيشسي',NULL,'2024-09-24 17:53:43','2024-09-24 17:53:43'),(34,79,'ضصقضصق','شسيضشصقضصق',NULL,'2024-09-24 17:54:50','2024-09-24 17:54:50'),(36,82,'شسيشسي','شسيشس',NULL,'2024-09-24 17:56:30','2024-09-24 17:56:30'),(37,83,'شسيشسي','شسيشس',NULL,'2024-09-24 17:56:54','2024-09-24 17:56:54'),(38,84,'شسيشسي','شسيشسي',NULL,'2024-09-24 17:57:32','2024-09-24 17:57:32'),(46,69,'الجديد','https://youtu.be/K4_fI62oaXQ?t=82',NULL,'2024-10-03 09:48:00','2024-10-27 09:47:25'),(48,106,'تعلم','https://youtu.be/Vd62pulIA9E?si=gdiWdpiXZFE7baU3',NULL,'2024-10-03 10:04:26','2024-10-03 10:04:26'),(49,110,'المناوبة','https://youtu.be/-seJMi4_n3E?si=zKpObg99GZlhcfjd',NULL,'2024-10-03 10:12:48','2024-10-10 09:36:14'),(50,111,'1','https://youtu.be/I0ZTlRfd55w?si=O0jfAJe42ibeMrNz',NULL,'2024-10-03 10:17:44','2024-10-03 10:17:44'),(51,112,'2','https://youtu.be/I0ZTlRfd55w?si=8EezlbZVxOaHW46Q',NULL,'2024-10-03 10:18:22','2024-10-03 10:18:22'),(52,113,'3','https://youtu.be/DkmUMedkbLo?si=sm2ON_dJx83Fw1ov',NULL,'2024-10-03 10:18:46','2024-10-03 10:18:46'),(53,80,'ال','https://youtu.be/35SvtylJaNY?si=4i6KUxTMMJFVo6SM',NULL,'2024-10-03 10:25:58','2024-10-03 10:25:58'),(54,81,'ااا','https://youtu.be/b3odHJStdB8?si=Uf44Ys29EqahXcn3',NULL,'2024-10-03 11:39:00','2024-10-03 11:39:00'),(55,67,'تعرف ما هي الخطابات الرسمسة حفقخبنثرح','https://youtu.be/a-PzBHtPivg?si=6FzCgZY0yC3xI0XN','2024-10-13 09:47:44','2024-10-10 09:37:47','2024-10-13 09:47:44'),(56,114,'المدير','https://youtu.be/dn8rw2fFl3s?si=bn2xzGpMlbEbrN2c',NULL,'2024-10-10 09:40:42','2024-10-10 09:40:42'),(57,115,'للابريؤء','https://youtu.be/B_I6H0j8Cmk?si=HE1BK-JEPPcg4xeK',NULL,'2024-10-13 09:50:46','2024-10-13 09:50:46'),(58,196,'عام','https://youtu.be/SRUuv3BSfpc?si=m5yYQswG_wvPQ-6o&t=887',NULL,'2024-10-27 09:53:18','2024-10-27 09:56:54');

--
-- Table structure for table `violation_assigns_`
--

CREATE TABLE `violation_assigns_` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `school_class_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `for_government` tinyint(1) NOT NULL DEFAULT '0',
  `violation_grade_id` bigint unsigned NOT NULL,
  `date_type` enum('coptic','hijri') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crime_date_type` enum('coptic','hijri') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `crime_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `violation_title_id` bigint unsigned NOT NULL,
  `namozeg_ids` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `committee_action_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `committee_subject` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `committee_date_type` enum('coptic','hijri') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `committee_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `administration_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `administration_date_type` enum('coptic','hijri') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `administration_date` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `violation_assigns__school_class_id_foreign` (`school_class_id`),
  KEY `violation_assigns__user_id_foreign` (`user_id`),
  KEY `violation_assigns__violation_grade_id_foreign` (`violation_grade_id`),
  KEY `violation_assigns__violation_title_id_foreign` (`violation_title_id`),
  CONSTRAINT `violation_assigns__school_class_id_foreign` FOREIGN KEY (`school_class_id`) REFERENCES `school_classes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `violation_assigns__user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `school_classes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `violation_assigns__violation_grade_id_foreign` FOREIGN KEY (`violation_grade_id`) REFERENCES `violation_grades` (`id`) ON DELETE CASCADE,
  CONSTRAINT `violation_assigns__violation_title_id_foreign` FOREIGN KEY (`violation_title_id`) REFERENCES `violation_titles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_assigns_`
--


--
-- Table structure for table `violation_grades`
--

CREATE TABLE `violation_grades` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `violation_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `violation_grades_violation_id_foreign` (`violation_id`),
  CONSTRAINT `violation_grades_violation_id_foreign` FOREIGN KEY (`violation_id`) REFERENCES `violations` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_grades`
--

INSERT INTO `violation_grades` (`id`, `name`, `violation_id`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'مخالفات الدرجة الثانية جديده',1,'2024-09-20 14:02:02','2024-11-09 08:42:57',NULL),(13,'مخالفة درجة ثانية',1,'2024-09-29 08:11:30','2024-09-29 08:11:30',NULL),(14,'الدرجة الثالثة',1,'2024-10-17 07:02:39','2024-10-17 07:02:39',NULL),(16,'مخالفات الدرجة الاولي',1,'2024-11-08 15:17:36','2024-11-08 15:17:36',NULL),(18,'مخالفة الدرجة الاولى',2,'2024-11-09 10:39:54','2024-11-09 10:39:54',NULL),(19,'مخالفة سلوكية 1',6,'2024-11-11 08:38:41','2024-11-11 08:38:41',NULL),(20,'مخالفة سلوكية تعليمية',9,'2024-11-11 09:22:08','2024-11-11 09:22:08',NULL),(21,'مخالفة سلوكية إدارية',9,'2024-11-11 09:36:26','2024-11-11 09:36:26',NULL),(22,'مخالفة عن بعد',8,'2024-11-11 09:37:27','2024-11-11 09:37:27',NULL),(23,'Test',7,'2024-11-13 13:01:43','2024-11-13 13:01:43',NULL),(24,'مخالفة الدرجة الثانية',2,'2024-11-13 15:47:42','2024-11-13 15:47:42',NULL);

--
-- Table structure for table `violation_names`
--

CREATE TABLE `violation_names` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_names`
--

INSERT INTO `violation_names` (`id`, `name`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'الاجراء الاولى',NULL,NULL,NULL),(2,'الاجراء الثانية',NULL,NULL,NULL),(3,'الاجراء الثالثة',NULL,NULL,NULL),(4,'الاجراء الرابعة',NULL,NULL,NULL),(5,'الاجراء الخامسة',NULL,NULL,NULL),(6,'الاجراء السادسة',NULL,NULL,NULL),(7,'الاجراء السابعة',NULL,NULL,NULL),(8,'الاجراء الثامنه',NULL,NULL,NULL),(9,'الاجراء التاسعه',NULL,NULL,NULL),(10,'الاجراء العاشرة',NULL,NULL,NULL);

--
-- Table structure for table `violation_punishments`
--

CREATE TABLE `violation_punishments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `violation_title_id` bigint unsigned NOT NULL,
  `violation_punishment_id` bigint unsigned NOT NULL,
  `value` tinyint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `violation_punishments_violation_title_id_foreign` (`violation_title_id`),
  KEY `violation_punishments_violation_punishment_id_foreign` (`violation_punishment_id`),
  CONSTRAINT `violation_punishments_violation_punishment_id_foreign` FOREIGN KEY (`violation_punishment_id`) REFERENCES `namazeg` (`id`) ON DELETE CASCADE,
  CONSTRAINT `violation_punishments_violation_title_id_foreign` FOREIGN KEY (`violation_title_id`) REFERENCES `violation_titles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=266 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_punishments`
--

INSERT INTO `violation_punishments` (`id`, `violation_title_id`, `violation_punishment_id`, `value`, `created_at`, `updated_at`, `deleted_at`) VALUES (9,3,46,NULL,'2024-10-16 09:50:15','2024-10-16 09:50:15',NULL),(10,3,164,NULL,'2024-10-16 09:50:15','2024-10-16 09:50:15',NULL),(14,5,164,5,'2024-10-17 07:13:26','2024-10-17 07:13:26',NULL),(45,11,46,NULL,'2024-11-11 08:39:18','2024-11-11 08:39:18',NULL),(46,11,48,NULL,'2024-11-11 08:39:18','2024-11-11 08:39:18',NULL),(47,11,164,NULL,'2024-11-11 08:39:18','2024-11-11 08:39:18',NULL),(48,11,166,NULL,'2024-11-11 08:39:18','2024-11-11 08:39:18',NULL),(168,27,46,NULL,'2024-11-13 15:49:36','2024-11-13 15:49:36',NULL),(169,27,48,NULL,'2024-11-13 15:49:36','2024-11-13 15:49:36',NULL),(170,27,164,NULL,'2024-11-13 15:49:36','2024-11-13 15:49:36',NULL),(171,27,166,NULL,'2024-11-13 15:49:36','2024-11-13 15:49:36',NULL),(191,20,46,NULL,'2024-11-14 10:14:16','2024-11-14 10:14:16',NULL),(192,20,166,NULL,'2024-11-14 10:14:16','2024-11-14 10:14:16',NULL),(193,20,164,NULL,'2024-11-14 10:14:16','2024-11-14 10:14:16',NULL),(194,20,48,NULL,'2024-11-14 10:14:16','2024-11-14 10:14:16',NULL),(198,4,164,4,'2024-11-14 11:19:55','2024-11-14 11:19:55',NULL),(199,29,46,NULL,'2024-11-14 11:21:58','2024-11-14 11:21:58',NULL),(200,29,48,NULL,'2024-11-14 11:21:58','2024-11-14 11:21:58',NULL),(201,10,133,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(202,10,134,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(203,10,135,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(204,10,136,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(205,10,137,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(206,10,138,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(207,10,139,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(208,10,140,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(209,10,141,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(210,10,142,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(211,10,143,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(212,10,144,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(213,10,145,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(214,10,146,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(215,10,147,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(216,10,148,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(217,10,149,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(218,10,150,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(219,10,151,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(220,10,152,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(221,10,153,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(222,10,154,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(223,10,155,NULL,'2024-11-15 19:28:22','2024-11-15 19:28:22',NULL),(242,19,133,NULL,'2024-11-16 13:47:30','2024-11-16 13:47:30',NULL),(243,19,136,NULL,'2024-11-16 13:47:30','2024-11-16 13:47:30',NULL),(244,19,137,NULL,'2024-11-16 13:47:30','2024-11-16 13:47:30',NULL),(245,19,141,NULL,'2024-11-16 13:47:30','2024-11-16 13:47:30',NULL),(246,19,142,NULL,'2024-11-16 13:47:30','2024-11-16 13:47:30',NULL),(247,19,144,NULL,'2024-11-16 13:47:30','2024-11-16 13:47:30',NULL),(248,30,133,NULL,'2024-11-16 14:18:37','2024-11-16 14:18:37',NULL),(249,30,147,NULL,'2024-11-16 14:18:37','2024-11-16 14:18:37',NULL),(252,15,133,NULL,'2024-11-17 07:46:38','2024-11-17 07:46:38',NULL),(253,15,135,NULL,'2024-11-17 07:46:38','2024-11-17 07:46:38',NULL),(260,32,141,NULL,'2024-11-17 08:40:38','2024-11-17 08:40:38',NULL),(261,32,153,NULL,'2024-11-17 08:40:38','2024-11-17 08:40:38',NULL),(262,31,143,NULL,'2024-11-17 09:44:59','2024-11-17 09:44:59',NULL),(263,31,142,NULL,'2024-11-17 09:44:59','2024-11-17 09:44:59',NULL),(264,16,141,NULL,'2024-11-19 10:17:58','2024-11-19 10:17:58',NULL),(265,16,147,NULL,'2024-11-19 10:17:58','2024-11-19 10:17:58',NULL);

--
-- Table structure for table `violation_student_punishments`
--

CREATE TABLE `violation_student_punishments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `violation_student_title_id` bigint unsigned NOT NULL,
  `punishment_id` int unsigned NOT NULL,
  `status` enum('skipped','done','still') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'still',
  `namazeg_version_id` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delete verison namozeg` (`namazeg_version_id`),
  KEY `delete violation student title` (`violation_student_title_id`),
  CONSTRAINT `delete verison namozeg` FOREIGN KEY (`namazeg_version_id`) REFERENCES `namazeg_versions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `delete violation student title` FOREIGN KEY (`violation_student_title_id`) REFERENCES `violation_student_titles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_student_punishments`
--

INSERT INTO `violation_student_punishments` (`id`, `violation_student_title_id`, `punishment_id`, `status`, `namazeg_version_id`, `created_at`, `updated_at`) VALUES (1,1,133,'done',NULL,'2024-11-16 19:32:01','2024-11-16 19:32:30'),(2,1,135,'done',NULL,'2024-11-16 19:32:01','2024-11-16 19:32:30'),(7,8,133,'done',NULL,'2024-11-17 07:48:12','2024-11-17 07:48:52'),(8,8,135,'done',NULL,'2024-11-17 07:48:12','2024-11-17 07:48:52'),(9,10,46,'done',NULL,'2024-11-17 08:26:30','2024-11-17 08:26:40'),(10,2,133,'done',NULL,'2024-11-17 08:27:24','2024-11-17 08:27:41'),(11,2,147,'done',NULL,'2024-11-17 08:27:24','2024-11-17 08:27:41'),(13,14,133,'done',NULL,'2024-11-17 09:19:30','2024-11-17 09:43:02'),(14,14,147,'done',NULL,'2024-11-17 09:19:30','2024-11-17 09:43:02'),(15,14,147,'done',NULL,'2024-11-17 09:33:18','2024-11-17 09:43:02'),(16,17,139,'done',NULL,'2024-11-17 09:34:19','2024-11-17 09:42:30'),(17,17,147,'done',NULL,'2024-11-17 09:34:56','2024-11-17 09:42:30'),(18,17,149,'done',NULL,'2024-11-17 09:36:01','2024-11-17 09:42:30'),(19,17,154,'done',NULL,'2024-11-17 09:36:29','2024-11-17 09:42:30'),(20,17,138,'done',NULL,'2024-11-17 09:36:57','2024-11-17 09:42:30'),(21,17,144,'done',NULL,'2024-11-17 09:37:19','2024-11-17 09:42:30'),(22,17,146,'done',NULL,'2024-11-17 09:37:49','2024-11-17 09:42:30'),(23,17,134,'done',NULL,'2024-11-17 09:38:34','2024-11-17 09:42:30'),(24,17,152,'done',NULL,'2024-11-17 09:39:13','2024-11-17 09:42:30'),(25,17,151,'done',NULL,'2024-11-17 09:39:43','2024-11-17 09:42:30'),(26,17,137,'done',NULL,'2024-11-17 09:40:18','2024-11-17 09:42:30'),(27,17,142,'done',12640,'2024-11-17 09:41:11','2024-11-17 09:42:30'),(28,14,147,'done',NULL,'2024-11-17 09:42:39','2024-11-17 09:43:02'),(29,14,133,'done',NULL,'2024-11-17 09:42:52','2024-11-17 09:43:02'),(30,14,147,'done',NULL,'2024-11-17 09:42:52','2024-11-17 09:43:02'),(31,15,143,'done',NULL,'2024-11-17 09:45:45','2024-11-17 09:45:58'),(32,15,133,'done',NULL,'2024-11-17 09:45:45','2024-11-17 09:45:58'),(33,16,141,'done',NULL,'2024-11-17 10:09:13','2024-11-17 10:09:24'),(34,16,143,'done',NULL,'2024-11-17 10:09:13','2024-11-17 10:09:24'),(35,20,149,'done',12642,'2024-11-17 10:17:15','2024-11-17 10:17:44'),(36,23,154,'done',12644,'2024-11-17 11:38:36','2024-11-17 11:42:02'),(37,26,138,'still',NULL,'2024-11-17 12:47:31','2024-11-17 12:47:31'),(38,29,144,'done',12647,'2024-11-17 14:52:57','2024-11-17 14:56:00'),(40,35,151,'done',12652,'2024-11-17 19:00:10','2024-11-17 19:28:23'),(41,38,151,'done',12654,'2024-11-17 19:32:41','2024-11-17 19:34:48'),(42,41,144,'done',NULL,'2024-11-17 19:53:01','2024-11-17 19:53:01'),(43,44,144,'done',12657,'2024-11-17 19:57:17','2024-11-17 19:58:44'),(44,47,134,'done',NULL,'2024-11-17 20:21:21','2024-11-17 20:22:22'),(45,47,146,'done',12661,'2024-11-17 20:21:21','2024-11-17 20:26:15'),(46,47,146,'done',NULL,'2024-11-17 20:22:22','2024-11-17 20:22:22'),(47,50,134,'done',12663,'2024-11-17 20:35:31','2024-11-17 20:35:48'),(48,53,152,'done',12665,'2024-11-17 20:41:55','2024-11-17 20:46:20'),(49,56,149,'done',12667,'2024-11-18 07:52:42','2024-11-18 07:56:51'),(50,59,149,'done',12669,'2024-11-18 07:59:06','2024-11-18 08:00:07'),(51,62,139,'done',12671,'2024-11-18 08:07:10','2024-11-18 08:07:35'),(52,65,154,'done',12673,'2024-11-18 08:11:47','2024-11-18 08:12:29'),(53,68,144,'done',12676,'2024-11-18 08:50:03','2024-11-18 08:54:02'),(54,71,146,'done',12679,'2024-11-18 09:22:32','2024-11-18 09:25:59'),(55,74,134,'done',12681,'2024-11-18 09:28:50','2024-11-18 09:33:32'),(56,77,152,'done',12683,'2024-11-18 09:41:13','2024-11-18 09:42:04'),(57,80,151,'done',12686,'2024-11-18 09:43:55','2024-11-18 10:00:06'),(58,83,142,'done',12688,'2024-11-18 10:05:40','2024-11-18 10:06:12'),(59,86,137,'done',12690,'2024-11-18 10:10:18','2024-11-18 10:10:44'),(60,89,137,'done',12693,'2024-11-18 11:14:57','2024-11-18 11:15:20'),(61,92,142,'done',12695,'2024-11-18 11:24:09','2024-11-18 11:24:44'),(62,92,142,'done',NULL,'2024-11-18 11:24:29','2024-11-18 11:24:29'),(63,95,142,'done',12697,'2024-11-18 11:25:27','2024-11-18 11:25:46'),(64,98,151,'done',12699,'2024-11-18 11:38:12','2024-11-18 11:38:51'),(65,101,151,'done',12701,'2024-11-18 11:42:42','2024-11-18 11:43:08'),(66,104,152,'done',12703,'2024-11-18 12:22:58','2024-11-18 12:27:26'),(67,107,134,'done',12705,'2024-11-18 12:33:33','2024-11-18 12:34:26'),(68,110,134,'done',12707,'2024-11-18 12:38:47','2024-11-18 12:39:22'),(69,113,146,'done',12709,'2024-11-18 13:10:49','2024-11-18 13:11:05'),(70,116,144,'done',12711,'2024-11-18 13:16:58','2024-11-18 13:17:53'),(71,119,154,'done',12713,'2024-11-18 13:25:58','2024-11-18 13:26:37'),(72,122,139,'done',12716,'2024-11-18 14:03:32','2024-11-18 14:04:03'),(73,125,133,'still',NULL,'2024-11-18 14:25:09','2024-11-18 14:25:09'),(74,125,134,'done',12718,'2024-11-18 14:25:09','2024-11-18 14:25:44'),(75,125,137,'done',12719,'2024-11-18 14:25:09','2024-11-18 14:26:16'),(76,125,139,'done',NULL,'2024-11-18 14:25:09','2024-11-18 14:25:09'),(77,128,134,'done',12721,'2024-11-18 14:36:38','2024-11-18 14:37:09'),(78,131,139,'done',NULL,'2024-11-18 14:38:08','2024-11-18 14:38:08'),(79,134,137,'done',12724,'2024-11-18 14:39:37','2024-11-18 14:39:51'),(80,134,139,'done',12725,'2024-11-18 14:39:37','2024-11-18 14:40:02'),(81,137,137,'done',12727,'2024-11-18 14:50:13','2024-11-18 14:50:45'),(82,137,139,'done',12728,'2024-11-18 14:50:13','2024-11-18 14:51:23'),(83,140,138,'done',12737,'2024-11-18 16:01:26','2024-11-18 17:50:18'),(84,143,138,'done',12739,'2024-11-18 20:05:02','2024-11-18 20:05:25'),(85,143,139,'done',12740,'2024-11-18 20:05:02','2024-11-18 20:06:07'),(86,143,133,'done',NULL,'2024-11-18 20:49:04','2024-11-18 20:49:04'),(87,143,146,'done',12742,'2024-11-18 20:49:04','2024-11-18 21:06:43'),(88,146,133,'done',NULL,'2024-11-19 08:08:03','2024-11-19 08:08:03'),(89,146,139,'done',12745,'2024-11-19 08:08:03','2024-11-19 08:12:06'),(90,146,141,'done',NULL,'2024-11-19 08:08:03','2024-11-19 08:08:03'),(91,146,142,'done',12744,'2024-11-19 08:08:03','2024-11-19 08:08:45'),(92,149,133,'done',NULL,'2024-11-19 08:30:54','2024-11-19 08:31:29'),(93,149,135,'done',NULL,'2024-11-19 08:30:54','2024-11-19 08:31:29'),(94,149,137,'done',12750,'2024-11-19 08:30:54','2024-11-19 09:40:02'),(95,149,139,'done',12751,'2024-11-19 08:31:29','2024-11-19 09:40:20'),(96,152,133,'done',NULL,'2024-11-19 08:47:46','2024-11-19 08:47:46'),(97,152,135,'done',NULL,'2024-11-19 08:47:46','2024-11-19 08:47:46'),(100,155,138,'done',12749,'2024-11-19 09:27:33','2024-11-19 09:36:50'),(101,153,149,'still',NULL,'2024-11-19 10:07:38','2024-11-19 10:07:38'),(102,153,149,'still',NULL,'2024-11-19 10:08:37','2024-11-19 10:08:37'),(103,153,151,'still',NULL,'2024-11-19 10:09:02','2024-11-19 10:09:02'),(104,153,133,'done',NULL,'2024-11-19 10:09:24','2024-11-19 10:09:24'),(105,153,149,'still',NULL,'2024-11-19 10:09:24','2024-11-19 10:09:24'),(106,158,133,'done',NULL,'2024-11-19 10:11:24','2024-11-19 10:11:24'),(107,158,135,'done',NULL,'2024-11-19 10:11:24','2024-11-19 10:11:24'),(108,160,134,'done',NULL,'2024-11-27 10:41:30','2024-11-27 10:41:30'),(109,163,133,'done',NULL,'2024-11-27 14:31:03','2024-11-27 14:31:03');

--
-- Table structure for table `violation_student_titles`
--

CREATE TABLE `violation_student_titles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `violation_student_id` bigint unsigned NOT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `violation_title_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` enum('still','started','done') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'still',
  PRIMARY KEY (`id`),
  KEY `fk_delete violation student` (`violation_student_id`),
  CONSTRAINT `fk_delete violation student` FOREIGN KEY (`violation_student_id`) REFERENCES `violation_students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=165 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_student_titles`
--

INSERT INTO `violation_student_titles` (`id`, `violation_student_id`, `date`, `violation_title_id`, `created_at`, `updated_at`, `status`) VALUES (1,1,'17/11/2024',10,'2024-11-16 19:32:01','2024-11-17 08:27:24','done'),(2,1,'17/11/2024',19,'2024-11-16 19:32:01','2024-11-17 08:27:41','done'),(3,1,'17/11/2024',20,'2024-11-16 19:32:01','2024-11-17 08:27:24','still'),(8,3,'17/11/2024',15,'2024-11-17 07:48:12','2024-11-17 07:48:52','done'),(9,3,'17/11/2024',16,'2024-11-17 07:48:12','2024-11-17 07:48:12','still'),(10,4,'17/11/2024',27,'2024-11-17 08:26:30','2024-11-17 08:26:40','done'),(11,4,'17/11/2024',28,'2024-11-17 08:26:30','2024-11-17 08:26:30','still'),(14,6,'17/11/2024',30,'2024-11-17 09:19:30','2024-11-17 09:43:02','done'),(15,6,'17/11/2024',31,'2024-11-17 09:19:30','2024-11-17 09:45:58','done'),(16,6,'17/11/2024',32,'2024-11-17 09:19:30','2024-11-17 10:09:24','done'),(17,7,'17/11/2024',10,'2024-11-17 09:34:19','2024-11-17 09:42:30','done'),(18,7,'17/11/2024',19,'2024-11-17 09:34:19','2024-11-17 09:34:19','still'),(19,7,'17/11/2024',20,'2024-11-17 09:34:19','2024-11-17 09:34:19','still'),(20,8,'17/11/2024',10,'2024-11-17 10:17:15','2024-11-17 10:17:44','started'),(21,8,'17/11/2024',19,'2024-11-17 10:17:15','2024-11-17 10:17:15','still'),(22,8,'17/11/2024',20,'2024-11-17 10:17:15','2024-11-17 10:17:15','still'),(23,9,'17/11/2024',10,'2024-11-17 11:38:36','2024-11-17 11:42:02','started'),(24,9,'17/11/2024',19,'2024-11-17 11:38:36','2024-11-17 11:38:36','still'),(25,9,'17/11/2024',20,'2024-11-17 11:38:36','2024-11-17 11:38:36','still'),(26,10,'17/11/2024',10,'2024-11-17 12:47:31','2024-11-17 12:47:31','still'),(27,10,'17/11/2024',19,'2024-11-17 12:47:31','2024-11-17 12:47:31','still'),(28,10,'17/11/2024',20,'2024-11-17 12:47:31','2024-11-17 12:47:31','still'),(29,11,'17/11/2024',10,'2024-11-17 14:52:57','2024-11-17 14:56:00','started'),(30,11,'17/11/2024',19,'2024-11-17 14:52:57','2024-11-17 14:52:57','still'),(31,11,'17/11/2024',20,'2024-11-17 14:52:57','2024-11-17 14:52:57','still'),(35,13,'17/11/2024',10,'2024-11-17 19:00:10','2024-11-17 19:00:58','started'),(36,13,'17/11/2024',19,'2024-11-17 19:00:10','2024-11-17 19:00:10','still'),(37,13,'17/11/2024',20,'2024-11-17 19:00:10','2024-11-17 19:00:10','still'),(38,14,'17/11/2024',10,'2024-11-17 19:32:41','2024-11-17 19:34:48','started'),(39,14,'17/11/2024',19,'2024-11-17 19:32:41','2024-11-17 19:32:41','still'),(40,14,'17/11/2024',20,'2024-11-17 19:32:41','2024-11-17 19:32:41','still'),(41,15,'17/11/2024',10,'2024-11-17 19:53:01','2024-11-17 19:53:01','still'),(42,15,'17/11/2024',19,'2024-11-17 19:53:01','2024-11-17 19:53:01','still'),(43,15,'17/11/2024',20,'2024-11-17 19:53:01','2024-11-17 19:53:01','still'),(44,16,'17/11/2024',10,'2024-11-17 19:57:17','2024-11-17 19:58:44','started'),(45,16,'17/11/2024',19,'2024-11-17 19:57:17','2024-11-17 19:57:17','still'),(46,16,'17/11/2024',20,'2024-11-17 19:57:17','2024-11-17 19:57:17','still'),(47,17,'17/11/2024',10,'2024-11-17 20:21:21','2024-11-17 20:24:50','started'),(48,17,'17/11/2024',19,'2024-11-17 20:21:21','2024-11-17 20:21:21','still'),(49,17,'17/11/2024',20,'2024-11-17 20:21:21','2024-11-17 20:21:21','still'),(50,18,'17/11/2024',10,'2024-11-17 20:35:31','2024-11-17 20:35:48','started'),(51,18,'17/11/2024',19,'2024-11-17 20:35:31','2024-11-17 20:35:31','still'),(52,18,'17/11/2024',20,'2024-11-17 20:35:31','2024-11-17 20:35:31','still'),(53,19,'17/11/2024',10,'2024-11-17 20:41:55','2024-11-17 20:42:26','started'),(54,19,'17/11/2024',19,'2024-11-17 20:41:55','2024-11-17 20:41:55','still'),(55,19,'17/11/2024',20,'2024-11-17 20:41:55','2024-11-17 20:41:55','still'),(56,20,'18/11/2024',10,'2024-11-18 07:52:42','2024-11-18 07:56:50','started'),(57,20,'18/11/2024',19,'2024-11-18 07:52:42','2024-11-18 07:52:42','still'),(58,20,'18/11/2024',20,'2024-11-18 07:52:42','2024-11-18 07:52:42','still'),(59,21,'18/11/2024',10,'2024-11-18 07:59:06','2024-11-18 08:00:06','started'),(60,21,'18/11/2024',19,'2024-11-18 07:59:06','2024-11-18 07:59:06','still'),(61,21,'18/11/2024',20,'2024-11-18 07:59:06','2024-11-18 07:59:06','still'),(62,22,'18/11/2024',10,'2024-11-18 08:07:10','2024-11-18 08:07:35','started'),(63,22,'18/11/2024',19,'2024-11-18 08:07:10','2024-11-18 08:07:10','still'),(64,22,'18/11/2024',20,'2024-11-18 08:07:10','2024-11-18 08:07:10','still'),(65,23,'18/11/2024',10,'2024-11-18 08:11:47','2024-11-18 08:12:29','started'),(66,23,'18/11/2024',19,'2024-11-18 08:11:47','2024-11-18 08:11:47','still'),(67,23,'18/11/2024',20,'2024-11-18 08:11:47','2024-11-18 08:11:47','still'),(68,24,'18/11/2024',10,'2024-11-18 08:50:03','2024-11-18 08:54:02','started'),(69,24,'18/11/2024',19,'2024-11-18 08:50:03','2024-11-18 08:50:03','still'),(70,24,'18/11/2024',20,'2024-11-18 08:50:03','2024-11-18 08:50:03','still'),(71,25,'18/11/2024',10,'2024-11-18 09:22:32','2024-11-18 09:25:59','started'),(72,25,'18/11/2024',19,'2024-11-18 09:22:32','2024-11-18 09:22:32','still'),(73,25,'18/11/2024',20,'2024-11-18 09:22:32','2024-11-18 09:22:32','still'),(74,26,'18/11/2024',10,'2024-11-18 09:28:50','2024-11-18 09:33:32','started'),(75,26,'18/11/2024',19,'2024-11-18 09:28:50','2024-11-18 09:28:50','still'),(76,26,'18/11/2024',20,'2024-11-18 09:28:50','2024-11-18 09:28:50','still'),(77,27,'18/11/2024',10,'2024-11-18 09:41:13','2024-11-18 09:42:03','started'),(78,27,'18/11/2024',19,'2024-11-18 09:41:13','2024-11-18 09:41:13','still'),(79,27,'18/11/2024',20,'2024-11-18 09:41:13','2024-11-18 09:41:13','still'),(80,28,'18/11/2024',10,'2024-11-18 09:43:55','2024-11-18 10:00:06','started'),(81,28,'18/11/2024',19,'2024-11-18 09:43:55','2024-11-18 09:43:55','still'),(82,28,'18/11/2024',20,'2024-11-18 09:43:55','2024-11-18 09:43:55','still'),(83,29,'18/11/2024',10,'2024-11-18 10:05:40','2024-11-18 10:06:12','started'),(84,29,'18/11/2024',19,'2024-11-18 10:05:40','2024-11-18 10:05:40','still'),(85,29,'18/11/2024',20,'2024-11-18 10:05:40','2024-11-18 10:05:40','still'),(86,30,'18/11/2024',10,'2024-11-18 10:10:18','2024-11-18 10:10:44','started'),(87,30,'18/11/2024',19,'2024-11-18 10:10:18','2024-11-18 10:10:18','still'),(88,30,'18/11/2024',20,'2024-11-18 10:10:18','2024-11-18 10:10:18','still'),(89,31,'18/11/2024',10,'2024-11-18 11:14:57','2024-11-18 11:15:20','started'),(90,31,'18/11/2024',19,'2024-11-18 11:14:57','2024-11-18 11:14:57','still'),(91,31,'18/11/2024',20,'2024-11-18 11:14:57','2024-11-18 11:14:57','still'),(92,32,'18/11/2024',10,'2024-11-18 11:24:09','2024-11-18 11:24:44','started'),(93,32,'18/11/2024',19,'2024-11-18 11:24:09','2024-11-18 11:24:09','still'),(94,32,'18/11/2024',20,'2024-11-18 11:24:09','2024-11-18 11:24:09','still'),(95,33,'18/11/2024',10,'2024-11-18 11:25:27','2024-11-18 11:25:45','started'),(96,33,'18/11/2024',19,'2024-11-18 11:25:27','2024-11-18 11:25:27','still'),(97,33,'18/11/2024',20,'2024-11-18 11:25:27','2024-11-18 11:25:27','still'),(98,34,'18/11/2024',10,'2024-11-18 11:38:12','2024-11-18 11:38:51','started'),(99,34,'18/11/2024',19,'2024-11-18 11:38:12','2024-11-18 11:38:12','still'),(100,34,'18/11/2024',20,'2024-11-18 11:38:12','2024-11-18 11:38:12','still'),(101,35,'18/11/2024',10,'2024-11-18 11:42:42','2024-11-18 11:43:08','started'),(102,35,'18/11/2024',19,'2024-11-18 11:42:42','2024-11-18 11:42:42','still'),(103,35,'18/11/2024',20,'2024-11-18 11:42:42','2024-11-18 11:42:42','still'),(104,36,'18/11/2024',10,'2024-11-18 12:22:58','2024-11-18 12:27:26','started'),(105,36,'18/11/2024',19,'2024-11-18 12:22:58','2024-11-18 12:22:58','still'),(106,36,'18/11/2024',20,'2024-11-18 12:22:58','2024-11-18 12:22:58','still'),(107,37,'18/11/2024',10,'2024-11-18 12:33:33','2024-11-18 12:34:26','started'),(108,37,'18/11/2024',19,'2024-11-18 12:33:33','2024-11-18 12:33:33','still'),(109,37,'18/11/2024',20,'2024-11-18 12:33:33','2024-11-18 12:33:33','still'),(110,38,'18/11/2024',10,'2024-11-18 12:38:47','2024-11-18 12:39:22','started'),(111,38,'18/11/2024',19,'2024-11-18 12:38:47','2024-11-18 12:38:47','still'),(112,38,'18/11/2024',20,'2024-11-18 12:38:47','2024-11-18 12:38:47','still'),(113,39,'18/11/2024',10,'2024-11-18 13:10:49','2024-11-18 13:11:04','started'),(114,39,'18/11/2024',19,'2024-11-18 13:10:49','2024-11-18 13:10:49','still'),(115,39,'18/11/2024',20,'2024-11-18 13:10:49','2024-11-18 13:10:49','still'),(116,40,'18/11/2024',10,'2024-11-18 13:16:58','2024-11-18 13:17:53','started'),(117,40,'18/11/2024',19,'2024-11-18 13:16:58','2024-11-18 13:16:58','still'),(118,40,'18/11/2024',20,'2024-11-18 13:16:58','2024-11-18 13:16:58','still'),(119,41,'18/11/2024',10,'2024-11-18 13:25:58','2024-11-18 13:26:37','started'),(120,41,'18/11/2024',19,'2024-11-18 13:25:58','2024-11-18 13:25:58','still'),(121,41,'18/11/2024',20,'2024-11-18 13:25:58','2024-11-18 13:25:58','still'),(122,42,'18/11/2024',10,'2024-11-18 14:03:32','2024-11-18 14:04:03','started'),(123,42,'18/11/2024',19,'2024-11-18 14:03:32','2024-11-18 14:03:32','still'),(124,42,'18/11/2024',20,'2024-11-18 14:03:32','2024-11-18 14:03:32','still'),(125,43,'18/11/2024',10,'2024-11-18 14:25:09','2024-11-18 14:25:44','started'),(126,43,'18/11/2024',19,'2024-11-18 14:25:09','2024-11-18 14:25:09','still'),(127,43,'18/11/2024',20,'2024-11-18 14:25:09','2024-11-18 14:25:09','still'),(128,44,'18/11/2024',10,'2024-11-18 14:36:38','2024-11-18 14:37:09','started'),(129,44,'18/11/2024',19,'2024-11-18 14:36:38','2024-11-18 14:36:38','still'),(130,44,'18/11/2024',20,'2024-11-18 14:36:38','2024-11-18 14:36:38','still'),(131,45,'18/11/2024',10,'2024-11-18 14:38:08','2024-11-18 14:38:08','still'),(132,45,'18/11/2024',19,'2024-11-18 14:38:08','2024-11-18 14:38:08','still'),(133,45,'18/11/2024',20,'2024-11-18 14:38:08','2024-11-18 14:38:08','still'),(134,46,'18/11/2024',10,'2024-11-18 14:39:37','2024-11-18 14:39:51','started'),(135,46,'18/11/2024',19,'2024-11-18 14:39:37','2024-11-18 14:39:37','still'),(136,46,'18/11/2024',20,'2024-11-18 14:39:37','2024-11-18 14:39:37','still'),(137,47,'18/11/2024',10,'2024-11-18 14:50:13','2024-11-18 14:50:45','started'),(138,47,'18/11/2024',19,'2024-11-18 14:50:13','2024-11-18 14:50:13','still'),(139,47,'18/11/2024',20,'2024-11-18 14:50:13','2024-11-18 14:50:13','still'),(140,48,'18/11/2024',10,'2024-11-18 16:01:26','2024-11-18 17:50:18','started'),(141,48,'18/11/2024',19,'2024-11-18 16:01:26','2024-11-18 16:01:26','still'),(142,48,'18/11/2024',20,'2024-11-18 16:01:26','2024-11-18 16:01:26','still'),(143,49,'18/11/2024',10,'2024-11-18 20:05:02','2024-11-18 20:05:25','started'),(144,49,'18/11/2024',19,'2024-11-18 20:05:02','2024-11-18 20:05:02','still'),(145,49,'18/11/2024',20,'2024-11-18 20:05:02','2024-11-18 20:05:02','still'),(146,50,'19/11/2024',10,'2024-11-19 08:08:03','2024-11-19 08:08:45','started'),(147,50,'19/11/2024',19,'2024-11-19 08:08:03','2024-11-19 08:08:03','still'),(148,50,'19/11/2024',20,'2024-11-19 08:08:03','2024-11-19 08:08:03','still'),(149,51,'19/11/2024',10,'2024-11-19 08:30:54','2024-11-19 09:40:02','started'),(150,51,'19/11/2024',19,'2024-11-19 08:30:54','2024-11-19 08:30:54','still'),(151,51,'19/11/2024',20,'2024-11-19 08:30:54','2024-11-19 08:30:54','still'),(152,52,'19/11/2024',10,'2024-11-19 08:47:45','2024-11-19 08:47:45','done'),(153,52,'19/11/2024',19,'2024-11-19 08:47:45','2024-11-19 08:47:45','still'),(154,52,'19/11/2024',20,'2024-11-19 08:47:46','2024-11-19 08:47:46','still'),(155,53,'19/11/2024',10,'2024-11-19 09:27:33','2024-11-19 09:36:50','started'),(156,53,'19/11/2024',19,'2024-11-19 09:27:33','2024-11-19 09:27:33','still'),(157,53,'19/11/2024',20,'2024-11-19 09:27:33','2024-11-19 09:27:33','still'),(158,54,'19/11/2024',15,'2024-11-19 10:11:24','2024-11-19 10:11:24','still'),(159,54,'19/11/2024',16,'2024-11-19 10:11:24','2024-11-19 10:11:24','still'),(160,55,'27/11/2024',10,'2024-11-27 10:41:30','2024-11-27 10:41:30','done'),(161,55,'27/11/2024',19,'2024-11-27 10:41:30','2024-11-27 10:41:30','still'),(162,55,'27/11/2024',20,'2024-11-27 10:41:30','2024-11-27 10:41:30','still'),(163,56,'27/11/2024',15,'2024-11-27 14:31:03','2024-11-27 14:31:03','done'),(164,56,'27/11/2024',16,'2024-11-27 14:31:03','2024-11-27 14:31:03','still');

--
-- Table structure for table `violation_students`
--

CREATE TABLE `violation_students` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `namazeg_version_id` bigint unsigned NOT NULL,
  `student_id` int unsigned NOT NULL,
  `school_id` int unsigned NOT NULL,
  `violation_grade_id` int unsigned NOT NULL,
  `date` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `violation_type_id` int unsigned DEFAULT NULL,
  `violation_category_id` int unsigned NOT NULL,
  `other_type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `violation_title_ids` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_students`
--

INSERT INTO `violation_students` (`id`, `namazeg_version_id`, `student_id`, `school_id`, `violation_grade_id`, `date`, `violation_type_id`, `violation_category_id`, `other_type`, `violation_title_ids`, `created_at`, `updated_at`) VALUES (1,12580,61534,81,18,'16/11/2024',12,2,NULL,NULL,'2024-11-16 19:30:47','2024-11-16 19:31:25'),(3,12582,61534,81,20,'17/11/2024',18,9,NULL,NULL,'2024-11-17 07:44:21','2024-11-17 07:45:02'),(4,12583,61534,81,24,'17/11/2024',24,2,NULL,NULL,'2024-11-17 08:26:13','2024-11-17 08:26:21'),(6,12585,61535,81,22,'17/11/2024',21,8,NULL,NULL,'2024-11-17 09:18:59','2024-11-17 09:19:16'),(7,12639,61536,81,18,'17/11/2024',12,2,NULL,NULL,'2024-11-17 09:34:00','2024-11-17 09:34:10'),(8,12641,61537,81,18,'17/11/2024',12,2,NULL,NULL,'2024-11-17 10:16:46','2024-11-17 10:16:57'),(9,12643,61538,81,18,'17/11/2024',13,2,NULL,NULL,'2024-11-17 11:37:11','2024-11-17 11:38:18'),(10,12645,61538,81,18,'17/11/2024',12,2,NULL,NULL,'2024-11-17 12:47:08','2024-11-17 12:47:22'),(11,12646,61540,81,18,'17/11/2024',13,2,NULL,NULL,'2024-11-17 14:52:39','2024-11-17 14:52:48'),(13,12651,61541,81,18,'17/11/2024',13,2,NULL,NULL,'2024-11-17 18:59:37','2024-11-17 18:59:43'),(14,12653,61542,81,18,'17/11/2024',14,2,NULL,NULL,'2024-11-17 19:31:43','2024-11-17 19:31:58'),(15,12655,61543,81,18,'17/11/2024',13,2,NULL,NULL,'2024-11-17 19:52:45','2024-11-17 19:52:50'),(16,12656,61545,81,18,'17/11/2024',12,2,NULL,NULL,'2024-11-17 19:57:02','2024-11-17 19:57:08'),(17,12658,61548,81,18,'17/11/2024',13,2,NULL,NULL,'2024-11-17 20:19:27','2024-11-17 20:19:36'),(18,12662,61540,81,18,'17/11/2024',12,2,NULL,NULL,'2024-11-17 20:35:20','2024-11-17 20:35:25'),(19,12664,61555,81,18,'17/11/2024',12,2,NULL,NULL,'2024-11-17 20:41:37','2024-11-17 20:41:41'),(20,12666,61544,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 07:52:06','2024-11-18 07:52:25'),(21,12668,61545,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 07:58:34','2024-11-18 07:58:39'),(22,12670,61546,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 08:06:58','2024-11-18 08:07:03'),(23,12672,61547,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 08:08:33','2024-11-18 08:08:38'),(24,12675,61548,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 08:49:43','2024-11-18 08:49:48'),(25,12678,61549,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 09:22:12','2024-11-18 09:22:19'),(26,12680,61550,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 09:28:35','2024-11-18 09:28:41'),(27,12682,61551,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 09:36:04','2024-11-18 09:36:11'),(28,12684,61552,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 09:43:31','2024-11-18 09:43:36'),(29,12687,61554,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 10:05:18','2024-11-18 10:05:28'),(30,12689,61554,81,18,'18/11/2024',NULL,2,'test other type',NULL,'2024-11-18 10:09:55','2024-11-18 10:10:07'),(31,12692,61552,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 11:14:44','2024-11-18 11:14:52'),(32,12694,61558,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 11:23:58','2024-11-18 11:24:03'),(33,12696,61656,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 11:25:15','2024-11-18 11:25:20'),(34,12698,61657,81,18,'18/11/2024',NULL,2,'test',NULL,'2024-11-18 11:37:48','2024-11-18 11:37:59'),(35,12700,61557,81,18,'18/11/2024',13,2,NULL,NULL,'2024-11-18 11:42:29','2024-11-18 11:42:34'),(36,12702,61654,81,18,'18/11/2024',NULL,2,'test',NULL,'2024-11-18 12:21:40','2024-11-18 12:21:48'),(37,12704,61656,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 12:33:17','2024-11-18 12:33:26'),(38,12706,61657,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 12:38:10','2024-11-18 12:38:34'),(39,12708,61659,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 13:10:25','2024-11-18 13:10:32'),(40,12710,61660,81,18,'18/11/2024',13,2,NULL,NULL,'2024-11-18 13:16:28','2024-11-18 13:16:44'),(41,12712,61661,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 13:25:25','2024-11-18 13:25:31'),(42,12715,61662,81,18,'28/11/2024',14,2,NULL,NULL,'2024-11-18 14:03:06','2024-11-18 14:03:17'),(43,12717,61666,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 14:24:37','2024-11-18 14:24:44'),(44,12720,61667,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 14:36:13','2024-11-18 14:36:26'),(45,12722,61534,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 14:37:57','2024-11-18 14:38:01'),(46,12723,61545,81,18,'18/11/2024',NULL,2,'test',NULL,'2024-11-18 14:39:18','2024-11-18 14:39:27'),(47,12726,61657,81,18,'18/11/2024',12,2,NULL,NULL,'2024-11-18 14:49:54','2024-11-18 14:50:03'),(48,12733,61555,81,18,'18/11/2024',14,2,NULL,NULL,'2024-11-18 15:59:30','2024-11-18 16:00:51'),(49,12738,61686,81,18,'18/11/2024',13,2,NULL,NULL,'2024-11-18 20:04:43','2024-11-18 20:04:49'),(50,12743,61684,81,18,'19/11/2024',12,2,NULL,NULL,'2024-11-19 08:06:59','2024-11-19 08:07:16'),(51,12746,61683,81,18,'19/11/2024',14,2,NULL,NULL,'2024-11-19 08:30:34','2024-11-19 08:30:42'),(52,12747,61682,81,18,'19/11/2024',12,2,NULL,NULL,'2024-11-19 08:47:13','2024-11-19 08:47:29'),(53,12748,61674,81,18,'19/11/2024',NULL,2,'test',NULL,'2024-11-19 09:27:11','2024-11-19 09:27:21'),(54,12752,61539,81,20,'19/11/2024',18,9,NULL,NULL,'2024-11-19 10:10:49','2024-11-19 10:11:16'),(55,13246,61441,81,18,'27/11/2024',12,2,NULL,NULL,'2024-11-27 10:41:05','2024-11-27 10:41:13'),(56,13247,106908,98,20,'27/11/2024',18,9,NULL,NULL,'2024-11-27 14:29:55','2024-11-27 14:30:10'),(57,13661,61441,81,20,'28/11/2024',NULL,9,NULL,NULL,'2024-11-28 17:21:27','2024-11-28 17:21:27'),(58,13662,61441,81,18,'28/11/2024',NULL,2,NULL,NULL,'2024-11-28 17:30:49','2024-11-28 17:30:49');

--
-- Table structure for table `violation_titles`
--

CREATE TABLE `violation_titles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `violation_grade_id` bigint unsigned NOT NULL,
  `has_related` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `violation_titles_violation_grade_id_foreign` (`violation_grade_id`),
  CONSTRAINT `violation_titles_violation_grade_id_foreign` FOREIGN KEY (`violation_grade_id`) REFERENCES `violation_grades` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_titles`
--

INSERT INTO `violation_titles` (`id`, `name`, `violation_grade_id`, `has_related`, `created_at`, `updated_at`, `deleted_at`) VALUES (3,'1',1,0,'2024-10-16 09:17:18','2024-10-16 09:17:18',NULL),(4,'2',1,1,'2024-10-16 09:58:04','2024-10-16 10:01:21',NULL),(5,'1',14,0,'2024-10-17 07:13:26','2024-10-17 07:13:26',NULL),(7,'3',14,1,'2024-10-17 08:13:21','2024-10-17 08:13:41',NULL),(10,'1',18,1,'2024-11-09 13:05:21','2024-11-09 13:05:29',NULL),(11,'6',19,1,'2024-11-11 08:39:18','2024-11-11 08:39:24',NULL),(15,'1',20,1,'2024-11-11 09:32:05','2024-11-11 09:32:14',NULL),(16,'2',20,1,'2024-11-11 09:32:46','2024-11-19 10:18:20',NULL),(17,'1',21,1,'2024-11-11 09:36:55','2024-11-11 09:36:58',NULL),(19,'2',18,1,'2024-11-11 12:22:14','2024-11-16 13:47:47',NULL),(20,'3',18,1,'2024-11-11 12:22:35','2024-11-14 10:14:27',NULL),(27,'1',24,1,'2024-11-13 15:49:36','2024-11-13 15:49:38',NULL),(28,'2',24,0,'2024-11-13 15:49:56','2024-11-13 15:49:56',NULL),(29,'4',1,0,'2024-11-14 11:21:58','2024-11-14 11:21:58',NULL),(30,'1',22,0,'2024-11-16 14:18:37','2024-11-16 14:18:37',NULL),(31,'2',22,1,'2024-11-16 14:18:52','2024-11-17 09:45:11',NULL),(32,'3',22,1,'2024-11-17 08:40:38','2024-11-17 08:40:58',NULL);

--
-- Table structure for table `violation_types`
--

CREATE TABLE `violation_types` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `violation_grade_id` bigint unsigned NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `violation_grade_id` (`violation_grade_id`),
  CONSTRAINT `violation_grade_id` FOREIGN KEY (`violation_grade_id`) REFERENCES `violation_grades` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violation_types`
--

INSERT INTO `violation_types` (`id`, `violation_grade_id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES (1,14,'مر بزيادة يتحول لمدرسة سعفان المر بزيادة',NULL,'2024-10-17 07:02:39','2024-10-17 07:02:39'),(2,14,'جميو جميو',NULL,'2024-10-17 07:02:39','2024-10-17 07:02:39'),(3,14,'إبداع والله، إبداع',NULL,'2024-10-17 07:02:39','2024-10-17 07:02:39'),(7,16,'نوع اول للدرجة الثانيه تيس',NULL,'2024-11-08 15:17:36','2024-11-08 15:17:36'),(8,16,'نوع ثانى للدرجة الثانيه تيس',NULL,'2024-11-08 15:17:36','2024-11-08 15:17:36'),(10,1,'تعدلي نوع العنف 1',NULL,'2024-11-09 08:42:57','2024-11-09 08:42:57'),(11,1,'تعدلي نوع العنف 2',NULL,'2024-11-09 08:42:57','2024-11-09 08:42:57'),(12,18,'عدم التقيد باللباس الرسمي الخاص بالمدرسة',NULL,'2024-11-09 10:39:54','2024-11-09 10:39:54'),(13,18,'التأخر أو العبث أثناء الاصطفاف الصباحي',NULL,'2024-11-09 10:39:54','2024-11-09 10:39:54'),(14,18,'تكرار خروج الطلاب و الطالبات و دخولهم من البوابة قبل الانصراف و الحضور ، و التجمهر أمام بوابة المدرسة',NULL,'2024-11-09 10:39:54','2024-11-09 10:39:54'),(15,19,'سلوك 1',NULL,'2024-11-11 08:38:42','2024-11-11 08:38:42'),(16,19,'سلوك 2',NULL,'2024-11-11 08:38:42','2024-11-11 08:38:42'),(17,19,'سلوك 3',NULL,'2024-11-11 08:38:42','2024-11-11 08:38:42'),(18,20,'سلوك 1',NULL,'2024-11-11 09:22:08','2024-11-11 09:22:08'),(19,21,'سلوك 1',NULL,'2024-11-11 09:36:26','2024-11-11 09:36:26'),(20,21,'سلوك 2',NULL,'2024-11-11 09:36:26','2024-11-11 09:36:26'),(21,22,'مخالفة 1',NULL,'2024-11-11 09:37:27','2024-11-11 09:37:27'),(22,22,'مخالفة 2',NULL,'2024-11-11 09:37:27','2024-11-11 09:37:27'),(23,23,'NewTest',NULL,'2024-11-13 13:01:43','2024-11-13 13:01:43'),(24,24,'مخالفة 1',NULL,'2024-11-13 15:47:42','2024-11-13 15:47:42'),(25,24,'مخالفة 2',NULL,'2024-11-13 15:47:42','2024-11-13 15:47:42'),(26,24,'مخالفة 3',NULL,'2024-11-13 15:47:42','2024-11-13 15:47:42');

--
-- Table structure for table `violations`
--

CREATE TABLE `violations` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `school_grade_id` bigint unsigned NOT NULL,
  `name` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `violations_school_grade_id_foreign` (`school_grade_id`),
  CONSTRAINT `violations_school_grade_id_foreign` FOREIGN KEY (`school_grade_id`) REFERENCES `school_grades` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `violations`
--

INSERT INTO `violations` (`id`, `school_grade_id`, `name`, `deleted_at`, `created_at`, `updated_at`) VALUES (1,1,'المخالفات السلوكية عن بعد',NULL,'2024-08-21 09:50:06','2024-08-21 09:50:06'),(2,2,'المخالفات السلوكية الحضورية',NULL,'2024-08-24 14:35:57','2024-08-24 14:35:57'),(6,1,'المخالفات السلوكية تجاه الهيئة التعليمية و الإدارية ',NULL,'2024-11-09 10:15:34','2024-11-09 10:15:34'),(7,1,'المخالفات السلوكية الحضورية',NULL,'2024-11-09 10:16:56','2024-11-09 10:16:56'),(8,2,'المخالفات السلوكية عن بعد',NULL,'2024-11-09 10:16:56','2024-11-09 10:16:56'),(9,2,'المخالفات السلوكية تجاه الهيئة التعليمية و الإدارية ',NULL,'2024-11-09 10:16:56','2024-11-09 10:16:56'),(10,3,'المخالفات السلوكية الحضورية',NULL,'2024-11-09 10:16:56','2024-11-09 10:16:56'),(11,3,'المخالفات السلوكية عن بعد',NULL,'2024-11-09 10:16:56','2024-11-09 10:16:56'),(12,3,'المخالفات السلوكية تجاه الهيئة التعليمية و الإدارية ',NULL,'2024-11-09 10:16:56','2024-11-09 10:16:56');

--
-- Table structure for table `visit_methods`
--

CREATE TABLE `visit_methods` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `visit_methods`
--

INSERT INTO `visit_methods` (`id`, `title`, `created_at`, `updated_at`, `deleted_at`) VALUES (1,'الزيارة الصفية والاجتماع بالمعلمة','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(2,'معرفة مدى مشاركتها في النشاطات الخارجية للمادة','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(3,'الإطلاع على الإعاداد الكاتبي للدرس','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(4,'مناقشة مديرة المدرسة','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(5,'الإطلاع على الواجبات والتطبيقات','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(6,'زيارة الموجهة الطلابية','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(7,'الإطلاع على التقويم والإختبارات','2024-08-28 13:05:54','2024-08-28 13:05:54',NULL),(8,'الزيارة الصفية والاجتماع بالمعلمة','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL),(9,'معرفة مدى مشاركتها في النشاطات الخارجية للمادة','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL),(10,'الإطلاع على الإعاداد الكاتبي للدرس','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL),(11,'مناقشة مديرة المدرسة','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL),(12,'الإطلاع على الواجبات والتطبيقات','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL),(13,'زيارة الموجهة الطلابية','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL),(14,'الإطلاع على التقويم والإختبارات','2024-10-25 18:55:33','2024-10-25 18:55:33',NULL);

--
-- Table structure for table `waiting_periods_schedule_data`
--

CREATE TABLE `waiting_periods_schedule_data` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `schedule_id` bigint unsigned NOT NULL,
  `school_employee_id` bigint unsigned NOT NULL,
  `school_class_id` bigint unsigned NOT NULL,
  `subject_id` bigint unsigned NOT NULL,
  `period_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `waiting_periods_schedule_data_schedule_id_foreign` (`schedule_id`),
  KEY `waiting_periods_schedule_data_school_employee_id_foreign` (`school_employee_id`),
  KEY `waiting_periods_schedule_data_school_class_id_foreign` (`school_class_id`),
  KEY `waiting_periods_schedule_data_period_id_foreign` (`period_id`),
  KEY `waiting_periods_schedule_data_subject_id_foreign` (`subject_id`),
  CONSTRAINT `waiting_periods_schedule_data_period_id_foreign` FOREIGN KEY (`period_id`) REFERENCES `periods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedule_data_schedule_id_foreign` FOREIGN KEY (`schedule_id`) REFERENCES `waiting_periods_schedules` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedule_data_school_class_id_foreign` FOREIGN KEY (`school_class_id`) REFERENCES `school_classes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedule_data_school_employee_id_foreign` FOREIGN KEY (`school_employee_id`) REFERENCES `school_employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedule_data_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `waiting_periods_schedule_data`
--

INSERT INTO `waiting_periods_schedule_data` (`id`, `schedule_id`, `school_employee_id`, `school_class_id`, `subject_id`, `period_id`, `created_at`, `updated_at`) VALUES (3,5,174,2462,5,2,NULL,NULL),(6,5,752,2462,5,3,NULL,NULL),(11,1,635,2019,1,1,'2024-10-17 08:47:32','2024-10-17 08:47:32'),(12,1,638,2019,3,2,'2024-10-17 08:47:32','2024-10-17 08:47:32'),(13,1,638,2026,5,3,'2024-10-17 08:47:32','2024-10-17 08:47:32'),(14,20,635,2019,1,1,'2024-10-17 08:57:31','2024-10-17 08:57:31'),(15,20,638,2019,3,2,'2024-10-17 08:57:31','2024-10-17 08:57:31'),(16,20,638,2026,5,3,'2024-10-17 08:57:31','2024-10-17 08:57:31');

--
-- Table structure for table `waiting_periods_schedules`
--

CREATE TABLE `waiting_periods_schedules` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `school_employee_id` bigint unsigned NOT NULL,
  `school_id` bigint unsigned NOT NULL,
  `semester_id` bigint unsigned NOT NULL,
  `day_id` bigint unsigned NOT NULL,
  `namazeg_version_id` bigint unsigned DEFAULT NULL,
  `absent_periods_count` int NOT NULL DEFAULT '0',
  `creation_date` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `waiting_periods_schedules_school_id_foreign` (`school_id`),
  KEY `waiting_periods_schedules_school_employee_id_foreign` (`school_employee_id`),
  KEY `waiting_periods_schedules_semester_id_foreign` (`semester_id`),
  KEY `waiting_periods_schedules_day_id_foreign` (`day_id`),
  KEY `waiting_periods_schedules_namazeg_version_id_foreign` (`namazeg_version_id`),
  CONSTRAINT `waiting_periods_schedules_day_id_foreign` FOREIGN KEY (`day_id`) REFERENCES `days` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedules_namazeg_version_id_foreign` FOREIGN KEY (`namazeg_version_id`) REFERENCES `namazeg_versions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedules_school_employee_id_foreign` FOREIGN KEY (`school_employee_id`) REFERENCES `school_employees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedules_school_id_foreign` FOREIGN KEY (`school_id`) REFERENCES `schools` (`id`) ON DELETE CASCADE,
  CONSTRAINT `waiting_periods_schedules_semester_id_foreign` FOREIGN KEY (`semester_id`) REFERENCES `semesters` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `waiting_periods_schedules`
--

INSERT INTO `waiting_periods_schedules` (`id`, `school_employee_id`, `school_id`, `semester_id`, `day_id`, `namazeg_version_id`, `absent_periods_count`, `creation_date`, `created_at`, `updated_at`, `user_id`) VALUES (1,638,39,1,1,NULL,0,'25/09/2024','2024-10-04 10:18:40','2024-10-12 19:44:13',29),(2,635,39,1,1,NULL,0,'25/09/2024','2024-10-04 10:30:55','2024-10-04 10:30:55',NULL),(3,635,39,1,1,NULL,0,'25/09/2024','2024-10-04 11:13:57','2024-10-04 11:13:57',NULL),(5,175,81,1,3,NULL,1,'08/10/2024',NULL,NULL,NULL),(6,635,39,1,1,NULL,0,'25/09/2024','2024-10-13 01:22:45','2024-10-13 01:22:45',29),(7,635,39,1,1,NULL,0,'25/09/2024','2024-10-16 16:07:08','2024-10-16 16:07:08',229),(8,635,39,1,1,NULL,0,'25/09/2024','2024-10-16 16:07:47','2024-10-16 16:07:47',29),(9,638,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:16:54','2024-10-16 20:16:54',29),(10,638,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:17:52','2024-10-16 20:17:52',29),(11,638,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:40:48','2024-10-16 20:40:48',29),(12,638,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:41:14','2024-10-16 20:41:14',29),(13,640,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:42:45','2024-10-16 20:42:45',29),(14,640,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:48:39','2024-10-16 20:48:39',29),(15,639,39,1,1,NULL,0,'25/09/2024','2024-10-16 20:50:25','2024-10-16 20:50:25',29),(16,639,39,1,1,NULL,0,'25/09/2024','2024-10-16 21:59:49','2024-10-16 21:59:49',29),(17,641,39,1,1,NULL,0,'25/09/2024','2024-10-16 22:43:00','2024-10-16 22:43:00',29),(18,641,39,1,1,NULL,0,'25/09/2024','2024-10-16 22:44:59','2024-10-16 22:44:59',29),(19,641,39,1,1,NULL,0,'25/09/2024','2024-10-16 22:46:37','2024-10-16 22:46:37',29),(20,641,39,1,1,NULL,0,'25/09/2024','2024-10-17 08:57:26','2024-10-17 08:57:26',29),(21,640,39,1,1,NULL,0,'25/09/2024','2024-10-17 08:58:14','2024-10-17 08:58:14',29),(22,638,39,1,1,NULL,0,'25/09/2024','2024-10-17 08:59:07','2024-10-17 08:59:10',29),(23,638,39,1,1,NULL,0,'25/09/2024','2024-10-17 08:59:40','2024-10-17 08:59:40',29),(24,640,39,1,1,NULL,0,'25/09/2024','2024-10-17 09:02:16','2024-10-17 09:02:16',29),(25,638,39,1,1,NULL,0,'25/09/2024','2024-10-17 09:06:34','2024-10-17 09:06:34',29),(26,640,39,1,1,NULL,0,'25/09/2024','2024-10-17 09:07:30','2024-10-17 09:07:30',29);

--
-- Table structure for table `weeks`
--

CREATE TABLE `weeks` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `weeks`
--

INSERT INTO `weeks` (`id`, `name`, `created_at`, `updated_at`) VALUES (1,'الأول','2024-08-21 08:50:12','2024-08-21 08:50:12'),(2,'الثاني','2024-08-21 08:50:12','2024-08-21 08:50:12'),(3,'الثالث','2024-08-21 08:50:12','2024-08-21 08:50:12'),(4,'الرابع','2024-08-21 08:50:12','2024-08-21 08:50:12'),(5,'الخامس','2024-08-21 08:50:12','2024-08-21 08:50:12'),(6,'السادس','2024-08-21 08:50:12','2024-08-21 08:50:12'),(7,'السابع','2024-08-21 08:50:12','2024-08-21 08:50:12'),(8,'الثامن','2024-08-21 08:50:12','2024-08-21 08:50:12'),(9,'التاسع','2024-08-21 08:50:12','2024-08-21 08:50:12'),(10,'العاشر','2024-08-21 08:50:12','2024-08-21 08:50:12'),(11,'الحادي عشر','2024-08-21 08:50:12','2024-08-21 08:50:12'),(12,'الثاني عشر','2024-08-21 08:50:12','2024-08-21 08:50:12'),(13,'الثالث عشر','2024-08-21 08:50:12','2024-08-21 08:50:12');

--
-- Dumping events for database 'digiflydev_laam_app'
--

--
-- Dumping routines for database 'digiflydev_laam_app'
--


