WebSphere Commerce database table: AUCTSTRREL

This table shows the relationship between an auction and a store.


Column Description(s):
Column NameColumn TypeDescription
AUCT_ID BIGINT NOT NULL The Auction ID.
STORE_ID INTEGER NOT NULL The ID of the store conducting the auction.
ITEMPAGE VARCHAR(254) The item page used to display the product.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031200080 STORE_ID+AUCT_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_92 AUCT_ID AUCTION AUCT_ID Cascade
F_93 STORE_ID STORE STORE_ID Cascade

Feedback