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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000264 | ITEMSPC_ID, ITEMVERSN_ID | Unique Index |
SQL030416035144090 | VERSIONSPC_ID | Primary Key |
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 |