Visitors: Crisp Visitors
read only
- Catalogue :
Crisp - Schéma :
Views - Label: Visitors
Permet uniquement de récupérer des données.
Colonnes de table
Les colonnes de la table Visitors sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | 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. |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :