BIDLOG

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

Column Descriptions:

NameTypeDescription
BID_IDBIGINT NOT NULLReserved for IBM internal use.
ACTIONTIMETIMESTAMP NOT NULLReserved for IBM internal use.
ACTIONTYPEINTEGERReserved for IBM internal use.
AUCPAYINFO_IDBIGINTReserved for IBM internal use.
STORE_IDINTEGERReserved for IBM internal use.
OWNER_IDBIGINTReserved for IBM internal use.
ADMIN_IDBIGINTReserved for IBM internal use.
ACTIONMSGVARCHAR (254)Reserved for IBM internal use.
REFCODECHAR (36)Reserved for IBM internal use.
AUCT_IDBIGINTReserved for IBM internal use.
BIDQUANTDOUBLEReserved for IBM internal use.
BIDPRICEDECIMAL (20,5)Reserved for IBM internal use.
BIDTIMETIMESTAMPReserved for IBM internal use.
WINOPTCHAR (4)Reserved for IBM internal use.
BIDSTATUSCHAR (4)Reserved for IBM internal use.
PAYTYPECHAR (64)Reserved for IBM internal use.
ENCRYPTINTEGERReserved for IBM internal use.
DEVICEVARCHAR (64)Reserved for IBM internal use.
EXPDATETIMESTAMPReserved 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_ID+ACTIONTIMEPrimary Key
I0000476STORE_IDNon-Unique Index
I0000477ADMIN_IDNon-Unique Index
I0000478OWNER_IDNon-Unique Index
I0001245AUCPAYINFO_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_116AUCPAYINFO_IDAUCPAYINFOAUCPAYINFO_IDCascade
F_117OWNER_IDMEMBERMEMBER_IDCascade
F_118ADMIN_IDMEMBERMEMBER_IDCascade
F_119STORE_IDSTORESTORE_IDCascade