ConversationFiles: Crisp Conversation Files
read only
- Katalog:
Crisp - Schema:
Views - Label: Conversation Files
Es können nur Daten abgerufen werden.
Tabellenspalten
Die Spalten der Tabelle ConversationFiles 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 |
|---|---|---|---|---|---|
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. |
Anmerkungen zu dieser Version
Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: