| USRTRAFFIC_ID | BIGINT NOT NULL | Internal generated reference ID. |
| SHLUSTMP | TIMESTAMP | The last time the customer logged in when the
request was made. |
| USERS_ID | BIGINT | The identifier of the user that issued the HTTP
interaction. |
| STMP | TIMESTAMP | The time when the current user traffic record is
created. |
| REMADDR | VARCHAR (254) | The Internet Protocol (IP) address of the client
that sent the request. |
| CLIMETH | CHAR (8) | 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 are
as follows:
|
| SERVNAME | VARCHAR (64) | The host name of the server that received the
request. |
| SCRIPT | VARCHAR (64) | The part of this request's URL that calls the
servlet. |
| PATHINFO | VARCHAR (254) | Any extra path information associated with the
URL the client sent when it made the URL request. |
| QUERYSTRING | VARCHAR (4000) | The query string that is contained in the request
URL after the path. |
| BRAGENT | VARCHAR (254) | Contains information about the user agent
originating the URL request. |
| REFURL | VARCHAR (254) | Referral URL from another site. |
| HTTPS | CHAR (1) | Indicator for whether the site is secure. Valid
values are as follows:
- 1=the site is secure and HTTPS is used
- 0=the site is not secure and HTTP is used
|
| RESULT | CHAR (1) | Indicator of whether or not this is a secure
interaction. Valid values are as follows:
- 1=the HTTP interaction was successful
- 0=the HTTP interaction was unsuccessful
|
| REDIR | VARCHAR (254) | 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. |
| VIEWTASK | VARCHAR (32) | The error or view command name that is used to
display the result page to the user, if any. |
| PREVURL | VARCHAR (254) | The previous URL, if used. |
| SESSIONID | CHAR (64) | The unique identifier of the session. |
| STORE_ID | INTEGER | The store involved with this request. |
| CATGROUP_ID | BIGINT | The catalog group involved with the request. |
| CATENTRY_ID | BIGINT | The catalog entry that is used in this
request. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |