Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACCLOGMAIN
This table contains information about access violation. Entries are created only if a violation has occurred. There will only be one entry per request. Detailed information is stored in the ACCLOGSUB table.
Column Name Column Type Description ACCLOGMAIN_ID BIGINT NOT NULL The primary key. THREADID VARCHAR(32) The ID of the thread in which the request was handled. HOSTNAME VARCHAR(64) The name of the host where the request originated. STOREENT_ID INTEGER NOT NULL The ID of the store as specified in 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 SQL100520030251570 ACCLOGMAIN_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_18 ACCLOGMAIN_ID ACCLOGSUB ACCLOGMAIN_ID Cascade
Related reference
_vcc_freeselect_bottom_