Ext_Eisai_SMS

테이블 (5)

MMS_MO

  • NUM — int — 기본 키 — 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 — =

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 — 기본 키 — 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 — =

발송공통코드 (COMMONCODE)

  • 발송타입MMS/SMS (KIND) — nvarchar(255) — 기본 키 — NOT NULL
  • 발송코드 (CODE) — float — 기본 키 — NOT NULL
  • 발송결과 (CODENAME) — nvarchar(255)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

발송매니저 (MMS_MSG)

  • MSGKEY — int — 기본 키 — 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)
  • TEMPLATE_KEY — varchar(20)
  • BAR_CODE — varchar(30)
  • BAR_CODE_MERGE_TXT — varchar(256)
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =