WebSphere Commerce database table: VERSIONSPC

Each row defines the relationship between a product version and a specified item.


Column Description(s):
Column NameColumn TypeDescription
VERSIONSPC_ID BIGINT NOT NULL Generated unique identifier.
ITEMSPC_ID BIGINT NOT NULL The specified item.
ITEMVERSN_ID BIGINT NOT NULL Identifies the item version.
LASTUPDATE TIMESTAMP Timestamp of last update.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000264 ITEMSPC_ID+ITEMVERSN_ID Unique Index
I0000363 VERSIONSPC_ID+ITEMSPC_ID Unique Index
SQL050212031326080 VERSIONSPC_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_905 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_906 ITEMVERSN_ID ITEMVERSN ITEMVERSN_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_543 VERSIONSPC_ID ORDPICKHST VERSIONSPC_ID Cascade
F_548 VERSIONSPC_ID ORDSHIPHST VERSIONSPC_ID Cascade
F_665 VERSIONSPC_ID RECEIPT VERSIONSPC_ID Cascade
F_729 VERSIONSPC_ID RTNRECEIPT VERSIONSPC_ID Cascade

Feedback