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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|