Visitors: Crisp Visitors
read only
- Catálogo:
Crisp - Esquema:
Views - Label: Visitors
Solo puede recuperar datos.
Columnas de la Tabla
A continuación se muestran las columnas de la tabla Visitors. Cada columna tiene un tipo de datos SQL. Se debe proporcionar un nuevo valor no nulo para cada columna requerida en todo momento durante la inserción y la actualización.
| Name | Tipo de Datos | 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. |
Notas de la Versión
Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: