VERSIONSPC

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

Column Descriptions:

Name	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	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	VERSIONSPC_ID	Primary Key
I0000264	ITEMSPC_ID+ITEMVERSN_ID	Unique Index
I0000363	VERSIONSPC_ID+ITEMSPC_ID	Unique Index
I0001293	ITEMVERSN_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_905	ITEMSPC_ID	ITEMSPC	ITEMSPC_ID	Cascade
F_906	ITEMVERSN_ID	ITEMVERSN	ITEMVERSN_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	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