Database Table: MEMBRAUCT

This table describes the member and auction relationship.

Column Name Column Type Column Description
AUCT_ID BIGINT
NOT NULL
Auction ID.
COMMENTS VARCHAR (254)
NULL
Comments field. Contains text.
FIELD1 BIGINT
NULL
Customizable.
FIELD2 BIGINT
NULL
Customizable.
FIELD3 BIGINT
NULL
Customizable.
MEMBER_ID BIGINT
NOT NULL
Member ID of the customer who is bidding.
RELATIONTYPE CHARACTER (10)
NOT NULL
Relationship type. Valid values: VR=customer has viewed the auction rules, GA=customer has put the auction in the auction gallery.
STATUS CHARACTER (4)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
I0000154 RELATIONTYPE Non-Unique Index
I0000155 STATUS Non-Unique Index
SQL030416035002920 AUCT_ID, MEMBER_ID, RELATIONTYPE Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable