sql_db_dummy.sql

-- --------------------------------------------------------
-- 호스트:                          127.0.0.1
-- 서버 버전:                        10.5.4-MariaDB-1:10.5.4+maria~focal - mariadb.org binary distribution
-- 서버 OS:                        debian-linux-gnu
-- HeidiSQL 버전:                  11.0.0.5919
-- --------------------------------------------------------

/*!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' */;


-- spots 데이터베이스 구조 내보내기
DROP DATABASE IF EXISTS `spots`;
CREATE DATABASE IF NOT EXISTS `spots` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
USE `spots`;

-- 테이블 spots.apply_team 구조 내보내기
DROP TABLE IF EXISTS `apply_team`;
CREATE TABLE IF NOT EXISTS `apply_team` (
  `team_uid` int(11) DEFAULT NULL,
  `user_uid` int(11) DEFAULT NULL,
  `comment` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='팀 신청';

-- 테이블 데이터 spots.apply_team:~2 rows (대략적) 내보내기
DELETE FROM `apply_team`;
/*!40000 ALTER TABLE `apply_team` DISABLE KEYS */;
INSERT INTO `apply_team` (`team_uid`, `user_uid`, `comment`) VALUES
	(61, 1, '가입신청'),
	(53, 102, 'asdasd');
/*!40000 ALTER TABLE `apply_team` ENABLE KEYS */;

-- 테이블 spots.city_code 구조 내보내기
DROP TABLE IF EXISTS `city_code`;
CREATE TABLE IF NOT EXISTS `city_code` (
  `city_code` varchar(50) NOT NULL,
  `city_name` varchar(50) NOT NULL,
  PRIMARY KEY (`city_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='도코드';

-- 테이블 데이터 spots.city_code:~218 rows (대략적) 내보내기
DELETE FROM `city_code`;
/*!40000 ALTER TABLE `city_code` DISABLE KEYS */;
INSERT INTO `city_code` (`city_code`, `city_name`) VALUES
	('1111000000', '종로구'),
	('1114000000', '중구'),
	('1117000000', '용산구'),
	('1120000000', '성동구'),
	('1123000000', '동대문구'),
	('1126000000', '중랑구'),
	('1129000000', '성북구'),
	('1132000000', '도봉구'),
	('1135000000', '노원구'),
	('1138000000', '은평구'),
	('1141000000', '서대문구'),
	('1144000000', '마포구'),
	('1147000000', '양천구'),
	('1150000000', '강서구'),
	('1153000000', '구로구'),
	('1156000000', '영등포구'),
	('1159000000', '동작구'),
	('1162000000', '관악구'),
	('1165000000', '서초구'),
	('1168000000', '강남구'),
	('1171000000', '송파구'),
	('1174000000', '강동구'),
	('2611000000', '중구'),
	('2614000000', '서구'),
	('2617000000', '동구'),
	('2620000000', '영도구'),
	('2623000000', '부산진구'),
	('2626000000', '동래구'),
	('2629000000', '남구'),
	('2632000000', '북구'),
	('2635000000', '해운대구'),
	('2638000000', '사하구'),
	('2641000000', '금정구'),
	('2644000000', '강서구'),
	('2647000000', '연제구'),
	('2650000000', '수영구'),
	('2653000000', '사상구'),
	('2671000000', '기장군'),
	('2711000000', '중구'),
	('2714000000', '동구'),
	('2717000000', '서구'),
	('2720000000', '남구'),
	('2723000000', '북구'),
	('2726000000', '수성구'),
	('2729000000', '달서구'),
	('2771000000', '달성군'),
	('2811000000', '중구'),
	('2814000000', '동구'),
	('2820000000', '남동구'),
	('2826000000', '서구'),
	('2871000000', '강화군'),
	('2872000000', '옹진군'),
	('2911000000', '동구'),
	('2914000000', '서구'),
	('2917000000', '북구'),
	('2920000000', '광산구'),
	('3011000000', '동구'),
	('3014000000', '중구'),
	('3017000000', '서구'),
	('3020000000', '유성구'),
	('3023000000', '대덕구'),
	('3111000000', '중구'),
	('3114000000', '남구'),
	('3117000000', '동구'),
	('3120000000', '북구'),
	('3171000000', '울주군'),
	('4111000000', '수원시'),
	('4113000000', '성남시'),
	('4115000000', '의정부시'),
	('4117000000', '안양시'),
	('4119000000', '부천시'),
	('4121000000', '광명시'),
	('4122000000', '평택시'),
	('4125000000', '동두천시'),
	('4127000000', '안산시'),
	('4128000000', '고양시'),
	('4129000000', '과천시'),
	('4131000000', '구리시'),
	('4136000000', '남양주시'),
	('4137000000', '오산시'),
	('4139000000', '시흥시'),
	('4141000000', '군포시'),
	('4143000000', '의왕시'),
	('4145000000', '하남시'),
	('4146000000', '용인시'),
	('4148000000', '파주시'),
	('4150000000', '이천시'),
	('4155000000', '안성시'),
	('4157000000', '김포시'),
	('4159000000', '화성시'),
	('4161000000', '광주시'),
	('4163000000', '양주시'),
	('4165000000', '포천시'),
	('4167000000', '여주시'),
	('4180000000', '연천군'),
	('4182000000', '가평군'),
	('4183000000', '양평군'),
	('4211000000', '춘천시'),
	('4213000000', '원주시'),
	('4215000000', '강릉시'),
	('4217000000', '동해시'),
	('4219000000', '태백시'),
	('4221000000', '속초시'),
	('4223000000', '삼척시'),
	('4272000000', '홍천군'),
	('4273000000', '횡성군'),
	('4275000000', '영월군'),
	('4276000000', '평창군'),
	('4277000000', '정선군'),
	('4278000000', '철원군'),
	('4279000000', '화천군'),
	('4280000000', '양구군'),
	('4281000000', '인제군'),
	('4282000000', '고성군'),
	('4283000000', '양양군'),
	('4311000000', '청주시'),
	('4313000000', '충주시'),
	('4315000000', '제천시'),
	('4372000000', '보은군'),
	('4373000000', '옥천군'),
	('4374000000', '영동군'),
	('4375000000', '진천군'),
	('4376000000', '괴산군'),
	('4377000000', '음성군'),
	('4380000000', '단양군'),
	('4413000000', '천안시'),
	('4415000000', '공주시'),
	('4418000000', '보령시'),
	('4420000000', '아산시'),
	('4421000000', '서산시'),
	('4423000000', '논산시'),
	('4425000000', '계룡시'),
	('4427000000', '당진시'),
	('4471000000', '금산군'),
	('4476000000', '부여군'),
	('4477000000', '서천군'),
	('4479000000', '청양군'),
	('4480000000', '홍성군'),
	('4481000000', '예산군'),
	('4511000000', '전주시'),
	('4513000000', '군산시'),
	('4514000000', '익산시'),
	('4518000000', '정읍시'),
	('4519000000', '남원시'),
	('4521000000', '김제시'),
	('4571000000', '완주군'),
	('4572000000', '진안군'),
	('4573000000', '무주군'),
	('4574000000', '장수군'),
	('4575000000', '임실군'),
	('4577000000', '순창군'),
	('4579000000', '고창군'),
	('4580000000', '부안군'),
	('4611000000', '목포시'),
	('4613000000', '여수시'),
	('4615000000', '순천시'),
	('4617000000', '나주시'),
	('4623000000', '광양시'),
	('4671000000', '담양군'),
	('4672000000', '곡성군'),
	('4673000000', '구례군'),
	('4677000000', '고흥군'),
	('4678000000', '보성군'),
	('4679000000', '화순군'),
	('4680000000', '장흥군'),
	('4681000000', '강진군'),
	('4682000000', '해남군'),
	('4683000000', '영암군'),
	('4684000000', '무안군'),
	('4686000000', '함평군'),
	('4687000000', '영광군'),
	('4688000000', '장성군'),
	('4689000000', '완도군'),
	('4690000000', '진도군'),
	('4691000000', '신안군'),
	('4711000000', '포항시'),
	('4713000000', '경주시'),
	('4715000000', '김천시'),
	('4717000000', '안동시'),
	('4719000000', '구미시'),
	('4721000000', '영주시'),
	('4723000000', '영천시'),
	('4725000000', '상주시'),
	('4728000000', '문경시'),
	('4729000000', '경산시'),
	('4772000000', '군위군'),
	('4773000000', '의성군'),
	('4775000000', '청송군'),
	('4776000000', '영양군'),
	('4777000000', '영덕군'),
	('4782000000', '청도군'),
	('4783000000', '고령군'),
	('4784000000', '성주군'),
	('4785000000', '칠곡군'),
	('4790000000', '예천군'),
	('4792000000', '봉화군'),
	('4793000000', '울진군'),
	('4794000000', '울릉군'),
	('4812000000', '창원시'),
	('4817000000', '진주시'),
	('4822000000', '통영시'),
	('4824000000', '사천시'),
	('4825000000', '김해시'),
	('4827000000', '밀양시'),
	('4831000000', '거제시'),
	('4833000000', '양산시'),
	('4872000000', '의령군'),
	('4873000000', '함안군'),
	('4874000000', '창녕군'),
	('4882000000', '고성군'),
	('4884000000', '남해군'),
	('4885000000', '하동군'),
	('4886000000', '산청군'),
	('4887000000', '함양군'),
	('4888000000', '거창군'),
	('4889000000', '합천군'),
	('5011000000', '제주시'),
	('5013000000', '서귀포시');
/*!40000 ALTER TABLE `city_code` ENABLE KEYS */;

-- 테이블 spots.dong_code 구조 내보내기
DROP TABLE IF EXISTS `dong_code`;
CREATE TABLE IF NOT EXISTS `dong_code` (
  `dong_code` varchar(50) NOT NULL,
  `dong_name` varchar(50) NOT NULL,
  PRIMARY KEY (`dong_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='동코드';

-- 테이블 데이터 spots.dong_code:~3,547 rows (대략적) 내보내기
DELETE FROM `dong_code`;
/*!40000 ALTER TABLE `dong_code` DISABLE KEYS */;
INSERT INTO `dong_code` (`dong_code`, `dong_name`) VALUES
	('1111051500', '청운효자동'),
	('1111053000', '사직동'),
	('1111054000', '삼청동'),
	('1111055000', '부암동'),
	('1111056000', '평창동'),
	('1111057000', '무악동'),
	('1111058000', '교남동'),
	('1111060000', '가회동'),
	('1111061500', '종로1.2.3.4가동'),
	('1111063000', '종로5.6가동'),
	('1111064000', '이화동'),
	('1111065000', '혜화동'),
	('1111067000', '창신제1동'),
	('1111068000', '창신제2동'),
	('1111069000', '창신제3동'),
	('1111070000', '숭인제1동'),
	('1111071000', '숭인제2동'),
	('1114052000', '소공동'),
	('1114054000', '회현동'),
	('1114055000', '명동'),
	('1114057000', '필동'),
	('1114058000', '장충동'),
	('1114059000', '광희동'),
	('1114060500', '을지로동'),
	('1114061500', '신당동'),
	('1114062500', '다산동'),
	('1114063500', '약수동'),
	('1114064500', '청구동'),
	('1114065000', '신당제5동'),
	('1114066500', '동화동'),
	('1114067000', '황학동'),
	('1114068000', '중림동'),
	('1117051000', '후암동'),
	('1117052000', '용산2가동'),
	('1117053000', '남영동'),
	('1117055500', '청파동'),
	('1117056000', '원효로제1동'),
	('1117057000', '원효로제2동'),
	('1117058000', '효창동'),
	('1117059000', '용문동'),
	('1117062500', '한강로동'),
	('1117063000', '이촌제1동'),
	('1117064000', '이촌제2동'),
	('1117065000', '이태원제1동'),
	('1117066000', '이태원제2동'),
	('1117068500', '한남동'),
	('1117069000', '서빙고동'),
	('1117070000', '보광동'),
	('1120052000', '왕십리제2동'),
	('1120053500', '왕십리도선동'),
	('1120054000', '마장동'),
	('1120055000', '사근동'),
	('1120056000', '행당제1동'),
	('1120057000', '행당제2동'),
	('1120058000', '응봉동'),
	('1120059000', '금호1가동'),
	('1120061500', '금호2.3가동'),
	('1120062000', '금호4가동'),
	('1120064500', '옥수동'),
	('1120065000', '성수1가제1동'),
	('1120066000', '성수1가제2동'),
	('1120067000', '성수2가제1동'),
	('1120069000', '성수2가제3동'),
	('1120072000', '송정동'),
	('1120079000', '용답동'),
	('1121571000', '화양동'),
	('1121573000', '군자동'),
	('1121574000', '중곡제1동'),
	('1121575000', '중곡제2동'),
	('1121576000', '중곡제3동'),
	('1121577000', '중곡제4동'),
	('1121578000', '능동'),
	('1121581000', '광장동'),
	('1121582000', '자양제1동'),
	('1121583000', '자양제2동'),
	('1121584000', '자양제3동'),
	('1121584700', '자양제4동'),
	('1121585000', '구의제1동'),
	('1121586000', '구의제2동'),
	('1121587000', '구의제3동'),
	('1123053600', '용신동'),
	('1123054500', '제기동'),
	('1123056000', '전농제1동'),
	('1123057000', '전농제2동'),
	('1123060000', '답십리제1동'),
	('1123061000', '답십리제2동'),
	('1123065000', '장안제1동'),
	('1123066000', '장안제2동'),
	('1123070500', '청량리동'),
	('1123071000', '회기동'),
	('1123072000', '휘경제1동'),
	('1123073000', '휘경제2동'),
	('1123074000', '이문제1동'),
	('1123075000', '이문제2동'),
	('1126052000', '면목제2동'),
	('1126054000', '면목제4동'),
	('1126055000', '면목제5동'),
	('1126056500', '면목본동'),
	('1126057000', '면목제7동'),
	('1126057500', '면목제3.8동'),
	('1126058000', '상봉제1동'),
	('1126059000', '상봉제2동'),
	('1126060000', '중화제1동'),
	('1126061000', '중화제2동'),
	('1126062000', '묵제1동'),
	('1126063000', '묵제2동'),
	('1126065500', '망우본동'),
	('1126066000', '망우제3동'),
	('1126068000', '신내1동'),
	('1126069000', '신내2동'),
	('1129052500', '성북동'),
	('1129055500', '삼선동'),
	('1129057500', '동선동'),
	('1129058000', '돈암제1동'),
	('1129059000', '돈암제2동'),
	('1129060000', '안암동'),
	('1129061000', '보문동'),
	('1129062000', '정릉제1동'),
	('1129063000', '정릉제2동'),
	('1129064000', '정릉제3동'),
	('1129065000', '정릉제4동'),
	('1129066000', '길음제1동'),
	('1129068500', '길음제2동'),
	('1129070500', '종암동'),
	('1129071500', '월곡제1동'),
	('1129072500', '월곡제2동'),
	('1129076000', '장위제1동'),
	('1129077000', '장위제2동'),
	('1129078000', '장위제3동'),
	('1129081000', '석관동'),
	('1130553400', '삼양동'),
	('1130553500', '미아동'),
	('1130554500', '송중동'),
	('1130555500', '송천동'),
	('1130557500', '삼각산동'),
	('1130559500', '번1동'),
	('1130560300', '번2동'),
	('1130560800', '번3동'),
	('1130561500', '수유1동'),
	('1130562500', '수유2동'),
	('1130563500', '수유3동'),
	('1130564500', '우이동'),
	('1130566000', '인수동'),
	('1132051100', '창제1동'),
	('1132051200', '창제2동'),
	('1132051300', '창제3동'),
	('1132051400', '창제4동'),
	('1132051500', '창제5동'),
	('1132052100', '도봉제1동'),
	('1132052200', '도봉제2동'),
	('1132066000', '쌍문제1동'),
	('1132067000', '쌍문제2동'),
	('1132068000', '쌍문제3동'),
	('1132068100', '쌍문제4동'),
	('1132069000', '방학제1동'),
	('1132070000', '방학제2동'),
	('1132071000', '방학제3동'),
	('1135056000', '월계1동'),
	('1135057000', '월계2동'),
	('1135058000', '월계3동'),
	('1135059500', '공릉1동'),
	('1135060000', '공릉2동'),
	('1135061100', '하계1동'),
	('1135061200', '하계2동'),
	('1135061900', '중계본동'),
	('1135062100', '중계1동'),
	('1135062400', '중계4동'),
	('1135062500', '중계2.3동'),
	('1135063000', '상계1동'),
	('1135064000', '상계2동'),
	('1135066500', '상계3.4동'),
	('1135067000', '상계5동'),
	('1135069500', '상계6.7동'),
	('1135070000', '상계8동'),
	('1135071000', '상계9동'),
	('1135072000', '상계10동'),
	('1138051000', '녹번동'),
	('1138052000', '불광제1동'),
	('1138053000', '불광제2동'),
	('1138055100', '갈현제1동'),
	('1138055200', '갈현제2동'),
	('1138056000', '구산동'),
	('1138057000', '대조동'),
	('1138058000', '응암제1동'),
	('1138059000', '응암제2동'),
	('1138060000', '응암제3동'),
	('1138062500', '역촌동'),
	('1138063100', '신사제1동'),
	('1138063200', '신사제2동'),
	('1138064000', '증산동'),
	('1138065000', '수색동'),
	('1138069000', '진관동'),
	('1141052000', '천연동'),
	('1141055500', '북아현동'),
	('1141056500', '충현동'),
	('1141058500', '신촌동'),
	('1141061500', '연희동'),
	('1141062000', '홍제제1동'),
	('1141064000', '홍제제3동'),
	('1141065500', '홍제제2동'),
	('1141066000', '홍은제1동'),
	('1141068500', '홍은제2동'),
	('1141069000', '남가좌제1동'),
	('1141070000', '남가좌제2동'),
	('1141071000', '북가좌제1동'),
	('1141072000', '북가좌제2동'),
	('1144055500', '아현동'),
	('1144056500', '공덕동'),
	('1144058500', '도화동'),
	('1144059000', '용강동'),
	('1144060000', '대흥동'),
	('1144061000', '염리동'),
	('1144063000', '신수동'),
	('1144065500', '서강동'),
	('1144066000', '서교동'),
	('1144068000', '합정동'),
	('1144069000', '망원제1동'),
	('1144070000', '망원제2동'),
	('1144071000', '연남동'),
	('1144072000', '성산제1동'),
	('1144073000', '성산제2동'),
	('1144074000', '상암동'),
	('1147051000', '목1동'),
	('1147052000', '목2동'),
	('1147053000', '목3동'),
	('1147054000', '목4동'),
	('1147055000', '목5동'),
	('1147056000', '신월1동'),
	('1147057000', '신월2동'),
	('1147058000', '신월3동'),
	('1147059000', '신월4동'),
	('1147060000', '신월5동'),
	('1147061000', '신월6동'),
	('1147061100', '신월7동'),
	('1147062000', '신정1동'),
	('1147063000', '신정2동'),
	('1147064000', '신정3동'),
	('1147065000', '신정4동'),
	('1147067000', '신정6동'),
	('1147068000', '신정7동'),
	('1150051000', '염창동'),
	('1150052000', '등촌제1동'),
	('1150053000', '등촌제2동'),
	('1150053500', '등촌제3동'),
	('1150054000', '화곡제1동'),
	('1150055000', '화곡제2동'),
	('1150056000', '화곡제3동'),
	('1150057000', '화곡제4동'),
	('1150059000', '화곡본동'),
	('1150059100', '화곡제6동'),
	('1150059300', '화곡제8동'),
	('1150060300', '가양제1동'),
	('1150060400', '가양제2동'),
	('1150060500', '가양제3동'),
	('1150061100', '발산제1동'),
	('1150061500', '우장산동'),
	('1150062000', '공항동'),
	('1150063000', '방화제1동'),
	('1150064000', '방화제2동'),
	('1150064100', '방화제3동'),
	('1153051000', '신도림동'),
	('1153052000', '구로제1동'),
	('1153053000', '구로제2동'),
	('1153054000', '구로제3동'),
	('1153055000', '구로제4동'),
	('1153056000', '구로제5동'),
	('1153059500', '가리봉동'),
	('1153072000', '고척제1동'),
	('1153073000', '고척제2동'),
	('1153074000', '개봉제1동'),
	('1153075000', '개봉제2동'),
	('1153076000', '개봉제3동'),
	('1153077000', '오류제1동'),
	('1153078000', '오류제2동'),
	('1153079000', '수궁동'),
	('1154551000', '가산동'),
	('1154561000', '독산제1동'),
	('1154562000', '독산제2동'),
	('1154563000', '독산제3동'),
	('1154564000', '독산제4동'),
	('1154567000', '시흥제1동'),
	('1154568000', '시흥제2동'),
	('1154569000', '시흥제3동'),
	('1154570000', '시흥제4동'),
	('1154571000', '시흥제5동'),
	('1156051500', '영등포본동'),
	('1156053500', '영등포동'),
	('1156054000', '여의동'),
	('1156055000', '당산제1동'),
	('1156056000', '당산제2동'),
	('1156058500', '도림동'),
	('1156060500', '문래동'),
	('1156061000', '양평제1동'),
	('1156062000', '양평제2동'),
	('1156063000', '신길제1동'),
	('1156065000', '신길제3동'),
	('1156066000', '신길제4동'),
	('1156067000', '신길제5동'),
	('1156068000', '신길제6동'),
	('1156069000', '신길제7동'),
	('1156070000', '대림제1동'),
	('1156071000', '대림제2동'),
	('1156072000', '대림제3동'),
	('1159051000', '노량진제1동'),
	('1159052000', '노량진제2동'),
	('1159053000', '상도제1동'),
	('1159054000', '상도제2동'),
	('1159055000', '상도제3동'),
	('1159056000', '상도제4동'),
	('1159060500', '흑석동'),
	('1159062000', '사당제1동'),
	('1159063000', '사당제2동'),
	('1159064000', '사당제3동'),
	('1159065000', '사당제4동'),
	('1159065100', '사당제5동'),
	('1159066000', '대방동'),
	('1159067000', '신대방제1동'),
	('1159068000', '신대방제2동'),
	('1162052500', '보라매동'),
	('1162054500', '청림동'),
	('1162056500', '성현동'),
	('1162057500', '행운동'),
	('1162058500', '낙성대동'),
	('1162059500', '청룡동'),
	('1162060500', '은천동'),
	('1162061500', '중앙동'),
	('1162062500', '인헌동'),
	('1162063000', '남현동'),
	('1162064500', '서원동'),
	('1162065500', '신원동'),
	('1162066500', '서림동'),
	('1162068500', '신사동'),
	('1162069500', '신림동'),
	('1162071500', '난향동'),
	('1162072500', '조원동'),
	('1162073500', '대학동'),
	('1162074500', '삼성동'),
	('1162076500', '미성동'),
	('1162077500', '난곡동'),
	('1165051000', '서초1동'),
	('1165052000', '서초2동'),
	('1165053000', '서초3동'),
	('1165053100', '서초4동'),
	('1165054000', '잠원동'),
	('1165055000', '반포본동'),
	('1165056000', '반포1동'),
	('1165057000', '반포2동'),
	('1165058000', '반포3동'),
	('1165058100', '반포4동'),
	('1165059000', '방배본동'),
	('1165060000', '방배1동'),
	('1165061000', '방배2동'),
	('1165062000', '방배3동'),
	('1165062100', '방배4동'),
	('1165065100', '양재1동'),
	('1165065200', '양재2동'),
	('1165066000', '내곡동'),
	('1168051000', '신사동'),
	('1168052100', '논현1동'),
	('1168053100', '논현2동'),
	('1168054500', '압구정동'),
	('1168056500', '청담동'),
	('1168058000', '삼성1동'),
	('1168059000', '삼성2동'),
	('1168060000', '대치1동'),
	('1168061000', '대치2동'),
	('1168063000', '대치4동'),
	('1168064000', '역삼1동'),
	('1168065000', '역삼2동'),
	('1168065500', '도곡1동'),
	('1168065600', '도곡2동'),
	('1168066000', '개포1동'),
	('1168067000', '개포2동'),
	('1168069000', '개포4동'),
	('1168070000', '세곡동'),
	('1168072000', '일원본동'),
	('1168073000', '일원1동'),
	('1168074000', '일원2동'),
	('1168075000', '수서동'),
	('1171051000', '풍납1동'),
	('1171052000', '풍납2동'),
	('1171053100', '거여1동'),
	('1171053200', '거여2동'),
	('1171054000', '마천1동'),
	('1171055000', '마천2동'),
	('1171056100', '방이1동'),
	('1171056200', '방이2동'),
	('1171056600', '오륜동'),
	('1171057000', '오금동'),
	('1171058000', '송파1동'),
	('1171059000', '송파2동'),
	('1171060000', '석촌동'),
	('1171061000', '삼전동'),
	('1171062000', '가락본동'),
	('1171063100', '가락1동'),
	('1171063200', '가락2동'),
	('1171064100', '문정1동'),
	('1171064200', '문정2동'),
	('1171064600', '장지동'),
	('1171064700', '위례동'),
	('1171065000', '잠실본동'),
	('1171067000', '잠실2동'),
	('1171068000', '잠실3동'),
	('1171069000', '잠실4동'),
	('1171071000', '잠실6동'),
	('1171072000', '잠실7동'),
	('1174051500', '강일동'),
	('1174052000', '상일동'),
	('1174053000', '명일제1동'),
	('1174054000', '명일제2동'),
	('1174055000', '고덕제1동'),
	('1174056000', '고덕제2동'),
	('1174057000', '암사제1동'),
	('1174058000', '암사제2동'),
	('1174059000', '암사제3동'),
	('1174060000', '천호제1동'),
	('1174061000', '천호제2동'),
	('1174062000', '천호제3동'),
	('1174064000', '성내제1동'),
	('1174065000', '성내제2동'),
	('1174066000', '성내제3동'),
	('1174068500', '길동'),
	('1174069000', '둔촌제1동'),
	('1174070000', '둔촌제2동'),
	('2611051000', '중앙동'),
	('2611052000', '동광동'),
	('2611053000', '대청동'),
	('2611054500', '보수동'),
	('2611056000', '부평동'),
	('2611057000', '광복동'),
	('2611058000', '남포동'),
	('2611059000', '영주제1동'),
	('2611060000', '영주제2동'),
	('2614051000', '동대신제1동'),
	('2614052000', '동대신제2동'),
	('2614053000', '동대신제3동'),
	('2614054000', '서대신제1동'),
	('2614056000', '서대신제3동'),
	('2614057000', '서대신제4동'),
	('2614059000', '부민동'),
	('2614061500', '아미동'),
	('2614063000', '초장동'),
	('2614064000', '충무동'),
	('2614065000', '남부민제1동'),
	('2614066000', '남부민제2동'),
	('2614068000', '암남동'),
	('2617051000', '초량제1동'),
	('2617052000', '초량제2동'),
	('2617053000', '초량제3동'),
	('2617055000', '초량제6동'),
	('2617056000', '수정제1동'),
	('2617057000', '수정제2동'),
	('2617059000', '수정제4동'),
	('2617060000', '수정제5동'),
	('2617064500', '좌천동'),
	('2617065000', '범일제1동'),
	('2617066000', '범일제2동'),
	('2617068000', '범일제5동'),
	('2620053000', '남항동'),
	('2620054000', '영선제1동'),
	('2620055000', '영선제2동'),
	('2620058500', '신선동'),
	('2620059000', '봉래제1동'),
	('2620060500', '봉래제2동'),
	('2620063000', '청학제1동'),
	('2620064000', '청학제2동'),
	('2620065000', '동삼제1동'),
	('2620066000', '동삼제2동'),
	('2620067000', '동삼제3동'),
	('2623051000', '부전제1동'),
	('2623052000', '부전제2동'),
	('2623054000', '연지동'),
	('2623055000', '초읍동'),
	('2623056000', '양정제1동'),
	('2623057000', '양정제2동'),
	('2623060000', '전포제1동'),
	('2623061000', '전포제2동'),
	('2623064000', '부암제1동'),
	('2623066000', '부암제3동'),
	('2623067000', '당감제1동'),
	('2623068000', '당감제2동'),
	('2623070000', '당감제4동'),
	('2623071000', '가야제1동'),
	('2623072000', '가야제2동'),
	('2623074000', '개금제1동'),
	('2623075000', '개금제2동'),
	('2623076000', '개금제3동'),
	('2623077000', '범천제1동'),
	('2623078000', '범천제2동'),
	('2626051000', '수민동'),
	('2626052000', '복산동'),
	('2626054500', '명륜동'),
	('2626055000', '온천제1동'),
	('2626056000', '온천제2동'),
	('2626057000', '온천제3동'),
	('2626058000', '사직제1동'),
	('2626059000', '사직제2동'),
	('2626060000', '사직제3동'),
	('2626074000', '안락제1동'),
	('2626075000', '안락제2동'),
	('2626076100', '명장제1동'),
	('2626076200', '명장제2동'),
	('2629051000', '대연제1동'),
	('2629053000', '대연제3동'),
	('2629054000', '대연제4동'),
	('2629055000', '대연제5동'),
	('2629056000', '대연제6동'),
	('2629057000', '용호제1동'),
	('2629058000', '용호제2동'),
	('2629059000', '용호제3동'),
	('2629060000', '용호제4동'),
	('2629061000', '용당동'),
	('2629062000', '감만제1동'),
	('2629063000', '감만제2동'),
	('2629064500', '우암동'),
	('2629068000', '문현제1동'),
	('2629069000', '문현제2동'),
	('2629070000', '문현제3동'),
	('2629071000', '문현제4동'),
	('2632051000', '구포제1동'),
	('2632052000', '구포제2동'),
	('2632052100', '구포제3동'),
	('2632053000', '금곡동'),
	('2632054100', '화명제1동'),
	('2632054200', '화명제2동'),
	('2632054300', '화명제3동'),
	('2632055000', '덕천제1동'),
	('2632056000', '덕천제2동'),
	('2632056100', '덕천제3동'),
	('2632057100', '만덕제1동'),
	('2632057200', '만덕제2동'),
	('2632057300', '만덕제3동'),
	('2635051000', '우제1동'),
	('2635052000', '우제2동'),
	('2635052500', '우제3동'),
	('2635053000', '중제1동'),
	('2635054000', '중제2동'),
	('2635055100', '좌제1동'),
	('2635055200', '좌제2동'),
	('2635055300', '좌제3동'),
	('2635055400', '좌제4동'),
	('2635056000', '송정동'),
	('2635057000', '반여제1동'),
	('2635058000', '반여제2동'),
	('2635059000', '반여제3동'),
	('2635059500', '반여제4동'),
	('2635061000', '반송제1동'),
	('2635062000', '반송제2동'),
	('2635065000', '재송제1동'),
	('2635066000', '재송제2동'),
	('2638051000', '괴정제1동'),
	('2638052000', '괴정제2동'),
	('2638053000', '괴정제3동'),
	('2638054000', '괴정제4동'),
	('2638055000', '당리동'),
	('2638056100', '하단제1동'),
	('2638056200', '하단제2동'),
	('2638057100', '신평제1동'),
	('2638057200', '신평제2동'),
	('2638058000', '장림제1동'),
	('2638059000', '장림제2동'),
	('2638060100', '다대제1동'),
	('2638060200', '다대제2동'),
	('2638061000', '구평동'),
	('2638062000', '감천제1동'),
	('2638063000', '감천제2동'),
	('2641051000', '서제1동'),
	('2641052000', '서제2동'),
	('2641053000', '서제3동'),
	('2641055500', '금사회동동'),
	('2641057000', '부곡제1동'),
	('2641058000', '부곡제2동'),
	('2641059000', '부곡제3동'),
	('2641059100', '부곡제4동'),
	('2641060000', '장전제1동'),
	('2641061000', '장전제2동'),
	('2641062000', '장전제3동'),
	('2641063500', '선두구동'),
	('2641066500', '청룡노포동'),
	('2641067000', '남산동'),
	('2641068000', '구서제1동'),
	('2641069000', '구서제2동'),
	('2641070000', '금성동'),
	('2644051000', '대저1동'),
	('2644052000', '대저2동'),
	('2644053000', '강동동'),
	('2644053500', '명지1동'),
	('2644054500', '명지2동'),
	('2644055000', '가락동'),
	('2644056000', '녹산동'),
	('2644058000', '가덕도동'),
	('2647061000', '거제제1동'),
	('2647062000', '거제제2동'),
	('2647063000', '거제제3동'),
	('2647064000', '거제제4동'),
	('2647065000', '연산제1동'),
	('2647066000', '연산제2동'),
	('2647067000', '연산제3동'),
	('2647068000', '연산제4동'),
	('2647069000', '연산제5동'),
	('2647070000', '연산제6동'),
	('2647072000', '연산제8동'),
	('2647073000', '연산제9동'),
	('2650066000', '남천제1동'),
	('2650067000', '남천제2동'),
	('2650073000', '수영동'),
	('2650074000', '망미제1동'),
	('2650075000', '망미제2동'),
	('2650076000', '광안제1동'),
	('2650077000', '광안제2동'),
	('2650078000', '광안제3동'),
	('2650079000', '광안제4동'),
	('2650080000', '민락동'),
	('2653058000', '삼락동'),
	('2653059100', '모라제1동'),
	('2653059300', '모라제3동'),
	('2653060000', '덕포제1동'),
	('2653061000', '덕포제2동'),
	('2653062000', '괘법동'),
	('2653064500', '감전동'),
	('2653065000', '주례제1동'),
	('2653066000', '주례제2동'),
	('2653066100', '주례제3동'),
	('2653067000', '학장동'),
	('2653068000', '엄궁동'),
	('2671025000', '기장읍'),
	('2671025300', '장안읍'),
	('2671025600', '정관읍'),
	('2671031000', '일광면'),
	('2671033000', '철마면'),
	('2711051700', '동인동'),
	('2711054500', '삼덕동'),
	('2711056500', '성내1동'),
	('2711057500', '성내2동'),
	('2711058500', '성내3동'),
	('2711059500', '대신동'),
	('2711064000', '남산1동'),
	('2711065000', '남산2동'),
	('2711066000', '남산3동'),
	('2711067000', '남산4동'),
	('2711068000', '대봉1동'),
	('2711069000', '대봉2동'),
	('2714051000', '신암1동'),
	('2714052000', '신암2동'),
	('2714053000', '신암3동'),
	('2714054000', '신암4동'),
	('2714054100', '신암5동'),
	('2714055500', '신천1.2동'),
	('2714057000', '신천3동'),
	('2714058000', '신천4동'),
	('2714059000', '효목1동'),
	('2714060000', '효목2동'),
	('2714061500', '도평동'),
	('2714062000', '불로.봉무동'),
	('2714064000', '지저동'),
	('2714065500', '동촌동'),
	('2714067000', '방촌동'),
	('2714068500', '해안동'),
	('2714072000', '안심1동'),
	('2714073000', '안심2동'),
	('2714074500', '안심3.4동'),
	('2714076000', '공산동'),
	('2717051000', '내당1동'),
	('2717052500', '내당2.3동'),
	('2717054000', '내당4동'),
	('2717055000', '비산1동'),
	('2717056500', '비산2.3동'),
	('2717058000', '비산4동'),
	('2717059000', '비산5동'),
	('2717060000', '비산6동'),
	('2717061000', '비산7동'),
	('2717062000', '평리1동'),
	('2717063000', '평리2동'),
	('2717064000', '평리3동'),
	('2717065000', '평리4동'),
	('2717066000', '평리5동'),
	('2717066100', '평리6동'),
	('2717067500', '상중이동'),
	('2717069500', '원대동'),
	('2720051500', '이천동'),
	('2720053000', '봉덕1동'),
	('2720054000', '봉덕2동'),
	('2720055000', '봉덕3동'),
	('2720056000', '대명1동'),
	('2720057100', '대명2동'),
	('2720058600', '대명3동'),
	('2720059000', '대명4동'),
	('2720060000', '대명5동'),
	('2720061000', '대명6동'),
	('2720064000', '대명9동'),
	('2720065000', '대명10동'),
	('2720066000', '대명11동'),
	('2723051000', '고성동'),
	('2723052600', '칠성동'),
	('2723055000', '침산1동'),
	('2723056000', '침산2동'),
	('2723057000', '침산3동'),
	('2723061000', '산격1동'),
	('2723062000', '산격2동'),
	('2723063000', '산격3동'),
	('2723063100', '산격4동'),
	('2723064500', '대현동'),
	('2723067100', '복현1동'),
	('2723067200', '복현2동'),
	('2723068000', '검단동'),
	('2723069500', '무태조야동'),
	('2723071500', '관문동'),
	('2723072500', '태전1동'),
	('2723073500', '태전2동'),
	('2723074500', '구암동'),
	('2723075000', '관음동'),
	('2723077000', '읍내동'),
	('2723078000', '동천동'),
	('2723079000', '노원동'),
	('2723080000', '국우동'),
	('2726051000', '범어1동'),
	('2726052000', '범어2동'),
	('2726053000', '범어3동'),
	('2726054000', '범어4동'),
	('2726055000', '만촌1동'),
	('2726056000', '만촌2동'),
	('2726056100', '만촌3동'),
	('2726057000', '수성1가동'),
	('2726058000', '수성2.3가동'),
	('2726059000', '수성4가동'),
	('2726060100', '황금1동'),
	('2726060200', '황금2동'),
	('2726061000', '중동'),
	('2726062000', '상동'),
	('2726063000', '파동'),
	('2726064000', '두산동'),
	('2726065100', '지산1동'),
	('2726065200', '지산2동'),
	('2726066100', '범물1동'),
	('2726066200', '범물2동'),
	('2726067000', '고산1동'),
	('2726068000', '고산2동'),
	('2726069000', '고산3동'),
	('2729051500', '성당동'),
	('2729053500', '두류1.2동'),
	('2729055000', '두류3동'),
	('2729055500', '감삼동'),
	('2729056300', '죽전동'),
	('2729056800', '장기동'),
	('2729057100', '용산1동'),
	('2729057200', '용산2동'),
	('2729057600', '이곡1동'),
	('2729057700', '이곡2동'),
	('2729058500', '신당동'),
	('2729059000', '본리동'),
	('2729060100', '월성1동'),
	('2729060200', '월성2동'),
	('2729061500', '진천동'),
	('2729062400', '상인1동'),
	('2729062500', '상인2동'),
	('2729062600', '상인3동'),
	('2729062800', '도원동'),
	('2729063000', '송현1동'),
	('2729064000', '송현2동'),
	('2729065000', '본동'),
	('2771025000', '화원읍'),
	('2771025300', '논공읍'),
	('2771025400', '논공읍공단출장소'),
	('2771025600', '다사읍'),
	('2771025700', '다사읍서재출장소'),
	('2771025900', '유가읍'),
	('2771026200', '옥포읍'),
	('2771026500', '현풍읍'),
	('2771031000', '가창면'),
	('2771033000', '하빈면'),
	('2771038000', '구지면'),
	('2811052000', '연안동'),
	('2811053000', '신포동'),
	('2811054000', '신흥동'),
	('2811056000', '도원동'),
	('2811057000', '율목동'),
	('2811058500', '동인천동'),
	('2811060000', '북성동'),
	('2811061000', '송월동'),
	('2811062000', '영종동'),
	('2811062200', '영종1동'),
	('2811062800', '운서동'),
	('2811063000', '용유동'),
	('2814051000', '만석동'),
	('2814052500', '화수1.화평동'),
	('2814053000', '화수2동'),
	('2814055500', '송현1.2동'),
	('2814057000', '송현3동'),
	('2814058000', '송림1동'),
	('2814059000', '송림2동'),
	('2814060500', '송림3.5동'),
	('2814061000', '송림4동'),
	('2814063000', '송림6동'),
	('2814064000', '금창동'),
	('2817751000', '숭의2동'),
	('2817752000', '숭의1,3동'),
	('2817753000', '숭의4동'),
	('2817754000', '용현1,4동'),
	('2817755000', '용현2동'),
	('2817756000', '용현3동'),
	('2817757000', '용현5동'),
	('2817758000', '학익1동'),
	('2817759000', '학익2동'),
	('2817760000', '도화1동'),
	('2817761000', '도화2,3동'),
	('2817762000', '주안1동'),
	('2817763000', '주안2동'),
	('2817764000', '주안3동'),
	('2817765000', '주안4동'),
	('2817766000', '주안5동'),
	('2817767000', '주안6동'),
	('2817768000', '주안7동'),
	('2817769000', '주안8동'),
	('2817770000', '관교동'),
	('2817771000', '문학동'),
	('2818563000', '옥련1동'),
	('2818564000', '옥련2동'),
	('2818575000', '선학동'),
	('2818576100', '연수1동'),
	('2818576200', '연수2동'),
	('2818576300', '연수3동'),
	('2818576600', '청학동'),
	('2818578000', '동춘1동'),
	('2818579000', '동춘2동'),
	('2818579500', '동춘3동'),
	('2818582000', '송도1동'),
	('2818583000', '송도2동'),
	('2818584000', '송도3동'),
	('2818585000', '송도4동'),
	('2820051000', '구월1동'),
	('2820052000', '구월2동'),
	('2820052100', '구월3동'),
	('2820052200', '구월4동'),
	('2820053000', '간석1동'),
	('2820054000', '간석2동'),
	('2820055000', '간석3동'),
	('2820055100', '간석4동'),
	('2820056000', '만수1동'),
	('2820057000', '만수2동'),
	('2820058000', '만수3동'),
	('2820058100', '만수4동'),
	('2820058200', '만수5동'),
	('2820058300', '만수6동'),
	('2820065000', '장수서창동'),
	('2820065500', '서창2동'),
	('2820066000', '남촌도림동'),
	('2820069000', '논현1동'),
	('2820070000', '논현2동'),
	('2820071000', '논현고잔동'),
	('2823751000', '부평1동'),
	('2823752000', '부평2동'),
	('2823753000', '부평3동'),
	('2823754000', '부평4동'),
	('2823755000', '부평5동'),
	('2823756000', '부평6동'),
	('2823757000', '산곡1동'),
	('2823758000', '산곡2동'),
	('2823758100', '산곡3동'),
	('2823758200', '산곡4동'),
	('2823759100', '청천1동'),
	('2823759200', '청천2동'),
	('2823764100', '갈산1동'),
	('2823764200', '갈산2동'),
	('2823764600', '삼산1동'),
	('2823764800', '삼산2동'),
	('2823765000', '부개1동'),
	('2823766000', '부개2동'),
	('2823766100', '부개3동'),
	('2823767000', '일신동'),
	('2823768000', '십정1동'),
	('2823769000', '십정2동'),
	('2824560100', '효성1동'),
	('2824560200', '효성2동'),
	('2824561100', '계산1동'),
	('2824561200', '계산2동'),
	('2824561300', '계산3동'),
	('2824561400', '계산4동'),
	('2824562100', '작전1동'),
	('2824562200', '작전2동'),
	('2824564000', '작전서운동'),
	('2824571000', '계양1동'),
	('2824572000', '계양2동'),
	('2824573000', '계양3동'),
	('2826051500', '검암경서동'),
	('2826053000', '연희동'),
	('2826053600', '청라1동'),
	('2826053700', '청라2동'),
	('2826053900', '청라3동'),
	('2826054200', '가정1동'),
	('2826054300', '가정2동'),
	('2826054400', '가정3동'),
	('2826055000', '석남1동'),
	('2826056000', '석남2동'),
	('2826056100', '석남3동'),
	('2826057500', '신현원창동'),
	('2826058000', '가좌1동'),
	('2826059000', '가좌2동'),
	('2826060000', '가좌3동'),
	('2826061000', '가좌4동'),
	('2826068000', '검단동'),
	('2826069000', '불로대곡동'),
	('2826070000', '원당동'),
	('2826071000', '당하동'),
	('2826072000', '오류왕길동'),
	('2871025000', '강화읍'),
	('2871031000', '선원면'),
	('2871032000', '불은면'),
	('2871033000', '길상면'),
	('2871034000', '화도면'),
	('2871035000', '양도면'),
	('2871036000', '내가면'),
	('2871037000', '하점면'),
	('2871038000', '양사면'),
	('2871039000', '송해면'),
	('2871040000', '교동면'),
	('2871041000', '삼산면'),
	('2871042000', '서도면'),
	('2871042500', '서도면볼음출장소'),
	('2872031000', '북도면'),
	('2872031500', '북도면장봉출장소'),
	('2872033000', '백령면'),
	('2872034000', '대청면'),
	('2872034500', '대청면소청출장소'),
	('2872035000', '덕적면'),
	('2872036000', '영흥면'),
	('2872037000', '자월면'),
	('2872037500', '자월면이작출장소'),
	('2872038000', '연평면'),
	('2911052500', '충장동'),
	('2911054500', '동명동'),
	('2911056000', '계림1동'),
	('2911057000', '계림2동'),
	('2911059000', '산수1동'),
	('2911060000', '산수2동'),
	('2911062000', '지산1동'),
	('2911063000', '지산2동'),
	('2911065500', '서남동'),
	('2911068500', '학동'),
	('2911071000', '학운동'),
	('2911073000', '지원1동'),
	('2911074000', '지원2동'),
	('2914057500', '양동'),
	('2914059000', '양3동'),
	('2914065000', '농성1동'),
	('2914066000', '농성2동'),
	('2914073000', '광천동'),
	('2914074000', '유덕동'),
	('2914074500', '치평동'),
	('2914075100', '상무1동'),
	('2914075200', '상무2동'),
	('2914076000', '화정1동'),
	('2914077000', '화정2동'),
	('2914078000', '화정3동'),
	('2914079000', '화정4동'),
	('2914080000', '서창동'),
	('2914082100', '금호1동'),
	('2914082400', '금호2동'),
	('2914083000', '풍암동'),
	('2914084000', '동천동'),
	('2915551000', '양림동'),
	('2915552000', '방림1동'),
	('2915553000', '방림2동'),
	('2915553700', '봉선1동'),
	('2915553800', '봉선2동'),
	('2915554500', '사직동'),
	('2915560500', '월산동'),
	('2915563000', '월산4동'),
	('2915564000', '월산5동'),
	('2915567000', '백운1동'),
	('2915568000', '백운2동'),
	('2915569000', '주월1동'),
	('2915570000', '주월2동'),
	('2915571000', '효덕동'),
	('2915572000', '송암동'),
	('2915573000', '대촌동'),
	('2917051000', '중흥1동'),
	('2917052000', '중흥2동'),
	('2917053000', '중흥3동'),
	('2917055500', '중앙동'),
	('2917057000', '임동'),
	('2917058000', '신안동'),
	('2917059000', '용봉동'),
	('2917060100', '운암1동'),
	('2917060200', '운암2동'),
	('2917060300', '운암3동'),
	('2917061500', '동림동'),
	('2917062000', '우산동'),
	('2917063500', '풍향동'),
	('2917065000', '문화동'),
	('2917065600', '문흥1동'),
	('2917065700', '문흥2동'),
	('2917066100', '두암1동'),
	('2917066200', '두암2동'),
	('2917066300', '두암3동'),
	('2917066600', '삼각동'),
	('2917066900', '일곡동'),
	('2917067300', '매곡동'),
	('2917067600', '오치1동'),
	('2917067700', '오치2동'),
	('2917068500', '석곡동'),
	('2917069500', '건국동'),
	('2917069600', '양산동'),
	('2920051500', '송정1동'),
	('2920052500', '송정2동'),
	('2920054000', '도산동'),
	('2920055000', '신흥동'),
	('2920056500', '어룡동'),
	('2920058000', '우산동'),
	('2920060000', '월곡1동'),
	('2920061000', '월곡2동'),
	('2920062000', '비아동'),
	('2920062400', '첨단1동'),
	('2920062600', '첨단2동'),
	('2920063000', '신가동'),
	('2920063500', '운남동'),
	('2920063700', '수완동'),
	('2920064000', '하남동'),
	('2920065000', '임곡동'),
	('2920066000', '동곡동'),
	('2920067000', '평동'),
	('2920068000', '삼도동'),
	('2920069000', '본량동'),
	('2920070000', '신창동'),
	('3011051500', '중앙동'),
	('3011053000', '효동'),
	('3011054500', '신인동'),
	('3011055100', '판암1동'),
	('3011055200', '판암2동'),
	('3011056000', '용운동'),
	('3011058500', '대동'),
	('3011059000', '자양동'),
	('3011062000', '가양1동'),
	('3011063000', '가양2동'),
	('3011064000', '용전동'),
	('3011066500', '성남동'),
	('3011067000', '홍도동'),
	('3011069500', '삼성동'),
	('3011072500', '대청동'),
	('3011074000', '산내동'),
	('3014053500', '은행선화동'),
	('3014055000', '목동'),
	('3014056000', '중촌동'),
	('3014057500', '대흥동'),
	('3014060500', '문창동'),
	('3014062000', '석교동'),
	('3014063000', '대사동'),
	('3014064000', '부사동'),
	('3014065500', '용두동'),
	('3014067000', '오류동'),
	('3014068000', '태평1동'),
	('3014069000', '태평2동'),
	('3014070000', '유천1동'),
	('3014071000', '유천2동'),
	('3014072000', '문화1동'),
	('3014073000', '문화2동'),
	('3014074000', '산성동'),
	('3017051000', '복수동'),
	('3017052000', '도마1동'),
	('3017053000', '도마2동'),
	('3017053500', '정림동'),
	('3017054000', '변동'),
	('3017055000', '용문동'),
	('3017055500', '탄방동'),
	('3017056000', '괴정동'),
	('3017057000', '가장동'),
	('3017057500', '내동'),
	('3017058100', '갈마1동'),
	('3017058200', '갈마2동'),
	('3017058600', '월평1동'),
	('3017058700', '월평2동'),
	('3017058800', '월평3동'),
	('3017059000', '가수원동'),
	('3017059600', '관저1동'),
	('3017059700', '관저2동'),
	('3017060000', '기성동'),
	('3017063000', '둔산1동'),
	('3017064000', '둔산2동'),
	('3017065000', '만년동'),
	('3017066000', '둔산3동'),
	('3020052000', '진잠동'),
	('3020053000', '온천1동'),
	('3020054000', '온천2동'),
	('3020054600', '노은1동'),
	('3020054700', '노은2동'),
	('3020054800', '노은3동'),
	('3020055000', '신성동'),
	('3020057000', '전민동'),
	('3020058000', '구즉동'),
	('3020060000', '관평동'),
	('3020061000', '원신흥동'),
	('3023051000', '오정동'),
	('3023052000', '대화동'),
	('3023052500', '회덕동'),
	('3023053300', '비래동'),
	('3023054300', '송촌동'),
	('3023054600', '중리동'),
	('3023055000', '신탄진동'),
	('3023056000', '석봉동'),
	('3023057000', '덕암동'),
	('3023058000', '목상동'),
	('3023060000', '법1동'),
	('3023061000', '법2동'),
	('3111051000', '학성동'),
	('3111052000', '반구1동'),
	('3111053000', '반구2동'),
	('3111054000', '복산1동'),
	('3111055000', '복산2동'),
	('3111058500', '중앙동'),
	('3111059000', '우정동'),
	('3111060000', '태화동'),
	('3111061000', '다운동'),
	('3111062000', '병영1동'),
	('3111063000', '병영2동'),
	('3111064000', '약사동'),
	('3111065000', '성안동'),
	('3114051000', '신정1동'),
	('3114052000', '신정2동'),
	('3114053000', '신정3동'),
	('3114054000', '신정4동'),
	('3114055000', '신정5동'),
	('3114056000', '달동'),
	('3114057000', '삼산동'),
	('3114058500', '삼호동'),
	('3114059500', '무거동'),
	('3114060000', '옥동'),
	('3114062500', '대현동'),
	('3114063500', '수암동'),
	('3114064000', '선암동'),
	('3114067000', '야음장생포동'),
	('3117051000', '방어동'),
	('3117052000', '일산동'),
	('3117053000', '화정동'),
	('3117054000', '대송동'),
	('3117055000', '전하1동'),
	('3117056000', '전하2동'),
	('3117058000', '남목1동'),
	('3117059000', '남목2동'),
	('3117060000', '남목3동'),
	('3120051000', '농소1동'),
	('3120052000', '농소2동'),
	('3120053000', '농소3동'),
	('3120054000', '강동동'),
	('3120056000', '효문동'),
	('3120057000', '송정동'),
	('3120058000', '양정동'),
	('3120059000', '염포동'),
	('3171025000', '온산읍'),
	('3171025300', '언양읍'),
	('3171025600', '온양읍'),
	('3171025900', '범서읍'),
	('3171026200', '청량읍'),
	('3171031000', '서생면'),
	('3171034000', '웅촌면'),
	('3171036000', '두동면'),
	('3171037000', '두서면'),
	('3171038000', '상북면'),
	('3171039000', '삼남면'),
	('3171040000', '삼동면'),
	('3611025000', '조치원읍'),
	('3611031000', '연기면'),
	('3611032000', '연동면'),
	('3611033000', '부강면'),
	('3611034000', '금남면'),
	('3611035000', '장군면'),
	('3611036000', '연서면'),
	('3611037000', '전의면'),
	('3611038000', '전동면'),
	('3611039000', '소정면'),
	('3611051000', '한솔동'),
	('3611051500', '새롬동'),
	('3611052000', '도담동'),
	('3611053000', '아름동'),
	('3611054000', '종촌동'),
	('3611055000', '고운동'),
	('3611055500', '소담동'),
	('3611056000', '보람동'),
	('3611057000', '대평동'),
	('4111156000', '파장동'),
	('4111156600', '율천동'),
	('4111157100', '정자1동'),
	('4111157200', '정자2동'),
	('4111157300', '정자3동'),
	('4111158000', '영화동'),
	('4111159100', '송죽동'),
	('4111159700', '조원1동'),
	('4111159800', '조원2동'),
	('4111160000', '연무동'),
	('4111352000', '세류1동'),
	('4111353000', '세류2동'),
	('4111354000', '세류3동'),
	('4111355000', '평동'),
	('4111356000', '서둔동'),
	('4111365000', '구운동'),
	('4111366200', '금곡동'),
	('4111366400', '호매실동'),
	('4111367000', '권선1동'),
	('4111368000', '권선2동'),
	('4111369000', '곡선동'),
	('4111370000', '입북동'),
	('4111565000', '매교동'),
	('4111566000', '매산동'),
	('4111567000', '고등동'),
	('4111568000', '화서1동'),
	('4111569000', '화서2동'),
	('4111570000', '지동'),
	('4111571000', '우만1동'),
	('4111572000', '우만2동'),
	('4111573000', '인계동'),
	('4111574000', '행궁동'),
	('4111751000', '매탄1동'),
	('4111752000', '매탄2동'),
	('4111753000', '매탄3동'),
	('4111754000', '매탄4동'),
	('4111755000', '원천동'),
	('4111757000', '영통1동'),
	('4111758000', '영통2동'),
	('4111758500', '영통3동'),
	('4111759300', '망포1동'),
	('4111759600', '망포2동'),
	('4111760000', '광교1동'),
	('4111761000', '광교2동'),
	('4113151000', '신흥1동'),
	('4113152000', '신흥2동'),
	('4113153000', '신흥3동'),
	('4113154000', '태평1동'),
	('4113155000', '태평2동'),
	('4113156000', '태평3동'),
	('4113156100', '태평4동'),
	('4113157000', '수진1동'),
	('4113158000', '수진2동'),
	('4113159000', '단대동'),
	('4113160000', '산성동'),
	('4113161000', '양지동'),
	('4113162000', '복정동'),
	('4113162500', '위례동'),
	('4113163000', '신촌동'),
	('4113164000', '고등동'),
	('4113165000', '시흥동'),
	('4113351000', '성남동'),
	('4113352500', '중앙동'),
	('4113353000', '금광1동'),
	('4113354000', '금광2동'),
	('4113355000', '은행1동'),
	('4113356000', '은행2동'),
	('4113357000', '상대원1동'),
	('4113358000', '상대원2동'),
	('4113359000', '상대원3동'),
	('4113366000', '하대원동'),
	('4113367000', '도촌동'),
	('4113551000', '분당동'),
	('4113552000', '수내1동'),
	('4113553000', '수내2동'),
	('4113554000', '수내3동'),
	('4113554500', '정자동'),
	('4113555000', '정자1동'),
	('4113556000', '정자2동'),
	('4113557000', '정자3동'),
	('4113558000', '서현1동'),
	('4113559000', '서현2동'),
	('4113560000', '이매1동'),
	('4113561000', '이매2동'),
	('4113562000', '야탑1동'),
	('4113563000', '야탑2동'),
	('4113564000', '야탑3동'),
	('4113565000', '판교동'),
	('4113565500', '삼평동'),
	('4113565700', '백현동'),
	('4113566200', '금곡동'),
	('4113566500', '구미1동'),
	('4113567000', '구미동'),
	('4113568000', '운중동'),
	('4115051000', '의정부1동'),
	('4115052000', '의정부2동'),
	('4115053000', '의정부3동'),
	('4115054500', '호원1동'),
	('4115055500', '호원2동'),
	('4115056100', '장암동'),
	('4115056700', '신곡1동'),
	('4115056800', '신곡2동'),
	('4115057300', '송산1동'),
	('4115057600', '송산2동'),
	('4115058000', '자금동'),
	('4115059500', '가능동'),
	('4115061500', '흥선동'),
	('4115062000', '녹양동'),
	('4117151000', '안양1동'),
	('4117152000', '안양2동'),
	('4117153000', '안양3동'),
	('4117154000', '안양4동'),
	('4117155000', '안양5동'),
	('4117156000', '안양6동'),
	('4117157000', '안양7동'),
	('4117158000', '안양8동'),
	('4117158100', '안양9동'),
	('4117159000', '석수1동'),
	('4117160000', '석수2동'),
	('4117161000', '석수3동'),
	('4117162100', '박달1동'),
	('4117163000', '박달2동'),
	('4117351000', '비산1동'),
	('4117352000', '비산2동'),
	('4117353000', '비산3동'),
	('4117354000', '부흥동'),
	('4117354600', '달안동'),
	('4117355000', '관양1동'),
	('4117356000', '관양2동'),
	('4117356600', '부림동'),
	('4117357000', '평촌동'),
	('4117357600', '평안동'),
	('4117357800', '귀인동'),
	('4117358000', '호계1동'),
	('4117359000', '호계2동'),
	('4117360000', '호계3동'),
	('4117361000', '범계동'),
	('4117362000', '신촌동'),
	('4117363000', '갈산동'),
	('4119060300', '심곡동'),
	('4119060600', '부천동'),
	('4119061000', '중동'),
	('4119074200', '신중동'),
	('4119074400', '상동'),
	('4119074600', '대산동'),
	('4119075000', '소사본동'),
	('4119079500', '범안동'),
	('4119080000', '성곡동'),
	('4119083000', '오정동'),
	('4121051000', '광명1동'),
	('4121052000', '광명2동'),
	('4121054000', '광명3동'),
	('4121055000', '광명4동'),
	('4121056000', '광명5동'),
	('4121057000', '광명6동'),
	('4121058000', '광명7동'),
	('4121059000', '철산1동'),
	('4121060000', '철산2동'),
	('4121061000', '철산3동'),
	('4121062000', '철산4동'),
	('4121063100', '하안1동'),
	('4121063200', '하안2동'),
	('4121063300', '하안3동'),
	('4121063400', '하안4동'),
	('4121064000', '소하1동'),
	('4121065000', '소하2동'),
	('4121066000', '학온동'),
	('4122025000', '팽성읍'),
	('4122025300', '안중읍'),
	('4122025600', '포승읍'),
	('4122025900', '청북읍'),
	('4122031000', '진위면'),
	('4122032000', '서탄면'),
	('4122033000', '고덕면'),
	('4122034000', '오성면'),
	('4122037000', '현덕면'),
	('4122051000', '중앙동'),
	('4122052000', '서정동'),
	('4122053500', '송탄동'),
	('4122055000', '지산동'),
	('4122056000', '송북동'),
	('4122057000', '신장1동'),
	('4122058000', '신장2동'),
	('4122059000', '신평동'),
	('4122060000', '원평동'),
	('4122061000', '통복동'),
	('4122062000', '비전1동'),
	('4122063000', '비전2동'),
	('4122064000', '세교동'),
	('4125051000', '생연1동'),
	('4125052000', '생연2동'),
	('4125053500', '중앙동'),
	('4125055000', '보산동'),
	('4125056500', '불현동'),
	('4125056600', '송내동'),
	('4125058000', '소요동'),
	('4125060000', '상패동'),
	('4127151000', '일동'),
	('4127151500', '이동'),
	('4127152500', '사동'),
	('4127153200', '사이동'),
	('4127153700', '해양동'),
	('4127154000', '본오1동'),
	('4127155000', '본오2동'),
	('4127156000', '본오3동'),
	('4127157000', '부곡동'),
	('4127158000', '월피동'),
	('4127159000', '성포동'),
	('4127160000', '반월동'),
	('4127161000', '안산동'),
	('4127351000', '와동'),
	('4127352500', '고잔동'),
	('4127353200', '중앙동'),
	('4127353500', '호수동'),
	('4127354500', '원곡동'),
	('4127355500', '백운동'),
	('4127356500', '신길동'),
	('4127357000', '초지동'),
	('4127358000', '선부1동'),
	('4127359000', '선부2동'),
	('4127360000', '선부3동'),
	('4127361000', '대부동'),
	('4128151000', '주교동'),
	('4128152000', '원신동'),
	('4128153000', '흥도동'),
	('4128154000', '성사1동'),
	('4128155000', '성사2동'),
	('4128156000', '효자동'),
	('4128157500', '삼송동'),
	('4128158000', '창릉동'),
	('4128159000', '고양동'),
	('4128160000', '관산동'),
	('4128161000', '능곡동'),
	('4128162100', '화정1동'),
	('4128162200', '화정2동'),
	('4128163000', '행주동'),
	('4128164000', '행신1동'),
	('4128165000', '행신2동'),
	('4128165500', '행신3동'),
	('4128166000', '화전동'),
	('4128167000', '대덕동'),
	('4128551000', '식사동'),
	('4128552000', '중산동'),
	('4128553000', '정발산동'),
	('4128554000', '풍산동'),
	('4128555100', '백석1동'),
	('4128555200', '백석2동'),
	('4128556000', '마두1동'),
	('4128557000', '마두2동'),
	('4128558000', '장항1동'),
	('4128559000', '장항2동'),
	('4128560000', '고봉동'),
	('4128751000', '일산1동'),
	('4128752000', '일산2동'),
	('4128753000', '일산3동'),
	('4128754000', '탄현동'),
	('4128755000', '주엽1동'),
	('4128756000', '주엽2동'),
	('4128757000', '대화동'),
	('4128758000', '송포동'),
	('4128759000', '송산동'),
	('4129051000', '중앙동'),
	('4129052000', '갈현동'),
	('4129053000', '별양동'),
	('4129054000', '부림동'),
	('4129055000', '과천동'),
	('4129056000', '문원동'),
	('4131051000', '갈매동'),
	('4131052000', '동구동'),
	('4131053000', '인창동'),
	('4131054100', '교문1동'),
	('4131054200', '교문2동'),
	('4131057000', '수택1동'),
	('4131058000', '수택2동'),
	('4131059000', '수택3동'),
	('4136025000', '와부읍'),
	('4136025300', '진접읍'),
	('4136025600', '화도읍'),
	('4136025700', '화도읍동부출장소'),
	('4136025900', '진건읍'),
	('4136026200', '오남읍'),
	('4136031000', '별내면'),
	('4136034000', '수동면'),
	('4136036000', '조안면'),
	('4136037000', '퇴계원면'),
	('4136051000', '호평동'),
	('4136052000', '평내동'),
	('4136053000', '금곡동'),
	('4136054000', '양정동'),
	('4136054500', '다산1동'),
	('4136056500', '다산2동'),
	('4136057000', '별내동'),
	('4137051000', '중앙동'),
	('4137053000', '남촌동'),
	('4137054000', '신장동'),
	('4137055000', '세마동'),
	('4137056000', '초평동'),
	('4137057000', '대원동'),
	('4139051000', '대야동'),
	('4139052000', '신천동'),
	('4139053100', '신현동'),
	('4139054000', '은행동'),
	('4139055000', '매화동'),
	('4139057000', '목감동'),
	('4139058100', '군자동'),
	('4139058200', '월곶동'),
	('4139058900', '정왕본동'),
	('4139059100', '정왕1동'),
	('4139059200', '정왕2동'),
	('4139059300', '정왕3동'),
	('4139059400', '정왕4동'),
	('4139059500', '배곧동'),
	('4139062100', '과림동'),
	('4139063000', '연성동'),
	('4139063100', '장곡동'),
	('4139064000', '능곡동'),
	('4141051000', '군포1동'),
	('4141052000', '군포2동'),
	('4141054000', '산본1동'),
	('4141055000', '산본2동'),
	('4141056000', '금정동'),
	('4141057000', '재궁동'),
	('4141058000', '오금동'),
	('4141059000', '수리동'),
	('4141060000', '궁내동'),
	('4141061000', '대야동'),
	('4141062000', '광정동'),
	('4143051000', '고천동'),
	('4143052000', '부곡동'),
	('4143053000', '오전동'),
	('4143054000', '내손1동'),
	('4143055000', '내손2동'),
	('4143056000', '청계동'),
	('4145051000', '천현동'),
	('4145052000', '신장1동'),
	('4145053000', '신장2동'),
	('4145054000', '덕풍1동'),
	('4145055000', '덕풍2동'),
	('4145056000', '덕풍3동'),
	('4145057000', '풍산동'),
	('4145058000', '감북동'),
	('4145058500', '위례동'),
	('4145059000', '춘궁동'),
	('4145060000', '초이동'),
	('4145061000', '미사1동'),
	('4145062000', '미사2동'),
	('4146125000', '포곡읍'),
	('4146125300', '모현읍'),
	('4146125600', '이동읍'),
	('4146132000', '남사면'),
	('4146134000', '원삼면'),
	('4146135000', '백암면'),
	('4146136000', '양지면'),
	('4146151000', '중앙동'),
	('4146152000', '역삼동'),
	('4146153000', '유림동'),
	('4146154000', '동부동'),
	('4146351000', '신갈동'),
	('4146351500', '영덕동'),
	('4146352000', '구갈동'),
	('4146353000', '상갈동'),
	('4146354000', '기흥동'),
	('4146355000', '서농동'),
	('4146356000', '구성동'),
	('4146357000', '마북동'),
	('4146358500', '동백동'),
	('4146358600', '상하동'),
	('4146359000', '보정동'),
	('4146551000', '풍덕천1동'),
	('4146552000', '풍덕천2동'),
	('4146553000', '신봉동'),
	('4146554000', '죽전1동'),
	('4146555000', '죽전2동'),
	('4146556000', '동천동'),
	('4146557000', '상현1동'),
	('4146558000', '상현2동'),
	('4146559000', '성복동'),
	('4148025000', '문산읍'),
	('4148025300', '파주읍'),
	('4148025600', '법원읍'),
	('4148026200', '조리읍'),
	('4148031000', '월롱면'),
	('4148032000', '탄현면'),
	('4148035000', '광탄면'),
	('4148036000', '파평면'),
	('4148037000', '적성면'),
	('4148038000', '군내면'),
	('4148038700', '장단출장소'),
	('4148039000', '장단면'),
	('4148040000', '진동면'),
	('4148041000', '진서면'),
	('4148051000', '금촌1동'),
	('4148052000', '금촌2동'),
	('4148053000', '금촌3동'),
	('4148054000', '교하동'),
	('4148055000', '운정1동'),
	('4148056000', '운정2동'),
	('4148057000', '운정3동'),
	('4150025000', '장호원읍'),
	('4150025300', '부발읍'),
	('4150031000', '신둔면'),
	('4150032000', '백사면'),
	('4150033000', '호법면'),
	('4150034000', '마장면'),
	('4150035000', '대월면'),
	('4150036000', '모가면'),
	('4150037000', '설성면'),
	('4150038000', '율면'),
	('4150051000', '창전동'),
	('4150051500', '증포동'),
	('4150052000', '중리동'),
	('4150053000', '관고동'),
	('4155025000', '공도읍'),
	('4155031000', '보개면'),
	('4155032000', '금광면'),
	('4155033000', '서운면'),
	('4155034000', '미양면'),
	('4155035000', '대덕면'),
	('4155036000', '양성면'),
	('4155038000', '원곡면'),
	('4155039000', '일죽면'),
	('4155040000', '죽산면'),
	('4155041000', '삼죽면'),
	('4155042000', '고삼면'),
	('4155051000', '안성1동'),
	('4155052000', '안성2동'),
	('4155053000', '안성3동'),
	('4157025000', '통진읍'),
	('4157025300', '고촌읍'),
	('4157025600', '양촌읍'),
	('4157034000', '대곶면'),
	('4157035000', '월곶면'),
	('4157036000', '하성면'),
	('4157051500', '김포본동'),
	('4157052500', '장기본동'),
	('4157054000', '사우동'),
	('4157055000', '풍무동'),
	('4157056000', '장기동'),
	('4157057000', '구래동'),
	('4157058000', '운양동'),
	('4159025300', '봉담읍'),
	('4159025600', '우정읍'),
	('4159025900', '향남읍'),
	('4159026200', '남양읍'),
	('4159031000', '매송면'),
	('4159032000', '비봉면'),
	('4159033000', '마도면'),
	('4159034000', '송산면'),
	('4159035000', '서신면'),
	('4159036000', '팔탄면'),
	('4159037000', '장안면'),
	('4159040000', '양감면'),
	('4159041000', '정남면'),
	('4159051500', '새솔동'),
	('4159052000', '진안동'),
	('4159053000', '병점1동'),
	('4159054000', '병점2동'),
	('4159055000', '반월동'),
	('4159056000', '기배동'),
	('4159057000', '화산동'),
	('4159058500', '동탄1동'),
	('4159058600', '동탄2동'),
	('4159058700', '동탄3동'),
	('4159058800', '동탄4동'),
	('4159059000', '동탄5동'),
	('4159060000', '동탄6동'),
	('4159061000', '동탄7동'),
	('4161025000', '오포읍'),
	('4161025300', '초월읍'),
	('4161025900', '곤지암읍'),
	('4161033000', '도척면'),
	('4161034000', '퇴촌면'),
	('4161035000', '남종면'),
	('4161037000', '남한산성면'),
	('4161051000', '경안동'),
	('4161052000', '송정동'),
	('4161053000', '광남동'),
	('4163025000', '백석읍'),
	('4163031000', '은현면'),
	('4163032000', '남면'),
	('4163033000', '광적면'),
	('4163034000', '장흥면'),
	('4163051000', '양주1동'),
	('4163052000', '양주2동'),
	('4163053000', '회천1동'),
	('4163054000', '회천2동'),
	('4163055000', '회천3동'),
	('4163056000', '회천4동'),
	('4165025000', '소흘읍'),
	('4165031000', '군내면'),
	('4165032000', '내촌면'),
	('4165033000', '가산면'),
	('4165034000', '신북면'),
	('4165035000', '창수면'),
	('4165036000', '영중면'),
	('4165037000', '일동면'),
	('4165038000', '이동면'),
	('4165039000', '영북면'),
	('4165040000', '관인면'),
	('4165041000', '화현면'),
	('4165051000', '포천동'),
	('4165052000', '선단동'),
	('4167025000', '가남읍'),
	('4167031000', '점동면'),
	('4167032000', '흥천면'),
	('4167033000', '금사면'),
	('4167034000', '능서면'),
	('4167035000', '대신면'),
	('4167036000', '북내면'),
	('4167037000', '강천면'),
	('4167038000', '산북면'),
	('4167051000', '여흥동'),
	('4167052000', '중앙동'),
	('4167053000', '오학동'),
	('4180025000', '연천읍'),
	('4180025300', '전곡읍'),
	('4180031000', '군남면'),
	('4180032000', '청산면'),
	('4180033000', '백학면'),
	('4180034000', '미산면'),
	('4180035000', '왕징면'),
	('4180036000', '신서면'),
	('4180037000', '중면'),
	('4180038000', '장남면'),
	('4182025000', '가평읍'),
	('4182031000', '설악면'),
	('4182032500', '청평면'),
	('4182033000', '상면'),
	('4182034500', '조종면'),
	('4182035000', '북면'),
	('4183025000', '양평읍'),
	('4183031000', '강상면'),
	('4183032000', '강하면'),
	('4183033000', '양서면'),
	('4183034000', '옥천면'),
	('4183035000', '서종면'),
	('4183036000', '단월면'),
	('4183037000', '청운면'),
	('4183038000', '양동면'),
	('4183039500', '지평면'),
	('4183040000', '용문면'),
	('4183041000', '개군면'),
	('4211025000', '신북읍'),
	('4211031000', '동면'),
	('4211032000', '동산면'),
	('4211033000', '신동면'),
	('4211034000', '남면'),
	('4211035000', '서면'),
	('4211036000', '사북면'),
	('4211038000', '북산면'),
	('4211039000', '동내면'),
	('4211040000', '남산면'),
	('4211052000', '교동'),
	('4211053000', '조운동'),
	('4211054500', '약사명동'),
	('4211057000', '근화동'),
	('4211058000', '소양동'),
	('4211060000', '후평1동'),
	('4211061000', '후평2동'),
	('4211061100', '후평3동'),
	('4211062000', '효자1동'),
	('4211063000', '효자2동'),
	('4211064000', '효자3동'),
	('4211065000', '석사동'),
	('4211066000', '퇴계동'),
	('4211067500', '강남동'),
	('4211070500', '신사우동'),
	('4213025000', '문막읍'),
	('4213031000', '소초면'),
	('4213032000', '호저면'),
	('4213033000', '지정면'),
	('4213035000', '부론면'),
	('4213036000', '귀래면'),
	('4213037000', '흥업면'),
	('4213038000', '판부면'),
	('4213039000', '신림면'),
	('4213051500', '중앙동'),
	('4213052000', '원인동'),
	('4213053000', '개운동'),
	('4213054100', '명륜1동'),
	('4213054200', '명륜2동'),
	('4213055000', '단구동'),
	('4213056000', '일산동'),
	('4213057500', '학성동'),
	('4213059000', '단계동'),
	('4213060000', '우산동'),
	('4213061000', '태장1동'),
	('4213062000', '태장2동'),
	('4213063500', '봉산동'),
	('4213065000', '행구동'),
	('4213066000', '무실동'),
	('4213067500', '반곡관설동'),
	('4215025000', '주문진읍'),
	('4215031000', '성산면'),
	('4215032000', '왕산면'),
	('4215033000', '구정면'),
	('4215034000', '강동면'),
	('4215035000', '옥계면'),
	('4215036000', '사천면'),
	('4215037000', '연곡면'),
	('4215051000', '홍제동'),
	('4215052000', '중앙동'),
	('4215054000', '옥천동'),
	('4215055000', '교1동'),
	('4215056000', '교2동'),
	('4215057100', '포남1동'),
	('4215057200', '포남2동'),
	('4215058000', '초당동'),
	('4215059000', '송정동'),
	('4215060000', '내곡동'),
	('4215061500', '강남동'),
	('4215064500', '성덕동'),
	('4215066500', '경포동'),
	('4217051000', '천곡동'),
	('4217052000', '송정동'),
	('4217053000', '북삼동'),
	('4217054000', '부곡동'),
	('4217055000', '동호동'),
	('4217057000', '발한동'),
	('4217059000', '묵호동'),
	('4217060000', '북평동'),
	('4217063000', '망상동'),
	('4217065000', '삼화동'),
	('4219051500', '황지동'),
	('4219052500', '황연동'),
	('4219053500', '삼수동'),
	('4219054000', '상장동'),
	('4219058500', '문곡소도동'),
	('4219059500', '장성동'),
	('4219060500', '구문소동'),
	('4219061500', '철암동'),
	('4221051000', '영랑동'),
	('4221052000', '동명동'),
	('4221054000', '금호동'),
	('4221056000', '교동'),
	('4221057000', '노학동'),
	('4221058000', '조양동'),
	('4221059000', '청호동'),
	('4221060000', '대포동'),
	('4223025000', '도계읍'),
	('4223025300', '원덕읍'),
	('4223025400', '원덕읍임원출장소'),
	('4223031000', '근덕면'),
	('4223032000', '하장면'),
	('4223033000', '노곡면'),
	('4223034000', '미로면'),
	('4223035000', '가곡면'),
	('4223036000', '신기면'),
	('4223051000', '남양동'),
	('4223053000', '교동'),
	('4223054000', '정라동'),
	('4223057000', '성내동'),
	('4272025000', '홍천읍'),
	('4272031000', '화촌면'),
	('4272032000', '두촌면'),
	('4272033000', '내촌면'),
	('4272034000', '서석면'),
	('4272035000', '동면'),
	('4272036000', '남면'),
	('4272037000', '서면'),
	('4272038000', '북방면'),
	('4272039000', '내면'),
	('4273025000', '횡성읍'),
	('4273031000', '우천면'),
	('4273032000', '안흥면'),
	('4273033000', '둔내면'),
	('4273034000', '갑천면'),
	('4273035000', '청일면'),
	('4273036000', '공근면'),
	('4273037000', '서원면'),
	('4273038000', '강림면'),
	('4275025000', '영월읍'),
	('4275025300', '상동읍'),
	('4275031000', '중동면'),
	('4275032500', '김삿갓면'),
	('4275033000', '북면'),
	('4275034000', '남면'),
	('4275035500', '한반도면'),
	('4275035900', '한반도면쌍용출장'),
	('4275036000', '주천면'),
	('4275038000', '무릉도원면'),
	('4276025000', '평창읍'),
	('4276031000', '미탄면'),
	('4276032000', '방림면'),
	('4276032500', '방림면계촌출장소'),
	('4276033000', '대화면'),
	('4276034000', '봉평면'),
	('4276035000', '용평면'),
	('4276036000', '진부면'),
	('4276038000', '대관령면'),
	('4277025000', '정선읍'),
	('4277025300', '고한읍'),
	('4277025600', '사북읍'),
	('4277025900', '신동읍'),
	('4277026000', '신동읍함백출장소'),
	('4277032000', '남면'),
	('4277034000', '북평면'),
	('4277035000', '임계면'),
	('4277036000', '화암면'),
	('4277037000', '여량면'),
	('4278025000', '철원읍'),
	('4278025300', '김화읍'),
	('4278025600', '갈말읍'),
	('4278025900', '동송읍'),
	('4278031000', '서면'),
	('4278031500', '서면와수출장소'),
	('4278032000', '근남면'),
	('4278033000', '근북면'),
	('4278034000', '근동면'),
	('4278035000', '원동면'),
	('4278036000', '원남면'),
	('4278037000', '임남면'),
	('4279025000', '화천읍'),
	('4279031000', '간동면'),
	('4279032000', '하남면'),
	('4279033000', '상서면'),
	('4279034000', '사내면'),
	('4280025000', '양구읍'),
	('4280031000', '남면'),
	('4280032000', '동면'),
	('4280033000', '방산면'),
	('4280034000', '해안면'),
	('4281025000', '인제읍'),
	('4281025100', '인제읍귀둔출장소'),
	('4281031000', '남면'),
	('4281032000', '북면'),
	('4281033000', '기린면'),
	('4281034000', '서화면'),
	('4281035000', '상남면'),
	('4282025000', '간성읍'),
	('4282025300', '거진읍'),
	('4282031000', '현내면'),
	('4282032000', '죽왕면'),
	('4282033000', '토성면'),
	('4282034000', '수동면'),
	('4283025000', '양양읍'),
	('4283031000', '서면'),
	('4283032000', '손양면'),
	('4283033000', '현북면'),
	('4283034000', '현남면'),
	('4283035000', '강현면'),
	('4311131000', '낭성면'),
	('4311132000', '미원면'),
	('4311133000', '가덕면'),
	('4311134000', '남일면'),
	('4311135000', '문의면'),
	('4311152500', '중앙동'),
	('4311154500', '성안동'),
	('4311162000', '탑대성동'),
	('4311167000', '영운동'),
	('4311168000', '금천동'),
	('4311169000', '용담.명암.산성동'),
	('4311172000', '용암1동'),
	('4311173000', '용암2동'),
	('4311231000', '남이면'),
	('4311232000', '현도면'),
	('4311251000', '사직1동'),
	('4311252000', '사직2동'),
	('4311253000', '사창동'),
	('4311254000', '모충동'),
	('4311255000', '산남동'),
	('4311256000', '분평동'),
	('4311257000', '수곡1동'),
	('4311258000', '수곡2동'),
	('4311259000', '성화.개신.죽림동'),
	('4311325000', '오송읍'),
	('4311331000', '강내면'),
	('4311332000', '옥산면'),
	('4311370000', '운천.신봉동'),
	('4311374100', '복대1동'),
	('4311374200', '복대2동'),
	('4311374700', '가경동'),
	('4311375100', '봉명1동'),
	('4311375600', '봉명2.송정동'),
	('4311376000', '강서제1동'),
	('4311377000', '강서제2동'),
	('4311425000', '내수읍'),
	('4311425300', '오창읍'),
	('4311431000', '북이면'),
	('4311451000', '우암동'),
	('4311452000', '내덕1동'),
	('4311453000', '내덕2동'),
	('4311454000', '율량.사천동'),
	('4311455000', '오근장동'),
	('4313025000', '주덕읍'),
	('4313031000', '살미면'),
	('4313032500', '수안보면'),
	('4313033500', '대소원면'),
	('4313035000', '신니면'),
	('4313036000', '노은면'),
	('4313037000', '앙성면'),
	('4313038500', '중앙탑면'),
	('4313039000', '금가면'),
	('4313040000', '동량면'),
	('4313041000', '산척면'),
	('4313042000', '엄정면'),
	('4313043000', '소태면'),
	('4313051500', '성내.충인동'),
	('4313053500', '교현.안림동'),
	('4313054000', '교현2동'),
	('4313055000', '용산동'),
	('4313056000', '지현동'),
	('4313057100', '문화동'),
	('4313058000', '호암.직동'),
	('4313060500', '달천동'),
	('4313061000', '봉방동'),
	('4313062500', '칠금.금릉동'),
	('4313063000', '연수동'),
	('4313064000', '목행.용탄동'),
	('4315025000', '봉양읍'),
	('4315031000', '금성면'),
	('4315032000', '청풍면'),
	('4315033000', '수산면'),
	('4315034000', '덕산면'),
	('4315035000', '한수면'),
	('4315036000', '백운면'),
	('4315038000', '송학면'),
	('4315051000', '교동'),
	('4315051800', '의림지동'),
	('4315052800', '중앙동'),
	('4315053700', '남현동'),
	('4315054700', '영서동'),
	('4315056000', '용두동'),
	('4315057700', '신백동'),
	('4315059000', '청전동'),
	('4315060500', '화산동'),
	('4372025000', '보은읍'),
	('4372031500', '속리산면'),
	('4372032500', '장안면'),
	('4372033000', '마로면'),
	('4372034000', '탄부면'),
	('4372035000', '삼승면'),
	('4372036000', '수한면'),
	('4372037000', '회남면'),
	('4372038500', '회인면'),
	('4372039000', '내북면'),
	('4372040000', '산외면'),
	('4373025000', '옥천읍'),
	('4373031000', '동이면'),
	('4373032000', '안남면'),
	('4373033000', '안내면'),
	('4373034000', '청성면'),
	('4373035000', '청산면'),
	('4373036000', '이원면'),
	('4373037000', '군서면'),
	('4373038000', '군북면'),
	('4374025000', '영동읍'),
	('4374031000', '용산면'),
	('4374032000', '황간면'),
	('4374033500', '추풍령면'),
	('4374034000', '매곡면'),
	('4374035000', '상촌면'),
	('4374036000', '양강면'),
	('4374037000', '용화면'),
	('4374038000', '학산면'),
	('4374039000', '양산면'),
	('4374040000', '심천면'),
	('4374525000', '증평읍'),
	('4374531000', '도안면'),
	('4375025000', '진천읍'),
	('4375025300', '덕산읍'),
	('4375032000', '초평면'),
	('4375033000', '문백면'),
	('4375034000', '백곡면'),
	('4375035000', '이월면'),
	('4375037000', '광혜원면'),
	('4376025000', '괴산읍'),
	('4376031000', '감물면'),
	('4376032000', '장연면'),
	('4376033000', '연풍면'),
	('4376034000', '칠성면'),
	('4376035000', '문광면'),
	('4376036000', '청천면'),
	('4376037000', '청안면'),
	('4376039000', '사리면'),
	('4376040000', '소수면'),
	('4376041000', '불정면'),
	('4377025000', '음성읍'),
	('4377025300', '금왕읍'),
	('4377031000', '소이면'),
	('4377032000', '원남면'),
	('4377033000', '맹동면'),
	('4377034000', '대소면'),
	('4377035000', '삼성면'),
	('4377036000', '생극면'),
	('4377037000', '감곡면'),
	('4380025000', '단양읍'),
	('4380025300', '매포읍'),
	('4380031000', '대강면'),
	('4380032000', '가곡면'),
	('4380033000', '영춘면'),
	('4380034000', '어상천면'),
	('4380035000', '적성면'),
	('4380036000', '단성면'),
	('4413125000', '목천읍'),
	('4413131000', '풍세면'),
	('4413132000', '광덕면'),
	('4413133000', '북면'),
	('4413134000', '성남면'),
	('4413135000', '수신면'),
	('4413136000', '병천면'),
	('4413137000', '동면'),
	('4413151000', '중앙동'),
	('4413152000', '문성동'),
	('4413153000', '원성1동'),
	('4413154000', '원성2동'),
	('4413155000', '봉명동'),
	('4413156000', '일봉동'),
	('4413157000', '신방동'),
	('4413158000', '청룡동'),
	('4413159000', '신안동'),
	('4413325000', '성환읍'),
	('4413325300', '성거읍'),
	('4413325600', '직산읍'),
	('4413331000', '입장면'),
	('4413351000', '성정1동'),
	('4413352000', '성정2동'),
	('4413353000', '쌍용1동'),
	('4413354000', '쌍용2동'),
	('4413355000', '쌍용3동'),
	('4413356000', '백석동'),
	('4413356500', '불당동'),
	('4413358000', '부성1동'),
	('4413359000', '부성2동'),
	('4415025000', '유구읍'),
	('4415031000', '이인면'),
	('4415032000', '탄천면'),
	('4415033000', '계룡면'),
	('4415034000', '반포면'),
	('4415036000', '의당면'),
	('4415037000', '정안면'),
	('4415038000', '우성면'),
	('4415039000', '사곡면'),
	('4415040000', '신풍면'),
	('4415051000', '중학동'),
	('4415054000', '웅진동'),
	('4415055000', '금학동'),
	('4415056000', '옥룡동'),
	('4415057000', '신관동'),
	('4415059000', '월송동'),
	('4418025000', '웅천읍'),
	('4418031000', '주포면'),
	('4418032000', '오천면'),
	('4418032500', '오천면어항출장소'),
	('4418032700', '오천면원산도출장'),
	('4418033000', '천북면'),
	('4418034000', '청소면'),
	('4418035000', '청라면'),
	('4418036000', '남포면'),
	('4418038000', '주산면'),
	('4418039000', '미산면'),
	('4418040000', '성주면'),
	('4418041000', '주교면'),
	('4418051500', '대천1동'),
	('4418052500', '대천2동'),
	('4418053500', '대천3동'),
	('4418054500', '대천4동'),
	('4418056500', '대천5동'),
	('4420025000', '염치읍'),
	('4420025300', '배방읍'),
	('4420031000', '송악면'),
	('4420033000', '탕정면'),
	('4420035000', '음봉면'),
	('4420036000', '둔포면'),
	('4420037000', '영인면'),
	('4420038000', '인주면'),
	('4420039000', '선장면'),
	('4420040000', '도고면'),
	('4420041000', '신창면'),
	('4420057000', '온양1동'),
	('4420058000', '온양2동'),
	('4420059000', '온양3동'),
	('4420060000', '온양4동'),
	('4420061000', '온양5동'),
	('4420062000', '온양6동'),
	('4421025000', '대산읍'),
	('4421031000', '인지면'),
	('4421032000', '부석면'),
	('4421033000', '팔봉면'),
	('4421034000', '지곡면'),
	('4421036000', '성연면'),
	('4421037000', '음암면'),
	('4421038000', '운산면'),
	('4421039000', '해미면'),
	('4421040000', '고북면'),
	('4421051000', '부춘동'),
	('4421052500', '동문1동'),
	('4421053500', '동문2동'),
	('4421054000', '수석동'),
	('4421055000', '석남동'),
	('4423025000', '강경읍'),
	('4423025300', '연무읍'),
	('4423031000', '성동면'),
	('4423032000', '광석면'),
	('4423033000', '노성면'),
	('4423034000', '상월면'),
	('4423035000', '부적면'),
	('4423036000', '연산면'),
	('4423038000', '벌곡면'),
	('4423039000', '양촌면'),
	('4423040000', '가야곡면'),
	('4423041000', '은진면'),
	('4423042000', '채운면'),
	('4423051000', '취암동'),
	('4423052000', '부창동'),
	('4425031000', '두마면'),
	('4425031500', '엄사면'),
	('4425033000', '신도안면'),
	('4425051000', '금암동'),
	('4427025000', '합덕읍'),
	('4427025300', '송악읍'),
	('4427031000', '고대면'),
	('4427032000', '석문면'),
	('4427033000', '대호지면'),
	('4427034000', '정미면'),
	('4427035000', '면천면'),
	('4427036000', '순성면'),
	('4427037000', '우강면'),
	('4427038000', '신평면'),
	('4427039000', '송산면'),
	('4427051000', '당진1동'),
	('4427052000', '당진2동'),
	('4427053000', '당진3동'),
	('4471025000', '금산읍'),
	('4471031000', '금성면'),
	('4471032000', '제원면'),
	('4471033000', '부리면'),
	('4471034000', '군북면'),
	('4471035000', '남일면'),
	('4471036000', '남이면'),
	('4471037000', '진산면'),
	('4471038000', '복수면'),
	('4471039000', '추부면'),
	('4476025000', '부여읍'),
	('4476031000', '규암면'),
	('4476032000', '은산면'),
	('4476033000', '외산면'),
	('4476034000', '내산면'),
	('4476035000', '구룡면'),
	('4476036000', '홍산면'),
	('4476037000', '옥산면'),
	('4476038000', '남면'),
	('4476039000', '충화면'),
	('4476040000', '양화면'),
	('4476041000', '임천면'),
	('4476042000', '장암면'),
	('4476043000', '세도면'),
	('4476044000', '석성면'),
	('4476045000', '초촌면'),
	('4477025000', '장항읍'),
	('4477025300', '서천읍'),
	('4477031000', '마서면'),
	('4477032000', '화양면'),
	('4477033000', '기산면'),
	('4477034000', '한산면'),
	('4477035000', '마산면'),
	('4477036000', '시초면'),
	('4477037000', '문산면'),
	('4477038000', '판교면'),
	('4477039000', '종천면'),
	('4477040000', '비인면'),
	('4477041000', '서면'),
	('4479025000', '청양읍'),
	('4479031000', '운곡면'),
	('4479032000', '대치면'),
	('4479033000', '정산면'),
	('4479034000', '목면'),
	('4479035000', '청남면'),
	('4479036000', '장평면'),
	('4479037000', '남양면'),
	('4479038000', '화성면'),
	('4479039000', '비봉면'),
	('4480025000', '홍성읍'),
	('4480025300', '광천읍'),
	('4480025600', '홍북읍'),
	('4480032000', '금마면'),
	('4480033000', '홍동면'),
	('4480034000', '장곡면'),
	('4480035000', '은하면'),
	('4480036000', '결성면'),
	('4480037000', '서부면'),
	('4480038000', '갈산면'),
	('4480039000', '구항면'),
	('4481025000', '예산읍'),
	('4481025300', '삽교읍'),
	('4481031000', '대술면'),
	('4481032000', '신양면'),
	('4481033000', '광시면'),
	('4481034000', '대흥면'),
	('4481035000', '응봉면'),
	('4481036000', '덕산면'),
	('4481037000', '봉산면'),
	('4481038000', '고덕면'),
	('4481039000', '신암면'),
	('4481040000', '오가면'),
	('4482525000', '태안읍'),
	('4482525300', '안면읍'),
	('4482531000', '고남면'),
	('4482532000', '남면'),
	('4482533000', '근흥면'),
	('4482534000', '소원면'),
	('4482535000', '원북면'),
	('4482536000', '이원면'),
	('4511151000', '중앙동'),
	('4511153000', '풍남동'),
	('4511160500', '노송동'),
	('4511163500', '완산동'),
	('4511165000', '동서학동'),
	('4511166000', '서서학동'),
	('4511167100', '중화산1동'),
	('4511167200', '중화산2동'),
	('4511168000', '서신동'),
	('4511169100', '평화1동'),
	('4511169200', '평화2동'),
	('4511170100', '삼천1동'),
	('4511170200', '삼천2동'),
	('4511170300', '삼천3동'),
	('4511171100', '효자1동'),
	('4511171200', '효자2동'),
	('4511171300', '효자3동'),
	('4511171400', '효자4동'),
	('4511173000', '효자5동'),
	('4511352500', '진북동'),
	('4511354000', '인후1동'),
	('4511355000', '인후2동'),
	('4511356000', '인후3동'),
	('4511357000', '덕진동'),
	('4511358000', '금암1동'),
	('4511359000', '금암2동'),
	('4511360000', '팔복동'),
	('4511361100', '우아1동'),
	('4511361200', '우아2동'),
	('4511362000', '호성동'),
	('4511364100', '송천1동'),
	('4511364200', '송천2동'),
	('4511365000', '조촌동'),
	('4511366000', '동산동'),
	('4511367000', '혁신동'),
	('4513025000', '옥구읍'),
	('4513031000', '옥산면'),
	('4513032000', '회현면'),
	('4513033000', '임피면'),
	('4513034000', '서수면'),
	('4513035000', '대야면'),
	('4513036000', '개정면'),
	('4513037000', '성산면'),
	('4513038000', '나포면'),
	('4513039000', '옥도면'),
	('4513040000', '옥서면'),
	('4513051500', '해신동'),
	('4513053000', '월명동'),
	('4513055000', '신풍동'),
	('4513056000', '삼학동'),
	('4513060500', '중앙동'),
	('4513064000', '흥남동'),
	('4513065000', '조촌동'),
	('4513066000', '경암동'),
	('4513067000', '구암동'),
	('4513068000', '개정동'),
	('4513069000', '수송동'),
	('4513070100', '나운1동'),
	('4513070200', '나운2동'),
	('4513070300', '나운3동'),
	('4513071000', '소룡동'),
	('4513072000', '미성동'),
	('4514025000', '함열읍'),
	('4514031000', '오산면'),
	('4514032000', '황등면'),
	('4514033000', '함라면'),
	('4514034000', '웅포면'),
	('4514035000', '성당면'),
	('4514036000', '용안면'),
	('4514037000', '낭산면'),
	('4514038000', '망성면'),
	('4514039000', '여산면'),
	('4514040000', '금마면'),
	('4514041000', '왕궁면'),
	('4514042000', '춘포면'),
	('4514043000', '삼기면'),
	('4514044000', '용동면'),
	('4514052000', '중앙동'),
	('4514053000', '평화동'),
	('4514056000', '인화동'),
	('4514057000', '동산동'),
	('4514058000', '마동'),
	('4514059500', '남중동'),
	('4514061000', '모현동'),
	('4514062000', '송학동'),
	('4514064600', '영등1동'),
	('4514064700', '영등2동'),
	('4514065200', '어양동'),
	('4514065600', '신동'),
	('4514067000', '팔봉동'),
	('4514069000', '삼성동'),
	('4518025000', '신태인읍'),
	('4518031000', '북면'),
	('4518032000', '입암면'),
	('4518033000', '소성면'),
	('4518034000', '고부면'),
	('4518035000', '영원면'),
	('4518036000', '덕천면'),
	('4518037000', '이평면'),
	('4518038000', '정우면'),
	('4518039000', '태인면'),
	('4518040000', '감곡면'),
	('4518041000', '옹동면'),
	('4518042000', '칠보면'),
	('4518043000', '산내면'),
	('4518044000', '산외면'),
	('4518051000', '수성동'),
	('4518052000', '장명동'),
	('4518053500', '내장상동'),
	('4518054500', '시기동'),
	('4518056500', '초산동'),
	('4518057000', '연지동'),
	('4518058000', '농소동'),
	('4518059500', '상교동'),
	('4519025000', '운봉읍'),
	('4519031000', '주천면'),
	('4519032000', '수지면'),
	('4519033000', '송동면'),
	('4519034000', '주생면'),
	('4519035000', '금지면'),
	('4519036000', '대강면'),
	('4519037000', '대산면'),
	('4519038000', '사매면'),
	('4519039000', '덕과면'),
	('4519040000', '보절면'),
	('4519041000', '산동면'),
	('4519042000', '이백면'),
	('4519045000', '아영면'),
	('4519046000', '산내면'),
	('4519047000', '인월면'),
	('4519051000', '동충동'),
	('4519052000', '죽항동'),
	('4519054000', '노암동'),
	('4519055000', '금동'),
	('4519056000', '왕정동'),
	('4519057000', '향교동'),
	('4519059000', '도통동'),
	('4521025000', '만경읍'),
	('4521032000', '죽산면'),
	('4521033000', '백산면'),
	('4521034000', '용지면'),
	('4521035000', '백구면'),
	('4521036000', '부량면'),
	('4521038000', '공덕면'),
	('4521039000', '청하면'),
	('4521040000', '성덕면'),
	('4521041000', '진봉면'),
	('4521042000', '금구면'),
	('4521043000', '봉남면'),
	('4521044000', '황산면'),
	('4521045000', '금산면'),
	('4521046000', '광활면'),
	('4521051000', '요촌동'),
	('4521052000', '신풍동'),
	('4521054000', '검산동'),
	('4521058000', '교월동'),
	('4571025000', '삼례읍'),
	('4571025300', '봉동읍'),
	('4571025600', '용진읍'),
	('4571032000', '상관면'),
	('4571033000', '이서면'),
	('4571034000', '소양면'),
	('4571035000', '구이면'),
	('4571036000', '고산면'),
	('4571037000', '비봉면'),
	('4571038000', '운주면'),
	('4571039000', '화산면'),
	('4571040000', '동상면'),
	('4571041000', '경천면'),
	('4572025000', '진안읍'),
	('4572031000', '용담면'),
	('4572032000', '안천면'),
	('4572033000', '동향면'),
	('4572034000', '상전면'),
	('4572035000', '백운면'),
	('4572036000', '성수면'),
	('4572037000', '마령면'),
	('4572038000', '부귀면'),
	('4572039000', '정천면'),
	('4572040000', '주천면'),
	('4573025000', '무주읍'),
	('4573031000', '무풍면'),
	('4573032000', '설천면'),
	('4573033000', '적상면'),
	('4573034000', '안성면'),
	('4573035000', '부남면'),
	('4574025000', '장수읍'),
	('4574031000', '산서면'),
	('4574032000', '번암면'),
	('4574033500', '장계면'),
	('4574034000', '천천면'),
	('4574035000', '계남면'),
	('4574036000', '계북면'),
	('4575025000', '임실읍'),
	('4575031000', '청웅면'),
	('4575032000', '운암면'),
	('4575033000', '신평면'),
	('4575034000', '성수면'),
	('4575035500', '오수면'),
	('4575036000', '신덕면'),
	('4575037000', '삼계면'),
	('4575038000', '관촌면'),
	('4575039000', '강진면'),
	('4575040000', '덕치면'),
	('4575041000', '지사면'),
	('4577025000', '순창읍'),
	('4577031000', '인계면'),
	('4577032000', '동계면'),
	('4577033000', '풍산면'),
	('4577034000', '금과면'),
	('4577035000', '팔덕면'),
	('4577036000', '쌍치면'),
	('4577037000', '복흥면'),
	('4577038000', '적성면'),
	('4577039000', '유등면'),
	('4577040000', '구림면'),
	('4579025000', '고창읍'),
	('4579031000', '고수면'),
	('4579032000', '아산면'),
	('4579033000', '무장면'),
	('4579034000', '공음면'),
	('4579035000', '상하면'),
	('4579036000', '해리면'),
	('4579037000', '성송면'),
	('4579038000', '대산면'),
	('4579039000', '심원면'),
	('4579040000', '흥덕면'),
	('4579041000', '성내면'),
	('4579042000', '신림면'),
	('4579043000', '부안면'),
	('4580025000', '부안읍'),
	('4580031000', '주산면'),
	('4580032000', '동진면'),
	('4580033000', '행안면'),
	('4580034000', '계화면'),
	('4580035000', '보안면'),
	('4580036000', '변산면'),
	('4580037000', '진서면'),
	('4580038000', '백산면'),
	('4580039000', '상서면'),
	('4580040000', '하서면'),
	('4580041000', '줄포면'),
	('4580042000', '위도면'),
	('4611051000', '용당1동'),
	('4611052000', '용당2동'),
	('4611053500', '연동'),
	('4611054500', '산정동'),
	('4611055400', '연산동'),
	('4611055800', '원산동'),
	('4611056500', '대성동'),
	('4611059500', '목원동'),
	('4611064000', '동명동'),
	('4611064500', '삼학동'),
	('4611065500', '만호동'),
	('4611066000', '유달동'),
	('4611069500', '죽교동'),
	('4611070500', '북항동'),
	('4611074500', '용해동'),
	('4611075000', '이로동'),
	('4611075600', '상동'),
	('4611075700', '하당동'),
	('4611075800', '신흥동'),
	('4611078000', '삼향동'),
	('4611079000', '옥암동'),
	('4611080000', '부흥동'),
	('4611081000', '부주동'),
	('4613025000', '돌산읍'),
	('4613025100', '돌산읍우두출장소'),
	('4613025200', '돌산읍죽포출장소'),
	('4613031000', '소라면'),
	('4613032000', '율촌면'),
	('4613033000', '화양면'),
	('4613034000', '남면'),
	('4613035000', '화정면'),
	('4613035600', '화정면개도출장소'),
	('4613036000', '삼산면'),
	('4613051500', '동문동'),
	('4613053500', '한려동'),
	('4613057000', '중앙동'),
	('4613060000', '충무동'),
	('4613062500', '광림동'),
	('4613063500', '서강동'),
	('4613065500', '대교동'),
	('4613067000', '국동'),
	('4613068500', '월호동'),
	('4613070000', '여서동'),
	('4613071000', '문수동'),
	('4613073000', '미평동'),
	('4613074000', '둔덕동'),
	('4613076500', '만덕동'),
	('4613078000', '쌍봉동'),
	('4613079000', '시전동'),
	('4613080000', '여천동'),
	('4613081000', '주삼동'),
	('4613082000', '삼일동'),
	('4613083000', '묘도동'),
	('4615025000', '승주읍'),
	('4615031000', '해룡면'),
	('4615031500', '해룡면상삼출장소'),
	('4615031600', '해룡면신대출장소'),
	('4615032000', '서면'),
	('4615033000', '황전면'),
	('4615034000', '월등면'),
	('4615035000', '주암면'),
	('4615036000', '송광면'),
	('4615037000', '외서면'),
	('4615038000', '낙안면'),
	('4615039000', '별량면'),
	('4615040000', '상사면'),
	('4615051500', '향동'),
	('4615054000', '매곡동'),
	('4615055000', '삼산동'),
	('4615056000', '조곡동'),
	('4615057000', '덕연동'),
	('4615058000', '풍덕동'),
	('4615059000', '남제동'),
	('4615060000', '저전동'),
	('4615061000', '장천동'),
	('4615062000', '중앙동'),
	('4615063500', '도사동'),
	('4615066100', '왕조1동'),
	('4615066500', '왕조2동'),
	('4617025000', '남평읍'),
	('4617031000', '세지면'),
	('4617032000', '왕곡면'),
	('4617033000', '반남면'),
	('4617034000', '공산면'),
	('4617035000', '동강면'),
	('4617036000', '다시면'),
	('4617037000', '문평면'),
	('4617038000', '노안면'),
	('4617039000', '금천면'),
	('4617040000', '산포면'),
	('4617042000', '다도면'),
	('4617043000', '봉황면'),
	('4617051000', '송월동'),
	('4617052000', '영강동'),
	('4617054000', '금남동'),
	('4617055000', '성북동'),
	('4617058000', '영산동'),
	('4617060000', '이창동'),
	('4617062000', '빛가람동'),
	('4623025000', '광양읍'),
	('4623031000', '봉강면'),
	('4623032000', '옥룡면'),
	('4623033000', '옥곡면'),
	('4623034000', '진상면'),
	('4623035000', '진월면'),
	('4623036000', '다압면'),
	('4623051500', '골약동'),
	('4623053000', '중마동'),
	('4623054000', '광영동'),
	('4623055000', '금호동'),
	('4623057000', '태인동'),
	('4671025000', '담양읍'),
	('4671031000', '봉산면'),
	('4671032000', '고서면'),
	('4671033500', '가사문학면'),
	('4671034000', '창평면'),
	('4671035000', '대덕면'),
	('4671036000', '무정면'),
	('4671037000', '금성면'),
	('4671038000', '용면'),
	('4671039000', '월산면'),
	('4671040000', '수북면'),
	('4671041000', '대전면'),
	('4672025000', '곡성읍'),
	('4672031000', '오곡면'),
	('4672032000', '삼기면'),
	('4672033000', '석곡면'),
	('4672034000', '목사동면'),
	('4672035000', '죽곡면'),
	('4672036000', '고달면'),
	('4672037000', '옥과면'),
	('4672038000', '입면'),
	('4672039000', '겸면'),
	('4672040000', '오산면'),
	('4673025000', '구례읍'),
	('4673031000', '문척면'),
	('4673032000', '간전면'),
	('4673033000', '토지면'),
	('4673034000', '마산면'),
	('4673035000', '광의면'),
	('4673036000', '용방면'),
	('4673037000', '산동면'),
	('4677025000', '고흥읍'),
	('4677025300', '도양읍'),
	('4677025400', '도양읍소록출장소'),
	('4677025500', '도양읍시산출장소'),
	('4677031000', '풍양면'),
	('4677032000', '도덕면'),
	('4677033000', '금산면'),
	('4677034000', '도화면'),
	('4677035000', '포두면'),
	('4677036000', '봉래면'),
	('4677037000', '점암면'),
	('4677038000', '과역면'),
	('4677039000', '남양면'),
	('4677040000', '동강면'),
	('4677041000', '대서면'),
	('4677042000', '두원면'),
	('4677044000', '영남면'),
	('4677045000', '동일면'),
	('4678025000', '보성읍'),
	('4678025300', '벌교읍'),
	('4678031000', '노동면'),
	('4678032000', '미력면'),
	('4678033000', '겸백면'),
	('4678034000', '율어면'),
	('4678035000', '복내면'),
	('4678036000', '문덕면'),
	('4678037000', '조성면'),
	('4678038000', '득량면'),
	('4678038500', '득량면예당출장소'),
	('4678039000', '회천면'),
	('4678040000', '웅치면'),
	('4679025000', '화순읍'),
	('4679031000', '한천면'),
	('4679031500', '한천면영외출장소'),
	('4679032000', '춘양면'),
	('4679033000', '청풍면'),
	('4679034000', '이양면'),
	('4679035000', '능주면'),
	('4679036000', '도곡면'),
	('4679037000', '도암면'),
	('4679038000', '이서면'),
	('4679039000', '북면'),
	('4679040000', '동복면'),
	('4679041000', '남면'),
	('4679042000', '동면'),
	('4680025000', '장흥읍'),
	('4680025300', '관산읍'),
	('4680025600', '대덕읍'),
	('4680031000', '용산면'),
	('4680032000', '안양면'),
	('4680033000', '장동면'),
	('4680034000', '장평면'),
	('4680035000', '유치면'),
	('4680036000', '부산면'),
	('4680037000', '회진면'),
	('4681025000', '강진읍'),
	('4681031000', '군동면'),
	('4681032000', '칠량면'),
	('4681033000', '대구면'),
	('4681034000', '도암면'),
	('4681035000', '신전면'),
	('4681036000', '성전면'),
	('4681037000', '작천면'),
	('4681038000', '병영면'),
	('4681039000', '옴천면'),
	('4681040000', '마량면'),
	('4682025000', '해남읍'),
	('4682031000', '삼산면'),
	('4682032000', '화산면'),
	('4682033000', '현산면'),
	('4682034000', '송지면'),
	('4682035000', '북평면'),
	('4682036000', '북일면'),
	('4682037000', '옥천면'),
	('4682038000', '계곡면'),
	('4682039000', '마산면'),
	('4682040000', '황산면'),
	('4682041000', '산이면'),
	('4682042000', '문내면'),
	('4682043000', '화원면'),
	('4683025000', '영암읍'),
	('4683025300', '삼호읍'),
	('4683025400', '삼호읍서부출장소'),
	('4683031000', '덕진면'),
	('4683032000', '금정면'),
	('4683033000', '신북면'),
	('4683034000', '시종면'),
	('4683035000', '도포면'),
	('4683036000', '군서면'),
	('4683037000', '서호면'),
	('4683038000', '학산면'),
	('4683039000', '미암면'),
	('4684025000', '무안읍'),
	('4684025300', '일로읍'),
	('4684025600', '삼향읍'),
	('4684025800', '삼향읍남악출장소'),
	('4684032000', '몽탄면'),
	('4684033000', '청계면'),
	('4684034000', '현경면'),
	('4684035000', '망운면'),
	('4684036000', '해제면'),
	('4684037000', '운남면'),
	('4686025000', '함평읍'),
	('4686031000', '손불면'),
	('4686032000', '신광면'),
	('4686033000', '학교면'),
	('4686034000', '엄다면'),
	('4686035000', '대동면'),
	('4686036000', '나산면'),
	('4686037000', '해보면'),
	('4686038000', '월야면'),
	('4687025000', '영광읍'),
	('4687025300', '백수읍'),
	('4687025600', '홍농읍'),
	('4687031000', '대마면'),
	('4687032000', '묘량면'),
	('4687033000', '불갑면'),
	('4687034000', '군서면'),
	('4687035000', '군남면'),
	('4687036000', '염산면'),
	('4687037000', '법성면'),
	('4687038000', '낙월면'),
	('4687038500', '낙월면안마출장소'),
	('4688025000', '장성읍'),
	('4688031000', '진원면'),
	('4688032000', '남면'),
	('4688033000', '동화면'),
	('4688034000', '삼서면'),
	('4688035000', '삼계면'),
	('4688036000', '황룡면'),
	('4688037000', '서삼면'),
	('4688038000', '북일면'),
	('4688039000', '북이면'),
	('4688040000', '북하면'),
	('4689025000', '완도읍'),
	('4689025300', '금일읍'),
	('4689025600', '노화읍'),
	('4689029000', '노화읍넙도출장소'),
	('4689031000', '군외면'),
	('4689032000', '신지면'),
	('4689033000', '고금면'),
	('4689034000', '약산면'),
	('4689035000', '청산면'),
	('4689035500', '청산면모도출장소'),
	('4689036000', '소안면'),
	('4689037000', '금당면'),
	('4689038000', '보길면'),
	('4689039000', '생일면'),
	('4690025000', '진도읍'),
	('4690031000', '군내면'),
	('4690032000', '고군면'),
	('4690033000', '의신면'),
	('4690034000', '임회면'),
	('4690035000', '지산면'),
	('4690036000', '조도면'),
	('4690036500', '조도면가사출장소'),
	('4690036600', '조도면거차출장소'),
	('4691025000', '지도읍'),
	('4691025100', '지도읍선도출장소'),
	('4691025300', '압해읍'),
	('4691025400', '압해읍매화출장소'),
	('4691025500', '압해읍고이도출장소'),
	('4691031000', '증도면'),
	('4691031500', '증도면병풍출장소'),
	('4691032000', '임자면'),
	('4691033000', '자은면'),
	('4691034000', '비금면'),
	('4691035000', '도초면'),
	('4691035500', '도초면우이도출장'),
	('4691036000', '흑산면'),
	('4691036500', '흑산면가거도출장'),
	('4691036600', '흑산면태도출장소'),
	('4691036700', '흑산면홍도출장소'),
	('4691036800', '흑산면대둔도출장'),
	('4691037000', '하의면'),
	('4691038000', '신의면'),
	('4691039000', '장산면'),
	('4691040000', '안좌면'),
	('4691040500', '안좌면자라출장소'),
	('4691041000', '팔금면'),
	('4691042000', '암태면'),
	('4711125000', '구룡포읍'),
	('4711125300', '연일읍'),
	('4711125600', '오천읍'),
	('4711131000', '대송면'),
	('4711132000', '동해면'),
	('4711133000', '장기면'),
	('4711135000', '호미곶면'),
	('4711152500', '상대동'),
	('4711154500', '해도동'),
	('4711155000', '송도동'),
	('4711156000', '청림동'),
	('4711157000', '제철동'),
	('4711158000', '효곡동'),
	('4711159000', '대이동'),
	('4711325000', '흥해읍'),
	('4711331000', '신광면'),
	('4711332000', '청하면'),
	('4711333000', '송라면'),
	('4711334000', '기계면'),
	('4711335000', '죽장면'),
	('4711335500', '죽장면상옥출장소'),
	('4711336000', '기북면'),
	('4711352000', '중앙동'),
	('4711363000', '양학동'),
	('4711365500', '죽도동'),
	('4711366500', '용흥동'),
	('4711368000', '우창동'),
	('4711369000', '두호동'),
	('4711370000', '장량동'),
	('4711371000', '환여동'),
	('4713025000', '감포읍'),
	('4713025300', '안강읍'),
	('4713025600', '건천읍'),
	('4713025900', '외동읍'),
	('4713031000', '양북면'),
	('4713032000', '양남면'),
	('4713033000', '내남면'),
	('4713034000', '산내면'),
	('4713035000', '서면'),
	('4713036000', '현곡면'),
	('4713037000', '강동면'),
	('4713038000', '천북면'),
	('4713051500', '중부동'),
	('4713053000', '황오동'),
	('4713055000', '성건동'),
	('4713057000', '황남동'),
	('4713059000', '선도동'),
	('4713060500', '월성동'),
	('4713061500', '용강동'),
	('4713062100', '황성동'),
	('4713063000', '동천동'),
	('4713065000', '불국동'),
	('4713066000', '보덕동'),
	('4715025000', '아포읍'),
	('4715031000', '농소면'),
	('4715032000', '남면'),
	('4715034000', '개령면'),
	('4715035000', '감문면'),
	('4715036000', '어모면'),
	('4715037000', '봉산면'),
	('4715038000', '대항면'),
	('4715039000', '감천면'),
	('4715040000', '조마면'),
	('4715041000', '구성면'),
	('4715042000', '지례면'),
	('4715043000', '부항면'),
	('4715044000', '대덕면'),
	('4715045000', '증산면'),
	('4715051600', '자산동'),
	('4715053600', '평화남산동'),
	('4715056500', '양금동'),
	('4715057500', '대신동'),
	('4715059500', '대곡동'),
	('4715061000', '지좌동'),
	('4715064000', '율곡동'),
	('4717025000', '풍산읍'),
	('4717031000', '와룡면'),
	('4717032000', '북후면'),
	('4717033000', '서후면'),
	('4717034000', '풍천면'),
	('4717035000', '일직면'),
	('4717036000', '남후면'),
	('4717037000', '남선면'),
	('4717038000', '임하면'),
	('4717039000', '길안면'),
	('4717040000', '임동면'),
	('4717041000', '예안면'),
	('4717042000', '도산면'),
	('4717043000', '녹전면'),
	('4717051000', '중구동'),
	('4717052000', '명륜동'),
	('4717055500', '용상동'),
	('4717058500', '서구동'),
	('4717060000', '태화동'),
	('4717062000', '평화동'),
	('4717063000', '안기동'),
	('4717065000', '옥동'),
	('4717066000', '송하동'),
	('4717069000', '강남동'),
	('4719025000', '선산읍'),
	('4719025300', '고아읍'),
	('4719031000', '무을면'),
	('4719032000', '옥성면'),
	('4719033000', '도개면'),
	('4719034000', '해평면'),
	('4719035000', '산동면'),
	('4719036000', '장천면'),
	('4719051000', '송정동'),
	('4719052000', '원평1동'),
	('4719053000', '원평2동'),
	('4719055100', '도량동'),
	('4719055500', '지산동'),
	('4719056500', '선주원남동'),
	('4719058200', '형곡1동'),
	('4719058300', '형곡2동'),
	('4719059000', '신평1동'),
	('4719060000', '신평2동'),
	('4719061000', '비산동'),
	('4719062100', '공단1동'),
	('4719062200', '공단2동'),
	('4719063000', '광평동'),
	('4719064500', '상모사곡동'),
	('4719066000', '임오동'),
	('4719067000', '인동동'),
	('4719068000', '진미동'),
	('4719069000', '양포동'),
	('4721025000', '풍기읍'),
	('4721031000', '이산면'),
	('4721032000', '평은면'),
	('4721033000', '문수면'),
	('4721034000', '장수면'),
	('4721035000', '안정면'),
	('4721036000', '봉현면'),
	('4721037000', '순흥면'),
	('4721038000', '단산면'),
	('4721039000', '부석면'),
	('4721051000', '상망동'),
	('4721052500', '하망동'),
	('4721055000', '영주1동'),
	('4721056000', '영주2동'),
	('4721059000', '휴천1동'),
	('4721060000', '휴천2동'),
	('4721061000', '휴천3동'),
	('4721062000', '가흥1동'),
	('4721063000', '가흥2동'),
	('4723025000', '금호읍'),
	('4723031000', '청통면'),
	('4723032000', '신녕면'),
	('4723033000', '화산면'),
	('4723034000', '화북면'),
	('4723035000', '화남면'),
	('4723036000', '자양면'),
	('4723037000', '임고면'),
	('4723038000', '고경면'),
	('4723039000', '북안면'),
	('4723040000', '대창면'),
	('4723051000', '동부동'),
	('4723052000', '중앙동'),
	('4723053500', '서부동'),
	('4723054000', '완산동'),
	('4723055500', '남부동'),
	('4725025000', '함창읍'),
	('4725031000', '중동면'),
	('4725032000', '사벌면'),
	('4725033000', '낙동면'),
	('4725033500', '낙동면동부출장소'),
	('4725034000', '청리면'),
	('4725035000', '공성면'),
	('4725036000', '외남면'),
	('4725037000', '내서면'),
	('4725038000', '모동면'),
	('4725039000', '모서면'),
	('4725039500', '모서면서부출장소'),
	('4725040000', '화동면'),
	('4725041000', '화서면'),
	('4725042000', '화북면'),
	('4725042600', '화북면서부출장소'),
	('4725043000', '외서면'),
	('4725044000', '은척면'),
	('4725044500', '은척면북부출장소'),
	('4725045000', '공검면'),
	('4725046000', '이안면'),
	('4725047000', '화남면'),
	('4725052000', '남원동'),
	('4725053000', '북문동'),
	('4725054000', '계림동'),
	('4725055000', '동문동'),
	('4725056000', '동성동'),
	('4725057000', '신흥동'),
	('4728025000', '문경읍'),
	('4728025100', '문경읍갈평출장소'),
	('4728025300', '가은읍'),
	('4728025400', '가은읍북부출장소'),
	('4728031000', '영순면'),
	('4728032000', '산양면'),
	('4728033000', '호계면'),
	('4728034000', '산북면'),
	('4728035000', '동로면'),
	('4728036000', '마성면'),
	('4728037000', '농암면'),
	('4728057000', '점촌1동'),
	('4728058000', '점촌2동'),
	('4728059000', '점촌3동'),
	('4728060000', '점촌4동'),
	('4728061000', '점촌5동'),
	('4729025000', '하양읍'),
	('4729025300', '진량읍'),
	('4729031000', '와촌면'),
	('4729033000', '자인면'),
	('4729034000', '용성면'),
	('4729035000', '남산면'),
	('4729036000', '압량면'),
	('4729037000', '남천면'),
	('4729051000', '중방동'),
	('4729052000', '중앙동'),
	('4729053000', '남부동'),
	('4729054100', '서부1동'),
	('4729054200', '서부2동'),
	('4729055000', '북부동'),
	('4729056000', '동부동'),
	('4772025000', '군위읍'),
	('4772031000', '소보면'),
	('4772032000', '효령면'),
	('4772033000', '부계면'),
	('4772034000', '우보면'),
	('4772035000', '의흥면'),
	('4772036000', '산성면'),
	('4772037000', '고로면'),
	('4773025000', '의성읍'),
	('4773031000', '단촌면'),
	('4773032000', '점곡면'),
	('4773033000', '옥산면'),
	('4773034000', '사곡면'),
	('4773035000', '춘산면'),
	('4773036000', '가음면'),
	('4773037000', '금성면'),
	('4773038000', '봉양면'),
	('4773039000', '비안면'),
	('4773040000', '구천면'),
	('4773041000', '단밀면'),
	('4773042000', '단북면'),
	('4773043000', '안계면'),
	('4773044000', '다인면'),
	('4773045000', '신평면'),
	('4773046000', '안평면'),
	('4773047000', '안사면'),
	('4775025000', '청송읍'),
	('4775031500', '주왕산면'),
	('4775032000', '부남면'),
	('4775033000', '현동면'),
	('4775034000', '현서면'),
	('4775035000', '안덕면'),
	('4775036000', '파천면'),
	('4775037000', '진보면'),
	('4776025000', '영양읍'),
	('4776031000', '입암면'),
	('4776032000', '청기면'),
	('4776033000', '일월면'),
	('4776034000', '수비면'),
	('4776035000', '석보면'),
	('4777025000', '영덕읍'),
	('4777031000', '강구면'),
	('4777032000', '남정면'),
	('4777033000', '달산면'),
	('4777034000', '지품면'),
	('4777034500', '지품면원전출장소'),
	('4777035000', '축산면'),
	('4777035500', '축산면축산출장소'),
	('4777036000', '영해면'),
	('4777037000', '병곡면'),
	('4777038000', '창수면'),
	('4782025000', '화양읍'),
	('4782025100', '화양읍남성현출장'),
	('4782025300', '청도읍'),
	('4782025400', '청도읍유호출장소'),
	('4782031000', '각남면'),
	('4782032000', '풍각면'),
	('4782033000', '각북면'),
	('4782034000', '이서면'),
	('4782035000', '운문면'),
	('4782036000', '금천면'),
	('4782037000', '매전면'),
	('4783025300', '대가야읍'),
	('4783031000', '덕곡면'),
	('4783032000', '운수면'),
	('4783033000', '성산면'),
	('4783034000', '다산면'),
	('4783035000', '개진면'),
	('4783036000', '우곡면'),
	('4783037000', '쌍림면'),
	('4784025000', '성주읍'),
	('4784031000', '선남면'),
	('4784032000', '용암면'),
	('4784033000', '수륜면'),
	('4784034000', '가천면'),
	('4784035000', '금수면'),
	('4784036000', '대가면'),
	('4784037000', '벽진면'),
	('4784038000', '초전면'),
	('4784039000', '월항면'),
	('4785025000', '왜관읍'),
	('4785025300', '북삼읍'),
	('4785025600', '석적읍'),
	('4785031000', '지천면'),
	('4785032000', '동명면'),
	('4785033000', '가산면'),
	('4785036000', '약목면'),
	('4785037000', '기산면'),
	('4790025000', '예천읍'),
	('4790031000', '용문면'),
	('4790034000', '감천면'),
	('4790035000', '보문면'),
	('4790036000', '호명면'),
	('4790037000', '유천면'),
	('4790038000', '용궁면'),
	('4790039000', '개포면'),
	('4790040000', '지보면'),
	('4790041000', '풍양면'),
	('4790042000', '효자면'),
	('4790043000', '은풍면'),
	('4792025000', '봉화읍'),
	('4792031000', '물야면'),
	('4792032000', '봉성면'),
	('4792033000', '법전면'),
	('4792034000', '춘양면'),
	('4792035000', '소천면'),
	('4792036000', '재산면'),
	('4792037000', '명호면'),
	('4792038000', '상운면'),
	('4792039000', '석포면'),
	('4793025000', '울진읍'),
	('4793025300', '평해읍'),
	('4793031000', '북면'),
	('4793031500', '북면하당출장소'),
	('4793033000', '근남면'),
	('4793035000', '기성면'),
	('4793036000', '온정면'),
	('4793037000', '죽변면'),
	('4793038000', '후포면'),
	('4793039000', '금강송면'),
	('4793040000', '매화면'),
	('4794025000', '울릉읍'),
	('4794031000', '서면'),
	('4794031500', '서면태하출장소'),
	('4794032000', '북면'),
	('4812125000', '동읍'),
	('4812131000', '북면'),
	('4812132000', '대산면'),
	('4812151000', '의창동'),
	('4812152000', '팔룡동'),
	('4812153000', '명곡동'),
	('4812154000', '봉림동'),
	('4812155000', '용지동'),
	('4812351000', '반송동'),
	('4812352000', '중앙동'),
	('4812353000', '상남동'),
	('4812354000', '사파동'),
	('4812355000', '가음정동'),
	('4812356000', '성주동'),
	('4812357000', '웅남동'),
	('4812531000', '구산면'),
	('4812532000', '진동면'),
	('4812533000', '진북면'),
	('4812534000', '진전면'),
	('4812551000', '현동'),
	('4812552000', '가포동'),
	('4812553000', '월영동'),
	('4812554000', '문화동'),
	('4812556500', '반월중앙동'),
	('4812557000', '완월동'),
	('4812558000', '자산동'),
	('4812561000', '교방동'),
	('4812562000', '노산동'),
	('4812563000', '오동동'),
	('4812564000', '합포동'),
	('4812565000', '산호동'),
	('4812725000', '내서읍'),
	('4812751000', '회원1동'),
	('4812752000', '회원2동'),
	('4812754500', '석전동'),
	('4812755000', '회성동'),
	('4812756000', '양덕1동'),
	('4812757000', '양덕2동'),
	('4812758000', '합성1동'),
	('4812759000', '합성2동'),
	('4812760000', '구암1동'),
	('4812761000', '구암2동'),
	('4812762000', '봉암동'),
	('4812951000', '중앙동'),
	('4812952000', '태평동'),
	('4812953000', '충무동'),
	('4812954000', '여좌동'),
	('4812955000', '태백동'),
	('4812956000', '경화동'),
	('4812957000', '병암동'),
	('4812958000', '석동'),
	('4812959000', '이동'),
	('4812960000', '자은동'),
	('4812961000', '덕산동'),
	('4812962000', '풍호동'),
	('4812963000', '웅천동'),
	('4812964000', '웅동1동'),
	('4812965000', '웅동2동'),
	('4817025000', '문산읍'),
	('4817031000', '내동면'),
	('4817032000', '정촌면'),
	('4817033000', '금곡면'),
	('4817035000', '진성면'),
	('4817036000', '일반성면'),
	('4817037000', '이반성면'),
	('4817038000', '사봉면'),
	('4817039000', '지수면'),
	('4817040000', '대곡면'),
	('4817041000', '금산면'),
	('4817042000', '집현면'),
	('4817043000', '미천면'),
	('4817044000', '명석면'),
	('4817045000', '대평면'),
	('4817046000', '수곡면'),
	('4817051500', '천전동'),
	('4817055500', '성북동'),
	('4817056500', '중앙동'),
	('4817059500', '상봉동'),
	('4817067300', '상대동'),
	('4817067800', '하대동'),
	('4817068000', '상평동'),
	('4817069500', '초장동'),
	('4817071000', '평거동'),
	('4817071500', '신안동'),
	('4817072000', '이현동'),
	('4817073000', '판문동'),
	('4817074000', '가호동'),
	('4817075000', '충무공동'),
	('4822025000', '산양읍'),
	('4822031000', '용남면'),
	('4822033000', '도산면'),
	('4822034000', '광도면'),
	('4822035000', '욕지면'),
	('4822036000', '한산면'),
	('4822037000', '사량면'),
	('4822051000', '도천동'),
	('4822053000', '명정동'),
	('4822055000', '중앙동'),
	('4822059000', '정량동'),
	('4822060000', '북신동'),
	('4822066500', '미수동'),
	('4822067000', '봉평동'),
	('4822070000', '무전동'),
	('4824025000', '사천읍'),
	('4824031000', '정동면'),
	('4824032000', '사남면'),
	('4824033000', '용현면'),
	('4824034000', '축동면'),
	('4824035000', '곤양면'),
	('4824036000', '곤명면'),
	('4824037000', '서포면'),
	('4824051000', '동서동'),
	('4824052000', '선구동'),
	('4824053000', '동서금동'),
	('4824055000', '벌룡동'),
	('4824057000', '향촌동'),
	('4824059500', '남양동'),
	('4824089000', '신수출장소'),
	('4825025000', '진영읍'),
	('4825032000', '주촌면'),
	('4825033000', '진례면'),
	('4825034000', '한림면'),
	('4825035000', '생림면'),
	('4825036000', '상동면'),
	('4825037000', '대동면'),
	('4825051000', '동상동'),
	('4825052000', '회현동'),
	('4825053000', '부원동'),
	('4825054000', '내외동'),
	('4825055000', '북부동'),
	('4825056500', '칠산서부동'),
	('4825058000', '활천동'),
	('4825059000', '삼안동'),
	('4825060000', '불암동'),
	('4825061000', '장유1동'),
	('4825062000', '장유2동'),
	('4825063000', '장유3동'),
	('4827025000', '삼랑진읍'),
	('4827025100', '삼랑진임천출장소'),
	('4827025300', '하남읍'),
	('4827031000', '부북면'),
	('4827032000', '상동면'),
	('4827033000', '산외면'),
	('4827034000', '산내면'),
	('4827035000', '단장면'),
	('4827036000', '상남면'),
	('4827037000', '초동면'),
	('4827038000', '무안면'),
	('4827039000', '청도면'),
	('4827051000', '내일동'),
	('4827052000', '내이동'),
	('4827053000', '삼문동'),
	('4827054000', '가곡동'),
	('4827055000', '교동'),
	('4831031000', '일운면'),
	('4831032000', '동부면'),
	('4831033000', '남부면'),
	('4831034000', '거제면'),
	('4831035000', '둔덕면'),
	('4831036000', '사등면'),
	('4831036600', '사등면가조출장소'),
	('4831037000', '연초면'),
	('4831038000', '하청면'),
	('4831038500', '하청면칠천출장소'),
	('4831039000', '장목면'),
	('4831039500', '장목면외포출장소'),
	('4831051000', '장승포동'),
	('4831053000', '능포동'),
	('4831054000', '아주동'),
	('4831055000', '옥포1동'),
	('4831056000', '옥포2동'),
	('4831057000', '장평동'),
	('4831058000', '고현동'),
	('4831059000', '상문동'),
	('4831060000', '수양동'),
	('4833025300', '물금읍'),
	('4833031000', '동면'),
	('4833032000', '원동면'),
	('4833033000', '상북면'),
	('4833034000', '하북면'),
	('4833051000', '중앙동'),
	('4833051500', '양주동'),
	('4833052000', '삼성동'),
	('4833053000', '강서동'),
	('4833054000', '서창동'),
	('4833055000', '소주동'),
	('4833056000', '평산동'),
	('4833057000', '덕계동'),
	('4872025000', '의령읍'),
	('4872031000', '가례면'),
	('4872032000', '칠곡면'),
	('4872033000', '대의면'),
	('4872034000', '화정면'),
	('4872035000', '용덕면'),
	('4872036000', '정곡면'),
	('4872037000', '지정면'),
	('4872038000', '낙서면'),
	('4872039000', '부림면'),
	('4872040000', '봉수면'),
	('4872041500', '궁류면'),
	('4872042000', '유곡면'),
	('4873025000', '가야읍'),
	('4873025300', '칠원읍'),
	('4873031000', '함안면'),
	('4873032000', '군북면'),
	('4873033000', '법수면'),
	('4873034000', '대산면'),
	('4873035000', '칠서면'),
	('4873036000', '칠북면'),
	('4873038000', '산인면'),
	('4873039000', '여항면'),
	('4874025000', '창녕읍'),
	('4874025300', '남지읍'),
	('4874031000', '고암면'),
	('4874032000', '성산면'),
	('4874033000', '대합면'),
	('4874034000', '이방면'),
	('4874035000', '유어면'),
	('4874036000', '대지면'),
	('4874037000', '계성면'),
	('4874038000', '영산면'),
	('4874039000', '장마면'),
	('4874040000', '도천면'),
	('4874041000', '길곡면'),
	('4874042000', '부곡면'),
	('4882025000', '고성읍'),
	('4882031000', '삼산면'),
	('4882032000', '하일면'),
	('4882033000', '하이면'),
	('4882034000', '상리면'),
	('4882035000', '대가면'),
	('4882036000', '영현면'),
	('4882037000', '영오면'),
	('4882038000', '개천면'),
	('4882039000', '구만면'),
	('4882040000', '회화면'),
	('4882041000', '마암면'),
	('4882042000', '동해면'),
	('4882043000', '거류면'),
	('4884025000', '남해읍'),
	('4884031000', '이동면'),
	('4884032000', '상주면'),
	('4884033000', '삼동면'),
	('4884034000', '미조면'),
	('4884035000', '남면'),
	('4884036000', '서면'),
	('4884037000', '고현면'),
	('4884038000', '설천면'),
	('4884039000', '창선면'),
	('4885025000', '하동읍'),
	('4885031000', '화개면'),
	('4885032000', '악양면'),
	('4885033000', '적량면'),
	('4885034000', '횡천면'),
	('4885035000', '고전면'),
	('4885036000', '금남면'),
	('4885037000', '진교면'),
	('4885038000', '양보면'),
	('4885039000', '북천면'),
	('4885040000', '청암면'),
	('4885041000', '옥종면'),
	('4885042000', '금성면'),
	('4886025000', '산청읍'),
	('4886031000', '차황면'),
	('4886032000', '오부면'),
	('4886033000', '생초면'),
	('4886034000', '금서면'),
	('4886035000', '삼장면'),
	('4886036000', '시천면'),
	('4886037000', '단성면'),
	('4886038000', '신안면'),
	('4886039000', '생비량면'),
	('4886040000', '신등면'),
	('4887025000', '함양읍'),
	('4887031000', '마천면'),
	('4887032000', '휴천면'),
	('4887033000', '유림면'),
	('4887034000', '수동면'),
	('4887035000', '지곡면'),
	('4887036000', '안의면'),
	('4887037000', '서하면'),
	('4887038000', '서상면'),
	('4887039000', '백전면'),
	('4887040000', '병곡면'),
	('4888025000', '거창읍'),
	('4888031000', '주상면'),
	('4888032000', '웅양면'),
	('4888033000', '고제면'),
	('4888034000', '북상면'),
	('4888035000', '위천면'),
	('4888036000', '마리면'),
	('4888037000', '남상면'),
	('4888038000', '남하면'),
	('4888039000', '신원면'),
	('4888040000', '가조면'),
	('4888041000', '가북면'),
	('4889025000', '합천읍'),
	('4889031000', '봉산면'),
	('4889032000', '묘산면'),
	('4889033000', '가야면'),
	('4889034000', '야로면'),
	('4889035000', '율곡면'),
	('4889036000', '초계면'),
	('4889037000', '쌍책면'),
	('4889038000', '덕곡면'),
	('4889039000', '청덕면'),
	('4889040000', '적중면'),
	('4889041000', '대양면'),
	('4889042000', '쌍백면'),
	('4889043000', '삼가면'),
	('4889044000', '가회면'),
	('4889045000', '대병면'),
	('4889046000', '용주면'),
	('5011025000', '한림읍'),
	('5011025300', '애월읍'),
	('5011025600', '구좌읍'),
	('5011025900', '조천읍'),
	('5011031000', '한경면'),
	('5011032000', '추자면'),
	('5011033000', '우도면'),
	('5011051000', '일도1동'),
	('5011052000', '일도2동'),
	('5011053000', '이도1동'),
	('5011054000', '이도2동'),
	('5011055000', '삼도1동'),
	('5011056000', '삼도2동'),
	('5011057000', '용담1동'),
	('5011058000', '용담2동'),
	('5011059000', '건입동'),
	('5011060000', '화북동'),
	('5011061000', '삼양동'),
	('5011062000', '봉개동'),
	('5011063000', '아라동'),
	('5011064000', '오라동'),
	('5011065000', '연동'),
	('5011066000', '노형동'),
	('5011067000', '외도동'),
	('5011068000', '이호동'),
	('5011069000', '도두동'),
	('5013025000', '대정읍'),
	('5013025300', '남원읍'),
	('5013025900', '성산읍'),
	('5013031000', '안덕면'),
	('5013032000', '표선면'),
	('5013051000', '송산동'),
	('5013052000', '정방동'),
	('5013053000', '중앙동'),
	('5013054000', '천지동'),
	('5013055000', '효돈동'),
	('5013056000', '영천동'),
	('5013057000', '동홍동'),
	('5013058000', '서홍동'),
	('5013059000', '대륜동'),
	('5013060000', '대천동'),
	('5013061000', '중문동'),
	('5013062000', '예래동');
/*!40000 ALTER TABLE `dong_code` ENABLE KEYS */;

-- 테이블 spots.free_matching 구조 내보내기
DROP TABLE IF EXISTS `free_matching`;
CREATE TABLE IF NOT EXISTS `free_matching` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `head_uid` int(11) NOT NULL COMMENT '방장',
  `home_matching_entry_uid` int(5) DEFAULT NULL COMMENT 'matching_entry uid',
  `away_matching_entry_uid` int(5) DEFAULT NULL COMMENT 'matching_entry uid',
  `create_date` varchar(50) DEFAULT NULL COMMENT '만든날',
  `matching_date` varchar(50) DEFAULT NULL COMMENT '매칭날, 시간',
  `home_score` int(2) NOT NULL DEFAULT 0,
  `away_score` int(2) NOT NULL DEFAULT 0,
  `ready_num` int(2) NOT NULL DEFAULT 0 COMMENT '한팀 전체 ready하면++ 22가 되면 매칭 완료',
  `place_uid` int(11) NOT NULL,
  `price` int(5) NOT NULL COMMENT '인당 가격',
  `head_price` int(5) NOT NULL COMMENT '방장 가격(22로 안나눠떨어지는건 방장이 더내는걸로)',
  `dong_code` varchar(50) DEFAULT NULL,
  `title` varchar(50) NOT NULL,
  `mvp` int(11) DEFAULT NULL,
  `manager_uid` int(11) NOT NULL,
  PRIMARY KEY (`uid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='자유 매칭';

-- 테이블 데이터 spots.free_matching:~14 rows (대략적) 내보내기
DELETE FROM `free_matching`;
/*!40000 ALTER TABLE `free_matching` DISABLE KEYS */;
INSERT INTO `free_matching` (`uid`, `head_uid`, `home_matching_entry_uid`, `away_matching_entry_uid`, `create_date`, `matching_date`, `home_score`, `away_score`, `ready_num`, `place_uid`, `price`, `head_price`, `dong_code`, `title`, `mvp`, `manager_uid`) VALUES
	(1, 1, 1, 2, '2020-08-10 13:30:50', '2020-08-20 09:00:00', 1, 1, 1, 1, 8000, 8000, '1153010100', '안양천체육생태공원에서 축구하실분 구해요', NULL, 1),
	(2, 257, 3, 4, '2020-08-10 13:30:50', '2020-08-20 19:00:00', 1, 1, 1, 3, 8000, 8000, '1153010100', '고척근린공원에서 6시에 축구할사람 구합니다', NULL, 1),
	(3, 365, 5, 6, '2020-08-10 13:30:50', '2020-08-21 09:00:00', 1, 1, 1, 4, 8000, 8000, '1153010600', '28일 고척스카이돔 축구팟 구합니다', NULL, 3),
	(4, 422, 7, 8, '2020-08-11 13:30:50', '2020-08-21 19:00:00', 0, 0, 0, 5, 8000, 8000, '1165010800\r\n', '즐겁게 같이 볼차실 분 구합니다', NULL, 3),
	(5, 284, 9, 10, '2020-08-11 13:30:50', '2020-08-22 09:00:00', 0, 0, 0, 6, 8000, 8000, '1171011400', '천마공원에서 같이 축구하고 식사할 인원 구합니다', NULL, 2),
	(6, 373, 11, 12, '2020-08-11 13:30:50', '2020-08-22 19:00:00', 0, 0, 0, 21, 8000, 8000, '1159010900', '보라매공원에서 한경기 같이해요', NULL, 2),
	(7, 339, 13, 14, '2020-08-12 13:30:50', '2020-08-23 09:00:00', 0, 0, 0, 7, 8000, 8000, '1174010200\r\n', '축구원 모집합니다', NULL, 4),
	(8, 299, 15, 16, '2020-08-12 13:30:50', '2020-08-23 19:00:00', 0, 0, 0, 8, 8000, 8000, '1162010200\r\n', '축구 한게임 같이해요', NULL, 4),
	(9, 407, 1, 2, '2020-08-12 13:30:50', '2020-08-24 09:00:00', 0, 0, 0, 9, 8000, 8000, '1171011100\r\n', '여기여기 모여라!', NULL, 5),
	(10, 318, 3, 4, '2020-08-13 13:30:50', '2020-08-24 19:00:00', 0, 0, 0, 10, 8000, 8000, '1168011000\r\n', '같이 경기할 인원 구합니다', NULL, 5),
	(11, 366, 5, 6, '2020-08-13 13:30:50', '2020-08-25 09:00:00', 0, 0, 0, 20, 8000, 8000, '1168011400', '탄천 축구할 인원 구해요~', NULL, 1),
	(12, 220, 7, 8, '2020-08-14 13:30:50', '2020-08-25 19:00:00', 0, 0, 0, 15, 8000, 8000, '1156013300\r\n', '대림 인조잔디에서 한판하실분', NULL, 3),
	(13, 432, 9, 10, '2020-08-14 13:30:50', '2020-08-26 09:00:00', 0, 0, 0, 12, 8000, 8000, '1154510200\r\n', '간단하게 한경기 뛸 인원 구합니다', NULL, 2),
	(14, 244, 11, 12, '2020-08-15 13:30:50', '2020-08-27 19:00:00', 0, 0, 0, 11, 8000, 8000, '1174010900\r\n', '광나루축구장에서 축구하실분~', NULL, 4);
/*!40000 ALTER TABLE `free_matching` ENABLE KEYS */;

-- 테이블 spots.matching_entry 구조 내보내기
DROP TABLE IF EXISTS `matching_entry`;
CREATE TABLE IF NOT EXISTS `matching_entry` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `striker1_uid` int(5) DEFAULT NULL,
  `striker2_uid` int(5) DEFAULT NULL,
  `striker3_uid` int(5) DEFAULT NULL,
  `striker4_uid` int(5) DEFAULT NULL,
  `midfielder1_uid` int(5) DEFAULT NULL,
  `midfielder2_uid` int(5) DEFAULT NULL,
  `midfielder3_uid` int(5) DEFAULT NULL,
  `midfielder4_uid` int(5) DEFAULT NULL,
  `defender1_uid` int(5) DEFAULT NULL,
  `defender2_uid` int(5) DEFAULT NULL,
  `defender3_uid` int(5) DEFAULT NULL,
  `defender4_uid` int(5) DEFAULT NULL,
  `goalkeeper_uid` int(5) DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='매칭포지션';

-- 테이블 데이터 spots.matching_entry:~20 rows (대략적) 내보내기
DELETE FROM `matching_entry`;
/*!40000 ALTER TABLE `matching_entry` DISABLE KEYS */;
INSERT INTO `matching_entry` (`uid`, `striker1_uid`, `striker2_uid`, `striker3_uid`, `striker4_uid`, `midfielder1_uid`, `midfielder2_uid`, `midfielder3_uid`, `midfielder4_uid`, `defender1_uid`, `defender2_uid`, `defender3_uid`, `defender4_uid`, `goalkeeper_uid`) VALUES
	(1, 222, NULL, 224, 225, 226, 227, NULL, 229, 230, 231, 232, 233, 234),
	(2, 235, 236, 237, 238, 239, 240, 241, NULL, 243, 244, 245, NULL, 247),
	(3, 248, 249, NULL, NULL, 252, 253, 254, 255, 256, 257, 258, 259, 260),
	(4, 261, 262, 263, 264, 265, 266, NULL, 268, 269, NULL, 271, 272, 273),
	(5, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, NULL, NULL, 286),
	(6, 287, 288, 289, 290, 291, 292, NULL, NULL, 295, 296, 297, 298, 299),
	(7, 300, 301, 302, NULL, 304, 305, 306, NULL, 308, 309, 310, 311, 312),
	(8, 313, 314, 315, NULL, 317, 318, 319, 320, 321, 322, 323, NULL, 325),
	(9, 326, 327, 328, 329, 330, 331, NULL, NULL, 334, 335, 336, 337, 338),
	(10, 339, 340, 341, 342, 343, 344, 345, NULL, 347, 348, 349, NULL, 351),
	(11, 352, 353, 354, 355, 356, 357, 358, 359, 360, 361, NULL, NULL, 364),
	(12, 365, 366, NULL, NULL, 369, 370, 371, 372, 373, 374, 375, 376, 377),
	(13, 378, 379, 380, NULL, 382, 383, 384, NULL, 386, 387, 388, 389, 390),
	(14, 391, 392, 393, 394, 395, 396, 397, 398, 399, 400, 401, 402, 403),
	(15, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416),
	(16, 417, 418, 419, 420, 421, 422, 423, NULL, 425, 426, 427, NULL, 429),
	(17, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(18, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(19, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	(20, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
/*!40000 ALTER TABLE `matching_entry` ENABLE KEYS */;

-- 테이블 spots.place 구조 내보내기
DROP TABLE IF EXISTS `place`;
CREATE TABLE IF NOT EXISTS `place` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `place_name` varchar(50) NOT NULL,
  `price` int(6) NOT NULL,
  `address` varchar(50) DEFAULT NULL,
  `code` varchar(50) DEFAULT NULL,
  `open` time DEFAULT NULL,
  `close` time DEFAULT NULL,
  `lng` text DEFAULT NULL,
  `lat` text DEFAULT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COMMENT='구장 정보';

-- 테이블 데이터 spots.place:~23 rows (대략적) 내보내기
DELETE FROM `place`;
/*!40000 ALTER TABLE `place` DISABLE KEYS */;
INSERT INTO `place` (`uid`, `place_name`, `price`, `address`, `code`, `open`, `close`, `lng`, `lat`) VALUES
	(1, '안양천체육생태공원', 50000, '구로구 신도림동', '1153010100', NULL, NULL, '37.5077345', '126.8805914'),
	(2, '안양천체육생태공원', 60000, '구로구 신도림동', '1153010100', NULL, NULL, '37.5077345', '126.8805914'),
	(3, '고척근린공원 운동장', 70000, '구로구 고척동 산9-14번지', '1153010600', NULL, NULL, '37.505969', '126.853168'),
	(4, '고척스카이돔 야외 축구장', 80000, '구로구 고척동 66-47', '1153010600', NULL, NULL, '37.4958302', '126.8674899'),
	(5, '계남근린공원 인조잔디 축구장', 90000, '구로구 고척동 산6-1', '1153010600', NULL, NULL, '37.5086492', '126.8555162'),
	(6, '천마공원 축구장', 100000, '송파구 마천동 산1-8번지', '1171011400', NULL, NULL, '37.50036', '127.1601091'),
	(7, '송파구시각장애인축구장', 50000, '송파구 올림픽로 474', '1171011100', NULL, NULL, '37.5247175', '127.1175084'),
	(8, '송파구 여성축구장', 60000, '송파구 올림픽로 474', '1171011100', NULL, NULL, '37.5247175', '127.1175084'),
	(9, '성보고등학교', 70000, '관악구 남부순환로156길 39', '1162010200', NULL, NULL, '37.4801177', '126.9207947'),
	(10, '광나루한강공원 축구장', 80000, '강동구 암사동 637-4', '1174010700', NULL, NULL, '37.5499421', '127.1216882'),
	(11, '광나루축구장', 90000, '강동구 천호동 351-1', '1174010900', NULL, NULL, '37.5464653', '127.119443'),
	(12, '동명근린공원 인조잔디축구장', 100000, '강동구 아리수로 78길 43-19', '1174010200', NULL, NULL, '37.5607615', '127.16486'),
	(13, '양화한강공원', 50000, '영등포구 양화동 1-4', '1156013100', NULL, NULL, '37.538351', '126.902254'),
	(14, '영롱이억새구장, 갈대구장', 60000, '영등포구 문래동 5가 31', '1156012300', NULL, NULL, '37.5179868', '126.8813009'),
	(15, '대림운동장 인조잔디구장', 70000, '영등포구 대림동 780', '1156013300', NULL, NULL, '37.4996112', '126.8948104'),
	(16, '양재근린공원 축구장', 80000, '서초구 양재2동 311', '1165010200', NULL, NULL, '37.4715434', '127.0423853'),
	(17, '서울시인재개발원 축구장', 90000, '서초구 서초동 393-1', '1165010800', NULL, NULL, '37.4795371', '127.0218775'),
	(18, '반포한강공원', 100000, '서초구 잠원동 122-1', '1165010600', NULL, NULL, '37.5173518', '127.0182303'),
	(19, '잠원한강공원', 50000, '강남구 압구정동 386', '1168011000', NULL, NULL, '37.5275007', '127.0189266'),
	(20, '탄천물재생센터축구장', 60000, '강남구 일원동 4-12', '1168011400', NULL, NULL, '37.495207', '127.0895837'),
	(21, '보라매공원', 70000, '동작구 여의대방로20길 33', '1159010900', NULL, NULL, '37.4932342', '126.9197115'),
	(22, '노들나루공원 인조잔디구장', 80000, '동작구 노량진로 247', '1159010400', NULL, NULL, '37.5138235', '126.953907'),
	(23, '독산동 잔디축구장', 90000, '금천구 독산1동 1086번지', '1154510200', NULL, NULL, '37.4636133', '126.8841338');
/*!40000 ALTER TABLE `place` ENABLE KEYS */;

-- 테이블 spots.state_code 구조 내보내기
DROP TABLE IF EXISTS `state_code`;
CREATE TABLE IF NOT EXISTS `state_code` (
  `state_code` varchar(50) NOT NULL,
  `state_name` varchar(50) NOT NULL,
  PRIMARY KEY (`state_code`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='시코드';

-- 테이블 데이터 spots.state_code:~17 rows (대략적) 내보내기
DELETE FROM `state_code`;
/*!40000 ALTER TABLE `state_code` DISABLE KEYS */;
INSERT INTO `state_code` (`state_code`, `state_name`) VALUES
	('1100000000', '서울특별시'),
	('2600000000', '부산광역시'),
	('2700000000', '대구광역시'),
	('2800000000', '인천광역시'),
	('2900000000', '광주광역시'),
	('3000000000', '대전광역시'),
	('3100000000', '울산광역시'),
	('3600000000', '세종특별자치시'),
	('4100000000', '경기도'),
	('4200000000', '강원도'),
	('4300000000', '충청북도'),
	('4400000000', '충청남도'),
	('4500000000', '전라북도'),
	('4600000000', '전라남도'),
	('4700000000', '경상북도'),
	('4800000000', '경상남도'),
	('5000000000', '제주특별자치도');
/*!40000 ALTER TABLE `state_code` ENABLE KEYS */;

-- 테이블 spots.team 구조 내보내기
DROP TABLE IF EXISTS `team`;
CREATE TABLE IF NOT EXISTS `team` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `team_name` varchar(50) NOT NULL,
  `team_intro` text DEFAULT NULL,
  `team_rate` double NOT NULL DEFAULT 0,
  `team_win` int(4) NOT NULL DEFAULT 0,
  `team_lose` int(4) NOT NULL DEFAULT 0,
  `team_draw` int(4) NOT NULL DEFAULT 0,
  `captain_uid` int(11) DEFAULT NULL,
  `city_code` varchar(50) DEFAULT NULL,
  `player_num` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `team_name` (`team_name`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COMMENT='팀';

-- 테이블 데이터 spots.team:~51 rows (대략적) 내보내기
DELETE FROM `team`;
/*!40000 ALTER TABLE `team` DISABLE KEYS */;
INSERT INTO `team` (`uid`, `team_name`, `team_intro`, `team_rate`, `team_win`, `team_lose`, `team_draw`, `captain_uid`, `city_code`, `player_num`) VALUES
	(52, '강원 FC', '강원 FC입니다', 80, 8, 2, 0, 219, '4211000000', 11),
	(53, '광주 FC', '광주 FC화이팅', 73.3333333, 11, 3, 1, 230, '4161000000', 11),
	(54, '대구 FC', '대구아인교', 95.3488372, 123, 4, 2, 241, '2711000000\r\n', 11),
	(55, '부산 아이파크', '마 뜨겁나?', 79.3103448, 23, 5, 1, 252, '2635000000\r\n', 11),
	(56, '상주 상무 축구단', '상주 파이팅', 46.4285714, 52, 57, 3, 263, '4725000000\r\n', 11),
	(57, 'FC 서울', '서울 자주합니다', 90.2439024, 74, 6, 2, 274, '1111000000\r\n', 11),
	(58, '성남 FC', '재밌게해봐요', 99.7722095, 876, 2, 0, 285, '4113000000\r\n', 11),
	(59, '수원 삼성 블루윙즈', '화이팅', 99.6941896, 978, 3, 0, 296, '4111000000\r\n', 11),
	(60, '울산 현대 축구단', '울산 현대 축구단 화이팅!~', 50, 4, 4, 0, 307, '3111000000\r\n', 11),
	(61, '인천 유나이티드 FC', '매주 10시 조기축구', 88.3419689, 341, 45, 0, 318, '2811000000\r\n', 11),
	(62, '전북 현대 모터스', '나가자 싸우자 이기자', 12.5, 1, 7, 0, 329, '4511000000\r\n', 11),
	(63, '포항 스틸러스', '축구같이 하실분 구해요', 6.25, 3, 45, 0, 340, '4711000000\r\n', 11),
	(64, '경남 FC', '경남 20대 환영', 82.9268292, 34, 7, 0, 351, '4822000000\r\n', 11),
	(65, '대전 시티즌', '대전 매달 회식', 74.1935483, 23, 8, 0, 362, '3020000000\r\n', 11),
	(66, '부천 FC 1995', '편히 들어오세요', 5.3571428, 3, 53, 0, 373, '4119000000\r\n', 11),
	(67, '서울 이랜드 FC', '서울 우오오오', 80, 24, 4, 2, 384, '1168000000\r\n', 11),
	(68, '수원 FC', '수원 FC', 0.8, 1, 123, 1, 395, '4111000000\r\n', 5),
	(69, '아산 무궁화 축구단', '아산 무궁화 축구단', 96.8503937, 123, 3, 1, 400, '4420000000\r\n', 1),
	(70, '안산 그리너스 FC', '안산 그리너스 FC', 60, 12, 6, 2, 401, '4127000000\r\n', 1),
	(71, 'FC 안양', 'FC 안양', 95.1219512, 78, 2, 2, 402, '4117000000\r\n', 1),
	(72, '전남 드래곤즈', '전남 드래곤즈', 26.3157894, 5, 1, 13, 403, '4611000000\r\n', 1),
	(73, '제주 유나이티드 FC', '제주 유나이티드 FC', 98.3783783, 364, 4, 2, 404, '5011000000\r\n', 1),
	(74, '강릉시청 축구단', '강릉시청 축구단', 90.1098901, 246, 26, 1, 405, '4215000000\r\n', 1),
	(75, '경주시민축구단', '경주시민축구단', 24.2424242, 8, 23, 2, 406, '4713000000\r\n', 1),
	(76, '경주 한국수력원자력 축구단', '경주 한국수력원자력 축구단', 3.3333333, 3, 87, 0, 407, '4713000000\r\n', 1),
	(77, '김포시민축구단', '김포시민축구단', 86.0465116, 37, 4, 2, 408, '4157000000\r\n', 1),
	(78, '김해시청 축구단', '김해시청 축구단', 9.015025, 54, 545, 0, 409, '4825000000\r\n', 1),
	(79, '대전 코레일 축구단', '대전 코레일 축구단', 14.2857142, 1, 6, 0, 410, '3011000000\r\n', 1),
	(80, '목포시청 축구단', '목포시청 축구단', 0.130039, 1, 768, 0, 411, '4611000000\r\n', 1),
	(81, '부산교통공사 축구단', '부산교통공사 축구단', 2.9850746, 2, 65, 0, 412, '2623000000\r\n', 1),
	(82, '양주시민축구단', '양주시민축구단', 91.3738019, 572, 54, 0, 413, '4163000000\r\n', 1),
	(83, '전주시민축구단', '전주시민축구단', 58.1081081, 43, 31, 0, 414, '4511000000\r\n', 1),
	(84, '창원시청 축구단', '창원시청 축구단', 25, 4, 12, 0, 415, '4812000000\r\n', 1),
	(85, '천안시청 축구단', '천안시청 축구단', 26.3157894, 5, 13, 1, 416, '4413000000\r\n', 1),
	(86, '청주 FC', '청주 FC', 30, 6, 3, 11, 417, '4311000000\r\n', 1),
	(87, '춘천시민축구단', '춘천시민축구단', 91.8918918, 34, 2, 1, 418, '4211000000\r\n', 1),
	(88, '평택시민축구단', '평택시민축구단', 37.5, 3, 4, 1, 419, '4122000000\r\n', 1),
	(89, '화성 FC', '화성 FC', 62.5, 5, 2, 1, 420, '4159000000\r\n', 1),
	(90, '고양시민축구단', '고양시민축구단', 60, 6, 3, 1, 421, '4128000000\r\n', 1),
	(91, 'FC 남동', 'FC 남동', 0.9070294, 4, 435, 2, 422, '2820000000\r\n', 1),
	(92, '서울 노원 유나이티드 FC', '우리들의 열정 놀이터', 76.2711864, 45, 3, 11, 423, '1135000000\r\n', 1),
	(93, '서울 중랑 축구단', '열정 놀이터 352', 5.2631578, 2, 34, 2, 424, '1126000000\r\n', 1),
	(94, '시흥 시민축구단', 'Talk about Soccer', 16.2790697, 7, 34, 2, 425, '4139000000\r\n', 1),
	(95, '양평 FC', '축구사랑의 중심', 53.8461538, 7, 3, 3, 426, '4183000000\r\n', 1),
	(96, '여주시민축구단', '더 넓은 세상으로 가는 열쇠', 90.140845, 64, 5, 2, 427, '4167000000\r\n', 1),
	(97, '울산시민축구단', '열정과 도전, 그 이상을 위하여', 91.8367346, 45, 4, 0, 428, '3120000000\r\n', 1),
	(98, '이천시민축구단', '비상하라! 내일의 챔피언이여!', 55.3459119, 88, 68, 3, 429, '4150000000\r\n', 1),
	(99, '진주시민축구단', '거침없는 도전, 위대한 승리!', 62.037037, 67, 7, 34, 430, '4817000000\r\n', 1),
	(100, '충주시민축구단', '멈추지 않는 도전, 승리의 환희! ', 16.3636363, 9, 45, 1, 431, '4313000000\r\n', 1),
	(101, '파주시민축구단', '뜨거운 열정, 깨끗한 승부!', 62.5, 5, 2, 1, 432, '4148000000\r\n', 1),
	(102, '포천시민축구단', '힘찬 도약, 끊임 없는 도전!', 88.4615384, 23, 1, 2, 433, '4165000000\r\n', 1);
/*!40000 ALTER TABLE `team` ENABLE KEYS */;

-- 테이블 spots.team_matching 구조 내보내기
DROP TABLE IF EXISTS `team_matching`;
CREATE TABLE IF NOT EXISTS `team_matching` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `head_uid` int(11) NOT NULL COMMENT '방장',
  `home_team_uid` int(11) NOT NULL,
  `away_team_uid` int(11) DEFAULT NULL,
  `create_date` varchar(50) DEFAULT NULL COMMENT '만든날',
  `matching_date` varchar(50) DEFAULT NULL COMMENT '매칭날, 시간',
  `home_score` int(2) NOT NULL DEFAULT 0,
  `away_score` int(2) NOT NULL DEFAULT 0,
  `ready_num` int(2) NOT NULL DEFAULT 0 COMMENT '한팀 전체 ready하면++ 2가 되면 매칭 완료',
  `place_uid` int(11) DEFAULT NULL,
  `price` int(5) NOT NULL COMMENT '인당 가격',
  `head_price` int(5) NOT NULL COMMENT '방장 가격(22로 안나눠떨어지는건 방장이 더내는걸로)',
  `dong_code` varchar(50) DEFAULT NULL,
  `title` varchar(50) NOT NULL,
  `mvp` int(11) DEFAULT NULL,
  `manager_uid` int(11) NOT NULL,
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COMMENT='팀 매칭';

-- 테이블 데이터 spots.team_matching:~14 rows (대략적) 내보내기
DELETE FROM `team_matching`;
/*!40000 ALTER TABLE `team_matching` DISABLE KEYS */;
INSERT INTO `team_matching` (`uid`, `head_uid`, `home_team_uid`, `away_team_uid`, `create_date`, `matching_date`, `home_score`, `away_score`, `ready_num`, `place_uid`, `price`, `head_price`, `dong_code`, `title`, `mvp`, `manager_uid`) VALUES
	(1, 1, 55, 56, '2020-08-11 19:30:50', '2020-08-20 10:00:00', 0, 0, 2, 1, 7000, 7000, '1153010100\r\n', '8/20에 한경기 뛸 팀 구합니다', NULL, 1),
	(2, 416, 58, 59, '2020-08-12 10:30:50', '2020-08-20 19:00:00', 0, 0, 2, 15, 7000, 7000, '1156013300\r\n', '8월20일 매너게임 할 팀만 들어오새요', NULL, 3),
	(3, 224, 61, 62, '2020-08-12 11:30:50', '2020-08-23 09:00:00', 0, 0, 2, 3, 7000, 7000, '1153010600\r\n', '8/23 9시 아침에 경기할 팀 구해요', NULL, 5),
	(4, 333, 64, 65, '2020-08-12 13:30:50', '2020-08-26 09:00:00', 0, 0, 2, 4, 7000, 7000, '1153010600\r\n', '26일에 고척스카이돔에서 한팔 할 팀 구해요', NULL, 2),
	(5, 411, 67, 68, '2020-08-13 12:30:50', '2020-08-26 18:00:00', 0, 0, 2, 5, 7000, 7000, '1153010600\r\n', '26일에 잘하는 팀과 대전하고싶습니다', NULL, 4),
	(6, 233, 70, 71, '2020-08-14 09:30:50', '2020-08-21 09:00:00', 0, 0, 2, 6, 7000, 7000, '1171011400\r\n', '8/21 같이 볼차실 팀 구합니다', NULL, 1),
	(7, 266, 73, 74, '2020-08-14 13:30:50', '2020-08-21 18:00:00', 0, 0, 2, 7, 7000, 7000, '1171011100\r\n', '21일 저녁에 축구할 팀 구해요', NULL, 3),
	(8, 276, 77, 78, '2020-08-11 19:30:50', '2020-08-22 09:00:00', 0, 0, 2, 8, 7000, 7000, '1171011100\r\n', '22일 매너좋은 팀 구합니다', NULL, 5),
	(9, 297, 80, 81, '2020-08-12 10:30:50', '2020-08-22 18:00:00', 0, 0, 2, 9, 7000, 7000, '1162010200\r\n', '22일 저녁에 가볍게 한경기 할 팀 구해요', NULL, 2),
	(10, 315, 83, 84, '2020-08-12 11:30:50', '2020-08-23 09:00:00', 0, 0, 2, 10, 7000, 7000, '1174010700\r\n', '23일 광나루한강공원에서 한판할 팀 구합니다', NULL, 4),
	(11, 338, 86, 87, '2020-08-12 13:30:50', '2020-08-23 18:00:00', 0, 0, 2, 11, 7000, 7000, '1174010900\r\n', '23일 저녁에 공찰 팀 구해요', NULL, 2),
	(12, 399, 89, 90, '2020-08-13 12:30:50', '2020-08-24 10:00:00', 0, 0, 2, 12, 7000, 7000, '1174010200\r\n', '24일 경기할 팀 구합니다', NULL, 4),
	(13, 331, 92, 93, '2020-08-14 09:30:50', '2020-08-24 18:00:00', 0, 0, 2, 13, 7000, 7000, '1156013100\r\n', '24일 초보팀 들어와주세요', NULL, 3),
	(14, 381, 95, 96, '2020-08-14 13:30:50', '2020-08-27 10:00:00', 0, 0, 2, 14, 7000, 7000, '1156012300\r\n', '27일 축구할 팀 구합니다', NULL, 1);
/*!40000 ALTER TABLE `team_matching` ENABLE KEYS */;

-- 테이블 spots.user 구조 내보내기
DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `password` varchar(50) NOT NULL,
  `win` int(4) NOT NULL DEFAULT 0,
  `lose` int(4) NOT NULL DEFAULT 0,
  `draw` int(4) NOT NULL DEFAULT 0,
  `warning` int(1) NOT NULL DEFAULT 0 COMMENT '경고',
  `team_uid` int(11) NOT NULL DEFAULT 0,
  `nickname` varchar(50) DEFAULT NULL,
  `city_code` varchar(50) DEFAULT NULL,
  `comment` text DEFAULT NULL,
  `mvp` int(11) NOT NULL DEFAULT 0,
  `blacklist` int(11) NOT NULL DEFAULT 0,
  `goal` int(11) NOT NULL DEFAULT 0,
  `assist` int(11) NOT NULL DEFAULT 0,
  `rate` double NOT NULL DEFAULT 0,
  `admin` varchar(50) NOT NULL DEFAULT 'N',
  PRIMARY KEY (`uid`) USING BTREE,
  UNIQUE KEY `email` (`email`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=438 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='사용자';

-- 테이블 데이터 spots.user:~220 rows (대략적) 내보내기
DELETE FROM `user`;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`uid`, `email`, `password`, `win`, `lose`, `draw`, `warning`, `team_uid`, `nickname`, `city_code`, `comment`, `mvp`, `blacklist`, `goal`, `assist`, `rate`, `admin`) VALUES
	(1, 'aaa@aaa.com', '111', 6, 4, 7, 1, 1, '서민규', NULL, NULL, 0, 0, 0, 0, 35.2941176, 'Y'),
	(2, 'bbb@bbb.com', '222', 5, 7, 6, 1, 1, '오정엽', NULL, NULL, 0, 0, 0, 0, 27.7777777, 'Y'),
	(3, 'ccc@ccc.com', '333', 8, 3, 1, 1, 1, '이동옥', NULL, NULL, 0, 0, 0, 0, 66.6666666, 'Y'),
	(4, 'ddd@ddd.com', '444', 4, 3, 7, 0, 1, '정진권', NULL, NULL, 0, 0, 0, 0, 28.5714285, 'Y'),
	(5, 'eee@eee.com', '555', 7, 8, 0, 0, 1, '최현민', NULL, NULL, 0, 0, 0, 0, 46.6666666, 'Y'),
	(219, 'tmp1@ssafy.com', '1', 3, 9, 2, 0, 52, '이광연', NULL, NULL, 0, 0, 0, 0, 21.4285714, 'N'),
	(220, 'tmp2@ssafy.com', '1', 4, 2, 7, 1, 52, '김영빈', NULL, NULL, 0, 0, 0, 0, 30.7692307, 'N'),
	(221, 'tmp3@ssafy.com', '1', 1, 3, 8, 0, 52, '신세계', NULL, NULL, 0, 0, 0, 0, 8.3333333, 'N'),
	(222, 'tmp4@ssafy.com', '1', 1, 10, 7, 0, 52, '이호인', NULL, NULL, 0, 0, 0, 0, 5.5555555, 'N'),
	(223, 'tmp5@ssafy.com', '1', 3, 9, 11, 0, 52, '조지훈', NULL, NULL, 0, 0, 0, 0, 13.0434782, 'N'),
	(224, 'tmp6@ssafy.com', '1', 2, 2, 12, 0, 52, '정석화', NULL, NULL, 0, 0, 0, 0, 12.5, 'N'),
	(225, 'tmp7@ssafy.com', '1', 1, 1, 12, 0, 52, '이재권', NULL, NULL, 0, 0, 0, 0, 7.1428571, 'N'),
	(226, 'tmp8@ssafy.com', '1', 1, 9, 10, 0, 52, '김지현', NULL, NULL, 0, 0, 0, 0, 5, 'N'),
	(227, 'tmp9@ssafy.com', '1', 0, 1, 10, 0, 52, '고무열', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(228, 'tmp10@ssafy.com', '1', 8, 8, 5, 0, 52, '김승대', NULL, NULL, 0, 0, 0, 0, 38.095238, 'N'),
	(229, 'tmp11@ssafy.com', '1', 10, 6, 12, 0, 52, '정민우', NULL, NULL, 0, 0, 0, 0, 35.7142857, 'N'),
	(230, 'tmp12@ssafy.com', '1', 4, 6, 10, 0, 53, '한국영 ', NULL, NULL, 0, 0, 8, 4, 20, 'N'),
	(231, 'tmp13@ssafy.com', '1', 1, 8, 9, 0, 53, '정지용', NULL, NULL, 0, 0, 0, 0, 5.5555555, 'N'),
	(232, 'tmp14@ssafy.com', '1', 4, 3, 12, 0, 53, '지의수', NULL, NULL, 0, 0, 0, 0, 21.0526315, 'N'),
	(233, 'tmp15@ssafy.com', '1', 4, 9, 11, 0, 53, '신광훈', NULL, NULL, 0, 0, 0, 0, 16.6666666, 'N'),
	(234, 'tmp16@ssafy.com', '1', 1, 7, 12, 0, 53, '조재완', NULL, NULL, 0, 0, 0, 0, 5, 'N'),
	(235, 'tmp17@ssafy.com', '1', 4, 3, 6, 0, 53, '채광훈', NULL, NULL, 0, 0, 0, 0, 30.7692307, 'N'),
	(236, 'tmp18@ssafy.com', '1', 3, 0, 7, 0, 53, '조윤성', NULL, NULL, 0, 0, 0, 0, 30, 'N'),
	(237, 'tmp19@ssafy.com', '1', 10, 0, 4, 0, 53, '서민우', NULL, NULL, 0, 0, 0, 0, 71.4285714, 'N'),
	(238, 'tmp20@ssafy.com', '1', 3, 2, 7, 0, 53, '이범수', NULL, NULL, 0, 0, 0, 0, 25, 'N'),
	(239, 'tmp21@ssafy.com', '1', 2, 7, 7, 0, 53, '임채민 ', NULL, NULL, 0, 0, 0, 0, 12.5, 'N'),
	(240, 'tmp22@ssafy.com', '1', 1, 8, 11, 0, 53, '김수혁', NULL, NULL, 0, 0, 0, 0, 5, 'N'),
	(241, 'tmp23@ssafy.com', '1', 9, 1, 12, 0, 54, '김수범', NULL, NULL, 0, 0, 0, 0, 40.9090909, 'N'),
	(242, 'tmp24@ssafy.com', '1', 2, 2, 10, 0, 54, '이현식', NULL, NULL, 0, 0, 0, 0, 14.2857142, 'N'),
	(243, 'tmp25@ssafy.com', '1', 9, 6, 10, 0, 54, '가솔현', NULL, NULL, 0, 0, 0, 0, 36, 'N'),
	(244, 'tmp26@ssafy.com', '1', 9, 2, 7, 0, 54, '이병욱', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(245, 'tmp27@ssafy.com', '1', 7, 5, 10, 0, 54, '이연규', NULL, NULL, 0, 0, 0, 0, 31.8181818, 'N'),
	(246, 'tmp28@ssafy.com', '1', 8, 6, 4, 0, 54, '이영재', NULL, NULL, 0, 0, 0, 0, 44.4444444, 'N'),
	(247, 'tmp29@ssafy.com', '1', 9, 8, 7, 0, 54, '신재욱', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(248, 'tmp30@ssafy.com', '1', 10, 2, 6, 0, 54, '홍원진', NULL, NULL, 0, 0, 0, 0, 55.5555555, 'N'),
	(249, 'tmp31@ssafy.com', '1', 3, 4, 9, 0, 54, '나카자토', NULL, NULL, 0, 0, 0, 0, 18.75, 'N'),
	(250, 'tmp32@ssafy.com', '1', 5, 5, 9, 0, 54, '이강한', NULL, NULL, 0, 0, 0, 0, 26.3157894, 'N'),
	(251, 'tmp33@ssafy.com', '1', 5, 2, 7, 0, 54, '김경중', NULL, NULL, 0, 0, 0, 0, 35.7142857, 'N'),
	(252, 'tmp34@ssafy.com', '1', 2, 5, 9, 0, 55, '권재범', NULL, NULL, 0, 0, 0, 0, 12.5, 'N'),
	(253, 'tmp35@ssafy.com', '1', 6, 9, 5, 0, 55, '송승준', NULL, NULL, 0, 0, 0, 0, 30, 'N'),
	(254, 'tmp36@ssafy.com', '1', 5, 1, 5, 0, 55, '문광석', NULL, NULL, 0, 0, 0, 0, 45.4545454, 'N'),
	(255, 'tmp37@ssafy.com', '1', 4, 7, 2, 0, 55, '박경배', NULL, NULL, 0, 0, 0, 0, 30.7692307, 'N'),
	(256, 'tmp38@ssafy.com', '1', 6, 0, 3, 0, 55, '정현우', NULL, NULL, 0, 0, 0, 0, 66.6666666, 'N'),
	(257, 'tmp39@ssafy.com', '1', 10, 2, 8, 0, 55, '이한도', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(258, 'tmp40@ssafy.com', '1', 10, 1, 4, 0, 55, '이진형', NULL, NULL, 0, 0, 0, 0, 66.6666666, 'N'),
	(259, 'tmp41@ssafy.com', '1', 8, 8, 4, 0, 55, '김주공', NULL, NULL, 0, 0, 0, 0, 40, 'N'),
	(260, 'tmp42@ssafy.com', '1', 4, 5, 9, 0, 55, '김태곤', NULL, NULL, 0, 0, 0, 0, 22.2222222, 'N'),
	(261, 'tmp43@ssafy.com', '1', 3, 3, 3, 0, 55, '이희균', NULL, NULL, 0, 0, 0, 0, 33.3333333, 'N'),
	(262, 'tmp44@ssafy.com', '1', 2, 10, 8, 0, 55, '김진현', NULL, NULL, 0, 0, 0, 0, 10, 'N'),
	(263, 'tmp45@ssafy.com', '1', 2, 9, 1, 0, 56, '김창수', NULL, NULL, 0, 0, 0, 0, 16.6666666, 'N'),
	(264, 'tmp46@ssafy.com', '1', 5, 6, 0, 0, 56, '최준혁', NULL, NULL, 0, 0, 0, 0, 45.4545454, 'N'),
	(265, 'tmp47@ssafy.com', '1', 0, 3, 10, 0, 56, '한희훈', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(266, 'tmp48@ssafy.com', '1', 4, 9, 7, 0, 56, '이민기', NULL, NULL, 0, 0, 0, 0, 20, 'N'),
	(267, 'tmp49@ssafy.com', '1', 1, 4, 5, 0, 56, '한용수', NULL, NULL, 0, 0, 0, 0, 10, 'N'),
	(268, 'tmp50@ssafy.com', '1', 0, 5, 6, 0, 56, '이순민', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(269, 'tmp51@ssafy.com', '1', 0, 0, 6, 0, 56, '마르코', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(270, 'tmp52@ssafy.com', '1', 10, 8, 0, 0, 56, '윌리안', NULL, NULL, 0, 0, 0, 0, 55.5555555, 'N'),
	(271, 'tmp53@ssafy.com', '1', 8, 8, 3, 0, 56, '허율', NULL, NULL, 0, 0, 0, 0, 42.1052631, 'N'),
	(272, 'tmp54@ssafy.com', '1', 3, 5, 4, 0, 56, '아슐마토프', NULL, NULL, 0, 0, 0, 0, 25, 'N'),
	(273, 'tmp55@ssafy.com', '1', 9, 0, 10, 0, 56, '정준연', NULL, NULL, 0, 0, 0, 0, 47.368421, 'N'),
	(274, 'tmp56@ssafy.com', '1', 5, 8, 9, 0, 57, '김태윤', NULL, NULL, 0, 0, 0, 0, 22.7272727, 'N'),
	(275, 'tmp57@ssafy.com', '1', 1, 8, 5, 0, 57, '박준희', NULL, NULL, 0, 0, 0, 0, 7.1428571, 'N'),
	(276, 'tmp58@ssafy.com', '1', 8, 9, 7, 0, 57, '박정수', NULL, NULL, 0, 0, 0, 0, 33.3333333, 'N'),
	(277, 'tmp59@ssafy.com', '1', 6, 8, 9, 0, 57, '여름', NULL, NULL, 0, 0, 0, 0, 26.0869565, 'N'),
	(278, 'tmp60@ssafy.com', '1', 7, 5, 4, 0, 57, '이으뜸', NULL, NULL, 0, 0, 0, 0, 43.75, 'N'),
	(279, 'tmp61@ssafy.com', '1', 9, 9, 5, 0, 57, '펠리페', NULL, NULL, 0, 0, 0, 0, 39.1304347, 'N'),
	(280, 'tmp62@ssafy.com', '1', 1, 1, 2, 0, 57, '임민혁', NULL, NULL, 0, 0, 0, 0, 25, 'N'),
	(281, 'tmp63@ssafy.com', '1', 10, 9, 4, 0, 57, '김정환', NULL, NULL, 0, 0, 0, 0, 43.4782608, 'N'),
	(282, 'tmp64@ssafy.com', '1', 5, 2, 3, 0, 57, '두현석', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(283, 'tmp65@ssafy.com', '1', 4, 3, 4, 0, 57, '여봉훈', NULL, NULL, 0, 0, 0, 0, 36.3636363, 'N'),
	(284, 'tmp66@ssafy.com', '1', 7, 7, 2, 0, 57, '홍준호', NULL, NULL, 0, 0, 0, 0, 43.75, 'N'),
	(285, 'tmp67@ssafy.com', '1', 3, 9, 7, 0, 58, '백도원', NULL, NULL, 0, 0, 0, 0, 15.7894736, 'N'),
	(286, 'tmp68@ssafy.com', '1', 4, 2, 8, 0, 58, '엄원상', NULL, NULL, 0, 0, 0, 0, 28.5714285, 'N'),
	(287, 'tmp69@ssafy.com', '1', 3, 2, 2, 0, 58, '김효기', NULL, NULL, 0, 0, 0, 0, 42.8571428, 'N'),
	(288, 'tmp70@ssafy.com', '1', 1, 4, 4, 0, 58, '양형모', NULL, NULL, 0, 0, 0, 0, 11.1111111, 'N'),
	(289, 'tmp71@ssafy.com', '1', 7, 3, 5, 0, 58, '김준형', NULL, NULL, 0, 0, 0, 0, 46.6666666, 'N'),
	(290, 'tmp72@ssafy.com', '1', 1, 3, 4, 0, 58, '명준재', NULL, NULL, 0, 0, 0, 0, 12.5, 'N'),
	(291, 'tmp73@ssafy.com', '1', 4, 8, 3, 0, 58, '이상민', NULL, NULL, 0, 0, 0, 0, 26.6666666, 'N'),
	(292, 'tmp74@ssafy.com', '1', 9, 10, 4, 0, 58, '최성근', NULL, NULL, 0, 0, 0, 0, 39.1304347, 'N'),
	(293, 'tmp75@ssafy.com', '1', 1, 4, 1, 0, 58, '염기훈 ', NULL, NULL, 0, 0, 0, 0, 16.6666666, 'N'),
	(294, 'tmp76@ssafy.com', '1', 8, 2, 2, 0, 58, '이풍연', NULL, NULL, 0, 0, 0, 0, 66.6666666, 'N'),
	(295, 'tmp77@ssafy.com', '1', 7, 6, 9, 0, 58, '신상휘', NULL, NULL, 0, 0, 0, 0, 31.8181818, 'N'),
	(296, 'tmp78@ssafy.com', '1', 10, 7, 9, 0, 59, '이이기', NULL, NULL, 0, 0, 0, 0, 38.4615384, 'N'),
	(297, 'tmp79@ssafy.com', '1', 8, 6, 7, 0, 59, '장호익', NULL, NULL, 0, 0, 0, 0, 38.095238, 'N'),
	(298, 'tmp80@ssafy.com', '1', 3, 8, 10, 0, 59, '강현욱', NULL, NULL, 0, 0, 0, 0, 14.2857142, 'N'),
	(299, 'tmp81@ssafy.com', '1', 0, 2, 7, 0, 59, '민상기', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(300, 'tmp82@ssafy.com', '1', 1, 7, 5, 0, 59, '이강희', NULL, NULL, 0, 0, 0, 0, 7.6923076, 'N'),
	(301, 'tmp83@ssafy.com', '1', 5, 1, 5, 0, 59, '윤서호', NULL, NULL, 0, 0, 0, 0, 45.4545454, 'N'),
	(302, 'tmp84@ssafy.com', '1', 3, 1, 1, 0, 59, '손호준', NULL, NULL, 0, 0, 0, 0, 60, 'N'),
	(303, 'tmp85@ssafy.com', '1', 8, 3, 8, 0, 59, '고승범', NULL, NULL, 0, 0, 0, 0, 42.1052631, 'N'),
	(304, 'tmp86@ssafy.com', '1', 2, 1, 6, 0, 59, '이용연', NULL, NULL, 0, 0, 0, 0, 22.2222222, 'N'),
	(305, 'tmp87@ssafy.com', '1', 8, 8, 9, 0, 59, '구대영', NULL, NULL, 0, 0, 0, 0, 32, 'N'),
	(306, 'tmp88@ssafy.com', '1', 3, 7, 5, 0, 59, '정상빈', NULL, NULL, 0, 0, 0, 0, 20, 'N'),
	(307, 'tmp89@ssafy.com', '1', 9, 1, 7, 0, 60, '박상혁', NULL, NULL, 0, 0, 0, 0, 52.9411764, 'N'),
	(308, 'tmp90@ssafy.com', '1', 9, 4, 9, 0, 60, '안찬기', NULL, NULL, 0, 0, 0, 0, 40.9090909, 'N'),
	(309, 'tmp91@ssafy.com', '1', 7, 7, 6, 0, 60, '박대원', NULL, NULL, 0, 0, 0, 0, 35, 'N'),
	(310, 'tmp92@ssafy.com', '1', 9, 1, 2, 0, 60, '양상민', NULL, NULL, 0, 0, 0, 0, 75, 'N'),
	(311, 'tmp93@ssafy.com', '1', 3, 5, 0, 0, 60, '헨리', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(312, 'tmp94@ssafy.com', '1', 0, 1, 7, 0, 60, '조성진', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(313, 'tmp95@ssafy.com', '1', 1, 9, 5, 0, 60, '임선영', NULL, NULL, 0, 0, 0, 0, 6.6666666, 'N'),
	(314, 'tmp96@ssafy.com', '1', 3, 3, 2, 0, 60, '크르피치', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(315, 'tmp97@ssafy.com', '1', 2, 9, 5, 0, 60, '안토니스', NULL, NULL, 0, 0, 0, 0, 12.5, 'N'),
	(316, 'tmp98@ssafy.com', '1', 9, 5, 8, 0, 60, '한의권', NULL, NULL, 0, 0, 0, 0, 40.9090909, 'N'),
	(317, 'tmp99@ssafy.com', '1', 3, 9, 5, 0, 60, '김민우', NULL, NULL, 0, 0, 0, 0, 17.6470588, 'N'),
	(318, 'tmp100@ssafy.com', '1', 6, 0, 2, 0, 61, '임상협', NULL, NULL, 0, 0, 0, 0, 75, 'N'),
	(319, 'tmp101@ssafy.com', '1', 9, 4, 4, 0, 61, '김태환', NULL, NULL, 0, 0, 0, 0, 52.9411764, 'N'),
	(320, 'tmp102@ssafy.com', '1', 1, 10, 5, 0, 61, '한석희', NULL, NULL, 0, 0, 0, 0, 6.25, 'N'),
	(321, 'tmp103@ssafy.com', '1', 5, 6, 3, 0, 61, '김건희', NULL, NULL, 0, 0, 0, 0, 35.7142857, 'N'),
	(322, 'tmp104@ssafy.com', '1', 1, 2, 9, 0, 61, '이용혁', NULL, NULL, 0, 0, 0, 0, 8.3333333, 'N'),
	(323, 'tmp105@ssafy.com', '1', 1, 2, 7, 0, 61, '이종성', NULL, NULL, 0, 0, 0, 0, 10, 'N'),
	(324, 'tmp106@ssafy.com', '1', 2, 2, 9, 0, 61, '김종우', NULL, NULL, 0, 0, 0, 0, 15.3846153, 'N'),
	(325, 'tmp107@ssafy.com', '1', 6, 7, 2, 0, 61, '타가트', NULL, NULL, 0, 0, 0, 0, 40, 'N'),
	(326, 'tmp108@ssafy.com', '1', 6, 6, 4, 0, 61, '노동건', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(327, 'tmp109@ssafy.com', '1', 9, 0, 3, 0, 61, '김상준', NULL, NULL, 0, 0, 0, 0, 75, 'N'),
	(328, 'tmp110@ssafy.com', '1', 9, 3, 6, 0, 61, '이진용', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(329, 'tmp111@ssafy.com', '1', 7, 3, 8, 0, 62, '데얀', NULL, NULL, 0, 0, 0, 0, 38.8888888, 'N'),
	(330, 'tmp112@ssafy.com', '1', 8, 8, 2, 0, 62, '이동건', NULL, NULL, 0, 0, 0, 0, 44.4444444, 'N'),
	(331, 'tmp113@ssafy.com', '1', 9, 8, 7, 0, 62, '류재문', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(332, 'tmp114@ssafy.com', '1', 1, 9, 10, 0, 62, '윤종태', NULL, NULL, 0, 0, 0, 0, 5, 'N'),
	(333, 'tmp115@ssafy.com', '1', 9, 1, 7, 0, 62, '하명래', NULL, NULL, 0, 0, 0, 0, 52.9411764, 'N'),
	(334, 'tmp116@ssafy.com', '1', 1, 6, 6, 0, 62, '정치인', NULL, NULL, 0, 0, 0, 0, 7.6923076, 'N'),
	(335, 'tmp117@ssafy.com', '1', 7, 8, 10, 0, 62, '김태한', NULL, NULL, 0, 0, 0, 0, 28, 'N'),
	(336, 'tmp118@ssafy.com', '1', 3, 1, 10, 0, 62, '이찬웅', NULL, NULL, 0, 0, 0, 0, 21.4285714, 'N'),
	(337, 'tmp119@ssafy.com', '1', 2, 0, 0, 0, 62, '이근섭', NULL, NULL, 0, 0, 0, 0, 100, 'N'),
	(338, 'tmp120@ssafy.com', '1', 2, 10, 1, 0, 62, '장성원', NULL, NULL, 0, 0, 0, 0, 15.3846153, 'N'),
	(339, 'tmp121@ssafy.com', '1', 4, 9, 3, 0, 62, '박재경', NULL, NULL, 0, 0, 0, 0, 25, 'N'),
	(340, 'tmp122@ssafy.com', '1', 6, 3, 5, 0, 63, '신중', NULL, NULL, 0, 0, 0, 0, 42.8571428, 'N'),
	(341, 'tmp123@ssafy.com', '1', 6, 8, 3, 0, 63, '이학윤', NULL, NULL, 0, 0, 0, 0, 35.2941176, 'N'),
	(342, 'tmp124@ssafy.com', '1', 3, 3, 2, 0, 63, '안창민', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(343, 'tmp125@ssafy.com', '1', 8, 2, 0, 0, 63, '조우현', NULL, NULL, 0, 0, 0, 0, 80, 'N'),
	(344, 'tmp126@ssafy.com', '1', 9, 0, 5, 0, 63, '츠바사', NULL, NULL, 0, 0, 0, 0, 64.2857142, 'N'),
	(345, 'tmp127@ssafy.com', '1', 2, 6, 6, 0, 63, '박한빈', NULL, NULL, 0, 0, 0, 0, 14.2857142, 'N'),
	(346, 'tmp128@ssafy.com', '1', 3, 7, 4, 0, 63, '구성윤', NULL, NULL, 0, 0, 0, 0, 21.4285714, 'N'),
	(347, 'tmp129@ssafy.com', '1', 9, 10, 0, 0, 63, '고태규', NULL, NULL, 0, 0, 0, 0, 47.368421, 'N'),
	(348, 'tmp130@ssafy.com', '1', 8, 6, 1, 0, 63, '조진우', NULL, NULL, 0, 0, 0, 0, 53.3333333, 'N'),
	(349, 'tmp131@ssafy.com', '1', 2, 9, 3, 0, 63, '이진현', NULL, NULL, 0, 0, 0, 0, 14.2857142, 'N'),
	(350, 'tmp132@ssafy.com', '1', 5, 10, 2, 0, 63, '황태현', NULL, NULL, 0, 0, 0, 0, 29.4117647, 'N'),
	(351, 'tmp133@ssafy.com', '1', 8, 10, 3, 0, 64, '김우석', NULL, NULL, 0, 0, 0, 0, 38.095238, 'N'),
	(352, 'tmp134@ssafy.com', '1', 7, 1, 10, 0, 64, '정태욱', NULL, NULL, 0, 0, 0, 0, 38.8888888, 'N'),
	(353, 'tmp135@ssafy.com', '1', 1, 5, 8, 0, 64, '홍정운 ', NULL, NULL, 0, 0, 0, 0, 7.1428571, 'N'),
	(354, 'tmp136@ssafy.com', '1', 3, 4, 2, 0, 64, '김재우', NULL, NULL, 0, 0, 0, 0, 33.3333333, 'N'),
	(355, 'tmp137@ssafy.com', '1', 2, 3, 4, 0, 64, '신창무', NULL, NULL, 0, 0, 0, 0, 22.2222222, 'N'),
	(356, 'tmp138@ssafy.com', '1', 9, 3, 3, 0, 64, '김선민', NULL, NULL, 0, 0, 0, 0, 60, 'N'),
	(357, 'tmp139@ssafy.com', '1', 2, 7, 6, 0, 64, '에드가', NULL, NULL, 0, 0, 0, 0, 13.3333333, 'N'),
	(358, 'tmp140@ssafy.com', '1', 0, 5, 0, 0, 64, '세징야', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(359, 'tmp141@ssafy.com', '1', 7, 4, 4, 0, 64, '오후성', NULL, NULL, 0, 0, 0, 0, 46.6666666, 'N'),
	(360, 'tmp142@ssafy.com', '1', 2, 5, 8, 0, 64, '김대원', NULL, NULL, 0, 0, 0, 0, 13.3333333, 'N'),
	(361, 'tmp143@ssafy.com', '1', 9, 4, 10, 0, 64, '임재혁', NULL, NULL, 0, 0, 0, 0, 39.1304347, 'N'),
	(362, 'tmp144@ssafy.com', '1', 2, 4, 3, 0, 65, '박민서', NULL, NULL, 0, 0, 0, 0, 22.2222222, 'N'),
	(363, 'tmp145@ssafy.com', '1', 0, 10, 6, 0, 65, '정승원', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(364, 'tmp146@ssafy.com', '1', 6, 5, 2, 0, 65, '정영웅', NULL, NULL, 0, 0, 0, 0, 46.1538461, 'N'),
	(365, 'tmp147@ssafy.com', '1', 9, 7, 1, 0, 65, '황순민', NULL, NULL, 0, 0, 0, 0, 52.9411764, 'N'),
	(366, 'tmp148@ssafy.com', '1', 5, 1, 8, 0, 65, '김동진', NULL, NULL, 0, 0, 0, 0, 35.7142857, 'N'),
	(367, 'tmp149@ssafy.com', '1', 2, 2, 9, 0, 65, '이준희', NULL, NULL, 0, 0, 0, 0, 15.3846153, 'N'),
	(368, 'tmp150@ssafy.com', '1', 1, 6, 9, 0, 65, '고명진', NULL, NULL, 0, 0, 0, 0, 6.25, 'N'),
	(369, 'tmp151@ssafy.com', '1', 2, 3, 9, 0, 65, '김태환', NULL, NULL, 0, 0, 0, 0, 14.2857142, 'N'),
	(370, 'tmp152@ssafy.com', '1', 7, 0, 6, 0, 65, '이현승', NULL, NULL, 0, 0, 0, 0, 53.8461538, 'N'),
	(371, 'tmp153@ssafy.com', '1', 10, 1, 5, 0, 65, '서주환', NULL, NULL, 0, 0, 0, 0, 62.5, 'N'),
	(372, 'tmp154@ssafy.com', '1', 6, 3, 8, 0, 65, '조현택', NULL, NULL, 0, 0, 0, 0, 35.2941176, 'N'),
	(373, 'tmp155@ssafy.com', '1', 2, 5, 4, 0, 66, '장재원', NULL, NULL, 0, 0, 0, 0, 18.1818181, 'N'),
	(374, 'tmp156@ssafy.com', '1', 0, 3, 7, 0, 66, '이형경', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(375, 'tmp157@ssafy.com', '1', 6, 3, 4, 0, 66, '정훈성', NULL, NULL, 0, 0, 0, 0, 46.1538461, 'N'),
	(376, 'tmp158@ssafy.com', '1', 8, 5, 6, 0, 66, '홍철', NULL, NULL, 0, 0, 0, 0, 42.1052631, 'N'),
	(377, 'tmp159@ssafy.com', '1', 1, 7, 9, 0, 66, '박하빈', NULL, NULL, 0, 0, 0, 0, 5.8823529, 'N'),
	(378, 'tmp160@ssafy.com', '1', 4, 9, 6, 0, 66, '김기희', NULL, NULL, 0, 0, 0, 0, 21.0526315, 'N'),
	(379, 'tmp161@ssafy.com', '1', 5, 3, 2, 0, 66, '이기운', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(380, 'tmp162@ssafy.com', '1', 6, 1, 2, 0, 66, '설영우', NULL, NULL, 0, 0, 0, 0, 66.6666666, 'N'),
	(381, 'tmp163@ssafy.com', '1', 2, 4, 6, 0, 66, '이청용', NULL, NULL, 0, 0, 0, 0, 16.6666666, 'N'),
	(382, 'tmp164@ssafy.com', '1', 2, 6, 4, 0, 66, '민동환', NULL, NULL, 0, 0, 0, 0, 16.6666666, 'N'),
	(383, 'tmp165@ssafy.com', '1', 4, 1, 2, 0, 66, '이상헌', NULL, NULL, 0, 0, 0, 0, 57.1428571, 'N'),
	(384, 'tmp166@ssafy.com', '1', 6, 5, 8, 0, 67, '박정인', NULL, NULL, 0, 0, 0, 0, 31.5789473, 'N'),
	(385, 'tmp167@ssafy.com', '1', 7, 1, 4, 0, 67, '정동호', NULL, NULL, 0, 0, 0, 0, 58.3333333, 'N'),
	(386, 'tmp168@ssafy.com', '1', 7, 9, 6, 0, 67, '데이비슨', NULL, NULL, 0, 0, 0, 0, 31.8181818, 'N'),
	(387, 'tmp169@ssafy.com', '1', 4, 4, 10, 0, 67, '불투이스', NULL, NULL, 0, 0, 0, 0, 22.2222222, 'N'),
	(388, 'tmp170@ssafy.com', '1', 9, 3, 9, 0, 67, '김민덕', NULL, NULL, 0, 0, 0, 0, 42.8571428, 'N'),
	(389, 'tmp171@ssafy.com', '1', 5, 2, 6, 0, 67, '박주호', NULL, NULL, 0, 0, 0, 0, 38.4615384, 'N'),
	(390, 'tmp172@ssafy.com', '1', 6, 3, 5, 0, 67, '김인성', NULL, NULL, 0, 0, 0, 0, 42.8571428, 'N'),
	(391, 'tmp173@ssafy.com', '1', 5, 6, 6, 0, 67, '신진호 ', NULL, NULL, 0, 0, 0, 0, 29.4117647, 'N'),
	(392, 'tmp174@ssafy.com', '1', 6, 3, 4, 0, 67, '주니오', NULL, NULL, 0, 0, 0, 0, 46.1538461, 'N'),
	(393, 'tmp175@ssafy.com', '1', 8, 7, 4, 0, 67, '윤빛가람', NULL, NULL, 0, 0, 0, 0, 42.1052631, 'N'),
	(394, 'tmp176@ssafy.com', '1', 9, 6, 8, 0, 67, '이근호', NULL, NULL, 0, 0, 0, 0, 39.1304347, 'N'),
	(395, 'tmp177@ssafy.com', '1', 2, 9, 7, 0, 68, '김민준', NULL, NULL, 0, 0, 0, 0, 11.1111111, 'N'),
	(396, 'tmp178@ssafy.com', '1', 3, 9, 2, 0, 68, '이동경', NULL, NULL, 0, 0, 0, 0, 21.4285714, 'N'),
	(397, 'tmp179@ssafy.com', '1', 1, 6, 7, 0, 68, '정승현', NULL, NULL, 0, 0, 0, 0, 7.1428571, 'N'),
	(398, 'tmp180@ssafy.com', '1', 4, 2, 9, 0, 68, '원두재', NULL, NULL, 0, 0, 0, 0, 26.6666666, 'N'),
	(399, 'tmp181@ssafy.com', '1', 9, 5, 4, 0, 68, '김성준', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(400, 'tmp182@ssafy.com', '1', 0, 8, 4, 0, 69, '비욘 존슨', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(401, 'tmp183@ssafy.com', '1', 6, 3, 7, 0, 70, '조현우', NULL, NULL, 0, 0, 0, 0, 37.5, 'N'),
	(402, 'tmp184@ssafy.com', '1', 9, 1, 3, 0, 71, '정성민', NULL, NULL, 0, 0, 0, 0, 69.2307692, 'N'),
	(403, 'tmp185@ssafy.com', '1', 8, 6, 5, 0, 72, '최필수', NULL, NULL, 0, 0, 0, 0, 42.1052631, 'N'),
	(404, 'tmp186@ssafy.com', '1', 0, 7, 4, 0, 73, '김승준', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(405, 'tmp187@ssafy.com', '1', 8, 6, 8, 0, 74, '김진규', NULL, NULL, 0, 0, 0, 0, 36.3636363, 'N'),
	(406, 'tmp188@ssafy.com', '1', 9, 1, 6, 0, 75, '이규성', NULL, NULL, 0, 0, 0, 0, 56.25, 'N'),
	(407, 'tmp189@ssafy.com', '1', 4, 6, 5, 0, 76, '김정호', NULL, NULL, 0, 0, 0, 0, 26.6666666, 'N'),
	(408, 'tmp190@ssafy.com', '1', 9, 7, 7, 0, 77, '이상준', NULL, NULL, 0, 0, 0, 0, 39.1304347, 'N'),
	(409, 'tmp191@ssafy.com', '1', 6, 6, 9, 0, 78, '박경민', NULL, NULL, 0, 0, 0, 0, 28.5714285, 'N'),
	(410, 'tmp192@ssafy.com', '1', 0, 1, 7, 0, 79, '이지승', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(411, 'tmp193@ssafy.com', '1', 4, 8, 8, 0, 80, '이래준', NULL, NULL, 0, 0, 0, 0, 20, 'N'),
	(412, 'tmp194@ssafy.com', '1', 10, 6, 9, 0, 81, '권혁규', NULL, NULL, 0, 0, 0, 0, 40, 'N'),
	(413, 'tmp195@ssafy.com', '1', 6, 7, 9, 0, 82, '박관우', NULL, NULL, 0, 0, 0, 0, 27.2727272, 'N'),
	(414, 'tmp196@ssafy.com', '1', 2, 6, 9, 0, 83, '김문환', NULL, NULL, 0, 0, 0, 0, 11.7647058, 'N'),
	(415, 'tmp197@ssafy.com', '1', 3, 9, 7, 0, 84, '박호영', NULL, NULL, 0, 0, 0, 0, 15.7894736, 'N'),
	(416, 'tmp198@ssafy.com', '1', 8, 5, 1, 0, 85, '성호영', NULL, NULL, 0, 0, 0, 0, 57.1428571, 'N'),
	(417, 'tmp199@ssafy.com', '1', 2, 2, 1, 0, 86, '황준호', NULL, NULL, 0, 0, 0, 0, 40, 'N'),
	(418, 'tmp200@ssafy.com', '1', 5, 1, 2, 0, 87, '정호정', NULL, NULL, 0, 0, 0, 0, 62.5, 'N'),
	(419, 'tmp201@ssafy.com', '1', 1, 1, 9, 0, 88, '박준강', NULL, NULL, 0, 0, 0, 0, 9.090909, 'N'),
	(420, 'tmp202@ssafy.com', '1', 9, 3, 7, 0, 89, '강민수', NULL, NULL, 0, 0, 0, 0, 47.368421, 'N'),
	(421, 'tmp203@ssafy.com', '1', 2, 2, 9, 0, 90, '도스톤벡', NULL, NULL, 0, 0, 0, 0, 15.3846153, 'N'),
	(422, 'tmp204@ssafy.com', '1', 4, 2, 6, 0, 91, '김동우', NULL, NULL, 0, 0, 0, 0, 33.3333333, 'N'),
	(423, 'tmp205@ssafy.com', '1', 1, 4, 10, 0, 92, '김병오', NULL, NULL, 0, 0, 0, 0, 6.6666666, 'N'),
	(424, 'tmp206@ssafy.com', '1', 5, 1, 2, 0, 93, '박종우', NULL, NULL, 0, 0, 0, 0, 62.5, 'N'),
	(425, 'tmp207@ssafy.com', '1', 3, 5, 1, 0, 94, '빈치씽코', NULL, NULL, 0, 0, 0, 0, 33.3333333, 'N'),
	(426, 'tmp208@ssafy.com', '1', 10, 3, 9, 0, 95, '호물로', NULL, NULL, 0, 0, 0, 0, 45.4545454, 'N'),
	(427, 'tmp209@ssafy.com', '1', 0, 8, 1, 0, 96, '이동준', NULL, NULL, 0, 0, 0, 0, 0, 'N'),
	(428, 'tmp210@ssafy.com', '1', 2, 1, 7, 0, 97, '김현', NULL, NULL, 0, 0, 0, 0, 20, 'N'),
	(429, 'tmp211@ssafy.com', '1', 8, 2, 4, 0, 98, '김정현', NULL, NULL, 0, 0, 0, 0, 57.1428571, 'N'),
	(430, 'tmp212@ssafy.com', '1', 4, 9, 8, 0, 99, '김명준', NULL, NULL, 0, 0, 0, 0, 19.047619, 'N'),
	(431, 'tmp213@ssafy.com', '1', 5, 6, 7, 0, 100, '윤석영', NULL, NULL, 0, 0, 0, 0, 27.7777777, 'N'),
	(432, 'tmp214@ssafy.com', '1', 3, 3, 0, 0, 101, '이정협', NULL, NULL, 0, 0, 0, 0, 50, 'N'),
	(433, 'tmp215@ssafy.com', '1', 1, 9, 2, 0, 102, '이지민', NULL, NULL, 0, 0, 0, 0, 8.3333333, 'N');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;

/*!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 */;