/*
SQLyog Ultimate v13.1.1 (64 bit)
MySQL - 10.4.19-MariaDB : Database - ttmis
*********************************************************************
*/



CREATE DATABASE /*!32312 IF NOT EXISTS*/`ttmis` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;

USE `ttmis`;

/*Table structure for table `assign_to_group_users` */


CREATE TABLE `assign_to_group_users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `assign_to_group_users_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assign_to_group_users` */

insert  into `assign_to_group_users`(`id`,`assign_to_group_users_id`,`user_id`,`deleted_at`,`created_at`,`updated_at`) values 
(80,51,29,'2021-12-09 09:09:55','2021-12-05 22:32:21','2021-12-09 09:09:55'),
(81,52,29,'2021-12-06 11:49:03','2021-12-05 22:32:33','2021-12-06 11:49:03'),
(82,53,37,'2021-12-09 09:10:00','2021-12-06 11:36:53','2021-12-09 09:10:00'),
(83,54,37,'2021-12-06 12:09:51','2021-12-06 11:37:00','2021-12-06 12:09:51'),
(84,49,29,'2021-12-09 09:09:37','2021-12-06 11:48:47','2021-12-09 09:09:37'),
(85,52,29,'2021-12-09 09:09:40','2021-12-06 11:49:03','2021-12-09 09:09:40'),
(86,54,37,'2021-12-06 12:12:34','2021-12-06 12:09:51','2021-12-06 12:12:34'),
(87,54,37,'2021-12-06 12:12:42','2021-12-06 12:12:34','2021-12-06 12:12:42'),
(88,54,36,'2021-12-06 12:12:42','2021-12-06 12:12:34','2021-12-06 12:12:42'),
(89,54,37,'2021-12-09 09:10:07','2021-12-06 12:12:42','2021-12-09 09:10:07'),
(90,54,36,'2021-12-09 09:10:07','2021-12-06 12:12:42','2021-12-09 09:10:07'),
(91,54,31,'2021-12-09 09:10:07','2021-12-06 12:12:42','2021-12-09 09:10:07'),
(92,54,29,'2021-12-09 09:10:07','2021-12-06 12:12:42','2021-12-09 09:10:07'),
(93,55,37,'2021-12-09 09:10:12','2021-12-07 10:00:33','2021-12-09 09:10:12'),
(94,55,36,'2021-12-09 09:10:12','2021-12-07 10:00:33','2021-12-09 09:10:12'),
(95,55,31,'2021-12-09 09:10:12','2021-12-07 10:00:33','2021-12-09 09:10:12'),
(96,55,29,'2021-12-09 09:10:12','2021-12-07 10:00:33','2021-12-09 09:10:12'),
(97,56,37,'2021-12-07 11:29:19','2021-12-07 10:34:02','2021-12-07 11:29:19'),
(98,56,36,'2021-12-07 11:29:19','2021-12-07 10:34:02','2021-12-07 11:29:19'),
(99,56,37,'2021-12-09 09:10:17','2021-12-07 11:29:19','2021-12-09 09:10:17'),
(100,56,36,'2021-12-09 09:10:17','2021-12-07 11:29:19','2021-12-09 09:10:17'),
(101,56,31,'2021-12-09 09:10:17','2021-12-07 11:29:19','2021-12-09 09:10:17'),
(102,57,37,'2021-12-09 09:10:20','2021-12-07 14:48:26','2021-12-09 09:10:20'),
(103,57,36,'2021-12-09 09:10:20','2021-12-07 14:48:26','2021-12-09 09:10:20'),
(104,58,31,NULL,'2021-12-07 14:48:55','2021-12-07 14:48:55'),
(105,59,37,'2021-12-09 09:02:27','2021-12-09 09:01:55','2021-12-09 09:02:27'),
(106,59,37,'2021-12-09 09:04:39','2021-12-09 09:02:27','2021-12-09 09:04:39'),
(107,59,37,NULL,'2021-12-09 09:04:39','2021-12-09 09:04:39'),
(108,60,32,'2021-12-09 09:06:04','2021-12-09 09:05:57','2021-12-09 09:06:04'),
(109,60,30,'2021-12-09 09:06:04','2021-12-09 09:05:57','2021-12-09 09:06:04'),
(110,60,28,'2021-12-09 09:06:04','2021-12-09 09:05:57','2021-12-09 09:06:04'),
(111,60,23,'2021-12-09 09:06:04','2021-12-09 09:05:57','2021-12-09 09:06:04'),
(112,60,22,'2021-12-09 09:06:04','2021-12-09 09:05:57','2021-12-09 09:06:04'),
(113,60,32,'2021-12-09 09:06:47','2021-12-09 09:06:04','2021-12-09 09:06:47'),
(114,60,32,'2021-12-09 09:06:53','2021-12-09 09:06:47','2021-12-09 09:06:53'),
(115,60,32,NULL,'2021-12-09 09:06:53','2021-12-09 09:06:53'),
(116,61,37,'2021-12-12 20:29:31','2021-12-12 20:29:20','2021-12-12 20:29:31'),
(117,61,37,'2021-12-12 20:29:43','2021-12-12 20:29:31','2021-12-12 20:29:43'),
(118,61,37,NULL,'2021-12-12 20:29:43','2021-12-12 20:29:43');

/*Table structure for table `assign_to_group_usersfddg` */


CREATE TABLE `assign_to_group_usersfddg` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `assign_to_group_users_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assign_to_group_usersfddg` */

/*Table structure for table `assign_to_groups` */


CREATE TABLE `assign_to_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assign_to_groups` */

insert  into `assign_to_groups`(`id`,`group_id`,`batch_id`,`status`,`deleted_at`,`created_at`,`updated_at`) values 
(61,14,4,0,NULL,'2021-12-12 20:29:20','2021-12-12 20:29:20');

/*Table structure for table `assignment_evalution_individuals` */


CREATE TABLE `assignment_evalution_individuals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` bigint(20) unsigned NOT NULL,
  `evalution_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assignment_evalution_individuals` */

insert  into `assignment_evalution_individuals`(`id`,`topic_id`,`evalution_file`,`marks`,`comments`,`created_at`,`updated_at`) values 
(1,11,'uploads/evalution_file/1638299287.png','33',NULL,'2021-11-30 19:08:07','2021-11-30 19:08:07'),
(2,12,NULL,'11',NULL,'2021-12-06 12:08:07','2021-12-06 12:08:07'),
(3,12,NULL,'13',NULL,'2021-12-06 12:09:00','2021-12-06 12:09:00'),
(4,1,NULL,'50',NULL,'2021-12-07 10:47:11','2021-12-07 10:47:11'),
(5,1,NULL,'60',NULL,'2021-12-07 10:47:34','2021-12-07 10:47:34'),
(6,1,NULL,'100',NULL,'2021-12-07 15:25:58','2021-12-07 15:25:58');

/*Table structure for table `assignment_evalutions` */


CREATE TABLE `assignment_evalutions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` bigint(20) unsigned NOT NULL,
  `evalution_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assignment_evalutions` */

insert  into `assignment_evalutions`(`id`,`topic_id`,`evalution_file`,`marks`,`comments`,`created_at`,`updated_at`) values 
(13,37,NULL,'5545',NULL,'2021-11-30 19:25:35','2021-12-01 19:20:35'),
(14,35,'uploads/evalution_file/1638300373.xls','44',NULL,'2021-11-30 19:26:13','2021-11-30 19:26:13'),
(15,35,'uploads/evalution_file/1638300498.png','44',NULL,'2021-11-30 19:28:18','2021-11-30 19:28:18'),
(16,35,NULL,'323',NULL,'2021-11-30 19:28:45','2021-11-30 19:28:45'),
(17,35,NULL,'undefined',NULL,'2021-11-30 19:29:16','2021-11-30 19:29:16'),
(18,38,NULL,'10',NULL,'2021-12-06 11:56:34','2021-12-06 11:56:34'),
(19,38,NULL,'20',NULL,'2021-12-06 11:57:19','2021-12-06 11:57:19');

/*Table structure for table `assignment_groups` */


CREATE TABLE `assignment_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `course_id` bigint(20) unsigned NOT NULL,
  `venue_id` bigint(20) unsigned NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assignment_groups` */

insert  into `assignment_groups`(`id`,`group_name`,`batch_id`,`course_id`,`venue_id`,`status`,`deleted_at`,`created_at`,`updated_at`) values 
(14,'group 1',4,2,2,1,NULL,'2021-12-12 20:26:36','2021-12-12 20:30:55'),
(15,'group 2',4,2,2,1,NULL,'2021-12-12 20:30:39','2021-12-12 20:30:39');

/*Table structure for table `assignment_groupworks` */


CREATE TABLE `assignment_groupworks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `files` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `group_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assignment_groupworks` */

insert  into `assignment_groupworks`(`id`,`title`,`description`,`files`,`user_id`,`group_id`,`created_at`,`updated_at`) values 
(1,'test 2',NULL,NULL,34,2,'2021-11-24 16:03:58','2021-11-24 16:03:58'),
(2,'sdfsd',NULL,'/private/var/folders/rh/0k97v4917c9fd36tzy2q6j4c0000gp/T/phpFdiRT4',34,2,'2021-11-24 16:12:36','2021-11-24 16:12:36'),
(3,'sdfsd',NULL,NULL,34,2,'2021-11-24 16:15:38','2021-11-24 16:15:38'),
(4,'sdf dfsd fs f',NULL,'uploads/assignment_group_work_file/1637770556.pdf',34,2,'2021-11-24 16:15:56','2021-11-24 16:15:56'),
(5,'testt',NULL,'uploads/assignment_group_work_file/1637770716.pdf',34,2,'2021-11-24 16:18:36','2021-11-24 16:18:36'),
(6,'sdfsd sdfsdfsdf sdf',NULL,'uploads/assignment_group_work_file/1637770771.pdf',34,2,'2021-11-24 16:19:31','2021-11-24 16:19:31'),
(7,'df sdf sdf sf',NULL,'uploads/assignment_group_work_file/1637770797.pdf',34,2,'2021-11-24 16:19:57','2021-11-24 16:19:57'),
(8,'sdf sdf sd sf',NULL,'uploads/assignment_group_work_file/1637770921.pdf',34,2,'2021-11-24 16:22:01','2021-11-24 16:22:01'),
(9,'tesf sdf ds',NULL,'uploads/assignment_group_work_file/1637770996.pdf',34,2,'2021-11-24 16:23:16','2021-11-24 16:23:16'),
(10,'sdf sdfsf',NULL,'uploads/assignment_group_work_file/1637771057.pdf',34,2,'2021-11-24 16:24:17','2021-11-24 16:24:17'),
(11,'sdfds',NULL,'uploads/assignment_group_work_file/1637776257.pdf',34,5,'2021-11-24 17:50:57','2021-11-24 17:50:57'),
(12,'fdgd',NULL,'uploads/assignment_group_work_file/1637989003.png',34,5,'2021-11-27 04:56:43','2021-11-27 04:56:43'),
(13,'first assignment',NULL,'uploads/assignment_group_work_file/1639320503.pdf',37,14,'2021-12-12 20:48:23','2021-12-12 20:48:23'),
(14,'Second file',NULL,'uploads/assignment_group_work_file/1639456667.pdf',1,14,'2021-12-14 10:37:47','2021-12-14 10:37:47');

/*Table structure for table `assignment_topic_individuals` */


CREATE TABLE `assignment_topic_individuals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `batch_id` int(11) DEFAULT NULL,
  `dua_date` date NOT NULL,
  `assignment_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topics` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `marks_distribution` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marks` varchar(222) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evalutions_file` varchar(333) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_submited_file` varchar(222) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_submited_date` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assignment_topic_individuals` */

insert  into `assignment_topic_individuals`(`id`,`user_id`,`batch_id`,`dua_date`,`assignment_file`,`topics`,`marks_distribution`,`marks`,`evalutions_file`,`trainee_submited_file`,`trainee_submited_date`,`deleted_at`,`created_at`,`updated_at`) values 
(1,31,1,'2021-12-07',NULL,'Topic 1',NULL,'2222',NULL,NULL,NULL,NULL,'2021-12-08 20:09:12','2021-12-13 19:17:44'),
(2,29,1,'2021-12-21',NULL,'Topic 2',NULL,'1111',NULL,'uploads/trainee_assignment/1640104343.pdf','2021-12-21 16:32:23',NULL,'2021-12-08 20:10:18','2021-12-21 16:32:23'),
(3,32,2,'2021-12-13',NULL,'sdfdsf',NULL,'22233',NULL,NULL,NULL,NULL,'2021-12-13 19:08:37','2021-12-13 19:17:19'),
(4,29,1,'2021-12-07','uploads/assignment_file/1639940559.png','test',NULL,NULL,NULL,'uploads/trainee_assignment/1640104206.pdf','2021-12-21 16:30:06',NULL,'2021-12-19 19:02:39','2021-12-21 16:30:06'),
(5,22,2,'2021-12-22','uploads/assignment_file/1639940820.png','sdfsdf',NULL,NULL,NULL,NULL,NULL,NULL,'2021-12-19 19:07:00','2021-12-19 19:07:00'),
(6,29,1,'2021-12-14','uploads/assignment_file/1640027175.pdf','test','undefined',NULL,NULL,'uploads/trainee_assignment/1640104404.jpeg','2021-12-21 16:33:24',NULL,'2021-12-20 19:06:15','2021-12-21 16:33:24'),
(7,37,4,'2021-12-23','uploads/assignment_file/1640238223.pdf','hgghg','gg',NULL,NULL,'uploads/trainee_assignment/1640238268.pdf','2021-12-23 11:44:28',NULL,'2021-12-23 11:43:43','2021-12-23 11:44:28');

/*Table structure for table `assignment_topics` */


CREATE TABLE `assignment_topics` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `group_id` bigint(20) unsigned NOT NULL,
  `batch_id` int(11) DEFAULT NULL,
  `dua_date` date NOT NULL,
  `assignment_file` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topics` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `marks_distribution` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marks` varchar(222) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evalutions_file` varchar(333) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_submited_file` varchar(222) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_submited_date` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `assignment_topics_group_id_foreign` (`group_id`),
  CONSTRAINT `assignment_topics_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `assignment_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `assignment_topics` */

insert  into `assignment_topics`(`id`,`group_id`,`batch_id`,`dua_date`,`assignment_file`,`topics`,`marks_distribution`,`marks`,`evalutions_file`,`trainee_submited_file`,`trainee_submited_date`,`deleted_at`,`created_at`,`updated_at`) values 
(9,14,4,'2021-12-23','uploads/assignment_file/1640238172.xlsx','ghhv','fghr',NULL,NULL,NULL,NULL,NULL,'2021-12-23 11:42:52','2021-12-23 11:42:52');

/*Table structure for table `attendances` */


CREATE TABLE `attendances` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `index_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_id` bigint(20) unsigned NOT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date` date NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `attendances_batch_id_foreign` (`batch_id`),
  KEY `attendances_user_id_foreign` (`user_id`),
  CONSTRAINT `attendances_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `attendances_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `attendances` */

insert  into `attendances`(`id`,`index_no`,`trainee_id`,`batch_id`,`user_id`,`status`,`date`,`deleted_at`,`created_at`,`updated_at`) values 
(5,'103',8,1,1,1,'2021-10-31',NULL,NULL,NULL),
(6,'100',7,2,1,1,'2021-10-31',NULL,NULL,NULL),
(7,'100',7,2,34,0,'2021-11-10',NULL,NULL,NULL),
(8,'101',12,2,34,1,'2021-11-10',NULL,NULL,NULL),
(9,'103',8,1,34,0,'2021-11-12',NULL,NULL,NULL),
(10,'103',8,1,1,1,'2021-12-21',NULL,NULL,NULL),
(11,'100',7,2,1,1,'2021-12-21',NULL,NULL,NULL),
(12,'101',12,2,1,1,'2021-12-21',NULL,NULL,NULL),
(13,'100',7,2,1,1,'2021-12-22',NULL,NULL,NULL),
(14,'101',12,2,1,0,'2021-12-22',NULL,NULL,NULL),
(15,'103',8,1,1,0,'2021-12-23',NULL,NULL,NULL);

/*Table structure for table `batches` */


CREATE TABLE `batches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sizes` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `venue_id` bigint(255) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `batches_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `batches` */

insert  into `batches`(`id`,`name`,`sizes`,`slug`,`venue_id`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'1st Batch','','1st-bastch',1,NULL,'2021-08-18 03:05:06','2021-08-18 03:05:06'),
(2,'2nd Batch','','2nd-batch',1,NULL,'2021-08-18 03:05:57','2021-08-18 03:05:57'),
(3,'3rd Batch','','3rd-batch',1,'2021-09-09 03:28:00','2021-09-09 03:27:57','2021-09-09 03:28:00'),
(4,'Test','10','test',2,NULL,'2021-10-24 06:45:53','2021-10-24 08:20:55'),
(5,'gfhrt','10','gfhrt',2,'2021-10-24 08:08:22','2021-10-24 08:08:18','2021-10-24 08:08:22'),
(6,'kkj','100','kkj',2,'2021-11-01 09:40:12','2021-11-01 09:40:07','2021-11-01 09:40:12'),
(7,'Test test','10','test-test',3,'2021-12-19 16:29:02','2021-12-19 15:59:13','2021-12-19 16:29:02');

/*Table structure for table `certificates` */


CREATE TABLE `certificates` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `completion_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grade` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unique_key` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `trainee_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `certificates_user_id_foreign` (`user_id`),
  CONSTRAINT `certificates_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `certificates` */

insert  into `certificates`(`id`,`user_id`,`name`,`course_name`,`completion_date`,`grade`,`unique_key`,`deleted_at`,`created_at`,`updated_at`,`trainee_id`) values 
(1,23,'Beatrice Little','Course Name','November, 2021','A+','fWVmCehaSI',NULL,'2021-11-30 09:53:05','2021-11-30 09:53:05',12),
(2,23,'Norman Clemons','Course Name','November, 2021','B+','MB578b3Za1',NULL,'2021-11-30 09:53:05','2021-11-30 09:53:05',15),
(3,23,'Beatrice Little 23','Course Name','November, 2021','A+','HnU5mpDlrO',NULL,'2021-11-30 09:54:01','2021-11-30 09:54:01',12),
(4,23,'Norman Clemons 34','Course Name','November, 2021','B+','WQYmw2ZU1I',NULL,'2021-11-30 09:54:01','2021-11-30 09:54:01',15),
(5,23,'Steve Smith','Course Name','November, 2021','A+','zlW3C6T4DJ',NULL,'2021-12-02 12:30:06','2021-12-02 12:30:06',16),
(6,1,'Ezra Hodges','Course Name','November, 2021','A+','6Tq52EwJ0u',NULL,'2021-12-19 13:53:36','2021-12-19 13:53:36',8);

/*Table structure for table `courses` */


CREATE TABLE `courses` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `courses_user_id_foreign` (`user_id`),
  CONSTRAINT `courses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `courses` */

insert  into `courses`(`id`,`title`,`user_id`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'first title',23,NULL,NULL,'2021-11-10 12:05:03'),
(2,'title edited',23,NULL,'2021-11-10 11:31:31','2021-11-10 11:31:31'),
(3,'test title edit',23,'2021-11-10 13:02:09','2021-11-10 12:53:53','2021-11-10 13:02:09'),
(4,'another course',23,NULL,'2021-11-10 13:02:36','2021-11-10 13:02:36'),
(5,'Database Management',1,NULL,'2021-12-05 15:51:32','2021-12-15 13:31:24');

/*Table structure for table `exam_questions` */


CREATE TABLE `exam_questions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `exam_id` bigint(20) unsigned NOT NULL,
  `subject_id` bigint(20) unsigned NOT NULL,
  `chapter_id` bigint(20) unsigned NOT NULL,
  `setquestion_id` bigint(20) unsigned DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exam_questions_exam_id_foreign` (`exam_id`),
  KEY `exam_questions_subject_id_foreign` (`subject_id`),
  KEY `exam_questions_chapter_id_foreign` (`chapter_id`),
  KEY `exam_questions_setquestion_id_foreign` (`setquestion_id`),
  CONSTRAINT `exam_questions_chapter_id_foreign` FOREIGN KEY (`chapter_id`) REFERENCES `topic_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exam_questions_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exam_questions_setquestion_id_foreign` FOREIGN KEY (`setquestion_id`) REFERENCES `set_questions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exam_questions_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `question_banks` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `exam_questions` */

insert  into `exam_questions`(`id`,`exam_id`,`subject_id`,`chapter_id`,`setquestion_id`,`status`,`deleted_at`,`created_at`,`updated_at`) values 
(4,1,12,19,7,1,NULL,NULL,NULL),
(5,1,12,19,8,1,NULL,NULL,NULL),
(8,2,13,23,15,0,NULL,NULL,NULL),
(9,2,13,23,17,0,NULL,NULL,NULL);

/*Table structure for table `exam_types` */


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

/*Data for the table `exam_types` */

insert  into `exam_types`(`id`,`name`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Written Question1',NULL,'2021-09-29 04:20:42','2021-12-23 09:09:54'),
(2,'MCQ Question',NULL,'2021-09-29 04:21:32','2021-09-29 04:21:32'),
(3,'Combined',NULL,'2021-10-03 04:41:39','2021-10-03 04:41:39'),
(4,'Multiple Type','2021-11-01 10:24:04','2021-10-31 11:59:10','2021-11-01 10:24:04'),
(5,'Test Question','2021-10-31 14:22:16','2021-10-31 14:22:10','2021-10-31 14:22:16'),
(6,'Test Try','2021-10-31 14:32:11','2021-10-31 14:23:30','2021-10-31 14:32:11'),
(7,'Admin','2021-10-31 14:32:13','2021-10-31 14:31:58','2021-10-31 14:32:13'),
(8,'Admin 1','2021-10-31 15:53:37','2021-10-31 14:32:22','2021-10-31 15:53:37'),
(9,'asfasf','2021-10-31 15:23:53','2021-10-31 14:34:28','2021-10-31 15:23:53'),
(10,'asdfasf','2021-10-31 15:21:36','2021-10-31 14:36:04','2021-10-31 15:21:36'),
(11,'fgg','2021-11-01 09:40:26','2021-11-01 09:40:23','2021-11-01 09:40:26'),
(12,'Admin 23','2021-11-01 10:20:09','2021-11-01 10:14:53','2021-11-01 10:20:09'),
(13,'sdfasdfs','2021-11-01 10:22:35','2021-11-01 10:22:27','2021-11-01 10:22:35'),
(14,'MCQ Question','2021-11-01 10:30:16','2021-11-01 10:27:50','2021-11-01 10:30:16'),
(15,'aa','2021-11-01 10:33:43','2021-11-01 10:33:30','2021-11-01 10:33:43'),
(16,'gdf','2021-11-01 10:35:37','2021-11-01 10:35:29','2021-11-01 10:35:37'),
(17,'juguj','2021-11-02 16:28:37','2021-11-01 16:29:36','2021-11-02 16:28:37'),
(18,'random exam','2021-11-02 09:52:16','2021-11-02 09:41:54','2021-11-02 09:52:16'),
(19,'Admin234','2021-11-02 09:52:11','2021-11-02 09:51:50','2021-11-02 09:52:11'),
(20,'MCQ',NULL,'2021-12-23 09:26:40','2021-12-23 09:26:40');

/*Table structure for table `exams` */


CREATE TABLE `exams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `exam_title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_id` bigint(20) unsigned NOT NULL,
  `venue_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `trainer_id` bigint(20) unsigned DEFAULT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `start_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `end_time` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date` date NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `exams_course_id_foreign` (`course_id`),
  KEY `exams_venue_id_foreign` (`venue_id`),
  KEY `exams_user_id_foreign` (`user_id`),
  KEY `exams_trainer_id_foreign` (`trainer_id`),
  KEY `exams_batch_id_foreign` (`batch_id`),
  CONSTRAINT `exams_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exams_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exams_trainer_id_foreign` FOREIGN KEY (`trainer_id`) REFERENCES `trainers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exams_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `exams_venue_id_foreign` FOREIGN KEY (`venue_id`) REFERENCES `venues` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `exams` */

insert  into `exams`(`id`,`exam_title`,`course_id`,`venue_id`,`user_id`,`trainer_id`,`batch_id`,`start_time`,`end_time`,`date`,`status`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Test Exam Test',2,2,1,NULL,4,'12:34 AM','03:35 AM','2021-12-20',1,NULL,'2021-12-15 11:31:39','2021-12-15 14:07:38'),
(2,'test ict',1,1,1,NULL,1,'10:55 AM','10:55 PM','2021-12-19',1,NULL,'2021-12-19 10:55:40','2021-12-19 10:55:40');

/*Table structure for table `failed_jobs` */


CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `failed_jobs` */

/*Table structure for table `favourites` */


CREATE TABLE `favourites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `forum_id` bigint(20) unsigned NOT NULL,
  `favourit` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `favourites_user_id_foreign` (`user_id`),
  KEY `favourites_forum_id_foreign` (`forum_id`),
  CONSTRAINT `favourites_forum_id_foreign` FOREIGN KEY (`forum_id`) REFERENCES `forums` (`id`) ON DELETE CASCADE,
  CONSTRAINT `favourites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `favourites` */

insert  into `favourites`(`id`,`user_id`,`forum_id`,`favourit`,`deleted_at`,`created_at`,`updated_at`) values 
(14,1,1,1,NULL,NULL,NULL),
(15,1,2,1,NULL,NULL,NULL),
(16,1,3,1,NULL,NULL,NULL);

/*Table structure for table `feedback` */


CREATE TABLE `feedback` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` bigint(20) unsigned DEFAULT NULL,
  `course_id` bigint(20) DEFAULT NULL,
  `venue_id` bigint(20) DEFAULT NULL,
  `batch_id` bigint(20) unsigned DEFAULT NULL,
  `frequency` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `role_status` tinyint(4) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_created_by_foreign` (`created_by`),
  KEY `feedback_batch_id_foreign` (`batch_id`),
  CONSTRAINT `feedback_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `feedback_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `feedback` */

insert  into `feedback`(`id`,`name`,`created_by`,`course_id`,`venue_id`,`batch_id`,`frequency`,`role_status`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Ignacia Bennett',23,1,1,1,'Praesentium est ut',2,'2021-10-17 03:14:59','2021-10-14 03:34:58','2021-10-17 03:14:59'),
(2,'Courtney Foley',23,1,1,1,'Eaque do facere sed',2,'2021-10-17 03:15:50','2021-10-14 04:08:44','2021-10-17 03:15:50'),
(3,'Database Management',23,1,1,1,'weekly',2,NULL,'2021-10-14 04:09:01','2021-10-21 08:57:03'),
(4,'Data Science',23,1,1,1,'monthly',2,NULL,'2021-10-14 04:35:15','2021-10-21 08:57:29'),
(5,'Computer Security',23,1,1,2,'weekly',2,NULL,'2021-10-14 04:58:48','2021-10-21 08:57:58'),
(6,'Basic C programming',23,1,1,1,'daily',2,NULL,'2021-10-14 10:26:53','2021-10-21 08:58:18'),
(7,'Software engineering',23,1,1,1,'daily',2,NULL,'2021-10-17 04:58:08','2021-10-21 08:58:39'),
(8,'Machine Learning',23,1,1,1,'monthly',2,NULL,'2021-10-17 11:04:55','2021-10-17 11:04:55'),
(9,'Final Feedback',23,1,1,2,'daily',2,NULL,'2021-10-24 11:11:29','2021-10-24 11:11:29'),
(10,'Test Feedback',1,1,1,2,'daily',2,'2021-11-01 10:45:25','2021-10-31 12:19:52','2021-11-01 10:45:25'),
(11,'test tuesday',23,1,1,2,'weekly',2,NULL,'2021-11-02 09:45:00','2021-11-02 10:26:24'),
(12,'Python',36,1,1,1,'daily',2,NULL,'2021-11-16 10:59:10','2021-11-16 10:59:10'),
(13,'test 1',1,1,1,1,'daily',2,'2021-12-22 15:17:04','2021-12-22 12:29:10','2021-12-22 15:17:04'),
(14,'Australia Cricket',23,1,1,1,'daily',2,NULL,'2021-12-22 15:10:23','2021-12-22 15:10:23'),
(15,'test',23,1,1,1,'daily',2,'2021-12-22 15:51:36','2021-12-22 15:48:05','2021-12-22 15:51:36'),
(16,'test',23,1,1,1,'daily',2,NULL,'2021-12-22 16:26:01','2021-12-22 16:58:37'),
(17,'Clark Powers',23,1,NULL,1,'monthly',8,NULL,'2021-12-22 17:11:40','2021-12-22 17:11:40'),
(18,'Kamal Holcomb',23,1,NULL,1,'monthly',8,NULL,'2021-12-22 17:15:02','2021-12-22 17:15:02');

/*Table structure for table `feedback_answers` */


CREATE TABLE `feedback_answers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `feedback_id` bigint(20) unsigned NOT NULL,
  `questions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `answers` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_answers_user_id_foreign` (`user_id`),
  KEY `feedback_answers_batch_id_foreign` (`batch_id`),
  CONSTRAINT `feedback_answers_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `feedback_answers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `feedback_answers` */

insert  into `feedback_answers`(`id`,`feedback_id`,`questions`,`answers`,`comment`,`user_id`,`batch_id`,`deleted_at`,`created_at`,`updated_at`) values 
(34,8,'How was the course?','random','No issues',23,2,NULL,'2021-10-21 10:34:22','2021-10-21 10:34:22'),
(35,8,'How was the instructor?','average','No issues',23,2,NULL,'2021-10-21 10:34:22','2021-10-21 10:34:22'),
(36,8,'How was the environment?','not nice','No issues',23,2,NULL,'2021-10-21 10:34:23','2021-10-21 10:34:23'),
(37,8,'Rate the course?','7','No issues',23,2,NULL,'2021-10-21 10:34:23','2021-10-21 10:34:23'),
(40,4,'How was the course?','8','nope',23,2,NULL,'2021-10-24 06:06:39','2021-10-24 06:06:39'),
(41,4,'What was the environment?','7','nope',23,2,NULL,'2021-10-24 06:06:39','2021-10-24 06:06:39'),
(42,4,'Course syllabus was good enough?','average','nope',23,2,NULL,'2021-10-24 06:06:39','2021-10-24 06:06:39'),
(43,4,'Anything to change?','no','nope',23,2,NULL,'2021-10-24 06:06:39','2021-10-24 06:06:39'),
(44,3,'How was the course?','8','no comment',23,2,NULL,'2021-10-24 06:07:54','2021-10-24 06:07:54'),
(45,3,'How was the instructor?','8','no comment',23,2,NULL,'2021-10-24 06:07:54','2021-10-24 06:07:54'),
(46,3,'What to change?','nothing','no comment',23,2,NULL,'2021-10-24 06:07:54','2021-10-24 06:07:54'),
(47,3,'How was the course?','7','no comment bro',37,1,NULL,'2021-11-16 10:38:14','2021-11-16 10:38:14'),
(48,3,'How was the instructor?','5','no comment bro',37,1,NULL,'2021-11-16 10:38:14','2021-11-16 10:38:14'),
(49,3,'What to change?','ting ding','no comment bro',37,1,NULL,'2021-11-16 10:38:14','2021-11-16 10:38:14'),
(50,3,'kigkjfjh','tung tang','no comment bro',37,1,NULL,'2021-11-16 10:38:14','2021-11-16 10:38:14'),
(51,12,'What is the rating for this course?','8','yep good one.',37,1,NULL,'2021-11-16 11:21:49','2021-11-16 11:21:49'),
(52,12,'Why that rating you gave?','bcs I am testing','yep good one.',37,1,NULL,'2021-11-16 11:21:49','2021-11-16 11:21:49'),
(56,14,'How was the cricket pitch?','nice','no comment',39,4,NULL,'2021-12-22 15:41:05','2021-12-22 15:41:05'),
(57,14,'What was the environment?','nice','no comment',39,4,NULL,'2021-12-22 15:41:05','2021-12-22 15:41:05'),
(58,14,'What can be the dressing room rating?','7','no comment',39,4,NULL,'2021-12-22 15:41:05','2021-12-22 15:41:05'),
(59,14,'What was the hotel rating?','7','no comment',39,4,NULL,'2021-12-22 15:41:05','2021-12-22 15:41:05'),
(60,15,'jhdgdgj','7','shgsfhs',23,2,'2021-12-22 15:51:36','2021-12-22 15:51:20','2021-12-22 15:51:36'),
(61,15,'dgfhgjdg','gsZfrhgsfh','shgsfhs',23,2,'2021-12-22 15:51:36','2021-12-22 15:51:21','2021-12-22 15:51:36');

/*Table structure for table `feedback_questions` */


CREATE TABLE `feedback_questions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `feedback_id` bigint(20) unsigned NOT NULL,
  `answer_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feedback_questions_user_id_foreign` (`user_id`),
  KEY `feedback_questions_feedback_id_foreign` (`feedback_id`),
  CONSTRAINT `feedback_questions_feedback_id_foreign` FOREIGN KEY (`feedback_id`) REFERENCES `feedback` (`id`) ON DELETE CASCADE,
  CONSTRAINT `feedback_questions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `feedback_questions` */

insert  into `feedback_questions`(`id`,`question`,`user_id`,`feedback_id`,`answer_type`,`deleted_at`,`created_at`,`updated_at`) values 
(10,'How was the course?',23,8,'written',NULL,'2021-10-17 11:06:31','2021-10-17 11:06:31'),
(11,'How was the instructor?',23,8,'written',NULL,'2021-10-17 11:06:31','2021-10-17 11:06:43'),
(12,'How was the environment?',23,8,'written',NULL,'2021-10-17 11:06:31','2021-10-17 11:06:54'),
(13,'Rate the course?',23,8,'point',NULL,'2021-10-17 11:06:31','2021-10-17 11:06:31'),
(14,'How was the course?',23,3,'point',NULL,'2021-10-21 08:59:54','2021-10-21 08:59:54'),
(15,'How was the instructor?',23,3,'point',NULL,'2021-10-21 08:59:54','2021-10-21 08:59:54'),
(16,'What to change?',23,3,'written',NULL,'2021-10-21 08:59:54','2021-10-21 08:59:54'),
(17,'How was the course?',23,4,'point',NULL,'2021-10-21 09:01:19','2021-10-21 09:01:19'),
(18,'What was the environment?',23,4,'point',NULL,'2021-10-21 09:01:19','2021-10-21 09:01:19'),
(19,'Course syllabus was good enough?',23,4,'written',NULL,'2021-10-21 09:01:19','2021-10-21 09:01:19'),
(20,'Anything to change?',23,4,'written',NULL,'2021-10-21 09:01:19','2021-10-21 09:01:19'),
(21,'What did you learn from the course?',23,5,'written',NULL,'2021-10-21 09:02:16','2021-10-21 09:02:16'),
(22,'How was the course?',23,5,'point',NULL,'2021-10-21 09:02:16','2021-10-21 09:02:16'),
(23,'Was the syllabus satisfying?',23,5,'written',NULL,'2021-10-21 09:02:16','2021-10-21 09:02:16'),
(24,'How was the course?',23,6,'point',NULL,'2021-10-21 09:02:57','2021-10-21 09:02:57'),
(25,'What did you learn?',23,6,'written',NULL,'2021-10-21 09:02:58','2021-10-21 09:02:58'),
(26,'What to change?',23,6,'written',NULL,'2021-10-21 09:02:58','2021-10-21 09:02:58'),
(27,'How was the course?',23,7,'point',NULL,'2021-10-21 09:03:50','2021-10-21 09:03:50'),
(28,'How was the instructor?',23,7,'point',NULL,'2021-10-21 09:03:50','2021-10-21 09:03:50'),
(29,'What did you learn from the course?',23,7,'written',NULL,'2021-10-21 09:03:50','2021-10-21 09:03:50'),
(30,'What to change?',23,7,'written',NULL,'2021-10-21 09:03:50','2021-10-21 09:03:50'),
(31,'How was the course?',23,9,'written',NULL,'2021-10-24 11:16:57','2021-10-24 11:16:57'),
(32,'Why so serious?',23,9,'point',NULL,'2021-10-24 11:16:58','2021-10-24 11:16:58'),
(33,'How was the course?',23,9,'point','2021-10-24 11:19:05','2021-10-24 11:18:43','2021-10-24 11:19:05'),
(34,'Why so serious',23,9,'Select Answer Type','2021-10-24 11:18:59','2021-10-24 11:18:43','2021-10-24 11:18:59'),
(35,'How was the course?',23,9,'point',NULL,'2021-10-24 11:18:50','2021-10-24 11:18:50'),
(36,'Why so serious?',23,9,'written',NULL,'2021-10-24 11:18:50','2021-10-24 11:18:50'),
(37,'kigkjfjh',1,3,'written',NULL,'2021-10-28 17:11:54','2021-10-28 17:11:54'),
(38,'How satisfied are you with the Trainer?',1,10,'point',NULL,'2021-10-31 12:20:49','2021-10-31 12:20:49'),
(39,'Any suggestion?',1,10,'written',NULL,'2021-10-31 12:20:49','2021-10-31 12:20:49'),
(40,'Nam et in explicabo',23,11,'written',NULL,'2021-11-02 10:45:58','2021-11-02 10:45:58'),
(41,'Excepteur laboris in',23,11,'written',NULL,'2021-11-02 10:45:58','2021-11-02 10:45:58'),
(42,'Omnis praesentium la?',23,11,'point',NULL,'2021-11-02 10:45:58','2021-11-02 10:45:58'),
(43,'What is the rating for this course?',36,12,'point',NULL,'2021-11-16 11:21:09','2021-11-16 11:21:09'),
(44,'Why that rating you gave?',36,12,'written',NULL,'2021-11-16 11:21:09','2021-11-16 11:21:09'),
(45,'test q',1,13,'point','2021-12-22 15:56:14','2021-12-22 12:30:23','2021-12-22 12:30:23'),
(46,'How was the cricket pitch?',23,14,'written',NULL,'2021-12-22 15:18:32','2021-12-22 15:18:32'),
(47,'What was the environment?',23,14,'written',NULL,'2021-12-22 15:18:33','2021-12-22 15:18:33'),
(48,'What can be the dressing room rating?',23,14,'point',NULL,'2021-12-22 15:18:33','2021-12-22 15:18:33'),
(49,'What was the hotel rating?',23,14,'point',NULL,'2021-12-22 15:18:33','2021-12-22 15:18:33'),
(50,'jhdgdgj',23,15,'point','2021-12-22 15:56:18','2021-12-22 15:50:53','2021-12-22 15:50:53'),
(51,'dgfhgjdg',23,15,'written','2021-12-22 15:56:20','2021-12-22 15:50:53','2021-12-22 15:50:53');

/*Table structure for table `forum_categories` */


CREATE TABLE `forum_categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `forum_categories` */

insert  into `forum_categories`(`id`,`name`,`slug`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'History','history',NULL,'2021-10-07 05:49:54','2021-10-07 06:35:35'),
(2,'Comedy','comedy',NULL,'2021-10-07 06:16:28','2021-10-07 06:16:28'),
(3,'Free','free','2021-10-07 06:36:30','2021-10-07 06:36:28','2021-10-07 06:36:30'),
(4,'General','general',NULL,'2021-10-07 06:37:39','2021-10-07 06:37:39'),
(5,'Request','request',NULL,'2021-10-07 06:38:15','2021-10-07 06:38:15'),
(6,'Admin','admin','2021-11-03 15:33:54','2021-11-03 15:13:10','2021-11-03 15:33:54'),
(7,'test 2','test-2',NULL,'2021-12-22 14:12:57','2021-12-22 14:12:57');

/*Table structure for table `forum_replies` */


CREATE TABLE `forum_replies` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `forum_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `forum_replies_user_id_foreign` (`user_id`),
  KEY `forum_replies_forum_id_foreign` (`forum_id`),
  CONSTRAINT `forum_replies_forum_id_foreign` FOREIGN KEY (`forum_id`) REFERENCES `forums` (`id`) ON DELETE CASCADE,
  CONSTRAINT `forum_replies_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `forum_replies` */

insert  into `forum_replies`(`id`,`comment`,`user_id`,`forum_id`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'The story is really good',1,1,'2021-10-21 15:27:42','2021-10-07 10:33:11','2021-10-21 15:27:42'),
(2,'The story is really Awsome',1,1,'2021-10-21 15:35:22','2021-10-07 10:33:49','2021-10-21 15:35:22'),
(3,'The story is really awesome',31,1,'2021-10-21 15:35:26','2021-10-21 15:05:05','2021-10-21 15:35:26'),
(4,'dfgvsfdg',31,1,'2021-10-21 15:31:07','2021-10-21 15:24:15','2021-10-21 15:31:07'),
(5,'fsdsadfasdfs',31,1,'2021-10-21 15:36:38','2021-10-21 15:35:34','2021-10-21 15:36:38'),
(6,'asfasfasf',31,1,'2021-10-21 15:36:41','2021-10-21 15:35:40','2021-10-21 15:36:41'),
(7,'The story is really awesome',31,1,'2021-10-21 15:36:57','2021-10-21 15:35:49','2021-10-21 15:36:57'),
(8,'The story is really good..',1,1,NULL,'2021-10-21 15:36:00','2021-10-21 15:36:00'),
(9,'The story is really awesome..Not',31,1,NULL,'2021-10-21 15:37:13','2021-10-21 15:37:13'),
(10,'asfsdafgasdfa',31,1,'2021-10-21 15:47:34','2021-10-21 15:44:45','2021-10-21 15:47:34'),
(11,'Not Good',31,1,NULL,'2021-10-21 16:31:28','2021-10-21 16:31:28'),
(12,'awesome',1,1,NULL,'2021-10-26 09:54:58','2021-10-26 09:54:58'),
(13,'gdgfsgs',1,3,'2021-11-03 16:15:07','2021-11-03 16:12:35','2021-11-03 16:15:07'),
(14,'Good Post',1,3,'2021-11-03 17:07:09','2021-11-03 16:12:51','2021-11-03 17:07:09'),
(15,'dsafgasrdgas',1,2,'2021-11-03 17:08:41','2021-11-03 17:08:34','2021-11-03 17:08:41');

/*Table structure for table `forums` */


CREATE TABLE `forums` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `forumcategory_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `forums_forumcategory_id_foreign` (`forumcategory_id`),
  KEY `forums_user_id_foreign` (`user_id`),
  CONSTRAINT `forums_forumcategory_id_foreign` FOREIGN KEY (`forumcategory_id`) REFERENCES `forum_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `forums_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



/*Table structure for table `marksheets` */


CREATE TABLE `marksheets` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `course_id` bigint(20) unsigned DEFAULT NULL,
  `venue_id` bigint(20) unsigned DEFAULT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `exam_id` bigint(20) unsigned DEFAULT NULL,
  `marks` bigint(20) unsigned DEFAULT NULL,
  `grade` varchar(255) 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`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `marksheets` */

insert  into `marksheets`(`id`,`course_id`,`venue_id`,`batch_id`,`exam_id`,`marks`,`grade`,`deleted_at`,`created_at`,`updated_at`) values 
(1,1,1,1,1,50,'C+',NULL,'2021-12-09 09:12:25','2021-12-09 09:12:27'),
(2,1,1,1,2,60,'B',NULL,'2021-12-09 09:12:29','2021-12-09 09:12:31'),
(3,1,1,1,3,70,'B+',NULL,'2021-12-09 09:12:33','2021-12-09 09:12:35'),
(4,1,1,1,4,80,'A',NULL,'2021-12-09 09:12:37','2021-12-09 09:12:39'),
(5,1,1,1,5,90,'A+',NULL,'2021-12-09 09:12:41','2021-12-09 09:12:42');

/*Table structure for table `migrations` */


CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `migrations` */

insert  into `migrations`(`id`,`migration`,`batch`) values 
(1,'2014_10_12_000000_create_users_table',1),
(2,'2014_10_12_100000_create_password_resets_table',1),
(3,'2019_08_19_000000_create_failed_jobs_table',1),
(4,'2021_06_28_171309_create_modules_table',1),
(5,'2021_06_28_171510_create_permissions_table',1),
(6,'2021_06_28_172950_create_roles_table',1),
(7,'2021_06_28_182347_create_permission_role_table',1),
(8,'2021_07_29_110233_create_batches_table',1),
(9,'2021_08_01_061245_create_attendances_table',1),
(10,'2021_08_31_090010_create_question_banks_table',1),
(11,'2021_09_02_051039_create_questionnaires_table',1),
(12,'2021_09_02_051823_create_questionnaire_answers_table',1),
(13,'2021_09_02_071423_create_trainees_table',1),
(14,'2021_09_02_080639_create_trainers_table',1),
(15,'2021_09_16_042437_create_exam_types_table',1),
(16,'2021_09_20_085925_create_topic_types_table',1),
(20,'2021_10_07_040644_create_forum_categories_table',1),
(21,'2021_10_07_064309_create_forums_table',1),
(22,'2021_10_07_101509_create_forum_replies_table',1),
(23,'2021_10_12_084638_create_feedback_table',1),
(25,'2021_10_14_050822_create_feedback_questions_table',1),
(26,'2021_10_17_053200_create_feedback_answers_table',1),
(27,'2021_10_21_095426_add_sizes_to_batches_table',1),
(28,'2021_10_25_090454_create_assignment_groups_table',1),
(29,'2021_10_26_044700_create_assignment_topics_table',1),
(30,'2021_10_27_093032_create_favourites_table',1),
(31,'2021_10_28_152012_create_assignment_groupworks_table',1),
(32,'2021_11_04_093557_create_assign_to_groups_table',1),
(35,'2021_11_10_094717_create_courses_table',1),
(36,'2021_11_10_115741_create_venues_table',1),
(46,'2021_11_25_162028_create_repositories_table',2),
(47,'2021_11_25_162252_create_certificates_table',2),
(48,'2021_11_25_163118_create_repository_files_table',2),
(83,'2021_11_29_113539_create_questions_table',3),
(84,'2021_12_01_155312_create_set_questions_table',3),
(85,'2021_12_01_155503_create_question_mcqs_table',3),
(86,'2021_12_01_155521_create_question_answers_table',3),
(89,'2021_12_14_153601_create_exams_table',4),
(90,'2021_12_15_153659_create_exam_questions_table',5),
(91,'2021_12_19_152959_create_submit_exams_table',6),
(92,'2021_12_19_153134_create_submit_exam_details_table',6),
(95,'2021_12_20_095629_create_marksheets_table',7);

/*Table structure for table `modules` */


CREATE TABLE `modules` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `modules_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `modules` */

insert  into `modules`(`id`,`name`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Admin Dashboard',NULL,'2021-06-30 12:08:30','2021-06-30 12:08:30'),
(2,'Role Management',NULL,'2021-06-30 12:08:31','2021-10-19 06:24:06'),
(3,'User Management',NULL,'2021-06-30 12:08:31','2021-10-19 06:24:26'),
(4,'Manage Module',NULL,'2021-07-04 05:36:24','2021-07-04 08:55:35'),
(5,'Manage Permission',NULL,'2021-07-04 05:41:10','2021-07-04 05:41:10'),
(6,'Manage Batch',NULL,'2021-08-18 01:49:01','2021-08-18 01:49:01'),
(7,'Manage Attendance',NULL,'2021-08-18 01:52:33','2021-08-18 01:52:33'),
(8,'Feedback',NULL,'2021-09-02 03:32:19','2021-09-02 03:32:19'),
(9,'Manage Trainee',NULL,'2021-09-02 09:09:36','2021-09-02 09:09:36'),
(10,'Manage Trainer',NULL,'2021-09-05 10:44:12','2021-09-05 10:44:12'),
(11,'Exam',NULL,'2021-09-07 05:13:18','2021-09-07 05:13:18'),
(14,'Feedback Question',NULL,'2021-10-14 06:08:09','2021-10-14 06:08:09'),
(15,'Assignment System',NULL,'2021-10-25 04:13:59','2021-10-25 04:13:59'),
(16,'Feedback Answer',NULL,'2021-10-25 04:48:27','2021-10-25 04:48:27'),
(17,'Repository',NULL,'2021-10-25 10:54:18','2021-10-25 10:54:18'),
(18,'Course',NULL,'2021-11-10 10:08:55','2021-11-10 10:08:55'),
(19,'Venue',NULL,'2021-11-10 12:14:00','2021-11-10 12:14:00'),
(20,'certificate',NULL,'2021-12-21 14:26:22','2021-12-21 14:26:22');

/*Table structure for table `notifications` */


CREATE TABLE `notifications` (
  `id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notifiable_id` bigint(20) unsigned NOT NULL,
  `data` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_notifiable_type_notifiable_id_index` (`notifiable_type`,`notifiable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `notifications` */

insert  into `notifications`(`id`,`type`,`notifiable_type`,`notifiable_id`,`data`,`read_at`,`created_at`,`updated_at`) values 
('012e40be-48da-4337-9c06-e73d74e1a4a7','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"user\":{\"id\":37,\"role_id\":3,\"trainee_id\":16,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainee\",\"email\":\"rtrainee@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:41:51.000000Z\",\"updated_at\":\"2021-11-16T03:41:51.000000Z\"},\"details\":{\"user_id\":37,\"assign_to_group_users_id\":54},\"group\":1}',NULL,'2021-12-06 12:12:42','2021-12-06 12:12:42'),
('0277e591-e727-4b8c-a463-338ea2d200f3','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',36,'{\"user\":{\"id\":36,\"role_id\":2,\"trainee_id\":null,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainer\",\"email\":\"rtrainer@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:38:58.000000Z\",\"updated_at\":\"2021-11-16T03:38:58.000000Z\"},\"details\":{\"user_id\":36,\"assign_to_group_users_id\":56},\"group\":1}',NULL,'2021-12-07 10:34:02','2021-12-07 10:34:02'),
('09c8f98b-4b20-4334-afc2-5757cfa91916','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:16:53','2021-12-04 07:16:53'),
('0e0a1d76-838e-46bd-8a29-49998063e6f8','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:44:25','2021-12-04 06:44:25'),
('112da6c3-dfd6-4dc2-8fb3-67ff6bd0932b','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:47:15','2021-12-04 06:47:15'),
('11fdad90-90ae-43bb-99be-afc1f757715d','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:18:50','2021-12-04 07:18:50'),
('17cfc5e6-b42a-400a-b179-821b90789b4a','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":46},\"group\":1}',NULL,'2021-12-04 06:49:13','2021-12-04 06:49:13'),
('20fdaf8b-1f80-44ed-a7ff-ef7f47912419','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:43:57','2021-12-04 06:43:57'),
('2a4c0337-fe80-4820-8705-a6d8ea40f144','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:19:11','2021-12-04 07:19:11'),
('2a800f11-d85e-4247-94e6-b790fb5c0ff2','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:23:51','2021-12-04 07:23:51'),
('2e0699cc-aa7d-4556-9733-9abb07afbb38','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":55},\"group\":1}',NULL,'2021-12-07 10:00:33','2021-12-07 10:00:33'),
('3046f0ef-85a9-4c64-8701-109e230a03dc','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"info\":\"test\"}',NULL,'2021-12-09 09:01:55','2021-12-09 09:01:55'),
('32122c9a-953e-4ec6-8178-b6756e2de818','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":42}}',NULL,'2021-12-01 19:01:23','2021-12-01 19:01:23'),
('3479d76e-01c0-41a3-aa6e-3f6062dd0e94','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"user\":{\"id\":37,\"role_id\":3,\"trainee_id\":16,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainee\",\"email\":\"rtrainee@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:41:51.000000Z\",\"updated_at\":\"2021-11-16T03:41:51.000000Z\"},\"details\":{\"user_id\":37,\"assign_to_group_users_id\":55},\"group\":1}',NULL,'2021-12-07 10:00:33','2021-12-07 10:00:33'),
('36c018c5-40ed-450a-b4e8-7939837be4fe','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',36,'{\"user\":{\"id\":36,\"role_id\":2,\"trainee_id\":null,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainer\",\"email\":\"rtrainer@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:38:58.000000Z\",\"updated_at\":\"2021-11-16T03:38:58.000000Z\"},\"details\":{\"user_id\":36,\"assign_to_group_users_id\":56},\"group\":1}',NULL,'2021-12-07 11:29:19','2021-12-07 11:29:19'),
('37c8fae2-decc-430f-a46a-9784fddf775b','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"user\":{\"id\":37,\"role_id\":3,\"trainee_id\":16,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainee\",\"email\":\"rtrainee@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:41:51.000000Z\",\"updated_at\":\"2021-11-16T03:41:51.000000Z\"},\"details\":{\"user_id\":37,\"assign_to_group_users_id\":56},\"group\":1}',NULL,'2021-12-07 10:34:02','2021-12-07 10:34:02'),
('3b491708-ea79-446f-81a4-3d9c7f544bcf','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',22,'{\"user\":{\"id\":22,\"role_id\":3,\"trainee_id\":1,\"trainer_id\":null,\"batch_id\":2,\"name\":\"jagimu\",\"email\":\"mudo@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"jagimu-6136f57e4701d-2021-09-07.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:15:42.000000Z\",\"updated_at\":\"2021-09-06T23:15:42.000000Z\"},\"details\":{\"user_id\":22,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:50:39','2021-12-04 06:50:39'),
('463f7fd0-a0f4-4661-9a37-ac76b46219da','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',22,'{\"info\":\"ttt\"}',NULL,'2021-12-09 09:05:57','2021-12-09 09:05:57'),
('4a3adc70-440a-45fd-98f5-b82f517db2cb','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"info\":\"ttt\"}',NULL,'2021-12-09 09:05:57','2021-12-09 09:05:57'),
('4baec14d-7f23-4ca4-94e2-3a198aa7bb56','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:42:32','2021-12-04 06:42:32'),
('4ca1590f-1c41-49ca-ac8e-87c726714e47','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',36,'{\"user\":{\"id\":36,\"role_id\":2,\"trainee_id\":null,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainer\",\"email\":\"rtrainer@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:38:58.000000Z\",\"updated_at\":\"2021-11-16T03:38:58.000000Z\"},\"details\":{\"user_id\":36,\"assign_to_group_users_id\":55},\"group\":1}',NULL,'2021-12-07 10:00:33','2021-12-07 10:00:33'),
('4de23b9d-5fd1-44d3-87ca-e7f3a310f618','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:47:59','2021-12-04 06:47:59'),
('4de9d8c2-106c-4db7-a198-60ab1ee74930','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":43},\"group\":1}',NULL,'2021-12-01 19:03:45','2021-12-01 19:03:45'),
('4f2d2fe8-a58e-44b1-9747-80a7682d905e','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:47:51','2021-12-04 06:47:51'),
('53967dde-cc8e-4bfa-96c2-6cf7d4872c01','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:21:01','2021-12-04 07:21:01'),
('570a4c90-d799-4561-be96-3b9fd87d07f0','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":54},\"group\":1}',NULL,'2021-12-06 12:12:42','2021-12-06 12:12:42'),
('5a00fca1-0336-4e27-8f1d-3bc2ace44a52','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:10:22','2021-12-04 07:10:22'),
('5e20aa3b-6d28-4a29-b658-8ccb6aabf2a9','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:54:20','2021-12-04 06:54:20'),
('5fa47048-a17c-44f5-940e-2cee806a384b','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:17:46','2021-12-04 07:17:46'),
('61230913-c741-4473-a4d0-419a4e0845c0','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":58},\"group\":1}',NULL,'2021-12-07 14:48:55','2021-12-07 14:48:55'),
('646dc977-f601-46d3-8405-24268a53a4de','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:24:40','2021-12-04 07:24:40'),
('6568b8fd-2693-473f-9a27-5c53e075e0cb','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:43:51','2021-12-04 06:43:51'),
('66b70dc3-82e5-40a1-bbd7-bf540f8e63fc','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:47:51','2021-12-04 06:47:51'),
('67f46eff-510a-4494-9189-af4adb64561f','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',28,'{\"info\":\"ttt\"}',NULL,'2021-12-09 09:05:57','2021-12-09 09:05:57'),
('6e33b872-6fa7-4751-9db5-622f0d957472','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:20:04','2021-12-04 07:20:04'),
('6efd4ffe-8f92-4d4f-afff-bc3eafbb5654','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',22,'{\"user\":{\"id\":22,\"role_id\":3,\"trainee_id\":1,\"trainer_id\":null,\"batch_id\":2,\"name\":\"jagimu\",\"email\":\"mudo@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"jagimu-6136f57e4701d-2021-09-07.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:15:42.000000Z\",\"updated_at\":\"2021-09-06T23:15:42.000000Z\"},\"details\":{\"user_id\":22,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:56:53','2021-12-04 07:56:53'),
('760a0cb8-cfc3-4f95-a5b8-4b67876439b6','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:06:59','2021-12-04 07:06:59'),
('7ebdbc8a-373d-46e9-80ea-b8b0e9e35262','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":3,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":55},\"group\":1}',NULL,'2021-12-07 10:00:34','2021-12-07 10:00:34'),
('7f22ce6d-102a-4f80-a59e-a9e16de59b23','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":43},\"group\":1}',NULL,'2021-12-01 19:03:45','2021-12-01 19:03:45'),
('83d36612-9650-4b3f-bf94-937bbb921eea','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:29:21','2021-12-04 06:29:21'),
('83d7726a-17af-46d0-a9e2-03289573e400','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',30,'{\"user\":{\"id\":30,\"role_id\":2,\"trainee_id\":12,\"trainer_id\":6,\"batch_id\":2,\"name\":\"kubasemof\",\"email\":\"jedujujeb@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-08T00:36:46.000000Z\",\"updated_at\":\"2021-09-08T00:40:27.000000Z\"},\"details\":{\"user_id\":30,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:56:53','2021-12-04 07:56:53'),
('8446701a-eca1-4f4a-bca8-352641e1c68a','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:25:03','2021-12-04 07:25:03'),
('88cf0c42-c1d0-4ade-b8de-2ec735764739','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:23:30','2021-12-04 07:23:30'),
('8b77de3a-9766-49f0-b4a1-ac94b5680b41','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"info\":\"Test group\"}',NULL,'2021-12-12 20:29:21','2021-12-12 20:29:21'),
('8d0bf97b-fc4a-40bd-8156-70dc99ebd622','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:29:10','2021-12-04 06:29:10'),
('8dcf2fbc-cbc8-4273-82e2-c532d42c73f5','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',32,'{\"info\":\"ttt\"}',NULL,'2021-12-09 09:05:57','2021-12-09 09:05:57'),
('97d611c2-4843-4cc5-840a-f1d0bbcb7ca9','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":46},\"group\":1}',NULL,'2021-12-04 06:48:52','2021-12-04 06:48:52'),
('991bc745-8fc3-495d-91ed-79dd05bcaf2a','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:51:28','2021-12-04 06:51:28'),
('9b73e740-8026-4863-a215-9e69ac3d6f88','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"user\":{\"id\":37,\"role_id\":3,\"trainee_id\":16,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainee\",\"email\":\"rtrainee@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:41:51.000000Z\",\"updated_at\":\"2021-11-16T03:41:51.000000Z\"},\"details\":{\"user_id\":37,\"assign_to_group_users_id\":54},\"group\":1}',NULL,'2021-12-06 12:12:34','2021-12-06 12:12:34'),
('a0079335-074b-4e3b-b6cd-a2d59577dc1b','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',22,'{\"user\":{\"id\":22,\"role_id\":3,\"trainee_id\":1,\"trainer_id\":null,\"batch_id\":2,\"name\":\"jagimu\",\"email\":\"mudo@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"jagimu-6136f57e4701d-2021-09-07.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:15:42.000000Z\",\"updated_at\":\"2021-09-06T23:15:42.000000Z\"},\"details\":{\"user_id\":22,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:56:41','2021-12-04 07:56:41'),
('ad58cba1-78c7-4080-91dc-a1cd8738f273','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',32,'{\"user\":{\"id\":32,\"role_id\":3,\"trainee_id\":15,\"trainer_id\":8,\"batch_id\":2,\"name\":\"fadowedaz\",\"email\":\"bocis@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-08T03:11:10.000000Z\",\"updated_at\":\"2021-09-08T03:38:27.000000Z\"},\"details\":{\"user_id\":32,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:56:53','2021-12-04 07:56:53'),
('af812f9f-e498-4a9b-a00d-a52a532846fb','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',36,'{\"user\":{\"id\":36,\"role_id\":2,\"trainee_id\":null,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainer\",\"email\":\"rtrainer@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:38:58.000000Z\",\"updated_at\":\"2021-11-16T03:38:58.000000Z\"},\"details\":{\"user_id\":36,\"assign_to_group_users_id\":57},\"group\":12}',NULL,'2021-12-07 14:48:26','2021-12-07 14:48:26'),
('b72ade1c-37de-4d04-aa8a-a943317e4fbe','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":1}',NULL,'2021-12-01 19:27:51','2021-12-01 19:27:51'),
('bcc2470b-c602-4685-a774-cddc5deb7ad9','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:43:57','2021-12-04 06:43:57'),
('bcec3e7c-4831-4a3b-b6a4-fa84a56c5d1d','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:25:27','2021-12-04 07:25:27'),
('bed39353-3383-4d80-936f-438eb57e390b','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',30,'{\"info\":\"ttt\"}',NULL,'2021-12-09 09:05:57','2021-12-09 09:05:57'),
('c146c7ec-3590-405c-a04e-5f09c97095ca','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:50:39','2021-12-04 06:50:39'),
('c301ca01-eb0a-4157-9d08-1cc609fd879e','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',36,'{\"user\":{\"id\":36,\"role_id\":2,\"trainee_id\":null,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainer\",\"email\":\"rtrainer@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:38:58.000000Z\",\"updated_at\":\"2021-11-16T03:38:58.000000Z\"},\"details\":{\"user_id\":36,\"assign_to_group_users_id\":54},\"group\":1}',NULL,'2021-12-06 12:12:34','2021-12-06 12:12:34'),
('c37fbf0f-894f-4a54-bcf2-e84681f678c8','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:52:36','2021-12-04 06:52:36'),
('c473f533-f567-474e-b863-e142dae68d14','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"user\":{\"id\":37,\"role_id\":3,\"trainee_id\":16,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainee\",\"email\":\"rtrainee@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:41:51.000000Z\",\"updated_at\":\"2021-11-16T03:41:51.000000Z\"},\"details\":{\"user_id\":37,\"assign_to_group_users_id\":56},\"group\":1}',NULL,'2021-12-07 11:29:19','2021-12-07 11:29:19'),
('c7bd9f1f-7f51-4d9f-b601-ad8167142121','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":56},\"group\":1}',NULL,'2021-12-07 11:29:19','2021-12-07 11:29:19'),
('ca53556e-b186-41d0-ab81-fe623f99267b','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":3,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":54},\"group\":1}',NULL,'2021-12-06 12:12:42','2021-12-06 12:12:42'),
('cbad79fb-518c-4161-a82c-2411590e0ae6','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',36,'{\"user\":{\"id\":36,\"role_id\":2,\"trainee_id\":null,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainer\",\"email\":\"rtrainer@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:38:58.000000Z\",\"updated_at\":\"2021-11-16T03:38:58.000000Z\"},\"details\":{\"user_id\":36,\"assign_to_group_users_id\":54},\"group\":1}',NULL,'2021-12-06 12:12:42','2021-12-06 12:12:42'),
('cf61f900-4bd0-4b05-bf46-8cce36991cbf','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":42}}',NULL,'2021-12-01 19:01:23','2021-12-01 19:01:23'),
('d5b98329-ca15-467f-8fb7-ed8a78b95fc7','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',29,'{\"user\":{\"id\":29,\"role_id\":2,\"trainee_id\":8,\"trainer_id\":2,\"batch_id\":1,\"name\":\"rixonibop\",\"email\":\"fodolunupa@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":null,\"deleted_at\":null,\"created_at\":\"2021-09-07T23:53:21.000000Z\",\"updated_at\":\"2021-09-08T00:36:10.000000Z\"},\"details\":{\"user_id\":29,\"assign_to_group_users_id\":44},\"group\":2}',NULL,'2021-12-04 06:47:15','2021-12-04 06:47:15'),
('d6888dd2-ffaa-4a3d-a284-7a77524a596a','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',37,'{\"user\":{\"id\":37,\"role_id\":3,\"trainee_id\":16,\"trainer_id\":null,\"batch_id\":1,\"name\":\"r trainee\",\"email\":\"rtrainee@fachuki.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-11-16T03:41:51.000000Z\",\"updated_at\":\"2021-11-16T03:41:51.000000Z\"},\"details\":{\"user_id\":37,\"assign_to_group_users_id\":57},\"group\":12}',NULL,'2021-12-07 14:48:26','2021-12-07 14:48:26'),
('d991aebd-a54a-492b-a992-f043711635dd','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:59:20','2021-12-04 06:59:20'),
('df347381-f3e2-4571-823e-d88f69ed1c89','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 06:51:30','2021-12-04 06:51:30'),
('e66daa62-3944-4a28-b2a1-9551377a6177','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',31,'{\"user\":{\"id\":31,\"role_id\":3,\"trainee_id\":13,\"trainer_id\":7,\"batch_id\":1,\"name\":\"poxawefu\",\"email\":\"nufesow@mailinator.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"poxawefu-2021-10-31.jpg\",\"deleted_at\":null,\"created_at\":\"2021-09-08T00:43:50.000000Z\",\"updated_at\":\"2021-10-31T06:39:05.000000Z\"},\"details\":{\"user_id\":31,\"assign_to_group_users_id\":44},\"group\":1}',NULL,'2021-12-01 19:27:51','2021-12-01 19:27:51'),
('e950e7c4-50be-4756-909a-a1da985e713d','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:25:49','2021-12-04 07:25:49'),
('fa30a202-f9a4-4be0-872e-b88badd37a6d','App\\Notifications\\AssignAssignmentNotification','App\\Models\\User',23,'{\"user\":{\"id\":23,\"role_id\":1,\"trainee_id\":1,\"trainer_id\":1,\"batch_id\":2,\"name\":\"tester\",\"email\":\"tester@gmail.com\",\"email_verified_at\":null,\"is_active\":1,\"image\":\"\",\"deleted_at\":null,\"created_at\":\"2021-09-06T23:39:50.000000Z\",\"updated_at\":\"2021-09-06T23:39:50.000000Z\"},\"details\":{\"user_id\":23,\"assign_to_group_users_id\":47},\"group\":2}',NULL,'2021-12-04 07:19:50','2021-12-04 07:19:50');

/*Table structure for table `password_resets` */


CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `password_resets` */

/*Table structure for table `permission_role` */


CREATE TABLE `permission_role` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_permission_id_foreign` (`permission_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `permission_role` */

insert  into `permission_role`(`id`,`permission_id`,`role_id`,`created_at`,`updated_at`) values 
(1,1,1,NULL,NULL),
(2,2,1,NULL,NULL),
(4,4,1,NULL,NULL),
(5,5,1,NULL,NULL),
(6,6,1,NULL,NULL),
(7,7,1,NULL,NULL),
(8,8,1,NULL,NULL),
(9,9,1,NULL,NULL),
(10,1,2,NULL,NULL),
(12,3,1,NULL,NULL),
(13,10,1,NULL,NULL),
(14,11,1,NULL,NULL),
(15,12,1,NULL,NULL),
(16,13,1,NULL,NULL),
(17,14,1,NULL,NULL),
(18,15,1,NULL,NULL),
(19,16,1,NULL,NULL),
(22,18,1,NULL,NULL),
(23,19,1,NULL,NULL),
(24,20,1,NULL,NULL),
(25,21,1,NULL,NULL),
(26,22,1,NULL,NULL),
(27,23,1,NULL,NULL),
(28,24,1,NULL,NULL),
(29,25,1,NULL,NULL),
(30,26,1,NULL,NULL),
(31,27,1,NULL,NULL),
(32,28,1,NULL,NULL),
(33,29,1,NULL,NULL),
(34,30,1,NULL,NULL),
(35,31,1,NULL,NULL),
(36,32,1,NULL,NULL),
(37,33,1,NULL,NULL),
(38,34,1,NULL,NULL),
(39,1,3,NULL,NULL),
(40,35,1,NULL,NULL),
(41,36,1,NULL,NULL),
(42,37,1,NULL,NULL),
(43,38,1,NULL,NULL),
(44,40,1,NULL,NULL),
(45,39,1,NULL,NULL),
(121,19,2,NULL,NULL),
(122,23,2,NULL,NULL),
(123,24,2,NULL,NULL),
(124,25,2,NULL,NULL),
(125,26,2,NULL,NULL),
(126,1,4,NULL,NULL),
(127,2,4,NULL,NULL),
(128,3,4,NULL,NULL),
(129,4,4,NULL,NULL),
(130,5,4,NULL,NULL),
(131,6,4,NULL,NULL),
(132,7,4,NULL,NULL),
(133,8,4,NULL,NULL),
(134,9,4,NULL,NULL),
(135,10,4,NULL,NULL),
(136,11,4,NULL,NULL),
(137,12,4,NULL,NULL),
(138,13,4,NULL,NULL),
(139,14,4,NULL,NULL),
(140,15,4,NULL,NULL),
(141,16,4,NULL,NULL),
(142,18,4,NULL,NULL),
(143,19,4,NULL,NULL),
(144,20,4,NULL,NULL),
(145,21,4,NULL,NULL),
(146,22,4,NULL,NULL),
(147,23,4,NULL,NULL),
(148,24,4,NULL,NULL),
(149,25,4,NULL,NULL),
(150,26,4,NULL,NULL),
(151,27,4,NULL,NULL),
(152,28,4,NULL,NULL),
(153,29,4,NULL,NULL),
(154,30,4,NULL,NULL),
(155,31,4,NULL,NULL),
(156,32,4,NULL,NULL),
(157,33,4,NULL,NULL),
(158,34,4,NULL,NULL),
(159,40,4,NULL,NULL),
(160,35,4,NULL,NULL),
(161,36,4,NULL,NULL),
(162,37,4,NULL,NULL),
(163,38,4,NULL,NULL),
(164,39,4,NULL,NULL),
(165,2,3,NULL,NULL),
(166,3,3,NULL,NULL),
(167,4,3,NULL,NULL),
(168,5,3,NULL,NULL),
(169,6,3,NULL,NULL),
(170,7,3,NULL,NULL),
(171,8,3,NULL,NULL),
(172,9,3,NULL,NULL),
(173,10,3,NULL,NULL),
(174,11,3,NULL,NULL),
(175,12,3,NULL,NULL),
(176,13,3,NULL,NULL),
(177,14,3,NULL,NULL),
(178,15,3,NULL,NULL),
(179,16,3,NULL,NULL),
(180,18,3,NULL,NULL),
(181,19,3,NULL,NULL),
(182,20,3,NULL,NULL),
(183,21,3,NULL,NULL),
(184,22,3,NULL,NULL),
(193,31,3,NULL,NULL),
(194,32,3,NULL,NULL),
(195,33,3,NULL,NULL),
(196,34,3,NULL,NULL),
(197,40,3,NULL,NULL),
(198,35,3,NULL,NULL),
(199,36,3,NULL,NULL),
(200,37,3,NULL,NULL),
(201,38,3,NULL,NULL),
(202,39,3,NULL,NULL),
(203,41,3,NULL,NULL),
(204,42,3,NULL,NULL),
(205,43,3,NULL,NULL),
(206,44,3,NULL,NULL),
(207,41,1,NULL,NULL),
(208,42,1,NULL,NULL),
(209,43,1,NULL,NULL),
(210,44,1,NULL,NULL),
(211,41,2,NULL,NULL),
(212,42,2,NULL,NULL),
(213,43,2,NULL,NULL),
(214,44,2,NULL,NULL),
(219,49,1,NULL,NULL),
(220,50,1,NULL,NULL),
(221,51,1,NULL,NULL),
(222,52,1,NULL,NULL),
(223,53,1,NULL,NULL),
(224,1,5,NULL,NULL),
(226,1,6,NULL,NULL),
(227,54,1,NULL,NULL),
(228,55,1,NULL,NULL),
(229,56,1,NULL,NULL),
(230,57,1,NULL,NULL),
(231,58,1,NULL,NULL),
(232,59,1,NULL,NULL),
(233,60,1,NULL,NULL),
(234,61,1,NULL,NULL),
(235,62,1,NULL,NULL),
(236,63,1,NULL,NULL),
(237,64,1,NULL,NULL),
(238,65,1,NULL,NULL),
(239,66,1,NULL,NULL),
(240,67,1,NULL,NULL),
(241,68,1,NULL,NULL),
(242,1,7,NULL,NULL),
(243,2,7,NULL,NULL),
(244,3,7,NULL,NULL),
(245,4,7,NULL,NULL),
(246,5,7,NULL,NULL),
(247,6,7,NULL,NULL),
(248,7,7,NULL,NULL),
(249,8,7,NULL,NULL),
(250,9,7,NULL,NULL),
(251,10,7,NULL,NULL),
(252,11,7,NULL,NULL),
(253,12,7,NULL,NULL),
(254,13,7,NULL,NULL),
(255,14,7,NULL,NULL),
(256,15,7,NULL,NULL),
(257,16,7,NULL,NULL),
(258,18,7,NULL,NULL),
(259,19,7,NULL,NULL),
(260,20,7,NULL,NULL),
(261,21,7,NULL,NULL),
(262,22,7,NULL,NULL),
(263,23,7,NULL,NULL),
(264,24,7,NULL,NULL),
(265,25,7,NULL,NULL),
(266,26,7,NULL,NULL),
(267,27,7,NULL,NULL),
(268,28,7,NULL,NULL),
(269,29,7,NULL,NULL),
(270,30,7,NULL,NULL),
(271,49,7,NULL,NULL),
(272,31,7,NULL,NULL),
(273,32,7,NULL,NULL),
(274,33,7,NULL,NULL),
(275,34,7,NULL,NULL),
(276,40,7,NULL,NULL),
(277,35,7,NULL,NULL),
(278,36,7,NULL,NULL),
(279,37,7,NULL,NULL),
(280,38,7,NULL,NULL),
(281,39,7,NULL,NULL),
(282,41,7,NULL,NULL),
(283,42,7,NULL,NULL),
(284,43,7,NULL,NULL),
(285,44,7,NULL,NULL),
(286,50,7,NULL,NULL),
(287,51,7,NULL,NULL),
(288,52,7,NULL,NULL),
(289,53,7,NULL,NULL),
(290,54,7,NULL,NULL),
(291,60,7,NULL,NULL),
(292,55,7,NULL,NULL),
(293,56,7,NULL,NULL),
(294,57,7,NULL,NULL),
(295,58,7,NULL,NULL),
(296,59,7,NULL,NULL),
(297,61,7,NULL,NULL),
(298,62,7,NULL,NULL),
(299,63,7,NULL,NULL),
(300,64,7,NULL,NULL),
(301,65,7,NULL,NULL),
(302,66,7,NULL,NULL),
(303,67,7,NULL,NULL),
(304,68,7,NULL,NULL),
(305,1,8,NULL,NULL),
(306,2,8,NULL,NULL),
(307,3,8,NULL,NULL),
(308,4,8,NULL,NULL),
(309,5,8,NULL,NULL),
(310,6,8,NULL,NULL),
(311,7,8,NULL,NULL),
(312,8,8,NULL,NULL),
(313,9,8,NULL,NULL),
(314,10,8,NULL,NULL),
(315,11,8,NULL,NULL),
(316,12,8,NULL,NULL),
(317,13,8,NULL,NULL),
(318,14,8,NULL,NULL),
(319,15,8,NULL,NULL),
(320,16,8,NULL,NULL),
(321,18,8,NULL,NULL),
(322,19,8,NULL,NULL),
(323,20,8,NULL,NULL),
(324,21,8,NULL,NULL),
(325,22,8,NULL,NULL),
(326,23,8,NULL,NULL),
(327,24,8,NULL,NULL),
(328,25,8,NULL,NULL),
(329,26,8,NULL,NULL),
(330,27,8,NULL,NULL),
(331,28,8,NULL,NULL),
(332,29,8,NULL,NULL),
(333,30,8,NULL,NULL),
(334,49,8,NULL,NULL),
(335,31,8,NULL,NULL),
(336,32,8,NULL,NULL),
(337,33,8,NULL,NULL),
(338,34,8,NULL,NULL),
(339,40,8,NULL,NULL),
(340,35,8,NULL,NULL),
(341,36,8,NULL,NULL),
(342,37,8,NULL,NULL),
(343,38,8,NULL,NULL),
(344,39,8,NULL,NULL),
(345,41,8,NULL,NULL),
(346,42,8,NULL,NULL),
(347,43,8,NULL,NULL),
(348,44,8,NULL,NULL),
(349,50,8,NULL,NULL),
(350,51,8,NULL,NULL),
(351,52,8,NULL,NULL),
(352,53,8,NULL,NULL),
(353,54,8,NULL,NULL),
(354,60,8,NULL,NULL),
(355,55,8,NULL,NULL),
(356,56,8,NULL,NULL),
(357,57,8,NULL,NULL),
(358,58,8,NULL,NULL),
(359,59,8,NULL,NULL),
(360,61,8,NULL,NULL),
(361,62,8,NULL,NULL),
(362,63,8,NULL,NULL),
(363,64,8,NULL,NULL),
(364,65,8,NULL,NULL),
(365,66,8,NULL,NULL),
(366,67,8,NULL,NULL),
(367,68,8,NULL,NULL),
(368,1,9,NULL,NULL),
(369,2,9,NULL,NULL),
(370,3,9,NULL,NULL),
(371,4,9,NULL,NULL),
(372,5,9,NULL,NULL),
(373,6,9,NULL,NULL),
(374,7,9,NULL,NULL),
(375,8,9,NULL,NULL),
(376,9,9,NULL,NULL),
(377,10,9,NULL,NULL),
(378,11,9,NULL,NULL),
(379,12,9,NULL,NULL),
(380,13,9,NULL,NULL),
(381,14,9,NULL,NULL),
(382,15,9,NULL,NULL),
(383,16,9,NULL,NULL),
(384,18,9,NULL,NULL),
(385,19,9,NULL,NULL),
(386,20,9,NULL,NULL),
(387,21,9,NULL,NULL),
(388,22,9,NULL,NULL),
(389,23,9,NULL,NULL),
(390,24,9,NULL,NULL),
(391,25,9,NULL,NULL),
(392,26,9,NULL,NULL),
(393,27,9,NULL,NULL),
(394,28,9,NULL,NULL),
(395,29,9,NULL,NULL),
(396,30,9,NULL,NULL),
(397,49,9,NULL,NULL),
(398,31,9,NULL,NULL),
(399,32,9,NULL,NULL),
(400,33,9,NULL,NULL),
(401,34,9,NULL,NULL),
(402,40,9,NULL,NULL),
(403,35,9,NULL,NULL),
(404,36,9,NULL,NULL),
(405,37,9,NULL,NULL),
(406,38,9,NULL,NULL),
(407,39,9,NULL,NULL),
(408,41,9,NULL,NULL),
(409,42,9,NULL,NULL),
(410,43,9,NULL,NULL),
(411,44,9,NULL,NULL),
(412,50,9,NULL,NULL),
(413,51,9,NULL,NULL),
(414,52,9,NULL,NULL),
(415,53,9,NULL,NULL),
(416,54,9,NULL,NULL),
(417,60,9,NULL,NULL),
(418,55,9,NULL,NULL),
(419,56,9,NULL,NULL),
(420,57,9,NULL,NULL),
(421,58,9,NULL,NULL),
(422,59,9,NULL,NULL),
(423,61,9,NULL,NULL),
(424,62,9,NULL,NULL),
(425,63,9,NULL,NULL),
(426,64,9,NULL,NULL),
(427,65,9,NULL,NULL),
(428,66,9,NULL,NULL),
(429,67,9,NULL,NULL),
(430,68,9,NULL,NULL),
(431,55,3,NULL,NULL),
(432,56,3,NULL,NULL),
(433,51,2,NULL,NULL),
(434,52,2,NULL,NULL),
(435,53,2,NULL,NULL),
(436,55,2,NULL,NULL),
(437,56,2,NULL,NULL),
(438,57,2,NULL,NULL),
(439,58,2,NULL,NULL),
(440,59,2,NULL,NULL),
(441,50,2,NULL,NULL),
(442,27,2,NULL,NULL),
(446,49,2,NULL,NULL),
(447,69,1,NULL,NULL);

/*Table structure for table `permissions` */


CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `module_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permissions_module_id_foreign` (`module_id`),
  CONSTRAINT `permissions_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `permissions` */

insert  into `permissions`(`id`,`module_id`,`name`,`slug`,`deleted_at`,`created_at`,`updated_at`) values 
(1,1,'Access Dashboard','home',NULL,'2021-06-30 12:08:30','2021-06-30 12:08:30'),
(2,2,'Access Role','roles.index',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(3,2,'Create Role','roles.create',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(4,2,'Edit Role','roles.edit',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(5,2,'Delete Role','roles.destroy',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(6,3,'Access User','users.index',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(7,3,'Create Users','users.create',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(8,3,'Edit User','users.edit',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(9,3,'Delete User','users.destroy',NULL,'2021-06-30 12:08:31','2021-06-30 12:08:31'),
(10,4,'Access Module','modules.index',NULL,'2021-07-04 07:50:04','2021-07-04 07:50:04'),
(11,4,'Create Module','modules.create',NULL,'2021-07-04 08:40:12','2021-07-04 08:40:12'),
(12,4,'Edit  Module','modules.edit',NULL,'2021-07-04 08:41:03','2021-07-04 08:41:03'),
(13,4,'Delete Module','modules.destroy',NULL,'2021-07-04 08:42:00','2021-09-06 06:08:04'),
(14,5,'Permission Access','permissions.index',NULL,'2021-07-04 08:56:30','2021-07-04 08:56:30'),
(15,5,'Permission Create','permissions.create',NULL,'2021-07-04 08:56:57','2021-07-04 08:56:57'),
(16,5,'Permission Edit','permissions.edit',NULL,'2021-07-04 08:57:35','2021-07-04 08:57:35'),
(18,5,'Permission Delete','permissions.destroy',NULL,'2021-07-04 12:13:54','2021-09-06 06:08:32'),
(19,6,'Access Batch','batch.index',NULL,'2021-08-18 01:50:18','2021-08-18 01:50:18'),
(20,6,'Create Batch','batch.create',NULL,'2021-08-18 01:50:59','2021-08-18 01:50:59'),
(21,6,'Batch Edit','batch.edit',NULL,'2021-08-18 01:51:50','2021-08-18 01:51:50'),
(22,6,'Batch Delete','batch.destroy',NULL,'2021-08-18 01:53:32','2021-08-18 01:53:32'),
(23,7,'Access Attendance','attendance.index',NULL,'2021-08-18 02:41:28','2021-08-18 02:41:28'),
(24,7,'Create Attendance','attendance.create',NULL,'2021-08-18 02:42:22','2021-08-18 02:42:22'),
(25,7,'Edit Attendance','attendance.edit',NULL,'2021-08-18 02:43:21','2021-08-18 02:43:21'),
(26,7,'Delete Attendance','attendance.delete',NULL,'2021-08-18 02:45:00','2021-08-18 02:45:00'),
(27,8,'Access Feedback','feedback.index',NULL,'2021-09-02 03:32:39','2021-09-02 03:32:39'),
(28,8,'Feedback Create','feedback.create',NULL,'2021-09-02 03:32:52','2021-09-02 03:32:52'),
(29,8,'Feedback Edit','feedback.edit',NULL,'2021-09-02 03:33:07','2021-09-02 03:33:07'),
(30,8,'Feedback Delete','feedback.destroy',NULL,'2021-09-02 03:33:18','2021-09-02 03:33:18'),
(31,9,'Access Trainee','trainee.index',NULL,'2021-09-02 09:10:20','2021-09-02 09:10:20'),
(32,9,'Trainee Create','trainee.create',NULL,'2021-09-02 09:10:44','2021-09-02 09:10:44'),
(33,9,'Edit Trainee','trainee.edit',NULL,'2021-09-02 09:11:07','2021-09-02 09:11:07'),
(34,9,'Trainee Delete','trainee.destroy',NULL,'2021-09-02 09:11:44','2021-09-02 09:11:44'),
(35,10,'Access Trainer','trainer.index',NULL,'2021-09-05 10:44:42','2021-09-05 10:44:42'),
(36,10,'Create Trainer','trainer.create',NULL,'2021-09-05 10:45:05','2021-09-05 10:45:05'),
(37,10,'Edit Trainer','trainer.edit',NULL,'2021-09-05 10:45:36','2021-09-05 10:45:36'),
(38,10,'Delete Trainer','trainer.destroy',NULL,'2021-09-05 10:45:59','2021-09-05 10:45:59'),
(39,10,'Trainer View','trainer.show',NULL,'2021-09-06 05:25:15','2021-09-06 05:26:23'),
(40,9,'Trainee View','trainee.show',NULL,'2021-09-06 05:25:34','2021-09-06 05:26:33'),
(41,11,'Exam','exam.index',NULL,'2021-09-07 05:14:09','2021-09-07 05:15:42'),
(42,11,'Exam Create','exam.create',NULL,'2021-09-07 05:14:46','2021-09-07 05:14:46'),
(43,11,'Exam Edit','exam.edit',NULL,'2021-09-07 05:15:13','2021-09-07 05:15:30'),
(44,11,'Exam Delete','exam.destroy',NULL,'2021-09-07 05:16:16','2021-09-07 10:33:36'),
(49,8,'Feedback Manage','feedback.manage',NULL,'2021-10-14 03:59:25','2021-10-14 03:59:25'),
(50,14,'Feedback Question','feedbackquestion.index',NULL,'2021-10-14 06:08:45','2021-10-14 06:08:45'),
(51,14,'Feedback Question Create','feedbackquestion.create',NULL,'2021-10-14 06:09:22','2021-10-14 06:09:22'),
(52,14,'Feedback Question Edit','feedbackquestion.edit',NULL,'2021-10-14 06:10:01','2021-10-14 06:10:01'),
(53,14,'Feedback Question Delete','feedbackquestion.destroy',NULL,'2021-10-14 06:10:26','2021-10-14 06:10:26'),
(54,15,'View Group','assignment.index',NULL,'2021-10-25 04:15:57','2021-10-28 12:31:52'),
(55,16,'Feedback Answer Index','feedbackanswer.index',NULL,'2021-10-25 04:49:27','2021-10-25 04:49:27'),
(56,17,'Repository Index','repository.index',NULL,'2021-10-25 10:55:01','2021-10-25 10:55:01'),
(57,17,'Repository Create','repository.create',NULL,'2021-10-25 10:55:35','2021-10-25 10:55:35'),
(58,17,'Repository Edit','repository.edit',NULL,'2021-10-25 10:56:01','2021-10-25 10:56:01'),
(59,17,'Repository Delete','repository.destroy',NULL,'2021-10-25 10:56:39','2021-10-25 10:56:39'),
(60,15,'Create Group','assignment.create',NULL,'2021-10-28 12:31:28','2021-10-28 12:31:28'),
(61,18,'Course Access','course.index',NULL,'2021-11-10 10:09:39','2021-11-10 10:10:17'),
(62,18,'Create Course','course.create',NULL,'2021-11-10 10:10:45','2021-11-10 10:11:28'),
(63,18,'Edit Course','course.edit',NULL,'2021-11-10 10:11:46','2021-11-10 10:11:46'),
(64,18,'Delete Course','course.destroy',NULL,'2021-11-10 10:12:12','2021-11-10 10:16:39'),
(65,19,'Venue Access','venue.index',NULL,'2021-11-10 12:14:25','2021-11-10 12:14:25'),
(66,19,'Venue Create','venue.create',NULL,'2021-11-10 12:14:52','2021-11-10 12:14:52'),
(67,19,'Venue Edit','venue.edit',NULL,'2021-11-10 12:15:34','2021-11-10 12:15:34'),
(68,19,'Venue Delete','venue.destroy',NULL,'2021-11-10 12:15:54','2021-11-10 12:15:54'),
(69,20,'certificate check','certificate.check',NULL,'2021-12-21 14:27:12','2021-12-21 14:27:12');

/*Table structure for table `question_answers` */


CREATE TABLE `question_answers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `setquestion_id` bigint(20) unsigned NOT NULL,
  `answer` longtext 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 `question_answers_setquestion_id_foreign` (`setquestion_id`),
  CONSTRAINT `question_answers_setquestion_id_foreign` FOREIGN KEY (`setquestion_id`) REFERENCES `set_questions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `question_answers` */

insert  into `question_answers`(`id`,`setquestion_id`,`answer`,`deleted_at`,`created_at`,`updated_at`) values 
(3,3,'6',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(4,4,'12',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(7,7,NULL,NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(8,8,'17',NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(9,10,'21',NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(10,16,'25',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(11,17,'30',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56');

/*Table structure for table `question_banks` */


CREATE TABLE `question_banks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_banks_user_id_foreign` (`user_id`),
  CONSTRAINT `question_banks_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `question_banks` */

insert  into `question_banks`(`id`,`title`,`slug`,`description`,`user_id`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Part A MCQ Test','about-vue-js','<h1 class=\"m-0 text-dark\" style=\"font-family: &quot;Source Sans Pro&quot;, -apple-system, BlinkMacSystemFont, &quot;Segoe UI&quot;, Roboto, &quot;Helvetica Neue&quot;, Arial, sans-serif, &quot;Apple Color Emoji&quot;, &quot;Segoe UI Emoji&quot;, &quot;Segoe UI Symbol&quot;; font-size: 1.8rem; background-color: rgb(244, 246, 249);\">Question Bank Create</h1>',1,'2021-09-20 06:17:29','2021-09-01 11:18:38','2021-09-20 06:17:29'),
(2,'About Lumne','about-lumne','<div class=\"text padding-top-0-0-0 padding-bottom-0-0-0 table aem-GridColumn--tablet--20 aem-GridColumn--default--none aem-GridColumn--phone--none aem-GridColumn--tablet--none aem-GridColumn--default--9 aem-GridColumn aem-GridColumn--phone--20 aem-GridColumn--offset--phone--2 aem-GridColumn--offset--default--1 aem-GridColumn--offset--tablet--2\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; clear: none; overflow: auto hidden; max-width: 100vw; float: left; width: 507.75px; margin-left: 56.4062px; color: rgb(51, 51, 51); font-family: Gotham-book, Arial, Helvetica; padding-top: 0px !important; padding-bottom: 0px !important;\"><div class=\"text padding-top-0-0-0 , padding-bottom-0-0-0 \" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; padding-top: 0px !important; padding-bottom: 0px !important;\"><div class=\"chi-text-wrapper\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; display: flex; position: relative;\"><div class=\"chi text-wrapper\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; line-height: 26px; --color-background-primary:#0075c9; --color-background-secondary:#38c6f4; --color-link-cta-icon:#e77528; --color-marketing-icon-primary:#083176; --color-marketing-icon-secondary:#f79950; --color-marketing-icon-shadow:#38c6f4; font-size: 18px; -webkit-box-flex: 1; flex: 1 1 0%; padding-left: 0px;\"><div class=\"cmp-text table\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; overflow: auto hidden; max-width: 100vw;\"><div id=\"text-d592a1b1b5\" class=\"cmp-text\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none;\"><p style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; margin: initial; font-size: inherit; line-height: inherit; font-family: inherit; color: inherit; font-style: inherit; font-weight: inherit;\"><span class=\"font-18-26__18-26__16-24\" data-pluginid=\"FontSizePlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; line-height: 26px;\"><span class=\"black\" data-pluginid=\"FontColorsPlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; color: rgb(0, 0, 0);\">Lumen is a multinational technology company that enables companies to capitalize on emerging applications and power the 4th Industrial Revolution (4IR). This revolution is redefining how we live and work, creating an unprecedented need for an advanced application delivery architecture—designed specifically to handle the complex and data-intensive workloads of next-gen technology and businesses.</span></span></p><p style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; margin: initial; font-size: inherit; line-height: inherit; font-family: inherit; color: inherit; font-style: inherit; font-weight: inherit;\"><span class=\"font-18-26__18-26__16-24\" data-pluginid=\"FontSizePlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; line-height: 26px;\"><span class=\"black\" data-pluginid=\"FontColorsPlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; color: rgb(0, 0, 0);\">&nbsp;</span></span></p><p style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; margin: initial; font-size: inherit; line-height: inherit; font-family: inherit; color: inherit; font-style: inherit; font-weight: inherit;\"><span class=\"font-18-26__18-26__16-24\" data-pluginid=\"FontSizePlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; line-height: 26px;\"><span class=\"black\" data-pluginid=\"FontColorsPlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; color: rgb(0, 0, 0);\">We integrate network assets, cloud connectivity, security solutions and voice and collaboration tools into one platform that enables businesses to leverage their data and adopt next-generation technologies.</span></span></p><p style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; margin: initial; font-size: inherit; line-height: inherit; font-family: inherit; color: inherit; font-style: inherit; font-weight: inherit;\"><span class=\"font-18-26__18-26__16-24\" data-pluginid=\"FontSizePlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; line-height: 26px;\"><span class=\"black\" data-pluginid=\"FontColorsPlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; color: rgb(0, 0, 0);\">&nbsp;</span></span></p><p style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; margin: initial; font-size: inherit; line-height: inherit; font-family: inherit; color: inherit; font-style: inherit; font-weight: inherit;\"><span class=\"font-18-26__18-26__16-24\" data-pluginid=\"FontSizePlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; line-height: 26px;\"><span class=\"black\" data-pluginid=\"FontColorsPlugin\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; color: rgb(0, 0, 0);\">Lumen brings together the talent, experience, infrastructure and capabilities of CenturyLink, Level 3 and 25+ other technology companies to create a new kind of company—one designed specifically to address the dynamic data and application needs of the 4th Industrial Revolution.</span></span></p></div></div></div></div></div></div><div class=\"container responsivegrid padding-top-100-80-60 padding-bottom-100-80-60 aem-GridColumn--default--none aem-GridColumn aem-GridColumn--default--24 aem-GridColumn--offset--default--0\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; clear: none; float: left; width: 1354px; margin-left: 0px; color: rgb(51, 51, 51); font-family: Gotham-book, Arial, Helvetica; padding-top: 100px !important; padding-bottom: 100px !important;\"><div id=\"container-d337db32e4\" class=\"cmp-container\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none;\"><div class=\"aem-Grid aem-Grid--default--24 aem-Grid--tablet--24 aem-Grid--smallDesktop--24 aem-Grid--phone--24 \" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; width: 1354px;\"><div class=\"container responsivegrid OneLinkHide_en_IN aem-GridColumn--offset--smallDesktop--0 aem-GridColumn--default--none aem-GridColumn--phone--24 aem-GridColumn--offset--phone--0 aem-GridColumn--offset--default--0 aem-GridColumn--offset--tablet--0 aem-GridColumn--smallDesktop--none aem-GridColumn--phone--none aem-GridColumn--tablet--none aem-GridColumn aem-GridColumn--default--13 aem-GridColumn--smallDesktop--14 aem-GridColumn--tablet--24\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; clear: none; float: left; width: 733.406px; margin-left: 0px;\"><div id=\"container-9efa38fe64\" class=\"cmp-container\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none;\"><div class=\"aem-Grid aem-Grid--default--13 aem-Grid--phone--24 aem-Grid--tablet--24 aem-Grid--smallDesktop--14 \" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; width: 733.406px;\"><div class=\"image padding-top-0-0-0 , padding-bottom-0-0-0 aem-GridColumn--offset--smallDesktop--0 aem-GridColumn--default--none aem-GridColumn--phone--24 aem-GridColumn--offset--phone--0 aem-GridColumn--offset--default--0 aem-GridColumn--offset--tablet--0 aem-GridColumn--smallDesktop--none aem-GridColumn--phone--none aem-GridColumn--tablet--none aem-GridColumn aem-GridColumn--default--13 aem-GridColumn--smallDesktop--14 aem-GridColumn--tablet--24\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; clear: none; float: left; width: 733.406px; margin-left: 0px; padding-top: 0px !important; padding-bottom: 0px !important;\"><div class=\"lazy-background\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none; background: 0px center;\"><picture style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none;\"><source media=\"(max-width: 425px)\" srcset=\"https://assets.lumen.com/is/image/Lumen/image-about-us-empowering-people-mobile?Creativeid=560cb57c-ba2e-4796-9f0f-49a397f120bc\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none;\"><source media=\"(max-width: 768px)\" srcset=\"https://assets.lumen.com/is/image/Lumen/image-larry-about-us-empowering-people-tablet?Creativeid=3e6c228a-da3a-4753-bf65-dcb624a1eb9a\" style=\"-webkit-font-smoothing: antialiased; text-rendering: optimizelegibility; outline: none;\"></picture></div></div></div></div></div></div></div></div>',2,'2021-11-28 12:42:57','2021-09-02 03:34:56','2021-11-28 12:42:57'),
(3,'about laravel','about-laravel','<span style=\"color: rgb(32, 33, 36); font-family: arial, sans-serif;\">Laravel is a&nbsp;</span><b style=\"color: rgb(32, 33, 36); font-family: arial, sans-serif;\">web application framework with expressive, elegant syntax</b><span style=\"color: rgb(32, 33, 36); font-family: arial, sans-serif;\">. ... Laravel attempts to take the pain out of development by easing common tasks used in the majority of web projects, such as authentication, routing, sessions, and caching.</span>',1,'2021-09-22 06:56:51','2021-09-02 06:31:56','2021-09-22 06:56:51'),
(4,'Mid Exam','mid-exam','This is Mid Tram Exam.Total Exam 30 marks',2,NULL,'2021-09-21 04:01:53','2021-10-13 05:18:20'),
(5,'English','english','yugtguytfgyruty y ygutyu ytt67y 76tt78&nbsp; &nbsp;7y7 t&nbsp; 8y87 yt67t 68t t76tgyugyugyt 76tuygyutgyu 6ghgt',1,NULL,'2021-09-22 04:15:51','2021-11-01 12:18:19'),
(6,'Math','math','Edit Math Exam',1,NULL,'2021-09-22 05:39:49','2021-11-01 12:17:49'),
(7,'bangla','bangla','ohojhipoioup ooijhiouiuo huhhu&nbsp;',1,'2021-09-22 06:55:40','2021-09-22 05:40:33','2021-09-22 06:55:40'),
(8,'Mid Exam','mid-exam','This is Mid Tram Exam.Total Exam 30 marks',23,NULL,'2021-10-13 05:21:43','2021-11-01 12:17:43'),
(9,'Test Exam create','test-exam-create','Bangladesh dsfads fdsgasf',1,'2021-11-01 11:49:48','2021-11-01 11:33:21','2021-11-01 11:49:48'),
(10,'Test Exam','test-exam','This Is Test Exam',1,NULL,'2021-11-11 10:23:41','2021-11-11 10:23:41'),
(11,'ICT123','ict123','Information and Communication Technology',1,NULL,'2021-11-25 08:23:17','2021-11-25 15:12:47'),
(12,'Test 1234556667','test-1234556667','This is Test Subject Create .How It Work..........................................................................................................',1,NULL,'2021-11-28 12:25:25','2021-11-28 12:25:25'),
(13,'ICT','ict','ICT test',1,NULL,'2021-12-19 10:35:27','2021-12-19 10:35:27'),
(14,'English 2','english-2','Grammar',1,NULL,'2021-12-23 11:54:04','2021-12-23 11:54:04');

/*Table structure for table `question_mcqs` */


CREATE TABLE `question_mcqs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `setquestion_id` bigint(20) unsigned NOT NULL,
  `option` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `question_mcqs_setquestion_id_foreign` (`setquestion_id`),
  CONSTRAINT `question_mcqs_setquestion_id_foreign` FOREIGN KEY (`setquestion_id`) REFERENCES `set_questions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `question_mcqs` */

insert  into `question_mcqs`(`id`,`setquestion_id`,`option`,`deleted_at`,`created_at`,`updated_at`) values 
(5,3,'watches',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(6,3,'have watched',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(7,3,'had watched',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(8,3,'was watching',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(9,4,'have been living',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(10,4,'has been living',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(11,4,'have lived',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(12,4,'living',NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(17,8,'Linux',NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(18,8,'windows XP',NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(19,8,'None',NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(20,8,'windows 10',NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(21,10,'cache:clear',NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(22,10,'cache:remove',NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(23,10,'cache:forget',NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(24,10,'cache:flush',NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(25,16,'It clears all the viruses and trojans from your system.',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(26,16,'it keeps you from downloading internet files.',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(27,16,'It stops you from accessing the internet.',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(28,16,'It messes with your computers operating system?',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(29,17,'No',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(30,17,'Confirm Yes',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(31,17,'Not sure',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56'),
(32,17,'1 and 2',NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56');

/*Table structure for table `questionnaires` */


CREATE TABLE `questionnaires` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `questions` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `questionnaires` */

/*Table structure for table `questions` */


CREATE TABLE `questions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `examtype_id` bigint(20) unsigned NOT NULL,
  `chapter_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `difficult_level` int(11) NOT NULL,
  `is_bank` tinyint(1) NOT NULL DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `questions_user_id_foreign` (`user_id`),
  KEY `questions_examtype_id_foreign` (`examtype_id`),
  KEY `questions_chapter_id_foreign` (`chapter_id`),
  CONSTRAINT `questions_chapter_id_foreign` FOREIGN KEY (`chapter_id`) REFERENCES `topic_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_examtype_id_foreign` FOREIGN KEY (`examtype_id`) REFERENCES `exam_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `questions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `questions` */

insert  into `questions`(`id`,`examtype_id`,`chapter_id`,`user_id`,`difficult_level`,`is_bank`,`deleted_at`,`created_at`,`updated_at`) values 
(8,2,21,1,1,1,NULL,'2021-12-05 10:18:39','2021-12-05 10:18:39'),
(9,3,19,1,2,1,NULL,'2021-12-05 10:18:57','2021-12-19 12:07:45'),
(10,1,22,1,2,1,NULL,'2021-12-08 09:22:10','2021-12-08 09:22:10'),
(11,3,23,1,1,0,NULL,'2021-12-19 10:37:48','2021-12-19 10:46:17');

/*Table structure for table `repositories` */


CREATE TABLE `repositories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `program_id` bigint(20) unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `repositories_user_id_foreign` (`user_id`),
  CONSTRAINT `repositories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `repositories` */

insert  into `repositories`(`id`,`program_id`,`title`,`user_id`,`deleted_at`,`created_at`,`updated_at`) values 
(1,1,'first title',23,NULL,'2021-11-08 16:46:23','2021-11-08 16:46:23'),
(2,1,'first title',23,NULL,'2021-11-08 17:09:25','2021-11-08 17:09:25'),
(3,2,'try',23,NULL,'2021-11-09 09:59:57','2021-11-10 16:33:20'),
(4,4,'ding',23,NULL,'2021-11-09 15:44:25','2021-11-10 16:06:03'),
(10,2,'thursday edit',23,NULL,'2021-11-11 12:15:08','2021-11-11 14:32:15'),
(11,1,'reference',36,NULL,'2021-11-16 10:23:24','2021-11-16 10:23:24');

/*Table structure for table `repository_files` */


CREATE TABLE `repository_files` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `repository_id` bigint(20) unsigned NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_size` bigint(20) unsigned DEFAULT NULL,
  `extension` varchar(255) 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 `repository_files_repository_id_foreign` (`repository_id`),
  CONSTRAINT `repository_files_repository_id_foreign` FOREIGN KEY (`repository_id`) REFERENCES `repositories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `repository_files` */

insert  into `repository_files`(`id`,`repository_id`,`file_name`,`file_path`,`file_size`,`extension`,`deleted_at`,`created_at`,`updated_at`) values 
(1,3,'ER Diagram.pdf','uploads/repository/ER Diagram.pdf',45703,'pdf',NULL,'2021-11-11 10:16:56','2021-11-11 11:54:29'),
(2,3,'cedp.pdf','uploads/repository/cedp.pdf',265849,'pdf',NULL,'2021-11-09 09:59:57','2021-11-11 11:55:09'),
(3,4,'mobile bill (1).xlsx','uploads/repository/mobile bill (1).xlsx',11035,'xlsx',NULL,'2021-11-09 15:44:25','2021-11-11 11:52:30'),
(4,4,'ER Diagram.pdf','uploads/repository/ER Diagram.pdf',45703,'pdf',NULL,'2021-11-09 15:44:25','2021-11-11 11:52:31'),
(7,10,'SRDL_অভিভাবকদের জন্য (Responses).xlsx','uploads/repository/SRDL_অভিভাবকদের জন্য (Responses).xlsx',132131,'xlsx',NULL,'2021-11-11 12:15:09','2021-11-11 12:15:09'),
(8,10,'করোনা টেস্টের নমুনা সংগ্রহের কিয়স্ক বুথ ব্যবস্থাপনা _ পরীক্ষার ফলাফল.pdf','uploads/repository/করোনা টেস্টের নমুনা সংগ্রহের কিয়স্ক বুথ ব্যবস্থাপনা _ পরীক্ষার ফলাফল.pdf',105620,'pdf',NULL,'2021-11-11 12:15:09','2021-11-11 12:15:09'),
(9,10,'adminusermanual.pdf','uploads/repository/adminusermanual.pdf',5067692,'pdf','2021-11-11 12:55:04','2021-11-11 12:54:24','2021-11-11 12:55:04'),
(10,10,'slide 1-01.jpg','uploads/repository/slide 1-01.jpg',2623321,'jpg',NULL,'2021-11-11 12:56:03','2021-11-11 12:56:03'),
(11,10,'Monitoring Checklist.xls','uploads/repository/Monitoring Checklist.xls',56832,'xls',NULL,'2021-11-11 12:56:03','2021-11-11 12:56:03'),
(12,10,'keyboard-shortcuts-windows.pdf','uploads/repository/keyboard-shortcuts-windows.pdf',145647,'pdf','2021-11-11 14:32:03','2021-11-11 12:56:03','2021-11-11 14:32:03'),
(13,11,'Grantt_Chart_1st_Page.pdf','uploads/repository/Grantt_Chart_1st_Page.pdf',303338,'pdf',NULL,'2021-11-16 10:23:24','2021-11-16 10:23:24'),
(14,11,'IT Enable_4.xls','uploads/repository/IT Enable_4.xls',112640,'xls',NULL,'2021-11-16 10:23:24','2021-11-16 10:23:24');

/*Table structure for table `roles` */


CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delteable` tinyint(1) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `roles` */

insert  into `roles`(`id`,`name`,`slug`,`description`,`delteable`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Admin','admin','This is Admin',0,NULL,'2021-09-01 10:56:12','2021-09-01 10:56:12'),
(2,'Trainer','trainer','This is Trainer',1,NULL,'2021-09-01 10:56:12','2021-09-01 10:56:12'),
(3,'Trainee','trainee','This is Trainee',1,NULL,'2021-09-02 09:59:48','2021-09-02 09:59:48'),
(4,'Guest','guest',NULL,1,NULL,'2021-09-06 09:35:35','2021-09-06 09:35:35'),
(5,'Test','test',NULL,1,'2021-10-19 04:58:18','2021-10-19 04:52:44','2021-10-19 04:58:18'),
(6,'Test','test',NULL,1,'2021-10-19 05:20:32','2021-10-19 05:00:19','2021-10-19 05:20:32'),
(7,'Super Admin','super-admin',NULL,1,NULL,'2021-11-11 14:56:53','2021-11-11 14:56:53'),
(8,'Course Coordinator','course-coordinator',NULL,1,NULL,'2021-11-11 14:59:25','2021-11-11 14:59:25'),
(9,'Venue Coordinator','venue-coordinator',NULL,1,NULL,'2021-11-11 14:59:58','2021-11-11 14:59:58');

/*Table structure for table `set_questions` */


CREATE TABLE `set_questions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `question_id` bigint(20) unsigned NOT NULL,
  `subject_id` bigint(20) unsigned NOT NULL,
  `chapter_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `question` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `mark` int(11) NOT NULL,
  `rubric` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `draft` tinyint(4) DEFAULT 1,
  `status` tinyint(4) DEFAULT 0,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `set_questions_question_id_foreign` (`question_id`),
  KEY `set_questions_subject_id_foreign` (`subject_id`),
  KEY `set_questions_chapter_id_foreign` (`chapter_id`),
  KEY `set_questions_user_id_foreign` (`user_id`),
  CONSTRAINT `set_questions_chapter_id_foreign` FOREIGN KEY (`chapter_id`) REFERENCES `topic_types` (`id`) ON DELETE CASCADE,
  CONSTRAINT `set_questions_question_id_foreign` FOREIGN KEY (`question_id`) REFERENCES `questions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `set_questions_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `question_banks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `set_questions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `set_questions` */

insert  into `set_questions`(`id`,`question_id`,`subject_id`,`chapter_id`,`user_id`,`question`,`mark`,`rubric`,`draft`,`status`,`deleted_at`,`created_at`,`updated_at`) values 
(3,8,11,21,1,'Rohan __________ the movie before he read the review.',2,NULL,1,0,NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(4,8,11,21,1,'He __________ in the States but he still does not have a command over the English language.',2,NULL,1,0,NULL,'2021-12-05 11:44:54','2021-12-05 11:44:54'),
(7,9,12,19,1,'What is DBMS easy definition and With Example?',2,NULL,0,1,NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(8,9,12,19,1,'Open Source Operating System..........?',2,NULL,0,1,NULL,'2021-12-07 11:44:50','2021-12-07 11:44:50'),
(9,9,12,19,1,'What is Laravel and why it is used?',5,'Laravel 2 mark and why used 3 mark',0,1,NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(10,9,12,19,1,'Artisan command to flush the application cache ?',3,'Laravel 2 mark and why used 3 mark',1,0,NULL,'2021-12-08 09:45:50','2021-12-08 09:45:50'),
(13,10,11,22,1,'View files in Laravel end in',2,'YUYUIH UIYUI',1,0,NULL,'2021-12-08 09:51:35','2021-12-08 09:51:35'),
(15,11,13,23,1,'What is hardware?',2,'Give One Example',1,0,NULL,'2021-12-19 10:43:55','2021-12-19 10:43:55'),
(16,11,13,23,1,'What does internet security do to help your computer?',1,'',0,1,NULL,'2021-12-19 10:43:55','2021-12-19 10:43:55'),
(17,11,13,23,1,'Does a Computer/Laptop have a GUI  (Graphics User Interface) .. ?',1,NULL,0,1,NULL,'2021-12-19 10:43:56','2021-12-19 10:43:56');

/*Table structure for table `submit_exam_details` */


CREATE TABLE `submit_exam_details` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `submitexam_id` bigint(20) unsigned NOT NULL,
  `setquestion_id` bigint(20) unsigned NOT NULL,
  `answer` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mark` int(11) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submit_exam_details_submitexam_id_foreign` (`submitexam_id`),
  KEY `submit_exam_details_setquestion_id_foreign` (`setquestion_id`),
  CONSTRAINT `submit_exam_details_setquestion_id_foreign` FOREIGN KEY (`setquestion_id`) REFERENCES `set_questions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `submit_exam_details_submitexam_id_foreign` FOREIGN KEY (`submitexam_id`) REFERENCES `submit_exams` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `submit_exam_details` */

insert  into `submit_exam_details`(`id`,`submitexam_id`,`setquestion_id`,`answer`,`mark`,`deleted_at`,`created_at`,`updated_at`) values 
(9,14,7,'A database management system (or DBMS) is essentially nothing more than a computerized data-keeping system. Users of the system are given facilities to perform several kinds of operations on such a system for either manipulation of the data in the database or the management of the database structure itself.',2,NULL,'2021-12-19 17:24:38','2021-12-21 10:04:08'),
(10,14,8,'17',3,NULL,'2021-12-19 17:24:38','2021-12-21 10:04:08');

/*Table structure for table `submit_exams` */


CREATE TABLE `submit_exams` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `trainee_id` bigint(20) unsigned DEFAULT NULL,
  `exam_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `submit_exams_exam_id_foreign` (`exam_id`),
  KEY `submit_exams_user_id_foreign` (`user_id`),
  KEY `submit_exams_trainee_id_foreign` (`trainee_id`),
  CONSTRAINT `submit_exams_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`) ON DELETE CASCADE,
  CONSTRAINT `submit_exams_trainee_id_foreign` FOREIGN KEY (`trainee_id`) REFERENCES `trainees` (`id`) ON DELETE CASCADE,
  CONSTRAINT `submit_exams_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `submit_exams` */

insert  into `submit_exams`(`id`,`user_id`,`trainee_id`,`exam_id`,`deleted_at`,`created_at`,`updated_at`) values 
(14,31,13,1,NULL,'2021-12-19 17:24:38','2021-12-19 17:24:38');

/*Table structure for table `topic_types` */


CREATE TABLE `topic_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `questionbank_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `learning_outcome` varchar(255) 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 `topic_types_questionbank_id_foreign` (`questionbank_id`),
  KEY `topic_types_user_id_foreign` (`user_id`),
  CONSTRAINT `topic_types_questionbank_id_foreign` FOREIGN KEY (`questionbank_id`) REFERENCES `question_banks` (`id`) ON DELETE CASCADE,
  CONSTRAINT `topic_types_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `topic_types` */

insert  into `topic_types`(`id`,`questionbank_id`,`user_id`,`name`,`learning_outcome`,`deleted_at`,`created_at`,`updated_at`) values 
(17,4,1,'2nd Chapter','sweetalert confirm submit laravel code example | Newbedev .uhisdfuyhfuiyhfui suifyiysdiufyiuas','2021-11-28 17:24:35','2021-11-28 16:19:01','2021-11-28 17:24:35'),
(18,10,1,'2nd Chapter','Laravel Sweet Alert Confirm Delete Example - NiceSnippets',NULL,'2021-11-28 16:29:28','2021-11-28 16:29:28'),
(19,12,1,'1st Chapter','1st Chapter',NULL,'2021-11-29 16:01:50','2021-11-29 16:01:50'),
(20,11,1,'1st Chapter','1st Chapter',NULL,'2021-11-29 16:01:58','2021-11-29 16:01:58'),
(21,11,1,'2nd Chapter','2nd Chapter',NULL,'2021-11-29 16:02:10','2021-11-29 16:02:10'),
(22,11,1,'3rd Chapter','3rd Chapter',NULL,'2021-11-29 16:02:30','2021-11-29 16:02:30'),
(23,13,1,'ICT TEST','knowledge about ict',NULL,'2021-12-19 10:37:20','2021-12-19 10:37:20');

/*Table structure for table `trainees` */


CREATE TABLE `trainees` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `index_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `trainee_birth` date NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `trainees_name_unique` (`name`),
  UNIQUE KEY `trainees_index_no_unique` (`index_no`),
  UNIQUE KEY `trainees_email_unique` (`email`),
  KEY `trainees_batch_id_foreign` (`batch_id`),
  KEY `trainees_user_id_foreign` (`user_id`),
  CONSTRAINT `trainees_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trainees_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `trainees` */

insert  into `trainees`(`id`,`user_id`,`batch_id`,`full_name`,`name`,`index_no`,`email`,`gender`,`trainee_birth`,`deleted_at`,`created_at`,`updated_at`) values 
(7,1,2,'Colleen Chapman','medivi','100','biqubiha@mailinator.com',2,'2021-09-15',NULL,'2021-09-08 05:37:45','2021-09-08 05:37:45'),
(8,1,1,'Ezra Hodges','rixonibop','103','fodolunupa@mailinator.com',1,'2021-09-07',NULL,'2021-09-08 05:53:21','2021-09-08 05:53:21'),
(12,1,2,'Beatrice Little','kubasemof','101','jedujujeb@mailinator.com',2,'2021-09-07',NULL,'2021-09-08 06:39:52','2021-09-08 06:39:52'),
(13,1,4,'Rudyard Morrow','poxawefu','105','nufesow@mailinator.com',2,'2021-09-07',NULL,'2021-09-08 06:43:50','2021-12-12 20:28:15'),
(15,1,4,'Norman Clemons','fadowedaz','104','bocis@mailinator.com',3,'2021-09-08',NULL,'2021-09-08 09:38:27','2021-12-12 20:28:49'),
(16,1,4,'Steve Smith','Smith','102','rtrainee@fachuki.com',2,'2021-12-01',NULL,'2021-12-02 11:42:49','2021-12-12 20:28:59'),
(17,23,4,'Shane Warne','Shane Warne','107','shanewarne@fachuki.com',1,'2021-12-23',NULL,'2021-12-22 10:06:59','2021-12-22 10:06:59');

/*Table structure for table `trainers` */


CREATE TABLE `trainers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `batch_id` bigint(20) unsigned NOT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` tinyint(4) NOT NULL,
  `trainer_birth` date NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `trainers_name_unique` (`name`),
  UNIQUE KEY `trainers_email_unique` (`email`),
  KEY `trainers_batch_id_foreign` (`batch_id`),
  KEY `trainers_user_id_foreign` (`user_id`),
  CONSTRAINT `trainers_batch_id_foreign` FOREIGN KEY (`batch_id`) REFERENCES `batches` (`id`) ON DELETE CASCADE,
  CONSTRAINT `trainers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `trainers` */

insert  into `trainers`(`id`,`user_id`,`batch_id`,`full_name`,`name`,`email`,`gender`,`trainer_birth`,`deleted_at`,`created_at`,`updated_at`) values 
(5,1,2,'Colleen Chapman','medivi','biqubiha@mailinator.com',2,'2021-09-15',NULL,'2021-09-08 05:00:52','2021-09-08 05:00:52'),
(6,1,4,'Beatrice Little','kubasemof','jedujujeb@mailinator.com',2,'2021-09-07',NULL,'2021-09-08 06:36:46','2021-12-12 20:28:24'),
(7,1,1,'Rudyard Morrow','poxawefu','nufesow@mailinator.com',2,'2021-09-07',NULL,'2021-09-08 06:44:11','2021-09-08 06:44:11'),
(8,1,2,'Norman Clemons','fadowedaz','bocis@mailinator.com',3,'2021-09-08',NULL,'2021-09-08 09:11:10','2021-09-08 09:11:10'),
(9,23,1,'David beckham','David Beckham','davidbeckham@fachuki.com',1,'2021-12-23',NULL,'2021-12-22 16:14:15','2021-12-22 16:14:15');

/*Table structure for table `venues` */


CREATE TABLE `venues` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `course_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `venues_course_id_foreign` (`course_id`),
  KEY `venues_user_id_foreign` (`user_id`),
  CONSTRAINT `venues_course_id_foreign` FOREIGN KEY (`course_id`) REFERENCES `courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `venues_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

/*Data for the table `venues` */

insert  into `venues`(`id`,`name`,`course_id`,`user_id`,`deleted_at`,`created_at`,`updated_at`) values 
(1,'Gazipur TTC',1,23,NULL,'2021-11-10 12:53:07','2021-11-10 12:53:17'),
(2,'Gazipur TTC',2,23,NULL,'2021-11-10 12:54:40','2021-11-10 12:54:40'),
(3,'Bogra TTC',1,23,NULL,'2021-12-05 15:49:47','2021-12-05 15:49:47'),
(4,'Satkhira TTC',4,23,NULL,'2021-12-05 15:50:35','2021-12-05 15:51:02'),
(5,'Khulna TTC',1,23,NULL,'2021-12-05 15:51:53','2021-12-05 15:51:53'),
(6,'Bogra TTC',5,23,NULL,'2021-12-08 14:54:48','2021-12-08 14:54:48'),
(7,'Satkhira TTC',5,23,NULL,'2021-12-08 14:55:17','2021-12-08 14:56:05'),
(8,'Bogra TTC',4,23,NULL,'2021-12-08 14:56:23','2021-12-08 14:56:23');

/* Procedure structure for procedure `RPT_ATTENDANCE_REPORT` */

/*!50003 DROP PROCEDURE IF EXISTS  `RPT_ATTENDANCE_REPORT` */;

DELIMITER $$

/*!50003 CREATE DEFINER=`root`@`localhost` PROCEDURE `RPT_ATTENDANCE_REPORT`(IN `p_course_id` INT(11),IN `p_venue_id` INT(11),IN `p_batch_id` INT(11),
in `start_date` date,in `end_date` date)
    NO SQL
BEGIN
select att.index_no,att.status,att.date,ba.name batch_name,va.name vanue_name,co.title course_name,tr.full_name 
from attendances as att
left join `batches` as ba on ba.id = att.batch_id
left join `venues` as va on va.id = ba.venue_id
left join `courses` as co on co.id = va.course_id
left join `trainees` as tr on tr.id = att.trainee_id

where (att.batch_id = p_batch_id OR p_batch_id = 0)
and (va.id = p_venue_id OR p_venue_id = 0)
and (va.course_id = p_course_id or p_course_id = 0)
AND att.`date` BETWEEN start_date AND end_date
;

END */$$
DELIMITER ;

