WebSphere Commerce database table: BIDPAYMENT

This table stores information about bid payments, including information on deposits.


Column Description(s):
Column NameColumn TypeDescription
BIDPAY_ID BIGINT NOT NULL Bid payment ID. The Primary key to this table.
BID_ID BIGINT NOT NULL ID of the bid for this payment.
AUCPAYINFO_ID BIGINT Reserved for IBM internal use.
AMOUNT DECIMAL (20,5) NOT NULL The amount of the payment.
TYPE INTEGER Type of payment. Valid values are as follows:
  • 1=deposit
  • 2=other payment
PAYTIME TIMESTAMP Date and time of the payment.
PAYTYPE CHAR(64) Device type used for payment. This is set to the PAYTYPE attribute of the associated bid.
ENCRYPT INTEGER Indicates if the device is encrypted or not. Valid values are as follows:
  • 0=not encrypted
  • 1=encrypted
DEVICE VARCHAR(64) The device used to make the payment. For example, credit card number.
EXPDATE TIMESTAMP Expiration date for the device (credit card expiration date).
BKNAME VARCHAR(254) Bank name.
COMMENTS VARCHAR(254) Payment comments.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031201440 BIDPAY_ID Primary Key
I0000047 TYPE Non-Unique Index
I0000480 BID_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_122 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_123 BID_ID BID BID_ID Cascade

Feedback