visitor: Odoo itgen_odoo_visitor
read only per partition
- Catalog:
Odoo - Schema:
website - Label: itgen_odoo_visitor
Website Visitor
Can only retrieve data.
Table Columns
The columns of the table visitor are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
access_ |
varchar2 |
Access Token | |||
country_ |
varchar2 |
Country Flag | Url of static flag image | ||
country_ |
varchar2 |
||||
country_ |
varchar2 |
||||
create_ |
datetime |
First Connection | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
display_ |
varchar2 |
Display Name | |||
email |
varchar2 |
||||
event_ |
varchar2 |
||||
event_ |
int32 |
# Registrations | |||
event_ |
varchar2 |
||||
has_ |
boolean |
Push Notifications Enabled | |||
id |
int32 |
ID | |||
is_ |
boolean |
Is connected ? | A visitor is considered as connected if his last page view was within the last 5 minutes. | ||
lang_ |
varchar2 |
Language from the website when visitor has been created | |||
lang_ |
varchar2 |
Language from the website when visitor has been created | |||
last_ |
datetime |
Last Connection | Last page view date | ||
last_ |
varchar2 |
||||
last_ |
varchar2 |
||||
lead_ |
int32 |
# Leads | |||
lead_ |
varchar2 |
||||
livechat_ |
varchar2 |
||||
livechat_ |
varchar2 |
||||
livechat_ |
varchar2 |
Operator Name | |||
mail_ |
varchar2 |
||||
mobile |
varchar2 |
Mobile | |||
name |
varchar2 |
Name | |||
page_ |
int32 |
# Visited Pages | Total number of tracked page visited | ||
page_ |
varchar2 |
||||
partner_ |
varchar2 |
Partner of the last logged in user. | |||
partner_ |
varchar2 |
Partner of the last logged in user. | |||
partner_ |
varbinary |
Image | |||
product_ |
int32 |
Products Views | Total number of product viewed | ||
product_ |
varchar2 |
||||
push_ |
varchar2 |
||||
session_ |
int32 |
# Sessions | |||
time_ |
varchar2 |
Last action | Time since last page view. E.g.: 2 minutes ago | ||
timezone |
varchar2 |
Timezone | |||
visit_ |
int32 |
# Visits | A new visit is considered if last connection was more than 8 hours ago. | ||
visitor_ |
int32 |
Page Views | Total number of visits on tracked pages | ||
visitor_ |
int32 |
Product Views | Total number of views on products | ||
website_ |
varchar2 |
||||
website_ |
varchar2 |
||||
website_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: