/****************************************************************************/
/* GF90 ( 青紙ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2017/07/31 15:48:30                                            */
/****************************************************************************/


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


ALTER TABLE GF90 ADD CONSTRAINT GF90_LUQ UNIQUE( SYSTEM_ID,PGID,CDSAKU )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


CREATE INDEX GF90_SA ON GF90( SYSTEM_ID,SEQ )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


CREATE INDEX GF90_SB ON GF90( SIYOSAKU )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


CREATE INDEX GF90_SC ON GF90( PGSAKU )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


CREATE INDEX GF90_SD ON GF90( PGKEN )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


CREATE INDEX GF90_SE ON GF90( CDSAKU )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;
