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

START TRANSACTION;



--
-- Database: `u602093072_tnedi`
--

DELIMITER $$
--
-- Procedures
--
CREATE DEFINER=`u602093072_tnedi`@`127.0.0.1` PROCEDURE `InsertDistricts` ()  BEGIN
    DECLARE str VARCHAR(1000);
    DECLARE pos INT DEFAULT 1;
    DECLARE len INT;
    DECLARE district VARCHAR(100);

    SET str = 'Ariyalur,Chengalpattu,Chennai,Coimbatore,Cuddalore,Dharmapuri,Dindigul,Erode,Kallakurichi,Kanchipuram,Kanyakumari,Karur,Krishnagiri,Madurai,Mayiladuthurai,Nagapattinam,Namakkal,Nilgiris,Perambalur,Pudukkottai,Ramanathapuram,Ranipet,Salem,Sivagangai,Tenkasi,Thanjavur,Theni,Thiruvallur,Thiruvarur,Tiruchirappalli,Tirunelveli,Tirupattur,Tiruppur,Tiruvannamalai,Tuticorin,Vellore,Viluppuram,Virudhunagar';

    WHILE pos <= LENGTH(str) DO
        SET len = LOCATE(',', str, pos) - pos;
        IF len = -1 THEN
            SET len = LENGTH(str) - pos + 1;
        END IF;

        SET district = TRIM(SUBSTRING(str, pos, len));

        SET pos = pos + len + 1;
    END WHILE;
END$$

DELIMITER ;

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

--
-- Table structure for table `application_form`
--

CREATE TABLE `application_form` (
  `id` int(11) NOT NULL,
  `app_no` varchar(10) DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `middle_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `mobile` varchar(12) DEFAULT NULL,
  `caste` varchar(50) DEFAULT NULL,
  `religion` varchar(50) DEFAULT NULL,
  `nationality` varchar(50) DEFAULT NULL,
  `program` varchar(60) DEFAULT NULL,
  `field` varchar(200) NOT NULL,
  `differently_abled` varchar(10) DEFAULT NULL,
  `marital_status` varchar(20) DEFAULT NULL,
  `fathers_name` varchar(100) DEFAULT NULL,
  `father_occupation` varchar(100) DEFAULT NULL,
  `fathers_annual_income` varchar(70) DEFAULT NULL,
  `fathers_mobile` varchar(15) DEFAULT NULL,
  `mothers_name` varchar(100) DEFAULT NULL,
  `mother_occupation` varchar(100) DEFAULT NULL,
  `mothers_annual_income` varchar(30) DEFAULT NULL,
  `mothers_mobile_number` varchar(15) DEFAULT NULL,
  `permanent_street_address1` varchar(255) DEFAULT NULL,
  `permanent_street_address2` varchar(255) DEFAULT NULL,
  `permanent_city` varchar(100) DEFAULT NULL,
  `permanent_state` varchar(100) DEFAULT NULL,
  `permanent_postal_code` varchar(10) DEFAULT NULL,
  `communication_street_address1` varchar(255) DEFAULT NULL,
  `communication_street_address2` varchar(255) DEFAULT NULL,
  `communication_city` varchar(100) DEFAULT NULL,
  `communication_state` varchar(100) DEFAULT NULL,
  `communication_postal_code` varchar(10) DEFAULT NULL,
  `passport_photo_path` varchar(255) DEFAULT NULL,
  `address_proof_path` varchar(255) DEFAULT NULL,
  `degree_certificate_path` varchar(255) DEFAULT NULL,
  `statusapp` varchar(20) NOT NULL,
  `application_date` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `qualification` varchar(50) DEFAULT NULL,
  `university` varchar(255) DEFAULT NULL,
  `degree_name` varchar(255) DEFAULT NULL,
  `graduation_year` int(11) DEFAULT NULL,
  `percentage` decimal(5,2) DEFAULT NULL,
  `remark` varchar(244) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `application_form`
--

INSERT INTO `application_form` (`id`, `app_no`, `first_name`, `middle_name`, `last_name`, `date_of_birth`, `gender`, `email`, `mobile`, `caste`, `religion`, `nationality`, `program`, `field`, `differently_abled`, `marital_status`, `fathers_name`, `father_occupation`, `fathers_annual_income`, `fathers_mobile`, `mothers_name`, `mother_occupation`, `mothers_annual_income`, `mothers_mobile_number`, `permanent_street_address1`, `permanent_street_address2`, `permanent_city`, `permanent_state`, `permanent_postal_code`, `communication_street_address1`, `communication_street_address2`, `communication_city`, `communication_state`, `communication_postal_code`, `passport_photo_path`, `address_proof_path`, `degree_certificate_path`, `statusapp`, `application_date`, `qualification`, `university`, `degree_name`, `graduation_year`, `percentage`, `remark`) VALUES
(24, '1805241013', 'Umashankar', '', 'C', '1993-05-12', 'Male', 'umashankariac@gmail.com', '9952371533', 'General', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Single', 'fds', 'Salaried', 'Rs.1,50,001 to Rs 3,00,000', 'a999999', 'fda', 'House wife', 'Rs. 3,00,001 to Rs.5,00,000', '1122334455', 'asd', 'ad', NULL, 'Tamil Nadu', '600123', 'asd', 'ad', 'Tiruchirappalli', 'Tamil Nadu', '600123', 'uploads/address_proofs/Optoma ZW350E.pdf', 'uploads/address_proofs/Optoma ZW350E.pdf', 'uploads/address_proofs/Optoma ZW350E.pdf', 'Approved', '2024-06-04 07:32:27', '', 'Anna University, Chennai', 'B.com', 2020, '65.00', 'APPLICATION GRANTED'),
(65, '1805241015', 'Lakshmi M', '', 'M', '2000-02-06', 'Female', 'sakthicodedev@gmail.com', '8668100821', 'General', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Veda', 'Entrepreneur', 'Above Rs. 5,00,000', 'Bye', 'Bta', 'Salaried', 'Below Rs.1,50,000', '122844588', '26 F1 SRI RAGAVENDRA SRINIVAS APT, KRISHNA NAGAR, MADHANANDHAPURAM', 'Ground', 'Chennai', 'Tamil Nadu', '600125', '26 F1 SRI RAGAVENDRA SRINIVAS APT, KRISHNA NAGAR, MADHANANDHAPURAM', 'Ground', 'Chennai', 'Tamil Nadu', '600125', 'uploads/passport_photos/uu-excellance-logo.png', 'uploads/address_proofs/v-thumb.jpeg', 'uploads/degree_certificates/v-thumb.jpeg', 'Document_uploaded', '2024-07-03 05:20:58', 'UG', 'Anna University, Chennai', 'Bcom', 2020, '90.00', NULL),
(68, '1805241018', 'C. Devakumar', NULL, NULL, NULL, NULL, 'devakumarsimpson@gmail.com', '9094082397', NULL, NULL, NULL, 'PG Diploma In Enterprenuership & Innovation', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chennai', 'Tamil Nadu', NULL, NULL, NULL, NULL, 'started', '2024-06-07 09:27:14', NULL, NULL, NULL, NULL, NULL, NULL),
(69, '1805241019', 'Dr R Ramachandran', '', 'RAJARAM', '1992-06-10', 'Male', 'chanus92@gmail.com', '9566531892', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Arts & Science (Arts stream)', 'No', 'Single', 'RR', 'Others', 'Below 1,50,000', '9566531892', 'RR', 'House wife', 'others', '9566531892', 'RR', 'RR', 'Virudhunagar', 'Tamil Nadu', '626108', 'RR', 'RR', 'Virudhunagar', 'Tamil Nadu', '626108', 'uploads/passport_photos/IMG-20240607-WA0024.jpg', 'uploads/address_proofs/IMG-20240607-WA0024.jpg', 'uploads/degree_certificates/IMG-20240607-WA0024.jpg', 'Document_uploaded', '2024-06-07 09:46:30', 'UG', 'Madurai Kamaraj University, Madurai', 'B.Com (Computer Application)', 2012, '81.00', NULL),
(70, '1805241020', 'sakthi', '', 'kumar', '2000-12-14', 'Male', 'sakthi@gmail.com', '9952048535', 'General', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Single', 'karunanthi murugan', 'Salaried', 'Below 1,50,000', '9922048535', 'santhiya karunanthi', 'Salaried', 'Below Rs.1,50,000', '9958148535', '3 SYSTEC COLONY', 'NORTH STREET THIRUVARUR', 'Chengalpattu', 'Tamil Nadu', '610001', '3 SYSTEC COLONY', 'NORTH STREET THIRUVARUR', 'Chengalpattu', 'Tamil Nadu', '610001', 'uploads/passport_photos/1_nd34ygxqy2.png', 'uploads/address_proofs/adv-thumb-uu.jpeg', 'uploads/degree_certificates/slide1.jpeg', 'Document_uploaded', '2024-07-02 12:19:30', 'UG', 'Anna University, Chennai', 'B.E Computer Science', 2000, '86.00', NULL),
(71, '1805241021', 'Raja', 'Boss', 'Raja', '1999-06-07', 'Male', 'dckarur@editn.in', '9994322859', 'General', 'Christian', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Raja', 'Entrepreneur', 'Below 1,50,000', '9994322859', 'Roja', 'House wife', 'Below Rs.1,50,000', '9994322859', 'Karur', 'Karur', 'Karur', 'Tamil Nadu', '639005', 'Karur', 'Karur', 'Karur', 'Tamil Nadu', '639005', 'uploads/passport_photos/IMG-20240607-WA0007.jpg', 'uploads/address_proofs/IMG-20240607-WA0007.jpg', 'uploads/degree_certificates/IMG-20240607-WA0007.jpg', 'Document_uploaded', '2024-06-07 09:49:48', 'PG ', 'Anna University, Chennai', 'M.E Computer Science ', 2015, '70.00', NULL),
(72, '1805241022', 'Abraham', '', 'G', '1985-11-23', 'Male', 'abilincolnbe@gmail.com', '9786644817', 'OBC', 'Christian', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Gnanadickam', 'Others', '', '9787795561', 'Santhosam', '', '', '', 'Annai illam', 'East 7th street', 'Pudukkottai', 'Tamil Nadu', '622001', 'Annai illam', 'East 7th street', 'Pudukkottai', 'Tamil Nadu', '622001', 'uploads/passport_photos/IMG-20240607-WA0019.jpg', 'uploads/address_proofs/IMG-20240607-WA0019.jpg', 'uploads/degree_certificates/IMG-20240607-WA0019.jpg', 'Document_uploaded', '2024-06-07 09:58:24', 'UG', 'Anna University, Chennai', 'BE', 2008, '71.00', NULL),
(73, '1805241023', 'Divya s', '', 'S', '1998-06-05', 'Female', 'divyadeepa1212@gmail.com', '8940499259', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Agriculture', 'No', 'Married', 'selvam', 'Farmer', 'Rs.1,50,001 to Rs 3,00,000', '9999999999', 'vanaroja', 'House wife', 'others', '8888888888', '42/1', '', 'Tirupattur', 'Tamil Nadu', 'Tirupathur', '42/1', '', 'Tirupattur', 'Tamil Nadu', 'Tirupathur', 'uploads/passport_photos/WhatsApp Image 2024-06-07 at 3.06.47 PM.jpeg', 'uploads/address_proofs/WhatsApp Image 2024-06-07 at 3.06.47 PM.jpeg', 'uploads/degree_certificates/WhatsApp Image 2024-06-07 at 3.06.47 PM.jpeg', 'Document_uploaded', '2024-06-07 10:01:03', 'UG', 'Tamil Nadu Agricultural University, Coimbatore', 'B.Tech (Biotechnology)', 2019, '78.00', NULL),
(74, '1805241024', 'G.Bhuvana', 'Gunasekaran ', 'K.G', '1989-09-10', 'Female', 'bhuvanasai.j@gmail.com', '9629007355', 'Others', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Others', 'No', 'Married', 'K.G. Gunasekaran ', 'Salaried', 'Below 1,50,000', '9962605951', 'G.Malarveni ', 'House wife', 'others', '9962605951', 'Ariyur, Vellore.', 'Ariyur, Vellore.', 'Vellore', 'Tamil Nadu', 'Vellore ', 'Ariyur, Vellore.', 'Ariyur, Vellore.', 'Vellore', 'Tamil Nadu', 'Vellore ', 'uploads/passport_photos/WhatsApp Image 2024-06-07 at 3.06.47 PM (1).jpeg', 'uploads/address_proofs/WhatsApp Image 2024-06-07 at 3.06.47 PM (1).jpeg', 'uploads/degree_certificates/WhatsApp Image 2024-06-07 at 3.06.47 PM (1).jpeg', 'Document_uploaded', '2024-06-07 10:34:21', 'PG ', 'Anna University, Chennai', 'MBA', 2011, '87.00', NULL),
(75, '1805241025', 'Priya', 'Venkatesh ', 'Priya venkatesh ', '1998-07-11', 'Female', 'lakshu11798mp@gmail.com', '8675561685', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Arts & Science (Arts stream)', 'No', 'Married', 'Manoharan ', 'Others', 'Below 1,50,000', '123456789', 'Aruna', 'House wife', 'others', '123456789', '119.mela St, Gangatharapuram post,kuttalam taluk mayiladuthurai ', '119.mela St, Gangatharapuram post,kuttalam taluk, mayiladuthurai ', 'Thiruvarur', 'Tamil Nadu', '609805', '119.mela St, Gangatharapuram post,kuttalam taluk mayiladuthurai ', '119.mela St, Gangatharapuram post,kuttalam taluk, mayiladuthurai ', 'Thiruvarur', 'Tamil Nadu', '609805', 'uploads/passport_photos/IMG-20240607-WA0012.jpg', 'uploads/address_proofs/IMG-20240607-WA0012.jpg', 'uploads/degree_certificates/IMG-20240607-WA0012.jpg', 'Document_uploaded', '2024-06-07 10:21:40', 'PG ', 'Tamil Nadu Open University, Chennai', 'Msw', 2020, '92.00', NULL),
(76, '1805241026', 'Priya', 'Venkatesh ', 'Priya venkatesh ', '1998-07-11', 'Female', 'lakshu11798mp@gmail.com', '8675561685', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Arts & Science (Arts stream)', 'No', 'Married', 'Manoharan ', 'Others', 'Below 1,50,000', '123456789', 'Aruna', 'House wife', 'others', '123456789', '119.mela St, Gangatharapuram post,kuttalam taluk mayiladuthurai ', '119.mela St, Gangatharapuram post,kuttalam taluk, mayiladuthurai ', 'Thiruvarur', 'Tamil Nadu', '609805', '119.mela St, Gangatharapuram post,kuttalam taluk mayiladuthurai ', '119.mela St, Gangatharapuram post,kuttalam taluk, mayiladuthurai ', 'Thiruvarur', 'Tamil Nadu', '609805', 'uploads/passport_photos/IMG-20240607-WA0012.jpg', 'uploads/address_proofs/IMG-20240607-WA0012.jpg', 'uploads/degree_certificates/IMG-20240607-WA0012.jpg', 'Document_uploaded', '2024-06-07 10:21:40', 'PG ', 'Tamil Nadu Open University, Chennai', 'Msw', 2020, '92.00', NULL),
(77, '1805241027', 'T keerthana', '', 'T', '1996-12-15', 'Female', 'keerthanaguhan@gmail.com', '8667082030', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Agriculture', 'No', 'Married', 'A Thirumoorthi ', 'Salaried', 'Below 1,50,000', '9943740572', 'T KANCHANA ', 'House wife', 'others', '', '50/48,N.Thairpalayam,Gangapuram(po),Chithode', '', 'Erode', 'Tamil Nadu', '638102', '50/48,N.Thairpalayam,Gangapuram(po),Chithode', '', 'Erode', 'Tamil Nadu', '638102', 'uploads/passport_photos/IMG-20240607-WA0009.jpg', 'uploads/address_proofs/IMG-20240607-WA0009.jpg', 'uploads/degree_certificates/IMG-20240607-WA0009.jpg', 'Document_uploaded', '2024-07-02 13:46:51', 'PG ', 'Anna University, Chennai', 'M.Sc., (Agri)', 2022, '90.00', NULL),
(78, '1805241028', 'Arivoli Nallathambi', '', 'Nallathambi', '1995-09-01', 'Male', 'sakthicodedev@gmail.com', '995204858110', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Nallathambi', 'Farmer', 'Below 1,50,000', '9098643368', 'Selvi', 'House wife', 'Below Rs.1,50,000', '6631589975', 'Federal mogul motorparts India limited', 'Plot no 42. 8th Avenue, Mahindra world city', 'Kallakurichi', 'Tamil Nadu', '603004', 'Federal mogul motorparts India limited', 'Plot no 42. 8th Avenue, Mahindra world city', 'Kallakurichi', 'Tamil Nadu', '603004', 'uploads/passport_photos/uu-excellance-logo.png', 'uploads/address_proofs/header-about-img.jpeg', 'uploads/degree_certificates/header-academics-img.jpeg', 'Document_uploaded', '2024-07-02 16:28:21', 'UG', 'Anna University, Chennai', 'BE mechanical ', 2017, '78.00', NULL),
(79, '1805241029', 'EZHILRANI', '', 'A', '1994-07-29', 'Female', 'ezhilranidanam@gmail.com', '7845358815', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Single', 'Azhagudurai', 'Farmer', 'Rs. 3,00,001 to Rs.5,00,000', '975809693', 'Danalakshmi', 'House wife', 'Rs. 3,00,001 to Rs.5,00,000', '8526756715', '2/170, EAST STREET', 'NEMAM', 'Cuddalore', 'Tamil Nadu', '606110', '2/170, EAST STREET', 'NEMAM', 'Cuddalore', 'Tamil Nadu', '606110', 'uploads/passport_photos/IMG-20240607-WA0102.jpg', 'uploads/address_proofs/IMG-20240523-WA0006.jpg', 'uploads/degree_certificates/IMG-20240523-WA0006.jpg', 'Pending', '2024-07-02 15:40:15', '', 'Anna University, Chennai', 'BE', 2015, '85.00', NULL),
(80, '1805241030', 'VIGNESH.P', NULL, NULL, NULL, NULL, 'vickysivam123@gmail.com', '6374453637', NULL, NULL, NULL, 'PG Diploma In Enterprenuership & Innovation', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Tiruchirappalli', 'Tamil Nadu', NULL, NULL, NULL, NULL, 'started', '2024-06-07 10:34:56', NULL, NULL, NULL, NULL, NULL, NULL),
(81, '1805241031', 'Praveen .p', '', 'Puhazhendhi ', '1993-03-04', 'Male', 'mechpraveen123@gmail.com', '9655579530', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Puhazhendhi ', 'Farmer', 'Rs.1,50,001 to Rs 3,00,000', 'Puhazhendh', 'Latha ', 'Farmer', 'Rs.1,50,001 to Rs 3,00,000', '9698303920', '688 sivan kovil street ', 'Maruthur ', 'Ariyalur', 'Tamil Nadu', 'Jayankonda', '688 sivan kovil street ', 'Maruthur ', 'Ariyalur', 'Tamil Nadu', 'Jayankonda', NULL, NULL, NULL, 'Pending', '2024-06-07 11:38:41', 'UG', 'Anna University, Chennai', 'B.E', 2015, '61.00', NULL),
(82, '1805241032', 'R Amarnath', '', 'amarnath', '1981-07-05', 'Male', 'eeeamarnath@gmail.com', '9842064180', 'General', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', ' V Ramalingam', 'Salaried', 'Rs.1,50,001 to Rs 3,00,000', '9042752339', 'R Subbulaxmi', 'House wife', 'Rs.1,50,001 to Rs 3,00,000', '9042752339', '2721,Pugalendhi Steet, Krishnapuram,MC Road,Thanjavur-613 007', 'Pugalendhi Steet', 'Thanjavur', 'Tamil Nadu', '613 004', '2721,Pugalendhi Steet, Krishnapuram,MC Road,Thanjavur-613 007', 'Pugalendhi Steet', 'Thanjavur', 'Tamil Nadu', 'Thanjavur', 'uploads/passport_photos/WhatsApp Image 2024-06-07 at 3.06.47 PM.jpeg', 'uploads/address_proofs/WhatsApp Image 2024-06-07 at 3.06.47 PM.jpeg', 'uploads/degree_certificates/WhatsApp Image 2024-06-07 at 3.06.47 PM.jpeg', 'Document_uploaded', '2024-06-07 12:49:01', 'PG ', 'SASTRA Deemed University, Thanjavur', 'Poewr Electronoics and drives', 2018, '79.00', NULL),
(83, '1805241033', 'Martin Ruso', '', 'S', '2000-06-08', 'Male', 'kss.martinruso00@gmail.com', '6374518013', 'General', 'Christian', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Arts and Science (Commerce)', 'No', 'Single', 'Saleth', 'Others', '', '7708144620', 'Rani', 'House wife', 'others', '', '208, W1, T.Sindalai Cherry', '', 'Theni', 'Tamil Nadu', '625530', '208, W1, T.Sindalai Cherry', '', 'Theni', 'Tamil Nadu', '625530', 'uploads/passport_photos/IMG-20240607-WA0005.jpg', 'uploads/address_proofs/IMG-20240607-WA0005.jpg', 'uploads/degree_certificates/IMG-20240607-WA0005.jpg', 'Document_uploaded', '2024-06-07 13:48:55', 'PG ', 'Madras University, Chennai', 'MSW', 2022, '75.00', NULL),
(84, '1805241034', 'SEENUVASAN G', '', 'G', '1987-01-03', 'Male', 'seenu0301g@gmail.com', '9677835172', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Arts & science (Science stream)', 'No', 'Married', 'GOPU', 'Salaried', 'Rs.1,50,001 to Rs 3,00,000', '7708864767', 'Vasantha', 'House wife', 'others', '9367529240', 'Thenkolapakkam ', '', 'Kanchipuram', 'Tamil Nadu', '604304', 'Thenkolapakkam ', '', 'Kanchipuram', 'Tamil Nadu', '604304', 'uploads/passport_photos/IMG-20240607-WA0086.jpg', 'uploads/address_proofs/IMG-20240607-WA0086.jpg', 'uploads/degree_certificates/IMG-20240607-WA0086.jpg', 'Document_uploaded', '2024-06-07 14:10:58', 'PG ', 'Anna University, Chennai', 'MCA', 2010, '76.00', NULL),
(85, '1805241035', 'SASIPRIYA N', '', 'NATARAJAN ', '1994-03-11', 'Female', 'sakthicodedev@gmail.com', '6382436094', 'General', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Single', 'NATARAJAN ', 'Salaried', 'Below 1,50,000', '9943247290', 'Uma', 'Entrepreneur', 'Below Rs.1,50,000', '9943247290', 'No.2 Sokkanathar Kovil Street', 'Kadambadi', 'Nagapattinam', 'Tamil Nadu', '611001', 'No.2 Sokkanathar Kovil Street', 'Kadambadi', 'Nagapattinam', 'Tamil Nadu', '611001', 'uploads/passport_photos/uu-excellance-logo.png', 'uploads/address_proofs/WhatsApp Image 2024-06-30 at 4.29.22 PM.jpeg', 'uploads/degree_certificates/adv-thumb-uu.jpeg', 'Document_uploaded', '2024-07-02 16:40:35', 'UG', 'Anna University, Chennai', 'B.E ECE', 2015, '67.00', NULL),
(86, '1805241036', 'Ramkumar', NULL, NULL, NULL, NULL, 'dcperambalur@editn.in', '9677898633', NULL, NULL, NULL, 'PG Diploma In Enterprenuership & Innovation', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Perambalur', 'Tamil Nadu', NULL, NULL, NULL, NULL, 'started', '2024-06-07 16:15:12', NULL, NULL, NULL, NULL, NULL, NULL),
(87, '1805241037', 'Dr.S.T.Suvaitharan', '', 'Thanulingam', '1981-10-22', 'Male', 'dcthoothukudi@editn.in', '8903637442', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Single', 'Father', 'Others', 'Above Rs. 5,00,000', '9876543210', 'Mother', 'House wife', 'others', '9876543210', 'Tirunelveli', '4th Street', 'Tirunelveli', 'Tamil Nadu', '627011', 'Tirunelveli', '4th Street', 'Tirunelveli', 'Tamil Nadu', '627011', 'uploads/passport_photos/WhatsApp Image 2024-06-07 at 15.06.48_0a75810f.jpg', 'uploads/address_proofs/IMG-20240414-WA0098 (Small).jpg', 'uploads/degree_certificates/IMG-20240414-WA0098 (Small).jpg', 'Document_uploaded', '2024-06-07 16:39:07', 'PG ', 'Manonmaniam Sundaranar University, Tirunelveli', 'Ph.D', 2021, '84.00', NULL),
(88, '1805241038', 'Sandhya G Trial', '', 'G', '1995-07-22', 'Female', 'dcchennai@editn.in', '9962596111', 'Others', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Gopal K', 'Entrepreneur', 'Above Rs. 5,00,000', '9443596169', 'Ramani G ', 'House wife', 'others', '9962836111', 'P.no.5, d.no.16,', 'Kilburn nagar, ,', 'Chennai', 'Tamil Nadu', '600060', 'P.no.5, d.no.16,', 'Kilburn nagar, ,', 'Chennai', 'Tamil Nadu', '600060', 'uploads/passport_photos/WhatsApp Image 2024-06-08 at 9.41.57 PM.jpeg', 'uploads/address_proofs/WhatsApp Image 2024-06-08 at 9.41.57 PM.jpeg', 'uploads/degree_certificates/WhatsApp Image 2024-06-08 at 9.41.57 PM.jpeg', 'Approved', '2024-08-02 05:01:12', 'UG', 'Anna University, Chennai', 'B.E', 2017, '79.00', NULL),
(89, '1805241039', 'maha', '', 'Lakshmi', '2000-06-18', 'Female', 'edptc@editn.in', '8778998924', 'General', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Megan', 'Entrepreneur', 'Above Rs. 5,00,000', '1234567890', 'Punitha', 'Others', '', '', '123', 'Chennai', 'Chennai', 'Tamil Nadu', '600125', '123', 'Chennai', 'Chennai', 'Tamil Nadu', '600125', 'uploads/passport_photos/WhatsApp Image 2024-06-07 at 3.04.54 PM.jpeg', 'uploads/address_proofs/WhatsApp Image 2024-06-07 at 3.04.54 PM.jpeg', 'uploads/degree_certificates/WhatsApp Image 2024-06-07 at 3.04.54 PM.jpeg', 'Document_uploaded', '2024-06-18 09:45:04', 'UG', 'Annamalai University', 'BE', 2022, '90.00', NULL),
(90, '1805241040', 'Dr.A.Apdhulkathar', NULL, NULL, NULL, NULL, 'drapdhulkathar88@gmail.com', '9840953738', NULL, NULL, NULL, 'PG Diploma In Enterprenuership & Innovation', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Salem', 'Tamil Nadu', NULL, NULL, NULL, NULL, 'started', '2024-06-19 10:39:25', NULL, NULL, NULL, NULL, NULL, NULL),
(92, '1805241042', 'Sakthi kumar', NULL, NULL, NULL, NULL, 'infintechstudio@gmail.com', '8608012585', NULL, NULL, NULL, 'PG Diploma In Enterprenuership & Innovation', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Chengalpattu', 'Tamil Nadu', NULL, NULL, NULL, NULL, 'started', '2024-07-02 11:05:37', NULL, NULL, NULL, NULL, NULL, NULL),
(93, '1805241043', 'Karthik', '', 'Muthukrishnan', '1981-07-07', 'Male', 'mkvspace@gmail.com', '9841316211', 'OBC', 'Hindu', 'Indian', 'PG Diploma In Enterprenuership & Innovation', 'Engineering', 'No', 'Married', 'Muthukrishnan', 'Salaried', 'Rs. 3,00,001 to Rs.5,00,000', '1234567893', 'Rajam', 'House wife', '', '1234566789', '33 Model House, ', 'AnnaNagar', 'Madurai', 'Tamil Nadu', '600041', '33 Model House, ', 'AnnaNagar', 'Madurai', 'Tamil Nadu', '600041', 'uploads/passport_photos/pp.jpg', 'uploads/address_proofs/address_proof.jpg', 'uploads/degree_certificates/degree.jpg', 'Verified', '2024-08-02 05:00:52', 'UG', 'Annamalai University', 'BE Computer Science', 1999, '86.00', 'We are yet to verify your application. ');

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

--
-- AUTO_INCREMENT for table `application_form`
--
ALTER TABLE `application_form`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=94;
COMMIT;

