WebSphere Commerce database table: LMEVENTMAP

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000146 LMSETNAME+STOREENT_ID+EXTEVENTNAME Unique Index
SQL050212031236850 LMEVENTMAP_ID Primary Key
I0000310 LMSETNAME+STOREENT_ID Non-Unique Index
I0000605 STOREENT_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_420 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback