-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `collagesoftware`
--

-- --------------------------------------------------------

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `bandhans`
--

CREATE TABLE `bandhans` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('Pending','Active','Canceled','Out','Suspended') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `active_by` bigint(20) UNSIGNED DEFAULT NULL,
  `active_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blog_category_id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count` int(11) NOT NULL DEFAULT 1,
  `status` enum('Pending','Review','Publish','Daft','Delete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blog_categories`
--

CREATE TABLE `blog_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Publish','Daft','Delete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Publish',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `blog_comments`
--

CREATE TABLE `blog_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `blog_id` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `books`
--

CREATE TABLE `books` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `book_category_id` bigint(20) UNSIGNED NOT NULL,
  `book_author_id` bigint(20) UNSIGNED NOT NULL,
  `book_publication_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish_date` timestamp NULL DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Pending','Published','Failed','Canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Published',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `books`
--

INSERT INTO `books` (`id`, `book_category_id`, `book_author_id`, `book_publication_id`, `name`, `name_bn`, `publish_date`, `description`, `avatar`, `status`, `user_id`, `created_at`, `updated_at`) VALUES
(2, 2, 1, 2, 'Monthy Rent', 'sadfasdf', NULL, 'sadfasdf', NULL, 'Published', 1, '2023-09-22 04:37:02', '2023-09-22 04:37:02');

-- --------------------------------------------------------

--
-- Table structure for table `book_authors`
--

CREATE TABLE `book_authors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bath_place` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `book_authors`
--

INSERT INTO `book_authors` (`id`, `name`, `name_ban`, `bath_place`, `dob`, `description`, `avatar`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Monthy Rent', 'History', '4rwe', '323', 'asdfasfd', NULL, 'Active', '2023-09-21 18:05:57', '2023-09-21 18:05:57');

-- --------------------------------------------------------

--
-- Table structure for table `book_categories`
--

CREATE TABLE `book_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `book_categories`
--

INSERT INTO `book_categories` (`id`, `name`, `name_ban`, `status`, `created_at`, `updated_at`) VALUES
(2, 'History', 'History', 'Active', '2023-09-21 17:35:49', '2023-09-21 17:35:49');

-- --------------------------------------------------------

--
-- Table structure for table `book_publications`
--

CREATE TABLE `book_publications` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `established` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive','Suspended') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `book_publications`
--

INSERT INTO `book_publications` (`id`, `name`, `name_ban`, `address`, `established`, `description`, `avatar`, `status`, `created_at`, `updated_at`) VALUES
(2, 'A', 'B', 'asdfasdf', '3423', 'asdfasfd', 'uploads/book_publications/images/book_publications-650d15002d13d.png', 'Active', '2023-09-22 04:16:00', '2023-09-22 04:16:00');

-- --------------------------------------------------------

--
-- Table structure for table `book_rents`
--

CREATE TABLE `book_rents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `book_id` bigint(20) UNSIGNED NOT NULL,
  `delivery_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `approx_return_date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `return_date` timestamp NULL DEFAULT NULL,
  `status` enum('Pending','Running','Failed','Canceled','Completed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Running',
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `class_routines`
--

CREATE TABLE `class_routines` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `session_id` bigint(20) UNSIGNED DEFAULT NULL,
  `group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `class_year_id` bigint(20) UNSIGNED DEFAULT NULL,
  `entry_id` bigint(20) UNSIGNED NOT NULL,
  `entry_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `view` int(11) NOT NULL DEFAULT 0,
  `status` enum('Pending','Daft','Published','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `class_types`
--

CREATE TABLE `class_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_types`
--

INSERT INTO `class_types` (`id`, `name`, `name_bn`, `status`, `created_at`, `updated_at`) VALUES
(1, 'HSC', 'এইচএসসি', 'active', '2023-04-05 18:09:08', '2023-04-05 18:14:18'),
(2, 'Honours', 'অনার্স', 'active', '2023-04-05 18:09:53', '2023-04-05 18:14:29'),
(3, 'Degree', 'ডিগ্রী', 'active', '2023-04-05 18:10:01', '2023-04-05 18:14:40'),
(4, 'Degree Private', 'ডিগ্রী প্রাইভেট', 'active', '2023-04-05 18:10:10', '2023-04-05 18:14:51');

-- --------------------------------------------------------

--
-- Table structure for table `class_years`
--

CREATE TABLE `class_years` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_type_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `class_years`
--

INSERT INTO `class_years` (`id`, `class_type_id`, `name`, `name_bn`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'HSc 1st Year', 'এইচএসসি ১ম বর্ষ', 'active', '2023-04-12 06:48:42', '2023-04-12 07:04:19'),
(2, 1, 'HSc 2nd Year', 'এইচএসসি ২য় বর্ষ', 'active', '2023-04-12 06:49:12', '2023-04-12 07:04:27');

-- --------------------------------------------------------

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Pending','Read','Reply','Done') COLLATE utf8mb4_unicode_ci DEFAULT 'Pending',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('Bandhon','CulturalForum','Scout') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Bandhon',
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` (`id`, `type`, `title`, `description`, `avatar`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Scout', 'This is title', 'This is description', 'uploads/contents/images/contents-650d288259956.png', 'Active', NULL, '2023-09-22 05:39:14', '2023-09-22 06:18:09');

-- --------------------------------------------------------

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `name_bn`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Bangladesh', 'বাংলাদেশ', 'active', '2023-04-18 09:03:33', '2023-04-18 09:03:33');

-- --------------------------------------------------------

--
-- Table structure for table `cultural_forums`
--

CREATE TABLE `cultural_forums` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('Pending','Active','Canceled','Out','Suspended') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `active_by` bigint(20) UNSIGNED DEFAULT NULL,
  `active_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `currencies`
--

CREATE TABLE `currencies` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `symbol` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('default','regular','daft') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `departments`
--

CREATE TABLE `departments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_description_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `position` int(11) NOT NULL DEFAULT 1,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `districts`
--

CREATE TABLE `districts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` int(11) DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `districts`
--

INSERT INTO `districts` (`id`, `country_id`, `name`, `name_bn`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Dhaka', 'ঢাকা', 'active', '2023-04-18 09:04:53', '2023-04-18 09:04:53'),
(2, 1, 'Mymensingh', 'ময়মনসিংহ', 'active', '2023-04-18 09:05:22', '2023-04-18 09:05:22'),
(3, 1, 'Munshiganj', 'মুন্সীগঞ্জ', 'active', '2023-04-18 09:05:46', '2023-04-18 09:05:46');

-- --------------------------------------------------------

--
-- Table structure for table `document_types`
--

CREATE TABLE `document_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Pending','Active','Deactive','Deleted') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `document_types`
--

INSERT INTO `document_types` (`id`, `name`, `name_bn`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, 'testimonial', 'টেসটিমনিয়াল', 'Pending', NULL, '2023-09-27 12:01:26', '2023-09-27 12:01:26');

-- --------------------------------------------------------

--
-- Table structure for table `education_boards`
--

CREATE TABLE `education_boards` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `education_boards`
--

INSERT INTO `education_boards` (`id`, `name`, `short_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Barisal', 'BAR', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(2, 'Chattogram', 'CTG', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(3, 'Comilla', 'COM', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(4, 'Dhaka', 'DHA', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(5, 'Dinajpur', 'DIN', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(6, 'Jessore', 'JES', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(7, 'Mymensingh', 'MYM', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(8, 'Rajshahi', 'RAJ', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(9, 'Sylhet', 'SYL', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(10, 'Technical', 'TECH', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(11, 'Madrasha', 'MAD', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(12, 'DIBS (DHAKA)', 'DIBS (DHAKA)', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54'),
(13, 'Open University', 'Open University', 'Active', '2023-09-14 11:22:54', '2023-09-14 11:22:54');

-- --------------------------------------------------------

--
-- Table structure for table `exam_routines`
--

CREATE TABLE `exam_routines` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `class_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `session_id` bigint(20) UNSIGNED DEFAULT NULL,
  `group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `class_year_id` bigint(20) UNSIGNED DEFAULT NULL,
  `entry_id` bigint(20) UNSIGNED NOT NULL,
  `entry_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `view` int(11) NOT NULL DEFAULT 0,
  `status` enum('Pending','Daft','Published','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Published',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `exam_subjects`
--

CREATE TABLE `exam_subjects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `exam_id` bigint(20) UNSIGNED NOT NULL,
  `subject_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int(11) DEFAULT NULL,
  `category` enum('cq','mcq','pp') COLLATE utf8mb4_unicode_ci NOT NULL,
  `distribution` enum('common','science','humanities','business') COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `subject_role` enum('First','Second') COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` enum('Compulsory','Optional','Both') COLLATE utf8mb4_unicode_ci NOT NULL,
  `fullmark` double NOT NULL DEFAULT 0,
  `passmark` double NOT NULL DEFAULT 0,
  `cq_fullmark` double NOT NULL DEFAULT 0,
  `cq_passmark` double NOT NULL DEFAULT 0,
  `mcq_fullmark` double DEFAULT 0,
  `mcq_passmark` double DEFAULT 0,
  `pp_fullmark` double DEFAULT 0,
  `pp_passmark` double DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `exam_subjects`
--

INSERT INTO `exam_subjects` (`id`, `exam_id`, `subject_id`, `name`, `name_bn`, `code`, `position`, `category`, `distribution`, `parent_id`, `subject_role`, `subject_type`, `fullmark`, `passmark`, `cq_fullmark`, `cq_passmark`, `mcq_fullmark`, `mcq_passmark`, `pp_fullmark`, `pp_passmark`, `created_at`, `updated_at`) VALUES
(1, 3, 1, 'Bangla', NULL, '101', 1, 'cq', 'common', NULL, 'First', 'Compulsory', 100, 33, 100, 33, NULL, NULL, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(2, 3, 2, 'Bangla', NULL, '102', 2, 'cq', 'common', 1, 'Second', 'Compulsory', 50, 18, 50, 18, NULL, NULL, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(3, 3, 3, 'English', NULL, '107', 3, 'cq', 'common', NULL, 'First', 'Compulsory', 100, 33, 100, 33, NULL, NULL, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(4, 3, 4, 'English', NULL, '108', 4, 'cq', 'common', 3, 'Second', 'Compulsory', 50, 18, 50, 18, NULL, NULL, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(5, 3, 5, 'Information and Communication Technology', NULL, '275', 5, 'pp', 'common', NULL, 'First', 'Compulsory', 100, 33, 50, 17, 25, 8, 25, 8, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(6, 3, 6, 'Physics', NULL, '174', 6, 'pp', 'science', NULL, 'First', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 7, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(7, 3, 7, 'Physics', NULL, '175', 6, 'pp', 'science', 6, 'Second', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 8, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(8, 3, 8, 'Chemistry', NULL, '176', 6, 'pp', 'science', NULL, 'First', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 7, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(9, 3, 9, 'Chemistry', NULL, '177', 6, 'pp', 'science', 8, 'Second', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 8, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(10, 3, 10, 'Biology', NULL, '178', 6, 'pp', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 30, 10, 20, 7, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(11, 3, 11, 'Biology', NULL, '179', 6, 'pp', 'science', 10, 'Second', 'Both', 100, 33, 50, 17, 30, 10, 20, 8, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(12, 3, 12, 'Higher Math', NULL, '265', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(13, 3, 13, 'Higher Math', NULL, '266', 10, 'mcq', 'science', 12, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(14, 3, 14, 'Civics & Good Governance', NULL, '269', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(15, 3, 15, 'Civics & Good Governance', NULL, '270', 10, 'mcq', 'science', 14, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(16, 3, 16, 'Economics', NULL, '109', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(17, 3, 17, 'Economics', NULL, '110', 10, 'mcq', 'science', 16, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(18, 3, 18, 'Social Work', NULL, '271', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(19, 3, 19, 'Social Work', NULL, '272', 10, 'mcq', 'science', 18, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(20, 3, 20, 'Islamic History & Culture', NULL, '267', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(21, 3, 21, 'Islamic History & Culture', NULL, '268', 10, 'mcq', 'science', 20, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(22, 3, 22, 'Logic', NULL, '121', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(23, 3, 23, 'Logic', NULL, '122', 10, 'mcq', 'science', 22, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(24, 3, 24, 'Geopraphy', NULL, '125', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(25, 3, 25, 'Geopraphy', NULL, '126', 10, 'mcq', 'science', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(26, 3, 26, 'Psychology', NULL, '125', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(27, 3, 27, 'Psychology', NULL, '126', 10, 'mcq', 'science', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(28, 3, 28, 'Islamic Studies', NULL, '125', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(29, 3, 29, 'Islamic Studies', NULL, '126', 10, 'mcq', 'science', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(30, 3, 30, 'Accounting', NULL, '253', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(31, 3, 31, 'Accounting', NULL, '254', 10, 'mcq', 'science', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(32, 3, 32, 'Business Organization And Management', NULL, '253', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(33, 3, 33, 'Business Organization And Management', NULL, '254', 10, 'mcq', 'science', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(34, 3, 34, 'Production Management and Marketing', NULL, '286', 10, 'mcq', 'science', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36'),
(35, 3, 35, 'Production Management and Marketing', NULL, '287', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-09-07 06:20:36', '2023-09-07 06:20:36');

-- --------------------------------------------------------

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `founders`
--

CREATE TABLE `founders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `founders`
--

INSERT INTO `founders` (`id`, `title`, `name`, `description`, `avatar`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Demo', NULL, NULL, NULL, 'Active', NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `galleries`
--

CREATE TABLE `galleries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','daft') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_type_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`id`, `class_type_id`, `name`, `name_bn`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'Science', 'বিজ্ঞান', 'active', '2023-04-12 07:00:18', '2023-04-12 07:00:18'),
(2, 1, 'Humanities', 'মানবিক', 'active', '2023-04-12 07:02:56', '2023-04-12 07:02:56'),
(3, 1, 'Business Studies', 'ব্যবসায় শিক্ষা', 'active', '2023-04-12 07:05:20', '2023-04-12 07:05:20');

-- --------------------------------------------------------

--
-- Table structure for table `honored_teachers`
--

CREATE TABLE `honored_teachers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hostels`
--

CREATE TABLE `hostels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hostel_type_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `room` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fee` double(30,2) NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostels`
--

INSERT INTO `hostels` (`id`, `hostel_type_id`, `name`, `room`, `fee`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'New Boys Hostel', '5', 1000.00, 'Active', '2023-09-12 04:44:33', '2023-09-12 04:44:33', '2023-09-12 06:15:03'),
(2, 1, 'Old Boys Hostel', '5', 800.00, 'Active', '2023-09-12 04:44:33', '2023-09-12 04:44:33', '2023-09-12 06:15:08'),
(3, 2, 'Girls Hostel', '5', 1200.00, 'Active', '2023-09-12 04:44:33', '2023-09-12 04:44:33', '2023-09-12 06:15:14');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_admission_fees`
--

CREATE TABLE `hostel_admission_fees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hostel_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `type` enum('Old','New','Both') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'New',
  `added_id` bigint(20) UNSIGNED DEFAULT NULL,
  `added_at` timestamp NULL DEFAULT NULL,
  `approved_id` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected','Canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Approved',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_admission_fees`
--

INSERT INTO `hostel_admission_fees` (`id`, `name`, `hostel_id`, `amount`, `type`, `added_id`, `added_at`, `approved_id`, `approved_at`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Bodys Admission Fee', 1, 1000.00, 'New', NULL, NULL, NULL, NULL, 'Approved', NULL, '2023-09-27 07:14:55', '2023-09-27 07:17:55');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_dues`
--

CREATE TABLE `hostel_dues` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hostel_student_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `added_id` bigint(20) UNSIGNED DEFAULT NULL,
  `added_at` timestamp NULL DEFAULT NULL,
  `approved_id` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected','Canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Approved',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_dues`
--

INSERT INTO `hostel_dues` (`id`, `hostel_student_id`, `amount`, `added_id`, `added_at`, `approved_id`, `approved_at`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(6, 19, 100.00, 1, '2023-10-03 05:06:44', 1, '2023-10-03 05:06:44', 'Approved', NULL, '2023-10-03 05:06:44', '2023-10-03 05:06:44');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_fees`
--

CREATE TABLE `hostel_fees` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hostel_id` bigint(20) UNSIGNED NOT NULL,
  `year_id` bigint(20) UNSIGNED NOT NULL,
  `month_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `added_id` bigint(20) UNSIGNED DEFAULT NULL,
  `added_at` timestamp NULL DEFAULT NULL,
  `approved_id` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected','Canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Approved',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_fees`
--

INSERT INTO `hostel_fees` (`id`, `name`, `hostel_id`, `year_id`, `month_id`, `amount`, `added_id`, `added_at`, `approved_id`, `approved_at`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Monthy Rent', 1, 2, 9, 2000.00, NULL, NULL, NULL, NULL, 'Approved', NULL, '2023-09-12 10:16:35', '2023-09-12 10:24:45'),
(2, 'Monthy Rent', 1, 2, 10, 3000.00, NULL, NULL, NULL, NULL, 'Approved', NULL, '2023-09-12 10:17:05', '2023-09-12 10:24:52');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_infos`
--

CREATE TABLE `hostel_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hostel_payment_histories`
--

CREATE TABLE `hostel_payment_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hostel_student_id` bigint(20) UNSIGNED NOT NULL,
  `payment_method_id` bigint(20) UNSIGNED NOT NULL,
  `hostel_fee_id` bigint(20) UNSIGNED NOT NULL,
  `receipt_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(20,2) NOT NULL,
  `payment_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` enum('Unpaid','Paid') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Paid',
  `payment_by` enum('API','Direct') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'API',
  `paid_by` bigint(20) UNSIGNED DEFAULT NULL,
  `paid_date` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `hostel_rooms`
--

CREATE TABLE `hostel_rooms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hostel_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seat` int(11) NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_rooms`
--

INSERT INTO `hostel_rooms` (`id`, `hostel_id`, `name`, `seat`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, '01', 3, 'Active', NULL, '2023-09-12 05:10:53', '2023-09-12 05:15:58'),
(2, 1, '02', 3, 'Active', NULL, '2023-09-12 05:11:44', '2023-09-12 05:16:25'),
(3, 1, '03', 3, 'Active', NULL, '2023-09-12 05:11:51', '2023-09-12 05:16:30'),
(4, 1, '04', 3, 'Active', NULL, '2023-09-12 05:11:57', '2023-09-12 05:16:34'),
(5, 1, '05', 3, 'Active', NULL, '2023-09-12 05:12:05', '2023-09-12 05:16:39');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_students`
--

CREATE TABLE `hostel_students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hostel_uid` int(11) NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `hostel_id` bigint(20) UNSIGNED NOT NULL,
  `hostel_room_id` bigint(20) UNSIGNED NOT NULL,
  `year_id` bigint(20) UNSIGNED NOT NULL,
  `month_id` bigint(20) UNSIGNED NOT NULL,
  `student_type` enum('Old','New','Both') COLLATE utf8mb4_unicode_ci DEFAULT 'New',
  `status` enum('Pending','Approved','Leave','Hold','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `approved_id` int(11) DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_students`
--

INSERT INTO `hostel_students` (`id`, `hostel_uid`, `student_user_id`, `hostel_id`, `hostel_room_id`, `year_id`, `month_id`, `student_type`, `status`, `approved_id`, `approved_at`, `deleted_at`, `created_at`, `updated_at`) VALUES
(12, 20230001, 5, 1, 1, 2, 2, 'Old', 'Approved', NULL, NULL, NULL, '2023-09-26 07:22:49', '2023-10-08 11:46:50'),
(13, 2342, 1, 1, 1, 2, 1, 'New', 'Pending', NULL, NULL, NULL, '2023-10-03 04:51:14', '2023-10-03 04:51:14'),
(14, 2342, 2, 1, 1, 2, 2, 'New', 'Pending', NULL, NULL, NULL, '2023-10-03 04:53:01', '2023-10-03 04:53:01'),
(15, 2342, 2, 1, 1, 2, 2, 'New', 'Pending', NULL, NULL, NULL, '2023-10-03 04:54:10', '2023-10-03 04:54:10'),
(19, 121212, 1, 1, 1, 2, 10, 'New', 'Approved', NULL, NULL, NULL, '2023-10-03 05:06:44', '2023-10-08 11:46:53');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_types`
--

CREATE TABLE `hostel_types` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ban` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hostel_types`
--

INSERT INTO `hostel_types` (`id`, `name`, `name_ban`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Boys Hostel', 'বালক হোস্টেল', 'Active', '2023-09-12 04:28:30', '2023-09-12 04:28:30', '2023-09-12 04:28:30'),
(2, 'Girls Hostel', 'বালিকা হোস্টেল', 'Active', '2023-09-12 04:28:30', '2023-09-12 04:28:30', '2023-09-12 04:28:30');

-- --------------------------------------------------------

--
-- Table structure for table `hostel_waivers`
--

CREATE TABLE `hostel_waivers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `hostel_student_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(20,2) NOT NULL DEFAULT 0.00,
  `added_id` bigint(20) UNSIGNED DEFAULT NULL,
  `added_at` timestamp NULL DEFAULT NULL,
  `approved_id` bigint(20) UNSIGNED DEFAULT NULL,
  `approved_at` timestamp NULL DEFAULT NULL,
  `status` enum('Pending','Approved','Rejected','Canceled') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Approved',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `important_links`
--

CREATE TABLE `important_links` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `important_links`
--

INSERT INTO `important_links` (`id`, `name`, `name_ban`, `link`, `logo`, `status`, `created_at`, `updated_at`) VALUES
(2, 'Facbook', 'ফেসবুক', 'https://www.facebook.com', NULL, 'Active', '2023-09-25 10:59:54', '2023-09-25 11:02:26'),
(3, 'Google', 'গুগল', 'https://www.facebook.com', NULL, 'Active', '2023-09-25 11:01:03', '2023-09-25 11:02:13');

-- --------------------------------------------------------

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('default','regular','daft') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `mark_entries`
--

CREATE TABLE `mark_entries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_id` bigint(20) UNSIGNED NOT NULL,
  `exam_id` bigint(20) UNSIGNED NOT NULL,
  `exam_subject_id` bigint(20) UNSIGNED NOT NULL,
  `group_id` bigint(20) UNSIGNED NOT NULL,
  `subject_type` enum('Compulsory','Optional') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Compulsory',
  `attendance` enum('Present','Absent') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Present',
  `cq_attendance` enum('Present','Absent') COLLATE utf8mb4_unicode_ci DEFAULT 'Present',
  `cq` double(10,2) DEFAULT NULL,
  `mcq_attendance` enum('Present','Absent') COLLATE utf8mb4_unicode_ci DEFAULT 'Present',
  `mcq` double(10,2) DEFAULT NULL,
  `practial_attendance` enum('Present','Absent') COLLATE utf8mb4_unicode_ci DEFAULT 'Present',
  `practial` double(10,2) DEFAULT NULL,
  `total` double(20,2) NOT NULL,
  `grade` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `point` double(10,2) NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `teacher_user_id` bigint(20) UNSIGNED NOT NULL,
  `entry_by` enum('Staff','Teacher') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Teacher',
  `entry_user_id` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mark_entries`
--

INSERT INTO `mark_entries` (`id`, `student_id`, `exam_id`, `exam_subject_id`, `group_id`, `subject_type`, `attendance`, `cq_attendance`, `cq`, `mcq_attendance`, `mcq`, `practial_attendance`, `practial`, `total`, `grade`, `point`, `status`, `teacher_user_id`, `entry_by`, `entry_user_id`, `created_at`, `updated_at`) VALUES
(12, 26, 3, 3, 1, 'Compulsory', 'Present', 'Present', 80.00, 'Present', NULL, 'Present', NULL, 80.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(13, 28, 3, 3, 1, 'Compulsory', 'Present', 'Present', 68.00, 'Present', NULL, 'Present', NULL, 68.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(14, 29, 3, 3, 1, 'Compulsory', 'Present', 'Present', 70.00, 'Present', NULL, 'Present', NULL, 70.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(15, 30, 3, 3, 1, 'Compulsory', 'Present', 'Present', 80.00, 'Present', NULL, 'Present', NULL, 80.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(16, 31, 3, 3, 1, 'Compulsory', 'Present', 'Present', 47.00, 'Present', NULL, 'Present', NULL, 47.00, 'C', 2.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(17, 32, 3, 3, 1, 'Compulsory', 'Present', 'Present', 80.00, 'Present', NULL, 'Present', NULL, 80.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(18, 33, 3, 3, 1, 'Compulsory', 'Present', 'Present', 45.00, 'Present', NULL, 'Present', NULL, 45.00, 'C', 2.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(19, 34, 3, 3, 1, 'Compulsory', 'Present', 'Present', 30.00, 'Present', NULL, 'Present', NULL, 30.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(20, 35, 3, 3, 1, 'Compulsory', 'Present', 'Present', 20.00, 'Present', NULL, 'Present', NULL, 20.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(21, 36, 3, 3, 1, 'Compulsory', 'Present', 'Present', 44.00, 'Present', NULL, 'Present', NULL, 44.00, 'C', 2.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(22, 37, 3, 3, 1, 'Compulsory', 'Present', 'Present', 30.00, 'Present', NULL, 'Present', NULL, 30.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:45:40', '2023-09-09 10:45:40'),
(23, 26, 3, 5, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 20.00, 'Present', 21.00, 81.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(24, 28, 3, 5, 1, 'Compulsory', 'Present', 'Present', 45.00, 'Present', 22.00, 'Present', 22.00, 89.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(25, 29, 3, 5, 1, 'Compulsory', 'Present', 'Present', 42.00, 'Present', 18.00, 'Present', 13.00, 73.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(26, 30, 3, 5, 1, 'Compulsory', 'Present', 'Present', 41.00, 'Present', 17.00, 'Present', 12.00, 70.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(27, 31, 3, 5, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 22.00, 'Present', 12.00, 69.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(28, 32, 3, 5, 1, 'Compulsory', 'Present', 'Present', 20.00, 'Present', 21.00, 'Present', 15.00, 56.00, 'B', 3.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(29, 33, 3, 5, 1, 'Compulsory', 'Present', 'Present', 11.00, 'Present', 18.00, 'Present', 12.00, 41.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(30, 34, 3, 5, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 13.00, 'Present', 14.00, 62.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(31, 35, 3, 5, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 14.00, 'Present', 23.00, 77.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(32, 36, 3, 5, 1, 'Compulsory', 'Present', 'Present', 38.00, 'Present', 15.00, 'Present', 15.00, 68.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(33, 37, 3, 5, 1, 'Compulsory', 'Present', 'Present', 43.00, 'Present', 12.00, 'Present', 23.00, 78.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-09 10:47:27', '2023-09-09 10:47:27'),
(34, 26, 3, 6, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 55.00, 'Present', 15.00, 110.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:12', '2023-09-11 06:13:11'),
(35, 28, 3, 6, 1, 'Compulsory', 'Present', 'Present', 45.00, 'Present', 20.00, 'Present', 20.00, 85.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:12', '2023-09-11 05:16:12'),
(36, 29, 3, 6, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 25.00, 'Present', 15.00, 80.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:12', '2023-09-11 05:16:12'),
(37, 30, 3, 6, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 25.00, 'Present', 18.00, 78.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(38, 31, 3, 6, 1, 'Compulsory', 'Present', 'Present', 30.00, 'Present', 22.00, 'Present', 16.00, 68.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(39, 32, 3, 6, 1, 'Compulsory', 'Present', 'Present', 25.00, 'Present', 15.00, 'Present', 14.00, 54.00, 'B', 3.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(40, 33, 3, 6, 1, 'Compulsory', 'Present', 'Present', 20.00, 'Present', 14.00, 'Present', 12.00, 46.00, 'C', 2.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(41, 34, 3, 6, 1, 'Compulsory', 'Present', 'Present', 15.00, 'Present', 10.00, 'Present', 11.00, 36.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(42, 35, 3, 6, 1, 'Compulsory', 'Present', 'Present', 30.00, 'Present', 20.00, 'Present', 8.00, 58.00, 'B', 3.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(43, 36, 3, 6, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 13.00, 'Present', 16.00, 64.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(44, 37, 3, 6, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 17.00, 'Present', 12.00, 69.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:16:13', '2023-09-11 05:16:13'),
(45, 26, 3, 8, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 29.00, 'Present', 12.00, 81.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(46, 28, 3, 8, 1, 'Compulsory', 'Present', 'Present', 22.00, 'Present', 28.00, 'Present', 14.00, 64.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(47, 29, 3, 8, 1, 'Compulsory', 'Present', 'Present', 30.00, 'Present', 27.00, 'Present', 14.00, 71.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(48, 30, 3, 8, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 26.00, 'Present', 16.00, 77.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(49, 31, 3, 8, 1, 'Compulsory', 'Present', 'Present', 33.00, 'Present', 25.00, 'Present', 12.00, 70.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(50, 32, 3, 8, 1, 'Compulsory', 'Present', 'Present', 34.00, 'Present', 22.00, 'Present', 13.00, 69.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(51, 33, 3, 8, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 24.00, 'Present', 11.00, 70.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(52, 34, 3, 8, 1, 'Compulsory', 'Present', 'Present', 36.00, 'Present', 23.00, 'Present', 10.00, 69.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(53, 35, 3, 8, 1, 'Compulsory', 'Present', 'Present', 37.00, 'Present', 21.00, 'Present', 13.00, 71.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(54, 36, 3, 8, 1, 'Compulsory', 'Present', 'Present', 38.00, 'Present', 20.00, 'Present', 14.00, 72.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(55, 37, 3, 8, 1, 'Compulsory', 'Present', 'Present', 39.00, 'Present', 17.00, 'Present', 10.00, 66.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:17:22', '2023-09-11 05:17:22'),
(56, 26, 3, 10, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 24.00, 'Present', 18.00, 82.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 06:13:52'),
(57, 28, 3, 10, 1, 'Compulsory', 'Present', 'Present', 12.00, 'Present', 25.00, 'Present', 16.00, 53.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(58, 29, 3, 10, 1, 'Compulsory', 'Present', 'Present', 15.00, 'Present', 10.00, 'Present', 17.00, 42.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(59, 30, 3, 10, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 12.00, 'Present', 18.00, 70.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(60, 31, 3, 10, 1, 'Compulsory', 'Present', 'Present', 22.00, 'Present', 13.00, 'Present', 10.00, 45.00, 'C', 2.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(61, 32, 3, 10, 1, 'Compulsory', 'Present', 'Present', 32.00, 'Present', 14.00, 'Present', 12.00, 58.00, 'B', 3.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(62, 33, 3, 10, 1, 'Compulsory', 'Present', 'Present', 23.00, 'Present', 15.00, 'Present', 12.00, 50.00, 'B', 3.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(63, 34, 3, 10, 1, 'Compulsory', 'Present', 'Present', 35.00, 'Present', 16.00, 'Present', 12.00, 63.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(64, 35, 3, 10, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', 17.00, 'Present', 14.00, 71.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(65, 36, 3, 10, 1, 'Compulsory', 'Present', 'Present', 22.00, 'Present', 18.00, 'Present', 16.00, 56.00, 'B', 3.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(66, 37, 3, 10, 1, 'Compulsory', 'Present', 'Present', 10.00, 'Present', 10.00, 'Present', 12.00, 32.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:19:03', '2023-09-11 05:19:03'),
(67, 26, 3, 12, 1, 'Optional', 'Present', 'Present', 0.00, 'Present', 40.00, 'Present', NULL, 40.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 06:15:21'),
(68, 28, 3, 12, 1, 'Optional', 'Present', 'Present', 35.00, 'Present', 45.00, 'Present', NULL, 80.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(69, 29, 3, 12, 1, 'Optional', 'Present', 'Present', 30.00, 'Present', 48.00, 'Present', NULL, 78.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(70, 30, 3, 12, 1, 'Optional', 'Present', 'Present', 40.00, 'Present', 30.00, 'Present', NULL, 70.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(71, 31, 3, 12, 1, 'Optional', 'Present', 'Present', 22.00, 'Present', 40.00, 'Present', NULL, 62.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(72, 32, 3, 12, 1, 'Optional', 'Present', 'Present', 33.00, 'Present', 35.00, 'Present', NULL, 68.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(73, 33, 3, 12, 1, 'Optional', 'Present', 'Present', 44.00, 'Present', 38.00, 'Present', NULL, 82.00, 'A+', 5.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(74, 34, 3, 12, 1, 'Optional', 'Present', 'Present', 33.00, 'Present', 12.00, 'Present', NULL, 45.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(75, 35, 3, 12, 1, 'Optional', 'Present', 'Present', 25.00, 'Present', 15.00, 'Present', NULL, 40.00, 'F', 0.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(76, 36, 3, 12, 1, 'Optional', 'Present', 'Present', 45.00, 'Present', 22.00, 'Present', NULL, 67.00, 'A-', 3.50, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(77, 37, 3, 12, 1, 'Optional', 'Present', 'Present', 35.00, 'Present', 40.00, 'Present', NULL, 75.00, 'A', 4.00, 'Active', 2, 'Staff', 1, '2023-09-11 05:20:04', '2023-09-11 05:20:04'),
(78, 37, 3, 1, 1, 'Compulsory', 'Present', 'Present', 20.00, 'Present', NULL, 'Present', NULL, 20.00, 'F', 0.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(79, 36, 3, 1, 1, 'Compulsory', 'Present', 'Present', 30.00, 'Present', NULL, 'Present', NULL, 30.00, 'F', 0.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(80, 66, 3, 1, 1, 'Compulsory', 'Present', 'Present', 50.00, 'Present', NULL, 'Present', NULL, 50.00, 'B', 3.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(81, 33, 3, 1, 1, 'Compulsory', 'Present', 'Present', 52.00, 'Present', NULL, 'Present', NULL, 52.00, 'B', 3.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(82, 67, 3, 1, 1, 'Compulsory', 'Present', 'Present', 80.00, 'Present', NULL, 'Present', NULL, 80.00, 'A+', 5.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(83, 34, 3, 1, 1, 'Compulsory', 'Present', 'Present', 95.00, 'Present', NULL, 'Present', NULL, 95.00, 'A+', 5.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(84, 35, 3, 1, 1, 'Compulsory', 'Present', 'Present', 45.00, 'Present', NULL, 'Present', NULL, 45.00, 'C', 2.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(85, 29, 3, 1, 1, 'Compulsory', 'Present', 'Present', 60.00, 'Present', NULL, 'Present', NULL, 60.00, 'A-', 3.50, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(86, 4, 3, 1, 1, 'Compulsory', 'Present', 'Present', 42.00, 'Present', NULL, 'Present', NULL, 42.00, 'C', 2.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(87, 30, 3, 1, 1, 'Compulsory', 'Present', 'Present', 65.00, 'Present', NULL, 'Present', NULL, 65.00, 'A-', 3.50, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(88, 26, 3, 1, 1, 'Compulsory', 'Present', 'Present', 80.00, 'Present', NULL, 'Present', NULL, 80.00, 'A+', 5.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(89, 32, 3, 1, 1, 'Compulsory', 'Present', 'Present', 79.00, 'Present', NULL, 'Present', NULL, 79.00, 'A', 4.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(90, 28, 3, 1, 1, 'Compulsory', 'Present', 'Present', 84.00, 'Present', NULL, 'Present', NULL, 84.00, 'A+', 5.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(91, 27, 3, 1, 1, 'Compulsory', 'Present', 'Present', 12.00, 'Present', NULL, 'Present', NULL, 12.00, 'F', 0.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25'),
(92, 31, 3, 1, 1, 'Compulsory', 'Present', 'Present', 40.00, 'Present', NULL, 'Present', NULL, 40.00, 'C', 2.00, 'Active', 1, 'Staff', 1, '2023-10-09 04:13:25', '2023-10-09 04:13:25');

-- --------------------------------------------------------

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type` enum('Committee','Chairman','Principal','Donar','Ex-Member') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `designation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `profession` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `type`, `name`, `father`, `mother`, `designation`, `profession`, `duration`, `mobile`, `email`, `address`, `avatar`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Committee', 'MD. ABU TALEB', 'MD. SOFIR UDDIN', 'MOST. JAMILA BEGUM', 'Asst. Teacher & Imam', 'Engineer', '10', '01779325718', 'abutalebgmtt@gmail.com', 'M-24, West Merul Badda, Dhaka.', 'uploads/members/images/members-650c190b40b24.jpg', 'Active', '2023-09-21 10:15:53', '2023-09-21 10:20:59');

-- --------------------------------------------------------

--
-- Table structure for table `meritorious_students`
--

CREATE TABLE `meritorious_students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `roll` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `migrations`
--

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

--
-- Dumping data for table `migrations`
--

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, '2019_08_19_000000_create_failed_jobs_table', 1),
(14, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(15, '2022_11_01_041213_create_permission_tables', 1),
(16, '2022_11_22_032020_create_web_settings_table', 1),
(17, '2022_11_22_150900_create_sliders_table', 1),
(18, '2022_11_22_150925_create_news_table', 1),
(19, '2022_12_03_160525_create_contacts_table', 1),
(20, '2022_12_08_093653_create_galleries_table', 1),
(21, '2022_12_21_133103_create_blog_categories_table', 1),
(22, '2022_12_21_133125_create_blogs_table', 1),
(23, '2022_12_31_102725_create_social_media_table', 1),
(24, '2023_01_12_235516_create_countries_table', 1),
(25, '2023_01_12_235608_create_districts_table', 1),
(26, '2023_02_21_181810_create_news_comments_table', 1),
(27, '2023_02_23_114125_create_blog_comments_table', 1),
(28, '2023_03_27_151412_create_email_settings_table', 1),
(29, '2023_03_28_101050_create_subscribers_table', 1),
(30, '2023_03_28_105203_create_languages_table', 1),
(31, '2023_03_28_105242_create_currencies_table', 1),
(32, '2023_04_05_234238_create_class_types_table', 2),
(33, '2023_04_11_231723_create_student_users_table', 3),
(34, '2023_04_11_231824_create_students_infos_table', 3),
(37, '2023_04_12_115348_create_sessiones_table', 4),
(38, '2023_04_12_115413_create_groups_table', 4),
(39, '2023_04_12_115432_create_class_years_table', 4),
(46, '2023_04_12_131848_create_students_table', 5),
(47, '2023_04_16_205616_create_subjects_table', 6),
(48, '2023_04_25_102818_create_sections_table', 7),
(55, '2023_05_06_150734_create_fee_categories_table', 8),
(56, '2023_05_06_164628_create_sub_fee_categories_table', 8),
(62, '2023_05_07_165907_create_waivers_table', 9),
(63, '2023_05_07_165946_create_settlements_table', 9),
(64, '2023_05_07_170045_create_exam_improvement_dues_table', 9),
(65, '2023_05_07_170209_create_payment_histories_table', 9),
(66, '2023_05_07_173740_create_payment_history_details_table', 9),
(68, '2023_05_09_124620_create_payment_methods_table', 10),
(69, '2023_05_11_211356_create_teacher_users_table', 11),
(70, '2023_05_11_211610_create_teachers_table', 11),
(71, '2023_08_09_092713_create_payment_permissions_table', 12),
(72, '2023_08_10_120217_create_exams_table', 13),
(73, '2023_08_10_120236_create_exam_subjects_table', 13),
(74, '2023_08_10_120317_create_subject_students_table', 13),
(75, '2023_08_10_120335_create_subject_teachers_table', 13),
(76, '2023_08_10_121739_create_mark_entries_table', 13),
(77, '2023_08_10_122822_create_result_summeries_table', 13),
(78, '2023_08_11_011725_create_years_table', 14),
(79, '2023_09_12_000958_create_months_table', 15),
(88, '2023_09_11_234941_create_hostel_types_table', 16),
(89, '2023_09_11_235154_create_hostels_table', 16),
(90, '2023_09_11_235211_create_hostel_rooms_table', 16),
(91, '2023_09_11_235245_create_hostel_students_table', 16),
(92, '2023_09_12_001119_create_hostel_dues_table', 16),
(93, '2023_09_12_001139_create_hostel_waivers_table', 16),
(94, '2023_09_12_001203_create_hostel_fees_table', 16),
(95, '2023_09_12_173636_create_hostel_payment_histories_table', 17),
(96, '2023_09_14_102419_create_about_us_table', 18),
(97, '2023_09_14_170553_create_student_education_table', 19),
(98, '2023_09_14_171739_create_education_boards_table', 20),
(99, '2023_09_20_162449_create_notices_table', 21),
(100, '2023_09_20_162747_create_president_messages_table', 21),
(101, '2023_09_20_162817_create_principal_messages_table', 21),
(102, '2023_09_20_165854_create_important_links_table', 21),
(103, '2023_09_20_170130_create_scouts_table', 21),
(104, '2023_09_20_170547_create_bandhans_table', 21),
(105, '2023_09_20_170610_create_cultural_forums_table', 21),
(106, '2023_09_20_170758_create_honored_teachers_table', 21),
(107, '2023_09_20_170911_create_founders_table', 21),
(108, '2023_09_20_171055_create_book_categories_table', 21),
(109, '2023_09_20_171109_create_book_authors_table', 21),
(110, '2023_09_20_171133_create_book_publications_table', 21),
(111, '2023_09_20_172226_create_books_table', 21),
(112, '2023_09_20_172817_create_book_rents_table', 21),
(113, '2023_09_20_173245_create_testimonials_table', 21),
(114, '2023_09_21_111432_create_members_table', 21),
(115, '2023_09_21_151820_create_hostel_infos_table', 22),
(116, '2023_09_21_163718_create_contents_table', 23),
(117, '2023_09_21_164948_create_meritorious_students_table', 23),
(118, '2023_09_21_172439_create_religions_table', 24),
(119, '2023_09_21_172834_create_departments_table', 25),
(120, '2023_09_22_234417_create_class_routines_table', 26),
(121, '2023_09_22_235239_create_exam_routines_table', 26),
(123, '2023_09_23_000752_create_office_staff_table', 27),
(124, '2023_09_23_005532_create_sms_histories_table', 28),
(125, '2023_09_23_005624_create_student_attendances_table', 28),
(126, '2023_09_23_005701_create_teacher_attendances_table', 28),
(127, '2023_09_23_005746_create_office_attendances_table', 28),
(128, '2023_09_23_005825_create_student_attendance_details_table', 28),
(129, '2023_09_23_012341_create_student_card_attendances_table', 28),
(130, '2023_09_27_115541_create_hostel_admission_fees_table', 29),
(131, '2023_09_27_131912_create_document_types_table', 30),
(132, '2023_09_27_131944_create_document_dues_table', 30);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--

INSERT INTO `model_has_permissions` (`permission_id`, `model_type`, `model_id`) VALUES
(1, 'App\\Models\\User', 1),
(1, 'App\\Models\\User', 2),
(2, 'App\\Models\\User', 1),
(3, 'App\\Models\\User', 1),
(4, 'App\\Models\\User', 1),
(5, 'App\\Models\\User', 1),
(6, 'App\\Models\\User', 1),
(6, 'App\\Models\\User', 2),
(7, 'App\\Models\\User', 1),
(7, 'App\\Models\\User', 2),
(8, 'App\\Models\\User', 1),
(9, 'App\\Models\\User', 1),
(10, 'App\\Models\\User', 1),
(11, 'App\\Models\\User', 1),
(12, 'App\\Models\\User', 1),
(13, 'App\\Models\\User', 1),
(14, 'App\\Models\\User', 1),
(15, 'App\\Models\\User', 1),
(15, 'App\\Models\\User', 2);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `months`
--

CREATE TABLE `months` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ban` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `months`
--

INSERT INTO `months` (`id`, `name`, `name_ban`, `number`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'January', 'জানুয়ারি', 1, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(2, 'February', 'ফেব্রুয়ারি', 2, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(3, 'March', 'মার্চ', 3, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(4, 'April', 'এপ্রিল', 4, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(5, 'May', 'মে', 5, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(6, 'June', 'জুন', 6, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(7, 'July', 'জুলাই', 7, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(8, 'August', 'আগস্ট', 8, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(9, 'September', 'সেপ্টেম্বর', 9, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(10, 'Octorbar', 'অক্টোবর', 10, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(11, 'November', 'নভেম্বর', 11, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35'),
(12, 'December', 'ডিসেম্বর', 12, 'Active', '2023-09-12 04:11:35', '2023-09-12 04:11:35', '2023-09-12 04:11:35');

-- --------------------------------------------------------

--
-- Table structure for table `news`
--

CREATE TABLE `news` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `title_bn` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('publish','daft','delete') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'publish',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `news_comments`
--

CREATE TABLE `news_comments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `news_id` int(11) DEFAULT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `office_attendances`
--

CREATE TABLE `office_attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `office_staff_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `intime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `outtime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_history_details`
--

CREATE TABLE `payment_history_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `payment_history_id` bigint(20) UNSIGNED NOT NULL,
  `fee_category_id` bigint(20) UNSIGNED NOT NULL,
  `amount` double(30,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Active','Deactived') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `name`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Cash', 'Active', NULL, '2023-05-11 08:34:32', '2023-05-11 08:34:32'),
(2, 'Nagad', 'Active', NULL, '2023-05-11 08:34:32', '2023-05-11 08:34:32'),
(3, 'Tap', 'Active', NULL, '2023-05-11 08:34:32', '2023-05-11 08:34:32');

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'User Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'Permissions', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'Setting', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'Location', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'Website', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'Student Setting', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'Student Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'Teacher Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'Exam Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 'Hostel Fee Setting', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'Hostel Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 'Academic Setting', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 'Library Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 'Student Application', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 'Payment Management', 'web', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- --------------------------------------------------------

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `president_messages`
--

CREATE TABLE `president_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `principal_messages`
--

CREATE TABLE `principal_messages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `religions`
--

CREATE TABLE `religions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `religions`
--

INSERT INTO `religions` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Islam', 'Active', '2023-09-21 11:27:34', '2023-09-21 11:27:34'),
(2, 'Hindu', 'Active', '2023-09-21 11:27:34', '2023-09-21 11:27:34'),
(3, 'Christian', 'Active', '2023-09-21 11:27:34', '2023-09-21 11:27:34'),
(4, 'Buddhism', 'Active', '2023-09-21 11:27:34', '2023-09-21 11:27:34');

-- --------------------------------------------------------

--
-- Table structure for table `result_summeries`
--

CREATE TABLE `result_summeries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `exam_id` bigint(20) UNSIGNED NOT NULL,
  `student_id` bigint(20) UNSIGNED NOT NULL,
  `rgroup_id` int(10) DEFAULT NULL,
  `attendance` enum('Present','Absent') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Present',
  `total` double(20,2) NOT NULL,
  `grade` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `point` double(10,2) NOT NULL,
  `withoutpoint` double(20,2) DEFAULT NULL,
  `failpoint` double(20,2) DEFAULT NULL,
  `position` int(10) DEFAULT NULL,
  `status` enum('Pending','Publish','Unpublish','Suspended') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `result_summeries`
--

INSERT INTO `result_summeries` (`id`, `exam_id`, `student_id`, `rgroup_id`, `attendance`, `total`, `grade`, `point`, `withoutpoint`, `failpoint`, `position`, `status`, `created_at`, `updated_at`) VALUES
(48, 3, 26, NULL, 'Present', 564.00, 'A+', 5.00, 5.00, 5.00, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(49, 3, 28, NULL, 'Present', 489.00, 'F', 0.00, 0.00, 3.83, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(50, 3, 29, NULL, 'Present', 474.00, 'F', 0.00, 0.00, 3.75, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(51, 3, 30, NULL, 'Present', 510.00, 'A', 4.42, 4.08, 4.42, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(52, 3, 31, NULL, 'Present', 401.00, 'B', 3.08, 2.83, 3.08, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(53, 3, 32, NULL, 'Present', 480.00, 'A', 4.00, 3.75, 4.00, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(54, 3, 33, NULL, 'Present', 422.00, 'F', 0.00, 0.00, 3.17, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(55, 3, 34, NULL, 'Present', 384.00, 'F', 0.00, 0.00, 2.42, NULL, 'Pending', '2023-09-11 06:39:43', '2023-09-11 06:39:43'),
(56, 3, 35, NULL, 'Present', 382.00, 'F', 0.00, 0.00, 2.83, NULL, 'Pending', '2023-09-11 06:39:44', '2023-09-11 06:39:44'),
(57, 3, 36, NULL, 'Present', 391.00, 'F', 0.00, 0.00, 2.92, NULL, 'Pending', '2023-09-11 06:39:44', '2023-09-11 06:39:44'),
(58, 3, 37, NULL, 'Absent', 431.00, 'F', 0.00, 0.00, 3.00, NULL, 'Pending', '2023-09-11 06:39:44', '2023-09-11 06:39:44');

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'web', '2023-04-05 17:31:55', '2023-04-05 17:31:55'),
(2, 'vendor', 'web', '2023-04-05 17:31:55', '2023-04-05 17:31:55'),
(3, 'user', 'web', '2023-04-05 17:31:55', '2023-04-05 17:31:55');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `scouts`
--

CREATE TABLE `scouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('Pending','Active','Canceled','Out','Suspended') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `active_by` bigint(20) UNSIGNED DEFAULT NULL,
  `active_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sessiones`
--

CREATE TABLE `sessiones` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessiones`
--

INSERT INTO `sessiones` (`id`, `name`, `name_bn`, `status`, `created_at`, `updated_at`) VALUES
(1, '2019-20', '২০১৯-২০', 'active', '2023-04-12 07:10:28', '2023-04-12 07:10:28'),
(2, '2020-21', '২০২০-২১', 'active', '2023-06-10 05:57:56', '2023-06-10 05:57:56'),
(3, '2021-22', '২০২১-২২', 'active', '2023-06-10 05:58:16', '2023-06-10 05:58:16'),
(4, '2022-23', '২০২২-২৩', 'active', '2023-06-10 06:10:44', '2023-06-10 06:10:44');

-- --------------------------------------------------------

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('active','deactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `name`, `name_bn`, `image`, `link`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Silder 01', NULL, 'uploads/sliders/images/sliders-65116b22d4ad3.jpg', NULL, 'active', NULL, '2023-09-25 11:12:34', '2023-09-25 11:12:34'),
(2, 'Silder 01', NULL, 'uploads/sliders/images/sliders-65116b29ca6c2.jpg', NULL, 'active', NULL, '2023-09-25 11:12:41', '2023-09-25 11:12:41');

-- --------------------------------------------------------

--
-- Table structure for table `sms_histories`
--

CREATE TABLE `sms_histories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `module` enum('Student','Teacher','OfficeStaff','Members','User','General') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'General',
  `user_id` int(11) DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('Delivered','Pending') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Delivered',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `social_media`
--

CREATE TABLE `social_media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Deactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `social_media`
--

INSERT INTO `social_media` (`id`, `name`, `name_bn`, `icon`, `link`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Facebook', 'Facebook', 'fas fa-facebook', 'https://www.facebook.com', 'Active', NULL, '2023-04-05 17:31:55', '2023-04-05 17:31:55'),
(2, 'Twitter', 'Twitter', 'fas fa-twitter', 'https://www.twitter.com', 'Active', NULL, '2023-04-05 17:31:55', '2023-04-05 17:31:55'),
(3, 'Youtube', 'Youtube', 'fas fa-youtube', 'https://www.youtube.com', 'Active', NULL, '2023-04-05 17:31:55', '2023-04-05 17:31:55');

-- --------------------------------------------------------

--
-- Table structure for table `students_infos`
--

CREATE TABLE `students_infos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `father` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_nid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_occupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `father_annual_income` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_nid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_occupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother_annual_income` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_relationship` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_nid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `guardian_occupation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `careof` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `blood_group` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion_id` int(11) DEFAULT NULL,
  `gender` enum('Male','Female') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marriage_status` enum('Married','Unmarried') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unmarried',
  `country_id` bigint(20) UNSIGNED DEFAULT 1,
  `district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `district_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `police_station` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_office` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_country_id` bigint(20) UNSIGNED DEFAULT 1,
  `per_district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `per_district_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_police_station` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_post_office` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_post_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `per_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `students_infos`
--

INSERT INTO `students_infos` (`id`, `student_user_id`, `father`, `father_bn`, `father_mobile`, `father_nid`, `father_avatar`, `father_occupation`, `father_annual_income`, `mother`, `mother_bn`, `mother_mobile`, `mother_nid`, `mother_avatar`, `mother_occupation`, `mother_annual_income`, `guardian`, `guardian_bn`, `guardian_relationship`, `guardian_mobile`, `guardian_nid`, `guardian_avatar`, `guardian_occupation`, `careof`, `dob`, `blood_group`, `religion_id`, `gender`, `marriage_status`, `country_id`, `district_id`, `district_name`, `police_station`, `post_office`, `post_code`, `address`, `per_country_id`, `per_district_id`, `per_district_name`, `per_police_station`, `per_post_office`, `per_post_code`, `per_address`, `created_at`, `updated_at`) VALUES
(1, 1, 'MD. ABDUL BAREK', 'MD. ABDUL BAREK', '01795624164', NULL, NULL, NULL, NULL, 'MST. HAJERA KHATUN', 'MST. HAJERA KHATUN', '01795624164', NULL, NULL, NULL, NULL, 'MD. ABDUL BAREK', 'MD. ABDUL BAREK', NULL, '01795624164', NULL, NULL, NULL, 'MD. ABDUL BAREK', '2003-10-15', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Trishal', 'Pazlarchar', NULL, 'Dhanikhola Vati Das Para', 1, NULL, 'Mymensingh', 'Trishal', 'Pazlarchar', NULL, 'Dhanikhola Vati Das Para', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(2, 2, 'FAZLU RAHMAN', 'FAZLU RAHMAN', '01797605244', NULL, NULL, NULL, NULL, 'MS. MINA', 'MS. MINA', '01757207789', NULL, NULL, NULL, NULL, 'FAZLU RAHMAN', 'FAZLU RAHMAN', NULL, '01797605244', NULL, NULL, NULL, 'FAZLU RAHMAN', '2000-05-15', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'NETRAKONA', 'MADAN', 'BALALI', NULL, 'BALALI', 1, NULL, 'NETRAKONA', 'MADAN', 'BALALI', NULL, 'BALALI', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(3, 3, 'Bimol Ghosh', 'Bimol Ghosh', '01746065021', NULL, NULL, NULL, NULL, 'Sayarani Ghosh', 'Sayarani Ghosh', '01746065021', NULL, NULL, NULL, NULL, 'Bimol Ghosh', 'Bimol Ghosh', NULL, '01746065021', NULL, NULL, NULL, 'Bimol Ghosh', '2001-02-10', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Sherpur', 'Nalitabari', 'Nalitabari', NULL, 'Gorkanda Sahapara', 1, NULL, 'Sherpur', 'Nalitabari', 'Nalitabari', NULL, 'Gorkanda Sahapara', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(4, 4, 'MD. HATEM ALI', 'MD. HATEM ALI', '01770583746', NULL, NULL, NULL, NULL, 'MST. RAHELA KHATUN', 'MST. RAHELA KHATUN', '01725427600', NULL, NULL, NULL, NULL, 'MD. HATEM ALI', 'MD. HATEM ALI', NULL, '01770583746', NULL, NULL, NULL, 'MD. HATEM ALI', '2003-08-04', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Mymensingh', 'Fulbaria', 'Kandania Bazar', NULL, 'Kandania', 1, NULL, 'Mymensingh', 'Fulbaria', 'Kandania Bazar', NULL, 'Kandania', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(5, 5, 'KHORSHED ALOM', 'KHORSHED ALOM', '01790996860', NULL, NULL, NULL, NULL, 'MOSADA KHATUN', 'MOSADA KHATUN', '01790996860', NULL, NULL, NULL, NULL, 'KHORSHED ALOM', 'KHORSHED ALOM', NULL, '01790996860', NULL, NULL, NULL, 'KHORSHED ALOM', '2001-06-10', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'trishal', 'MUKSHAPUR', NULL, 'MUKSHAPUR', 1, NULL, 'MYMENSINGH', 'trishal', 'MUKSHAPUR', NULL, 'MUKSHAPUR', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(6, 6, 'md. gulam mustafa labu', 'md. gulam mustafa labu', '01712536593', NULL, NULL, NULL, NULL, 'mst. hasina khatun chadni', 'mst. hasina khatun chadni', '01732405893', NULL, NULL, NULL, NULL, 'md. gulam mustafa labu', 'md. gulam mustafa labu', NULL, '01712536593', NULL, NULL, NULL, 'md. gulam mustafa labu', '1970-01-01', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'SHERPUR', 'NALITABARI', 'NALITABARI', NULL, 'NALITABARI', 1, NULL, 'SHERPUR', 'NALITABARI', 'NALITABARI', NULL, 'NALITABARI', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(7, 7, 'KHUKA MANDOL', 'KHUKA MANDOL', '01965033986', NULL, NULL, NULL, NULL, 'GITA RANI MANDOL', 'GITA RANI MANDOL', '01965033986', NULL, NULL, NULL, NULL, 'KHUKA MANDOL', 'KHUKA MANDOL', NULL, '01965033986', NULL, NULL, NULL, 'KHUKA MANDOL', '2002-06-03', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'NETRAKONA', 'KALMAKANDA', 'BALUCHORA', NULL, 'NALCHAPRA', 1, NULL, 'NETRAKONA', 'KALMAKANDA', 'BALUCHORA', NULL, 'NALCHAPRA', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(8, 8, 'HASIM UDDIN  FAKIR', 'HASIM UDDIN  FAKIR', '01885193357', NULL, NULL, NULL, NULL, 'HELENA KHATUN', 'HELENA KHATUN', '01885193357', NULL, NULL, NULL, NULL, 'HASIM UDDIN  FAKIR', 'HASIM UDDIN  FAKIR', NULL, '01885193357', NULL, NULL, NULL, 'HASIM UDDIN  FAKIR', '2002-02-20', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TARAKANDA', 'HAZIGONJ', NULL, 'NAKIJANI', 1, NULL, 'MYMENSINGH', 'TARAKANDA', 'HAZIGONJ', NULL, 'NAKIJANI', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(9, 9, 'MD. MAKHAN MIA', 'MD. MAKHAN MIA', '01740262075', NULL, NULL, NULL, NULL, 'ANJUMANARA KHATUN', 'ANJUMANARA KHATUN', '017', NULL, NULL, NULL, NULL, 'MD. MAKHAN MIA', 'MD. MAKHAN MIA', NULL, '01740262075', NULL, NULL, NULL, 'MD. MAKHAN MIA', '2001-12-16', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'PHULPUR', 'KHORIAPARA', NULL, 'MICHKIPARA', 1, NULL, 'MYMENSINGH', 'PHULPUR', 'KHORIAPARA', NULL, 'MICHKIPARA', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(10, 10, 'A.R.M. OBAID ULLAH', 'A.R.M. OBAID ULLAH', '01988622644', NULL, NULL, NULL, NULL, 'SALMA FERDOUS', 'SALMA FERDOUS', '01988622644', NULL, NULL, NULL, NULL, 'A.R.M. OBAID ULLAH', 'A.R.M. OBAID ULLAH', NULL, '01988622644', NULL, NULL, NULL, 'SALMA FERDOUS', '2003-06-02', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'HALUAGHAT', NULL, 'HALUAGHAT BAZAR', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'HALUAGHAT', NULL, 'HALUAGHAT BAZAR', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(11, 11, 'MD. SOLAIMAN', 'MD. SOLAIMAN', '01725374565', NULL, NULL, NULL, NULL, 'MST. FATEMA AKTER', 'MST. FATEMA AKTER', '01725374565', NULL, NULL, NULL, NULL, 'MD. SOLAIMAN', 'MD. SOLAIMAN', NULL, '01725374565', NULL, NULL, NULL, 'MD. SOLAIMAN', '2003-01-03', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'kotwali', 'Bhaluka', NULL, 'MADUARIY', 1, NULL, 'MYMENSINGH', 'kotwali', 'Bhaluka', NULL, 'MADUARIY', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(12, 12, 'Md. Shahidul Islam', 'Md. Shahidul Islam', '01595352235', NULL, NULL, NULL, NULL, 'Nurunnahar Khatun', 'Nurunnahar Khatun', '01780193482', NULL, NULL, NULL, NULL, 'Md. Shahidul Islam', 'Md. Shahidul Islam', NULL, '01595352235', NULL, NULL, NULL, 'Md. Shahidul Islam', '2002-09-25', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'MYMENSINGH SADAR', 'Char Kharicha Bazar (2252)', NULL, 'Char Vobanipur', 1, NULL, 'MYMENSINGH', 'MYMENSINGH SADAR', 'Char Kharicha Bazar (2252)', NULL, 'Char Vobanipur', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(13, 13, 'SHOHIDUL ISLAM', 'SHOHIDUL ISLAM', '01717814477', NULL, NULL, NULL, NULL, 'DILUARA BEGOM', 'DILUARA BEGOM', '01311471293', NULL, NULL, NULL, NULL, 'SHOHIDUL ISLAM', 'SHOHIDUL ISLAM', NULL, '01717814477', NULL, NULL, NULL, 'SHOHIDUL ISLAM', '2001-07-27', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Tarakanda', 'Tarakanda', NULL, 'Dowhatoli', 1, NULL, 'Mymensingh', 'Tarakanda', 'Tarakanda', NULL, 'Dowhatoli', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(14, 14, 'MD.MONIR UDDIN AKANDA', 'MD.MONIR UDDIN AKANDA', '01628958022', NULL, NULL, NULL, NULL, 'SURAIYA BEGUM', 'SURAIYA BEGUM', '01640588434', NULL, NULL, NULL, NULL, 'MD.MONIR UDDIN AKANDA', 'MD.MONIR UDDIN AKANDA', NULL, '01628958022', NULL, NULL, NULL, 'MD.MONIR UDDIN AKANDA', '2003-01-24', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'BHALUKA,MYMENSINGH', 'BHALUKA,MYMENSINGH', NULL, 'BHALUKA,MYMENSINGH', 1, NULL, 'MYMENSINGH', 'BHALUKA,MYMENSINGH', 'BHALUKA,MYMENSINGH', NULL, 'BHALUKA,MYMENSINGH', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(15, 15, 'MD. SHAFIQUIZZAMAN', 'MD. SHAFIQUIZZAMAN', '01521447300', NULL, NULL, NULL, NULL, 'ROKEYA BEGUN', 'ROKEYA BEGUN', '01521447300', NULL, NULL, NULL, NULL, 'MD. SHAFIQUIZZAMAN', 'MD. SHAFIQUIZZAMAN', NULL, '01521447300', NULL, NULL, NULL, 'RIAZ UDDIN', '2002-03-10', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Bhaluka', 'Mollikbari', NULL, 'Mamarishpur', 1, NULL, 'Mymensingh', 'Bhaluka', 'Mollikbari', NULL, 'Mamarishpur', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(16, 16, 'MD. RAFIQUL ISLAM', 'MD. RAFIQUL ISLAM', '01727683315', NULL, NULL, NULL, NULL, 'MOLIDA AKTER', 'MOLIDA AKTER', '01728379958', NULL, NULL, NULL, NULL, 'MD. RAFIQUL ISLAM', 'MD. RAFIQUL ISLAM', NULL, '01727683315', NULL, NULL, NULL, 'MD. RAFIQUL ISLAM', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'BOROBILA BAZAR-2216', NULL, 'BHOBANIPUR', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'BOROBILA BAZAR-2216', NULL, 'BHOBANIPUR', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(17, 17, 'NARENDRANATH SARKER', 'NARENDRANATH SARKER', '01733168149', NULL, NULL, NULL, NULL, 'SUNITI RANI BARMAN', 'SUNITI RANI BARMAN', '01613583779', NULL, NULL, NULL, NULL, 'NARENDRANATH SARKER', 'NARENDRANATH SARKER', NULL, '01733168149', NULL, NULL, NULL, 'NARENDRANATH SARKER', '2004-01-03', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'SOUATH KANDA', NULL, 'RAYERGRAM', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'SOUATH KANDA', NULL, 'RAYERGRAM', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(18, 18, 'MD. HASAN MIA', 'MD. HASAN MIA', '01713525556', NULL, NULL, NULL, NULL, 'MST. NASIMA BEGUM', 'MST. NASIMA BEGUM', '01731770459', NULL, NULL, NULL, NULL, 'MD. HASAN MIA', 'MD. HASAN MIA', NULL, '01713525556', NULL, NULL, NULL, 'MD. HASAN MIA', '1970-01-01', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'BHALUKA', 'ANGARGARA', NULL, 'SITAL', 1, NULL, 'MYMENSINGH', 'BHALUKA', 'ANGARGARA', NULL, 'SITAL', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(19, 19, 'MD. ERSHAD ALI SARKER', 'MD. ERSHAD ALI SARKER', '01734012559', NULL, NULL, NULL, NULL, 'SULEMA KHATUN', 'SULEMA KHATUN', '01963654027', NULL, NULL, NULL, NULL, 'MD. ERSHAD ALI SARKER', 'MD. ERSHAD ALI SARKER', NULL, '01734012559', NULL, NULL, NULL, 'MD. ERSHAD ALI SARKER', '2001-11-10', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'PHULPUR', 'SHALIA', NULL, 'BIRAMPUR', 1, NULL, 'MYMENSINGH', 'PHULPUR', 'SHALIA', NULL, 'BIRAMPUR', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(20, 20, 'MD. SARWAR JAHAN', 'MD. SARWAR JAHAN', '01647350593', NULL, NULL, NULL, NULL, 'RUKSHANA BEGUM', 'RUKSHANA BEGUM', '01712654238', NULL, NULL, NULL, NULL, 'MD. SARWAR JAHAN', 'MD. SARWAR JAHAN', NULL, '01647350593', NULL, NULL, NULL, 'MD. SARWAR JAHAN', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'kotwali', 'SADAR', NULL, 'RK MISSION ROAD', 1, NULL, 'MYMENSINGH', 'kotwali', 'SADAR', NULL, 'RK MISSION ROAD', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(21, 21, 'MD. MASHIUR RAHMAN', 'MD. MASHIUR RAHMAN', '01772234468', NULL, NULL, NULL, NULL, 'MST. SHAHINA AKTER HELEN', 'MST. SHAHINA AKTER HELEN', '01772234468', NULL, NULL, NULL, NULL, 'MD. MASHIUR RAHMAN', 'MD. MASHIUR RAHMAN', NULL, '01772234468', NULL, NULL, NULL, 'MST. SHAHINA AKTER HELEN', '2003-11-11', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Mymensingh', 'Fulbaria', 'Alim Nagar', NULL, 'Kali Bazail', 1, NULL, 'Mymensingh', 'Fulbaria', 'Alim Nagar', NULL, 'Kali Bazail', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(22, 22, 'MD. JAHID HASAN', 'MD. JAHID HASAN', '01716757179', NULL, NULL, NULL, NULL, 'FARIDA YASMIN', 'FARIDA YASMIN', '01735990017', NULL, NULL, NULL, NULL, 'MD. JAHID HASAN', 'MD. JAHID HASAN', NULL, '01716757179', NULL, NULL, NULL, 'MD. JAHID HASAN', '2003-01-11', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'kotwali', 'SADAR', NULL, 'SA SARKAR ROAD', 1, NULL, 'MYMENSINGH', 'kotwali', 'SADAR', NULL, 'SA SARKAR ROAD', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(23, 23, 'OMAR FARUQUE JOGLU', 'OMAR FARUQUE JOGLU', '01955491324', NULL, NULL, NULL, NULL, 'RAZIA SULTANA RIPA', 'RAZIA SULTANA RIPA', '01747752000', NULL, NULL, NULL, NULL, 'OMAR FARUQUE JOGLU', 'OMAR FARUQUE JOGLU', NULL, '01955491324', NULL, NULL, NULL, 'OMAR FARUQUE JOGLU', '2003-12-02', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Jamalpur', 'Madergonj', 'Madergonj', NULL, 'Uttor Graber Gram', 1, NULL, 'Jamalpur', 'Madergonj', 'Madergonj', NULL, 'Uttor Graber Gram', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(24, 24, 'ABDUR RAZZAQUE', 'ABDUR RAZZAQUE', '01789109595', NULL, NULL, NULL, NULL, 'FARIDA KHATUN', 'FARIDA KHATUN', '017', NULL, NULL, NULL, NULL, 'ABDUR RAZZAQUE', 'ABDUR RAZZAQUE', NULL, '01789109595', NULL, NULL, NULL, 'ABDUR RAZZAQUE', '2001-03-03', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'DHARA', NULL, 'BIRGUCHINA', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'DHARA', NULL, 'BIRGUCHINA', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(25, 25, 'MD. JAKIR HOSSAIN', 'MD. JAKIR HOSSAIN', '01700548464', NULL, NULL, NULL, NULL, 'MAKSUDA BEGUM', 'MAKSUDA BEGUM', '01763892948', NULL, NULL, NULL, NULL, 'MD. JAKIR HOSSAIN', 'MD. JAKIR HOSSAIN', NULL, '01700548464', NULL, NULL, NULL, 'MD. JAKIR HOSSAIN', '2003-11-03', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'FULPUR', 'FULPUR AMUAKANDA', NULL, 'FULPUR AMUAKANDA', 1, NULL, 'MYMENSINGH', 'FULPUR', 'FULPUR AMUAKANDA', NULL, 'FULPUR AMUAKANDA', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(26, 26, 'MD. SYFUL ISLAM', 'MD. SYFUL ISLAM', '01738093565', NULL, NULL, NULL, NULL, 'MST. KOLPONA BEGUM', 'MST. KOLPONA BEGUM', '01738093565', NULL, NULL, NULL, NULL, 'MD. SYFUL ISLAM', 'MD. SYFUL ISLAM', NULL, '01738093565', NULL, NULL, NULL, 'MD. SYFUL ISLAM', '2003-10-26', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'Kaladara', NULL, 'Horbari', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'Kaladara', NULL, 'Horbari', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(27, 27, 'ABDUL BAREK', 'ABDUL BAREK', '01910610755', NULL, NULL, NULL, NULL, 'RAHIMA AKTER', 'RAHIMA AKTER', '01910610755', NULL, NULL, NULL, NULL, 'ABDUL BAREK', 'ABDUL BAREK', NULL, '01910610755', NULL, NULL, NULL, 'ABDUL BAREK', '1970-01-01', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'DHOBAURA', 'GOATALA', NULL, 'GOATALA', 1, NULL, 'MYMENSINGH', 'DHOBAURA', 'GOATALA', NULL, 'GOATALA', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(28, 28, 'MD. ABDUL MALEK', 'MD. ABDUL MALEK', '01705539220', NULL, NULL, NULL, NULL, 'REHANA BEGUM', 'REHANA BEGUM', '01930948369', NULL, NULL, NULL, NULL, 'MD. ABDUL MALEK', 'MD. ABDUL MALEK', NULL, '01705539220', NULL, NULL, NULL, 'MD. ABDUL MALEK', '2003-02-06', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Kotwali Thana, Sadar, Mymensingh', 'Shambuganj', NULL, 'Char Laxmipur', 1, NULL, 'Mymensingh', 'Kotwali Thana, Sadar, Mymensingh', 'Shambuganj', NULL, 'Char Laxmipur', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(29, 29, 'MD. SHAHIDUL ISLAM', 'MD. SHAHIDUL ISLAM', '01732119089', NULL, NULL, NULL, NULL, 'MST. NASIMA KHATUN', 'MST. NASIMA KHATUN', '01933280999', NULL, NULL, NULL, NULL, 'MD. SHAHIDUL ISLAM', 'MD. SHAHIDUL ISLAM', NULL, '01732119089', NULL, NULL, NULL, 'MD. SHAHIDUL ISLAM', '2001-05-11', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'BHALUKA', 'HOBIRBARI', NULL, 'JAMIRDIA', 1, NULL, 'MYMENSINGH', 'BHALUKA', 'HOBIRBARI', NULL, 'JAMIRDIA', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(30, 30, 'MD. AKTARUJJAMAN', 'MD. AKTARUJJAMAN', '01925106298', NULL, NULL, NULL, NULL, 'NASIMA KHATUN', 'NASIMA KHATUN', '01925106298', NULL, NULL, NULL, NULL, 'MD. AKTARUJJAMAN', 'MD. AKTARUJJAMAN', NULL, '01925106298', NULL, NULL, NULL, 'MD. AKTARUJJAMAN', '2002-12-27', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'ISHWARGANJ', 'UCHAKHILA', NULL, 'MORICHAR CHOR', 1, NULL, 'MYMENSINGH', 'ISHWARGANJ', 'UCHAKHILA', NULL, 'MORICHAR CHOR', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(31, 31, 'HARUNOR RASHID', 'HARUNOR RASHID', '01729957927', NULL, NULL, NULL, NULL, 'SHAMIMA AKTER RUMA', 'SHAMIMA AKTER RUMA', '01729957927', NULL, NULL, NULL, NULL, 'HARUNOR RASHID', 'HARUNOR RASHID', NULL, '01729957927', NULL, NULL, NULL, 'HARUNOR RASHID', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'SHERPUR', 'SREEBORDI', 'EAST JHINIA', NULL, 'CHITHAILA', 1, NULL, 'SHERPUR', 'SREEBORDI', 'EAST JHINIA', NULL, 'CHITHAILA', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(32, 32, 'HOMAYON KABIR MONSI', 'HOMAYON KABIR MONSI', '01725060772', NULL, NULL, NULL, NULL, 'SHARMIN AKTER SHULI', 'SHARMIN AKTER SHULI', '01787130703', NULL, NULL, NULL, NULL, 'HOMAYON KABIR MONSI', 'HOMAYON KABIR MONSI', NULL, '01725060772', NULL, NULL, NULL, 'HOMAYON KABIR MONSI', '2002-08-12', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'VALUKA', 'KATHLY', NULL, 'KATHLY', 1, NULL, 'MYMENSINGH', 'VALUKA', 'KATHLY', NULL, 'KATHLY', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(33, 33, 'MD. BOZLUR RASHID SIDDIQUE', 'MD. BOZLUR RASHID SIDDIQUE', '01923900392', NULL, NULL, NULL, NULL, 'ROZINA BEGUM', 'ROZINA BEGUM', '01718664798', NULL, NULL, NULL, NULL, 'MD. BOZLUR RASHID SIDDIQUE', 'MD. BOZLUR RASHID SIDDIQUE', NULL, '01923900392', NULL, NULL, NULL, 'MD. BOZLUR RASHID SIDDIQUE', '2002-01-02', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Jamalpur', 'Sarishabari', 'Sarishabari', NULL, 'Maizbari', 1, NULL, 'Jamalpur', 'Sarishabari', 'Sarishabari', NULL, 'Maizbari', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(34, 34, 'MOHAMMAD ZAHANGIR ALAM', 'MOHAMMAD ZAHANGIR ALAM', '01729974222', NULL, NULL, NULL, NULL, 'MST.SHAHANA KHATUN', 'MST.SHAHANA KHATUN', '01729974222', NULL, NULL, NULL, NULL, 'MOHAMMAD ZAHANGIR ALAM', 'MOHAMMAD ZAHANGIR ALAM', NULL, '01729974222', NULL, NULL, NULL, 'MOHAMMAD ZAHANGIR ALAM', '2003-12-30', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'JAMALPUR', 'BAKSHIGONJ', 'ROBIAR CHAR', NULL, 'ROBIAR CHAR', 1, NULL, 'JAMALPUR', 'BAKSHIGONJ', 'ROBIAR CHAR', NULL, 'ROBIAR CHAR', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(35, 35, 'MD.SHAH ALI', 'MD.SHAH ALI', '01874551675', NULL, NULL, NULL, NULL, 'MST. ROUSHANARA BEGUM', 'MST. ROUSHANARA BEGUM', '01766499132', NULL, NULL, NULL, NULL, 'MD.SHAH ALI', 'MD.SHAH ALI', NULL, '01874551675', NULL, NULL, NULL, 'MD.SHAH ALI', '2003-05-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Jamalpur', 'MALANDHA', 'AMBRIYA', NULL, 'SORULIA', 1, NULL, 'Jamalpur', 'MALANDHA', 'AMBRIYA', NULL, 'SORULIA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(36, 36, 'ABDUL KADIR', 'ABDUL KADIR', '01724103724', NULL, NULL, NULL, NULL, 'SHIRIN AKTER', 'SHIRIN AKTER', '01724103724', NULL, NULL, NULL, NULL, 'ABDUL KADIR', 'ABDUL KADIR', NULL, '01724103724', NULL, NULL, NULL, 'ABDUL KADIR', '2002-08-10', NULL, NULL, 'Female', 'Married', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'GOFAKURI BAZAR', NULL, 'BIRRAMPUR CHARPARA', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'GOFAKURI BAZAR', NULL, 'BIRRAMPUR CHARPARA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(37, 37, 'RANJIT SARKER', 'RANJIT SARKER', '01781765075', NULL, NULL, NULL, NULL, 'JAYANTI RANI SARKER', 'JAYANTI RANI SARKER', '01781765075', NULL, NULL, NULL, NULL, 'RANJIT SARKER', 'RANJIT SARKER', NULL, '01781765075', NULL, NULL, NULL, 'RANJIT SARKER', '2002-03-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'NETROKONA', 'BARHATTA', 'BARHATTA', NULL, 'BRI-KALIKA ,BARHATTA', 1, NULL, 'NETROKONA', 'BARHATTA', 'BARHATTA', NULL, 'BRI-KALIKA ,BARHATTA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(38, 38, 'GULAM MUSTOFA', 'GULAM MUSTOFA', '01740828452', NULL, NULL, NULL, NULL, 'MAFIYA KHATUN', 'MAFIYA KHATUN', '01740828452', NULL, NULL, NULL, NULL, 'GULAM MUSTOFA', 'GULAM MUSTOFA', NULL, '01740828452', NULL, NULL, NULL, 'GULAM MUSTOFA', '2004-04-15', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Fulbaria', 'Bakta', NULL, 'Nishchintapur', 1, NULL, 'Mymensingh', 'Fulbaria', 'Bakta', NULL, 'Nishchintapur', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(39, 39, 'A.K.M NURUL AMIN', 'A.K.M NURUL AMIN', '01929470296', NULL, NULL, NULL, NULL, 'AFROZA BILKIS', 'AFROZA BILKIS', '01718642964', NULL, NULL, NULL, NULL, 'A.K.M NURUL AMIN', 'A.K.M NURUL AMIN', NULL, '01929470296', NULL, NULL, NULL, 'A.K.M NURUL AMIN', '1970-01-01', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'ALIMNOGOR', NULL, 'SHOBARIA', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'ALIMNOGOR', NULL, 'SHOBARIA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(40, 40, 'MD. HELAL UDDIN', 'MD. HELAL UDDIN', '01746118614', NULL, NULL, NULL, NULL, 'MST. NASIMA KHATUN', 'MST. NASIMA KHATUN', '01746118614', NULL, NULL, NULL, NULL, 'MD. HELAL UDDIN', 'MD. HELAL UDDIN', NULL, '01746118614', NULL, NULL, NULL, 'MD. HELAL UDDIN', '2004-01-07', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'KATHAL BAZAR', NULL, 'DORIKATHAL', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'KATHAL BAZAR', NULL, 'DORIKATHAL', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(41, 41, 'GONESH CHANDRA DAS', 'GONESH CHANDRA DAS', '01744104941', NULL, NULL, NULL, NULL, 'SOBITA RANI', 'SOBITA RANI', '01744104941', NULL, NULL, NULL, NULL, 'GONESH CHANDRA DAS', 'GONESH CHANDRA DAS', NULL, '01744104941', NULL, NULL, NULL, 'SOBITA RANI', '2003-08-17', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Mymensingh', 'Fulbaria', 'Kandania', NULL, 'Langol Shimul', 1, NULL, 'Mymensingh', 'Fulbaria', 'Kandania', NULL, 'Langol Shimul', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(42, 42, 'MD. RUHOL AMIN', 'MD. RUHOL AMIN', '01726313061', NULL, NULL, NULL, NULL, 'MST. ANUWARA', 'MST. ANUWARA', '01726313061', NULL, NULL, NULL, NULL, 'MD. RUHOL AMIN', 'MD. RUHOL AMIN', NULL, '01726313061', NULL, NULL, NULL, 'MD. RUHOL AMIN', '2002-05-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'trishal', 'TRISHAL', NULL, 'Trishal', 1, NULL, 'MYMENSINGH', 'trishal', 'TRISHAL', NULL, 'Trishal', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(43, 43, 'MD . ABU SUFIAN', 'MD . ABU SUFIAN', '01728626291', NULL, NULL, NULL, NULL, 'MINA KHANOM', 'MINA KHANOM', '01786471091', NULL, NULL, NULL, NULL, 'MD . ABU SUFIAN', 'MD . ABU SUFIAN', NULL, '01728626291', NULL, NULL, NULL, 'MD . ABU SUFIAN', '2001-10-17', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'NETRAKONA', 'DURGAPUR', 'KRISHNOPUR', NULL, 'NALIYAKANDA', 1, NULL, 'NETRAKONA', 'DURGAPUR', 'KRISHNOPUR', NULL, 'NALIYAKANDA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(44, 44, 'MD. MOSHARAF HOSSAIN', 'MD. MOSHARAF HOSSAIN', '01719396922', NULL, NULL, NULL, NULL, 'SAIFUN NAHAR', 'SAIFUN NAHAR', '01744293993', NULL, NULL, NULL, NULL, 'MD. MOSHARAF HOSSAIN', 'MD. MOSHARAF HOSSAIN', NULL, '01719396922', NULL, NULL, NULL, 'MD. MOSHARAF HOSSAIN', '1970-01-01', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'AKHRAIL', NULL, 'NOGORCHORA', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'AKHRAIL', NULL, 'NOGORCHORA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(45, 45, 'MD. ANWAR HOSSEN', 'MD. ANWAR HOSSEN', '01600010838', NULL, NULL, NULL, NULL, 'RANI AKTER', 'RANI AKTER', '01600010838', NULL, NULL, NULL, NULL, 'MD. ANWAR HOSSEN', 'MD. ANWAR HOSSEN', NULL, '01600010838', NULL, NULL, NULL, 'MD. ANWAR HOSSEN', '2002-12-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Jamalpur', 'Sarishabari', 'Shibpur', NULL, 'Sengua', 1, NULL, 'Jamalpur', 'Sarishabari', 'Shibpur', NULL, 'Sengua', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(46, 46, 'MD. JAHIR UDDIN', 'MD. JAHIR UDDIN', '01724901469', NULL, NULL, NULL, NULL, 'AMBIA KHATUN', 'AMBIA KHATUN', '01933553015', NULL, NULL, NULL, NULL, 'MD. JAHIR UDDIN', 'MD. JAHIR UDDIN', NULL, '01724901469', NULL, NULL, NULL, 'MD. JAHIR UDDIN', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'HALUAGHAT', NULL, 'MAZRAKURA', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'HALUAGHAT', NULL, 'MAZRAKURA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(47, 47, 'MD.SURUJ ALI AKONDA', 'MD.SURUJ ALI AKONDA', '01842609695', NULL, NULL, NULL, NULL, 'SALEMA KHATUN', 'SALEMA KHATUN', '01888371216', NULL, NULL, NULL, NULL, 'MD.SURUJ ALI AKONDA', 'MD.SURUJ ALI AKONDA', NULL, '01842609695', NULL, NULL, NULL, 'MD.SURUJ ALI AKONDA', '2002-05-10', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'DURGAPUR', 'KAKOIRGORA', NULL, 'KHONUA', 1, NULL, 'MYMENSINGH', 'DURGAPUR', 'KAKOIRGORA', NULL, 'KHONUA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(48, 48, 'ASADUL ISLAM', 'ASADUL ISLAM', '01791276438', NULL, NULL, NULL, NULL, 'SUFIA KHATUN', 'SUFIA KHATUN', '01711064044', NULL, NULL, NULL, NULL, 'ASADUL ISLAM', 'ASADUL ISLAM', NULL, '01791276438', NULL, NULL, NULL, 'ASADUL ISLAM', '2002-02-20', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'GAZIPUR', 'SREEPUR', 'TANGRA', NULL, 'MAWNA', 1, NULL, 'GAZIPUR', 'SREEPUR', 'TANGRA', NULL, 'MAWNA', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(49, 49, 'MD. AKRAM HOSSAIN', 'MD. AKRAM HOSSAIN', '01768230512', NULL, NULL, NULL, NULL, 'MST. REBA PARBEN', 'MST. REBA PARBEN', '01921455686', NULL, NULL, NULL, NULL, 'MD. AKRAM HOSSAIN', 'MD. AKRAM HOSSAIN', NULL, '01768230512', NULL, NULL, NULL, 'MD. AKRAM HOSSAIN', '2003-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'kotwali', 'kandapara', NULL, 'Harguzir par', 1, NULL, 'MYMENSINGH', 'kotwali', 'kandapara', NULL, 'Harguzir par', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(50, 50, 'MD. MOSLEH UDDIN', 'MD. MOSLEH UDDIN', '01753637633', NULL, NULL, NULL, NULL, 'MST. SULTANA AKTER', 'MST. SULTANA AKTER', '01864560824', NULL, NULL, NULL, NULL, 'MD. MOSLEH UDDIN', 'MD. MOSLEH UDDIN', NULL, '01753637633', NULL, NULL, NULL, 'MD. MOSLEH UDDIN', '2003-03-03', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'PAGLA', 'SOTEROBARI', NULL, 'DOKKHINPARA', 1, NULL, 'MYMENSINGH', 'PAGLA', 'SOTEROBARI', NULL, 'DOKKHINPARA', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(51, 51, 'ELAS UDDIN', 'ELAS UDDIN', '01644378953', NULL, NULL, NULL, NULL, 'SURAIA AKHTER', 'SURAIA AKHTER', '01824774870', NULL, NULL, NULL, NULL, 'ELAS UDDIN', 'ELAS UDDIN', NULL, '01644378953', NULL, NULL, NULL, 'ELAS UDDIN', '2002-05-16', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TARAKANDA', 'KAMARGOAN', NULL, 'RAJDARIKAL', 1, NULL, 'MYMENSINGH', 'TARAKANDA', 'KAMARGOAN', NULL, 'RAJDARIKAL', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(52, 52, 'MD. FAZLUL HOQUE', 'MD. FAZLUL HOQUE', '01752290967', NULL, NULL, NULL, NULL, 'MST. SHIRINA KHATUN', 'MST. SHIRINA KHATUN', '017', NULL, NULL, NULL, NULL, 'MD. FAZLUL HOQUE', 'MD. FAZLUL HOQUE', NULL, '01752290967', NULL, NULL, NULL, 'MD. FAZLUL HOQUE', '2002-01-05', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'SAKHUA', NULL, 'SAKHUA', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'SAKHUA', NULL, 'SAKHUA', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(53, 53, 'MD. ISHAQUE MIA', 'MD. ISHAQUE MIA', '01726227151', NULL, NULL, NULL, NULL, 'MST. SUHEDA AKHTER', 'MST. SUHEDA AKHTER', '01613227151', NULL, NULL, NULL, NULL, 'MD. ISHAQUE MIA', 'MD. ISHAQUE MIA', NULL, '01726227151', NULL, NULL, NULL, 'MD. ISHAQUE MIA', '2003-01-24', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Bhaluka', 'Bhaluka', NULL, 'Damsur', 1, NULL, 'Mymensingh', 'Bhaluka', 'Bhaluka', NULL, 'Damsur', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(54, 54, 'MD. AMDADUL KABIR', 'MD. AMDADUL KABIR', '01640588109', NULL, NULL, NULL, NULL, 'MST. AKLIMA', 'MST. AKLIMA', '01760989881', NULL, NULL, NULL, NULL, 'MD. AMDADUL KABIR', 'MD. AMDADUL KABIR', NULL, '01640588109', NULL, NULL, NULL, 'MD. AMDADUL KABIR', '2002-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'GAFARGAON', 'KANDIPARA', NULL, 'BAKSHI', 1, NULL, 'MYMENSINGH', 'GAFARGAON', 'KANDIPARA', NULL, 'BAKSHI', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(55, 55, 'MAHFUZUR RAHMAN MASUD', 'MAHFUZUR RAHMAN MASUD', '01719719818', NULL, NULL, NULL, NULL, 'FARHANA JESMIN POLY', 'FARHANA JESMIN POLY', '01913570326', NULL, NULL, NULL, NULL, 'MAHFUZUR RAHMAN MASUD', 'MAHFUZUR RAHMAN MASUD', NULL, '01719719818', NULL, NULL, NULL, 'MAHFUZUR RAHMAN MASUD', '2003-01-05', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'Mymensingh', 'Haluaghat', 'Haluaghat', NULL, 'Haluaghat', 1, NULL, 'Mymensingh', 'Haluaghat', 'Haluaghat', NULL, 'Haluaghat', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(56, 56, 'Ali Akbor', 'Ali Akbor', '01856927708', NULL, NULL, NULL, NULL, 'Hasina Begum', 'Hasina Begum', '01772924199', NULL, NULL, NULL, NULL, 'Ali Akbor', 'Ali Akbor', NULL, '01856927708', NULL, NULL, NULL, 'Ali Akbor', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'SADAR', 'RAGHABPUR MADRASAH,', NULL, 'CHARNILOKKHIA VATIPARA,', 1, NULL, 'MYMENSINGH', 'SADAR', 'RAGHABPUR MADRASAH,', NULL, 'CHARNILOKKHIA VATIPARA,', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(57, 57, 'Md. Shohidur Rahman', 'Md. Shohidur Rahman', '01309863031', NULL, NULL, NULL, NULL, 'Mst. Shorifa Begum', 'Mst. Shorifa Begum', '01309863031', NULL, NULL, NULL, NULL, 'Md. Shohidur Rahman', 'Md. Shohidur Rahman', NULL, '01309863031', NULL, NULL, NULL, 'Md. Shorif Hasan', '2003-06-02', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Jamalpur', 'Dewanganj', 'Dewanganj', NULL, 'Dewanganj Jamalpur', 1, NULL, 'Jamalpur', 'Dewanganj', 'Dewanganj', NULL, 'Dewanganj Jamalpur', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(58, 58, 'ANOWARUL HAQUE SARDAR', 'ANOWARUL HAQUE SARDAR', '01751404831', NULL, NULL, NULL, NULL, 'DULALI BEGUM', 'DULALI BEGUM', '01787914971', NULL, NULL, NULL, NULL, 'ANOWARUL HAQUE SARDAR', 'ANOWARUL HAQUE SARDAR', NULL, '01751404831', NULL, NULL, NULL, 'MD MONZURUL ISLAM', '1970-01-01', NULL, NULL, 'Female', 'Married', 1, NULL, 'Kurigram', 'Ulipur', 'Daldalia', NULL, 'Uttar daldalia (Bakshipara)', 1, NULL, 'Kurigram', 'Ulipur', 'Daldalia', NULL, 'Uttar daldalia (Bakshipara)', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(59, 59, 'md. razaul karim', 'md. razaul karim', '01739533589', NULL, NULL, NULL, NULL, 'shahina khatun', 'shahina khatun', '01925018137', NULL, NULL, NULL, NULL, 'md. razaul karim', 'md. razaul karim', NULL, '01739533589', NULL, NULL, NULL, 'md. razaul karim', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'jamalpur', 'JAMALPUR SADAR', 'jamalpur', NULL, 'jamalpur', 1, NULL, 'JAMALPUR', 'JAMALPUR SADAR', 'jamalpur', NULL, 'jamalpur', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(60, 60, 'MD. AMIR HOSSAN', 'MD. AMIR HOSSAN', '01612303455', NULL, NULL, NULL, NULL, 'MOST. NASIMA KHATUN', 'MOST. NASIMA KHATUN', '01725270271', NULL, NULL, NULL, NULL, 'MD. AMIR HOSSAN', 'MD. AMIR HOSSAN', NULL, '01612303455', NULL, NULL, NULL, 'MD. AMIR HOSSAN', '2001-06-05', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'BAGHAITOLA', NULL, 'GHILAVUI', 1, NULL, 'MYMENSINGH', 'HALUAGHAT', 'BAGHAITOLA', NULL, 'GHILAVUI', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(61, 61, 'MD. ANWARUL ISLAM', 'MD. ANWARUL ISLAM', '01716827712', NULL, NULL, NULL, NULL, 'JANNATUL FARDUSH', 'JANNATUL FARDUSH', '01737595121', NULL, NULL, NULL, NULL, 'MD. ANWARUL ISLAM', 'MD. ANWARUL ISLAM', NULL, '01716827712', NULL, NULL, NULL, 'MD. ANWARUL ISLAM', '2002-03-21', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'MYMENSINGH', 'trishal', 'BAILOR', NULL, 'BAILOR MOTHBARI', 1, NULL, 'MYMENSINGH', 'trishal', 'BAILOR', NULL, 'BAILOR MOTHBARI', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(62, 62, 'MD. KISLU MIA', 'MD. KISLU MIA', '01823397505', NULL, NULL, NULL, NULL, 'ASMA AKTER', 'ASMA AKTER', '01846271322', NULL, NULL, NULL, NULL, 'MD. KISLU MIA', 'MD. KISLU MIA', NULL, '01823397505', NULL, NULL, NULL, 'MD. KISLU MIA', '2003-01-01', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'TANGAIL', 'DHANBARI', 'DHANBARI', NULL, 'NIZBORNI', 1, NULL, 'TANGAIL', 'DHANBARI', 'DHANBARI', NULL, 'NIZBORNI', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(63, 63, 'SANOWER HOSSAIN', 'SANOWER HOSSAIN', '01717084450', NULL, NULL, NULL, NULL, 'JORINA AKTER', 'JORINA AKTER', '01306370696', NULL, NULL, NULL, NULL, 'SANOWER HOSSAIN', 'SANOWER HOSSAIN', NULL, '01717084450', NULL, NULL, NULL, 'SANOWER HOSSAIN', '1970-01-01', NULL, NULL, 'Female', 'Married', 1, NULL, 'MYMENSINGH', 'BHALUKA', 'AOWLIRCHALA', NULL, 'AOWLIARCHALA', 1, NULL, 'MYMENSINGH', 'BHALUKA', 'AOWLIARCHALA', NULL, 'AOWLIARCHALA', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(64, 64, 'MUHAMMAD ALI', 'MUHAMMAD ALI', '01752419498', NULL, NULL, NULL, NULL, 'ANOWARA KHATUN', 'ANOWARA KHATUN', '01719096909', NULL, NULL, NULL, NULL, 'MUHAMMAD ALI', 'MUHAMMAD ALI', NULL, '01752419498', NULL, NULL, NULL, 'MUHAMMAD ALI', '2002-08-12', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Mymensingh', 'Gouripur', 'Kuturagon', NULL, 'Satpai', 1, NULL, 'Mymensingh', 'Gouripur', 'Kuturagon', NULL, 'Satpai', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(65, 65, 'MD. JALAL UDDIN', 'MD. JALAL UDDIN', '01754219926', NULL, NULL, NULL, NULL, 'FEROZA BEGUM', 'FEROZA BEGUM', '01775355713', NULL, NULL, NULL, NULL, 'MD. JALAL UDDIN', 'MD. JALAL UDDIN', NULL, '01754219926', NULL, NULL, NULL, 'MD. JALAL UDDIN', '2002-12-20', NULL, NULL, 'Female', 'Unmarried', 1, NULL, 'NETRAKONA', 'PURBADHALA', 'PURBADHALA', NULL, 'PURBADHALA', 1, NULL, 'NETRAKONA', 'PURBADHALA', 'PURBADHALA', NULL, 'PURBADHALA', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(66, 66, 'JOYNAL ABDEN', 'JOYNAL ABDEN', '01614635834', NULL, NULL, NULL, NULL, 'ROMIZA KHATUN', 'ROMIZA KHATUN', '01630416407', NULL, NULL, NULL, NULL, 'JOYNAL ABDEN', 'JOYNAL ABDEN', NULL, '01614635834', NULL, NULL, NULL, 'JOYNAL ABDEN', '2002-08-02', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'RAIMONY', NULL, 'RAIMONY', 1, NULL, 'MYMENSINGH', 'TRISHAL', 'RAIMONY', NULL, 'RAIMONY', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(67, 67, 'MD.ABDUL AZIT', 'MD.ABDUL AZIT', '01967223002', NULL, NULL, NULL, NULL, 'SALINA KHATUN', 'SALINA KHATUN', '01967223002', NULL, NULL, NULL, NULL, 'MD.ABDUL AZIT', 'MD.ABDUL AZIT', NULL, '01967223002', NULL, NULL, NULL, 'MD.ABDUL AZIT', '2001-02-11', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'Mymensingh', 'Phulpur', 'Phulpur', NULL, 'Kaziakanda', 1, NULL, 'Mymensingh', 'Phulpur', 'Phulpur', NULL, 'Kaziakanda', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(68, 68, 'MD KHAIRUL BASHAR', 'MD KHAIRUL BASHAR', '01740953596', NULL, NULL, NULL, NULL, 'MST SABINA YESMIN', 'MST SABINA YESMIN', '01740953596', NULL, NULL, NULL, NULL, 'MD KHAIRUL BASHAR', 'MD KHAIRUL BASHAR', NULL, '01740953596', NULL, NULL, NULL, 'MD KHAIRUL BASHAR', '1970-01-01', NULL, NULL, 'Male', 'Unmarried', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'RANIGONJ', NULL, 'JUNGLEBARI', 1, NULL, 'MYMENSINGH', 'FULBARIA', 'RANIGONJ', NULL, 'JUNGLEBARI', '2023-10-01 06:07:03', '2023-10-01 06:07:03');

-- --------------------------------------------------------

--
-- Table structure for table `student_attendances`
--

CREATE TABLE `student_attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_type_id` bigint(20) UNSIGNED DEFAULT NULL,
  `session_id` bigint(20) UNSIGNED DEFAULT NULL,
  `group_id` bigint(20) UNSIGNED DEFAULT NULL,
  `class_year_id` bigint(20) UNSIGNED DEFAULT NULL,
  `teacher_id` bigint(20) UNSIGNED NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `student_attendance_details`
--

CREATE TABLE `student_attendance_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_attendance_id` bigint(20) UNSIGNED DEFAULT NULL,
  `student_id` bigint(20) UNSIGNED DEFAULT NULL,
  `attendance` enum('Present','Absent') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Absent',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `student_card_attendances`
--

CREATE TABLE `student_card_attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `intime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `outtime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `student_education`
--

CREATE TABLE `student_education` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `ssc_school` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssc_roll` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssc_registration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssc_group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssc_board` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssc_passing_year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ssc_result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_college` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_roll` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_registration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_board` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_passing_year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hsc_result` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_education`
--

INSERT INTO `student_education` (`id`, `student_user_id`, `ssc_school`, `ssc_roll`, `ssc_registration`, `ssc_group`, `ssc_board`, `ssc_passing_year`, `ssc_result`, `hsc_college`, `hsc_roll`, `hsc_registration`, `hsc_group`, `hsc_board`, `hsc_passing_year`, `hsc_result`, `created_at`, `updated_at`) VALUES
(1, 1, 'Abul Monsur Memorial Girls\' High School', '203126', '1610491592', NULL, NULL, '2019', '4.28', NULL, '406182', '1610491592', NULL, NULL, '2021', '4.5', '2023-10-01 06:06:58', '2023-10-09 05:50:21'),
(2, 2, 'BALALI BAGHMARA HIGH SCHOOL', '713348', '1410472491', NULL, NULL, '2018', '3.55', 'Mymensingh commerce College', '445704', '1410472491', NULL, NULL, '2021', '3.5', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(3, 3, 'Taragonj pilot High School', '216774', '1510183292', NULL, NULL, '2018', '3.78', 'Nazmul Smrity College', '422045', '1510183292', NULL, NULL, '2020', '3.92', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(4, 4, 'ASIM HIGH SCHOOL', '209747', '1610506790', NULL, NULL, '2019', '4.56', 'Shahabuddin College (Asim)', '207438', '1610506790', NULL, NULL, '2021', '4.92', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(5, 5, 'MOKHAPUR HIGH SCHOOL', '195514', '1610492742', NULL, NULL, '2019', '3.72', 'Trishal Mohila degree college', '405707', '1610492742', NULL, NULL, '2021', '3.5', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(6, 6, 'abdul hakim smriti model high school', '216979', '1510182216', NULL, NULL, '2018', '4.78', 'Royal Media Collage(131944)', '212851', '1510182216', NULL, NULL, '2021', '4.5', '2023-10-01 06:06:58', '2023-10-01 06:06:58'),
(7, 7, 'NALCHAPRA HIGH SCHOOL', '394066', '1610417790', NULL, NULL, '2019', '3.5', 'SUSANG GOVT. MAHABIDYALAYA', '442235', '1610417790', NULL, NULL, '2021', '3.5', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(8, 8, 'RAJ DARIKEL ISLAMIA DAKHIL MADRASAH', '320960', '1518958029', NULL, NULL, '2018', '4.4', 'FAZLUL HAQUECHOUDHURY MOHILA COLLEGE', '418821', '1518958029', NULL, NULL, '2020', '3.5', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(9, 9, 'MISKEYPARA NAWZOAN HIGH SCHOOL', '379553', '1510347305', NULL, NULL, '2018', '4.22', 'GOVT. SHERPUR MOHILA COLLEGE', '419619', '1510347305', NULL, NULL, '2020', '4.08', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(10, 10, 'HALUAGHAT GIRLS HIGH SCHOOL', '191340', '1510297298', NULL, NULL, '2018', '4.44', 'HALUAGHAT SHAHID SMRITI   COLLEGE', '417602', '1510297298', NULL, NULL, '2020', '4.42', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(11, 11, 'BHARADOBA HIGH SCHOOL', '201101', '1610510525', NULL, NULL, '2019', '3.72', 'BHALUKA GOVT. COLLEGE', '407821', '1610510525', NULL, NULL, '2021', '3', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(12, 12, 'Char Kharicha High School(7262)', '242560', '1510339000', NULL, NULL, '2018', '4.17', 'ALamgir Monsur Memorial College(111918)', '401088', '1510339000', NULL, NULL, '2020', '3.83', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(13, 13, 'SHAH SHAHID SAROWAR MODEL GIRL\'S HIGH SCHOOL', '489270', '1410585230', NULL, NULL, '2018', '3.72', 'Bangabondhu Govt. College', '418407', '1410585230', NULL, NULL, '2020', '3.67', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(14, 14, 'VALUKA PILOT HIGH SCHOOL', '431172', '1610510583', NULL, NULL, '2019', '4.28', 'VALUKA GOVT.COLLEGE', '407849', '1610510583', NULL, NULL, '2021', '4.75', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(15, 15, 'Bhaluka Govt. Girls\' High School', '194726', '1510332567', NULL, NULL, '2018', '4.67', 'Valuka Govt. College', '205645', '1510332567', NULL, NULL, '2020', '4.75', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(16, 16, 'SAKHIPUR P.M. PILOT HIGH SCHOOL,  SAKHIPUR, TANGAIL.', '162796', '1510494156', NULL, NULL, '2018', '4.56', 'GOVT. MUJIB COLLEGE, SAKHIPUR, TANGAIL.', '178602', '1510494156', NULL, NULL, '2020', '4.83', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(17, 17, 'RAYERGRAM SHAHID SMRITI HIGH SCHOOL', '195080', '1610494934', NULL, NULL, '2019', '4.44', 'TRISHAL MOHILA DEGREE COLLEGE', '405943', '1610494934', NULL, NULL, '2021', '4.5', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(18, 18, 'ANGARGARA UNITTED HIGH SCHOOL', '198917', '1610511976', NULL, NULL, '2019', '4.28', 'SHAKHIPUR RESIDNTIAL WOMENS COLLEGE', '172395', '1610511976', NULL, NULL, '2021', '4.67', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(19, 19, 'SHALIA HIGH SCHOOL', '499675', '1510345492', NULL, NULL, '2018', '3.72', 'BOWLA COLLEGE PHULPUR', '413279', '1510345492', NULL, NULL, '2020', '3.83', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(20, 20, 'PROGRESSIVE MODEL SCHOOL', '192755', '1610513364', NULL, NULL, '2019', '4.44', 'Alamgir monsur memorial college', '202374', '1610513364', NULL, NULL, '2021', '5', '2023-10-01 06:06:59', '2023-10-01 06:06:59'),
(21, 21, 'Mondol Bari High School', '276068', '1610503898', NULL, NULL, '2019', '4.17', 'Islamia College', '207347', '1610503898', NULL, NULL, '2021', '4.58', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(22, 22, 'PROGSSIBE MODEL SCHOOL', '192623', '1610513595', NULL, NULL, '2019', '4.56', 'ADVANCED RESIDENTIAL MODEL COLLEGE', '201203', '1610513595', NULL, NULL, '2021', '4.92', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(23, 23, 'MADERGANJ A. M. PILOT HIGH SCHOOL', '217702', '1610369889', NULL, NULL, '2019', '4.44', 'ALAMGIR MONSUR MEMORIAL COLLEGE', '201140', '1610369889', NULL, NULL, '2021', '4.58', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(24, 24, 'KAYRA HATI LALARPAR DAKHIL MADRASAH MYMENSINGH', '129832', '1518954142', NULL, NULL, '2018', '3.5', 'DHARA ADARSHA MOHABIDDALOY MYMENSINGH', '764581', '2147483647', NULL, NULL, '2020', '4.08', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(25, 25, 'FULPUR PILOT HIGH SCHOOL', '196291', '1610529071', NULL, NULL, '2019', '4.5', 'CANTONMENT PUBLIC SCHOOL COLLEGE 111925', '403250', '1610529071', NULL, NULL, '2020', '4.5', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(26, 26, '1', '203312', '1', NULL, NULL, '2018', '4.5', '1', '207525', '1', NULL, NULL, '2020', '4.75', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(27, 27, 'GOATALA HIGH SCHOOL', '202523', '1610466641', NULL, NULL, '2019', '4.11', 'DHUBARA MOHILA COLLEGE', '419906', '1610466641', NULL, NULL, '2021', '4.5', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(28, 28, 'Mymensingh Jute Mills Adarsha Bidyapith', '497782', '1610515794', NULL, NULL, '2019', '3.89', 'Alamgir Monsur Memorial College', '400670', '1610515794', NULL, NULL, '2021', '4.67', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(29, 29, 'JAMIRDIA ABDUL GANI MASTER SCHOOL & COLLEGE', '191591', '1610507528', NULL, NULL, '2019', '4.44', 'JAMIRDIA ABDUL GANI MASTER SCHOOL& COLLEGE', '205643', '1610507528', NULL, NULL, '2021', '5', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(30, 30, 'MARICHAR CHAR HIGH SCHOOL', '175330', '1510304295', NULL, NULL, '2018', '4.5', 'MUSLIM GIRLS\' HIGH SCHOOL & COLLEGE', '204850', '1510304295', NULL, NULL, '2020', '4.5', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(31, 31, 'KUSHUM HATI HIGH SCHOOL', '229343', '1610359278', NULL, NULL, '2019', '4.39', 'GOVT. SHERPUR  COLLEGE', NULL, '1610359278', NULL, NULL, '2021', '4.33', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(32, 32, 'HAZIRBAZAR RAHMATE ALAM ACADEMY', '191789', '1610510646', NULL, NULL, '2019', '4.5', 'ADVANCE RESIDENTIAL MODEL COLLEGE', '202610', '1610510646', NULL, NULL, '2021', '4.42', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(33, 33, 'Konabari Dakhil Madrasah, Jamalpur', '139852', '1518926871', NULL, NULL, '2018', '4.05', 'Sarishabari Mahmuda Salam Mohila College', '426737', '1518926871', NULL, NULL, '2020', '3.25', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(34, 34, 'BAKSHIGONJ N.M HIGH SCHOOL', '218749', '1610366029', NULL, NULL, '2019', '4.28', 'JAMALPUR RESIDENTIAL MODEL COLLEGE', '210230', '1610366029', NULL, NULL, '2021', '4.58', '2023-10-01 06:07:00', '2023-10-01 06:07:00'),
(35, 35, 'KALABADHA HIGH SCHOOL', '216462', '1610384381', NULL, NULL, '2019', '4.17', 'ISLAMPUR IDEAL TECHNICAL AND B.M. COLLAGE', '941817', '2147483647', NULL, NULL, '2021', '4.92', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(36, 36, 'RAMPUR HIGH SCHOOL', '427138', '1510312903', NULL, NULL, '2018', '3.72', 'Trishal Mohila degree college', '405419', '1510312903', NULL, NULL, '2020', '3.58', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(37, 37, 'BARHATTA C.K.P. PILOT HIGH SCHOOL', '454221', '1510227658', NULL, NULL, '2018', '2.94', 'b', '439446', '1510227658', NULL, NULL, '2020', '2.92', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(38, 38, 'PALASHIHATA HIGH SCHOOL', '173284', '1610506292', NULL, NULL, '2019', '4.61', 'Muslim Girls High School & College', '204839', '1610506292', NULL, NULL, '2021', '4.58', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(39, 39, 'GOUURIPUR PILOT GIRLS HIGH SCHOOL', '195910', '1610479088', NULL, NULL, '2019', '4.61', 'GOUURIPUR MOHILA COLLEGE', '205969', '1610479088', NULL, NULL, '2021', '4.67', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(40, 40, 'DARI KATHAL HIGH SCHOOL', '257917', '1610493308', NULL, NULL, '2019', '3.72', 'Trishal Mohila degree college', '405884', '1610493308', NULL, NULL, '2021', '4.83', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(41, 41, 'Kandania High School', '209865', '1610506452', NULL, NULL, '2019', '4.56', 'Shahabuddin College', '207466', '1610506452', NULL, NULL, '2021', '4.67', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(42, 42, 'Dukhu mia bidyanikaton', '196871', '1510313490', NULL, NULL, '2018', '3.5', 'islami academy school & college', '405969', '1510313490', NULL, NULL, '2020', '3.42', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(43, 43, 'G.M.S MEMORIAL HIGH SCHOOL', '455417', '1510249631', NULL, NULL, '2018', '3.61', 'Susang Govt. Mahabidyalaya', '438351', '1510249631', NULL, NULL, NULL, '3.61', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(44, 44, 'AKHRAIL HIGH SCHOL', '196802', '1510315171', NULL, NULL, '2018', '4.56', 'Trishal Mohila degree college', '212892', '1510315171', NULL, NULL, '2021', '4.33', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(45, 45, 'Sanakoir Shiekh Khalilur Rahman High School', '221487', '1610373056', NULL, NULL, '2019', '4.39', 'Govt. Banghabandu College, Sharishabari', '210855', '1610373056', NULL, NULL, '2021', '4.42', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(46, 46, 'HALUAGHAT ADARSHA HIGH SCHOOL', '197088', '1610473373', NULL, NULL, '2019', '4.39', 'HALUAGHAT SHAHID SMRITI  GOVT. COLLEGE', '207709', '1610473373', NULL, NULL, '2021', '4.75', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(47, 47, 'Kakairgora High School', '446805', '1510249759', NULL, NULL, '2018', '3.94', 'Susang Govt. Mahabidyalaya(112975)', '438690', '1510249759', NULL, NULL, '2020', '3.67', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(48, 48, 'AGRICULTURE UNIVERSITY HIGH SCHOOL', '243498', '1510340770', NULL, NULL, '2018', '4', 'B.K.B COLLEGE, MYMENSINGH', '212883', '1510340770', NULL, NULL, '2021', '3.83', '2023-10-01 06:07:01', '2023-10-01 06:07:01'),
(49, 49, 'Ideal International school', '900422', '1510171169', NULL, NULL, '2018', '3.61', 'D.K.G.S. United College', '401469', '1510171169', NULL, NULL, '2020', '3.67', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(50, 50, 'NATUN BAZAR JANATA ARSHWA BIDDYA NIKETAN', '192482', '1610495646', NULL, NULL, '2019', '4.5', 'ABDUR RAHMAN COLLEGE KANDIPARA', '416672', '1610495646', NULL, NULL, '2021', '4.25', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(51, 51, 'RAJ DARIKEL ISLAMIA DAKHIL MADRASAH', '321005', '1518627028', NULL, NULL, '2018', '3.7', 'SHEIKH MUJIB COLLEGE', '419336', '1518627028', NULL, NULL, '2020', '3.08', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(52, 52, 'SAKHUA HIGH SCHOOL', '189980', '1510648757', NULL, NULL, '2018', '4.28', 'Govt. nazrul college', '406031', '1510648757', NULL, NULL, '2020', '4.5', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(53, 53, 'Halimunnessa Chowdhorani Memorial Girls\' High School', '200644', '1610510888', NULL, NULL, '2019', '4.61', 'Bhaluka Govt. College', '205507', '1610510888', NULL, NULL, '2021', '4.5', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(54, 54, 'NATUN BAZAR JANATA ADARSHWA BIDDYA NIKETAN', '192491', '1610495633', NULL, NULL, '2019', '4.5', 'ABDUR RAHMAN COLLEGE KANDIPARA', '416673', '1610495633', NULL, NULL, '2021', '4.25', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(55, 55, 'Haluaghat Girls High School', '418070', '1510297287', NULL, NULL, '2018', '3.56', 'Haluaghat Shahid Smriti College', '417571', '1510297287', NULL, NULL, '2020', '3.67', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(56, 56, 'Mukul Niketan High School', '242983', '1510341300', NULL, NULL, '2018', '3.56', 'Advanced Residential Model College', '401414', '1510341300', NULL, NULL, '2020', '4', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(57, 57, 'Dewanganj Technical School and College', '248984', '826440', NULL, NULL, '2019', '4.29', 'Dewanganj Technical School and College', '476287', '2147483647', NULL, NULL, '2021', '4.85', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(58, 58, 'DALDALIA ADARSHA HIGH SCHOOL', '224986', '1617716209', NULL, NULL, '2019', '4.72', 'ULIPUR GOVERNMENT COLLEGE', '149054', '1617716209', NULL, NULL, '2021', '4.58', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(59, 59, 'jahawla gopalpur high school', '210389', '1610396919', NULL, NULL, '2019', '4.44', 'CANTONMENT PUBLIC SCHOOL COLLEGE 111925', '204273', '1610396919', NULL, NULL, '2021', '4.67', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(60, 60, 'BAGHAITALA ADARSHA HIGH SCHOOL', '197157', '1610835361', NULL, NULL, '2019', '3.5', 'HALUAGHAT SHAHID SMRITI COLLEGE', '207678', '1610835361', NULL, NULL, '2021', '3.58', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(61, 61, 'Bailor Rahmamnia High School (7741)', '203261', '1618946054', NULL, NULL, '2019', '3.89', 'Trishal Mohila degree college', '405914', '1618946054', NULL, NULL, '2021', '3.58', '2023-10-01 06:07:02', '2023-10-01 06:07:02'),
(62, 62, 'DHANBARI  COLLEGITE SCHOOL', '189128', '1610633493', NULL, NULL, '2019', '4.06', 'DHANBARI COLLEGE', '175802', '1610633493', NULL, NULL, '2021', '4.75', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(63, 63, 'SHAHID NAZIM UDDIN HIGH SCHOOL', '200820', '1610508265', NULL, NULL, '2019', '4.72', 'Muslim Girls High School & Collage', '204626', '1610508265', NULL, NULL, '2021', '4.42', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(64, 64, 'SHAMGONJ HIGH SCHOOL', '416405', '1518958782', NULL, NULL, '2018', '3.56', 'Hafez Ziaur Rahman College (Shyamganj)', '437024', '1518958782', NULL, NULL, '2020', '3.5', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(65, 65, 'PURBADHALA J. M. PILOT HIGH SCHOOL', '206285', '1510248271', NULL, NULL, '2018', '3.89', 'PURBADHALA  GOVT. COLLEGE', '437346', '1510248271', NULL, NULL, '2020', '4.25', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(66, 66, 'GUZIUM AMIRABARI HIGH SCHOOL', '189570', '1510314566', NULL, NULL, '2018', '3.61', 'ADVANCCD RESIDENTIAL MODEL COLLEGE , MYMENSINGH', '401339', '1510314566', NULL, NULL, '2020', '3.42', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(67, 67, 'FULPUR PILOT HIGH SCHOOL', '190574', '1510350034', NULL, NULL, '2018', '4.61', 'Alamgir Monsur (Mintu) Memorial College', '202267', '1510350034', NULL, NULL, '2020', '4.75', '2023-10-01 06:07:03', '2023-10-01 06:07:03'),
(68, 68, 'PORABARI HIGH SCHOOL', '195205', '1610494043', NULL, NULL, '2019', '4.78', 'Royal Media Collage(131944)', '205054', '1610494043', NULL, NULL, '2021', '4.63', '2023-10-01 06:07:03', '2023-10-01 06:07:03');

-- --------------------------------------------------------

--
-- Table structure for table `subjects`
--

CREATE TABLE `subjects` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `class_type_id` bigint(20) UNSIGNED NOT NULL,
  `group_id` bigint(20) UNSIGNED NOT NULL,
  `class_year_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `position` int(11) DEFAULT NULL,
  `category` enum('cq','mcq','pp') COLLATE utf8mb4_unicode_ci NOT NULL,
  `distribution` enum('common','science','humanities','business') COLLATE utf8mb4_unicode_ci NOT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `subject_role` enum('First','Second') COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_type` enum('Compulsory','Optional','Both') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Compulsory',
  `fullmark` double NOT NULL DEFAULT 0,
  `passmark` double NOT NULL DEFAULT 0,
  `cq_fullmark` double NOT NULL DEFAULT 0,
  `cq_passmark` double NOT NULL DEFAULT 0,
  `mcq_fullmark` double DEFAULT 0,
  `mcq_passmark` double DEFAULT 0,
  `pp_fullmark` double DEFAULT 0,
  `pp_passmark` double DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subjects`
--

INSERT INTO `subjects` (`id`, `class_type_id`, `group_id`, `class_year_id`, `name`, `name_bn`, `code`, `position`, `category`, `distribution`, `parent_id`, `subject_role`, `subject_type`, `fullmark`, `passmark`, `cq_fullmark`, `cq_passmark`, `mcq_fullmark`, `mcq_passmark`, `pp_fullmark`, `pp_passmark`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 1, 'Bangla', 'বাংলা', '101', 1, 'cq', 'common', NULL, 'First', 'Compulsory', 100, 33, 100, 33, NULL, NULL, NULL, NULL, '2023-04-18 03:53:54', '2023-04-18 03:53:54'),
(2, 1, 1, 2, 'Bangla', 'বাংলা', '102', 2, 'cq', 'common', 1, 'Second', 'Compulsory', 50, 18, 50, 18, NULL, NULL, NULL, NULL, '2023-04-18 03:59:25', '2023-04-18 03:59:25'),
(3, 1, 1, 1, 'English', 'ইংরেজি', '107', 3, 'cq', 'common', NULL, 'First', 'Compulsory', 100, 33, 100, 33, NULL, NULL, NULL, NULL, '2023-04-27 03:16:23', '2023-04-27 03:16:23'),
(4, 1, 1, 2, 'English', 'ইংরেজি', '108', 4, 'cq', 'common', 3, 'Second', 'Compulsory', 50, 18, 50, 18, NULL, NULL, NULL, NULL, '2023-04-27 03:17:08', '2023-04-27 03:17:08'),
(5, 1, 1, 1, 'Information and Communication Technology', 'তথ্য ও যোগাযোগ প্রযুক্তি', '275', 5, 'pp', 'common', NULL, 'First', 'Compulsory', 100, 33, 50, 17, 25, 8, 25, 8, '2023-04-27 03:20:13', '2023-04-27 03:20:13'),
(6, 1, 1, 1, 'Physics', 'পদার্থ', '174', 6, 'pp', 'science', NULL, 'First', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 7, '2023-04-27 03:24:29', '2023-04-27 03:24:29'),
(7, 1, 1, 2, 'Physics', 'পদার্থ', '175', 6, 'pp', 'science', 6, 'Second', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 8, '2023-04-27 03:25:22', '2023-04-27 03:25:22'),
(8, 1, 1, 1, 'Chemistry', 'রসায়ন', '176', 6, 'pp', 'science', NULL, 'First', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 7, '2023-04-27 03:24:29', '2023-04-27 03:24:29'),
(9, 1, 1, 2, 'Chemistry', 'রসায়ন', '177', 6, 'pp', 'science', 8, 'Second', 'Compulsory', 100, 33, 50, 17, 30, 10, 20, 8, '2023-04-27 03:25:22', '2023-04-27 03:25:22'),
(10, 1, 1, 1, 'Biology', 'জীববিজ্ঞান', '178', 6, 'pp', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 30, 10, 20, 7, '2023-04-27 03:24:29', '2023-04-27 03:24:29'),
(11, 1, 1, 2, 'Biology', 'জীববিজ্ঞান', '179', 6, 'pp', 'science', 10, 'Second', 'Both', 100, 33, 50, 17, 30, 10, 20, 8, '2023-04-27 03:25:22', '2023-04-27 03:25:22'),
(12, 1, 1, 1, 'Higher Mathematics', 'উচ্চতর গণিত', '265', 10, 'mcq', 'science', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-09-24 17:21:33'),
(13, 1, 1, 2, 'Higher Mathematics', 'উচ্চতর গণিত', '266', 10, 'mcq', 'science', 12, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-09-24 17:20:59'),
(14, 1, 2, 1, 'Civics & Good Governance', 'নাগরিক ও সুশাসন', '269', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(15, 1, 2, 2, 'Civics & Good Governance', 'নাগরিক ও সুশাসন', '270', 10, 'mcq', 'humanities', 14, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(16, 1, 2, 1, 'Economics', 'অর্থনীতি', '109', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(17, 1, 2, 2, 'Economics', 'অর্থনীতি', '110', 10, 'mcq', 'humanities', 16, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(18, 1, 2, 1, 'Social Work', 'সমাজ কর্ম', '271', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(19, 1, 2, 2, 'Social Work', 'সমাজ কর্ম', '272', 10, 'mcq', 'humanities', 18, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(20, 1, 2, 1, 'Islamic History & Culture', 'ইসলামের ইতিহাস ও সংস্কৃতি', '267', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(21, 1, 2, 2, 'Islamic History & Culture', 'ইসলামের ইতিহাস ও সংস্কৃতি', '268', 10, 'mcq', 'humanities', 20, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(22, 1, 2, 1, 'Logic', 'যুক্তিবিদ্যা', '121', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(23, 1, 2, 2, 'Logic', 'যুক্তিবিদ্যা', '122', 10, 'mcq', 'humanities', 22, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(24, 1, 2, 1, 'Geopraphy ', 'ভূগোল', '125', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(25, 1, 2, 2, 'Geopraphy ', 'ভূগোল', '126', 10, 'mcq', 'humanities', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(26, 1, 2, 1, 'Psychology', 'মনোবিজ্ঞান', '125', 10, 'mcq', 'humanities', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(27, 1, 2, 2, 'Psychology', 'মনোবিজ্ঞান', '126', 10, 'mcq', 'business', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(28, 1, 2, 1, 'Islamic Studies', 'ইসলামিক স্টাডিজ', '125', 10, 'mcq', 'business', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(29, 1, 2, 2, 'Islamic Studies', 'ইসলামিক স্টাডিজ', '126', 10, 'mcq', 'business', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(30, 1, 3, 1, 'Accounting', 'হিসাববিজ্ঞান', '253', 10, 'mcq', 'business', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(31, 1, 3, 2, 'Accounting', 'হিসাববিজ্ঞান', '254', 10, 'mcq', 'business', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(32, 1, 3, 1, 'Business Organization And Management', 'ব্যবসা প্রতিষ্ঠান এবং ব্যবস্থাপনা', '277', 10, 'mcq', 'business', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57'),
(33, 1, 3, 2, 'Business Organization And Management', 'ব্যবসা প্রতিষ্ঠান এবং ব্যবস্থাপনা', '278', 10, 'mcq', 'business', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(34, 1, 3, 1, 'Production Management and Marketing', 'উত্পাদন ব্যবস্থাপনা এবং বিপণন', '286', 10, 'mcq', 'business', 24, 'Second', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:20:40'),
(35, 1, 3, 2, 'Production Management and Marketing', 'উত্পাদন ব্যবস্থাপনা এবং বিপণন', '287', 10, 'mcq', 'business', NULL, 'First', 'Both', 100, 33, 50, 17, 50, 17, NULL, NULL, '2023-04-27 04:00:57', '2023-04-27 04:00:57');

-- --------------------------------------------------------

--
-- Table structure for table `subject_students`
--

CREATE TABLE `subject_students` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `student_id` bigint(20) UNSIGNED NOT NULL,
  `subject_id` bigint(20) UNSIGNED NOT NULL,
  `class_year_id` bigint(20) UNSIGNED NOT NULL,
  `serial` int(11) DEFAULT NULL,
  `student_subject_type` enum('Compulsory','Optional') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Compulsory',
  `status` enum('Active','Inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subject_students`
--

INSERT INTO `subject_students` (`id`, `student_user_id`, `student_id`, `subject_id`, `class_year_id`, `serial`, `student_subject_type`, `status`, `created_at`, `updated_at`) VALUES
(1, 5, 4, 1, 1, 1, 'Compulsory', 'Active', '2023-08-11 06:13:59', '2023-08-11 06:42:58'),
(2, 28, 26, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:22'),
(3, 28, 26, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:22'),
(4, 28, 26, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:22'),
(5, 28, 26, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:22'),
(6, 28, 26, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:22'),
(7, 28, 26, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:22'),
(8, 28, 26, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:27:22', '2023-09-03 10:27:26'),
(9, 39, 37, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:47'),
(10, 39, 37, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:47'),
(11, 39, 37, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:47'),
(12, 39, 37, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:47'),
(13, 39, 37, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:47'),
(14, 39, 37, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:47'),
(15, 39, 37, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:28:47', '2023-09-03 10:28:53'),
(16, 38, 36, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:09'),
(17, 38, 36, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:09'),
(18, 38, 36, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:09'),
(19, 38, 36, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:09'),
(20, 38, 36, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:09'),
(21, 38, 36, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:09'),
(22, 38, 36, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:29:09', '2023-09-03 10:29:11'),
(23, 37, 35, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:25'),
(24, 37, 35, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:25'),
(25, 37, 35, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:25'),
(26, 37, 35, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:25'),
(27, 37, 35, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:25'),
(28, 37, 35, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:25'),
(29, 37, 35, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:29:25', '2023-09-03 10:29:28'),
(30, 36, 34, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:41'),
(31, 36, 34, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:41'),
(32, 36, 34, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:41'),
(33, 36, 34, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:41'),
(34, 36, 34, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:41'),
(35, 36, 34, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:41'),
(36, 36, 34, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:29:41', '2023-09-03 10:29:43'),
(37, 35, 33, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:05'),
(38, 35, 33, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:05'),
(39, 35, 33, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:05'),
(40, 35, 33, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:05'),
(41, 35, 33, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:05'),
(42, 35, 33, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:05'),
(43, 35, 33, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:30:05', '2023-09-03 10:30:08'),
(44, 34, 32, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:37'),
(45, 34, 32, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:37'),
(46, 34, 32, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:37'),
(47, 34, 32, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:37'),
(48, 34, 32, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:37'),
(49, 34, 32, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:37'),
(50, 34, 32, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:30:37', '2023-09-03 10:30:39'),
(51, 33, 31, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:53'),
(52, 33, 31, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:53'),
(53, 33, 31, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:53'),
(54, 33, 31, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:53'),
(55, 33, 31, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:53'),
(56, 33, 31, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:53'),
(57, 33, 31, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:30:53', '2023-09-03 10:30:56'),
(58, 32, 30, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:10'),
(59, 32, 30, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:10'),
(60, 32, 30, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:10'),
(61, 32, 30, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:10'),
(62, 32, 30, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:10'),
(63, 32, 30, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:10'),
(64, 32, 30, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:31:10', '2023-09-03 10:31:12'),
(65, 31, 29, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:25'),
(66, 31, 29, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:25'),
(67, 31, 29, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:25'),
(68, 31, 29, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:25'),
(69, 31, 29, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:25'),
(70, 31, 29, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:25'),
(71, 31, 29, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:31:25', '2023-09-03 10:31:27'),
(72, 30, 28, 1, 1, 1, 'Compulsory', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:43'),
(73, 30, 28, 3, 1, 2, 'Compulsory', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:43'),
(74, 30, 28, 5, 1, 3, 'Compulsory', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:43'),
(75, 30, 28, 6, 1, 4, 'Compulsory', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:43'),
(76, 30, 28, 8, 1, 5, 'Compulsory', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:43'),
(77, 30, 28, 10, 1, 6, 'Compulsory', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:43'),
(78, 30, 28, 12, 1, 7, 'Optional', 'Active', '2023-09-03 10:31:43', '2023-09-03 10:31:46'),
(86, 29, 27, 1, 1, 1, 'Compulsory', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:28'),
(87, 29, 27, 3, 1, 2, 'Compulsory', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:28'),
(88, 29, 27, 5, 1, 3, 'Compulsory', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:28'),
(89, 29, 27, 14, 1, 4, 'Compulsory', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:28'),
(90, 29, 27, 16, 1, 5, 'Compulsory', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:28'),
(91, 29, 27, 18, 1, 6, 'Compulsory', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:28'),
(92, 29, 27, 22, 1, 7, 'Optional', 'Active', '2023-09-08 04:16:28', '2023-09-08 04:16:32'),
(100, 60, 66, 1, 1, 1, 'Compulsory', 'Active', '2023-09-25 09:40:12', '2023-09-25 09:40:12'),
(101, 60, 66, 3, 1, 2, 'Compulsory', 'Active', '2023-09-25 09:40:12', '2023-09-25 09:40:12'),
(102, 60, 66, 5, 1, 3, 'Compulsory', 'Active', '2023-09-25 09:40:12', '2023-09-25 09:40:12'),
(103, 60, 66, 16, 1, 4, 'Compulsory', 'Active', '2023-09-25 09:40:13', '2023-09-25 09:40:13'),
(104, 60, 66, 18, 1, 5, 'Compulsory', 'Active', '2023-09-25 09:40:13', '2023-09-25 09:40:13'),
(105, 60, 66, 24, 1, 6, 'Compulsory', 'Active', '2023-09-25 09:40:13', '2023-09-25 09:40:13'),
(106, 60, 66, 28, 1, 7, 'Optional', 'Active', '2023-09-25 09:40:13', '2023-09-25 09:40:13'),
(107, 61, 67, 1, 1, 1, 'Compulsory', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42'),
(108, 61, 67, 3, 1, 2, 'Compulsory', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42'),
(109, 61, 67, 5, 1, 3, 'Compulsory', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42'),
(110, 61, 67, 30, 1, 4, 'Compulsory', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42'),
(111, 61, 67, 32, 1, 5, 'Compulsory', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42'),
(112, 61, 67, 34, 1, 6, 'Compulsory', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42'),
(113, 61, 67, 24, 1, 7, 'Optional', 'Active', '2023-09-25 10:08:42', '2023-09-25 10:08:42');

-- --------------------------------------------------------

--
-- Table structure for table `subscribers`
--

CREATE TABLE `subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('subscribe','unsubscribe') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subscribe',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `sub_fee_categories`
--

CREATE TABLE `sub_fee_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fee_category_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `p_id` int(11) DEFAULT 0,
  `amount` double(30,2) NOT NULL DEFAULT 0.00,
  `status` enum('Daft','Active','Deactive','Deleted') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_fee_categories`
--

INSERT INTO `sub_fee_categories` (`id`, `name`, `name_bn`, `fee_category_id`, `user_id`, `p_id`, `amount`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Monthly Fee', 'Monthly Fee', 1, 1, NULL, 600.00, 'Deleted', '2023-05-07 10:50:32', '2023-05-06 11:04:40', '2023-05-07 10:50:32'),
(2, 'January', 'January', 1, 1, 1, 500.00, 'Deleted', '2023-05-06 11:18:31', '2023-05-06 11:05:03', '2023-05-06 11:18:31'),
(3, 'Admission Fee', 'Admission Fee', 1, 1, NULL, 1000.00, 'Active', NULL, '2023-05-07 10:51:23', '2023-05-07 10:51:23'),
(4, 'Admission Fee', 'Admission Fee', 2, 1, NULL, 2000.00, 'Active', NULL, '2023-06-14 05:35:04', '2023-06-14 05:35:04'),
(5, 'Software Processign Fee', 'Software Processign Fee', 2, 1, NULL, 600.00, 'Active', NULL, '2023-06-14 05:35:22', '2023-06-14 05:35:22'),
(6, 'Red Crecent Fee', 'Red Crecent Fee', 2, 1, NULL, 20.00, 'Active', NULL, '2023-06-14 05:35:35', '2023-06-14 05:35:35'),
(7, 'Month Fee', 'Month Fee', 2, 1, NULL, 1200.00, 'Active', NULL, '2023-06-14 05:35:51', '2023-06-14 05:35:51'),
(8, 'Admission Fee', 'Admission Fee', 3, 1, NULL, 4500.00, 'Active', NULL, '2023-06-18 10:29:34', '2023-06-18 10:29:34'),
(9, 'Admission Fee', 'Admission Fee', 4, 1, NULL, 2600.00, 'Active', NULL, '2023-06-18 12:21:45', '2023-06-18 12:21:45'),
(10, 'Software Fee', 'Software Fee', 4, 1, NULL, 1000.00, 'Active', NULL, '2023-06-18 12:34:52', '2023-06-18 12:34:52'),
(11, 'Admission Fee', 'Admission Fee', 5, 1, NULL, 1000.00, 'Active', NULL, '2023-08-13 06:30:42', '2023-08-13 06:30:42'),
(12, 'Monthly Fee', 'Monthly Fee', 5, 1, NULL, 1200.00, 'Active', NULL, '2023-08-13 06:30:57', '2023-08-13 06:30:57'),
(13, 'Monthly Fee', 'Monthly Fee', 5, 1, NULL, 1200.00, 'Deleted', '2023-08-13 06:31:00', '2023-08-13 06:30:57', '2023-08-13 06:31:00');

-- --------------------------------------------------------

--
-- Table structure for table `teachers`
--

CREATE TABLE `teachers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `teacher_user_id` bigint(20) UNSIGNED NOT NULL,
  `father` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mother` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marrage_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `religion_id` int(10) DEFAULT NULL,
  `joindate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` bigint(20) UNSIGNED DEFAULT NULL,
  `district_id` bigint(20) UNSIGNED DEFAULT NULL,
  `policestation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postoffice` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Active','Deactive','Trash') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Active',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teachers`
--

INSERT INTO `teachers` (`id`, `teacher_user_id`, `father`, `mother`, `dob`, `gender`, `marrage_status`, `nid`, `religion_id`, `joindate`, `country_id`, `district_id`, `policestation`, `postoffice`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'MD. SOFIR UDDIN', 'MST. JAMILA BEGUM', '1996-09-15', 'Male', 'Unmarried', '8214569974', 0, '2023-06-10', 1, 1, 'Badda', 'Badda', 'Active', NULL, '2023-06-10 10:34:14', '2023-06-10 10:59:30'),
(2, 2, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, 1, NULL, NULL, NULL, 'Active', NULL, '2023-10-09 03:15:20', '2023-10-09 03:18:03');

-- --------------------------------------------------------

--
-- Table structure for table `teacher_attendances`
--

CREATE TABLE `teacher_attendances` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `teacher_id` bigint(20) UNSIGNED DEFAULT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `intime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `outtime` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `student_user_id` bigint(20) UNSIGNED NOT NULL,
  `roll` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `registration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passing_year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `point` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `result_for` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `result_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `education_board_id` bigint(20) UNSIGNED NOT NULL,
  `status` enum('Pending','Confirm','Rejected') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Confirm',
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `student_user_id`, `roll`, `registration`, `group`, `subject`, `passing_year`, `point`, `result_for`, `result_type`, `education_board_id`, `status`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 5, '2032234', '23432423', 'asfdasfd', 'asfsadf', '2023', 'asfasf', '1', 'Division', 4, 'Confirm', 1, '2023-09-22 17:32:31', '2023-09-22 17:39:21');

-- --------------------------------------------------------

--
-- Table structure for table `web_settings`
--

CREATE TABLE `web_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `site_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `site_name_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `web_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `favicon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `footer_logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title_bn` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keyword_bn` longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyright` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `copyright_bn` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altemail` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `altphone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_bn` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `developed_by` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `developed_by_bn` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `established` int(10) DEFAULT NULL,
  `eiin` int(10) DEFAULT NULL,
  `college_code` int(10) DEFAULT NULL,
  `degree` int(10) DEFAULT NULL,
  `status` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `web_settings`
--

INSERT INTO `web_settings` (`id`, `site_name`, `site_name_bn`, `web_url`, `description`, `description_bn`, `logo`, `mobile_logo`, `favicon`, `footer_logo`, `meta_title`, `meta_title_bn`, `meta_description`, `meta_description_bn`, `meta_keyword`, `meta_keyword_bn`, `copyright`, `copyright_bn`, `email`, `altemail`, `phone`, `altphone`, `location`, `address`, `address_bn`, `developed_by`, `developed_by_bn`, `established`, `eiin`, `college_code`, `degree`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Nasirabad College, Mymensingh', 'নাসিরাবাদ কলেজ, ময়মনসিংহ', 'https://ncmym.edu.bd/', NULL, NULL, 'uploads/web_settings/images/web_settings-65115b0c3d5d0.png', 'uploads/web_settings/images/web_settings-65115b0c3d5d0.png', 'uploads/web_settings/images/web_settings-65115b0c3d5d0.png', 'uploads/web_settings/images/web_settings-65115b0c3d5d0.png', NULL, NULL, NULL, NULL, NULL, NULL, 'Copyright @ 2023 | All right reserved', 'কপিরাইট © ২০২৩। সকল তথ্য সংরক্ষিত।', 'nasirabadcollege48@gmail.com', 'nasirabaduniversitycollege@yahoo.com', '০১৭১৩-২৬৬৮৭৭', '+৮৮-০২-৯৯৬৬৬৫০২২', NULL, 'Nasirabad', 'নাসিরাবাদ', 'SOFTECH BD LTD', 'সফটেক বাংলাদেশ লিমিটেড', 1948, 111912, 7250, 5204, NULL, NULL, '2023-04-05 17:31:55', '2023-09-25 10:03:56');

-- --------------------------------------------------------

--
-- Table structure for table `years`
--

CREATE TABLE `years` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `years`
--

INSERT INTO `years` (`id`, `name`, `created_at`, `updated_at`) VALUES
(2, '2023', '2023-08-11 03:52:08', '2023-08-11 03:52:08');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_us`
--
ALTER TABLE `about_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `bandhans`
--
ALTER TABLE `bandhans`
  ADD PRIMARY KEY (`id`),
  ADD KEY `bandhans_student_user_id_foreign` (`student_user_id`),
  ADD KEY `bandhans_active_by_foreign` (`active_by`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `books`
--
ALTER TABLE `books`
  ADD PRIMARY KEY (`id`),
  ADD KEY `books_book_category_id_foreign` (`book_category_id`),
  ADD KEY `books_book_author_id_foreign` (`book_author_id`),
  ADD KEY `books_book_publication_id_foreign` (`book_publication_id`),
  ADD KEY `books_user_id_foreign` (`user_id`);

--
-- Indexes for table `book_authors`
--
ALTER TABLE `book_authors`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_categories`
--
ALTER TABLE `book_categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_publications`
--
ALTER TABLE `book_publications`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `book_rents`
--
ALTER TABLE `book_rents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `book_rents_student_user_id_foreign` (`student_user_id`),
  ADD KEY `book_rents_book_id_foreign` (`book_id`),
  ADD KEY `book_rents_user_id_foreign` (`user_id`);

--
-- Indexes for table `class_routines`
--
ALTER TABLE `class_routines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_routines_entry_id_foreign` (`entry_id`),
  ADD KEY `class_routines_class_type_id_foreign` (`class_type_id`),
  ADD KEY `class_routines_session_id_foreign` (`session_id`),
  ADD KEY `class_routines_group_id_foreign` (`group_id`),
  ADD KEY `class_routines_class_year_id_foreign` (`class_year_id`);

--
-- Indexes for table `class_types`
--
ALTER TABLE `class_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `class_years`
--
ALTER TABLE `class_years`
  ADD PRIMARY KEY (`id`),
  ADD KEY `class_years_class_type_id_foreign` (`class_type_id`);

--
-- Indexes for table `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cultural_forums`
--
ALTER TABLE `cultural_forums`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cultural_forums_student_user_id_foreign` (`student_user_id`),
  ADD KEY `cultural_forums_active_by_foreign` (`active_by`);

--
-- Indexes for table `currencies`
--
ALTER TABLE `currencies`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `departments`
--
ALTER TABLE `departments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `document_types`
--
ALTER TABLE `document_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `education_boards`
--
ALTER TABLE `education_boards`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `exam_routines`
--
ALTER TABLE `exam_routines`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_routines_entry_id_foreign` (`entry_id`),
  ADD KEY `exam_routines_class_type_id_foreign` (`class_type_id`),
  ADD KEY `exam_routines_session_id_foreign` (`session_id`),
  ADD KEY `exam_routines_group_id_foreign` (`group_id`),
  ADD KEY `exam_routines_class_year_id_foreign` (`class_year_id`);

--
-- Indexes for table `exam_subjects`
--
ALTER TABLE `exam_subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `exam_subjects_exam_id_foreign` (`exam_id`),
  ADD KEY `exam_subjects_subject_id_foreign` (`subject_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `founders`
--
ALTER TABLE `founders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `galleries`
--
ALTER TABLE `galleries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`id`),
  ADD KEY `groups_class_type_id_foreign` (`class_type_id`);

--
-- Indexes for table `honored_teachers`
--
ALTER TABLE `honored_teachers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostels`
--
ALTER TABLE `hostels`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostels_hostel_type_id_foreign` (`hostel_type_id`);

--
-- Indexes for table `hostel_admission_fees`
--
ALTER TABLE `hostel_admission_fees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_admission_fees_hostel_id_foreign` (`hostel_id`),
  ADD KEY `hostel_admission_fees_added_id_foreign` (`added_id`),
  ADD KEY `hostel_admission_fees_approved_id_foreign` (`approved_id`);

--
-- Indexes for table `hostel_dues`
--
ALTER TABLE `hostel_dues`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_dues_hostel_student_id_foreign` (`hostel_student_id`),
  ADD KEY `hostel_dues_added_id_foreign` (`added_id`),
  ADD KEY `hostel_dues_approved_id_foreign` (`approved_id`);

--
-- Indexes for table `hostel_fees`
--
ALTER TABLE `hostel_fees`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_fees_hostel_id_foreign` (`hostel_id`),
  ADD KEY `hostel_fees_year_id_foreign` (`year_id`),
  ADD KEY `hostel_fees_month_id_foreign` (`month_id`),
  ADD KEY `hostel_fees_added_id_foreign` (`added_id`),
  ADD KEY `hostel_fees_approved_id_foreign` (`approved_id`);

--
-- Indexes for table `hostel_infos`
--
ALTER TABLE `hostel_infos`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostel_payment_histories`
--
ALTER TABLE `hostel_payment_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_payment_histories_hostel_student_id_foreign` (`hostel_student_id`),
  ADD KEY `hostel_payment_histories_hostel_fee_id_foreign` (`hostel_fee_id`),
  ADD KEY `hostel_payment_histories_paid_by_foreign` (`paid_by`),
  ADD KEY `hostel_payment_histories_payment_method_id_foreign` (`payment_method_id`) USING BTREE;

--
-- Indexes for table `hostel_rooms`
--
ALTER TABLE `hostel_rooms`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_rooms_hostel_id_foreign` (`hostel_id`);

--
-- Indexes for table `hostel_students`
--
ALTER TABLE `hostel_students`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_students_student_user_id_foreign` (`student_user_id`),
  ADD KEY `hostel_students_hostel_room_id_foreign` (`hostel_room_id`),
  ADD KEY `hostel_students_year_id_foreign` (`year_id`),
  ADD KEY `hostel_students_month_id_foreign` (`month_id`),
  ADD KEY `hostel_students_hostel_id_foreign` (`hostel_id`);

--
-- Indexes for table `hostel_types`
--
ALTER TABLE `hostel_types`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `hostel_waivers`
--
ALTER TABLE `hostel_waivers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `hostel_waivers_hostel_student_id_foreign` (`hostel_student_id`),
  ADD KEY `hostel_waivers_added_id_foreign` (`added_id`),
  ADD KEY `hostel_waivers_approved_id_foreign` (`approved_id`);

--
-- Indexes for table `important_links`
--
ALTER TABLE `important_links`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `mark_entries`
--
ALTER TABLE `mark_entries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `mark_entries_exam_id_foreign` (`exam_id`),
  ADD KEY `mark_entries_exam_subject_id_foreign` (`exam_subject_id`),
  ADD KEY `mark_entries_teacher_user_id_foreign` (`teacher_user_id`),
  ADD KEY `mark_entries_group_id_foreign` (`group_id`),
  ADD KEY `mark_entries_student_id_foreign` (`student_id`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `meritorious_students`
--
ALTER TABLE `meritorious_students`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `months`
--
ALTER TABLE `months`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news`
--
ALTER TABLE `news`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news_comments`
--
ALTER TABLE `news_comments`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `office_attendances`
--
ALTER TABLE `office_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `office_attendances_office_staff_id_foreign` (`office_staff_id`);

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `payment_history_details`
--
ALTER TABLE `payment_history_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_history_details_payment_history_id_foreign` (`payment_history_id`),
  ADD KEY `payment_history_details_fee_category_id_foreign` (`fee_category_id`);

--
-- Indexes for table `payment_methods`
--
ALTER TABLE `payment_methods`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `president_messages`
--
ALTER TABLE `president_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `principal_messages`
--
ALTER TABLE `principal_messages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `religions`
--
ALTER TABLE `religions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `result_summeries`
--
ALTER TABLE `result_summeries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `result_summeries_exam_id_foreign` (`exam_id`),
  ADD KEY `result_summeries_student_id_foreign` (`student_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `scouts`
--
ALTER TABLE `scouts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `scouts_student_user_id_foreign` (`student_user_id`),
  ADD KEY `scouts_active_by_foreign` (`active_by`);

--
-- Indexes for table `sessiones`
--
ALTER TABLE `sessiones`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sliders`
--
ALTER TABLE `sliders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sms_histories`
--
ALTER TABLE `sms_histories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social_media`
--
ALTER TABLE `social_media`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `students_infos`
--
ALTER TABLE `students_infos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `students_infos_student_user_id_foreign` (`student_user_id`),
  ADD KEY `students_infos_country_id_foreign` (`country_id`),
  ADD KEY `students_infos_district_id_foreign` (`district_id`),
  ADD KEY `students_infos_per_country_id_foreign` (`per_country_id`),
  ADD KEY `students_infos_per_district_id_foreign` (`per_district_id`);

--
-- Indexes for table `student_attendances`
--
ALTER TABLE `student_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_attendances_class_type_id_foreign` (`class_type_id`),
  ADD KEY `student_attendances_session_id_foreign` (`session_id`),
  ADD KEY `student_attendances_group_id_foreign` (`group_id`),
  ADD KEY `student_attendances_class_year_id_foreign` (`class_year_id`),
  ADD KEY `student_attendances_teacher_id_foreign` (`teacher_id`);

--
-- Indexes for table `student_attendance_details`
--
ALTER TABLE `student_attendance_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_attendance_details_student_attendance_id_foreign` (`student_attendance_id`),
  ADD KEY `student_attendance_details_student_id_foreign` (`student_id`);

--
-- Indexes for table `student_card_attendances`
--
ALTER TABLE `student_card_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_card_attendances_student_id_foreign` (`student_id`);

--
-- Indexes for table `student_education`
--
ALTER TABLE `student_education`
  ADD PRIMARY KEY (`id`),
  ADD KEY `student_education_student_user_id_foreign` (`student_user_id`);

--
-- Indexes for table `subjects`
--
ALTER TABLE `subjects`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subjects_class_type_id_foreign` (`class_type_id`),
  ADD KEY `subjects_group_id_foreign` (`group_id`),
  ADD KEY `subjects_class_year_id_foreign` (`class_year_id`);

--
-- Indexes for table `subject_students`
--
ALTER TABLE `subject_students`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subject_students_student_user_id_foreign` (`student_user_id`),
  ADD KEY `subject_students_student_id_foreign` (`student_id`),
  ADD KEY `subject_students_subject_id_foreign` (`subject_id`),
  ADD KEY `subject_students_class_year_id_foreign` (`class_year_id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sub_fee_categories`
--
ALTER TABLE `sub_fee_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_fee_categories_fee_category_id_foreign` (`fee_category_id`),
  ADD KEY `sub_fee_categories_user_id_foreign` (`user_id`);

--
-- Indexes for table `teachers`
--
ALTER TABLE `teachers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teachers_teacher_user_id_foreign` (`teacher_user_id`);

--
-- Indexes for table `teacher_attendances`
--
ALTER TABLE `teacher_attendances`
  ADD PRIMARY KEY (`id`),
  ADD KEY `teacher_attendances_teacher_id_foreign` (`teacher_id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`),
  ADD KEY `testimonials_student_user_id_foreign` (`student_user_id`),
  ADD KEY `testimonials_education_board_id_foreign` (`education_board_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `web_settings`
--
ALTER TABLE `web_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `years`
--
ALTER TABLE `years`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_us`
--
ALTER TABLE `about_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `bandhans`
--
ALTER TABLE `bandhans`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `books`
--
ALTER TABLE `books`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `book_authors`
--
ALTER TABLE `book_authors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `book_categories`
--
ALTER TABLE `book_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `book_publications`
--
ALTER TABLE `book_publications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `book_rents`
--
ALTER TABLE `book_rents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `class_routines`
--
ALTER TABLE `class_routines`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `class_types`
--
ALTER TABLE `class_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `class_years`
--
ALTER TABLE `class_years`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `cultural_forums`
--
ALTER TABLE `cultural_forums`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `currencies`
--
ALTER TABLE `currencies`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `document_types`
--
ALTER TABLE `document_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `education_boards`
--
ALTER TABLE `education_boards`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `exam_routines`
--
ALTER TABLE `exam_routines`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `exam_subjects`
--
ALTER TABLE `exam_subjects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `founders`
--
ALTER TABLE `founders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `galleries`
--
ALTER TABLE `galleries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `honored_teachers`
--
ALTER TABLE `honored_teachers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostels`
--
ALTER TABLE `hostels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `hostel_admission_fees`
--
ALTER TABLE `hostel_admission_fees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `hostel_dues`
--
ALTER TABLE `hostel_dues`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `hostel_fees`
--
ALTER TABLE `hostel_fees`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hostel_infos`
--
ALTER TABLE `hostel_infos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostel_payment_histories`
--
ALTER TABLE `hostel_payment_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `hostel_rooms`
--
ALTER TABLE `hostel_rooms`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `hostel_students`
--
ALTER TABLE `hostel_students`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `hostel_types`
--
ALTER TABLE `hostel_types`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `hostel_waivers`
--
ALTER TABLE `hostel_waivers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `important_links`
--
ALTER TABLE `important_links`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `mark_entries`
--
ALTER TABLE `mark_entries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `meritorious_students`
--
ALTER TABLE `meritorious_students`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=133;

--
-- AUTO_INCREMENT for table `months`
--
ALTER TABLE `months`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `news`
--
ALTER TABLE `news`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `news_comments`
--
ALTER TABLE `news_comments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `office_attendances`
--
ALTER TABLE `office_attendances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_history_details`
--
ALTER TABLE `payment_history_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `payment_methods`
--
ALTER TABLE `payment_methods`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `president_messages`
--
ALTER TABLE `president_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `principal_messages`
--
ALTER TABLE `principal_messages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `religions`
--
ALTER TABLE `religions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `result_summeries`
--
ALTER TABLE `result_summeries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `scouts`
--
ALTER TABLE `scouts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sessiones`
--
ALTER TABLE `sessiones`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sms_histories`
--
ALTER TABLE `sms_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `social_media`
--
ALTER TABLE `social_media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `students_infos`
--
ALTER TABLE `students_infos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `student_attendances`
--
ALTER TABLE `student_attendances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_attendance_details`
--
ALTER TABLE `student_attendance_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_card_attendances`
--
ALTER TABLE `student_card_attendances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `student_education`
--
ALTER TABLE `student_education`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `subjects`
--
ALTER TABLE `subjects`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `subject_students`
--
ALTER TABLE `subject_students`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=114;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `sub_fee_categories`
--
ALTER TABLE `sub_fee_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `teachers`
--
ALTER TABLE `teachers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `teacher_attendances`
--
ALTER TABLE `teacher_attendances`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `web_settings`
--
ALTER TABLE `web_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `years`
--
ALTER TABLE `years`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `bandhans`
--
ALTER TABLE `bandhans`
  ADD CONSTRAINT `bandhans_active_by_foreign` FOREIGN KEY (`active_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `bandhans_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`);

--
-- Constraints for table `books`
--
ALTER TABLE `books`
  ADD CONSTRAINT `books_book_author_id_foreign` FOREIGN KEY (`book_author_id`) REFERENCES `book_authors` (`id`),
  ADD CONSTRAINT `books_book_category_id_foreign` FOREIGN KEY (`book_category_id`) REFERENCES `book_categories` (`id`),
  ADD CONSTRAINT `books_book_publication_id_foreign` FOREIGN KEY (`book_publication_id`) REFERENCES `book_publications` (`id`),
  ADD CONSTRAINT `books_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `book_rents`
--
ALTER TABLE `book_rents`
  ADD CONSTRAINT `book_rents_book_id_foreign` FOREIGN KEY (`book_id`) REFERENCES `books` (`id`),
  ADD CONSTRAINT `book_rents_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`),
  ADD CONSTRAINT `book_rents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `class_routines`
--
ALTER TABLE `class_routines`
  ADD CONSTRAINT `class_routines_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`),
  ADD CONSTRAINT `class_routines_class_year_id_foreign` FOREIGN KEY (`class_year_id`) REFERENCES `class_years` (`id`),
  ADD CONSTRAINT `class_routines_entry_id_foreign` FOREIGN KEY (`entry_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `class_routines_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  ADD CONSTRAINT `class_routines_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `sessiones` (`id`);

--
-- Constraints for table `class_years`
--
ALTER TABLE `class_years`
  ADD CONSTRAINT `class_years_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`);

--
-- Constraints for table `cultural_forums`
--
ALTER TABLE `cultural_forums`
  ADD CONSTRAINT `cultural_forums_active_by_foreign` FOREIGN KEY (`active_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `cultural_forums_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`);

--
-- Constraints for table `exam_routines`
--
ALTER TABLE `exam_routines`
  ADD CONSTRAINT `exam_routines_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`),
  ADD CONSTRAINT `exam_routines_class_year_id_foreign` FOREIGN KEY (`class_year_id`) REFERENCES `class_years` (`id`),
  ADD CONSTRAINT `exam_routines_entry_id_foreign` FOREIGN KEY (`entry_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `exam_routines_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  ADD CONSTRAINT `exam_routines_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `sessiones` (`id`);

--
-- Constraints for table `exam_subjects`
--
ALTER TABLE `exam_subjects`
  ADD CONSTRAINT `exam_subjects_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`),
  ADD CONSTRAINT `exam_subjects_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`);

--
-- Constraints for table `groups`
--
ALTER TABLE `groups`
  ADD CONSTRAINT `groups_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`);

--
-- Constraints for table `hostels`
--
ALTER TABLE `hostels`
  ADD CONSTRAINT `hostels_hostel_type_id_foreign` FOREIGN KEY (`hostel_type_id`) REFERENCES `hostel_types` (`id`);

--
-- Constraints for table `hostel_admission_fees`
--
ALTER TABLE `hostel_admission_fees`
  ADD CONSTRAINT `hostel_admission_fees_added_id_foreign` FOREIGN KEY (`added_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_admission_fees_approved_id_foreign` FOREIGN KEY (`approved_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_admission_fees_hostel_id_foreign` FOREIGN KEY (`hostel_id`) REFERENCES `hostels` (`id`);

--
-- Constraints for table `hostel_dues`
--
ALTER TABLE `hostel_dues`
  ADD CONSTRAINT `hostel_dues_added_id_foreign` FOREIGN KEY (`added_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_dues_approved_id_foreign` FOREIGN KEY (`approved_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_dues_hostel_student_id_foreign` FOREIGN KEY (`hostel_student_id`) REFERENCES `hostel_students` (`id`);

--
-- Constraints for table `hostel_fees`
--
ALTER TABLE `hostel_fees`
  ADD CONSTRAINT `hostel_fees_added_id_foreign` FOREIGN KEY (`added_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_fees_approved_id_foreign` FOREIGN KEY (`approved_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_fees_hostel_id_foreign` FOREIGN KEY (`hostel_id`) REFERENCES `hostels` (`id`),
  ADD CONSTRAINT `hostel_fees_month_id_foreign` FOREIGN KEY (`month_id`) REFERENCES `months` (`id`),
  ADD CONSTRAINT `hostel_fees_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`);

--
-- Constraints for table `hostel_payment_histories`
--
ALTER TABLE `hostel_payment_histories`
  ADD CONSTRAINT `hostel_payment_histories_hostel_fee_id_foreign` FOREIGN KEY (`hostel_fee_id`) REFERENCES `hostel_fees` (`id`),
  ADD CONSTRAINT `hostel_payment_histories_hostel_student_id_foreign` FOREIGN KEY (`hostel_student_id`) REFERENCES `hostel_students` (`id`),
  ADD CONSTRAINT `hostel_payment_histories_paid_by_foreign` FOREIGN KEY (`paid_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_payment_histories_payment_mehtod_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`);

--
-- Constraints for table `hostel_rooms`
--
ALTER TABLE `hostel_rooms`
  ADD CONSTRAINT `hostel_rooms_hostel_id_foreign` FOREIGN KEY (`hostel_id`) REFERENCES `hostels` (`id`);

--
-- Constraints for table `hostel_students`
--
ALTER TABLE `hostel_students`
  ADD CONSTRAINT `hostel_students_hostel_id_foreign` FOREIGN KEY (`hostel_id`) REFERENCES `hostels` (`id`),
  ADD CONSTRAINT `hostel_students_hostel_room_id_foreign` FOREIGN KEY (`hostel_room_id`) REFERENCES `hostel_rooms` (`id`),
  ADD CONSTRAINT `hostel_students_month_id_foreign` FOREIGN KEY (`month_id`) REFERENCES `months` (`id`),
  ADD CONSTRAINT `hostel_students_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`),
  ADD CONSTRAINT `hostel_students_year_id_foreign` FOREIGN KEY (`year_id`) REFERENCES `years` (`id`);

--
-- Constraints for table `hostel_waivers`
--
ALTER TABLE `hostel_waivers`
  ADD CONSTRAINT `hostel_waivers_added_id_foreign` FOREIGN KEY (`added_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_waivers_approved_id_foreign` FOREIGN KEY (`approved_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `hostel_waivers_hostel_student_id_foreign` FOREIGN KEY (`hostel_student_id`) REFERENCES `hostel_students` (`id`);

--
-- Constraints for table `mark_entries`
--
ALTER TABLE `mark_entries`
  ADD CONSTRAINT `mark_entries_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`),
  ADD CONSTRAINT `mark_entries_exam_subject_id_foreign` FOREIGN KEY (`exam_subject_id`) REFERENCES `exam_subjects` (`id`),
  ADD CONSTRAINT `mark_entries_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  ADD CONSTRAINT `mark_entries_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`),
  ADD CONSTRAINT `mark_entries_teacher_user_id_foreign` FOREIGN KEY (`teacher_user_id`) REFERENCES `teacher_users` (`id`);

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `office_attendances`
--
ALTER TABLE `office_attendances`
  ADD CONSTRAINT `office_attendances_office_staff_id_foreign` FOREIGN KEY (`office_staff_id`) REFERENCES `office_staff` (`id`);

--
-- Constraints for table `payment_history_details`
--
ALTER TABLE `payment_history_details`
  ADD CONSTRAINT `payment_history_details_fee_category_id_foreign` FOREIGN KEY (`fee_category_id`) REFERENCES `fee_categories` (`id`),
  ADD CONSTRAINT `payment_history_details_payment_history_id_foreign` FOREIGN KEY (`payment_history_id`) REFERENCES `payment_histories` (`id`);

--
-- Constraints for table `result_summeries`
--
ALTER TABLE `result_summeries`
  ADD CONSTRAINT `result_summeries_exam_id_foreign` FOREIGN KEY (`exam_id`) REFERENCES `exams` (`id`),
  ADD CONSTRAINT `result_summeries_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`);

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `scouts`
--
ALTER TABLE `scouts`
  ADD CONSTRAINT `scouts_active_by_foreign` FOREIGN KEY (`active_by`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `scouts_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`);

--
-- Constraints for table `students_infos`
--
ALTER TABLE `students_infos`
  ADD CONSTRAINT `students_infos_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `students_infos_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`),
  ADD CONSTRAINT `students_infos_per_country_id_foreign` FOREIGN KEY (`per_country_id`) REFERENCES `countries` (`id`),
  ADD CONSTRAINT `students_infos_per_district_id_foreign` FOREIGN KEY (`per_district_id`) REFERENCES `districts` (`id`),
  ADD CONSTRAINT `students_infos_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`);

--
-- Constraints for table `student_attendances`
--
ALTER TABLE `student_attendances`
  ADD CONSTRAINT `student_attendances_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`),
  ADD CONSTRAINT `student_attendances_class_year_id_foreign` FOREIGN KEY (`class_year_id`) REFERENCES `class_years` (`id`),
  ADD CONSTRAINT `student_attendances_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`),
  ADD CONSTRAINT `student_attendances_session_id_foreign` FOREIGN KEY (`session_id`) REFERENCES `sessiones` (`id`),
  ADD CONSTRAINT `student_attendances_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`);

--
-- Constraints for table `student_attendance_details`
--
ALTER TABLE `student_attendance_details`
  ADD CONSTRAINT `student_attendance_details_student_attendance_id_foreign` FOREIGN KEY (`student_attendance_id`) REFERENCES `student_attendances` (`id`),
  ADD CONSTRAINT `student_attendance_details_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`);

--
-- Constraints for table `student_card_attendances`
--
ALTER TABLE `student_card_attendances`
  ADD CONSTRAINT `student_card_attendances_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`);

--
-- Constraints for table `student_education`
--
ALTER TABLE `student_education`
  ADD CONSTRAINT `student_education_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`);

--
-- Constraints for table `subjects`
--
ALTER TABLE `subjects`
  ADD CONSTRAINT `subjects_class_type_id_foreign` FOREIGN KEY (`class_type_id`) REFERENCES `class_types` (`id`),
  ADD CONSTRAINT `subjects_class_year_id_foreign` FOREIGN KEY (`class_year_id`) REFERENCES `class_years` (`id`),
  ADD CONSTRAINT `subjects_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`);

--
-- Constraints for table `subject_students`
--
ALTER TABLE `subject_students`
  ADD CONSTRAINT `subject_students_class_year_id_foreign` FOREIGN KEY (`class_year_id`) REFERENCES `class_years` (`id`),
  ADD CONSTRAINT `subject_students_student_id_foreign` FOREIGN KEY (`student_id`) REFERENCES `students` (`id`),
  ADD CONSTRAINT `subject_students_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`),
  ADD CONSTRAINT `subject_students_subject_id_foreign` FOREIGN KEY (`subject_id`) REFERENCES `subjects` (`id`);

--
-- Constraints for table `sub_fee_categories`
--
ALTER TABLE `sub_fee_categories`
  ADD CONSTRAINT `sub_fee_categories_fee_category_id_foreign` FOREIGN KEY (`fee_category_id`) REFERENCES `fee_categories` (`id`),
  ADD CONSTRAINT `sub_fee_categories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `teachers`
--
ALTER TABLE `teachers`
  ADD CONSTRAINT `teachers_teacher_user_id_foreign` FOREIGN KEY (`teacher_user_id`) REFERENCES `teacher_users` (`id`);

--
-- Constraints for table `teacher_attendances`
--
ALTER TABLE `teacher_attendances`
  ADD CONSTRAINT `teacher_attendances_teacher_id_foreign` FOREIGN KEY (`teacher_id`) REFERENCES `teachers` (`id`);

--
-- Constraints for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD CONSTRAINT `testimonials_education_board_id_foreign` FOREIGN KEY (`education_board_id`) REFERENCES `education_boards` (`id`),
  ADD CONSTRAINT `testimonials_student_user_id_foreign` FOREIGN KEY (`student_user_id`) REFERENCES `student_users` (`id`);
COMMIT;

