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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000047 | TYPE | Non-Unique Index |
SQL030416034843450 | BIDPAY_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|