WebSphere Commerce database table: CACHEIVL

WebSphere Commerce database table: CACHEIVL

This table records changes to product or category information in the database. It can be populated by user-defined database triggers.
Column Descriptions
Column Name Column 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 Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000299 INSERTTIME Non-Unique Index

Column Name	Column 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	Reserved for IBM internal use.