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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000140 | BASEITEM_ID, EXPIRATIONDATE | Unique Index |
I0000141 | BASEITEM_ID, VERSIONNAME | Unique Index |
SQL030416034950220 | ITEMVERSN_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_408 | BASEITEM_ID | BASEITEM | BASEITEM_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_906 | ITEMVERSN_ID | VERSIONSPC | ITEMVERSN_ID | Cascade |