Database Table: VERSIONSPC

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

Column Name Column Type Column Description
ITEMSPC_ID BIGINT
NOT NULL
The specified item.
ITEMVERSN_ID BIGINT
NOT NULL
Identifies the item version.
LASTUPDATE TIMESTAMP
NULL
Timestamp of last update.
VERSIONSPC_ID BIGINT
NOT NULL
Generated unique identifier.
Indexes:
Index Name Indexed Column Names Index Type
I0000264 ITEMSPC_ID, ITEMVERSN_ID Unique Index
SQL030416035144090 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

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