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:

Name	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 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
<SYSTEM-GENERATED>	ITEMVERSN_ID	Primary Key
I0000140	BASEITEM_ID+EXPIRATIONDATE	Unique Index
I0000141	BASEITEM_ID+VERSIONNAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_408	BASEITEM_ID	BASEITEM	BASEITEM_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_906	ITEMVERSN_ID	VERSIONSPC	ITEMVERSN_ID	Cascade