(13229,2661,299,0,'2021-04-20 04:59:56'),(13230,2661,300,0,'2021-04-20 04:59:56'),(13231,2661,301,0,'2021-04-20 04:59:56'),(13232,2661,302,0,'2021-04-20 04:59:56'),(13233,2661,303,0,'2021-04-20 04:59:57'),(13234,2662,304,0,'2021-04-20 04:59:57'),(13235,2662,305,0,'2021-04-20 04:59:57'),(13236,2662,306,0,'2021-04-20 04:59:57'),(13237,2662,307,0,'2021-04-20 04:59:57'),(13238,2662,308,0,'2021-04-20 04:59:57'),(13239,2663,304,0,'2021-04-20 04:59:57'),(13240,2663,305,0,'2021-04-20 04:59:57'),(13241,2663,306,0,'2021-04-20 04:59:57'),(13242,2663,307,0,'2021-04-20 04:59:57'),(13243,2663,308,0,'2021-04-20 04:59:57'),(13244,2664,304,0,'2021-04-20 04:59:58'),(13245,2664,305,0,'2021-04-20 04:59:58'),(13246,2664,306,0,'2021-04-20 04:59:58'),(13247,2664,307,0,'2021-04-20 04:59:58'),(13248,2664,308,0,'2021-04-20 04:59:58'),(13249,2665,304,0,'2021-04-20 04:59:58'),(13250,2665,305,0,'2021-04-20 04:59:58'),(13251,2665,306,0,'2021-04-20 04:59:58'),(13252,2665,307,0,'2021-04-20 04:59:58'),(13253,2665,308,0,'2021-04-20 04:59:58'),(13254,2666,304,0,'2021-04-20 04:59:58'),(13255,2666,305,0,'2021-04-20 04:59:58'),(13256,2666,306,0,'2021-04-20 04:59:58'),(13257,2666,307,0,'2021-04-20 04:59:58'),(13258,2666,308,0,'2021-04-20 04:59:58'),(13259,2667,304,0,'2021-04-20 04:59:59'),(13260,2667,305,0,'2021-04-20 04:59:59'),(13261,2667,306,0,'2021-04-20 04:59:59'),(13262,2667,307,0,'2021-04-20 04:59:59'),(13263,2667,308,0,'2021-04-20 04:59:59'),(13264,2668,304,0,'2021-04-20 04:59:59'),(13265,2668,305,0,'2021-04-20 04:59:59'),(13266,2668,306,0,'2021-04-20 04:59:59'),(13267,2668,307,0,'2021-04-20 04:59:59'),(13268,2668,308,0,'2021-04-20 04:59:59'),(13269,2669,304,0,'2021-04-20 04:59:59'),(13270,2669,305,0,'2021-04-20 04:59:59'),(13271,2669,306,0,'2021-04-20 04:59:59'),(13272,2669,307,0,'2021-04-20 05:00:00'),(13273,2669,308,0,'2021-04-20 05:00:00'),(13274,2670,304,0,'2021-04-20 05:00:00'),(13275,2670,305,0,'2021-04-20 05:00:00'),(13276,2670,306,0,'2021-04-20 05:00:00'),(13277,2670,307,0,'2021-04-20 05:00:00'),(13278,2670,308,0,'2021-04-20 05:00:00'),(13279,2671,304,0,'2021-04-20 05:00:00'),(13280,2671,305,0,'2021-04-20 05:00:00'),(13281,2671,306,0,'2021-04-20 05:00:00'),(13282,2671,307,0,'2021-04-20 05:00:00'),(13283,2671,308,0,'2021-04-20 05:00:00'),(13284,2672,304,0,'2021-04-20 05:00:01'),(13285,2672,305,0,'2021-04-20 05:00:01'),(13286,2672,306,0,'2021-04-20 05:00:01'),(13287,2672,307,0,'2021-04-20 05:00:01'),(13288,2672,308,0,'2021-04-20 05:00:01'),(13289,2673,304,0,'2021-04-20 05:00:01'),(13290,2673,305,0,'2021-04-20 05:00:01'),(13291,2673,306,0,'2021-04-20 05:00:01'),(13292,2673,307,0,'2021-04-20 05:00:01'),(13293,2673,308,0,'2021-04-20 05:00:01'),(13294,2674,304,0,'2021-04-20 05:00:02'),(13295,2674,305,0,'2021-04-20 05:00:02'),(13296,2674,306,0,'2021-04-20 05:00:02'),(13297,2674,307,0,'2021-04-20 05:00:02'),(13298,2674,308,0,'2021-04-20 05:00:02');

--
-- Table structure for table `sb_student_update_request`
--

CREATE TABLE `sb_student_update_request` (
  `sr_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `sr_student_id` int(11) DEFAULT NULL,
  `sr_parent_id` int(11) DEFAULT NULL,
  `sr_class_id` int(11) DEFAULT NULL,
  `sr_student_address` longtext,
  `sr_parent_address` longtext,
  `sr_document` varchar(255) DEFAULT NULL,
  `sr_addres_prof` int(11) DEFAULT NULL,
  `sr_is_verify` int(11) DEFAULT '0',
  `sr_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sr_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_student_update_request`
--


--
-- Table structure for table `sb_study_material`
--

CREATE TABLE `sb_study_material` (
  `study_id` int(11) NOT NULL AUTO_INCREMENT,
  `study_fk_class_id` int(11) NOT NULL,
  `study_fk_section_id` int(11) NOT NULL,
  `study_fk_subject_id` int(11) NOT NULL,
  `study_fk_sub_subject_id` int(11) NOT NULL,
  `study_fk_syllabus_id` int(11) NOT NULL,
  `study_topic_title` mediumtext NOT NULL,
  `study_topic_comment` mediumtext NOT NULL,
  `study_file_name` varchar(255) NOT NULL,
  `study_fk_status_id` int(2) NOT NULL,
  `study_publish_date` date NOT NULL,
  `study_added_by` int(11) NOT NULL,
  `study_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`study_id`),
  KEY `NewIndex1` (`study_id`),
  KEY `NewIndex2` (`study_fk_class_id`),
  KEY `NewIndex3` (`study_fk_section_id`),
  KEY `NewIndex4` (`study_fk_subject_id`),
  KEY `NewIndex5` (`study_fk_subject_id`),
  KEY `NewIndex6` (`study_fk_status_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_study_material`
--

INSERT INTO `sb_study_material` VALUES (1,1,1,1,0,1,'Practice the attached material','','',1,'2021-04-15',164,'2021-04-15 05:58:56');

--
-- Table structure for table `sb_study_material_files`
--

CREATE TABLE `sb_study_material_files` (
  `material_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `material_fk_study_id` int(11) NOT NULL,
  `material_filename` varchar(255) NOT NULL,
  `material_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`material_pk_id`),
  KEY `NewIndex1` (`material_pk_id`),
  KEY `NewIndex2` (`material_fk_study_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_study_material_files`
--

INSERT INTO `sb_study_material_files` VALUES (1,1,'Book1xlsx15042021112856_0.xlsx','2021-04-15 05:58:56');

--
-- Table structure for table `sb_subject`
--

CREATE TABLE `sb_subject` (
  `subject_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(255) NOT NULL,
  `subject_code` varchar(255) DEFAULT NULL,
  `subject_fk_subject_id` int(11) DEFAULT NULL,
  `subject_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`subject_pk_id`),
  KEY `NewIndex1` (`subject_pk_id`),
  KEY `NewIndex2` (`subject_name`),
  KEY `NewIndex3` (`subject_code`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subject`
--

INSERT INTO `sb_subject` VALUES (1,'English 05','English 05',NULL,'2021-04-15 05:42:39'),(2,'ENGLISH 01','engl0nu',NULL,'2021-04-20 04:31:10'),(3,'MATHS 01','math0nu',NULL,'2021-04-20 04:31:10'),(4,'ENGLISH 02','engl0ii',NULL,'2021-04-20 04:33:31'),(5,'ODIA 02','odia0ii',NULL,'2021-04-20 04:33:31'),(6,'MATHS 02','math0ii',NULL,'2021-04-20 04:33:31'),(7,'EVS 02','evs0ii',NULL,'2021-04-20 04:33:31'),(8,'COMPUTER02','comp0ii',NULL,'2021-04-20 04:33:31'),(9,'ENGLISH 03','engl0ii',NULL,'2021-04-20 04:40:03'),(10,'ODIA 03','odia0ii',NULL,'2021-04-20 04:40:03'),(11,'MATHS 03','math0ii',NULL,'2021-04-20 04:40:03'),(12,'SCIENCE 03','scie0ii',NULL,'2021-04-20 04:40:03'),(13,'SOCIAL SCIENCE 03','soci0ii',NULL,'2021-04-20 04:40:03'),(14,'COMPUTER03','comp0ii',NULL,'2021-04-20 04:40:03'),(15,'ENGLISH 04','engl0iv',NULL,'2021-04-20 04:41:36'),(16,'HIGHER HINDI 04','high0iv',NULL,'2021-04-20 04:41:36'),(17,'LOWER ODIA 04','lowe0iv',NULL,'2021-04-20 04:41:36'),(18,'MATHEMATICS 04','math0iv',NULL,'2021-04-20 04:41:36'),(19,'SCIENCE 04','scie0iv',NULL,'2021-04-20 04:41:36'),(20,'SOCIAL SCIENCE 04','soci0iv',NULL,'2021-04-20 04:41:36'),(21,'COMPUTER04','comp0iv',NULL,'2021-04-20 04:41:36'),(22,'MATHEMATICS 05','math00v',NULL,'2021-04-20 04:43:27'),(23,'SCIENCE 05','scie00v',NULL,'2021-04-20 04:43:27'),(24,'SOCIAL SCIENCE 05','soci00v',NULL,'2021-04-20 04:43:27'),(25,'COMPUTER05','comp00v',NULL,'2021-04-20 04:43:27'),(26,'ENGLISH 06','engl0vi',NULL,'2021-04-20 04:45:00'),(27,'HIGHER ODIA 06','high0vi',NULL,'2021-04-20 04:45:01'),(28,'LOWER HINDI 06','lowe0vi',NULL,'2021-04-20 04:45:01'),(29,'MATHEMATICS06','math0vi',NULL,'2021-04-20 04:45:01'),(30,'SCIENCE 06','scie0vi',NULL,'2021-04-20 04:45:01'),(31,'SOCIAL SCIENCE 06','soci0vi',NULL,'2021-04-20 04:45:01'),(32,'COMPUTER 06','comp0vi',NULL,'2021-04-20 04:45:01');

--
-- Table structure for table `sb_subject_assignment`
--

CREATE TABLE `sb_subject_assignment` (
  `sa_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `sa_fk_subject_id` int(11) NOT NULL,
  `sa_fk_class_id` int(11) NOT NULL,
  `sa_fk_section_id` int(11) NOT NULL,
  `sa_parent_option_subject_id` int(11) NOT NULL COMMENT 'self primary key id as foreign key',
  `sa_optional_flag` varchar(5) NOT NULL DEFAULT 'c',
  `sa_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sa_pk_id`),
  KEY `NewIndex1` (`sa_pk_id`),
  KEY `NewIndex2` (`sa_fk_subject_id`),
  KEY `NewIndex3` (`sa_fk_class_id`),
  KEY `NewIndex4` (`sa_fk_section_id`),
  KEY `NewIndex5` (`sa_parent_option_subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=194 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subject_assignment`
--

INSERT INTO `sb_subject_assignment` VALUES (1,1,1,1,0,'c','2021-04-15 05:43:17'),(2,2,2,2,0,'c','2021-04-20 04:31:10'),(3,3,2,2,0,'c','2021-04-20 04:31:10'),(4,2,3,3,0,'c','2021-04-20 04:31:14'),(5,3,3,3,0,'c','2021-04-20 04:31:14'),(6,2,3,4,0,'c','2021-04-20 04:31:16'),(7,3,3,4,0,'c','2021-04-20 04:31:16'),(8,2,4,5,0,'c','2021-04-20 04:31:22'),(9,3,4,5,0,'c','2021-04-20 04:31:22'),(10,2,4,6,0,'c','2021-04-20 04:31:24'),(11,3,4,6,0,'c','2021-04-20 04:31:24'),(12,2,3,7,0,'c','2021-04-20 04:31:25'),(13,3,3,7,0,'c','2021-04-20 04:31:25'),(14,2,4,8,0,'c','2021-04-20 04:31:40'),(15,3,4,8,0,'c','2021-04-20 04:31:40'),(16,2,4,9,0,'c','2021-04-20 04:32:10'),(17,3,4,9,0,'c','2021-04-20 04:32:10'),(18,2,5,10,0,'c','2021-04-20 04:32:32'),(19,3,5,10,0,'c','2021-04-20 04:32:32'),(20,2,5,11,0,'c','2021-04-20 04:32:50'),(21,3,5,11,0,'c','2021-04-20 04:32:51'),(22,2,5,12,0,'c','2021-04-20 04:33:09'),(23,3,5,12,0,'c','2021-04-20 04:33:09'),(24,2,5,13,0,'c','2021-04-20 04:33:21'),(25,3,5,13,0,'c','2021-04-20 04:33:21'),(26,4,6,14,0,'c','2021-04-20 04:33:31'),(27,5,6,14,0,'c','2021-04-20 04:33:31'),(28,6,6,14,0,'c','2021-04-20 04:33:31'),(29,7,6,14,0,'c','2021-04-20 04:33:31'),(30,8,6,14,0,'c','2021-04-20 04:33:31'),(31,4,6,15,0,'c','2021-04-20 04:33:49'),(32,5,6,15,0,'c','2021-04-20 04:33:49'),(33,6,6,15,0,'c','2021-04-20 04:33:49'),(34,7,6,15,0,'c','2021-04-20 04:33:49'),(35,8,6,15,0,'c','2021-04-20 04:33:49'),(36,4,6,16,0,'c','2021-04-20 04:34:08'),(37,5,6,16,0,'c','2021-04-20 04:34:08'),(38,6,6,16,0,'c','2021-04-20 04:34:08'),(39,7,6,16,0,'c','2021-04-20 04:34:08'),(40,8,6,16,0,'c','2021-04-20 04:34:08'),(41,4,6,17,0,'c','2021-04-20 04:34:27'),(42,5,6,17,0,'c','2021-04-20 04:34:27'),(43,6,6,17,0,'c','2021-04-20 04:34:27'),(44,7,6,17,0,'c','2021-04-20 04:34:27'),(45,8,6,17,0,'c','2021-04-20 04:34:27'),(46,4,6,18,0,'c','2021-04-20 04:34:40'),(47,5,6,18,0,'c','2021-04-20 04:34:40'),(48,6,6,18,0,'c','2021-04-20 04:34:40'),(49,7,6,18,0,'c','2021-04-20 04:34:41'),(50,8,6,18,0,'c','2021-04-20 04:34:41'),(51,4,6,19,0,'c','2021-04-20 04:34:52'),(52,5,6,19,0,'c','2021-04-20 04:34:52'),(53,6,6,19,0,'c','2021-04-20 04:34:52'),(54,7,6,19,0,'c','2021-04-20 04:34:53'),(55,8,6,19,0,'c','2021-04-20 04:34:53'),(56,9,7,20,0,'c','2021-04-20 04:40:03'),(57,10,7,20,0,'c','2021-04-20 04:40:03'),(58,11,7,20,0,'c','2021-04-20 04:40:03'),(59,12,7,20,0,'c','2021-04-20 04:40:03'),(60,13,7,20,0,'c','2021-04-20 04:40:03'),(61,14,7,20,0,'c','2021-04-20 04:40:04'),(62,9,7,21,0,'c','2021-04-20 04:40:23'),(63,10,7,21,0,'c','2021-04-20 04:40:24'),(64,11,7,21,0,'c','2021-04-20 04:40:24'),(65,12,7,21,0,'c','2021-04-20 04:40:24'),(66,13,7,21,0,'c','2021-04-20 04:40:24'),(67,14,7,21,0,'c','2021-04-20 04:40:24'),(68,9,7,22,0,'c','2021-04-20 04:40:50'),(69,10,7,22,0,'c','2021-04-20 04:40:50'),(70,11,7,22,0,'c','2021-04-20 04:40:50'),(71,12,7,22,0,'c','2021-04-20 04:40:50'),(72,13,7,22,0,'c','2021-04-20 04:40:50'),(73,14,7,22,0,'c','2021-04-20 04:40:50'),(74,9,7,23,0,'c','2021-04-20 04:41:10'),(75,10,7,23,0,'c','2021-04-20 04:41:10'),(76,11,7,23,0,'c','2021-04-20 04:41:10'),(77,12,7,23,0,'c','2021-04-20 04:41:11'),(78,13,7,23,0,'c','2021-04-20 04:41:11'),(79,14,7,23,0,'c','2021-04-20 04:41:11'),(80,9,7,24,0,'c','2021-04-20 04:41:12'),(81,10,7,24,0,'c','2021-04-20 04:41:12'),(82,11,7,24,0,'c','2021-04-20 04:41:12'),(83,12,7,24,0,'c','2021-04-20 04:41:12'),(84,13,7,24,0,'c','2021-04-20 04:41:12'),(85,14,7,24,0,'c','2021-04-20 04:41:12'),(86,9,7,25,0,'c','2021-04-20 04:41:23'),(87,10,7,25,0,'c','2021-04-20 04:41:23'),(88,11,7,25,0,'c','2021-04-20 04:41:23'),(89,12,7,25,0,'c','2021-04-20 04:41:23'),(90,13,7,25,0,'c','2021-04-20 04:41:23'),(91,14,7,25,0,'c','2021-04-20 04:41:23'),(92,15,8,26,0,'c','2021-04-20 04:41:36'),(93,16,8,26,0,'c','2021-04-20 04:41:36'),(94,17,8,26,0,'c','2021-04-20 04:41:36'),(95,18,8,26,0,'c','2021-04-20 04:41:36'),(96,19,8,26,0,'c','2021-04-20 04:41:36'),(97,20,8,26,0,'c','2021-04-20 04:41:36'),(98,21,8,26,0,'c','2021-04-20 04:41:36'),(99,15,8,27,0,'c','2021-04-20 04:41:37'),(100,16,8,27,0,'c','2021-04-20 04:41:37'),(101,17,8,27,0,'c','2021-04-20 04:41:37'),(102,18,8,27,0,'c','2021-04-20 04:41:37'),(103,19,8,27,0,'c','2021-04-20 04:41:37'),(104,20,8,27,0,'c','2021-04-20 04:41:37'),(105,21,8,27,0,'c','2021-04-20 04:41:38'),(106,15,8,28,0,'c','2021-04-20 04:42:00'),(107,16,8,28,0,'c','2021-04-20 04:42:00'),(108,17,8,28,0,'c','2021-04-20 04:42:00'),(109,18,8,28,0,'c','2021-04-20 04:42:00'),(110,19,8,28,0,'c','2021-04-20 04:42:00'),(111,20,8,28,0,'c','2021-04-20 04:42:00'),(112,21,8,28,0,'c','2021-04-20 04:42:01'),(113,15,8,29,0,'c','2021-04-20 04:42:45'),(114,16,8,29,0,'c','2021-04-20 04:42:46'),(115,17,8,29,0,'c','2021-04-20 04:42:46'),(116,18,8,29,0,'c','2021-04-20 04:42:46'),(117,19,8,29,0,'c','2021-04-20 04:42:46'),(118,20,8,29,0,'c','2021-04-20 04:42:46'),(119,21,8,29,0,'c','2021-04-20 04:42:46'),(120,15,8,30,0,'c','2021-04-20 04:43:09'),(121,16,8,30,0,'c','2021-04-20 04:43:09'),(122,17,8,30,0,'c','2021-04-20 04:43:09'),(123,18,8,30,0,'c','2021-04-20 04:43:09'),(124,19,8,30,0,'c','2021-04-20 04:43:09'),(125,20,8,30,0,'c','2021-04-20 04:43:09'),(126,21,8,30,0,'c','2021-04-20 04:43:09'),(127,1,9,31,0,'c','2021-04-20 04:43:27'),(128,22,9,31,0,'c','2021-04-20 04:43:27'),(129,23,9,31,0,'c','2021-04-20 04:43:27'),(130,24,9,31,0,'c','2021-04-20 04:43:27'),(131,25,9,31,0,'c','2021-04-20 04:43:27'),(132,1,9,32,0,'c','2021-04-20 04:43:48'),(133,22,9,32,0,'c','2021-04-20 04:43:48'),(134,23,9,32,0,'c','2021-04-20 04:43:48'),(135,24,9,32,0,'c','2021-04-20 04:43:48'),(136,25,9,32,0,'c','2021-04-20 04:43:48'),(137,1,9,33,0,'c','2021-04-20 04:44:07'),(138,22,9,33,0,'c','2021-04-20 04:44:07'),(139,23,9,33,0,'c','2021-04-20 04:44:07'),(140,24,9,33,0,'c','2021-04-20 04:44:07'),(141,25,9,33,0,'c','2021-04-20 04:44:07'),(142,1,9,34,0,'c','2021-04-20 04:44:27'),(143,22,9,34,0,'c','2021-04-20 04:44:27'),(144,23,9,34,0,'c','2021-04-20 04:44:27'),(145,24,9,34,0,'c','2021-04-20 04:44:27'),(146,25,9,34,0,'c','2021-04-20 04:44:27'),(147,1,9,35,0,'c','2021-04-20 04:44:46'),(148,22,9,35,0,'c','2021-04-20 04:44:46'),(149,23,9,35,0,'c','2021-04-20 04:44:46'),(150,24,9,35,0,'c','2021-04-20 04:44:46'),(151,25,9,35,0,'c','2021-04-20 04:44:46'),(152,26,10,36,0,'c','2021-04-20 04:45:00'),(153,27,10,36,0,'c','2021-04-20 04:45:01'),(154,28,10,36,0,'c','2021-04-20 04:45:01'),(155,29,10,36,0,'c','2021-04-20 04:45:01'),(156,30,10,36,0,'c','2021-04-20 04:45:01'),(157,31,10,36,0,'c','2021-04-20 04:45:01'),(158,32,10,36,0,'c','2021-04-20 04:45:01'),(159,26,10,37,0,'c','2021-04-20 04:45:25'),(160,27,10,37,0,'c','2021-04-20 04:45:25'),(161,28,10,37,0,'c','2021-04-20 04:45:26'),(162,29,10,37,0,'c','2021-04-20 04:45:26'),(163,30,10,37,0,'c','2021-04-20 04:45:26'),(164,31,10,37,0,'c','2021-04-20 04:45:26'),(165,32,10,37,0,'c','2021-04-20 04:45:26'),(166,26,10,38,0,'c','2021-04-20 04:45:48'),(167,27,10,38,0,'c','2021-04-20 04:45:48'),(168,28,10,38,0,'c','2021-04-20 04:45:48'),(169,29,10,38,0,'c','2021-04-20 04:45:48'),(170,30,10,38,0,'c','2021-04-20 04:45:48'),(171,31,10,38,0,'c','2021-04-20 04:45:48'),(172,32,10,38,0,'c','2021-04-20 04:45:48'),(173,26,10,39,0,'c','2021-04-20 04:46:11'),(174,27,10,39,0,'c','2021-04-20 04:46:11'),(175,28,10,39,0,'c','2021-04-20 04:46:11'),(176,29,10,39,0,'c','2021-04-20 04:46:11'),(177,30,10,39,0,'c','2021-04-20 04:46:11'),(178,31,10,39,0,'c','2021-04-20 04:46:11'),(179,32,10,39,0,'c','2021-04-20 04:46:12'),(180,26,10,40,0,'c','2021-04-20 04:46:34'),(181,27,10,40,0,'c','2021-04-20 04:46:34'),(182,28,10,40,0,'c','2021-04-20 04:46:34'),(183,29,10,40,0,'c','2021-04-20 04:46:34'),(184,30,10,40,0,'c','2021-04-20 04:46:35'),(185,31,10,40,0,'c','2021-04-20 04:46:35'),(186,32,10,40,0,'c','2021-04-20 04:46:35'),(187,26,10,41,0,'c','2021-04-20 04:46:49'),(188,27,10,41,0,'c','2021-04-20 04:46:49'),(189,28,10,41,0,'c','2021-04-20 04:46:49'),(190,29,10,41,0,'c','2021-04-20 04:46:49'),(191,30,10,41,0,'c','2021-04-20 04:46:49'),(192,31,10,41,0,'c','2021-04-20 04:46:49'),(193,32,10,41,0,'c','2021-04-20 04:46:49');

--
-- Table structure for table `sb_subject_assignment_clone`
--

CREATE TABLE `sb_subject_assignment_clone` (
  `sa_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `sa_fk_subject_id` int(11) NOT NULL,
  `sa_fk_class_id` int(11) NOT NULL,
  `sa_fk_section_id` int(11) NOT NULL,
  `sa_parent_option_subject_id` int(11) NOT NULL COMMENT 'self primary key id as foreign key',
  `sa_optional_flag` varchar(5) NOT NULL DEFAULT 'c',
  `sa_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sa_pk_id`),
  KEY `NewIndex1` (`sa_pk_id`),
  KEY `NewIndex2` (`sa_fk_subject_id`),
  KEY `NewIndex3` (`sa_fk_class_id`),
  KEY `NewIndex4` (`sa_fk_section_id`),
  KEY `NewIndex5` (`sa_parent_option_subject_id`)
) ENGINE=InnoDB AUTO_INCREMENT=309 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subject_assignment_clone`
--

INSERT INTO `sb_subject_assignment_clone` VALUES (1,1,1,1,0,'c','2021-04-15 05:43:17'),(2,2,2,2,0,'c','2021-04-20 04:31:10'),(3,3,2,2,0,'c','2021-04-20 04:31:10'),(4,2,3,3,0,'c','2021-04-20 04:31:14'),(5,3,3,3,0,'c','2021-04-20 04:31:14'),(6,2,3,4,0,'c','2021-04-20 04:31:16'),(7,3,3,4,0,'c','2021-04-20 04:31:16'),(8,2,4,5,0,'c','2021-04-20 04:31:22'),(9,3,4,5,0,'c','2021-04-20 04:31:22'),(10,2,4,6,0,'c','2021-04-20 04:31:24'),(11,3,4,6,0,'c','2021-04-20 04:31:24'),(12,2,3,7,0,'c','2021-04-20 04:31:25'),(13,3,3,7,0,'c','2021-04-20 04:31:25'),(14,2,4,8,0,'c','2021-04-20 04:31:40'),(15,3,4,8,0,'c','2021-04-20 04:31:40'),(16,2,4,9,0,'c','2021-04-20 04:32:10'),(17,3,4,9,0,'c','2021-04-20 04:32:10'),(18,2,5,10,0,'c','2021-04-20 04:32:32'),(19,3,5,10,0,'c','2021-04-20 04:32:32'),(20,2,5,11,0,'c','2021-04-20 04:32:50'),(21,3,5,11,0,'c','2021-04-20 04:32:51'),(22,2,5,12,0,'c','2021-04-20 04:33:09'),(23,3,5,12,0,'c','2021-04-20 04:33:09'),(24,2,5,13,0,'c','2021-04-20 04:33:21'),(25,3,5,13,0,'c','2021-04-20 04:33:21'),(26,4,6,14,0,'c','2021-04-20 04:33:31'),(27,5,6,14,0,'c','2021-04-20 04:33:31'),(28,6,6,14,0,'c','2021-04-20 04:33:31'),(29,7,6,14,0,'c','2021-04-20 04:33:31'),(30,8,6,14,0,'c','2021-04-20 04:33:31'),(31,4,6,15,0,'c','2021-04-20 04:33:49'),(32,5,6,15,0,'c','2021-04-20 04:33:49'),(33,6,6,15,0,'c','2021-04-20 04:33:49'),(34,7,6,15,0,'c','2021-04-20 04:33:49'),(35,8,6,15,0,'c','2021-04-20 04:33:49'),(36,4,6,16,0,'c','2021-04-20 04:34:08'),(37,5,6,16,0,'c','2021-04-20 04:34:08'),(38,6,6,16,0,'c','2021-04-20 04:34:08'),(39,7,6,16,0,'c','2021-04-20 04:34:08'),(40,8,6,16,0,'c','2021-04-20 04:34:08'),(41,4,6,17,0,'c','2021-04-20 04:34:27'),(42,5,6,17,0,'c','2021-04-20 04:34:27'),(43,6,6,17,0,'c','2021-04-20 04:34:27'),(44,7,6,17,0,'c','2021-04-20 04:34:27'),(45,8,6,17,0,'c','2021-04-20 04:34:27'),(46,4,6,18,0,'c','2021-04-20 04:34:40'),(47,5,6,18,0,'c','2021-04-20 04:34:40'),(48,6,6,18,0,'c','2021-04-20 04:34:40'),(49,7,6,18,0,'c','2021-04-20 04:34:41'),(50,8,6,18,0,'c','2021-04-20 04:34:41'),(51,4,6,19,0,'c','2021-04-20 04:34:52'),(52,5,6,19,0,'c','2021-04-20 04:34:52'),(53,6,6,19,0,'c','2021-04-20 04:34:52'),(54,7,6,19,0,'c','2021-04-20 04:34:53'),(55,8,6,19,0,'c','2021-04-20 04:34:53'),(56,9,7,20,0,'c','2021-04-20 04:40:03'),(57,10,7,20,0,'c','2021-04-20 04:40:03'),(58,11,7,20,0,'c','2021-04-20 04:40:03'),(59,12,7,20,0,'c','2021-04-20 04:40:03'),(60,13,7,20,0,'c','2021-04-20 04:40:03'),(61,14,7,20,0,'c','2021-04-20 04:40:04'),(62,9,7,21,0,'c','2021-04-20 04:40:23'),(63,10,7,21,0,'c','2021-04-20 04:40:24'),(64,11,7,21,0,'c','2021-04-20 04:40:24'),(65,12,7,21,0,'c','2021-04-20 04:40:24'),(66,13,7,21,0,'c','2021-04-20 04:40:24'),(67,14,7,21,0,'c','2021-04-20 04:40:24'),(68,9,7,22,0,'c','2021-04-20 04:40:50'),(69,10,7,22,0,'c','2021-04-20 04:40:50'),(70,11,7,22,0,'c','2021-04-20 04:40:50'),(71,12,7,22,0,'c','2021-04-20 04:40:50'),(72,13,7,22,0,'c','2021-04-20 04:40:50'),(73,14,7,22,0,'c','2021-04-20 04:40:50'),(74,9,7,23,0,'c','2021-04-20 04:41:10'),(75,10,7,23,0,'c','2021-04-20 04:41:10'),(76,11,7,23,0,'c','2021-04-20 04:41:10'),(77,12,7,23,0,'c','2021-04-20 04:41:11'),(78,13,7,23,0,'c','2021-04-20 04:41:11'),(79,14,7,23,0,'c','2021-04-20 04:41:11'),(80,9,7,24,0,'c','2021-04-20 04:41:12'),(81,10,7,24,0,'c','2021-04-20 04:41:12'),(82,11,7,24,0,'c','2021-04-20 04:41:12'),(83,12,7,24,0,'c','2021-04-20 04:41:12'),(84,13,7,24,0,'c','2021-04-20 04:41:12'),(85,14,7,24,0,'c','2021-04-20 04:41:12'),(86,9,7,25,0,'c','2021-04-20 04:41:23'),(87,10,7,25,0,'c','2021-04-20 04:41:23'),(88,11,7,25,0,'c','2021-04-20 04:41:23'),(89,12,7,25,0,'c','2021-04-20 04:41:23'),(90,13,7,25,0,'c','2021-04-20 04:41:23'),(91,14,7,25,0,'c','2021-04-20 04:41:23'),(92,15,8,26,0,'c','2021-04-20 04:41:36'),(93,16,8,26,0,'c','2021-04-20 04:41:36'),(94,17,8,26,0,'c','2021-04-20 04:41:36'),(95,18,8,26,0,'c','2021-04-20 04:41:36'),(96,19,8,26,0,'c','2021-04-20 04:41:36'),(97,20,8,26,0,'c','2021-04-20 04:41:36'),(98,21,8,26,0,'c','2021-04-20 04:41:36'),(99,15,8,27,0,'c','2021-04-20 04:41:37'),(100,16,8,27,0,'c','2021-04-20 04:41:37'),(101,17,8,27,0,'c','2021-04-20 04:41:37'),(102,18,8,27,0,'c','2021-04-20 04:41:37'),(103,19,8,27,0,'c','2021-04-20 04:41:37'),(104,20,8,27,0,'c','2021-04-20 04:41:37'),(105,21,8,27,0,'c','2021-04-20 04:41:38'),(106,15,8,28,0,'c','2021-04-20 04:42:00'),(107,16,8,28,0,'c','2021-04-20 04:42:00'),(108,17,8,28,0,'c','2021-04-20 04:42:00'),(109,18,8,28,0,'c','2021-04-20 04:42:00'),(110,19,8,28,0,'c','2021-04-20 04:42:00'),(111,20,8,28,0,'c','2021-04-20 04:42:00'),(112,21,8,28,0,'c','2021-04-20 04:42:01'),(113,15,8,29,0,'c','2021-04-20 04:42:45'),(114,16,8,29,0,'c','2021-04-20 04:42:46'),(115,17,8,29,0,'c','2021-04-20 04:42:46'),(116,18,8,29,0,'c','2021-04-20 04:42:46'),(117,19,8,29,0,'c','2021-04-20 04:42:46'),(118,20,8,29,0,'c','2021-04-20 04:42:46'),(119,21,8,29,0,'c','2021-04-20 04:42:46'),(120,15,8,30,0,'c','2021-04-20 04:43:09'),(121,16,8,30,0,'c','2021-04-20 04:43:09'),(122,17,8,30,0,'c','2021-04-20 04:43:09'),(123,18,8,30,0,'c','2021-04-20 04:43:09'),(124,19,8,30,0,'c','2021-04-20 04:43:09'),(125,20,8,30,0,'c','2021-04-20 04:43:09'),(126,21,8,30,0,'c','2021-04-20 04:43:09'),(127,1,9,31,0,'c','2021-04-20 04:43:27'),(128,22,9,31,0,'c','2021-04-20 04:43:27'),(129,23,9,31,0,'c','2021-04-20 04:43:27'),(130,24,9,31,0,'c','2021-04-20 04:43:27'),(131,25,9,31,0,'c','2021-04-20 04:43:27'),(132,1,9,32,0,'c','2021-04-20 04:43:48'),(133,22,9,32,0,'c','2021-04-20 04:43:48'),(134,23,9,32,0,'c','2021-04-20 04:43:48'),(135,24,9,32,0,'c','2021-04-20 04:43:48'),(136,25,9,32,0,'c','2021-04-20 04:43:48'),(137,1,9,33,0,'c','2021-04-20 04:44:07'),(138,22,9,33,0,'c','2021-04-20 04:44:07'),(139,23,9,33,0,'c','2021-04-20 04:44:07'),(140,24,9,33,0,'c','2021-04-20 04:44:07'),(141,25,9,33,0,'c','2021-04-20 04:44:07'),(142,1,9,34,0,'c','2021-04-20 04:44:27'),(143,22,9,34,0,'c','2021-04-20 04:44:27'),(144,23,9,34,0,'c','2021-04-20 04:44:27'),(145,24,9,34,0,'c','2021-04-20 04:44:27'),(146,25,9,34,0,'c','2021-04-20 04:44:27'),(147,1,9,35,0,'c','2021-04-20 04:44:46'),(148,22,9,35,0,'c','2021-04-20 04:44:46'),(149,23,9,35,0,'c','2021-04-20 04:44:46'),(150,24,9,35,0,'c','2021-04-20 04:44:46'),(151,25,9,35,0,'c','2021-04-20 04:44:46'),(152,26,10,36,0,'c','2021-04-20 04:45:00'),(153,27,10,36,0,'c','2021-04-20 04:45:01'),(154,28,10,36,0,'c','2021-04-20 04:45:01'),(155,29,10,36,0,'c','2021-04-20 04:45:01'),(156,30,10,36,0,'c','2021-04-20 04:45:01'),(157,31,10,36,0,'c','2021-04-20 04:45:01'),(158,32,10,36,0,'c','2021-04-20 04:45:01'),(159,26,10,37,0,'c','2021-04-20 04:45:25'),(160,27,10,37,0,'c','2021-04-20 04:45:25'),(161,28,10,37,0,'c','2021-04-20 04:45:26'),(162,29,10,37,0,'c','2021-04-20 04:45:26'),(163,30,10,37,0,'c','2021-04-20 04:45:26'),(164,31,10,37,0,'c','2021-04-20 04:45:26'),(165,32,10,37,0,'c','2021-04-20 04:45:26'),(166,26,10,38,0,'c','2021-04-20 04:45:48'),(167,27,10,38,0,'c','2021-04-20 04:45:48'),(168,28,10,38,0,'c','2021-04-20 04:45:48'),(169,29,10,38,0,'c','2021-04-20 04:45:48'),(170,30,10,38,0,'c','2021-04-20 04:45:48'),(171,31,10,38,0,'c','2021-04-20 04:45:48'),(172,32,10,38,0,'c','2021-04-20 04:45:48'),(173,26,10,39,0,'c','2021-04-20 04:46:11'),(174,27,10,39,0,'c','2021-04-20 04:46:11'),(175,28,10,39,0,'c','2021-04-20 04:46:11'),(176,29,10,39,0,'c','2021-04-20 04:46:11'),(177,30,10,39,0,'c','2021-04-20 04:46:11'),(178,31,10,39,0,'c','2021-04-20 04:46:11'),(179,32,10,39,0,'c','2021-04-20 04:46:12'),(180,26,10,40,0,'c','2021-04-20 04:46:34'),(181,27,10,40,0,'c','2021-04-20 04:46:34'),(182,28,10,40,0,'c','2021-04-20 04:46:34'),(183,29,10,40,0,'c','2021-04-20 04:46:34'),(184,30,10,40,0,'c','2021-04-20 04:46:35'),(185,31,10,40,0,'c','2021-04-20 04:46:35'),(186,32,10,40,0,'c','2021-04-20 04:46:35'),(187,26,10,41,0,'c','2021-04-20 04:46:49'),(188,27,10,41,0,'c','2021-04-20 04:46:49'),(189,28,10,41,0,'c','2021-04-20 04:46:49'),(190,29,10,41,0,'c','2021-04-20 04:46:49'),(191,30,10,41,0,'c','2021-04-20 04:46:49'),(192,31,10,41,0,'c','2021-04-20 04:46:49'),(193,32,10,41,0,'c','2021-04-20 04:46:49'),(194,33,11,42,0,'c','2021-04-20 04:53:55'),(195,34,11,42,0,'c','2021-04-20 04:53:55'),(196,35,11,42,0,'c','2021-04-20 04:53:55'),(197,36,11,42,0,'c','2021-04-20 04:53:55'),(198,37,11,42,0,'c','2021-04-20 04:53:55'),(199,33,11,43,0,'c','2021-04-20 04:54:14'),(200,34,11,43,0,'c','2021-04-20 04:54:14'),(201,35,11,43,0,'c','2021-04-20 04:54:14'),(202,36,11,43,0,'c','2021-04-20 04:54:14'),(203,37,11,43,0,'c','2021-04-20 04:54:14'),(204,33,11,44,0,'c','2021-04-20 04:54:38'),(205,34,11,44,0,'c','2021-04-20 04:54:38'),(206,35,11,44,0,'c','2021-04-20 04:54:38'),(207,36,11,44,0,'c','2021-04-20 04:54:38'),(208,37,11,44,0,'c','2021-04-20 04:54:38'),(209,33,11,45,0,'c','2021-04-20 04:54:59'),(210,34,11,45,0,'c','2021-04-20 04:54:59'),(211,35,11,45,0,'c','2021-04-20 04:54:59'),(212,36,11,45,0,'c','2021-04-20 04:54:59'),(213,37,11,45,0,'c','2021-04-20 04:54:59'),(214,33,11,46,0,'c','2021-04-20 04:55:19'),(215,34,11,46,0,'c','2021-04-20 04:55:19'),(216,35,11,46,0,'c','2021-04-20 04:55:19'),(217,36,11,46,0,'c','2021-04-20 04:55:19'),(218,37,11,46,0,'c','2021-04-20 04:55:19'),(219,33,11,47,0,'c','2021-04-20 04:55:33'),(220,34,11,47,0,'c','2021-04-20 04:55:33'),(221,35,11,47,0,'c','2021-04-20 04:55:33'),(222,36,11,47,0,'c','2021-04-20 04:55:33'),(223,37,11,47,0,'c','2021-04-20 04:55:33'),(224,38,12,48,0,'c','2021-04-20 04:55:41'),(225,39,12,48,0,'c','2021-04-20 04:55:41'),(226,40,12,48,0,'c','2021-04-20 04:55:41'),(227,41,12,48,0,'c','2021-04-20 04:55:41'),(228,42,12,48,0,'c','2021-04-20 04:55:41'),(229,38,12,49,0,'c','2021-04-20 04:56:01'),(230,39,12,49,0,'c','2021-04-20 04:56:01'),(231,40,12,49,0,'c','2021-04-20 04:56:01'),(232,41,12,49,0,'c','2021-04-20 04:56:01'),(233,42,12,49,0,'c','2021-04-20 04:56:01'),(234,38,12,50,0,'c','2021-04-20 04:56:20'),(235,39,12,50,0,'c','2021-04-20 04:56:20'),(236,40,12,50,0,'c','2021-04-20 04:56:20'),(237,41,12,50,0,'c','2021-04-20 04:56:20'),(238,42,12,50,0,'c','2021-04-20 04:56:20'),(239,38,12,51,0,'c','2021-04-20 04:56:40'),(240,39,12,51,0,'c','2021-04-20 04:56:40'),(241,40,12,51,0,'c','2021-04-20 04:56:40'),(242,41,12,51,0,'c','2021-04-20 04:56:41'),(243,42,12,51,0,'c','2021-04-20 04:56:41'),(244,38,12,52,0,'c','2021-04-20 04:56:53'),(245,39,12,52,0,'c','2021-04-20 04:56:53'),(246,40,12,52,0,'c','2021-04-20 04:56:53'),(247,41,12,52,0,'c','2021-04-20 04:56:53'),(248,42,12,52,0,'c','2021-04-20 04:56:53'),(249,43,13,53,0,'c','2021-04-20 04:57:04'),(250,44,13,53,0,'c','2021-04-20 04:57:05'),(251,45,13,53,0,'c','2021-04-20 04:57:05'),(252,46,13,53,0,'c','2021-04-20 04:57:05'),(253,47,13,53,0,'c','2021-04-20 04:57:05'),(254,48,13,53,0,'c','2021-04-20 04:57:05'),(255,49,13,53,0,'c','2021-04-20 04:57:05'),(256,43,13,54,0,'c','2021-04-20 04:57:29'),(257,44,13,54,0,'c','2021-04-20 04:57:29'),(258,45,13,54,0,'c','2021-04-20 04:57:29'),(259,46,13,54,0,'c','2021-04-20 04:57:29'),(260,47,13,54,0,'c','2021-04-20 04:57:29'),(261,48,13,54,0,'c','2021-04-20 04:57:29'),(262,49,13,54,0,'c','2021-04-20 04:57:29'),(263,43,13,55,0,'c','2021-04-20 04:57:53'),(264,44,13,55,0,'c','2021-04-20 04:57:53'),(265,45,13,55,0,'c','2021-04-20 04:57:53'),(266,46,13,55,0,'c','2021-04-20 04:57:53'),(267,47,13,55,0,'c','2021-04-20 04:57:53'),(268,48,13,55,0,'c','2021-04-20 04:57:53'),(269,49,13,55,0,'c','2021-04-20 04:57:54'),(270,43,13,56,0,'c','2021-04-20 04:58:17'),(271,44,13,56,0,'c','2021-04-20 04:58:17'),(272,45,13,56,0,'c','2021-04-20 04:58:17'),(273,46,13,56,0,'c','2021-04-20 04:58:18'),(274,47,13,56,0,'c','2021-04-20 04:58:18'),(275,48,13,56,0,'c','2021-04-20 04:58:18'),(276,49,13,56,0,'c','2021-04-20 04:58:18'),(277,43,13,57,0,'c','2021-04-20 04:58:33'),(278,44,13,57,0,'c','2021-04-20 04:58:33'),(279,45,13,57,0,'c','2021-04-20 04:58:33'),(280,46,13,57,0,'c','2021-04-20 04:58:33'),(281,47,13,57,0,'c','2021-04-20 04:58:33'),(282,48,13,57,0,'c','2021-04-20 04:58:33'),(283,49,13,57,0,'c','2021-04-20 04:58:33'),(284,50,14,58,0,'c','2021-04-20 04:58:48'),(285,51,14,58,0,'c','2021-04-20 04:58:48'),(286,52,14,58,0,'c','2021-04-20 04:58:48'),(287,53,14,58,0,'c','2021-04-20 04:58:48'),(288,54,14,58,0,'c','2021-04-20 04:58:48'),(289,50,14,59,0,'c','2021-04-20 04:59:08'),(290,51,14,59,0,'c','2021-04-20 04:59:08'),(291,52,14,59,0,'c','2021-04-20 04:59:08'),(292,53,14,59,0,'c','2021-04-20 04:59:09'),(293,54,14,59,0,'c','2021-04-20 04:59:09'),(294,50,14,60,0,'c','2021-04-20 04:59:28'),(295,51,14,60,0,'c','2021-04-20 04:59:28'),(296,52,14,60,0,'c','2021-04-20 04:59:28'),(297,53,14,60,0,'c','2021-04-20 04:59:28'),(298,54,14,60,0,'c','2021-04-20 04:59:28'),(299,50,14,61,0,'c','2021-04-20 04:59:48'),(300,51,14,61,0,'c','2021-04-20 04:59:48'),(301,52,14,61,0,'c','2021-04-20 04:59:48'),(302,53,14,61,0,'c','2021-04-20 04:59:48'),(303,54,14,61,0,'c','2021-04-20 04:59:48'),(304,50,14,62,0,'c','2021-04-20 04:59:57'),(305,51,14,62,0,'c','2021-04-20 04:59:57'),(306,52,14,62,0,'c','2021-04-20 04:59:57'),(307,53,14,62,0,'c','2021-04-20 04:59:57'),(308,54,14,62,0,'c','2021-04-20 04:59:57');

--
-- Table structure for table `sb_subject_clone`
--

CREATE TABLE `sb_subject_clone` (
  `subject_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(255) NOT NULL,
  `subject_code` varchar(255) DEFAULT NULL,
  `subject_fk_subject_id` int(11) DEFAULT NULL,
  `subject_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`subject_pk_id`),
  KEY `NewIndex1` (`subject_pk_id`),
  KEY `NewIndex2` (`subject_name`),
  KEY `NewIndex3` (`subject_code`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subject_clone`
--

INSERT INTO `sb_subject_clone` VALUES (1,'English 05','English 05',NULL,'2021-04-15 05:42:39'),(2,'ENGLISH 01','engl0nu',NULL,'2021-04-20 04:31:10'),(3,'MATHS 01','math0nu',NULL,'2021-04-20 04:31:10'),(4,'ENGLISH 02','engl0ii',NULL,'2021-04-20 04:33:31'),(5,'ODIA 02','odia0ii',NULL,'2021-04-20 04:33:31'),(6,'MATHS 02','math0ii',NULL,'2021-04-20 04:33:31'),(7,'EVS 02','evs0ii',NULL,'2021-04-20 04:33:31'),(8,'COMPUTER02','comp0ii',NULL,'2021-04-20 04:33:31'),(9,'ENGLISH 03','engl0ii',NULL,'2021-04-20 04:40:03'),(10,'ODIA 03','odia0ii',NULL,'2021-04-20 04:40:03'),(11,'MATHS 03','math0ii',NULL,'2021-04-20 04:40:03'),(12,'SCIENCE 03','scie0ii',NULL,'2021-04-20 04:40:03'),(13,'SOCIAL SCIENCE 03','soci0ii',NULL,'2021-04-20 04:40:03'),(14,'COMPUTER03','comp0ii',NULL,'2021-04-20 04:40:03'),(15,'ENGLISH 04','engl0iv',NULL,'2021-04-20 04:41:36'),(16,'HIGHER HINDI 04','high0iv',NULL,'2021-04-20 04:41:36'),(17,'LOWER ODIA 04','lowe0iv',NULL,'2021-04-20 04:41:36'),(18,'MATHEMATICS 04','math0iv',NULL,'2021-04-20 04:41:36'),(19,'SCIENCE 04','scie0iv',NULL,'2021-04-20 04:41:36'),(20,'SOCIAL SCIENCE 04','soci0iv',NULL,'2021-04-20 04:41:36'),(21,'COMPUTER04','comp0iv',NULL,'2021-04-20 04:41:36'),(22,'MATHEMATICS 05','math00v',NULL,'2021-04-20 04:43:27'),(23,'SCIENCE 05','scie00v',NULL,'2021-04-20 04:43:27'),(24,'SOCIAL SCIENCE 05','soci00v',NULL,'2021-04-20 04:43:27'),(25,'COMPUTER05','comp00v',NULL,'2021-04-20 04:43:27'),(26,'ENGLISH 06','engl0vi',NULL,'2021-04-20 04:45:00'),(27,'HIGHER ODIA 06','high0vi',NULL,'2021-04-20 04:45:01'),(28,'LOWER HINDI 06','lowe0vi',NULL,'2021-04-20 04:45:01'),(29,'MATHEMATICS06','math0vi',NULL,'2021-04-20 04:45:01'),(30,'SCIENCE 06','scie0vi',NULL,'2021-04-20 04:45:01'),(31,'SOCIAL SCIENCE 06','soci0vi',NULL,'2021-04-20 04:45:01'),(32,'COMPUTER 06','comp0vi',NULL,'2021-04-20 04:45:01'),(33,'ENGLISH 09','engl0ix',NULL,'2021-04-20 04:53:55'),(34,'HINDI 09','hind0ix',NULL,'2021-04-20 04:53:55'),(35,'MATHEMATICS 09','math0ix',NULL,'2021-04-20 04:53:55'),(36,'SCIENCE 09','scie0ix',NULL,'2021-04-20 04:53:55'),(37,'SOCIAL SCIENCE 09','soci0ix',NULL,'2021-04-20 04:53:55'),(38,'ENGLISH 07','engl0vi',NULL,'2021-04-20 04:55:41'),(39,'MATHEMATICS 07','math0vi',NULL,'2021-04-20 04:55:41'),(40,'SCIENCE 07','scie0vi',NULL,'2021-04-20 04:55:41'),(41,'SOCIAL SCIENCE 07','soci0vi',NULL,'2021-04-20 04:55:41'),(42,'COMPUTER07','comp0vi',NULL,'2021-04-20 04:55:41'),(43,'ENGLISH 08','engl0vi',NULL,'2021-04-20 04:57:04'),(44,'HIGHER HINDI 08','high0vi',NULL,'2021-04-20 04:57:05'),(45,'LOWER ODIA 08','lowe0vi',NULL,'2021-04-20 04:57:05'),(46,'MATHEMATICS 08','math0vi',NULL,'2021-04-20 04:57:05'),(47,'SCIENCE 08','scie0vi',NULL,'2021-04-20 04:57:05'),(48,'SOCIAL SCIENCE 08','soci0vi',NULL,'2021-04-20 04:57:05'),(49,'COMPUTER08','comp0vi',NULL,'2021-04-20 04:57:05'),(50,'ENGLISH 10','engl00x',NULL,'2021-04-20 04:58:48'),(51,'HINDI 10','hind00x',NULL,'2021-04-20 04:58:48'),(52,'MATHEMATICS 10','math00x',NULL,'2021-04-20 04:58:48'),(53,'SCIENCE 10','scie00x',NULL,'2021-04-20 04:58:48'),(54,'SOCIAL SCIENCE 10','soci00x',NULL,'2021-04-20 04:58:48');

--
-- Table structure for table `sb_subject_master`
--

CREATE TABLE `sb_subject_master` (
  `subject_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `subject_name` varchar(45) DEFAULT NULL,
  `subject_code` varchar(45) DEFAULT NULL,
  `subject_class` int(11) DEFAULT '0',
  `subject_desc` varchar(45) DEFAULT NULL,
  `subject_status` int(5) DEFAULT '1',
  `subject_added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`subject_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=179 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subject_master`
--


--
-- Table structure for table `sb_subject_option_assignment`
--

CREATE TABLE `sb_subject_option_assignment` (
  `option_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `option_fk_sa_id` int(11) NOT NULL COMMENT 'subject assignment id',
  `option_fk_subject_id` int(11) NOT NULL COMMENT 'subject id',
  PRIMARY KEY (`option_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subject_option_assignment`
--


--
-- Table structure for table `sb_subscription_fees_logs`
--

CREATE TABLE `sb_subscription_fees_logs` (
  `fl_id` mediumint(20) NOT NULL AUTO_INCREMENT,
  `fl_class_id` int(11) DEFAULT NULL,
  `fl_section_id` int(11) DEFAULT NULL,
  `fl_student_id` int(11) DEFAULT NULL,
  `fl_invoice_id` int(11) DEFAULT NULL,
  `fl_plan_log_id` int(11) DEFAULT NULL,
  `fl_log` mediumtext,
  `fl_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fl_user_id` int(11) DEFAULT NULL,
  `fl_remarks` mediumtext,
  `fl_mode` int(11) DEFAULT NULL,
  `fl_status` varchar(255) DEFAULT NULL,
  `fl_details` mediumtext,
  PRIMARY KEY (`fl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subscription_fees_logs`
--


--
-- Table structure for table `sb_subscription_invoices`
--

CREATE TABLE `sb_subscription_invoices` (
  `si_id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_reference_invoice_id` int(11) DEFAULT NULL,
  `fee_receipt_number` bigint(20) DEFAULT NULL,
  `fi_student_id` int(11) DEFAULT NULL,
  `fi_student_details_id` bigint(20) DEFAULT NULL,
  `fi_plan_id` int(11) DEFAULT NULL,
  `fi_student_plan_id` int(11) DEFAULT NULL,
  `fi_invoice_date` date DEFAULT NULL,
  `fi_effective_due_date` date DEFAULT NULL,
  `fi_due_date` date DEFAULT NULL,
  `fi_gross_amount` int(11) DEFAULT NULL,
  `fi_net_amount` int(11) DEFAULT NULL,
  `fi_amount_paid` int(11) DEFAULT NULL,
  `fi_payment_receive` int(100) DEFAULT NULL,
  `fi_payment_status` varchar(50) DEFAULT NULL,
  `fi_transaction_id` int(11) DEFAULT NULL,
  `fi_payment_date` timestamp NULL DEFAULT NULL,
  `fi_payment_mode` int(11) DEFAULT NULL,
  `fi_payment_details` mediumtext,
  `fi_status` varchar(255) DEFAULT NULL,
  `fi_remarks` mediumtext,
  `fi_remarks_receipt` mediumtext,
  `fi_check_status` int(11) DEFAULT NULL,
  `fi_check_date` datetime DEFAULT NULL,
  `in_generated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`si_id`),
  UNIQUE KEY `in_generated_date_UNIQUE` (`in_generated_date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subscription_invoices`
--


--
-- Table structure for table `sb_subscription_plan`
--

CREATE TABLE `sb_subscription_plan` (
  `sp_id` int(11) NOT NULL AUTO_INCREMENT,
  `sp_plan_name` varchar(45) DEFAULT NULL,
  `sp_plan_description` varchar(100) DEFAULT NULL,
  `sp_plan_type` int(11) DEFAULT NULL,
  `sp_status` varchar(45) DEFAULT NULL,
  `sp_default_plan` int(11) DEFAULT NULL,
  PRIMARY KEY (`sp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subscription_plan`
--


--
-- Table structure for table `sb_subscription_plan_frequency`
--

CREATE TABLE `sb_subscription_plan_frequency` (
  `pt_id` int(11) NOT NULL AUTO_INCREMENT,
  `pt_plan_type_fk_id` varchar(45) DEFAULT NULL,
  `pt_invoice_date` date DEFAULT NULL,
  `pt_invoice_due_date` date DEFAULT NULL,
  `pt_invoice_effective_date` date DEFAULT NULL,
  `pt_invoice_amount` int(11) DEFAULT NULL,
  `pt_status` int(2) DEFAULT NULL,
  PRIMARY KEY (`pt_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='	';

--
-- Dumping data for table `sb_subscription_plan_frequency`
--


--
-- Table structure for table `sb_subscription_plan_type_master`
--

CREATE TABLE `sb_subscription_plan_type_master` (
  `ptm_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ptm_name` varchar(45) DEFAULT NULL,
  `ptm_description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`ptm_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subscription_plan_type_master`
--


--
-- Table structure for table `sb_subscription_student_plan`
--

CREATE TABLE `sb_subscription_student_plan` (
  `sub_id` int(11) NOT NULL AUTO_INCREMENT,
  `sub_student_pk_id` int(11) DEFAULT NULL,
  `sub_sudent_detail_id` int(11) DEFAULT NULL,
  `sub_clas_id` int(11) DEFAULT NULL,
  `sub_section_id` int(11) DEFAULT NULL,
  `sub_plan_id` int(11) DEFAULT NULL,
  `sub_type_id` int(11) DEFAULT NULL,
  `sub_status` int(2) DEFAULT NULL,
  `sub_default_plan` int(11) DEFAULT NULL,
  PRIMARY KEY (`sub_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_subscription_student_plan`
--


--
-- Table structure for table `sb_survey`
--

CREATE TABLE `sb_survey` (
  `survey_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `survey_name` varchar(255) NOT NULL,
  `survey_disc` mediumtext NOT NULL,
  `survey_submission_date` date NOT NULL,
  `survey_publish_date` date NOT NULL,
  `survey_fk_status_id` tinyint(1) NOT NULL DEFAULT '2',
  `survey_fk_report_status_id` tinyint(1) NOT NULL DEFAULT '2',
  `survey_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`survey_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_survey`
--


--
-- Table structure for table `sb_survey_answer`
--

CREATE TABLE `sb_survey_answer` (
  `answer_id` int(11) NOT NULL AUTO_INCREMENT,
  `answer_fk_sq_id` int(11) NOT NULL,
  `answer_option` mediumtext,
  PRIMARY KEY (`answer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_survey_answer`
--


--
-- Table structure for table `sb_survey_applicables`
--

CREATE TABLE `sb_survey_applicables` (
  `sapplicable_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `sapplicable_fk_survey_id` int(11) NOT NULL,
  `sapplicable_fk_class_id` int(11) NOT NULL,
  `sapplicable_fk_section_id` int(11) NOT NULL,
  PRIMARY KEY (`sapplicable_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_survey_applicables`
--


--
-- Table structure for table `sb_survey_question`
--

CREATE TABLE `sb_survey_question` (
  `sq_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `sq_fk_survey_id` int(11) NOT NULL,
  `sq_question` mediumtext NOT NULL,
  `sq_option1` mediumtext NOT NULL,
  `sq_option2` mediumtext NOT NULL,
  `sq_option3` mediumtext NOT NULL,
  `sq_option4` mediumtext NOT NULL,
  `sq_option5` mediumtext NOT NULL,
  `sq_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sq_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_survey_question`
--


--
-- Table structure for table `sb_survey_submission`
--

CREATE TABLE `sb_survey_submission` (
  `submission_id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_fk_parent_id` int(11) NOT NULL,
  `submission_fk_survey_id` int(11) NOT NULL,
  `submission_fk_sq_id` int(11) NOT NULL,
  `submission_fk_answer_id` int(11) NOT NULL,
  `submission_comment` text NOT NULL,
  `submission_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`submission_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_survey_submission`
--


--
-- Table structure for table `sb_syllabus`
--

CREATE TABLE `sb_syllabus` (
  `syllabus_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `syllabus_fk_class_id` int(11) NOT NULL,
  `syllabus_fk_section_id` int(11) NOT NULL,
  `syllabus_fk_subject_id` int(11) NOT NULL,
  `syllabus_fk_sub_subject_id` int(11) NOT NULL,
  `syllabus_chapter_no` int(11) NOT NULL,
  `syllabus_chapter_name` mediumtext NOT NULL,
  `syllabus_no_of_lectures` int(11) NOT NULL,
  `syllabus_weightage` float NOT NULL,
  `syllabus_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`syllabus_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_syllabus`
--

INSERT INTO `sb_syllabus` VALUES (1,1,1,1,0,1,'Grammer',10,0,'2021-04-15 05:44:39');

--
-- Table structure for table `sb_syllabus_subtopics`
--

CREATE TABLE `sb_syllabus_subtopics` (
  `subtopic_id` int(11) NOT NULL AUTO_INCREMENT,
  `session` varchar(45) DEFAULT NULL,
  `complition_timeline` date DEFAULT NULL,
  `session_taken` varchar(45) DEFAULT NULL,
  `completed_status` varchar(255) DEFAULT NULL,
  `complition_status` varchar(255) DEFAULT NULL,
  `topics_covered` mediumtext,
  `activity_conducted` varchar(255) DEFAULT NULL,
  `peadagogy_used` varchar(255) DEFAULT NULL,
  `notebook_checked` varchar(255) DEFAULT NULL,
  `revision_status` varchar(45) DEFAULT NULL,
  `remark` mediumtext,
  `notebook_date` varchar(45) DEFAULT NULL,
  `chapter_remark` mediumtext,
  `chapter_id_fk` int(11) DEFAULT NULL,
  `section_id_fk` int(11) DEFAULT NULL,
  `class_id_fk` int(11) DEFAULT NULL,
  `chapter_status` varchar(45) DEFAULT NULL,
  `inserted_date` datetime DEFAULT NULL,
  `subject_id` int(11) DEFAULT NULL,
  `teacher_id` int(11) DEFAULT NULL,
  `public_comment` mediumtext,
  `private_comment` mediumtext,
  `star_rating` varchar(45) DEFAULT NULL,
  `public_mgt_comments` mediumtext,
  `private_mgt_comments` mediumtext,
  `mgt_star_rating` varchar(45) DEFAULT NULL,
  `reviewer_id` int(11) DEFAULT NULL,
  `mgt_id` int(11) DEFAULT NULL,
  `reviewer_comment_date` datetime DEFAULT NULL,
  `manager_comment_date` datetime DEFAULT NULL,
  `notebook_check_timeline` date DEFAULT NULL,
  PRIMARY KEY (`subtopic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_syllabus_subtopics`
--


--
-- Table structure for table `sb_tc_student_request`
--

CREATE TABLE `sb_tc_student_request` (
  `tc_req_id` int(11) NOT NULL AUTO_INCREMENT,
  `student_id` int(11) DEFAULT NULL,
  `class` varchar(45) DEFAULT NULL,
  `section` varchar(45) DEFAULT NULL,
  `request_status` int(11) DEFAULT NULL,
  `remark` varchar(255) DEFAULT 'NULL',
  `added_date` datetime DEFAULT NULL,
  PRIMARY KEY (`tc_req_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_tc_student_request`
--


--
-- Table structure for table `sb_teacher_details`
--

CREATE TABLE `sb_teacher_details` (
  `teacher_c_id` int(11) NOT NULL AUTO_INCREMENT,
  `teacher_user_id` int(11) DEFAULT NULL,
  `teacher_anni_date` date DEFAULT NULL,
  `teacher_order` int(11) DEFAULT NULL,
  `details_field_1` varchar(255) DEFAULT NULL,
  `details_field_2` varchar(255) DEFAULT NULL,
  `details_field_3` varchar(255) DEFAULT NULL,
  `details_field_4` varchar(255) DEFAULT NULL,
  `details_field_5` varchar(255) DEFAULT NULL,
  `details_field_6` varchar(255) DEFAULT NULL,
  `details_field_7` varchar(255) DEFAULT NULL,
  `details_field_8` varchar(255) DEFAULT NULL,
  `details_field_9` varchar(255) DEFAULT NULL,
  `details_field_10` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`teacher_c_id`)
) ENGINE=MyISAM AUTO_INCREMENT=172 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_teacher_details`
--

INSERT INTO `sb_teacher_details` VALUES (171,362,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `sb_temp_data`
--

CREATE TABLE `sb_temp_data` (
  `temp_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `table` varchar(255) NOT NULL,
  `class_id` int(11) NOT NULL,
  `section_id` int(11) NOT NULL,
  `exam_id` int(11) NOT NULL,
  `temp_table_id` int(11) NOT NULL,
  `temp_login_id` int(11) NOT NULL,
  `schedule_date` date NOT NULL,
  `schedule_start_time` time NOT NULL,
  `schedule_end_time` time NOT NULL,
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`temp_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_temp_data`
--


--
-- Table structure for table `sb_thumb_attendance`
--

CREATE TABLE `sb_thumb_attendance` (
  `rfid_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `rfid_sid` varchar(10) NOT NULL,
  `rfid_mid` varchar(5) NOT NULL,
  `rfid_card_id` varchar(15) NOT NULL,
  `rfid_dot` datetime NOT NULL COMMENT 'Date of Transaction',
  `rfid_original_date` datetime NOT NULL,
  `rfid_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`rfid_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_thumb_attendance`
--


--
-- Table structure for table `sb_timeslot`
--

CREATE TABLE `sb_timeslot` (
  `timeslot_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `time_slot_fk_shift_id` int(10) NOT NULL,
  `timeslot_from_time` time NOT NULL,
  `timeslot_to_time` time NOT NULL,
  `timeslot_day` varchar(10) NOT NULL,
  `timeslot_is_break` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'timeslot is for break for not',
  `timeslot_break_desc` varchar(100) NOT NULL,
  `timeslot_lecture` tinyint(1) NOT NULL,
  PRIMARY KEY (`timeslot_pk_id`),
  KEY `NewIndex1` (`timeslot_pk_id`),
  KEY `NewIndex2` (`time_slot_fk_shift_id`),
  KEY `NewIndex3` (`timeslot_from_time`),
  KEY `NewIndex4` (`timeslot_to_time`),
  KEY `NewIndex5` (`timeslot_day`),
  KEY `NewIndex6` (`timeslot_is_break`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_timeslot`
--

INSERT INTO `sb_timeslot` VALUES (1,1,'10:00:00','11:00:00','Monday','','',1),(2,1,'10:00:00','11:00:00','Tuesday','','',1),(3,1,'10:00:00','11:00:00','Wednesday','','',1),(4,1,'10:00:00','11:00:00','Thursday','','',1),(5,1,'10:00:00','11:00:00','Friday','','',1),(6,1,'00:00:00','00:00:00','Saturday','','',1),(7,1,'00:00:00','00:00:00','Sunday','','',1);

--
-- Table structure for table `sb_timeslot_old`
--

CREATE TABLE `sb_timeslot_old` (
  `timeslot_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `time_slot_fk_shift_id` int(10) NOT NULL,
  `timeslot_from_time` time NOT NULL,
  `timeslot_to_time` time NOT NULL,
  `timeslot_day` varchar(10) NOT NULL,
  `timeslot_is_break` enum('0','1') NOT NULL DEFAULT '0' COMMENT 'timeslot is for break for not',
  `timeslot_break_desc` varchar(100) NOT NULL,
  `timeslot_lecture` tinyint(1) NOT NULL,
  PRIMARY KEY (`timeslot_pk_id`),
  KEY `NewIndex1` (`timeslot_pk_id`),
  KEY `NewIndex2` (`time_slot_fk_shift_id`),
  KEY `NewIndex3` (`timeslot_from_time`),
  KEY `NewIndex4` (`timeslot_to_time`),
  KEY `NewIndex5` (`timeslot_day`),
  KEY `NewIndex6` (`timeslot_is_break`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_timeslot_old`
--


--
-- Table structure for table `sb_timeslot_shift`
--

CREATE TABLE `sb_timeslot_shift` (
  `shift_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `shift_title` varchar(50) NOT NULL,
  `shift_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`shift_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_timeslot_shift`
--

INSERT INTO `sb_timeslot_shift` VALUES (1,'Testing Shift','2021-04-15 06:24:44');

--
-- Table structure for table `sb_timetable`
--

CREATE TABLE `sb_timetable` (
  `timetable_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `timetable_fk_timetable_shift_id` int(11) NOT NULL,
  `timetable_fk_timeslot_id` int(11) NOT NULL,
  `timetable_fk_week_id` int(11) NOT NULL,
  `timetable_date` date NOT NULL,
  `timetable_day` varchar(10) NOT NULL,
  `timetable_fk_class_id` int(11) NOT NULL,
  `timetable_fk_section_id` int(11) NOT NULL,
  `timetable_fk_activity_id` int(11) NOT NULL,
  `timetable_fk_status_id` tinyint(11) NOT NULL DEFAULT '2',
  PRIMARY KEY (`timetable_pk_id`),
  KEY `NewIndex1` (`timetable_pk_id`),
  KEY `NewIndex2` (`timetable_fk_timetable_shift_id`),
  KEY `NewIndex3` (`timetable_fk_timeslot_id`),
  KEY `NewIndex4` (`timetable_fk_week_id`),
  KEY `NewIndex5` (`timetable_date`),
  KEY `NewIndex6` (`timetable_day`),
  KEY `NewIndex7` (`timetable_fk_class_id`),
  KEY `NewIndex8` (`timetable_fk_section_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_timetable`
--

INSERT INTO `sb_timetable` VALUES (1,1,4,1,'2021-04-15','Thursday',1,1,0,1);

--
-- Table structure for table `sb_timetable_shift`
--

CREATE TABLE `sb_timetable_shift` (
  `timetable_shift_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `timetable_shift_fk_class_id` int(11) NOT NULL,
  `timetable_shift_fk_section_id` int(11) NOT NULL,
  `timetable_shift_fk_shift_id` int(11) NOT NULL,
  `timetable_shift_start_date` date NOT NULL,
  `timetable_shift_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`timetable_shift_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_timetable_shift`
--

INSERT INTO `sb_timetable_shift` VALUES (1,1,1,1,'2021-04-12','2021-04-15 06:26:07');

--
-- Table structure for table `sb_timetable_subjects`
--

CREATE TABLE `sb_timetable_subjects` (
  `ts_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ts_fk_timetable_id` int(11) NOT NULL COMMENT 'time table id',
  `ts_fk_sa_id` int(11) NOT NULL COMMENT 'subject assignment id',
  `ts_fk_option_id` int(11) NOT NULL COMMENT 'subject option assignment id',
  `ts_fk_teacher_id` int(11) NOT NULL,
  `ts_fk_syllabus_id` int(11) NOT NULL,
  `ts_remark` mediumtext NOT NULL,
  `ts_fk_leave_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ts_pk_id`),
  KEY `NewIndex1` (`ts_fk_timetable_id`),
  KEY `NewIndex2` (`ts_fk_sa_id`),
  KEY `NewIndex3` (`ts_fk_option_id`),
  KEY `NewIndex4` (`ts_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_timetable_subjects`
--

INSERT INTO `sb_timetable_subjects` VALUES (1,1,1,0,362,0,'',0);

--
-- Table structure for table `sb_timetable_week`
--

CREATE TABLE `sb_timetable_week` (
  `week_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `week_start_date` date NOT NULL,
  `week_end_date` date NOT NULL,
  `week_year` int(11) NOT NULL,
  `week_number` int(11) NOT NULL,
  `week_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`week_pk_id`),
  KEY `NewIndex1` (`week_pk_id`),
  KEY `NewIndex2` (`week_start_date`),
  KEY `NewIndex3` (`week_end_date`),
  KEY `NewIndex4` (`week_year`),
  KEY `NewIndex5` (`week_number`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_timetable_week`
--

INSERT INTO `sb_timetable_week` VALUES (1,'2021-04-12','2021-04-17',2021,15,'2021-04-15 06:25:57');

--
-- Table structure for table `sb_transfar_certificate`
--

CREATE TABLE `sb_transfar_certificate` (
  `tc_id` int(11) NOT NULL AUTO_INCREMENT,
  `tc_student_id` int(11) DEFAULT NULL,
  `tc_nationality` varchar(45) DEFAULT NULL,
  `tc_first_admission_date` date DEFAULT NULL,
  `tc_first_admission_with_class` varchar(45) DEFAULT NULL,
  `tc_whether_failed` varchar(45) DEFAULT NULL,
  `tc_is_promoted_to_class` varchar(45) DEFAULT NULL,
  `tc_promoted_class` varchar(45) DEFAULT NULL,
  `tc_promoted_section` varchar(45) DEFAULT NULL,
  `tc_fees_paid_month` varchar(45) DEFAULT NULL,
  `tc_fees_concession` varchar(45) DEFAULT NULL,
  `tc_working_days` varchar(45) DEFAULT NULL,
  `tc_working_days_present` varchar(45) DEFAULT NULL,
  `tc_ncc` varchar(45) DEFAULT NULL,
  `tc_extra_activity` varchar(45) DEFAULT NULL,
  `tc_general_conduct` varchar(45) DEFAULT NULL,
  `tc_date_of_app_cert` date DEFAULT NULL,
  `tc_date_of_certificate` date DEFAULT NULL,
  `tc_reason_for_leaving_school` varchar(45) DEFAULT NULL,
  `tc_remark` varchar(45) DEFAULT NULL,
  `tc_subjects` varchar(255) DEFAULT NULL,
  `tc_last_taken_result` varchar(255) DEFAULT NULL,
  `tc_pramoted_class_in_word` varchar(255) DEFAULT NULL,
  `last_class_in_word` varchar(255) DEFAULT NULL,
  `tc_student_category` varchar(255) DEFAULT NULL,
  `tc_srno` int(255) DEFAULT NULL,
  `tc_dob` date DEFAULT NULL,
  `tc_parent_name` varchar(255) DEFAULT NULL,
  `tc_mother_name` varchar(25) DEFAULT NULL,
  `tc_type` int(11) DEFAULT '1',
  `tc_aadhar_card` varchar(255) DEFAULT NULL,
  `tc_aadhar_card_mother` varchar(45) DEFAULT NULL,
  `tc_aadhar_card_father` varchar(45) DEFAULT NULL,
  `tc_date_rolls` date DEFAULT NULL,
  `tc_no_meetings` varchar(45) DEFAULT NULL,
  `tc_issue_date` date DEFAULT NULL,
  `tc_generate_status` int(11) DEFAULT '1',
  `tc_sr_no` int(11) DEFAULT NULL,
  `tc_reg_no_class_9_to_12` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`tc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=240 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transfar_certificate`
--


--
-- Table structure for table `sb_transport_admin`
--

CREATE TABLE `sb_transport_admin` (
  `ta_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ta_user_id` int(11) DEFAULT NULL,
  `ta_user_name` varchar(45) DEFAULT NULL,
  `ta_email_id` mediumtext,
  `ta_type` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`ta_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_admin`
--


--
-- Table structure for table `sb_transport_allocation`
--

CREATE TABLE `sb_transport_allocation` (
  `ta_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `ta_bus_id` int(255) DEFAULT NULL,
  `ta_route_id` int(255) DEFAULT NULL,
  `ta_stop_id` int(255) DEFAULT NULL,
  `ta_type` int(10) DEFAULT NULL,
  `ta_status` int(10) DEFAULT NULL,
  PRIMARY KEY (`ta_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_allocation`
--


--
-- Table structure for table `sb_transport_bus`
--

CREATE TABLE `sb_transport_bus` (
  `bus_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `bus_name` varchar(255) DEFAULT NULL,
  `bus_number` varchar(255) DEFAULT NULL,
  `bus_gps_id` varchar(255) DEFAULT NULL,
  `bus_driver_name` varchar(255) DEFAULT NULL,
  `bus_driver_address` varchar(255) DEFAULT NULL,
  `bus_driver_contact` varchar(255) DEFAULT NULL,
  `bus_driver_email` varchar(255) DEFAULT NULL,
  `bus_driver_gender` varchar(255) DEFAULT NULL,
  `bus_driver_age` int(255) DEFAULT NULL,
  `bus_driver_image` varchar(255) DEFAULT NULL,
  `bus_coordinator_name` varchar(255) DEFAULT NULL,
  `bus_coordinator_adress` varchar(255) DEFAULT NULL,
  `bus_coordinator_contact` varchar(255) DEFAULT NULL,
  `bus_coordinator_email` varchar(255) DEFAULT NULL,
  `bus_coordinator_gender` varchar(255) DEFAULT NULL,
  `bus_teacher` int(255) DEFAULT NULL,
  `bus_status` int(255) DEFAULT '1',
  PRIMARY KEY (`bus_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_bus`
--


--
-- Table structure for table `sb_transport_bus_driver_document`
--

CREATE TABLE `sb_transport_bus_driver_document` (
  `dd_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dd_bus_id` int(11) DEFAULT NULL,
  `dd_doc_name` mediumtext,
  `dd_document` mediumtext,
  `dd_doc_datetime` datetime DEFAULT NULL,
  `dd_added_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`dd_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_bus_driver_document`
--


--
-- Table structure for table `sb_transport_log`
--

CREATE TABLE `sb_transport_log` (
  `tl_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `tl_stud_id` int(255) DEFAULT NULL,
  `tl_bus_id` int(255) DEFAULT NULL,
  `tl_route_id` int(255) DEFAULT NULL,
  `tl_stop_id` int(255) DEFAULT NULL,
  `tl_type` int(255) DEFAULT NULL,
  `tl_text` varchar(255) DEFAULT NULL,
  `tl_log_date` datetime DEFAULT NULL,
  `tl_status_type` int(255) DEFAULT NULL,
  `tl_date` varchar(255) DEFAULT NULL,
  `tl_q_date` varchar(255) DEFAULT NULL,
  `tl_q_period` varchar(255) DEFAULT NULL,
  `tl_q_type` varchar(255) DEFAULT NULL,
  `tl_user_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`tl_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_log`
--


--
-- Table structure for table `sb_transport_quarter`
--

CREATE TABLE `sb_transport_quarter` (
  `tq_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `tq_date` date DEFAULT NULL,
  `tq_quarter_id` int(255) DEFAULT NULL,
  `tq_trasport_type` int(255) DEFAULT NULL,
  `tq_stud_id` int(255) DEFAULT NULL,
  `tq_main_type` int(255) DEFAULT NULL,
  PRIMARY KEY (`tq_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=52 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_quarter`
--


--
-- Table structure for table `sb_transport_route`
--

CREATE TABLE `sb_transport_route` (
  `route_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `route_name` varchar(255) DEFAULT NULL,
  `route_number` varchar(255) DEFAULT NULL,
  `route_distance` varchar(255) DEFAULT NULL,
  `route_distance_unit` varchar(255) DEFAULT NULL,
  `route_helper` varchar(255) DEFAULT NULL,
  `route_helper_contact` varchar(45) DEFAULT NULL,
  `route_ayah` varchar(255) DEFAULT NULL,
  `route_ayah_contact` varchar(45) DEFAULT NULL,
  `route_bus_pickup` int(11) DEFAULT NULL,
  `route_bus_drop` int(11) DEFAULT NULL,
  PRIMARY KEY (`route_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_route`
--


--
-- Table structure for table `sb_transport_route_incharge`
--

CREATE TABLE `sb_transport_route_incharge` (
  `route_incharge_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `route_incharge_name` varchar(255) DEFAULT NULL,
  `route_fk_id` int(255) DEFAULT NULL,
  PRIMARY KEY (`route_incharge_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_route_incharge`
--


--
-- Table structure for table `sb_transport_route_stop`
--

CREATE TABLE `sb_transport_route_stop` (
  `rs_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `rs_route_id` int(255) DEFAULT NULL,
  `rs_stop_id` int(255) DEFAULT NULL,
  `rs_pickup_sequence` int(11) DEFAULT NULL,
  `rs_pickup_time` time DEFAULT NULL,
  `rs_drop_sequence` int(11) DEFAULT NULL,
  `rs_drop_time` time DEFAULT NULL,
  PRIMARY KEY (`rs_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=829 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_route_stop`
--


--
-- Table structure for table `sb_transport_stop`
--

CREATE TABLE `sb_transport_stop` (
  `stop_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `stop_name` varchar(255) DEFAULT NULL,
  `stop_address` varchar(255) DEFAULT NULL,
  `pic_price` int(10) DEFAULT NULL,
  `drop_price` int(10) DEFAULT NULL,
  `both_price` int(10) DEFAULT NULL,
  `stop_lat` double DEFAULT NULL,
  `stop_long` double DEFAULT NULL,
  PRIMARY KEY (`stop_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=437 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_stop`
--


--
-- Table structure for table `sb_transport_student`
--

CREATE TABLE `sb_transport_student` (
  `ts_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `ts_bus_id` int(255) DEFAULT NULL,
  `ts_route_id` int(255) DEFAULT NULL,
  `ts_stop_id` int(255) DEFAULT NULL,
  `ts_student_id` int(255) DEFAULT NULL,
  `ts_type` int(255) DEFAULT NULL,
  `ts_status` int(255) DEFAULT NULL,
  PRIMARY KEY (`ts_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_transport_student`
--


--
-- Table structure for table `sb_trasport_quarter_setting`
--

CREATE TABLE `sb_trasport_quarter_setting` (
  `qs_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `qs_date` date DEFAULT NULL,
  `qs_inv_date` date DEFAULT NULL,
  `qs_quarter` int(255) DEFAULT NULL,
  PRIMARY KEY (`qs_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_trasport_quarter_setting`
--

INSERT INTO `sb_trasport_quarter_setting` VALUES (1,'2019-04-01','2019-03-01',1),(2,'2019-05-01','2019-04-01',2),(3,'2019-06-01','2019-07-01',3),(4,'2019-07-01','2019-10-01',4),(5,'2019-08-01','2020-01-01',5),(6,'2019-09-01','2019-03-01',1),(7,'2019-10-01','2019-04-01',2),(8,'2019-11-01','2019-07-01',3),(9,'2019-12-01','2019-10-01',4),(10,'2020-01-01','2020-01-01',5),(11,'2020-02-01','2019-03-01',1),(12,'2020-03-01','2019-04-01',2);

--
-- Table structure for table `sb_url_request`
--

CREATE TABLE `sb_url_request` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL,
  `school_id` int(11) DEFAULT NULL,
  `added_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_url_request`
--


--
-- Table structure for table `sb_user`
--

CREATE TABLE `sb_user` (
  `user_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_fk_school_id` int(11) NOT NULL,
  `user_fk_user_type_id` int(11) NOT NULL DEFAULT '10',
  `user_id_number` varchar(255) NOT NULL,
  `user_name` varchar(50) DEFAULT NULL,
  `user_password` varchar(255) NOT NULL,
  `user_fullname` varchar(255) NOT NULL,
  `user_email` varchar(255) NOT NULL,
  `user_alt_email` varchar(50) NOT NULL,
  `user_contact` bigint(11) NOT NULL,
  `user_alt_contact` varchar(12) NOT NULL,
  `user_dob` date NOT NULL,
  `user_joining_date` date NOT NULL,
  `user_gender` enum('Male','Female') NOT NULL DEFAULT 'Male',
  `user_blood_group` varchar(10) NOT NULL,
  `user_marital_status` varchar(10) NOT NULL,
  `user_address` mediumtext,
  `user_city` varchar(50) NOT NULL,
  `user_pincode` varchar(8) NOT NULL,
  `user_state` varchar(50) NOT NULL,
  `user_photo` varchar(255) DEFAULT NULL,
  `user_specialization` mediumtext NOT NULL,
  `user_qualification` mediumtext NOT NULL,
  `user_assigned_class` mediumtext,
  `user_remark` mediumtext NOT NULL,
  `user_token` varchar(255) NOT NULL,
  `user_last_login` datetime NOT NULL,
  `user_added_by` int(11) DEFAULT NULL,
  `user_fk_status_id` int(3) NOT NULL,
  `user_password_token` mediumtext NOT NULL,
  `user_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `user_biometric_id` varchar(50) DEFAULT NULL,
  `user_shift_id` int(3) DEFAULT NULL,
  `user_lg_id` int(3) DEFAULT NULL,
  `user_wdm_id` int(3) DEFAULT NULL,
  `user_eg_id` int(3) DEFAULT NULL,
  `user_spouse_name` varchar(50) DEFAULT NULL,
  `user_spouse_contact` bigint(11) DEFAULT NULL,
  `user_child_name` varchar(255) DEFAULT NULL,
  `user_child_contact` bigint(11) DEFAULT NULL,
  `user_additional_duties` varchar(512) DEFAULT NULL,
  `user_permanent_address` varchar(512) DEFAULT NULL,
  `user_aadhar_no` bigint(20) DEFAULT NULL,
  `user_reporting_manager` bigint(20) DEFAULT NULL,
  `user_is_reporting_manager` int(1) DEFAULT NULL,
  `assigned_reviewer` varchar(255) DEFAULT NULL,
  `user_pan_no` varchar(45) DEFAULT NULL,
  `user_leaving_date` varchar(45) DEFAULT NULL,
  `sb_usercol` varchar(45) DEFAULT NULL,
  `dept_fk_id` int(11) DEFAULT NULL,
  `user_probation_date` date DEFAULT NULL,
  `user_probation_period` varchar(45) DEFAULT NULL,
  `user_last_access` datetime DEFAULT NULL,
  `user_login_device_type` varchar(50) DEFAULT NULL,
  `user_login_device_id` varchar(255) DEFAULT NULL,
  `user_bank_ac_no` varchar(100) DEFAULT NULL,
  `user_ppf_no` varchar(100) DEFAULT NULL,
  `user_uan_no` varchar(100) DEFAULT NULL,
  `user_esic_no` varchar(100) DEFAULT NULL,
  `user_org_id` int(11) DEFAULT NULL,
  `user_holiday_group_id` int(11) DEFAULT NULL,
  `is_councilor` int(11) DEFAULT '0',
  `is_inventory_user` int(11) DEFAULT '0',
  `is_inventory_type` int(11) DEFAULT '0',
  PRIMARY KEY (`user_pk_id`),
  KEY `NewIndex1` (`user_fk_school_id`),
  KEY `NewIndex2` (`user_fk_user_type_id`),
  KEY `NewIndex4` (`user_id_number`),
  KEY `NewIndex3` (`user_email`),
  KEY `NewIndex5` (`user_name`)
) ENGINE=InnoDB AUTO_INCREMENT=364 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_user`
--

INSERT INTO `sb_user` VALUES (1,149,1,'0','Super Admin','e10adc3949ba59abbe56e057f20f883e','Super Admin','superadmin@gmail.com','',0,'','0000-00-00','0000-00-00','Male','','','','','','','1458800171teacher_photophoto 1.jpg','','','','','','2021-04-19 21:23:03',NULL,1,'','2021-04-19 15:53:03',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0),(2,149,2,'0','School Admin','e10adc3949ba59abbe56e057f20f883e','Sachin Awari','sachinawari@gmail.com','',9922923525,'','0000-00-00','0000-00-00','Male','','','SchoolBellQ* Mumbai','Mumbai','220001','Maharashtra',NULL,'','',NULL,'','','2021-04-17 15:45:02',1,1,'','2021-04-17 10:15:02',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0),(362,149,19,'100',NULL,'e4ccb212806eb5e35794b3ebbdf1f6b6','Neelamadhab Panda','neelamadhab.panda@schoolbellq.com','',9619101328,'','2005-11-27','2021-04-01','Male','','Married','Sai Bhawan,\r\nVijay Vihar, Bhubaneswar.','Bhubaneswar','751002','Odisha','','1','MBA','1','','','2021-04-20 09:50:49',164,1,'','2021-04-20 04:20:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0),(363,149,19,'',NULL,'39cf77d8989671cca659b8b5b8c7d7cc','Aman Rouniyar','amanrouniyar88@gmail.com','',9337781090,'','0000-00-00','0000-00-00','Male','','','ODM Connect','Bhubaneswar','751031','Odisha',NULL,'','',NULL,'','','2021-04-16 13:21:15',NULL,1,'','2021-04-16 07:51:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0);

--
-- Table structure for table `sb_user_permissions`
--

CREATE TABLE `sb_user_permissions` (
  `permission_id` int(11) NOT NULL AUTO_INCREMENT,
  `permission_title` varchar(255) DEFAULT NULL,
  `permission_code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`permission_id`)
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_user_permissions`
--

INSERT INTO `sb_user_permissions` VALUES (1,'Manage Profile','PEM_SCH'),(4,'Teacher Management','PEM_TM'),(5,'Class Management','PEM_CM'),(6,'Student Management','PEM_SM'),(7,'Subject Management','PEM_SUB'),(8,'Exam Management','PEM_EM'),(9,'Timetable Management','PEM_TM'),(10,'Fee Management','PEM_FM'),(11,'User Permission','PEM_UP'),(12,'Dashboard Management','PEM_DASH'),(13,'Fees Discount Management','PEM_FEE_DISC'),(14,'Fees Status Update','PEM_FEE_STATUS'),(15,'Fess Paid Status Update','PEM_FEE_PAID_STATUS'),(16,'Fees Assign plans','PEM_FEE_ASSIGN_PLAN'),(17,'Fees Component Management','PEM_FEE_COMPONENT'),(18,'Frequency Management','PEM_FEE_DATE_FREQUENCY'),(19,'Fees Plan Management','PEM_FEE_PLAN'),(20,'Fees Late payment Management','PEM_FEE_LATEPAY'),(21,'Fees Bus Route Management','PEM_FEE_BUSROUTE'),(22,'Fees Concession Management','PEM_FEE_CONCESSION'),(23,'Settings','PEM_SETTINGS'),(24,'Reports','PEM_REPORTS'),(25,'Cron Manager','PEM_CRON'),(26,'Pre Admission Management','PEM_PRE_ADMISSION'),(27,'Fees Dates management','PEM_FEE_DATE'),(28,'Student Deletion','PEM_STUDENT_DELETE'),(29,'Send welcome Verification Mail','PEM_SEND_WELCOME_MAIL'),(30,'Allow Email Management','PEM_ALLOW_EMAIL'),(31,'Change Password Managemnet','PEM_CHANGE_PASSWORD'),(32,'Fees Retract Invoice','FEES_RETRACT_INVOICE'),(33,'Employee Holiday','PEM_EMP_HOLIDAY'),(34,'Shift Management','PEM_SHIFT_MGT'),(35,'Leave Category','PEM_LEAVE_CAT'),(36,'Leave Groups','PEM_LEAVE_GROUPS'),(37,'Work Day Management','PEM_WORK_DAY_MGT'),(38,'Employee Group','PEM_EMP_GROUP'),(39,'Add Employee','PEM_ADD_EMP'),(40,'Employee List','PEM_EMP_LIST'),(41,'Apply Leave','PEM_APPLY_LEV'),(42,'Manage Leave Application','PEM_MNG_LEV_APPLI'),(43,'Employee Attendance','PEM_EMP_ATTENDANCE'),(44,'Employee Performance Register','PEM_EMP_PERFORM_REGI'),(45,'Employee Late Arrival','PEM_LATE_ARRIVAL'),(46,'Send Notificaion','PEM_SEND_NOTI'),(47,'Library Management','PEM_LIB'),(48,'Add Book','PEM_ADD_BOOK'),(49,'Book List','PEM_BOOK_LIST'),(50,'Issue Book','PEM_ISSUE_BOOK'),(51,'Issue Book List','PEM_ISSUE_BOOK_LIST'),(52,'Transction Book List','PEM_TRAN_LIST'),(53,'Syllabus Management','PEM_SYLLLABUS_MANAGER'),(54,'Department','PEM_DEPT'),(55,'Leave Notification','PEM_LEAVE_NOTOFICATION'),(56,'General Notification','PEM_GENERAL_NOTIFICATION'),(57,'School Management','PEM_SCHOOL_MANAGEMENT'),(58,'Event Gallery','PEM_EVENT_GALLERY'),(59,'Scholastic Certificate','PEM_SCHOLASTIC'),(60,'Circular Module','PEM_CIRCULAR'),(61,'Student Subscription','STUD_SUBSCRIPTION'),(62,'Visitor Management','PEM_VISITOR'),(63,'Feedback Management','PEM_FEEDBACK'),(64,'Transport Management','PEM_TRANSPORT'),(65,'Payroll Management','PEM_PAYROLL'),(66,'Online Test Module','ONLINE_TEST'),(67,'CRO_LIST','PEM_CRO_LIST'),(68,'Pre Admission Update','PEM_PRE_UPDATE'),(69,'Pre Super User','PEM_SUPER_USER'),(70,'Lead Admin','PEM_ADMIN'),(71,'Syllabus UPLOAD','PEM_SYLLLABUS_UPLOAD'),(72,'View All Syllabus','PEM_SYLLLABUS_VIEW'),(73,'Inventory Requisition','PEM_REQISITION'),(74,'Smart Dashboard Report','PEM_SMART_DASH'),(75,' Manage Leads & Enquiries','PEM_MANAGE_LEADS_AND_ENQUIRIES'),(76,' Withdrawal Management','PEM_WITHDRAWAL_MANAGEMENT'),(77,'TC Management','PEM_TC_MGMT'),(78,'HR Dashboard','PEM_HR_MGMT'),(79,'Lesson Management','PEM_LESSION_MNAG'),(80,'Inventory Management','PEM_INV_MANG'),(81,'Inventory Reports','PEM_REP_MANG'),(82,'Manage SMS Group','PEM_SMS_GROUP'),(83,'Gatepass Management','PEM_GETP_MANG'),(84,'Feedback Management','PEM_FB_MANG'),(85,'Syllabus Management','PEM_SYLB_MANG'),(86,'Parent Concern Management','PEM_PRN_CON_MANG'),(88,'Lession User Management','PEM_LESSION_USER_MNAG'),(89,'Delete Online Subject','PEM_DEL_OT_SUB');

--
-- Table structure for table `sb_user_type`
--

CREATE TABLE `sb_user_type` (
  `user_type_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) DEFAULT NULL,
  `user_type_active` int(2) NOT NULL,
  `user_type_default_permissions` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`user_type_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_user_type`
--

INSERT INTO `sb_user_type` VALUES (1,'superadmin',1,'1,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,88,89'),(2,'school_admin',1,'1,4,5,6,7,8,9,10,'),(3,'Non-Teaching',3,'12,41,47,48,55,56'),(4,'Teaching',3,'5,41,47,48,53,55,56,59,71,58,79'),(15,'Admin academics & Dashboard',1,'81,80,24,9,8,6,5,4,'),(16,'Admin Full Rights',1,'89,81,80,79,57,31,30,29,26,25,24,22,21,20,19,18,17,16,15,14,13,12,10,9,8,7,6,5,4,1,'),(17,'Admin Fees (ASRDCfps)',1,'6,10,13,14,15,16,24,'),(18,'Admin Notifications',1,'6,47,48,49,50,51,52,'),(19,'Admin ALL Rights with Fees',1,'1,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,79,80,81,88,89,77'),(20,'Principal ',1,'1,4,5,6,7,8,9,10,12,13,15,16,23,24,'),(21,'Admin Fees (ASR) ',1,'6,10,12,14,16,17,18,19,24,'),(22,'Admin Pre-admissions & Student List',1,'1,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,89'),(23,'Admin All Rights with Cron & Verification Mail',1,'1,4,5,6,7,8,9,12,24,29,'),(34,'Admin Student List',1,'81,80,77,68,26,24,12,6,'),(35,'Admin Accept fees, Student List & Pre-admissions',1,NULL),(40,'Admin HR',1,'26,68,69,70,'),(41,'Admin Supreme with Student Deletion Rights',1,'1,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,'),(42,'Admin Payabbhi Fees Student list',1,NULL),(43,'Admin ALL Rights with Fees (sans Retract Invoice, Student Deletion)',1,NULL),(44,'Admin ALL Rights with Fees & Student Deletion',1,'1,4,5,6,7,8,9,10,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,'),(46,'Enquiry Form Permissions',1,NULL),(47,'Admin Inventory',1,'80,81'),(48,'Admin',1,NULL),(49,'Staff',1,NULL),(50,'Admin Fee Rights',1,'81,80,68,32,27,26,24,22,21,20,19,18,17,16,15,13,12,10,'),(51,'Admin Class Management',1,'60,58,56,53,46,25,12,5,'),(52,'Admin Transport Management',1,'81,80,72,71,64,'),(53,'Inventory',1,NULL),(54,'Leads Management & Enquiry',1,'75,70,12,');

--
-- Table structure for table `sb_visitor`
--

CREATE TABLE `sb_visitor` (
  `visitor_id` int(11) NOT NULL AUTO_INCREMENT,
  `v_name` varchar(255) DEFAULT NULL,
  `v_email` varchar(45) DEFAULT NULL,
  `v_phone` varchar(45) DEFAULT NULL,
  `v_check_in` datetime DEFAULT NULL,
  `v_check_out` datetime DEFAULT NULL,
  `to_meet` int(11) DEFAULT NULL,
  `v_purpose` varchar(45) DEFAULT NULL,
  `v_status` varchar(45) DEFAULT NULL,
  `v_number` varchar(255) DEFAULT NULL,
  `v_child` varchar(255) DEFAULT NULL,
  `v_photo` varchar(255) DEFAULT NULL,
  `v_class_id` int(100) DEFAULT NULL,
  `v_section_id` int(100) DEFAULT NULL,
  `v_stud_id` int(11) DEFAULT NULL,
  `v_no_of_visitor` varchar(45) DEFAULT NULL,
  `v_location` varchar(45) DEFAULT NULL,
  `v_appointment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`visitor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_visitor`
--


--
-- Table structure for table `sb_visitor_settings`
--

CREATE TABLE `sb_visitor_settings` (
  `vs_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `vs_selfie_required` int(10) DEFAULT NULL,
  `vs_send_feedback_checkout` int(10) DEFAULT NULL,
  `vs_classes_req_authz` varchar(255) DEFAULT NULL,
  `vs_feedback_id` int(10) DEFAULT NULL,
  `vs_without_auth` int(255) DEFAULT NULL,
  PRIMARY KEY (`vs_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_visitor_settings`
--

INSERT INTO `sb_visitor_settings` VALUES (1,1,1,'',1,0);

--
-- Table structure for table `sb_withdrawal_fee_refund`
--

CREATE TABLE `sb_withdrawal_fee_refund` (
  `wr_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `wr_student_id` int(11) DEFAULT NULL,
  `wr_student_number` varchar(255) DEFAULT NULL,
  `wr_amount` varchar(255) DEFAULT NULL,
  `wr_pening_amount` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`wr_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_withdrawal_fee_refund`
--


--
-- Table structure for table `sb_withdrawal_list`
--

CREATE TABLE `sb_withdrawal_list` (
  `wl_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `wl_withdrawal_id` int(11) DEFAULT NULL,
  `wl_student_id` int(11) DEFAULT NULL,
  `wl_class` int(11) DEFAULT NULL,
  `wl_section_id` int(11) DEFAULT NULL,
  `wl_index_number` varchar(255) DEFAULT NULL,
  `wl_pending_amount` varchar(255) DEFAULT NULL,
  `wl_refund_amount` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`wl_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_withdrawal_list`
--


--
-- Table structure for table `sb_withdrawal_refund_invoices`
--

CREATE TABLE `sb_withdrawal_refund_invoices` (
  `wi_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `wi_withdrawal_id` int(11) DEFAULT NULL,
  `wi_student_id` int(11) DEFAULT NULL,
  `wi_invoice_id` int(11) DEFAULT NULL,
  `wi_remaing_amount` varchar(255) DEFAULT NULL,
  `wi_paid_amount` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`wi_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_withdrawal_refund_invoices`
--


--
-- Table structure for table `sb_withdrawal_status`
--

CREATE TABLE `sb_withdrawal_status` (
  `sw_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `sw_status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sw_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_withdrawal_status`
--

INSERT INTO `sb_withdrawal_status` VALUES (1,'Submitted'),(2,'Verified'),(3,'Certificate Collection'),(4,'Refund collection Request'),(5,'Refund collected');

--
-- Table structure for table `sb_withdrawal_students`
--

CREATE TABLE `sb_withdrawal_students` (
  `ws_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ws_student_name` varchar(255) DEFAULT NULL,
  `ws_gender` varchar(45) DEFAULT NULL,
  `ws_dateofbirth` date DEFAULT NULL,
  `ws_nationality` varchar(45) DEFAULT NULL,
  `ws_id_pp_number` varchar(255) DEFAULT NULL,
  `ws_grade` varchar(45) DEFAULT NULL,
  `ws_present_address` mediumtext,
  `ws_permanent` mediumtext,
  `ws_index_number` varchar(255) DEFAULT NULL,
  `ws_extraactivites` mediumtext,
  `ws_grate_experience` varchar(255) DEFAULT NULL,
  `ws_acdemic_programs` varchar(255) DEFAULT NULL,
  `ws_sports_offering` varchar(255) DEFAULT NULL,
  `ws_extracurricular_activity` varchar(255) DEFAULT NULL,
  `ws_school_canteen` varchar(255) DEFAULT NULL,
  `ws_office_services` varchar(255) DEFAULT NULL,
  `ws_cashier_services` varchar(255) DEFAULT NULL,
  `ws_any_comments` mediumtext,
  `ws_reason_leaving` mediumtext,
  `ws_dateof_withdrawal` date DEFAULT NULL,
  `ws_account_number` varchar(255) DEFAULT NULL,
  `ws_bank_name` varchar(255) DEFAULT NULL,
  `ws_account_holder_name` varchar(255) DEFAULT NULL,
  `ws_id_pp_copy` varchar(255) DEFAULT NULL,
  `ws_relation_to_student` varchar(255) DEFAULT NULL,
  `ws_contact_number` varchar(45) DEFAULT NULL,
  `ws_guardian_name` varchar(255) DEFAULT NULL,
  `ws_guardian_contact` varchar(45) DEFAULT NULL,
  `ws_guardian_permanent_add` mediumtext,
  `ws_duardian_date` date DEFAULT NULL,
  `ws_student_id` int(11) DEFAULT NULL,
  `ws_status` int(11) DEFAULT NULL,
  `ws_added_date` datetime DEFAULT NULL,
  `ws_is_certificate` int(11) DEFAULT '0',
  `ws_text` mediumtext,
  PRIMARY KEY (`ws_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_withdrawal_students`
--


--
-- Table structure for table `test_table`
--

CREATE TABLE `test_table` (
  `id` int(10) NOT NULL,
  `symbol` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `test_table`
--



