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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034826340 | ACCLOGMAIN_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_18 | ACCLOGMAIN_ID | ACCLOGSUB | ACCLOGMAIN_ID | Cascade |