BID

Deprecated. Provided for backward compatibility only.

Column Descriptions:

Name	Type	Description
BID_ID	BIGINT NOT NULL	Reserved for IBM internal use.
REFCODE	CHAR (36) NOT NULL	Reserved for IBM internal use.
AUCPAYINFO_ID	BIGINT	Reserved for IBM internal use.
OWNER_ID	BIGINT NOT NULL	Reserved for IBM internal use.
STORE_ID	INTEGER	Reserved for IBM internal use.
ADMIN_ID	BIGINT	Reserved for IBM internal use.
AUCT_ID	BIGINT NOT NULL	Reserved for IBM internal use.
BIDQUANT	DOUBLE NOT NULL	Reserved for IBM internal use.
BIDPRICE	DECIMAL (20,5) NOT NULL	Reserved for IBM internal use.
BIDTIME	TIMESTAMP NOT NULL	Reserved for IBM internal use.
WINOPT	CHAR (4) NOT NULL	Reserved for IBM internal use.
BIDSTATUS	CHAR (4) NOT NULL	Reserved for IBM internal use.
PAYTYPE	CHAR (64) NOT NULL	Reserved for IBM internal use.
ENCRYPT	INTEGER NOT NULL	Reserved for IBM internal use.
DEVICE	VARCHAR (64) NOT NULL	Reserved for IBM internal use.
EXPDATE	TIMESTAMP NOT NULL	Reserved for IBM internal use.
QUANTSCALE	INTEGER	Reserved for IBM internal use.
AUTOBID_ID	BIGINT	Reserved for IBM internal use.
BIDROOT	BIGINT	Reserved for IBM internal use.
BKNAME	VARCHAR (254)	Reserved for IBM internal use.
SHIPTO_ID	BIGINT	Reserved for IBM internal use.
SHIPMODE	INTEGER	Reserved for IBM internal use.
WINPRICE	DECIMAL (20,5)	Reserved for IBM internal use.
WINQUANT	DOUBLE	Reserved for IBM internal use.
BIDMSG	VARCHAR (254)	Reserved for IBM internal use.
FIELD1	BIGINT	Reserved for IBM internal use.
FIELD2	DECIMAL (20,5)	Reserved for IBM internal use.
FIELD3	VARCHAR (254)	Reserved for IBM internal use.
BILLADDR	BIGINT	Reserved for IBM internal use.
INITPRICE	DECIMAL (20,5)	Reserved for IBM internal use.
LIMITPRICE	DECIMAL (20,5)	Reserved for IBM internal use.
BIDMODE	CHAR (4)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	Reserved for IBM internal use.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	BID_ID	Primary Key
I0000041	REFCODE	Unique Index
I0000042	AUTOBID_ID	Non-Unique Index
I0000043	BIDQUANT	Non-Unique Index
I0000044	BIDPRICE	Non-Unique Index
I0000045	BIDSTATUS	Non-Unique Index
I0000473	ADMIN_ID	Non-Unique Index
I0000474	OWNER_ID	Non-Unique Index
I0000475	STORE_ID	Non-Unique Index
I0001243	AUCPAYINFO_ID	Non-Unique Index
I0001244	AUCT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_111	AUCPAYINFO_ID	AUCPAYINFO	AUCPAYINFO_ID	Cascade
F_112	AUCT_ID	AUCTION	AUCT_ID	Cascade
F_113	STORE_ID	STORE	STORE_ID	Cascade
F_114	OWNER_ID	MEMBER	MEMBER_ID	Cascade
F_115	ADMIN_ID	MEMBER	MEMBER_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_121	BID_ID	BIDORDRREL	BID_ID	Cascade
F_123	BID_ID	BIDPAYMENT	BID_ID	Cascade