Kakao i Connect Message::BizMessage(ENG)::BizMessage Agent::Table Specification::MySQL

페이지 이동경로

MySQL Table Specification

The following is table specifications that must be entered to send message from BizMessage Agent.

K_MESSAGE(Request for Sending message)

K_MESSAGE(Request for Sending message)
Column Name Data Type Null Option Comment
MSG_SEQNO(PK) NUMERIC(15,0) NOT NULL Self sequence value, must be unique
- MESSAGE_SEQ.NEXTVAL() value or its own unique number
KKO_MSG VARCHAR(4000) NULL Message to be sent
TITLE VARCHAR(255) NULL Title of LMS alternate message
- LMS only
PHONE_MSG VARCHAR(4000) NULL Body of alternative message
MSG_TYPE VARCHAR(10) NOT NULL Message type
KX: Sending only Alim Talk
KS: Sending Alim Talk + SMS alternate message
KM: Sending Alim Talk + MMS alternate message
XS: Sending SMS
XM: Sending MMS
MOBILE_NO VARCHAR(50) NOT NULL Phone number to receive messages
SENDER_NO VARCHAR(50) NOT NULL Sender number
- Phone number to send actual push, SMS, MMS
SEND_TYPE VARCHAR(10) NOT NULL Message type
S: real time sending
M: batch sending (2 or more messages)
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- If there is no value, the message is sent immediately
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
KKO_TEMPLATE_CD VARCHAR(50) NULL Code of Alim Talk template
- Applicable only when using AlimTalk, not for SMS and MMS
- Code can be checked in Admin site Template management menu
KKO_TEMPLATE_TYPE VARCHAR(2) NULL Template type of Alim Talk
- If NULL is entered, the server recognize as AT
AT: General text template type
AI: Image template type
KKO_APP_USER_ID VARCHAR(30) NULL App user ID
- Enter one of MOBILE_NO or KKO_APP_USER_ID (required)
- If MOBILE_NO and KKO_APP_USER_ID information are requested at the same time, only MOBILE_NO is sent.
MMS_IMG1 VARCHAR(255) NULL MMS image path 1
MMS_IMG2 VARCHAR(255) NULL MMS image path 2
MMS_IMG3 VARCHAR(255) NULL MMS image path 3
KKO_BTN_LINK1 VARCHAR(500) NULL Button 1 information
- Refer to Button Information Data Sample
KKO_BTN_LINK2 VARCHAR(500) NULL Button 2 information
- Refer to Button Information Data Sample
KKO_BTN_LINK3 VARCHAR(500) NULL Button 3 information
- Refer to Button Information Data Sample
KKO_BTN_LINK4 VARCHAR(500) NULL Button 4 information
- Refer to Button Information Data Sample
KKO_BTN_LINK5 VARCHAR(500) NULL Button 5 information
- Refer to Button Information Data Sample
SEND_CD VARCHAR(1) NOT NULL Whether to send
- Changed in the order of N > H > Y according to the system procedure
N(default): sending reception
H: sending
Y: sent
SEND_DATE DATETIME NULL Sent date
- Format: YYYY-MM-DD HH:MM:SS
RESEND_CD VARCHAR(1) NULL Reservation field for error retransmission when transmitting to server (not available for customer company)
- Default: N
SERVER_MMS_IMG1 VARCHAR(100) NULL Image server path1 (not available for customer company)
- sent date from server + image path by AGENT ID
SERVER_MMS_IMG2 VARCHAR(100) NULL Image server path2 (not available for customer company)
- sent date from server + image path by AGENT ID
SERVER_MMS_IMG3 VARCHAR(100) NULL Image server path3 (not available for customer company)
- sent date from server + image path by AGENT ID
IMG_ATTACH_CD VARCHAR(1) NOT NULL Whether to attach image
Y: Image attached
M: Request for attaching image
N: No image
IMG_SEND_DATE DATETIME NULL Image sent date (not available for customer company)
FILE_NAME VARCHAR(50) NULL File name to be sent
- Format: {Batch File Name} + {Sending AGENT ID}
RESULT_CD1 VARCHAR(10) NULL Result code of Alim Talk sent
OK: success
etc: error
RESULT_CD2 VARCHAR(10) NULL SMS/LMS/MMS sending result code
OK: success
etc: error
TELECOM_CD VARCHAR(3) NULL Message carrier code (not available for customer company)
SERVER_SEND_DATE1 DATETIME NULL Server-based sending request time 1 (not available for customer company)
SERVER_SEND_DATE2 DATETIME NULL Server-based sending request time 2 (not available for customer company)
RESULT_DATE1 DATETIME NULL Server-based push sent time (not available for customer company)
RESULT_DATE2 DATETIME NULL Server-based alternate message sent time (not available for customer company)
RESULT_REG_DATE DATETIME NULL Date the result was received (not available for customer company)
TAX_CD1 VARCHAR(50) NULL Settlement related department code 1
TAX_CD2 VARCHAR(50) NULL Settlement related department code 2
NAT_CD VARCHAR(3) NULL Country calling code
- Default: 82
EMPHASIZE_TITLE VARCHAR(255) NULL Title to be emphasized when using Emphasis type template
KKO_QUICK_REPLY1 VARCHAR(500) NULL Information of Quick Reply1
- Refer to Button Information Data Sample
KKO_QUICK_REPLY2 VARCHAR(500) NULL Information of Quick Reply2
- Refer to Button Information Data Sample
KKO_QUICK_REPLY3 VARCHAR(500) NULL Information of Quick Reply3
- Refer to Button Information Data Sample
KKO_QUICK_REPLY4 VARCHAR(500) NULL Information of Quick Reply4
- Refer to Button Information Data Sample
KKO_QUICK_REPLY5 VARCHAR(500) NULL Information of Quick Reply5
- Refer to Button Information Data Sample
KKO_QUICK_REPLY6 VARCHAR(500) NULL Information of Quick Reply6
- Refer to Button Information Data Sample
KKO_QUICK_REPLY7 VARCHAR(500) NULL Information of Quick Reply7
- Refer to Button Information Data Sample
KKO_QUICK_REPLY8 VARCHAR(500) NULL Information of Quick Reply8
- Refer to Button Information Data Sample
KKO_QUICK_REPLY9 VARCHAR(500) NULL Information of Quick Reply9
- Refer to Button Information Data Sample
KKO_QUICK_REPLY10 VARCHAR(500) NULL Information of Quick Reply10
- Refer to Button Information Data Sample
HEADER VARCHAR(50) NULL Title to appear at the top of the message when using item list type template
ITEM_HIGHLIGHT VARCHAR(100) NULL Item to be emphasized when using item list type template
- Refer to [Item List Type Template] Highlighted Item Data Sample
ITEM VARCHAR(4000) NULL Item list and Item summary information when using item list type template
- Refer to [Item List Type Template] Item List and Item Summary Information Sample
REG_DATE DATETIME NOT NULL Date of registration
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
UPDATE_BY VARCHAR(20) NOT NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_K_MESSAGE : RESERVE_DATE
I2_K_MESSAGE : SEND_DATE
I3_K_MESSAGE : SEND_CD, IMG_ATTACH_CD
I4_K_MESSAGE : REG_DATE

K_MESSAGE_LOG(Result of Message Sent)

K_MESSAGE_LOG(Result of Message Sent)
Column Name Data Type Null Option Comment
MSG_SEQNO(PK) NUMERIC(15,0) NOT NULL Self sequence value, must be unique
- MESSAGE_SEQ.NEXTVAL() value or its own unique number
KKO_MSG VARCHAR(4000) NULL Message to be sent
TITLE VARCHAR(255) NULL Title of LMS alternate message
- LMS only
PHONE_MSG VARCHAR(4000) NULL Body of alternate message
MSG_TYPE VARCHAR(10) NOT NULL Message type
KX: Sending only Alim Talk
KS: Sending Alim Talk + SMS alternate message
KM: Sending Alim Talk + MMS alternate message
XS: Sending SMS
XM: Sending MMS
MOBILE_NO VARCHAR(50) NOT NULL Phone number to receive messages
SENDER_NO VARCHAR(50) NOT NULL Sender number
- Phone number to send actual push, SMS, MMS
SEND_TYPE VARCHAR(10) NOT NULL Message type
S: single item sending
M: batch sending(2 or more messages)
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- If there is no value, the message is sent immediately
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
KKO_TEMPLATE_CD VARCHAR(50) NULL Code of Alim Talk template
- Applicable only when using AlimTalk, not for SMS and MMS
KKO_TEMPLATE_TYPE VARCHAR(2) NULL Template type of Alim Talk
- If NULL is entered, the server recognize as AT
AT: General text template type
AI: Image template type
KKO_APP_USER_ID VARCHAR(30) NULL App user ID
- Enter one of MOBILE_NO or KKO_APP_USER_ID (required)
- If MOBILE_NO and KKO_APP_USER_ID information are requested at the same time, only MOBILE_NO is sent.
MMS_IMG1 VARCHAR(255) NULL MMS image path 1
MMS_IMG2 VARCHAR(255) NULL MMS image path 2
MMS_IMG3 VARCHAR(255) NULL MMS image path 3
KKO_BTN_LINK1 VARCHAR(500) NULL Button 1 information
- Refer to Button Information Data Sample
KKO_BTN_LINK2 VARCHAR(500) NULL Button 2 information
- Refer to Button Information Data Sample
KKO_BTN_LINK3 VARCHAR(500) NULL Button 3 information
- Refer to Button Information Data Sample
KKO_BTN_LINK4 VARCHAR(500) NULL Button 4 information
- Refer to Button Information Data Sample
KKO_BTN_LINK5 VARCHAR(500) NULL Button 5 information
- Refer to Button Information Data Sample
SEND_CD VARCHAR(1) NOT NULL Whether to send
- Changed in the order of N > H > Y according to the system procedure
N(default): sending reception
H: sending
Y: sent
SEND_DATE DATETIME NULL Sent date
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
RESEND_CD VARCHAR(1) NULL Reservation field for error retransmission when transmitting to server (not available for customer company)
- Default: N
SERVER_MMS_IMG1 VARCHAR(100) NULL Image server path1 (not available for customer company)
- sent date from server + image path by AGENT ID
SERVER_MMS_IMG2 VARCHAR(100) NULL Image server path2 (not available for customer company)
- sent date from server + image path by AGENT ID
SERVER_MMS_IMG3 VARCHAR(100) NULL Image server path3 (not available for customer company)
- sent date from server + image path by AGENT ID
IMG_ATTACH_CD VARCHAR(1) NOT NULL Whether to attach an image
Y: attach image as real-time sending
M: attach image as batch sending
N(default): no image attachment
IMG_SEND_DATE DATETIME NULL Image sent date (not available for customer company)
FILE_NAME VARCHAR(50) NULL File name to be sent
- Format: {Batch File Name} + {Sending AGENT ID}
RESULT_CD1 VARCHAR(10) NULL Result code of Kakao sent
OK: success
etc: error
RESULT_CD2 VARCHAR(10) NULL SMS/LMS/MMS sending result code
OK: success
etc: error
TELECOM_CD VARCHAR(3) NULL message carrier code
- Unavailable for agent use only
SERVER_SEND_DATE1 DATETIME NULL Server-based sending request time 1
- Unavailable for agent use only
SERVER_SEND_DATE2 DATETIME NULL Server-based sending request time 2
- Unavailable for agent use only
RESULT_DATE1 DATETIME NULL Server-based push sent time
- Unavailable for agent use only
RESULT_DATE2 DATETIME NULL Server-based alternate message sent time
- Unavailable for agent use only
RESULT_REG_DATE DATETIME NULL Date the result was received
- Unavailable for agent use only
TAX_CD1 VARCHAR(50) NULL Settlement related department code 1
TAX_CD2 VARCHAR(50) NULL Settlement related department code 2
NAT_CD VARCHAR(3) NULL Country calling code
- Default: 82
EMPHASIZE_TITLE VARCHAR(255) NULL Title to be emphasized when using Emphasis type template
KKO_QUICK_REPLY1 VARCHAR(500) NULL Information of Quick Reply1
- Refer to Button Information Data Sample
KKO_QUICK_REPLY2 VARCHAR(500) NULL Information of Quick Reply2
- Refer to Button Information Data Sample
KKO_QUICK_REPLY3 VARCHAR(500) NULL Information of Quick Reply3
- Refer to Button Information Data Sample
KKO_QUICK_REPLY4 VARCHAR(500) NULL Information of Quick Reply4
- Refer to Button Information Data Sample
KKO_QUICK_REPLY5 VARCHAR(500) NULL Information of Quick Reply5
- Refer to Button Information Data Sample
KKO_QUICK_REPLY6 VARCHAR(500) NULL Information of Quick Reply6
- Refer to Button Information Data Sample
KKO_QUICK_REPLY7 VARCHAR(500) NULL Information of Quick Reply7
- Refer to Button Information Data Sample
KKO_QUICK_REPLY8 VARCHAR(500) NULL Information of Quick Reply8
- Refer to Button Information Data Sample
KKO_QUICK_REPLY9 VARCHAR(500) NULL Information of Quick Reply9
- Refer to Button Information Data Sample
KKO_QUICK_REPLY10 VARCHAR(500) NULL Information of Quick Reply10
- Refer to Button Information Data Sample
HEADER VARCHAR(50) NULL Title to appear at the top of the message when using item list type template
ITEM_HIGHLIGHT VARCHAR(100) NULL Item to be emphasized when using item list type template
- Refer to [Item List Type Template] Highlighted Item Data Sample
ITEM VARCHAR(4000) NULL Item list and Item summary information when using item list type template
- Refer to [Item List Type Template] Item List and Item Summary Information Sample
REG_DATE DATETIME NOT NULL Date of registration
- Default: NOW()
UPDATE_BY VARCHAR(20) NOT NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_K_MESSAGE_LOG : RESERVE_DATE
I2_K_MESSAGE_LOG : SEND_DATE
I3_K_MESSAGE_LOG : SEND_CD, IMG_ATTACH_CD
I4_K_MESSAGE_LOG : REG_DATE

K_AGENT (Manage Agent Redundancy)

K_AGENT (Manage Agent Redundancy)
Column name Date type Null Option Description
AGENT_ID(PK) VARCHAR(20) NOT NULL Agent sharing ID
CURRENT_STATUS VARCHAR(1) NOT NULL Status of agent
M: Master
S: Slave
L_CHECK_TIME DATETIME NULL Health check time
INDEX PK : AGENT_ID

K_F_AGENT (Request for Sending Friend Talk)

K_F_AGENT (Request for Sending Friend Talk)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMERIC(15,0) NOT NULL Self sequence value, must be unique
- MESSAGE_SEQ.NEXTVAL() value or its own unique number
KKO_MSG VARCHAR(4000) NULL Message to be sent
MOBILE_NO VARCHAR(50) NOT NULL Phone number to receive messages
- Used when you want to designate a specific number other than the default
SENDER_NO VARCHAR(50) NOT NULL Sender number
- Phone number to send actual push, SMS, MMS
TITLE VARCHAR(255) NULL Title of message when using LMS or MMS alternate message
PHONE_MSG VARCHAR(4000) NULL Alternate message
MSG_TYPE VARCHAR(10) NOT NULL Message type
FX(default): Friend Talk only
FS: Friend Talk + SMS alternate message
FM: Friend Talk + LMS alternate message
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- If there is no value, the message is sent immediately
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
KKO_IMG_PATH VARCHAR(255) NULL Image path to attach to Friend Talk
KKO_IMG_WIDE_CD VARCHAR(1) NOT NULL Whether the image to be attached to Friend talk is wide
Y: wide image
N(default): general image
KKO_IMG_LINK_URL VARCHAR(1000) NULL Link URL to be connected when clicking on the image attached to Friend Talk
KKO_IMG_URL VARCHAR2(1000) NULL Image URL uploaded to Kakao is automatically entered
- If you reuse the uploaded image URL, you can also manually enter it
KKO_APP_USER_ID VARCHAR2(30) NULL App user ID
- Enter one of MOBILE_NO or KKO_APP_USER_ID (required)
- If MOBILE_NO and KKO_APP_USER_ID information are requested at the same time, only MOBILE_NO is sent.
KKO_USER_KEY VARCHAR2(30) NULL User identity key
- KakaoTalk channel user identity key issued by KakaoTalk channel bot
KKO_AD_FLAG VARCHAR2(1) NULL Whether the required informations of advertisement message have been exposed
Y(default): exposed
N: not exposed
KKO_BTN_LINK1 VARCHAR(500) NULL Button 1 information
- Refer to Button Information Data Sample
KKO_BTN_LINK2 VARCHAR(500) NULL Button 2 information
- Refer to Button Information Data Sample
KKO_BTN_LINK3 VARCHAR(500) NULL Button 3 information
- Refer to Button Information Data Sample
KKO_BTN_LINK4 VARCHAR(500) NULL Button 4 information
- Refer to Button Information Data Sample
KKO_BTN_LINK5 VARCHAR(500) NULL Button 5 information
- Refer to Button Information Data Sample
SEND_CD VARCHAR(1) NOT NULL Whether to send
- Default: N
SEND_DATE DATETIME NULL Sent date
RESEND_CD VARCHAR(1) NULL Reservation field for error retransmission when transmitting to server (not available for customer company)
- Default: N
SERVER_KKO_IMG VARCHAR(255) NULL Image path saved in KakaoTalk server
IMG_ATTACH_CD VARCHAR(1) NOT NULL Whether to attach an image
N(default): No image
Y: attach an image with URL
M: have an image to upload to server
IMG_SEND_DATE DATETIME NULL Image sent date (not available for customer company)
FILE_NAME VARCHAR(50) NULL File name to be sent
- Format: {Batch File Name} + {Sending AGENT ID}
RESULT_CD1 VARCHAR(20) NULL Result code of Friend Talk sent
OK: success
etc: error
RESULT_CD2 VARCHAR(20) NULL Result code of Message sent
OK: success
etc: error
TELECOM_CD VARCHAR(20) NULL Message carrier code
SERVER_SEND_DATE1 DATETIME NULL Date 1 of request to send Friend Talk(server-based)
- Unavailable for agent use only
SERVER_SEND_DATE2 DATETIME NULL Date 2 of request to send Friend Talk(server-based)
- Unavailable for agent use only
RESULT_DATE1 DATETIME NULL Date the result of sending Friend Talk was received (server-based)
- Unavailable for agent use only
RESULT_DATE2 DATETIME NULL Date the result of message was received (server-based)
- Unavailable for agent use only
RESULT_REG_DATE DATETIME NULL Date the result was received
- Unavailable for agent use only
TAX_CD1 VARCHAR(50) NULL Settlement related department code 1
TAX_CD2 VARCHAR(50) NULL Settlement related department code 2
REG_DATE DATETIME NOT NULL Date of registration
- Default: NOW()
UPDATE_BY VARCHAR(20) NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_K_F_MESSAGE : RESERVE_DATE
I2_K_F_MESSAGE : SEND_DATE
I3_K_F_MESSAGE : SEND_CD, IMG_ATTACH_CD
I4_K_F_MESSAGE : REG_DATE

K_F_MESSAGE_LOG (Result of Friend Talk Sent)

K_F_MESSAGE_LOG (Result of Friend Talk Sent)
Column Name Data Type Null Option Comment
MSG_SEQNO(PK) NUMERIC(15,0) NOT NULL Self sequence value, must be unique
- MESSAGE_SEQ.NEXTVAL() value or its own unique number
KKO_MSG VARCHAR(4000) NULL Message to be sent
MOBILE_NO VARCHAR(50) NOT NULL Sender number
- Used when you want to designate a specific number other than the default
SENDER_NO VARCHAR(50) NOT NULL Phone number to receive messages
TITLE VARCHAR(255) NULL Title of message when using LMS or MMS alternate message
PHONE_MSG VARCHAR(4000) NULL Body of alternate message
MSG_TYPE VARCHAR(10) NOT NULL Message type
FX: Friend Talk only
FS: Friend Talk + SMS alternate message
FM: Friend Talk + LMS alternate message
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- If there is no value, the message is sent immediately
KKO_IMG_PATH VARCHAR(255) NULL Image path to attach to Friend Talk
KKO_IMG_WIDE_CD VARCHAR(1) NOT NULL Whether the image to be attached to Friend talk is wide
Y: wide image
N(default): general image
KKO_IMG_LINK_URL VARCHAR(1000) NULL Link URL to be connected when clicking on the image attached to Friend Talk
KKO_IMG_URL VARCHAR2(1000) NULL Image URL uploaded to Kakao is automatically entered
- If you have the uploaded image URL, enter it manually
KKO_APP_USER_ID VARCHAR2(30) NULL App user ID
- Enter one of MOBILE_NO or KKO_APP_USER_ID (required)
- If MOBILE_NO and KKO_APP_USER_ID information are requested at the same time, only MOBILE_NO is sent.
KKO_USER_KEY VARCHAR2(30) NULL User identity key
- KakaoTalk channel user identity key issued by KakaoTalk channel bot
KKO_AD_FLAG VARCHAR2(1) NULL Whether the required informations of advertisement message have been exposed
Y(default): exposed
N: not exposed
KKO_BTN_LINK1 VARCHAR(500) NULL Button 1 information
- Refer to Button Information Data Sample
KKO_BTN_LINK2 VARCHAR(500) NULL Button 2 information
- Refer to Button Information Data Sample
KKO_BTN_LINK3 VARCHAR(500) NULL Button 3 information
- Refer to Button Information Data Sample
KKO_BTN_LINK4 VARCHAR(500) NULL Button 4 information
- Refer to Button Information Data Sample
KKO_BTN_LINK5 VARCHAR(500) NULL Button 5 information
- Refer to Button Information Data Sample
SEND_CD VARCHAR(1) NOT NULL Whether to send
SEND_DATE DATETIME NULL Sent date
RESEND_CD VARCHAR(1) NULL Reservation field for error retransmission when transmitting to server (not available for customer company)
- Default: N
SERVER_KKO_IMG VARCHAR(255) NULL Server path of KakaoTalk image
IMG_ATTACH_CD VARCHAR(1) NOT NULL Whether to attach an image
N(default): No image
Y: attach an image with URL
M: have an image to upload to server
IMG_SEND_DATE DATETIME NULL Image sent date (not available for customer company)
FILE_NAME VARCHAR(50) NULL File name to be sent
- Format: {Batch File Name} + {Sending AGENT ID}
RESULT_CD1 VARCHAR(20) NULL Result code of Friend Talk sent
OK: success
etc: error
RESULT_CD2 VARCHAR(20) NULL Result code of message sent
OK: success
etc: error
TELECOM_CD VARCHAR(20) NULL Message carrier code
SERVER_SEND_DATE1 DATETIME NULL Date 1 of request to send Friend Talk(server-based)
- Unavailable for agent use only
SERVER_SEND_DATE2 DATETIME NULL Date 2 of request to send Friend Talk(server-based)
- Unavailable for agent use only
RESULT_DATE1 DATETIME NULL Date the result of sending Friend Talk was received (server-based)
- Unavailable for agent use only
RESULT_DATE2 DATETIME NULL Date the result of message was received (server-based)
- Unavailable for agent use only
RESULT_REG_DATE DATETIME NULL Date the result was received
- Unavailable for agent use only
TAX_CD1 VARCHAR(50) NULL Settlement related department code 1
TAX_CD2 VARCHAR(50) NULL Settlement related department code 2
REG_DATE DATETIME NOT NULL Date of registration
UPDATE_BY VARCHAR(20) NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_K_F_MESSAGE_LOG : RESERVE_DATE
I2_K_F_MESSAGE_LOG : SEND_DATE
I3_K_F_MESSAGE_LOG : SEND_CD, IMG_ATTACH_CD
I4_K_F_MESSAGE_LOG : REG_DATE

K_BLACKLIST (Manage Black List)

K_BLACKLIST (Manage Black List)
Column Name Data Type Null Option Comment
MOBILE_NO(PK) VARCHAR(50) NOT NULL Mobile phone number
USE_YN VARCHAR(1) NOT NULL Whether to use black-list
Y(default): use black-list
N: do not use black-list
REG_DATE DATETIME NOT NULL Date of registration
- Default: NOW()
INDEX PK : MOBILE_NO
I1_K_BLACKLIST : USE_YN

XMS_MESSAGE_LOG (Result of XMS Sent)

XMS_MESSAGE_LOG (Result of XMS Sent)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMBER(15,0) NOT NULL Self sequence value, must be unique
TITLE VARCHAR(255) NULL Title of LMS or MMS message
PHONE_MSG VARCHAR(4000) NULL Message to be sent
MSG_TYPE VARCHAR(10) NOT NULL Message type
SM: sending message
LM: sending LMS
MM: sending MMS
MOBILE_NO VARCHAR(50) NOT NULL Phone number to receive messages
SENDER_NO VARCHAR(50) NOT NULL Sender number
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- Format: YYYY-MM-DD HH:MM:SS
MMS_IMG1 VARCHAR(255) NULL MMS image path 1
MMS_IMG2 VARCHAR(255) NULL MMS image path 2
MMS_IMG3 VARCHAR(255) NULL MMS image path 3
SEND_CD VARCHAR(1) NOT NULL Whether to send
- Changed in the order of N > H > Y according to the system procedure
N(default) : sending reception
H: sending
Y: sent
SEND_DATE DATETIME NULL Sent date(using engine)
RESEND_CD VARCHAR(1) NOT NULL Retransmission code when server error occurs(using engine)
- Default: N
SERVER_MMS_IMG1 VARCHAR(100) NULL Image server path 1(using engine)
SERVER_MMS_IMG2 VARCHAR(100) NULL Image server path 2(using engine)
SERVER_MMS_IMG3 VARCHAR(100) NULL Image server path 3(using engine)
IMG_ATTACH_CD VARCHAR(1) NOT NULL Whether to attach the image
- N(default): no image
IMG_SEND_DATE DATETIME NULL Image sent date(using engine)
FILE_NAME VARCHAR(50) NULL File name sent(using engine)
RESULT_CD VARCHAR(20) NULL Result code
TELECOM_CD VARCHAR(20) NULL message carrier code
SERVER_SEND_DATE DATETIME NULL Date of request for sending (server-based)
RESULT_DATE DATETIME NULL Date that the push result was received
RESULT_REG_DATE DATETIME NULL Date the result was successfully received
TAX_CD1 VARCHAR(50) NULL Department code1
TAX_CD2 VARCHAR(50) NULL Department code2
NAT_CD VARCHAR(3) NULL Country calling code
- Default: 82
REG_DATE DATETIME NULL Creation date
UPDATE_BY VARCHAR(20) NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_XMS_MESSAGE : RESERVE_DATE
I2_XMS_MESSAGE : SEND_DATE
I3_XMS_MESSAGE : SEND_CD, IMG_ATTACH_CD
I4_XMS_MESSAGE : REG_DATE

RCS_MESSAGE(Send RCS)

RCS_MESSAGE(Send RCS)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMBER(15,0) NOT NULL Self sequence value, must be unique
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- Format: YYYY-MM-DD HH:MM:SS
SEND_DATE DATETIME NULL Sent date
SEND_CD VARCHAR(1) NOT NULL Whether to send
N(default) : sending reception
RESEND_CD VARCHAR(1) NOT NULL Retransmission code when server error occurs(using engine)
- Default: N
RESULT_CD1 VARCHAR(20) NULL Code of sending result(result code of push sent)
RESULT_CD2 VARCHAR(20) NULL Code of sending result(result code of message sent)
SERVER_SEND_DATE1 DATETIME NULL Date of request for sending 1
SERVER_SEND_DATE2 DATETIME NULL Date of request for sending 2
RESULT_DATE1 DATETIME NULL Date received result 1
RESULT_DATE2 DATETIME NULL Date received result 2
PHONE_NO VARCHAR(50) NOT NULL Phone number to receive messages
CALLBACK VARCHAR(50) NOT NULL Callback number
AGENCY_ID VARCHAR(100) NOT NULL RCS agency ID
MESSAGE_BASE_ID VARCHAR(100) NOT NULL RCS template code ID
MESSAGE_GROUP_ID VARCHAR(100) NULL Message group ID
SERVICE_TYPE VARCHAR(10) NOT NULL Service type
RCSSMS: SMS type
RCSLMS: LMS type
RCSMMS: MMS type
RCSTMPL: RCS template type
HEADER VARCHAR(1) NOT NULL Whether to advertise
0: Informational Advertisement
1: Advertisement
FOOTER VARCHAR(20) NULL 080 call rejection phone number(HEADER : 1)
- Fill in only for advertisements
COPY_ALLOWED VARCHAR(4) NOT NULL Whether to allow to copy message
true(default): copy allowed
false: not allowed
BODY VARCHAR(4000) NULL Body(JSON)
BUTTONS VARCHAR(4000) NULL Button(JSON)
MMS_TITLE1 VARCHAR(100) NULL RCSMMS title1
MMS_MSG1 VARCHAR(4000) NULL RCSMMS message1
MMS_IMG_URL1 VARCHAR(300) NULL RCSMMS image URL 1
MMS_TITLE2 VARCHAR(100) NULL RCSMMS title2
MMS_MSG2 VARCHAR(4000) NULL RCSMMS message2
MMS_IMG_URL2 VARCHAR(300) NULL RCSMMS image URL 2
MMS_TITLE3 VARCHAR(100) NULL RCSMMS title3
MMS_MSG3 VARCHAR(4000) NULL RCSMMS message3
MMS_IMG_URL3 VARCHAR(300) NULL RCSMMS image URL 3
MMS_TITLE4 VARCHAR(100) NULL RCSMMS title4
MMS_MSG4 VARCHAR(4000) NULL RCSMMS message4
MMS_IMG_URL4 VARCHAR(300) NULL RCSMMS image URL 4
MMS_TITLE5 VARCHAR(100) NULL RCSMMS title5
MMS_MSG5 VARCHAR(4000) NULL RCSMMS message5
MMS_IMG_URL5 VARCHAR(300) NULL RCSMMS image URL 5
MMS_TITLE6 VARCHAR(100) NULL RCSMMS title6
MMS_MSG6 VARCHAR(4000) NULL RCSMMS message6
MMS_IMG_URL6 VARCHAR(300) NULL RCSMMS image URL 6
FALLBACK_YN BOOLEAN NOT NULL Whether to send alternative message
true: to send
false(default): not to send
FALLBACK_TYPE VARCHAR(10) NULL Fallback type
SMS: SMS type
LMS: LMS type
FALLBACK_CALLBACK VARCHAR(50) NULL Callback number of alternate sending
FALLBACK_SUBJECT VARCHAR(120) NULL Title of alternate message
FALLBACK_MESSAGE VARCHAR(2000) NULL Alternate sending message
TAX_CD1 VARCHAR(50) NULL Department code 1
TAX_CD2 VARCHAR(50) NULL Department code 2
REQ_DATE DATETIME NULL Sent date
RES_DATE DATETIME NULL Date received result
ERROR_MESSAGE1 VARCHAR(500) NULL Detailed message of RCS error
ERROR_MESSAGE2 VARCHAR(500) NULL Detailed message of alternate sending error
MNO_INFO1 VARCHAR(10) NULL Mobile carrier information of RCS recipient
MNO_INFO2 VARCHAR(10) NULL Mobile carrier information of alternate message recipient
UPDATE_BY VARCHAR(20) NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_RCS_MESSAGE : RESERVE_DATE
I2_RCS_MESSAGE : SEND_DATE
I3_RCS_MESSAGE : SERVICE_TYPE

RCS_MESSAGE_LOG(Result of RCS Sent)

RCS_MESSAGE_LOG(Result of RCS Sent)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMBER(15,0) NOT NULL Self sequence value, must be unique
RESERVE_DATE DATETIME NOT NULL Scheduled sending time
- Format: YYYY-MM-DD HH:MM:SS
SEND_DATE DATETIME NULL Sent date
SEND_CD VARCHAR(1) NOT NULL Whether to send
N(default) : sending reception
RESEND_CD VARCHAR(1) NOT NULL Retransmission code when server error occurs(using engine)
- Default: N
RESULT_CD1 VARCHAR(20) NULL Code of sending result(result code of push sent)
RESULT_CD2 VARCHAR(20) NULL Code of sending result(result code of message sent)
SERVER_SEND_DATE1 DATETIME NULL Date of request for sending 1
SERVER_SEND_DATE2 DATETIME NULL Date of request for sending 2
RESULT_DATE1 DATETIME NULL Date received result 1
RESULT_DATE2 DATETIME NULL Date received result 2
PHONE_NO VARCHAR(50) NOT NULL Phone number to receive messages
CALLBACK VARCHAR(50) NOT NULL Callback number
AGENCY_ID VARCHAR(100) NOT NULL RCS agency ID
MESSAGE_BASE_ID VARCHAR(100) NOT NULL RCS template code ID
MESSAGE_GROUP_ID VARCHAR(100) NULL Message group ID
SERVICE_TYPE VARCHAR(10) NOT NULL Service type
RCSSMS: SMS type
RCSLMS: LMS type
RCSMMS: MMS type
RCSTMPL: RCS template type
HEADER VARCHAR(1) NOT NULL Whether to advertise
0 : Informational Advertisement
1 : Advertisement
FOOTER VARCHAR(20) NULL 080 call rejection phone number(HEADER : 1)
- Fill in only for advertisements
COPY_ALLOWED VARCHAR(4) NOT NULL Whether to allow to copy message
true(default): copy allowed
false: not allowed
BODY VARCHAR(4000) NULL Body(JSON)
BUTTONS VARCHAR(4000) NULL Button(JSON)
MMS_TITLE1 VARCHAR(100) NULL RCSMMS title1
MMS_MSG1 VARCHAR(4000) NULL RCSMMS message1
MMS_IMG_URL1 VARCHAR(300) NULL RCSMMS image URL 1
MMS_TITLE2 VARCHAR(100) NULL RCSMMS title2
MMS_MSG2 VARCHAR(4000) NULL RCSMMS message2
MMS_IMG_URL2 VARCHAR(300) NULL RCSMMS image URL 2
MMS_TITLE3 VARCHAR(100) NULL RCSMMS title3
MMS_MSG3 VARCHAR(4000) NULL RCSMMS message3
MMS_IMG_URL3 VARCHAR(300) NULL RCSMMS image URL 3
MMS_TITLE4 VARCHAR(100) NULL RCSMMS title4
MMS_MSG4 VARCHAR(4000) NULL RCSMMS message4
MMS_IMG_URL4 VARCHAR(300) NULL RCSMMS image URL 4
MMS_TITLE5 VARCHAR(100) NULL RCSMMS title5
MMS_MSG5 VARCHAR(4000) NULL RCSMMS message5
MMS_IMG_URL5 VARCHAR(300) NULL RCSMMS image URL 5
MMS_TITLE6 VARCHAR(100) NULL RCSMMS title6
MMS_MSG6 VARCHAR(4000) NULL RCSMMS message6
MMS_IMG_URL6 VARCHAR(300) NULL RCSMMS image URL 6
FALLBACK_YN BOOLEAN NOT NULL Whether to send alternative message
true : to send
false (default): not to send
FALLBACK_TYPE VARCHAR(10) NULL Fallback type
SMS: SMS type
LMS: LMS type
FALLBACK_CALLBACK VARCHAR(50) NULL Callback number of alternate sending
FALLBACK_SUBJECT VARCHAR(120) NULL Title of alternate message
FALLBACK_MESSAGE VARCHAR(2000) NULL Alternate sending message
TAX_CD1 VARCHAR(50) NULL Department code 1
TAX_CD2 VARCHAR(50) NULL Department code 2
REQ_DATE DATETIME NULL Sent date
RES_DATE DATETIME NULL Date received result
ERROR_MESSAGE1 VARCHAR(500) NULL Detailed message of RCS error
ERROR_MESSAGE2 VARCHAR(500) NULL Detailed message of alternate sending error
MNO_INFO1 VARCHAR(10) NULL Mobile carrier information of RCS recipient
MNO_INFO2 VARCHAR(10) NULL Mobile carrier information of alternate message recipient
UPDATE_BY VARCHAR(20) NULL Who updated
UPDATE_DATE DATETIME NULL Date of update
INDEX PK : MSG_SEQNO
I1_RCS_MESSAGE_LOG : RESERVE_DATE I2_RCS_MESSAGE_LOG : SEND_DATE I3_RCS_MESSAGE_LOG : SERVICE_TYPE

RCS_CONTENTS(RCS Image)

RCS_CONTENTS(RCS Image)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMBER(15,0) NOT NULL Self sequence value, must be unique
REG_DATE DATETIME NOT NULL Registration date
IMG_STATUS VARCHAR(10) NOT NULL image processing status
0 : Registration
1: Uploading
2: Uploaded
IMG_RESULT_CODE VARCHAR(100) Image processing result
IMG_RESULT_MESSAGE VARCHAR(100) Image processing result detailed message
IMG_FILE_PATH VARCHAR(100) NOT NULL Image save path
IMG_MIME_TYPE VARCHAR(100) NOT NULL Image type
IMG_DESCRIPTION VARCHAR(200) Image description
IMG_UPLOAD_URL VARCHAR(100) Image upload URL(Automatic input when upload is complete)
IMG_EXPIRY_DATE VARCHAR(100) Image expiry time
REQ_DATE DATETIME image sending date
RES_DATE DATETIME Image Result Receipt date
ETC1 VARCHAR(200) User Field 1
ETC2 VARCHAR(200) User Field 2
ETC3 VARCHAR(200) User Field 3
INDEX PK : MSG_SEQNO
I1_RCS_CONTENTS : REG_DATE
NAVER_MESSAGE(Send Naver TalkTalk)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMBER(15,0) NOT NULL Self sequence value, must be unique.
SEND_CD VARCHAR(1) NOT NULL whether to send
- Default: N
RESEND_CD VARCHAR(1) NOT NULL Retransmission code in case of server transmission error (using engine)
- Default: N
MESSAGE_TYPE VARCHAR(10) NOT NULL Naver Talk Talk service type
NT_FM: NAVER TALK TALK Sends the entire text including variables attached.
NT_TM: Only Naver Talk Talk variables are sent as attachments.
TEMPLATE_CODE VARCHAR(100) NOT NULL Naver Talk Talk template code
TEMPLATE_PARAMS TEXT   Attaching Variables in Template Messages(JSON)
key: variable name
value: substitution content
MESSAGE VARCHAR(2500)   Body with template message variable
USER_NAME VARCHAR(20)   Naver Talk Talk Recipient Name
USER_ACCESS_TOKEN VARCHAR(100)   Naver Talk Talk Recipient Login Access Token
SENDER_KEY VARCHAR(50) NOT NULL Customer Sending Channel Partner Key
GROUP_KEY VARCHAR(50)   Sending group key (attached when using a template included in sending group)
PHONE_NUMBER VARCHAR(50) NOT NULL Naver Talk Talk Recipient Number
ATTACHMENTS TEXT   Naver Talk Talk Attachments(Attach information such as buttons, images, and coupons)
FALLBACK_YN BOOLEAN NOT NULL Whether to alternative send
true: alternative send
false(default): no alternative send
FALLBACK_TYPE VARCHAR(10) NULL Alternative send type
SMS: SMS type
LMS: LMS type
FALLBACK_CALLBACK VARCHAR(50) NULL Alternative Sending Return Number
FALLBACK_SUBJECT VARCHAR(120) NULL Alternative Sending title
FALLBACK_MESSAGE VARCHAR(2000) NULL Alternative Sending message
RESULT_MSG_TYPE1-5 VARCHAR(10)   Result message type (using engine)
RESULT_CD1-5 VARCHAR(20)   Result code (using engine)
SERVER_SEND_DATE1-5 DATETIME   Request time for sending (using engine)
RESULT_DATE1-5 DATETIME   Result time (using engine)
ERROR_MESSAGE1-5 VARCHAR(500)   Error detailed message (using engine)
TELECOM_CD1-5 VARCHAR(20)   Message carrier code (using engine)
RESERVE_DATE1-5 DATETIME NOT NULL Sending reservation date
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
REG_DATE DATETIME NOT NULL Agent dispatch data registration time (using engine)
- Default: NOW()
SEND_DATE DATETIME Agent dispatch time (using engine)
RESULT_REG_DATE DATETIME   Agent result reception time (using engine)
UPDATE_BY VARCHAR(20)   Who updated
UPDATE_DATE DATETIME   Date of update
TAX_CD1 VARCHAR(50)   Settlement related department code 1
TAX_CD2 VARCHAR(50)   Settlement related department code 2
INDEX PK : MSG_SEQNO
I1_NAVER_MESSAGE : RESERVE_DATE
I2_NAVER_MESSAGE : REG_DATE
I3_NAVER_MESSAGE: MESSAGE_TYPE
NAVER_MESSAGE_LOG(Result of Naver TalkTalk Sent)
Column name Date type Null option Comment
MSG_SEQNO(PK) NUMBER(15,0) NOT NULL Self sequence value, must be unique
SEND_CD VARCHAR(1) NOT NULL whether to send
- Default: N
RESEND_CD VARCHAR(1) NOT NULL Retransmission code in case of server transmission error (using engine)
- Default: N
MESSAGE_TYPE VARCHAR(10) NOT NULL Naver Talk Talk service type
NT_FM: NAVER TALK TALK Sends the entire text including variables attached.
NT_TM: Only Naver Talk Talk variables are sent as attachments.
TEMPLATE_CODE VARCHAR(100) NOT NULL Naver Talk Talk template code
TEMPLATE_PARAMS TEXT   Attaching Variables in Template Messages(JSON)
- key: variable name
- value: substitution content
MESSAGE VARCHAR(2500)   Body with template message variable
USER_NAME VARCHAR(20)   Naver Talk Talk Recipient Name
USER_ACCESS_TOKEN VARCHAR(100)   Naver Talk Talk Recipient Login Access Token
SENDER_KEY VARCHAR(50) NOT NULL Customer Sending Channel Partner Key
GROUP_KEY VARCHAR(50)   Sending group key (attached when using a template included in sending group)
PHONE_NUMBER VARCHAR(50) NOT NULL Naver Talk Talk Recipient Number
ATTACHMENTS TEXT   Naver Talk Talk Attachments(Attach information such as buttons, images, and coupons)
FALLBACK_YN BOOLEAN NOT NULL Whether to alternative send
true: alternative send
false(default): no alternative send
FALLBACK_TYPE VARCHAR(10) NULL Alternative send type
SMS: SMS type
LMS: LMS type
FALLBACK_CALLBACK VARCHAR(50) NULL Alternative Sending Return Number
FALLBACK_SUBJECT VARCHAR(120) NULL Alternative Sending title
FALLBACK_MESSAGE VARCHAR(2000) NULL Alternative Sending message
RESULT_MSG_TYPE1-5 VARCHAR(10)   Result message type (using engine)
RESULT_CD1-5 VARCHAR(20)   Result code (using engine)
SERVER_SEND_DATE1-5 DATETIME   Request time for sending (using engine)
RESULT_DATE1-5 DATETIME   Result time (using engine)
ERROR_MESSAGE1-5 VARCHAR(500)   Error detailed message (using engine)
TELECOM_CD1-5 VARCHAR(20)   Message carrier code (using engine)
RESERVE_DATE1-5 DATETIME NOT NULL Sending reservation date
- Default: NOW()
- Format: YYYY-MM-DD HH:MM:SS
REG_DATE DATETIME NOT NULL Agent dispatch data registration time (using engine)
- Default: NOW()
SEND_DATE DATETIME Agent dispatch time (using engine)
RESULT_REG_DATE DATETIME   Agent result reception time (using engine)
UPDATE_BY VARCHAR(20)   Who updated
UPDATE_DATE DATETIME   Date of update
TAX_CD1 VARCHAR(50)   Settlement related department code 1
TAX_CD2 VARCHAR(50)   Settlement related department code 2
INDEX PK : MSG_SEQNO
I1_NAVER_MESSAGE : RESERVE_DATE
I2_NAVER_MESSAGE : REG_DATE
I3_NAVER_MESSAGE: MESSAGE_TYPE

Sample Code

Button Data

코드예제Button Data

{
        "name": "Button name",
        "type": "WL",
        "url_pc": "http://naver.com",
        "url_mobile": "http://daum.net",
        "target": "out"
}

[Item List Template] Item Highlithed Data

코드예제[Item List Template] Item Highlighted Data

{
        "title": "Bizmessage",
        "description": "Alim Talk"
}

[Item List Template] Item List and Item Summary Data

코드예제[Item List Template] Item List Template and Summary Data

{
        "list": [
                {
                        "title": "Price",
                        "description": "10,000won"
                },
                {
                        "title": "Discount amount",
                        "description": "-1won"
                }
        ],
        "summary": {
                "title": "Tatal amount",
                "description": "9,999won"
        }
}

이 문서가 만족스러운 이유를 알려주세요.
이 문서에 아쉬운 점을 알려주세요.
평가해주셔서 감사합니다.

더 자세한 의견은 contact.dkt@kakaocorp.com 으로 제보해주세요.