Reference > Database > WebSphere Commerce database tables > V
WebSphere Commerce database table: VERSIONSPC
Each row defines the relationship between a product version and a specified item.
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 SQL100520030445810 VERSIONSPC_ID Primary Key I0001293 ITEMVERSN_ID Non-Unique Index
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
Referenced By 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
- Receipt data model
- Order item - allocated data model
- Order release data model
- Order management - receipt and disposition data model
- ATP inventory data model
- ATP inventory adjustment data model
- ATP inventory orders data model
_vcc_freeselect_bottom_