Each row of this table represents a price in a currency for an Offer.
Column Name | Column Type | Column Description |
---|---|---|
COMPAREPRICE | DECIMAL (20,5) NULL |
Reserved for IBM internal use. |
CURRENCY | CHARACTER (3) NOT NULL |
The currency of the price. This is a currency code as per ISO 4217 standards. |
OFFER_ID | BIGINT NOT NULL |
The Offer. |
PRICE | DECIMAL (20,5) NOT NULL |
The price for the nominal quantity (see CATENTSHIP.NOMINALQUANTITY) of the product referred to by the Offer. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000168 | PRICE, CURRENCY, OFFER_ID | Non-Unique Index |
SQL030416035010920 | OFFER_ID, CURRENCY | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_472 | OFFER_ID | OFFER | OFFER_ID | Cascade |
F_473 | CURRENCY | SETCURR | SETCCURR | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|