Conversations: Crisp Conversations
read only
- Catálogo:
Crisp - Esquema:
Views - Label: Conversations
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla Conversations. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
active_ |
datetime |
itgen_crp_active_last | filters on the platform, writable | Timestamp at which the user was last active. | |
active_ |
char |
itgen_crp_active_now | filters on the platform, writable | Whether user is considered active right now or not. | |
assigned_ |
varchar2 |
itgen_crp_assigned_user_id | filters on the platform, writable | Operator user identifier. | |
availability |
varchar2 |
itgen_crp_availability | filters on the platform, writable | Visitor availability; one of online and offline. | |
compose_ |
char |
itgen_crp_compose_operator_automated | filters on the platform, writable | Whether compose is automated or not (ie. comes from a bot). | |
compose_ |
varchar2 |
itgen_crp_compose_operator_excerpt | filters on the platform, writable | Message excerpt for compose state. | |
compose_ |
datetime |
itgen_crp_compose_operator_timestamp | filters on the platform, writable | Timestamp for compose state. | |
compose_ |
varchar2 |
itgen_crp_compose_operator_type | filters on the platform, writable | Compose state type; one of start and stop. | |
compose_ |
varchar2 |
itgen_crp_compose_operator_user_avatar | filters on the platform, writable | Compose user avatar. | |
compose_ |
varchar2 |
itgen_crp_compose_operator_user_nickname | filters on the platform, writable | Compose user nickname. | |
compose_ |
varchar2 |
itgen_crp_compose_operator_user_user_id | filters on the platform, writable | Compose user identifier. | |
compose_ |
char |
itgen_crp_compose_visitor_automated | filters on the platform, writable | Whether compose is automated or not (ie. comes from a bot). | |
compose_ |
varchar2 |
itgen_crp_compose_visitor_excerpt | filters on the platform, writable | Message excerpt for compose state. | |
compose_ |
datetime |
itgen_crp_compose_visitor_timestamp | filters on the platform, writable | Timestamp for compose state. | |
compose_ |
varchar2 |
itgen_crp_compose_visitor_type | filters on the platform, writable | Compose state type; one of start and stop. | |
created_ |
datetime |
itgen_crp_created_at | filters on the platform, writable | Conversation creation timestamp. | |
inbox_ |
varchar2 |
itgen_crp_inbox_id | filters on the platform, writable | Inbox identifier. | |
is_ |
char |
itgen_crp_is_blocked | filters on the platform, writable | Whether session is blocked or not (block messages from visitor). | |
is_ |
char |
itgen_crp_is_verified | filters on the platform, writable | Whether session is verified or not (user email ownership is authenticated). | |
last_ |
varchar2 |
itgen_crp_last_message | filters on the platform, writable | Last message excerpt (from visitor). | |
meta_ |
varchar2 |
itgen_crp_meta_address | filters on the platform, writable | Visitor address. | |
meta_ |
varchar2 |
itgen_crp_meta_avatar | filters on the platform, writable | Visitor avatar. | |
meta_ |
varchar2 |
itgen_crp_meta_connection_asn | filters on the platform, writable | Autonomous system number, derived by Crisp from the IP address. | |
meta_ |
varchar2 |
itgen_crp_meta_connection_isp | filters on the platform, writable | Name of the internet service provider, derived by Crisp from the IP address. | |
meta_ |
varchar2 |
itgen_crp_meta_data | filters on the platform, writable | Visitor data as JSON. | |
meta_ |
varchar2 |
itgen_crp_meta_device_geolocation_city | filters on the platform, writable | City name. | |
meta_ |
decimal |
itgen_crp_meta_device_geolocation_coordinates_latitude | filters on the platform, writable | Latitude coordinate. | |
meta_ |
decimal |
itgen_crp_meta_device_geolocation_coordinates_longitude | filters on the platform, writable | Longitude coordinate. | |
meta_ |
varchar2 |
itgen_crp_meta_device_geolocation_country | filters on the platform, writable | Country code. | |
meta_ |
varchar2 |
itgen_crp_meta_device_geolocation_region | filters on the platform, writable | Region code. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_browser_major | filters on the platform, writable | Browser major version (eg: version 8.1 has a major of 8). | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_browser_name | filters on the platform, writable | Browser name. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_browser_version | filters on the platform, writable | Browser version. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_engine_name | filters on the platform, writable | Engine name. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_engine_version | filters on the platform, writable | Engine version. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_os_name | filters on the platform, writable | OS name. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_os_version | filters on the platform, writable | OS version. | |
meta_ |
varchar2 |
itgen_crp_meta_device_system_useragent | filters on the platform, writable | Visitor user agent. | |
meta_ |
int32 |
itgen_crp_meta_device_timezone | filters on the platform, writable | Visitor device time zone offset in minutes relative to UTC, negated (-120 stands for UTC+02:00). | |
meta_ |
varchar2 |
itgen_crp_meta_email | filters on the platform, writable | Visitor email. | |
meta_ |
varchar2 |
itgen_crp_meta_ip | filters on the platform, writable | Visitor IP address. | |
meta_ |
varchar2 |
itgen_crp_meta_nickname | filters on the platform, writable | Visitor nickname. | |
meta_ |
varchar2 |
itgen_crp_meta_origin | filters on the platform, writable | Conversation origin; chat, email or a URN of the channel used. | |
meta_ |
varchar2 |
itgen_crp_meta_phone | filters on the platform, writable | Visitor phone. | |
meta_ |
varchar2 |
itgen_crp_meta_subject | filters on the platform, writable | Subject for conversation (if any). | |
people_ |
varchar2 |
itgen_crp_people_id | filters on the platform, writable | People identifier. | |
preview_ |
varchar2 |
itgen_crp_preview_message_excerpt | filters on the platform, writable | Preview message excerpt. | |
preview_ |
int64 |
itgen_crp_preview_message_fingerprint | filters on the platform, writable | Preview message fingerprint. | |
preview_ |
varchar2 |
itgen_crp_preview_message_from | filters on the platform, writable | Preview message sender; one of user and operator. | |
preview_ |
varchar2 |
itgen_crp_preview_message_type | filters on the platform, writable | Preview message type. | |
session_ |
varchar2 |
itgen_crp_session_id | filters on the platform, writable | Session identifier. | |
state |
varchar2 |
itgen_crp_state | filters on the platform, writable | Conversation state; one of pending, unresolved and resolved. | |
status |
int32 |
itgen_crp_status | filters on the platform, writable | Conversation status (a numeric alias of the state; useful for sorting conversations). | |
topic |
varchar2 |
itgen_crp_topic | filters on the platform, writable | Topic for conversation (based on messages). | |
unread_ |
int32 |
itgen_crp_unread_operator | filters on the platform, writable | Unread messages counter for operator. | |
unread_ |
int32 |
itgen_crp_unread_visitor | filters on the platform, writable | Unread messages counter for visitor. | |
updated_ |
datetime |
itgen_crp_updated_at | filters on the platform, writable | Conversation update timestamp. | |
waiting_ |
datetime |
itgen_crp_waiting_since | filters on the platform, writable | Conversation waiting since timestamp (if any). | |
website_ |
varchar2 |
itgen_crp_website_id | filters on the platform, writable | Website identifier. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: