Database Table: AUTOBID

This table contains information about autobids. Autobids are bids automatically submitted by a scheduler command.

Column Name Column Type Column Description
ABFIELD1 BIGINT
NULL
Customizable.
ABFIELD2 DECIMAL (20,5)
NULL
Customizable.
ABFIELD3 VARCHAR (254)
NULL
Customizable.
ABQUANT DOUBLE
NOT 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 creation date and time.
ADMIN_ID BIGINT
NULL
ID of the administrator who retracted the autobid.
AUCPAYINFO_ID BIGINT
NULL
Reserved for IBM internal use.
AUCT_ID BIGINT
NOT NULL
Auction ID.
AUTOBID_ID BIGINT
NOT NULL
Unique identifier for autobid. Primary key for this table.
BIDMSG VARCHAR (254)
NULL
Reserved for IBM internal use.
BID_ID BIGINT
NULL
Reference to the bid generated from this autobid.
BILLADDR BIGINT
NULL
Billing address for customer.
BKNAME VARCHAR (254)
NULL
Reserved for IBM internal use.
DEVICE VARCHAR (64)
NOT NULL
Credit card number.
ENCRYPT INTEGER
NOT NULL
Indicates whether credit card number is encrypted or not. Valid values: 0=not encrypted, 1=encrypted.
ENDTIME TIMESTAMP
NULL
Reserved for IBM internal use.
EXPDATE TIMESTAMP
NOT NULL
Expiration date for the credit card.
INITBIDVAL DECIMAL (20,5)
NULL
The initial bid value for the autobid.
LASTBID_ID BIGINT
NULL
Reserved for IBM internal use.
MAXBIDLIMIT DECIMAL (20,5)
NULL
Maximum bid. No autobids will be generated if the bidding exceeds this limit.
MSGFLAG INTEGER
NULL
Reserved for IBM internal use.
OWNER_ID BIGINT
NOT NULL
ID of the customer who submitted the bid.
PAYTYPE CHARACTER (64)
NOT NULL
Payment type. This is set to the value of the cardBrand payment parameter when the autobid is submitted.
QUANTSCALE INTEGER
NULL
Reserved for IBM internal use.
REFCODE CHARACTER (36)
NOT NULL
Reference code. A unique code that identifies the auction.
SHIPMODE INTEGER
NULL
Shipping mode.
SHIPTO_ID BIGINT
NULL
ID of ship-to address.
STARTTIME TIMESTAMP
NULL
Reserved for IBM internal use.
STORE_ID INTEGER
NULL
ID of the store that is 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
I0000034 REFCODE Unique Index
I0000035 BID_ID Non-Unique Index
I0000036 ABQUANT Non-Unique Index
I0000037 MAXBIDLIMIT Non-Unique Index
I0000038 ABSTATUS Non-Unique Index
SQL030416034840890 AUTOBID_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_100 OWNER_ID MEMBER MEMBER_ID Cascade
F_101 ADMIN_ID MEMBER MEMBER_ID Cascade
F_97 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_98 AUCT_ID AUCTION AUCT_ID Cascade
F_99 STORE_ID STORE STORE_ID Cascade

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