28 lines
1.1 KiB
SQL
28 lines
1.1 KiB
SQL
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)
|
|
);
|