WebSphere Commerce database table: VERSIONSPC

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000264 ITEMSPC_ID+ITEMVERSN_ID Unique Index
I0000363 VERSIONSPC_ID+ITEMSPC_ID Unique Index
SQL060903235306340 VERSIONSPC_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_905 ITEMSPC_ID ITEMSPC ITEMSPC_ID Cascade
F_906 ITEMVERSN_ID ITEMVERSN ITEMVERSN_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names 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
Related reference