Reference > Database > WebSphere Commerce database tables > I
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 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. Specify an end date that will not expire, for example: '9999-12-31 23:59:59.0' 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 SQL100520030348470 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_906 ITEMVERSN_ID VERSIONSPC ITEMVERSN_ID Cascade
Related reference
_vcc_freeselect_bottom_