Database Table: LMEVENTMAP

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.
Indexes:
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
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_420 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable