Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: AUTOBID

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

Column Name Column Type Description
AUTOBID_ID BIGINT NOT NULL Unique identifier for autobid. Primary key for this table.
REFCODE CHAR(36) NOT NULL Reference code. A unique code that identifies the auction.
AUCPAYINFO_ID BIGINT Reserved for IBM internal use.
OWNER_ID BIGINT NOT NULL ID of the customer who submitted the bid.
STORE_ID INTEGER ID of the store that is conducting the auction.
ADMIN_ID BIGINT ID of the administrator who retracted the autobid.
AUCT_ID BIGINT NOT NULL Auction ID.
ABQUANT DOUBLE NOT NULL Autobid quantity.
PAYTYPE CHAR(64) NOT NULL Payment type. This is set to the value of the cardBrand payment parameter when the autobid is submitted.
ENCRYPT INTEGER NOT NULL Indicates whether credit card number is encrypted or not. Valid values are...

  • 0=not encrypted

  • 1=encrypted

DEVICE VARCHAR(64) NOT NULL Credit card number.
EXPDATE TIMESTAMP NOT NULL Expiration date for the credit card.
QUANTSCALE INTEGER Reserved for IBM internal use.
MAXBIDLIMIT DECIMAL (20,5) Maximum bid. No autobids will be generated if the bidding exceeds this limit.
ABSTATUS CHAR(4) Autobid status. Valid values are...

  • A=active bid

  • R=bid retracted by customer

  • D=bid deleted by administrator

WINOPT CHAR(4) Indicates if bidder will accept a partial quantity. Valid values are...

  • A=bidder will only accept full quantity

  • P=bidder will accept a partial quantity

ABTIME TIMESTAMP Autobid creation date and time.
LASTBID_ID BIGINT Reserved for IBM internal use.
BID_ID BIGINT Reference to the bid generated from this autobid.
BKNAME VARCHAR(254) Reserved for IBM internal use.
SHIPTO_ID BIGINT ID of ship-to address.
SHIPMODE INTEGER Ship mode.
BIDMSG VARCHAR(254) Reserved for IBM internal use.
MSGFLAG INTEGER Reserved for IBM internal use.
STARTTIME TIMESTAMP Reserved for IBM internal use.
ENDTIME TIMESTAMP Reserved for IBM internal use.
ABFIELD1 BIGINT Customizable.
ABFIELD2 DECIMAL (20,5) Customizable.
ABFIELD3 VARCHAR(254) Customizable.
BILLADDR BIGINT Billing address for customer.
INITBIDVAL DECIMAL (20,5) The initial bid value for the autobid.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000034 REFCODE Unique Index
SQL100520030301720 AUTOBID_ID Primary Key
I0000035 BID_ID Non-Unique Index
I0000036 ABQUANT Non-Unique Index
I0000037 MAXBIDLIMIT Non-Unique Index
I0000038 ABSTATUS Non-Unique Index
I0000467 STORE_ID Non-Unique Index
I0000468 ADMIN_ID Non-Unique Index
I0000469 OWNER_ID Non-Unique Index
I0001240 AUCT_ID Non-Unique Index
I0001241 AUCPAYINFO_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_97 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_98 AUCT_ID AUCTION AUCT_ID Cascade
F_100 OWNER_ID MEMBER MEMBER_ID Cascade
F_101 ADMIN_ID MEMBER MEMBER_ID Cascade
F_99 STORE_ID STORE STORE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search