WebSphere Commerce database table: MEMBRAUCT

This table describes the relationship between a member and an auction.


Column Description(s):
Column NameColumn TypeDescription
AUCT_ID BIGINT NOT NULL Auction ID.
MEMBER_ID BIGINT NOT NULL Member ID of the customer who is bidding.
RELATIONTYPE CHAR(10) NOT NULL Relationship type. Valid values are as follows:
  • VR=customer has viewed the auction rules
  • GA=customer has put the auction in the auction gallery
STATUS CHAR(4) Reserved for IBM internal use.
COMMENTS VARCHAR(254) Comments field. This field contains text.
FIELD1 BIGINT Customizable.
FIELD2 BIGINT Customizable.
FIELD3 BIGINT Customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031239760 AUCT_ID+MEMBER_ID+RELATIONTYPE Primary Key
I0000154 RELATIONTYPE Non-Unique Index
I0000155 STATUS Non-Unique Index
I0000618 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_457 AUCT_ID AUCTION AUCT_ID Cascade
F_458 MEMBER_ID MEMBER MEMBER_ID Cascade

Feedback