mrsms
Tables (12)
kkt_msg
- MSGKEY — int(11) — Primary key — NOT NULL
- TYPE — varchar(5)
- RESEND — varchar(5) — NOT NULL
- YELLOWID_KEY — varchar(50) — NOT NULL
- TMPL_CD — varchar(30)
- MSG — varchar(2000)
- SMS_MSG — varchar(90)
- LMS_MSG — varchar(4000)
- IMAGE_URL — varchar(300)
- IMAGE_LINK — varchar(300)
- PHONE — varchar(15)
- CHATBUBBLE_URL1 — varchar(2500)
- CHATBUBBLE_URL2 — varchar(2500)
- CHATBUBBLE_URL3 — varchar(2500)
- CHATBUBBLE_URL4 — varchar(2500)
- CHATBUBBLE_URL5 — varchar(2500)
- FILE_CNT — int(11) — NOT NULL
- FILE_CNT_REAL — int(11) — NOT NULL
- FILE_PATH1 — varchar(128)
- FILE_PATH1_SIZ — int(11)
- CALLBACK — varchar(15)
- ORG_CALLBACK — varchar(20)
- BILL_ID — varchar(20)
- STATUS — varchar(4)
- REQDATE — datetime — NOT NULL
- SENTDATE — datetime
- RSLTDATE — datetime
- REPORTDATE — datetime
- TERMINATEDDATE — datetime
- RSLT — varchar(10)
- RSLT_RESEND — varchar(5)
- ID — varchar(20)
- POST — varchar(20)
- ETC1 — varchar(64)
- ETC2 — varchar(32)
- ETC3 — varchar(32)
- ETC4 — varchar(160)
- ETC5 — varchar(32)
- ETC6 — varchar(32)
- ETC7 — varchar(32)
- ETC8 — varchar(32)
- ETC9 — varchar(32)
- ETC10 — varchar(32)
- Eidx — int(10)
kkt_tmp_list
- tm_num — int(11) — Primary key — NOT NULL
- create_user — varchar(20)
- type — varchar(5)
- YELLOWID_KEY — varchar(50) — NOT NULL
- title — varchar(200)
- msg — varchar(2000)
- msg_real — varchar(2000)
- tmp_dept_code — varchar(40)
- tmp_dept_name — varchar(50)
- tmp_list_num — varchar(20)
- button1 — text
- button2 — text
- button3 — text
- button4 — text
- button5 — text
- TMPL_CD — varchar(30)
mms_msg
- MSGKEY — int(11) — Primary key — NOT NULL
- SUBJECT — varchar(120)
- PHONE — varchar(15)
- CALLBACK — varchar(15)
- ORG_CALLBACK — varchar(20)
- BILL_ID — varchar(20)
- STATUS — varchar(4)
- WRTDATE — datetime
- REQDATE — datetime — NOT NULL
- MSG — varchar(2000)
- FILE_CNT — int(10)
- FILE_CNT_REAL — int(10)
- FILE_PATH1 — varchar(128)
- FILE_PATH1_SIZ — int(10)
- FILE_PATH2 — varchar(128)
- FILE_PATH2_SIZ — int(10)
- FILE_PATH3 — varchar(128)
- FILE_PATH3_SIZ — int(10)
- FILE_PATH4 — varchar(128)
- FILE_PATH4_SIZ — int(10)
- FILE_PATH5 — varchar(128)
- FILE_PATH5_SIZ — int(10)
- EXPIRETIME — varchar(10)
- SENTDATE — datetime
- RSLTDATE — datetime
- REPORTDATE — datetime
- TERMINATEDDATE — datetime
- RSLT — varchar(10)
- REPCNT — int(10)
- type — varchar(5)
- TELCOINFO — varchar(10)
- ID — varchar(20)
- POST — varchar(20)
- ETC1 — varchar(64)
- ETC2 — varchar(32)
- ETC3 — varchar(32)
- ETC4 — varchar(160)
- IMO_KEY — int(11) — NOT NULL
- Eidx — int(10)
sms_msg
- MSGKEY — int(11) — Primary key — NOT NULL
- COMPKEY — varchar(40)
- ID — varchar(20)
- PHONE — varchar(15)
- CALLBACK — varchar(15)
- STATUS — varchar(4)
- WRTDATE — datetime
- REQDATE — datetime — NOT NULL
- RSLTDATE — datetime
- REPORTDATE — datetime
- TERMINATEDDATE — datetime
- EXPIRETIME — varchar(10)
- RSLT — varchar(10)
- MSG — varchar(2000)
- type — varchar(5)
- SENDCNT — int(11) — NOT NULL
- SENTDATE — datetime
- TELCOINFO — varchar(10)
- ETC1 — varchar(64)
- ETC2 — varchar(32)
- ETC3 — varchar(32)
- ETC4 — varchar(160)
- TR_ORG_CALLBACK — varchar(20)
- TR_BILL_ID — varchar(20)
- IMO_KEY — int(11) — NOT NULL
- Eidx — int(10)
smssock_log
- CMID — varchar(1000)
- DOCID — varchar(40)
- GBNCHK — varchar(10)
- SENDDATE — varchar(20)
- ETC1 — varchar(64)
- ETC2 — varchar(32)
- ETC3 — varchar(32)
- ETC4 — varchar(160)
tb_bas_gong
- IL_BUN — int(11) — Primary key — NOT NULL
- IL_TITLE — varchar(255) — 공지제목
- IL_DATE — datetime — 생성날짜
- IL_TXT — varchar(1000) — 공지내용
tb_bas_msggroup
- LRG_GUBN — varchar(3) — 대 구분 항목
- MID_GUBN — varchar(3) — 중 구분 항목
- SML_GUBN — varchar(3) — 소 구분 항목
- MSG_GROUP — varchar(9) — NOT NULL — 메세지 그룹코드
- MSG_NAME — varchar(2000)
- PUBLIC_FLAG — char(1)
- OPEN_FLAG — char(1)
- LIST_GUBN — varchar(2)
- CREATE_USER — varchar(20)
- CREATE_DATE — datetime — 등록일시
tb_bas_msglist
- MSG_GROUP — varchar(9) — 메세지그룹 코드
- MSG_TITLE — varchar(100) — 메세지 제목
- MSG_NAME — varchar(2000)
- MSG_USE — char(1) — 메세지 용도 (0:문자, 1:음성)
- CREATE_USER — varchar(20)
- MSG_PRKEY — int(11) — SMS_MSG,SMS_LOG테이블의 MSG_PRKEY필드
tb_bas_send_stmsg
- msgnum — int(11) — Primary key — NOT NULL
- MSG — varchar(2000)
- ID — varchar(20)
tb_bas_telgroup
- LRG_GUBN — varchar(3) — 대 구분 항목
- MID_GUBN — varchar(3) — 중 구분항목
- SML_GUBN — varchar(3) — 소 구분항목
- TEL_GROUP — varchar(9) — NOT NULL — 주소록그룹 코드
- TEL_NAME — varchar(30) — 주소록 그룹명
- PUBLIC_FLAG — char(1) — 공용/개인 여부 (0:공개, 1:비공개)
- OPEN_FLAG — char(1) — 공개여부 (0:공개, 1:비공개)
- LIST_GUBN — varchar(2)
- CREATE_USER — varchar(20) — NOT NULL
- CREATE_DATE — datetime — 등록일시
tb_bas_tellist
- CREATE_USER — varchar(20)
- TEL_GROUP — varchar(9) — NOT NULL — 주소록 그룹코드
- TEL_PRKEY — int(11) — 키값
- KOR_NAME — varchar(50)
- WIRE_PHONE — varchar(15) — 전화번호
- WIRELESS_PHONE — varchar(15) — 핸드폰번호
- CREATE_DATE — datetime — 등록일시
tb_sms_usecnt_yyyymm
- IDX — int(11) — Primary key — NOT NULL
- YYYY — varchar(4)
- MM — varchar(2)