WebSphere Commerce database table: BIDPAYMENT

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

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235130470 BIDPAY_ID Primary Key
I0000047 TYPE Non-Unique Index
I0000480 BID_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_122 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade
F_123 BID_ID BID BID_ID Cascade
Related reference