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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|