-- phpMyAdmin SQL Dump -- version 5.2.3 -- https://www.phpmyadmin.net/ -- -- Host: localhost -- Generation Time: Aug 07, 2026 at 10:37 AM -- Server version: 10.5.29-MariaDB -- PHP Version: 8.2.33 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!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 utf8mb4 */; -- -- Database: `sssify` -- -- -------------------------------------------------------- -- -- Table structure for table `account` -- CREATE TABLE `account` ( `a_id` int(11) NOT NULL, `a_user` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `a_pass` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `acc_master_tbl` -- CREATE TABLE `acc_master_tbl` ( `acc_master_id` int(11) NOT NULL, `acc_mst_entry_date` date NOT NULL, `acc_mst_entry_time` datetime NOT NULL, `fk_year_id` int(11) NOT NULL, `amount` float NOT NULL, `payment_type` varchar(30) NOT NULL COMMENT 'credit or debit', `fk_activity_id` int(11) NOT NULL COMMENT 'po_id | ord_id | pay_id', `fk_user_id` int(11) NOT NULL COMMENT 'cust_id for order , payment and vendor', `activity_type` varchar(30) NOT NULL COMMENT 'order|payment|RM|credit|debit', `remark` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `admin_login` -- CREATE TABLE `admin_login` ( `al_id` int(11) NOT NULL, `al_user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `al_password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `report_status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `role` varchar(50) NOT NULL DEFAULT 'user' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `admin_login` -- INSERT INTO `admin_login` (`al_id`, `al_user_name`, `al_password`, `report_status`, `role`) VALUES (1, 'BarakaCropScience@2026', 'BarakaCropScience@2026', '1', 'Admin'), (3, 'kc', 'kc', '2', 'user'); -- -------------------------------------------------------- -- -- Table structure for table `bank_table` -- CREATE TABLE `bank_table` ( `bt_id` int(11) NOT NULL, `bt_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `bank_table` -- INSERT INTO `bank_table` (`bt_id`, `bt_name`) VALUES (143, 'AXIS BANK LTD '), (13, 'THE JANLAXMI COOPERATIVE BANK LTD'), (14, 'SYNDICATE BANK'), (15, 'UCO BANK'), (16, 'THE NASHIK MERCHANTS CO OP BANK LTD'), (17, 'TJSB BANK LTD'), (18, 'ICICI BANK LTD'), (19, 'THE NASHIK ROAD DEOLALI VYAPARI SAHAKARI BANK LTD'), (20, 'NASIK ROAD DEOLALI VYAPARI BANK'), (21, 'THE NASIK MERCHANTS\' CO OP BANK LTD NASHIK'), (22, 'PIMPALGAON MARCHANT CO OP BANK'), (23, 'ORIENTAL BANK OF COMMERCE'), (24, 'LATUR URBAN CO OP BANK LATUR'), (25, 'SHIVAJIRAO BHOSALE SAHAKARI BANK LTD'), (26, 'JANSEVA SAHAKARI BANK LTD'), (27, 'THE VISHWESHWAR SAHAKARI BANK LTD PUNE'), (28, 'THE KARAD URBAN CO OP BAN LTD KARAD'), (29, 'LAXMI URBAN CO OP BANK'), (30, 'JIJAMATA MAHILA SAHAKARI BANK LTD PUNE'), (31, 'SYNDICATE BANK'), (32, 'SHANKARRAO MAHITE PATIL SAHAKARI BANK LTD'), (33, 'CANARA BANK'), (34, 'SHRI WARANA SAHAKARI BANK LTD'), (35, 'KARAD JANTA'), (36, 'NASIK DISTRICT GIRNA CO OP BANK'), (37, 'MAHARASHTRA GRAMIN BANK'), (38, 'KHAMGAON URBAN CO OP BANK LTD'), (39, 'BANK OF INDIA'), (40, 'ALLAHABAD BANK'), (117, 'LOKNETE DATTAJI PATIL COOPERATIVE BANK LIMITED'), (42, 'VIDARBHA KOKAN GRAMIN BANK'), (43, 'THE KHAMGAON URBAN COOP BANK LTD'), (44, 'THE AKOLA DISTRICT CENTRAL CO OP BANK LTD AKOLA'), (45, 'KHAMGAON URBAN CO OP BANK LTD'), (46, 'CENTRAL BANK OF INDIA'), (47, 'ORIENTAL BANK OF COMMERCE'), (48, 'THE AKOLA DISTRICT CENTRAL CO OP BANK LTD AKOLA'), (49, 'JANATA SAHAKARI BANK LTD'), (50, 'AJANTHA URBAN CO OPERATIVE BANK LTD'), (51, 'STATE BANK OF HYDRABAD'), (52, 'JALNA MERCHANT CO OP BANK LTD'), (53, 'THE SIDDHESHWAR URBAN CO OP BANK LTD'), (54, 'THE VAIJAPUR MERCHANT\'S CO-OP BANK LTD '), (55, 'MAHARASHTRA GODAVARI GRAMIN BANK'), (56, 'SHREE CHATRAPATI SHAHU CO-OP BANK LTD BEED'), (57, 'DEOGIRI NAGARI SAHAKARI BANK LTD.AURANGABAD'), (58, 'POORNAWADI NASIK SAHAKARI BANK LTD'), (59, 'SHREE CHATRAPATI SHAHU CO-OP BANK LTD BEED'), (60, 'COSMOS BANK '), (61, 'THE SIDDHESHWAR URBAN CO OP BANK LTD'), (62, 'HDFC BANK'), (63, 'THE MALKAPUR URBAN CO OP BANK LTD'), (64, 'SHREE CHATRAPATI SHAHU CO-OP BANK LTD BEED'), (65, 'VIDHARBHA KSHETRIYA GRAMIN BANK'), (66, 'UNION BANK'), (67, 'PUNJAB NATIONAL BANK LTD'), (68, 'CORPORATION BANK JALGAON'), (69, 'THE PEOPLES CO OP BANK HINGOLI'), (70, 'THE PACHORA PEOPLES CO OP BANK LTD PACHORA'), (71, 'NAGPUR NAGARIK SAHAKARI BANK'), (72, 'THE MAHESH CO OP BANK LTD'), (73, 'JALGAON JANATA SAHAKARI BANK LTD'), (74, 'WARDHA NAGARI SAHAKARI ADHIKOSH BANK MARYADIT'), (75, 'WARDHA NAGRI SAHAKARI BANK'), (76, 'ARVIND SAHAKARI BANK LTD'), (77, 'BULDHANA URBAN CO OP CREDIT SOCIETY LTD'), (78, 'AKOLA URBAN CO OP BANK LTD'), (79, 'YAVATMAL URBAN CO OP BANK LTD '), (80, 'THE YEOTMAL URBAN CO OP BANK YEOTMAL'), (81, 'THE AKOLA JANTA COMMERCIAL CO OP BANK LTD'), (82, 'PUSAD URBAN CO-OP BANK LTD'), (83, 'THE MALKAPUR URBAN CO OP BANK LTD'), (84, 'DR PANJABRAO DESHMUKH URBAN CO OP BANK LTD'), (85, 'THE KHAMGAON URBAN CO OP BANK LTD KHAMGAON'), (86, 'NARMADA JHABUA GRAMIN BANK'), (87, 'JHABVA DHAR GRAMIN KSHETRIYA BANK '), (88, 'SMRITI NAGRI SAHAKARI BANK MYDT'), (89, 'UNION BANK'), (90, 'BANK OF RAJASTHAN'), (91, 'SHREE RAJENDRA SURISAKH SAHAKARITA MARYADIT'), (92, 'SATPURA NARMADA GRAMIN BANK'), (93, 'VIJAYA BANK'), (94, 'INDIAN OVERSEAS BANK'), (95, 'PUNJAB & SIND BANK'), (96, 'UNITED BANK OF INDIA'), (97, 'INDIAN BANK'), (98, 'STATE BANK OF BIKANER AND JAIPUR'), (99, 'J & K BANK'), (100, 'ORIENTAL BANK OF COMMERCE'), (101, 'STATE BANK OF PATIALA'), (102, 'KOTAK MAHINDRA BANK'), (103, 'INDUSIND BANK'), (104, 'RAJARAMBAPU SAH BANK LTD'), (105, 'KARUR VYSYA BANK'), (106, 'SARASWAT CO OP BANK LTD'), (107, 'IDBI BANK'), (108, 'STATE BANK OF INDIA'), (109, 'Dena Bank'), (110, 'Bank of Maharashtra'), (111, 'Vidharbha Konkan Gramin Bank'), (112, 'The Hasti Co-operative Bank Ltd'), (113, 'BANDHAN BANK'), (114, 'The Akola Janata Commercial Co-operative Bank Ltd'), (118, 'Andhra Bank'), (119, 'KALWAN MARCHENT BANK'), (121, 'THE NASHIK DISTRICT CO-OP BANK LTD.'), (122, 'THE NASHIK DISTRIC CENTRAL CO-OP BANK LTD NASHIK '), (123, 'SHANKAR NAGARI SAHAKARI BANK LTD NASHIK'), (124, 'CORPORATION BANK'), (134, 'THE NASHIK DISTRICT CO-OP BANK LTD.'), (129, 'NASHIK DISTICT CENTRAL CO-OP BANK LTD NASHIK'), (132, 'THE NASHIK DISTRIC CENTRAL CO-OP BANK LTD NASHIK'), (133, 'THE NASHIK PEOPLES CO - OP BANK LTD'), (137, 'RBL'), (138, 'SANGALI DCC BANK'), (139, 'KOLHAPUR DCC BANK'), (140, 'SOLAPUR DCC BANK'), (141, 'RAJSHREE SHAHU CO-OPRATIVE BANK'); -- -------------------------------------------------------- -- -- Table structure for table `bom_details_table` -- CREATE TABLE `bom_details_table` ( `bom_details_id` int(11) NOT NULL, `fk_bom_id` int(11) NOT NULL, `fk_raw_id` int(11) NOT NULL, `bom_details_qty` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `bom_table` -- CREATE TABLE `bom_table` ( `bom_id` int(11) NOT NULL, `fk_product_id` int(11) NOT NULL, `bom_date` varchar(30) NOT NULL DEFAULT '', `login_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `company_alert` -- CREATE TABLE `company_alert` ( `ca_id` int(11) NOT NULL, `ca_desc` text NOT NULL, `ca_date` date NOT NULL, `ca_img` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `company_alert_detail` -- CREATE TABLE `company_alert_detail` ( `alert_check_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `fk_alert_id` int(11) NOT NULL, `alert_check_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `company_details` -- CREATE TABLE `company_details` ( `comp_id` int(11) NOT NULL, `core_values` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `facebook_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `linkedin_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `twitter_link` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `godown_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_head_office_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_logo` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_vision` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_mission` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_tagline` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_phone_no` varchar(50) NOT NULL, `comp_email` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_fax_no` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_about` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `factory_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `bank_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `account_no` varchar(255) NOT NULL, `ifsc_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `core_purpose` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `qr_code` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `comp_vat_tin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_state_id` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `company_details` -- INSERT INTO `company_details` (`comp_id`, `core_values`, `facebook_link`, `linkedin_link`, `twitter_link`, `godown_addr`, `comp_head_office_addr`, `comp_logo`, `comp_vision`, `comp_mission`, `comp_tagline`, `comp_name`, `comp_addr`, `comp_phone_no`, `comp_email`, `comp_fax_no`, `comp_about`, `factory_addr`, `bank_name`, `account_no`, `ifsc_code`, `core_purpose`, `qr_code`, `comp_vat_tin`, `fk_state_id`) VALUES (3, 'Innovation: Pioneering new bio fertilizers, bio insecticides, and bio fungicides to support environmentally friendly agriculture.\r\nSustainability: Creating eco-conscious products that reduce the dependency on chemical inputs while improving soil health and crop productivity.\r\nCustomization: Developing need-based solutions tailored to meet specific agricultural challenges faced by farmers.\r\nQuality Assurance: Ensuring all products meet the highest standards of safety, efficiency, and environmental compliance.', 'https://www.facebook.com', 'https://in.linkedin.com', 'https://www.instagram.com/', 'Head office - Sector B- 73 & 74 kinhi Midc,Bhusawal.Dist- Jalgaon (MS). Branch office- Prozone Trade Center, 4th Floor D-20, Beside Prozone Mall, API Road, N1, CIDCO, Chhatrapati Sambhajinagar (MS) - 431006', 'Head office - Sector B- 73 & 74 kinhi Midc,Bhusawal.Dist- Jalgaon (MS). Branch office- Prozone Trade Center, 4th Floor D-20, Beside Prozone Mall, API Road, N1, CIDCO, Chhatrapati Sambhajinagar (MS) - 431006', '74f245ef9064c847475f400dd89ddf25.png', 'Revolve Agro', 'Revolve Agro', 'Revolve Agro', 'Revolve Agro', 'Survey no 1122A1, plot no 3, Shinde Farm, Uruli Devachi, Tal- Haveli, Dist- Pune, 412308', '7397820357', 'revolveagro@gamil.com', '', 'Revolve Agro', 'Survey no 1122A1, plot no 3, Shinde Farm, Uruli Devachi, Tal- Haveli, Dist- Pune, 412308', 'Bank Details\r\nBank Name: \r\nAccount Name: \r\nAccount Number: \r\nIFSC: \r\nBranch Address: ', '', '', 'Innovation: Pioneering new bio fertilizers, bio insecticides, and bio fungicides to support environmentally friendly agriculture.\r\nSustainability: Creating eco-conscious products that reduce the dependency on chemical inputs while improving soil health and crop productivity.\r\nCustomization: Developing need-based solutions tailored to meet specific agricultural challenges faced by farmers.\r\nQuality Assurance: Ensuring all products meet the highest standards of safety, efficiency, and environmental compliance.\r\n', '', '27ASDPM4433G1ZU', '15'); -- -------------------------------------------------------- -- -- Table structure for table `company_table` -- CREATE TABLE `company_table` ( `comp_id` int(11) NOT NULL, `comp_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `company_table` -- INSERT INTO `company_table` (`comp_id`, `comp_name`) VALUES (1, 'Baraka Crop Science'); -- -------------------------------------------------------- -- -- Table structure for table `comp_bank_table` -- CREATE TABLE `comp_bank_table` ( `cbt_id` int(11) NOT NULL, `cbt_name` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `comp_bank_table` -- INSERT INTO `comp_bank_table` (`cbt_id`, `cbt_name`) VALUES (1, 'SBI'); -- -------------------------------------------------------- -- -- Table structure for table `crop` -- CREATE TABLE `crop` ( `crop_id` int(11) NOT NULL, `crop_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `crop_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `crop_schedule` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `crop` -- INSERT INTO `crop` (`crop_id`, `crop_name`, `crop_img`, `crop_schedule`) VALUES (1, 'द्राक्ष-अंगूर-Grape', '', ''), (3, 'डाळिंब-अनार-Pomogranate', '', ''), (4, 'मका/मकाई भुट्टा-Corn-Maize', '', ''), (5, 'केळी-केला-Banana', 'images/product_crop/bbb.png', 'images/Banana_Crop_Schedule_1.pdf'), (6, 'वांगे-बैंगण-Brinjal', '', ''), (7, 'टमाटे-टमाटर-Tomato', '', ''), (8, 'मिरची-हरी मिरची-Green Chilli', '', ''), (9, 'भेंडी-भेंडी-Lady Finger', '', ''), (10, 'सोयाबीन-सोया-Soyabeen', '', ''), (11, 'भुईमुग-मुंगफली-Groundnut', '', ''), (12, 'आले-अद्रक-Ginger', '', ''), (13, 'संत्री-संत्रा-Orange', '', ''), (14, 'लिंबू-निंबू-Lemon', '', ''), (15, 'हळद-हलदी-Turmeric', '', ''), (16, 'पपई-पपीता-Papaya', '', ''), (17, 'कलिंगड-टरबूज-Watermelon', '', ''), (18, 'बटाटे-आलू-Potato', '', ''), (19, 'कांदे-प्याज-Onion', '', ''), (20, 'फुलकोबी-गोबी-Calliflower', '', ''), (21, 'पत्ताकोबी-पत्तागोबी-Cabbage', '', ''), (22, 'ढोबळी मिरची-सिमला मिर्च-Capsicum', '', ''), (23, 'डाळी-दाल-Pulses', '', ''), (24, 'गहू-गेहू-Wheat', '', ''), (25, 'ज्वारी-ज्वार-Jowar', '', ''), (26, 'सफरचंद-सेब-Apple', '', ''), (27, 'पेरू-अमरूद-Guava', '', ''), (28, 'गाजर-गाजर-Carrot', '', ''), (29, 'लसुण-लसन-Garlic', '', ''), (30, 'कोहळा-पेठा-Ash Gourd', '', ''), (31, 'फरसबी-फरसबी-French Beans', '', ''), (32, 'कारले-करेला-Bitter Gourd', '', ''), (33, 'दुधी भोपळा -लौकी,कहु-Bottel Gourd', '', ''), (34, 'कोथंबिर/हरा धनिया-Coriander', '', ''), (35, 'काकडी-खीरा काकडी-Cucumber', '', ''), (36, 'कढी पत्ता/करी पत्ता-Curry Leaves', '', ''), (37, 'शेवग्याची शेंग - सिंगफली-Drumstic', '', ''), (38, 'मूळा/मूला-Radish', '', ''), (39, 'मोसंबी- मोसंबी-Sweet Lime', '', ''), (40, '--SUGARCANE', '', ''), (41, '--HARBARA', '', ''), (43, '--BER', '', ''), (44, '-DODKA - RIDGE GOURD ', '', ''), (45, '--GILKI', '', ''), (46, '--opium', '', ''), (55, 'ग्ल्याडीओलस-ग्ल्याडीओलस-GLADIOLUS', '', ''), (54, 'कारनेशन-कारनेशन-CARNATION', '', ''), (53, 'जरबेरा-जरबेरा-JERBERA', '', ''), (52, 'गुलाब-गुलाब-Rose', '', ''), (56, 'गुलशडी-गुलशेडी-TUBEROSE', '', ''), (57, 'मोगरा-मोगरा-MOGARA', '', ''), (58, 'झेंडू-झेंडू-MARIGOLD', '', ''), (59, 'शेवंती-शेवंती-CHRYSANTHEMUM', '', ''), (60, 'खरबूज-खरबूज-MUSKMELON', '', ''), (61, 'ढेमसे-ढेमसे-TINDA', '', ''), (62, 'मधुमका-मधुमका-sweetcorn ', '', ''), (63, 'बेबीकॉर्न-बेबीकॉर्न-babycorn', '', ''), (64, 'Mango', '', ''), (68, 'PALAK', '', ''), (67, 'CORIANDER', '', ''), (69, 'FENUGREEK (METHI)', '', ''), (70, 'ORNAMENTAL FLOWERS', '', ''), (71, 'कपाशी-कपास-Cotton', '', ''), (72, 'तंबाखू Tambakhu', '', ''), (73, 'भात Bhat', '', ''), (74, 'घोसाळे Ghosale ', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `customer` -- CREATE TABLE `customer` ( `cust_id` int(11) NOT NULL, `cust_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_mob_no` text NOT NULL, `cust_email` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_vat_tin` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_c_s_t_tin` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_gst` varchar(260) NOT NULL, `cust_adhar_no` varchar(260) NOT NULL, `cust_pan_no` varchar(150) NOT NULL, `cust_bank_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_bank_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_bank_acc_no` varchar(50) NOT NULL, `cust_acc_type` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_rtgs_ifsc_code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_ct_id` int(11) NOT NULL, `et_id` int(11) NOT NULL, `user` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pass` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `credit_limit` text NOT NULL, `credit_days` text NOT NULL, `fk_dg_id` int(11) NOT NULL, `seq_deposit` text NOT NULL, `seq_cheque` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `firm_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `postal_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pincode` varchar(10) NOT NULL, `state_name` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `taluka_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `district_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `telephone_no` varchar(25) NOT NULL, `fax_no` varchar(25) NOT NULL, `cust_dob` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `dealer_photo` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `partner_name` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `partner_dob` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `parmanent_addr` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `establish_date` text NOT NULL, `incenticide_no` varchar(50) NOT NULL, `fertilizer_no` varchar(50) NOT NULL, `passport_no` varchar(50) NOT NULL, `year1` varchar(30) NOT NULL, `year2` varchar(30) NOT NULL, `year3` varchar(30) NOT NULL, `amount1` varchar(25) NOT NULL, `amount2` varchar(25) NOT NULL, `amount3` varchar(25) NOT NULL, `turnover1` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `turnover2` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `turnover3` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_office_id` varchar(25) NOT NULL, `approval_date` text NOT NULL, `credit_limit_office` varchar(50) NOT NULL, `credit_days_office` varchar(50) NOT NULL, `contact_no` varchar(25) NOT NULL, `seq_cheque2` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `sec_check_bank` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `close_balance` varchar(200) DEFAULT NULL, `credit_close_balance` varchar(200) DEFAULT NULL, `active_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 fo active and 1 for inactive', `cat1_diss` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cat2_diss` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cat3_diss` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_verify` tinyint(1) NOT NULL DEFAULT 0 COMMENT '0 not verify 1 verify', `cust_lat` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_long` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_location_date` date DEFAULT NULL, `cust_location_time` time DEFAULT NULL, `reg_type` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `group_type` varchar(255) NOT NULL, `transpot_name` varchar(255) NOT NULL, `cust_dealer_code` varchar(260) NOT NULL, `cust_reg_status` varchar(15) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `dealer_credit_note` -- CREATE TABLE `dealer_credit_note` ( `cn_id` int(11) NOT NULL, `fk_cust_id` int(11) NOT NULL, `cn_amount` varchar(200) NOT NULL, `cn_against` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cn_date` date NOT NULL, `cn_narration` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_pay_id` int(11) NOT NULL, `cn_status` int(11) NOT NULL, `year_id` int(11) NOT NULL DEFAULT 2 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `dealer_stock_table` -- CREATE TABLE `dealer_stock_table` ( `dst_id` int(11) NOT NULL, `fk_cust_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `dst_date` date NOT NULL, `dst_status` int(11) NOT NULL DEFAULT 0, `dst_img` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `dealer_stock_table_details` -- CREATE TABLE `dealer_stock_table_details` ( `dstd_id` int(11) NOT NULL, `fk_dst_id` int(11) NOT NULL, `fk_product_id` int(11) NOT NULL, `product_qty_case` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `product_qty_norm` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `demo_customer_for_testing` -- CREATE TABLE `demo_customer_for_testing` ( `id` int(11) NOT NULL, `name` varchar(100) NOT NULL, `mobile` varchar(10) NOT NULL, `address` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `department` -- CREATE TABLE `department` ( `dept_id` int(11) NOT NULL, `dept_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `department` -- INSERT INTO `department` (`dept_id`, `dept_name`) VALUES (1, 'Office'), (2, 'Marketing and Development'), (3, 'Production'), (6, 'Sales Management'); -- -------------------------------------------------------- -- -- Table structure for table `designation` -- CREATE TABLE `designation` ( `desig_id` int(11) NOT NULL, `desig_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `designation` -- INSERT INTO `designation` (`desig_id`, `desig_name`) VALUES (1, 'Accountant'), (2, 'Admin'), (3, 'HR'), (4, 'Sale Officer'), (6, 'Purchase Officer'), (7, 'Area Sales Manager'), (8, 'Asst Area Development Manager'), (9, 'Marketing And Development Officer'), (10, 'Marketing Sales Officer'), (11, 'Sale and Development Office'), (12, 'RSM'), (13, 'Development Manager '), (14, 'Development Executive'), (15, 'Sales Executive'), (16, 'Market and Development officer'), (25, 'Sales representative'), (26, 'Managing director'), (39, 'Field Assistant'), (28, 'Regional area manager '), (40, 'Depo Incharge'), (31, 'Accountant'), (32, 'Sales executive '), (33, 'Business co-ordinator '), (34, 'Territory manager'), (38, 'Area sales manager'); -- -------------------------------------------------------- -- -- Table structure for table `designation_table` -- CREATE TABLE `designation_table` ( `dt_id` int(11) NOT NULL, `dt_name` varchar(200) NOT NULL, `qta_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 for company 1 for qta' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `dispatch_godown` -- CREATE TABLE `dispatch_godown` ( `dg_id` int(11) NOT NULL, `dg_name` text NOT NULL, `dg_address` text NOT NULL, `dg_mob` varchar(20) NOT NULL, `dg_email` text NOT NULL, `dg_landline` text NOT NULL, `dg_reg_date` date NOT NULL, `dg_user` text NOT NULL, `dg_pass` varchar(200) NOT NULL, `dg_incharge` varchar(255) NOT NULL, `short_code` varchar(200) NOT NULL, `dg_active_status` int(11) NOT NULL DEFAULT 1 COMMENT '1 acive and 0 inactive', `SAP_id` int(11) NOT NULL, `comp_name` varchar(30) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `dispatch_godown` -- INSERT INTO `dispatch_godown` (`dg_id`, `dg_name`, `dg_address`, `dg_mob`, `dg_email`, `dg_landline`, `dg_reg_date`, `dg_user`, `dg_pass`, `dg_incharge`, `short_code`, `dg_active_status`, `SAP_id`, `comp_name`) VALUES (5, 'Obenol Chemicals', 'Sector B- 73 & 74 kinhi Midc,Bhusawal.Dist- Jalgaon (MS)', '8421631603', 'enquiry@obenolchemicals.in', '918421365772', '2026-06-01', 'Obenol@123', 'obenol', 'Obenol Chemicals', 'OC', 1, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `district_table` -- CREATE TABLE `district_table` ( `dt_id` int(11) NOT NULL, `dt_district` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_st_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `district_table` -- INSERT INTO `district_table` (`dt_id`, `dt_district`, `fk_st_id`) VALUES (1, 'NASHIK', 13), (2, 'PUNE', 13), (3, 'AHEMADNAGAR', 13), (4, 'SANGLI', 13), (5, 'SATARA', 13), (6, 'SOLAPUR', 13), (7, 'THANE', 13), (8, 'PALGHAR', 13), (9, 'RATNAGIRI', 13), (10, 'SINDHUDURG', 13), (11, 'KOLHAPUR', 13), (12, 'AURANGABAD', 13), (13, 'DHULE', 13), (14, 'JALGAON', 13), (15, 'NANDURBAR', 13), (16, 'AKOLA', 13), (17, 'AMRAVATI', 13), (18, 'BULDHANA', 13), (19, 'YAVATMAL', 13), (20, 'WASHIM', 13), (21, 'HINGOLI', 13), (22, 'JALNA', 13), (23, 'LATUR', 13), (24, 'NANDED', 13), (25, 'OSMANABAD', 13), (26, 'PARBHANI', 13), (27, 'CHANDRAPUR', 13), (28, 'GADCHIROLI', 13), (29, 'GONDIA', 13), (30, 'NAGPUR', 13), (31, 'WARDHA', 13), (32, 'BEED', 13), (33, 'RAIGARD', 13), (34, 'BHANDARA', 13), (35, 'Barwani', 12), (36, 'bhopal ', 12), (37, 'burhanpur', 12), (38, 'dhar', 12), (39, 'Hoshangabad', 12), (40, 'Mandsaur ', 12), (41, 'Neemuch ', 12), (42, 'Raisen', 12), (43, 'Rajgarh', 12), (44, 'Ratlam', 12), (45, 'Sehore ', 12), (46, 'Shajapur', 12), (47, 'Ujjain', 12), (48, 'East Nimar', 12), (49, 'West Nimar', 12), (50, 'Narmada', 7), (51, 'Tapi', 7), (52, 'Vadodara', 7), (53, 'Chikkaballapura', 11), (54, 'Kolar', 11), (55, 'Mysore', 11), (56, 'Tumkur', 11), (57, 'Bangalore Rural', 11), (58, 'Chitradurga', 11), (59, 'Shimoga', 11), (60, 'Krishnagiri', 14), (61, 'Betul', 12), (62, 'Jhabua', 12), (63, 'Indore', 12), (64, 'Surat', 7), (65, 'Bharuch', 7), (66, 'Anand', 7), (67, 'Kheda', 7), (68, 'Ahmadabad', 7), (69, 'Davanagere', 11), (70, 'Ramanagara', 11), (71, 'Bangalore', 11), (72, 'Dewas', 12), (73, 'Adilabad', 15), (74, 'Bhoisar', 13), (75, 'Guntur', 2), (77, 'Belgaon', 11); -- -------------------------------------------------------- -- -- Table structure for table `dwr_table` -- CREATE TABLE `dwr_table` ( `dwr_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `dwr_date` date NOT NULL, `dwr_time` varchar(100) NOT NULL, `dwr_end_ime` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `dwr_status` int(11) NOT NULL DEFAULT 0, `fa_status` int(11) NOT NULL DEFAULT 0, `fa_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `so_status` int(11) NOT NULL DEFAULT 0, `so_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `am_status` int(11) NOT NULL DEFAULT 0, `am_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `gm_status` int(11) NOT NULL DEFAULT 0, `gm_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `director_status` int(11) NOT NULL DEFAULT 0, `director_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `employee_adv_payment` -- CREATE TABLE `employee_adv_payment` ( `emp_adv_id` int(11) NOT NULL, `emp_adv_date` date NOT NULL, `emp_adv_amt` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_et_id` varchar(200) NOT NULL, `emp_adv_status` int(11) NOT NULL DEFAULT 0, `emp_adv_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `employee_hierarchy` -- CREATE TABLE `employee_hierarchy` ( `eh_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `map_to` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `employee_salary_table` -- CREATE TABLE `employee_salary_table` ( `emp_adv_id` int(11) NOT NULL, `emp_adv_date` date NOT NULL, `emp_adv_amt` varchar(200) NOT NULL, `fk_et_id` varchar(200) NOT NULL, `emp_adv_status` int(11) NOT NULL DEFAULT 0, `emp_adv_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `es_total_days` varchar(200) NOT NULL, `es_working_days` varchar(200) NOT NULL, `es_total_salary` varchar(200) NOT NULL, `es_payable_salary` varchar(200) NOT NULL, `es_adv_payment` varchar(200) NOT NULL, `es_month` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `es_adv_deduction` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `es_expence_amt` varchar(200) NOT NULL, `es_net_salary` varchar(200) NOT NULL, `es_year` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `employee_table` -- CREATE TABLE `employee_table` ( `et_id` int(11) NOT NULL, `et_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_add` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_contact` text NOT NULL, `et_location` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_join_date` text NOT NULL, `et_birth_date` text NOT NULL, `et_status` int(11) NOT NULL DEFAULT 1, `et_desig` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `pass` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_par_add` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_nation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_relig` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_caste` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_gender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_bg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_height` text NOT NULL, `et_weight` text NOT NULL, `et_pan_no` text NOT NULL, `et_mat_st` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_pass_no` blob DEFAULT NULL, `et_hobbies` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_iden` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_tw` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_fw` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_ctw` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_cfw` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_dr_lice_no` text NOT NULL, `et_near_rail_stat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_near_airport` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_near_police` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_home_detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_home_lone` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_major_dise` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_aller` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_lan_known` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_agri_land` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_agri_land_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_non_irr` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_non_irr_area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_insurance` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_bank_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_branch_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_acc_no` text NOT NULL, `et_acc_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_micr_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_ifse_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_qua` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_pass_year` text NOT NULL, `et_school_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_univer` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_per` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_gra` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_fam` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_nomi` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_joining_date` text NOT NULL, `et_designation` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_emp_id` text NOT NULL, `et_dept` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_head_quar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_name_imme` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_pre_emp_detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `img_file` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_rpk` float NOT NULL, `fk_st_id` int(11) NOT NULL, `Direct_bill` varchar(200) NOT NULL, `Four_wheel` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `Two_wheel` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `wk_off` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_company` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_branch` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_emp_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_emp_cardno` varchar(200) NOT NULL, `et_grade` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_default_shift` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_emplyment` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_ot_appliacable` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `et_auto_shift` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `father_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `mother_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `marital_status` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `spouse_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `payment_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `prev_design` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `prev_work_yr` varchar(200) NOT NULL, `prev_salary` varchar(200) NOT NULL, `reason_resign` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pin_code` varchar(200) NOT NULL, `emergency_no` varchar(200) NOT NULL, `prev_company` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_dt_id` varchar(200) NOT NULL, `city_id` varchar(200) NOT NULL, `pf_acc_no` varchar(200) NOT NULL, `emp_UAN_no` varchar(200) NOT NULL, `emp_status` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `emp_division` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `emp_company_id` int(11) NOT NULL DEFAULT 1, `fk_dg_id` varchar(20) NOT NULL, `return_to_head_qua_da` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `out_of_head_qua_da` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `monthly_salary` varchar(200) NOT NULL, `et_inactive_date` date DEFAULT NULL, `emp_availability` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `emp_report_per_status` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '1 for on 0 for off ', `mis_report_status` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `mis_attendence_smry` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `mis_prtial_pendi_ord` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `mis_tranding_pro` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `emp_loading_limit` varchar(40) NOT NULL, `et_device_id` varchar(255) NOT NULL, `probation_period` varchar(255) NOT NULL, `probation_status` varchar(255) NOT NULL, `et_region_rate` varchar(255) NOT NULL COMMENT '1-maharastra,2-other maharastra', `et_region_rate_status` int(11) NOT NULL COMMENT '0 for hide 1 for show\r\n\r\nPrice List Status' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `employee_table` -- INSERT INTO `employee_table` (`et_id`, `et_name`, `et_add`, `et_email`, `et_contact`, `et_location`, `et_join_date`, `et_birth_date`, `et_status`, `et_desig`, `user`, `pass`, `et_par_add`, `et_nation`, `et_relig`, `et_caste`, `et_category`, `et_gender`, `et_bg`, `et_height`, `et_weight`, `et_pan_no`, `et_mat_st`, `et_pass_no`, `et_hobbies`, `et_iden`, `et_tw`, `et_fw`, `et_ctw`, `et_cfw`, `et_dr_lice_no`, `et_near_rail_stat`, `et_near_airport`, `et_near_police`, `et_home_detail`, `et_home_lone`, `et_major_dise`, `et_aller`, `et_lan_known`, `et_agri_land`, `et_agri_land_area`, `et_non_irr`, `et_non_irr_area`, `et_insurance`, `et_bank_name`, `et_branch_name`, `et_acc_no`, `et_acc_type`, `et_micr_code`, `et_ifse_code`, `et_qua`, `et_pass_year`, `et_school_name`, `et_univer`, `et_per`, `et_gra`, `et_fam`, `et_nomi`, `et_joining_date`, `et_designation`, `et_emp_id`, `et_dept`, `et_head_quar`, `et_name_imme`, `et_pre_emp_detail`, `img_file`, `et_rpk`, `fk_st_id`, `Direct_bill`, `Four_wheel`, `Two_wheel`, `wk_off`, `et_company`, `et_branch`, `et_emp_code`, `et_emp_cardno`, `et_grade`, `et_default_shift`, `et_emplyment`, `et_ot_appliacable`, `et_auto_shift`, `father_name`, `mother_name`, `marital_status`, `spouse_name`, `payment_type`, `prev_design`, `prev_work_yr`, `prev_salary`, `reason_resign`, `pin_code`, `emergency_no`, `prev_company`, `fk_dt_id`, `city_id`, `pf_acc_no`, `emp_UAN_no`, `emp_status`, `emp_division`, `emp_company_id`, `fk_dg_id`, `return_to_head_qua_da`, `out_of_head_qua_da`, `monthly_salary`, `et_inactive_date`, `emp_availability`, `emp_report_per_status`, `mis_report_status`, `mis_attendence_smry`, `mis_prtial_pendi_ord`, `mis_tranding_pro`, `emp_loading_limit`, `et_device_id`, `probation_period`, `probation_status`, `et_region_rate`, `et_region_rate_status`) VALUES (1, 'FlyCT Softtech', 'Nashik', '', '8380808066', NULL, '2026-06-06', '', 1, '111', 'flyctuser', 'user@1991', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '2', NULL, NULL, NULL, NULL, 0, 13, 'yes', '10', '6', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', '100', '120', '', NULL, '', '', '1', '1', '1', '1', '800', '', '3', '', '2', 1), (2, 'Bhavesh Kumbhar', 'Nashik', '', '8380808066', NULL, '2026-06-06', '', 1, '111', 'bs', 'bs', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', '', '', NULL, '', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '', '1', NULL, NULL, NULL, NULL, 0, 13, 'no', '10', '8', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 1, '', '100', '120', '', NULL, '', '', '1', '1', '1', '1', '800', '', '3', '', '8', 1); -- -------------------------------------------------------- -- -- Table structure for table `employee_tour_route` -- CREATE TABLE `employee_tour_route` ( `etr_id` int(11) NOT NULL, `fk_emp_id` varchar(255) NOT NULL, `route_name` varchar(255) NOT NULL, `route_date` date DEFAULT NULL, `entry_date_time` datetime NOT NULL, `status` varchar(255) NOT NULL COMMENT '0 for pending 1 for received', `login_id` varchar(255) NOT NULL, `approved_date` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `emp_attendance` -- CREATE TABLE `emp_attendance` ( `attendance_id` int(11) NOT NULL, `fk_emp_id` int(11) NOT NULL, `att_check_in_date` date NOT NULL, `att_check_in_time` time NOT NULL, `att_emp_photo` varchar(200) NOT NULL, `att_check_in_lat` varchar(200) NOT NULL, `att_check_in_long` varchar(200) NOT NULL, `att_check_out_time` time NOT NULL, `att_check_out_lat` varchar(200) NOT NULL, `att_check_out_long` varchar(200) NOT NULL, `emp_atte_check_in_status` int(11) NOT NULL DEFAULT 0, `att_is_delete` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `emp_state_maping` -- CREATE TABLE `emp_state_maping` ( `esm_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `fk_st_id` int(11) NOT NULL, `esm_date` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `emp_target` -- CREATE TABLE `emp_target` ( `emp_trg_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `emp_trg_amt` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_fin_year_id` int(11) NOT NULL, `fk_st_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `expenses` -- CREATE TABLE `expenses` ( `exp_id` int(11) NOT NULL, `exp_account_user` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `group_type` varchar(255) NOT NULL, `exp_amount` text NOT NULL, `exp_date` text NOT NULL, `exp_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `exp_status` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `etype` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `factory_order` -- CREATE TABLE `factory_order` ( `fo_id` int(11) NOT NULL, `fo_date` date NOT NULL, `fo_time` varchar(100) NOT NULL, `fo_status` int(11) NOT NULL DEFAULT 0, `fk_gd_id` int(11) NOT NULL, `status` int(11) NOT NULL, `challan_no` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `tran_details` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lr_no` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `challan_status` int(11) NOT NULL DEFAULT 0, `freight_amount` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `year_id` int(11) NOT NULL DEFAULT 6, `challan_sequence` int(11) NOT NULL, `godown_tranfer_id` int(11) NOT NULL, `narration` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `factory_order_data` -- CREATE TABLE `factory_order_data` ( `fod_id` int(11) NOT NULL, `fk_fo_id` int(11) NOT NULL, `product_id` int(11) NOT NULL, `packing_id` int(11) NOT NULL, `product_qty` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `receiving_qty` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lot_no` varchar(200) NOT NULL, `no_ofunit_in_a_case` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `farmer_meeting` -- CREATE TABLE `farmer_meeting` ( `fm_id` int(11) NOT NULL, `district_id` varchar(200) NOT NULL, `taluka_id` varchar(200) NOT NULL, `place_id` varchar(200) NOT NULL, `fm_date` date NOT NULL, `fm_photo` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `status` int(11) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `farmer_meeting_details` -- CREATE TABLE `farmer_meeting_details` ( `fmd_id` int(11) NOT NULL, `fmd_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fmd_contact` varchar(200) NOT NULL, `fmd_crop` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fmd_acerage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fmd_place` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `financial_year` -- CREATE TABLE `financial_year` ( `id` int(11) NOT NULL, `from_date` date NOT NULL, `to_date` date NOT NULL, `year` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `financial_year` -- INSERT INTO `financial_year` (`id`, `from_date`, `to_date`, `year`) VALUES (1, '2024-04-01', '2025-03-31', '2024-25'), (2, '2025-04-01', '2026-03-31', '2025-26'), (3, '2026-04-01', '2027-03-31', '2026-27'), (4, '2027-04-01', '2028-03-31', '2027-28'), (5, '2028-04-01', '2029-03-31', '2028-29'); -- -------------------------------------------------------- -- -- Table structure for table `finish_product_damage_stock` -- CREATE TABLE `finish_product_damage_stock` ( `fps_id` int(11) NOT NULL, `fps_date` date NOT NULL, `fps_time` text NOT NULL, `batch_no` varchar(200) NOT NULL, `fk_dg_id` int(11) NOT NULL, `fk_year_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `finish_product_damage_stock_details` -- CREATE TABLE `finish_product_damage_stock_details` ( `fpsd_id` int(11) NOT NULL, `fk_fps_id` int(11) NOT NULL, `fk_packing_id` varchar(200) NOT NULL, `fpsd_case_qty` varchar(200) NOT NULL, `manu_date` date NOT NULL, `ex_date` date NOT NULL, `batch_code` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `finish_product_stock` -- CREATE TABLE `finish_product_stock` ( `fps_id` int(11) NOT NULL, `fps_date` date NOT NULL, `fps_time` text NOT NULL, `batch_no` varchar(200) NOT NULL, `fk_dg_id` int(11) NOT NULL, `year_id` int(11) NOT NULL DEFAULT 7, `entry_type_mater` varchar(90) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `finish_product_stock_details` -- CREATE TABLE `finish_product_stock_details` ( `fpsd_id` int(11) NOT NULL, `fk_fps_id` int(11) NOT NULL, `fk_product_id` int(11) NOT NULL, `fk_packing_id` varchar(200) NOT NULL, `fpsd_case_qty` varchar(200) NOT NULL, `manu_date` date NOT NULL, `ex_date` date NOT NULL, `batch_code` varchar(200) NOT NULL, `fk_year_id` int(11) NOT NULL, `entry_type` varchar(10) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `godown_to_godown_transfer_order` -- CREATE TABLE `godown_to_godown_transfer_order` ( `godown_transfer_id` int(11) NOT NULL, `from_godown_id` int(11) NOT NULL, `to_godown_id` int(11) NOT NULL, `transfer_date` datetime NOT NULL DEFAULT current_timestamp(), `transfer_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `group_table` -- CREATE TABLE `group_table` ( `gt_id` int(11) NOT NULL, `gt_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `holiday` -- CREATE TABLE `holiday` ( `holi_id` int(11) NOT NULL, `holi_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `holi_date` date NOT NULL, `fk_state_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `holiday` -- INSERT INTO `holiday` (`holi_id`, `holi_name`, `holi_date`, `fk_state_id`) VALUES (19, 'DIWALI', '2026-11-11', 13), (17, 'DIWALI', '2026-11-09', 13), (18, 'DIWALI', '2026-11-10', 13), (16, 'DASHERA', '2026-10-20', 13), (15, 'Rakshabandan', '2026-08-28', 13), (14, 'INDEPENDENCE DAY ', '2026-08-15', 13), (20, 'SHRI GANESH CHATURTHI ', '2026-09-14', 13); -- -------------------------------------------------------- -- -- Table structure for table `holiday_details` -- CREATE TABLE `holiday_details` ( `holi_id` int(11) NOT NULL, `fk_hl_id` int(11) NOT NULL, `fk_state_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `holiday_master` -- CREATE TABLE `holiday_master` ( `hl_id` int(11) NOT NULL, `ht_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `hl_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `invoice_table` -- CREATE TABLE `invoice_table` ( `inv_id` int(11) NOT NULL, `invoice_no` int(11) NOT NULL, `invoice_date` varchar(200) NOT NULL, `invoice_time` varchar(200) NOT NULL, `fk_ord_id` int(11) NOT NULL, `ref_dc_no` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `item_master` -- CREATE TABLE `item_master` ( `sr_no` int(11) NOT NULL, `item_code` varchar(50) NOT NULL COMMENT 'SAP id', `brand_name` varchar(100) NOT NULL COMMENT 'Product Name', `item_group` varchar(100) DEFAULT NULL, `state` varchar(50) DEFAULT NULL, `standard_packing` varchar(50) DEFAULT NULL, `nos` int(11) DEFAULT 0, `units_per_master_packing` varchar(260) DEFAULT '1', `master_packing` varchar(50) DEFAULT NULL, `item_name` varchar(150) NOT NULL, `foreign_name` varchar(150) DEFAULT NULL COMMENT 'Packing', `flag` varchar(10) DEFAULT 'N', `gst_slab` varchar(20) DEFAULT '0.00', `hsn_code` varchar(20) DEFAULT NULL, `dp_per_nos` varchar(200) DEFAULT '0.00', `master_packing_dp` varchar(260) DEFAULT '0.00' COMMENT 'DP Rate', `dp_incl_gst` varchar(100) DEFAULT NULL, `mrp_per_unit` varchar(260) DEFAULT '0.00', `master_packing_mrp` varchar(260) DEFAULT '0.00', `inventory_uom` varchar(20) DEFAULT NULL, `item_type` varchar(50) DEFAULT NULL, `exp_period_days` varchar(11) DEFAULT '0', `company_name` varchar(80) NOT NULL, `created_at` date NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `language_list` -- CREATE TABLE `language_list` ( `lang_id` int(11) NOT NULL, `lang_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lang_is_delete` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `leave` -- CREATE TABLE `leave` ( `lv_id` int(11) NOT NULL, `fk_pl_id` int(11) NOT NULL, `lv_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lv_date` date NOT NULL, `lv_status` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lv_reason` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lv_applic_date` date NOT NULL, `fk_et_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `leave_table` -- CREATE TABLE `leave_table` ( `lt_id` int(11) NOT NULL, `fk_leave_type_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `lt_from_date` date NOT NULL, `lt_to_date` date NOT NULL, `lt_reason` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `lt_app_date` date NOT NULL, `lt_status` int(11) NOT NULL DEFAULT 0 COMMENT 'admin', `so_status` int(11) NOT NULL DEFAULT 0, `so_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `am_status` int(11) NOT NULL DEFAULT 0, `am_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `gm_status` int(11) NOT NULL DEFAULT 0, `gm_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_quarter_id` int(11) NOT NULL, `lt_type` int(11) DEFAULT 0 COMMENT '0 for regular AND 1 for other', `lt_status_mgr` int(11) NOT NULL COMMENT '1 for approve | 0 for not approve' ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `leave_verify_table` -- CREATE TABLE `leave_verify_table` ( `report_verify_id` int(11) NOT NULL, `fk_dwr_id` int(11) NOT NULL, `fk_leave_id` varchar(255) NOT NULL, `fk_et_id` int(11) NOT NULL, `report_verify_status` int(11) NOT NULL DEFAULT 0, `sr_approve_status` varchar(255) NOT NULL, `sr_reject_remark` varchar(255) NOT NULL, `report_verify_remark` text NOT NULL, `report_verify_date` date NOT NULL, `sr_approval_date` date NOT NULL, `sr_approval_time` time NOT NULL, `map_to` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `leave_verify_tableold` -- CREATE TABLE `leave_verify_tableold` ( `lvt_id` int(11) NOT NULL, `fk_leave_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL COMMENT 'sr person', `sr_approve_status` int(11) NOT NULL COMMENT '0 for pending | 1for approve ', `sr_approval_date` date NOT NULL, `sr_approval_time` time NOT NULL, `sr_reject_remark` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `map_emp_district` -- CREATE TABLE `map_emp_district` ( `med_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `fk_dt_id` int(11) NOT NULL, `fk_st_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `master_seting` -- CREATE TABLE `master_seting` ( `mseting_id` int(11) NOT NULL, `mseting_year` varchar(200) NOT NULL, `mseting_start_date` date NOT NULL, `mseting_end_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `mobile_firebase_token` -- CREATE TABLE `mobile_firebase_token` ( `mft_id` int(11) NOT NULL, `fk_emp_id` int(11) NOT NULL, `mfb_token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `mft_imei_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `mft_generate_date` date NOT NULL, `mft_generate_time` datetime NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `monthly_salary` -- CREATE TABLE `monthly_salary` ( `ms_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `ms_basic` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_da` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_hra` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_medical` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_mobile` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_conveyance` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_education` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_special_allow` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_pf` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_pt` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_total_salary` varchar(200) NOT NULL, `ms_other_deduction` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_advanced` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_date` date NOT NULL, `ms_payment_mode` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_tds` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `no_absent_days` int(11) NOT NULL, `no_present_day` int(11) NOT NULL, `no_weekly_off` int(11) NOT NULL, `no_holiday` int(11) NOT NULL, `no_leave` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `month` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `year` varchar(200) NOT NULL, `ms_bonus` varchar(200) NOT NULL, `ms_ot_amount` varchar(200) NOT NULL, `ms_ot_hour` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ms_half_day` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_basic` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_da` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_medical1` int(11) NOT NULL, `allow_hra` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_medical` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_conveyance` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_education` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_special_allow` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `allow_mobile` varchar(200) NOT NULL, `allow_total_sallary` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=DYNAMIC; -- -------------------------------------------------------- -- -- Table structure for table `new_dwr` -- CREATE TABLE `new_dwr` ( `new_dwr_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `dwr_start_date` date NOT NULL, `dwr_start_time` varchar(200) NOT NULL, `dwr_start_lat` varchar(200) NOT NULL, `dwr_start_long` varchar(200) NOT NULL, `dwr_end_date` date NOT NULL, `dwr_end_time` varchar(200) NOT NULL, `dwr_end_lat` varchar(200) NOT NULL, `dwr_end_long` varchar(200) NOT NULL, `dwr_visited_route` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `dwr_start_reading_km` varchar(200) NOT NULL, `dwr_total_km` varchar(200) NOT NULL, `dwr_start_odometer_img` varchar(200) NOT NULL, `dwr_end_reading_km` varchar(200) NOT NULL, `dwr_end_odometer_img` varchar(200) NOT NULL, `dwr_travel_by_vehicle` varchar(200) NOT NULL, `dwr_fuel_receipt_img` varchar(200) NOT NULL, `ex_fuel` varchar(200) NOT NULL, `dwr_rate_per_km` varchar(200) NOT NULL, `emp_direct_bill_status` varchar(255) NOT NULL, `dwr_ticket_img` varchar(200) NOT NULL, `dwr_logging_img` varchar(200) NOT NULL, `dwr_other_exp_img` varchar(260) NOT NULL, `dwr_da` varchar(200) NOT NULL, `dwr_local_da` varchar(255) NOT NULL, `dwr_other_expenses` varchar(200) NOT NULL, `dwr_total_expenses` varchar(200) NOT NULL, `dwr_change_date` date NOT NULL, `dwr_status` varchar(200) NOT NULL DEFAULT '0' COMMENT '0 for Pending | 1 for Accept', `dwr_other_remark` varchar(200) NOT NULL, `dwr_lodging_bill` varchar(200) NOT NULL, `dwr_bus_fair` varchar(200) NOT NULL, `dwr_rail_fair` varchar(200) NOT NULL, `dwr_tot_km_random_no` int(11) NOT NULL, `dwr_is_delete` varchar(200) NOT NULL DEFAULT '0', `change_present_status` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `new_hierarchy` -- CREATE TABLE `new_hierarchy` ( `nh_id` int(11) NOT NULL, `reporting_emp` int(11) NOT NULL, `report_to` int(11) NOT NULL, `report_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 for reporting and 1 for order verify', `order_status` int(11) NOT NULL DEFAULT 0, `leave_status` int(11) NOT NULL DEFAULT 0 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_product` -- CREATE TABLE `order_product` ( `ord_pro_id` int(11) NOT NULL, `fk_ord_id` int(11) NOT NULL, `product_id` varchar(200) NOT NULL, `product_qty` varchar(25) NOT NULL COMMENT 'case', `product_qty_in_norms` int(11) NOT NULL, `remainig_qty` varchar(50) DEFAULT NULL, `product_rate` varchar(25) NOT NULL, `op_status` int(11) NOT NULL DEFAULT 1, `p_diss2` float NOT NULL, `ord_gst` int(11) NOT NULL, `lot_no` varchar(200) NOT NULL, `mandate` varchar(200) NOT NULL, `expdate` varchar(200) NOT NULL, `product_temp_qty` varchar(50) DEFAULT NULL, `product_barcode` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `no_ofunit_in_a_case` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pro_kit_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_table` -- CREATE TABLE `order_table` ( `ord_id` int(11) NOT NULL, `cust_id` int(11) NOT NULL, `ord_date` date NOT NULL, `ord_status` varchar(25) NOT NULL DEFAULT 'no', `ord_emp_staus` blob DEFAULT NULL, `vat` varchar(10) DEFAULT NULL, `discount` int(11) DEFAULT 0, `et_id` int(11) NOT NULL, `ot_who` text NOT NULL, `fk_dg_id` int(11) NOT NULL, `ord_remark` text DEFAULT NULL, `deliver_to` text NOT NULL, `dispatach_by` text DEFAULT NULL, `ord_ref_id` varchar(50) NOT NULL, `ord_time` varchar(200) NOT NULL, `tname` varchar(200) NOT NULL, `tvalue` varchar(200) NOT NULL, `trans_from_order` int(11) NOT NULL, `tras_ref_order_id` int(11) NOT NULL, `ord_admin_verify_status` int(11) NOT NULL DEFAULT 0, `comp_id` int(11) NOT NULL, `fk_product_id` int(11) NOT NULL, `packing` varchar(100) NOT NULL, `qty` int(11) NOT NULL, `ord_bill_image` varchar(200) NOT NULL, `ord_ref_from` varchar(200) NOT NULL, `am_status` int(11) NOT NULL DEFAULT 0, `gm_status` int(11) NOT NULL DEFAULT 0, `ord_type` int(11) NOT NULL DEFAULT 1, `challan_status` int(11) NOT NULL DEFAULT 0, `transporter` varchar(200) NOT NULL, `challan_no` varchar(200) NOT NULL, `tran_details` varchar(200) NOT NULL, `lr_no` varchar(200) NOT NULL, `ord_freight_amt` varchar(200) NOT NULL, `ord_challan_no` int(11) NOT NULL, `year_status` int(11) NOT NULL DEFAULT 1, `challan_date` date NOT NULL, `narration` text DEFAULT NULL, `year_id` int(11) NOT NULL DEFAULT 3, `remainig_prod_qty_status` int(11) NOT NULL DEFAULT 1 COMMENT '1 for complete 2 for remaining', `ord_gst_type` int(11) NOT NULL COMMENT '0 for non gst | 1 for with gst ', `farmer_address` text NOT NULL, `farmer_mob_no` varchar(12) NOT NULL, `transporter_name` varchar(255) NOT NULL, `transfer_cust_id` int(11) NOT NULL COMMENT 'order reference id ' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `order_verify_table` -- CREATE TABLE `order_verify_table` ( `order_verify_id` int(11) NOT NULL, `fk_order_id` int(11) NOT NULL, `order_verify_status` int(11) NOT NULL DEFAULT 0, `order_verify_date` date NOT NULL, `fk_et_id` int(11) NOT NULL, `order_verify_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `paid_leave` -- CREATE TABLE `paid_leave` ( `pl_id` int(11) NOT NULL, `pl_personal_leave` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pl_seek_leave` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pl_casual_leave` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `pl_updated_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment` -- CREATE TABLE `payment` ( `pay_id` int(11) NOT NULL, `cust_id` int(11) NOT NULL, `emp_id` int(11) DEFAULT NULL, `amt` text DEFAULT NULL, `pay_date` date DEFAULT NULL, `pay_by` text DEFAULT NULL, `bank_name` text DEFAULT NULL, `branch_name` text DEFAULT NULL, `acc_no` text DEFAULT NULL, `status` varchar(25) NOT NULL DEFAULT 'no', `rtgs` text DEFAULT NULL, `neft` text DEFAULT NULL, `comp_bank_name` text DEFAULT NULL, `cheque_on_date` date DEFAULT NULL, `receipt_no` text DEFAULT NULL, `deposit_location` text DEFAULT NULL, `NFT_RTGS_no` text DEFAULT NULL, `third_party` text DEFAULT NULL, `check_no` varchar(100) DEFAULT NULL, `pay_remark` text DEFAULT NULL, `comp_name` text DEFAULT NULL, `pay_collect_by` varchar(200) DEFAULT NULL, `emp_verify` varchar(20) NOT NULL DEFAULT '1', `pay_time` varchar(200) DEFAULT NULL, `deposit_date` date NOT NULL, `pay_note` text NOT NULL, `emp_status` varchar(200) NOT NULL, `pay_type` int(11) NOT NULL DEFAULT 1, `account_id` int(11) NOT NULL, `payment_against` text DEFAULT NULL, `year_id` int(11) NOT NULL DEFAULT 9, `pay_otp` int(11) NOT NULL, `pay_otp_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 for pending and 1 for verified', `cheque_img` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `payment_verify_table` -- CREATE TABLE `payment_verify_table` ( `payment_verify_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `fk_pay_id` int(11) NOT NULL, `payment_verify_status` int(11) NOT NULL DEFAULT 0, `payment_verify_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `place_table` -- CREATE TABLE `place_table` ( `pt_id` int(11) NOT NULL, `pt_place` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_tt_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_category_tbl` -- CREATE TABLE `product_category_tbl` ( `product_category_tbl_id` int(11) NOT NULL, `product_category_tbl_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cat_code` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `product_category_image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_details` -- CREATE TABLE `product_details` ( `product_d_id` int(11) NOT NULL, `product_id` int(11) DEFAULT NULL, `packing_label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `packing` varchar(260) NOT NULL, `no_of_units_in_a_case` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `unit_label` varchar(260) NOT NULL, `ndp_per_ltr_kg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `mrp_per_ltr_kg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `second_ndp_per_ltr_kg` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `stock` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `p_diss1` int(11) NOT NULL, `fk_st_id` int(11) NOT NULL, `packing_unit` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `region_rate` varchar(255) NOT NULL COMMENT '1-maharstra,2-other maharastra MRP\r\nVidarbha , Marathwada & Khandesh', `SolapurSataraPune` varchar(100) NOT NULL COMMENT 'region 3 MRP', `Baramati` varchar(100) NOT NULL COMMENT 'region 4 MRP', `sangli` varchar(100) NOT NULL COMMENT 'region 10 MRP', `parbhani` varchar(100) NOT NULL COMMENT 'region 5 MRP', `yeola` varchar(100) NOT NULL COMMENT 'region 7 MRP', `nashik` varchar(100) NOT NULL COMMENT 'region 8 MRP', `palghar` varchar(100) NOT NULL COMMENT 'region 9 MRP', `madhyapradesh` varchar(260) NOT NULL COMMENT 'region 6 MRP', `DPregion_rate` varchar(30) NOT NULL COMMENT '1-maharstra,2-other maharastra Vidarbha , Marathwada & Khandesh', `DPSolapurSataraPune` varchar(30) NOT NULL COMMENT 'region 3', `DPBaramati` varchar(30) NOT NULL COMMENT 'region 4', `DPsangli` varchar(30) NOT NULL COMMENT 'region 10', `DPparbhani` varchar(30) NOT NULL COMMENT 'region 5', `DPyeola` varchar(30) NOT NULL COMMENT 'region 7', `DPnashik` varchar(30) NOT NULL COMMENT 'region 8', `DPpalghar` varchar(30) NOT NULL COMMENT 'region 9', `DPmadhyapradesh` varchar(30) NOT NULL COMMENT 'region 6', `fk_region_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_kit` -- CREATE TABLE `product_kit` ( `product_kit_id` int(11) NOT NULL, `mst_pro_id` int(11) NOT NULL, `assign_pro_id` int(11) NOT NULL, `assign_pro_qty` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `product_master` -- CREATE TABLE `product_master` ( `product_id` int(11) NOT NULL, `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_desc` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_insert_date` date DEFAULT NULL, `product_img` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_contain` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_uses` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_benefits` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_status` int(11) NOT NULL DEFAULT 1, `p_rank` int(11) DEFAULT NULL, `p_flag` int(11) DEFAULT NULL, `product_name_marathi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_desc_marathi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_contain_marathi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_uses_marathi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_benefits_marathi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_status_marathi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_name_hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_desc_hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_contain_hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_uses_hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `poduct_benefits_hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `product_status_hindi` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `p_diss` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `comp_id` int(11) NOT NULL, `hsn_code` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `gst` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_german2_ci NOT NULL DEFAULT '0', `fk_category_id` int(11) NOT NULL, `fk_lang_id` int(11) NOT NULL, `company_id` int(11) NOT NULL DEFAULT 1 COMMENT '1 for puma 2 for mahgreen', `kit_status` int(11) NOT NULL DEFAULT 0 COMMENT '1 for kir product', `product_pdf` varchar(255) NOT NULL, `product_info_img` varchar(255) NOT NULL, `product_disc` int(11) NOT NULL, `packing_label` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `ptr_delear` -- CREATE TABLE `ptr_delear` ( `ptr_did` int(11) NOT NULL, `ptr_dname` text NOT NULL, `ptr_dmob` text NOT NULL, `ptr_dorder` text NOT NULL, `ptr_dsupply` text NOT NULL, `ptr_dcolle` text NOT NULL, `ptr_nf` text NOT NULL, `ptr_ddate` varchar(200) NOT NULL, `ptr_dtime` text NOT NULL, `fk_dwr_id` int(11) NOT NULL, `ptr_tdate` varchar(200) NOT NULL, `ptr_ddis` varchar(200) NOT NULL, `ptr_dtaluka` int(11) NOT NULL, `ptr_dplace` int(11) NOT NULL, `super_senior_verify_status` varchar(50) DEFAULT '0', `follow_status` int(11) DEFAULT 0, `senior_verify_status` varchar(20) NOT NULL DEFAULT '0', `remark` text NOT NULL, `scheme_name` text NOT NULL, `target` text NOT NULL, `achievement` text NOT NULL, `dealer_entry_date` date DEFAULT NULL, `dealer_entry_time` varchar(50) DEFAULT NULL, `ptr_dlat` varchar(200) NOT NULL, `ptr_dlong` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `ptr_expence` -- CREATE TABLE `ptr_expence` ( `ex_id` int(11) NOT NULL, `ex_bus` varchar(50) NOT NULL, `ex_rail` varchar(50) NOT NULL, `ex_j_b_km` varchar(20) NOT NULL DEFAULT '0', `ex_fuel` varchar(20) NOT NULL, `ex_loadg` varchar(20) NOT NULL, `ex_d_a` varchar(20) NOT NULL, `ex_postage` varchar(20) NOT NULL, `ex_other` varchar(20) NOT NULL, `ex_tdate` date NOT NULL, `fk_dwr_id` int(11) NOT NULL, `super_senior_verify_status` varchar(20) DEFAULT '0', `senior_verify_status` varchar(20) NOT NULL DEFAULT '0', `ptr_start_place` text NOT NULL, `ptr_end_place` text NOT NULL, `ptr_start_reading` text NOT NULL, `ptr_end_reading` text NOT NULL, `ptr_total_km` text NOT NULL, `ptr_remark` text NOT NULL, `v_type` varchar(200) NOT NULL, `updated_remark` text NOT NULL, `expense_entry_date` date DEFAULT NULL, `expense_entry_time` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `ptr_expenceold` -- CREATE TABLE `ptr_expenceold` ( `ex_id` int(11) NOT NULL, `ex_bus` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_rail` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_j_b_km` varchar(20) NOT NULL DEFAULT '0', `ex_fuel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_loadg` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_d_a` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_postage` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_other` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ex_tdate` date NOT NULL, `fk_dwr_id` int(11) NOT NULL, `super_senior_verify_status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0', `senior_verify_status` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `ptr_route_id` int(11) NOT NULL, `ptr_route_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ptr_start_place` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ptr_end_place` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ptr_start_reading` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ptr_end_reading` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ptr_total_km` text NOT NULL, `ptr_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `v_type` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `mobile_bill` varchar(200) NOT NULL DEFAULT '0', `petrol_card` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `vehicle_maintence` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `ex_start_reading_img` text CHARACTER SET utf8 COLLATE utf8_icelandic_ci NOT NULL, `ex_end_reading_img` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `loadging_img` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fule_bill_image` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `admin_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `open_ptr_lat` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `open_ptr_long` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `close_ptr_lat` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `close_ptr_long` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `total_expence` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `ptr_farmer` -- CREATE TABLE `ptr_farmer` ( `ptr_did` int(11) NOT NULL, `ptr_fname` text DEFAULT NULL, `ptr_place` text DEFAULT NULL, `ptr_mob` text DEFAULT NULL, `ptr_crop` int(11) DEFAULT NULL, `ptr_ace` text DEFAULT NULL, `ptr_nf` text DEFAULT NULL, `ptr_fdate` varchar(200) DEFAULT NULL, `ptr_ftime` text DEFAULT NULL, `fk_dwr_id` int(11) DEFAULT NULL, `ptr_tdate` varchar(200) DEFAULT NULL, `ptr_r` text DEFAULT NULL, `ptr_fplace` int(11) DEFAULT NULL, `ptr_ftaluka` int(11) DEFAULT NULL, `ptr_fdis` int(11) DEFAULT NULL, `super_senior_verify_status` varchar(20) DEFAULT '0', `follow_status` int(11) DEFAULT 0, `senior_verify_status` varchar(20) NOT NULL DEFAULT '0', `product_used` text NOT NULL, `quentity_used` text NOT NULL, `stage` text NOT NULL, `scheme_name` varchar(200) NOT NULL, `target` varchar(200) NOT NULL, `acheivement` varchar(200) NOT NULL, `farmer_entry_date` date DEFAULT NULL, `farmer_entry_time` varchar(50) DEFAULT NULL, `ptr_flat` varchar(200) NOT NULL, `ptr_flong` varchar(200) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchase_order` -- CREATE TABLE `purchase_order` ( `po_id` int(11) NOT NULL, `fk_vt_id` int(11) DEFAULT NULL, `po_date` date DEFAULT NULL, `po_time` varchar(255) DEFAULT NULL, `fk_rmo_id` int(11) DEFAULT NULL, `po_recieve_date` date DEFAULT NULL, `po_recieve_emp_id` int(11) DEFAULT 0, `po_receive_status` int(11) DEFAULT 0, `po_vendor_invoice_no` varchar(200) DEFAULT NULL, `po_vendor_invoice_date` varchar(200) DEFAULT NULL, `po_transport_charges` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `po_insurance_charges` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `purchase_order_details` -- CREATE TABLE `purchase_order_details` ( `pod_id` int(11) NOT NULL, `fk_po_id` int(11) DEFAULT NULL, `fk_rm_id` int(11) DEFAULT NULL, `pod_qty` varchar(200) DEFAULT NULL, `pod_recieving_qty` varchar(200) DEFAULT NULL, `pod_rate` varchar(200) DEFAULT NULL, `pod_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `gst_per` varchar(200) DEFAULT '0', `final_total` varchar(200) DEFAULT NULL, `remark` varchar(255) NOT NULL, `image` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `raw_material` -- CREATE TABLE `raw_material` ( `rm_id` int(11) NOT NULL, `rm_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_cat_id` int(11) NOT NULL, `hsn_code` varchar(200) NOT NULL DEFAULT '31026000', `rm_unit` varchar(50) NOT NULL, `rm_desc` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `qty_limit` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `raw_material_order` -- CREATE TABLE `raw_material_order` ( `rmo_id` int(11) NOT NULL, `rmo_date` date NOT NULL, `rmo_time` varchar(255) NOT NULL, `rmo_status` int(11) NOT NULL DEFAULT 0, `rmo_pm_status` int(11) NOT NULL DEFAULT 0, `pur_status` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `raw_material_stock` -- CREATE TABLE `raw_material_stock` ( `rms_id` int(11) NOT NULL, `rms_date` date NOT NULL, `rms_time` varchar(200) NOT NULL, `rms_type` int(11) NOT NULL, `fk_finish_good_stock_id` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `raw_material_stock_details` -- CREATE TABLE `raw_material_stock_details` ( `rmsd_id` int(11) NOT NULL, `fk_rms_id` int(11) NOT NULL, `fk_rm_id` int(11) NOT NULL, `rmsd_qty` varchar(200) NOT NULL, `batch_code` varchar(255) NOT NULL, `entry_type` varchar(20) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `recieving_quotation_po` -- CREATE TABLE `recieving_quotation_po` ( `rqpo_id` int(11) NOT NULL, `fk_rmo_id` int(11) NOT NULL, `fk_rrpo_id` int(11) NOT NULL, `rqpo_rate` float NOT NULL, `fk_sqpo_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `report_verify_table` -- CREATE TABLE `report_verify_table` ( `report_verify_id` int(11) NOT NULL, `fk_dwr_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `report_verify_status` int(11) NOT NULL DEFAULT 0, `report_verify_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `report_verify_date` date NOT NULL, `map_to` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `rm_category` -- CREATE TABLE `rm_category` ( `cat_id` int(11) NOT NULL, `cat_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `salary_slips` -- CREATE TABLE `salary_slips` ( `id` int(11) NOT NULL, `employee_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `employee_number` varchar(50) DEFAULT NULL, `function` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `designation` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `location` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `bank_details` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `date_of_joining` date DEFAULT NULL, `tax_number` varchar(50) DEFAULT NULL, `uan` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `pf_account` varchar(50) DEFAULT NULL, `esi_number` varchar(50) DEFAULT NULL, `present_days` int(11) DEFAULT NULL, `basic_salary` decimal(10,2) DEFAULT NULL, `special_allowance` decimal(10,2) DEFAULT NULL, `conveyance_allowance` decimal(10,2) DEFAULT NULL, `medical_allowance` decimal(10,2) DEFAULT NULL, `education_allowance` decimal(10,2) DEFAULT NULL, `hra` decimal(10,2) DEFAULT NULL, `washing_allowance` decimal(10,2) DEFAULT NULL, `epf` decimal(10,2) DEFAULT NULL, `pt` decimal(10,2) DEFAULT NULL, `income_tax` decimal(10,2) DEFAULT NULL, `total_earnings` decimal(10,2) DEFAULT NULL, `total_deductions` decimal(10,2) DEFAULT NULL, `net_salary` decimal(10,2) DEFAULT NULL, `month` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `year` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `scheme` -- CREATE TABLE `scheme` ( `scheme_id` int(11) NOT NULL, `scheme_name` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `scheme_start_date` date NOT NULL, `scheme_end_date` date NOT NULL, `scheme_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `scheme_dealer_category` -- CREATE TABLE `scheme_dealer_category` ( `scheme_dealer_cat_id` int(11) NOT NULL, `fk_scheme_id` varchar(512) NOT NULL, `fk_dealer_cat_id` varchar(512) NOT NULL, `from_target` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `to_target` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `advance_amount` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `sending_quotation_po` -- CREATE TABLE `sending_quotation_po` ( `sqpo_id` int(11) NOT NULL, `fk_vt_id` int(11) NOT NULL, `fk_rmo_id` int(11) NOT NULL, `sqpo_recieving_status` int(11) NOT NULL DEFAULT 0, `sqpo_accepting_status` int(11) NOT NULL DEFAULT 0 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `state_table` -- CREATE TABLE `state_table` ( `st_id` int(11) NOT NULL, `st_name` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `gst_code` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `state_table` -- INSERT INTO `state_table` (`st_id`, `st_name`, `gst_code`) VALUES (1, 'Andaman and Nicobar Islands', '123'), (2, 'Andhra Pradesh', '123'), (3, 'Arunachal Pradesh', '123'), (4, 'Assam', '123'), (5, 'Bihar', '123'), (6, 'Goa', '123'), (7, 'Gujarat', '24'), (8, 'Haryana', '123'), (9, 'Himachal Pradesh', '123'), (10, 'Jammu and Kashmir', '123'), (11, 'Karnataka', '123'), (12, 'Madhya Pradesh', '23'), (13, 'Maharashtra', '27'), (14, 'Tamilnadu', '123'), (15, 'Uttar Pradesh', '123'), (19, 'Chhattisgarh', '22'), (20, 'Jharkhand', '20'), (21, 'Kerala', '32'), (22, 'Manipur', '14'), (23, 'Meghalaya', '17'), (24, 'Mizoram', '15'), (25, 'Nagaland', '13'), (26, 'Odisha', '21'), (27, 'Punjab', '3'), (28, 'Rajasthan', '8'), (29, 'Sikkim', '11'), (30, 'Telangana', '36'), (31, 'Tripura', '16'), (32, 'Uttarakhand', '5'), (33, 'West Bengal', '19'); -- -------------------------------------------------------- -- -- Table structure for table `taluka_table` -- CREATE TABLE `taluka_table` ( `tt_id` int(11) NOT NULL, `fk_dt_id` int(11) NOT NULL, `tt_taluka` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Dumping data for table `taluka_table` -- INSERT INTO `taluka_table` (`tt_id`, `fk_dt_id`, `tt_taluka`) VALUES (1, 1, 'SATANA'), (2, 1, 'CHANDVAD'), (3, 1, 'DEOLA'), (4, 1, 'DINDORI'), (5, 1, 'IGATPURI'), (6, 1, 'KALWAN'), (7, 1, 'MALEGAON'), (8, 1, 'NANDGAON'), (9, 1, 'NASHIK TAHSIL'), (10, 1, 'NIFAD'), (11, 1, 'PEINT'), (12, 1, 'SINNAR'), (13, 1, 'SURGANA'), (14, 1, 'TRIMBAKESHWAR'), (15, 1, 'YEVLA'), (16, 2, 'AMBEGAON'), (17, 2, 'BARAMATI'), (18, 2, 'BHOR'), (19, 2, 'DAUND'), (20, 2, 'HAVELI'), (21, 2, 'INDAPUR'), (22, 2, 'JUNNAR'), (23, 2, 'KHED'), (24, 2, 'MAWAL'), (25, 2, 'MULSHI'), (26, 2, 'PUNE CITY'), (27, 2, 'PURANDHAR'), (28, 2, 'SHIRUR'), (29, 2, 'VELHE'), (30, 3, 'AKOLA'), (31, 3, 'JAMKHED'), (32, 3, 'KARJAT'), (33, 3, 'KOPARGAON'), (34, 3, 'NAGAR'), (35, 3, 'NEVASA'), (36, 3, 'PARNER'), (37, 3, 'PATHARDI'), (38, 3, 'RAHTA'), (39, 3, 'RAHURI'), (40, 3, 'SANGAMNER'), (41, 3, 'SHEVGAON'), (42, 3, 'SHRIGONDA'), (43, 3, 'SHRIRAMPUR'), (44, 4, 'ATAPADI'), (45, 4, 'JAT'), (46, 4, 'KADEGAON'), (47, 4, 'KAVATHEMAHANKAL'), (48, 4, 'KHANAPUR'), (49, 4, 'MIRAJ'), (50, 4, 'PALUS'), (51, 4, 'SHIRALA'), (52, 4, 'TASGAON'), (53, 4, 'WALWA'), (54, 5, 'JAOLI'), (55, 5, 'KARAD'), (56, 5, 'KHANDALA'), (57, 5, 'KHATAV'), (58, 5, 'KOREGAON'), (59, 5, 'MAHABALESHWAR'), (60, 5, 'MAN'), (61, 5, 'PATAN'), (62, 5, 'PHALTAN'), (63, 5, 'SATARA'), (64, 5, 'WAI'), (65, 6, 'AKKALKOT'), (66, 6, 'BARSHI'), (67, 6, 'KARMALA'), (68, 6, 'MADHA'), (69, 6, 'MALSHIRAS'), (70, 6, 'MANGALVEDHE'), (71, 6, 'MOHOL'), (72, 6, 'PANDHARPUR'), (73, 6, 'SANGOLE'), (74, 6, 'SOLAPUR NORTH'), (75, 6, 'SOLAPUR SOUTH'), (76, 7, 'AMBARNATH'), (77, 7, 'BHIWANDI'), (78, 7, 'DAHANU'), (79, 7, 'JAWHAR'), (80, 7, 'KALYAN'), (81, 7, 'MOKHADA'), (82, 7, 'MURBAD'), (83, 7, 'PALGHAR'), (84, 7, 'SHAHAPUR'), (85, 7, 'TALASARI'), (86, 7, 'THANE'), (87, 7, 'ULHASNAGAR'), (88, 7, 'VADA'), (89, 7, 'VASAI'), (90, 7, 'VIKRAMGAD'), (91, 8, 'PALGHAR'), (92, 9, 'CHIPLUN'), (93, 9, 'DAPOLI'), (94, 9, 'GUHAGAR'), (95, 9, 'KHED'), (96, 9, 'LANJA'), (97, 9, 'MANDANGAD'), (98, 9, 'RAJAPUR'), (99, 9, 'RATNAGIRI'), (100, 9, 'SANGAMESHWAR'), (101, 10, 'DEVGAD'), (102, 10, 'DODAMARG'), (103, 10, 'KANKAVLI'), (104, 10, 'KUDAL'), (105, 10, 'MALWAN'), (106, 10, 'SAWANTWADI'), (107, 10, 'VAIBHAVVADI'), (108, 10, 'VENGURLA'), (109, 11, 'AJRA'), (110, 11, 'BAVDA'), (111, 11, 'BHUDARGAD'), (112, 11, 'CHANDGAD'), (113, 11, 'GADHINGLAJ'), (114, 11, 'HATKANANGLE'), (115, 11, 'KAGAL'), (116, 11, 'KARVIR'), (117, 11, 'PANHALA'), (118, 11, 'RADHANAGARI'), (119, 11, 'SHAHUWADI'), (120, 11, 'SHIROL'), (121, 12, 'AURANGABAD'), (122, 12, 'GANGAPUR'), (123, 12, 'KANNAD'), (124, 12, 'KHULDABAD'), (125, 12, 'PAITHAN'), (126, 12, 'PHULAMBRI'), (127, 12, 'SILLOD'), (128, 12, 'SOEGAON'), (129, 12, 'VAIJAPUR'), (130, 13, 'DHULE'), (131, 13, 'SAKRI'), (132, 13, 'SHIRPUR'), (133, 13, 'SINDHKHEDE'), (134, 14, 'AMALNER'), (135, 14, 'BHADGAON'), (136, 14, 'BHUSAWAL'), (137, 14, 'BODVAD'), (138, 14, 'CHALISGAON'), (139, 14, 'CHOPDA'), (140, 14, 'DHARANGAON'), (141, 14, 'ERANDOL'), (142, 14, 'JALGAON'), (143, 14, 'JAMNER'), (144, 14, 'MUKTAINAGAR ( EDLABAD)'), (145, 14, 'PACHORA'), (146, 14, 'PAROLA'), (147, 14, 'RAVER'), (148, 14, 'YAWAL'), (149, 15, 'AKKALKUWA'), (150, 15, 'AKRANI'), (151, 15, 'NANDURBAR'), (152, 15, 'NAWAPUR'), (153, 15, 'SHAHADE'), (154, 15, 'TALODE'), (155, 16, 'AKOLA'), (156, 16, 'AKOT'), (157, 16, 'BALAPUR'), (158, 16, 'BARSHITAKLI '), (159, 16, 'MURTIJAPUR'), (160, 16, 'PATUR'), (161, 16, 'TELHARA'), (162, 17, 'ACHALPUR'), (163, 17, 'AMRAVATI'), (164, 17, 'ANJANGAON SURJI'), (165, 17, 'BHATKULI'), (166, 17, 'CHANDUR RAILWAY'), (167, 17, 'CHANDURBAZAR'), (168, 17, 'CHIKHALDARA '), (169, 17, 'DARYAPUR'), (170, 17, 'DHAMANGAON RAILWAY'), (171, 17, 'DHARNI'), (172, 17, 'MORSHI'), (173, 17, 'NANDGAON-KHANDESHWAR'), (174, 17, 'TEOSA'), (175, 17, 'WARUD'), (176, 18, 'BULDHANA'), (177, 18, 'CHIKHLI'), (178, 18, 'DEOLGAON RAJA '), (179, 18, 'JALGAON ( JAMOD)'), (180, 18, 'KHAMGAON'), (181, 18, 'LONAR'), (182, 18, 'MALKAPUR'), (183, 18, 'MEHKAR'), (184, 18, 'MOTALA'), (185, 18, 'NANDURA'), (186, 18, 'SANGRAMPUR '), (187, 18, 'SHEGAON'), (188, 18, 'SINDHKHED RAJA'), (189, 19, 'ARNI'), (190, 19, 'BABULGAON'), (191, 19, 'DARWHA'), (192, 19, 'DIGRAS'), (193, 19, 'GHATANJI '), (194, 19, 'KALAMB'), (195, 19, 'KELAPUR'), (196, 19, 'MAHAGAON'), (197, 19, 'MAREGAON'), (198, 19, 'NER'), (199, 19, 'PUSAD'), (200, 19, 'RALEGAON'), (201, 19, 'UMARKHED'), (202, 19, 'WANI'), (203, 19, 'YAVATMAL'), (204, 19, 'ZARI-JAMANI '), (205, 20, 'KARANJA '), (206, 20, 'MALEGAON'), (207, 20, 'MANGRULPIR'), (208, 20, 'MANORA'), (209, 20, 'RISOD'), (210, 20, 'WASHIM'), (211, 21, 'AUNDHA (NAGNATH)'), (212, 21, 'BASMATH'), (213, 21, 'HINGOLI'), (214, 21, 'KALAMNURI'), (215, 21, 'SENGAON'), (216, 22, 'AMBAD'), (217, 22, 'BADNAPUR'), (218, 22, 'BHOKARDAN'), (219, 22, 'GHANSAWANGI'), (220, 22, 'JAFFERABAD'), (221, 22, 'JALNA'), (222, 22, 'MANTHA'), (223, 22, 'PARTUR'), (224, 23, 'AHAMADPUR'), (225, 23, 'AUSA'), (226, 23, 'CHAKUR'), (227, 23, 'DEONI'), (228, 23, 'JALKOT'), (229, 23, 'LATUR'), (230, 23, 'NILANGA'), (231, 23, 'RENAPUR'), (232, 23, 'SHIRUR-ANANTPAL '), (233, 23, 'UDGIR'), (234, 24, 'ARDHAPUR'), (235, 24, 'BHOKAR'), (236, 24, 'BILOLI'), (237, 24, 'DEGLUR'), (238, 24, 'DHARMABAD'), (239, 24, 'HADGAON'), (240, 24, 'HIMAYATNAGAR'), (241, 24, 'KANDHAR'), (242, 24, 'KINWAT'), (243, 24, 'LOHA'), (244, 24, 'MAHOOR'), (245, 24, 'MUDKHED'), (246, 24, 'MUKHED'), (247, 24, 'NAIGAON ( KHAIRGAON)'), (248, 24, 'NANDED'), (249, 24, 'UMRI'), (250, 25, 'BHUM'), (251, 25, 'KALAMB'), (252, 25, 'LOHARA'), (253, 25, 'OSMANABAD'), (254, 25, 'PARANDA'), (255, 25, 'TULJAPUR'), (256, 25, 'UMARGA'), (257, 25, 'WASHI'), (258, 26, 'GANGAKHED'), (259, 26, 'JINTUR'), (260, 26, 'MANWATH'), (261, 26, 'PALAM'), (262, 26, 'PARBHANI'), (263, 26, 'PATHRI'), (264, 26, 'PURNA'), (265, 26, 'SAILU'), (266, 26, 'SONPETH'), (267, 27, 'BALLARPUR'), (268, 27, 'BHADRAVATI'), (269, 27, 'BRAHMAPURI'), (270, 27, 'CHANDRAPUR'), (271, 27, 'CHIMUR'), (272, 27, 'GONDPIPRI'), (273, 27, 'JIWATI'), (274, 27, 'KORPANA'), (275, 27, 'MUL'), (276, 27, 'NAGBHIR'), (277, 27, 'POMBHURNA'), (278, 27, 'RAJURA'), (279, 27, 'SAWALI'), (280, 27, 'SINDEWAHI'), (281, 27, 'WARORA'), (282, 28, 'AHERI'), (283, 28, 'ARMORI'), (284, 28, 'BHAMRAGAD'), (285, 28, 'CHAMORSHI'), (286, 28, 'DESAIGANJ( VADASA)'), (287, 28, 'DHANORA'), (288, 28, 'ETAPALLI'), (289, 28, 'GADCHIROLI '), (290, 28, 'KORCHI'), (291, 28, 'KURKHEDA'), (292, 28, 'MULCHERA'), (293, 28, 'SIRONCHA'), (294, 29, 'AMGAON'), (295, 29, 'ARJUNI MORGAON'), (296, 29, 'DEORI'), (297, 29, 'GONDIYA'), (298, 29, 'GOREGAON'), (299, 29, 'SADAK-ARJUNI '), (300, 29, 'SALEKASA'), (301, 29, 'TIRORA'), (302, 30, 'BHIWAPUR'), (303, 30, 'HINGNA'), (304, 30, 'KALAMESHWAR'), (305, 30, 'KAMPTEE'), (306, 30, 'KATOL'), (307, 30, 'KUHI'), (308, 30, 'MAUDA'), (309, 30, 'NAGPUR ( RURAL)'), (310, 30, 'NAGPUR ( URBAN)'), (311, 30, 'NARKHED'), (312, 30, 'PARSEONI'), (313, 30, 'RAMTEK'), (314, 30, 'SAVNER'), (315, 30, 'UMRED'), (316, 31, 'ARVI'), (317, 31, 'ASHTI'), (318, 31, 'DEOLI'), (319, 31, 'HINGANGHAT'), (320, 31, 'KARANJA'), (321, 31, 'SAMUDRAPUR'), (322, 31, 'SELOO'), (323, 31, 'WARDHA'), (324, 32, 'ASHTI'), (325, 32, 'BEED CITY'), (326, 32, 'DHARUR'), (327, 32, 'GEORAI'), (328, 32, 'KAIJ'), (329, 32, 'MAJALGAON'), (330, 32, 'PARALI V'), (331, 32, 'PATODA'), (332, 32, 'SHIRUR'), (333, 33, 'KARJAT'), (334, 33, 'KHALAPUR'), (335, 33, 'MAHAD'), (336, 33, 'MANGAON'), (337, 33, 'MHASALA'), (338, 33, 'MURUD'), (339, 33, 'PANVEL'), (340, 33, 'PEN'), (341, 33, 'POLADPUR'), (342, 33, 'ROHA'), (343, 33, 'SHRIVARDHAN'), (344, 33, 'SUDHAGAD'), (345, 33, 'TALA'), (346, 33, 'URAN'), (347, 34, 'BHANDARA'), (348, 34, 'LAKHANDUR '), (349, 34, 'LAKHANI'), (350, 34, 'MOHADI'), (351, 34, 'PAUNI'), (352, 34, 'SAKOLI'), (353, 34, 'TUMSAR'), (354, 35, 'Anjad'), (355, 35, 'Barwani '), (356, 35, 'Niwali'), (357, 35, 'Pansemal '), (358, 35, 'Pati '), (359, 35, 'Rajpur '), (360, 35, 'Sendhwa'), (361, 35, 'Thikri'), (362, 35, 'Varla '), (363, 36, 'Berasia'), (364, 36, 'Huzur '), (365, 37, 'Burhanpur '), (366, 37, 'Khaknar'), (367, 37, 'Nepanagar'), (368, 38, 'Badnawar'), (369, 38, 'Dahi'), (370, 38, 'Dhar'), (371, 38, 'Dharampuri '), (372, 38, 'Gandhwani'), (373, 38, 'Kukshi '), (374, 38, 'Manawar '), (375, 38, 'Sardarpur'), (376, 39, 'Babai'), (377, 39, 'Bankhedi'), (378, 39, 'Dolariya '), (379, 39, 'Hoshangabad '), (380, 39, 'Itarsi '), (381, 39, 'Pipariya'), (382, 39, 'Seoni-Malwa'), (383, 39, 'Sohagpur '), (384, 40, 'Bhanpura '), (385, 40, 'Daloda'), (386, 40, 'Garoth '), (387, 40, 'Malhargarh'), (388, 40, 'Mandsaur '), (389, 40, 'Shamgarh '), (390, 40, 'Sitamau '), (391, 40, 'Suwasara'), (392, 41, 'Jawad'), (393, 41, 'Jiran'), (394, 41, 'Manasa '), (395, 41, 'Neemuch'), (396, 41, 'Singoli'), (397, 42, 'Badi'), (398, 42, 'Baraily'), (399, 42, 'Begamganj?'), (400, 42, 'Gairatganj?'), (401, 42, 'Goharganj'), (402, 42, 'Raisen'), (403, 42, 'Silwani'), (404, 42, 'Udaipura'), (405, 43, 'Biaora'), (406, 43, 'Jirapur '), (407, 43, 'Khilchipur'), (408, 43, 'Narsinghgarh'), (409, 43, 'Pachore'), (410, 43, 'Rajgarh'), (411, 43, 'Sarangpur '), (412, 44, 'Alot'), (413, 44, 'Bajna'), (414, 44, 'Jaora '), (415, 44, 'Piploda'), (416, 44, 'Ratlam'), (417, 44, 'Rawti'), (418, 44, 'Sailana'), (419, 44, 'Tal '), (420, 45, '?Ashta'), (421, 45, 'Budni'), (422, 45, ' Ichhawar?'), (423, 45, 'Jawar'), (424, 45, '?Nasrullaganj'), (425, 45, 'Rehti'), (426, 45, 'Sehore'), (427, 45, 'Shyampur'), (428, 46, '?Agar'), (429, 46, 'Badod'), (430, 46, '?Gulana'), (431, 46, 'Kalapipal?'), (432, 46, 'Moman Badodiya'), (433, 46, 'Nalkheda'), (434, 46, 'Shajapur'), (435, 46, '?Shujalpur'), (436, 46, 'Susner'), (437, 47, 'Badnagar'), (438, 47, 'Ghatiya'), (439, 47, 'Khacharod'), (440, 47, 'Mahidpur'), (441, 47, 'Nagda?'), (442, 47, 'Tarana'), (443, 47, '?Ujjain'), (444, 48, 'Harsud '), (445, 48, 'Khalwa'), (446, 48, 'Khandwa'), (447, 48, 'Pandhana '), (448, 48, 'Punasa '), (449, 49, 'Barwaha?'), (450, 49, 'Bhagwanpura'), (451, 49, 'Bhikangaon'), (452, 49, 'Gogaon?'), (453, 49, '?Jhiranya'), (454, 49, 'Kasrawad'), (455, 49, '?Khargon'), (456, 49, '?Maheshwar'), (457, 49, 'Segaon'), (458, 50, 'Dediapada'), (459, 50, 'Nandod'), (460, 50, '?Sagbara'), (461, 50, 'Tilakwada?'), (462, 51, '?Nizar'), (463, 51, 'Songadh'), (464, 51, '?Uchchhal'), (465, 51, 'Valod'), (466, 51, 'Vyara'), (467, 52, 'Chhota Udaipur'), (468, 52, 'Dabhoi'), (469, 52, 'Jetpur Pavi'), (470, 52, '?Karjan'), (471, 52, 'Kavant?'), (472, 52, 'Nasvadi'), (473, 52, 'Padra'), (474, 52, 'Sankheda'), (475, 52, 'Savli'), (476, 52, 'Sinor'), (477, 52, 'Vadodara?'), (478, 52, 'Vaghodia?'), (479, 53, 'Bagepalli'), (480, 53, '?Chikkaballapura'), (481, 53, '?Chintamani'), (482, 53, 'Gauribidanur?'), (483, 53, 'Gudibanda'), (484, 53, 'Sidlaghatta'), (485, 54, 'Bangarapet'), (486, 54, '?Kolar'), (487, 54, 'Malur'), (488, 54, 'Mulbagal'), (489, 54, '?Srinivaspur'), (490, 55, '?Heggadadevankote'), (491, 55, 'Hunsur'), (492, 55, 'Krishnarajanagara'), (493, 55, 'Mysore'), (494, 55, 'Nanjangud'), (495, 55, '?Piriyapatna'), (496, 55, 'Tirumakudal - Narsipur'), (497, 56, 'Chiknayakanhalli'), (498, 56, 'Gubbi?'), (499, 56, 'Koratagere'), (500, 56, 'Kunigal'), (501, 56, '?Madhugiri'), (502, 56, 'Pavagada'), (503, 56, 'Sira'), (504, 56, '?Tiptur'), (505, 56, 'Tumkur'), (506, 56, 'Turuvekere'), (507, 57, '?Devanahalli'), (508, 57, 'Dod Ballapur'), (509, 57, '?Hosakote'), (510, 57, 'Nelamangala'), (511, 58, 'Challakere?'), (512, 58, 'Chitradurga'), (513, 58, 'Hiriyur?'), (514, 58, 'Holalkere'), (515, 58, 'Hosdurga'), (516, 58, 'Molakalmuru'), (517, 59, 'Bhadravati'), (518, 59, 'Hosanagara'), (519, 59, '?Sagar'), (520, 59, '?Shikarpur'), (521, 59, 'Shimoga'), (522, 59, 'Sorab'), (523, 59, '?Tirthahalli'), (524, 60, 'Denkanikottai?'), (525, 60, 'Hosur'), (526, 60, 'Krishnagiri'), (527, 60, '?Pochampalli?'), (528, 60, 'Uthangarai'), (529, 61, 'Amla'), (530, 61, 'Athner'), (531, 61, 'Betul'), (532, 61, 'Bhainsdehi'), (533, 61, 'Chicholi'), (534, 61, 'Ghoda Dongri'), (535, 61, 'Multai'), (536, 61, 'Shahpur'), (537, 61, 'Jhabua'), (538, 61, 'Meghnagar'), (539, 61, 'Petlawad'), (540, 61, 'Ranapur'), (541, 61, 'Thandla'), (542, 61, 'Depalpur'), (543, 61, 'Hatod'), (544, 61, 'Indore'), (545, 61, 'Mhow'), (546, 61, 'Sawer'), (547, 61, 'Bardoli'), (548, 61, 'Chorasi'), (549, 61, 'Kamrej'), (550, 61, 'Mahuva'), (551, 61, 'Mandvi'), (552, 61, 'Mangrol'), (553, 61, 'Olpad'), (554, 61, 'Palsana'), (555, 61, 'Umarpada'), (556, 61, 'Amod'), (557, 61, 'Anklesvar'), (558, 61, 'Bharuch'), (559, 61, 'Hansot'), (560, 61, 'Jambusar'), (561, 61, 'Jhagadia'), (562, 61, 'Vagra'), (563, 61, 'Valia'), (564, 61, 'Anand'), (565, 61, 'Anklav'), (566, 61, 'Borsad'), (567, 61, 'Khambhat'), (568, 61, 'Petlad'), (569, 61, 'Sojitra'), (570, 61, 'Tarapur'), (571, 61, 'Umreth'), (572, 61, 'Balasinor'), (573, 61, 'Kapadvanj'), (574, 61, 'Kathlal'), (575, 61, 'Kheda'), (576, 61, 'Mahudha'), (577, 61, 'Matar'), (578, 61, 'Mehmedabad'), (579, 61, 'Nadiad'), (580, 61, 'Thasra'), (581, 61, 'Virpur'), (582, 61, 'Ahmadabad City'), (583, 61, 'Barwala'), (584, 61, 'Bavla'), (585, 61, 'Daskroi'), (586, 61, 'Detroj-Rampura'), (587, 61, 'Dhandhuka'), (588, 61, 'Dholka'), (589, 61, 'Mandal'), (590, 61, 'Ranpur'), (591, 61, 'Sanand'), (592, 61, 'Viramgam'), (593, 75, 'Durgi'), (594, 75, 'Vatti Cherukuru'), (595, 75, 'Pratipadu'), (596, 75, 'Guntur Rural'), (597, 77, 'Athani'), (598, 77, 'Bailhongal'), (599, 77, 'Belagavi'), (600, 77, 'Chikkodi'), (601, 77, 'Gokak'), (602, 77, 'Hukkeri'), (603, 77, 'Khanapur'), (604, 77, 'Ramdurg'), (605, 77, 'Raibhag '), (606, 77, 'Saundatti'); -- -------------------------------------------------------- -- -- Table structure for table `tbl_customer_visited` -- CREATE TABLE `tbl_customer_visited` ( `cust_visited_id` int(11) NOT NULL, `fk_cust_id` int(11) NOT NULL, `fk_dwr_id` int(11) NOT NULL, `cust_visited_perpose` varchar(200) NOT NULL, `cust_visited_lat` varchar(200) NOT NULL, `cust_visited_long` varchar(200) NOT NULL, `cust_visited_date` date NOT NULL, `cust_followup_date` date NOT NULL, `cust_visited_time` time NOT NULL, `cust_visited_remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `cust_visit_img` varchar(200) NOT NULL, `cust_visited_is_delete` varchar(200) NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_farmer_visited` -- CREATE TABLE `tbl_farmer_visited` ( `farm_visited_id` int(11) NOT NULL, `fk_farm_id` int(11) NOT NULL, `fk_dwr_id` int(11) NOT NULL, `fk_crop_id` int(11) NOT NULL, `farm_visited_no_of_acers` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_crop_id2` int(11) NOT NULL, `farm_visited_no_of_acers2` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_crop_id3` int(11) NOT NULL, `farm_visited_no_of_acers3` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `farm_visited_lat` varchar(200) NOT NULL, `farm_visited_long` varchar(200) NOT NULL, `farm_visited_date` date NOT NULL, `farm_visited_purpose` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `farm_visited_time` time NOT NULL, `farm_visited_img` varchar(200) NOT NULL, `farm_visited_remark` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `farm_visited_followup_date` date NOT NULL, `farm_visited_delete` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_financial_year` -- CREATE TABLE `tbl_financial_year` ( `fin_year_id` int(11) NOT NULL, `from_date` date DEFAULT NULL, `to_date` date DEFAULT NULL, `financial_year` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_mas_farmer` -- CREATE TABLE `tbl_mas_farmer` ( `farm_id` int(11) NOT NULL, `farm_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `farm_mob` varchar(200) NOT NULL, `fk_state_id` varchar(255) NOT NULL, `fk_district_id` varchar(255) NOT NULL, `fk_taluka_id` varchar(255) NOT NULL, `farm_address` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `farm_start_lat` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `farm_start_long` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `farm_reg_date` date NOT NULL, `farm_img` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_et_id` int(11) NOT NULL, `farm_is_delete` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '0', `farm_status` int(11) NOT NULL COMMENT '0 for pending 1 for verify' ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_region` -- CREATE TABLE `tbl_region` ( `id` int(11) NOT NULL, `region_name` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_region_product_rate` -- CREATE TABLE `tbl_region_product_rate` ( `id` int(11) NOT NULL, `fk_region_id` int(11) NOT NULL, `fk_product_d_id` int(11) NOT NULL, `price` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_salary_parameter` -- CREATE TABLE `tbl_salary_parameter` ( `id` int(11) NOT NULL, `basic_pay` decimal(10,2) NOT NULL, `house_rent_allowance` decimal(10,2) DEFAULT 0.00, `dearness_allowance` decimal(10,2) DEFAULT 0.00, `medical_allowance` decimal(10,2) DEFAULT 0.00, `travel_allowance` decimal(10,2) DEFAULT 0.00, `other_allowance` decimal(10,2) DEFAULT 0.00, `provident_fund` decimal(10,2) DEFAULT 0.00, `professional_tax` decimal(10,2) DEFAULT 0.00, `gross_salary` decimal(10,2) GENERATED ALWAYS AS (`basic_pay` + `house_rent_allowance` + `dearness_allowance` + `medical_allowance` + `travel_allowance` + `other_allowance`) STORED, `net_salary` decimal(10,2) GENERATED ALWAYS AS (`gross_salary` - `provident_fund` - `professional_tax`) STORED, `created_at` timestamp NULL DEFAULT current_timestamp(), `updated_at` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `tbl_ship_to_address` -- CREATE TABLE `tbl_ship_to_address` ( `ship_to_id` int(11) NOT NULL, `ship_to_addres` text NOT NULL, `comp_name` varchar(30) NOT NULL, `SAP_id` int(11) NOT NULL, `fk_cust_id` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `tokens` -- CREATE TABLE `tokens` ( `id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `created_at` datetime NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- -------------------------------------------------------- -- -- Table structure for table `transfer_order_product` -- CREATE TABLE `transfer_order_product` ( `ord_pro_id` int(11) NOT NULL, `fk_ord_id` int(11) NOT NULL, `product_id` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `product_qty` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `product_rate` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `op_status` int(11) NOT NULL DEFAULT 1, `ord_gst` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `no_ofunit_in_a_case` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `transfer_order_table` -- CREATE TABLE `transfer_order_table` ( `ord_id` int(11) NOT NULL, `cust_id` int(11) NOT NULL, `ord_date` date NOT NULL, `ord_status` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'no', `ord_emp_staus` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `vat` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `discount` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `et_id` int(11) NOT NULL, `ot_who` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `fk_dg_id` int(11) NOT NULL, `ord_remark` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `deliver_to` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `dispatach_by` text CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `ord_ref_id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ord_time` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `tname` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `tvalue` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `trans_from_order` int(11) NOT NULL, `tras_ref_order_id` int(11) NOT NULL, `ord_admin_verify_status` int(11) NOT NULL DEFAULT 0, `comp_id` int(11) NOT NULL, `ord_bill_image` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ord_ref_from` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `am_status` int(11) NOT NULL DEFAULT 0, `gm_status` int(11) NOT NULL DEFAULT 0, `ord_type` int(11) NOT NULL DEFAULT 1 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `unit_master` -- CREATE TABLE `unit_master` ( `unit_id` int(11) NOT NULL, `unit_name` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `user_current_location` -- CREATE TABLE `user_current_location` ( `ul_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `ul_lat` text NOT NULL, `ul_lang` text NOT NULL, `ul_bl` text NOT NULL, `ul_date` date NOT NULL, `ul_time` datetime DEFAULT NULL, `fk_cust_farm_visited_id` int(11) NOT NULL DEFAULT 0, `visited_type` varchar(200) NOT NULL, `location_off_type` varchar(255) NOT NULL, `username` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -------------------------------------------------------- -- -- Table structure for table `verify_transfer_order_table` -- CREATE TABLE `verify_transfer_order_table` ( `verify_transfer_order_id` int(11) NOT NULL, `fk_ord_id` int(11) NOT NULL, `fk_et_id` int(11) NOT NULL, `verify_transfer_order_status` int(11) NOT NULL DEFAULT 0, `verify_transfer_order_date` date NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `acc_master_tbl` -- ALTER TABLE `acc_master_tbl` ADD PRIMARY KEY (`acc_master_id`), ADD KEY `fk_year_id` (`fk_year_id`), ADD KEY `fk_activity_id` (`fk_activity_id`), ADD KEY `fk_user_id` (`fk_user_id`); -- -- Indexes for table `admin_login` -- ALTER TABLE `admin_login` ADD PRIMARY KEY (`al_id`); -- -- Indexes for table `bank_table` -- ALTER TABLE `bank_table` ADD PRIMARY KEY (`bt_id`); -- -- Indexes for table `bom_details_table` -- ALTER TABLE `bom_details_table` ADD PRIMARY KEY (`bom_details_id`), ADD KEY `fk_bom_id` (`fk_bom_id`), ADD KEY `fk_raw_id` (`fk_raw_id`); -- -- Indexes for table `bom_table` -- ALTER TABLE `bom_table` ADD PRIMARY KEY (`bom_id`), ADD KEY `fk_product_id` (`fk_product_id`), ADD KEY `login_id` (`login_id`); -- -- Indexes for table `company_alert` -- ALTER TABLE `company_alert` ADD PRIMARY KEY (`ca_id`); -- -- Indexes for table `company_alert_detail` -- ALTER TABLE `company_alert_detail` ADD PRIMARY KEY (`alert_check_id`), ADD KEY `fk_et_id` (`fk_et_id`), ADD KEY `fk_alert_id` (`fk_alert_id`); -- -- Indexes for table `company_details` -- ALTER TABLE `company_details` ADD PRIMARY KEY (`comp_id`), ADD KEY `comp_phone_no` (`comp_phone_no`) USING BTREE, ADD KEY `fk_state_id` (`fk_state_id`); -- -- Indexes for table `company_table` -- ALTER TABLE `company_table` ADD PRIMARY KEY (`comp_id`); -- -- Indexes for table `comp_bank_table` -- ALTER TABLE `comp_bank_table` ADD PRIMARY KEY (`cbt_id`); -- -- Indexes for table `crop` -- ALTER TABLE `crop` ADD PRIMARY KEY (`crop_id`); -- -- Indexes for table `customer` -- ALTER TABLE `customer` ADD PRIMARY KEY (`cust_id`); -- -- Indexes for table `dealer_credit_note` -- ALTER TABLE `dealer_credit_note` ADD PRIMARY KEY (`cn_id`); -- -- Indexes for table `dealer_stock_table` -- ALTER TABLE `dealer_stock_table` ADD PRIMARY KEY (`dst_id`), ADD KEY `fk_cust_id` (`fk_cust_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `dealer_stock_table_details` -- ALTER TABLE `dealer_stock_table_details` ADD PRIMARY KEY (`dstd_id`), ADD KEY `fk_dst_id` (`fk_dst_id`), ADD KEY `fk_product_id` (`fk_product_id`); -- -- Indexes for table `demo_customer_for_testing` -- ALTER TABLE `demo_customer_for_testing` ADD PRIMARY KEY (`id`); -- -- Indexes for table `department` -- ALTER TABLE `department` ADD PRIMARY KEY (`dept_id`); -- -- Indexes for table `designation` -- ALTER TABLE `designation` ADD PRIMARY KEY (`desig_id`); -- -- Indexes for table `designation_table` -- ALTER TABLE `designation_table` ADD PRIMARY KEY (`dt_id`); -- -- Indexes for table `dispatch_godown` -- ALTER TABLE `dispatch_godown` ADD PRIMARY KEY (`dg_id`); -- -- Indexes for table `district_table` -- ALTER TABLE `district_table` ADD PRIMARY KEY (`dt_id`); -- -- Indexes for table `dwr_table` -- ALTER TABLE `dwr_table` ADD PRIMARY KEY (`dwr_id`); -- -- Indexes for table `employee_adv_payment` -- ALTER TABLE `employee_adv_payment` ADD PRIMARY KEY (`emp_adv_id`); -- -- Indexes for table `employee_hierarchy` -- ALTER TABLE `employee_hierarchy` ADD PRIMARY KEY (`eh_id`), ADD KEY `fk_et_id` (`fk_et_id`), ADD KEY `map_to` (`map_to`); -- -- Indexes for table `employee_salary_table` -- ALTER TABLE `employee_salary_table` ADD PRIMARY KEY (`emp_adv_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `employee_table` -- ALTER TABLE `employee_table` ADD PRIMARY KEY (`et_id`), ADD KEY `fk_st_id` (`fk_st_id`), ADD KEY `fk_dt_id` (`fk_dt_id`), ADD KEY `city_id` (`city_id`), ADD KEY `emp_company_id` (`emp_company_id`), ADD KEY `fk_dg_id` (`fk_dg_id`); -- -- Indexes for table `employee_tour_route` -- ALTER TABLE `employee_tour_route` ADD PRIMARY KEY (`etr_id`); -- -- Indexes for table `emp_attendance` -- ALTER TABLE `emp_attendance` ADD PRIMARY KEY (`attendance_id`), ADD KEY `fk_emp_id` (`fk_emp_id`); -- -- Indexes for table `emp_state_maping` -- ALTER TABLE `emp_state_maping` ADD PRIMARY KEY (`esm_id`), ADD KEY `fk_et_id` (`fk_et_id`), ADD KEY `fk_st_id` (`fk_st_id`); -- -- Indexes for table `emp_target` -- ALTER TABLE `emp_target` ADD PRIMARY KEY (`emp_trg_id`); -- -- Indexes for table `expenses` -- ALTER TABLE `expenses` ADD PRIMARY KEY (`exp_id`); -- -- Indexes for table `factory_order` -- ALTER TABLE `factory_order` ADD PRIMARY KEY (`fo_id`), ADD KEY `fo_status` (`fo_status`), ADD KEY `fk_gd_id` (`fk_gd_id`), ADD KEY `year_id` (`year_id`), ADD KEY `godown_tranfer_id` (`godown_tranfer_id`); -- -- Indexes for table `factory_order_data` -- ALTER TABLE `factory_order_data` ADD PRIMARY KEY (`fod_id`), ADD KEY `fk_fo_id` (`fk_fo_id`), ADD KEY `product_id` (`product_id`), ADD KEY `packing_id` (`packing_id`); -- -- Indexes for table `farmer_meeting` -- ALTER TABLE `farmer_meeting` ADD PRIMARY KEY (`fm_id`); -- -- Indexes for table `farmer_meeting_details` -- ALTER TABLE `farmer_meeting_details` ADD PRIMARY KEY (`fmd_id`); -- -- Indexes for table `financial_year` -- ALTER TABLE `financial_year` ADD PRIMARY KEY (`id`); -- -- Indexes for table `finish_product_damage_stock` -- ALTER TABLE `finish_product_damage_stock` ADD PRIMARY KEY (`fps_id`), ADD KEY `fk_dg_id` (`fk_dg_id`); -- -- Indexes for table `finish_product_damage_stock_details` -- ALTER TABLE `finish_product_damage_stock_details` ADD PRIMARY KEY (`fpsd_id`), ADD KEY `fk_fps_id` (`fk_fps_id`), ADD KEY `fk_packing_id` (`fk_packing_id`); -- -- Indexes for table `finish_product_stock` -- ALTER TABLE `finish_product_stock` ADD PRIMARY KEY (`fps_id`), ADD KEY `fk_dg_id` (`fk_dg_id`), ADD KEY `year_id` (`year_id`); -- -- Indexes for table `finish_product_stock_details` -- ALTER TABLE `finish_product_stock_details` ADD PRIMARY KEY (`fpsd_id`), ADD KEY `fk_fps_id` (`fk_fps_id`), ADD KEY `fk_year_id` (`fk_year_id`), ADD KEY `fk_packing_id` (`fk_packing_id`); -- -- Indexes for table `godown_to_godown_transfer_order` -- ALTER TABLE `godown_to_godown_transfer_order` ADD PRIMARY KEY (`godown_transfer_id`), ADD KEY `from_godown_id` (`from_godown_id`), ADD KEY `to_godown_id` (`to_godown_id`); -- -- Indexes for table `group_table` -- ALTER TABLE `group_table` ADD PRIMARY KEY (`gt_id`); -- -- Indexes for table `holiday` -- ALTER TABLE `holiday` ADD PRIMARY KEY (`holi_id`); -- -- Indexes for table `holiday_details` -- ALTER TABLE `holiday_details` ADD PRIMARY KEY (`holi_id`), ADD KEY `fk_et_id` (`fk_state_id`), ADD KEY `fk_hl_id` (`fk_hl_id`); -- -- Indexes for table `holiday_master` -- ALTER TABLE `holiday_master` ADD PRIMARY KEY (`hl_id`); -- -- Indexes for table `invoice_table` -- ALTER TABLE `invoice_table` ADD PRIMARY KEY (`inv_id`), ADD KEY `fk_order_id` (`fk_ord_id`); -- -- Indexes for table `item_master` -- ALTER TABLE `item_master` ADD PRIMARY KEY (`sr_no`), ADD KEY `item_code` (`item_code`); -- -- Indexes for table `language_list` -- ALTER TABLE `language_list` ADD PRIMARY KEY (`lang_id`); -- -- Indexes for table `leave` -- ALTER TABLE `leave` ADD PRIMARY KEY (`lv_id`); -- -- Indexes for table `leave_table` -- ALTER TABLE `leave_table` ADD PRIMARY KEY (`lt_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `leave_verify_table` -- ALTER TABLE `leave_verify_table` ADD PRIMARY KEY (`report_verify_id`), ADD KEY `fk_dwr_id` (`fk_dwr_id`), ADD KEY `fk_et_id` (`fk_et_id`), ADD KEY `map_to` (`map_to`); -- -- Indexes for table `leave_verify_tableold` -- ALTER TABLE `leave_verify_tableold` ADD PRIMARY KEY (`lvt_id`), ADD KEY `fk_leave_id` (`fk_leave_id`), ADD KEY `ek_et_id` (`fk_et_id`); -- -- Indexes for table `map_emp_district` -- ALTER TABLE `map_emp_district` ADD PRIMARY KEY (`med_id`); -- -- Indexes for table `master_seting` -- ALTER TABLE `master_seting` ADD PRIMARY KEY (`mseting_id`); -- -- Indexes for table `mobile_firebase_token` -- ALTER TABLE `mobile_firebase_token` ADD PRIMARY KEY (`mft_id`), ADD KEY `fk_emp_id` (`fk_emp_id`); -- -- Indexes for table `monthly_salary` -- ALTER TABLE `monthly_salary` ADD PRIMARY KEY (`ms_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `new_dwr` -- ALTER TABLE `new_dwr` ADD PRIMARY KEY (`new_dwr_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `new_hierarchy` -- ALTER TABLE `new_hierarchy` ADD PRIMARY KEY (`nh_id`), ADD KEY `reporting_emp` (`reporting_emp`), ADD KEY `report_to` (`report_to`); -- -- Indexes for table `order_product` -- ALTER TABLE `order_product` ADD PRIMARY KEY (`ord_pro_id`), ADD KEY `fk_order_product` (`fk_ord_id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `order_table` -- ALTER TABLE `order_table` ADD PRIMARY KEY (`ord_id`), ADD KEY `fk_dg_id` (`fk_dg_id`), ADD KEY `ord_status` (`ord_status`), ADD KEY `cust_id` (`cust_id`), ADD KEY `et_id` (`et_id`), ADD KEY `tras_ref_order_id` (`tras_ref_order_id`), ADD KEY `year_id` (`year_id`), ADD KEY `fk_product_id` (`fk_product_id`); -- -- Indexes for table `order_verify_table` -- ALTER TABLE `order_verify_table` ADD PRIMARY KEY (`order_verify_id`), ADD KEY `fk_order_id` (`fk_order_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `paid_leave` -- ALTER TABLE `paid_leave` ADD PRIMARY KEY (`pl_id`); -- -- Indexes for table `payment` -- ALTER TABLE `payment` ADD PRIMARY KEY (`pay_id`), ADD KEY `cust_id` (`cust_id`), ADD KEY `emp_id` (`emp_id`), ADD KEY `account_id` (`account_id`), ADD KEY `year_id` (`year_id`); -- -- Indexes for table `payment_verify_table` -- ALTER TABLE `payment_verify_table` ADD PRIMARY KEY (`payment_verify_id`), ADD KEY `fk_et_id` (`fk_et_id`), ADD KEY `fk_pay_id` (`fk_pay_id`); -- -- Indexes for table `place_table` -- ALTER TABLE `place_table` ADD PRIMARY KEY (`pt_id`), ADD KEY `fk_tt_id` (`fk_tt_id`); -- -- Indexes for table `product_category_tbl` -- ALTER TABLE `product_category_tbl` ADD PRIMARY KEY (`product_category_tbl_id`); -- -- Indexes for table `product_details` -- ALTER TABLE `product_details` ADD PRIMARY KEY (`product_d_id`), ADD KEY `fk_product_details` (`product_id`), ADD KEY `fk_st_id` (`fk_st_id`); -- -- Indexes for table `product_kit` -- ALTER TABLE `product_kit` ADD PRIMARY KEY (`product_kit_id`), ADD KEY `mst_pro_id` (`mst_pro_id`), ADD KEY `assign_pro_id` (`assign_pro_id`); -- -- Indexes for table `product_master` -- ALTER TABLE `product_master` ADD PRIMARY KEY (`product_id`); -- -- Indexes for table `ptr_delear` -- ALTER TABLE `ptr_delear` ADD PRIMARY KEY (`ptr_did`), ADD KEY `dwr_id_p_dealer` (`fk_dwr_id`); -- -- Indexes for table `ptr_expence` -- ALTER TABLE `ptr_expence` ADD PRIMARY KEY (`ex_id`), ADD KEY `uq_yourtablename` (`fk_dwr_id`) USING BTREE; -- -- Indexes for table `ptr_expenceold` -- ALTER TABLE `ptr_expenceold` ADD PRIMARY KEY (`ex_id`); -- -- Indexes for table `ptr_farmer` -- ALTER TABLE `ptr_farmer` ADD PRIMARY KEY (`ptr_did`), ADD KEY `fk_dwr_id` (`fk_dwr_id`); -- -- Indexes for table `purchase_order` -- ALTER TABLE `purchase_order` ADD PRIMARY KEY (`po_id`), ADD KEY `fk_vt_id` (`fk_vt_id`), ADD KEY `fk_rmo_id` (`fk_rmo_id`), ADD KEY `po_recieve_emp_id` (`po_recieve_emp_id`); -- -- Indexes for table `purchase_order_details` -- ALTER TABLE `purchase_order_details` ADD PRIMARY KEY (`pod_id`), ADD KEY `fk_po_id` (`fk_po_id`), ADD KEY `fk_rm_id` (`fk_rm_id`); -- -- Indexes for table `raw_material` -- ALTER TABLE `raw_material` ADD PRIMARY KEY (`rm_id`); -- -- Indexes for table `raw_material_order` -- ALTER TABLE `raw_material_order` ADD PRIMARY KEY (`rmo_id`); -- -- Indexes for table `raw_material_stock` -- ALTER TABLE `raw_material_stock` ADD PRIMARY KEY (`rms_id`), ADD KEY `fk_finish_good_stock_id` (`fk_finish_good_stock_id`); -- -- Indexes for table `raw_material_stock_details` -- ALTER TABLE `raw_material_stock_details` ADD PRIMARY KEY (`rmsd_id`), ADD KEY `fk_rms_id` (`fk_rms_id`), ADD KEY `fk_rm_id` (`fk_rm_id`); -- -- Indexes for table `recieving_quotation_po` -- ALTER TABLE `recieving_quotation_po` ADD KEY `fk_rmo_id` (`fk_rmo_id`), ADD KEY `fk_rrpo_id` (`fk_rrpo_id`), ADD KEY `fk_sqpo_id` (`fk_sqpo_id`); -- -- Indexes for table `report_verify_table` -- ALTER TABLE `report_verify_table` ADD PRIMARY KEY (`report_verify_id`), ADD KEY `fk_dwr_id` (`fk_dwr_id`), ADD KEY `fk_et_id` (`fk_et_id`), ADD KEY `map_to` (`map_to`); -- -- Indexes for table `rm_category` -- ALTER TABLE `rm_category` ADD PRIMARY KEY (`cat_id`); -- -- Indexes for table `salary_slips` -- ALTER TABLE `salary_slips` ADD PRIMARY KEY (`id`); -- -- Indexes for table `scheme` -- ALTER TABLE `scheme` ADD PRIMARY KEY (`scheme_id`); -- -- Indexes for table `scheme_dealer_category` -- ALTER TABLE `scheme_dealer_category` ADD PRIMARY KEY (`scheme_dealer_cat_id`); -- -- Indexes for table `state_table` -- ALTER TABLE `state_table` ADD PRIMARY KEY (`st_id`); -- -- Indexes for table `taluka_table` -- ALTER TABLE `taluka_table` ADD PRIMARY KEY (`tt_id`), ADD KEY `fk_dt_id` (`fk_dt_id`); -- -- Indexes for table `tbl_customer_visited` -- ALTER TABLE `tbl_customer_visited` ADD PRIMARY KEY (`cust_visited_id`), ADD KEY `fk_cust_id` (`fk_cust_id`), ADD KEY `fk_dwr_id` (`fk_dwr_id`); -- -- Indexes for table `tbl_farmer_visited` -- ALTER TABLE `tbl_farmer_visited` ADD PRIMARY KEY (`farm_visited_id`), ADD KEY `fk_farm_id` (`fk_farm_id`), ADD KEY `fk_dwr_id` (`fk_dwr_id`), ADD KEY `fk_crop_id` (`fk_crop_id`), ADD KEY `fk_crop_id2` (`fk_crop_id2`), ADD KEY `fk_crop_id3` (`fk_crop_id3`); -- -- Indexes for table `tbl_financial_year` -- ALTER TABLE `tbl_financial_year` ADD PRIMARY KEY (`fin_year_id`); -- -- Indexes for table `tbl_mas_farmer` -- ALTER TABLE `tbl_mas_farmer` ADD PRIMARY KEY (`farm_id`), ADD KEY `fk_state_id` (`fk_state_id`), ADD KEY `fk_district_id` (`fk_district_id`), ADD KEY `fk_taluka_id` (`fk_taluka_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `tbl_region` -- ALTER TABLE `tbl_region` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_region_product_rate` -- ALTER TABLE `tbl_region_product_rate` ADD PRIMARY KEY (`id`), ADD KEY `fk_region_id` (`fk_region_id`), ADD KEY `fk_product_d_id` (`fk_product_d_id`); -- -- Indexes for table `tbl_salary_parameter` -- ALTER TABLE `tbl_salary_parameter` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tbl_ship_to_address` -- ALTER TABLE `tbl_ship_to_address` ADD PRIMARY KEY (`ship_to_id`); -- -- Indexes for table `tokens` -- ALTER TABLE `tokens` ADD PRIMARY KEY (`id`); -- -- Indexes for table `transfer_order_product` -- ALTER TABLE `transfer_order_product` ADD PRIMARY KEY (`ord_pro_id`), ADD KEY `fk_order_product` (`fk_ord_id`), ADD KEY `product_id` (`product_id`); -- -- Indexes for table `transfer_order_table` -- ALTER TABLE `transfer_order_table` ADD PRIMARY KEY (`ord_id`), ADD KEY `fk_cust_id` (`cust_id`), ADD KEY `fk_dg_id` (`fk_dg_id`), ADD KEY `ord_status` (`ord_status`), ADD KEY `et_id` (`et_id`), ADD KEY `ord_ref_id` (`ord_ref_id`), ADD KEY `tras_ref_order_id` (`tras_ref_order_id`); -- -- Indexes for table `unit_master` -- ALTER TABLE `unit_master` ADD PRIMARY KEY (`unit_id`); -- -- Indexes for table `user_current_location` -- ALTER TABLE `user_current_location` ADD PRIMARY KEY (`ul_id`), ADD KEY `fk_cust_farm_visited_id` (`fk_cust_farm_visited_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- Indexes for table `verify_transfer_order_table` -- ALTER TABLE `verify_transfer_order_table` ADD PRIMARY KEY (`verify_transfer_order_id`), ADD KEY `fk_ord_id` (`fk_ord_id`), ADD KEY `fk_et_id` (`fk_et_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `acc_master_tbl` -- ALTER TABLE `acc_master_tbl` MODIFY `acc_master_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `admin_login` -- ALTER TABLE `admin_login` MODIFY `al_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `bank_table` -- ALTER TABLE `bank_table` MODIFY `bt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=144; -- -- AUTO_INCREMENT for table `bom_details_table` -- ALTER TABLE `bom_details_table` MODIFY `bom_details_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `bom_table` -- ALTER TABLE `bom_table` MODIFY `bom_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `company_alert` -- ALTER TABLE `company_alert` MODIFY `ca_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `company_alert_detail` -- ALTER TABLE `company_alert_detail` MODIFY `alert_check_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `company_details` -- ALTER TABLE `company_details` MODIFY `comp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5; -- -- AUTO_INCREMENT for table `company_table` -- ALTER TABLE `company_table` MODIFY `comp_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `comp_bank_table` -- ALTER TABLE `comp_bank_table` MODIFY `cbt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `crop` -- ALTER TABLE `crop` MODIFY `crop_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75; -- -- AUTO_INCREMENT for table `customer` -- ALTER TABLE `customer` MODIFY `cust_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dealer_credit_note` -- ALTER TABLE `dealer_credit_note` MODIFY `cn_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dealer_stock_table` -- ALTER TABLE `dealer_stock_table` MODIFY `dst_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dealer_stock_table_details` -- ALTER TABLE `dealer_stock_table_details` MODIFY `dstd_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `demo_customer_for_testing` -- ALTER TABLE `demo_customer_for_testing` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `department` -- ALTER TABLE `department` MODIFY `dept_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `designation` -- ALTER TABLE `designation` MODIFY `desig_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41; -- -- AUTO_INCREMENT for table `designation_table` -- ALTER TABLE `designation_table` MODIFY `dt_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `dispatch_godown` -- ALTER TABLE `dispatch_godown` MODIFY `dg_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `district_table` -- ALTER TABLE `district_table` MODIFY `dt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78; -- -- AUTO_INCREMENT for table `dwr_table` -- ALTER TABLE `dwr_table` MODIFY `dwr_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `employee_adv_payment` -- ALTER TABLE `employee_adv_payment` MODIFY `emp_adv_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `employee_hierarchy` -- ALTER TABLE `employee_hierarchy` MODIFY `eh_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `employee_salary_table` -- ALTER TABLE `employee_salary_table` MODIFY `emp_adv_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `employee_table` -- ALTER TABLE `employee_table` MODIFY `et_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `employee_tour_route` -- ALTER TABLE `employee_tour_route` MODIFY `etr_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `emp_attendance` -- ALTER TABLE `emp_attendance` MODIFY `attendance_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `emp_state_maping` -- ALTER TABLE `emp_state_maping` MODIFY `esm_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `emp_target` -- ALTER TABLE `emp_target` MODIFY `emp_trg_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `expenses` -- ALTER TABLE `expenses` MODIFY `exp_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `factory_order` -- ALTER TABLE `factory_order` MODIFY `fo_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `factory_order_data` -- ALTER TABLE `factory_order_data` MODIFY `fod_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `farmer_meeting` -- ALTER TABLE `farmer_meeting` MODIFY `fm_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `farmer_meeting_details` -- ALTER TABLE `farmer_meeting_details` MODIFY `fmd_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `financial_year` -- ALTER TABLE `financial_year` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `finish_product_damage_stock` -- ALTER TABLE `finish_product_damage_stock` MODIFY `fps_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `finish_product_damage_stock_details` -- ALTER TABLE `finish_product_damage_stock_details` MODIFY `fpsd_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `finish_product_stock` -- ALTER TABLE `finish_product_stock` MODIFY `fps_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `finish_product_stock_details` -- ALTER TABLE `finish_product_stock_details` MODIFY `fpsd_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `godown_to_godown_transfer_order` -- ALTER TABLE `godown_to_godown_transfer_order` MODIFY `godown_transfer_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `group_table` -- ALTER TABLE `group_table` MODIFY `gt_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `holiday` -- ALTER TABLE `holiday` MODIFY `holi_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21; -- -- AUTO_INCREMENT for table `holiday_details` -- ALTER TABLE `holiday_details` MODIFY `holi_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `holiday_master` -- ALTER TABLE `holiday_master` MODIFY `hl_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `invoice_table` -- ALTER TABLE `invoice_table` MODIFY `inv_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `item_master` -- ALTER TABLE `item_master` MODIFY `sr_no` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `language_list` -- ALTER TABLE `language_list` MODIFY `lang_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `leave` -- ALTER TABLE `leave` MODIFY `lv_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `leave_table` -- ALTER TABLE `leave_table` MODIFY `lt_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `leave_verify_table` -- ALTER TABLE `leave_verify_table` MODIFY `report_verify_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `leave_verify_tableold` -- ALTER TABLE `leave_verify_tableold` MODIFY `lvt_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `map_emp_district` -- ALTER TABLE `map_emp_district` MODIFY `med_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `master_seting` -- ALTER TABLE `master_seting` MODIFY `mseting_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `mobile_firebase_token` -- ALTER TABLE `mobile_firebase_token` MODIFY `mft_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `monthly_salary` -- ALTER TABLE `monthly_salary` MODIFY `ms_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `new_dwr` -- ALTER TABLE `new_dwr` MODIFY `new_dwr_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `new_hierarchy` -- ALTER TABLE `new_hierarchy` MODIFY `nh_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_product` -- ALTER TABLE `order_product` MODIFY `ord_pro_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_table` -- ALTER TABLE `order_table` MODIFY `ord_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `order_verify_table` -- ALTER TABLE `order_verify_table` MODIFY `order_verify_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `paid_leave` -- ALTER TABLE `paid_leave` MODIFY `pl_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment` -- ALTER TABLE `payment` MODIFY `pay_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `payment_verify_table` -- ALTER TABLE `payment_verify_table` MODIFY `payment_verify_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `place_table` -- ALTER TABLE `place_table` MODIFY `pt_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_category_tbl` -- ALTER TABLE `product_category_tbl` MODIFY `product_category_tbl_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_details` -- ALTER TABLE `product_details` MODIFY `product_d_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_kit` -- ALTER TABLE `product_kit` MODIFY `product_kit_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `product_master` -- ALTER TABLE `product_master` MODIFY `product_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ptr_delear` -- ALTER TABLE `ptr_delear` MODIFY `ptr_did` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ptr_expence` -- ALTER TABLE `ptr_expence` MODIFY `ex_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ptr_expenceold` -- ALTER TABLE `ptr_expenceold` MODIFY `ex_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `ptr_farmer` -- ALTER TABLE `ptr_farmer` MODIFY `ptr_did` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchase_order` -- ALTER TABLE `purchase_order` MODIFY `po_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `purchase_order_details` -- ALTER TABLE `purchase_order_details` MODIFY `pod_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `raw_material` -- ALTER TABLE `raw_material` MODIFY `rm_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `raw_material_order` -- ALTER TABLE `raw_material_order` MODIFY `rmo_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `raw_material_stock` -- ALTER TABLE `raw_material_stock` MODIFY `rms_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `raw_material_stock_details` -- ALTER TABLE `raw_material_stock_details` MODIFY `rmsd_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `report_verify_table` -- ALTER TABLE `report_verify_table` MODIFY `report_verify_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `rm_category` -- ALTER TABLE `rm_category` MODIFY `cat_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `salary_slips` -- ALTER TABLE `salary_slips` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `scheme` -- ALTER TABLE `scheme` MODIFY `scheme_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `scheme_dealer_category` -- ALTER TABLE `scheme_dealer_category` MODIFY `scheme_dealer_cat_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `state_table` -- ALTER TABLE `state_table` MODIFY `st_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34; -- -- AUTO_INCREMENT for table `taluka_table` -- ALTER TABLE `taluka_table` MODIFY `tt_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=607; -- -- AUTO_INCREMENT for table `tbl_customer_visited` -- ALTER TABLE `tbl_customer_visited` MODIFY `cust_visited_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_farmer_visited` -- ALTER TABLE `tbl_farmer_visited` MODIFY `farm_visited_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_financial_year` -- ALTER TABLE `tbl_financial_year` MODIFY `fin_year_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_mas_farmer` -- ALTER TABLE `tbl_mas_farmer` MODIFY `farm_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_region` -- ALTER TABLE `tbl_region` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_region_product_rate` -- ALTER TABLE `tbl_region_product_rate` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_salary_parameter` -- ALTER TABLE `tbl_salary_parameter` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tbl_ship_to_address` -- ALTER TABLE `tbl_ship_to_address` MODIFY `ship_to_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `tokens` -- ALTER TABLE `tokens` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transfer_order_product` -- ALTER TABLE `transfer_order_product` MODIFY `ord_pro_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `transfer_order_table` -- ALTER TABLE `transfer_order_table` MODIFY `ord_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `unit_master` -- ALTER TABLE `unit_master` MODIFY `unit_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `user_current_location` -- ALTER TABLE `user_current_location` MODIFY `ul_id` int(11) NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT for table `verify_transfer_order_table` -- ALTER TABLE `verify_transfer_order_table` MODIFY `verify_transfer_order_id` int(11) NOT NULL AUTO_INCREMENT; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;