ConversationFiles: Crisp Conversation Files
read only
- Catalog:
Crisp - Schema:
Views - Label: Conversation Files
Can only retrieve data.
Table Columns
The columns of the table ConversationFiles are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
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). | |
fingerprint |
int64 |
itgen_crp_fingerprint | filters on the platform, writable | Unique fingerprint of the message holding the file. | |
name |
varchar2 |
itgen_crp_name | filters on the platform, writable | File name. | |
session_ |
varchar2 |
itgen_crp_session_id | filters on the platform, writable | Session identifier. | |
timestamp |
datetime |
itgen_crp_timestamp | filters on the platform, writable | Timestamp at which the message holding the file was sent. | |
type |
varchar2 |
itgen_crp_type | filters on the platform, writable | File MIME type. | |
url |
varchar2 |
itgen_crp_url | filters on the platform, writable | File URL. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: