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
|
Related reference