
IF NOT EXISTS (SELECT 1 FROM KSQL_USERTABLES WHERE KSQL_TABNAME = 'T_ER_CONTRACT_ITEM')
CREATE TABLE T_ER_CONTRACT_ITEM (
                                    FID BIGINT DEFAULT 0 NOT NULL,
                                    FENTRYID BIGINT DEFAULT 1 NOT NULL,
                                    FSEQ INT DEFAULT 0 NOT NULL,
                                    FITEMCODE VARCHAR(255) DEFAULT ' ' NOT NULL,
                                    FTTEMNAME VARCHAR(255) DEFAULT ' ' NOT NULL,
                                    FITEMCONTENT NCLOB DEFAULT ' '
);


EXEC P_ALTERPK 'PK_T_ER_CONTRACT_ITEM', 'T_ER_CONTRACT_ITEM', 'FENTRYID', '0';


