CREATE TABLE TEST.GPPP001
(
    COMP_CD             VARCHAR2(4) NOT NULL,
    STY_CD              VARCHAR2(14) NOT NULL,
    PLAN_SEQ            VARCHAR2(13),
    WRK_GB              VARCHAR2(5),
    REG_DT              VARCHAR2(8),
    FIX_DT              VARCHAR2(8),
    MAT_DT              VARCHAR2(8),
    PR_DT               VARCHAR2(8),
    DELI_DT             VARCHAR2(8),
    IN_SHCD_DT          VARCHAR2(8),
    OUT_SHCD_DT         VARCHAR2(8),
    PROEN_DT            VARCHAR2(8),
    AF_OPRI_CLS_DT      VARCHAR2(8),
    UNFOLD_DT           VARCHAR2(8),
    TEST_IN_DT          VARCHAR2(8),
    RESULT_DT           VARCHAR2(8),
    ORIGIN              VARCHAR2(5),
    VD_CD               VARCHAR2(6),
    BF_RMAT_AMT         NUMBER(20,2),
    BF_SMAT_AMT         NUMBER(20,2),
    BF_CM_AMT           NUMBER(20,2),
    BF_MG_RATE          NUMBER(7,2),
    BF_MG_AMT           NUMBER(20,2),
    BF_OPRI             NUMBER(20,2) DEFAULT 0,
    BF_CF_UPRI          NUMBER(20,2),
    BF_IMPORT_AMT       NUMBER(20,2),
    BF_HQ_SMAT_AMT      NUMBER(20,2),
    BF_PROC_OPRI        NUMBER(20,2),
    MANAGE_RT           NUMBER(7,2),
    BF_MANAGE_OPRI      NUMBER(20,2),
    MULTIPLE            NUMBER(14,4),
    PNL_SALE_RT         NUMBER(7,2),
    PNL_SELL_RT         CHAR(18),
    FIX_YN              VARCHAR2(1),
    AF_RMAT_AMT         NUMBER(20,2),
    AF_SMAT_AMT         NUMBER(20,2),
    AF_CM_AMT           NUMBER(20,2),
    AF_IMPORT_AMT       NUMBER(20,2),
    AF_HQ_SMAT_AMT      NUMBER(20,2),
    AF_PROC_ETC_AMT     NUMBER(20,2),
    AF_H_EXP            NUMBER(20,2),
    AET_COST            NUMBER(20,2),
    AF_OPRI             NUMBER(20,2) DEFAULT 0,
    ACC_YYYYMM          VARCHAR2(6),
    ACC_OPRI            NUMBER(20,2) DEFAULT 0,
    FIX_YN_1            VARCHAR2(1),
    FIX_YN_DT_1         VARCHAR2(8),
    FIX_YN_USER_1       VARCHAR2(10),
    FIX_YN_2            VARCHAR2(1),
    FIX_YN_DT_2         VARCHAR2(8),
    FIX_YN_USER_2       VARCHAR2(10),
    FIX_YN_3            VARCHAR2(1),
    FIX_YN_DT_3         VARCHAR2(8),
    FIX_YN_USER_3       VARCHAR2(10),
    FIX_YN_4            VARCHAR2(1),
    FIX_YN_DT_4         VARCHAR2(8),
    FIX_YN_USER_4       VARCHAR2(10),
    FIX_YN_5            VARCHAR2(1),
    FIX_YN_DT_5         VARCHAR2(8),
    FIX_YN_USER_5       VARCHAR2(10),
    FIX_YN_6            VARCHAR2(1),
    FIX_YN_DT_6         VARCHAR2(8),
    FIX_YN_USER_6       VARCHAR2(10),
    AF_MULTIPLE         NUMBER(20,2),
    BF_OPRI_CLS_DT      VARCHAR2(8),
    AF_NEGO_AMT         NUMBER(20,2),
    ANEGO_PRI           NUMBER(20,2),
    AF_ETC_EXP          NUMBER(20,2),
    AF_MG_AMT           NUMBER(20,2),
    IMAGE_PATH          VARCHAR2(200),
    IMAGE_PATH_2        VARCHAR2(200),
    IN_USER             VARCHAR2(20),
    STD_SIZE_CD         VARCHAR2(20),
    SAMPLE_CD           VARCHAR2(100),
    IN_TIME             DATE,
    UPD_USER            VARCHAR2(20),
    UPD_TIME            DATE,
    BT_CF_DT            VARCHAR2(8),
    FACTORY_NM          VARCHAR2(100),
    TR_DELI_DT          VARCHAR2(8),
    CUST_EMP_ID         VARCHAR2(30),
    TEL_NO              VARCHAR2(30),
    FIX_YN_7            VARCHAR2(1),
    FIX_YN_DT_7         VARCHAR2(8),
    FIX_YN_USER_7       VARCHAR2(10),
    CF_QC_YN            VARCHAR2(1),
    CF_QC_DT            VARCHAR2(8),
    CF_QC_USER          VARCHAR2(10),
    DELI_INPUT_ID       VARCHAR2(10),
    DELI_INPUT_DT       VARCHAR2(8),
    DELI_TR_INPUT_ID    VARCHAR2(10),
    DELI_TR_INPUT_DT    VARCHAR2(8),
    HISTORY_COMMENT     VARCHAR2(300),
    TR_UNFOLD_DT        VARCHAR2(8),
    DELAY_REASON        VARCHAR2(4000),
    PROCESS_CONTENT     VARCHAR2(4000),
    ORG_COMP_CD         VARCHAR2(4),
    ORG_VD_CD           VARCHAR2(6),
    IN_CLOSE            VARCHAR2(1),
    BF_SALE_RATE        NUMBER(20,2),
    ERP_COLOR_CD        VARCHAR2(3),
    ERP_COLOR_NM        VARCHAR2(100)
)
TABLESPACE USERS
STORAGE
(
    INITIAL 64K
    NEXT 1M
    BUFFER_POOL KEEP
)
NOCOMPRESS;

CREATE UNIQUE INDEX TEST.PK_GPPP001
ON TEST.GPPP001 (COMP_CD,STY_CD) 
TABLESPACE USERS
STORAGE
(
    INITIAL 64K
    NEXT 1M
);

ALTER TABLE TEST.GPPP001
ADD CONSTRAINT IX_GPPP001_01 PRIMARY KEY (COMP_CD,STY_CD);