Reference > Database > WebSphere Commerce database tables > L
WebSphere Commerce database table: LMEVENTMAP
LikeMinds event information. This information is also stored in the LikeMinds server database.
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 SQL100520030351190 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
_vcc_freeselect_bottom_