Oracle 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 | VARCHAR2(4000) | NULL | Message to be sent |
| TITLE | VARCHAR2(255) | NULL | Title of LMS alternate message - LMS only |
| PHONE_MSG | VARCHAR2(4000) | NULL | Body of alternate message |
| MSG_TYPE | VARCHAR2(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 | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| SENDER_NO | VARCHAR2(50) | NOT NULL | Sender number - Phone number to send actual push, SMS, MMS |
| SEND_TYPE | VARCHAR2(10) | NOT NULL | Message type |
S: real time sending |
|||
M: batch sending(2 or more messages) |
|||
| RESERVE_DATE | DATE | NOT NULL | Scheduled sending time - If there is no value, the message is sent immediately - Default: SYSDATE- Format: YYYY-MM-DD HH:MM:SS |
| KKO_TEMPLATE_CD | VARCHAR2(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 | VARCHAR2(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 | 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. |
| MMS_IMG1 | VARCHAR2(255) | NULL | MMS image path 1 |
| MMS_IMG2 | VARCHAR2(255) | NULL | MMS image path 2 |
| MMS_IMG3 | VARCHAR2(255) | NULL | MMS image path 3 |
| KKO_BTN_LINK1 | VARCHAR2(500) | NULL | Button 1 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK2 | VARCHAR2(500) | NULL | Button 2 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK3 | VARCHAR2(500) | NULL | Button 3 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK4 | VARCHAR2(500) | NULL | Button 4 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK5 | VARCHAR2(500) | NULL | Button 5 information - Refer to Button Information Data Sample |
| SEND_CD | VARCHAR2(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 | DATE | NULL | Sent date - Format: YYYY-MM-DD HH:MM:SS |
| RESEND_CD | VARCHAR2(1) | NULL | Reservation field for error retransmission when transmitting to server (not available for customer company) - Default: N |
| SERVER_MMS_IMG1 | VARCHAR2(100) | NULL | Image server path1 (not available for customer company) - sent date from server + image path by AGENT ID |
| SERVER_MMS_IMG2 | VARCHAR2(100) | NULL | Image server path2 (not available for customer company) - sent date from server + image path by AGENT ID |
| SERVER_MMS_IMG3 | VARCHAR2(100) | NULL | Image server path3 (not available for customer company) - sent date from server + image path by AGENT ID |
| IMG_ATTACH_CD | VARCHAR2(1) | NOT NULL | Whether to attach image |
Y: Image attached |
|||
M: Request for attaching image |
|||
N: No image |
|||
| IMG_SEND_DATE | DATE | NULL | Image sent date (not available for customer company) |
| FILE_NAME | VARCHAR2(50) | NULL | File name to be sent - Format: {Batch File Name} + {Sending AGENT ID} |
| RESULT_CD1 | VARCHAR2(10) | NULL | Result code of Alim Talk sent |
OK: success |
|||
| etc: error | |||
| RESULT_CD2 | VARCHAR2(10) | NULL | SMS/LMS/MMS sending result code |
OK: success |
|||
| etc: error | |||
| TELECOM_CD | VARCHAR2(3) | NULL | Message carrier code (not available for customer company) |
| SERVER_SEND_DATE1 | DATE | NULL | Server-based sending request time 1 (not available for customer company) |
| SERVER_SEND_DATE2 | DATE | NULL | Server-based sending request time 2 (not available for customer company) |
| RESULT_DATE1 | DATE | NULL | Server-based push sent time (not available for customer company) |
| RESULT_DATE2 | DATE | NULL | Server-based alternate message sent time (not available for customer company) |
| RESULT_REG_DATE | DATE | NULL | Date the result was received (not available for customer company) |
| TAX_CD1 | VARCHAR2(50) | NULL | Settlement related department code 1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Settlement related department code 2 |
| NAT_CD | VARCHAR2(3) | NULL | Country calling code - Default: 82 |
| EMPHASIZE_TITLE | VARCHAR2(255) | NULL | Title to be emphasized when using Emphasis type template |
| KKO_QUICK_REPLY1 | VARCHAR2(500) | NULL | Information of Quick Reply1 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY2 | VARCHAR2(500) | NULL | Information of Quick Reply2 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY3 | VARCHAR2(500) | NULL | Information of Quick Reply3 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY4 | VARCHAR2(500) | NULL | Information of Quick Reply4 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY5 | VARCHAR2(500) | NULL | Information of Quick Reply5 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY6 | VARCHAR2(500) | NULL | Information of Quick Reply6 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY7 | VARCHAR2(500) | NULL | Information of Quick Reply7 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY8 | VARCHAR2(500) | NULL | Information of Quick Reply8 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY9 | VARCHAR2(500) | NULL | Information of Quick Reply9 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY10 | VARCHAR2(500) | NULL | Information of Quick Reply10 - Refer to Button Information Data Sample |
| HEADER | VARCHAR2(50) | NULL | Title to appear at the top of the message when using item list type template |
| ITEM_HIGHLIGHT | VARCHAR2(100) | NULL | Item to be emphasized when using item list type template - Refer to [Item List Type Template] Highlighted Item Data Sample |
| ITEM | VARCHAR2(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 | DATE | NOT NULL | Date of registration - Default: SYSDATE- Format: YYYY-MM-DD HH:MM:SS |
| UPDATE_BY | VARCHAR2(20) | NOT NULL | Who updated |
| UPDATE_DATE | DATE | 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) |
NUMBER(15,0) | NOT NULL | Self sequence value, must be unique - MESSAGE_SEQ.NEXTVAL() value or its own unique number |
| KKO_MSG | VARCHAR2(4000) | NULL | Message to be sent |
| TITLE | VARCHAR2(255) | NULL | Title of LMS alternate message - LMS only |
| PHONE_MSG | VARCHAR2(4000) | NULL | Body of alternate message |
| MSG_TYPE | VARCHAR2(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 | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| SENDER_NO | VARCHAR2(50) | NOT NULL | Sender number - Phone number to send actual push, SMS, MMS |
| SEND_TYPE | VARCHAR2(10) | NOT NULL | Message type |
S: single item sending |
|||
M: batch sending(2 or more messages) |
|||
| RESERVE_DATE | DATE | NOT NULL | Scheduled sending time - If there is no value, the message is sent immediately - Default: SYSDATE- Format: YYYY-MM-DD HH:MM:SS |
| KKO_TEMPLATE_CD | VARCHAR2(50) | NULL | Code of Alim Talk template - Applicable only when using AlimTalk, not for SMS and MMS |
| KKO_TEMPLATE_TYPE | VARCHAR2(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 | 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. |
| MMS_IMG1 | VARCHAR2(255) | NULL | MMS image path 1 |
| MMS_IMG2 | VARCHAR2(255) | NULL | MMS image path 2 |
| MMS_IMG3 | VARCHAR2(255) | NULL | MMS image path 3 |
| KKO_BTN_LINK1 | VARCHAR2(500) | NULL | Button 1 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK2 | VARCHAR2(500) | NULL | Button 2 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK3 | VARCHAR2(500) | NULL | Button 3 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK4 | VARCHAR2(500) | NULL | Button 4 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK5 | VARCHAR2(500) | NULL | Button 5 information - Refer to Button Information Data Sample |
| SEND_CD | VARCHAR2(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 | DATE | NULL | Sent date - Default: SYSDATE- Format: YYYY-MM-DD HH:MM:SS |
| RESEND_CD | VARCHAR2(1) | NULL | Reservation field for error retransmission when transmitting to server (not available for customer company) - Default: N |
| SERVER_MMS_IMG1 | VARCHAR2(100) | NULL | Image server path1 (not available for customer company) - sent date from server + image path by AGENT ID |
| SERVER_MMS_IMG2 | VARCHAR2(100) | NULL | Image server path2 (not available for customer company) - sent date from server + image path by AGENT ID |
| SERVER_MMS_IMG3 | VARCHAR2(100) | NULL | Image server path3 (not available for customer company) - sent date from server + image path by AGENT ID |
| IMG_ATTACH_CD | VARCHAR2(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 | DATE | NULL | Image sent date (not available for customer company) |
| FILE_NAME | VARCHAR2(50) | NULL | File name to be sent - Format: {Batch File Name} + {Sending AGENT ID} |
| RESULT_CD1 | VARCHAR2(10) | NULL | Result code of Kakao sent |
OK: success |
|||
| etc: error | |||
| RESULT_CD2 | VARCHAR2(10) | NULL | SMS/LMS/MMS sending result code |
OK: success |
|||
| etc: error | |||
| TELECOM_CD | VARCHAR2(3) | NULL | message carrier code - Unavailable for agent use only |
| SERVER_SEND_DATE1 | DATE | NULL | Server-based sending request time 1 - Unavailable for agent use only |
| SERVER_SEND_DATE2 | DATE | NULL | Server-based sending request time 2 - Unavailable for agent use only |
| RESULT_DATE1 | DATE | NULL | Server-based push sent time - Unavailable for agent use only |
| RESULT_DATE2 | DATE | NULL | Server-based alternate message sent time - Unavailable for agent use only |
| RESULT_REG_DATE | DATE | NULL | Date the result was received - Unavailable for agent use only |
| TAX_CD1 | VARCHAR2(50) | NULL | Settlement related department code 1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Settlement related department code 2 |
| NAT_CD | VARCHAR2(3) | NULL | Country calling code - Defalut: 82 |
| EMPHASIZE_TITLE | VARCHAR2(255) | NULL | Title to be emphasized when using Emphasis type template |
| KKO_QUICK_REPLY1 | VARCHAR2(500) | NULL | Information of Quick Reply1 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY2 | VARCHAR2(500) | NULL | Information of Quick Reply2 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY3 | VARCHAR2(500) | NULL | Information of Quick Reply3 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY4 | VARCHAR2(500) | NULL | Information of Quick Reply4 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY5 | VARCHAR2(500) | NULL | Information of Quick Reply5 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY6 | VARCHAR2(500) | NULL | Information of Quick Reply6 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY7 | VARCHAR2(500) | NULL | Information of Quick Reply7 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY8 | VARCHAR2(500) | NULL | Information of Quick Reply8 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY9 | VARCHAR2(500) | NULL | Information of Quick Reply9 - Refer to Button Information Data Sample |
| KKO_QUICK_REPLY10 | VARCHAR2(500) | NULL | Information of Quick Reply10 - Refer to Button Information Data Sample |
| HEADER | VARCHAR2(50) | NULL | Title to appear at the top of the message when using item list type template |
| ITEM_HIGHLIGHT | VARCHAR2(100) | NULL | Item to be emphasized when using item list type template - Refer to [Item List Type Template] Highlighted Item Data Sample |
| ITEM | VARCHAR2(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 | DATE | NOT NULL | Date of registration - Default: SYSDATE |
| UPDATE_BY | VARCHAR2(20) | NOT NULL | Who updated |
| UPDATE_DATE | DATE | 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 | Data type | Null option | Comment |
|---|---|---|---|
AGENT_ID(PK) |
VARCHAR2(20) | NOT NULL | Agent sharing ID |
| CURRENT_STATUS | VARCHAR2(1) | NOT NULL | Status of agent |
M: Master |
|||
S: Slave |
|||
| L_CHECK_TIME | DATE | 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) |
NUMBER(15,0) | NOT NULL | Self sequence value, must be unique - MESSAGE_SEQ.NEXTVAL() value or its own unique number |
| KKO_MSG | VARCHAR2(4000) | NULL | Message to be sent |
| MOBILE_NO | VARCHAR2(50) | NOT NULL | Phone number to receive messages - Used when you want to designate a specific number other than the default |
| SENDER_NO | VARCHAR2(50) | NOT NULL | Sender number - Phone number to send actual push, SMS, MMS |
| TITLE | VARCHAR2(255) | NULL | Title of message when using LMS or MMS alternate message |
| PHONE_MSG | VARCHAR2(4000) | NULL | Alternate message |
| MSG_TYPE | VARCHAR2(10) | NOT NULL | Message type |
FX(default): Friend Talk only |
|||
FS: Friend Talk + SMS alternate message |
|||
FM: Friend Talk + LMS alternate message |
|||
| RESERVE_DATE | DATE | NOT NULL | Scheduled sending time - If there is no value, the message is sent immediately - Default: SYSDATE- Format: YYYY-MM-DD HH:MM:SS |
| KKO_IMG_PATH | VARCHAR2(255) | NULL | Image path to attach to Friend Talk |
| KKO_IMG_WIDE_CD | VARCHAR2(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 | VARCHAR2(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 | VARCHAR2(500) | NULL | Button 1 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK2 | VARCHAR2(500) | NULL | Button 2 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK3 | VARCHAR2(500) | NULL | Button 3 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK4 | VARCHAR2(500) | NULL | Button 4 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK5 | VARCHAR2(500) | NULL | Button 5 information - Refer to Button Information Data Sample |
| SEND_CD | VARCHAR2(1) | NOT NULL | Whether to send - Default: N |
| SEND_DATE | DATE | NULL | Sent date |
| RESEND_CD | VARCHAR2(1) | NULL | Reservation field for error retransmission when transmitting to server (not available for customer company) - Default: N |
| SERVER_KKO_IMG | VARCHAR2(255) | NULL | Image path saved in KakaoTalk server |
| IMG_ATTACH_CD | VARCHAR2(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 | DATE | NULL | Image sent date (not available for customer company) |
| FILE_NAME | VARCHAR2(50) | NULL | File name to be sent - Format: {Batch File Name} + {Sending AGENT ID} |
| RESULT_CD1 | VARCHAR2(20) | NULL | Result code of Friend Talk sent |
OK: success |
|||
| etc: error | |||
| RESULT_CD2 | VARCHAR2(20) | NULL | Result code of Message sent |
OK: success |
|||
| etc: error | |||
| TELECOM_CD | VARCHAR2(20) | NULL | Message carrier code |
| SERVER_SEND_DATE1 | DATE | NULL | Date 1 of request to send Friend Talk(server-based) - Unavailable for agent use only |
| SERVER_SEND_DATE2 | DATE | NULL | Date 2 of request to send Friend Talk(server-based) - Unavailable for agent use only |
| RESULT_DATE1 | DATE | NULL | Date the result of sending Friend Talk was received (server-based) - Unavailable for agent use only |
| RESULT_DATE2 | DATE | NULL | Date the result of message was received (server-based) - Unavailable for agent use only |
| RESULT_REG_DATE | DATE | NULL | Date the result was received - Unavailable for agent use only |
| TAX_CD1 | VARCHAR2(50) | NULL | Settlement related department code 1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Settlement related department code 2 |
| REG_DATE | DATE | NOT NULL | Date of registration - Default: SYSDATE |
| UPDATE_BY | VARCHAR2(20) | NULL | Who updated |
| UPDATE_DATE | DATE | 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) |
NUMBER(15,0) | NOT NULL | Self sequence value, must be unique - MESSAGE_SEQ.NEXTVAL() value or its own unique number |
| KKO_MSG | VARCHAR2(4000) | NULL | Message to be sent |
| MOBILE_NO | VARCHAR2(50) | NOT NULL | Sender number - Used when you want to designate a specific number other than the default |
| SENDER_NO | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| TITLE | VARCHAR2(255) | NULL | Title of message when using LMS or MMS alternate message |
| PHONE_MSG | VARCHAR2(4000) | NULL | Body of alternate message |
| MSG_TYPE | VARCHAR2(10) | NOT NULL | Message type |
FX: Friend Talk only |
|||
FS: Friend Talk + SMS alternate message |
|||
FM: Friend Talk + LMS alternate message |
|||
| RESERVE_DATE | DATE | NOT NULL | Scheduled sending time - If there is no value, the message is sent immediately |
| KKO_IMG_PATH | VARCHAR2(255) | NULL | Image path to attach to Friend Talk |
| KKO_IMG_WIDE_CD | VARCHAR2(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 | VARCHAR2(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 | VARCHAR2(500) | NULL | Button 1 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK2 | VARCHAR2(500) | NULL | Button 2 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK3 | VARCHAR2(500) | NULL | Button 3 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK4 | VARCHAR2(500) | NULL | Button 4 information - Refer to Button Information Data Sample |
| KKO_BTN_LINK5 | VARCHAR2(500) | NULL | Button 5 information - Refer to Button Information Data Sample |
| SEND_CD | VARCHAR2(1) | NOT NULL | Whether to send |
| SEND_DATE | DATE | NULL | Sent date |
| RESEND_CD | VARCHAR2(1) | NULL | Reservation field for error retransmission when transmitting to server (not available for customer company) - Default: N |
| SERVER_KKO_IMG | VARCHAR2(255) | NULL | Server path of KakaoTalk image |
| IMG_ATTACH_CD | VARCHAR2(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 | DATE | NULL | Image sent date (not available for customer company) |
| FILE_NAME | VARCHAR2(50) | NULL | File name to be sent - Format: {Batch File Name} + {Sending AGENT ID} |
| RESULT_CD1 | VARCHAR2(20) | NULL | Result code of Friend Talk sent |
OK: success |
|||
etc: error |
|||
| TELECOM_CD | VARCHAR2(20) | NULL | Message carrier code |
| SERVER_SEND_DATE1 | DATE | NULL | Date 1 of request to send Friend Talk(server-based) - Unavailable for agent use only |
| SERVER_SEND_DATE2 | DATE | NULL | Date 2 of request to send Friend Talk(server-based) - Unavailable for agent use only |
| RESULT_DATE1 | DATE | NULL | Date the result of sending Friend Talk was received (server-based) - Unavailable for agent use only |
| RESULT_DATE2 | DATE | NULL | Date the result of message was received (server-based) - Unavailable for agent use only |
| RESULT_REG_DATE | DATE | NULL | Date the result was received - Unavailable for agent use only |
| TAX_CD1 | VARCHAR2(50) | NULL | Settlement related department code 1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Settlement related department code 2 |
| REG_DATE | DATE | NOT NULL | Date of registration |
| UPDATE_BY | VARCHAR2(20) | NULL | Who updated |
| UPDATE_DATE | DATE | 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) |
VARCHAR2(50) | NOT NULL | Mobile phone number |
| USE_YN | VARCHAR2(1) | NOT NULL | Whether to use black-list |
Y(default): use black-list |
|||
N: do not use black-list |
|||
| REG_DATE | DATE | NOT NULL | Date of registration - Default: SYSDATE |
| 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 | VARCHAR2(255) | NULL | Title of LMS or MMS message |
| PHONE_MSG | VARCHAR2(4000) | NULL | Message to be sent |
| MSG_TYPE | VARCHAR2(10) | NOT NULL | Message type |
SM: sending message |
|||
LM: sending LMS |
|||
MM: sending MMS |
|||
| MOBILE_NO | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| SENDER_NO | VARCHAR2(50) | NOT NULL | Sender number |
| RESERVE_DATE | DATE | NOT NULL | Scheduled sending time - Format: YYYY-MM-DD HH:MM:SS |
| MMS_IMG1 | VARCHAR2(255) | NULL | MMS image path 1 |
| MMS_IMG2 | VARCHAR2(255) | NULL | MMS image path 2 |
| MMS_IMG3 | VARCHAR2(255) | NULL | MMS image path 3 |
| SEND_CD | VARCHAR2(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 | DATE | NULL | Sent date(using engine) |
| RESEND_CD | VARCHAR2(1) | NOT NULL | Retransmission code when server error occurs(using engine) - Default: N |
| SERVER_MMS_IMG1 | VARCHAR2(100) | NULL | Image server path 1(using engine) |
| SERVER_MMS_IMG2 | VARCHAR2(100) | NULL | Image server path 2(using engine) |
| SERVER_MMS_IMG3 | VARCHAR2(100) | NULL | Image server path 3(using engine) |
| IMG_ATTACH_CD | VARCHAR2(1) | NOT NULL | Whether to attach the image |
N(default): no image |
|||
| IMG_SEND_DATE | DATE | NULL | Image sent date(using engine) |
| FILE_NAME | VARCHAR2(50) | NULL | File name sent(using engine) |
| RESULT_CD | VARCHAR2(20) | NULL | Result code |
| TELECOM_CD | VARCHAR2(20) | NULL | message carrier code |
| SERVER_SEND_DATE | DATE | NULL | Date of request for sending (server-based) |
| RESULT_DATE | DATE | NULL | Date that the push result was received |
| RESULT_REG_DATE | DATE | NULL | Date the result was successfully received |
| TAX_CD1 | VARCHAR2(50) | NULL | Department code1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Department code2 |
| NAT_CD | VARCHAR2(3) | NULL | Country calling code - Default: 82 |
| REG_DATE | DATE | NULL | Creation date |
| UPDATE_BY | VARCHAR2(20) | NULL | Who updated |
| UPDATE_DATE | DATE | 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 | VARCHAR2(255) | NULL | Title of LMS or MMS message |
| PHONE_MSG | VARCHAR2(4000) | NULL | Message to be sent |
| MSG_TYPE | VARCHAR2(10) | NOT NULL | Message type |
SM: sending message |
|||
LM: sending LMS |
|||
MM: sending MMS |
|||
| MOBILE_NO | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| SENDER_NO | VARCHAR2(50) | NOT NULL | Sender number |
| RESERVE_DATE | DATE | NOT NULL | Scheduled sending time - Format: YYYY-MM-DD HH:MM:SS |
| MMS_IMG1 | VARCHAR2(255) | NULL | MMS image path 1 |
| MMS_IMG2 | VARCHAR2(255) | NULL | MMS image path 2 |
| MMS_IMG3 | VARCHAR2(255) | NULL | MMS image path 3 |
| SEND_CD | VARCHAR2(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 | DATE | NULL | Sent date(using engine) |
| RESEND_CD | VARCHAR2(1) | NOT NULL | Retransmission code when server error occurs(using engine) - Default: N |
| SERVER_MMS_IMG1 | VARCHAR2(100) | NULL | Image server path 1(using engine) |
| SERVER_MMS_IMG2 | VARCHAR2(100) | NULL | Image server path 2(using engine) |
| SERVER_MMS_IMG3 | VARCHAR2(100) | NULL | Image server path 3(using engine) |
| IMG_ATTACH_CD | VARCHAR2(1) | NOT NULL | Whether to attach the image |
N(default): no image |
|||
| IMG_SEND_DATE | DATE | NULL | Image sent date(using engine) |
| FILE_NAME | VARCHAR2(50) | NULL | File name sent(using engine) |
| RESULT_CD | VARCHAR2(20) | NULL | Result code |
| TELECOM_CD | VARCHAR2(20) | NULL | message carrier code |
| SERVER_SEND_DATE | DATE | NULL | Date of request for sending (server-based) |
| RESULT_DATE | DATE | NULL | Date that the push result was received |
| RESULT_REG_DATE | DATE | NULL | Date the result was successfully received |
| TAX_CD1 | VARCHAR2(50) | NULL | Department code1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Department code2 |
| NAT_CD | VARCHAR2(3) | NULL | Country calling code - Default: 82 |
| REG_DATE | DATE | NULL | Creation date |
| UPDATE_BY | VARCHAR2(20) | NULL | Who updated |
| UPDATE_DATE | DATE | 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 | DATE | NOT NULL | Scheduled sending time - Format: YYYY-MM-DD HH:MM:SS |
| SEND_DATE | DATE | NULL | Sent date |
| SEND_CD | VARCHAR2(1) | NOT NULL | Whether to send |
N(default): sending reception |
|||
| RESEND_CD | VARCHAR2(1) | NOT NULL | Retransmission code when server error occurs(using engine) - Default: N |
| RESULT_CD1 | VARCHAR2(20) | NULL | Code of sending result(result code of push sent) |
| RESULT_CD2 | VARCHAR2(20) | NULL | Code of sending result(result code of message sent) |
| SERVER_SEND_DATE1 | DATE | NULL | Date of request for sending 1 |
| SERVER_SEND_DATE2 | DATE | NULL | Date of request for sending 2 |
| RESULT_DATE1 | DATE | NULL | Date received result 1 |
| RESULT_DATE2 | DATE | NULL | Date received result 2 |
| PHONE_NO | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| CALLBACK | VARCHAR2(50) | NOT NULL | Callback number |
| AGENCY_ID | VARCHAR2(100) | NOT NULL | RCS agency ID |
| MESSAGE_BASE_ID | VARCHAR2(100) | NOT NULL | RCS template code ID |
| MESSAGE_GROUP_ID | VARCHAR2(100) | NULL | Message group ID |
| SERVICE_TYPE | VARCHAR2(10) | NOT NULL | Service type |
RCSSMS: SMS type |
|||
RCSLMS: LMS type |
|||
RCSMMS: MMS type |
|||
RCSTMPL: RCS template type |
|||
| HEADER | VARCHAR2(1) | NOT NULL | Whether to advertise |
0: Informational Advertisement |
|||
1: Advertisement |
|||
| FOOTER | VARCHAR2(20) | NULL | 080 call rejection phone number(HEADER : 1) - Fill in only for advertisements |
| COPY_ALLOWED | VARCHAR2(4) | NOT NULL | Whether to allow to copy message |
true(default): copy allowed |
|||
false: not allowed |
|||
| BODY | VARCHAR2(4000) | NULL | Body(JSON) |
| BUTTONS | VARCHAR2(4000) | NULL | Button(JSON) |
| MMS_TITLE1 | VARCHAR2(100) | NULL | RCSMMS title1 |
| MMS_MSG1 | VARCHAR2(4000) | NULL | RCSMMS message1 |
| MMS_IMG_URL1 | VARCHAR2(300) | NULL | RCSMMS image URL 1 |
| MMS_TITLE2 | VARCHAR2(100) | NULL | RCSMMS title2 |
| MMS_MSG2 | VARCHAR2(4000) | NULL | RCSMMS message2 |
| MMS_IMG_URL2 | VARCHAR2(300) | NULL | RCSMMS image URL 2 |
| MMS_TITLE3 | VARCHAR2(100) | NULL | RCSMMS title3 |
| MMS_MSG3 | VARCHAR2(4000) | NULL | RCSMMS message3 |
| MMS_IMG_URL3 | VARCHAR2(300) | NULL | RCSMMS image URL 3 |
| MMS_TITLE4 | VARCHAR2(100) | NULL | RCSMMS title4 |
| MMS_MSG4 | VARCHAR2(4000) | NULL | RCSMMS message4 |
| MMS_IMG_URL4 | VARCHAR2(300) | NULL | RCSMMS image URL 4 |
| MMS_TITLE5 | VARCHAR2(100) | NULL | RCSMMS title5 |
| MMS_MSG5 | VARCHAR2(4000) | NULL | RCSMMS message5 |
| MMS_IMG_URL5 | VARCHAR2(300) | NULL | RCSMMS image URL 5 |
| MMS_TITLE6 | VARCHAR2(100) | NULL | RCSMMS title6 |
| MMS_MSG6 | VARCHAR2(4000) | NULL | RCSMMS message6 |
| MMS_IMG_URL6 | VARCHAR2(300) | NULL | RCSMMS image URL 6 |
| FALLBACK_YN | CHAR(1) | NOT NULL | Whether to use fallback |
true : send alternate message |
|||
false(default): no alternate message |
|||
| FALLBACK_TYPE | VARCHAR2(10) | NULL | Fallback type |
SMS: SMS type |
|||
LMS: LMS type |
|||
| FALLBACK_CALLBACK | VARCHAR2(50) | NULL | Callback number of alternate sending |
| FALLBACK_SUBJECT | VARCHAR2(120) | NULL | Title of alternate message |
| FALLBACK_MESSAGE | VARCHAR2(2000) | NULL | Alternate sending message |
| TAX_CD1 | VARCHAR2(50) | NULL | Department code 1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Department code 2 |
| REQ_DATE | DATE | NULL | Sent date |
| RES_DATE | DATE | NULL | Date received result |
| ERROR_MESSAGE1 | VARCHAR2(500) | NULL | Detailed message of RCS error |
| ERROR_MESSAGE2 | VARCHAR2(500) | NULL | Detailed message of alternate sending error |
| MNO_INFO1 | VARCHAR2(10) | NULL | Mobile carrier information of RCS recipient |
| MNO_INFO2 | VARCHAR2(10) | NULL | Mobile carrier information of alternate message recipient |
| UPDATE_BY | VARCHAR2(20) | NULL | Who updated |
| UPDATE_DATE | DATE | 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 | DATE | NOT NULL | Scheduled sending time - Format: YYYY-MM-DD HH:MM:SS |
| SEND_DATE | DATE | NULL | Sent date |
| SEND_CD | VARCHAR2(1) | NOT NULL | Whether to send |
N(default) : sending reception |
|||
| RESEND_CD | VARCHAR2(1) | NOT NULL | Retransmission code when server error occurs(using engine) - Default: N |
| RESULT_CD1 | VARCHAR2(20) | NULL | Code of sending result(result code of push sent) |
| RESULT_CD2 | VARCHAR2(20) | NULL | Code of sending result(result code of message sent) |
| SERVER_SEND_DATE1 | DATE | NULL | Date of request for sending 1 |
| SERVER_SEND_DATE2 | DATE | NULL | Date of request for sending 2 |
| RESULT_DATE1 | DATE | NULL | Date received result 1 |
| RESULT_DATE2 | DATE | NULL | Date received result 2 |
| PHONE_NO | VARCHAR2(50) | NOT NULL | Phone number to receive messages |
| CALLBACK | VARCHAR2(50) | NOT NULL | Callback number |
| AGENCY_ID | VARCHAR2(100) | NOT NULL | RCS agency ID |
| MESSAGE_BASE_ID | VARCHAR2(100) | NOT NULL | RCS template code ID |
| MESSAGE_GROUP_ID | VARCHAR2(100) | NULL | Message group ID |
| SERVICE_TYPE | VARCHAR2(10) | NOT NULL | Service type |
RCSSMS: SMS type |
|||
RCSLMS: LMS type |
|||
RCSMMS: MMS type |
|||
RCSTMPL: RCS template type |
|||
| HEADER | VARCHAR2(1) | NOT NULL | Whether to advertise |
0: Informational Advertisement |
|||
1: Advertisement |
|||
| FOOTER | VARCHAR2(20) | NULL | 080 call rejection phone number(HEADER : 1) - Fill in only for advertisements |
| COPY_ALLOWED | VARCHAR2(4) | NOT NULL | Whether to allow to copy message |
true(default): copy allowed |
|||
false: not allowed |
|||
| BODY | VARCHAR2(4000) | NULL | Body(JSON) |
| BUTTONS | VARCHAR2(4000) | NULL | Button(JSON) |
| MMS_TITLE1 | VARCHAR2(100) | NULL | RCSMMS title1 |
| MMS_MSG1 | VARCHAR2(4000) | NULL | RCSMMS message1 |
| MMS_IMG_URL1 | VARCHAR2(300) | NULL | RCSMMS image URL 1 |
| MMS_TITLE2 | VARCHAR2(100) | NULL | RCSMMS title2 |
| MMS_MSG2 | VARCHAR2(4000) | NULL | RCSMMS message2 |
| MMS_IMG_URL2 | VARCHAR2(300) | NULL | RCSMMS image URL 2 |
| MMS_TITLE3 | VARCHAR2(100) | NULL | RCSMMS title3 |
| MMS_MSG3 | VARCHAR2(4000) | NULL | RCSMMS message3 |
| MMS_IMG_URL3 | VARCHAR2(300) | NULL | RCSMMS image URL 3 |
| MMS_TITLE4 | VARCHAR2(100) | NULL | RCSMMS title4 |
| MMS_MSG4 | VARCHAR2(4000) | NULL | RCSMMS message4 |
| MMS_IMG_URL4 | VARCHAR2(300) | NULL | RCSMMS image URL 4 |
| MMS_TITLE5 | VARCHAR2(100) | NULL | RCSMMS title5 |
| MMS_MSG5 | VARCHAR2(4000) | NULL | RCSMMS message5 |
| MMS_IMG_URL5 | VARCHAR2(300) | NULL | RCSMMS image URL 5 |
| MMS_TITLE6 | VARCHAR2(100) | NULL | RCSMMS title6 |
| MMS_MSG6 | VARCHAR2(4000) | NULL | RCSMMS message6 |
| MMS_IMG_URL6 | VARCHAR2(300) | NULL | RCSMMS image URL 6 |
| FALLBACK_YN | CHAR(1) | NOT NULL | Whether to use fallback |
true : send alternate message |
|||
false (default): no alternate message |
|||
| FALLBACK_TYPE | VARCHAR2(10) | NULL | Fallback type |
SMS: SMS type |
|||
LMS: LMS type |
|||
| FALLBACK_CALLBACK | VARCHAR2(50) | NULL | Callback number of alternate sending |
| FALLBACK_SUBJECT | VARCHAR2(120) | NULL | Title of alternate message |
| FALLBACK_MESSAGE | VARCHAR2(2000) | NULL | Alternate sending message |
| TAX_CD1 | VARCHAR2(50) | NULL | Department code 1 |
| TAX_CD2 | VARCHAR2(50) | NULL | Department code 2 |
| REQ_DATE | DATE | NULL | Sent date |
| RES_DATE | DATE | NULL | Date received result |
| ERROR_MESSAGE1 | VARCHAR2(500) | NULL | Detailed message of RCS error |
| ERROR_MESSAGE2 | VARCHAR2(500) | NULL | Detailed message of alternate sending error |
| MNO_INFO1 | VARCHAR2(10) | NULL | Mobile carrier information of RCS recipient |
| MNO_INFO2 | VARCHAR2(10) | NULL | Mobile carrier information of alternate message recipient |
| UPDATE_BY | VARCHAR2(20) | NULL | Who updated |
| UPDATE_DATE | DATE | 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 | DATE | NOT NULL | Registration date |
| IMG_STATUS | VARCHAR2(10) | NOT NULL | image processing status |
0: Registration |
|||
1: Uploading |
|||
2: Uploaded |
|||
| IMG_RESULT_CODE | VARCHAR2(100) | Image processing result | |
| IMG_RESULT_MESSAGE | VARCHAR2(100) | Image processing result detailed message | |
| IMG_FILE_PATH | VARCHAR2(100) | NOT NULL | Image save path |
| IMG_MIME_TYPE | VARCHAR2(100) | NOT NULL | Image type |
| IMG_DESCRIPTION | VARCHAR2(200) | Image description | |
| IMG_UPLOAD_URL | VARCHAR2(100) | Image upload URL(Automatic input when upload is complete) | |
| IMG_EXPIRY_DATE | VARCHAR2(100) | Image expiry time | |
| REQ_DATE | DATE | image sending date | |
| RES_DATE | DATE | Image Result Receipt date | |
| ETC1 | VARCHAR2(200) | User Field 1 | |
| ETC2 | VARCHAR2(200) | User Field 2 | |
| ETC3 | VARCHAR2(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"
}
}