Description
๋ณธ ๋ฌธ์๋ ๋ฐฑ์
๋ ๋ฐ์ดํฐ์ ๋ํ ๊ตฌ์กฐ ์ค๋ช
๋ฌธ์์
๋๋ค.
โข
๋ฐ์ดํฐ ์ด๊ด ํ๋ผ๋ฏธํฐ๋ ์ธ์ ๋ ์ง ์ ๊ท๋ก ์ถ๊ฐ๋ ์ ์์ต๋๋ค.
๊ณ ๊ฐ์ฌ์์๋ ์ถ๊ฐ ํ๋ผ๋ฏธํฐ๋ค์ ๊ฐ์ํ๊ณ ์ฐ๋ํ์๊ธฐ ๋ฐ๋๋๋ค.
โข
๋ฉ์์ง ํฌ๋งท ๊ฐ์ด๋
ํ
ํ๋ฆฟ ๋ฉ์์ง(template) ํฌ๋งท์ ๋ํ ์์ธํ ์ค๋ช
์ ์ ๊ท ๋ฉ์์ง ํฌ๋งท ๊ฐ์ด๋ ๋ฌธ์๋ฅผ ์ฐธ๊ณ ํ์ธ์.
Data Structure
Field Name | Type | Length | Description |
id | Bigint | 20 | AUTO_INCREMENT |
chat_list_id | Char | 30 | ์ฑํ
๋ฐฉ ID |
socket_room_id | Char | 30 | ํดํผํก ์ฌ์ฉ ๊ฐ |
from_id | Int | 11 | ๋ณด๋ธ ์ฌ๋ ID |
to_id | Int | 11 | ๋ฐ์ ์ฌ๋ ID |
type | Char | 1 | ์ฑํ
ํ์
|
user_type | Char | 1 | ๋ณด๋ธ ์ฌ๋ ์ ์ ํ์
|
contents | Text | ์๋ด ๋ฉ์์ง | |
contents_type | Varchar | 15 | ์๋ด ๋ฉ์์ง ํ์
|
status | Char | 2 | ์๋ด ๋ฉ์์ง ์ํ (ํดํผํก ๋ด๋ถ ์ฌ์ฉ ๊ฐ) |
counterpart_status | Char | 2 | ์๋ด ๋ฉ์์ง ์ํ (ํดํผํก ๋ด๋ถ ์ฌ์ฉ ๊ฐ) |
send_date | Datetime | ์ ์ก์ผ์ | |
receive_date | Datetime | ๋ฉ์์ง ๋ฐ์ ์ผ์ | |
read_date | Datetime | ๋ฉ์์ง ์ฝ์ ์ผ์ | |
fail_date | Datetime | ๋ฉ์์ง ์ ์ก ์คํจ ์ผ์ | |
msg_id | Varchar | 50 | ๋ฉ์์ง ID (๋๋ค ๋ฌธ์์ด์ ์ ๋ํฌ ๊ฐ) |
seq | Int | 11 | ํดํผํก ์ฌ์ฉ ๊ฐ (ํดํผํก ๋ด๋ถ ์ฌ์ฉ ๊ฐ) |
is_today_first_counsel | Tinyint | 4 | ์๋ด์ ์ต์ด ์๋ด ์ฌ๋ถ (ํดํผํก ๋ด๋ถ ์ฌ์ฉ ๊ฐ) |
Data Structure Example (Json)
Data Structure Example
text / image / normal ์์
{
"id": "304185866",
"chat_list_id": "a78AbccD4abcdeFGH5i4j03k429l9m",
"socket_room_id": "a78AbccD4abcdeFGH5i4j03k429l9m",
"from_id": "robot1234567890",
"to_id": "1222333444_ABCD520",
"type": "C",
"user_type": "B",
"contents": "์๋
ํ์ธ์. ์ ์ธ๊ณ๋ฉด์ธ์ ๋ด ์
๋๋ค. ๋ฌด์์ ๋์๋๋ฆด๊น์?\nโ ํ์ฌ ์ ์ธ๊ณ๋ฉด์ธ์ ์จ๋ผ์ธ๋ชฐ ์ฃผ๋ฌธ๊ฐ๋ฅ์๊ฐ ๋ฐ ์คํ๋ผ์ธ ๋งค์ฅ ์ด์ฉ ์๊ฐ์ด ํ์์ ์ผ๋ก ๋ณ๊ฒฝ๋์์ต๋๋ค.\n์์ธํ ์ฌํญ์ ํํ์ด์ง ๊ณต์ง์ฌํญ ๋ฐ ๊ณ ๊ฐ์ผํฐ(1661-8778)๋ก ์ฐ๋ฝ ๋ถํ๋๋ฆฝ๋๋ค.",
"contents_type": "text",
"status": "1",
"counterpart_status": "1",
"send_date": "2020-08-30 10:41:08",
"receive_date": null,
"read_date": "2020-08-30 10:41:09",
"fail_date": null,
"msg_id": "c5dac4d7-1b66-4bc3-a257-7284e57b9318",
"seq": null,
"is_today_first_counsel": "0"
}
JavaScript
๋ณต์ฌ
{
"id": "35749047",
"chat_list_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"socket_room_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"from_id": "48322362",
"to_id": "52588",
"type": "C",
"user_type": "C",
"contents": "https:\/\/patch.happytalk.io\/data\/chat_data\/2022_03_25\/4ba20d6a5a7a72133aeabfb80eab604b_w.png",
"contents_type": "image",
"status": "1",
"counterpart_status": "1",
"send_date": "2022-03-25 11:43:36",
"receive_date": null,
"read_date": "2022-03-25 11:43:57",
"fail_date": null,
"msg_id": "d93724f4-74b7-4d69-90fb-531f33cc6dcb",
"seq": null,
"is_today_first_counsel": "0"
}
JavaScript
๋ณต์ฌ
{
"id": "35749044",
"chat_list_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"socket_room_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"from_id": "52589",
"to_id": "48322362",
"type": "C",
"user_type": "H",
"contents": "{\"text\":\"๋น ๋ฅด๊ณ ์ ํํ ์๋ด์ ์ํด ๊ณ ๊ฐ๋์ ํ๋กํ์ ์
๋ ฅํด ์ฃผ์ธ์333:)\",\"link\":{\"name\":[\"๊ณ ๊ฐ ํ๋กํ ์
๋ ฅ\"],\"url\":[\"http:\\\/\\\/local-customer.happytalk.io\\\/bot\\\/profilebot?token=Q1RtJL1TRVeA%2Bua34dzNzTlnjx91SxBFLruugrebEeDk46k%2FY6DGKlPUKml49JQ9NgJWpT4hpOsXJBDdsJedO%2BHLA4vQa%2BTdl0M1DJJN1pflUgq2Whzkxvgn7sAr%2BYi2gycO1BODj6HwJseoa5RiOBgfGOF5sKzB0tcjExshv2Q%3D\"]},\"image_url\":\"https:\\\/\\\/local.happytalk.io\\\/data2\\\/profile_bot\\\/5000100210\\\/fde2bfede744fe9f42780ea401213fd3.png\"}",
"contents_type": "normal",
"status": "1",
"counterpart_status": "1",
"send_date": "2022-03-25 11:43:09",
"receive_date": null,
"read_date": "2022-03-25 11:43:09",
"fail_date": null,
"msg_id": "c84328d7-ac4c-47fe-bf1b-c831a048a93a",
"seq": null,
"is_today_first_counsel": "0"
}
JavaScript
๋ณต์ฌ
template ์์ (TEXT / IMAGE / CAROUSEL)
{
"id": "35749044",
"chat_list_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"socket_room_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"from_id": "52589",
"to_id": "48322362",
"type": "C",
"user_type": "H",
"contents": "{\"type\":\"TEXT\",\"message\":\"test ์ ๊ทtest ์ ๊ทtest ์ ๊ทtest ์ ๊ท\",\"isLocked\":false,\"buttonList\":[{\"type\":\"TEXT\",\"name\":\"!์ข
๋ฃ\"}],\"quickReplyList\":[{\"type\":\"TEXT\",\"name\":\"!์ข
๋ฃ\"}]}",
"contents_type": "template",
"status": "1",
"counterpart_status": "1",
"send_date": "2025-10-25 11:43:09",
"receive_date": null,
"read_date": "2025-10-25 11:43:09",
"fail_date": null,
"msg_id": "c84328d7-ac4c-47fe-bf1b-c831a048a93a",
"seq": null,
"is_today_first_counsel": "0"
}
JavaScript
๋ณต์ฌ
{
"id": "35749044",
"chat_list_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"socket_room_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"from_id": "52589",
"to_id": "48322362",
"type": "C",
"user_type": "H",
"contents": "{\"type\":\"IMAGE\",\"message\":\"์ด๋ฏธ์ง ํผํฉํ ํ
์คํธ ์
๋๋ค\\n1\",\"isLocked\":false,\"image\":{\"imageUrl\":\"https:\\/\\/patch.happytalk.io\\/data\\/template\\/1000225100\\/1000225100_a8533563f0b5a28bae97055849958062_w.jpg\"},\"buttonList\":[{\"type\":\"WEB_LINK\",\"name\":\"ํดํผํก\",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\"},{\"type\":\"TEXT\",\"name\":\"๋ด ํค์๋\"}],\"quickReplyList\":[{\"type\":\"WEB_LINK\",\"name\":\"ํดํผํก\",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\"},{\"type\":\"TEXT\",\"name\":\"๋ด ํค์๋\"}]}",
"contents_type": "template",
"status": "1",
"counterpart_status": "1",
"send_date": "2025-10-25 11:43:09",
"receive_date": null,
"read_date": "2025-10-25 11:43:09",
"fail_date": null,
"msg_id": "c84328d7-ac4c-47fe-bf1b-c831a048a93a",
"seq": null,
"is_today_first_counsel": "0"
}
JavaScript
๋ณต์ฌ
{
"id": "35749044",
"chat_list_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"socket_room_id": "jQwGXWjCrrNFChCGl623d2c39bad92",
"from_id": "52589",
"to_id": "48322362",
"type": "C",
"user_type": "H",
"contents": "{\"type\":\"CAROUSEL\",\"message\":\"์บ๋ฌ์
+ ๋ฐ๋ก ์ฐ๊ฒฐ\",\"isLocked\":false,\"quickReplyList\":[{\"type\":\"TEXT\",\"name\":\"์ฑ๋ด ๋ฐํ ๋ฒํผ\"},{\"type\":\"WEB_LINK\",\"name\":\"๋งํฌ ๋ฒํผ\",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\"}],\"carouselBlocks\":[{\"header\":\"์ผ๋ฌ์
1๋ฒ ํค๋\",\"message\":\"์ผ๋ฌ์
1๋ฒ ๋ฉ์์ง\",\"image\":{\"imageUrl\":\"https:\\/\\/patch.happytalk.io\\/data\\/template\\/1000225100\\/1000225100_a8533563f0b5a28bae97055849958062_w.jpg\"},\"buttonList\":[{\"type\":\"TEXT\",\"name\":\"์ฑ๋ด ๋ฐํ ๋ฒํผ\"},{\"type\":\"WEB_LINK\",\"name\":\"๋งํฌ ๋ฒํผ\",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\"}],\"coupon\":{\"name\":\"10% ํ ์ธ ์ฟ ํฐ\",\"description\":\"์ ๊ท ๊ณ ๊ฐ ํ์ \",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\",\"schemaAOS\":\"https:\\/\\/www.happytalk.io\",\"schemaIOS\":\"https:\\/\\/www.happytalk.io\"}},{\"header\":\"์ผ๋ฌ์
2๋ฒ ํค๋\",\"message\":\"์ผ๋ฌ์
2๋ฒ ๋ฉ์์ง\",\"image\":{\"imageUrl\":\"https:\\/\\/dev.happytalk.io\\/data\\/template\\/1000225100\\/1000225100_a8533563f0b5a28bae97055849958062_w.jpg\"},\"buttonList\":[{\"type\":\"TEXT\",\"name\":\"์ฑ๋ด ๋ฐํ ๋ฒํผ\"},{\"type\":\"WEB_LINK\",\"name\":\"๋งํฌ ๋ฒํผ\",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\"}],\"coupon\":{\"name\":\"10% ํ ์ธ ์ฟ ํฐ\",\"description\":\"์ ๊ท ๊ณ ๊ฐ ํ์ \",\"pcUrl\":\"https:\\/\\/www.happytalk.io\",\"mobileUrl\":\"https:\\/\\/www.happytalk.io\",\"schemaAOS\":\"https:\\/\\/www.happytalk.io\",\"schemaIOS\":\"https:\\/\\/www.happytalk.io\"}}]}",
"contents_type": "template",
"status": "1",
"counterpart_status": "1",
"send_date": "2025-10-25 11:43:09",
"receive_date": null,
"read_date": "2025-10-25 11:43:09",
"fail_date": null,
"msg_id": "c84328d7-ac4c-47fe-bf1b-c831a048a93a",
"seq": null,
"is_today_first_counsel": "0"
}
JavaScript
๋ณต์ฌ
Data Dictionary
Request Dictionary
None
Response Dictionary
type
user_type
contents_type
Type | Description |
C | ์ฑํ
|
M | ๋ฉ๋ชจ |


