WebSphere Commerce database table: AUCTDESC

This table stores locale sensitive information for an auction. The table is updated when an auction is created or changed.

Column Descriptions
Column Name Column Type Description
AUCT_ID BIGINT NOT NULL The Auction ID.
LANGUAGE_ID INTEGER NOT NULL The Language ID. For a list of language components, see the LANGUAGE table.
AUSDESC VARCHAR(254) Short description of the auction. This value is updated when an auction is created or modified.
AULDESC VARCHAR(2048) A detailed or long description of the auction.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235128360 AUCT_ID+LANGUAGE_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_78 AUCT_ID AUCTION AUCT_ID Cascade
F_79 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference