LikeMinds event information. This information is also stored in the LikeMinds server database.
Column Name | Column Type | Column Description |
---|---|---|
EXTEVENTDESC | VARCHAR (254) NULL |
The description of the event. |
EXTEVENTNAME | VARCHAR (64) NOT NULL |
The name of the event. |
LMEVENTMAP_ID | INTEGER NOT NULL |
The ID of the event. |
LMSETNAME | VARCHAR (64) NOT NULL |
The name of the transaction set to which the event belongs. |
LMTXTYPEID | INTEGER NOT NULL |
The transaction type ID. This value must match the value of the trx_type_id in the wcs_trx_type table of the LikeMinds database. |
STOREENT_ID | INTEGER NOT NULL |
The storeent ID for the event. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000146 | LMSETNAME, STOREENT_ID, EXTEVENTNAME | Unique Index |
I0000310 | LMSETNAME, STOREENT_ID | Non-Unique Index |
SQL030416034953260 | LMEVENTMAP_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_420 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|