ConversationMessages: Crisp Conversation Messages
read only
- Katalog:
Crisp - Schema:
Views - Label: Conversation Messages
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle ConversationMessages sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.
| Name | Datentyp | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
automated |
char |
itgen_crp_automated | filters on the platform, writable | Whether the message is automated or not (ie. comes from a bot). | |
content |
varchar2 |
itgen_crp_content | filters on the platform, writable | Message content; the text itself for the types text and note, otherwise the content object as JSON. | |
content_ |
int32 |
itgen_crp_content_duration | filters on the platform, writable | Object duration in seconds (only set for the type audio). | |
content_ |
varchar2 |
itgen_crp_content_explain | filters on the platform, writable | Object explanatory text (only set for the type field). | |
content_ |
varchar2 |
itgen_crp_content_id | filters on the platform, writable | Object identifier (only set for the types picker and field). | |
content_ |
varchar2 |
itgen_crp_content_name | filters on the platform, writable | Object name (only set for the type file). | |
content_ |
varchar2 |
itgen_crp_content_namespace | filters on the platform, writable | Event namespace (only set for the type event). | |
content_ |
char |
itgen_crp_content_required | filters on the platform, writable | Whether the message must be filled before continuing (only set for the types picker and field). | |
content_ |
varchar2 |
itgen_crp_content_text | filters on the platform, writable | Object text (only set for the types picker, field, carousel and event). | |
content_ |
varchar2 |
itgen_crp_content_type | filters on the platform, writable | Object MIME type (only set for the types file, animation and audio). | |
content_ |
varchar2 |
itgen_crp_content_url | filters on the platform, writable | Object URL (only set for the types file, animation and audio). | |
content_ |
varchar2 |
itgen_crp_content_value | filters on the platform, writable | Object value (only set for the type field). | |
conversation_ |
datetime |
itgen_crp_active_last | filters on the platform, writable, conversation_ |
Timestamp at which the user was last active. | |
conversation_ |
datetime |
itgen_crp_created_at | filters on the platform, writable, conversation_ |
Conversation creation timestamp. | |
conversation_ |
varchar2 |
itgen_crp_topic | filters on the platform, writable, conversation_ |
Topic for conversation (based on messages). | |
conversation_ |
datetime |
itgen_crp_updated_at | filters on the platform, writable, conversation_ |
Conversation update timestamp. | |
conversation_ |
datetime |
itgen_crp_waiting_since | filters on the platform, writable, conversation_ |
Conversation waiting since timestamp (if any). | |
delivered |
varchar2 |
itgen_crp_delivered | filters on the platform, writable | Channel in which the message has last been delivered (can be blank). | |
edited |
char |
itgen_crp_edited | filters on the platform, writable | Whether the message was edited after being sent or not. | |
fingerprint |
int64 |
itgen_crp_fingerprint | filters on the platform, writable | Unique message fingerprint. | |
from |
varchar2 |
itgen_crp_from | filters on the platform, writable | Message sender; one of user and operator. | |
origin |
varchar2 |
itgen_crp_origin | filters on the platform, writable | Message origin; chat, email or a URN of the channel used. | |
original_ |
varchar2 |
itgen_crp_original_id | filters on the platform, writable | Identifier of the original message as held by the channel it arrived on (if any). | |
properties |
varchar2 |
itgen_crp_properties | filters on the platform, writable | Arbitrary properties set on the message as JSON (if any). | |
read |
varchar2 |
itgen_crp_read | filters on the platform, writable | Channel in which the message has been read (can be blank). | |
session_ |
varchar2 |
itgen_crp_session_id | filters on the platform, writable | Session identifier. | |
stamped |
char |
itgen_crp_stamped | filters on the platform, writable | Whether the message was fully processed in the internal Crisp pipeline. | |
timestamp |
datetime |
itgen_crp_timestamp | filters on the platform, writable | Timestamp at which the message was sent. | |
translated |
char |
itgen_crp_translated | filters on the platform, writable | Whether the message was automatically translated or not. | |
type |
varchar2 |
itgen_crp_type | filters on the platform, writable | Message type; one of text, note, file, animation, audio, picker, field, carousel and event. | |
user_ |
varchar2 |
itgen_crp_user_avatar | filters on the platform, writable | Sending user avatar. | |
user_ |
varchar2 |
itgen_crp_user_nickname | filters on the platform, writable | Sending user nickname. | |
user_ |
varchar2 |
itgen_crp_user_type | filters on the platform, writable | Sending user type; one of website and participant. | |
user_ |
varchar2 |
itgen_crp_user_user_id | filters on the platform, writable | Sending user identifier; an operator user identifier or a session identifier. | |
website_ |
varchar2 |
itgen_crp_website_id | filters on the platform, writable | Website identifier. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: