CREATE TABLE `zipcode_street` (
`ZIPCODE` VARCHAR(6) NOT NULL COMMENT '우편번호',
`ZIPSEQ` INT(11) DEFAULT NULL COMMENT '우편일련번호',
`SIDO` VARCHAR(21) DEFAULT NULL COMMENT '시도',
`GUGUN` VARCHAR(25) DEFAULT NULL COMMENT '시군구',
`EUPMYUN` VARCHAR(12) DEFAULT NULL COMMENT '읍면',
`STREETCODE` VARCHAR(12) DEFAULT NULL COMMENT '도로명코드',
`STREET` VARCHAR(30) DEFAULT NULL COMMENT '도로명',
`ISUNDER` CHAR(1) DEFAULT NULL COMMENT '지하여부(1,0)',
`BUILDINGNUM1` INT(11) DEFAULT NULL COMMENT '건물번호본번',
`BUILDINGNUM2` INT(11) DEFAULT NULL COMMENT '건물번호부번',
`BUILDING` VARCHAR(60) DEFAULT NULL COMMENT '다량배달처명(건물명)',
`DONGCODE` VARCHAR(10) DEFAULT NULL COMMENT '법정동코드',
`DONG` VARCHAR(16) DEFAULT NULL COMMENT '법정동명',
`BLDGCODE` VARCHAR(26) NOT NULL COMMENT '건물관리번호',
PRIMARY KEY (`BLDGCODE`),
KEY `IDX_ZIPCODE` (`ZIPCODE`),
KEY `IDX_GUGUN` (`GUGUN`),
KEY `IDX_EUPMYUN` (`EUPMYUN`),
KEY `IDX_STREET` (`STREET`),
KEY `IDX_BUILDING` (`BUILDING`),
KEY `IDX_DONG` (`DONG`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8