MSSQL 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 ) |
NUMBER(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: 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: GETDATE() - 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: GETDATE() - 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: GETDATE() - 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 |
|||
AT : General text 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: GETDATE() - 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 - Defaul: 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: GETDATE() |
UPDATE_BY | VARCHAR(20) | NOT NULL | Who updated |
UPDATE_DATE | DATETIME | NULL | Date of update |
INDEX | PK : MSG_SEQNO I1_K_MESSAGE_LOG : RESERVE_DATEI1_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>I4_K_MESSAGE_LOG : REG_DATE |
K_AGENT (Manage Agent Redundancy)
표K_AGENT (Manage Agent Redundancy)Column name | Data type | Null option | Comment |
---|---|---|---|
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 | 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 | 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: GETDATE() - 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): to exposed |
|||
N : Not to 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: GETDATE() |
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): to exposed |
|||
N : Not to 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: GETDATE() |
INDEX | PK : MOBILE_NO I1_K_BLACKLIST : USE_YN |
XMS_MESSAGE (Send XMS)
표XMS_MESSAGE (Send XMS)Column Name | Data 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 in case of server error(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 |
XMS_MESSAGE_LOG (Result of XMS Sent)
표XMS_MESSAGE_LOG (Result of XMS Sent)Column Name | Data 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 in case of server error (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_LOG : RESERVE_DATE I2_XMS_MESSAGE_LOG : SEND_DATE I3_XMS_MESSAGE_LOG : SEND_CD, IMG_ATTACH_CD I4_XMS_MESSAGE_LOG : REG_DATE |
RCS_MESSAGE(Send RCS)
표RCS_MESSAGE(Send RCS)Column Name | Data 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 in case of server transmit error (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 | Data 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 in case of server transmit error (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 | Data 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)
표NAVER_MESSAGE(Send Naver TalkTalk)Column Name | Data 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)
표NAVER_MESSAGE_LOG(Result of Naver TalkTalk Sent)Column Name | Data 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 Tempalte] Item List Tempalte and Summary Data
{
"list": [
{
"title": "Price",
"description": "10,000won"
},
{
"title": "Discount amount",
"description": "-1won"
}
],
"summary": {
"title": "Tatal amount",
"description": "9,999won"
}
}