-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 24, 2022 at 04:45 AM
-- Server version: 5.1.36
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `no1tech_db`
--

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

--
-- Table structure for table `feestbl`
--

CREATE TABLE IF NOT EXISTS `feestbl` (
  `id` bigint(11) NOT NULL,
  `batchCode` varchar(100) NOT NULL,
  `name` varchar(100) NOT NULL,
  `course` varchar(100) NOT NULL,
  `amountPaid` decimal(40,0) NOT NULL,
  `rdate` varchar(40) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `feestbl`
--

INSERT INTO `feestbl` (`id`, `batchCode`, `name`, `course`, `amountPaid`, `rdate`) VALUES
(1, 'NT0001', 'MANIKANDAN SADHARAM', 'python- PART 1', '1000', '23-11-2022'),
(2, 'NT0001', 'MANIKANDAN SADHARAM', 'python- PART 2', '4000', '23-11-2022'),
(3, 'NT0002', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '1000', '23-11-2022'),
(4, 'NT0003', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '1000', '23-11-2022'),
(5, 'NT0004', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '2000', '23-11-2022'),
(6, 'NT0005', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '123', '23-11-2022'),
(7, 'NT0006', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '123', '23-11-2022'),
(8, 'NT0007', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '123', '23-11-2022'),
(9, 'NT0008', 'Mani', 'JAVA- PART 1', '123', '23-11-2022'),
(10, 'NT0009', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '1000', '23-11-2022'),
(11, 'NT0010', 'Mani', 'JAVA- PART 1', '3000', '23-11-2022'),
(12, 'NT0011', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '2000', '23-11-2022'),
(13, 'NT0012', 'MANIKANDAN SADHARAM', 'JAVA- PART 1', '1000', '23-11-2022');

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

--
-- Table structure for table `studenttbl`
--

CREATE TABLE IF NOT EXISTS `studenttbl` (
  `id` bigint(11) NOT NULL,
  `batchCode` varchar(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `collegeName` varchar(100) NOT NULL,
  `degree` varchar(50) NOT NULL,
  `contactNo` varchar(15) NOT NULL,
  `emailId` varchar(50) NOT NULL,
  `courseName` varchar(50) NOT NULL,
  `totalAmount` decimal(50,0) NOT NULL,
  `paidAmount` decimal(50,0) NOT NULL,
  `baalanceAmount` decimal(50,0) NOT NULL,
  `rdate` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `studenttbl`
--

INSERT INTO `studenttbl` (`id`, `batchCode`, `name`, `collegeName`, `degree`, `contactNo`, `emailId`, `courseName`, `totalAmount`, `paidAmount`, `baalanceAmount`, `rdate`) VALUES
(1, 'NT0001', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'itsupport@ktt.sg', 'python', '25000', '5000', '20000', '23-11-2022'),
(2, 'NT0002', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'itsupport@ktt.sg', 'JAVA', '25000', '1000', '24000', '23-11-2022'),
(3, 'NT0003', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'roopacb57@gmail.com', 'JAVA', '25000', '1000', '24000', '23-11-2022'),
(4, 'NT0004', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'thomas@ktt.sg', 'JAVA', '25000', '2000', '23000', '23-11-2022'),
(5, 'NT0005', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'thomas@ktt.sg', 'JAVA', '25000', '123', '24877', '23-11-2022'),
(6, 'NT0006', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'itsupport@ktt.sg', 'JAVA', '25000', '123', '24877', '23-11-2022'),
(7, 'NT0007', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'thomas@ktt.sg', 'JAVA', '25000', '123', '24877', '23-11-2022'),
(8, 'NT0008', 'Mani', 'Saranathan', 'BE', '7871361947', 'itsupport@ktt.sg', 'JAVA', '15000', '123', '14877', '23-11-2022'),
(9, 'NT0009', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'thomas@ktt.sg', 'JAVA', '25000', '1000', '24000', '23-11-2022'),
(10, 'NT0010', 'Mani', 'Saranathan', 'BE', '7871361947', 'itsupport@ktt.sg', 'JAVA', '25000', '3000', '22000', '23-11-2022'),
(11, 'NT0011', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '8667842469', 'thomas@ktt.sg', 'JAVA', '25000', '2000', '23000', '23-11-2022'),
(12, 'NT0012', 'MANIKANDAN SADHARAM', 'Saranathan', 'BE', '7871361947', 'thomas@ktt.sg', 'JAVA', '25000', '1000', '24000', '23-11-2022');