Reference > Database > WebSphere Commerce database tables > B


WebSphere Commerce database table: BUSEVENT

The purpose of this table is to persist the event object so it can be later processed by those other applications that may want to participate in the event. The table will contain a sequence column where each 4K chunk of the XML will be stored in a separate record and can be pieced back based on a unique key and the sequence. One of the objectives of this table is to ensure that the data can be easy replicated using DB2 replication.

Column Name Column Type Description
BUSEVENT_ID BIGINT NOT NULL The primary key of the CBE event. This value uniquely identifiers the CBE document.
SEQUENCE INTEGER NOT NULL The sequence number associated with the chunk of XML document. The XML document can be pieced back together again based on all records with the same BUSEVENT_ID and the ordering of the sequence column.
CREATETSTMP TIMESTAMP NOT NULL The timestamp when the CBE event was processed. This can be used for table cleanup so events older then X days can be purged; where X is a number greater then 0.
EVENTDATA VARCHAR(4000) NOT NULL A 4K chunk of the CBE XML document. This chunk could be part of the entire XML document that represents the business event.
CHECKED SMALLINT A flag to determine whether the event has been raised.
OPTCOUNTER SMALLINT Reserved IBM Internal Use
EVENT_SEARCHKEY CHAR(64) No EVENT_SEARCHKEY external description assigned yet

Indexes
Index Name Indexed Column Names Index Type
SQL100520030305020 BUSEVENT_ID+SEQUENCE Primary Key
I0001104 CHECKED Non-Unique Index

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search