# ************************************************************
# Sequel Ace SQL dump
# Version 20051
#
# https://sequel-ace.com/
# https://github.com/Sequel-Ace/Sequel-Ace
#
# Host: 127.0.0.1 (MySQL 8.0.27)
# Database: schoolinn_db
# Generation Time: 2023-09-27 21:15:41 +0000
# ************************************************************




# Dump of table attendance
# ------------------------------------------------------------


CREATE TABLE `attendance` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `attendable_id` bigint unsigned DEFAULT NULL,
  `attendable_type` varchar(100) DEFAULT NULL,
  `checkin` datetime DEFAULT NULL,
  `checkout` datetime DEFAULT NULL,
  `status` enum('P','A','H','L') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `comments` longtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `attendance` (`id`, `attendable_id`, `attendable_type`, `checkin`, `checkout`, `status`, `comments`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,1,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 11:08:17','2022-11-14 12:24:30',NULL),
	(3,2,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 11:15:21','2022-11-14 12:23:43',NULL),
	(4,3,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 11:23:01','2022-11-14 12:24:26',NULL),
	(7,4,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 11:46:20','2022-11-14 12:24:29',NULL),
	(8,5,'App\\Models\\Student','2022-11-14 12:03:15',NULL,'P',NULL,'2022-11-14 11:46:24','2022-11-14 12:12:58',NULL),
	(9,6,'App\\Models\\Student','2022-11-14 12:15:11',NULL,'P',NULL,'2022-11-14 11:46:28','2022-11-14 12:17:23',NULL),
	(11,7,'App\\Models\\Student','2022-11-14 12:15:11',NULL,'P',NULL,'2022-11-14 12:18:00','2022-11-14 12:18:00',NULL),
	(12,8,'App\\Models\\Student','2022-11-14 12:15:11',NULL,'P',NULL,'2022-11-14 12:18:01','2022-11-14 12:18:01',NULL),
	(13,9,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:36','2022-11-14 12:22:36',NULL),
	(14,10,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:37','2022-11-14 12:22:37',NULL),
	(15,11,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:38','2022-11-14 12:22:38',NULL),
	(16,12,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:39','2022-11-14 12:22:39',NULL),
	(17,13,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:40','2022-11-14 12:22:40',NULL),
	(18,14,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:41','2022-11-14 12:22:41',NULL),
	(19,15,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:43','2022-11-14 12:22:43',NULL),
	(20,16,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:44','2022-11-14 12:22:44',NULL),
	(21,17,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:44','2022-11-14 12:22:44',NULL),
	(22,18,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:46','2022-11-14 12:22:46',NULL),
	(23,19,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:22:51','2022-11-14 12:22:51',NULL),
	(24,20,'App\\Models\\Student','2022-11-14 12:58:27',NULL,'P',NULL,'2022-11-14 12:22:52','2022-11-14 12:58:34',NULL),
	(25,21,'App\\Models\\Student','2022-11-14 12:19:47',NULL,'P',NULL,'2022-11-14 12:38:51','2022-11-14 12:38:55',NULL),
	(28,5,'App\\Models\\Staff','2022-11-17 11:52:03',NULL,'P',NULL,'2022-11-17 06:22:31','2022-11-17 11:54:52',NULL),
	(29,1,'App\\Models\\Student','2022-11-22 11:07:26',NULL,'P',NULL,'2022-11-22 11:07:41','2022-11-22 11:07:41',NULL),
	(30,2,'App\\Models\\Student','2022-11-22 11:07:26',NULL,'P',NULL,'2022-11-22 11:07:42','2022-11-22 11:07:42',NULL),
	(31,3,'App\\Models\\Student','2022-11-22 11:07:26',NULL,'P',NULL,'2022-11-22 11:07:44','2022-11-22 11:07:44',NULL),
	(32,4,'App\\Models\\Student','2022-11-22 11:07:26',NULL,'P',NULL,'2022-11-22 11:07:45','2022-11-22 11:07:45',NULL),
	(33,14,'App\\Models\\Staff','2022-11-22 11:19:46',NULL,'P',NULL,'2022-11-22 11:19:51','2022-11-22 11:20:03',NULL),
	(34,2,'App\\Models\\Student','2023-02-16 09:52:36',NULL,'P',NULL,'2023-02-16 09:53:11','2023-02-16 09:53:18',NULL),
	(35,1,'App\\Models\\Student','2023-02-16 09:55:58',NULL,'H',NULL,'2023-02-16 09:53:22','2023-02-16 09:56:02',NULL),
	(36,3,'App\\Models\\Student','2023-02-16 09:52:36',NULL,'A',NULL,'2023-02-16 09:53:25','2023-02-16 09:53:25',NULL),
	(37,4,'App\\Models\\Student','2023-02-16 09:52:36',NULL,'H',NULL,'2023-02-16 09:53:26','2023-02-16 09:53:26',NULL),
	(38,5,'App\\Models\\Student','2023-02-16 09:52:36',NULL,'L',NULL,'2023-02-16 09:53:28','2023-02-16 09:53:28',NULL),
	(39,1,'App\\Models\\Student','2023-02-15 09:55:58',NULL,'P',NULL,'2023-02-16 09:56:07','2023-02-16 09:56:07',NULL),
	(40,1,'App\\Models\\Student','2023-02-22 07:46:42',NULL,'P',NULL,'2023-02-22 07:46:50','2023-02-22 07:46:50',NULL),
	(41,2,'App\\Models\\Student','2023-02-22 07:46:42',NULL,'A',NULL,'2023-02-22 07:46:51','2023-02-22 07:46:51',NULL),
	(42,1,'App\\Models\\Student','2023-03-22 18:00:15',NULL,'P',NULL,'2023-03-24 18:00:29','2023-03-24 18:00:29',NULL),
	(43,2,'App\\Models\\Student','2023-03-22 18:00:15',NULL,'P',NULL,'2023-03-24 18:00:31','2023-03-24 18:00:31',NULL),
	(44,3,'App\\Models\\Student','2023-03-22 18:00:15',NULL,'A',NULL,'2023-03-24 18:00:32','2023-03-24 18:00:32',NULL),
	(45,4,'App\\Models\\Student','2023-03-22 18:00:15',NULL,'P',NULL,'2023-03-24 18:00:33','2023-03-24 18:00:33',NULL),
	(46,1,'App\\Models\\Student','2023-06-01 19:12:17',NULL,'P',NULL,'2023-06-01 18:12:43','2023-06-01 18:12:43',NULL),
	(47,2,'App\\Models\\Student','2023-06-01 19:12:17',NULL,'A',NULL,'2023-06-01 18:12:44','2023-06-01 18:12:44',NULL),
	(48,3,'App\\Models\\Student','2023-06-01 19:12:17',NULL,'P',NULL,'2023-06-01 18:12:46','2023-06-01 18:12:46',NULL),
	(49,4,'App\\Models\\Student','2023-06-01 19:12:17',NULL,'H',NULL,'2023-06-01 18:12:47','2023-06-01 18:12:47',NULL),
	(50,5,'App\\Models\\Student','2023-06-01 19:12:17',NULL,'L',NULL,'2023-06-01 18:12:48','2023-06-01 18:12:48',NULL),
	(51,6,'App\\Models\\Student','2023-06-01 19:12:17',NULL,'P',NULL,'2023-06-01 18:12:49','2023-06-01 18:12:49',NULL),
	(52,91,'App\\Models\\Student','2023-08-02 19:16:18',NULL,'P',NULL,'2023-08-02 18:17:06','2023-08-02 18:17:06',NULL),
	(53,92,'App\\Models\\Student','2023-08-02 19:16:18',NULL,'A',NULL,'2023-08-02 18:17:08','2023-08-02 18:17:08',NULL),
	(54,93,'App\\Models\\Student','2023-08-02 19:16:18',NULL,'A',NULL,'2023-08-02 18:17:09','2023-08-02 18:17:09',NULL),
	(55,95,'App\\Models\\Student','2023-08-02 19:16:18',NULL,'P',NULL,'2023-08-02 18:17:11','2023-08-02 18:17:11',NULL),
	(56,96,'App\\Models\\Student','2023-08-02 19:16:18',NULL,'A',NULL,'2023-08-02 18:17:13','2023-08-02 18:17:13',NULL);



# Dump of table campuses
# ------------------------------------------------------------


CREATE TABLE `campuses` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `contacts` json DEFAULT NULL,
  `address` text,
  `email` varchar(191) DEFAULT NULL,
  `city` varchar(191) DEFAULT NULL,
  `website` varchar(191) DEFAULT NULL,
  `details` json DEFAULT NULL,
  `manager_id` bigint unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`manager_id`),
  CONSTRAINT `campuses_ibfk_1` FOREIGN KEY (`manager_id`) REFERENCES `users` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `campuses` (`id`, `title`, `code`, `contacts`, `address`, `email`, `city`, `website`, `details`, `manager_id`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'Sanghar Town Branch','101','{\"primary\": \"+92-343-343-4343\", \"secondary\": \"undefined\"}','Sanghar Town, Khokhar Road','admin@axiom.pk',NULL,NULL,NULL,NULL,'2022-10-28 08:08:04','2022-10-28 08:08:04',NULL);



# Dump of table departments
# ------------------------------------------------------------


CREATE TABLE `departments` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `departments` (`id`, `title`, `description`)
VALUES
	(1,'Management',NULL),
	(2,'Academic',NULL);



# Dump of table failed_jobs
# ------------------------------------------------------------


CREATE TABLE `failed_jobs` (
  `id` bigint 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;



# Dump of table fee_plans
# ------------------------------------------------------------


CREATE TABLE `fee_plans` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;



# Dump of table fee_types
# ------------------------------------------------------------


CREATE TABLE `fee_types` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` varchar(191) DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `fee_types` (`id`, `title`, `description`, `status`)
VALUES
	(1,'Tuition Fee',NULL,'ACTIVE'),
	(2,'Annual Charges',NULL,'ACTIVE'),
	(3,'Admission Fee',NULL,'ACTIVE');



# Dump of table fees
# ------------------------------------------------------------


CREATE TABLE `fees` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `serial` varchar(100) DEFAULT NULL,
  `student_id` bigint unsigned DEFAULT NULL,
  `month` date DEFAULT NULL,
  `due_date` date DEFAULT NULL,
  `charges` json DEFAULT NULL,
  `balance` decimal(16,2) DEFAULT '0.00',
  `status` enum('PAID','PENDING','PARTIALLY PAID') DEFAULT NULL,
  `method` enum('CASH','BANK','ONLINE','OTHER') DEFAULT 'CASH',
  `notes` mediumtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `student_id` (`student_id`),
  CONSTRAINT `fees_ibfk_1` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `fees` (`id`, `serial`, `student_id`, `month`, `due_date`, `charges`, `balance`, `status`, `method`, `notes`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'221106-1',1,'2022-11-01','2022-11-10','{\"Tuition Fee\": \"2000\"}',-200.00,'PAID','CASH',NULL,'2022-11-06 15:21:58','2022-11-12 06:10:26',NULL),
	(2,'221106-2',2,'2022-11-01','2022-11-10','{\"Tuition Fee\": \"2200\"}',0.00,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-08 14:10:13',NULL),
	(3,'221106-3',3,'2022-11-01','2022-11-10','{\"Tuition Fee\": \"2000\"}',0.00,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-08 13:55:17',NULL),
	(4,'221106-4',4,'2022-11-01','2022-11-10','{\"Tuition Fee\": \"1600\"}',0.00,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-08 13:55:42',NULL),
	(5,'221106-5',5,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(6,'221106-6',6,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1200}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(7,'221106-7',7,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2200}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(8,'221106-8',8,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1600}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(9,'221106-9',9,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(10,'221106-10',10,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1700}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(11,'221106-11',11,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1800}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(12,'221106-12',12,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1500}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(13,'221106-13',13,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1500}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(14,'221106-14',14,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2200}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(15,'221106-15',15,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1800}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(16,'221106-16',16,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(17,'221106-17',17,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(18,'221106-18',18,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(19,'221106-19',19,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2200}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(20,'221106-20',20,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1900}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(21,'221106-21',21,'2022-11-01','2022-11-10','{\"Tuition Fee\": 1900}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(22,'221106-22',22,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(23,'221106-23',23,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(24,'221106-24',24,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(25,'221106-25',25,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2200}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(26,'221106-26',26,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2300}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(27,'221106-27',27,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2500}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(28,'221106-28',28,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2500}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(29,'221106-29',29,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2000}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(30,'221106-30',30,'2022-11-01','2022-11-10','{\"Tuition Fee\": 2500}',NULL,'PENDING','CASH',NULL,'2022-11-06 15:21:58','2022-11-06 15:21:58',NULL),
	(31,'230216-31',103,'2023-02-01','2023-02-17','{\"Tuition Fee\": 1500, \"Admission Fee\": \"1000\", \"Annual Charges\": \"2000\"}',0.00,'PENDING','CASH','fasdf','2023-02-16 09:51:28','2023-02-16 09:51:28',NULL),
	(32,'230222-32',1,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(33,'230222-33',2,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(34,'230222-34',3,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(35,'230222-35',4,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(36,'230222-36',5,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(37,'230222-37',6,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(38,'230222-38',7,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(39,'230222-39',8,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(40,'230222-40',9,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(41,'230222-41',10,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(42,'230222-42',11,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(43,'230222-43',12,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(44,'230222-44',13,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(45,'230222-45',14,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(46,'230222-46',15,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(47,'230222-47',16,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(48,'230222-48',17,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(49,'230222-49',18,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(50,'230222-50',19,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(51,'230222-51',20,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(52,'230222-52',21,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(53,'230222-53',22,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(54,'230222-54',23,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(55,'230222-55',24,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(56,'230222-56',25,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(57,'230222-57',26,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(58,'230222-58',27,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(59,'230222-59',28,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(60,'230222-60',29,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(61,'230222-61',30,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(62,'230222-62',91,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(63,'230222-63',92,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2150}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(64,'230222-64',93,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(65,'230222-65',94,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(66,'230222-66',95,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(67,'230222-67',96,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(68,'230222-68',97,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1300}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(69,'230222-69',98,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(70,'230222-70',99,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(71,'230222-71',100,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(72,'230222-72',101,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(73,'230222-73',102,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(74,'230222-74',103,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(75,'230222-75',104,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(76,'230222-76',105,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(77,'230222-77',106,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(78,'230222-78',107,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(79,'230222-79',108,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(80,'230222-80',109,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(81,'230222-81',110,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(82,'230222-82',111,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(83,'230222-83',112,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(84,'230222-84',113,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(85,'230222-85',114,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(86,'230222-86',115,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(87,'230222-87',116,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(88,'230222-88',117,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(89,'230222-89',118,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(90,'230222-90',119,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(91,'230222-91',120,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1400}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(92,'230222-92',121,'2023-02-01','2023-02-22','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(93,'230222-93',122,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(94,'230222-94',123,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(95,'230222-95',124,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(96,'230222-96',125,'2023-02-01','2023-02-22','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-02-22 07:48:57','2023-02-22 07:48:57',NULL),
	(97,'230601-97',1,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000, \"Annual Charges\": \"1000\"}',1000.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:15:29',NULL),
	(98,'230601-98',2,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(99,'230601-99',3,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(100,'230601-100',4,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(101,'230601-101',5,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(102,'230601-102',6,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(103,'230601-103',7,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(104,'230601-104',8,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(105,'230601-105',9,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(106,'230601-106',10,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(107,'230601-107',11,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(108,'230601-108',12,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(109,'230601-109',13,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(110,'230601-110',14,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(111,'230601-111',15,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(112,'230601-112',16,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(113,'230601-113',17,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(114,'230601-114',18,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(115,'230601-115',19,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(116,'230601-116',20,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(117,'230601-117',21,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(118,'230601-118',22,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(119,'230601-119',23,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(120,'230601-120',24,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(121,'230601-121',25,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(122,'230601-122',26,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(123,'230601-123',27,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(124,'230601-124',28,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(125,'230601-125',29,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(126,'230601-126',30,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(127,'230601-127',91,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(128,'230601-128',92,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2150}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(129,'230601-129',93,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(130,'230601-130',94,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(131,'230601-131',95,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(132,'230601-132',96,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(133,'230601-133',97,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1300}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(134,'230601-134',98,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(135,'230601-135',99,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(136,'230601-136',100,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(137,'230601-137',101,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(138,'230601-138',102,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(139,'230601-139',103,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(140,'230601-140',104,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(141,'230601-141',105,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(142,'230601-142',106,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(143,'230601-143',107,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(144,'230601-144',108,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(145,'230601-145',109,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(146,'230601-146',110,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(147,'230601-147',111,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(148,'230601-148',112,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(149,'230601-149',113,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(150,'230601-150',114,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(151,'230601-151',115,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(152,'230601-152',116,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(153,'230601-153',117,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(154,'230601-154',118,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(155,'230601-155',119,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(156,'230601-156',120,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1400}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(157,'230601-157',121,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(158,'230601-158',122,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(159,'230601-159',123,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(160,'230601-160',124,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(161,'230601-161',125,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:13:42','2023-06-01 18:13:42',NULL),
	(162,'230601-162',1,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(163,'230601-163',2,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(164,'230601-164',3,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(165,'230601-165',4,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(166,'230601-166',5,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(167,'230601-167',6,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(168,'230601-168',7,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(169,'230601-169',8,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(170,'230601-170',9,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(171,'230601-171',10,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(172,'230601-172',11,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(173,'230601-173',12,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(174,'230601-174',13,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(175,'230601-175',14,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(176,'230601-176',15,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(177,'230601-177',16,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(178,'230601-178',17,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(179,'230601-179',18,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(180,'230601-180',19,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(181,'230601-181',20,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(182,'230601-182',21,'2023-05-31','2023-06-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(183,'230601-183',22,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(184,'230601-184',23,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(185,'230601-185',24,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(186,'230601-186',25,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(187,'230601-187',26,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(188,'230601-188',27,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(189,'230601-189',28,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(190,'230601-190',29,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(191,'230601-191',30,'2023-05-31','2023-06-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-06-01 18:14:37','2023-06-01 18:14:37',NULL),
	(192,'230802-192',1,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(193,'230802-193',2,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(194,'230802-194',3,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000, \"Annual Charges\": \"2000\"}',2000.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:20:04',NULL),
	(195,'230802-195',4,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(196,'230802-196',5,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(197,'230802-197',6,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(198,'230802-198',7,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(199,'230802-199',8,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1600}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(200,'230802-200',9,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(201,'230802-201',10,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(202,'230802-202',11,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(203,'230802-203',12,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(204,'230802-204',13,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(205,'230802-205',14,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(206,'230802-206',15,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(207,'230802-207',16,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(208,'230802-208',17,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(209,'230802-209',18,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(210,'230802-210',19,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(211,'230802-211',20,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(212,'230802-212',21,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(213,'230802-213',22,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(214,'230802-214',23,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(215,'230802-215',24,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(216,'230802-216',25,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(217,'230802-217',26,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(218,'230802-218',27,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(219,'230802-219',28,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(220,'230802-220',29,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(221,'230802-221',30,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(222,'230802-222',91,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(223,'230802-223',92,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2150}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(224,'230802-224',93,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(225,'230802-225',94,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(226,'230802-226',95,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(227,'230802-227',96,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(228,'230802-228',97,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1300}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(229,'230802-229',98,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(230,'230802-230',99,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(231,'230802-231',100,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(232,'230802-232',101,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1700}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(233,'230802-233',102,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(234,'230802-234',103,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(235,'230802-235',104,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(236,'230802-236',105,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(237,'230802-237',106,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1800}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(238,'230802-238',107,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(239,'230802-239',108,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2300}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(240,'230802-240',109,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(241,'230802-241',110,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(242,'230802-242',111,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(243,'230802-243',112,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(244,'230802-244',113,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(245,'230802-245',114,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(246,'230802-246',115,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(247,'230802-247',116,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(248,'230802-248',117,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1500}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(249,'230802-249',118,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(250,'230802-250',119,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(251,'230802-251',120,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1400}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(252,'230802-252',121,'2023-07-31','2023-08-09','{\"Tuition Fee\": 1900}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(253,'230802-253',122,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2100}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(254,'230802-254',123,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2200}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(255,'230802-255',124,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL),
	(256,'230802-256',125,'2023-07-31','2023-08-09','{\"Tuition Fee\": 2000}',0.00,'PENDING','CASH',NULL,'2023-08-02 18:19:11','2023-08-02 18:19:11',NULL);



# Dump of table grade_sections
# ------------------------------------------------------------


CREATE TABLE `grade_sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `grade_id` bigint unsigned DEFAULT NULL,
  `section_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `grade_id` (`grade_id`),
  KEY `section_id` (`section_id`),
  CONSTRAINT `grade_sections_ibfk_1` FOREIGN KEY (`grade_id`) REFERENCES `grades` (`id`) ON DELETE CASCADE,
  CONSTRAINT `grade_sections_ibfk_2` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `grade_sections` (`id`, `grade_id`, `section_id`)
VALUES
	(2,1,1),
	(3,2,1),
	(4,3,1),
	(5,4,1),
	(6,5,1),
	(7,6,1),
	(8,7,1),
	(9,8,1),
	(10,9,1);



# Dump of table grades
# ------------------------------------------------------------


CREATE TABLE `grades` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `label` varchar(191) DEFAULT NULL,
  `description` text,
  `status` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `grades` (`id`, `title`, `label`, `description`, `status`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'Junior Montessori','Pre-School',NULL,'ACTIVE','2022-10-28 19:09:29','2022-11-03 21:13:55',NULL),
	(2,'Sernior Montessori','Pre-Nursery',NULL,'ACTIVE','2022-10-29 08:30:59','2022-11-03 21:14:05',NULL),
	(3,'Advance Montessori','Nursery',NULL,'ACTIVE','2022-10-29 08:31:20','2022-11-03 21:13:35',NULL),
	(4,'One','Class 1',NULL,'ACTIVE','2022-10-29 08:31:33','2022-10-29 08:33:01',NULL),
	(5,'Two','Class 2',NULL,'ACTIVE','2022-10-29 08:31:43','2022-10-29 08:33:05',NULL),
	(6,'Three','Class 3',NULL,'ACTIVE','2022-10-29 08:31:58','2022-10-29 08:33:11',NULL),
	(7,'Four','Class 4',NULL,'ACTIVE','2022-10-29 08:32:09','2022-10-29 08:33:17',NULL),
	(8,'Five','Class 5',NULL,'ACTIVE','2022-10-29 08:32:19','2022-10-29 08:33:22',NULL),
	(9,'Six','Class 6',NULL,'ACTIVE','2022-10-29 10:43:20','2022-10-29 10:43:20',NULL);



# Dump of table media
# ------------------------------------------------------------


CREATE TABLE `media` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `mediable_id` bigint unsigned DEFAULT NULL,
  `mediable_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `file_type` varchar(100) DEFAULT NULL,
  `path` varchar(191) DEFAULT NULL,
  `name` varchar(191) DEFAULT NULL,
  `original_name` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `size` double DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `media` (`id`, `mediable_id`, `mediable_type`, `type`, `file_type`, `path`, `name`, `original_name`, `size`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,7,'App\\Models\\User','DOC','image/png','app/documents/doc-bf968efb-dc10-4818-b8ca-0eb82c15f07d.png','doc-bf968efb-dc10-4818-b8ca-0eb82c15f07d.png','Screenshot 2022-10-07 at 08.23.41.png',444690,'2022-10-27 07:16:46','2022-10-27 08:12:02',NULL),
	(2,7,'App\\Models\\User','DOC','image/png','app/documents/doc-4d5029bd-4449-4643-981c-649521d0869e.png','doc-4d5029bd-4449-4643-981c-649521d0869e.png','Screenshot 2022-09-27 at 18.26.20.png',351670,'2022-10-27 07:16:46','2022-10-27 08:13:10','2022-10-27 08:13:10'),
	(3,1,'App\\Models\\Campus','IMAGE','image/png','/public/assets/images/avatar-49dd05f4-0deb-4188-8460-3e7754e51330.png','avatar-49dd05f4-0deb-4188-8460-3e7754e51330.png','axiom-favicon.png',0,'2022-10-28 08:08:04','2022-10-28 08:08:04',NULL),
	(7,1,'App\\Models\\Student','AVATAR','image/png','/public/assets/avatars/avatar-3a375735-ba71-42d8-a1c6-da19068636a7.png','avatar-3a375735-ba71-42d8-a1c6-da19068636a7.png','Screenshot 2022-11-03 at 08.28.36.png',0,'2022-11-05 07:21:55','2022-11-05 07:26:15','2022-11-05 07:26:15'),
	(8,1,'App\\Models\\Student','AVATAR','image/png','/public/assets/avatars/avatar-956117c9-e79e-43ff-95c9-85636b7d4f8e.png','avatar-956117c9-e79e-43ff-95c9-85636b7d4f8e.png','ia-favicon-large.png',0,'2022-11-05 17:07:13','2022-11-05 17:10:06','2022-11-05 17:10:06');



# Dump of table migrations
# ------------------------------------------------------------


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


INSERT INTO `migrations` (`id`, `migration`, `batch`)
VALUES
	(11,'2014_10_12_000000_create_users_table',1),
	(12,'2014_10_12_100000_create_password_resets_table',1),
	(13,'2016_06_01_000001_create_oauth_auth_codes_table',1),
	(14,'2016_06_01_000002_create_oauth_access_tokens_table',1),
	(15,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),
	(16,'2016_06_01_000004_create_oauth_clients_table',1),
	(17,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),
	(18,'2019_08_19_000000_create_failed_jobs_table',1),
	(19,'2019_12_14_000001_create_personal_access_tokens_table',1),
	(20,'2022_10_21_183915_create_permission_tables',1);



# Dump of table model_has_permissions
# ------------------------------------------------------------


CREATE TABLE `model_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;



# Dump of table model_has_roles
# ------------------------------------------------------------


CREATE TABLE `model_has_roles` (
  `role_id` bigint unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`)
VALUES
	(1,'App\\Models\\User',2),
	(1,'App\\Models\\User',3),
	(1,'App\\Models\\User',4),
	(1,'App\\Models\\User',5),
	(1,'App\\Models\\User',6),
	(1,'App\\Models\\User',7),
	(2,'App\\Models\\User',7),
	(2,'App\\Models\\User',8),
	(2,'App\\Models\\User',9),
	(2,'App\\Models\\User',10),
	(2,'App\\Models\\User',11),
	(1,'App\\Models\\User',12),
	(1,'App\\Models\\User',13),
	(1,'App\\Models\\User',14),
	(1,'App\\Models\\User',15),
	(1,'App\\Models\\User',16),
	(1,'App\\Models\\User',17),
	(1,'App\\Models\\User',18),
	(1,'App\\Models\\User',19),
	(1,'App\\Models\\User',20);



# Dump of table oauth_auth_codes
# ------------------------------------------------------------


CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


# Dump of table oauth_personal_access_clients
# ------------------------------------------------------------


CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` char(36) COLLATE utf8mb4_unicode_ci NOT 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;


INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`)
VALUES
	(1,'978e60e0-8078-4bb1-b1f1-558c625a4acd','2022-10-21 18:41:04','2022-10-21 18:41:04');



# Dump of table parents
# ------------------------------------------------------------


CREATE TABLE `parents` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `first_name` varchar(191) DEFAULT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `cnic` varchar(40) DEFAULT NULL,
  `address` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `contacts` json DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `parents_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `parents` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;



# Dump of table payrolls
# ------------------------------------------------------------


CREATE TABLE `payrolls` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staff_id` bigint unsigned DEFAULT NULL,
  `joined_at` datetime DEFAULT NULL,
  `basic_salary` decimal(12,2) DEFAULT '0.00',
  `allowances` json DEFAULT NULL,
  `taxes` json DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `staff_id` (`staff_id`),
  CONSTRAINT `payrolls_ibfk_1` FOREIGN KEY (`staff_id`) REFERENCES `staff` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `payrolls` (`id`, `staff_id`, `joined_at`, `basic_salary`, `allowances`, `taxes`, `status`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,5,'2022-11-03 20:26:43',10000.00,NULL,NULL,'ACTIVE','2022-11-03 20:26:43','2022-11-03 20:26:43',NULL),
	(2,6,'2022-11-03 20:26:43',15000.00,NULL,NULL,'ACTIVE','2022-11-03 20:26:43','2022-11-03 20:26:43',NULL),
	(3,14,'1970-01-01 00:00:00',25000.00,'[{\"type\": \"Bonus\", \"amount\": \"1000\"}]',NULL,'ACTIVE','2022-11-18 16:21:15','2022-11-18 16:21:15',NULL);



# Dump of table payslips
# ------------------------------------------------------------


CREATE TABLE `payslips` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `payroll_id` bigint unsigned DEFAULT NULL,
  `serial` varchar(100) DEFAULT NULL,
  `month` date DEFAULT NULL,
  `payment_at` datetime DEFAULT NULL,
  `payments` json DEFAULT NULL,
  `deductions` json DEFAULT NULL,
  `net_amount` decimal(12,2) DEFAULT '0.00',
  `notes` mediumtext,
  `status` enum('PENDING','PAID','HOLD') DEFAULT 'PENDING',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;



# Dump of table permissions
# ------------------------------------------------------------


CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`)
VALUES
	(7,'operate campus','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(8,'read campus','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(9,'create staff','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(10,'read staff','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(11,'update staff','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(12,'delete staff','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(13,'create student','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(14,'update student','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(15,'read student','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(16,'create parent','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(17,'update parent','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(18,'read parent','api','2022-11-01 20:03:32','2022-11-01 20:03:32'),
	(19,'delete student','api','2022-11-02 07:19:26','2022-11-02 07:19:26'),
	(20,'delete parent','api','2022-11-02 07:19:26','2022-11-02 07:19:26');




# Dump of table role_has_permissions
# ------------------------------------------------------------


CREATE TABLE `role_has_permissions` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `role_has_permissions` (`permission_id`, `role_id`)
VALUES
	(13,1),
	(14,1),
	(15,1),
	(16,1),
	(17,1),
	(18,1),
	(19,1),
	(20,1),
	(7,2),
	(8,2),
	(9,2),
	(10,2),
	(11,2),
	(12,2),
	(13,2),
	(14,2),
	(15,2),
	(16,2),
	(17,2),
	(18,2);



# Dump of table roles
# ------------------------------------------------------------


CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


INSERT INTO `roles` (`id`, `name`, `title`, `guard_name`, `created_at`, `updated_at`)
VALUES
	(1,'Teacher','Teacher','api','2022-10-26 10:46:33','2022-10-26 10:46:33'),
	(2,'Principal','Head of School','api','2022-10-26 10:52:12','2022-10-26 10:52:12');



# Dump of table sections
# ------------------------------------------------------------


CREATE TABLE `sections` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` text,
  `capacity` int unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `sections` (`id`, `title`, `description`, `capacity`, `created_at`, `updated_at`)
VALUES
	(1,'A',NULL,50,'2022-10-28 13:19:27','2022-10-29 10:44:51'),
	(2,'B',NULL,50,'2022-10-28 18:55:34','2022-10-29 10:44:55');



# Dump of table sessions
# ------------------------------------------------------------


CREATE TABLE `sessions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(191) DEFAULT NULL,
  `description` text,
  `status` enum('ACTIVE','INACTIVE') DEFAULT 'INACTIVE',
  `started_at` datetime DEFAULT NULL,
  `ended_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `sessions` (`id`, `title`, `description`, `status`, `started_at`, `ended_at`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'2022-2023','asdfasf','ACTIVE','2022-03-01 00:00:00','2023-03-01 00:00:00','2022-10-28 20:33:42','2023-02-19 17:40:36',NULL);



# Dump of table staff
# ------------------------------------------------------------


CREATE TABLE `staff` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `campus_id` bigint unsigned DEFAULT NULL,
  `first_name` varchar(191) DEFAULT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `code` varchar(100) DEFAULT NULL,
  `barcode` varchar(255) DEFAULT NULL,
  `cnic` varchar(20) DEFAULT NULL,
  `title` varchar(191) DEFAULT NULL,
  `department` varchar(191) DEFAULT NULL,
  `address` mediumtext,
  `contacts` json DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE') DEFAULT 'ACTIVE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `campus_id` (`campus_id`),
  CONSTRAINT `staff_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `staff_ibfk_3` FOREIGN KEY (`campus_id`) REFERENCES `campuses` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `staff` (`id`, `user_id`, `campus_id`, `first_name`, `last_name`, `code`, `barcode`, `cnic`, `title`, `department`, `address`, `contacts`, `status`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(2,1,NULL,'Super','Admin',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ACTIVE',NULL,NULL,NULL),
	(5,11,1,'Almas','Farrukh','1001',NULL,'34343-4343434-3','Head','Management','KA 308 Street 13 Karimabad','{\"primary\": \"+92-334-343-4343\", \"secondary\": \"+92-343-434-3434\"}','ACTIVE','2022-11-03 20:26:43','2022-11-03 20:26:43',NULL),
	(6,12,1,'Teacher','One','1002',NULL,'34343-4343434-6','Maths Teacher','Academic','KA 308 Street 13 Karimabad','{\"primary\": \"+92-343-434-3434\", \"secondary\": \"\"}','ACTIVE','2022-11-18 16:09:33','2022-11-18 16:09:33',NULL),
	(14,20,1,'Teacher','Two','1003',NULL,'45365-3435453-4','Science Teacher','Academic','KA 308 Street 13 Karimabad','{\"primary\": \"+92-453-434-2323\", \"secondary\": \"\"}','ACTIVE','2022-11-18 16:21:15','2022-11-18 16:21:15',NULL);



# Dump of table students
# ------------------------------------------------------------


CREATE TABLE `students` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `number` varchar(100) DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `first_name` varchar(191) DEFAULT NULL,
  `last_name` varchar(191) DEFAULT NULL,
  `email` varchar(191) DEFAULT NULL,
  `guardian_name` varchar(191) DEFAULT NULL,
  `contacts` json DEFAULT NULL,
  `address` text,
  `bio` json DEFAULT NULL,
  `fees` json DEFAULT NULL,
  `cnic` varchar(20) DEFAULT NULL,
  `campus_id` bigint unsigned DEFAULT NULL,
  `grade_id` bigint unsigned DEFAULT NULL,
  `section_id` bigint unsigned DEFAULT NULL,
  `status` enum('ACTIVE','INACTIVE','SUSPENDED') DEFAULT 'ACTIVE',
  `admission_date` datetime DEFAULT NULL,
  `dob` datetime DEFAULT NULL,
  `gender` enum('MALE','FEMALE') DEFAULT 'MALE',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `campus_id` (`campus_id`),
  KEY `grade_id` (`grade_id`),
  KEY `section_id` (`section_id`),
  CONSTRAINT `students_ibfk_1` FOREIGN KEY (`campus_id`) REFERENCES `campuses` (`id`) ON DELETE SET NULL,
  CONSTRAINT `students_ibfk_2` FOREIGN KEY (`grade_id`) REFERENCES `grades` (`id`) ON DELETE SET NULL,
  CONSTRAINT `students_ibfk_3` FOREIGN KEY (`section_id`) REFERENCES `sections` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `students` (`id`, `number`, `code`, `first_name`, `last_name`, `email`, `guardian_name`, `contacts`, `address`, `bio`, `fees`, `cnic`, `campus_id`, `grade_id`, `section_id`, `status`, `admission_date`, `dob`, `gender`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,'1','AHE-220001','Musa','Bhutta',NULL,'Muhammad Nasir Sajjad','{\"primary\": \"+92-3004493362\", \"secondary\": \"\"}','House No.278,ST.No 09 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','34104-0847147-9',1,1,1,'ACTIVE','2022-03-21 00:00:00','2018-02-16 00:00:00','MALE','2022-11-02 17:42:26','2022-11-08 18:37:00',NULL),
	(2,'2','AHE-220002','Hania','Ali','','Ali Arshad','{\"primary\": \"+92-3349989819\"}','House No.249,ST.No 04 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}, {\"type\": \"Annual Charges\", \"amount\": 3200}]',NULL,1,1,1,'ACTIVE','2022-03-22 00:00:00','2017-11-16 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(3,'3','AHE-220003','Sana','Saddam','','Saddam Hussain','{\"primary\": \"+92-3102240009\"}','House No.291,ST.No 09 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','B200382-18-50293',1,1,1,'ACTIVE','2022-03-22 00:00:00','2016-06-30 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(4,'4','AHE-220004','Ayesha','Khurrum','','Khurrum Rasheed','{\"primary\": \"+92-3124305850\"}','House No.02, ST No A-1 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1600}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','B300616-19-13398',1,1,1,'ACTIVE','2022-03-25 00:00:00','2018-08-26 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(5,'5','AHE-220005','Isra','Shehbaz','','Muhammad Shehbaz','{\"primary\": \"+92-3120830280\"}','House No.293, ST No 09 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','61101-5970151-8',1,1,1,'ACTIVE','2022-03-28 00:00:00','2018-03-08 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(6,'6','AHE-220006','Abdul','Rafey','','Umar Siddique','{\"primary\": \"+92-3336128436\"}','House No.206,ST No 06 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1200}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','B100407-18-11552',1,1,1,'ACTIVE','2022-03-30 00:00:00','2018-01-14 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(7,'7','AHE-220007','Zarwa','waqas','','Waqas Ahmed','{\"primary\": \"+92-3143000017\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','61101-9067292-8',1,1,1,'ACTIVE','2022-03-31 00:00:00','2018-12-02 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(8,'8','AHE-220008','Ahmed','Raza','','Ahmad Raza Khan','{\"primary\": \"+92-3205750747\"}','House No.236, Sanghar Town, Gangal West',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1600}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','38302-0303795-9',1,1,1,'ACTIVE','2022-01-04 00:00:00','2018-09-10 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(9,'9','AHE-220009','Raheel','Nazakat','','Nazakat Hussain','{\"primary\": \"+92-3045201312\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1000}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','37405-3876738-9',1,1,1,'ACTIVE','2022-04-04 00:00:00','2017-06-02 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(10,'10','AHE-220010','Moeez','','',NULL,'{\"primary\": \"+92-3494516328\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1700}]',NULL,1,1,1,'ACTIVE','2022-02-04 00:00:00',NULL,'MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(11,'11','AHE-220011','Fatima','','','Muhammad Imran','{\"primary\": \"+92-3315522646\"}','ST No 02 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1800}, {\"type\": \"Annual Charges\", \"amount\": 3000}]',NULL,1,1,1,'ACTIVE','2022-12-04 00:00:00',NULL,'FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(12,'12','AHE-220012','Furqan','Ahmed','',NULL,'{\"primary\": \"+92-3104798159\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1500}]',NULL,1,1,1,'ACTIVE','2022-11-04 00:00:00',NULL,'MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(13,'13','AHE-220013','M.','Ahmer','','Muhammad Imran','{\"primary\": \"+92-3315522646\"}','ST No 02 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1500}, {\"type\": \"Annual Charges\", \"amount\": 3000}]',NULL,1,1,1,'ACTIVE','2022-12-04 00:00:00',NULL,'FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(14,'14','AHE-220014','M.','Aizaam','','Waqar Ashraf','{\"primary\": \"+92-3315071108\"}','House No.09, ST No 04 Sangar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}, {\"type\": \"Annual Charges\", \"amount\": 4000}]',NULL,1,1,1,'ACTIVE','2022-04-13 00:00:00','2019-06-19 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(15,'15','AHE-220015','Moin-ur-Rehman','','','Muhammad Maroof','{\"primary\": \"+92-3195908164\"}','Dhoke lalyal ST.No 10',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1800}]','82701-0443989-5',1,1,1,'ACTIVE','2022-10-05 00:00:00','2018-07-16 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(16,'16','AHE-220016','Muhammad','Alyaan',NULL,'Unknown','{\"primary\": \"+92-3005247680\", \"secondary\": \"\"}','Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,1,1,'ACTIVE','2022-04-18 00:00:00','2017-01-10 00:00:00','MALE','2022-11-02 17:42:26','2022-11-06 16:17:50',NULL),
	(17,'17','AHE-220017','Muhammad','Ashar',NULL,'M. Shahbaz','{\"primary\": \"+92-3330756660\", \"secondary\": \"\"}','Rubeenabad Near Wapda Office Dhoke',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 4000}]','37405-3194477-5',1,1,1,'ACTIVE','2022-04-20 00:00:00','2017-01-11 00:00:00','MALE','2022-11-02 17:42:26','2022-11-06 16:18:09',NULL),
	(18,'19','AHE-220018','Nisha','Nadeem','',NULL,'{\"primary\": \"+92-3075643781\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1000}]',NULL,1,1,1,'ACTIVE','2022-09-05 00:00:00',NULL,'FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(19,'19','AHE-220019','Mishal','Fatima','','Muhammad Riaz','{\"primary\": \"+92-3151558656\"}','Mangral Model Town.(Rwp)',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}, {\"type\": \"Annual Charges\", \"amount\": 4000}]','38204-0355124-4',1,1,1,'ACTIVE','2022-11-08 00:00:00','2018-08-03 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(20,'20','AHE-220020','Noor','Fatima','','Nauman Akram','{\"primary\": \"+92-3348456502\"}','House No. 02 ST. 7A Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1900}, {\"type\": \"Annual Charges\", \"amount\": 3000}]',NULL,1,1,1,'ACTIVE','2022-08-31 00:00:00','2018-04-30 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(21,'21','AHE-220021','Sara','Sajid','','Sajid Iqbal','{\"primary\": \"+92-3115259289\"}','House No. 321 ST 14 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1900}, {\"type\": \"Annual Charges\", \"amount\": 3000}]','37405-4837996-2',1,1,1,'ACTIVE','2022-03-09 00:00:00','2018-08-18 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(22,'22','AHE-220022','M.Rayaan','','','Roman Khan','{\"primary\": \"+92-3165137488\"}','House No. 262/263 ST 04 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3000}]',NULL,1,1,1,'ACTIVE','2022-05-09 00:00:00','2016-01-21 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(23,'23','AHE-220023','Ahmed','Fiaz','',NULL,'{\"primary\": \"+92-3135553685\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,1,1,'ACTIVE',NULL,NULL,'MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(24,'24','AHE-220024','Rayyan','Asif','',NULL,'[]',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,1,1,'ACTIVE',NULL,NULL,'MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(25,'25','AHE-220025','Muntaha','','',NULL,'[]',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}]',NULL,1,1,1,'ACTIVE',NULL,NULL,'FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(26,'26','AHE-220026','Ibrahim','Fayyaz','','Saqlain Haider','{\"primary\": \"+92-3066029343\"}','House No. 151 ST 03 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2300}, {\"type\": \"Annual Charges\", \"amount\": 4000}]','B100625-18-10195',1,1,1,'ACTIVE','2022-06-08 00:00:00','2018-12-01 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(27,'27','AHE-220027','Manahil','','','Shazad khan','{\"primary\": \"+92-3165688125\"}','House No. 249 ST 04 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2500}, {\"type\": \"Annual Charges\", \"amount\": 4000}]','42401-1237671-2',1,1,1,'ACTIVE','2022-06-08 00:00:00','2018-11-14 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(28,'28','AHE-220028','Hareem','Fatima','','Muhammad Aslam','{\"primary\": \"+92-3178111646\"}','House No.228 ST No 05 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2500}, {\"type\": \"Annual Charges\", \"amount\": 3000}]','B100467-18-10994',1,1,1,'ACTIVE','2022-08-08 00:00:00','2017-12-26 00:00:00','FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(29,'29','AHE-220029','M.Abbas','','','Ghazi khan','{\"primary\": \"+92-3005003825\"}','House No.309 ST No 04 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3000}]','37405-9214323-1',1,1,1,'ACTIVE','2022-08-18 00:00:00','2018-09-29 00:00:00','MALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(30,'30','AHE-220030','Bakhat','Bhari','','M.Sajid ','{\"primary\": \"+92-3339971634\"}','House No.153 ST No 03 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2500}]',NULL,1,1,1,'ACTIVE','2022-08-09 00:00:00',NULL,'FEMALE','2022-11-02 17:42:26','2022-11-02 17:42:26',NULL),
	(91,'1','AHE-220031','Dua','Fiaz','','M.Fiaz-ur-Rehman','{\"primary\": \"+92-3490583716\"}','House No 228, ST No 5 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}]',NULL,1,2,1,'ACTIVE','2021-08-06 00:00:00','2017-11-01 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(92,'2','AHE-220032','M.','Rohan','','Naveed Ali Khan','{\"primary\": \"+92-3452464994\"}','House No 312, ST No 04 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2150}]','37405-0148285-1',1,2,1,'ACTIVE','2021-07-06 00:00:00','2018-02-01 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(93,'3','AHE-220033','Anaya','mehmood','','Sharafat Mehmood','{\"primary\": \"+92-3229468751\"}','House No 02 ST No 22 M.M Town Rwp',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1900}]',NULL,1,2,1,'ACTIVE','2021-09-06 00:00:00','2017-05-02 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(94,'4','AHE-220034','Khansa','kiyani','','Zia-ul-Haq-Kiyani','{\"primary\": \"+92-3095738537\"}','New Mangral Model Town, Gangal West',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1800}]','37405-4645250-8',1,2,1,'ACTIVE','2021-12-06 00:00:00','2016-12-13 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(95,'5','AHE-220035','Rida e','Zainab','','M.Nazir','{\"primary\": \"+92-3348558496\"}','House No 05, ST No 17 Shaheen Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1800}]','37401-6263161-6',1,2,1,'ACTIVE','2021-06-14 00:00:00','2017-06-23 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(96,'6','AHE-220036','M.Husnain','','','M.Imran','{\"primary\": \"+92-3488278613\"}','ST No 3 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1800}]',NULL,1,2,1,'ACTIVE','2021-06-16 00:00:00','2016-02-20 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(97,'7','AHE-220037','Suliman','Masih','','Imran Masih','{\"primary\": \"+92-3060407846\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1300}]',NULL,1,2,1,'ACTIVE','2021-05-07 00:00:00',NULL,'MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(98,'8','AHE-220038','Minahil','Khurrum','','Khurrum Rasheed','{\"primary\": \"+92-3134305850\"}','House No 02 ST A1 Sanghar Town Rwp',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2300}]',NULL,1,2,1,'ACTIVE','2021-03-08 00:00:00',NULL,'FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(99,'9','AHE-220039','M.','Subhan','','Yasir Khokar','{\"primary\": \"+92-3452464994\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1700}]','B100467-17-10760',1,2,1,'ACTIVE','2021-05-08 00:00:00','2017-07-29 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(100,'10','AHE-220040','Ayesha','Sajid','','Sajid Iqbal','{\"primary\": \"+92-3323007145\"}','House No 322, ST No 16 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2100}]',NULL,1,2,1,'ACTIVE','2021-09-08 00:00:00','2016-11-19 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(101,'11','AHE-220041','Wasi','Haider','','Syed Rizwan Haider','{\"primary\": \"+92-3008439513\"}','House No 144, Main ST Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1700}]','B611026-17-98843',1,2,1,'ACTIVE','2021-11-08 00:00:00','2017-04-05 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(102,'12','AHE-220042','Raja','Zayan','','Manaj Ahmed','{\"primary\": \"+92-3165422859\"}','House No 307, ST No 4 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2100}]','B100461-18-12230',1,2,1,'ACTIVE','2021-09-08 00:00:00','2018-01-08 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(103,'13','AHE-220043','Usman','Irfan','','Irfan','{\"primary\": \"+92-3182666537\"}','House No 2 ST No 24, Sector F-7/2 ISB',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1500}, {\"type\": \"Annual Charges\", \"amount\": \"2000\"}, {\"type\": \"Admission Fee\", \"amount\": \"1000\"}]','B611026-19-114224',1,2,1,'ACTIVE','2021-10-08 00:00:00','2017-06-22 00:00:00','MALE','2022-11-02 19:38:07','2023-02-16 09:50:30',NULL),
	(104,'14','AHE-220044','Abrish','Waqas','','Raja Waqas Ahmed','{\"primary\": \"+92-3008582949\"}','House No 307, ST No 4 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2100}]','37405-3766404-0',1,2,1,'ACTIVE','2021-08-13 00:00:00','2019-01-22 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(105,'15','AHE-220045','M. Ali','Hassan','','Yasir Aziz','{\"primary\": \"+92-3185725646\"}','House No 378,Main ST Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2300}]',NULL,1,2,1,'ACTIVE','2021-02-09 00:00:00','2018-06-09 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(106,'16','AHE-220046','Anabia','Mehtab','','Mehtab Alam','{\"primary\": \"+92-3312688884\"}','ST No 13, Mohalla Shaheen Town, Rwp',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1800}]','37405-3793342-0',1,2,1,'ACTIVE','2021-02-10 00:00:00','2021-08-03 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(107,'17','AHE-220047','Rameen','Fatima','','Sheraz Ahmed','{\"primary\": \"+92-3115324122\"}','House No 220 Sanghar Town ',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,2,1,'ACTIVE','2021-10-26 00:00:00',NULL,'FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(108,'19','AHE-220048','Syed Adil','Gilani','','Adil Gilani','{\"primary\": \"+92-3128688443\"}','House No. 226,ST No 5 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2300}]','B700540-17-11815',1,2,1,'ACTIVE','2021-11-16 00:00:00','2017-10-11 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(109,'19','AHE-220049','M.','Ibrahim','','Ishtiaq Ahmed','{\"primary\": \"+92-3115253453\"}','Dhoke Lalyal Near Bilal Masjid',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2100}]','82603-0352976-7',1,2,1,'ACTIVE','2022-11-01 00:00:00','2017-12-21 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(110,'20','AHE-220050','M.','Umer','','Rao Zaka Ullah','{\"primary\": \"+92-3245632110\"}','House No 129, ST No 02 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}, {\"type\": \"Annual Charges\", \"amount\": 3200}]','B611026-18-108397',1,2,1,'ACTIVE','2022-03-28 00:00:00','2017-11-11 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(111,'21','AHE-220051','M.','Saarim','',NULL,'{\"primary\": \"+92-3145373898\"}','House No 137,ST No 02 Mangral Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}]',NULL,1,2,1,'ACTIVE','2022-03-30 00:00:00','2017-07-15 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(112,'22','AHE-220052','Ayesha','Naeem','','M.Naeem','{\"primary\": \"+92-3335543974\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1100}]',NULL,1,2,1,'ACTIVE',NULL,NULL,'FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(113,'23','AHE-220053','M.','Wahab','','Shazad Akhter','{\"primary\": \"+92-3049946507\"}','Manger Model Town ST No 19',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 4000}]','36401-6182850-9',1,2,1,'ACTIVE','2022-04-04 00:00:00','2016-01-11 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(114,'24','AHE-220054','Ali','Hassan','','Yasir Aziz','{\"primary\": \"+92-3225010765\"}','House No 378,Main ST Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,2,1,'ACTIVE','2021-02-09 00:00:00','2018-06-09 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(115,'25','AHE-220055','Adil','','','Muhammad Javed','{\"primary\": \"+92-3014491389\"}','ST No 1 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2100}]',NULL,1,2,1,'ACTIVE','2021-09-11 00:00:00','2017-05-26 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(116,'26','AHE-220056','Minal','Asad','','Asad Hussnain Sabir','{\"primary\": \"+92-3244868774\"}','House No 111 ST No Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,2,1,'ACTIVE','2021-04-09 00:00:00','2016-07-31 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(117,'27','AHE-220057','Burhan','Ahmed','',NULL,'{\"primary\": \"+92-3104798159\"}',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1500}]',NULL,1,2,1,'ACTIVE','2022-11-04 00:00:00',NULL,'MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(118,'28','AHE-220058','Hamza','Ibrar','','Syed-ul-Ibrar','{\"primary\": \"+92-3115270105\"}','ST No 16 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1000}]',NULL,1,2,1,'ACTIVE','2021-12-17 00:00:00','2017-05-12 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(119,'29','AHE-220059','Waqas','','','M.Ramzan','{\"primary\": \"+92-3114973077\"}','Sanghar Town ST No 10',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}]',NULL,1,2,1,'ACTIVE','2021-08-21 00:00:00','2016-08-10 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(120,'30','AHE-220060','Eman','Nadeem','',NULL,'[]',NULL,NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1400}]',NULL,1,2,1,'ACTIVE','2022-09-05 00:00:00',NULL,'FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(121,'31','AHE-220061','Uzair','','','Ihsan Ullah','{\"primary\": \"+92-3359066790\"}','ST No 1 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 1900}]',NULL,1,2,1,'ACTIVE',NULL,NULL,'MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(122,'32','AHE-220062','Anza','Yasir','','Yasir Iqbal','{\"primary\": \"+92-3339509508\"}','Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2100}]','61101-2372012-0',1,2,1,'ACTIVE','2022-06-08 00:00:00','2017-10-04 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(123,'33','AHE-220063','M.','Zaroon','','M.Azam','{\"primary\": \"+92-3185636576\"}','Flat# 03, Sadaat Plaza, Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2200}, {\"type\": \"Annual Charges\", \"amount\": 3000}]','B100274-18-10958',1,2,1,'ACTIVE','2022-08-23 00:00:00','2017-11-27 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(124,'34','AHE-220064','Ajwa','Yasir','','Muhammad Yaseen','{\"primary\": \"+92-3155317550\"}','House No 322, ST No 15 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3000}]','37405-5784851-8',1,2,1,'ACTIVE','2022-03-09 00:00:00','2016-09-20 00:00:00','FEMALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL),
	(125,'35','AHE-220065','Talha','Sami','','Sami Ullah','{\"primary\": \"+92-3129307497\"}','House No 321, ST No 16 Sanghar Town',NULL,'[{\"type\": \"Tuition Fee\", \"amount\": 2000}, {\"type\": \"Annual Charges\", \"amount\": 3000}]','37405-9052589-5',1,2,1,'ACTIVE','2022-03-09 00:00:00','2017-06-20 00:00:00','MALE','2022-11-02 19:38:07','2022-11-02 19:38:07',NULL);



# Dump of table transactions
# ------------------------------------------------------------


CREATE TABLE `transactions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `transactable_id` bigint unsigned DEFAULT NULL,
  `transactable_type` varchar(100) DEFAULT NULL,
  `ref` varchar(191) DEFAULT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `amount` decimal(16,2) DEFAULT '0.00',
  `type` enum('IN','OUT') DEFAULT 'IN',
  `status` enum('PENDING','COMPLETED','IN-PROGRESS') CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT 'IN-PROGRESS',
  `comments` mediumtext,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;


INSERT INTO `transactions` (`id`, `transactable_id`, `transactable_type`, `ref`, `user_id`, `amount`, `type`, `status`, `comments`, `created_at`, `updated_at`, `deleted_at`)
VALUES
	(1,1,'App\\Models\\Fee',NULL,1,2200.00,'IN','COMPLETED',NULL,'2022-11-08 14:04:34','2022-11-12 06:10:26',NULL);




