Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: AUCTSTRREL
This table shows the relationship between an auction and a store.
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 SQL100520030301370 STORE_ID+AUCT_ID Primary Key I0001239 AUCT_ID Non-Unique Index
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
Related reference
_vcc_freeselect_bottom_