JYymMYdv

· 7 years ago · Oct 03, 2018, 07:50 AM
1/*
2SQLyog Community v11.26 (32 bit)
3MySQL - 5.6.17-enterprise-commercial-advanced-log : Database - CorpUDAAN
4*********************************************************************
5*/
6
7
8/*!40101 SET NAMES utf8 */;
9
10/*!40101 SET SQL_MODE=''*/;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
16USE `CorpUDAAN`;
17
18/*Table structure for table `ff_d_gst_state` */
19
20DROP TABLE IF EXISTS `ff_d_gst_state`;
21
22CREATE TABLE `ff_d_gst_state` (
23  `GST_STATE_ID` int(11) NOT NULL AUTO_INCREMENT,
24  `EMPLOYEE_NAME` varchar(50) DEFAULT NULL,
25  `STATE_ID` int(11) DEFAULT NULL,
26  `GOVT_STATE_CODE` varchar(4) DEFAULT NULL,
27  `GST_NO` varchar(20) DEFAULT NULL,
28  `OFFICE_ADDR` varchar(200) DEFAULT NULL,
29  `CITY` int(11) DEFAULT NULL,
30  `PINCODE` int(11) DEFAULT NULL,
31  `REGION` int(11) DEFAULT NULL,
32  `REGD_OFC_MAIL_ID` varchar(100) DEFAULT NULL,
33  `PHONE_NO` varchar(15) DEFAULT NULL,
34  `UNION_TERITORY` enum('Y','N') DEFAULT 'N',
35  `SAC` varchar(20) DEFAULT NULL,
36  `ARN_NO` varchar(20) DEFAULT NULL,
37  `CREATED_BY` int(11) DEFAULT NULL,
38  `CREATION_DATE` date DEFAULT NULL,
39  `UPDATE_BY` int(11) DEFAULT NULL,
40  `UPDATE_DATE` date DEFAULT NULL,
41  `DT_TO_BRANCH` enum('Y','N') NOT NULL DEFAULT 'N',
42  PRIMARY KEY (`GST_STATE_ID`),
43  KEY `FK_ff_d_gst_state_1` (`STATE_ID`),
44  KEY `FK_ff_d_gst_state_2` (`CITY`),
45  KEY `FK_ff_d_gst_state_3` (`PINCODE`),
46  KEY `FK_ff_d_gst_state_4` (`REGION`),
47  CONSTRAINT `FK_ff_d_gst_state_1` FOREIGN KEY (`STATE_ID`) REFERENCES `ff_d_state` (`STATE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
48  CONSTRAINT `FK_ff_d_gst_state_2` FOREIGN KEY (`CITY`) REFERENCES `ff_d_city` (`CITY_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
49  CONSTRAINT `FK_ff_d_gst_state_3` FOREIGN KEY (`PINCODE`) REFERENCES `ff_d_pincode` (`PINCODE_ID`) ON DELETE NO ACTION ON UPDATE CASCADE,
50  CONSTRAINT `FK_ff_d_gst_state_4` FOREIGN KEY (`REGION`) REFERENCES `ff_d_region` (`REGION_ID`)
51) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=latin1;
52
53/*Data for the table `ff_d_gst_state` */
54
55insert  into `ff_d_gst_state`(`GST_STATE_ID`,`EMPLOYEE_NAME`,`STATE_ID`,`GOVT_STATE_CODE`,`GST_NO`,`OFFICE_ADDR`,`CITY`,`PINCODE`,`REGION`,`REGD_OFC_MAIL_ID`,`PHONE_NO`,`UNION_TERITORY`,`SAC`,`ARN_NO`,`CREATED_BY`,`CREATION_DATE`,`UPDATE_BY`,`UPDATE_DATE`,`DT_TO_BRANCH`) values (1,'Mr.SHASHAVALI',2,'37','37AAACF0841R3ZA','Door No.5/5 & 5/7, Babukhan Estate, 5th Floor, Basheerbagh, Hyderabad - 500 001.',312,2353,1,'shashavali@firstflight.net','9346311218','N',NULL,NULL,1,'2017-07-01',NULL,NULL,'N'),(2,'Mr Ambesh Panchal\n',12,'24','24AAACF0841R2ZI','A-104, Premium House, Near Gandhigram Railway Station, Off. Ashram Road, Navrangpura, Ahmedabad - 380 009. Guj.',7,1262,7,'ambeshp@firstflight.net,','9328051856','N','AAACF0841RST006','AAACF0841RST064',1,'2017-07-01',NULL,NULL,'N'),(3,'Mr. Rajesh Kumar',13,'06','06AAACF0841R2ZG','Plot No.477, Udyog Vihar, Phase â€“ III, Gurgaon â€“ 122 001.',278,150,11,'kumarr@firstflight.net,','9311402717','N',NULL,NULL,1,'2017-07-01',NULL,NULL,'Y'),(4,'Mr. Arun Mishra',23,'17','17AAACF0841R2ZD','Kamber Building, Keating Road, Tinsukia, Shillong - 793 001.',726,6449,14,'arunm@firstflight.net,','9330015204','N',NULL,NULL,1,'2017-07-01',NULL,NULL,'N'),(5,'Mr.Sanjeev kaushik\n\n',15,'01','01AAACF0841R1ZR','Shop No.212, Sector-1, Lane No.10, Nanak Nagar, Jammu - 180 001.',334,495,9,'sanjeevk@firstflight.net,','9356439223','N',NULL,'AA010317000169T',1,'2017-07-01',NULL,NULL,'N'),(6,'Mr Uday Thakur',34,'05','05AAACF0841R1ZJ','Chaman Vihar, Niranjanpur, Majra, Dehradun - 248 171.',195,852,20,'udayt@firstflight.net,','9311404001','N',NULL,'AA050317009253N',1,'2017-07-01',NULL,NULL,'N'),(7,'Mr. SABU JOSEPH',31,'33','33AAACF0841R2ZJ','7CD & F, 7th Floor, 560-562, Century Plaza, Anna Salai, Teynampet, Chennai - 600 018.',160,3141,3,'sabuj@firstflight.net,','9344072345','N',NULL,'AA3304170329745',1,'2017-07-01',NULL,NULL,'N'),(8,'Mr.Vinod C',21,'27','27AAACF0841R1ZD','D-1001/02, Lotus Corporate Park, Off Jay Coach Flyover, W.E. Highway, Goregaon (E), Mumbai - 400 063',516,1512,2,'vinodc@firstflight.net ','9324337884','N',NULL,'AA270417082177Y',1,'2017-07-01',NULL,NULL,'N'),(9,'Mr. Jaishankar',17,'29','29AAACF0841R1Z9','#89, Ist & IInd Floor, South Wing, A.M.Plaza, Airport Main Road, Vimanapura, Bengaluru â€“ 560017',66,2730,6,'jaishankarp@firstflight.net,','9341024660','N',NULL,'AA2904170275054',1,'2017-07-01',NULL,NULL,'N'),(10,'Mr. Sujeet Jha',16,'20','20AAACF0841R1ZR','Ward No.27, Holding No.534, 05 Main Road, Ranchi - 834 001.',672,6674,19,'sujeetj@firstflight.net,','7070091301','N',NULL,'AA200417004334W',1,'2017-07-01',NULL,NULL,'N'),(11,'Mr. Arun Mishra',4,'18','18AAACF0841R1ZC','Piali Phukan Road, Rehabari, Guwahati - 781 008.',279,6344,14,'arunm@firstflight.net','9330015204','N',NULL,'AA180417007008F',1,'2017-07-01',NULL,NULL,'N'),(12,'Mr. Sujeet Jha',5,'10','10AAACF0841R2ZR','G-19, PC Colony, Rajendra Nagar Over Bridge, Kankarbagh, Patna, Bihar - 800 020.',615,6498,19,'sujeetj@firstflight.net,','7070091301','N','AAACF0841RST147','AAACF0841RST181',1,'2017-07-01',NULL,NULL,'N'),(13,'Mr.Sanjeev kaushik\n\n',6,'04','04AAACF0841R1ZL','Plot No. 24/9, Industrial Area, Phase-2, Chandigarh - 160002.',151,375,10,'sanjeevk@firstflight.net,','9356439223','Y',NULL,'AA040417001404U',1,'2017-07-01',NULL,NULL,'N'),(14,'Mr. Hitesh patel',7,'22','22AAACF0841R1ZN','Behind Mata Garage, Beside Post Office, Jeevan Bima Marg, Pandari, Raipur - 492 002.',654,2314,15,'hiteshp@firstflight.net,','9300147901','N',NULL,'AA2204170040215',1,'2017-07-01',NULL,NULL,'N'),(15,'Mr. Rajesh Kumar',10,'07','07AAACF0841R1ZF','408, Vishal Bhavan, 95, Nehru Place, New Delhi - 110 019.',196,19,4,'kumarr@firstflight.net,','9311402717','N',NULL,'AA070417025479Z',1,'2017-07-01',NULL,NULL,'N'),(16,'Ms.Preeti',11,'30','30AAACF0841R2ZP','Shop No.1, Kamakshi Prasad, Near Patto Brij, Panjim, Goa - 403 001.',260,1619,13,'goa@firstflight.net','8669635820','N',NULL,NULL,1,'2017-07-01',NULL,NULL,'N'),(17,'Mr.Sanjeev kaushik\n\n',14,'02','02AAACF0841R1ZP','Shop No.11, 12, Gr. Flr., Gullarwala, Baddi, Dist.Solan, Himachal Pradesh - 173 205.',151,458,10,'sanjeevk@firstflight.net,','9356439223','N',NULL,'AA020417003844K',1,'2017-07-01',NULL,NULL,'N'),(18,'Mr. SABU JOSEPH',18,'32','32AAACF0841R1ZM','Room No.67/832, 2nd Floor, Abhilash Building, St. Benedict Road, Ernakulam North, Kochi - 682 018.',175,5369,8,'sabuj@firstflight.net,','9344072345','N',NULL,'AA320417014800Q',1,'2017-07-01',NULL,NULL,'N'),(19,'Mr. Hitesh patel',20,'23','23AAACF0841R1ZL','#11, Firoz Gandhi Press Complex, B/h Dainik Bhaskar Press, A.B. Road, Indore - 452 001.',317,2132,15,'hiteshp@firstflight.net,','9300147901','N',NULL,'AA230417009284I',1,'2017-07-01',NULL,NULL,'N'),(20,'Mr. Sujeet Jha',26,'21','21AAACF0841R1ZP','Plot No.U22/2, Forest Park, Near Jhadeswari Temple, Bhubaneswar, 751 009.',118,6149,19,'sujeetj@firstflight.net,','7070091301','N',NULL,'AA210417006883F',1,'2017-07-01',NULL,NULL,'N'),(21,'Mr.Sanjeev kaushik\n\n',28,'03','03AAACF0841R1ZN','1-2-3-4, 2nd Floor, Jandu Tower, Miller Ganj, G.T. Rd., Ludhiana -141 003.',444,273,9,'sanjeevk@firstflight.net,','9356439223','N',NULL,'AA030417010729D',1,'2017-07-01',NULL,NULL,'N'),(22,'Mr. Sunil Verma',29,'08','08AAACF0841R2ZC','150 & 162, Maa Hinglaj Nagar-B, Lalarpura Road, Gandhi Path (West), Near Vaishali Nagar, Jaipur â€“ 302021.',324,1062,16,'sunilv@firstflight.net,','9314020681','N',NULL,NULL,1,'2017-07-01',NULL,NULL,'N'),(23,'Mr. Koshlesh Mishra',33,'09','09AAACF0841R2ZA','414/415, 2nd Floor, Sahara Trade Centre, Indira Nagar, Faizabad Rd., Lucknow - 226 016.',443,718,12,'koshleshm@firstflight.net,','9389325200','N',NULL,'AA0904170313187',1,'2017-07-01',NULL,NULL,'N'),(24,'Mr. Arun Mishra',35,'19','19AAACF0841R1ZA','CB-187, Sector-1, Bidhan Nagar, Salt Lake City, Kolkata - 700 064.',411,5796,5,'arunm@firstflight.net,','9330015204','N',NULL,'AA190417027242D',1,'2017-07-01',NULL,NULL,'N'),(25,'Mr.SHASHAVALI',36,'36','36AAACF0841R2ZD','Door No.505 & 507 Babukhan Estate, 5th Floor Basheerbagh Hyderabad,Andra Pradesh - 500001',312,2353,1,'shashavali@firstflight.net','9346311218','N',NULL,NULL,1,'2017-07-01',NULL,NULL,'N'),(32,'Mr. SABU JOSEPH',31,'33','33AAACF0841R2ZJ','7CD & F, 7th Floor, 560-562, Century Plaza, Anna Salai, Teynampet, Chennai - 600 018.',160,3141,17,'mascsd@firstflight.net','24313666 â€“ 70','N',NULL,'AA3304170329745',1,'2017-07-24',NULL,NULL,'N'),(33,'Mr. SABU JOSEPH',31,'33','33AAACF0841R2ZJ','7CD & F, 7th Floor, 560-562, Century Plaza, Anna Salai, Teynampet, Chennai - 600 018.',160,3141,18,'mascsd@firstflight.net','24313666 â€“ 70','N',NULL,'AA3304170329745',1,'2017-07-24',NULL,NULL,'N'),(34,'Mr.Shailesh Parab',21,'27','27AAACF0841R1ZD','427 â€“ 428, Gultekdi Industrial Estate, Nr. Prabhat Printing Press, Pune â€“ 411 037.',642,1764,13,'puecsd@firstflight.net','24263183-86','N',NULL,'AA270417082177Y',1,'2017-07-24',NULL,NULL,'N'),(35,'Mr. Arun Mishra',30,'11','18AAACF0841R1ZC','Piali Phukan Road, Rehabari, Guwahati - 781 008.',251,NULL,5,'arunm@firstflight.net','9330015204','N',NULL,NULL,1,'2017-07-24',NULL,NULL,'N'),(36,NULL,27,'34','34AAACF0841R2ZH','Ground Floor, No.4, 100 Feet Road, Natesan Nagar, Pondicherry - 605 005.',634,3318,17,'mascsd@firstflight.net','24313666 â€“70','Y',NULL,NULL,NULL,NULL,NULL,NULL,'N'),(37,'Mr. Rajesh Kumar',13,'06','06AAACF0841R2ZG','Plot No.477, Udyog Vihar, Phase â€“ III, Gurgaon â€“ 122 001.',278,150,10,'kumarr@firstflight.net,','9311402717','N',NULL,NULL,1,'2017-08-02',NULL,NULL,'N'),(38,'Mr. Koshlesh Mishra',33,'09','09AAACF0841R2ZA','414/415, 2nd Floor, Sahara Trade Centre, Indira Nagar, Faizabad Rd., Lucknow - 226 016.',443,718,20,'koshleshm@firstflight.net,','9389325200','N',NULL,'AA0904170313187',1,'2017-08-02',NULL,NULL,'N'),(39,'Mr. SABU JOSEPH',31,'33','33AAACF0841R2ZJ','7CD & F, 7th Floor, 560-562, Century Plaza, Anna Salai, Teynampet, Chennai - 600 018.',307,4642,6,'mascsd@firstflight.net','24313666 â€“ 70','N',NULL,'AA3304170329745',1,'2017-08-05',NULL,NULL,'N'),(40,'Mr.Sanjeev kaushik\n\n',28,'03','03AAACF0841R1ZN','1-2-3-4, 2nd Floor, Jandu Tower, Miller Ganj, G.T. Rd., Ludhiana -141 003.',505,NULL,10,'sanjeevk@firstflight.net,','9356439223','N',NULL,'AA030417010729D',1,'2017-08-05',NULL,NULL,'N'),(41,'Mr. Hitesh patel',20,'23','23AAACF0841R1ZL','#11, Firoz Gandhi Press Complex, B/h Dainik Bhaskar Press, A.B. Road, Indore - 452 001.',745,NULL,12,'hiteshp@firstflight.net,','9300147901','N',NULL,'AA230417009284I',1,'2017-08-05',NULL,NULL,'N'),(42,'Mr. Hitesh patel',20,'23','23AAACF0841R1ZL','#11, Firoz Gandhi Press Complex, B/h Dainik Bhaskar Press, A.B. Road, Indore - 452 001.',162,NULL,13,'hiteshp@firstflight.net,','9300147901','N',NULL,'AA230417009284I',1,'2017-08-05',NULL,NULL,'N'),(43,'Mr. Arun Mishra',32,'16','18AAACF0841R1ZC','Piali Phukan Road, Rehabari, Guwahati - 781 008.',5,NULL,14,'arunm@firstflight.net,','9330015204','N',NULL,'AA180417007008F',1,'2017-08-05',NULL,NULL,'N'),(44,'Mr. Rajesh Kumar',13,'06','06AAACF0841R2ZG','Plot No.477, Udyog Vihar, Phase â€“ III, Gurgaon â€“ 122 001.',278,150,16,'kumarr@firstflight.net,','9311402717','N',NULL,NULL,1,'2017-08-02',NULL,NULL,'N'),(45,'Mr Ambesh Panchal',8,'26','26AAACF0841R1ZF','First Flight Couriers Ltd  Shop No.- 6  Opp. Town Hall  Nr. Brijwasi Sweet shope  Silvassa  396230',1130,1451,7,'ambeshp@firstflight.net','9328051856','Y',NULL,'AA260917001000U',1,'2017-10-03',NULL,NULL,'N'),(46,'Mr Ambesh Panchal',9,'25','25AAACF0841R1ZH','First Flight Couriers Ltd Omsai complex, Shop no:05, survey no750/24   kalaria, dabhel Daman 396210',185,1449,7,'ambeshp@firstflight.net','9328051856','Y',NULL,'AA250917000678Y',1,'2017-10-03',NULL,NULL,'N');
56
57/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
58/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
59/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
60/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;