Database View: AUCTVIEW

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

Column Name Column Type Column Description
ADMIN_ID BIGINT
NULL
From the AUCTION table.
AUCMODE CHARACTER (4)
NULL
Reserved for IBM internal use.
AUCPAYINFO_ID BIGINT
NULL
Reserved for IBM internal use.
AUCT_ID BIGINT
NOT NULL
From the AUCTION table.
AUQUANT DOUBLE
NOT NULL
From the AUCTION table.
AUSTATUS CHARACTER (4)
NOT NULL
From the AUCTION table.
AUTYPE CHARACTER (4)
NOT NULL
From the AUCTION table.
BESTBID_ID BIGINT
NULL
From the AUCTION table.
BIDRULE_ID BIGINT
NULL
From the AUCTION table.
CATENTRY_ID BIGINT
NOT NULL
From the AUCTION table.
CLOSEPR CHARACTER (4)
NULL
From the AUCTION table.
CLOSETYPE INTEGER
NULL
From the AUCTION table.
CURRENCY CHARACTER (4)
NULL
From the AUCTION table.
CURRPRICE DECIMAL (20,5)
NULL
From the AUCTION table.
CURRQUANT DOUBLE
NULL
From the AUCTION table.
DEPOSIT DECIMAL (20,5)
NULL
From the AUCTION table.
DURATION TIMESTAMP
NULL
From the AUCTION table.
DURDAYS INTEGER
NULL
From the AUCTION table.
DURLENGTH INTEGER
NULL
Reserved for IBM internal use.
ENDTIME TIMESTAMP
NULL
From the AUCTION table.
FFMCENTER_ID INTEGER
NULL
From the AUCTION table.
FIELD1 BIGINT
NULL
From the AUCTION table.
FIELD2 BIGINT
NULL
From the AUCTION table.
FIELD3 DECIMAL (20,5)
NULL
From the AUCTION table.
FIELD4 DECIMAL (20,5)
NULL
From the AUCTION table.
FIELD5 VARCHAR (254)
NULL
From the AUCTION table.
FIELD6 VARCHAR (254)
NULL
From the AUCTION table.
HIGHBID_ID BIGINT
NULL
From the AUCTION table.
INVRSRVID BIGINT
NULL
Inventory reservation ID.
ITEMPAGE VARCHAR (254)
NULL
From the AUCTSTRREL auction-store relationship table.
LASTBKTIME TIMESTAMP
NULL
From the AUCTION table.
LOCKFLAG INTEGER
NULL
From the AUCTION table.
MBRGRP_ID BIGINT
NULL
From the AUCTION table.
OPENPRICE DECIMAL (20,5)
NULL
From the AUCTION table.
OWNER_ID BIGINT
NOT NULL
From the AUCTION table.
PAYMETHODS CHARACTER (254)
NULL
From the AUCTION table.
PRECEDENCE INTEGER
NULL
From the AUCTION table.
PRICELIMIT DECIMAL (20,5)
NULL
Reserved for IBM internal use.
QUANTLIMIT DOUBLE
NULL
Reserved for IBM internal use.
QUANTSCALE INTEGER
NULL
From the AUCTION table.
REALENDTIME TIMESTAMP
NULL
From the AUCTION table.
REFCODE CHARACTER (36)
NOT NULL
From the AUCTION table.
REFPRICE DECIMAL (20,5)
NULL
From the AUCTION table.
RESRVPRICE DECIMAL (20,5)
NULL
From the AUCTION table.
RETRACT_BID INTEGER
NULL
From the AUCTION table.
RULEPAGE VARCHAR (254)
NULL
From the AUCTION table.
STARTTIME TIMESTAMP
NULL
From the AUCTION table.
STATE INTEGER
NULL
From the AUCTION table.
STORE_ID INTEGER
NOT NULL
From the AUCTSTRREL auction-store relationship table.
SUPPLIER_ID BIGINT
NULL
From the AUCTION table.
UPDATETIME TIMESTAMP
NULL
From the AUCTION 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