CREATE TABLE `zipcode_street` (
`DONGCODE` VARCHAR(10) DEFAULT NULL COMMENT '법정동코드[10자리]',
`SIDO` VARCHAR(30) DEFAULT NULL COMMENT '시도',
`SIGUNGU` VARCHAR(30) DEFAULT NULL COMMENT '시군구',
`DONG` VARCHAR(30) DEFAULT NULL COMMENT '법정읍면동명',
`RI` VARCHAR(30) DEFAULT NULL COMMENT '법정리명',
`ISMOUNTAIN` CHAR(1) NOT NULL DEFAULT '0' COMMENT '산여부(0:토지,1:산)(PK2)',
`JIBUN1` INT(4) NOT NULL COMMENT '관련지번본번(PK3)',
`JIBUN2` INT(4) NOT NULL COMMENT '관련지번부번(PK4)',
`STREETCODE` VARCHAR(12) DEFAULT NULL COMMENT '도로명코드',
`STREET` VARCHAR(90) DEFAULT NULL COMMENT '도로명',
`ISUNDER` CHAR(1) DEFAULT NULL COMMENT '지하여부(0:지상,1:지하,2:공중)',
`BUILDINGNUM1` VARCHAR(5) DEFAULT NULL COMMENT '건물본번',
`BUILDINGNUM2` VARCHAR(5) DEFAULT NULL COMMENT '건물부번',
`BUILDING` VARCHAR(50) DEFAULT NULL COMMENT '건물명',
`BUILDINGDETAIL` VARCHAR(110) DEFAULT NULL COMMENT '상세건물명',
`BUILDINGCODE` VARCHAR(25) NOT NULL DEFAULT '' COMMENT '건물관리번호(PK1)',
`DONGSEQ` VARCHAR(2) DEFAULT NULL COMMENT '읍면동일련번호',
`HAENGDONGCODE` VARCHAR(10) DEFAULT NULL COMMENT '행정동코드',
`HAENGDONG` VARCHAR(30) DEFAULT NULL COMMENT '행정동명',
`ZIPCODE` VARCHAR(6) DEFAULT NULL COMMENT '우편번호',
`ZIPSEQ` VARCHAR(10) DEFAULT NULL COMMENT '우편일련번호',
`MASSDESTINATION` VARCHAR(60) DEFAULT NULL COMMENT '다량배달처명',
PRIMARY KEY (`BUILDINGCODE`,`ISMOUNTAIN`,`JIBUN1`,`JIBUN2`),
KEY `IDX_STREET` (`STREET`),
KEY `IDX_DONG` (`DONG`),
KEY `IDX_BUILDING` (`BUILDING`),
KEY `IDX_MASSDESTINATION` (`MASSDESTINATION`),
KEY `IDX_ZIPCODE` (`ZIPCODE`)
) ENGINE=MYISAM DEFAULT CHARSET=utf8