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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000140 BASEITEM_ID+EXPIRATIONDATE Unique Index
I0000141 BASEITEM_ID+VERSIONNAME Unique Index
SQL050212031235510 ITEMVERSN_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_408 BASEITEM_ID BASEITEM BASEITEM_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_906 ITEMVERSN_ID VERSIONSPC ITEMVERSN_ID Cascade

Feedback