Database View: AUCTBIDVW

This view is a join of the AUCTVIEW and BID tables. The join is based on AUCT_ID and STORE_ID. For column descriptions, refer to either the AUCTVIEW or BID tables.

Column Name Column Type Column Description
ADMIN_ID BIGINT
NULL
From the AUCTVIEW table.
AUCT_ID BIGINT
NOT NULL
From the AUCTVIEW table.
AUQUANT DOUBLE
NOT NULL
From the AUCTVIEW table.
AUREFCODE CHARACTER (36)
NOT NULL
From the AUCTVIEW table.
AUSTATUS CHARACTER (4)
NOT NULL
From the AUCTVIEW table.
AUTOBID_ID BIGINT
NULL
From the BID table.
AUTYPE CHARACTER (4)
NOT NULL
From the AUCTVIEW table.
BESTBID_ID BIGINT
NULL
From the AUCTVIEW table.
BIDMSG VARCHAR (254)
NULL
From the BID table.
BIDPRICE DECIMAL (20,5)
NOT NULL
From the BID table.
BIDQUANT DOUBLE
NOT NULL
From the BID table.
BIDROOT BIGINT
NULL
From the BID table.
BIDSTATUS CHARACTER (4)
NOT NULL
From the BID table.
BIDTIME TIMESTAMP
NOT NULL
From the BID table.
BID_ID BIGINT
NOT NULL
From the BID table.
BKNAME VARCHAR (254)
NULL
From the BID table.
CLOSEPR CHARACTER (4)
NULL
From the AUCTVIEW table.
CLOSETYPE INTEGER
NULL
From the AUCTVIEW table.
CURRENCY CHARACTER (4)
NULL
From the AUCTVIEW table.
CURRPRICE DECIMAL (20,5)
NULL
From the AUCTVIEW table.
CURRQUANT DOUBLE
NULL
From the AUCTVIEW table.
DEPOSIT DECIMAL (20,5)
NULL
From the AUCTVIEW table.
DEVICE VARCHAR (64)
NOT NULL
From the BID table.
DURATION TIMESTAMP
NULL
From the AUCTVIEW table.
ENCRYPT INTEGER
NOT NULL
From the BID table.
ENDTIME TIMESTAMP
NULL
From the AUCTVIEW table.
EXPDATE TIMESTAMP
NOT NULL
From the BID table.
FIELD1 BIGINT
NULL
From the AUCTVIEW table.
FIELD2 DECIMAL (20,5)
NULL
From the AUCTVIEW table.
FIELD3 VARCHAR (254)
NULL
From the AUCTVIEW table.
HIGHBID_ID BIGINT
NULL
From the AUCTVIEW table.
ITEMPAGE VARCHAR (254)
NULL
From the AUCTVIEW table.
LASTBKTIME TIMESTAMP
NULL
From the AUCTVIEW table.
LOCKFLAG INTEGER
NULL
From the AUCTVIEW table.
OPENPRICE DECIMAL (20,5)
NULL
From the AUCTVIEW table.
OWNER_ID BIGINT
NOT NULL
From the AUCTVIEW table.
PAYMETHODS CHARACTER (254)
NULL
From the AUCTVIEW table.
PAYTYPE CHARACTER (64)
NOT NULL
From the BID table.
PRECEDENCE INTEGER
NULL
From the AUCTVIEW table.
QUANTSCALE INTEGER
NULL
From the AUCTVIEW table.
REALENDTIME TIMESTAMP
NULL
From the AUCTVIEW table.
REFCODE CHARACTER (36)
NOT NULL
From the AUCTVIEW table.
RESRVPRICE DECIMAL (20,5)
NULL
From the AUCTVIEW table.
RULEPAGE VARCHAR (254)
NULL
From the AUCTVIEW table.
SHIPMODE INTEGER
NULL
From the BID table.
SHIPTO_ID BIGINT
NULL
From the BID table.
STARTTIME TIMESTAMP
NULL
From the AUCTVIEW table.
STORE_ID INTEGER
NULL
From the BID table.
SUPPLIER_ID BIGINT
NULL
From the AUCTVIEW table.
UPDATETIME TIMESTAMP
NULL
From the AUCTVIEW table.
WINOPT CHARACTER (4)
NOT NULL
From the BID table.
WINPRICE DECIMAL (20,5)
NULL
From the BID table.
WINQUANT DOUBLE
NULL
From the BID table.
Indexes:
Index Name Indexed Column Names Index Type
Not Applicable
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable