WebSphere Commerce database table: OFFERPRICE

OFFERPRICE

Each row of this table represents a price in a currency for an Offer.

Column Descriptions:

Name Type Description
OFFER_ID BIGINT NOT NULL The Offer.
CURRENCY CHAR (3) NOT NULL The currency of the price. This is a currency code as per ISO 4217 standards.
PRICE DECIMAL (20,5) NOT NULL The price for the nominal quantity (see CATENTSHIP.NOMINALQUANTITY) of the product referred to by the Offer.
COMPAREPRICE DECIMAL (20,5) Reserved for IBM internal use.
OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 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> OFFER_ID+CURRENCY Primary Key
I0000168 PRICE+CURRENCY+OFFER_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_472 OFFER_ID OFFER OFFER_ID Cascade
F_473 CURRENCY SETCURR SETCCURR Cascade

Related reference
Offers data model

Name	Type	Description
OFFER_ID	BIGINT NOT NULL	The Offer.
CURRENCY	CHAR (3) NOT NULL	The currency of the price. This is a currency code as per ISO 4217 standards.
PRICE	DECIMAL (20,5) NOT NULL	The price for the nominal quantity (see CATENTSHIP.NOMINALQUANTITY) of the product referred to by the Offer.
COMPAREPRICE	DECIMAL (20,5)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Name	Column Names	Type
<SYSTEM-GENERATED>	OFFER_ID+CURRENCY	Primary Key
I0000168	PRICE+CURRENCY+OFFER_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_472	OFFER_ID	OFFER	OFFER_ID	Cascade
F_473	CURRENCY	SETCURR	SETCCURR	Cascade