/****************************************************************************/
/* GF42 ( 郵便番号定義 )                                                    */
/* Created : 2016/04/02 23:31:07                                            */
/****************************************************************************/


ALTER TABLE GF42 ADD CONSTRAINT GF42_LUQ UNIQUE( POSTCODE,PREF_KANA,CITY_KANA,TOWN_KANA );


CREATE INDEX GF42_SA ON GF42( JIGYO_KANA );


CREATE INDEX GF42_SB ON GF42( CITY_KANA,JISCODE );


CREATE INDEX GF42_SC ON GF42( TOWN_KANA );


CREATE INDEX GF42_SD ON GF42( JIGYO_KANJI );


CREATE INDEX GF42_SE ON GF42( CITY_KANJI );


CREATE INDEX GF42_SF ON GF42( TOWN_KANJI );
