invantive documentation
Invantive SupportforenAnmelden / Eintragen

Visitors: Crisp Visitors

read only

  • Katalog: Crisp
  • Schema: Views
  • Label: Visitors

Es können nur Daten abgerufen werden.

Tabellenspalten

Die Spalten der Tabelle Visitors sind unten aufgeführt. Jede Spalte hat einen SQL-Datentyp. Beim Einfügen und Aktualisieren muss für jede erforderliche Spalte jederzeit ein neuer Wert angegeben werden der nicht Null ist.

Name Datentyp 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.

Anmerkungen zu dieser Version

Was hat sich in den Tabellen, Spalten, Attributen und Funktionen des Treibers mit jeder neuen Version geändert: