-- -------------------------------------------------------- -- 호스트: 175.126.232.177 -- 서버 버전: 5.0.96 - Source distribution -- 서버 OS: unknown-linux-gnu -- HeidiSQL 버전: 9.5.0.5196 -- -------------------------------------------------------- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!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' */; -- lions 데이터베이스 구조 내보내기 CREATE DATABASE IF NOT EXISTS `lions` /*!40100 DEFAULT CHARACTER SET utf8 */; USE `lions`; -- 테이블 lions.club 구조 내보내기 CREATE TABLE IF NOT EXISTS `club` ( `club_seq` int(11) NOT NULL auto_increment, `club_code` varchar(10) collate utf8_bin NOT NULL COMMENT '클럽코드', `club_name` varchar(15) collate utf8_bin NOT NULL COMMENT '클럽명', `club_name_en` varchar(20) collate utf8_bin NOT NULL COMMENT '클럽명(영문)', `club_gu` varchar(10) collate utf8_bin NOT NULL, `club_jiyuk` varchar(10) collate utf8_bin NOT NULL, `club_jidae` varchar(10) collate utf8_bin NOT NULL, `general_meeting_date` varchar(6) collate utf8_bin NOT NULL COMMENT '조직총회일(YYMMDD)', `approval_date` varchar(6) collate utf8_bin NOT NULL COMMENT '클럽승인일(YYMMDD)', `club_gender` varchar(4) collate utf8_bin NOT NULL COMMENT '클럽구분(남성,여성,혼성)코드', `board_date` varchar(40) collate utf8_bin NOT NULL COMMENT '이사회일자(YYMMDD)', `board_place` varchar(255) collate utf8_bin NOT NULL COMMENT '이사회장소', `club_sponsor` varchar(15) collate utf8_bin NOT NULL COMMENT '스폰서클럽명', `guide_lion` varchar(45) collate utf8_bin NOT NULL COMMENT '가이딩라이온', `club_tel` varchar(15) collate utf8_bin NOT NULL COMMENT '클럽전화번호', `club_fax` varchar(15) collate utf8_bin NOT NULL COMMENT '클럽팩스번호', `club_address` varchar(255) collate utf8_bin NOT NULL COMMENT '클럽주소', `club_address_2` varchar(255) collate utf8_bin NOT NULL, `club_zip` varchar(7) collate utf8_bin NOT NULL COMMENT '클럽우편번호', `club_address_en` varchar(255) collate utf8_bin NOT NULL COMMENT '클럽주소(영문)', `club_address_en_2` varchar(255) collate utf8_bin NOT NULL, `club_status` varchar(4) collate utf8_bin NOT NULL COMMENT '클럽상태(굳스텐딩,정지,해체)코드', `reg_date` datetime NOT NULL COMMENT '등록일', `modify_date` datetime default NULL COMMENT '수정일', `quit_date` char(6) collate utf8_bin NOT NULL, `approval` char(1) collate utf8_bin NOT NULL default 'N', `remark` varchar(255) collate utf8_bin default NULL, `reg_member` varchar(45) collate utf8_bin default NULL, `modify_member` varchar(45) collate utf8_bin default NULL, PRIMARY KEY (`club_seq`), KEY `index` (`club_code`) ) ENGINE=MyISAM AUTO_INCREMENT=179 DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='클럽'; -- 테이블 데이터 lions.club:174 rows 내보내기 DELETE FROM `club`; /*!40000 ALTER TABLE `club` DISABLE KEYS */; INSERT INTO `club` (`club_seq`, `club_code`, `club_name`, `club_name_en`, `club_gu`, `club_jiyuk`, `club_jidae`, `general_meeting_date`, `approval_date`, `club_gender`, `board_date`, `board_place`, `club_sponsor`, `guide_lion`, `club_tel`, `club_fax`, `club_address`, `club_address_2`, `club_zip`, `club_address_en`, `club_address_en_2`, `club_status`, `reg_date`, `modify_date`, `quit_date`, `approval`, `remark`, `reg_member`, `modify_member`) VALUES (1, '025706', '파고다', 'PAGODA', '동대문', '4', '3', '681112', '681112', 'CA', '', '클럽사무실', '중앙', '오명동', '0222498648', '0222493298', '서울특별시 동대문구 고미술로 100 (답십리동)', '송화빌딩 708호', '02622', '100, Gomisul-ro, Dongdaemun-gu, Seoul', 'Rm708, Songhwa B/D', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (2, '025698', '흥인', 'HEUNGIN', '', '5', '1', '700725', '700725', 'CA', '', '', '반도', '윤덕순·김병인', '01099420220', '0315110845', '서울특별시 노원구 동일로174길 9-52', '(공릉동)', '01849', 'Dongil-ro 174-gil, Nowon-gu, Seoul', '9-52,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (3, '025715', '고려', 'KORYO', '', '5', '1', '701203', '701203', 'CC', '', '', '서서울', '한영희·정철모', '027336416', '027336417', '서울 성북구 종암로 13길', '고려대 교우회관 404-C', '136-712', 'Korea Univ. Alumni Association, Jongam-dong, Seongbuk-gu, Seoul', 'Rm603, Korea Univ. Alumni Association,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (4, '025714', '건국', 'KONKUK', '광진', '3', '3', '731030', '731204', 'CA', '', '', '수도', '한순용·이정욱', '01047807608', '0234370051', '서울특별시 양천구 목동동로 430, 611동 407호', '(목동, 목동신시가지아파트6단지)', '07986', '430, Mokdongdong-ro, Yangcheon-gu, Seoul', '611-407', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'issong@konkuk.ac.kr', NULL, NULL), (5, '030080', '남대문', 'NAM DAE MUN', '성북,마포', '.', '.', '741217', '741230', 'CC', '', '', '반도', '(고)박장환', '01052783303', '024435452', '서울 송파구 중대로 24(문정동)', '훼미리 202-402', '138-769', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150929', 'Y', '', NULL, NULL), (6, '030062', '동양', 'DONGYANG', '', '', '', '741220', '741220', 'CC', '', '', '남산', '한명헌·배윤선', '027434616', '027434616', '서울 종로구 명륜동4가', '188-4 동화빌딩 510호', '110-524', 'Myeongnyun-dong 4-ga, Jongno-gu, Seoul', 'Rm510, Dong-hwa Bldg., 188-4', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '클럽해체(2011.12.29)', NULL, NULL), (7, '032837', '을지', 'EULJI', '광진', '3', '1', '761019', '761019', 'CA', '', '', '반도', '윤성준·이성희', '0234772839', '02594-0109', '서울특별시 서초구 반포대로 300-3 (잠원동,상화빌딩 )', '4층', '06509', '300-3, Banpo-daero, Seocho-gu, Seoul', 'F4', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'seront0061@naver.com', NULL, NULL), (8, '033975', '동도', 'DONGDO', '동대문', '.', '.', '770314', '770523', 'CA', '', '', '국도', '유용근·김영배', '01037602856', '0222817372', '서울특별시 강남구 영동대로 702 (청담동)', '청담 삼익상가', '135-958', '702, Yeongdong-daero, Gangnam-gu, Seoul', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (9, '033598', '아카데미', 'ACADEMY', '중랑', '1', '1', '770330', '770330', 'CA', '', '', '서울', '정길복·하두철', '', '', '경기도 고양시 덕양구 중앙로54번길 51 (덕은동)', '(주)마이보성', '10539', 'Jungang-ro 54beon-gil, Deogyang-gu, Goyang-si, Gyeonggi-do', '51', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (10, '034698', '무궁화', 'MUGUNGWHA', '성동', '1', '2', '770929', '771107', 'CA', '', '', '삼일', '손학인', '024097856', '024097856', '서울 중랑구 봉화산로 153', '1201동 501', '131-792', '153, Bonghwasan-ro, Jungnang-gu, Seoul', '1201-501', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (11, '034237', '동대문', 'DONGDAEMOON', '동대문', '4', '3', '770630', '770630', 'CA', '', '', '신장', '박광희', '010-2297-2903', '02-2277-2905', '서울 중구 충무로 29 아시아미디어타워', '806호', '446-908', '`', '`', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (169, '136046', '에버그린', 'Ever Green', '`', '`', '`', '180701', '180701', '', '', '', '뉴리치', '김영신', '`', '', '`', '`', '`', '`', '`', 'BA', '2018-07-18 13:53:19', NULL, '', 'Y', '', NULL, NULL), (12, '036166', '태우', 'TAE WOO', '중랑', '4', '3', '781005', '781023', 'CA', '', '', '용마', '장대식', '4350630', '4350638', '서울특별시 중랑구 면목로96길 8 (상봉동)', '3층', '02148', '8, Myeonmok-ro 96-gil, Jungnang-gu, Seoul', 'F3', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (13, '036412', '안암', 'ANAM', '', '2', '1', '781201', '781228', 'CA', '', '', '고려', '제재형', '01090820056', '', '경기 파주시 교하읍', '한울마을 510-604', '413-830', 'Gyoha-eup, Paju-si, Gyeonggi-do', '510-604, Hanwool-villige', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '131230', 'Y', '', NULL, NULL), (14, '036931', '북서울', 'NORTH', '', '6', '1', '790312', '790404', 'CA', '', '', '서서울', '김인환', '0226387066', '0226387067', '서울시 노원구 한글비석로444 B104-105', '(상계동,교림노원프라자)', '01694', '`', '`', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (15, '037193', '서도', 'SEODO', '은평,서대문', '9', '3', '790313', '790529', 'CC', '', '', '국도', '이종국·유용국', '01066410605', '(02)2677-4530', '영등포구 도신로 178(신길동. 한흥빌딩1층)', '현대냉동종합상사', '07347', '178, Dosin-ro, Yeongdeungpo-gu, Seoul', 'F1', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (16, '036759', '서부', 'SEOBOU', '은평,서대문', '9', '3', '790315', '790315', 'CA', '', '', '아카데미', '이강식·한봉수', '0113239126', '', '서울특별시 은평구 은평로 147 (응암동,미주빌딩)', '3층', '03460', '147, Eunpyeong-ro, Eunpyeong-gu, Seoul', 'F3', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (17, '037136', '동봉', 'DONGBONG', '광진', '3', '2', '790410', '790518', 'CA', '', '', '동도', '강대철', '0236759920', '0236759920', '서울특별시 종로구 창경궁로16나길 30 ', '(원남동,천우빌딩) 2층', '110-450', 'Wonnam-dong, Jongno-gu, Seoul', '2F, Cheonwoo Bldg., 62', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (18, '037141', '통일', 'TONGIL', '강북, 도봉', '3', '3', '790416', '790518', 'CA', '매월5일', '통일사무국(한디예건 內)', '파고다', '이호규', '0236643081', '0236642506', '서울특별시 강서구 화곡로63길 93, 132호', '(등촌동,신송타워)', '07590', '93, Hwagok-ro 63-gil, Gangseo-gu, Seoul', '#132', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (19, '037452', '동일', 'DONGIL', '중랑', '1', '1', '790423', '790711', 'CA', '', '', '동도', '이재현', '0222312737', '0222358794', '서울특별시 동대문구 하정로 5', '(신설동)', '02586', '5, Hajeong-ro, Dongdaemun-gu, Seoul', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (20, '037982', '독립문', 'DOKRIBMOON', '중랑', '1', '2', '790607', '800124', 'CA', '', '', '한강', '송삼섭', '028389964', '028389965', '서울특별시 구로구 새말로18길 24 (구로동)', '한국마그네슘빌딩 2층', '08289', '24, Saemal-ro 18-gil, Guro-gu, Seoul', 'F2', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'kiha63@hanmail.net', NULL, NULL), (21, '037270', '새한성', 'SAI HANSUNG', '동대문', '3', '2', '790611', '790611', 'CA', '', '', '한성(354-A)', '방철주', '027773310', '027771117', '서울 중구 명동1가 1-3번지', '한국YWCA회관 507', '100-021', 'Myeong-dong 1(il)-ga, Jung-gu, Seoul', 'Rm 507, 1-3', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'jklee1115@naver.com', NULL, NULL), (22, '038092', '동신', 'DONGSHIN', '', '', '', '791226', '800208', 'CC', '', '', '동도', '장천식', '027838126', '027832046', '서울 강남구 도곡동 934-10', '역삼우성아파트 1동 912호', '135-270', 'Dogok-dong, Gangnam-gu, Seoul', '1-912, Yeoksam Woosung Apt., 934-10', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2010.8.30 해체', NULL, NULL), (23, '038509', '무악', 'MOOAK', '', '', '', '800223', '800531', 'CA', '', '', '태평', '박종석', '023557670', '023567634', '은평구 대조동', '186-1', '122-842', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '10.11.29 해체', NULL, NULL), (24, '038924', '동우', 'DONGWOO', '동대문', '5', '3', '800422', '800904', 'CC', '', '', '동광', '김용준', '0220601137', '0220601156', '경기도 광명시 철산로 5 (철산동, 융창빌딩 )', '10층 1001호, 씨엠웰 주성탁', '14235', '5, Cheolsan-ro, Gwangmyeong-si, Gyeonggi-do', 'Rm1001, F10', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '1radyc@naver.com', NULL, NULL), (25, '039079', '금화', 'KEUMHWA', '광진', '3', '2', '800926', '801110', 'CA', '', '', '중앙', '김해경', '01097119835', '', '서울특별시 노원구 노해로 508, 613동 1504호', '(상계동, 상계주공6단지아파트)', '01752', '508, Nohae-ro, Nowon-gu, Seoul', '613-1504', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (26, '039575', '무도', 'MOO DO', '은평,서대문', '9', '2', '810110', '810313', 'CA', '', '', '성봉', '팽재원', '', '', '서울특별시 서대문구 통일로 495', '(홍은동)', '03647', 'Tongil-ro, Seodaemun-gu, Seoul', '495,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (27, '039646', '국일', 'GUGIL', '강북, 도봉', '6', '1', '810327', '810330', 'CA', '', '', '동원', '강신명', '0314790077', '0314790078', '서울 종로구 장사동 173', '세운상가동 SPT 772호', '110-430', 'Jangsa-dong, Jongno-gu, Seoul', 'Rm 772, Se-woon store', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (28, '039918', '연궁', 'YOUNKUNG', '은평,서대문', '4', '1', '810515', '810515', 'CA', '', '', '대동', '정성웅', '0222736654', '0222736654', '서울특별시 중구 충무로 70-4 (입정동,우정빌딩)', '207호', '04544', '70-4, Chungmu-ro, Jung-gu, Seoul', '#207', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (29, '040454', '정광', 'JEONG GWANG', '', '5', '2', '810730', '811006', 'CA', '', '', '종오', '정명관', '0313187225', '0313187252', '경기도 시흥시 적살뚝길 41', '(계수동)', '14924', 'Jeoksalttuk-gil, Siheung-si, Gyeonggi-do', '41,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (30, '041401', '뉴서울', 'NEW-SEOUL', '강북, 도봉', '6', '2', '820416', '820513', 'CA', '', '', '통일', '이숙행', '0234879161', '0234879165', '서울 서초구 방배동 441-1', '은혜빌딩 201호', '137-060', 'Bangbae-dong, Seocho-gu, Seoul', 'Rm201, Eunhye Bldg., 441-1', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (31, '043802', '다보', 'DABO', '동대문', '4', '1', '840331', '840413', 'CA', '', '', '동보', '정진성', '0222429622', '0222429623', '서울특별시 동대문구 답십리로 94 (답십리동)', '한성실업 7층', '130-804', '94, Dapsimni-ro, Dongdaemun-gu, Seoul', '7F,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'ys911204@naver.com', NULL, NULL), (32, '045024', '공덕', 'KONGDUK', '', '5', '1', '850329', '850506', 'CA', '', '', '흥인', '권중섭', '029774153', '', '서울 노원구 공릉1동', '513-1, 3층', '139-806', 'Gongneung 1.3-dong, Nowon-gu, Seoul', '3F, 513-1', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (33, '045612', '한강', 'HAN KANG', '광진', '2', '2', '851205', '851219', 'CA', '', '', '일주', '고재갑', '01052423309', '05050831239', '서울특별시 성동구 성수이로 118,', '913호 (성수동2가,성수아카데미타워)', '04797', '118, Seongsui-ro, Seongdong-gu, Seoul', 'Rm913', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (34, '047564', '호림', 'HORIM', '', '2', '1', '870422', '870626', 'CA', '', '', '고려', '제제형', '0112252186', '0236708359', '경기 고양시 일산동구 장항동 731', '동하넥서스빌 701호', '410-380', '43-33, Mugunghwa-ro, Ilsandong-gu, Goyang-si, Gyeonggi-do', 'Rm 701', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '140629', 'Y', '', NULL, NULL), (35, '047311', '호암', 'HO AHM', '광진', '3', '1', '870326', '870512', 'CC', '', '', '안암', '권영철', '0115372760', '025876149', '서울 동작구 대방동', '407-46', '156-020', 'Daebang-dong, Dongjak-gu, Seoul', '407-46', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150629', 'Y', '', NULL, NULL), (36, '049119', '충우', 'CHUNG WOO', '', '4', '3', '881128', '981228', 'CC', '', '', '성덕', '이철희', '0220388252', '0220388132', '서울 서초구 효령로 70길 36-25, 2층', '줌테크빌딩 202호', '137-865', '1435-6, Seocho 1-dong, Seocho-gu, Seoul', 'Rm202', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (37, '049304', '정일', 'JEONG ILL', '중랑', '1', '3', '890223', '890313', 'CC', '', '', '정광', '김홍석', '01085113616', '024530836', '서울특별시 광진구 아차산로 563', '(광장동)', '04983', 'Achasan-ro, Gwangjin-gu, Seoul', '563', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'miraefive@naver.com', NULL, NULL), (38, '051455', '청강', 'CHUNG KANG', '동대문', '6', '2', '910112', '910322', 'CB', '', '', '독립문', '이호순', '01032234468', '', '서울특별시 서대문구 연희로41다길 29-17', '(홍은동)', '422-764', 'Yeonhui-ro 41da-gil, Seodaemun-gu, Seoul', '29-17,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'ysoo5700@naver.com', NULL, NULL), (39, '051721', '동경', 'DONG KYUNG', '성동', '7', '1', '910423', '910524', 'CC', '', '', '샛별', '김소식', '01063207899', '', '서울특별시 노원구 한글비석로24가길 20-8', '(상계동)', '01668', '20-8, Hangeulbiseok-ro 24ga-gil, Nowon-gu, Seoul', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (40, '055233', '백상', 'BAIKSANG', '', '5', '2', '931031', '940119', 'CC', '', '', '동경', '조규', '01052358944', '22698945', '서울특별시 종로구 청계천로 159, 바열 433호 (장사동)', '세운상가', '03194', '159, Cheonggyecheon-ro, Jongno-gu, Seoul', 'BA-433', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (41, '056234', '정화', 'JUNGHWA', '성북,마포', '7', '1', '941027', '941114', 'CA', '', '', '동양', '최정아', '01037469734', '0313889887', '경기도 안양시 동안구 비산동 1104', '리빙인테리어', '431-050', '`', '`', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (42, '056829', '송죽', 'SONGJUK', '성동', '2', '1', '950215', '950413', 'CC', '', '', '무악', '진정우', '025786411', '029096411', '서울시 서초구 강남대로 27', '(양재동 화훼공판장) 지하20호', '137-942', '27, Gangnam-daero, Seocho-gu, Seoul', '#20,BF', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (43, '058267', '강북', 'KANG BUK', '강북', '6', '1', '960509', '960513', 'CA', '', '', '한강', '이병옥', '029075544', '029072555', '서울 강북구 한천로 1076(수유동)', '광명빌딩 4층', '142-876', 'Suyu 3(sam)-dong, Gangbuk-gu, Seoul', '182-46, GwangMyeong Bldg. 4F', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (44, '059280', '경우', 'KYONG WOO', '성북,마포', '8', '3', '970326', '970326', 'CC', '', '', '서도', '이오장', '0222634721', '0222634726', '서울 중구 동호로 24길 27-11', '최신빌딩 4층', '100-855', '27-11, Dongho-ro 24-gil, Jung-gu, Seoul', '4F, Choisin', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (45, '060260', '동산', 'DONG SAN', '동대문', '.', '.', '971104', '980102', 'CA', '', '', '을지', '안두훈', '', '', '서울 강남구 논현동 152-5', '(대우아이빌 431호)', '135-824', 'Nonhyeon 1(il)-dong, Gangnam-gu, Seoul', 'Rm431, 152-5', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150929', 'Y', '', NULL, NULL), (46, '060019', '동아', 'DONG-A', '성북,마포', '.', '.', '970821', '971003', 'CC', '', '', '동경', '최낙성', '023198159', '027528123', '서울 중구 퇴계로 42-3', '불리나빌딩 5층', '100-806', 'Toegye-ro, Jung-gu, Seoul', '42-3', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '160629', 'Y', '', NULL, NULL), (47, '059918', '한마음', 'HAN-MA-EUM', '성동', '2', '2', '970814', '970814', 'CC', '', '', '강남', '김진동', '01077675214', '', '서울 서초구 서초3동 1532-7', '서울빌딩 512호', '137-073', '`', '`', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (48, '061369', '봉화', 'BONG HWA', '', '', '', '981016', '981221', 'CA', '', '', '넝쿨', '고석봉', '024928081', '024920859', '중랑구 묵동 동1로', '179 코디아빌딩 502호', '131-140', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2010.09.30 해체', NULL, NULL), (49, '061263', '샛별', 'SAET BYEOL', '', '3', '2', '981010', '981118', 'CC', '', '', '을지', '홍경훈', '0221881011', '0221881091', '서울 강남구 삼성1동 공항타워', '14층 법무법인 유한 로고스', '135-973', 'Air Tower, Samseong 1(il)-dong, Gangnam-gu, Seoul', 'radiology Kyung hee Uni. Hospital, 1', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '140228', 'Y', 'F14', NULL, NULL), (50, '061370', '이화', 'EHWA', '', '', '', '981028', '981221', 'CC', '', '', '샛별', '이은성', '0226628210', '0226626355', '서울 강서구 방화동', '536-17 홍화빌딩 2층', '157-220', 'Banghwa-dong, Gangseo-gu, Seoul', '2F, Hong-hwa bldg., 536-17', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '110729', 'Y', '클럽해체(2011.7.29)', NULL, NULL), (51, '061237', '대원', 'DEA WEON', '성북,마포', '8', '3', '981027', '981105', 'CC', '', '', '명동', '방조원', '0222721317', '0222695211', '서울 중구 묵정동', '18번지 대학문화원 301호', '100-380', 'Mukjeong-dong, Jung-gu, Seoul', '18(Rm301, University Culture Center)', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (52, '061238', '씨앤지', 'C&G', '동대문', '4', '1', '981028', '981109', 'CC', '', '', '다보', '이준구', '0222532233', '0222386314', '서울특별시 중구 퇴계로78길 39 (신당동)', '1층', '100-450', '39, Toegye-ro 78-gil, Jung-gu, Seoul', 'F1', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (53, '061374', '금강', 'KUM KANG', '성동', '1', '2', '981109', '981221', 'CA', '', '', '한강', '이병옥', '01022227534', '', '서울특별시 서초구 방배중앙로15길 8', '', '06564', '8, Bangbaejungang-ro 15-gil, Seocho-gu, Seoul', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (54, '061372', '진아', 'JIN-AH', '', '', '', '981111', '981221', 'CB', '', '', '금화', '류만성', '01071225277', '', '경기 고양시 덕양구 행신동', '175-4 극동빌라 1동 401호', '412-220', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '121229', 'Y', '', NULL, NULL), (55, '062057', '대모', 'DAEMO', '', '', '', '990322', '990608', 'CA', '', '', '무궁화', '조병길', '025644790', '', '서울 강남구 대치동', '890-12 다봉타워 3층', '135-280', 'Daechi-dong, Gangnam-gu, Seoul', '3F, Dabong Tower, 890-12', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (56, '064022', '신화', 'SHINHWA', '동대문', '7', '3', '000725', '010216', 'CC', '', '', '독립문', '김흥주', '01055224081', '', '서울특별시 광진구 자양로32길 16,', '402호 (구의동, 도성아파트)', '05031', '16, Jayang-ro 32-gil, Gwangjin-gu, Seoul', '#402', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '1411하모니에서개명', NULL, NULL), (57, '063667', '진선미', 'JIN SUN MI', '광진', '3', '3', '000823', '001107', 'CB', '', '', '샛별', '우영식', '01087723209', '', '서울특별시 강남구 논현로 218, 2동 112호', '(도곡동, 삼익아파트)', '06272', '218, Nonhyeon-ro, Gangnam-gu, Seoul', '2-112', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (58, '063910', '영우', 'YOUNGWOO', '중구', '1', '1', '000929', '010110', 'CC', '', '', '파고다', '정연통', '029235439', '', '서울 동대문구 신설동', '104-210', '130-812', 'Sinseol-dong, Dongdaemun-gu, Seoul', '104-210', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '130630', 'Y', '', NULL, NULL), (59, '063834', '청운', 'CHUNG-WOON', '성북,마포', '.', '.', '001018', '001204', 'CC', '', '', '아카데미', '진재철', '01065129693', '028663736', '서울 관악구 은천동 926-36번지', '302호 임윤규 법무사무실', '151-843', '926-36, Euncheon-dong, Gwanak-gu, Seoul', 'Rm302', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150929', 'Y', '', NULL, NULL), (60, '063839', '뉴중앙', 'NEW JOONGANG', '성북,마포', '5', '1', '001026', '001204', 'CA', '', '', '정광', '차호근', '01056047948', '0313843732', '서울특별시 성동구 금호동1가 1806', '', '100-828', '', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (61, '063744', '홍익', 'HONG IK', '성북,마포', '8', '2', '001026', '001204', 'CA', '', '', '다보', '조선묵', '07077201100', '7636313', '경기도 의정부시 송양로 45, 808동 1304호', '(낙양동, 양지마을8단지)', '11812', '45, Songyang-ro, Uijeongbu-si, Gyeonggi-do', '808-1304', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (62, '063743', '노블레스', 'Noblesse', '중랑', '8', '3', '001030', '001204', 'CC', '', '', '샛별', '우영식', '4155002', '', '서울특별시 송파구 석촌동', '295-12', '05687', 'Baekjegobun-ro 40-gil, Songpa-gu, Seoul', '37', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (63, '064354', '해송', 'HAESONG', '', '', '', '001124', '010521', 'CB', '', '', '동대문', '이관치', '029759515', '029753594', '서울 중랑구 망우본동', '403-64 3층', '131-805', 'Mangubon-dong, Jungnang-gu, Seoul', '3F, 403-64', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2011년 1월 해체', NULL, NULL), (64, '064688', '장미', 'ROSE', '중랑', '4', '2', '010723', '010907', 'CC', '', '', '아카데미', '김철근', '025422471', '025087204', '서울 강남구 역삼2동 765-14', '영진빌라 401호', '135-080', 'Yeoksam-dong, Gangnam-gu, Seoul', 'Rm401, Yeongjin Villa, 765-14', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '141129', 'Y', '', NULL, NULL), (65, '064919', '타워', 'TOWER', '강북, 도봉', '4', '2', '010921', '020110', 'CA', '', '', '봉화', '안복렬', '0222530141', '029213298', '서울특별시 동대문구 무학로 128-1 ', '(용두동,가산빌딩)1층 ', '130-820', '128-1, Muhak-ro, Dongdaemun-gu, Seoul', 'F1', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (66, '064991', '은평', 'EUNPYEONG', '은평,서대문', '9', '2', '011031', '020213', 'CA', '', '', '무악', '안희규', '0231581119', '0231581138', '경기도 고양시 삼송로205번안길2(삼송동)', '(주)신한F&C(KCC페인트대리점)', '10556', 'Deogyang-gu, Goyang-si, Gyeonggi-do', '2, Samsong-ro 205beonan-gil,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '54071045@hanmail.net', NULL, NULL), (67, '064897', '강산', 'KANG SAN', '은평,서대문', '9', '1', '011129', '020102', 'CA', '', '', '다보', '조한문', '01052439623', '', '서울시 구로구 개봉동', '97-19', '152-804', '', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (148, '117873', 'APP', 'APP', '강북, 도봉', '6', '1', '120821', '120924', 'CC', '', '', '국일', '이경삼, 이병도', '025449501', '025449502', '서울특별시 강남구 논현로164길 32', 'A동 401호 (신사동, 칼릭스빌)', '06024', '32, Nonhyeon-ro 164-gil, Gangnam-gu, Seoul', 'A-401', 'BA', '2012-10-04 10:25:35', NULL, '', 'Y', 'shs3220@hanmail.net', NULL, NULL), (68, '065489', '뉴한마음', 'NEW-HAN-MAEUM', '성북,마포', '5', '2', '020218', '020612', 'CC', '', '', '한마음', '채희원', '0222676073', '0222676075', '서울시 중구 퇴계로41길13', '4층 (무릉빌딩)', '04302', '`', '`', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'osungsjs@daum.net', NULL, NULL), (69, '067296', '미래', 'MIRAE', '', '', '', '020917', '030224', 'CC', '', '', '월드스타', '박광성', '029277357', '029033471', '서울 광진구 구의3동 203-5', '경우빌딩 302호', '143-821', 'Guui 3-dong, Gwangjin-gu, Seoul', 'Rm302, Gyeong-woo bldg., 203-5', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2012/2/29 클럽해체', NULL, NULL), (70, '067654', '리치', 'RICH', '', '8', '2', '021103', '030404', 'CC', '', '', '수정', '이경자', '01054747469', '025877460', '서울특별시 서초구 서초대로58길 27 (서초동)', 'B1층', '06632', '27, Seocho-daero 58-gil, Seocho-gu, Seoul', 'BF', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'ddaccom@naver.com', NULL, NULL), (71, '067308', '배봉', 'BAEBONG', '동대문', '4', '2', '021207', '030224', 'CC', '', '', '다보', '최창학', '0222473949', '0222121731', '서울 동대문구 답십리로133', '영빌딩 5층', '130-802', '133, Dapsimni-ro, Dongdaemun-gu, Seoul', '5F, Young Bulding', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'dbpyw@hanmail.net', NULL, NULL), (72, '075901', '고인', 'KOIN', '', '2', '1', '030310', '030630', 'CC', '', '', '고려', '제재형', '0117203721', '0222697301', '서울 성동구 행당동 346 행당한진타운', '101-1202', '133-777', 'Hanjin Apt., Haengdang-dong, Seongdong-gu, Seoul', '314-1105', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '140829', 'Y', '', NULL, NULL), (73, '075896', '이과수', 'IGUAZU', '', '', '', '030317', '030630', 'CB', '', '', '동경', '천정자', '025788496', '025758835', '서울 서초구 양재동', '275-3', '137-130', 'Yangjae-dong, Seocho-gu, Seoul', '275-3', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (74, '075897', '강천', 'KANG CHEON', '', '', '', '000319', '030630', 'CB', '', '', '봉화', '김종선', '0117998707', '', '서울 서초구 내곡동', '1-259 금강화훼백화점 3동 1호', '137-180', 'Naegok-dong, Seocho-gu, Seoul', 'Rm1, 3-dong, Geumgang flower department store, 1-259', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '클럽해체(2011.8.29)', NULL, NULL), (75, '078213', '정우', 'JUNG WOO', '성동', '.', '.', '030821', '040211', 'CA', '', '', '정광', '김영욱·김병식', '', '', '', '', '', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150629', 'Y', '', NULL, NULL), (76, '077828', '그린', 'GREEN', '강북, 도봉', '6', '2', '030907', '031120', 'CB', '', '', '강북', '김두선', '9803070', '9803073', '서울특별시 성북구 도봉로 31-1 (길음동)', '설빙', '02728', 'Dobong-ro, Seongbuk-gu, Seoul', '31-1,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (77, '077954', '송하', 'SONG HA', '', '8', '2', '031103', '031219', 'CB', '', '', '무궁화', '조삼순', '01071650911', '05040609132', '서울특별시 도봉구 우이천로16길 7', '101호', '132-918', '7, Uicheon-ro 16-gil, Dobong-gu, Seoul', '#101', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (78, '082869', '경동', 'KYUNG DONG', '성동', '2', '1', '040107', '040628', 'CA', '', '', '한강', '정경웅', '01062609411', '05040339411', '서울특별시 성북구 동소문로32길 4 (동선동3가)', '(주)세일기획', '02840', 'Dongsomun-ro 32-gil, Seongbuk-gu, Seoul', '4,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'hyung1400@Gmail.com', NULL, NULL), (79, '078207', '광진', 'KWANG JIN', '광진', '3', '3', '040129', '040211', 'CB', '', '', '리치', '이경자', '01026664156', '', '서울특별시 광진구 긴고랑로15길 40,', '굿모닝빌동 302호 (중곡동)', '04934', '647-1, Junggok-dong, Gwangjin-gu, Seoul', '101-503, Sambo Apt.,', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (80, '082861', '그린우드', 'GREEN WOOD', '중랑', '4', '3', '040428', '040628', 'CC', '', '', '봉화', '김태웅', '0222078690', '0222078047', '서울 중랑구 면목2동', '132-15 우드마트코리아', '131-819', 'Myeonmok 2(i)-dong, Jungnang-gu, Seoul', '132-15', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '141229', 'Y', '', NULL, NULL), (81, '082862', '뉴광진', 'NEW GWANGJIN', '광진', '.', '.', '040302', '040628', 'CB', '', '', '광진', '김영규', '01028595888', '0261803678', '서울 노원구 월계3동 한진그랑빌아파트', '109-2705', '139-956', 'Grangvill Apt., Wolgye 3(sam)-dong, Nowon-gu, Seoul', '109-2705', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150729', 'Y', '', NULL, NULL), (82, '082863', '미네르바', 'MINERVA', '', '', '', '040308', '040628', 'CB', '', '', '동일', '김옥례', '0318685900', '0318685903', '경기 동두천시 생연동', '664-59 파크타운상가 104호 나이스365(주)', '483-030', 'Saengyeon-dong, Dongducheon-si, Gyeonggi-do', 'Nice365 Co., Rm104, ParkTownStore, 664-59', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '클럽해체(2011.8.29)', NULL, NULL), (83, '082864', '뉴은평', 'NEW EUNPYUNG', '은평,서대문', '9', '3', '040309', '040628', 'CC', '', '', '무악', '안희규', '01043968590', '05051658590', '서울 은평구 갈현동', '2F, 423-7', '122-895', 'Galhyeon-dong, Eunpyeong-gu, Seoul', '2F, 423-7', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (84, '082865', '고담', 'GODAM', '중랑', '1', '3', '040312', '040628', 'CC', '', '', '태우', '이중선', '01050440360', '029511403', '서울시 용산구 한남2동', '739-18호', '140-893', '', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (85, '082866', '청야', 'CHUNGYA', '', '', '', '040321', '040322', 'CA', '', '', '한마음', '최인형', '01081915724', '0317941976', '서울 광진구 화양동', '49-9 (3M썬팅전문시공점)', '143-917', 'Hwayang-dong, Gwangjin-gu, Seoul', '49-9', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '100330', 'Y', '', NULL, NULL), (86, '084622', '아리랑', 'ARIRANG', '', '', '', '040715', '050103', 'CC', '', '', '정화', '최창수', '029532183', '029532183', '서울 성북구 동소문동4가', '98번지 지층', '136-034', 'Dongsomun-dong 4-ga, Seongbuk-gu, Seoul', '98', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '클럽해체(2011.8.29)', NULL, NULL), (87, '084623', '화이트', 'WHITE', '중랑', '5', '3', '040830', '050103', 'CB', '', '', '진선미', '최순옥', '01038395780', '', '서울특별시 중랑구 중화동 18-2', '장미빌라 가동 201호', '02049', '37, Bonghwasan-ro 27-gil, Jungnang-gu, Seoul', 'GA-201', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (88, '085935', '성진', 'SUNGJIN', '', '', '', '040916', '050520', 'CC', '', '', '미래', '박광성', '0114368005', '', '서울 금천구 시흥동', '982-4 영일빌딩 3층 (현대자동차 엄한규)', '153-030', 'Siheung-dong, Geumcheon-gu, Seoul', '982-4', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (89, '084625', '하나로', 'HANARO', '성동', '2', '2', '041116', '050103', 'CC', '', '', '무궁화', '박석묵', '027571504', '027571504', '서울 동대문구 사가정로 223', '301호', '130-838', '', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'juno890@naver.com', NULL, NULL), (90, '084900', '햇빛', 'HAETBIT', '', '12', '1', '041123', '050224', 'CC', '', '', '한마음', '임호완', '01037847652', '0319199526', '경기 고양시 일산서구 대화동 장성아파트', '303-1403', '411-707', 'Daehwa-dong, Goyang-si', '303-1403', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '140729', 'Y', '', NULL, NULL), (91, '093224', '썬월드', 'SUN WORLD', '', '', '', '051227', '060103', 'CC', '', '', '월드스타', '황자로', '0236627773', '0236627773', '경기 이천시 호법면', '매곡리 704-59 덕평수련원', '467-820', 'Hobeop-myeon, Icheon-si, Gyeonggi-do', 'Deokpyeong training center, 704-59, Maegok-ri,', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (92, '093225', '양천월드', 'YANGCHUN WORLD', '은평,서대문', '9', '1', '051215', '060103', 'CC', '', '', '월드스타', '황자로', '01036654089', '0226968218', '서울특별시 양천구 신정로 267, 307호', ' (신정동,양천벤처타운)', '158-073', 'Sinjeong-dong, Yangcheon-gu, Seoul', 'Rm 307', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2018년 8월29일 해체', NULL, NULL), (93, '093599', '중랑', 'JUNGNANG', '중랑', '1', '1', '051227', '060110', 'CC', '', '', '다보', '조태환', '', '', '서울특별시 서초구 잠원로 213-10, 6동 601호 (잠원동, 한강아파트)', '``', '06514', '213-10, Jamwon-ro, Seocho-gu, Seoul', '6-601', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '160629', 'Y', '', NULL, NULL), (94, '096701', '노원', 'NOWON', '노원', '5', '3', '060306', '060322', 'CC', '', '', '한마음', '송옥주', '9369779', '05058731010', '서울특별시 노원구 공릉동 379-1', '2층', '01852', '', '', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (95, '097097', '광일', 'KWANG IL', '', '8', '3', '060327', '060508', 'CC', '', '', '아리랑', '김태순', '07077880049', '029332070', '노원구 동일로250길(상계동 은빛3단지아파트상가)', '은빛아파트상가 205호', '139-879', 'Dongil-ro 250-gil, Nowon-gu, Seoul', 'Rm 205', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'joodj2000 @ hanmail.net', NULL, NULL), (96, '097721', '리더스', 'LEADERS', '노원', '8', '2', '060607', '060913', 'CC', '', '', '미래', '박광성', '0234872642', '0260071677', '서울특별시 서초구 동광로18길 74', '(방배동)', '06572', 'Donggwang-ro 18-gil, Seocho-gu, Seoul', '74', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'magicyr@naver.com', NULL, NULL), (97, '097756', '뉴지성', 'NEW JISUNG', '', '', '', '060818', '060926', 'CB', '', '', '이화', '이은성', '028735001', '028735005', '관악구 낙성대동', '1664-4호', '151-848', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (98, '097757', '한성인', 'HAN SUNG IN', '성북,마포', '1', '2', '060829', '060926', 'CC', '', '', '경동', '이완걸', '0222647759', '0222650558', '서울특별시 중구 퇴계로53길 6-17 (쌍림동,동우빌딩)', '401호', '04560', '6-17, Toegye-ro 53-gil, Jung-gu, Seoul', 'Rm401', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (99, '098337', '한아름', 'HANAREUM', '', '', '', '061116', '070123', 'CC', '', '', '을지', '김형일', '027498744', '', '서울 용산구 남영동', '127-1', '140-160', 'Namyeong-dong, Yongsan-gu, Seoul', '127-1', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (100, '098516', '도산', 'DOSAN', '광진', '3', '3', '061211', '070326', 'CC', '', '', '장미', '여인화', '025916027', '025916009', '서울특별시 서초구 서초중앙로24길 5 (서초동, 맨투맨빌딩)', '301호', '137-883', '5, Seochojungang-ro 24-gil, Seocho-gu, Seoul', 'Rm 301', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2018년 8월29일 해체', NULL, NULL), (101, '098336', '방배월드', 'BANGBAE WORLD', '', '', '', '070108', '070123', 'CC', '', '', '동도', '서재업', '025814950', '025252623', '서울 서초구 방배2동', '474-22 조한욱 컬렉션', '137-819', 'Bangbae 2-dong, Seocho-gu, Seoul', '474-22', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '140228', 'Y', '', NULL, NULL), (102, '098749', '서라벌고', 'SORABOL HIGH', '', '', '', '070131', '070312', 'CA', '', '', '리더스', '박광성', '01089147654', '', '서울 서초구 서초동 1321-11', '플래티넘빌딩 14층 ING생명 VIP지점', '137-070', '1321-11, Seocho-dong, Seocho-gu, Seoul', 'VIP branch, ING Life Insurance Co., 14F, Platinum bldg.', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2012/2/29 클럽해체', NULL, NULL), (103, '098750', '청동', 'CHUNG DONG', '은평,서대문', '1', '1', '070205', '070312', 'CC', '', '', '연궁', '원용주', '', '', '서울특별시 종로구 종로34길 6 (종로5가)', '대륙상사(한미타올)', '03196', 'Jong-ro 34-gil, Jongno-gu, Seoul', '6', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (104, '098754', '백운', 'BAIK UN', '', '', '', '070213', '070312', 'CC', '', '', '무궁화', '김창기', '0182516667', '', '강북구 인수동', '119-35', '142-077', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (105, '099084', '도봉', 'DOBONG', '강북,도봉', '7', '2', '070412', '070412', 'CC', '', '', '동대문', '천선덕', '029564479', '029562477', '서울특별시 도봉구 도봉로180길 77,', '101동 209호 (도봉동, 극동아파트)', '132-753', '77, Dobong-ro 180-gil, Dobong-gu, Seoul', '101-209', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'Osj2020@daum.net', NULL, NULL), (106, '100682', '정다운', 'JUNGDAUN', '', '', '', '071009', '071127', 'CC', '', '', '타워', '최옥금', '0222730661', '0222651994', '', '', '', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '110630', 'Y', '2010.8.30 해체', NULL, NULL), (107, '101022', '호산', 'HOSAN', '광진', '.', '.', '071203', '080115', 'CC', '', '', '강산', '봉정현', '01045624442', '0264426929', '경기 남양주시 진접읍 장현1리', '휴먼시아3단지 307-1703', '472-865', 'Janghyeon 1-ri, Jinjeop-eup, Namyangju-si, Gyeonggi-do', '307-1703', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150929', 'Y', '', NULL, NULL), (108, '101149', '등대', 'DEUNGDAE', '성동', '2', '2', '071119', '080205', 'CC', '', '', '봉화', '이만희', '07075574377', '0312854309', '경기 성남시 분당구 금곡동 210 코오롱트리폴리스', 'A-1306', '463-943', '1, Jeongjail-ro, Bundang-gu, Seongnam-si, Gyeonggi-do', 'A-1306', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (109, '101150', '효경', 'HYOKYUNG', '성동', '2', '1', '071123', '080205', 'CB', '', '', '통일', '김기철', '028838545', '023383007', '서울 관악구 보라매동', '970-21 4층', '151-051', 'Boramae-dong, Gwanak-gu, Seoul', 'F4, 970-21', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150629', 'Y', '', NULL, NULL), (110, '101858', '우정', 'WOO JEONG', '', '', '', '071228', '080603', 'CC', '', '', '무궁화', '남순기', '01198883657', '0312748764', '', '', '', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2010.09.30 해체', NULL, NULL), (111, '102271', '한가람', 'HANGARAM', '', '', '', '080428', '080603', 'CC', '', '', '정다운', '최예원', '01092196687', '025190201', '서울 중랑구 묵1동 184-2', '나인빌라 301호', '131-850', 'Muk 1-dong, Jungnang-gu, Seoul', 'Rm301, Na-in Villa', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (112, '102586', '벽송', 'BEOKSONG', '', '', '', '080522', '080623', 'CC', '', '', '한강', '이을우', '029850555', '029810111', '강북구 미아3동', '214-37', '142-103', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2010.8.30 해체', NULL, NULL), (113, '103486', '한예', 'HANYE', '', '', '', '080707', '080922', 'CC', '', '', '한마음', '임희선', '025886892', '025886893', '서초구 서초3동', '1532-7호 서울빌딩 지하1층', '137-073', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '100830', 'Y', '2010.8.30 해체', NULL, NULL), (114, '103800', '희망', 'HUI MANG', '동대문', '4', '2', '080715', '081015', 'CC', '', '', '리더스', '박광성', '01092587072', '0325673926', '서울특별시 강남구 테헤란로 401 (삼성동)', '15층', '06162', '401, Teheran-ro, Gangnam-gu, Seoul', 'F15', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (115, '104580', '희망', 'HUI MANG', '', '', '', '081029', '090204', 'CC', '', '', '강북', '김정환', '0318521996', '0318521996', '경기도 의정부시 금오동', '474-2번지 대송프라자 701호', '480-130', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '110101', 'Y', '2011년 1월 해체', NULL, NULL), (116, '104579', '중앙', 'JUNGANG', '성동', '2', '1', '090108', '090203', 'CA', '', '', '경동', '이완결', '0222352772', '0222352581', '서울특별시 노원구 동일로216길 47, 511동 305호', '(상계동, 상계주공5단지아파트)', '01753', '47, Dongil-ro 216-gil, Nowon-gu, Seoul', '511-305', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (117, '104833', '글로벌', 'GLOBAL', '', '', '', '800422', '090304', 'CC', '', '', '동광', '김용준', '0221015000', '0226252020', '서초구 반포동', 'LG자이아파트 129동 203호', '137-040', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2011년 1월 해체', NULL, NULL), (118, '104823', '한울', 'HANUL', '은평,서대문', '8', '1', '090120', '090223', 'CC', '', '', '타워', '권동선', '01096501733', '', '서울 동작구 대방동 501', '대림쇼핑타운 221호', '156-761', '501, Daebang-dong, Dongjak-gu, Seoul', 'Rm221 ,Daelim shopping-town.', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '150629', 'Y', '', NULL, NULL), (119, '104957', '가야금', 'GAYAGEUM', '', '', '', '090202', '090311', 'CC', '', '', '동경', '우근식', '025667723', '025157724', '', '', '', '', '', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '100830', 'Y', '2010.8.30 해체', NULL, NULL), (120, '105303', '백산', 'BACKSAN', '광진', '3', '2', '090212', '090422', 'CA', '', '', '다보', '조선묵', '0234726601', '0234726603', '서울특별시 중구 퇴계로 282 (쌍림동)', '오랜후레쉬빌딩 10층', '100-400', '282, Toegye-ro, Jung-gu, Seoul', 'F10', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', 'kjkwsms @ hanmail.net', NULL, NULL), (121, '105791', '뉴공작', 'NEW GONGJAK', '중랑', '7', '2', '090226', '090615', 'CC', '', '', '국일', '이경삼,김동욱', '01052672815', '', '경기도 안양시 만안구 안양로 323', '(안양동)', '14006', 'Anyang-ro, Manan-gu, Anyang-si, Gyeonggi-do', '323', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (122, '105790', '뉴양천', 'NEWYANG CHEON', '', '4', '1', '090512', '090615', 'CA', '', '', '정광', '이영백', '0226075778', '0226522169', '서울 양천구 신월5동', '68-4 2층', '158-095', 'Sinwol 5(o)-dong, Yangcheon-gu, Seoul', 'F2, 68-4', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '121229', 'Y', '', NULL, NULL), (123, '105953', '정미', 'JUNGMI', '강북,도봉', '6', '2', '090615', '090626', 'CC', '', '', '정일', '이일심', '01023304753', '', '서울특별시 노원구 노원로19길 31,', '408동 904호 (중계동, 목화아파트)', '01787', '31, Nowon-ro 19-gil, Nowon-gu, Seoul', '408-904', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2018년 6월29일 해체', NULL, NULL), (124, '106684', 'A.P.P', 'A.P.P.', '', '', '', '090803', '090925', 'CC', '', '', '국일', '이경삼', '0319742001', '0319745008', '인천 연수구 청학동', '487-2 3층', '406-831', 'Cheonghak-dong, Yeonsu-gu, Incheon', '3층, 487-2', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '110629', 'Y', '해체 2011.06. 29', NULL, NULL), (125, '106683', '소나무', 'SONAMOO', '', '1', '1', '090915', '090925', 'CC', '', '', '하모니', '최성수', '', '029224370', '서울 동대문구 신설동', '102-6 대한생명B/D 1층', '130-812', 'Sinseol-dong, Dongdaemun-gu, Seoul', '106-1303, Bugae Jugong Apt., 496', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '131230', 'Y', '', NULL, NULL), (126, '106792', '음대교수', 'EUMDAE GYOSU', '', '', '', '091012', '091020', 'CC', '', '', '국일', '이경삼', '0234764838', '0237465030', '경기 화성시 병점동', '신창2차아파트 204-1603', '445-360', 'Byeongjeom-dong, Hwaseong-si, Gyeonggi-do', '204-1603, Sinchang 2-cha', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (127, '107396', '중구', 'JUNGGU', '동대문', '9', '1', '091210', '100202', 'CC', '', '', '아리랑', '장동찬', '0222731360', '0222791733', '중구 창경궁로 21 일지스튜디오', '(예관동 56-10번지)', '100-290', 'Changgyeonggung-ro, Jung-gu, Seoul', '21', 'BA', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '2012.7 목멱산->중구 클럽명칭변경', NULL, NULL), (128, '107501', '라틴코리아', 'LATIN KOREA', '', '', '', '091223', '100218', 'CC', '', '', '국일', '이경삼', '025126416', '025126434', '서울 강남구 역삼1동', '삼흥빌딩 1215호', '135-711', 'Yeoksam 1-dong, Gangnam-gu, Seoul', 'Rm1215, Samheung Bldg.', 'BC', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 'Y', '', NULL, NULL), (131, '108019', '선덕', 'SUNDEOK', '성동', '7', '1', '100326', '100409', 'CC', '', '', '동경', '장정근', '029937652', '029936515', '서울특별시 강북구 한천로 1046-1', '(수유동)', '01054', 'Hancheon-ro, Gangbuk-gu, Seoul', '1046-1,', 'BA', '2010-07-13 21:06:12', NULL, '', 'Y', 'lee-hyky@hanmail.net', NULL, NULL), (132, '108082', '솔벗', 'SOLBEOT', '', '', '', '100326', '100413', 'CC', '', '', '동일', '이종만', '', '', '서울 광진구 자양3동 762', '한라@ A상가 301호', '143-878', '762, Jayang 3-dong, Gwangjin-gu, Seoul', 'Rm301, Hanra Apt., A Store,', 'BC', '2010-07-13 21:08:17', NULL, '', 'Y', '', NULL, NULL), (133, '108615', '해바라기', 'HAEBARAGI', '', '', '', '100427', '100611', 'CB', '', '', '도봉', '박봉규', '', '', '서울 도봉구 창2동', '608-182', '132-919', 'Chang 2-dong, Dobong-gu, Seoul', '608-182', 'BC', '2010-07-13 21:10:08', NULL, '', 'Y', '', NULL, NULL), (134, '109896', '정의', 'JUNGUI', '중랑', '8', '1', '101028', '101217', 'CC', '', '', '대모', '임영복', '01052874543', '', '서울 강남구 양재대로 55길 10, 103-1318', '403-64번지 3층', '135-938', '10, Yangjae-daero 55-gil, Gangnam-gu, Seoul', '103-1318', 'BC', '2011-02-17 11:11:57', NULL, '160229', 'Y', '150629해체,150827재조직', NULL, NULL), (135, '110425', '한우리', 'HANWOORI', '광진', '3', '1', '110124', '110223', 'CC', '', '', '동아', '송병준, 선영석', '01032933600', '', '서울 동대문구 전농동', '530-66,3층', '130-857', 'Jeonnong 1-dong, Dongdaemun-gu, Seoul', '3F, 530-66', 'BC', '2011-03-02 17:02:30', NULL, '', 'Y', '', NULL, NULL), (136, '110787', '성북', 'SEONGBUK', '성북,마포', '8', '1', '110304', '110408', 'CC', '', '', '양천월드', '문용덕', '029273181', '029232774', '서울특별시 성북구 인촌로1길 89', '(삼선동5가)', '02848', 'Inchon-ro 1-gil, Seongbuk-gu, Seoul', '89,', 'BA', '2011-03-03 22:28:48', NULL, '', 'Y', '', NULL, NULL), (139, '999999', '테스트', 'test', '.', '.', '.', '111111', '111111', '', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', '1', 'BA', '2011-06-28 15:33:02', NULL, '150629', 'Y', '1', NULL, NULL), (140, '111508', '불암', 'BULAM', '', '', '', '110331', '110624', 'CC', '', '', '노원', '정기옥', '', '', '서울 동대문구 장안동', '466-7', '130-100', 'Jangan-dong, Dongdaemun-gu, Seoul', '466-7', 'BC', '2011-07-08 10:34:13', NULL, '', 'Y', '', NULL, NULL), (141, '111509', '퀸도봉산', 'QUEEN DOBONGSAN', '강북, 도봉', '7', '2', '110413', '110624', 'CB', '', '', '동도', '정기옥', '029005124', '029005124', '서울특별시 도봉구 도봉로 637', '(쌍문동)', '132-896', 'Dobong-ro, Dobong-gu, Seoul', '637,', 'BA', '2011-07-08 10:36:42', NULL, '', 'Y', '', NULL, NULL), (142, '111521', '서문', 'SEOMUN', '은평,서대문', '9', '2', '110511', '110627', 'CC', '', '', '강북', '이종학', '01037077408', '34002124', '서울특별시 은평구 대서문길 36', '(진관동)', '03307', 'Daeseomun-gil, Eunpyeong-gu, Seoul', '36', 'BA', '2011-07-08 10:38:17', NULL, '', 'Y', 'JKW2344@hanmail.net', NULL, NULL), (143, '115588', 'KGP', 'KGP', '', '', '', '110716', '111116', 'CA', '', '', '을지', '안두훈', '', '', '서울 용산구 한강로3가', '91 우림아파트 104동 504호', '140-013', 'Hangangno 3(sam)-ga, Yongsan-gu, Seoul', '104-504 Woolim APT, 91', 'BC', '2011-09-08 14:14:00', NULL, '', 'Y', '', NULL, NULL), (144, '115525', '뉴세종', 'New Sejong', '강북, 도봉', '6', '1', '110922', '111108', 'CC', '', '', '뉴서울', '박영래', '7824101', '', '서울특별시 영등포구 은행로 37 (여의도동)', '한국기계산업진흥회 본관2층', '435-050', '37, Eunhaeng-ro, Yeongdeungpo-gu, Seoul', 'F2', 'BC', '2011-11-21 11:00:23', NULL, '', 'Y', '2018년 12월29일 해체', NULL, NULL), (145, '116544', '큰사랑', 'KEUNSARANG', '강북, 도봉', '1', '3', '120313', '120409', 'CC', '', '', '새한성', '허보양', '029326486', '029326483', '서울특별시 노원구 동일로230다길 11', '(상계동)', '01629', 'Dongil-ro 230da-gil, Nowon-gu, Seoul', '11', 'BA', '2012-05-18 11:17:52', NULL, '', 'Y', '', NULL, NULL), (146, '116691', '한양인', 'HANYANGIN', '성동', '2', '1', '120413', '120427', 'CC', '', '', '배봉', '송영호', '5166611', '05027006534', '서울특별시 강남구 신사동 587-1', '', '135-892', '205, Dosan-daero, Gangnam-gu, Seoul', '', 'BA', '2012-05-18 11:19:40', NULL, '', 'Y', '', NULL, NULL), (147, '116690', '혜성', 'HYESEONG', '중랑', '4', '1', '120412', '120427', 'CC', '', '', '동일', '최돈오', '01059199985', '', '서울특별시 중구 다산로36길 109,', '2동 104호 (신당동, 현대아파트)', '04582', '109, Dasan-ro 36-gil, Jung-gu, Seoul', '2-104', 'BC', '2012-05-18 11:24:33', NULL, '', 'Y', '', NULL, NULL), (149, '118987', '세종로', 'SEJONGRO', '광진', '1', '1', '130304', '130320', 'CC', '', '', '정우', '오태섭', '01047349438', '', '서울특별시 강동구 길동 366-3', '해평빌딩 4층', '134-812', '.', '.', 'BA', '2013-03-06 14:49:20', NULL, '', 'Y', '', NULL, NULL), (150, '118986', '뉴성북', 'NEW SEONGBUK', '성북,마포', '8', '1', '130305', '130320', 'CC', '130305', '', '고인', '장순자', '029121755', '029124362', '서울특별시 성북구 정릉로38바길 15 (정릉동, 금성빌딩)', '금성전기', '02816', 'Jeongneung-ro 38ba-gil, Seongbuk-gu, Seoul', '15', 'BA', '2013-03-25 16:30:27', NULL, '', 'Y', '', NULL, NULL), (151, '119301', '뉴-양천', 'NEW-YANG CHEON', '', '14', '2', '130311', '130531', '', '', '', '정광', '이영백', '01023957719', '0226900745', '서울 양천구 신월5동 68-4 2층', '(월정로 36길 5-11 2층)', '158-095', 'Sinwol 5(o)-dong, Yangcheon-gu, Seoul', 'F2, 68-4', 'BC', '2013-06-04 15:48:10', NULL, '140629', 'Y', '', NULL, NULL), (152, '120996', '서구', 'SEOGU', '강북, 도봉', '6', '2', '131114', '140226', 'CA', '', '', '서문', '곽기현', '027362100', '029459731', '서울 종로구 인사동7길 33 남도빌딩 202호', '남도빌딩 202호', '110-300', '198-16, Gwanhun-dong, Jongno-gu, Seoul', 'Rm202, Namdo Bldg.,', 'BA', '2014-02-27 10:04:54', NULL, '', 'Y', 'seogulions@naver.com', NULL, NULL), (159, '125908', '보석', 'JEWELRY', '', '4', '2', '150727', '151002', '', '', '', '타워', '나흥수L,최찬기L', '', '', '서울특별시 중구 장충단로 221 (광희동1가, 명봉빌딩),', '1층 104호 클랙잭', '04561', 'Jangchungdan-ro, Jung-gu, Seoul', '221', 'BC', '2015-10-01 18:18:45', NULL, '', 'Y', '', NULL, NULL), (153, '123424', '온누리', 'ONNURI', '성동', '2', '1', '141016', '141022', 'CC', '', '', '한양인', '이현주', '01057888191', '', '서울특별시 강남구 테헤란로16길 31,', 'A동 101호(역삼동)', '135-924', 'Teheran-ro 16-gil, Gangnam-gu, Seoul', 'A-101, 31,', 'BC', '2014-10-17 14:33:40', NULL, '', 'Y', '', NULL, NULL), (154, '123765', '드림', 'DREAM', '성북', '.', '.', '141119', '141208', '', '', '', '선덕', '유연식,김미영', '0263154943', '', '서울특별시 성북구 성북로4길 52, 206동301호', '(돈암동, 한신 아파트)', '136-753', 'Seongbuk-ro 4-gil 52, Seongbuk-gu, Seoul ', '206-301,', 'BC', '2014-12-11 19:43:15', NULL, '160629', 'Y', '', NULL, NULL), (155, '124513', '한예진', 'HANYEJIN', '', '8', '2', '150326', '150413', '', '', '', '리더스', '권동선L,박광성L', '01077462612', '', '서울특별시 서대문구 신촌로 197', '한국방송예술진흥원', '120-808', 'Seodaemun-gu, Seoul, Korea', '197, Sinchon-ro,', 'BC', '2015-03-25 18:34:53', NULL, '', 'Y', '', NULL, NULL), (156, '124557', '호서', 'HOSEO', '', '6', '2', '150330', '150414', '', '', '', '서구', '이계오L ,이영애L', '36600296', '', '서울특별시 강서구 강서로 420 (등촌동)', '서울호서전문학교', '157-731', '420, Gangseo-ro, Gangseo-gu, Seoul', '`', 'BC', '2015-04-21 09:33:11', NULL, '', 'Y', '', NULL, NULL), (157, '124771', '소낭', 'SO NANG', '', '3', '1', '150415', '150429', '', '', '', '을지', '김명구L,문철호L', '0222449007', '22427890', '서울특별시 동대문구 장한로29길 14', '(장안동)', '130-838', 'Janghan-ro 29-gil, Dongdaemun-gu, Seoul', '14,', 'BC', '2015-04-21 15:22:52', NULL, '', 'Y', '', NULL, NULL), (158, '125062', '불암산', 'BULAM SAN', '', '7', '3', '150430', '150609', '', '', '', '세종로', '신현종L,조흥식L', '01067506409', '', '서울특별시 노원구 중계로 195, 107동 303호', '(중계동, 동진,신안아파트)', '01735', '195, Junggye-ro, Nowon-gu, Seoul', '107-303', 'BA', '2015-04-27 16:20:37', NULL, '', 'Y', '', NULL, NULL), (167, '131197', '코리아나', 'Koreana', '', '`', '`', '170331', '170613', 'CC', '', '', '세종로', '조흥식', '', '', '서울시 동작구 도산대로54길 48-10', '풍납동빌딩 5층', '06056', '`', '`', 'BC', '2017-07-18 09:10:01', NULL, '', 'Y', '', NULL, NULL), (160, '126051', '청마', 'Chung ma', '', '4', '2', '151002', '151029', '', '', '', '배봉', '김재홍L,성정헌L', '', '', '서울특별시 강서구 화곡로68길 82, 302호', '(등촌동, 강서아이티밸리)', '07566', '82, Hwagok-ro 68-gil, Gangseo-gu, Seoul', 'Rm302,', 'BA', '2015-11-02 15:22:21', NULL, '', 'Y', '', NULL, NULL), (161, '126286', 'IWS', 'IWS', '', '9', '1', '150803', '151130', '', '', '', '양천월드', '문용덕L,안용길L', '', '', '서울특별시 강북구 도봉로61길 14', '㈜국선 (미아동)', '01118', 'Dobong-ro 61-gil, Gangbuk-gu, Seoul', '14', 'BA', '2015-11-25 11:36:30', NULL, '', 'Y', '', NULL, NULL), (162, '126287', '예향', 'Yehyang', '', '1', '1', '151110', '151125', '', '', '', '아카데미', '장주인L,장복만L', '', '', '서울특별시 서초구 신반포로47길41(잠원동)', '3층', '06530', '41, Sinbanpo-ro 47-gil, Seocho-gu', 'F3', 'BC', '2015-11-26 11:00:56', NULL, '', 'Y', '', NULL, NULL), (163, '126319', '뉴리치', 'New Rich', '', '8', '2', '151106', '151202', '', '', '', '리치', '이기홍L,이경자L', '', '', '서울특별시 중랑구 동일로 709 (상봉동, SGTOWER)', '202호', '02122', '709, Dongil-ro, Jungnang-gu, Seoul', 'Rm202', 'BA', '2015-12-02 09:44:24', NULL, '', 'Y', '', NULL, NULL), (164, '127204', '명품', 'MYUNGPOOM', '', '4', '2', '151116', '160405', '', '', '', '타워', '이석희L,임호완L', '', '', '서울특별시 동대문구 하정로3길 7-3', '(신설동, 성산빌딩)301호', '02582', '7-3, Hajeong-ro 3-gil, Dongdaemun-gu,', 'Rm301', 'BC', '2016-03-24 16:39:39', NULL, '', 'Y', '', NULL, NULL), (165, '129230', '뉴무궁화', 'New Mugungwha', '', '15', '1', '160729', '161027', '', '', '', '서문', '곽기현,김동진', '', '', '서울시 강북구 수유동 296-19', '`', '011031', 'seoul', '`', 'BA', '2016-12-01 16:11:22', NULL, '', 'Y', '', NULL, NULL), (166, '129784', '백호', 'Baek Ho', '', '1', '1', '161130', '170110', 'CC', '', '', '성북,뉴성북', '허재갑,고재종', '', '', '서울특별시 성북구 아리랑로 40', '백호 B/D 4층', '02829', '4th f/l, 40, Arirang-ro, Seongbuk-gu,', 'Seoul, Korea', 'BA', '2017-01-20 09:18:58', NULL, '', 'Y', '', NULL, NULL), (168, '132653', '소망', 'SOMANG', '성북', '5', '1', '170719', '170928', '', '', '', '광진', '문용덕문철호', '', '', '제주시 구좌읍 월정리', '1685', '-', '-', '-', 'BC', '2017-08-15 14:40:57', NULL, '', 'Y', '', NULL, NULL), (170, '135716', '씨이오', 'CEO', '.', '.', '.', '180701', '180701', '', '', '', '코리아나', '김동원', '', '', '.', '.', '.', '.', '.', 'BC', '2018-07-18 16:40:51', NULL, '', 'Y', '', NULL, NULL), (171, '135717', '뉴경성', 'NEWKYUNGSUNG', '.', '.', '.', '180701', '180701', '', '', '', '청마', '김재홍', '', '', '.', '.', '.', '.', '.', 'BC', '2018-07-20 10:58:11', NULL, '', 'Y', '', NULL, NULL), (172, '136677', '드림드림', 'DreamDream', '', '10', '1', '181019', '111111', 'CC', '', '', '코리아나', '김동원', '', '', '`', '`', '`', '`', '`', 'BC', '2018-10-05 14:54:32', NULL, '', 'Y', '', NULL, NULL), (173, '136567', '섬남MJF', 'SumNamMJF', '', '1', '1', '180928', '181005', '', '', '', '을지', '안두훈', '', '', '`', '`', '`', '`', '`', 'BA', '2018-10-05 15:01:06', NULL, '', 'Y', '', NULL, NULL), (174, '137497', 'BNH', 'BNH', '', '6', '2', '190220', '190424', '', '', '', 'APP', '이윤희', '', '', '`', '`', '`', '`', '`', 'BC', '2019-02-19 11:22:12', NULL, '', 'Y', '', NULL, NULL), (175, '139375', '풍차', 'POONGCHA', '노원구', '6', '3', '190725', '190808', '', '', '', '뉴리치', '김영신', '', '', '서울 송파구 삼전동', '301', '138-841', 'Samjeon-dong, Songpa-gu, Seoul', '`', 'BA', '2019-07-23 11:28:10', NULL, '', 'Y', '', NULL, NULL), (176, '139921', '남서울시니', 'NAMSEOUL SENIOR', '`', '2', '2', '190901', '190930', 'CC', '', '', '강북', '박영래', '', '', '`', '`', '`', '`', '`', 'BA', '2019-09-20 11:58:31', NULL, '', 'Y', '', NULL, NULL), (177, '140122', '신세계', 'Shinsegae', '강북', '2', '2', '191001', '191021', '', '', '', '한강', '강윤성', '', '', '`', '`', '`', '`', '`', 'BA', '2019-10-30 15:26:20', NULL, '', 'Y', '', NULL, NULL), (178, '141024', 'KTC드론', 'KTC DRONE', '광진', '1', '2', '200218', '200421', '', '', '', '청마', '박진후', '', '', '대전 서구 관저동', '4층', '302-243', 'Gwanjeo-dong, Seo-gu, Daejeon', '4F', 'BA', '2020-02-24 09:47:22', NULL, '', 'Y', '', NULL, NULL); /*!40000 ALTER TABLE `club` 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 */;