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 Column Description
BASEITEM_ID BIGINT
NOT NULL
The BaseItem for this ItemVersion.
EXPIRATIONDATE TIMESTAMP
NOT NULL
The time this ItemVersion expires.
ITEMVERSN_ID BIGINT
NOT NULL
Generated primary key.
LASTUPDATE TIMESTAMP
NULL
The time this ItemVersion was most recently updated.
VERSIONNAME N (30)
NULL, DEFAULT 'Version
Uniquely identifies this ItemVersion for its BaseItem.
Indexes:
Index Name Indexed Column Names Index Type
I0000140 BASEITEM_ID, EXPIRATIONDATE Unique Index
I0000141 BASEITEM_ID, VERSIONNAME Unique Index
SQL030416034950220 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