-- Table structure for table `sb_coacademic_score_position_type`
--

CREATE TABLE `sb_coacademic_score_position_type` (
  `score_position_type_pkid` int(11) NOT NULL AUTO_INCREMENT,
  `score_position_type_name` varchar(45) DEFAULT NULL,
  `score_position_type_added_by` int(11) DEFAULT NULL,
  `score_position_type_added_date_time` datetime DEFAULT NULL,
  `score_position_update_by` int(11) DEFAULT NULL,
  `score_position_update_date_time` datetime DEFAULT NULL,
  PRIMARY KEY (`score_position_type_pkid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_coacademic_score_position_type`
--

INSERT INTO `sb_coacademic_score_position_type` VALUES (1,'1st position',644,'2022-09-06 11:00:59',NULL,NULL),(2,'2nd position',363,'2022-09-20 13:20:36',NULL,NULL),(3,'3rd position',363,'2022-09-20 13:20:48',363,'2022-09-22 15:54:22');

--
-- Table structure for table `sb_color`
--

CREATE TABLE `sb_color` (
  `color_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `color_code` varchar(10) NOT NULL,
  `color_lable` varchar(255) NOT NULL,
  PRIMARY KEY (`color_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_color`
--

INSERT INTO `sb_color` VALUES (1,'#e2b329','Homework is open'),(2,'#d02222','Homework is expired and not yet submitted'),(3,'#00751c','Homework is submitted on time'),(4,'#f14343','Late submission. Submitted after due date'),(5,'#FFFFFF','Homework is expired and status is not updated by the admin'),(6,'#4d9900','student present - #027f05 - #ace600'),(7,'#e60000','student absent - #ff0000'),(8,'#ff00bf','partial day - #fe5e5e - #ffff00'),(9,'#b84dff','sunday - #828282'),(10,'#00cccc','holiday - #4165ff'),(11,'#ffbe00','activity day'),(12,'#3366ff','In time not from rfid, its time when marked as P/PA'),(13,'#ff3333','Student attendace marked as absent but rfid detected later');

--
-- Table structure for table `sb_contact_person`
--

CREATE TABLE `sb_contact_person` (
  `cp_id` int(11) NOT NULL AUTO_INCREMENT,
  `cp_name` varchar(45) DEFAULT NULL,
  `cp_contact` varchar(45) DEFAULT NULL,
  `cp_email` varchar(255) DEFAULT NULL,
  `cp_designation` varchar(255) DEFAULT NULL,
  `cp_status` varchar(45) DEFAULT NULL,
  `cp_deleted_status` varchar(45) DEFAULT NULL,
  `cp_dept_name` varchar(255) DEFAULT NULL,
  `cp_send_authorization_via` varchar(255) DEFAULT NULL,
  `cp_auth_user_ids` varchar(255) DEFAULT NULL,
  `cp_send_authorization_contacts` varchar(255) DEFAULT NULL,
  `cp_send_authorization_emails` varchar(255) DEFAULT NULL,
  `cp_send_notification_via` varchar(45) DEFAULT NULL,
  `cp_send_notification_contacts` varchar(255) DEFAULT NULL,
  `cp_send_notification_emails` varchar(255) DEFAULT NULL,
  `cp_employee_ids` varchar(255) DEFAULT NULL,
  `cp_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`cp_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_contact_person`
--


--
-- Table structure for table `sb_councelor_list`
--

CREATE TABLE `sb_councelor_list` (
  `cl_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `cl_role_id` int(11) DEFAULT NULL,
  `cl_user_id` int(11) DEFAULT NULL,
  `cl_status` int(1) DEFAULT '1',
  `cl_added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`cl_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_councelor_list`
--

INSERT INTO `sb_councelor_list` VALUES (1,1,569,5,'2022-11-16 08:08:53'),(2,1,570,5,'2022-11-16 09:26:02'),(3,2,645,5,'2022-11-16 09:43:40'),(4,2,569,5,'2022-11-16 09:47:21'),(5,1,569,5,'2022-11-16 09:59:45'),(6,1,569,5,'2022-11-16 10:06:17'),(7,2,363,5,'2022-11-17 04:02:37'),(8,1,589,1,'2022-11-17 06:28:34'),(9,1,590,1,'2022-11-17 06:28:45'),(10,2,832,1,'2022-11-17 06:29:03'),(11,2,591,1,'2022-11-17 06:29:22'),(12,2,635,1,'2022-11-17 06:29:40'),(13,2,825,1,'2022-11-17 06:31:02'),(14,3,833,1,'2022-11-17 06:31:13'),(15,3,834,1,'2022-11-17 06:31:20'),(16,3,815,1,'2022-11-17 06:32:09'),(17,3,826,1,'2022-11-17 06:32:19'),(18,3,811,1,'2022-11-17 06:32:44'),(19,2,689,1,'2022-11-17 07:40:34');

--
-- Table structure for table `sb_cro_category`
--

CREATE TABLE `sb_cro_category` (
  `cro_cat_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `cro_cat_name` varchar(255) DEFAULT NULL,
  `cro_cat_created_date` date DEFAULT NULL,
  `cro_cat_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`cro_cat_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_cro_category`
--


--
-- Table structure for table `sb_cro_list`
--

CREATE TABLE `sb_cro_list` (
  `cro_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `cro_teacher` int(11) DEFAULT NULL,
  `cro_class` varchar(255) DEFAULT NULL,
  `cro_section` varchar(45) DEFAULT NULL,
  `cro_date` date DEFAULT NULL,
  `cro_subject` varchar(45) DEFAULT NULL,
  `cro_topic` varchar(45) DEFAULT NULL,
  `cro_created_date` datetime DEFAULT NULL,
  `cro_updated_date` datetime DEFAULT NULL,
  `cro_created_by` int(11) DEFAULT NULL,
  `cro_updated_by` int(11) DEFAULT NULL,
  `cro_status` int(11) DEFAULT NULL,
  `observer_comment` varchar(45) DEFAULT NULL,
  `teacher_reflection` varchar(45) DEFAULT NULL,
  `cro_is_appraiser` int(11) DEFAULT '0',
  `cro_is_reviewer` int(11) DEFAULT '0',
  `cro_is_principal` int(11) DEFAULT '0',
  `cro_month` int(11) DEFAULT '0',
  `reviewer_comment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cro_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_cro_list`
--


--
-- Table structure for table `sb_cro_list_value`
--

CREATE TABLE `sb_cro_list_value` (
  `cro_v_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `cro_fk_id` int(11) DEFAULT NULL,
  `cro_v_cat_id` int(11) DEFAULT NULL,
  `cro_v_cat_name` longtext,
  `cro_v_sub_cat_name` longtext,
  `cro_v_sub_rate` int(11) DEFAULT NULL,
  `cro_reviewer_rate` int(11) DEFAULT NULL,
  `cro_principal_rate` int(11) DEFAULT NULL,
  PRIMARY KEY (`cro_v_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_cro_list_value`
--


--
-- Table structure for table `sb_cro_sub_category`
--

CREATE TABLE `sb_cro_sub_category` (
  `cro_scat_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `cro_cat_fk_id` int(11) DEFAULT NULL,
  `cro_scat_name` longtext,
  PRIMARY KEY (`cro_scat_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_cro_sub_category`
--


--
-- Table structure for table `sb_cron_executions`
--

CREATE TABLE `sb_cron_executions` (
  `cron_id` int(11) NOT NULL AUTO_INCREMENT,
  `cron_name` varchar(255) DEFAULT NULL,
  `cron_last_execution_time` timestamp NULL DEFAULT NULL,
  `cron_duration` varchar(255) DEFAULT NULL,
  `cron_file_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`cron_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_cron_executions`
--


--
-- Table structure for table `sb_customer`
--

CREATE TABLE `sb_customer` (
  `cust_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_name` varchar(255) NOT NULL,
  `cust_email` varchar(100) NOT NULL,
  `cust_mobile` varchar(100) NOT NULL,
  `cust_birthday` date DEFAULT NULL,
  `cust_anniversary` date DEFAULT NULL,
  `cust_occupation` varchar(255) DEFAULT NULL,
  `cust_address` varchar(255) DEFAULT NULL,
  `cust_photo` varchar(255) DEFAULT NULL,
  `cust_promotional_offer` varchar(45) DEFAULT NULL,
  `cust_status` int(100) DEFAULT '1',
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_customer`
--


--
-- Table structure for table `sb_debug`
--

CREATE TABLE `sb_debug` (
  `debug_id` int(11) NOT NULL AUTO_INCREMENT,
  `debug_student_pk_id` int(11) NOT NULL,
  `debug_student_name` varchar(255) NOT NULL,
  `debug_guardian_name` varchar(255) NOT NULL,
  `debug_guardian_email` varchar(255) NOT NULL,
  `debug_subject` mediumtext NOT NULL,
  `debug_message` mediumtext NOT NULL,
  `debug_for` varchar(255) NOT NULL,
  `debug_filename` varchar(255) NOT NULL,
  `debug_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`debug_id`),
  KEY `IDX_STUDENT_PK_ID` (`debug_student_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_debug`
--


--
-- Table structure for table `sb_department`
--

CREATE TABLE `sb_department` (
  `dep_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `department_name` varchar(250) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dep_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_department`
--

INSERT INTO `sb_department` VALUES (1,'Utility Department',1,'2023-02-25 05:33:26');

--
-- Table structure for table `sb_discipline_category`
--

CREATE TABLE `sb_discipline_category` (
  `discipline_category_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `discipline_category_name` varchar(555) DEFAULT NULL,
  `discipline_category_added_by` int(11) DEFAULT NULL,
  `discipline_category_added_datetime` datetime DEFAULT NULL,
  `discipline_category_update_by` int(11) DEFAULT NULL,
  `eventfeed_update_datetime` datetime DEFAULT NULL,
  `status` enum('1','2','3') DEFAULT NULL,
  PRIMARY KEY (`discipline_category_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_category`
--

INSERT INTO `sb_discipline_category` VALUES (1,'Zero-Tolerance Activities',363,'2022-10-10 12:39:49',NULL,NULL,'1'),(2,'Other Violations',808,'2022-10-10 14:34:38',NULL,NULL,'1');

--
-- Table structure for table `sb_discipline_incident`
--

CREATE TABLE `sb_discipline_incident` (
  `di_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `di_activity` int(11) DEFAULT NULL,
  `di_added_by` int(11) DEFAULT NULL,
  `di_added_datetime` datetime DEFAULT NULL,
  `di_datetime` datetime DEFAULT NULL,
  `di_category_id` int(11) DEFAULT NULL,
  `di_sub_category_id` int(11) DEFAULT NULL,
  `di_location` varchar(255) DEFAULT NULL,
  `di_remark` varchar(1000) DEFAULT NULL,
  `di_status` int(11) DEFAULT NULL,
  `di_fine_status` int(11) DEFAULT NULL,
  `di_fine_amount` int(11) DEFAULT NULL,
  PRIMARY KEY (`di_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_incident`
--

INSERT INTO `sb_discipline_incident` VALUES (1,1,363,'2022-11-14 11:54:37','2022-11-14 11:53:15',1,2,'Near BBlock','dfsgzfsfdgs',1,1,NULL);

--
-- Table structure for table `sb_discipline_incident_images`
--

CREATE TABLE `sb_discipline_incident_images` (
  `di_img_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `di_img_di_fk_id` int(11) DEFAULT NULL,
  `di_img_file_name` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`di_img_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_incident_images`
--


--
-- Table structure for table `sb_discipline_incident_st_details`
--

CREATE TABLE `sb_discipline_incident_st_details` (
  `dist_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dist_di_fk_id` int(11) DEFAULT NULL,
  `dist_fk_student_detail_id` int(11) DEFAULT NULL,
  `dist_fk_student_id` int(11) DEFAULT NULL,
  `dist_student_admission_no` varchar(100) DEFAULT NULL,
  `dist_student_name` varchar(255) DEFAULT NULL,
  `dist_inc_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`dist_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_incident_st_details`
--

INSERT INTO `sb_discipline_incident_st_details` VALUES (1,1,6303,6302,'12815','SHEIKH SARFARAJ  AHMED',1),(2,1,4485,4485,'11234','SANJEEV KUMAR SAHANI',1);

--
-- Table structure for table `sb_discipline_parent_meeting_counselling`
--

CREATE TABLE `sb_discipline_parent_meeting_counselling` (
  `pmcoun_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pmcoun_fk_pmd_id` int(11) DEFAULT NULL,
  `pmcoun_fk_student_id` int(11) DEFAULT NULL,
  `pmcoun_fk_incident_id` int(11) DEFAULT NULL,
  `pmcoun_counselling_status` int(11) DEFAULT NULL,
  `pmcoun_added_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`pmcoun_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_parent_meeting_counselling`
--


--
-- Table structure for table `sb_discipline_parent_meeting_details`
--

CREATE TABLE `sb_discipline_parent_meeting_details` (
  `pmd_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pmd_fk_student_id` int(11) DEFAULT NULL,
  `pmd_informed_to` varchar(555) DEFAULT NULL,
  `pmd_informed_medium` varchar(555) DEFAULT NULL,
  `pmd_m_date_time` datetime DEFAULT NULL,
  `pmd_added_by` int(11) DEFAULT NULL,
  `pmd_added_datetime` datetime DEFAULT NULL,
  `pmd_visited_datetime` datetime DEFAULT NULL,
  `pmd_status` int(11) DEFAULT NULL,
  `pmd_remark` varchar(1000) DEFAULT NULL,
  `pmd_fk_incident_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`pmd_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_parent_meeting_details`
--

INSERT INTO `sb_discipline_parent_meeting_details` VALUES (1,6302,'1,4','1','2022-11-14 11:56:07',363,'2022-11-14 11:56:25',NULL,1,'efgds',1);

--
-- Table structure for table `sb_discipline_parent_meeting_scheduling`
--

CREATE TABLE `sb_discipline_parent_meeting_scheduling` (
  `pmscheduling_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pmscheduling_fk_pmd_id` int(11) DEFAULT NULL,
  `pmscheduling_fk_student_id` int(11) DEFAULT NULL,
  `pmscheduling_fk_incident_id` int(11) DEFAULT NULL,
  `pmscheduling_visit_status` int(11) DEFAULT NULL,
  `pmscheduling_added_datetime_vist` datetime DEFAULT NULL,
  `pmscheduling_coun_status` int(11) DEFAULT NULL,
  `pmscheduling_coun_com_datetime` datetime DEFAULT NULL,
  `pmscheduling_scsus_status` int(11) DEFAULT NULL,
  `pmscheduling_scsus_from` date DEFAULT NULL,
  `pmscheduling_scsus_to` date DEFAULT NULL,
  `pmscheduling_trsus_status` int(11) DEFAULT NULL,
  `pmscheduling_trsus_from` date DEFAULT NULL,
  `pmscheduling_trsus_to` date DEFAULT NULL,
  `pmscheduling_hos_status` int(11) DEFAULT NULL,
  `pmscheduling_hos_from` date DEFAULT NULL,
  `pmscheduling_hos_to` date DEFAULT NULL,
  `pmscheduling_finalwarn_status` int(11) DEFAULT NULL,
  `pmscheduling_finalwarn_datetime` datetime DEFAULT NULL,
  `pmscheduling_gadget_status` int(11) DEFAULT NULL,
  `pmscheduling_gadget_datetime` datetime DEFAULT NULL,
  `pmscheduling_couns_completed_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pmscheduling_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_parent_meeting_scheduling`
--


--
-- Table structure for table `sb_discipline_parent_meeting_status`
--

CREATE TABLE `sb_discipline_parent_meeting_status` (
  `pms_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pms_fk_pmd_id` int(11) DEFAULT NULL,
  `pms_fk_student_id` int(11) DEFAULT NULL,
  `pms_added_by_name` varchar(555) DEFAULT NULL,
  `pms_added_by_id` int(11) DEFAULT NULL,
  `pms_added_visit_status` int(11) DEFAULT NULL,
  `pms_counsling_status` int(11) DEFAULT NULL,
  `pms_undertaking_status` int(11) DEFAULT NULL,
  `pms_sc_suspension_status` int(11) DEFAULT NULL,
  `pms_sc_suspension_from` date DEFAULT NULL,
  `pms_sc_suspension_to` date DEFAULT NULL,
  `pms_tr_suspension_status` int(11) DEFAULT NULL,
  `pms_tr_suspension_from` date DEFAULT NULL,
  `pms_tr_suspension_to` date DEFAULT NULL,
  `pms_hos_suspension_status` int(11) DEFAULT NULL,
  `pms_hos_suspension_from` date DEFAULT NULL,
  `pms_hos_suspension_to` date DEFAULT NULL,
  `pms_penality_status` int(11) DEFAULT NULL,
  `pms_final_warning_status` int(11) DEFAULT NULL,
  `pms_gadget_status` int(11) DEFAULT NULL,
  `pms_added_datetime` datetime DEFAULT NULL,
  `pms_fk_incident_id` int(11) DEFAULT NULL,
  `pms_status_stage` int(11) DEFAULT NULL,
  `pms_vist_previous_status` int(11) DEFAULT NULL,
  `pms_couns_previous_status` int(11) DEFAULT NULL,
  `pms_scsus_previous_status` int(11) DEFAULT NULL,
  `pms_trsus_previous_status` int(11) DEFAULT NULL,
  `pms_hossus_previous_status` int(11) DEFAULT NULL,
  `pms_file_input` varchar(1000) DEFAULT NULL,
  `pms_remark` text,
  `pms_finalwarn_previous_status` int(11) DEFAULT NULL,
  `pms_congadget_previous_status` int(11) DEFAULT NULL,
  `pms_undrtakt_previous_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`pms_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_parent_meeting_status`
--


--
-- Table structure for table `sb_discipline_parent_meeting_undertaking`
--

CREATE TABLE `sb_discipline_parent_meeting_undertaking` (
  `pmunder_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pmunder_fk_pmd_id` int(11) DEFAULT NULL,
  `pmunder_fk_student_id` int(11) DEFAULT NULL,
  `pmunder_fk_incident_id` int(11) DEFAULT NULL,
  `pmunder_file_input` varchar(1000) DEFAULT NULL,
  `pmunder_undertaking_status` int(11) DEFAULT NULL,
  `pmunder_status` int(11) DEFAULT NULL,
  `pmunder_added_datetime` datetime DEFAULT NULL,
  `pmunder_verified_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pmunder_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_parent_meeting_undertaking`
--


--
-- Table structure for table `sb_discipline_sub_category`
--

CREATE TABLE `sb_discipline_sub_category` (
  `discipline_sub_category_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `discipline_sub_category_fk_cat_id` int(11) DEFAULT NULL,
  `discipline_sub_category_payment_id` int(11) DEFAULT NULL,
  `discipline_sub_category_name` varchar(555) DEFAULT NULL,
  `discipline_sub_category_added_by` int(11) DEFAULT NULL,
  `discipline_sub_category_added_datetime` datetime DEFAULT NULL,
  `discipline_sub_category_update_by` int(11) DEFAULT NULL,
  `sub_category_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`discipline_sub_category_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_sub_category`
--

INSERT INTO `sb_discipline_sub_category` VALUES (1,1,NULL,'Intoxication Substances or Tobacco-related products (Use/Distribution/Possession/Sale)',363,'2022-10-10 12:41:17',363,5),(2,1,NULL,'Intoxication Substances or Tobacco-related products (Use/Distribution/Possession/Sale)',363,'2022-10-10 12:41:17',NULL,1),(3,1,NULL,'Weapons, Sharp Objects, Fireworks & etc.',363,'2022-10-10 12:41:38',NULL,1),(4,1,NULL,'Verbal Abuses or Fights - With other students or members',363,'2022-10-10 12:41:53',NULL,1),(5,1,NULL,'Bullying, Cyber-Bullying or Ragging any student',363,'2022-10-10 12:42:08',NULL,1),(6,1,NULL,'Harassment of any student',363,'2022-10-10 14:22:03',NULL,1),(7,1,NULL,'Harassment of any student',363,'2022-10-10 14:22:03',363,5),(8,1,NULL,'Damage to School Property',363,'2022-10-10 14:23:02',NULL,1),(9,1,NULL,'Carrying Phones, Electronic Devices to School/Hostel',363,'2022-10-10 14:23:18',NULL,1),(10,1,NULL,'Unpermitted Exit from the school',363,'2022-10-10 14:23:45',NULL,1),(11,1,NULL,'Any kind of theft, Forgery or Malpractice',363,'2022-10-10 14:24:04',NULL,1),(12,1,NULL,'Misrepresenting or Defaming School - in Any Social/Digital Forum',363,'2022-10-10 14:25:27',NULL,1),(13,1,NULL,'Intending or Causing Harm to safety of other students or staff',363,'2022-10-10 14:26:43',NULL,1),(14,1,NULL,'Misusing School Devices - Illegal or Not age appropriate Digital Activities',363,'2022-10-10 14:27:00',NULL,1),(15,2,NULL,'Violation of School Entry & Exit Discipline Protocols',363,'2022-10-10 14:27:56',NULL,1),(16,2,NULL,'Violation of School Transport Protocols',363,'2022-10-10 14:28:50',NULL,1),(17,2,NULL,'Violation of Discipline in School Premises or Classroom or any other facility',363,'2022-10-10 14:29:41',NULL,1),(18,2,NULL,'Academic or Examination Discipline',363,'2022-10-10 14:29:55',NULL,1),(19,2,NULL,'Student Dress Code Violations',363,'2022-10-10 14:30:30',NULL,1);

--
-- Table structure for table `sb_discipline_violation`
--

CREATE TABLE `sb_discipline_violation` (
  `divi_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `divi_fk_class_id` varchar(1000) DEFAULT NULL,
  `divi_fk_cat_id` int(11) DEFAULT NULL,
  `divi_fk_sub_cat_id` int(11) DEFAULT NULL,
  `divi_coun_req1` int(11) DEFAULT NULL,
  `divi_coun_type1` int(11) DEFAULT NULL,
  `divi_under_req1` int(11) DEFAULT NULL,
  `divi_sc_sus_req1` int(11) DEFAULT NULL,
  `divi_sch_sus_days1` varchar(255) DEFAULT NULL,
  `divi_tr_sus_req1` int(11) DEFAULT NULL,
  `divi_tr_sus_days1` varchar(255) DEFAULT NULL,
  `divi_imp_penality1` int(11) DEFAULT NULL,
  `divi_pen_amount1` int(11) DEFAULT NULL,
  `divi_final_warn1` int(11) DEFAULT NULL,
  `divi_war_note1` varchar(1000) DEFAULT NULL,
  `divi_conf_gadget_req1` int(11) DEFAULT NULL,
  `divi_conf_type1` int(11) DEFAULT NULL,
  `divi_emp_id_fk1` varchar(1000) DEFAULT NULL,
  `divi_remark1` varchar(1000) DEFAULT NULL,
  `divi_coun_req2` int(11) DEFAULT NULL,
  `divi_coun_type2` int(11) DEFAULT NULL,
  `divi_under_req2` int(11) DEFAULT NULL,
  `divi_sc_sus_req2` int(11) DEFAULT NULL,
  `divi_sch_sus_days2` varchar(255) DEFAULT NULL,
  `divi_tr_sus_req2` int(11) DEFAULT NULL,
  `divi_tr_sus_days2` varchar(255) DEFAULT NULL,
  `divi_imp_penality2` int(11) DEFAULT NULL,
  `divi_pen_amount2` int(11) DEFAULT NULL,
  `divi_final_warn2` int(11) DEFAULT NULL,
  `divi_war_note2` varchar(1000) DEFAULT NULL,
  `divi_conf_gadget_req2` int(11) DEFAULT NULL,
  `divi_conf_type2` int(11) DEFAULT NULL,
  `divi_emp_id_fk2` varchar(1000) DEFAULT NULL,
  `divi_remark2` varchar(1000) DEFAULT NULL,
  `divi_coun_req3` int(11) DEFAULT NULL,
  `divi_coun_type3` int(11) DEFAULT NULL,
  `divi_under_req3` int(11) DEFAULT NULL,
  `divi_sc_sus_req3` int(11) DEFAULT NULL,
  `divi_sch_sus_days3` varchar(255) DEFAULT NULL,
  `divi_tr_sus_req3` int(11) DEFAULT NULL,
  `divi_tr_sus_days3` varchar(255) DEFAULT NULL,
  `divi_imp_penality3` int(11) DEFAULT NULL,
  `divi_pen_amount3` int(11) DEFAULT NULL,
  `divi_final_warn3` int(11) DEFAULT NULL,
  `divi_war_note3` varchar(1000) DEFAULT NULL,
  `divi_conf_gadget_req3` int(11) DEFAULT NULL,
  `divi_conf_type3` int(11) DEFAULT NULL,
  `divi_emp_id_fk3` varchar(1000) DEFAULT NULL,
  `divi_remark3` varchar(1000) DEFAULT NULL,
  `divi_added_by` int(11) DEFAULT NULL,
  `divi_added_datetime` datetime DEFAULT NULL,
  `divi_status` int(11) DEFAULT NULL,
  `divi_hos_sus_days1` int(11) DEFAULT NULL,
  `divi_hos_sus_days2` int(11) DEFAULT NULL,
  `divi_hos_sus_days3` int(11) DEFAULT NULL,
  `divi_hos_sus_req1` int(11) DEFAULT NULL,
  `divi_hos_sus_req2` int(11) DEFAULT NULL,
  `divi_hos_sus_req3` int(11) DEFAULT NULL,
  PRIMARY KEY (`divi_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_discipline_violation`
--

INSERT INTO `sb_discipline_violation` VALUES (1,'7',1,2,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,2,'',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 15:04:19',1,0,0,0,2,2,2),(2,'8',1,2,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,2,'',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 15:04:19',1,0,0,0,2,2,2),(3,'9',1,2,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,2,'',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 15:04:19',1,0,0,0,2,2,2),(4,'7',1,3,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:22:59',1,0,0,0,2,2,2),(5,'8',1,3,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:22:59',1,0,0,0,2,2,2),(6,'9',1,3,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:22:59',1,0,0,0,2,2,2),(7,'7',1,3,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:22:59',5,0,0,0,2,2,2),(8,'8',1,3,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:22:59',5,0,0,0,2,2,2),(9,'9',1,3,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:22:59',5,0,0,0,2,2,2),(10,'7',1,4,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,2,'',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:39:40',1,0,0,0,2,2,2),(11,'8',1,4,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,2,'',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:39:40',1,0,0,0,2,2,2),(12,'9',1,4,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,2,'',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-10 16:39:40',1,0,0,0,2,2,2),(13,'7',1,5,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-11 10:33:56',1,0,0,0,2,2,2),(14,'8',1,5,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-11 10:33:56',1,0,0,0,2,2,2),(15,'9',1,5,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-11 10:33:56',1,0,0,0,2,2,2),(16,'7',1,6,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-11 10:36:48',1,0,0,0,2,2,2),(17,'8',1,6,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-11 10:36:48',1,0,0,0,2,2,2),(18,'9',1,6,1,1,2,2,'',2,'',2,0,2,'',2,1,NULL,'',1,3,1,2,'',2,'',2,0,1,'Your behavior has violated the standard code of conduct established by the school.Please make sure you do not involve yourself in any further issues misconduct as the organization will be forced to take disciplinary action against you.',2,1,NULL,'',1,2,2,1,'3',2,'',1,2500,2,'',2,1,NULL,'',363,'2022-10-11 10:36:48',1,0,0,0,2,2,2);

--
-- Table structure for table `sb_document_publisher`
--

CREATE TABLE `sb_document_publisher` (
  `doc_id` int(255) NOT NULL AUTO_INCREMENT,
  `doc_title` varchar(255) DEFAULT NULL,
  `doc_desc` text,
  `doc_file_path` varchar(255) DEFAULT NULL,
  `doc_remark` varchar(255) DEFAULT NULL,
  `doc_date` datetime DEFAULT NULL,
  `doc_publish_status` int(11) DEFAULT '0',
  `doc_type` int(11) DEFAULT '1',
  `doc_stud_type` varchar(45) DEFAULT NULL,
  `doc_schedule_publishing` int(11) DEFAULT '0',
  `doc_publish_by` int(11) DEFAULT NULL,
  `doc_publish_date` datetime DEFAULT NULL,
  `doc_added_by` int(11) DEFAULT NULL,
  `doc_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `doc_number` varchar(255) DEFAULT '0',
  PRIMARY KEY (`doc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_document_publisher`
--


--
-- Table structure for table `sb_document_publisher_classes`
--

CREATE TABLE `sb_document_publisher_classes` (
  `doc_cls_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `doc_fk_id` int(255) DEFAULT NULL,
  `doc_cls_fk_id` int(255) DEFAULT NULL,
  `doc_sec_fk_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`doc_cls_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_document_publisher_classes`
--


--
-- Table structure for table `sb_document_publisher_files`
--

CREATE TABLE `sb_document_publisher_files` (
  `dpf_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dpf_doc_id` int(11) DEFAULT NULL,
  `dpf_tittle` text,
  `dpf_file_name` text,
  PRIMARY KEY (`dpf_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_document_publisher_files`
--


--
-- Table structure for table `sb_document_publisher_log`
--

CREATE TABLE `sb_document_publisher_log` (
  `dpl_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dpl_doc_id` int(11) DEFAULT NULL,
  `dpl_doc_type` varchar(255) DEFAULT NULL,
  `dpl_added_by` int(11) DEFAULT NULL,
  `dpl_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dpl_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_document_publisher_log`
--


--
-- Table structure for table `sb_document_publisher_section`
--

CREATE TABLE `sb_document_publisher_section` (
  `doc_sec_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_sec_doc_fk_id` int(11) DEFAULT NULL,
  `doc_sec_class_fk_id` int(11) DEFAULT NULL,
  `doc_sec_section_fk_id` int(11) DEFAULT NULL,
  `doc_sec_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`doc_sec_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_document_publisher_section`
--


--
-- Table structure for table `sb_document_publisher_student`
--

CREATE TABLE `sb_document_publisher_student` (
  `doc_stud_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `doc_stud_doc_fk_id` int(11) DEFAULT NULL,
  `doc_stud_student_fk_id` int(11) DEFAULT NULL,
  `doc_stud_added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`doc_stud_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_document_publisher_student`
--


--
-- Table structure for table `sb_document_publisher_student_download`
--

CREATE TABLE `sb_document_publisher_student_download` (
  `docactivityview_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `docactivityview_student_id` int(11) DEFAULT NULL,
  `docactivityview_document_id` int(11) DEFAULT NULL,
  `docactivityview_is_view` int(11) DEFAULT '0',
  `docactivityview_status` int(11) DEFAULT '1',
  `docactivityview_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`docactivityview_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_document_publisher_student_download`
--


--
-- Table structure for table `sb_document_publisher_student_view`
--

CREATE TABLE `sb_document_publisher_student_view` (
  `docactivityview_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `docactivityview_student_id` int(11) DEFAULT NULL,
  `docactivityview_document_id` int(11) DEFAULT NULL,
  `docactivityview_is_view` int(11) DEFAULT '0',
  `docactivityview_status` int(11) DEFAULT '1',
  `docactivityview_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`docactivityview_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_document_publisher_student_view`
--


--
-- Table structure for table `sb_doubt_clearning_schedule`
--

CREATE TABLE `sb_doubt_clearning_schedule` (
  `ds_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ds_doubt_id` int(11) DEFAULT NULL,
  `ds_meet_date` date DEFAULT NULL,
  `ds_meet_start_time` time DEFAULT NULL,
  `ds_meet_end_time` time DEFAULT NULL,
  `ds_meet_mode` int(11) DEFAULT NULL,
  `ds_meet_link` varchar(2000) DEFAULT NULL,
  `ds_meet_id` varchar(1000) DEFAULT NULL,
  `ds_meet_code` varchar(1500) DEFAULT NULL,
  `ds_added_by` int(11) DEFAULT '0',
  `ds_added_dateime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ds_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_doubt_clearning_schedule`
--


--
-- Table structure for table `sb_doubt_clearning_schedule_student`
--

CREATE TABLE `sb_doubt_clearning_schedule_student` (
  `dss_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dss_schedule_id` int(11) DEFAULT NULL,
  `dss_doubt_id` int(11) DEFAULT NULL,
  `dss_student_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`dss_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_doubt_clearning_schedule_student`
--


--
-- Table structure for table `sb_dought_clearning_discussion`
--

CREATE TABLE `sb_dought_clearning_discussion` (
  `dcd_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dcd_dought_id` int(11) DEFAULT NULL,
  `dcd_student_id` int(11) DEFAULT '0',
  `dcd_user_id` int(11) DEFAULT '0',
  `dcd_type` int(11) DEFAULT '0',
  `dcd_message` varchar(1000) DEFAULT NULL,
  `dcd_file_name_camera` varchar(1000) DEFAULT NULL,
  `dcd_file_name_upload` varchar(1000) DEFAULT NULL,
  `dcd_file_name_voice` varchar(1000) DEFAULT NULL,
  `dcd_read_unread` int(11) DEFAULT '0',
  `dcd_datetime` varchar(45) DEFAULT 'CURRENT_TIMESTAMP',
  PRIMARY KEY (`dcd_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_dought_clearning_discussion`
--

INSERT INTO `sb_dought_clearning_discussion` VALUES (1,1,3333,529,1,'Hello','','','',0,'2022-05-31 15:23:26');

--
-- Table structure for table `sb_dought_clearning_file`
--

CREATE TABLE `sb_dought_clearning_file` (
  `dcf_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dcf_dought_id` int(11) DEFAULT NULL,
  `dcf_file_text` varchar(255) DEFAULT NULL,
  `dcf_file_name` varchar(1500) DEFAULT NULL,
  `dcf_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dcf_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_dought_clearning_file`
--

INSERT INTO `sb_dought_clearning_file` VALUES (1,5,'Attachment 1','image201768747639651231679782.jpg','2022-10-07 12:31:49');

--
-- Table structure for table `sb_dought_clearning_manage`
--

CREATE TABLE `sb_dought_clearning_manage` (
  `dcm_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dcm_student_id` int(11) DEFAULT NULL,
  `dcm_subject_id` int(11) DEFAULT NULL,
  `dcm_chapter_id` int(11) DEFAULT NULL,
  `dcm_tittle` varchar(1000) DEFAULT NULL,
  `dcm_description` varchar(1500) DEFAULT NULL,
  `dcm_status` int(11) DEFAULT '0',
  `dcm_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `dcm_rate` varchar(45) DEFAULT NULL,
  `dcm_remark` varchar(1000) DEFAULT NULL,
  `dcm_rr_datetime` datetime DEFAULT NULL,
  `dcm_solve_by` int(11) DEFAULT '0',
  `dcm_solve_date` datetime DEFAULT NULL,
  `dcm_rej_remark` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`dcm_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_dought_clearning_manage`
--

INSERT INTO `sb_dought_clearning_manage` VALUES (1,3333,1,17822,'How many types of Tenses are there?','',2,'2022-05-31 15:22:31',NULL,NULL,NULL,0,NULL,NULL),(2,1539,3,17844,'What is the meaning of metalloids ?','',2,'2022-08-24 19:48:40',NULL,NULL,NULL,0,NULL,NULL),(3,1633,3,17850,'Composition of matter','',2,'2022-09-05 14:26:10',NULL,NULL,NULL,0,NULL,NULL),(4,1318,1,7345,'Q/A','',2,'2022-09-22 23:34:18',NULL,NULL,NULL,0,NULL,NULL),(5,1234,30,3703,'List out some possible ways by which soil erosion can be prevented in your area by using 3Rs (reduce reuse recycle) concept.','We know how to conserve soil or prevent soil erosion by the methods like \r\nCrop cover \r\nbuilding embankments\r\n terrace farming\r\n afforestation\r\nETC\r\nBut when it comes to prevent soil erosion by 3rs concept.I can\'t find any of the ways because I think 3rs  is used to recycle something like papers,jars etc..\r\nMy DOUBT is how can we prevent soil erosion by 3Rs method.\r\nKindly clarify my doubt\r\n',2,'2022-10-07 12:31:49',NULL,NULL,NULL,0,NULL,NULL),(6,2413,3,12370,'Colloidal solution ','Name the type of colloid in the following and mention the DP and DM in it. Blood and fug.',2,'2022-10-10 16:38:21',NULL,NULL,NULL,0,NULL,NULL),(7,1030,28,3805,'Answer 5ye following questions ','Mam we have to write the  1 no. as you told or have to do all of them or we have to write the the mcq',2,'2022-10-15 19:23:20',NULL,NULL,NULL,0,NULL,NULL),(8,1159,45,3895,'study notes','can you please send the study note because i was absent in a class',2,'2022-10-18 15:00:16',NULL,NULL,NULL,0,NULL,NULL),(9,3351,28,17701,'Q/A','Why does it start raining in India from june',2,'2022-10-25 13:18:07',NULL,NULL,NULL,0,NULL,NULL),(10,2173,2,10791,'SNELL\'S LAW','I can\'t understand the 2nd point of SNELL\'S LAW.  \r\nWhat is sine of angle of incidence and refraction why sine is used in this ?',2,'2022-11-01 20:04:50',NULL,NULL,NULL,0,NULL,NULL),(11,6005,2,16063,'Work energy theroem','I have doubt in derivation of work energy theorem\r\n',2,'2022-11-04 06:42:34',NULL,NULL,NULL,0,NULL,NULL),(12,6244,3,16180,'Chemical bonding','Please clear doubt',2,'2022-11-09 22:00:23',NULL,NULL,NULL,0,NULL,NULL);

--
-- Table structure for table `sb_dought_clearning_mode`
--

CREATE TABLE `sb_dought_clearning_mode` (
  `dcmm_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dcmm_class_mode` varchar(1000) DEFAULT NULL,
  `dcmm_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dcmm_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_dought_clearning_mode`
--


--
-- Table structure for table `sb_dought_clearning_status`
--

CREATE TABLE `sb_dought_clearning_status` (
  `dcs_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `dcs_status` varchar(255) DEFAULT NULL,
  `dcs_color` varchar(255) DEFAULT NULL,
  `dcs_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dcs_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_dought_clearning_status`
--

INSERT INTO `sb_dought_clearning_status` VALUES (1,'Solved','#1BA0E1','2021-07-28 11:05:48'),(2,'Pending','#FDB912','2021-07-28 11:05:48'),(3,'Verified','#008A00','2021-07-28 11:05:48'),(4,'Rejected','#E41300','2021-07-28 11:05:49'),(5,'Not Verified','#647585','2021-08-16 18:54:39');

--
-- Table structure for table `sb_download_logs`
--

CREATE TABLE `sb_download_logs` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_fk_student_details_id` int(11) NOT NULL,
  `log_type` enum('study','homework') NOT NULL,
  `log_fk_table_id` int(11) NOT NULL COMMENT 'primary key of homework or study material table',
  `log_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_download_logs`
--


--
-- Table structure for table `sb_educational_years`
--

CREATE TABLE `sb_educational_years` (
  `edu_year_id` int(11) NOT NULL AUTO_INCREMENT,
  `edu_year` varchar(255) DEFAULT NULL,
  `edu_status` int(1) NOT NULL DEFAULT '1',
  `edu_active_session` int(1) NOT NULL DEFAULT '0',
  `edu_payemnt_active` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`edu_year_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_educational_years`
--

INSERT INTO `sb_educational_years` VALUES (5,'2020-2021',1,0,0),(6,'2021-2022',1,0,1),(7,'2022-2023',1,0,1),(8,'2023-2024',1,1,1),(9,'2024-2025',0,0,0),(10,'2025-2026',0,0,0),(11,'2026-2027',0,0,0),(12,'2027-2028',0,0,0),(13,'2028-2029',0,0,0),(14,'2029-2030',0,0,0);

--
-- Table structure for table `sb_email_template_admit_card`
--

CREATE TABLE `sb_email_template_admit_card` (
  `em_ta_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_admit_card_heading` varchar(45) DEFAULT NULL,
  `email_admit_card` text,
  `em_ta_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`em_ta_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_email_template_admit_card`
--

INSERT INTO `sb_email_template_admit_card` VALUES (1,'sdsfdf',' dsf sadsdsdsd ','3'),(2,'sdsdd',' sd  ','3'),(3,'Documentation Instruction','Carry All Necessary Materials. ...\r\nFollow the Instructions Carefully: ...\r\nRead the Question Paper Carefully: ...\r\nGetting Answer Sheet Signed by Invigilator. ...\r\nMake Strategy for Writing an Answer: ...\r\nManage Your Time: ...\r\nIgnore Other Test Takers: ...\r\nListen to Any Verbal Instructions.','3'),(4,'Admit Card Instruction','Point No. 1\r\n Point No. 2\r\n Point No. 3\r\n Point No. 4\r\n Point No. 5\r\n\r\n Point No. 1\r\n Point No. 2\r\n Point No. 3\r\n Point No. 4\r\n Point No. 5','3');

--
-- Table structure for table `sb_email_template_body`
--

CREATE TABLE `sb_email_template_body` (
  `em_tb_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_body_heading` varchar(45) DEFAULT NULL,
  `email_body_data` text,
  `em_tb_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`em_tb_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_email_template_body`
--

INSERT INTO `sb_email_template_body` VALUES (1,'dsfdf',' dfdfsdf','3'),(2,'test2',' ','3'),(3,'test32','  sdsa ','3'),(4,'test22','2 asdssadsdasdsasdsds\r\nsdsdsadsa','3'),(5,'Thankyou Email','Student Name:RICHA DAS\r\nStudent Admission NO.:12022\r\nStudent Class:VI\r\nStudent Section:A\r\nCategory:Suggestion & Feedback\r\nDescription:Please don\'t force to children to swim in winter season.\r\nStatus:Management Review Pending\r\nDate Time:2022-11-17 20:27:49','3'),(6,'Documentation Information','Dear Parent\'s/Student\'s,\r\nWe would request you to attend the event in ODM Public School','3'),(7,'Documentation Email Body','Dear Mr./Mrs. {Recipient’s Name},\r\n\r\nI am writing this letter to let you know that I am in need of a long-term leave. Thus, I would like to avail my full annual leave allotment as I have my complete yearly leave allowance.\r\n\r\nI request you to consider my leave application of thirty days as I am planning for an international vacation with my family. I would like to avail the leaves from {start date} to {end date}.','3'),(8,'Screening Process Information','Dear Parent\'s/Student\'s\r\n\r\nCongratulation you are eligible for Admission Process and we would request you to please attend screening process in the mentioned details :-','3'),(9,'Documentation Process Information','Dear Parent\'s/Student\'s\r\n\r\nCongratulation you are eligible for Admission Process and we would request you to please attend documentation process in the mentioned details :-','3'),(10,'Documentation Information -2','Dear Parent\'s / Student\'s\r\nyou are invited for documentation round','3'),(11,'Screening Process','Dear Parents / Students,\r\n\r\nGreetings of the day!\r\n\r\nThank you for showing interest towards ODM Educational Group. We are officially informing you that you have been selected for the screening process in ODM Educational Group. \r\nWe request you to kindly go through the below mentioned details.','1'),(12,'Documentation Email Body','Dear Parents / Students,\r\n\r\nGreetings of the day!\r\n\r\nWe are delighted to inform you that you have been selected for the further Admission Process in ODM Educational Group. We have  already sent you an email to upload all the relevant documents for the smooth admission process. \r\nWe would request you kindly complete the online documentation before you visit the school.','1');

--
-- Table structure for table `sb_email_template_heading`
--

CREATE TABLE `sb_email_template_heading` (
  `emth_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_heading` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`emth_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_email_template_heading`
--

INSERT INTO `sb_email_template_heading` VALUES (1,'test','3'),(2,'ddsfs','3'),(3,'test3','3'),(4,'sadsd','3'),(5,'Thankyou Mail','3'),(6,'Documentation Information','1'),(7,'Screening Process Information','1'),(8,'Documentation Information -2','3'),(9,'Baseline Test Information','3');

--
-- Table structure for table `sb_email_template_instruction`
--

CREATE TABLE `sb_email_template_instruction` (
  `em_ti_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_instruction_heading` varchar(45) DEFAULT NULL,
  `email_instruction` text,
  `em_ti_status` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`em_ti_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_email_template_instruction`
--

INSERT INTO `sb_email_template_instruction` VALUES (1,'sd','sdfs sad\r sadsd\r sadsd','3'),(2,'test msg','da dsf\r dsfdsfddsf\r dsf','2'),(3,'Thanku mails','Student Name:RICHA DAS\r Student Admission NO.:12022\r Student Class:VI\r Student Section:A\r Category:Suggestion & Feedback\r Description:Please don\'t force to children to swim in winter season.\r Status:Management Review Pending\r Date Time:2022-11-17 20:27:...','3'),(4,'thankyou','1. The alarm code is 7957. Don\'t forget to set it when you go out and remember to turn it off when you get back home as it is LOUD!\r\n 2.The rabbits need feeding once a day and under no circumstances should they be allowed out of their cage in the garden a...','2'),(5,'Documentation Information','-Carry All Necessary Materials. ...\r -Follow the Instructions Carefully: ...\r -Read the Question Paper Carefully: ...\r -Getting Answer Sheet Signed by Invigilator. ...\r -Make Strategy for Writing an Answer: ...\r -Manage Your Time: ...\r -Ignore Other Test...','1'),(6,'Documentation Email Body Instruction','Point No. 1\r  Point No. 2\r  Point No. 3\r  Point No. 4\r  Point No. 5\r \r  Point No. 1\r  Point No. 2\r  Point No. 3\r  Point No. 4\r  Point No. 5','1'),(7,'Screening Process (Email Instruction)','1. Students are requested to reach venue on mentioned date & time.\r\n2. No Mobile Phones are allowed.\r\n3. Screening Process will take place for 15 min.\r\n4. It is a one on one process.','1'),(8,'Documentation Process (Email Information)','1. Students are requested to reach venue on mentioned date & time.\r\n2. No Mobile Phones are allowed.\r\n3. Screening Process will take place for 15 min.\r\n4. It is a one on one process.','1'),(9,'Documentation Related Instruction','Documentation Related Instruction -1\r Documentation Related Instruction -2\r Documentation Related Instruction -3','1'),(10,'Screening Process  Email Information','For any queries please feel free to reach out to :-\r\nContact : 1800-120-2316\r\nEmail : admission@odmegroup.org \r\n\r\nThanks & Regards\r\nODM Educational Group.','1'),(11,'Documentation Email Instruction','For any queries please feel free to reach out to :-\r\nContact : 1800-120-2316\r\nEmail : admission@odmegroup.org \r\n\r\nThanks & Regards\r\nODM Educational Group.','1');

--
-- Table structure for table `sb_email_template_manager`
--

CREATE TABLE `sb_email_template_manager` (
  `em_tm_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `email_template_name` varchar(45) DEFAULT NULL,
  `em_heading_fk_id` int(11) DEFAULT NULL,
  `em_body_fk_id` int(11) DEFAULT NULL,
  `em_instruction_fk_id` int(11) DEFAULT NULL,
  `em_admit_card_fk_id` int(11) DEFAULT NULL,
  `em_tm_status` varchar(45) DEFAULT NULL,
  `em_card_required` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`em_tm_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_email_template_manager`
--

INSERT INTO `sb_email_template_manager` VALUES (4,'Documentation Email',5,5,7,4,'3','No'),(14,'Screening Process Template ',7,11,7,0,'3','No'),(15,'Documentation Email Template 1',8,10,9,4,'1','No'),(16,'Baseline Test',6,7,7,4,'1','Yes'),(21,'Testing Documentation Email Template',6,12,11,0,'1','No'),(22,'Testing Document Email Template',6,12,11,0,'3','No'),(23,'Screening Template - 4',7,11,10,0,'1','No'),(24,'Screening Process',7,11,7,0,'1','No');

--
-- Table structure for table `sb_emp_attendance`
--

CREATE TABLE `sb_emp_attendance` (
  `emp_attendance_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_attendance_fk_user_id` int(11) NOT NULL,
  `emp_attendance_ymd_date` date DEFAULT NULL,
  `emp_attendance_date` int(11) DEFAULT NULL,
  `emp_attendance_month` varchar(255) DEFAULT NULL,
  `emp_attendance_year` int(11) DEFAULT NULL,
  `emp_attendance_attendance` int(11) DEFAULT NULL,
  `emp_attendance_remark` varchar(255) DEFAULT NULL,
  `emp_attendance_status` int(11) DEFAULT NULL,
  `emp_attendance_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `emp_attendance_in` time DEFAULT NULL,
  `emp_attendance_out` time DEFAULT NULL,
  `emp_attendance_ptime` time DEFAULT NULL,
  `emp_attendance_manual` enum('0','1','2') NOT NULL DEFAULT '0' COMMENT '0=>In time from ifid entry, 1=>In time not from rfid, its time when marked as P/PA, 2=>Employee attendace marked as absent but rfid detected later',
  `emp_attendance_lat_in` varchar(255) DEFAULT NULL,
  `emp_attendance_lang_in` varchar(255) DEFAULT NULL,
  `emp_attendance_IMEI_in` varchar(255) DEFAULT NULL,
  `emp_attendace_accuracy_in` varchar(10) DEFAULT NULL,
  `emp_attendance_lat_out` varchar(255) DEFAULT NULL,
  `emp_attendance_lang_out` varchar(255) DEFAULT NULL,
  `emp_attendance_IMEI_out` varchar(255) DEFAULT NULL,
  `emp_attendace_accuracy_out` varchar(10) DEFAULT NULL,
  `emp_selfie_in` varchar(255) DEFAULT NULL,
  `emp_selfie_out` varchar(255) DEFAULT NULL,
  `emp_loaction_in` mediumtext,
  `emp_location_out` mediumtext,
  PRIMARY KEY (`emp_attendance_pk_id`),
  KEY `IDX_DATE` (`emp_attendance_ymd_date`),
  KEY `IDX_MONTH` (`emp_attendance_month`),
  KEY `IDX_Search` (`emp_attendance_fk_user_id`,`emp_attendance_ymd_date`,`emp_attendance_date`,`emp_attendance_month`,`emp_attendance_year`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_emp_attendance`
--

INSERT INTO `sb_emp_attendance` VALUES (1,537,'2021-08-19',19,'August',2021,3,NULL,1,'2021-08-19 07:34:07','13:22:58',NULL,NULL,'0','','','web','50',NULL,NULL,NULL,NULL,'',NULL,'',NULL),(2,362,'2021-08-19',19,'August',2021,3,NULL,1,'2021-08-19 08:07:49','13:51:14',NULL,NULL,'0','16.7744507','74.2749683','web','50',NULL,NULL,NULL,NULL,'',NULL,'',NULL),(3,537,'2021-08-20',20,'August',2021,3,NULL,1,'2021-08-20 04:16:26','10:28:13',NULL,NULL,'0','19.0212708','75.0426789','web','50',NULL,NULL,NULL,NULL,'',NULL,'',NULL);

--
-- Table structure for table `sb_emp_department`
--

CREATE TABLE `sb_emp_department` (
  `dept_id` int(11) NOT NULL AUTO_INCREMENT,
  `dept_name` varchar(45) DEFAULT NULL,
  `dept_head` int(11) DEFAULT NULL,
  PRIMARY KEY (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_emp_department`
--


--
-- Table structure for table `sb_emp_group`
--

CREATE TABLE `sb_emp_group` (
  `eg_id` int(11) NOT NULL AUTO_INCREMENT,
  `eg_name` varchar(255) DEFAULT NULL,
  `eg_status` int(2) DEFAULT NULL,
  `eg_added_on` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`eg_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_emp_group`
--

INSERT INTO `sb_emp_group` VALUES (3,'Alpha',1,'2022-07-30 07:34:25');

--
-- Table structure for table `sb_emp_hoiliday_group`
--

CREATE TABLE `sb_emp_hoiliday_group` (
  `hg_id` int(255) NOT NULL AUTO_INCREMENT,
  `hg_name` varchar(255) DEFAULT NULL,
  `hg_description` varchar(255) DEFAULT NULL,
  `hg_status` int(100) DEFAULT NULL,
  PRIMARY KEY (`hg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_emp_hoiliday_group`
--


--
-- Table structure for table `sb_emp_holiday`
--

CREATE TABLE `sb_emp_holiday` (
  `emp_holiday_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_holiday_name` varchar(255) NOT NULL,
  `emp_holiday_start_date` date NOT NULL,
  `emp_holiday_end_date` date NOT NULL,
  `emp_holiday_image` varchar(255) DEFAULT NULL,
  `emp_holiday_group` int(255) DEFAULT NULL,
  PRIMARY KEY (`emp_holiday_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_emp_holiday`
--


--
-- Table structure for table `sb_employee_loan_master`
--

CREATE TABLE `sb_employee_loan_master` (
  `emp_master_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `emp_fk_id` int(255) DEFAULT NULL,
  `emp_loan_amount` varchar(255) DEFAULT NULL,
  `emp_tenure` varchar(255) DEFAULT NULL,
  `emp_deduction_month_year` varchar(255) DEFAULT NULL,
  `emp_fk_loan_type_id` int(255) DEFAULT NULL,
  `emp_loan_added_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`emp_master_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_employee_loan_master`
--


--
-- Table structure for table `sb_employee_loan_type`
--

CREATE TABLE `sb_employee_loan_type` (
  `emp_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `emp_loan_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`emp_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_employee_loan_type`
--

INSERT INTO `sb_employee_loan_type` VALUES (7,'Loan');

--
-- Table structure for table `sb_employee_notification`
--

CREATE TABLE `sb_employee_notification` (
  `employee_notification_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `request_date` timestamp NULL DEFAULT NULL,
  `receive_date` datetime DEFAULT NULL,
  `receive_lat` varchar(45) DEFAULT NULL,
  `receive_lang` varchar(45) DEFAULT NULL,
  `service_calling_time` timestamp NULL DEFAULT NULL,
  `emp_address` varchar(255) DEFAULT NULL,
  `net_receive_lat` varchar(45) DEFAULT NULL,
  `net_receive_lang` varchar(45) DEFAULT NULL,
  `net_emp_address` mediumtext,
  `net_emp_accuracy` varchar(10) DEFAULT NULL,
  `emp_accuracy` varchar(10) DEFAULT NULL,
  `request_status` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`employee_notification_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_employee_notification`
--


--
-- Table structure for table `sb_empolyee_loan_emi`
--

CREATE TABLE `sb_empolyee_loan_emi` (
  `emi_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `emi_emp_fk_id` int(11) DEFAULT NULL,
  `emi_loan_total_amout` varchar(45) DEFAULT NULL,
  `emi_date` datetime DEFAULT NULL,
  `emi_amount` varchar(45) DEFAULT NULL,
  `emi_receive_date` datetime DEFAULT NULL,
  `emi_receive_amount` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`emi_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_empolyee_loan_emi`
--


--
-- Table structure for table `sb_eoa_setting`
--

CREATE TABLE `sb_eoa_setting` (
  `eoa_setting_id` int(11) NOT NULL,
  `setting_name` varchar(45) DEFAULT NULL,
  `setting_value` varchar(45) DEFAULT NULL,
  `setting_addded_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`eoa_setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_eoa_setting`
--

INSERT INTO `sb_eoa_setting` VALUES (1,'custom_field_1','demo1','2018-12-12 11:27:49'),(2,'custom_field_2','','2018-12-12 11:27:49'),(3,'custom_field_3','','2018-12-12 11:27:49'),(4,'custom_field_4','demo4','2018-12-12 11:27:49'),(5,'custom_field_5','','2018-12-12 11:27:49'),(6,'custom_field_6','','2018-12-12 11:27:49'),(7,'custom_field_7','','2018-12-12 11:27:49'),(8,'custom_field_8','','2018-12-12 11:27:49'),(9,'custom_field_9','','2018-12-12 11:27:49'),(10,'custom_field_10','','2018-12-12 11:27:49');

--
-- Table structure for table `sb_eoa_status`
--

CREATE TABLE `sb_eoa_status` (
  `eoa_status_id` int(11) NOT NULL,
  `status_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`eoa_status_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_eoa_status`
--

INSERT INTO `sb_eoa_status` VALUES (1,'Active'),(2,'Inactive'),(3,'New'),(4,'Assigned'),(11,'Not Working'),(5,'Dmanaged'),(6,'Theft'),(7,'Sold'),(8,'Repair'),(9,'Replace'),(10,'unassigned');

--
-- Table structure for table `sb_equipment_amc`
--

CREATE TABLE `sb_equipment_amc` (
  `eq_amc_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_id` varchar(255) DEFAULT NULL,
  `type_id` varchar(255) DEFAULT NULL,
  `WEF_date` date DEFAULT NULL,
  `amc_amount` varchar(255) DEFAULT NULL,
  `amc_applied` varchar(45) DEFAULT NULL,
  `amc_monthly_date` varchar(255) DEFAULT NULL,
  `amc_status` int(11) DEFAULT NULL,
  `amc_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`eq_amc_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_equipment_amc`
--


--
-- Table structure for table `sb_equipment_item`
--

CREATE TABLE `sb_equipment_item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_type_id` int(11) DEFAULT NULL,
  `item_location_id` int(11) DEFAULT NULL,
  `item_vendor_id` int(11) DEFAULT NULL,
  `item_incharge` varchar(45) DEFAULT NULL,
  `item_description` varchar(45) DEFAULT NULL,
  `item_status` varchar(45) DEFAULT NULL,
  `item_amount` varchar(45) DEFAULT NULL,
  `item_model` varchar(45) DEFAULT NULL,
  `item_sr_no` varchar(45) DEFAULT NULL,
  `custom_field_1` varchar(255) DEFAULT NULL,
  `custom_field_2` varchar(255) DEFAULT NULL,
  `custom_field_3` varchar(255) DEFAULT NULL,
  `custom_field_4` varchar(255) DEFAULT NULL,
  `custom_field_5` varchar(255) DEFAULT NULL,
  `custom_field_6` varchar(255) DEFAULT NULL,
  `custom_field_7` varchar(255) DEFAULT NULL,
  `custom_field_8` varchar(255) DEFAULT NULL,
  `custom_field_9` varchar(255) DEFAULT NULL,
  `custom_field_10` varchar(255) DEFAULT NULL,
  `Item_date` date DEFAULT NULL,
  `item_name` varchar(255) DEFAULT NULL,
  `cpu` varchar(45) DEFAULT NULL,
  `ram` varchar(45) DEFAULT NULL,
  `dispplay` varchar(45) DEFAULT NULL,
  `hdd` varchar(45) DEFAULT NULL,
  `cd` varchar(45) DEFAULT NULL,
  `mouse` varchar(45) DEFAULT NULL,
  `spaker` varchar(45) DEFAULT NULL,
  `keyboard` varchar(45) DEFAULT NULL,
  `ups` varchar(45) DEFAULT NULL,
  `item_quantity` varchar(45) DEFAULT NULL,
  `item_code` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`item_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_equipment_item`
--


--
-- Table structure for table `sb_equipment_location`
--

CREATE TABLE `sb_equipment_location` (
  `eq_location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`eq_location_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_equipment_location`
--


--
-- Table structure for table `sb_equipment_log`
--

CREATE TABLE `sb_equipment_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_item_id` varchar(45) DEFAULT NULL,
  `log_item_type_id` int(11) DEFAULT NULL,
  `log_item_code` varchar(45) DEFAULT NULL,
  `log_item_status` varchar(45) DEFAULT NULL,
  `log_item_remark` mediumtext,
  `log_item_date` date DEFAULT NULL,
  `log_amount` varchar(45) DEFAULT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `replaced_item_code` varchar(45) DEFAULT NULL,
  `log_location` int(11) DEFAULT NULL,
  `log_incharge` varchar(45) DEFAULT NULL,
  `log_for_not_working_date` date DEFAULT NULL,
  `task_completed_date` date DEFAULT NULL,
  `sold_to` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`log_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_equipment_log`
--


--
-- Table structure for table `sb_equipment_type`
--

CREATE TABLE `sb_equipment_type` (
  `eq_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `eq_type_name` varchar(255) DEFAULT NULL,
  `eq_type_item_code` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`eq_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_equipment_type`
--

INSERT INTO `sb_equipment_type` VALUES (1,'Test Equipment Type','tet');

--
-- Table structure for table `sb_equipment_vendor`
--

CREATE TABLE `sb_equipment_vendor` (
  `vendor_id` int(11) NOT NULL AUTO_INCREMENT,
  `vendor_eq_id` int(11) DEFAULT NULL,
  `vendor_company` varchar(45) DEFAULT NULL,
  `vendor_name` varchar(45) DEFAULT NULL,
  `vendor_contact` varchar(45) DEFAULT NULL,
  `complaint_number` varchar(45) DEFAULT NULL,
  `vendor_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`vendor_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_equipment_vendor`
--


--
-- Table structure for table `sb_event_gallery`
--

CREATE TABLE `sb_event_gallery` (
  `event_id` int(11) NOT NULL AUTO_INCREMENT,
  `event_title` mediumtext,
  `event_start_date` datetime DEFAULT NULL,
  `event_end_date` datetime DEFAULT NULL,
  `event_status` int(2) NOT NULL DEFAULT '0',
  `event_default_image` int(11) DEFAULT NULL,
  `event_assigned_classes` text,
  `event_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `event_assigned_section` text,
  PRIMARY KEY (`event_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_event_gallery`
--


--
-- Table structure for table `sb_event_gallery_images`
--

CREATE TABLE `sb_event_gallery_images` (
  `image_id` int(11) NOT NULL AUTO_INCREMENT,
  `e_id` int(11) DEFAULT NULL,
  `image_title` mediumtext,
  `image_desc` mediumtext,
  `image_status` int(2) NOT NULL DEFAULT '0',
  `image_image_path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`image_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_event_gallery_images`
--


--
-- Table structure for table `sb_event_gallry_image_activity`
--

CREATE TABLE `sb_event_gallry_image_activity` (
  `image_activity_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `image_event_id` int(11) DEFAULT NULL,
  `student_id` int(11) DEFAULT NULL,
  `activity_type` varchar(45) DEFAULT NULL,
  `comment` varchar(45) DEFAULT NULL,
  `date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`image_activity_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_event_gallry_image_activity`
--


--
-- Table structure for table `sb_events_feeds`
--

CREATE TABLE `sb_events_feeds` (
  `eventfeed_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `eventfeed_start_date` date DEFAULT NULL,
  `eventfeed_end_date` date DEFAULT NULL,
  `eventfeed_type` int(11) DEFAULT NULL,
  `eventfeed_added_by` int(11) DEFAULT NULL,
  `eventfeed_added_datetime` datetime DEFAULT NULL,
  `eventfeed_updat_by` int(11) DEFAULT NULL,
  `eventfeed_update_datetime` datetime DEFAULT NULL,
  `status` enum('1','2','3') DEFAULT NULL,
  PRIMARY KEY (`eventfeed_pk_id`),
  KEY `IDXEF1` (`eventfeed_pk_id`),
  KEY `IDXEF2` (`eventfeed_type`),
  KEY `IDXEF3` (`eventfeed_start_date`),
  KEY `IDXEF4` (`eventfeed_end_date`),
  KEY `IDXEF5` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_events_feeds`
--

INSERT INTO `sb_events_feeds` VALUES (1,'2023-02-28','2024-03-31',2,363,'2023-02-28 15:15:17',NULL,NULL,'1'),(2,'2023-02-28','2024-03-31',1,363,'2023-02-28 15:30:29',NULL,NULL,'1'),(3,'2023-02-28','2024-03-31',1,363,'2023-02-28 15:31:12',NULL,NULL,'1'),(4,'2023-02-28','2024-03-31',1,363,'2023-02-28 15:31:46',NULL,NULL,'1'),(5,'2023-02-28','2024-03-31',1,363,'2023-02-28 15:32:46',NULL,NULL,'1'),(6,'2023-02-28','2024-03-31',1,363,'2023-02-28 15:33:20',NULL,NULL,'1'),(7,'2023-02-28','2024-03-31',1,363,'2023-02-28 15:34:04',NULL,NULL,'1'),(8,'2023-02-28','2023-03-01',2,363,'2023-02-28 15:40:09',NULL,NULL,'2'),(9,'2023-03-17','2023-03-17',3,5358,'2023-03-17 10:14:46',NULL,NULL,'2'),(10,'2023-03-17','2023-03-17',3,5358,'2023-03-17 10:14:46',NULL,NULL,'2'),(11,'2023-03-17','2023-03-17',3,2143,'2023-03-17 13:15:22',NULL,NULL,'3'),(12,'2023-03-17','2023-03-17',3,5132,'2023-03-17 22:16:40',NULL,NULL,'2'),(13,'2023-03-17','2023-03-17',3,5132,'2023-03-17 22:16:45',NULL,NULL,'3'),(14,'2023-03-17','2023-03-17',3,5132,'2023-03-17 22:16:45',NULL,NULL,'2'),(15,'2023-03-17','2023-03-17',3,5132,'2023-03-17 22:16:46',NULL,NULL,'2'),(16,'2023-03-19','2023-03-19',3,5358,'2023-03-19 10:14:56',NULL,NULL,'2'),(17,'2023-03-26','2023-03-26',3,5784,'2023-03-26 15:20:16',NULL,NULL,'3');

--
-- Table structure for table `sb_events_feeds_class_section`
--

CREATE TABLE `sb_events_feeds_class_section` (
  `events_feeds_class_section_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `eventfeed_pk_id` int(11) DEFAULT NULL,
  `events_feeds_class_section_classId` varchar(1000) DEFAULT NULL,
  `events_feeds_class_section_sectionId` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`events_feeds_class_section_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_events_feeds_class_section`
--

INSERT INTO `sb_events_feeds_class_section` VALUES (1,1,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(2,2,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(3,3,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(4,4,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(5,5,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(6,6,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(7,7,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(8,8,'1,2,3,4,5,6,7,8,9,10,11,12,16,13,14,15,17,18,19,20,21','4,5,6,7,8,3,9,10,11,12,13,14,1,15,16,17,18,19,20,21'),(9,9,NULL,NULL),(10,10,NULL,NULL),(11,11,NULL,NULL),(12,12,NULL,NULL),(13,13,NULL,NULL),(14,14,NULL,NULL),(15,15,NULL,NULL),(16,16,NULL,NULL),(17,17,NULL,NULL);

--
-- Table structure for table `sb_events_feeds_images`
--

CREATE TABLE `sb_events_feeds_images` (
  `events_feeds_images_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `eventfeed_pk_id` int(11) DEFAULT NULL,
  `events_feeds_images_title` varchar(100) DEFAULT NULL,
  `events_feeds_images_description` varchar(500) DEFAULT NULL,
  `events_feeds_images_file` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`events_feeds_images_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_events_feeds_images`
--

INSERT INTO `sb_events_feeds_images` VALUES (1,1,'ODM Educational Group!','','SocialMedi28022023031517_0.jpg'),(2,2,'ODM Educational Group','','5266dimage28022023033029_0.jpeg'),(3,3,'ODM Educational Group','','451638969228022023033112_0.jpeg'),(4,4,'ODM Educational Group','','Acticvitie28022023033146_0.jpeg'),(5,5,'ODM Educational Group','','Acticvitie28022023033246_0.jpeg'),(6,6,'ODM Educational Group','','Campusjpeg28022023033320_0.jpeg'),(7,7,'ODM Educational Group','','chairmanjp28022023033404_0.jpeg'),(8,8,'ODM','','PHOTO2023028022023034009_0.jpg'),(9,9,'For changing 2nd language subject from Hindi to Odia','Sir,                                                                                                             Respectfully I beg to say that my child will promotion to class I of your school. I had wrongly taken 2nd language Hindi.                               So, kindly change 2nd language from Hindi to Odia subject of my child.                                                    Thank you.                    ',''),(10,10,'For changing 2nd language subject from Hindi to Odia','Sir,                                                                                                             Respectfully I beg to say that my child will promotion to class I of your school. I had wrongly taken 2nd language Hindi.                               So, kindly change 2nd language from Hindi to Odia subject of my child.                                                    Thank you.                    ',''),(11,11,'Annual composit fees ','We have paid ANNUAL COMPOSIT FEES ON Dt -15/03/23\r\nStill it is not updated in ODM CONNECT,for this we are not able to proceed for next step.\r\nName - Tanmay Das\r\nSchool no- 3023,STD -9\r\nLOOKING FOR YOUR KIND SUPPORT REGARDING THIS.\r\nATTACHED SCREEN SHORT OF PAYMENT DETAILS IS FOR YOUR REFFERENCE. ','Screenshot17032023011522_0.jpg'),(12,12,'Painting by Evanshi class 3 ','Buddha painting by Evanshi Maharana.\r\n\r\nUsing color chalk and water colour\r\n','202303051717032023101640_0.jpg'),(13,13,'Painting by Evanshi class 3 ','Buddha painting by Evanshi Maharana.\r\n\r\nUsing color chalk and water colour\r\n','202303051717032023101645_0.jpg'),(14,14,'Painting by Evanshi class 3 ','Buddha painting by Evanshi Maharana.\r\n\r\nUsing color chalk and water colour\r\n','202303051717032023101645_0.jpg'),(15,15,'Painting by Evanshi class 3 ','Buddha painting by Evanshi Maharana.\r\n\r\nUsing color chalk and water colour\r\n','202303051717032023101646_0.jpg'),(16,16,'For changing second language from Hindi to Odia ','Sir,                                                                                                 Respectfully, I beg to say that my child Sri Dibya Jyoti Pradhan, Class,-I (Day scholar)-ODMBDA, Admn. No. 11939 of your school. I had wrongly taken 2nd language Hindi.                                                  So, I am kindly requesting change to the 2nd language from Hindi to Odia of my child.                    Thanking you sir.',''),(17,17,'Request for cabin','Dear Sir\r\nI request to provide a cabin in ODM Hostel for my son Saraswat Panigrahi , class xii , school Id 12372 \r\nThank you ','');

--
-- Table structure for table `sb_events_feeds_wings`
--

CREATE TABLE `sb_events_feeds_wings` (
  `sb_events_feeds_wings_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `eventfeed_pk_id` int(11) DEFAULT NULL,
  `sb_events_feeds_wings_wingsId` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`sb_events_feeds_wings_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=150 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_events_feeds_wings`
--

INSERT INTO `sb_events_feeds_wings` VALUES (1,1,'9,1,2,3,6'),(2,2,'9,1,2,3,6'),(3,3,'9,1,2,3,6'),(4,4,NULL),(5,5,'9,1,2,3,6'),(6,6,NULL),(7,7,NULL),(8,8,NULL),(9,9,NULL),(10,10,NULL),(11,11,'9,1,2,3,6'),(12,12,NULL),(13,13,NULL),(14,14,NULL),(15,15,NULL),(16,16,NULL),(20,21,NULL),(21,22,NULL),(22,24,'1,2,3,6,9,'),(23,25,'9,1,2,3,6'),(24,26,NULL),(25,27,'9,1,2,3,6'),(26,28,NULL),(27,29,'1,2,3,6,9,'),(28,30,'9,1,2,3,6'),(29,31,'9,1,2,3,6'),(30,32,'9,1,2,3,6'),(31,33,'9,1,2,3,6'),(32,34,'9,1,2,3,6'),(33,35,'9,1,2,3,6'),(34,36,'9,1,2,3,6'),(35,37,'9,1,2,3,6'),(36,38,'9,1,2,3,6'),(37,39,'9,1,2,3,6'),(38,40,'9,1,2,3,6'),(39,41,'9,1,2,3,6'),(40,42,'9,1,2,3,6'),(41,43,'1,2,3,6,9,'),(42,44,'9,1,2,3,6'),(43,45,'9,1,2,3,6'),(44,46,'9,1,2,3,6'),(45,47,'9,1,2,3,6'),(46,48,'9,1,2,3,6'),(47,49,'9,1,2,3,6'),(48,50,'9,1,2,3,6'),(49,51,'1,2,3,6'),(50,52,'1,2,3,6'),(51,53,NULL),(52,54,NULL),(53,55,NULL),(54,56,NULL),(55,57,'1,2,3,6'),(56,58,NULL),(57,59,NULL),(58,60,NULL),(59,61,NULL),(60,62,NULL),(61,63,NULL),(62,64,NULL),(63,65,'9,1,2,3,6'),(64,66,NULL),(65,67,NULL),(66,68,NULL),(67,69,NULL),(68,70,NULL),(69,71,NULL),(70,72,NULL),(71,73,NULL),(72,74,NULL),(73,75,NULL),(74,76,NULL),(75,77,NULL),(76,78,NULL),(77,79,NULL),(78,80,NULL),(79,81,NULL),(80,82,NULL),(81,83,NULL),(82,84,NULL),(83,85,NULL),(84,86,NULL),(85,87,NULL),(86,88,NULL),(87,89,NULL),(88,90,NULL),(89,91,NULL),(90,92,NULL),(91,93,NULL),(92,94,NULL),(93,95,NULL),(94,96,NULL),(95,97,NULL),(96,98,NULL),(97,99,NULL),(98,100,NULL),(99,101,NULL),(100,102,NULL),(101,103,NULL),(102,104,'1,2,3,6'),(103,105,'1,2,3,6'),(104,106,NULL),(105,107,'1,2,3,6'),(106,108,'1,2,3,6'),(107,109,'9,1,2,3,6'),(108,110,'9,1,2,3,6'),(109,111,'9,1,2,3,6'),(110,112,'1,2,3,6'),(111,113,NULL),(112,114,NULL),(113,115,NULL),(114,116,'1,2,3,6'),(115,117,'1,2,3,6'),(116,118,'1,2,3,6'),(117,119,NULL),(118,120,'1,2,3,6'),(119,121,'1,2,3,6,9,'),(120,122,NULL),(121,123,NULL),(122,124,NULL),(123,125,NULL),(124,126,'1,2,3,6'),(125,127,'1,2,3,6'),(126,128,'1,2,3,6'),(127,129,'1,2,3,6'),(128,130,'9,1,2,3,6'),(129,131,'9,1,2,3,6'),(130,132,'9,1,2,3,6'),(131,133,'9,1,2,3,6'),(132,134,'1,2,3,6'),(133,1,'2,1,4,3'),(134,2,'2,1,4,3'),(135,3,'2,1,4,3'),(136,4,'2,1,4,3'),(137,5,'2,1,4,3'),(138,6,'2,1,4,3'),(139,7,'2,1,4,3'),(140,8,'2,1,4,3'),(141,9,NULL),(142,10,NULL),(143,11,NULL),(144,12,NULL),(145,13,NULL),(146,14,NULL),(147,15,NULL),(148,16,NULL),(149,17,NULL);

--
-- Table structure for table `sb_exam_grade`
--

CREATE TABLE `sb_exam_grade` (
  `eg_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `eg_grade` varchar(45) DEFAULT NULL,
  `eg_min_mark` varchar(45) DEFAULT NULL,
  `eg_max_mark` varchar(45) DEFAULT NULL,
  `eg_color` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`eg_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_exam_grade`
--

INSERT INTO `sb_exam_grade` VALUES (1,'95_100','95','100','#006634'),(2,'90_95','90','94.9','#01994E'),(3,'80_90','80','89.9','#00CC65'),(4,'70_80','70','79.9','#999A01'),(5,'60_70','60','69.9','#FFFF00'),(6,'50_60','50','59.9','#FEFF99'),(7,'40_50','40','49.9','#FECCCB'),(8,'30_40','30','39.9','#FF9899'),(9,'20_30','20','29.9','#FF6666'),(10,'10_20','10','19.9','#FF3334'),(11,'0_10','0','9.9','#E41300');

--
-- Table structure for table `sb_exam_grade_master`
--

CREATE TABLE `sb_exam_grade_master` (
  `examgrade_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `examgrade_grade` varchar(255) DEFAULT NULL,
  `examgrade_range_from` varchar(45) DEFAULT NULL,
  `examgrade_range_to` varchar(45) DEFAULT NULL,
  `examgrade_remarks` varchar(255) DEFAULT NULL,
  `examgrade_stautus` int(11) DEFAULT '1',
  `examgrade_user_id` int(11) DEFAULT '0',
  `examgrade_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`examgrade_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_exam_grade_master`
--

INSERT INTO `sb_exam_grade_master` VALUES (3,'A1','91','100','OUT STANDING',1,1,'2022-02-11 17:35:57'),(4,'A2','81','90','EXCELLENT',1,1,'2022-02-11 17:49:37'),(5,'B1','71','80','VERY GOOD',1,1,'2022-02-11 17:49:38'),(6,'B2','61','70','GOOD',1,1,'2022-02-11 17:49:39'),(7,'C1','51','60','AVERAGE',1,1,'2022-02-11 17:49:40'),(8,'C2','41','50','NEED IMPROVEMENT',1,1,'2022-02-11 17:49:40'),(9,'D','31','40','NEED IMPROVEMENT',1,1,'2022-02-11 17:49:41'),(10,'E','0','30','NEED IMPROVEMENT',1,1,'2022-02-11 17:49:42');

--
-- Table structure for table `sb_exam_management`
--

CREATE TABLE `sb_exam_management` (
  `exam_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `exam_fk_school_id` int(11) NOT NULL,
  `exam_name` varchar(50) NOT NULL,
  `exam_code` varchar(255) DEFAULT NULL,
  `exam_start_date` date NOT NULL,
  `exam_end_date` date NOT NULL,
  `exam_type` int(11) NOT NULL DEFAULT '0',
  `exam_comments` mediumtext NOT NULL,
  `exam_fk_status_id` tinyint(1) NOT NULL,
  `exam_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`exam_pk_id`),
  KEY `IDX1` (`exam_pk_id`,`exam_name`),
  KEY `IDX2` (`exam_fk_status_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_exam_management`
--


--
-- Table structure for table `sb_exam_marks`
--

CREATE TABLE `sb_exam_marks` (
  `marks_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `marks_fk_exam_id` int(11) NOT NULL,
  `marks_fk_schedule_id` int(11) NOT NULL,
  `marks_fk_student_detail_id` int(11) NOT NULL,
  `marks_fk_sa_id` int(11) NOT NULL,
  `marks_fk_option_sa_id` int(11) DEFAULT NULL,
  `marks_fk_class_id` int(11) NOT NULL,
  `marks_fk_section_id` int(11) NOT NULL,
  `marks_marks` varchar(255) NOT NULL,
  `marks_fk_grade_id` int(11) NOT NULL,
  `marks_fk_passing_status` int(11) NOT NULL COMMENT 'Passing status - Pass, Fail',
  `marks_fk_status` int(11) NOT NULL DEFAULT '2' COMMENT 'Publish status',
  `marks_subject_id` int(11) DEFAULT '0',
  `marks_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `marks_individual_status` int(11) DEFAULT '0',
  PRIMARY KEY (`marks_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_exam_marks`
--


--
-- Table structure for table `sb_exam_marks_log`
--

CREATE TABLE `sb_exam_marks_log` (
  `eml_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `eml_exam_id` int(11) DEFAULT NULL,
  `eml_schedule_id` int(11) DEFAULT NULL,
  `eml_student_id` int(11) DEFAULT NULL,
  `eml_subject_id` int(11) DEFAULT NULL,
  `eml_subject_mark` varchar(45) DEFAULT NULL,
  `eml_added_by` int(11) DEFAULT NULL,
  `eml_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`eml_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_exam_marks_log`
--


--
-- Table structure for table `sb_exam_schedule`
--

CREATE TABLE `sb_exam_schedule` (
  `schedule_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `schedule_fk_id` int(11) DEFAULT NULL,
  `schedule_fk_class_id` int(11) NOT NULL,
  `schedule_fk_section_id` int(11) NOT NULL,
  `schedule_fk_exam_id` int(11) NOT NULL,
  `schedule_fk_teacher_id` int(11) NOT NULL,
  `schedule_fk_subject_id` int(11) NOT NULL,
  `schedule_date` date NOT NULL,
  `schedule_start_time` time NOT NULL,
  `schedule_end_time` time NOT NULL,
  `schedule_out_of_marks` varchar(11) NOT NULL,
  `schedule_passing_marks` varchar(11) NOT NULL,
  `schedule_grace_marks` varchar(11) NOT NULL,
  `schedule_remarks` text,
  `schedule_compulsory_subject` int(2) NOT NULL DEFAULT '0' COMMENT '0=not_compulsory,1=compulsory',
  `schedule_is_grade_marks` int(2) NOT NULL DEFAULT '0' COMMENT '0=marks,1=grade',
  `schedule_best_of_subject` int(2) NOT NULL DEFAULT '0' COMMENT '0=not BOS,1=BOS',
  `schedule_fk_status_id` tinyint(1) NOT NULL,
  `schedule_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `schedule_display_order` int(2) NOT NULL DEFAULT '0',
  `schedule_practical_subject` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`schedule_pk_id`),
  KEY `IDX1` (`schedule_pk_id`,`schedule_fk_subject_id`),
  KEY `IDX2` (`schedule_fk_subject_id`),
  KEY `IDX6` (`schedule_fk_subject_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_exam_schedule`
--


--
-- Table structure for table `sb_exam_schedule_master`
--

CREATE TABLE `sb_exam_schedule_master` (
  `esm_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `esm_exam_id` int(11) DEFAULT NULL,
  `esm_class_id` int(11) DEFAULT NULL,
  `esm_status` int(11) DEFAULT '1',
  `esm_status_publish` int(11) DEFAULT '0',
  `esm_user_id` int(11) DEFAULT NULL,
  `esm_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `esm_publish_datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`esm_pk_id`),
  KEY `IDX1` (`esm_pk_id`,`esm_exam_id`,`esm_class_id`,`esm_status`),
  KEY `IDX2` (`esm_exam_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_exam_schedule_master`
--


--
-- Table structure for table `sb_exam_schedule_section`
--

CREATE TABLE `sb_exam_schedule_section` (
  `ess_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ess_schedule_id` int(11) DEFAULT NULL,
  `ess_section_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`ess_pk_id`),
  KEY `IDX1` (`ess_pk_id`,`ess_schedule_id`,`ess_section_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_exam_schedule_section`
--


--
-- Table structure for table `sb_exam_type`
--

CREATE TABLE `sb_exam_type` (
  `et_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `et_exam_type` varchar(255) DEFAULT NULL,
  `et_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`et_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_exam_type`
--

INSERT INTO `sb_exam_type` VALUES (1,'Scholastic','2021-06-16 11:42:10'),(2,'Co-scholastic','2021-06-16 11:42:11');

--
-- Table structure for table `sb_extracurricular_activity`
--

CREATE TABLE `sb_extracurricular_activity` (
  `activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_fk_class_id` int(11) NOT NULL,
  `activity_fk_section_id` int(11) NOT NULL,
  `activity_fk_timeslot_id` mediumtext NOT NULL,
  `activity_name` varchar(255) NOT NULL,
  `activity_total_participant` int(11) NOT NULL,
  `activity_date` date NOT NULL,
  `activity_participation_date` date NOT NULL,
  `activity_fk_status_id` int(11) NOT NULL DEFAULT '2',
  `activity_type` varchar(10) NOT NULL,
  `activity_image` varchar(250) NOT NULL,
  `activity_added_by` int(11) NOT NULL,
  `activity_emails_send` mediumtext,
  `activity_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `activity_doc_image` varchar(255) DEFAULT NULL,
  `activity_desc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_extracurricular_activity`
--


--
-- Table structure for table `sb_extracurricular_activity_participate`
--

CREATE TABLE `sb_extracurricular_activity_participate` (
  `participate_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `participate_activity_fk_id` int(11) NOT NULL,
  `participate_fk_student_id` int(11) NOT NULL,
  `participate_fk_status_id` tinyint(4) NOT NULL,
  `participate_remarks` mediumtext,
  `participate_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`participate_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_extracurricular_activity_participate`
--


--
-- Table structure for table `sb_fee_management`
--

CREATE TABLE `sb_fee_management` (
  `fee_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_fk_fee_type` tinyint(1) NOT NULL DEFAULT '21' COMMENT 'Main fee or suplimentory fee',
  `fee_fk_plan_id` int(11) NOT NULL COMMENT 'Monthly, querterly, half yearly, yearly',
  `fee_fk_ref_id` int(11) NOT NULL,
  `fee_total` float(10,2) NOT NULL,
  `fee_invoice_date` date NOT NULL,
  `fee_due_date` date NOT NULL,
  `fee_discount` float(10,2) NOT NULL,
  `fee_penaulty` float(10,2) NOT NULL,
  `fee_fk_status_id` tinyint(1) NOT NULL DEFAULT '2',
  `fee_invoice_generate_status` enum('0','1') NOT NULL DEFAULT '0' COMMENT '0=>not sent, 1=>sent',
  `fee_invoice_generate_date` datetime NOT NULL,
  `fee_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`fee_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fee_management`
--


--
-- Table structure for table `sb_fee_submission`
--

CREATE TABLE `sb_fee_submission` (
  `submission_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `submission_fk_student_detail_id` int(11) NOT NULL,
  `submission_fk_fee_id` int(11) NOT NULL,
  `submission_fk_fee_type` tinyint(1) NOT NULL,
  `submission_invoice_number` int(11) NOT NULL,
  `submission_invoice_date` date NOT NULL,
  `submission_invoice_due_date` date NOT NULL,
  `submission_total_amount` float(10,2) NOT NULL,
  `submission_final_total_amount` float(10,2) NOT NULL,
  `submission_discount` float(10,2) NOT NULL,
  `submission_discount_amount` float(10,2) NOT NULL,
  `submission_penalty` float(10,2) NOT NULL,
  `submission_penalty_amount` float(10,2) NOT NULL,
  `submission_payment_mode` tinyint(1) NOT NULL DEFAULT '23',
  `submission_cheque_number` varchar(100) NOT NULL,
  `submission_payment_date` datetime NOT NULL,
  `submission_payment_status` varchar(100) NOT NULL DEFAULT 'failure' COMMENT 'success, failure',
  `submission_invoice_status` varchar(100) NOT NULL DEFAULT 'pending' COMMENT '''paid'',''pending''',
  `submission_transaction_id` varchar(255) NOT NULL,
  `submission_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`submission_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fee_submission`
--


--
-- Table structure for table `sb_feedback`
--

CREATE TABLE `sb_feedback` (
  `f_pk_id` int(255) NOT NULL AUTO_INCREMENT,
  `f_title` varchar(255) NOT NULL,
  `f_description` text NOT NULL,
  `f_created_by` int(255) NOT NULL,
  `f_created_date` datetime NOT NULL,
  `f_status` int(2) NOT NULL,
  `f_emails` varchar(255) DEFAULT NULL,
  `f_criteria` int(100) DEFAULT NULL,
  `f_operator` varchar(255) DEFAULT NULL,
  `f_star_value` int(100) DEFAULT NULL,
  `f_frequency` int(100) DEFAULT NULL,
  `f_type` int(10) DEFAULT NULL,
  PRIMARY KEY (`f_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_feedback`
--


--
-- Table structure for table `sb_feedback_category`
--

CREATE TABLE `sb_feedback_category` (
  `feedback_category_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_category_name` varchar(455) DEFAULT NULL,
  `feedback_category_added_by` int(11) DEFAULT NULL,
  `feedback_category_added_datetime` datetime DEFAULT NULL,
  `feedback_category_update_by` int(11) DEFAULT NULL,
  `feedback_update_datetime` datetime DEFAULT NULL,
  `status` enum('1','2','3') DEFAULT NULL,
  PRIMARY KEY (`feedback_category_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_feedback_category`
--

INSERT INTO `sb_feedback_category` VALUES (1,'test1',707,'2022-09-03 16:24:38',NULL,NULL,'3'),(2,'Suggestion & Feedback',363,'2022-09-09 08:02:00',NULL,NULL,'1'),(3,'Feedback',363,'2022-09-07 09:57:48',NULL,NULL,'3'),(4,'Good Idea Club',363,'2022-09-09 08:01:46',NULL,NULL,'1'),(5,'Area of improvement',363,'2022-09-07 09:58:39',NULL,NULL,'3');

--
-- Table structure for table `sb_feedback_dashboard`
--

CREATE TABLE `sb_feedback_dashboard` (
  `feedback_dashboard_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_category` varchar(45) DEFAULT NULL,
  `feedback_status` int(11) DEFAULT NULL,
  `description` varchar(455) DEFAULT NULL,
  `feedback_added_time` datetime DEFAULT NULL,
  `feedback_file` varchar(45) DEFAULT NULL,
  `feedback_added_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`feedback_dashboard_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_feedback_dashboard`
--

INSERT INTO `sb_feedback_dashboard` VALUES (1,'Good Idea Club',1,'Extra curricular activity add in exam.example  ludoo chess caroom quiz competition ect','2023-03-15 15:31:19',NULL,1599),(2,'Good Idea Club',1,'School is teaching students benefits of recycling. However school forces students to buy new books and copies from school at much higher rate. <br />\r\n<br />\r\nExample the pic attached costs Rs 170/- online. School charges Rs 215/- more than 26% profit on retail. The actual profit to school from selling of books is much more higher.<br />\r\n<br />\r\nA good practice would be giving freedom of buying books either from the market (used) or can be reused fro','2023-03-21 09:06:50','Screenshot151400.jpg',6223);

--
-- Table structure for table `sb_feedback_question`
--

CREATE TABLE `sb_feedback_question` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `question_type` int(11) NOT NULL,
  `question_option` text NOT NULL,
  `question_fk_id` int(255) NOT NULL,
  `option_value` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_feedback_question`
--

INSERT INTO `sb_feedback_question` VALUES (1,3,'Abc',1,0),(2,3,'PQR',1,0),(3,5,'Good',2,1),(4,5,'Better',2,2),(5,5,'Best',2,3);

--
-- Table structure for table `sb_feedback_status`
--

CREATE TABLE `sb_feedback_status` (
  `feedback_status_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `feedback_status_name` varchar(45) DEFAULT NULL,
  `feedback_status` int(11) DEFAULT NULL,
  `feedback_color_code` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`feedback_status_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_feedback_status`
--

INSERT INTO `sb_feedback_status` VALUES (4,'Management Reviewed',2,'#168d5a'),(8,'Management Review Pending',1,'#ffd500'),(9,'Not Valid ',3,'#ff0019');

--
-- Table structure for table `sb_fees_bus_route_master`
--

CREATE TABLE `sb_fees_bus_route_master` (
  `route_id` int(11) NOT NULL AUTO_INCREMENT,
  `route_name` varchar(250) DEFAULT NULL,
  `route_category` varchar(255) DEFAULT NULL,
  `route_rate` int(7) DEFAULT NULL,
  `route_number` varchar(255) DEFAULT NULL,
  `route_vehical_number` varchar(100) DEFAULT NULL,
  `route_driver_name` varchar(255) DEFAULT NULL,
  `route_driver_contact` bigint(11) DEFAULT NULL,
  `route_teacher_incharge` varchar(255) DEFAULT NULL,
  `route_teacher_contact` bigint(11) DEFAULT NULL,
  `route_stops` mediumtext,
  `route_bus_pick_time` varchar(100) DEFAULT NULL,
  `route_bus_drop_time` varchar(100) DEFAULT NULL,
  `route_status` int(2) NOT NULL DEFAULT '1',
  `remarks` mediumtext,
  PRIMARY KEY (`route_id`),
  KEY `master_index` (`route_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_bus_route_master`
--


--
-- Table structure for table `sb_fees_components`
--

CREATE TABLE `sb_fees_components` (
  `fee_component_id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_item_name` varchar(255) DEFAULT NULL,
  `fee_item_allow` int(2) NOT NULL DEFAULT '1' COMMENT '1-allow for all students, 2- allow for only new student',
  `fee_item_amount` int(7) NOT NULL,
  `fee_component_category` varchar(255) DEFAULT NULL,
  `fee_item_status` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`fee_component_id`),
  KEY `IDX1` (`fee_component_id`),
  KEY `IDX2` (`fee_component_category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_components`
--


--
-- Table structure for table `sb_fees_concession_components`
--

CREATE TABLE `sb_fees_concession_components` (
  `fcc_id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `fcc_conc_id` int(5) DEFAULT NULL,
  `fcc_component_id` int(5) DEFAULT NULL,
  `fcc_percentage` int(4) DEFAULT NULL,
  `fcc_date_number` int(2) DEFAULT NULL,
  `fcc_conc_amount` int(7) DEFAULT NULL,
  `fcc_component_type` int(2) NOT NULL DEFAULT '1',
  `fcc_status` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`fcc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_concession_components`
--


--
-- Table structure for table `sb_fees_concession_master`
--

CREATE TABLE `sb_fees_concession_master` (
  `conc_id` int(11) NOT NULL AUTO_INCREMENT,
  `conc_title` varchar(250) DEFAULT NULL,
  `conc_desc` mediumtext,
  `conc_fee_component_id` varchar(255) DEFAULT NULL,
  `conc_percentage` float NOT NULL DEFAULT '0' COMMENT '%',
  `conc_modified_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `conc_status` int(2) NOT NULL DEFAULT '1',
  `concn_type_id` int(3) DEFAULT NULL,
  `conc_date_id` int(11) DEFAULT '0',
  PRIMARY KEY (`conc_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_concession_master`
--


--
-- Table structure for table `sb_fees_concession_type`
--

CREATE TABLE `sb_fees_concession_type` (
  `concession_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `concession_type` varchar(255) DEFAULT NULL,
  `concession_type_status` int(2) NOT NULL DEFAULT '1',
  `concession_is_delete` int(2) DEFAULT '0',
  PRIMARY KEY (`concession_type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_concession_type`
--

INSERT INTO `sb_fees_concession_type` VALUES (13,'Fixed',1,0);

--
-- Table structure for table `sb_fees_date_master`
--

CREATE TABLE `sb_fees_date_master` (
  `in_date_id` int(11) NOT NULL AUTO_INCREMENT,
  `in_date_title` varchar(255) DEFAULT NULL,
  `in_date_desc` text,
  `in_date_1` date DEFAULT NULL,
  `in_date_due_1` date DEFAULT NULL,
  `in_date_due_appli_1` date DEFAULT NULL,
  `in_date_2` date DEFAULT NULL,
  `in_date_due_2` date DEFAULT NULL,
  `in_date_due_appli_2` date DEFAULT NULL,
  `in_date_3` date DEFAULT NULL,
  `in_date_due_3` date DEFAULT NULL,
  `in_date_due_appli_3` date DEFAULT NULL,
  `in_date_4` date DEFAULT NULL,
  `in_date_due_4` date DEFAULT NULL,
  `in_date_due_appli_4` date DEFAULT NULL,
  `in_date_5` date DEFAULT NULL,
  `in_date_due_5` date DEFAULT NULL,
  `in_date_due_appli_5` date DEFAULT NULL,
  `in_date_6` date DEFAULT NULL,
  `in_date_due_6` date DEFAULT NULL,
  `in_date_due_appli_6` date DEFAULT NULL,
  `in_date_7` date DEFAULT NULL,
  `in_date_due_7` date DEFAULT NULL,
  `in_date_due_appli_7` date DEFAULT NULL,
  `in_date_8` date DEFAULT NULL,
  `in_date_due_8` date DEFAULT NULL,
  `in_date_due_appli_8` date DEFAULT NULL,
  `in_date_9` date DEFAULT NULL,
  `in_date_due_9` date DEFAULT NULL,
  `in_date_due_appli_9` date DEFAULT NULL,
  `in_date_10` date DEFAULT NULL,
  `in_date_due_10` date DEFAULT NULL,
  `in_date_due_appli_10` date DEFAULT NULL,
  `in_date_11` date DEFAULT NULL,
  `in_date_due_11` date DEFAULT NULL,
  `in_date_due_appli_11` date DEFAULT NULL,
  `in_date_12` date DEFAULT NULL,
  `in_date_due_12` date DEFAULT NULL,
  `in_date_due_appli_12` date DEFAULT NULL,
  `in_date_13` date DEFAULT NULL,
  `in_date_due_13` date DEFAULT NULL,
  `in_date_due_appli_13` date DEFAULT NULL,
  `in_date_14` date DEFAULT NULL,
  `in_date_due_14` date DEFAULT NULL,
  `in_date_due_appli_14` date DEFAULT NULL,
  `in_date_15` date DEFAULT NULL,
  `in_date_due_15` date DEFAULT NULL,
  `in_date_due_appli_15` date DEFAULT NULL,
  `in_date_invoice_period_1` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_2` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_3` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_4` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_5` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_6` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_7` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_8` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_9` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_10` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_11` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_12` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_13` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_14` varchar(255) DEFAULT NULL,
  `in_date_invoice_period_15` varchar(255) DEFAULT NULL,
  `in_date_status` int(1) NOT NULL DEFAULT '1',
  `in_date_session_id` int(200) DEFAULT NULL,
  PRIMARY KEY (`in_date_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_fees_date_master`
--


--
-- Table structure for table `sb_fees_frequency_master`
--

CREATE TABLE `sb_fees_frequency_master` (
  `frq_id` int(11) NOT NULL AUTO_INCREMENT,
  `frq_title` varchar(255) DEFAULT NULL,
  `frq_installment_count` int(3) DEFAULT NULL,
  `frq_fee_component_id` int(11) DEFAULT NULL,
  `frq_date_id` varchar(255) DEFAULT NULL,
  `frq_date_numbers` varchar(255) DEFAULT NULL,
  `frq_status` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`frq_id`),
  KEY `idx_cmp_id` (`frq_fee_component_id`,`frq_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_frequency_master`
--


--
-- Table structure for table `sb_fees_invoice_details`
--

CREATE TABLE `sb_fees_invoice_details` (
  `invoice_details_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ind_invoice_id` bigint(20) DEFAULT NULL,
  `ind_fee_component_id` int(11) DEFAULT NULL,
  `ind_fee_amount` int(7) DEFAULT NULL,
  `ind_fee_concession_amount` int(11) NOT NULL DEFAULT '0',
  `ind_fee_amount_after_conc` int(7) DEFAULT NULL,
  `ind_fee_amount_paid` int(7) DEFAULT NULL,
  `ind_item_type` int(1) DEFAULT NULL COMMENT '1=fee item,2=concession,3=bus route,4 Late Patment,5=discount',
  `ind_remarks` mediumtext,
  `ind_concession_type` varchar(255) DEFAULT NULL,
  `ind_conc_heads` varchar(45) DEFAULT NULL,
  `ind_volume_conc_amt` int(6) DEFAULT NULL,
  PRIMARY KEY (`invoice_details_id`),
  KEY `NewIndex1` (`ind_invoice_id`),
  KEY `IDX1` (`ind_fee_component_id`),
  KEY `IDX2` (`invoice_details_id`),
  KEY `IDX3` (`ind_item_type`),
  KEY `IDX4` (`ind_invoice_id`,`ind_item_type`),
  KEY `IDX5` (`ind_fee_amount_after_conc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoice_details`
--


--
-- Table structure for table `sb_fees_invoice_details_old`
--

CREATE TABLE `sb_fees_invoice_details_old` (
  `invoice_details_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ind_invoice_id` bigint(20) DEFAULT NULL,
  `ind_fee_component_id` int(11) DEFAULT NULL,
  `ind_fee_amount` int(7) DEFAULT NULL,
  `ind_fee_concession_amount` int(11) NOT NULL DEFAULT '0',
  `ind_fee_amount_after_conc` int(7) DEFAULT NULL,
  `ind_fee_amount_paid` int(7) DEFAULT NULL,
  `ind_item_type` int(1) DEFAULT NULL COMMENT '1=fee item,2=concession,3=bus route,4 Late Patment,5=discount',
  `ind_remarks` mediumtext,
  `ind_concession_type` varchar(255) DEFAULT NULL,
  `ind_conc_heads` varchar(45) DEFAULT NULL,
  `ind_volume_conc_amt` int(6) DEFAULT NULL,
  PRIMARY KEY (`invoice_details_id`),
  KEY `NewIndex1` (`ind_invoice_id`),
  KEY `IDX1` (`ind_fee_component_id`),
  KEY `IDX2` (`invoice_details_id`),
  KEY `IDX3` (`ind_item_type`),
  KEY `IDX4` (`ind_invoice_id`,`ind_item_type`),
  KEY `IDX5` (`ind_fee_amount_after_conc`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoice_details_old`
--


--
-- Table structure for table `sb_fees_invoice_details_retracted`
--

CREATE TABLE `sb_fees_invoice_details_retracted` (
  `invoice_details_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ind_invoice_id` bigint(20) DEFAULT NULL,
  `ind_fee_component_id` int(11) DEFAULT NULL,
  `ind_fee_amount` int(7) DEFAULT NULL,
  `ind_fee_concession_amount` int(11) NOT NULL DEFAULT '0',
  `ind_fee_amount_after_conc` int(7) DEFAULT NULL,
  `ind_fee_amount_paid` int(7) DEFAULT NULL,
  `ind_item_type` int(1) DEFAULT NULL COMMENT '1=fee item,2=concession,3=bus route,4 Late Patment,5=discount',
  `ind_remarks` mediumtext,
  `ind_concession_type` varchar(255) DEFAULT NULL,
  `ind_conc_heads` varchar(45) DEFAULT NULL,
  `ind_volume_conc_amt` int(6) DEFAULT NULL,
  PRIMARY KEY (`invoice_details_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoice_details_retracted`
--


--
-- Table structure for table `sb_fees_invoices`
--

CREATE TABLE `sb_fees_invoices` (
  `fee_invoice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fee_reference_invoice_id` varchar(255) DEFAULT NULL,
  `fee_receipt_number` bigint(20) DEFAULT '0',
  `fee_receipt_number_old` bigint(20) DEFAULT NULL,
  `fi_student_id` int(11) NOT NULL,
  `fi_student_details_id` bigint(20) DEFAULT NULL,
  `fi_plan_id` int(11) DEFAULT NULL,
  `fi_plan_type_id` int(11) DEFAULT NULL COMMENT '21,22',
  `fi_student_plan_id` bigint(20) 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(7) DEFAULT NULL,
  `fi_net_amount` int(7) DEFAULT NULL,
  `fi_amount_paid` int(7) DEFAULT NULL,
  `fi_payment_status` varchar(50) DEFAULT NULL,
  `fi_transaction_id` varchar(255) 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(1) DEFAULT '0',
  `fi_check_date` datetime DEFAULT NULL,
  `in_generated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fi_bank_id` int(11) DEFAULT NULL,
  `fi_bank_date` date DEFAULT NULL,
  `fi_collection_date` timestamp NULL DEFAULT NULL,
  `fi_invoice_month_date` date DEFAULT NULL,
  `fi_merged_invoice_dates` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fee_invoice_id`),
  KEY `idx_fee_invoice_id` (`fee_invoice_id`),
  KEY `idx_student_id` (`fi_student_id`),
  KEY `idx_student_detail_id` (`fi_student_details_id`),
  KEY `idx_dashboard` (`fi_student_id`,`fi_payment_date`,`fi_status`),
  KEY `idx_fi_status` (`fi_status`),
  KEY `fi_payment_mode` (`fi_payment_mode`),
  KEY `idx_fi_payment_date` (`fi_payment_date`),
  KEY `fi_invoice_date` (`fi_invoice_date`,`fi_student_details_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoices`
--


--
-- Table structure for table `sb_fees_invoices_calcelled`
--

CREATE TABLE `sb_fees_invoices_calcelled` (
  `can_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `can_invoice_id` bigint(20) DEFAULT NULL,
  `can_receipt_number` bigint(20) DEFAULT '0',
  `can_student_id` int(11) NOT NULL,
  `can_student_details_id` bigint(20) DEFAULT NULL,
  `can_invoice_date` date DEFAULT NULL,
  `can_gross_amount` int(7) DEFAULT NULL,
  `can_net_amount` int(7) DEFAULT NULL,
  `can_amount_paid` int(7) DEFAULT NULL,
  `can_payment_status` varchar(50) DEFAULT NULL,
  `can_transaction_id` varchar(255) DEFAULT NULL,
  `can_payment_date` timestamp NULL DEFAULT NULL,
  `can_payment_mode` int(11) DEFAULT NULL,
  `can_payment_details` mediumtext,
  `can_status` varchar(255) DEFAULT NULL,
  `can_remarks` mediumtext,
  `can_remarks_receipt` mediumtext,
  `can_check_status` int(1) DEFAULT '0',
  `can_check_date` datetime DEFAULT NULL,
  `can_canceeled_by` varchar(255) DEFAULT NULL,
  `can_calcellation_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`can_id`),
  KEY `idx_fee_invoice_id` (`can_id`),
  KEY `idx_student_id` (`can_student_id`),
  KEY `idx_student_detail_id` (`can_student_details_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoices_calcelled`
--


--
-- Table structure for table `sb_fees_invoices_old`
--

CREATE TABLE `sb_fees_invoices_old` (
  `fee_invoice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fee_reference_invoice_id` varchar(255) DEFAULT NULL,
  `fee_receipt_number` bigint(20) DEFAULT '0',
  `fee_receipt_number_old` bigint(20) DEFAULT NULL,
  `fi_student_id` int(11) NOT NULL,
  `fi_student_details_id` bigint(20) DEFAULT NULL,
  `fi_plan_id` int(11) DEFAULT NULL,
  `fi_plan_type_id` int(11) DEFAULT NULL COMMENT '21,22',
  `fi_student_plan_id` bigint(20) 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(7) DEFAULT NULL,
  `fi_net_amount` int(7) DEFAULT NULL,
  `fi_amount_paid` int(7) DEFAULT NULL,
  `fi_payment_status` varchar(50) DEFAULT NULL,
  `fi_transaction_id` varchar(255) 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(1) DEFAULT '0',
  `fi_check_date` datetime DEFAULT NULL,
  `in_generated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fi_bank_id` int(11) DEFAULT NULL,
  `fi_bank_date` date DEFAULT NULL,
  `fi_collection_date` timestamp NULL DEFAULT NULL,
  `fi_invoice_month_date` date DEFAULT NULL,
  `fi_merged_invoice_dates` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fee_invoice_id`),
  KEY `idx_fee_invoice_id` (`fee_invoice_id`),
  KEY `idx_student_id` (`fi_student_id`),
  KEY `idx_student_detail_id` (`fi_student_details_id`),
  KEY `idx_dashboard` (`fi_student_id`,`fi_payment_date`,`fi_status`),
  KEY `idx_fi_status` (`fi_status`),
  KEY `fi_payment_mode` (`fi_payment_mode`),
  KEY `idx_fi_payment_date` (`fi_payment_date`),
  KEY `fi_invoice_date` (`fi_invoice_date`,`fi_student_details_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoices_old`
--


--
-- Table structure for table `sb_fees_invoices_retracted`
--

CREATE TABLE `sb_fees_invoices_retracted` (
  `fee_invoice_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `fee_reference_invoice_id` varchar(255) DEFAULT NULL,
  `fee_receipt_number` bigint(20) DEFAULT '0',
  `fee_receipt_number_old` bigint(20) DEFAULT NULL,
  `fi_student_id` int(11) NOT NULL,
  `fi_student_details_id` bigint(20) DEFAULT NULL,
  `fi_plan_id` int(11) DEFAULT NULL,
  `fi_plan_type_id` int(11) DEFAULT NULL COMMENT '21,22',
  `fi_student_plan_id` bigint(20) 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(7) DEFAULT NULL,
  `fi_net_amount` int(7) DEFAULT NULL,
  `fi_amount_paid` int(7) DEFAULT NULL,
  `fi_payment_status` varchar(50) DEFAULT NULL,
  `fi_transaction_id` varchar(255) 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(1) DEFAULT '0',
  `fi_check_date` datetime DEFAULT NULL,
  `in_generated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fi_bank_id` int(11) DEFAULT NULL,
  `fi_bank_date` date DEFAULT NULL,
  `fi_collection_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fi_invoice_month_date` date DEFAULT NULL,
  `fi_merged_invoice_dates` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`fee_invoice_id`),
  KEY `idx_fee_invoice_id` (`fee_invoice_id`),
  KEY `idx_student_id` (`fi_student_id`),
  KEY `idx_student_detail_id` (`fi_student_details_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_invoices_retracted`
--


--
-- Table structure for table `sb_fees_late_payment_master`
--

CREATE TABLE `sb_fees_late_payment_master` (
  `late_pay_id` int(11) NOT NULL AUTO_INCREMENT,
  `late_pay_name` varchar(255) NOT NULL,
  `overdue_1_amount` int(5) DEFAULT NULL,
  `overdue_2_amount` int(5) DEFAULT NULL,
  `overdue_3_amount` int(5) DEFAULT NULL,
  `overdue_4_amount` int(5) DEFAULT NULL,
  `overdue_5_amount` int(5) DEFAULT NULL,
  `overdue_6_amount` int(5) DEFAULT NULL,
  `overdue_7_amount` int(5) DEFAULT NULL,
  `overdue_8_amount` int(5) DEFAULT NULL,
  `overdue_9_amount` int(5) DEFAULT NULL,
  `overdue_10_amount` int(5) DEFAULT NULL,
  `overdue_11_amount` int(5) DEFAULT NULL,
  `overdue_12_amount` int(5) DEFAULT NULL,
  `overdue_13_amount` int(5) DEFAULT NULL,
  `overdue_14_amount` int(5) DEFAULT NULL,
  `overdue_15_amount` int(5) DEFAULT NULL,
  `late_pay_type` int(1) NOT NULL DEFAULT '1' COMMENT '1=monthly, 2=instalment wise',
  `late_pay_status` int(2) NOT NULL DEFAULT '1',
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`late_pay_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_late_payment_master`
--


--
-- Table structure for table `sb_fees_late_payment_setting`
--

CREATE TABLE `sb_fees_late_payment_setting` (
  `lps_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `lps_date_id` int(11) DEFAULT NULL,
  `lps_date` date DEFAULT NULL,
  `lps_status` int(11) DEFAULT '0',
  `lps_added_by` int(11) DEFAULT '0',
  `lps_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`lps_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_fees_late_payment_setting`
--


--
-- Table structure for table `sb_fees_logs`
--

CREATE TABLE `sb_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_type` varchar(255) 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`),
  KEY `fl_invoice_id` (`fl_invoice_id`),
  KEY `fl_id` (`fl_id`),
  KEY `fl_user_id` (`fl_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_logs`
--


--
-- Table structure for table `sb_fees_payment_status`
--

CREATE TABLE `sb_fees_payment_status` (
  `fs_id` int(11) NOT NULL AUTO_INCREMENT,
  `fs_text` varchar(255) NOT NULL,
  `fs_show_status` int(11) DEFAULT '1',
  PRIMARY KEY (`fs_id`),
  KEY `NewIndex1` (`fs_id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_payment_status`
--

INSERT INTO `sb_fees_payment_status` VALUES (1,'Online',1),(2,'Cheque',0),(3,'Cash',0),(4,'Bank Transfer',0),(5,'Other Settlement',0),(6,'Cancelled',0),(7,'Swipe',1),(8,'DD',1),(9,'Paytm',0),(10,'Adjust from Student Account Balance',1),(11,'NEFT',1),(12,'Online Manual',0),(13,'UPI',1),(14,'DC',0),(15,'Adjustment',0),(16,'Online Manual',1);

--
-- Table structure for table `sb_fees_plan_components`
--

CREATE TABLE `sb_fees_plan_components` (
  `pc_id` int(11) NOT NULL AUTO_INCREMENT,
  `pc_fee_component_id` int(11) NOT NULL,
  `pc_fee_plan_id` int(11) NOT NULL,
  `pc_option_component_id` int(11) DEFAULT NULL,
  `pc_status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`pc_id`),
  KEY `isx_plan_id` (`pc_fee_plan_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_plan_components`
--


--
-- Table structure for table `sb_fees_plan_master`
--

CREATE TABLE `sb_fees_plan_master` (
  `fp_id` int(11) NOT NULL AUTO_INCREMENT,
  `fp_fee_type_id` int(3) DEFAULT NULL COMMENT 'Main 21,suplimentory22',
  `fp_title` varchar(255) DEFAULT NULL,
  `fp_desc` mediumtext,
  `fp_late_payment_id` int(11) DEFAULT NULL,
  `fp_status` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`fp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_plan_master`
--


--
-- Table structure for table `sb_fees_refund`
--

CREATE TABLE `sb_fees_refund` (
  `refund_id` int(11) NOT NULL AUTO_INCREMENT,
  `refund_student_id` int(11) DEFAULT NULL,
  `refund_amount` int(11) DEFAULT NULL,
  `refund_updated_date` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`refund_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_fees_refund`
--


--
-- Table structure for table `sb_fees_refund_heads`
--

CREATE TABLE `sb_fees_refund_heads` (
  `rcmp_id` int(11) NOT NULL AUTO_INCREMENT,
  `rcmp_refund_id` int(11) DEFAULT NULL,
  `rcmp_category_head` varchar(45) DEFAULT NULL,
  `rcmp_amount` varchar(45) DEFAULT NULL,
  `ecmp_type` int(2) DEFAULT NULL,
  PRIMARY KEY (`rcmp_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_fees_refund_heads`
--


--
-- Table structure for table `sb_fees_refund_logs`
--

CREATE TABLE `sb_fees_refund_logs` (
  `rl_id` mediumint(20) NOT NULL AUTO_INCREMENT,
  `rl_student_id` int(11) DEFAULT NULL,
  `rl_log` mediumtext,
  `rl_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `rl_user_id` int(11) DEFAULT NULL,
  `rl_remarks` mediumtext,
  PRIMARY KEY (`rl_id`),
  KEY `IDXISTUDENT_ID` (`rl_student_id`),
  KEY `IDX2` (`rl_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_refund_logs`
--


--
-- Table structure for table `sb_fees_security_deposite`
--

CREATE TABLE `sb_fees_security_deposite` (
  `sec_id` int(11) NOT NULL AUTO_INCREMENT,
  `sec_student_id` int(11) DEFAULT NULL,
  `sec_session_year` varchar(45) DEFAULT NULL,
  `sec_category_head` varchar(45) DEFAULT NULL,
  `sec_amount` int(11) DEFAULT NULL,
  PRIMARY KEY (`sec_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_fees_security_deposite`
--


--
-- Table structure for table `sb_fees_student_plans`
--

CREATE TABLE `sb_fees_student_plans` (
  `sp_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `sp_student_pk_id` bigint(20) DEFAULT NULL,
  `sp_student_details_id` int(11) NOT NULL,
  `sp_class_id` int(11) NOT NULL,
  `sp_section_id` int(11) NOT NULL,
  `sp_fee_plan_id` int(11) DEFAULT NULL,
  `sp_main_optional_fee_plan_ids` varchar(255) NOT NULL,
  `sp_fee_type_id` int(2) DEFAULT NULL COMMENT '21,22',
  `sp_bus_route_id` varchar(255) DEFAULT NULL,
  `sp_concession_ids` varchar(255) DEFAULT NULL,
  `sp_discount` int(7) DEFAULT NULL,
  `sp_discount_remarks` mediumtext,
  `sp_status` int(2) NOT NULL DEFAULT '1',
  PRIMARY KEY (`sp_id`),
  KEY `idx_serch` (`sp_student_pk_id`,`sp_fee_type_id`,`sp_concession_ids`,`sp_status`),
  KEY `Idx_sp_student_id` (`sp_student_pk_id`),
  KEY `idx_plan_id` (`sp_fee_plan_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_fees_student_plans`
--


--
-- Table structure for table `sb_fees_transactions_payu`
--

CREATE TABLE `sb_fees_transactions_payu` (
  `ftp_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ftp_split_info` varchar(255) DEFAULT NULL,
  `ftp_customer_name` text,
  `ftp_additional_charges` varchar(45) DEFAULT NULL,
  `ftp_payment_mode` varchar(45) DEFAULT NULL,
  `ftp_hash` text,
  `ftp_status` varchar(45) DEFAULT NULL,
  `ftp_error_message` text,
  `ftp_payment_id` varchar(255) DEFAULT NULL,
  `ftp_product_info` varchar(255) DEFAULT NULL,
  `ftp_customer_email` varchar(255) DEFAULT NULL,
  `ftp_customer_phone` varchar(255) DEFAULT NULL,
  `ftp_merchant_transaction_id` varchar(255) DEFAULT NULL,
  `ftp_amount` varchar(45) DEFAULT NULL,
  `ftp_udf2` varchar(45) DEFAULT NULL,
  `ftp_notification_id` int(11) DEFAULT NULL,
  `ftp_udf1` varchar(255) DEFAULT NULL,
  `ftp_udf3` varchar(255) DEFAULT NULL,
  `ftp_udf4` varchar(255) DEFAULT NULL,
  `ftp_udf5` varchar(255) DEFAULT NULL,
  `ftp_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ftp_pk_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_fees_transactions_payu`
--


--
-- Table structure for table `sb_follow_up_notes`
--

CREATE TABLE `sb_follow_up_notes` (
  `fun_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `added_by` int(11) DEFAULT NULL,
  `added_date_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `fun_date_time` varchar(100) DEFAULT NULL,
  `fun_tag_id` int(11) DEFAULT NULL,
  `over_due_status` tinyint(4) DEFAULT NULL,
  `fun_type` tinyint(4) DEFAULT NULL,
  `notes` text,
  `lead_app_id` bigint(20) DEFAULT NULL,
  `follow_up_status` tinyint(4) DEFAULT NULL,
  `rescheduled_status` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`fun_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_follow_up_notes`
--

INSERT INTO `sb_follow_up_notes` VALUES (1,644,'2023-01-24 04:42:28','2023-01-25 10:12',9,1,2,'call to parent',1671773778351,3,1),(2,644,'2023-01-24 04:43:15','2023-01-25 10:12',10,2,2,'send payment link and get follow-up.',1671773778351,1,1);

--
-- Table structure for table `sb_follow_up_tag`
--

CREATE TABLE `sb_follow_up_tag` (
  `tag_pk_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `tag_name` varchar(250) DEFAULT NULL,
  `tag_added_by` int(11) DEFAULT NULL,
  `tag_added_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `tag_status` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`tag_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_follow_up_tag`
--

INSERT INTO `sb_follow_up_tag` VALUES (9,'Lead Manager',808,'2023-01-10 07:33:28',1),(10,'Form Payment',363,'2023-01-13 06:26:30',1),(11,'Application Form',363,'2023-01-13 06:26:37',1),(12,'Screening',363,'2023-01-13 06:26:43',1),(13,'Baseline Test',363,'2023-01-13 06:26:49',1),(14,'Documentation',363,'2023-01-13 06:26:55',1),(15,'Admission Fee',363,'2023-01-13 06:27:02',1),(16,'Other',363,'2023-01-13 06:27:07',1);

--
-- Table structure for table `sb_ga_goals_achieved`
--

CREATE TABLE `sb_ga_goals_achieved` (
  `gv_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `gv_teacher_id` int(11) DEFAULT NULL,
  `gv_date` date DEFAULT NULL,
  `gv_added_user_id` int(11) DEFAULT NULL,
  `gv_added_date` datetime DEFAULT NULL,
  `gv_updated_user_id` int(11) DEFAULT NULL,
  `gv_updated_date` datetime DEFAULT NULL,
  `gv_desciption` longtext,
  `gv_is_appraiser` int(11) DEFAULT '0',
  `gv_is_reviewer` int(11) DEFAULT '0',
  `cro_is_principal` int(11) DEFAULT '0',
  `ga_month` int(11) DEFAULT '0',
  PRIMARY KEY (`gv_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_ga_goals_achieved`
--


--
-- Table structure for table `sb_ga_goals_achieved_value`
--

CREATE TABLE `sb_ga_goals_achieved_value` (
  `agv_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `agv_gc_fk_id` int(11) DEFAULT NULL,
  `agv_ga_fk_id` int(11) DEFAULT NULL,
  `gv_self_appraisal` int(11) DEFAULT NULL,
  `gv_appraiser_comments` longtext,
  `gv_appraiser_scores` int(11) DEFAULT NULL,
  `gv_reviewer_comments` longtext,
  `gv_reviewer_scores` int(11) DEFAULT NULL,
  `gv_principal_comments` longtext,
  `gv_principal_scores` int(11) DEFAULT NULL,
  `g_teacher_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`agv_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_ga_goals_achieved_value`
--


--
-- Table structure for table `sb_ga_goals_category`
--

CREATE TABLE `sb_ga_goals_category` (
  `ga_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ga_sr_no` int(11) DEFAULT NULL,
  `ga_goals` longtext,
  `ga_description` longtext,
  PRIMARY KEY (`ga_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_ga_goals_category`
--

INSERT INTO `sb_ga_goals_category` VALUES (1,1,'Class/Subject Result ','What is the Highest result in class/subject ?How many students have scored with perfect 100%? What is the % improvement from the last exam? Any other '),(2,2,'Use of new pedagogical Initiatives','What contribution did the employee make in learning from CTL initiatives, Khan Academy,  Project Based Learning, any other'),(3,3,'Established Parent Connect','Regular call schedule with Parent , Sharing information about student, class school or any other, engaged parents with some  activities                                      '),(4,4,'Professional upgradation','Initiative to clear teaching certifications like CTET, have you further made efforts to acquire ore knowledge through Coursera, MOOC etc, have you nominated yourself for any advance courses offered by IIT, IIM and other organizations'),(5,5,'Digital Literacy','Initiative taken tp use smart board, creating online lesson plan and content. Use of technology for class room delivery'),(6,6,'Institution Building','Additional Assignments Accomplished');

--
-- Table structure for table `sb_ga_year_months`
--

CREATE TABLE `sb_ga_year_months` (
  `ym_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `ym_name` longtext,
  `ym_number` int(11) DEFAULT NULL,
  `ym_year` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ym_pk_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_ga_year_months`
--

INSERT INTO `sb_ga_year_months` VALUES (1,'April-2019',4,'2019'),(2,'October-2019',10,'2019'),(3,'March-2020',3,'2020'),(5,'November-2019',11,'2019');

--
-- Table structure for table `sb_get_pass`
--

CREATE TABLE `sb_get_pass` (
  `gp_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `gp_student_name` varchar(255) DEFAULT NULL,
  `gp_class` int(11) DEFAULT NULL,
  `gp_section` int(11) DEFAULT NULL,
  `gp_parent` varchar(45) DEFAULT NULL,
  `gp_parent_name` varchar(45) DEFAULT NULL,
  `gp_parent_mno` varchar(45) DEFAULT NULL,
  `gp_parent_rel` varchar(45) DEFAULT NULL,
  `gp_parent_identification` varchar(255) DEFAULT NULL,
  `gp_class_teacher` int(11) DEFAULT NULL,
  `gp_student_id` int(11) DEFAULT NULL,
  `gp_reason` mediumtext,
  `gp_type` int(11) DEFAULT NULL,
  `gp_status` int(11) DEFAULT NULL,
  `gp_added_date` datetime DEFAULT NULL,
  PRIMARY KEY (`gp_pk_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_get_pass`
--


--
-- Table structure for table `sb_global_details`
--

CREATE TABLE `sb_global_details` (
  `glob_id` int(11) NOT NULL AUTO_INCREMENT,
  `glob_key` varchar(255) DEFAULT NULL,
  `glob_value` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`glob_id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_global_details`
--



--
-- Table structure for table `sb_gps_post_test`
--

CREATE TABLE `sb_gps_post_test` (
  `track_id` int(11) NOT NULL AUTO_INCREMENT,
  `device_number` mediumtext,
  `vehicle_number` mediumtext,
  `g_date` datetime DEFAULT NULL,
  `device_time` datetime DEFAULT NULL,
  `latitude` varchar(255) DEFAULT NULL,
  `longitude` varchar(255) DEFAULT NULL,
  `speed` varchar(255) DEFAULT NULL,
  `data_posted_on` datetime DEFAULT NULL,
  PRIMARY KEY (`track_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_gps_post_test`
--


--
-- Table structure for table `sb_gps_tracker`
--

CREATE TABLE `sb_gps_tracker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imei_number` varchar(255) NOT NULL,
  `gprs_mode` varchar(50) NOT NULL,
  `vehicle_number` varchar(50) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `calculated_latitude` varchar(255) NOT NULL,
  `calculated_longitude` varchar(255) NOT NULL,
  `speed` varchar(50) NOT NULL,
  `rfid` varchar(255) NOT NULL,
  `gps_status` varchar(20) NOT NULL,
  `time_from_device` time NOT NULL,
  `timezone_added_date` datetime NOT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_gps_tracker`
--


--
-- Table structure for table `sb_gps_tracker_missed`
--

CREATE TABLE `sb_gps_tracker_missed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `imei_number` varchar(255) NOT NULL,
  `gprs_mode` varchar(50) NOT NULL,
  `vehicle_number` varchar(50) NOT NULL,
  `date` date NOT NULL,
  `time` time NOT NULL,
  `latitude` varchar(100) NOT NULL,
  `longitude` varchar(100) NOT NULL,
  `calculated_latitude` varchar(255) NOT NULL,
  `calculated_longitude` varchar(255) NOT NULL,
  `speed` varchar(50) NOT NULL,
  `rfid` varchar(255) NOT NULL,
  `gps_status` varchar(20) NOT NULL,
  `time_from_device` time NOT NULL,
  `timezone_added_date` datetime NOT NULL,
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_gps_tracker_missed`
--


--
-- Table structure for table `sb_grade`
--

CREATE TABLE `sb_grade` (
  `grade_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `grade_name` varchar(500) NOT NULL,
  `grade_min_marks` float(10,2) NOT NULL,
  `grade_max_marks` float(10,2) NOT NULL,
  `grade_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`grade_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_grade`
--

INSERT INTO `sb_grade` VALUES (1,'A1',91.00,100.00,'2021-05-27 06:02:22'),(2,'A2',81.00,90.00,'2021-05-27 06:02:23'),(3,'B1',71.00,80.00,'2021-05-27 06:02:23'),(5,'B2',61.00,70.00,'2021-05-27 06:02:24'),(6,'C1',51.00,60.00,'2021-05-27 06:02:25'),(7,'C2',41.00,50.00,'2021-05-27 06:02:25'),(8,'D',33.00,40.00,'2021-05-27 06:02:26');

--
-- Table structure for table `sb_grooming_criteria`
--

CREATE TABLE `sb_grooming_criteria` (
  `grooming_id` int(11) NOT NULL AUTO_INCREMENT,
  `grooming_criteria` varchar(255) NOT NULL,
  PRIMARY KEY (`grooming_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_grooming_criteria`
--

INSERT INTO `sb_grooming_criteria` VALUES (1,'test abc');

--
-- Table structure for table `sb_grooming_marks`
--

CREATE TABLE `sb_grooming_marks` (
  `gm_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `gm_fk_student_detail_id` int(11) NOT NULL,
  `gm_fk_grooming_id` int(11) NOT NULL,
  `gm_grooming_mark` enum('Yes','No') NOT NULL DEFAULT 'Yes',
  `gm_grooming_date` date NOT NULL,
  `gm_added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`gm_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_grooming_marks`
--

INSERT INTO `sb_grooming_marks` VALUES (2,1656,1,'Yes','2022-10-20','2022-10-20 17:19:31');

--
-- Table structure for table `sb_guardian_profession`
--

CREATE TABLE `sb_guardian_profession` (
  `pf_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `pf_profession` varchar(255) NOT NULL,
  PRIMARY KEY (`pf_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=818 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sb_guardian_profession`
--

INSERT INTO `sb_guardian_profession` VALUES (1,'Teacher'),(2,'Computer Engineer'),(3,'Doctor'),(4,'Other'),(5,'Advocate'),(6,'Accountant'),(7,'Architect'),(8,'Business'),(9,'Contractor'),(10,'Defense (Air Force, Navy, Army)'),(11,'Police'),(12,'Engineer'),(13,'Dentist'),(14,'Central Govt'),(15,'State Govt'),(16,'Insurance Advisor'),(17,'Travel Agency'),(18,'Interior Designer '),(19,'Professor '),(20,'Journalist'),(21,'Chartered Accountants'),(22,'Service - Private'),(23,'Politician'),(24,'Airlines'),(25,'Bank'),(26,'Educational Institute (Pvt)'),(27,'Medical College'),(28,'Software Developer'),(29,'SERVICE (ADMINISTRATION MANAGER)'),(30,'SERVICE'),(31,'HOUSEWIFE'),(32,'MANAGER'),(33,'SER (ADVOCATE)'),(34,'SERVICE (SOFTWARE ENGINEER)'),(35,'SERVICE (ACCOUNTANT)'),(36,'SELF EMPLOYED'),(37,'SERVICE (CONSULTANT)'),(38,'SERVICE (MANAGER)'),(39,'SERVICE (SR. ENGINEER)'),(40,'BUSINESS (DIRECTOR)'),(41,'SERVICE (HR MANAGER)'),(42,'SERVICE (A.G.M)'),(43,'ENTREPRENEUR'),(44,'SERVICE (TEACHER)'),(45,'SERVICE (DIRECTOR)'),(46,'SERVICE (S.M.O)'),(47,'SERVICE (AREA SALES MANAGER)'),(48,'SERVICE (KEY ACCOUNT MANAGER)'),(49,'SERVICE (AUDITOR)'),(50,'SERVICE (PRODUCT MANAGER)'),(51,'SPEECH THERAPIST'),(52,'SERVICE (ASST. MANAGER)'),(53,'SERVICE (SR.MANAGER)'),(54,'SERVICE (IT PROFESSIONAL)'),(55,'SERVICE (TEST MANAGER)'),(56,'SERVICE (DEPUTY BRANCH MANAGER)'),(57,'#N/A'),(58,'GOVT. EMPLOYEE'),(59,'SERVICE (ADVOCATE)'),(60,'SERVICE (GROUP HEAD)'),(61,'SERVICE (SR. SOFTWARE ENGINEER)'),(62,'SERVICE (ASST. PROFESSOR)'),(63,'SERVICE (COUNSELLOR)'),(64,'SERVICE (PROJECT MANAGER)'),(65,'SERVICE (DY. MANAGER)'),(66,'SERVICE (SR. MANAGER)'),(67,'SERVICE (TECH. OFFICER)'),(68,'SERVICE (EXECUTIVE)'),(69,'SERVICE (ASSISTANT MANAGER)'),(70,'SERVICE (ASSISTANT TEACHER)'),(71,'SERVICE (TECH, LEAD)'),(72,'SERVICE (RELATIONSHIP MANAGER)'),(73,'SERVICE (ANALYST)'),(74,'JOURNALIST (GROUP EDITOR)'),(75,'SERVICE (BACK OFFICE)'),(76,'SERVICE (VP)'),(77,'SERVICE (OFFICE-COORDINATOR)'),(78,'SERVICE (LECTURER)'),(79,'SERVICE (TRAVEL CONSULTANT)'),(80,'SERVICE (MEDICAL REPRESENTATIVE)'),(81,'SERVICE (AVP)'),(82,'SERVICE (TEAM LEAD)'),(83,'SERVICE (NURSING OFFICER)'),(84,'SERVICE (ASST. FOOD AND BEVERAGE MANAGER)'),(85,'SERVICE (SR. B.A)'),(86,'SERVICE (PHYSICIAN)'),(87,'SERVICE (REGIONAL MANAGER)'),(88,'SERVICE (PLACEMENT MANAGER)'),(89,'SERVICE (SPECIALIST)'),(90,'SERVICE (SPL. EDUCATOR)'),(91,'SERVICE (SYSTEM ANALST)'),(92,'COORDINATOR'),(93,'TEACHER (VICE PRINCIPAL)'),(94,'SERVICE (PA)'),(95,'TEACHER (TEACHER)'),(96,'DOCTOR (SENIOR RESIDENT)'),(97,'FREELANCER INTERIOR'),(98,'SERVICE (SR.SC/TO)'),(99,'GARMENT EXPORT'),(100,'SERVICE (NURSING)'),(101,'(COMPUTER TEACHER)'),(102,'SERVICE (TECHNICAL ARCHITECT)'),(103,'FREELANCER (TEXTILE DESIGNER)'),(104,'SERVICE (CHIEF MANAGER)'),(105,'GOVT. EMPLOYEE (NURSING OFFICER)'),(106,'SERVICE (ADMIN INCHARGE)'),(107,'SERVICE (ACCOUNTS MANAGER)'),(108,'SERVICE (ENGINEER)'),(109,'SERVICE (JOURNALIST)'),(110,'SERVICE (SR. EXECUTIVE)'),(111,'SERVICE (P.S)'),(112,'SERVICE (ACCOUNTS EXECUTIVE)'),(113,'SERVICE (ASSISTANT PROFESSOR)'),(114,'SERVICE (GM)'),(115,'TEXTILE DESIGNER (FREELANCER)'),(116,'SERVICE (LEAD ENGINEER)'),(117,'SERVICE (LEAD CONSULTANT)'),(118,'SERVICE (DGM -PURCHASE)'),(119,'SERVICE (MARKET MANAGER)'),(120,'TEACHER (TGT SCIENCE)'),(121,'JOURNALIST (CHIEF SUB EDITOR)'),(122,'SERVICE (TECHNICAL DELIVERY MANAGER)'),(123,'INDEPENDENT (DIETICIAN)'),(124,'ENTREPRENEUR (DIRECTOR)'),(125,'SERVICE (DIVISIONAL MANAGER)'),(126,'SERVICE (SR. PRINCIPAL ENGINEER)'),(127,'(CA)'),(128,'SERVICE (TECHNICAL LEAD)'),(129,'SERVICE (HEAD DEFENCE BUSINESS)'),(130,'SELF EMPLOYED (DIRECTOR)'),(131,'SERVICE (SENIOR ASSISTANT)'),(132,'DEFENCE'),(133,'RETIRED'),(134,'SERVICE (RECEPTIONIST)'),(135,'SERVICE (STENO)'),(136,'SERVICE (EDITOR)'),(137,'SERVICE (ASST. FOOD AND BEVERAGE MANAGER)'),(138,'SERVICE (ASST. FOOD AND BEVERAGE MANAGER)'),(139,'Assistant Professor'),(140,'SERVIVE'),(141,'Guest Lecturer'),(142,'HOUSE WIFE'),(143,'Minister'),(144,'Retired Test Cricketer'),(145,'IT PROFESSIONAL'),(146,'BANKER'),(147,'MEDIA SERVICE'),(148,'CHARTERED ACCOUNTANT'),(149,'LAWYER'),(150,'NURSING'),(151,'PRIVATE JOB'),(152,'SOFTWARE ENGINEER'),(153,'QUALITY ANALYST'),(154,'GOVERNMENT SERVICE'),(155,'PHARMACIST'),(156,'LEGAL OFFICER'),(157,'TECHNICAL SUPERINTENDENT'),(158,'PRIVATE SERVICE'),(159,'HOME MEKER'),(160,'IT PROFESSINAL'),(161,'LOGISTIC IRON BELT'),(162,'STAFF NURSE'),(163,'SOFT ENG'),(164,'FACULTY'),(165,'HOME MAKER'),(166,'FINANCIAL SERVICES'),(167,'SALARIED'),(168,'OT MANAGER'),(169,'MARKETING IN PHARMA'),(170,'IT SOFTWARE'),(171,'ACTOR'),(172,'IT - SOFTWARE'),(173,'MERCHANT NAVY'),(174,'HOUSE  WIFE'),(175,'PROFESSIONAL'),(176,'BM AT INNOVITI PAYMENT SOLUTION'),(177,'ASST MGR AT SWOSTI TRAVELS'),(178,'JOURNALISM'),(179,'GOVT. SERVICE'),(180,'GOVT EMPLOYEE'),(181,'HOUSE MAKER'),(182,'JOB'),(183,'IT CONSULTANT'),(184,'ONLINE BUSINESS'),(185,'REPORTER'),(186,'MARKETING MANAGER'),(187,'SELF EMPLOYEED'),(188,'RED CROSS EMPLOYEE'),(189,'LAB TECHNICIAN'),(190,'TECHNICAL ASSISTANT'),(191,'PROJECT MANAGER'),(192,'HOMEMAKER'),(193,'EMPLOYED'),(194,'TECHNOLOGY ARCHITECT'),(195,'GIS PROJECT ASSISTANT'),(196,'STATION MASTER, EAST COAST RAILWAY'),(197,'ASSOCIATE PROFESSOR'),(198,'SCIENTIST'),(199,'GOVT SERVICE'),(200,'SERVICE HOLDER'),(201,'ASSISTANT  PROFESSOR'),(202,'CIVIL ENGINEER'),(203,'SHREEMA DAS'),(204,'LAXMIPRIYA PATI'),(205,'SASMITA MAHAPATRO'),(206,'SAGARIKA BEHERA'),(207,'SARAJINI HANSDAH'),(208,'RITANJALI NAYAK'),(209,'BRUNDABATI RAJ'),(210,'SHANTI LATA MISHRA'),(211,'ENTERPRENEUR'),(212,'KIIT'),(213,'RESEARCHER'),(214,'IMMUNIZATION PROGRAM OFFICER.'),(215,'EMBRYOLOGIST'),(216,'STUDENT'),(217,'BANK EMPLOYEE'),(218,'EXECUTIVE CHEF'),(219,'LECTURESHIP'),(220,'SERCICE'),(221,'BANK SERVICE'),(222,'GOVT SERVANT'),(223,'ARMY'),(224,'IT JOB'),(225,'COST ACCOUNTANT'),(226,'RESEARCH ASSOCIATE'),(227,'COUNSELOR'),(228,'PUBLIC SERVENT'),(229,'PHYSIOTHERAPIST'),(230,'CORPORATE'),(231,'ASST SECTION OFFICER'),(232,'GEOLOGIST'),(233,'RAILWAY EMPLOYEE'),(234,'HOUSEWIVES'),(235,'ADVISOR'),(236,'SYSTEM ENGINEER'),(237,'MARINE ENGINEER'),(238,'HOUSE MANAGER'),(239,'CENIER MANAGER AT TATA STEEL'),(240,'STATE GOVERNMENT JOB HOLDER'),(241,'SOFTWARE PROFESSIONAL'),(242,'SERVICE AT MAHINDRA FINANCE'),(243,'SERVICE AT IDBI BANK LTD.'),(244,'CIVIL ENGINEER PVT'),(245,'LECTURER'),(246,'JOB AT THE RAMCO CEMENTS LTD'),(247,'BUISSNESS'),(248,'SENIOR SCIENTIST'),(249,'RELIANCE JIO'),(250,'WORKING'),(251,'IT ENGINEER'),(252,'RLY EMPLOYEE'),(253,'BUISNESS'),(254,'SHOPKEEPER'),(255,'PRIVATE EMPLOYEE'),(256,'BUSINESS WOMEN'),(257,'GOVT. SERVENT'),(258,'CIVIL CONTRACTOR'),(259,'PSU EMPLOYEE'),(260,'BRAND MANAGER : ACC CEMENT'),(261,'S/W ENGINEER'),(262,'SELF EMPLOYMENT'),(263,'PVT PROFESSIONAL'),(264,'HOUSEMAKER'),(265,'TEACHING'),(266,'MANAGER OF EXPORT'),(267,'INDUSTRIALIST.'),(268,'HOMEOPATH.'),(269,'BUSSINESSMAN'),(270,'MANAGER IN PROJECTS'),(271,'IT'),(272,'HW'),(273,'SERVICE IN NALCO'),(274,'BISENS'),(275,'HOUSEWHIFE'),(276,'ASSISTANT PROFESSOR (MECHANICAL  ENGG) KIIT UNIVERSITY, BBSR'),(277,'RESEARCH AND DEVELOPMENT'),(278,'TECHNOLOGY LEAD'),(279,'HR'),(280,'BUSINEES'),(281,'EVENT MANAGEMENT'),(282,'SOFTWARE  ENGINEER'),(283,'HOME-MAKER'),(284,'SERVICE(CRPF)'),(285,'DENTAL SURGEON'),(286,'IT MANAGER'),(287,'LECT.'),(288,'BRANCH OPERATIONAL MANAGER'),(289,'BUSSINESS'),(290,'IT SERVICE'),(291,'SERVICE (PRIVATE)'),(292,'SELF EMPLOYEE'),(293,'OWN BUSINESS'),(294,'SERVICE (IT)'),(295,'MANAGER IN BAL PHARMA LIMITED.'),(296,'GOVERNMENT EMPLOYEE'),(297,'PVT EMPLOYEE'),(298,'PUBLIC SERVICE'),(299,'ARCHITECTURE VONSULTANCY'),(300,'SERVICE IN BSNL'),(301,'SOFTWARE ENGINEER AT CAPGEMINI'),(302,'GOVT.EMPLOYEE'),(303,'CRS IN INDIAN RAILWAY'),(304,'SERVICE IN INFOSYS'),(305,'HOTEL MANAGER'),(306,'GOVT. SCHOOL TEACHER'),(307,'INSURANCE  ADVISER'),(308,'CENTRAL GOVT.'),(309,'LATE'),(310,'SOFTWARE'),(311,'ASST. MANAGER'),(312,'PVT JOB HOLDER'),(313,'IT CONSULTING'),(314,'PRIVATE SECTOR'),(315,'BUSINESSES'),(316,'MANAGER IN VODAFONE'),(317,'HR MANAGER'),(318,'PRIVATE BUSINESS'),(319,'MECHANICAL ENGINEER'),(320,'INDIAN RAILWAY SERVICE, SR. SECTION OFFICER (A)'),(321,'FACULTY IN BIOLOGY'),(322,'LECTURER IN BOTANY'),(323,'FOREST OFFICER'),(324,'GOVT .SERVICE'),(325,'MEDIA PERSONS'),(326,'SAILOR'),(327,'COMPANY SERVICE'),(328,'SERVICE IN PRIVATE SECTOR'),(329,'NA'),(330,'LIC ADVISOR'),(331,'GOVERNMENT JOB'),(332,'GOVT. JOB'),(333,'ELECTRICAL ENGINEER'),(334,'GOVT .EMPLOYEE'),(335,'ELECTRICAL SDO'),(336,'DOCTOR, ASSISTANT PROFESSOR IN RADIO NA DIAGNOSIS, KIMS'),(337,'RESEARCHER IN PHYSICS'),(338,'PVT.EMPLOYEES'),(339,'EMPLOYEE'),(340,'LAWER'),(341,'RESEARCH SCHOLAR'),(342,'EDUCATIONIST'),(343,'MANAGER,RELIANCE JIO.'),(344,'BUSINESS MAN'),(345,'COSMOTOLOGOST'),(346,'HOSPITAL MANANGER'),(347,'EXIDE LIFE INSURANCE'),(348,'JOB HOLDER'),(349,'BANK MANAGER'),(350,'DEMONSTRATER'),(351,'GOVT.SERVICE'),(352,'GOVT. SERVICE (ODISHA POLICE)'),(353,'HOME MAKE'),(354,'SALES AND MARKETING'),(355,'DGM IN SADHAV OFFSHORE'),(356,'PVT SERVICE'),(357,'LECTURE'),(358,'BE. ELECTRONICS'),(359,'BANK JOB'),(360,'GOVERNMENT  OFFICIALS'),(361,'PRACTICING ADVOCATE'),(362,'GOVT.SERVENT'),(363,'CHOREOGRAPHER'),(364,'WORK FROM HOME'),(365,'INDIAN AIR FORCE'),(366,'CENTRAL RESERVE POLICE FORCE'),(367,'FACULTY MEMBER'),(368,'LIBRARIAN'),(369,'SBI MF'),(370,'SOFTWARE CONSULTANT'),(371,'SOFT ENGINEER'),(372,'ASSISTANT COMMANDENT BSF(GOVT.SERVICE)'),(373,'SENIOR JOURNALIST'),(374,'BUSINESSMAN'),(375,'PR. MANAGER'),(376,'BUSINESS ANALYST'),(377,'TEACHING PROFESSION'),(378,'MARKETING EXECUTIVE'),(379,'CONSULTANT SERVICE'),(380,'NURSING SUPERVISOR'),(381,'SW ENGG.'),(382,'PSYCHOLOGIST'),(383,'PVT. SERVICE'),(384,'LIC AGENT'),(385,'RLY. EMPLOYEE'),(386,'X-ARMY'),(387,'HOUSEWIFE/ SOCIAL WORKER'),(388,'HOMOEOPATHY DOCTOR'),(389,'BUSINESS.'),(390,'HOUSE WIFE.'),(391,'MUSIC TEACHER'),(392,'RAILWAY SERVICE'),(393,'IT COMPANY JOB'),(394,'BANKING'),(395,'POLICE SERVICE'),(396,'STATE GOVT EMPLOYEE'),(397,'MEDICAL STAFF'),(398,'TELECOM PROFESSIONAL'),(399,'SERVICE (TELECOM)'),(400,'ASSIST. PROFESSOR'),(401,'GOVERNMENT SERVANT'),(402,'ELECTRICIAN'),(403,'STATE GOVT. SERVICE'),(404,'AUDIOLOGIST'),(405,'OPERATIONAL MANAGER'),(406,'JUNIOR ENGINEER'),(407,'TEACHING AND RESEARCH'),(408,'TEACHING AND RESEARCH'),(409,'HR HEAD'),(410,'BANK OFFICER'),(411,'GOVT JOB'),(412,'SERVICE IN PRIVATE FIRM'),(413,'AGENT'),(414,'PHARMA COMPANY'),(415,'CENT. GOVERNMENT SERVICE'),(416,'GOVT. SERVANT'),(417,'GOVT.SERVANT'),(418,'NBFC EMPLOYEE'),(419,'BSNL SERVICE'),(420,'ASST.EXECUTIVE ENGG IN CESU'),(421,'JUNIOR EXECUTIVE IN APOLLO HOSPITALS'),(422,'CEO (BARODA HOSPITAL )'),(423,'DIRECTOR OF STRIDE HOSPITAL'),(424,'BUSINESS MANEGER'),(425,'PLANT HEAD(PLASTIC ENG.)'),(426,'MARKETING'),(427,'INSURANCE EMPLOYEE'),(428,'PRESS'),(429,'SALARY PERSONNEL'),(430,'PVT.SERVICE'),(431,'VETRINARY SURGEON'),(432,'DRIVER'),(433,'TEACHER (PLAY SCHOOL)'),(434,'BLOGGER'),(435,'TELECOM SERVICE'),(436,'PRIVATE  JOB'),(437,'ASST .ENGINEER'),(438,'PVT. JOB'),(439,'SUB INSPECTOR'),(440,'BEUTICIAN'),(441,'SOFTWARE ENGG'),(442,'ASSISTANT PROF. (II), KIIT-DU, BBSR'),(443,'PRIVATE COMPANY SERVICE'),(444,'TEACHING AND RESEARCH'),(445,'TEACHING AND RESEARCH'),(446,'CENTRAL GOVT.EMPLOYEE'),(447,'SENIOR MANAGER (MAYFAIR LAGOON)'),(448,'AYUSH M. O.'),(449,'STATE GOVERNMENT SERVICE'),(450,'PROFESSIONAL COST ACCOUNTANT COMPANY SECRETARY'),(451,'COMPANY SERVICES'),(452,'DIRECTOR IN EDUSKILLS FOUNDATION'),(453,'TPA AND CORPORATE MANAGER APOLLO HOSPITALS BHUBANESWAR'),(454,'SERVICE (LARSEN AND TOURBO)'),(455,'PVT JOB'),(456,'SENIOR MANAGER(MAYFAIR LAGOON)'),(457,'DYLISIS TECHNICIAN'),(458,'JR. ENGINEER, RWSS DEPARTMENT'),(459,'OWN'),(460,'SELFNAEMPLOYED'),(461,'SERVICE (INDIAN RAILWAY)'),(462,'PERSONAL CLINIC'),(463,'PRIVATE JOB,CARE HOSPITAL'),(464,'MANAGING DIRECTOR'),(465,'ODISHA POLICE'),(466,'DANCE TEACHER/ CHOREOGRAPHER'),(467,'DANCE TEACHER/DANCER'),(468,'DIETICIAN CONSULTANT'),(469,'DEPUTY MANAGER IOCL'),(470,'CENTRAL GOVERNMENT RAILWAY SERVICE'),(471,'FAMILY MANAGER'),(472,'SOCIAL SERVICE'),(473,'MASTER MARINER'),(474,'AYURVEDIC DOCTOR'),(475,'PRINCIPAL, PCS COLLEGE, ANADAPUR'),(476,'GOVERNMENT  JOB'),(477,'CA, ADVOCATE'),(478,'ANCHOR'),(479,'BRANCH MANAGER'),(480,'PRIVATE SECTOR JOB'),(481,'DEFENCE EMPLOYEE'),(482,'ACCOUNTS EXECUTIVE'),(483,'HR PROFESSIONAL'),(484,'SENIOR PROJECT MANAGER'),(485,'WONDERFUL HOMEMAKER'),(486,'ENGINEEE @ NTPLC LTD'),(487,'BANK EMPLOYEE INDIAN BANK'),(488,'SW PROFESSIONAL'),(489,'HOUSEWIVE'),(490,'SERVICE IT ENGINEER'),(491,'MEDICAL BIO-TECHNOLOGIST'),(492,'GOBINDA CH TIRIA'),(493,'MANGULI TIRIA'),(494,'HOUSWIFE'),(495,'CLERK'),(496,'PDS DEALER'),(497,'SERVICE MAN'),(498,'COMPANY JOB'),(499,'PVT.EMPLOYEE'),(500,'PRT'),(501,'B. D. A AMIN'),(502,'ZONAL MANAGER'),(503,'DNS'),(504,'SENIOR ACCOUNTANT'),(505,'SERVICE HEAD IN ACOMPANY'),(506,'POLICE MAN'),(507,'ELCT ENGG'),(508,'TECHNICAL ENGINEER'),(509,'HOTEL MANAGMENT'),(510,'REAL ESTATE BUSINESS'),(511,'#REF!'),(512,'KANAKA BEHERA'),(513,'DRUGS INSPECTOR ODISHA, H&FW DEPARTMENT, GOVERNMENT SERVANT'),(514,'DRUGS INSPECTOR ODISHA , H&FW DEPARTMENT, GOVERNMENT SERVANT'),(515,'GOVNMENT SERVANT (SECRETARIAT).'),(516,'MARINE PILOT'),(517,'GOVT. ENGINEER'),(518,'MANAGER IN A LAB'),(519,'--'),(520,'PRIVATE JOB HOLDER'),(521,'PROFESSOR AT REC- RAJDHANI ENGINEERING COLLAGE'),(522,'STAFF NURSE AT CAPITAL HOSPITAL, NO.6'),(523,'ARMY OFFICER'),(524,'HOME MAKER.'),(525,'PRIVATE SERVICE MAN'),(526,'PROFESSOR IN HIGHER EDUCATION'),(527,'ORTEL EXECUTIVE MANAGER'),(528,'PROFESSOR IN MATHS'),(529,'GOVERNMENT SERVENT'),(530,'CIVIL SERVICE'),(531,'PRIVATE OFFICE'),(532,'COAL MINING ENGINEER'),(533,'EX SERVICEMAN'),(534,'JURNALIST'),(535,'PROFESSIONAL ARCHITECT'),(536,'SERVICE IN COAL INDIA LIMITED'),(537,'AQUACULTURE SPECIALIST'),(538,'JUDGE'),(539,'PATHOLOGIST'),(540,'INDIAN ARMY,'),(541,'RETIRED ARMY'),(542,'TERTIARY'),(543,'AXIS BANK MANAGER'),(544,'JOB & BUSINESS'),(545,'HOME MANAGER'),(546,'GOVERNMENT OFFICER (ALL INDIA RADIO)'),(547,'PRIVATE COMPANY JOB'),(548,'CENTRAL GOVT JOB'),(549,'OWN BUSINESS(BEAUTY PARLOUR)'),(550,'UNEMPLOYED.'),(551,'CIVIL CONTRACTER'),(552,'GOVERMENT SERVICE'),(553,'GOV\'T SERVICE'),(554,'TEACHERSHIP'),(555,'REGIONAL HEAD'),(556,'BUISSNESS MAN'),(557,'FINANCIAL ADVISOR'),(558,'SBI LIFE'),(559,'MANEGAR IN JYOTI MOTORS'),(560,'CH MANAGER, INDIAN OIL CORPORATION LTD'),(561,'------'),(562,'HOUSE WIFE\''),(563,'SOCIAL ENTREPRENEUR'),(564,'RAILWAY ENPLOYEE'),(565,'POLICE CONSTABLE'),(566,'GOVT.SERVANT (COMMISSIONERATE  POLICE)'),(567,'GOVT. SERVANTS'),(568,'POLICE OFFICER'),(569,'SERVICES'),(570,'BUSSINESS MAN'),(571,'EAST COST RAILWAY'),(572,'BUSINESS (GROCERY)'),(573,'CENTRAL GOVERNMENT EMPLOYEE'),(574,'SERVICE IN HOTEL MAYFAIR LAGOON'),(575,'TEACHING AND RESEARCH'),(576,'EXECUTIVE IN PRIVATE ORGANIZATION'),(577,'SERVICE,AREA MANAGER'),(578,'SERVICE, AY MEDICAL OFFICER'),(579,'SOCIAL WORKER'),(580,'GOVERNMENT  SERVICE'),(581,'SOFTWARE EMPLOYEE'),(582,'GRADUATION'),(583,'CHIEF SCIENTIFIC OFFICER'),(584,'SCHOOL ADMIN'),(585,'ENTREPRENEURSHIP'),(586,'NURSING SUPERVISOR.K.I.M.S MEDICAL COLLEGE.'),(587,'BUISNESS MAN'),(588,'SELF -EMPLOYED'),(589,'BUSINES'),(590,'HOUSEHOLD'),(591,'MAYFAIR HOTEL'),(592,'LABOURER'),(593,'ACADEMICIAN'),(594,'A/C TECHNICIAN'),(595,'HOUSE BUILDERS'),(596,'READER IN COMMERCE'),(597,'GOVERNMENT EMPLOY'),(598,'HOUSE-WIFE'),(599,'SOFTWARE ENGINEER , TCS'),(600,'ACCOUNTS OFFICER BSNL ODISHA'),(601,'ASI/RPF'),(602,'NONE'),(603,'YOGA CONSULTANT'),(604,'ENGINEERS'),(605,'WORKS AS B. M. OF NCCF, BBSR, INDIA LTD.'),(606,'SENIOR SCIENTIST K V K'),(607,'PRIVATE JOB(NALCO)'),(608,'CENTRAL GOVT SERVANT'),(609,'CENTRAL GOVT. EMPLOY'),(610,'GOVT . EMPLOYEE'),(611,'GOVERNMENT SERVANT(EAST COAST RAILWAY)'),(612,'BUISNESSMAN'),(613,'VETERINARY ASSISTANT SURGEON'),(614,'VETERINARY ASST.SURGEON'),(615,'OT TECHNICIAN, APOLLO HOSPITAL'),(616,'ASST. TEACHER'),(617,'SELF EMPLOYED--'),(618,'DEPUTY MANAGERS'),(619,'CA'),(620,'SEVICE'),(621,'RESEARCH'),(622,'PETROLEUM ENGINEERING'),(623,'TECHNICIAN'),(624,'SERVICEMAN'),(625,'TRANSPORT'),(626,'BUSSNIESS'),(627,'EMPLOYEE (PVT)'),(628,'GOVT SERVICE (SUB COLLECTOR)'),(629,'SENIOR TECHNICAL OFFICER'),(630,'PRIVATE'),(631,'MANAGER OF GOLF CLUB'),(632,'POLICE INSPECTOR INCHARGE (IIC)'),(633,'LECTURER IN HISTORY'),(634,'CG SERVICE'),(635,'SR. MANAGER, GEOLOGY'),(636,'SELF SERVICE'),(637,'EMPLOYEE IN A PRIVATE SECTOR'),(638,'GOVT SERVICE RAILWAYS'),(639,'HOUSE. WIFE'),(640,'COMPANY EXECUTIVE'),(641,'AUDIO VISIAL'),(642,'GARMENTS'),(643,'BUGNESS'),(644,'SBI BANK OFFCIER'),(645,'ADVOCATE AND NOTARY PUBLIC BBSR'),(646,'CHEMIST'),(647,'HOUSE MANEGEMENT'),(648,'OAS OFFICER'),(649,'NEWS7 IT SECTION'),(650,'EXSM'),(651,'CHARTED ACCOUNTANT'),(652,'STATION MASTER , EAST COAST RAILWAY'),(653,'DIRECTOR'),(654,'CHAIRMAN OF PCS DEGREE COLLAGE'),(655,'PRIVATE SERVICE(PROJECT)'),(656,'BUSSINNES MAN'),(657,'EDITOR'),(658,'NURCING'),(659,'BEASNIS'),(660,'HOTELIER'),(661,'HOMR MAKER'),(662,'MECHANICAL ENGINEERING PROF'),(663,'SERVICE MAN(ENGINEER)'),(664,'NURSE MANAGER'),(665,'MARKETING MANAGER IN ARGO CHEMICALS'),(666,'BUILDER'),(667,'WORKING PROFESSIONAL ( JOB)'),(668,'CENTRAL GOVT. EMPLOYEE(EAST COAST RAILWAY)'),(669,'INDIAN ARMY'),(670,'ASSISTANT SECTION OFFICER'),(671,'DGM IN NATIONAL HIGHWAY AUTHORITY OF INDIA'),(672,'DGM (AVIATION) IN INDIAN OIL CORPORATION OF LIMITED'),(673,'PRIVATE SERVICE (MANAGER)'),(674,'PEDIATRIC DOCTOR'),(675,'SENIOR PRODUCER IN NEWS 7'),(676,'FARMER'),(677,'LIVELIHOOD EXPERT,DIRECTORATE ANIMAL RESOURCE DEPARTMENT ODISHA GOVERNMENT'),(678,'BUILDER ENGINEER'),(679,'HOUSE WOFE'),(680,'DIRECTOR OF SSB HOSPITAL'),(681,'MEDICINE BUSINESS'),(682,'INDIGO EMPLOYEE'),(683,'BUSINESSES AND CONTRACTOR'),(684,'EXECUTIVE ASSISTANT'),(685,'BUSINESSWOMAN'),(686,'FINANCIAL ADVISER'),(687,'ASP'),(688,'SECRETORY'),(689,'TRAVEL BUSINESS'),(690,'JUNIOR ASSISTANT IN KIIT MECHANICAL ENGINEERING LIBRARY'),(691,'HOUSE MANAGEMENT'),(692,'LIBRARARY ASSISTANT'),(693,'BUSSNESS'),(694,'MANAGER IN KIMS HOSPITAL'),(695,'LECTURER IN KISS UNIVERSITY'),(696,'MANAGER IN STATE BANK OF INDIA'),(697,'BUSINESS AND SERVICE'),(698,'HR HEAD OF MAYFAIR HOTEL'),(699,'GOVERNMENT SERVICE (POLICE)'),(700,'BANKING SERVICE'),(701,'NURSING MANAGER'),(702,'SSE IN RAILWAY MANCHESWAR'),(703,'HOUSE LADY'),(704,'CENTRAL GOVT. EMPLOYEE'),(705,'ENGENEER'),(706,'SERVICE AT KIIMS'),(707,'SERVICE MANAGER SBI'),(708,'MANAGER IN STAR LINK LOGISTICS'),(709,'MUTUAL FUND ADVISER'),(710,'KIMS NETWORK ENGINEER HEAD'),(711,'POLICE DEPT.'),(712,'PROFESSOR IN CHEMISTRY'),(713,'SECRETARY IN WOMEN\'S SOCIETY'),(714,'GOVT EMPLOYEE(POLICE)'),(715,'GOVT SERVICES'),(716,'-TEACHER'),(717,'SR.DEPUTY MANAGER'),(718,'SELF BUSINESS'),(719,'VETERINARY DOCTOR'),(720,'TUTOR'),(721,'ADVOCATE, BUSINESSMAN'),(722,'SELF-EMPLOYED'),(723,'PROFESSOR & DEAN'),(724,'CIVIL SERVANT'),(725,'RETIRED GOVERNMENT SERVANT'),(726,'RETIRED GOVERNMENT EMPLOYEE'),(727,'NURSE IN KALINGA HOSPITAL'),(728,'CENTRAL GOVT. EMPLOYEE IN EAST COAST RAILWAY'),(729,'-'),(730,'ASSISTANT TEACHER'),(731,'SELF EMP'),(732,'ENGINEER IN NESTLE SRI LANKA LIMITED'),(733,'BUSNESS'),(734,'FREELANCER'),(735,'PRIVATE JOB IN VEDANTA ALUMINIUM LIMITED'),(736,'RSP EMPLOY'),(737,'RESEARCH AND DEVELOPMENT'),(738,'SALES AND MARKETING'),(739,'TEACHING AND RESEARCH'),(740,'TEACHING AND RESEARCH'),(741,'TEACHING AND RESEARCH'),(742,'TEACHING AND RESEARCH'),(743,'TPA AND CORPORATE MANAGER APOLLO HOSPITALS BHUBANESWAR'),(744,'SERVICE (LARSEN AND TOURBO)'),(745,'TEACHING AND RESEARCH'),(746,'ADVOCATE AND NOTARY PUBLIC BBSR'),(747,'BUSINESSES AND CONTRACTOR'),(748,'BUSINESS AND SERVICE'),(749,'RESEARCH AND DEVELOPMENT'),(750,'SALES AND MARKETING'),(751,'TEACHING AND RESEARCH'),(752,'TEACHING AND RESEARCH'),(753,'TEACHING AND RESEARCH'),(754,'TEACHING AND RESEARCH'),(755,'TPA AND CORPORATE MANAGER APOLLO HOSPITALS BHUBANESWAR'),(756,'SERVICE (LARSEN AND TOURBO)'),(757,'TEACHING AND RESEARCH'),(758,'ADVOCATE AND NOTARY PUBLIC BBSR'),(759,'BUSINESSES AND CONTRACTOR'),(760,'BUSINESS AND SERVICE'),(761,'RESEARCH AND DEVELOPMENT'),(762,'SALES AND MARKETING'),(763,'TEACHING AND RESEARCH'),(764,'TEACHING AND RESEARCH'),(765,'TEACHING AND RESEARCH'),(766,'TEACHING AND RESEARCH'),(767,'TPA AND CORPORATE MANAGER APOLLO HOSPITALS BHUBANESWAR'),(768,'SERVICE (LARSEN AND TOURBO)'),(769,'RESEARCH AND DEVELOPMENT'),(770,'RESEARCH AND DEVELOPMENT'),(771,'SALES AND MARKETING'),(772,'TEACHING AND RESEARCH'),(773,'TEACHING AND RESEARCH'),(774,'TEACHING AND RESEARCH'),(775,'TEACHING AND RESEARCH'),(776,'TPA AND CORPORATE MANAGER APOLLO HOSPITALS BHUBANESWAR'),(777,'SERVICE (LARSEN AND TOURBO)'),(778,'TEACHING AND RESEARCH'),(779,'ADVOCATE AND NOTARY PUBLIC BBSR'),(780,'BUSINESSES AND CONTRACTOR'),(781,'BUSINESS AND SERVICE'),(782,'COMPUTER PROGRAMMER'),(783,'PRIVATE EMPLOYEE (ORTLEL)'),(784,'CARPENTER'),(785,'GOVT SERVIVE'),(786,'Yoga therapist'),(787,'SELF EMPLO'),(788,'NURSING OFFICER'),(789,'PRACTICE IN CS'),(790,'SCIENTIEST'),(791,'PRFOSSOR IN CHEM'),(792,'SERVICE(EX SERVICEMAN)'),(793,'ASST ENGINEER'),(794,'SELF-EMPLOYEE'),(795,'SERVCIE'),(796,'POLICE DEPART'),(797,'RTD GOVT EMP'),(798,'LIFE ADVISOR'),(799,'SINGER'),(800,'BEAUTICIAN'),(801,'GOVT. TEACHER'),(802,'Insurance agent'),(803,'EX SERVICE MAN'),(804,'BUSINESS PROPRIETOR'),(805,'HEALTH CONSULTANT'),(806,'POLICE INSPECTOR'),(807,'ODM EMPLOYEE'),(808,'MANAGER IN GALAXY TILES AND MARBLE'),(809,'LOCO PILOT'),(810,'CULTIVATION'),(811,'GENERAL INSURANCE AGENT'),(812,'DEFENCE RTD'),(813,'LEGAL PRATICE'),(814,'RETIRED FROM NALCO, ANGUL'),(815,'SUNITA BOIPAI'),(816,'GOVERNMENT'),(817,'SARPANCH');

--
-- Table structure for table `sb_handbook_file`
--

CREATE TABLE `sb_handbook_file` (
  `hdfk_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `hdfk_fk_id` int(11) DEFAULT NULL,
  `hdfk_file_name` varchar(455) DEFAULT NULL,
  `hdfk_status` int(11) DEFAULT NULL,
  PRIMARY KEY (`hdfk_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_handbook_file`
--

INSERT INTO `sb_handbook_file` VALUES (22,2,'1JPG19092022033720_0.JPG',1),(23,2,'hanbookjpg19092022033720_1.jpg',1),(24,2,'2JPG19092022033720_2.JPG',1),(29,3,'1JPG20092022092634_0.JPG',1),(30,3,'2JPG20092022092634_1.JPG',1),(31,3,'3JPG20092022092634_2.JPG',1),(32,4,'1JPG20092022093927_0.JPG',1),(33,4,'2JPG20092022093927_1.JPG',1),(34,5,'image037jp11102022114043_0.jpg',1),(35,6,'Screenshot11102022114132_0.png',1),(36,7,'image037jp13102022112719_0.jpg',1),(37,8,'StudentHan14102022104917_0.pdf',1),(38,9,'StudentHan14102022105008_0.pdf',1),(39,10,'StudentDis14102022105456_0.pdf',1),(40,11,'image037jp14102022105457_0.jpg',1);

--
-- Table structure for table `sb_handbook_master`
--

CREATE TABLE `sb_handbook_master` (
  `hdbk_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `hdbk_title` varchar(45) DEFAULT NULL,
  `hdbk_desc` varchar(500) DEFAULT NULL,
  `hdbk_status` int(11) DEFAULT NULL,
  `hdbk_added_by` int(11) DEFAULT NULL,
  `hdbk_added_date` datetime DEFAULT NULL,
  PRIMARY KEY (`hdbk_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_handbook_master`
--

INSERT INTO `sb_handbook_master` VALUES (2,'re','re',3,707,'2022-09-19 15:37:20'),(3,'ggf','fgff',3,707,'2022-09-20 09:26:34'),(4,'hell','fdf',3,707,'2022-09-20 09:39:27'),(5,'test3','sdsd',3,707,'2022-10-11 11:40:43'),(6,'HANDBOOK','About School',3,363,'2022-10-11 11:41:32'),(7,'test3','fd',3,707,'2022-10-13 11:27:19'),(8,'Student HandBook','Procedural Handbook  Academic Year 2022-23',3,363,'2022-10-14 10:49:17'),(9,'Student Handbook','Procedural Handbook Academic Year 2022-23',1,363,'2022-10-14 10:50:08'),(10,'Student Discipline Handbook','Student\'s Discipline Handbook',1,363,'2022-10-14 10:54:56'),(11,'test','sddf',3,707,'2022-10-14 10:54:57');

--
-- Table structure for table `sb_help_desk_chat_teacher_student`
--

CREATE TABLE `sb_help_desk_chat_teacher_student` (
  `hdchat_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `hdchat_raise_id` int(11) DEFAULT NULL,
  `hdchat_student_id` varchar(1500) DEFAULT '0',
  `hdchat_user_id` int(11) DEFAULT '0',
  `hdchat_user_type` int(11) DEFAULT '0',
  `hdchat_message` varchar(1500) DEFAULT NULL,
  `hdchat_attachment` varchar(1500) DEFAULT NULL,
  `hdchat_seen_status` int(11) DEFAULT '0',
  `hdchat_added_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `hdchat_seen_by_type` int(11) DEFAULT '0',
  `hdchat_seen_by_sub_type` int(11) DEFAULT '0',
  `hdchat_seen_by_admin` int(11) DEFAULT '0',
  `hdchat_seen_by_other` int(11) DEFAULT '0',
  PRIMARY KEY (`hdchat_pk_id`),
  KEY `idx_sb_help_desk_chat_teacher_student_3` (`hdchat_raise_id`,`hdchat_student_id`,`hdchat_user_id`) COMMENT 'idx_sb_help_desk_chat_teacher_student_hdchat_raise_id_hdchat_student_id_hdchat_user_id'
) ENGINE=InnoDB AUTO_INCREMENT=252 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_help_desk_chat_teacher_student`
--

INSERT INTO `sb_help_desk_chat_teacher_student` VALUES (1,7,'428',428,2,'My child class details was wrong ','',1,'2023-03-14 14:19:19',0,0,0,0),(2,7,'428',428,2,'So fees structure was also wrong ','',1,'2023-03-14 14:19:46',0,0,0,0),(3,73,'2450',2450,2,'ODM Connect App not showing school fee structure. How to deposit.','',1,'2023-03-16 12:23:23',1,0,0,0),(4,65,'6526',6526,2,'Hi','',1,'2023-03-16 12:32:32',0,1,1,0),(5,65,'6526',6526,2,'Could you plz chk the issue ?','',1,'2023-03-16 12:32:51',0,1,1,0),(6,25,'440',440,2,'Any update on my request. I can see that status is still DS.. please solve the issue.','',1,'2023-03-16 13:43:05',0,0,0,0),(7,61,'6552',6552,2,'Hello Sir/Madam','',1,'2023-03-16 14:06:19',0,1,0,0),(8,61,'6552',6552,2,'I had raised a query on transport','',1,'2023-03-16 14:06:35',0,1,0,0),(9,61,'6552',6552,2,'Please look into it','',1,'2023-03-16 14:06:44',0,1,0,0),(10,45,'1104',1104,2,'Good afternoon, I have paid Rs 7300.00 for annual composite fees of class VI ...the same is deducted from my account but not updated in ODM Connect, I have attached supportive documents in the query','',1,'2023-03-16 14:53:37',0,0,0,0),(11,87,'1198',1198,2,'I have paid annual composite fees , but it is not reflecting in your portal ','',1,'2023-03-16 16:06:20',0,0,0,0),(12,78,'3376',3376,2,'I want Siddhi\'s annual math exam photo copy','',1,'2023-03-16 17:01:18',1,0,0,0),(13,78,'3376',3376,2,'Class -4 D/B,7755','',1,'2023-03-16 17:01:38',1,0,0,0),(14,92,'1276',1276,2,'Hello Sir','',1,'2023-03-16 17:08:00',0,0,0,0),(15,92,'1276',1276,2,'Admission no 6657','',1,'2023-03-16 18:14:24',0,0,0,0),(16,92,'1276',1276,2,'Kindly update the payment in odm connecct','',1,'2023-03-16 18:15:28',0,0,0,0),(17,15,'1331',1331,2,'As per your given time is over  what is the status of my query','',1,'2023-03-16 19:03:12',1,0,0,0),(18,110,'1196',1196,2,'Wants for rechecking of math notes','',1,'2023-03-16 21:00:53',1,0,0,0),(19,98,'435',435,2,'I have finally made payment towards purchase of book and notebooks. This is for your information','',1,'2023-03-16 22:53:49',1,0,0,0),(20,50,'216',216,2,'Waiting ','',1,'2023-03-16 23:18:45',0,0,0,0),(21,43,'5761',772,1,' Dear Parents, greetings of the day! Thank you for reaching out to us. Sir/Madam your concern will be taken care with all possible way.  It is not yet finalized that students will shift their room in class 12. Thank you once again. Hope we have resolved your concern.<br />\r\n<br />\r\n                               <br />\r\n                            ','',0,'2023-03-17 10:10:54',0,0,0,0),(22,70,'564',675,1,'Dear Parents, Greetings! Contact number suggested by you has  been updated in the Connect App. Thanks TEAM ODM.','',0,'2023-03-17 11:39:10',0,0,0,0),(23,71,'310',310,2,'Please do needful at your earliest otherwise it would no be possible to pay the quarter fees.','',1,'2023-03-17 11:51:10',1,0,0,0),(24,133,'1686',1686,2,'Apply','',1,'2023-03-17 12:11:37',0,1,0,0),(25,45,'1104',1104,2,'Kindly resolve my issue at the earliest so I can proceed for further payments of quarterly and books and copies.','',1,'2023-03-17 12:19:53',0,0,0,0),(26,116,'2474',675,1,'Dear Parents, Greetings, Please make the payment in the Connect App. process - Non - academics - fees and other - payments.','',0,'2023-03-17 12:20:50',0,0,0,0),(27,92,'1276',1276,2,'Hello','',1,'2023-03-17 15:28:22',0,0,0,0),(28,87,'1198',1198,2,'Why no updates ','',1,'2023-03-17 21:31:54',0,0,0,0),(29,163,'2474',363,1,'Dear Student,<br />\r\nThe dashboard is now working.                        <br />\r\n                            ','',0,'2023-03-17 23:12:58',0,0,0,0),(30,163,'2474',363,1,'Thank you once again, Hope we are able to close your grievance.','',0,'2023-03-17 23:13:56',0,0,0,0),(31,159,'1362',363,1,'Dear Parent,<br />\r\nPlease find the Money receipt attached.                            <br />\r\n                            ','studpaymen832938.pdf',0,'2023-03-17 23:15:50',0,0,0,0),(32,159,'1362',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:16:01',0,0,0,0),(33,158,'714',363,1,' Dear Parent,<br />\r\nPlease find the receipt attached.                               <br />\r\n                            ','studpaymen445751.pdf',0,'2023-03-17 23:18:29',0,0,0,0),(34,158,'714',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:18:42',0,0,0,0),(35,142,'2450',363,1,'Dear Student,<br />\r\nPlease find the money receipt attached.                    <br />\r\n                            ','studpaymen786421.pdf',1,'2023-03-17 23:23:36',0,0,0,0),(36,140,'511',363,1,'Dear Student,<br />\r\nIts working now.                                <br />\r\n                            ','',0,'2023-03-17 23:25:40',0,0,0,0),(37,140,'511',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:25:51',0,0,0,0),(38,139,'511',363,1,'Dear Student,<br />\r\nIts working now.                                <br />\r\n                            ','',0,'2023-03-17 23:26:30',0,0,0,0),(39,139,'511',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:26:39',0,0,0,0),(40,108,'6553',363,1,' Dear Student,<br />\r\nSubject combination is now showing on utility dashboard.Kindly proceed with the payment.                           <br />\r\n                            ','',0,'2023-03-17 23:29:53',0,0,0,0),(41,108,'6553',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:30:02',0,0,0,0),(42,106,'790',363,1,'Dear Parent,<br />\r\nThere is an option to switch child on right hand side of our app screen.Kindly click on settings button to switch another child\'s account.                               <br />\r\n                            ','',0,'2023-03-17 23:32:36',0,0,0,0),(43,106,'790',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:32:48',0,0,0,0),(44,98,'435',363,1,'    Thank you once again, Hope we are able to close your grievance.                            <br />\r\n                            ','',0,'2023-03-17 23:40:44',0,0,0,0),(45,73,'2450',363,1,'Dear Student,<br />\r\nHope your issue is resolved and amount is successfully paid from your end.                                <br />\r\n                            ','',0,'2023-03-17 23:44:23',0,0,0,0),(46,73,'2450',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:44:34',0,0,0,0),(47,71,'310',363,1,'Dear Parent,<br />\r\nCOP is now updated.                                <br />\r\n                            ','',0,'2023-03-17 23:45:14',0,0,0,0),(48,71,'310',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:45:24',0,0,0,0),(49,60,'228',363,1,' Dear Parent,<br />\r\nChange of plan is updated now.                              <br />\r\n                            ','',0,'2023-03-17 23:46:34',0,0,0,0),(50,60,'228',363,1,'We hope this helps. Since the issue has been resolved at our end,we are marking this query as closed. Please note this chat will no longer be monitored by the team. Incase of any other queries, kindly raise a new ticket on ODM Connect.','',0,'2023-03-17 23:46:43',0,0,0,0),(51,14,'1030',363,1,'Dear Parent, Please share your issue with description and attachment on other ticket. as this ticket shows no issue i am closing it now.                                <br />\r\n                            ','',0,'2023-03-17 23:49:58',0,0,0,0),(52,39,'565',363,1,'Dear Parent,<br />\r\nPlease share the details of the another student so that I can check.                                <br />\r\n                            ','',0,'2023-03-17 23:51:01',0,0,0,0),(53,0,'NA',363,1,'As the ticket shows no issue we are closing it now.                                <br />\r\n                            ','',0,'2023-03-17 23:51:41',0,0,1,0),(54,53,'600',363,1,'Dear Parent,<br />\r\nPlease share the detail of another student.                                <br />\r\n                            ','',0,'2023-03-17 23:52:57',0,0,0,0),(55,165,'4442',675,1,'Dear Parents, Greetings! Please be informed that student will receive the I\'d card in the new academic session 2023-2024. Request you to kindly co-operate Regards TEAM ODM','',1,'2023-03-18 10:28:37',0,0,0,0),(56,40,'3358',805,1,'Dear Parents Greetings from the ODM family, ok sir we will do the needful                              <br />\r\n                            ','',0,'2023-03-18 11:32:30',0,0,0,0),(57,58,'1221',805,1,'  Dear Parent, Thank you for reaching out to us. Kindly share your location                              <br />\r\n                            ','',0,'2023-03-18 11:33:59',0,0,0,0),(58,61,'6552',805,1,'  Dear Parent, Thank you for reaching out to us. now i Northen height location has been updated                              <br />\r\n                            ','',0,'2023-03-18 11:36:05',0,0,0,0),(59,62,'6551',805,1,'<br />\r\nDear Parent, Thank you for reaching out to us, Sir kindly check master canteen location ,you will find sahid nagar stoppage                                <br />\r\n                            ','',0,'2023-03-18 11:44:44',0,0,0,0),(60,67,'1281',805,1,'Dear Parent, Thank you for reaching out to us, ok  we will update in our end.                            <br />\r\n                            ','',0,'2023-03-18 11:48:41',0,0,0,0),(61,81,'1492',805,1,' Dear Parent, Thank you for reaching out to us, sir our route up to Patia collage, there is no route for Bhoi shai ,Banamali basera                               <br />\r\n                            ','',0,'2023-03-18 11:53:56',0,0,0,0),(62,82,'4447',805,1,' Dear Parent, Greetings of the day! Thank you for reaching out on us. now it has been updated please check                             <br />\r\n                            ','',0,'2023-03-18 12:26:42',0,0,0,0),(63,187,'364',364,2,'Annual exam copy ','',1,'2023-03-18 12:44:10',0,1,1,0),(64,133,'1686',805,1,'Dear parents Good Afternoon kindly mentioned location                           <br />\r\n                            ','',0,'2023-03-18 15:05:46',0,0,0,0),(65,118,'6542',6542,2,'Please confirm me the route of school bus','',1,'2023-03-18 15:20:52',0,0,0,0),(66,192,'6624',805,1,'  Dear parents Good afternoon parents please check in mancheswar location you will find Chakeisiani stoppage                              <br />\r\n                            ','',0,'2023-03-18 15:34:19',0,0,0,0),(67,188,'2425',805,1,'    Dear Yashraj thank you for contacting us, now you can check your patia location ,label crossing stoppage is there. Thank you                            <br />\r\n                            ','',0,'2023-03-18 15:43:47',0,0,0,0),(68,168,'1474',675,1,'Dear Parents, Greetings! Payment for composite fee and books and notebooks has been paid by you and updated in the Connect app. Regards TEAM ODM.','',0,'2023-03-18 17:46:39',0,0,0,0),(69,167,'6612',675,1,'Dear Parents, Greetings! Subject combination is visible in the Connect app. Please click on non - academics - utility dashboard - select book notebook combination. Regards TEAM ODM.','',0,'2023-03-18 17:51:40',0,0,0,0),(70,197,'2220',2220,2,'Kinldy reaolve this issue ','',1,'2023-03-18 19:29:00',0,0,0,0),(71,0,'5793',5794,2,'Today is the last date but still your management is too slow to react','',1,'2023-03-18 20:22:28',0,0,0,0),(72,49,'602',602,2,'I\'m still unable to download payment receipt for utilities ','',1,'2023-03-18 20:57:42',0,0,0,0),(73,0,'5571',5572,2,'Hi','',1,'2023-03-20 09:19:49',0,0,0,0),(74,176,'5373',5374,2,'Hi','',1,'2023-03-20 10:04:03',0,0,0,0),(75,228,'1624',1624,2,'In  school  our  problems  will    slove','',1,'2023-03-20 10:33:35',0,0,0,0),(76,115,'1432',1432,2,'Hello ','',1,'2023-03-20 11:32:29',0,0,0,0),(77,232,'1224',1224,2,'We have already made payment of Rs 7300 as session fee for academic year 2023-24. But it is not yet updated in Odm Connect app. Hence we are not able to pay further for books and notebooks. Please assist immediately so that we can bring the desired books and notebooks for our son Yatharth (std 6) tomorrow as per the schedule','',1,'2023-03-20 12:03:17',0,0,1,0),(78,234,'6635',6635,2,'Good morning Sir/Mam','',1,'2023-03-20 12:11:51',0,0,0,0),(79,132,'1275',363,1,'Dear Parents,  Good Evening, We regret the inconvenience caused to you. We also appreciate you for taking the time to bring this to our notice.<br />\r\n                                <br />\r\n                            ','SONAKSHIpd900494.pdf',0,'2023-03-20 18:33:32',0,0,0,0),(80,216,'5702',5703,2,'Please solve our query..','',1,'2023-03-20 19:45:42',0,0,0,0),(81,2,'1157',1157,2,'No reply','',1,'2023-03-20 22:38:02',1,0,0,0),(82,247,'46',46,2,'Hi','',1,'2023-03-20 22:38:27',0,1,0,0),(83,247,'46',46,2,'My son Arnesh is promoted to class 1','',1,'2023-03-20 22:39:04',0,1,0,0),(84,247,'46',46,2,'Due to some emergency we are out of bbsr','',1,'2023-03-20 22:39:25',0,1,0,0),(85,247,'46',46,2,'So if we pay for the books today and take the the books on school open day, which is April 3, will that be a problem?','',1,'2023-03-20 22:40:23',0,1,0,0),(86,0,'6189',6190,2,'Thanks for converting my daughter\'s section from DS1 to RS1.But no payment link has received yet.','',1,'2023-03-21 08:51:38',0,0,0,0),(87,0,'6189',6190,2,'Kindly send the payment link so that I can pay for my daughter who has been transferred from DS1 to RS1','',1,'2023-03-21 09:38:42',0,0,0,0),(88,247,'46',46,2,'Hi. Any update ?','',1,'2023-03-21 10:21:44',0,1,0,0),(89,200,'5504',5505,2,'Hello , i raised a ticket butnit yet solved','',1,'2023-03-21 12:51:58',0,0,0,0),(90,262,'6651',6651,2,'Hello','',1,'2023-03-21 13:28:20',0,0,0,0),(91,262,'6651',6651,2,'I have a query about bus route','',1,'2023-03-21 13:28:59',0,0,0,0),(92,88,'58',58,2,'Why my request rejected ','',1,'2023-03-21 16:42:50',0,1,0,0),(93,260,'2066',675,1,'Dear Parents, Greetings! Notice will be sent to the parents WhatsApp group for books and notebooks purchase. Regards TEAM ODM.','',1,'2023-03-21 17:02:28',0,0,0,0),(94,240,'6012',675,1,'Dear Parents, Greetings! Please brief your concern which will help us to address. Regards TEAM ODM.','',0,'2023-03-21 17:04:34',0,0,0,0),(95,214,'1135',675,1,'Dear Parents, Greetings! Please share the transaction details of the student. Regards TEAM ODM.','',0,'2023-03-21 17:12:54',0,0,0,0),(96,214,'1135',675,1,'Dear Parents, Please ignore the previous message and share the transaction details of the payment made by you which will help us to forward your request to the concerned department. Regards TEAM ODM.','',0,'2023-03-21 17:15:04',0,0,0,0),(97,207,'385',675,1,'Dear Parents, Greetings! Please download the receipt from the money receipt option. Regards TEAM ODM.','',0,'2023-03-21 17:19:23',0,0,0,0),(98,268,'1594',1594,2,'Hi','',1,'2023-03-21 17:34:17',0,0,0,0),(99,41,'276',276,2,'Good evening ','',1,'2023-03-21 18:59:20',0,0,0,0),(100,41,'276',276,2,'Pls check my query ','',1,'2023-03-21 18:59:41',0,0,0,0),(101,241,'966',966,2,'Issue not yet solved. Kindly resolve','',1,'2023-03-22 07:28:23',0,0,0,0),(102,287,'661',661,2,'Hi','',1,'2023-03-22 13:09:40',0,1,0,0),(103,287,'661',661,2,'I wrongly ordered higher Hindi and lower odiya ','',1,'2023-03-22 13:09:57',0,1,0,0),(104,50,'216',216,2,'Still waiting ','',1,'2023-03-22 13:24:32',0,0,0,0),(105,288,'2407',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come down to school on 24.03.23 to see the answer copies of your ward. Kindly come to B block, Ground floor in-between 7-8 am.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 17:40:56',0,0,1,0),(106,276,'2192',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school on 24.03.23; B Block Second Floor in-between 10-11 am.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 17:44:14',0,0,0,0),(107,272,'799',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come down to school on 24.03.23 to see the answer copies of your ward. Kindly come to B block, Ground floor-BG-5 in-between 9:30-10 am.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 17:49:37',0,0,0,0),(108,272,'799',799,2,'Hi','',1,'2023-03-22 17:55:12',1,0,0,0),(109,272,'799',799,2,'As this query is solved','',1,'2023-03-22 17:55:50',1,0,0,0),(110,272,'799',799,2,'But i didn\'t receive any information details ','',1,'2023-03-22 17:56:25',1,0,0,0),(111,272,'799',799,2,'Please guide me','',1,'2023-03-22 17:56:43',1,0,0,0),(112,272,'799',799,2,'Sorry thank you','',1,'2023-03-22 17:58:20',1,0,0,0),(113,272,'799',799,2,'One qq','',1,'2023-03-22 18:14:25',1,0,0,0),(114,272,'799',799,2,'As my kid given the examin BDA branch still we need to go  main branch? ','',1,'2023-03-22 18:15:41',1,0,0,0),(115,263,'956',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school on 24.03.23 at B Block Room No. BG-5 in-between 10-10:30 am.<br />\r\nRegards.<br />\r\n                                 <br />\r\n                            ','',0,'2023-03-22 18:45:43',0,0,0,0),(116,235,'3385',459,1,'Dear Parent, <br />\r\nGreetings of the day. Request you to come to the school on 24.03.23 at B Block Ground floor in-between 7-8 am to see the answer copies. <br />\r\nRegards.											<br />\r\n                                <br />\r\n                            ','',0,'2023-03-22 18:56:18',0,0,0,0),(117,226,'822',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copies.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 19:02:03',0,0,0,0),(118,225,'951',459,1,' Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copies.<br />\r\nRegards.                             <br />\r\n                            ','',0,'2023-03-22 19:06:46',0,0,0,0),(119,170,'1741',459,1,'Dear Parent, <br />\r\nGreetings of the day. Request you to come to the school on 24.03.23 at B Block second floor in-between 10-11 am to see the answer copies. <br />\r\nRegards.										<br />\r\n                                <br />\r\n                            ','',0,'2023-03-22 19:13:47',0,0,0,0),(120,134,'1645',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nIt\'s a technical issue and we are working on it. The changes will be automatically reflected in the ODM Connect. Kindly bear with us.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 19:19:07',0,0,0,0),(121,123,'2372',459,1,'Dear Parent,<br />\r\nGreetings of the day. Request you to come to the school on 24.03.23 at B Block Ground floor in-between 7-8 am to see the answer copies.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 19:20:15',0,0,0,0),(122,21,'2255',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly let us know the issue that you want to get rectified in the report card.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 19:44:05',0,0,0,0),(123,265,'1102',459,1,' Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.<br />\r\n                            ','',0,'2023-03-22 20:22:33',0,0,0,0),(124,181,'914',459,1,' Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                               <br />\r\n                            ','',0,'2023-03-22 20:26:10',0,0,0,0),(125,160,'1089',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 20:28:39',0,0,0,0),(126,110,'1196',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 20:30:38',0,0,0,0),(127,96,'1206',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 20:31:12',0,0,0,0),(128,78,'3376',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 20:34:39',0,0,0,0),(129,44,'1125',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly find the report card attached for your reference.<br />\r\nRegards.                               <br />\r\n                            ','YAJNESHKUM632065.pdf',0,'2023-03-22 20:38:11',0,0,0,0),(130,33,'1051',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 20:38:54',0,0,0,0),(131,23,'2415',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-22 20:39:34',0,0,0,0),(132,19,'2272',459,1,'Dear Parent,<br />\r\nGreetings of the day. <br />\r\nRequest you to come to the school on 24.03.23 at B Block Ground floor in-between 7-8 am to see the answer copies.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 20:41:16',0,0,0,0),(133,18,'2179',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school on 24.03.23; B Block Second Floor in-between 10-11 am.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 20:42:42',0,0,0,0),(134,8,'5128',459,1,'Dear Parent,<br />\r\nThe issue has been resolved, kindly find the report card attached for your reference.<br />\r\nRegards.                                <br />\r\n                            ','SHIVAANSHS723930.pdf',0,'2023-03-22 20:45:44',0,0,0,0),(135,2,'1157',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school on 24.03.23; B Block Second Floor in-between 10-11 am.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-22 20:47:46',0,0,0,0),(136,2,'1157',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly ignore the above message. <br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.','',1,'2023-03-22 20:49:20',0,0,0,0),(137,299,'409',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nA date and time slot will be intimated to you to see the answer copy.<br />\r\nRegards.                           <br />\r\n                            ','',0,'2023-03-22 20:50:46',0,0,0,0),(138,50,'216',216,2,'Waiting for quick response.','',1,'2023-03-22 22:20:12',0,0,0,0),(139,250,'2475',2475,2,'School is opening tomorrow and it is very sad to message that till date my query has not been answered.','',1,'2023-03-23 06:36:32',0,0,0,0),(140,214,'1135',675,1,'Dear Parents, Greetings ! As we didn\'t received any response from your side, we are closing this ticket.Please raise a new ticket for the grievance. Thanks TEAM ODM.','',0,'2023-03-23 08:28:56',0,0,0,0),(141,240,'6012',675,1,'Dear Parents, Greetings! As we didn\'t received any response from your side, we are closing this ticket.Please raise a new ticket for the grievance.Regards TEAM ODM.','',0,'2023-03-23 08:31:46',0,0,0,0),(142,0,'5735',5736,2,'Please do respond','',1,'2023-03-23 10:04:30',0,0,0,0),(143,284,'672',363,1,'Dear Parent, Greetings! It has been done. Thanks, TEAM ODM.    ','',0,'2023-03-23 12:31:22',0,0,0,0),(144,246,'1390',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 24.03.23, at B Block Second floor in-between 10-11am.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-23 12:38:25',0,0,0,0),(145,302,'1032',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 24.03.23; at B Block Room No. BG-5 in-between 10:30-11 am.<br />\r\nRegards.                              <br />\r\n                            ','',1,'2023-03-23 12:45:40',0,0,0,0),(146,297,'428',675,1,'Dear Parents, Greetings! Utility store is in OPS only not in BDA. So parents have to purchase it from OPS only. Thanks TEAM ODM.','',0,'2023-03-23 12:48:19',0,0,0,0),(147,308,'5286',675,1,'Dear Parents, Greetings! Your request has been forwarded to the concerned department. Will let you know once we receive any confirmation on the same. Regards TEAM ODM','',0,'2023-03-23 13:45:38',0,0,0,0),(148,31,'2156',2156,2,'Whether ur complaint mechanism system is working or not','',1,'2023-03-23 13:57:32',0,0,0,0),(149,254,'3388',3388,2,'Sir, no reply.?','',1,'2023-03-23 15:30:07',0,1,0,0),(150,137,'5174',5175,2,'Helloo','',1,'2023-03-23 16:58:28',0,0,0,0),(151,137,'5174',5175,2,'Kindly confirm me about the school campus change to sisubihar from bda ','',1,'2023-03-23 17:00:20',0,0,0,0),(152,272,'799',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly visit the BDA (OKW) campus on 27.03.23 in-between 9-9:30 am. We regret for the inconvenience.<br />\r\nRegards.                                <br />\r\n                            ','',1,'2023-03-23 17:34:24',0,0,0,0),(153,226,'822',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 8:30-9 am.   <br />\r\nRegards.                            <br />\r\n                            ','',0,'2023-03-23 17:37:37',0,0,0,0),(154,299,'409',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 9-9:30 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',0,'2023-03-23 17:39:12',0,0,0,0),(155,181,'914',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 8:30-9 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',0,'2023-03-23 17:40:05',0,0,0,0),(156,181,'914',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come in-between 9:30-10 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',0,'2023-03-23 17:42:15',0,0,0,0),(157,263,'956',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 10-10:30 am.  We, regret for the inconvenience caused.<br />\r\n<br />\r\nRegards.                            <br />\r\n                                                      <br />\r\n                            ','',0,'2023-03-23 17:44:31',0,0,0,0),(158,225,'951',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 9-9:30  am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',0,'2023-03-23 17:45:49',0,0,0,0),(159,78,'3376',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 9:30-10 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',1,'2023-03-23 17:46:34',0,0,0,0),(160,33,'1051',459,1,' Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 9-9:30 am.   <br />\r\nRegards.                            <br />\r\n                                                      <br />\r\n                            ','',0,'2023-03-23 17:47:16',0,0,0,0),(161,265,'1102',459,1,' Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 8:30-9 am.   <br />\r\nRegards.                            <br />\r\n                                                      <br />\r\n                            ','',0,'2023-03-23 17:47:53',0,0,0,0),(162,160,'1089',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 9-9:30 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',1,'2023-03-23 17:48:35',0,0,0,0),(163,110,'1196',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 10-10:30 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',0,'2023-03-23 17:49:18',0,0,0,0),(164,96,'1206',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 8:30-9 am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',0,'2023-03-23 17:49:43',0,0,0,0),(165,2,'1157',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor, in-between 9:30-10  am.   <br />\r\nRegards.                            <br />\r\n                                                       <br />\r\n                            ','',1,'2023-03-23 17:50:56',0,0,0,0),(166,305,'1679',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 24.03.23, at B Block Second floor in-between 10-11 am.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-23 18:01:24',0,0,0,0),(167,304,'3404',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 24.03.23, at B Block Second floor in-between 10-11 am.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-23 18:01:58',0,0,0,0),(168,301,'1601',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 24.03.23, at B Block Second floor in-between 10-11 am.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-23 18:02:32',0,0,0,0),(169,314,'2413',2413,2,'I want to change my section from A to C','',1,'2023-03-23 20:00:33',0,1,1,0),(170,317,'6340',677,1,'Dear parent ,Greetings of the day ,we are going to 2nd slot books & NB distribution circular will be sent to the parents group so kindly collect it from our utility store.<br />\r\n              <br />\r\n                            ','',0,'2023-03-24 10:02:36',0,0,0,0),(171,295,'571',677,1,'Dear parent, Greetings of the day ,sorry for the inconvenience , due to vehicle strike of Odisha vendor unable to deliver on time. Rest books we will give to students in their classroom.          <br />\r\n                            ','',1,'2023-03-24 10:09:36',0,0,0,0),(172,287,'661',677,1,'Dear parent ,Greetings of the day ,we are going to 2nd slot books & NB distribution circular will be sent to the parents group so kindly come this day & change ur language books & NB.','',0,'2023-03-24 10:12:45',0,0,0,0),(173,279,'779',677,1,'Dear Parent, Greetings of the day Sorry for the inconvenience, this is the actual price,            <br />\r\n                            ','',0,'2023-03-24 10:14:51',0,0,0,0),(174,266,'1730',677,1,'Dear parent ,Greetings of the day , Sorry for the inconvenience we are going to 2nd slot books & NB distribution, circular will be sent to the parents group so kindly come  & collect Books & NB.   <br />\r\n                            ','',0,'2023-03-24 10:16:52',0,0,0,0),(175,261,'2239',677,1,'ear parent ,Greetings of the day ,we are going to 2nd slot books & NB distribution circular will be sent to the parents group so kindly come this day collect NB & Books.                            <br />\r\n                            ','',0,'2023-03-24 10:19:59',0,0,0,0),(176,254,'3388',677,1,'Dear parent ,Greetings of the day ,sorry for the late reply,  we will give the student in their classroom.<br />\r\n','',1,'2023-03-24 10:24:38',0,0,0,0),(177,247,'46',677,1,'Dear Parent, greetings of the day, we are going to 2nd slot books & NB distribution circular will be sent to the parents group so on this day kindly collect it from our utility store. April 3rd we cant give the Books & NB.<br />\r\n                            ','',0,'2023-03-24 10:28:26',0,0,0,0),(178,229,'1748',677,1,'Dear Parent, greetings of the day, Yes sir mandatory for math & science books.                         <br />\r\n                            ','',0,'2023-03-24 10:30:07',0,0,0,0),(179,222,'2325',677,1,'Dear Parent, greetings of the day , Sorry for the inconvenience, after payment go to the money receipt option their is option for download money receipt for books & NB .                       <br />\r\n                            ','',0,'2023-03-24 10:32:37',0,0,0,0),(180,55,'6411',677,1,'Dear Parent, Greetings of the day, come to the uniform counter collect the uniform and pay. ( offline)<br />\r\n                <br />\r\n                            ','',0,'2023-03-24 10:42:12',0,0,0,0),(181,249,'763',555,1,'          Dear Parent,       Greetings. The Spell Bee results will be declared in a week\'s time as the next level venue will be soon finalized but the date will be around 30th April. About the IMO kindly enquire from the class teacher or from Gitabali madam.                                                                             <br />\r\n                            ','',0,'2023-03-24 11:33:25',0,0,0,0),(182,294,'196',593,1,'Dear Parents, Greetings from the ODM family. Kindly let us know the issue of raising your grievance. Thank you ','',0,'2023-03-24 12:44:58',0,0,0,0),(183,238,'97',593,1,'Dear Parents, Greetings from the ODM family. Your child has been allotted to section C. Thank you for reaching out to us. Good day ahead.','',0,'2023-03-24 12:47:27',0,0,0,0),(184,124,'5269',593,1,'Dear Parents, Greetings from the ODM family. In Std I we have to choose only from either Hindi or Odia. ( Any 1). Thank you and have a great day ahead.','',0,'2023-03-24 12:54:13',0,0,0,0),(185,89,'58',593,1,'Dear Parents, Greetings from the ODM family. The academic coordinator had a telephonic conversation with you and we are pleased to know that you are completely fine with the section change of your ward. We are really thankful for all your understanding and cooperation. Thank you and have a great day ahead.','',0,'2023-03-24 13:08:00',0,0,0,0),(186,88,'58',593,1,'Dear Parents, Greetings from the ODM family. The academic coordinator had a telephonic conversation with you and we are pleased to know that you are completely fine with the section change of your ward. We are really thankful for all your understanding and cooperation. Thank you and have a great day ahead.<br />\r\n','',0,'2023-03-24 13:08:41',0,0,0,0),(187,0,'NA',564,1,'     Dear sir /Madam,please come to school on 27/03/2023 between 10am to 1 pm and collect your wards TC.                         <br />\r\n                            ','',0,'2023-03-24 13:40:44',0,0,1,0),(188,190,'1073',564,1,'Dear sir/Madam Affiliation letter already reflect in our web site you can download there. that sub menu name is mandatory disclosure in our web site..     Regards.                 <br />\r\n                            ','',0,'2023-03-24 13:46:25',0,0,0,0),(189,220,'536',564,1,'      Dear sir/Madam please come to school on 27/03/2023 between 10 am to 1 pm and collect your SLC. Regards                          <br />\r\n                            ','',0,'2023-03-24 13:47:46',0,0,0,0),(190,254,'3388',3388,2,'Thank you Sir.','',1,'2023-03-24 14:38:33',0,0,0,0),(191,0,'5885',5886,2,'Good afternoon ma\'am Myself Trisha sahoo of class 12 Ds2 Ma\'am I am having defaulter issues can you please check and tell me what are my pending payments because I am not able to find any pending payments in odm connect.','',1,'2023-03-24 14:57:15',0,0,0,0),(192,0,'5885',5886,2,'Good afternoon ma\'am Myself Trisha sahoo of class 12 Ds2 Ma\'am I am having defaulter issues can you please check and tell me what are my pending payments because I am not able to find any pending payments in odm connect.','',1,'2023-03-24 14:57:26',0,0,0,0),(193,0,'5885',5886,2,'Good afternoon ma\'am Myself Trisha sahoo of class 12 Ds2 Ma\'am I am having defaulter issues can you please check and tell me what are my pending payments because I am not able to find any pending payments in odm connect.','',1,'2023-03-24 14:58:15',0,0,0,0),(194,308,'5286',675,1,'Dear Parents, Greetings! Meeting has been scheduled with the Vice principal ma\'am on 31st March 2023 at 9am. Regards TEAM ODM','',0,'2023-03-24 15:12:33',0,0,0,0),(195,320,'1003',675,1,'Dear Parents, Greetings! Please make the payment of composite fee and books and note books in the ODM connect and collect it from the utility store on certain date shared on WhatsApp group. Thanks TEAM ODM.','',0,'2023-03-24 15:16:50',0,0,0,0),(196,331,'6473',6473,2,'Hello','',1,'2023-03-24 15:42:48',0,0,1,0),(197,331,'6473',6473,2,'anyone der?','',1,'2023-03-24 15:42:58',0,0,1,0),(198,143,'3368',363,1,'Dear Parent, Greetings! Request you to please share the screenshot of the ID card which will help us to correct the information mentioned in it. Regards Team ODM     <br />\r\n                            ','',0,'2023-03-24 15:49:35',0,1,0,0),(199,149,'5444',363,1,'Dear Parent, Greetings! Please share the screenshot of the ID card so that we can correct it and process it further. Regards Team ODM                              <br />\r\n                            ','',1,'2023-03-24 15:52:53',0,1,0,0),(200,79,'6552',363,1,'Dear Parent, Greetings! As per Odm connect app is it visible that the payment has been done for Books and Notebooks. Regards Team ODM                       <br />\r\n                            ','',0,'2023-03-24 15:59:11',0,0,0,0),(201,237,'1112',1112,2,'What happened sir','',1,'2023-03-24 19:50:50',0,0,0,0),(202,237,'1112',1112,2,'There is no response from your end still I am waiting for recheck','',1,'2023-03-24 19:52:11',0,0,0,0),(203,337,'235',235,2,'When can I get the response?','',1,'2023-03-25 08:57:00',0,1,1,0),(204,149,'5444',363,1,'Dear Parent, Greetings! we are still waiting for the screenshot of the ID card kindly share the same for further process. Regards Team ODM.<br />\r\n                            ','',1,'2023-03-25 09:52:03',0,1,0,0),(205,143,'3368',363,1,'Dear Parent, Greetings! we are still waiting for screenshot of the ID card please share the same to proceed further. Regards Team ODM.              <br />\r\n                            ','',0,'2023-03-25 09:54:23',0,1,0,0),(206,338,'213',213,2,'Can i collect the books and note books of my daughter studying innclass 2. ','',1,'2023-03-25 10:33:56',0,1,0,0),(207,338,'213',213,2,'Today','',1,'2023-03-25 10:34:12',0,1,0,0),(208,338,'213',593,1,'Dear Parents, Greetings from the ODM family. The schedule for the distribution of books and notebooks for Std II is already over. We will be notifying the second slot soon, for parents who could not avail the books and notebooks on the given scheduled date. Information regarding the same will be intimated in the parents group. Thank you.','',0,'2023-03-25 11:16:04',0,0,0,0),(209,339,'1575',363,1,'Dear Parents, Greetings! Notification will be sent to you in the WhatsApp group for the second phase distribution of the books and notebooks. Regards Team TEAM.','',1,'2023-03-25 11:18:15',0,0,0,0),(210,337,'235',593,1,'Dear Parents, Greetings from the ODM family. The distribution of books and notebooks for Std II is already over and we will be giving the second date for distribution of the above in the parents group soon. Thank you and have a great day ahead. ','',1,'2023-03-25 11:18:28',0,0,0,0),(211,337,'235',235,2,'How it\'s over? We visited they told books are not available?','',1,'2023-03-25 11:19:57',0,0,0,0),(212,337,'235',235,2,'Books are allotted as per the payment details then how it\'s over? ','',1,'2023-03-25 11:21:11',0,0,0,0),(213,337,'235',235,2,'Book must be available as per the student count those who paid in advance?','',1,'2023-03-25 11:22:13',0,0,0,0),(214,340,'6578',593,1,'Dear Parents, Greetings from the ODM family. We understand your concern regarding the issue. We will be changing your request from Odia to Hindi. I got to know from the Classteacher that you haven\'t taken the books so kindly take the books when the second date of distribution will be posted in the parents group. Thank you and have a great day ahead.','',1,'2023-03-25 11:32:57',0,0,0,0),(215,334,'1018',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come to the school on 27.03.23 to see the answer paper. Time will be intimated to you.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-25 13:08:03',0,0,0,0),(216,326,'1051',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nOn 25.03.23 your request have been replied (Kindly refer to the earlier request that you raised). <br />\r\nPlease come to the school to see the answer paper on 27.03.23 to B Block Ground floor, in-between 9-9:30 am.<br />\r\nRegards.  <br />\r\n                            <br />\r\n                            ','',0,'2023-03-25 13:16:51',0,0,0,0),(217,324,'3462',459,1,'   Dear Parent,<br />\r\nGreetings of the day.<br />\r\nThe computer answer copy of your ward has been sent for rechecking; changes if any will be intimated to you through the ODM Connect. <br />\r\nRegarding the percentage: it\'s is an technical issue and we are working on it this might take some days and, changes will be automatically reflected in the ODM Connect.<br />\r\nRegards.                             <br />\r\n                            ','',0,'2023-03-25 13:23:05',0,0,0,0),(218,323,'750',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor. Time will be intimated to you. You may call the class teacher as well for information.<br />\r\nRegards.                               <br />\r\n                            ','',1,'2023-03-25 13:25:08',0,0,0,0),(219,318,'891',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor. Time will be intimated to you. You may call the class teacher for more information.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-25 13:27:26',0,0,0,0),(220,316,'1018',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nRequest you to come to the school to see the answer copies on 27.03.23, at B Block Ground floor. Time will be intimated to you. You may call the class teacher for more information.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-25 13:29:01',0,0,0,0),(221,93,'1102',1102,2,'Why it is rejected','',1,'2023-03-25 13:31:45',1,0,0,0),(222,93,'1102',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nYou have raised two tokens (93 and 265) with same issue. So, one has been accepted and the other has been rejected.<br />\r\nRegards.                                <br />\r\n                            ','',0,'2023-03-25 13:55:36',0,0,0,0),(223,260,'2066',2066,2,'Till now their is no update about 2nd books and notebook distribution ','',1,'2023-03-25 14:12:37',0,0,0,0),(224,0,'5591',5592,2,'Hallo sir','',1,'2023-03-25 14:37:19',0,0,0,0),(225,341,'493',593,1,'Dear Parents, Greetings from the ODM family. The dates for Std 3 books and notebooks distribution is already over, the second date will be posted in the official Parents group soon. Thank you.','',0,'2023-03-25 16:03:04',0,0,0,0),(226,343,'6578',593,1,'Dear Parents, Greetings from the ODM family. We will change the subject as per your raised request. Thank you. ','',0,'2023-03-25 16:04:03',0,0,0,0),(227,334,'1018',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come to the school on 27.03.23 in-between 9:30-10 am to see the answer paper.     <br />\r\nRegards                     <br />\r\n                            ','',0,'2023-03-25 17:14:34',0,0,0,0),(228,316,'1018',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come to the school on 27.03.23 in-between 9:30-10 am to see the answer paper.     <br />\r\nRegards                                      <br />\r\n                            ','',0,'2023-03-25 17:15:48',0,0,0,0),(229,326,'1051',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come to the school on 27.03.23 in-between 8:30-9 am to see the answer paper.     <br />\r\nRegards                                      <br />\r\n                            ','',0,'2023-03-25 17:16:58',0,0,0,0),(230,323,'750',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come to the school on 27.03.23 in-between 8:30-9 am to see the answer paper.     <br />\r\nRegards                                      <br />\r\n                            ','',1,'2023-03-25 17:18:57',0,0,0,0),(231,318,'891',459,1,'Dear Parent,<br />\r\nGreetings of the day.<br />\r\nKindly come to the school on 27.03.23 in-between 9-9:30 am to see the answer paper.     <br />\r\nRegards                                      <br />\r\n                            ','',0,'2023-03-25 17:19:57',0,0,0,0),(232,333,'5304',675,1,'Dear Parent, Greetings! We are looking into it. Request you to kindly co-operate.Thanks TEAM ODM.','',1,'2023-03-25 17:35:11',0,0,1,0),(233,342,'2375',363,1,'Dear Parent, Greetings! Please confirm which meeting you are talking about. Thanks, TEAM ODM                  <br />\r\n                            ','',0,'2023-03-25 17:37:29',0,1,0,0),(234,344,'1259',363,1,'Dear Parents, Greetings! Notice will be sent over WhatsApp for the same.Thanks, TEAM ODM.             ','',0,'2023-03-25 17:39:12',0,0,0,0),(235,356,'6606',593,1,'Dear Parents, Greetings from the ODM family. In Std I we have to choose between Hindi or Odia, so please choose the desired subject and inform the class teacher about the same. The class teacher needs to record the same for future reference. Thank you and have a great day ahead.','',0,'2023-03-27 08:13:57',0,0,0,0),(236,358,'2475',363,1,'Dear Parent Greetings ! Please elaborate your issues so that we can process further with the concerned department. Regards Team ODM.','',1,'2023-03-27 10:04:34',0,1,0,0),(237,358,'2475',2475,2,'I have changed my son\'s section from Scholar batch to day scholar in tenth. Now, he is in class X-B. After several messages in odm connect my number has not been added to the parents group of the class. The phone number of class teacher is not given for which I couldn\'t connect to her. The weekly routine is not available with me. As the number of Academic coordinator is not available. In previous year we have the number of Samarjeet sir and I never faced such kind of problem as I am facing this year.','',1,'2023-03-27 10:35:17',0,1,1,0),(238,342,'2375',363,1,'Dear Parent, Greetings! Please confirm which meeting you are talking about. Thanks, Team ODM           ','',0,'2023-03-27 10:47:43',0,1,0,0),(239,310,'433',677,1,'Dear Parent ,greetings of the day, We will distribute rest books  in their  classrooms .                <br />\r\n                            ','',0,'2023-03-27 10:52:12',0,0,0,0),(240,281,'2473',677,1,'Dear Parent, greetings of the day , 2nd slot books & NB already sent to the parents group that is 28 march 2023 will distribute. kindly collect in our utility store on this date.                       <br />\r\n                            ','',0,'2023-03-27 10:54:26',0,0,0,0),(241,244,'5344',677,1,'Dear Parent, greetings of the day , 28 th march 23 we will distribute books & NB Kindly collect in our utility store on this date  ,timing & date also shared in parents group.','ODMEG20230634312.pdf',0,'2023-03-27 11:00:25',0,0,0,0),(242,218,'796',677,1,'Dear Parents , greetings of the day , 2nd slot books & Nb distribution date & time shared with Parents Group(28th march23), I am sending also please check the attachment<br />\r\n                            ','ODMEG20230156941.pdf',0,'2023-03-27 11:03:07',0,0,0,0),(243,172,'1741',677,1,'Dear Parents, Greetings of the day, sorry for the inconvenience, there is no option for only notebooks,                              <br />\r\n                            ','',0,'2023-03-27 11:12:35',0,0,0,0),(244,143,'3368',675,1,'Dear Parents, Greetings! As we didn\'t received any response from your side.We are closing this ticket. Please raise a new request for the grievance.Thanks TEAM ODM.','',0,'2023-03-27 11:51:40',0,0,0,0),(245,36,'35',677,1,'Dear Parent, Greetings of the day, sorry for the inconvenience, single rule 13 copy -english-3,mathematics-3,test copy-4,additional notebooks-3<br />\r\n                            ','',0,'2023-03-27 12:02:00',0,0,0,0),(246,149,'5444',363,1,'Dear Parent, Greetings! as we did not received any response from your side we are closing this ticket please raise a new request for the grievance. Thanks Team ODM<br />\r\n                            ','',1,'2023-03-27 12:19:53',0,0,0,0),(247,149,'5444',5445,2,'Pls change the name from REENA PRADHAN TO REENA MANI PRADHAN','',1,'2023-03-27 13:09:13',0,0,0,0),(248,333,'5304',675,1,'Dear Parents, Greetings! You can exchange the drawing notebook tomorrow ( 28 March,2023) from 4.30 pm - 5.00 pm. Regards TEAM ODM.','',1,'2023-03-27 15:52:49',0,0,1,0),(249,333,'5304',5305,2,'So you are suggesting me I will again go to school again during my ofice hour spending Rs 50 to get get back Rs 54 worth notebook? Please learn to value others time and money.','',1,'2023-03-27 17:50:57',0,0,0,0),(250,358,'2475',363,1,'Dear Parent Greetings ! Please confirm the section allotted to your child so that we can add the provided number to the WhatsApp group.           Regards Team ODM                      <br />\r\n                            ','',0,'2023-03-27 17:54:56',0,0,0,0),(251,363,'1426',363,1,'Dear Parent Greetings ! Please mention the reason for the appointment which will help us to proceed your request. Regards Team ODM.<br />\r\n                            ','',0,'2023-03-27 17:57:19',0,0,0,0);

--
-- Table structure for table `sb_help_desk_chat_user_employee`
--

CREATE TABLE `sb_help_desk_chat_user_employee` (
  `hdcue_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `hdcue_raise_id` int(11) DEFAULT NULL,
  `hdcue_user_id` int(11) DEFAULT NULL,
  `hdcue_emp_id` int(11) DEFAULT '0',
  `hdcue_student_id` int(11) DEFAULT NULL,
  `hdcue_type` int(11) DEFAULT NULL,
  `hdcue_message` varchar(1000) DEFAULT NULL,
  `hdcue_attachment` varchar(2000) DEFAULT NULL,
  `hdcue_seen_status` int(11) DEFAULT '0',
  `hdcue_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  `hdcue_seen_by_type` int(11) DEFAULT '0',
  `hdcue_seen_by_sub_type` int(11) DEFAULT '0',
  `hdcue_seen_by_admin` int(11) DEFAULT '0',
  `hdcue_seen_by_other` int(11) DEFAULT '0',
  `hdcue_mension_user_ids` varchar(255) DEFAULT NULL,
  `hdcue_mension_status` int(11) DEFAULT '0' COMMENT '0-new 1-close',
  PRIMARY KEY (`hdcue_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_help_desk_chat_user_employee`
--

INSERT INTO `sb_help_desk_chat_user_employee` VALUES (1,0,772,0,0,1,'nothing is showing in this ticket','',0,'2023-03-18 10:01:48',0,0,1,1,'',0);

--
-- Table structure for table `sb_help_desk_grievance_user`
--

CREATE TABLE `sb_help_desk_grievance_user` (
  `gu_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `gu_user_id` int(11) DEFAULT NULL,
  `gu_status` int(11) DEFAULT NULL,
  `gu_added_by` int(11) DEFAULT NULL,
  `du_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`gu_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_help_desk_grievance_user`
--

INSERT INTO `sb_help_desk_grievance_user` VALUES (3,606,1,363,'2022-07-05 13:01:27'),(5,0,1,604,'2022-09-03 12:25:22'),(6,382,1,382,'2022-09-03 13:39:09');

--
-- Table structure for table `sb_help_desk_logs`
--

CREATE TABLE `sb_help_desk_logs` (
  `hdlog_pk_id` int(11) NOT NULL AUTO_INCREMENT,
  `hdlog_fk_id` int(11) DEFAULT NULL,
  `hdlog_user_id` int(11) DEFAULT NULL,
  `hdlog_action` varchar(45) DEFAULT NULL,
  `hdlog_type` int(11) DEFAULT '1',
  `hdlog_remark` varchar(1000) DEFAULT NULL,
  `hdlog_datetime` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`hdlog_pk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `sb_help_desk_logs`
--

INSERT INTO `sb_help_desk_logs` VALUES (1,60,675,'hds_re_assign',1,'','2023-03-17 09:54:40'),(2,59,675,'hds_re_assign',1,'','2023-03-17 12:21:33'),(3,65,526,'hds_re_assign',1,'Dear Team \n\nKindly look into  the matter .','2023-03-17 17:32:18'),(4,120,526,'hds_re_assign',1,'Dear team \n\nKindly help the parent with their raised concern .','2023-03-17 17:34:10'),(5,137,675,'hds_re_assign',1,'','2023-03-18 10:13:30'),(6,190,675,'hds_re_assign',1,'','2023-03-18 16:24:40'),(7,176,675,'hds_re_assign',1,'','2023-03-18 17:41:36'),(8,172,526,'hds_re_assign',1,'Dear Team \n\nKindly do the needful !','2023-03-20 07:09:55'),(9,173,526,'hds_re_assign',1,'Dear team \n\nKindly aasist the parent ','2023-03-20 07:11:20'),(10,222,526,'hds_re_assign',1,'Dear Team \n\nKinfly assist the team!','2023-03-20 07:12:01'),(11,75,526,'hds_re_assign',1,'Dear team \nKindly reply to the concern !','2023-03-20 07:13:36'),(12,3467,587,'hds_re_assign',1,'DO THE NEED FULL','2023-03-20 18:34:42'),(13,266,675,'hds_re_assign',1,'Kindly look into it.','2023-03-21 16:38:14'),(14,263,675,'hds_re_assign',1,'','2023-03-21 17:00:24'),(15,238,675,'hds_re_assign',1,'Kindly look into it.','2023-03-21 17:09:53'),(16,238,675,'hds_re_assign',1,'Kindly look into it.','2023-03-21 17:44:58'),(17,254,526,'hds_re_assign',1,'Dear Team \n\nKindly address the concern of the parents ','2023-03-22 07:02:22'),(18,261,526,'hds_re_assign',1,'Dear Team \n\nKindly address the concern of the team.','2023-03-22 07:03:20'),(19,246,526,'hds_re_assign',1,'Dear Team \n Kindly look into the matter ','2023-03-22 12:27:58'),(20,282,526,'hds_re_assign',1,'Dear Sir,\nKindly Reply to the queries of the child.','2023-03-22 12:35:52'),(21,293,675,'hds_re_assign',1,'','2023-03-22 17:47:00'),(22,249,459,'hds_re_assign',1,'Dear Team,\nThe parent is enquiring about SPELL BEE EXAM.\nRegards.','2023-03-22 18:53:39'),(23,76,459,'hds_re_assign',1,'Dear Team,\nKindly re-assign to the BDA team, I don\'t deal with it.\nRegards.','2023-03-22 19:33:02'),(24,238,675,'hds_re_assign',1,'','2023-03-23 08:54:16'),(25,277,675,'hds_re_assign',1,'Please look into it','2023-03-23 09:12:27'),(26,283,363,'hds_re_assign',1,'Issue regarding section.please see to this.','2023-03-23 12:20:58'),(27,291,675,'hds_re_assign',1,'Please look into it ','2023-03-23 12:32:13'),(28,295,675,'hds_re_assign',1,'Please look into it.','2023-03-23 12:39:17'),(29,313,363,'hds_re_assign',1,'','2023-03-23 17:32:19'),(30,312,363,'hds_re_assign',1,'','2023-03-23 17:32:43'),(31,311,363,'hds_re_assign',1,'','2023-03-23 17:33:04'),(32,173,677,'hds_re_assign',1,'','2023-03-24 10:34:17'),(33,172,677,'hds_re_assign',1,'','2023-03-24 10:36:03'),(34,79,677,'hds_re_assign',1,'','2023-03-24 10:36:33'),(35,75,677,'hds_re_assign',1,'','2023-03-24 10:37:23'),(36,283,593,'hds_re_assign',1,'Kindly connect the parents and do the needful.','2023-03-24 12:42:45'),(37,310,593,'hds_re_assign',1,'Kindly do the needful.','2023-03-24 12:43:32'),(38,244,593,'hds_re_assign',1,'Kindly do the needful.','2023-03-24 12:45:46'),(39,281,526,'hds_re_assign',1,'Dear Team\n\nKindly look into the matter.','2023-03-24 12:47:01'),(40,237,593,'hds_re_assign',1,'Kindly do the needful.','2023-03-24 12:48:51'),(41,218,593,'hds_re_assign',1,'Kindly do the needful.','2023-03-24 12:50:00'),(42,187,593,'hds_re_assign',1,'Kindly do the needful.','2023-03-24 12:50:55'),(43,36,593,'hds_re_assign',1,'Kindly do the needful.','2023-03-24 12:56:54'),(44,22,564,'hds_re_assign',1,'please check it. ','2023-03-24 13:38:03'),(45,149,564,'hds_re_assign',1,'please sir check it','2023-03-24 13:38:49'),(46,149,564,'hds_re_assign',1,'please sir check it.','2023-03-24 13:49:02'),(47,143,564,'hds_re_assign',1,'please sir check it.','2023-03-24 13:49:41'),(48,318,675,'hds_re_assign',1,'','2023-03-24 15:13:05'),(49,333,677,'hds_re_assign',1,'','2023-03-25 10:03:22'),(50,173,526,'hds_re_assign',1,'Kindly look into the matter, as requested.','2023-03-26 05:48:14'),(51,346,593,'hds_re_assign',1,'Kindly look into the matter.','2023-03-27 08:11:34'),(52,357,363,'hds_re_assign',1,'Student wants to add name in 7th DB whatsApp group. Her name is still in scholar group.','2023-03-27 10:16:20'),(53,173,677,'hds_re_assign',1,'','2023-03-27 11:04:28'),(54,0,677,'hds_re_assign',1,'','2023-03-27 11:23:24');

--
