Reference > Database > WebSphere Commerce database tables > M

WebSphere Commerce database table: MEMBRAUCT

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

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... 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
SQL100520030355260	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

• Auction customer interaction data model

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search