--
-- Host: localhost    Database: Reimbursement
-- ------------------------------------------------------


--
-- Table structure for table `Expense`
--

CREATE TABLE `Expense` (
  `Expense_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `Approval` int(11) DEFAULT NULL,
  `Total` varchar(255) DEFAULT NULL,
  `Total_type` varchar(255) DEFAULT NULL,
  `Cost_in_USD` varchar(255) DEFAULT NULL,
  `Approval_status` int(11) NOT NULL DEFAULT '0',
  `Approval_date` timestamp NULL DEFAULT NULL,
  `reject_resons` text,
  `Payment_status` int(11) NOT NULL DEFAULT '0',
  `Payment_date` timestamp NULL DEFAULT NULL,
  `date` date DEFAULT NULL,
  `Timezone` varchar(20) DEFAULT NULL,
  `Location` varchar(255) DEFAULT NULL,
  `Declined_by` int(11) DEFAULT NULL,
  `Declined_date` timestamp NULL DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`Expense_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Expense`
--

INSERT INTO `Expense` VALUES (16,101,'aa',58,'100.00','CNY',NULL,2,'2020-12-24 11:30:12','1234567',2,'2020-12-24 11:30:12','2020-12-01',NULL,'Mumbai',58,'2020-12-24 11:30:12','2020-12-09 11:39:14',NULL),(17,101,'bb',58,'200.00','CNY',NULL,1,'2020-12-31 11:00:40','123',2,'2020-12-31 11:00:40','2020-12-09',NULL,'Mumbai',58,'2020-12-22 18:15:37','2020-12-09 11:40:21',NULL),(18,101,'cc',58,'300.00','CNY',NULL,1,'2020-12-31 10:33:14',NULL,1,'2020-12-31 10:33:14','2020-12-09',NULL,'Mumbai',NULL,NULL,'2020-12-09 11:42:11',NULL),(20,101,'eat',58,'9.19','USD','9.19',2,'2020-12-15 11:21:57','Yes, and a notifiation should be displayed if aa expense hasa not been approved/denied in over a week',0,NULL,'2020-12-09',NULL,'Mumbai',6,'2020-12-15 11:21:48','2020-12-09 16:12:19',NULL),(21,101,'eat',58,'60.00','CNY',NULL,2,'2020-12-31 10:32:14','fafsaf',2,'2020-12-31 10:32:14','2020-12-10',NULL,'Mumbai',58,'2020-12-31 10:32:14','2020-12-10 17:23:04',NULL),(22,101,'eat',58,'400.07','CNY',NULL,2,'2020-12-31 10:30:06','sdfafdsaggsd',2,'2020-12-31 10:30:06','2020-12-18',NULL,'Mumbai',58,'2020-12-31 10:30:06','2020-12-18 17:55:20',NULL),(23,101,'eat',58,'400.07','CNY',NULL,1,'2020-12-31 10:31:16','rfrrfrffrrf',1,'2020-12-31 10:31:17','2020-12-31',NULL,'Mumbai',58,'2020-12-31 10:29:52','2020-12-18 17:55:48',NULL),(24,101,'yyy',1,'6.00','CNY',NULL,2,'2020-12-31 10:28:15','ttttttttttttttttt',2,'2020-12-31 10:28:15','2020-12-24',NULL,'Mumbai',58,'2020-12-31 10:28:15','2020-12-24 15:39:17',NULL),(27,101,'eat',1,'6.00','CNY',NULL,1,'2020-12-30 18:38:33',NULL,2,'2020-12-30 18:38:33','2020-12-02','UTC+8','Mumbai',NULL,NULL,'2020-12-25 14:15:33',NULL),(28,101,'yyy',1,'60.00','CNY',NULL,2,'2020-12-30 18:32:53','dfdsfsdfsdfdsfdf',2,'2020-12-30 18:32:53','2020-12-24','UTC+8','Mumbai',58,'2020-12-30 18:32:53','2020-12-25 14:16:35',NULL),(29,101,'eat',1,'7.00','CNY',NULL,2,'2020-12-28 15:00:01','rrrradfdfsdfsdf',2,'2020-12-28 15:00:01','2020-12-25','UTC+8','Mumbai',58,'2020-12-28 15:00:01','2020-12-28 14:47:41',NULL),(30,101,'erwrewrew',1,'78.00','CNY',NULL,2,'2020-12-31 10:30:33','sdfafasdgg',2,'2020-12-31 10:30:33','2020-11-10','UTC+8','Mumbai',58,'2020-12-31 10:30:33','2020-12-28 14:51:04',NULL),(31,101,'yyy',1,'60.00','CNY',NULL,2,'2020-12-30 18:04:26','',2,'2020-12-30 18:04:26','2020-12-12','UTC+8','Mumbai',58,'2020-12-30 18:04:26','2020-12-28 15:19:21',NULL),(32,101,'yyy',1,'61.00','CNY',NULL,2,'2021-01-05 14:32:56','gggggg',2,'2021-01-05 14:32:56','2020-12-16','UTC+8','Mumbai',58,'2021-01-05 14:32:56','2020-12-28 15:24:36',NULL),(33,101,'business trip',58,'382.55','CNY',NULL,1,'2021-01-04 14:57:54','drrrrrrrrrrrrrr',1,'2021-01-04 14:57:54','2020-12-31','UTC+8','Mumbai',58,'2021-01-04 14:41:36','2020-12-30 17:51:58',NULL),(34,57,'hhhbbbhs',1,'1.00','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-14','UTC+8','Shenzhen',NULL,NULL,'2021-01-04 16:57:01',NULL),(35,57,'rftretrtwt',58,'53.66','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-13','UTC+8','Mumbai',NULL,NULL,'2021-01-06 10:39:08',NULL),(36,101,'dsagrgagv',58,'3.00','CNY',NULL,2,'2021-01-06 11:13:30','dfadgdasgsdagsdag',2,'2021-01-06 11:13:30','2021-01-13','UTC+8','Shenzhen',58,'2021-01-06 11:13:30','2021-01-06 10:40:50',NULL),(37,101,'eat',58,'6.00','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-06','UTC+8','Mumbai',NULL,NULL,'2021-01-06 10:51:38',NULL),(38,101,'dgasdgrrwagsdgsdf',58,'14.18','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-06','UTC+8','Mumbai',NULL,NULL,'2021-01-06 11:07:22',NULL),(39,101,'eeeffefef',101,'2.00','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-06','UTC+8','Mumbai',NULL,NULL,'2021-01-06 11:08:20',NULL),(40,101,'rrrrrr',58,'16.00','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-06','UTC+8','Mumbai',NULL,NULL,'2021-01-06 11:11:16',NULL),(41,101,'ertewrfef',1,'23.00','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-06','UTC+8','Mumbai',NULL,NULL,'2021-01-06 11:20:13',NULL),(42,58,'dsgasdfgsdfgsdgsd',1,'3.00','CNY',NULL,0,NULL,NULL,0,NULL,'2021-01-06','UTC+8','',NULL,NULL,'2021-01-06 18:17:26',NULL),(43,58,'dfdfdfds',1,'15.00','CNY',NULL,1,'2022-06-08 18:51:24',NULL,1,'2022-06-08 18:51:24','2021-02-17','UTC+8','',NULL,NULL,'2021-02-24 12:36:32',NULL),(44,58,'vhvh',1,'18.66','CNY',NULL,0,NULL,NULL,0,NULL,'2022-06-15','UTC+5.5','',NULL,NULL,'2022-06-15 07:07:45',NULL),(45,58,'vhvh',1,'18.66','CNY',NULL,0,NULL,NULL,0,NULL,'2022-06-15','UTC+5.5','',NULL,NULL,'2022-06-15 07:07:54',NULL),(46,58,'vhvh',1,'18.66','CNY',NULL,0,NULL,NULL,0,NULL,'2022-06-15','UTC+5.5','',NULL,NULL,'2022-06-15 07:08:00',NULL),(47,58,'hii sainath',6,'5010.00','CNY',NULL,1,'2022-06-15 15:28:26',NULL,1,'2022-06-15 15:28:27','2022-06-15','UTC+5.5','',NULL,NULL,'2022-06-15 07:10:37',NULL),(48,58,'hii sainath',6,'5010.00','CNY',NULL,1,'2022-06-15 15:27:59',NULL,1,'2022-06-15 15:28:00','2022-06-15','UTC+5.5','',NULL,NULL,'2022-06-15 07:10:51',NULL),(49,58,'hii sainath',6,'5010.00','CNY',NULL,1,'2022-06-15 15:26:07',NULL,1,'2022-06-15 15:26:08','2022-06-15','UTC+5.5','',NULL,NULL,'2022-06-15 07:10:59',NULL);

--
-- Table structure for table `Expense_image`
--

CREATE TABLE `Expense_image` (
  `Expense_id` int(11) DEFAULT NULL,
  `image_id` int(11) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Expense_image`
--

INSERT INTO `Expense_image` VALUES (13,13,'2020-12-03 18:11:24',NULL),(13,14,'2020-12-03 18:11:27',NULL),(17,16,'2020-12-09 11:40:21',NULL),(18,17,'2020-12-09 11:42:11',NULL),(19,18,'2020-12-09 15:14:10',NULL),(20,19,'2020-12-09 16:12:19',NULL),(21,20,'2020-12-10 17:23:04',NULL),(22,21,'2020-12-18 17:55:20',NULL),(22,22,'2020-12-18 17:55:20',NULL),(23,23,'2020-12-18 17:55:48',NULL),(23,24,'2020-12-18 17:55:48',NULL),(24,25,'2020-12-24 15:39:17',NULL),(25,26,'2020-12-25 14:11:09',NULL),(26,27,'2020-12-25 14:14:51',NULL),(27,28,'2020-12-25 14:15:33',NULL),(28,29,'2020-12-25 14:16:35',NULL),(29,30,'2020-12-28 14:47:41',NULL),(30,31,'2020-12-28 14:51:04',NULL),(31,32,'2020-12-28 15:19:21',NULL),(32,33,'2020-12-28 15:24:36',NULL),(33,34,'2020-12-30 17:51:58',NULL),(34,35,'2021-01-04 16:57:01',NULL),(35,36,'2021-01-06 10:39:08',NULL),(36,37,'2021-01-06 10:40:50',NULL),(36,38,'2021-01-06 10:40:50',NULL),(36,39,'2021-01-06 10:40:50',NULL),(37,40,'2021-01-06 10:51:38',NULL),(38,41,'2021-01-06 11:07:22',NULL),(39,42,'2021-01-06 11:08:20',NULL),(40,43,'2021-01-06 11:11:16',NULL),(41,44,'2021-01-06 11:20:13',NULL),(42,45,'2021-01-06 18:17:26',NULL),(43,46,'2021-02-24 12:36:32',NULL),(44,47,'2022-06-15 07:07:45',NULL),(45,48,'2022-06-15 07:07:54',NULL),(46,49,'2022-06-15 07:08:00',NULL),(47,50,'2022-06-15 07:10:37',NULL),(48,51,'2022-06-15 07:10:51',NULL),(49,52,'2022-06-15 07:10:59',NULL);

--
-- Table structure for table `Expense_item`
--

CREATE TABLE `Expense_item` (
  `Expense_id` int(11) DEFAULT NULL,
  `Item` varchar(255) DEFAULT NULL,
  `Cost` decimal(10,2) DEFAULT NULL,
  `Cost_type` varchar(255) DEFAULT NULL,
  `created_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Expense_item`
--

INSERT INTO `Expense_item` VALUES (17,'gg',0.00,'CNY','2020-12-09 11:40:21','2020-12-09 11:42:28'),(18,'gg',0.00,'CNY','2020-12-09 11:42:11','2020-12-09 11:42:29'),(19,'shop',200.00,'CNY','2020-12-09 15:14:10',NULL),(20,'eat',60.00,'CNY','2020-12-09 16:12:19',NULL),(21,'eat',60.00,'CNY','2020-12-10 17:23:04',NULL),(22,'eat',60.00,'USD','2020-12-18 17:55:20',NULL),(23,'eat',60.00,'USD','2020-12-18 17:55:49',NULL),(24,'y',6.00,'CNY','2020-12-24 15:39:17',NULL),(25,'eat',60.00,'CNY','2020-12-25 14:11:09',NULL),(26,'eat',60.00,'CNY','2020-12-25 14:14:51',NULL),(27,'eat',6.00,'CNY','2020-12-25 14:15:33',NULL),(28,'345',60.00,'CNY','2020-12-25 14:16:35',NULL),(29,'eat',6.00,'CNY','2020-12-28 14:47:41',NULL),(30,'eat',60.00,'CNY','2020-12-28 14:51:04',NULL),(30,'erefd',12.00,'CNY','2020-12-28 14:51:04',NULL),(31,'eat',60.00,'CNY','2020-12-28 15:19:21',NULL),(32,'345',60.00,'CNY','2020-12-28 15:24:36',NULL),(33,'tickets',106.50,'CNY','2020-12-30 17:51:58',NULL),(33,'hotel',212.60,'CNY','2020-12-30 17:51:58',NULL),(33,'dinner',60.00,'CNY','2020-12-30 17:51:58',NULL),(34,'ddd',1.00,'CNY','2021-01-04 16:57:01',NULL),(35,'trretret',1.00,'USD','2021-01-06 10:39:08',NULL),(35,'frgrgsd',1.00,'CNY','2021-01-06 10:39:08',NULL),(35,'567',2.00,'USD','2021-01-06 10:39:08',NULL),(36,'dfefsf',1.00,'CNY','2021-01-06 10:40:50',NULL),(37,'drink',4.00,'CNY','2021-01-06 10:51:38',NULL),(38,'eefgewf',2.00,'CNY','2021-01-06 11:07:22',NULL),(38,'343435',2.00,'INR','2021-01-06 11:07:22',NULL),(39,'wefe',1.00,'CNY','2021-01-06 11:08:20',NULL),(40,'dssffds',12.00,'CNY','2021-01-06 11:11:16',NULL),(41,'213231',1.00,'CNY','2021-01-06 11:20:13',NULL),(42,'ertetaewtw',2.00,'CNY','2021-01-06 18:17:26',NULL),(43,'df',13.00,'CNY','2021-02-24 12:36:32',NULL),(44,'hi',100.00,'INR','2022-06-15 07:07:45',NULL),(45,'hi',100.00,'INR','2022-06-15 07:07:54',NULL),(46,'hi',100.00,'INR','2022-06-15 07:08:00',NULL),(47,'hotel',5000.00,'CNY','2022-06-15 07:10:37',NULL),(48,'hotel',5000.00,'CNY','2022-06-15 07:10:51',NULL),(49,'hotel',5000.00,'CNY','2022-06-15 07:10:59',NULL);

--
-- Table structure for table `Expense_tax`
--

CREATE TABLE `Expense_tax` (
  `Expense_id` int(11) DEFAULT NULL,
  `Tax` decimal(10,2) DEFAULT NULL,
  `Tax_type` varchar(255) DEFAULT NULL,
  `created_on` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Expense_tax`
--

INSERT INTO `Expense_tax` VALUES (18,0.00,'CNY','2020-12-09 11:42:11',NULL),(19,10.00,'CNY','2020-12-09 15:14:10',NULL),(20,0.00,'CNY','2020-12-09 16:12:19',NULL),(21,0.00,'CNY','2020-12-10 17:23:04',NULL),(22,4.00,'HKD','2020-12-18 17:55:20',NULL),(22,5.00,'CNY','2020-12-18 17:55:20',NULL),(23,4.00,'HKD','2020-12-18 17:55:49',NULL),(23,5.00,'CNY','2020-12-18 17:55:49',NULL),(24,0.00,'CNY','2020-12-24 15:39:17',NULL),(25,0.00,'CNY','2020-12-25 14:11:09',NULL),(26,0.00,'CNY','2020-12-25 14:14:51',NULL),(27,0.00,'CNY','2020-12-25 14:15:33',NULL),(28,0.00,'CNY','2020-12-25 14:16:35',NULL),(29,1.00,'CNY','2020-12-28 14:47:41',NULL),(30,1.00,'CNY','2020-12-28 14:51:04',NULL),(30,5.00,'CNY','2020-12-28 14:51:04',NULL),(31,0.00,'CNY','2020-12-28 15:19:21',NULL),(32,1.00,'CNY','2020-12-28 15:24:36',NULL),(33,1.77,'CNY','2020-12-30 17:51:58',NULL),(33,2.00,'HKD','2020-12-30 17:51:58',NULL),(34,0.00,'CNY','2021-01-04 16:57:01',NULL),(35,1.00,'CNY','2021-01-06 10:39:08',NULL),(35,5.00,'USD','2021-01-06 10:39:08',NULL),(36,2.00,'CNY','2021-01-06 10:40:50',NULL),(37,2.00,'CNY','2021-01-06 10:51:38',NULL),(38,12.00,'CNY','2021-01-06 11:07:22',NULL),(39,1.00,'CNY','2021-01-06 11:08:20',NULL),(40,4.00,'CNY','2021-01-06 11:11:16',NULL),(41,22.00,'CNY','2021-01-06 11:20:13',NULL),(42,1.00,'CNY','2021-01-06 18:17:26',NULL),(43,2.00,'CNY','2021-02-24 12:36:32',NULL),(44,10.00,'CNY','2022-06-15 07:07:45',NULL),(45,10.00,'CNY','2022-06-15 07:07:54',NULL),(46,10.00,'CNY','2022-06-15 07:08:00',NULL),(47,10.00,'CNY','2022-06-15 07:10:37',NULL),(48,10.00,'CNY','2022-06-15 07:10:51',NULL),(49,10.00,'CNY','2022-06-15 07:10:59',NULL);

--
-- Table structure for table `images`
--

CREATE TABLE `images` (
  `image_id` int(11) NOT NULL AUTO_INCREMENT,
  `image_url` varchar(255) DEFAULT NULL,
  `description` text,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`image_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `images`
--

INSERT INTO `images` VALUES (15,'http://192.168.50.202:8082/uploads/20201209/9b17eb6701fdd8dade18e98dada6a45f.jpg',NULL,'2020-12-09 11:39:14',NULL),(16,'http://192.168.50.202:8082/uploads/20201209/cb4617e44c5682a630f2e76a13dd6f1d.jpg',NULL,'2020-12-09 11:40:21',NULL),(17,'http://192.168.50.202:8082/uploads/20201209/b4d8dd676482599b9a75660d606dc6bb.jpg',NULL,'2020-12-09 11:42:11',NULL),(18,'http://192.168.50.202:8082/uploads/20201209/731f724c17eedaf8cfe9ff41a203b02c.png',NULL,'2020-12-09 15:14:10',NULL),(19,'http://192.168.50.202:8082/uploads/20201209/b8298f90f28982d35298a98f2562e085.jpg',NULL,'2020-12-09 16:12:19',NULL),(20,'http://192.168.50.202:8082/uploads/20201210/d9dd1f27692d69010ef715c19a167cfc.jpg',NULL,'2020-12-10 17:23:04',NULL),(21,'http://192.168.50.202:8082/uploads/20201218/04b919da2d2539173d31aa1e6d7de703.jpg',NULL,'2020-12-18 17:55:20',NULL),(22,'http://192.168.50.202:8082/uploads/20201218/7b37274544cd6d959c13147b9185c059.jpg',NULL,'2020-12-18 17:55:20',NULL),(23,'http://192.168.50.202:8082/uploads/20201218/9b2f0b3903713cf09b96d523950e15c0.jpg',NULL,'2020-12-18 17:55:48',NULL),(24,'http://192.168.50.202:8082/uploads/20201218/606ed57c8d87fa236342259d16028013.jpg',NULL,'2020-12-18 17:55:48',NULL),(25,'http://192.168.50.202:8082/uploads/20201224/464d31a6b22f5268ebfe7d15efeecab6.jpg',NULL,'2020-12-24 15:39:17',NULL),(26,'http://192.168.50.202:8082/uploads/20201225/e640cc4b1b0e0e905dda2a90dd413447.jpg',NULL,'2020-12-25 14:11:09',NULL),(27,'http://192.168.50.202:8082/uploads/20201225/3c5de959a9ad706b9547c84827c6f88b.jpg',NULL,'2020-12-25 14:14:51',NULL),(28,'http://192.168.50.202:8082/uploads/20201225/05c0b90d59114ae4276d61fdbab40ad0.jpg',NULL,'2020-12-25 14:15:33',NULL),(29,'http://192.168.50.202:8082/uploads/20201225/11a9dc420542dcd383f8dc7c1db0dafb.jpg',NULL,'2020-12-25 14:16:35',NULL),(30,'http://192.168.50.202:8082/uploads/20201228/d3b32bc6fef1f1218409afe77d650f54.jpg',NULL,'2020-12-28 14:47:41',NULL),(31,'http://192.168.50.202:8082/uploads/20201228/232485cf9cdae6bf3c8c0babbcac76a8.jpg',NULL,'2020-12-28 14:51:04',NULL),(32,'http://192.168.50.202:8082/uploads/20201228/b696572f7dce26b4b44c7c3741a2f6cf.jpg',NULL,'2020-12-28 15:19:21',NULL),(33,'http://192.168.50.202:8082/uploads/20201228/7f2f2318c3a8b4136a0c4efb14258a31.jpg',NULL,'2020-12-28 15:24:36',NULL),(34,'http://192.168.50.202:8082/uploads/20201230/061431fe27aa03910af37832b6800f3d.jpg',NULL,'2020-12-30 17:51:58',NULL),(35,'http://192.168.50.202:8082/uploads/20210104/c0e03fee63c42fab89a2cc7967c20fcb.jpg',NULL,'2021-01-04 16:57:01',NULL),(36,'http://192.168.50.202:8082/uploads/20210106/9ded115c86badb52bcbc664411da4c55.jpg',NULL,'2021-01-06 10:39:08',NULL),(37,'http://192.168.50.202:8082/uploads/20210106/6cb2d9b551b22db6ff72144356908024.jpg',NULL,'2021-01-06 10:40:50',NULL),(38,'http://192.168.50.202:8082/uploads/20210106/f518cb79cd03aceb4a652491206ccc23.jpg',NULL,'2021-01-06 10:40:50',NULL),(39,'http://192.168.50.202:8082/uploads/20210106/6238a3349b1a9dd4e87a11e01ad38502.jpg',NULL,'2021-01-06 10:40:50',NULL),(40,'http://192.168.50.202:8082/uploads/20210106/d736b01810a4b3edef7db566f4d7e94c.jpg',NULL,'2021-01-06 10:51:38',NULL),(41,'http://192.168.50.202:8082/uploads/20210106/e92f66a36309e39ae88bdab7e6f13373.jpg',NULL,'2021-01-06 11:07:22',NULL),(42,'http://192.168.50.202:8082/uploads/20210106/acd56c8484568eff7ab27ef5ed736a9a.jpg',NULL,'2021-01-06 11:08:20',NULL),(43,'http://192.168.50.202:8082/uploads/20210106/5a5d9b9dbde89dbb0dd736a4ff3eeae1.jpg',NULL,'2021-01-06 11:11:16',NULL),(44,'http://192.168.50.202:8082/uploads/20210106/84ef700cca9b4c1ce39dd160db10ab49.jpg',NULL,'2021-01-06 11:20:13',NULL),(45,'http://192.168.50.202:8082/uploads/20210106/c238d4722c73ccbaa47aefd2b162f431.jpg',NULL,'2021-01-06 18:17:26',NULL),(46,'http://192.168.50.202:8082/uploads/20210224/1b76e27507e7cefb1d75085780ab1caf.jpg',NULL,'2021-02-24 12:36:32',NULL),(47,'http://45.76.160.28:5001/uploads/20220615/841886d20e6fa0ac71ea67bad3a013eb.png',NULL,'2022-06-15 07:07:45',NULL),(48,'http://45.76.160.28:5001/uploads/20220615/c31452affaefefa0e08bdb5349826a0e.png',NULL,'2022-06-15 07:07:54',NULL),(49,'http://45.76.160.28:5001/uploads/20220615/eed4b26a880ebe0e6f5316b7e254ecfd.png',NULL,'2022-06-15 07:08:00',NULL),(50,'http://45.76.160.28:5001/uploads/20220615/2d6605f582844419f28e8887c3e78a2b.jpeg',NULL,'2022-06-15 07:10:37',NULL),(51,'http://45.76.160.28:5001/uploads/20220615/b0ee7bb1d17db6d4dfaf5cb28b81ff38.jpeg',NULL,'2022-06-15 07:10:51',NULL),(52,'http://45.76.160.28:5001/uploads/20220615/0b3da73d584f8727af8cd97a991fefa0.jpeg',NULL,'2022-06-15 07:10:59',NULL);

--
-- Table structure for table `linkRoles`
--

CREATE TABLE `linkRoles` (
  `linkID` int(11) NOT NULL AUTO_INCREMENT,
  `staffID` int(11) NOT NULL,
  `roleID` int(11) NOT NULL,
  `nodeID` int(11) DEFAULT NULL,
  `approved_on` timestamp NULL DEFAULT NULL,
  `approved_by` int(11) DEFAULT NULL,
  `removed_on` timestamp NULL DEFAULT NULL,
  `removed_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`linkID`),
  KEY `staffID` (`staffID`),
  KEY `roleID` (`roleID`),
  CONSTRAINT `linkRoles_ibfk_1` FOREIGN KEY (`staffID`) REFERENCES `staffInfo` (`staffID`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `linkRoles_ibfk_2` FOREIGN KEY (`roleID`) REFERENCES `miscRoles` (`roleID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `linkRoles`
--

INSERT INTO `linkRoles` VALUES (1,57,10,NULL,NULL,NULL,NULL,NULL),(2,58,8,NULL,NULL,NULL,NULL,NULL),(3,100,2,NULL,NULL,NULL,NULL,NULL),(4,98,2,NULL,NULL,NULL,NULL,NULL),(5,97,5,NULL,NULL,NULL,NULL,NULL),(6,101,15,NULL,NULL,NULL,'2020-10-29 11:00:09',6),(7,7,5,NULL,NULL,NULL,NULL,NULL),(8,7,6,NULL,NULL,NULL,NULL,NULL),(9,45,8,NULL,NULL,NULL,NULL,NULL),(10,1,9,NULL,NULL,NULL,NULL,NULL),(11,2,7,NULL,NULL,NULL,NULL,NULL),(12,96,7,NULL,NULL,NULL,NULL,NULL),(13,102,15,NULL,NULL,NULL,NULL,NULL),(14,103,15,NULL,NULL,NULL,NULL,NULL),(15,99,11,NULL,NULL,NULL,NULL,NULL),(18,54,7,NULL,NULL,NULL,'2020-08-27 13:17:16',6),(19,54,1,NULL,NULL,NULL,NULL,NULL),(20,58,5,NULL,NULL,NULL,NULL,NULL),(26,101,2,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `miscRoles`
--

CREATE TABLE `miscRoles` (
  `roleID` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(10) NOT NULL DEFAULT 'Main',
  `name` varchar(100) NOT NULL,
  `departmentID` int(11) DEFAULT NULL,
  PRIMARY KEY (`roleID`),
  KEY `departmentID` (`departmentID`),
  CONSTRAINT `miscRoles_ibfk_1` FOREIGN KEY (`departmentID`) REFERENCES `miscDepartments` (`departmentID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `miscRoles`
--

INSERT INTO `miscRoles` VALUES (1,'Main','Social Media Intern',NULL),(2,'Main','Social Media Executive',NULL),(3,'Main','Content Writer',NULL),(4,'Main','Graphic Designer',NULL),(5,'Main','Social Media Manager',NULL),(6,'Main','Digital Media Manager ',NULL),(7,'Main','Subject Matter Expert\r',NULL),(8,'Main','CEO\r',NULL),(9,'Main','COO',NULL),(10,'Main','Campaign Manager\r',NULL),(11,'Main','SEO',NULL),(12,'Main','Film Content Manager',NULL),(13,'Main','Channel Manager',NULL),(14,'Main','Platform Manager',NULL),(15,'Main','Digital Media Executive',NULL);

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `notification_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `Approval_user_id` int(11) DEFAULT NULL,
  `status` int(11) NOT NULL DEFAULT '0',
  `Expense_id` int(11) DEFAULT NULL,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` VALUES (31,101,58,1,17,'2020-12-23 18:09:14',NULL),(32,101,58,0,16,'2020-12-24 11:29:27',NULL),(33,101,58,0,18,'2020-12-24 11:29:27',NULL),(34,101,58,0,21,'2020-12-24 11:29:27',NULL),(35,101,58,0,22,'2020-12-28 14:18:10',NULL),(36,101,58,0,23,'2020-12-28 14:18:10',NULL),(37,101,1,0,30,'2020-12-28 15:19:50',NULL),(38,101,1,0,32,'2020-12-28 17:42:46',NULL),(39,101,58,0,33,'2021-01-04 16:06:44',NULL),(40,101,58,0,37,'2021-01-06 10:51:57',NULL),(41,101,58,1,36,'2021-01-06 10:52:09',NULL),(42,101,58,0,35,'2021-01-06 10:52:11',NULL),(43,101,58,0,40,'2021-01-06 11:11:21',NULL),(44,101,1,0,41,'2021-01-07 15:26:39',NULL),(45,101,58,0,37,'2021-01-07 15:26:54',NULL),(46,101,58,0,33,'2021-01-07 15:26:56',NULL),(47,101,58,0,36,'2021-01-07 15:26:58',NULL),(48,57,1,0,34,'2021-01-15 16:03:30',NULL),(49,101,58,0,38,'2021-01-15 16:03:30',NULL),(50,101,101,0,39,'2021-01-15 16:03:30',NULL),(51,58,1,0,42,'2021-01-15 16:03:30',NULL),(52,58,1,0,43,'2022-06-06 08:46:38',NULL),(53,57,58,0,35,'2022-06-06 09:15:54',NULL),(54,58,6,0,49,'2022-06-15 07:45:51',NULL);

--
-- Table structure for table `salary`
--

CREATE TABLE `salary` (
  `salary_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `gross_salary` int(11) DEFAULT NULL,
  `gross_salary_currency` varchar(255) DEFAULT NULL,
  `net_salary` int(11) DEFAULT NULL,
  `net_salary_currency` varchar(255) DEFAULT NULL,
  `payment_day` timestamp NULL DEFAULT NULL,
  `starts_on` timestamp NULL DEFAULT NULL,
  `ends_on` timestamp NULL DEFAULT NULL,
  `added_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `removed_on` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`salary_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `salary`
--

INSERT INTO `salary` VALUES (18,57,123,'INR',12,'INR','2021-09-18 00:00:00','2021-05-23 00:00:00','2021-12-12 00:00:00','2021-03-03 16:17:42',NULL),(19,57,123,'INR',123,'INR','2012-08-12 00:00:00','2021-12-05 00:00:00','2021-12-05 00:00:00','2021-03-03 17:21:35',NULL),(20,6,1,'INR',123,'INR','2012-04-12 00:00:00','2021-12-12 00:00:00','2021-12-12 00:00:00','2021-03-05 17:55:54',NULL),(21,2,125,'INR',123,'INR','2021-03-12 00:00:01','2021-03-12 00:00:00','2021-03-12 00:00:00','2021-03-12 11:02:34',NULL),(22,57,1,'INR',1,'INR','2021-03-01 00:00:00','2021-03-02 00:00:00','2021-03-03 00:00:00','2021-03-12 11:04:48',NULL),(23,1,0,'CNY',0,'CNY','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','2022-06-07 05:00:16',NULL),(24,102,123,'INR',123,'INR','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','2022-06-07 05:00:41',NULL),(25,1,0,'INR',0,'INR','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','2022-06-15 06:58:42',NULL),(26,1,0,'INR',0,'INR','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','2022-06-15 07:22:21',NULL),(27,1,0,'INR',0,'INR','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','2022-06-15 07:23:10',NULL);

--
-- Table structure for table `staffInfo`
--

CREATE TABLE `staffInfo` (
  `staffID` int(10) NOT NULL AUTO_INCREMENT,
  `memberID` int(10) DEFAULT NULL,
  `departmentID` int(11) DEFAULT NULL,
  `clearanceLevel` int(11) NOT NULL DEFAULT '1' COMMENT '1 - intern level, 2 - employee level, 3 - head level, 4 - high head level, 5 - admin level',
  `firstName` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
  `middleName` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
  `lastName` varchar(50) CHARACTER SET utf8mb4 NOT NULL,
  `email` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `phoneNumber` varchar(20) CHARACTER SET latin1 DEFAULT NULL,
  `city` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `state` varchar(50) CHARACTER SET latin1 DEFAULT NULL,
  `country` varchar(30) CHARACTER SET latin1 DEFAULT NULL,
  `avatar` varchar(150) CHARACTER SET utf8mb4 DEFAULT NULL,
  `planned` int(10) DEFAULT NULL,
  `joinDate` date DEFAULT NULL,
  `leaveDate` date DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `functionalManager` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `locationManager` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `removed_By` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `removed_On` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
  `photo_id` int(11) DEFAULT NULL,
  `birthDate` varchar(11) COLLATE utf8mb4_bin DEFAULT NULL,
  PRIMARY KEY (`staffID`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `staffInfo`
--

INSERT INTO `staffInfo` VALUES (1,28,4,5,'Jose','Pietro','Aparicio','drpietroaparicio@72dragons.com','+1 (917)-541-8663','New York','New York','USA','pietro-aparicio-f2g5g.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,30,2,4,'Will','Cai','Jiawei','willtsai@thedragonyeargallery.com','','Shenzhen',NULL,'China','will-jiawei-f821f.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,25,3,3,'Antonio',NULL,'Ho','antonioho@72dragons.com','+852 9125-3712','',NULL,'Hong Kong','antonio-ho-sin2t.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(4,24,5,2,'Hilda','Isabel','Aparicio','hildaaparicio@72dragons.com','+1 (646) 334-4487','',NULL,'Honduras','hilda-aparicio-fn2ig.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(6,NULL,NULL,5,'David',NULL,'Moreno',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,27,7,4,'Nagesh',NULL,'Anjayya','nageshanjayya@72dragons.com','+91 99202 31867','Mumbai',NULL,'India','nagesh-anjayya-op3fg.jpg',NULL,NULL,NULL,NULL,'45','45',NULL,NULL,NULL,NULL),(8,23,8,0,'Vinay',NULL,'Yadad','vinayy17@yahoo.com','+91 97312 37661','Bangalore',NULL,'India','vinay-yadad-dsgwg.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(9,0,6,0,'Mimi',NULL,'Mutesa','mimimutesa@gmail.com','+1 (917)-957-1878','',NULL,'Uganda','mimi-mutesa-2ngnw.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(10,22,10,0,'Kelly','Kendall','Burns','kelly_burns@emerson.edu','+1 (970)-333-0701','Boston',NULL,'USA','kelly-burns-hen84.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(11,20,11,0,'Jiaxin',NULL,'Liu','x1aoji@hotmail.com','+86 13632831250','Shenzhen',NULL,'China','shane-liu-fin2g.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(12,0,7,0,'Hayley',NULL,'Broderick','broderickhayley@yahoo.com','+1 508-243-5282','',NULL,'USA','hayley-broderick-3gj9w.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(13,0,13,1,'Mingyu',NULL,'Yang','my2545@columbia.edu','+1 (917)-853-8593','',NULL,'China','mingyu-yang-f429g.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(14,0,13,1,'Yu',NULL,'Su','Yu.su@columbia.edu','+1 (917)-900-7192','New York','New York','USA','yu-su-42ggw.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(15,21,9,4,'Jimmy',NULL,'Zhong','jimmyzhong@72dragons.com','+86 15919820669','Shenzhen',NULL,'China','jimmy-zhong-gn2g2.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(17,0,7,1,'Alice',NULL,'Millar','alicemillar@72dragons.com','+1 (917)-348-6770','New York','New York','United Kingdom','alice-millar-2ggw4.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(18,9,1,0,'Spoorthi',NULL,'Ullal','spoorthiullalp@gmail.com','','New York','New York','USA','spoorthi-ullal-f3gnf.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(20,0,6,1,'Jen',NULL,'Kang','','','Seoul',NULL,'Korea','jen-kang-pkmfm.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(21,0,12,1,'Serena',NULL,'Schlegel','sdschlegel@gmail.com','+1 (919)-869-9798','Grand Rapids','Michigan','USA','serena-schlegal-gni2g.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(22,0,13,1,'Shijie',NULL,'Zhou','sz2670@columbia.edu','9172871526','',NULL,'China','shijie-zhou-2gnog.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(23,0,5,1,'Suri',NULL,'Peng','suri9898@hotmail.com','+1 (347)-414-1547','New York','New York','USA','suri-peng-9gnvi.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(24,0,10,1,'Isabel',NULL,'Kingsepp','isabel.kingsepp@gmail.com','','Boston','Massachusetts','USA','isabel-kingsepp-g2nig.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(25,0,9,1,'Sebastian',NULL,'Suarez','sebastianandressuarez@yahoo.com','+1 (864)-201-0745','',NULL,'USA','sebastian-suarez-g3nig.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(26,0,5,1,'Winnie',NULL,'Yao','winie@thedragonyeargallery.com','','',NULL,'United Kingdom','winnie-yao-2ghhg.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(27,0,6,1,'Molly',NULL,'Ling','molly@thedragonyeargallery.com','','Paris',NULL,'France','molly-ling-m2nif.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(28,0,7,1,'Enrique',NULL,'Medrano','','','',NULL,'Puerto Rico','enrique-medrano-gm2of.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(29,0,7,1,'Sanders',NULL,'Aparicio','','','Tegucigalpa',NULL,'Honduras','sanders-aparicio-ff8sf.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(31,0,11,0,'Yolanda',NULL,'Chow','yolandayay@gmail.com','+852 5107-1248','',NULL,'Hong Kong','yolanda-chow-2gj9g.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(32,0,13,1,'Shan',NULL,'Guan','sg3506@columbia.edu','+1 (917)-513-6389','New York','New York','United States','shan-guan-gnitg.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(33,0,5,1,'Weiwei',NULL,'Zhang','','','Shenzhen',NULL,'China','weiwei-zhang-gntgt.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(34,0,12,1,'Crystal',NULL,'Zhang','','','Shenzhen',NULL,'China','crystal-zhang-3ngjg.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(35,0,5,1,'Xiaoyun',NULL,'Liu','','','Shenzhen',NULL,'China','xiaoyun-liu-dopow.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(36,0,5,1,'Penny',NULL,'Peng','','','Shenzhen',NULL,'China','penny-peng-fi2er.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(37,0,6,1,'Maddi',NULL,'Ekeblad','madeleine@omsa.com.au','','',NULL,'Australia','maddi-ekeblad-pqkgj.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(38,0,13,1,'Yi',NULL,'Chen','yc3356@columbia.edu','','New York','New York','USA','yi-chen-mwfff.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(39,0,6,1,'Joshua',NULL,'Perez','perezjoshua57@gmail.com','','',NULL,'','joshua-perez-fiwin.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(40,0,13,1,'Lanyi',NULL,'Dai','ld2716@columbia.edu','6462362599','',NULL,'China','lanyi-dai-pqkdj.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(41,0,7,0,'Susan',NULL,'Morgan','','','',NULL,'','susan-morgan-gniwr.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(42,0,7,1,'Nicole',NULL,'Garbellini','','','',NULL,'','nicole-garbellini-2ni2f.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(43,0,13,1,'Guyu',NULL,'Zhang','','','',NULL,'USA','guyu-zhang-1fifn.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(45,13,1,5,'Bradley','','Miller','Bradleycmiller@72dragons.com','+852 92675619','Hong Kong',NULL,'Hong Kong','bradley-miller-fwijo.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(46,0,5,1,'Superman',NULL,' .','','','',NULL,'','superman-sdadd.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(47,51,1,1,'Dulce',NULL,'Aparicio','dulceepereira@gmail.com','','New York','New York','United States','dulce-aparicio-1dk32.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(48,50,1,1,'Akshay',NULL,'Rane','arane02@nyit.edu','','Jersey City','New Jersey','United States','akshay-rane-fgwn2.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(49,0,1,0,'Andrew',NULL,'Hwang','hwang.andrew.96@gmail.com','','East Lansing','Michigan','United States','andrew-hwang-asfaf.jpeg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(50,52,1,1,'Darshan','Kiritbhai','Patel','dpate246@nyit.edu','','-','New Jersey','United States','darshan-patel-12hri.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(51,0,0,1,'Pithadia',NULL,'Pritee','pritu.rp@gmail.com','','New York','New York','USA','pithadia-pritee-fnjod.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(52,54,1,1,'Fake','Staff','Member','fakeemail@email.com',NULL,'Nowhere',NULL,'USA','unknown.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(53,NULL,1,2,'Siddharth',NULL,'Padwal','siddharthpadwal3@gmail.com',NULL,'Mumbai',NULL,'India','siddharth-padwal-32fs.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(54,60,1,5,'Yun','Shang','Yin','yinly1113@163.com','+86 17375835669','Shenzhen',NULL,'China','avatar-wWhDJ.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,61,1,5,'Liu',NULL,'Qi','',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(57,59,1,5,'ZePeng','','Ma','',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,'6','2',NULL,NULL,NULL,NULL),(58,62,1,5,'Saihao',NULL,'Chen','',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,58,1,5,'xunhuang',NULL,'Duan','',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(87,83,1,1,'训煌',NULL,'段','1763604360@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(89,87,0,1,'沛',NULL,'徐','1143576150@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(90,88,0,1,'金阳',NULL,'李','1193366212@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(91,89,0,1,'东东',NULL,'焦','1094098346@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(92,90,0,1,'康雨',NULL,'林','2218479476@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(93,91,0,1,'战宇',NULL,'丁','1515338240@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(94,92,0,1,'尚文',NULL,'谢','1208019553@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(95,94,0,1,'Jianfeng',NULL,'Cheng','1404974688@qq.com',NULL,'',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(96,NULL,NULL,1,'Jazeela',NULL,'Basheer',NULL,NULL,'Mumbai',NULL,NULL,'Jazeela.jpg',NULL,NULL,NULL,NULL,'7','7',NULL,NULL,NULL,NULL),(97,97,NULL,1,'Purvi',NULL,'Sharma',NULL,NULL,'Mumbai',NULL,NULL,'Purvi.jpg',NULL,NULL,NULL,NULL,'7','7',NULL,NULL,NULL,NULL),(98,NULL,NULL,1,'Amit',NULL,'Mishra',NULL,NULL,'Mumbai',NULL,NULL,'Amit.png',NULL,NULL,NULL,NULL,'7','7',NULL,NULL,NULL,NULL),(99,NULL,NULL,1,'Amit',NULL,'Karambaikar',NULL,NULL,'Mumbai',NULL,NULL,'Amit K.png',NULL,NULL,NULL,NULL,'7','7',NULL,NULL,NULL,NULL),(100,100,NULL,1,'Harshitha',NULL,'Polamarasetti',NULL,NULL,'Mumbai',NULL,NULL,'Harshita.jpg',NULL,NULL,NULL,NULL,'7','7',NULL,NULL,NULL,NULL),(101,101,NULL,1,'Sahil',NULL,'Sood',NULL,NULL,'Mumbai',NULL,NULL,'Sahil.jpg',NULL,NULL,NULL,NULL,'7','7',NULL,NULL,NULL,NULL),(102,NULL,NULL,1,'Brook',NULL,'Cai',NULL,NULL,'Shenzhen',NULL,NULL,'Brooke.jpg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,NULL,NULL,1,'Jenny',NULL,'Wang',NULL,NULL,'Shenzhen',NULL,NULL,'Jenny.png',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);


