김천시_sms
테이블 (21)
KNLSP_ENVIRONMENT
- OFF_INDEX — varchar(2) — 기본 키 — NOT NULL
- ENV_IMID — varchar(100)
- ENV_IMIP — varchar(100)
- ENV_MADD — varchar(100)
- ENV_SEID — varchar(100)
- ENV_SICO — varchar(100)
- ENV_DANO — varchar(100)
- ENV_DAIP — varchar(100)
- ENV_NAME — varchar(100)
- ENV_PHON — varchar(100)
- ENV_SEPK — varchar(100)
- ENV_SEGU — varchar(100)
- ENV_SENO — varchar(100)
- expirydate — varchar(50)
- first_memo — varchar(100)
- second_memo — varchar(100)
- third_memo — varchar(100)
- day_week_gubun — char(1)
- chk_sun — char(1)
- chk_mon — char(1)
- chk_tue — char(1)
- chk_wed — char(1)
- chk_thu — char(1)
- chk_fri — char(1)
- chk_sat — char(1)
- sche_time — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_FMS_RECEIVE
- JOB_ID — int — 기본 키 — NOT NULL
- SUBJOB_ID — int
- ANI_NUMBER — varchar(20)
- DEST_NUMBER — varchar(20)
- FILE_NAME — varchar(250)
- RESULT — int — NOT NULL
- TCS_RESULT — int
- STIME — varchar(20)
- RTIME — varchar(20)
- FEE — float
- DURATION — varchar(20)
- FAX_PAGE — int — NOT NULL
- MSG_ID — int — NOT NULL
- RECV_DATE — varchar(20)
- STAT_STATUS — int — NOT NULL
- UMS_MEMO — varchar(100)
- DEL_TM — varchar(14)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_FMS_REPORT
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- MSG_SUBTYPE — int — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- DEST_TYPE — int — NOT NULL
- SUBJECT — varchar(50)
- NOW_DATE — varchar(20)
- SEND_DATE — varchar(20) — NOT NULL
- CALLBACK — varchar(20)
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- ATTACH_FILE — text — NOT NULL
- RESERVED1 — varchar(50)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SUCC_COUNT — int — NOT NULL
- FAIL_COUNT — int — NOT NULL
- CANCEL_STATUS — int — NOT NULL
- CANCEL_COUNT — int — NOT NULL
- CANCEL_REQ_DATE — varchar(20)
- CANCEL_RESULT — int — NOT NULL
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_FMS_REPORT_DETAIL
- MSG_ID — int — 기본 키 — NOT NULL
- SUBJOB_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- SEND_DATE — varchar(20) — NOT NULL
- DEST_NAME — varchar(20) — NOT NULL
- PHONE_NUMBER — varchar(20) — NOT NULL
- RESULT — int — NOT NULL
- TCS_RESULT — int
- DELIVER_DATE — varchar(20)
- FEE — float
- FAX_PAGE — int — NOT NULL
- REPORT_STATUS — int — NOT NULL
- REPORT_COUNT — int — NOT NULL
- REPORT_REQ_DATE — varchar(20)
- REPORT_RES_DATE — varchar(20)
- MSG_SUBJOB_TYPE — int
- STAT_STATUS — int — NOT NULL
- STATUS_TEXT — varchar(200)
- SEND_SPID — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_FMS_SEND
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- MSG_SUBTYPE — int — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- DEST_TYPE — int — NOT NULL
- SUBJECT — varchar(50)
- NOW_DATE — varchar(20)
- SEND_DATE — varchar(20) — NOT NULL
- CALLBACK — varchar(20)
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- ATTACH_FILE — text — NOT NULL
- RESERVED1 — varchar(50)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SEND_STATUS — int — NOT NULL
- SEND_COUNT — int — NOT NULL
- SEND_RESULT — int — NOT NULL
- SEND_PROC_TIME — varchar(20)
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_MMS_REPORT
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- SUBJECT — varchar(64)
- NOW_DATE — varchar(16)
- SEND_DATE — varchar(16) — NOT NULL
- CALLBACK — varchar(20) — NOT NULL
- MMS_MSG — text
- CONTENT_COUNT — int — NOT NULL
- CONTENT_DATA — varchar(250)
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- RESERVED1 — varchar(50)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SUCC_COUNT — int — NOT NULL
- FAIL_COUNT — int — NOT NULL
- MSG_TYPE — int — NOT NULL
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_MMS_REPORT_DETAIL
- MSG_ID — int — 기본 키 — NOT NULL
- SUBJOB_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- SEND_DATE — varchar(16)
- DEST_NAME — varchar(20)
- PHONE_NUMBER — varchar(20)
- RESULT — int — NOT NULL
- TCS_RESULT — int
- DELIVER_DATE — varchar(20)
- READ_TIME — varchar(20)
- MOBILE_INFO — int
- FEE — int
- REPORT_RES_DATE — varchar(20)
- STAT_STATUS — int — NOT NULL
- STIME — varchar(16)
- RTIME — varchar(16)
- STATUS_TEXT — varchar(200)
- SEND_SPID — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_MMS_SEND
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- SUBJECT — varchar(64)
- NOW_DATE — varchar(16) — NOT NULL
- SEND_DATE — varchar(16) — NOT NULL
- CALLBACK — varchar(20) — NOT NULL
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- MMS_MSG — text
- CONTENT_COUNT — int — NOT NULL
- CONTENT_DATA — varchar(250)
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- RESERVED1 — varchar(50)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SEND_STATUS — int — NOT NULL
- SEND_COUNT — int — NOT NULL
- SEND_RESULT — int — NOT NULL
- SEND_PROC_TIME — varchar(20)
- MSG_TYPE — int — NOT NULL
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_RECV_STAT
- RECV_YEAR — char(4) — 기본 키 — NOT NULL
- RECV_MONTH — char(2) — 기본 키 — NOT NULL
- RECV_DAY — char(2) — 기본 키 — NOT NULL
- RECV_HOUR — char(2) — 기본 키 — NOT NULL
- SMS_TOTAL — int — NOT NULL
- FMS_TOTAL — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_SEND_STAT
- SEND_YEAR — char(4) — 기본 키 — NOT NULL
- SEND_MONTH — char(2) — 기본 키 — NOT NULL
- SEND_DAY — char(2) — 기본 키 — NOT NULL
- SEND_HOUR — char(2) — 기본 키 — NOT NULL
- USER_ID — varchar(20) — 기본 키 — NOT NULL
- SMS_TOTAL — int — NOT NULL
- SMS_SUCC — int — NOT NULL
- VMS_TTS_TOTAL — int — NOT NULL
- VMS_TTS_SUCC — int — NOT NULL
- VMS_FILE_TOTAL — int — NOT NULL
- VMS_FILE_SUCC — int — NOT NULL
- VMS_MSTG_TOTAL — int — NOT NULL
- VMS_MSTG_SUCC — int — NOT NULL
- VMS_SP_TOTAL — int — NOT NULL
- VMS_SP_SUCC — int — NOT NULL
- FMS_TOTAL — int — NOT NULL
- FMS_SUCC — int — NOT NULL
- MMS_TOTAL — int — NOT NULL
- MMS_SUCC — int — NOT NULL
- THREAD_NO — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_SMS_RECEIVE
- JOB_ID — int — 기본 키 — NOT NULL
- MSG_ID — int — NOT NULL
- CALLBACK — varchar(20) — NOT NULL
- ANI_NUMBER — varchar(20) — NOT NULL
- DEST_NUMBER — varchar(20) — NOT NULL
- SMS_MSG — varchar(200) — NOT NULL
- RECV_DATE — varchar(20) — NOT NULL
- REPORT_STATUS — int — NOT NULL
- REPORT_COUNT — int — NOT NULL
- REPORT_PROC_TIME — varchar(20)
- REPORT_RESULT — int — NOT NULL
- STAT_STATUS — int — NOT NULL
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_SMS_REPORT
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- SUBJECT — varchar(50)
- SMS_MSG — varchar(200)
- CALLBACK_URL — varchar(200)
- NOW_DATE — varchar(20)
- SEND_DATE — varchar(20) — NOT NULL
- CALLBACK — varchar(20)
- DEST_TYPE — int — NOT NULL
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- RESERVED1 — varchar(64)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SUCC_COUNT — int — NOT NULL
- FAIL_COUNT — int — NOT NULL
- CANCEL_STATUS — int — NOT NULL
- CANCEL_COUNT — int — NOT NULL
- CANCEL_REQ_DATE — varchar(20)
- CANCEL_RESULT — int — NOT NULL
- DELIVER_STATUS — int — NOT NULL
- DELIVER_COUNT — int — NOT NULL
- DELIVER_REQ_DATE — varchar(20)
- DELIVER_RESULT — int — NOT NULL
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_SMS_REPORT_DETAIL
- MSG_ID — int — 기본 키 — NOT NULL
- SUBJOB_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- SEND_DATE — varchar(20) — NOT NULL
- DEST_NAME — varchar(20) — NOT NULL
- PHONE_NUMBER — varchar(20) — NOT NULL
- RESULT — int — NOT NULL
- TCS_RESULT — int
- FEE — float
- DELIVER_DATE — varchar(20)
- REPORT_RES_DATE — varchar(20)
- MSG_SUBJOB_TYPE — int
- STAT_STATUS — int — NOT NULL
- TELCOINFO — varchar(8)
- STATUS_TEXT — varchar(200)
- SEND_SPID — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_SMS_SEND
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- SUBJECT — varchar(50)
- SMS_MSG — varchar(200)
- CALLBACK_URL — varchar(200)
- NOW_DATE — varchar(20)
- SEND_DATE — varchar(20) — NOT NULL
- CALLBACK — varchar(20)
- DEST_TYPE — int — NOT NULL
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- RESERVED1 — varchar(64)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SEND_STATUS — int — NOT NULL
- SEND_COUNT — int — NOT NULL
- SEND_RESULT — int — NOT NULL
- SEND_PROC_TIME — varchar(20)
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_VMS_REPORT
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20)
- JOB_ID — bigint — NOT NULL
- MSG_SUBTYPE — int — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- DEST_TYPE — int — NOT NULL
- MENT_TYPE — int — NOT NULL
- VOICE_TYPE — int — NOT NULL
- SUBJECT — varchar(50)
- NOW_DATE — varchar(20)
- SEND_DATE — varchar(20) — NOT NULL
- CALLBACK — varchar(20)
- REPLY_TYPE — int — NOT NULL
- REPLY_COUNT — int — NOT NULL
- COUNSELOR_DTMF — int — NOT NULL
- COUNSELOR_NUMBER — varchar(20)
- RELISTEN_COUNT — int — NOT NULL
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- SMSPLUS_MSG — varchar(100)
- HEADER_MSG — varchar(150)
- TAIL_MSG — varchar(150)
- TTS_MSG — text
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- ATTACH_FILE — text
- RESERVED1 — varchar(50)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SUCC_COUNT — int — NOT NULL
- FAIL_COUNT — int — NOT NULL
- CANCEL_STATUS — int — NOT NULL
- CANCEL_COUNT — int — NOT NULL
- CANCEL_REQ_DATE — varchar(20)
- CANCEL_RESULT — int — NOT NULL
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_VMS_REPORT_DETAIL
- MSG_ID — int — 기본 키 — NOT NULL
- SUBJOB_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- JOB_ID — bigint — NOT NULL
- SEND_DATE — varchar(20) — NOT NULL
- DEST_NAME — varchar(20) — NOT NULL
- PHONE_NUMBER — varchar(20) — NOT NULL
- RESULT — int — NOT NULL
- TCS_RESULT — int
- STIME — varchar(20)
- RTIME — varchar(20)
- FEE — float
- DURATION — int — NOT NULL
- REPLIED_DTMF — int — NOT NULL
- REPLIED_FILE — varchar(250)
- REPORT_STATUS — int — NOT NULL
- REPORT_COUNT — int — NOT NULL
- REPORT_REQ_DATE — varchar(20)
- REPORT_RES_DATE — varchar(20)
- MSG_SUBJOB_TYPE — int
- STAT_STATUS — int — NOT NULL
- STATUS_TEXT — varchar(200)
- SEND_SPID — varchar(100)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
SDK_VMS_SEND
- MSG_ID — int — 기본 키 — NOT NULL
- USER_ID — varchar(20) — NOT NULL
- MSG_SUBTYPE — int — NOT NULL
- SCHEDULE_TYPE — int — NOT NULL
- DEST_TYPE — int — NOT NULL
- MENT_TYPE — int — NOT NULL
- VOICE_TYPE — int — NOT NULL
- SUBJECT — varchar(50)
- NOW_DATE — varchar(20)
- SEND_DATE — varchar(20) — NOT NULL
- CALLBACK — varchar(20)
- REPLY_TYPE — int — NOT NULL
- REPLY_COUNT — int — NOT NULL
- COUNSELOR_DTMF — int — NOT NULL
- COUNSELOR_NUMBER — varchar(20)
- RELISTEN_COUNT — int — NOT NULL
- KT_OFFICE_CODE — varchar(20)
- CDR_ID — varchar(20)
- SMSPLUS_MSG — varchar(100)
- HEADER_MSG — varchar(150)
- TAIL_MSG — varchar(150)
- TTS_MSG — text
- DEST_COUNT — int — NOT NULL
- DEST_INFO — text — NOT NULL
- ATTACH_FILE — text
- RESERVED1 — varchar(50)
- RESERVED2 — varchar(50)
- RESERVED3 — varchar(50)
- RESERVED4 — varchar(50)
- RESERVED5 — varchar(50)
- RESERVED6 — varchar(50)
- SEND_STATUS — int — NOT NULL
- SEND_COUNT — int — NOT NULL
- SEND_RESULT — int — NOT NULL
- SEND_PROC_TIME — varchar(20)
- STD_ID — bigint
- RESERVED7 — varchar(50)
- RESERVED8 — varchar(50)
- RESERVED9 — varchar(50)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
imsi
- Pkey — int
- SName — varchar(150)
- JubsuDate — varchar(10)
- SZipcode — varchar(7)
- SAddress — varchar(250)
- JubBang — varchar(12)
- Bigo — varchar(255)
- BuName — varchar(50)
- JuminNum — varchar(50)
- NotifyNO — varchar(50)
- DongCode — varchar(9)
- WoonNum — varchar(13)
- BalSongDate — varchar(12)
tblEnviron
- Pkey — varchar(30)
- Userid — varchar(30)
- Passwd — varchar(30)
- UserName — varchar(30)
- MassNo — varchar(30)
- Check_1 — char(1)
- Check_2 — char(1)
- Check_3 — char(1)
- Check_4 — char(1)
- Check_5 — char(1)
tbl_character_send
- jubsudate — varchar(10) — 기본 키 — NOT NULL
- buname — varchar(50) — 기본 키 — NOT NULL
- jubs_seq — varchar(4) — 기본 키 — NOT NULL
- datagubun — varchar(10)
- carnum — varchar(20)
- pername — varchar(50)
- juminbunho — varchar(50)
- expirydate — varchar(50)
- exam_expirygigan — varchar(50)
- exam_gigan — varchar(50)
- zipcode — varchar(10)
- address — varchar(200)
- carname — varchar(50)
- telnum — varchar(50)
- hpnum — varchar(50)
- first_date — varchar(10)
- second_date — varchar(10)
- third_date — varchar(10)
- car_date — varchar(10)
- juso_yn — char(1)
- move_yn — char(1)
- except_yn — char(1)
- bigo — varchar(4000)
- malso_yn — char(1)
- change_yn — char(1)
- change_date — varchar(10)
- STATISTICS_NORECOMPUTE — =
- IGNORE_DUP_KEY — =
- ALLOW_ROW_LOCKS — =
- ALLOW_PAGE_LOCKS — =
tblnotice
- Pkey — int
- Content — varchar(255)
- SupostCheck — char(1)
- BansongMoney — int
- woonsusuMoney — int
- ServerUser — varchar(100)
- ServerPasswd — varchar(100)
- ServerType — char(1)
- ExcelTime — varchar(4)
- UserType — char(1)
- ClientCnt — varchar(4)
- Semuinput — char(1)
- SemuJubsu — char(1)