---
title: "Visitors (Crisp)"
description: "Visitors"
language: fr
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/fr/datamodels/crisp/Crisp.Views.Visitors
original: https://documentation.invantive.eu/en/datamodels/crisp/Crisp.Views.Visitors
updated: 2026-11-16T20:44:09Z
license: https://documentation.invantive.eu/fr/
---

# 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_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 | [x] | 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 :

- [Crisp](/fr/release-notes/drivers?driver=crisp)
