Untitled

CREATE TABLE MISA_TEMP_DOWN_HIS_ACTV
(
    BIZ_KEY     VARCHAR(20),
    DOC_ID      VARCHAR(50),
    APPRVR_ID   VARCHAR(100),
    APPRVR_STTS CHAR(1),
    APPRVR_NM   VARCHAR(100),
    APPR_DTM    VARCHAR(14),
    REG_ID      VARCHAR(100),
    REG_DTM     VARCHAR(14),
    MOD_ID      VARCHAR(100),
    MOD_DTM     VARCHAR(14)
);

COMMENT ON TABLE MISA_TEMP_DOWN_HIS_ACTV IS 'MISA_TEMP_DOWN_HIS_ACTV';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.BIZ_KEY IS '사업자키';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.DOC_ID IS '문서ID';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.APPRVR_ID IS 'approver ID';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.APPRVR_STTS IS 'approver status';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.APPRVR_NM IS 'approver name';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.APPR_DTM IS 'approval datetime';
COMMENT ON COLUMN ACCT_TRNS_RCV_PAY_INFM.REG_ID IS '등록자ID';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.REG_DTM IS '등록일시';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.MOD_ID IS '수정자ID';
COMMENT ON COLUMN MISA_TEMP_DOWN_HIS_ACTV.MOD_DTM IS '수정일시';


ALTER TABLE MISA_TEMP_DOWN_HIS_ACTV
    ADD CONSTRAINT PK_MISA_TEMP_DOWN_HIS_ACTV PRIMARY KEY (
                                                           BIZ_KEY, DOC_ID, APPRVR_ID
        );


--- MISA_TEMP_DOWN_HIS_ACTV_C001 ---
INSERT INTO MISA_TEMP_DOWN_HIS_ACTV ( BIZ_KEY
                                    , DOC_ID
                                    , APPRVR_ID
                                    , APPRVR_STTS
                                    , APPRVR_NM
                                    , APPR_DTM
                                    , REG_ID
                                    , REG_DTM
                                    , MOD_ID
                                    , MOD_DTM)
VALUES ( :BIZ_KEY
       , :DOC_ID
       , :APPRVR_ID
       , :APPRVR_STTS
       , :APPRVR_NM
       , :APPR_DTM
       , :REG_ID
       , :REG_DTM
       , :MOD_ID
       , :MOD_DTM);

--- MISA_TEMP_DOWN_HIS_ACTV_R001 ---
SELECT BIZ_KEY
     , DOC_ID
     , APPRVR_ID
     , APPRVR_STTS
     , APPRVR_NM
     , APPR_DTM
     , REG_ID
     , REG_DTM
     , MOD_ID
     , MOD_DTM
FROM MISA_TEMP_DOWN_HIS_ACTV
WHERE 1 = 1
    ??;

--- MISA_TEMP_DOWN_HIS_ACTV_U001 ---
UPDATE MISA_TEMP_DOWN_HIS_ACTV
SET APPRVR_STTS = COALESCE(:APPRVR_STTS, APPRVR_STTS)
  , APPRVR_NM   = COALESCE(:APPRVR_NM, APPRVR_NM)
  , APPR_DTM    = COALESCE(:APPR_DTM, APPR_DTM)
  , MOD_ID      = COALESCE(:MOD_ID, MOD_ID)
  , MOD_DTM     = COALESCE(:MOD_DTM, MOD_DTM)
WHERE BIZ_KEY = :BIZ_KEY
  AND DOC_ID = :DOC_ID
  AND APPRVR_ID = :APPRVR_ID;


--- MISA_TEMP_DOWN_HIS_ACTV_D001 ---
DELETE
FROM MISA_TEMP_DOWN_HIS_ACTV
WHERE BIZ_KEY = :BIZ_KEY
  AND DOC_ID = :DOC_ID
  AND APPRVR_ID = :APPRVR_ID;

--- MISA_TEMP_DOWN_HIS_ACTV_U000 ---
UPDATE MISA_TEMP_DOWN_HIS_ACTV
SET FIELDS_TO_UPDATE = :FIELDS_TO_UPDATE
WHERE BIZ_KEY = :BIZ_KEY
  AND DOC_ID = :DOC_ID
  AND APPRVR_ID = :APPRVR_ID;

--- MISA_TEMP_DOWN_HIS_ACTV_R001_CNT ---
SELECT COUNT(*) AS TOT_CNT
FROM MISA_TEMP_DOWN_HIS_ACTV
WHERE 1 = 1
    ??;