Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACCLOGSUB

This table contains detailed information of the request causing access violation. The entries are linked to the ACCLOGMAIN table.

Column Name Column Type Description
ACCLOGSUB_ID BIGINT NOT NULL The primary key.
ACCLOGMAIN_ID BIGINT NOT NULL Foreign key to the ACCLOGMAIN table.
LOGTIME TIMESTAMP The time the access violation occurred.
ACTION VARCHAR(254) A description of what the request tried to do.
RESULT VARCHAR(254) The result of the access control check.
RESOURCES VARCHAR(254) The resources accessed by the request.
USERS_ID BIGINT NOT NULL The ID of the user executing the request.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030251710 ACCLOGSUB_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_18 ACCLOGMAIN_ID ACCLOGMAIN ACCLOGMAIN_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search