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 Column Description
ACCLOGMAIN_ID BIGINT
NOT NULL
The primary key.
HOSTNAME VARCHAR (64)
NULL
The name of the host where the request originated.
STOREENT_ID INTEGER
NOT NULL
The ID of the store as specified in the request.
THREADID VARCHAR (32)
NULL
The ID of the thread in which the request was handled.
USERS_ID BIGINT
NOT NULL
The ID of the user executing the request.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034826340 ACCLOGMAIN_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_15 STOREENT_ID STOREENT STOREENT_ID Cascade
F_16 USERS_ID USERS USERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_18 ACCLOGMAIN_ID ACCLOGSUB ACCLOGMAIN_ID Cascade