ConversationMessages: Crisp Conversation Messages
read only
- Catalogo:
Crisp - Schema:
Views - Label: Conversation Messages
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella ConversationMessages. Ogni colonna ha un tipo di dati SQL. Un nuovo valore non nullo deve essere fornito per ogni colonna richiesta in ogni momento durante l'inserimento e l'aggiornamento.
| Name | Tipo di dati | 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. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: