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 | 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 |