WebSphere Commerce database table: ITEMVERSN

Each row of this table represents an ItemVersion for a BaseItem. An ItemVersion expires when its expiration date is in the past. Each BaseItem must only have a single ItemVersion defined.

Column Descriptions
Column Name Column Type Description
ITEMVERSN_ID BIGINT NOT NULL Generated primary key.
LASTUPDATE TIMESTAMP The time this ItemVersion was most recently updated.
BASEITEM_ID BIGINT NOT NULL The BaseItem for this ItemVersion.
EXPIRATIONDATE TIMESTAMP NOT NULL The time this ItemVersion expires.
VERSIONNAME CHAR(30) NOT NULL DEFAULT 'Version 1' Uniquely identifies this ItemVersion for its BaseItem.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000140 BASEITEM_ID+EXPIRATIONDATE Unique Index
I0000141 BASEITEM_ID+VERSIONNAME Unique Index
SQL060903235209440 ITEMVERSN_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_408 BASEITEM_ID BASEITEM BASEITEM_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_906 ITEMVERSN_ID VERSIONSPC ITEMVERSN_ID Cascade

Related reference