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

• Auction data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search