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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031159530 AUCT_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_78 AUCT_ID AUCTION AUCT_ID Cascade
F_79 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback