Database Table: AUTOBIDLOG

This table tracks changes made to an autobid. An autobid is written to the AUTOBIDLOG table before it is changed in the AUTOBID table.

Column Name Column Type Column Description
ABFIELD1 BIGINT
NULL
Customizable.
ABFIELD2 DECIMAL (20,5)
NULL
Customizable.
ABFIELD3 VARCHAR (254)
NULL
Customizable.
ABQUANT DOUBLE
NULL
Autobid quantity.
ABSTATUS CHARACTER (4)
NULL
Autobid status. Valid values: A=active bid, R=bid retracted by customer, D=bid deleted by administrator.
ABTIME TIMESTAMP
NULL
Autobid date and time.
ACTIONMSG VARCHAR (254)
NULL
Description of the change to the autobid.
ACTIONTIME TIMESTAMP
NOT NULL
Date and time of the change to the autobid.
ACTIONTYPE INTEGER
NULL
Type of change made to the autobid.
ADMIN_ID BIGINT
NULL
ID of the administrator who retracted the autobid.
AUCPAYINFO_ID BIGINT
NULL
Reserved for IBM internal use.
AUCT_ID BIGINT
NULL
Auction ID of the auction that the autobid is based on.
AUTOBID_ID BIGINT
NOT NULL
ID of autobid that was changed.
BIDMSG VARCHAR (254)
NULL
Reserved for IBM internal use.
BID_ID BIGINT
NULL
Bid ID generated for the autobid.
BILLADDR BIGINT
NULL
The billing address specified by the user submitting the bid.
BKNAME VARCHAR (254)
NULL
Bank name associated with credit card number in DEVICE column.
DEVICE VARCHAR (64)
NULL
The credit card number used for this autobid.
ENCRYPT INTEGER
NULL
Indicates if the credit card number is encrypted or not. Valid values: 0=not encrypted, 1=encrypted.
ENDTIME TIMESTAMP
NULL
Reserved for IBM internal use.
EXPDATE TIMESTAMP
NULL
Expiration date of the credit card.
INITBIDVAL DECIMAL (20,5)
NULL
Initial bid value.
LASTBID_ID BIGINT
NULL
Reserved for IBM internal use.
MAXBIDLIMIT DECIMAL (20,5)
NULL
The maximum bid amount.
MSGFLAG INTEGER
NULL
Reserved for IBM internal use.
OWNER_ID BIGINT
NULL
ID of the user submitting the autobid.
PAYTYPE CHARACTER (64)
NULL
Payment type. Valid values: MC=MasterCard, VS=Visa, DS=Discover, AM=American Express, DC=Diners Club, and BK=other bank card.
QUANTSCALE INTEGER
NULL
Reserved for IBM internal use.
REFCODE CHARACTER (36)
NULL
Reference code. A unique code that identifies the auction.
SHIPMODE INTEGER
NULL
The shipping mode specified by the user submitting the bid.
SHIPTO_ID BIGINT
NULL
The shipping address specified by the user submitting the bid.
STARTTIME TIMESTAMP
NULL
Reserved for IBM internal use.
STORE_ID INTEGER
NULL
The ID of the store conducting the auction.
WINOPT CHARACTER (4)
NULL
Indicates if bidder will accept a partial quantity. Valid values: A=bidder will only accept full quantity, P=bidder will accept a partial quantity.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034841230 AUTOBID_ID, ACTIONTIME Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_102 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_103 STORE_ID STORE STORE_ID Cascade
F_104 OWNER_ID MEMBER MEMBER_ID Cascade
F_105 ADMIN_ID MEMBER MEMBER_ID Cascade

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