Notes

-- --------------------------------------------------------
-- Host: 103.10.234.199
-- Server version: 5.7.24 - MySQL Community Server (GPL)
-- Server OS: Win64
-- HeidiSQL Version: 10.2.0.5599
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


-- Dumping database structure for nilondata
CREATE DATABASE IF NOT EXISTS `nilondata` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `nilondata`;

-- Dumping structure for table nilondata.persons1
CREATE TABLE IF NOT EXISTS `persons1` (
`NSM` varchar(255) DEFAULT NULL,
`ASM` varchar(255) DEFAULT NULL,
`RSM` varchar(255) DEFAULT NULL,
`ZSM` varchar(255) DEFAULT NULL,
`GSM` varchar(255) DEFAULT NULL,
`ESM` varchar(255) DEFAULT NULL,
`Level8Position` varchar(255) DEFAULT NULL,
`Level8PositionCode` varchar(255) DEFAULT NULL,
`Level7Position` varchar(255) DEFAULT NULL,
`Level7PositionCode` varchar(255) DEFAULT NULL,
`Level6Position` varchar(255) DEFAULT NULL,
`Level6PositionCode` varchar(255) DEFAULT NULL,
`Level5Position` varchar(255) DEFAULT NULL,
`Level5PositionCode` varchar(255) DEFAULT NULL,
`Level4Position` varchar(255) DEFAULT NULL,
`Level4PositionCode` varchar(255) DEFAULT NULL,
`Level3Position` varchar(255) DEFAULT NULL,
`Level3PositionCode` varchar(255) DEFAULT NULL,
`Level2Position` varchar(255) DEFAULT NULL,
`Level2PositionCode` varchar(255) DEFAULT NULL,
`Level1Position` varchar(255) DEFAULT NULL,
`Level1PositionCode` varchar(255) DEFAULT NULL,
`ESMErpId` varchar(255) DEFAULT NULL,
`ESMRank` varchar(255) DEFAULT NULL,
`ESMHQ` varchar(255) DEFAULT NULL,
`ESMDesignation` varchar(255) DEFAULT NULL,
`Region` varchar(255) DEFAULT NULL,
`Zone` varchar(255) DEFAULT NULL,
`Beat` varchar(255) DEFAULT NULL,
`BeatErpId` varchar(255) DEFAULT NULL,
`Territory` varchar(255) DEFAULT NULL,
`Shop` varchar(255) DEFAULT NULL,
`ShopErpId` varchar(255) DEFAULT NULL,
`ShopOwnersName` varchar(255) DEFAULT NULL,
`ShopOwnersNo` varchar(255) DEFAULT NULL,
`ShopAddress` varchar(255) DEFAULT NULL,
`ShopMarket` varchar(255) DEFAULT NULL,
`ShopCity` varchar(255) DEFAULT NULL,
`ShopState` varchar(255) DEFAULT NULL,
`ShopType` varchar(255) DEFAULT NULL,
`ShopSegmentation` varchar(255) DEFAULT NULL,
`ChannelName` varchar(255) DEFAULT NULL,
`ChannelErpId` varchar(255) DEFAULT NULL,
`ShopIsFocussed` varchar(255) DEFAULT NULL,
`AttendanceId` varchar(255) DEFAULT NULL,
`VisitGuid` varchar(255) DEFAULT NULL,
`OrderDate` varchar(255) DEFAULT NULL,
`OrderTime` varchar(255) DEFAULT NULL,
`NoSalesReason` varchar(255) DEFAULT NULL,
`InvoiceNumber` varchar(255) DEFAULT NULL,
`IsTelephonic` varchar(255) DEFAULT NULL,
`IsProductive` varchar(255) DEFAULT NULL,
`IsSchemeEffective` varchar(255) DEFAULT NULL,
`IsOutOfTurn` varchar(255) DEFAULT NULL,
`OutOfCompliance` varchar(255) DEFAULT NULL,
`OrderType` varchar(255) DEFAULT NULL,
`ProductStandardUnitConversionFactor` varchar(255) DEFAULT NULL,
`ProductStandardUnit` varchar(255) DEFAULT NULL,
`ProductUnit` varchar(255) DEFAULT NULL,
`ProductErpId` varchar(255) DEFAULT NULL,
`ProductName` varchar(255) DEFAULT NULL,
`SecondaryCategory` varchar(255) DEFAULT NULL,
`PrimaryCategory` varchar(255) DEFAULT NULL,
`MOQ` varchar(255) DEFAULT NULL,
`CloseToExpiry` varchar(255) DEFAULT NULL,
`StockQuantity` varchar(255) DEFAULT NULL,
`StockChange` varchar(255) DEFAULT NULL,
`SaleId` varchar(255) DEFAULT NULL,
`SuggestedQuantity` varchar(255) DEFAULT NULL,
`ReturnQty` varchar(255) DEFAULT NULL,
`OrderInUnits` varchar(255) DEFAULT NULL,
`DispatchInUnits` varchar(255) DEFAULT NULL,
`DispatchRemark` varchar(255) DEFAULT NULL,
`DispatchDate` varchar(255) DEFAULT NULL,
`DispatchStatus` varchar(255) DEFAULT NULL,
`PTR` varchar(255) DEFAULT NULL,
`OriginalPTR` varchar(255) DEFAULT NULL,
`SchemeQuantity` varchar(255) DEFAULT NULL,
`SchemeDiscount` varchar(255) DEFAULT NULL,
`ProductWiseDiscount` varchar(255) DEFAULT NULL,
`ProductIsFocussed` varchar(255) DEFAULT NULL,
`ProductIsPromoted` varchar(255) DEFAULT NULL,
`ProductIsRecommended` varchar(255) DEFAULT NULL,
`ProductIsFastMoving` varchar(255) DEFAULT NULL,
`CGST` varchar(255) DEFAULT NULL,
`SGST` varchar(255) DEFAULT NULL,
`IGST` varchar(255) DEFAULT NULL,
`FAUnifySource` varchar(255) DEFAULT NULL,
`id` int(255) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8276008 DEFAULT CHARSET=latin1;

-- Data exporting was unselected.

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;