/****************************************************************************/
/* GEA03 ( ｶﾗﾑ定義 )                                                        */
/* Created : 2021/06/29 13:32:29                                            */
/****************************************************************************/


ALTER TABLE GEA03 DROP CONSTRAINT GEA03_UQ;

ALTER TABLE GEA03 ADD CONSTRAINT GEA03_UQ PRIMARY KEY ( UNIQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


DROP INDEX GEA03_SA;

CREATE INDEX GEA03_SA ON GEA03( SYSTEM_ID,CLM,KBSAKU,FGJ )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


DROP INDEX GEA03_SB;

CREATE INDEX GEA03_SB ON GEA03( SYSTEM_ID,FGJ,KBSAKU,CLM )
TABLESPACE GFTBL01
STORAGE( INITIAL 64K )
;
