WebSphere Commerce database table: AUCTSTRREL

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235128810 STORE_ID+AUCT_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_92 AUCT_ID AUCTION AUCT_ID Cascade
F_93 STORE_ID STORE STORE_ID Cascade