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

START TRANSACTION;



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

--
-- Table structure for table `tbl_answers`
--

CREATE TABLE `tbl_answers` (
  `answer_id` int(11) NOT NULL,
  `submit_answer` varchar(255) NOT NULL,
  `final_marks` int(11) NOT NULL,
  `negative_marks` int(11) DEFAULT NULL,
  `question_id` int(11) NOT NULL,
  `answer_remark` enum('correct','wrong') NOT NULL,
  `attempt_answer_time` int(11) NOT NULL,
  `attempt_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_attempts`
--

CREATE TABLE `tbl_attempts` (
  `attempt_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `package_id` int(11) NOT NULL,
  `sheet_id` int(11) NOT NULL,
  `total_marks` int(11) DEFAULT NULL,
  `obtained_marks` int(11) DEFAULT NULL,
  `percentage` float DEFAULT NULL,
  `exam_status` enum('finished','deleted') DEFAULT NULL,
  `result_status` enum('pending','approved') DEFAULT NULL,
  `exam_type` enum('free','paid') NOT NULL,
  `serial_questions_id` text DEFAULT NULL,
  `time_taken` int(11) NOT NULL DEFAULT 0,
  `attempt_at` datetime NOT NULL,
  `submission_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_chapters`
--

CREATE TABLE `tbl_chapters` (
  `chapter_id` int(11) NOT NULL,
  `exam_type_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `chapter_name` varchar(255) NOT NULL,
  `position_chapter` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_classes`
--

CREATE TABLE `tbl_classes` (
  `class_id` int(11) NOT NULL,
  `class` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_class_schedule`
--

CREATE TABLE `tbl_class_schedule` (
  `class_schedule_id` int(11) NOT NULL,
  `exam_category_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_cms`
--

CREATE TABLE `tbl_cms` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `segment` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_cms`
--

INSERT INTO `tbl_cms` (`id`, `title`, `description`, `segment`) VALUES
(1, 'About Aims', '', 'about-aims'),
(2, 'Online Payment', '<p>Online Payment</p>\r\n', 'online-payment'),
(3, 'Privacy Policy', '<p>PRIVACY POLICY<br />\r\nProtecting the security and privacy of your personal data is important to Aims; therefore, we conduct our business in compliance with applicable laws on data privacy protection and data security. We hope the policy outlined below will help you understand what data Aims&nbsp;may collect, how Aims&nbsp;uses and safeguards that data and with whom we may share it. This Privacy Policy explains how Aims&nbsp;collects personal and non-personal information, classified as mandatory or voluntary and uses, discloses and protects such information through the Website.</p>\r\n\r\n<p>&lsquo;Personal Information&rsquo; is data that can be used to uniquely identify or contact a single person (&ldquo;Personal Information&rdquo;). Personal Information for the purposes of this Policy shall include, but not limited to, information regarding Your name, address, telephone number, date of birth, gender, e-mail address, etc. You may need to provide Your Personal Information during the course of using some services of the Aims, for instance, creating a User ID, provide information in Your account while registering on the app,or communicate with Aims&nbsp;by phone, email or otherwise, provide reviews for the content available on the Website.</p>\r\n\r\n<p>The Information Aims&nbsp;Collects User-provided Information: When you register for, browse and use the Website, you may provide to Aims&nbsp;what is generally called &ldquo;personally identifiable information&rdquo; (such as your full name, email address, postal mailing address, and/or home/mobile telephone number).</p>\r\n\r\n<p>You should check your privacy settings on each Integrated Service to understand and change the information sent to us through each Integrated Service. Please review each Integrated Service&rsquo;s terms of use and privacy policies carefully before using their services and connecting to our Website. From time to time, Aims may also ask you optionally to provide other information. If you choose to provide such information, during registration or otherwise, you are giving Aims&nbsp;the permission to use and store it consistent with this policy.</p>\r\n\r\n<p>The Way Aims Uses Information that you provide or that we collect in order to establish and enhance our relationship with you. Aims&nbsp;generally uses the information you provide or that we collect to operate, maintain, enhance, and provide all of the features and services found on the Website. If you have given Aims consent, we may use your personally identifiable information to provide you with information about website&rsquo;s features, services and other offerings that may be of interest to you.</p>\r\n\r\n<p>Aims&nbsp;also reserves the right to disclose User information that we believe, in good faith, is appropriate or necessary to take precautions against liability; protect Aims&nbsp;from fraudulent, abusive, or unlawful uses; to investigate and defend ourselves against any third-party claims or allegations; to assist government enforcement agencies; to protect the security or integrity of the Website; or to protect the rights, property, or personal safety of Aims, our Users, or others. You may, of course, decline to share your personally-identifiable information with Aims, in which case Aims&nbsp;will not be able to provide to you some of the features and functionality found on the Website. If you register as a member of Aims, you may update, correct, or delete your profile information and preferences at any time by going to your account settings page. To protect your privacy and security, we take reasonable steps to verify your identity before granting you account access or making corrections to your information.</p>\r\n\r\n<p>You are responsible for maintaining the secrecy of your unique password and account information at all times.</p>\r\n\r\n<p>What we collect:<br />\r\nWe may collect the following information:</p>\r\n\r\n<p>name and residential /permanent address of students/users<br />\r\nquery related to students&rsquo; enrollment/registration<br />\r\ncontact information including email address<br />\r\ndemographic information such as postcode, preferences, and interests<br />\r\nother information relevant to user and/or offers<br />\r\nWhat we do with the information we gather<br />\r\nWe require this information to understand your needs and provide you with a better service, and in particular for the following reasons:</p>\r\n\r\n<p>Internal record keeping.<br />\r\nWe may use the information to improve our services for students/users.<br />\r\nWe may periodically send promotional emails about new courses or other incidental information which we think you may find interesting using the email address which you have provided.<br />\r\nFrom time to time, we may also use your information to contact you for students related issues research purposes. We may contact you by email, phone, fax or mail, SMS messages etc. We may use the information to customize the website according to your interests.<br />\r\nAll transactions are processed through a gateway provider and are not stored or processed on our servers. So, in any case, we do not store any of the payer&rsquo;s payment or transaction information.</p>\r\n\r\n<p>When you visit the Institute Official Website, the following information may be collected from you, either voluntarily or involuntarily:</p>\r\n\r\n<p>Your computer or network IP address, which must be validated in order for you to access the Aims&nbsp;Official Website;<br />\r\n&nbsp;Your e-mail address and message when you communicate electronically with us;<br />\r\nNote: By submitting a payment through the online-payments site you are agreeing to these terms and conditions including any updated changes in terms and conditions from time to time through our website.</p>\r\n', 'privacy-policy'),
(4, 'Refund Rules', '<p>As of now we do not provide any option for cancellation of products and / or services you have purchased or subscribed. Once a product / service has been purchased by you, we cannot provide any refund, either totally or partially in any case / situation / circumstances.</p>\r\n\r\n<p>We suggest that first you go through the demos and / or free to use contents / products / services before you subscribe to or purchase from aimscognitivetests.in</p>\r\n', 'refund-rules'),
(5, 'Terms & Conditions', '', 'terms-and-conditions'),
(6, 'Faqs', '<p>Faqs</p>\r\n', 'faqs');

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

--
-- Table structure for table `tbl_compose_sheets`
--

CREATE TABLE `tbl_compose_sheets` (
  `id` int(11) NOT NULL,
  `compose_sheet_id` int(11) NOT NULL,
  `sheet_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tbl_comprehensives`
--

CREATE TABLE `tbl_comprehensives` (
  `comprehensive_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `comprehensive` text DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `comprehensive_created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_contents`
--

CREATE TABLE `tbl_contents` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `short_description` text NOT NULL,
  `type` enum('banner','list') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_contents`
--

INSERT INTO `tbl_contents` (`id`, `title`, `short_description`, `type`) VALUES
(1, 'Best software landing page for you!', 'Lorem ipsum dolor sitamet consectetur adipisicing elit seddo enim is doloremque laudantium, totam rem aperiam.', 'banner'),
(2, 'Experience & Skilled', '1.Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolor erat, sed diam voluptua', 'list'),
(3, 'Feature Integration', '2.Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolor erat, sed diam voluptua', 'list'),
(4, 'Multiple Dicussion', '3.Consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolor erat, sed diam voluptua', 'list');

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

--
-- Table structure for table `tbl_country_codes`
--

CREATE TABLE `tbl_country_codes` (
  `country_code_id` int(11) NOT NULL,
  `country_code` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_country_codes`
--

INSERT INTO `tbl_country_codes` (`country_code_id`, `country_code`) VALUES
(1, 'India (+91)'),
(2, 'Australia (+61)'),
(3, 'Bangladesh (+880)'),
(4, 'United States of America (+1)'),
(5, 'New Zealand (+64)');

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

--
-- Table structure for table `tbl_courses`
--

CREATE TABLE `tbl_courses` (
  `course_id` int(11) NOT NULL,
  `exam_category_id` int(11) NOT NULL,
  `course_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_examinations`
--

CREATE TABLE `tbl_examinations` (
  `examination_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `target_year` year(4) NOT NULL,
  `class` varchar(255) NOT NULL,
  `price` float NOT NULL,
  `tab_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_exam_category`
--

CREATE TABLE `tbl_exam_category` (
  `exam_category_id` int(11) NOT NULL,
  `exam_category` varchar(50) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_exam_category`
--

INSERT INTO `tbl_exam_category` (`exam_category_id`, `exam_category`, `status`) VALUES
(1, 'Test Series', 1),
(2, 'Scholarship Test', 1),
(3, 'Free Mocktest', 1);

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

--
-- Table structure for table `tbl_exam_type`
--

CREATE TABLE `tbl_exam_type` (
  `exam_type_id` int(11) NOT NULL,
  `exam_type` varchar(255) NOT NULL,
  `position_exam_type` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_groups`
--

CREATE TABLE `tbl_groups` (
  `group_id` int(11) NOT NULL,
  `group_name` varchar(255) NOT NULL,
  `packages` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_groups`
--

INSERT INTO `tbl_groups` (`group_id`, `group_name`, `packages`, `created_at`) VALUES
(21, 'Demo Group', '3,8,9,10,11,12,13,14,15,16,17,18,19,20', '2020-04-20 14:03:37'),
(35, 'AST 2021 IX ENG', '20,21,22', '2020-12-13 02:16:42'),
(36, 'AST 2021 IX MED', '19,20,21', '2020-12-13 02:17:26'),
(37, 'AST 2021 X ENG', '10,11,23', '2020-12-13 02:19:08'),
(38, 'AST 2021 X MED', '11,18,23', '2020-12-13 02:19:23'),
(39, 'AST 2021 XI ENG', '3,12,13', '2020-12-13 02:19:39'),
(40, 'AST 2021 XI MED', '12,13,16', '2020-12-13 02:20:09'),
(41, 'AST 2021 XII ENG', '8,9,14', '2020-12-13 02:20:22'),
(42, 'AST 2021 XII MED', '8,14,15', '2020-12-13 02:20:39'),
(49, 'JEE Main 2021 Mock Test', '29,38,43', '2020-12-31 18:09:37'),
(55, 'JEE Mock 2021 Mock Test PHYS', '33,37,39,44,47', '2021-01-22 09:23:06'),
(56, 'NEET Mock Test 2021', '51', '2021-01-28 08:14:27'),
(57, 'NEET Mock Test 2021 BIOS', '34,41', '2021-01-28 08:14:44'),
(59, 'Revision Test 2 Yrs New MAIN', '48', '2021-04-24 05:31:50'),
(60, 'Revision Test 2 Yrs New NEET', '49', '2021-04-28 07:29:58'),
(61, 'NEET Mock Test 2021', NULL, '2021-05-14 12:21:48'),
(62, 'CLASS TEST XI 2021', '52', '2021-07-15 18:50:45'),
(63, 'Compose Group', '51,53', '2021-07-16 03:52:37');

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

--
-- Table structure for table `tbl_live_class_group`
--

CREATE TABLE `tbl_live_class_group` (
  `id` int(11) NOT NULL,
  `live_class_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_live_class_group`
--

INSERT INTO `tbl_live_class_group` (`id`, `live_class_id`, `group_id`) VALUES
(5, 1, 21);

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

--
-- Table structure for table `tbl_marks`
--

CREATE TABLE `tbl_marks` (
  `marks_id` int(11) NOT NULL,
  `exam_type_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `question_type_id` int(11) NOT NULL,
  `marks` int(11) NOT NULL,
  `negative_marks` int(11) NOT NULL,
  `question_time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_orders`
--

CREATE TABLE `tbl_orders` (
  `order_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `target_year` year(4) NOT NULL,
  `class` varchar(255) NOT NULL,
  `price` float NOT NULL,
  `tab` varchar(255) NOT NULL,
  `ordered_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_packages`
--

CREATE TABLE `tbl_packages` (
  `package_id` int(11) NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `price` float NOT NULL,
  `sale_price` float NOT NULL,
  `short_description` text NOT NULL,
  `package_image` varchar(255) DEFAULT NULL,
  `sheet_id` text NOT NULL,
  `package_start_time` timestamp NULL DEFAULT NULL,
  `package_end_time` timestamp NULL DEFAULT NULL,
  `package_type` enum('paid','free') NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_pages`
--

CREATE TABLE `tbl_pages` (
  `id` int(11) NOT NULL,
  `meta_title` varchar(255) NOT NULL,
  `meta_descriptions` text NOT NULL,
  `meta_keywords` varchar(255) NOT NULL,
  `segment` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_pages`
--

INSERT INTO `tbl_pages` (`id`, `meta_title`, `meta_descriptions`, `meta_keywords`, `segment`) VALUES
(1, 'Online Test Series for JEE ( mains & Advanced) | NEET| Aims Barrackpore', 'Join India’s best Online test series for JEE Mains, JEE Advanced, NEET & Others Pre Engineering & Pre Medical Entrance Examination, CBSE,ICSE,ISC over more than 1 lakhs unique question for JEE ( Mains & Advanced) & NEET ( UG). Join Aims Online test series and get free Mock test based on latest NTA guideline. ', 'JEEmain online test,JEEadvanced online test,NEET Online Test,AIIMS Online test,IITJEE Online Test', 'home'),
(2, 'Aims online Test Series', 'Aims, India’s most trusted coaching institute provide best Online test series for NEET & JEE & Others Pre Engineering & Pre Medical Entrance examination. For Online Test Call +917003557150', 'Aims Barrackpore,Aims online test for NEET,Aims online Test for JEE,Aims coaching kolkata', 'contact-us');

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

--
-- Table structure for table `tbl_parent_levels`
--

CREATE TABLE `tbl_parent_levels` (
  `parent_level_id` int(11) NOT NULL,
  `parent_level_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_parent_levels`
--

INSERT INTO `tbl_parent_levels` (`parent_level_id`, `parent_level_name`) VALUES
(1, 'Easy'),
(2, 'Medium'),
(3, 'Hard');

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

--
-- Table structure for table `tbl_questions`
--

CREATE TABLE `tbl_questions` (
  `question_id` int(11) NOT NULL,
  `question_type_id` int(11) NOT NULL,
  `comprehensive_id` int(11) DEFAULT NULL,
  `question` text NOT NULL,
  `option1` text DEFAULT NULL,
  `option2` text DEFAULT NULL,
  `option3` text DEFAULT NULL,
  `option4` text DEFAULT NULL,
  `option5` text DEFAULT NULL,
  `option6` text DEFAULT NULL,
  `option7` text DEFAULT NULL,
  `option8` text DEFAULT NULL,
  `option9` text DEFAULT NULL,
  `option10` text DEFAULT NULL,
  `option11` text DEFAULT NULL,
  `option12` text DEFAULT NULL,
  `option13` text DEFAULT NULL,
  `option14` text DEFAULT NULL,
  `option15` text DEFAULT NULL,
  `option16` text DEFAULT NULL,
  `correct_answer` varchar(255) DEFAULT NULL,
  `explanation` text DEFAULT NULL,
  `video_explanation` varchar(255) DEFAULT NULL,
  `marks` int(11) NOT NULL DEFAULT 0,
  `negative_marks` int(11) NOT NULL DEFAULT 0,
  `question_time` int(11) NOT NULL DEFAULT 0,
  `topic_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `remarks` varchar(150) DEFAULT NULL,
  `position_question` int(11) NOT NULL,
  `created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_question_banks`
--

CREATE TABLE `tbl_question_banks` (
  `question_bank_id` int(11) NOT NULL,
  `sheet_id` int(11) NOT NULL,
  `topic_id` int(11) NOT NULL,
  `question_id` text DEFAULT NULL,
  `no_of_objective` int(11) NOT NULL DEFAULT 0,
  `no_of_true_false` int(11) NOT NULL DEFAULT 0,
  `no_of_comprehensive` int(11) NOT NULL DEFAULT 0,
  `no_of_numeric` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_question_types`
--

CREATE TABLE `tbl_question_types` (
  `question_type_id` int(11) NOT NULL,
  `question_type` varchar(255) NOT NULL,
  `question_type_name` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_question_types`
--

INSERT INTO `tbl_question_types` (`question_type_id`, `question_type`, `question_type_name`) VALUES
(1, 'Objective', 'objective'),
(2, 'True & False', 'true_false'),
(3, 'Comprehensive', 'comprehensive'),
(4, 'Numeric', 'numeric'),
(5, 'Subjective', 'subjective');

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

--
-- Table structure for table `tbl_save_attempt_questions`
--

CREATE TABLE `tbl_save_attempt_questions` (
  `sq_id` int(11) NOT NULL,
  `attempt_id` int(11) NOT NULL,
  `question_id` int(11) NOT NULL,
  `save_answer` varchar(255) NOT NULL DEFAULT 'not_attempt',
  `save_answer_time` int(11) NOT NULL DEFAULT 0,
  `attempt_status` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_save_attempt_questions`
--

INSERT INTO `tbl_save_attempt_questions` (`sq_id`, `attempt_id`, `question_id`, `save_answer`, `save_answer_time`, `attempt_status`) VALUES
(127, 6, 17145, 'not_attempt', 19, 0),
(128, 6, 17144, '3', 1, 1),
(129, 6, 17146, '4', 1, 1),
(130, 6, 17148, 'not_attempt', 0, 0),
(131, 6, 17142, 'not_attempt', 0, 0),
(132, 6, 17140, 'not_attempt', 0, 0),
(133, 6, 17141, 'not_attempt', 0, 0),
(134, 6, 17139, 'not_attempt', 0, 0),
(135, 6, 17135, 'not_attempt', 0, 0),
(136, 6, 17134, 'not_attempt', 0, 0),
(137, 6, 17152, 'not_attempt', 0, 0),
(138, 6, 17151, 'not_attempt', 0, 0),
(139, 7, 15246, '1', 22, 1),
(140, 7, 9334, 'not_attempt', 0, 0),
(141, 7, 14822, 'not_attempt', 0, 0),
(142, 7, 15004, 'not_attempt', 0, 0),
(143, 7, 14818, 'not_attempt', 0, 0),
(144, 7, 15455, 'not_attempt', 0, 0),
(145, 7, 14815, 'not_attempt', 0, 0),
(146, 7, 9309, 'not_attempt', 0, 0),
(147, 7, 16846, 'not_attempt', 0, 0),
(148, 7, 16844, 'not_attempt', 0, 0),
(149, 7, 14800, 'not_attempt', 0, 0),
(150, 7, 8635, 'not_attempt', 0, 0),
(151, 7, 16801, 'not_attempt', 0, 0),
(152, 7, 7784, 'not_attempt', 0, 0),
(153, 7, 14791, 'not_attempt', 0, 0),
(154, 7, 16794, 'not_attempt', 0, 0),
(155, 7, 15415, 'not_attempt', 0, 0),
(156, 7, 16840, 'not_attempt', 0, 0),
(157, 7, 16843, 'not_attempt', 0, 0),
(158, 7, 15154, 'not_attempt', 0, 0),
(159, 7, 8629, 'not_attempt', 0, 0),
(160, 7, 15417, 'not_attempt', 0, 0),
(161, 7, 15453, 'not_attempt', 0, 0),
(162, 7, 16847, 'not_attempt', 0, 0),
(163, 7, 15334, 'not_attempt', 0, 0),
(164, 7, 14953, 'not_attempt', 0, 0),
(165, 7, 9337, 'not_attempt', 0, 0),
(166, 7, 15336, 'not_attempt', 0, 0),
(167, 7, 7786, 'not_attempt', 0, 0),
(168, 7, 9310, 'not_attempt', 0, 0),
(169, 7, 16790, 'not_attempt', 0, 0),
(170, 7, 14789, 'not_attempt', 0, 0),
(171, 7, 8638, 'not_attempt', 0, 0),
(172, 7, 9341, 'not_attempt', 0, 0),
(173, 7, 9308, 'not_attempt', 0, 0),
(174, 7, 16845, 'not_attempt', 0, 0),
(175, 7, 8641, 'not_attempt', 0, 0),
(176, 7, 9321, 'not_attempt', 0, 0),
(177, 7, 15241, 'not_attempt', 0, 0),
(178, 7, 16842, 'not_attempt', 0, 0),
(179, 7, 9326, 'not_attempt', 0, 0),
(180, 7, 14952, 'not_attempt', 0, 0),
(181, 7, 14987, 'not_attempt', 0, 0),
(182, 7, 16841, 'not_attempt', 0, 0),
(183, 7, 15460, 'not_attempt', 0, 0),
(184, 8, 17145, 'not_attempt', 0, 0),
(185, 8, 17146, 'not_attempt', 0, 0),
(186, 8, 17148, 'not_attempt', 0, 0),
(187, 8, 17144, 'not_attempt', 0, 0);

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

--
-- Table structure for table `tbl_sheets`
--

CREATE TABLE `tbl_sheets` (
  `sheet_id` int(11) NOT NULL,
  `sheet_name` varchar(255) NOT NULL,
  `short_description` text NOT NULL,
  `parent_level_id` int(11) NOT NULL,
  `sheet_duration` int(11) NOT NULL,
  `instruction` text NOT NULL,
  `sheets` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_sheet_types`
--

CREATE TABLE `tbl_sheet_types` (
  `sheet_type_id` int(11) NOT NULL,
  `exam_type_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `sheet_type` varchar(255) NOT NULL,
  `sheet` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_sheet_types`
--

INSERT INTO `tbl_sheet_types` (`sheet_type_id`, `exam_type_id`, `subject_id`, `sheet_type`, `sheet`) VALUES
(1, 1, 2, 'Sheet Type', '1,2'),
(2, 1, 2, 'Sheet Type 2', '1,2,7');

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

--
-- Table structure for table `tbl_students_assign_group`
--

CREATE TABLE `tbl_students_assign_group` (
  `sa_id` int(11) NOT NULL,
  `exam_category_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `added_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_students_assign_group`
--

INSERT INTO `tbl_students_assign_group` (`sa_id`, `exam_category_id`, `course_id`, `class_id`, `group_id`, `student_id`, `added_at`) VALUES
(1, 1, 2, 3, 63, 44, '2021-07-16 04:06:30'),
(2, 1, 1, 1, 21, 66, '2022-10-10 14:07:06');

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

--
-- Table structure for table `tbl_subjects`
--

CREATE TABLE `tbl_subjects` (
  `subject_id` int(11) NOT NULL,
  `exam_type_id` int(11) NOT NULL,
  `subject_name` varchar(255) NOT NULL,
  `position_subject` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `tbl_tabs`
--

CREATE TABLE `tbl_tabs` (
  `tab_id` int(11) NOT NULL,
  `tab` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tbl_tabs`
--

INSERT INTO `tbl_tabs` (`tab_id`, `tab`) VALUES
(1, 'Pre Engineering'),
(2, 'Pre Medical'),
(3, 'Others');

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

--
-- Table structure for table `tbl_topics`
--

CREATE TABLE `tbl_topics` (
  `topic_id` int(11) NOT NULL,
  `exam_type_id` int(11) NOT NULL,
  `subject_id` int(11) NOT NULL,
  `chapter_id` int(11) NOT NULL,
  `topic_name` varchar(255) NOT NULL,
  `parent_level_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for table `tbl_answers`
--
ALTER TABLE `tbl_answers`
  ADD PRIMARY KEY (`answer_id`);

--
-- Indexes for table `tbl_attempts`
--
ALTER TABLE `tbl_attempts`
  ADD PRIMARY KEY (`attempt_id`);

--
-- Indexes for table `tbl_chapters`
--
ALTER TABLE `tbl_chapters`
  ADD PRIMARY KEY (`chapter_id`);

--
-- Indexes for table `tbl_classes`
--
ALTER TABLE `tbl_classes`
  ADD PRIMARY KEY (`class_id`);

--
-- Indexes for table `tbl_class_schedule`
--
ALTER TABLE `tbl_class_schedule`
  ADD PRIMARY KEY (`class_schedule_id`);

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

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

--
-- Indexes for table `tbl_comprehensives`
--
ALTER TABLE `tbl_comprehensives`
  ADD PRIMARY KEY (`comprehensive_id`);

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

--
-- Indexes for table `tbl_country_codes`
--
ALTER TABLE `tbl_country_codes`
  ADD PRIMARY KEY (`country_code_id`);

--
-- Indexes for table `tbl_courses`
--
ALTER TABLE `tbl_courses`
  ADD PRIMARY KEY (`course_id`);

--
-- Indexes for table `tbl_examinations`
--
ALTER TABLE `tbl_examinations`
  ADD PRIMARY KEY (`examination_id`);

--
-- Indexes for table `tbl_exam_category`
--
ALTER TABLE `tbl_exam_category`
  ADD PRIMARY KEY (`exam_category_id`);

--
-- Indexes for table `tbl_exam_type`
--
ALTER TABLE `tbl_exam_type`
  ADD PRIMARY KEY (`exam_type_id`);

--
-- Indexes for table `tbl_groups`
--
ALTER TABLE `tbl_groups`
  ADD PRIMARY KEY (`group_id`);

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

--
-- Indexes for table `tbl_marks`
--
ALTER TABLE `tbl_marks`
  ADD PRIMARY KEY (`marks_id`);

--
-- Indexes for table `tbl_orders`
--
ALTER TABLE `tbl_orders`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `tbl_packages`
--
ALTER TABLE `tbl_packages`
  ADD PRIMARY KEY (`package_id`);

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

--
-- Indexes for table `tbl_parent_levels`
--
ALTER TABLE `tbl_parent_levels`
  ADD PRIMARY KEY (`parent_level_id`);

--
-- Indexes for table `tbl_questions`
--
ALTER TABLE `tbl_questions`
  ADD PRIMARY KEY (`question_id`);

--
-- Indexes for table `tbl_question_banks`
--
ALTER TABLE `tbl_question_banks`
  ADD PRIMARY KEY (`question_bank_id`);

--
-- Indexes for table `tbl_question_types`
--
ALTER TABLE `tbl_question_types`
  ADD PRIMARY KEY (`question_type_id`);

--
-- Indexes for table `tbl_save_attempt_questions`
--
ALTER TABLE `tbl_save_attempt_questions`
  ADD PRIMARY KEY (`sq_id`);

--
-- Indexes for table `tbl_sheets`
--
ALTER TABLE `tbl_sheets`
  ADD PRIMARY KEY (`sheet_id`);

--
-- Indexes for table `tbl_sheet_types`
--
ALTER TABLE `tbl_sheet_types`
  ADD PRIMARY KEY (`sheet_type_id`);

--
-- Indexes for table `tbl_students_assign_group`
--
ALTER TABLE `tbl_students_assign_group`
  ADD PRIMARY KEY (`sa_id`);

--
-- Indexes for table `tbl_subjects`
--
ALTER TABLE `tbl_subjects`
  ADD PRIMARY KEY (`subject_id`);

--
-- Indexes for table `tbl_tabs`
--
ALTER TABLE `tbl_tabs`
  ADD PRIMARY KEY (`tab_id`);

--
-- Indexes for table `tbl_topics`
--
ALTER TABLE `tbl_topics`
  ADD PRIMARY KEY (`topic_id`);

--
-- AUTO_INCREMENT for table `tbl_answers`
--
ALTER TABLE `tbl_answers`
  MODIFY `answer_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_attempts`
--
ALTER TABLE `tbl_attempts`
  MODIFY `attempt_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_chapters`
--
ALTER TABLE `tbl_chapters`
  MODIFY `chapter_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_classes`
--
ALTER TABLE `tbl_classes`
  MODIFY `class_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_class_schedule`
--
ALTER TABLE `tbl_class_schedule`
  MODIFY `class_schedule_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_cms`
--
ALTER TABLE `tbl_cms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `tbl_compose_sheets`
--
ALTER TABLE `tbl_compose_sheets`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=137;

--
-- AUTO_INCREMENT for table `tbl_comprehensives`
--
ALTER TABLE `tbl_comprehensives`
  MODIFY `comprehensive_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_contents`
--
ALTER TABLE `tbl_contents`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `tbl_country_codes`
--
ALTER TABLE `tbl_country_codes`
  MODIFY `country_code_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_courses`
--
ALTER TABLE `tbl_courses`
  MODIFY `course_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_examinations`
--
ALTER TABLE `tbl_examinations`
  MODIFY `examination_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_exam_category`
--
ALTER TABLE `tbl_exam_category`
  MODIFY `exam_category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_exam_type`
--
ALTER TABLE `tbl_exam_type`
  MODIFY `exam_type_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_groups`
--
ALTER TABLE `tbl_groups`
  MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `tbl_live_class_group`
--
ALTER TABLE `tbl_live_class_group`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_marks`
--
ALTER TABLE `tbl_marks`
  MODIFY `marks_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_orders`
--
ALTER TABLE `tbl_orders`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_packages`
--
ALTER TABLE `tbl_packages`
  MODIFY `package_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_pages`
--
ALTER TABLE `tbl_pages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_parent_levels`
--
ALTER TABLE `tbl_parent_levels`
  MODIFY `parent_level_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_questions`
--
ALTER TABLE `tbl_questions`
  MODIFY `question_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_question_banks`
--
ALTER TABLE `tbl_question_banks`
  MODIFY `question_bank_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_question_types`
--
ALTER TABLE `tbl_question_types`
  MODIFY `question_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `tbl_save_attempt_questions`
--
ALTER TABLE `tbl_save_attempt_questions`
  MODIFY `sq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=188;

--
-- AUTO_INCREMENT for table `tbl_sheets`
--
ALTER TABLE `tbl_sheets`
  MODIFY `sheet_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_sheet_types`
--
ALTER TABLE `tbl_sheet_types`
  MODIFY `sheet_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_students_assign_group`
--
ALTER TABLE `tbl_students_assign_group`
  MODIFY `sa_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `tbl_subjects`
--
ALTER TABLE `tbl_subjects`
  MODIFY `subject_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `tbl_tabs`
--
ALTER TABLE `tbl_tabs`
  MODIFY `tab_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `tbl_topics`
--
ALTER TABLE `tbl_topics`
  MODIFY `topic_id` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

