Database Table: USRTRAFFIC

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000261 USRTRAFFIC_ID, STMP Non-Unique Index
SQL030416035142600 USRTRAFFIC_ID Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_900 USRTRAFFIC_ID UTMERINFO UTMERREF Cascade