Visitors: Crisp Visitors
read only
- Catalog:
Crisp - Schema:
Views - Label: Visitors
Can only retrieve data.
Table Columns
The columns of the table Visitors 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 |
|---|---|---|---|---|---|
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. |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: