---
title: "Conversations (Crisp)"
description: "Conversations"
language: de
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/de/datamodels/crisp/Crisp.Views.Conversations
original: https://documentation.invantive.eu/en/datamodels/crisp/Crisp.Views.Conversations
updated: 2026-11-16T20:43:46Z
license: https://documentation.invantive.eu/de/
---

# Conversations: Crisp Conversations

`read only`

- Katalog: `Crisp`
- Schema: `Views`
- Label: Conversations

Es können nur Daten abgerufen werden.

## Tabellenspalten

Die Spalten der Tabelle `Conversations` 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 |
|---|---|---|:---:|---|---|
| `active_last` | `datetime` | itgen_crp_active_last | [ ] | filters on the platform, writable | Timestamp at which the user was last active. |
| `active_now` | `char` | itgen_crp_active_now | [x] | filters on the platform, writable | Whether user is considered active right now or not. |
| `assigned_user_id` | `varchar2` | itgen_crp_assigned_user_id | [ ] | filters on the platform, writable | Operator user identifier. |
| `availability` | `varchar2` | itgen_crp_availability | [x] | filters on the platform, writable | Visitor availability; one of online and offline. |
| `compose_operator_automated` | `char` | itgen_crp_compose_operator_automated | [ ] | filters on the platform, writable | Whether compose is automated or not (ie. comes from a bot). |
| `compose_operator_excerpt` | `varchar2` | itgen_crp_compose_operator_excerpt | [ ] | filters on the platform, writable | Message excerpt for compose state. |
| `compose_operator_timestamp` | `datetime` | itgen_crp_compose_operator_timestamp | [ ] | filters on the platform, writable | Timestamp for compose state. |
| `compose_operator_type` | `varchar2` | itgen_crp_compose_operator_type | [ ] | filters on the platform, writable | Compose state type; one of start and stop. |
| `compose_operator_user_avatar` | `varchar2` | itgen_crp_compose_operator_user_avatar | [ ] | filters on the platform, writable | Compose user avatar. |
| `compose_operator_user_nickname` | `varchar2` | itgen_crp_compose_operator_user_nickname | [ ] | filters on the platform, writable | Compose user nickname. |
| `compose_operator_user_user_id` | `varchar2` | itgen_crp_compose_operator_user_user_id | [ ] | filters on the platform, writable | Compose user identifier. |
| `compose_visitor_automated` | `char` | itgen_crp_compose_visitor_automated | [ ] | filters on the platform, writable | Whether compose is automated or not (ie. comes from a bot). |
| `compose_visitor_excerpt` | `varchar2` | itgen_crp_compose_visitor_excerpt | [ ] | filters on the platform, writable | Message excerpt for compose state. |
| `compose_visitor_timestamp` | `datetime` | itgen_crp_compose_visitor_timestamp | [ ] | filters on the platform, writable | Timestamp for compose state. |
| `compose_visitor_type` | `varchar2` | itgen_crp_compose_visitor_type | [ ] | filters on the platform, writable | Compose state type; one of start and stop. |
| `created_at` | `datetime` | itgen_crp_created_at | [x] | filters on the platform, writable | Conversation creation timestamp. |
| `inbox_id` | `varchar2` | itgen_crp_inbox_id | [ ] | filters on the platform, writable | Inbox identifier. |
| `is_blocked` | `char` | itgen_crp_is_blocked | [x] | filters on the platform, writable | Whether session is blocked or not (block messages from visitor). |
| `is_verified` | `char` | itgen_crp_is_verified | [ ] | filters on the platform, writable | Whether session is verified or not (user email ownership is authenticated). |
| `last_message` | `varchar2` | itgen_crp_last_message | [ ] | filters on the platform, writable | Last message excerpt (from visitor). |
| `meta_address` | `varchar2` | itgen_crp_meta_address | [ ] | filters on the platform, writable | Visitor address. |
| `meta_avatar` | `varchar2` | itgen_crp_meta_avatar | [ ] | filters on the platform, writable | Visitor avatar. |
| `meta_connection_asn` | `varchar2` | itgen_crp_meta_connection_asn | [ ] | filters on the platform, writable | Autonomous system number, derived by Crisp from the IP address. |
| `meta_connection_isp` | `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_data` | `varchar2` | itgen_crp_meta_data | [ ] | filters on the platform, writable | Visitor data as JSON. |
| `meta_device_geolocation_city` | `varchar2` | itgen_crp_meta_device_geolocation_city | [ ] | filters on the platform, writable | City name. |
| `meta_device_geolocation_coordinates_latitude` | `decimal` | itgen_crp_meta_device_geolocation_coordinates_latitude | [ ] | filters on the platform, writable | Latitude coordinate. |
| `meta_device_geolocation_coordinates_longitude` | `decimal` | itgen_crp_meta_device_geolocation_coordinates_longitude | [ ] | filters on the platform, writable | Longitude coordinate. |
| `meta_device_geolocation_country` | `varchar2` | itgen_crp_meta_device_geolocation_country | [ ] | filters on the platform, writable | Country code. |
| `meta_device_geolocation_region` | `varchar2` | itgen_crp_meta_device_geolocation_region | [ ] | filters on the platform, writable | Region code. |
| `meta_device_system_browser_major` | `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_device_system_browser_name` | `varchar2` | itgen_crp_meta_device_system_browser_name | [ ] | filters on the platform, writable | Browser name. |
| `meta_device_system_browser_version` | `varchar2` | itgen_crp_meta_device_system_browser_version | [ ] | filters on the platform, writable | Browser version. |
| `meta_device_system_engine_name` | `varchar2` | itgen_crp_meta_device_system_engine_name | [ ] | filters on the platform, writable | Engine name. |
| `meta_device_system_engine_version` | `varchar2` | itgen_crp_meta_device_system_engine_version | [ ] | filters on the platform, writable | Engine version. |
| `meta_device_system_os_name` | `varchar2` | itgen_crp_meta_device_system_os_name | [ ] | filters on the platform, writable | OS name. |
| `meta_device_system_os_version` | `varchar2` | itgen_crp_meta_device_system_os_version | [ ] | filters on the platform, writable | OS version. |
| `meta_device_system_useragent` | `varchar2` | itgen_crp_meta_device_system_useragent | [ ] | filters on the platform, writable | Visitor user agent. |
| `meta_device_timezone` | `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_email` | `varchar2` | itgen_crp_meta_email | [ ] | filters on the platform, writable | Visitor email. |
| `meta_ip` | `varchar2` | itgen_crp_meta_ip | [ ] | filters on the platform, writable | Visitor IP address. |
| `meta_nickname` | `varchar2` | itgen_crp_meta_nickname | [ ] | filters on the platform, writable | Visitor nickname. |
| `meta_origin` | `varchar2` | itgen_crp_meta_origin | [ ] | filters on the platform, writable | Conversation origin; chat, email or a URN of the channel used. |
| `meta_phone` | `varchar2` | itgen_crp_meta_phone | [ ] | filters on the platform, writable | Visitor phone. |
| `meta_subject` | `varchar2` | itgen_crp_meta_subject | [ ] | filters on the platform, writable | Subject for conversation (if any). |
| `people_id` | `varchar2` | itgen_crp_people_id | [ ] | filters on the platform, writable | People identifier. |
| `preview_message_excerpt` | `varchar2` | itgen_crp_preview_message_excerpt | [ ] | filters on the platform, writable | Preview message excerpt. |
| `preview_message_fingerprint` | `int64` | itgen_crp_preview_message_fingerprint | [ ] | filters on the platform, writable | Preview message fingerprint. |
| `preview_message_from` | `varchar2` | itgen_crp_preview_message_from | [ ] | filters on the platform, writable | Preview message sender; one of user and operator. |
| `preview_message_type` | `varchar2` | itgen_crp_preview_message_type | [ ] | filters on the platform, writable | Preview message type. |
| `session_id` | `varchar2` | itgen_crp_session_id | [x] | filters on the platform, writable | Session identifier. |
| `state` | `varchar2` | itgen_crp_state | [x] | filters on the platform, writable | Conversation state; one of pending, unresolved and resolved. |
| `status` | `int32` | itgen_crp_status | [x] | 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_operator` | `int32` | itgen_crp_unread_operator | [x] | filters on the platform, writable | Unread messages counter for operator. |
| `unread_visitor` | `int32` | itgen_crp_unread_visitor | [x] | filters on the platform, writable | Unread messages counter for visitor. |
| `updated_at` | `datetime` | itgen_crp_updated_at | [x] | filters on the platform, writable | Conversation update timestamp. |
| `waiting_since` | `datetime` | itgen_crp_waiting_since | [ ] | filters on the platform, writable | Conversation waiting since timestamp (if any). |
| `website_id` | `varchar2` | itgen_crp_website_id | [x] | 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:

- [Crisp](/de/release-notes/drivers?driver=crisp)
