Database Table: OFFERPRICE

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.
Indexes:
Index Name Indexed Column Names Index Type
I0000168 PRICE, CURRENCY, OFFER_ID Non-Unique Index
SQL030416035010920 OFFER_ID, CURRENCY Primary Key
Constraints:
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable