WebSphere Commerce database table: MEMBRAUCT

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235214240 AUCT_ID+MEMBER_ID+RELATIONTYPE Primary Key
I0000154 RELATIONTYPE Non-Unique Index
I0000155 STATUS Non-Unique Index
I0000618 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_457 AUCT_ID AUCTION AUCT_ID Cascade
F_458 MEMBER_ID MEMBER MEMBER_ID Cascade
Related reference