invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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_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.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: