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


--
-- Table structure for table `ADP`
--

CREATE TABLE `ADP` (
  `ADP_id` int(11) NOT NULL AUTO_INCREMENT,
  `ADP` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `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 (`ADP_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `ADP`
--

INSERT INTO `ADP` VALUES (21,'72766',213,'INR','2021-12-25 00:00:00','2021-12-25 00:00:00','2021-12-25 00:00:00','2021-03-11 15:49:02',NULL);

--
-- Table structure for table `Electric_Bill`
--

CREATE TABLE `Electric_Bill` (
  `Electric_Bill_id` int(11) NOT NULL AUTO_INCREMENT,
  `Electric_Bill` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `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 (`Electric_Bill_id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Electric_Bill`
--

INSERT INTO `Electric_Bill` VALUES (21,'7212',123,'INR','2021-12-24 00:00:00','2021-12-24 00:00:00','2021-12-24 00:00:00','2021-03-11 15:52:09',NULL);

--
-- 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=6 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `Expense` VALUES (1,57,'demos',2,'161.04','CNY',NULL,0,NULL,NULL,0,NULL,'2022-07-22','UTC+5.5','Shenzhen',NULL,NULL,'2022-07-04 07:20:49','2022-07-04 09:19:38'),(2,57,'dff',1,'2.00','CNY',NULL,0,NULL,NULL,0,NULL,'2022-07-19','UTC+5.5','Shenzhen',NULL,NULL,'2022-07-04 08:20:24','2022-07-04 09:59:48'),(3,57,'same',1,'2.00','CNY',NULL,0,NULL,NULL,0,NULL,'2022-07-13','UTC+5.5','Shenzhen',NULL,NULL,'2022-07-04 09:46:44','2022-07-04 09:59:43'),(4,57,'demo',1,'2.00','CNY',NULL,2,'2022-07-04 21:13:08','Haha 1',2,'2022-07-04 21:13:08','2022-07-20','UTC+5.5','Shenzhen',57,'2022-07-04 21:13:08','2022-07-04 10:00:12',NULL),(5,57,'same',58,'2.00','CNY',NULL,2,'2022-07-04 18:02:03','ffdfdfd',2,'2022-07-04 18:02:03','2022-07-26','UTC+5.5','Shenzhen',57,'2022-07-04 18:02:03','2022-07-04 10:00:34','2022-07-04 13:08:53');

--
-- 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 (1,2,'2022-07-04 07:20:49',NULL),(2,3,'2022-07-04 08:20:24',NULL),(3,4,'2022-07-04 09:46:44',NULL),(4,5,'2022-07-04 10:00:12',NULL),(5,6,'2022-07-04 10:00:34',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 (1,'as',2.00,'USD','2022-07-04 07:28:47',NULL),(2,'d',1.00,'CNY','2022-07-04 08:20:24',NULL),(3,'d',1.00,'CNY','2022-07-04 09:46:44',NULL),(4,'item',1.00,'CNY','2022-07-04 10:00:12',NULL),(5,'ite',1.00,'CNY','2022-07-04 12:49:01',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 (1,21.00,'USD','2022-07-04 07:28:47',NULL),(1,1.00,'USD','2022-07-04 07:28:47',NULL),(2,1.00,'CNY','2022-07-04 08:20:24',NULL),(3,1.00,'CNY','2022-07-04 09:46:44',NULL),(4,1.00,'CNY','2022-07-04 10:00:12',NULL),(5,1.00,'CNY','2022-07-04 12:49:01',NULL);

--
-- Table structure for table `Internet_Bill`
--

CREATE TABLE `Internet_Bill` (
  `Internet_Bill_id` int(11) NOT NULL AUTO_INCREMENT,
  `Internet_Bill` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `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 (`Internet_Bill_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Internet_Bill`
--

INSERT INTO `Internet_Bill` VALUES (21,'5466',123,'INR','2021-12-21 00:00:00','2021-12-21 00:00:00','2021-12-21 00:00:00','2021-03-11 15:57:01',NULL),(22,'速度',48,'INR','2021-03-25 00:00:00','2021-03-25 00:00:00','2021-03-25 00:00:00','2021-03-12 10:58:13',NULL);

--
-- Table structure for table `Office`
--

CREATE TABLE `Office` (
  `Office_id` int(11) NOT NULL AUTO_INCREMENT,
  `Office` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `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 (`Office_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Office`
--

INSERT INTO `Office` VALUES (21,'shuxiaow2',12,'INR','2020-12-30 00:00:00','2021-12-14 00:00:00','2020-02-12 00:00:00','2021-03-11 15:45:07',NULL),(22,'72',2,'INR','2021-12-30 00:00:00','2020-12-30 00:00:00','2021-12-31 00:00:00','2021-03-12 11:35:42',NULL),(23,'72',2,'INR','2021-02-12 00:00:00','2021-02-12 00:00:00','2021-02-12 00:00:00','2021-03-12 11:36:56',NULL),(24,'速度',3,'INR','2021-03-21 00:00:00','2021-03-21 00:00:00','2021-03-21 00:00:00','2021-03-12 11:37:28',NULL),(25,'速度',6,'INR','2021-02-12 00:00:00','2021-02-12 00:00:00','2021-02-12 00:00:00','2021-03-12 11:38:44',NULL),(26,'速度',4,'INR','2021-02-02 00:00:01','2021-02-01 00:00:00','2021-02-01 00:00:00','2021-03-12 11:40:05',NULL);

--
-- Table structure for table `Server_Bills`
--

CREATE TABLE `Server_Bills` (
  `Server_Bills_id` int(11) NOT NULL AUTO_INCREMENT,
  `Server_Bills` varchar(255) DEFAULT NULL,
  `amount` int(11) DEFAULT NULL,
  `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 (`Server_Bills_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `Server_Bills`
--

INSERT INTO `Server_Bills` VALUES (21,'Server_Bills',110,'CNY',NULL,NULL,NULL,'2021-03-09 16:07:03',NULL),(22,'速度',159,'CNY','2012-12-12 00:00:00','2012-12-12 00:00:00','2012-12-12 00:00:00','2021-03-09 16:26:11',NULL),(23,'shuxiaoxia',125,'INR','2021-12-25 00:00:00','2021-02-21 00:00:00','2021-02-21 00:00:00','2021-03-12 10:54:49',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=7 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `images` VALUES (1,'http://45.76.160.28:5004/tp5/public/uploads/20220704/1bf36ce11879f5f24416ff9cb87197b2.jpg',NULL,'2022-07-04 07:20:49',NULL),(2,'http://45.76.160.28:5004/tp5/public/uploads/20220704/sy(: &[q.b.jpg',NULL,'2022-07-04 07:25:33',NULL),(3,'http://45.76.160.28:5004/tp5/public/uploads/20220704/b1c653eeafed788d80c0ff9f253bb941.jpg',NULL,'2022-07-04 08:20:24',NULL),(4,'http://45.76.160.28:5004/tp5/public/uploads/20220704/70eb07836d42fa9b61c9e14bb61af6af.jpg',NULL,'2022-07-04 09:46:44',NULL),(5,'http://45.76.160.28:5004/tp5/public/uploads/20220704/7c3de57d8cce807bea04b0c3558c5eb7.jpg',NULL,'2022-07-04 10:00:12',NULL),(6,'http://45.76.160.28:5004/tp5/public/uploads/20220704/92b51d73d71fce29f9e4cdfc0cfc43f9.jpg',NULL,'2022-07-04 10:00:34',NULL);

--
-- Table structure for table `insurance_Taxes`
--

CREATE TABLE `insurance_Taxes` (
  `insurance_Taxes_id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_id` int(11) NOT NULL,
  `insurance_Taxes` varchar(255) NOT NULL,
  `amount` int(11) DEFAULT NULL,
  `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 (`insurance_Taxes_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `insurance_Taxes`
--

INSERT INTO `insurance_Taxes` VALUES (21,98,'速度',123,'INR','2021-12-25 08:00:00','2012-12-25 00:00:00','2012-12-25 00:00:00','2021-03-11 16:03:32',NULL),(22,2,'72',12,'INR','2021-03-10 00:00:00','2021-03-10 00:00:00','2021-03-10 00:00:00','2021-03-12 10:37:11',NULL),(23,103,'shuxiaoxia',258,'INR','2021-03-25 00:00:00','2021-03-25 00:00:00','2021-03-25 00:00:00','2021-03-12 10:58:57',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=29 DEFAULT CHARSET=latin1;

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

INSERT INTO `linkRoles` VALUES (1,57,10,NULL,NULL,NULL,NULL,NULL),(2,58,10,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),(26,101,2,NULL,NULL,NULL,NULL,NULL),(27,57,5,NULL,NULL,NULL,NULL,NULL),(28,58,5,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=3 DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `notification` VALUES (1,57,1,0,5,'2022-07-04 12:48:37',NULL),(2,57,58,0,5,'2022-07-04 12:49:09',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 DEFAULT CHARSET=utf8mb4;

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


--
-- 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','Shenzhen',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','Shenzhen',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','Shenzhen',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','Shenzhen',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','Shenzhen',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','Shenzhen',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','Shenzhen',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','','Shenzhen',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','','','Shenzhen',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','Shenzhen',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','','Shenzhen',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','','Shenzhen',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','Shenzhen',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','','','Shenzhen',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','','','Shenzhen',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','','','Shenzhen',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,' .','','','Shenzhen',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,'Shenzhen',NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2020-06-09 21:39:26',NULL,NULL),(57,59,1,5,'ZePeng','','Ma','',NULL,'Shenzhen',NULL,'','',NULL,NULL,NULL,NULL,'6','2',NULL,NULL,NULL,NULL),(58,62,1,5,'Saihao',NULL,'Chen','',NULL,'Shenzhen',NULL,'','',NULL,NULL,NULL,NULL,'58','58',NULL,NULL,NULL,NULL),(59,58,1,5,'xunhuang',NULL,'Duan','',NULL,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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,'Shenzhen',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);


