Visitors: Crisp Visitors
read only
- Catalogo:
Crisp - Schema:
Views - Label: Visitors
È possibile solo recuperare i dati.
Colonne della tabella
Di seguito sono riportate le colonne della tabella Visitors. 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 |
|---|---|---|---|---|---|
active |
char |
itgen_crp_active | filters on the platform, writable | Whether the visitor is actively browsing or not. | |
avatar |
varchar2 |
itgen_crp_avatar | filters on the platform, writable | Avatar of the visitor. | |
email |
varchar2 |
itgen_crp_email | filters on the platform, writable | Email of the visitor. | |
geolocation_ |
varchar2 |
itgen_crp_geolocation_city | filters on the platform, writable | City name. | |
geolocation_ |
decimal |
itgen_crp_geolocation_coordinates_latitude | filters on the platform, writable | Latitude coordinate. | |
geolocation_ |
decimal |
itgen_crp_geolocation_coordinates_longitude | filters on the platform, writable | Longitude coordinate. | |
geolocation_ |
varchar2 |
itgen_crp_geolocation_country | filters on the platform, writable | Country code. | |
geolocation_ |
varchar2 |
itgen_crp_geolocation_region | filters on the platform, writable | Region code. | |
inbox_ |
varchar2 |
itgen_crp_inbox_id | filters on the platform, writable | Inbox identifier of the visitor (if any). | |
initiated |
char |
itgen_crp_initiated | filters on the platform, writable | Whether the session is initiated or not. | |
last_ |
varchar2 |
itgen_crp_last_page_title | filters on the platform, writable | Title of the last page browsed. | |
last_ |
varchar2 |
itgen_crp_last_page_url | filters on the platform, writable | URL of the last page browsed. | |
nickname |
varchar2 |
itgen_crp_nickname | filters on the platform, writable | Nickname of the visitor. | |
session_ |
varchar2 |
itgen_crp_session_id | filters on the platform, writable | Session identifier of the visitor. | |
timezone |
int32 |
itgen_crp_timezone | filters on the platform, writable | Time zone offset of the visitor in minutes relative to UTC, negated (-120 stands for UTC+02:00). | |
useragent |
varchar2 |
itgen_crp_useragent | filters on the platform, writable | User agent as advertised by the browser of the visitor. |
Note di rilascio
Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: