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. |
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 |
---|---|---|---|---|