drop table MPSTSMS;
create table MPSTSMS
(
   SMS_ID           CHAR(14)          NOT NULL,
   OP_CD            CHAR(04)          NOT NULL,
   SP_ID            CHAR(04)          NOT NULL,
   SRV_ID           CHAR(05)          NOT NULL,
   OPR_ID           CHAR(05)          NOT NULL,
   CING_NO          CHAR(20)          NOT NULL,
   CED_NO           CHAR(20)          DEFAULT ' ',
   SMS              CHAR(140)         DEFAULT ' ',
   STA_REP          CHAR(01)          DEFAULT 'Y', 
   ORD_NO           CHAR(20)          DEFAULT ' ',
   OPP_NM           CHAR(60)          DEFAULT ' ',
   CMT_CD           CHAR(16)          DEFAULT ' ',
   TRF_NO           CHAR(16)          DEFAULT ' ',
   PRY_LVL          CHAR(01)          DEFAULT '1',
   RCV_DT           CHAR(08)          NOT NULL,
   RCV_TM           CHAR(06)          NOT NULL,
   SMS_ST           CHAR(01)          NOT NULL,
   SND_CNT          CHAR(02)          DEFAULT ' ',
   SND_TM           CHAR(06)          DEFAULT ' ',
   RSP_TM           CHAR(06)          DEFAULT ' ',
   UNQ_ID           CHAR(20)          DEFAULT ' ',
--   constraint PK_MPSSMSINF primary key (SMS_ID)
primary key (SMS_ID)
);