WebSphere Commerce database table: LMEVENTMAP

LikeMinds event information. This information is also stored in the LikeMinds server database.

Column Descriptions
Column Name Column Type Description
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.
STOREENT_ID INTEGER NOT NULL The store entity ID for store to which the event belongs.
EXTEVENTNAME VARCHAR(64) NOT NULL The name of the event.
EXTEVENTDESC VARCHAR(254) The description of the event.
LMTXTYPEID INTEGER NOT NULL The transaction type ID. This value must match the value of the TRX_TYPE_ID in the LPS_TRX_TYPE table of the LikeMinds database.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000146 LMSETNAME+STOREENT_ID+EXTEVENTNAME Unique Index
SQL060903235211020 LMEVENTMAP_ID Primary Key
I0000310 LMSETNAME+STOREENT_ID Non-Unique Index
I0000605 STOREENT_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_420 STOREENT_ID STOREENT STOREENT_ID Cascade
Related reference