WebSphere Commerce database table: CACHEIVL

CACHEIVL

This table records changes to product or category information in the database. It can be populated by user-defined database triggers.

Column Descriptions:

Name Type Description
TEMPLATE VARCHAR (1024) This column is a name that groups common cache entries.
DATAID VARCHAR (2960) Represents the dependency ID or the cache entry ID in the WebSphere dynamic cache.
INSERTTIME TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP Represents the time the row was inserted. Defaults to CURRENT TIMESTAMP.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name Column Names Type
I0000299 INSERTTIME Non-Unique Index

Name	Type	Description
TEMPLATE	VARCHAR (1024)	This column is a name that groups common cache entries.
DATAID	VARCHAR (2960)	Represents the dependency ID or the cache entry ID in the WebSphere dynamic cache.
INSERTTIME	TIMESTAMP NOT NULL DEFAULT CURRENT TIMESTAMP	Represents the time the row was inserted. Defaults to CURRENT TIMESTAMP.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.