WebSphere Commerce database table: OFFER

Each row of this table represents an Offer to sell a product identified by a CatalogEntry.

Column Descriptions
Column Name Column Type Description
OFFER_ID BIGINT NOT NULL Generated unique key.
STARTDATE TIMESTAMP The start of the time range during which this Offer is effective.
TRADEPOSCN_ID BIGINT NOT NULL The TradingPositionContainer this Offer is part of.
CATENTRY_ID BIGINT NOT NULL The CatalogEntry offered for sale.
ENDDATE TIMESTAMP The end of the time range during which this Offer is effective.
PRECEDENCE DOUBLE NOT NULL DEFAULT 0 When more than one Offer is effective at a particular time, the one with the highest PRECEDENCE is used.
PUBLISHED INTEGER NOT NULL DEFAULT 0 Describes whether or not the offer has been published as follows:
0 = not published (temporarily disabled).
1 = published.
2 = marked for deletion (and not published).
LASTUPDATE TIMESTAMP The last time this Offer was updated.
MINIMUMQUANTITY DOUBLE The minimum quantity that can be purchased in a single Order under this Offer.
QTYUNIT_ID CHAR(16) The unit of measure for MINIMUMQUANTITY and MAXIMUMQUANTITY. If this is NULL, then MINIMUMQUANTITY and MAXIMUMQUANTITY are multiplied by CATENTSHIP.NOMINALQUANTITY and the unit of measure of the results is CATENTSHIP.QUANTITYMEASURE.
MAXIMUMQUANTITY DOUBLE The maximum quantity that can be purchased in a single Order under this Offer.
FIELD1 CHAR(30) Customizable.
FIELD2 CHAR(1) Customizable.
FLAGS INTEGER NOT NULL DEFAULT 1 Reserved for IBM internal use.
IDENTIFIER BIGINT A number that uniquely identifies this Offer along with its specified CatalogEntry and TradingPositionContainer.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000165 CATENTRY_ID+IDENTIFIER+TRADEPOSCN_ID Unique Index
SQL060903235216300 OFFER_ID Primary Key
I0000167 CATENTRY_ID+PUBLISHED+TRADEPOSCN_ID Non-Unique Index
I0000626 TRADEPOSCN_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_468 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_469 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
F_467 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1180 OFFER_ID DKPDCOFFERREL OFFER_ID Cascade
F_470 OFFER_ID OFFERDESC OFFER_ID Cascade
F_472 OFFER_ID OFFERPRICE OFFER_ID Cascade
F_506 OFFER_ID ORDERITEMS OFFER_ID Cascade
F_525 OFFER_ID ORDIOFFER OFFER_ID Cascade
Related reference