Database Table: BIDPAYMENT

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

Column Name Column Type Column Description
AMOUNT DECIMAL (20,5)
NOT NULL
The amount of the payment.
AUCPAYINFO_ID BIGINT
NULL
Reserved for IBM internal use.
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.
BKNAME VARCHAR (254)
NULL
Bank name.
COMMENTS VARCHAR (254)
NULL
Payment comments.
DEVICE VARCHAR (64)
NULL
The device used to make the payment. For example, credit card number.
ENCRYPT INTEGER
NULL
Indicates if the device is encrypted or not. Valid values: 0=not encrypted, 1=encrypted.
EXPDATE TIMESTAMP
NULL
Expiration date for the device (credit card expiration date).
PAYTIME TIMESTAMP
NULL
Date and time of the payment.
PAYTYPE CHARACTER (64)
NULL
Device type used for payment. This is set to the PAYTYPE attribute of the associated bid.
TYPE INTEGER
NULL
Type of payment. Valid values: 1=deposit, 2=other payment.
Indexes:
Index Name Indexed Column Names Index Type
I0000047 TYPE Non-Unique Index
SQL030416034843450 BIDPAY_ID Primary Key
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

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