invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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_city varchar2 itgen_crp_geolocation_city filters on the platform, writable City name.
geolocation_coordinates_latitude decimal itgen_crp_geolocation_coordinates_latitude filters on the platform, writable Latitude coordinate.
geolocation_coordinates_longitude decimal itgen_crp_geolocation_coordinates_longitude filters on the platform, writable Longitude coordinate.
geolocation_country varchar2 itgen_crp_geolocation_country filters on the platform, writable Country code.
geolocation_region varchar2 itgen_crp_geolocation_region filters on the platform, writable Region code.
inbox_id 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_page_title varchar2 itgen_crp_last_page_title filters on the platform, writable Title of the last page browsed.
last_page_url 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_id 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: