User Traffic table stores data about the visitors of your stores.
Column Name | Column Type | Column Description |
---|---|---|
BRAGENT | VARCHAR (254) NULL |
Contains information about the user agent originating the URL request. |
CATENTRY_ID | BIGINT NULL |
The catalog entry that is used in this request. |
CATGROUP_ID | BIGINT NULL |
The catalog group involved with the request. |
CLIMETH | CHARACTER (8) NULL |
The HTTP method to be performed on the resource obtained from the Http
Servlet Request. It is the name of HTTP method with which this request was
made. Valid values include: GET, POST, or PUT. |
HTTPS | CHARACTER (1) NULL |
"1" indicates whether HTTPS is used; "0" indicates that HTTP is used. |
PATHINFO | VARCHAR (254) NULL |
Any extra path information associated with the URL the client sent when it made the URL request. |
PREVURL | VARCHAR (254) NULL |
Previous URL. |
QUERYSTRING | VARCHAR (4000) NULL |
The query string that is contained in the request URL after the path. |
REDIR | VARCHAR (254) NULL |
The URL of the Web page that the user was redirected to, if the command resulted in a redirection. In order to complete the current interaction, the user-agent has to fulfill the request described by redirection URL. |
REFURL | VARCHAR (254) NULL |
Referral URL from another site. |
REMADDR | VARCHAR (254) NULL |
The Internet Protocol (IP) address of the client that sent the request. |
RESULT | CHARACTER (1) NULL |
"1" if the HTTP interaction was successful, "0" otherwise. |
SCRIPT | VARCHAR (64) NULL |
The part of this request's URL that calls the servlet. |
SERVNAME | VARCHAR (64) NULL |
The host name of the server that received the request. |
SESSIONID | CHARACTER (64) NULL |
The unique identifier of the session. |
SHLUSTMP | TIMESTAMP NULL |
The last time the customer logged in when the request was made. |
STMP | TIMESTAMP NULL |
The time when the current user traffic record is created. |
STORE_ID | INTEGER NULL |
The store involved with this request. |
USERS_ID | BIGINT NULL |
The identifier of the user that issued the HTTP interaction. |
USRTRAFFIC_ID | BIGINT NOT NULL |
Internal generated reference ID. |
VIEWTASK | VARCHAR (32) NULL |
The error or view command name that is used to display the result page to the user, if any. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000261 | USRTRAFFIC_ID, STMP | Non-Unique Index |
SQL030416035142600 | USRTRAFFIC_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_899 | USERS_ID | USERS | USERS_ID | Cascade |
F_936 | STORE_ID | STORE | STORE_ID | Cascade |
F_937 | CATGROUP_ID | CATGROUP | CATGROUP_ID | Cascade |
F_938 | CATENTRY_ID | CATENTRY | CATENTRY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_900 | USRTRAFFIC_ID | UTMERINFO | UTMERREF | Cascade |