Ext_DSKR_SMS
Tables (4)
MMS_MO
- NUM — int — Primary key — NOT NULL
- ID — varchar(50)
- MONUMBER — varchar(20)
- SENDER — varchar(20)
- CALLBACK — varchar(20)
- SUBJECT — varchar(60)
- NETCODE — varchar(3)
- STATUS — char(1) — NOT NULL
- SND_DATE — varchar(14)
- RCV_DATE — varchar(14)
- INS_DATE — varchar(14)
- MESSAGE — varchar(4000)
- CONTENT_COUNT — int — NOT NULL
- CONTENT1_EXT — varchar(10)
- CONTENT1_NAME — varchar(128)
- CONTENT1_SIZE — int
- CONTENT1_PATH — varchar(256)
- CONTENT2_EXT — varchar(10)
- CONTENT2_NAME — varchar(128)
- CONTENT2_SIZE — int
- CONTENT2_PATH — varchar(256)
- CONTENT3_EXT — varchar(10)
- CONTENT3_NAME — varchar(128)
- CONTENT3_SIZE — int
- CONTENT3_PATH — varchar(256)
- CONTENT4_EXT — varchar(10)
- CONTENT4_NAME — varchar(128)
- CONTENT4_SIZE — int
- CONTENT4_PATH — varchar(256)
- CONTENT5_EXT — varchar(10)
- CONTENT5_NAME — varchar(128)
- CONTENT5_SIZE — int
- CONTENT5_PATH — varchar(256)
- CONTENT6_EXT — varchar(10)
- CONTENT6_NAME — varchar(128)
- CONTENT6_SIZE — int
- CONTENT6_PATH — varchar(256)
- CONTENT7_EXT — varchar(10)
- CONTENT7_NAME — varchar(128)
- CONTENT7_SIZE — int
- CONTENT7_PATH — varchar(256)
- CONTENT8_EXT — varchar(10)
- CONTENT8_NAME — varchar(128)
- CONTENT8_SIZE — int
- CONTENT8_PATH — varchar(256)
- CONTENT9_EXT — varchar(10)
- CONTENT9_NAME — varchar(128)
- CONTENT9_SIZE — int
- CONTENT9_PATH — varchar(256)
- CONTENT10_EXT — varchar(10)
- CONTENT10_NAME — varchar(128)
- CONTENT10_SIZE — int
- CONTENT10_PATH — varchar(256)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MMS_MSG
- MSGKEY — int — Primary key — NOT NULL
- SUBJECT — varchar(120)
- PHONE — varchar(15) — NOT NULL
- CALLBACK — varchar(15) — NOT NULL
- STATUS — varchar(2) — NOT NULL
- REQDATE — datetime — NOT NULL
- MSG — varchar(4000)
- FILE_CNT — int — NOT NULL
- FILE_CNT_REAL — int
- FILE_PATH1 — varchar(512)
- FILE_PATH1_SIZ — int
- FILE_PATH2 — varchar(512)
- FILE_PATH2_SIZ — int
- FILE_PATH3 — varchar(512)
- FILE_PATH3_SIZ — int
- FILE_PATH4 — varchar(512)
- FILE_PATH4_SIZ — int
- FILE_PATH5 — varchar(512)
- FILE_PATH5_SIZ — int
- EXPIRETIME — varchar(10) — NOT NULL
- SENTDATE — datetime
- RSLTDATE — datetime
- REPORTDATE — datetime
- TERMINATEDDATE — datetime
- RSLT — varchar(4)
- TYPE — varchar(2) — NOT NULL
- TELCOINFO — varchar(10)
- ROUTE_ID — varchar(20)
- ID — varchar(20)
- POST — varchar(20)
- ETC1 — varchar(64)
- ETC2 — varchar(32)
- ETC3 — varchar(32)
- ETC4 — int
- MULTI_SEQ — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
MO_MAP
- MO_NUMBER — varchar(20)
- ALARM_YN — varchar(1)
- ALARM_DAY_TIME — varchar(20)
- ALARM_DAY_RECEIVERS — varchar(200)
- ALARM_DAY_SENDER — varchar(20)
- ALARM_NIGHT_TIME — varchar(20)
- ALARM_NIGHT_RECEIVERS — varchar(200)
- ALARM_NIGHT_SENDER — varchar(20)
- ALARM_MSG — varchar(160)
- AUTO_REPLY_YN — varchar(1)
- AUTO_REPLY_MSG — varchar(160)
MO_TRAN
- MO_NUM — int — Primary key — NOT NULL
- MO_ACCEPTTIME — varchar(14)
- MO_MODIFIED — varchar(14)
- MO_NUMBER — varchar(20)
- MO_SENDER — varchar(20)
- MO_ORGADDR — varchar(20)
- MO_MSG — varchar(160)
- MO_SN — int
- MO_NET — varchar(10)
- MO_STATUS — varchar(1)
- MO_REPLY_DATE — varchar(14)
- MO_REPLY_MSG — varchar(160)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =