BID

This table is deprecated and is provided for backward compatibility only.

Column Descriptions:

NameTypeDescription
BID_IDBIGINT NOT NULLReserved for IBM internal use.
REFCODECHAR (36) NOT NULLReserved for IBM internal use.
AUCPAYINFO_IDBIGINTReserved for IBM internal use.
OWNER_IDBIGINT NOT NULLReserved for IBM internal use.
STORE_IDINTEGERReserved for IBM internal use.
ADMIN_IDBIGINTReserved for IBM internal use.
AUCT_IDBIGINT NOT NULLReserved for IBM internal use.
BIDQUANTDOUBLE NOT NULLReserved for IBM internal use.
BIDPRICEDECIMAL (20,5) NOT NULLReserved for IBM internal use.
BIDTIMETIMESTAMP NOT NULLReserved for IBM internal use.
WINOPTCHAR (4) NOT NULLReserved for IBM internal use.
BIDSTATUSCHAR (4) NOT NULLReserved for IBM internal use.
PAYTYPECHAR (64) NOT NULLReserved for IBM internal use.
ENCRYPTINTEGER NOT NULLReserved for IBM internal use.
DEVICEVARCHAR (64) NOT NULLReserved for IBM internal use.
EXPDATETIMESTAMP NOT NULLReserved for IBM internal use.
QUANTSCALEINTEGERReserved for IBM internal use.
AUTOBID_IDBIGINTReserved for IBM internal use.
BIDROOTBIGINTReserved for IBM internal use.
BKNAMEVARCHAR (254)Reserved for IBM internal use.
SHIPTO_IDBIGINTReserved for IBM internal use.
SHIPMODEINTEGERReserved for IBM internal use.
WINPRICEDECIMAL (20,5)Reserved for IBM internal use.
WINQUANTDOUBLEReserved for IBM internal use.
BIDMSGVARCHAR (254)Reserved for IBM internal use.
FIELD1BIGINTReserved for IBM internal use.
FIELD2DECIMAL (20,5)Reserved for IBM internal use.
FIELD3VARCHAR (254)Reserved for IBM internal use.
BILLADDRBIGINTReserved for IBM internal use.
INITPRICEDECIMAL (20,5)Reserved for IBM internal use.
LIMITPRICEDECIMAL (20,5)Reserved for IBM internal use.
BIDMODECHAR (4)Reserved for IBM internal use.
OPTCOUNTERSMALLINTReserved for IBM internal use.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>BID_IDPrimary Key
I0000041REFCODEUnique Index
I0000042AUTOBID_IDNon-Unique Index
I0000043BIDQUANTNon-Unique Index
I0000044BIDPRICENon-Unique Index
I0000045BIDSTATUSNon-Unique Index
I0000473ADMIN_IDNon-Unique Index
I0000474OWNER_IDNon-Unique Index
I0000475STORE_IDNon-Unique Index
I0001243AUCPAYINFO_IDNon-Unique Index
I0001244AUCT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_111AUCPAYINFO_IDAUCPAYINFOAUCPAYINFO_IDCascade
F_112AUCT_IDAUCTIONAUCT_IDCascade
F_113STORE_IDSTORESTORE_IDCascade
F_114OWNER_IDMEMBERMEMBER_IDCascade
F_115ADMIN_IDMEMBERMEMBER_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_121BID_IDBIDORDRRELBID_IDCascade
F_123BID_IDBIDPAYMENTBID_IDCascade