CREATE TABLE TEST.GPPP057 ( COMP_CD VARCHAR2(4) NOT NULL, STY_CD VARCHAR2(14) NOT NULL, SEQ VARCHAR2(3) NOT NULL, QC1_FIX_GB VARCHAR2(1), QC1_FIX_CF_DT VARCHAR2(8), RE_QC1_LDIV VARCHAR2(5), RE_QC1_MDIV VARCHAR2(5), RE_QC1_DT VARCHAR2(8), RE_QC1_REMARK VARCHAR2(1000), QC1_IN_USER VARCHAR2(20), QC1_IN_TIME DATE, QC1_UPD_USER VARCHAR2(20), QC1_UPD_TIME DATE, QC2_FIX_GB VARCHAR2(1), QC2_FIX_CF_DT VARCHAR2(8), RE_QC2_LDIV VARCHAR2(5), RE_QC2_MDIV VARCHAR2(5), RE_QC2_DT VARCHAR2(8), RE_QC2_REMARK VARCHAR2(1000), QC2_IN_USER VARCHAR2(20), QC2_IN_TIME DATE, QC2_UPD_USER VARCHAR2(20), QC2_UPD_TIME DATE, QC3_FIX_GB VARCHAR2(1), QC3_FIX_CF_DT VARCHAR2(8), RE_QC3_LDIV VARCHAR2(5), RE_QC3_MDIV VARCHAR2(5), RE_QC3_DT VARCHAR2(8), RE_QC3_REMARK VARCHAR2(1000), QC3_IN_USER VARCHAR2(20), QC3_IN_TIME DATE, QC3_UPD_USER VARCHAR2(20), QC3_UPD_TIME DATE, QC4_FIX_GB VARCHAR2(1), QC4_FIX_CF_DT VARCHAR2(8), RE_QC4_LDIV VARCHAR2(5), RE_QC4_MDIV VARCHAR2(5), RE_QC4_DT VARCHAR2(8), RE_QC4_REMARK VARCHAR2(1000), QC4_IN_USER VARCHAR2(20), QC4_IN_TIME DATE, QC4_UPD_USER VARCHAR2(20), QC4_UPD_TIME DATE, QC5_FIX_GB VARCHAR2(1), QC5_FIX_CF_DT VARCHAR2(8), RE_QC5_LDIV VARCHAR2(5), RE_QC5_MDIV VARCHAR2(5), RE_QC5_DT VARCHAR2(8), RE_QC5_REMARK VARCHAR2(1000), QC5_IN_USER VARCHAR2(20), QC5_IN_TIME DATE, QC5_UPD_USER VARCHAR2(20), QC5_UPD_TIME DATE, QC6_FIX_GB VARCHAR2(1), QC6_FIX_CF_DT VARCHAR2(8), RE_QC6_LDIV VARCHAR2(5), RE_QC6_MDIV VARCHAR2(5), RE_QC6_DT VARCHAR2(8), RE_QC6_REMARK VARCHAR2(1000), QC6_IN_USER VARCHAR2(20), QC6_IN_TIME DATE, QC6_UPD_USER VARCHAR2(20), QC6_UPD_TIME DATE, QC7_FIX_GB VARCHAR2(1), QC7_FIX_CF_DT VARCHAR2(8), RE_QC7_LDIV VARCHAR2(5), RE_QC7_MDIV VARCHAR2(5), RE_QC7_DT VARCHAR2(8), RE_QC7_REMARK VARCHAR2(1000), QC7_IN_USER VARCHAR2(20), QC7_IN_TIME DATE, QC7_UPD_USER VARCHAR2(20), QC7_UPD_TIME DATE, QC8_FIX_GB VARCHAR2(1), QC8_FIX_CF_DT VARCHAR2(8), RE_QC8_LDIV VARCHAR2(5), RE_QC8_MDIV VARCHAR2(5), RE_QC8_DT VARCHAR2(8), RE_QC8_REMARK VARCHAR2(1000), QC8_IN_USER VARCHAR2(20), QC8_IN_TIME DATE, QC8_UPD_USER VARCHAR2(20), QC8_UPD_TIME DATE, QC9_FIX_GB VARCHAR2(1), QC9_FIX_CF_DT VARCHAR2(8), RE_QC9_LDIV VARCHAR2(5), RE_QC9_MDIV VARCHAR2(5), RE_QC9_DT VARCHAR2(8), RE_QC9_REMARK VARCHAR2(1000), QC9_IN_USER VARCHAR2(20), QC9_IN_TIME DATE, QC9_UPD_USER VARCHAR2(20), QC9_UPD_TIME DATE ) TABLESPACE USERS STORAGE ( INITIAL 64K NEXT 1M ) NOCOMPRESS; CREATE UNIQUE INDEX TEST.IX_GPPP057_01 ON TEST.GPPP057 (COMP_CD,STY_CD,SEQ) TABLESPACE USERS STORAGE ( INITIAL 64K NEXT 1M ); ALTER TABLE TEST.GPPP057 ADD CONSTRAINT PK_GPPP057 PRIMARY KEY (COMP_CD,STY_CD,SEQ);