BID

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

Column Descriptions:

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