<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF42'>
/****************************************************************************/
/* GF42 ( 郵便番号定義 )                                                    */
/*                                                                          */
/* Created : 2018/09/28 16:03:33                                            */
/****************************************************************************/
<EXEC_SQL>
CREATE TABLE GF42 (
   JISCODE          VARCHAR (   5 )         NOT NULL                
 , POSTCODE_SHORT   VARCHAR (   5 )                                 
 , POSTCODE         VARCHAR (   7 )         NOT NULL                
 , JIGYO_KANA       VARCHAR ( 300 )                                 
 , PREF_KANA        VARCHAR (  30 )                                 
 , CITY_KANA        VARCHAR ( 100 )                                 
 , TOWN_KANA        VARCHAR ( 300 )                                 
 , JIGYO_KANJI      VARCHAR ( 300 )                                 
 , PREF_KANJI       VARCHAR (  12 )                                 
 , CITY_KANJI       VARCHAR (  36 )                                 
 , TOWN_KANJI       VARCHAR ( 200 )                                 
 , BLOCK_KANJI      VARCHAR ( 200 )                                 
 , CODE_SHU         VARCHAR (   1 )                                 
)
</EXEC_SQL>
</ROWSET>
