AUCTIONLOG
Deprecated. Provided for backward compatibility only.
Column Descriptions:
Name Type Description AUCT_ID BIGINT NOT NULL Reserved for IBM internal use. ACTIONTIME TIMESTAMP NOT NULL Reserved for IBM internal use. ACTIONTYPE INTEGER Reserved for IBM internal use. AUCPAYINFO_ID BIGINT Reserved for IBM internal use. OWNER_ID BIGINT Reserved for IBM internal use. ADMIN_ID BIGINT Reserved for IBM internal use. MBRGRP_ID BIGINT Reserved for IBM internal use. FFMCENTER_ID INTEGER Reserved for IBM internal use. ACTIONMSG VARCHAR (254) Reserved for IBM internal use. REFCODE CHAR (36) Reserved for IBM internal use. CATENTRY_ID BIGINT Reserved for IBM internal use. AUTYPE CHAR (4) Reserved for IBM internal use. AUSTATUS CHAR (4) Reserved for IBM internal use. AUQUANT DOUBLE Reserved for IBM internal use. BIDRULE_ID BIGINT Reserved for IBM internal use. QUANTSCALE INTEGER Reserved for IBM internal use. RESRVPRICE DECIMAL (20,5) Reserved for IBM internal use. OPENPRICE DECIMAL (20,5) Reserved for IBM internal use. CURRPRICE DECIMAL (20,5) Reserved for IBM internal use. CURRQUANT DOUBLE Reserved for IBM internal use. CLOSEPR CHAR (4) Reserved for IBM internal use. CURRENCY CHAR (4) Reserved for IBM internal use. PAYMETHODS CHAR (254) Reserved for IBM internal use. CLOSETYPE INTEGER Reserved for IBM internal use. RULEPAGE VARCHAR (254) Reserved for IBM internal use. STARTTIME TIMESTAMP Reserved for IBM internal use. ENDTIME TIMESTAMP Reserved for IBM internal use. DURATION TIMESTAMP Reserved for IBM internal use. DEPOSIT DECIMAL (20,5) Reserved for IBM internal use. BESTBID_ID BIGINT Reserved for IBM internal use. LOCKFLAG INTEGER Reserved for IBM internal use. HIGHBID_ID BIGINT Reserved for IBM internal use. UPDATETIME TIMESTAMP Reserved for IBM internal use. LASTBKTIME TIMESTAMP Reserved for IBM internal use. REALENDTIME TIMESTAMP Reserved for IBM internal use. PRECEDENCE INTEGER Reserved for IBM internal use. FIELD1 BIGINT Reserved for IBM internal use. RETRACT_BID INTEGER Reserved for IBM internal use. FIELD2 BIGINT Reserved for IBM internal use. FIELD3 DECIMAL (20,5) Reserved for IBM internal use. FIELD4 DECIMAL (20,5) Reserved for IBM internal use. FIELD5 VARCHAR (254) Reserved for IBM internal use. FIELD6 VARCHAR (254) Reserved for IBM internal use. SUPPLIER_ID BIGINT Reserved for IBM internal use. DURDAYS INTEGER Reserved for IBM internal use. REFPRICE DECIMAL (20,5) Reserved for IBM internal use. STATE INTEGER Reserved for IBM internal use. INVRSRVID BIGINT Reserved for IBM internal use. AUCMODE CHAR (4) Reserved for IBM internal use. PRICELIMIT DECIMAL (20,5) Reserved for IBM internal use. QUANTLIMIT DOUBLE Reserved for IBM internal use. DURLENGTH INTEGER Reserved for IBM internal use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> AUCT_ID+ACTIONTIME Primary Key I0000461 ADMIN_ID Non-Unique Index I0000462 FFMCENTER_ID Non-Unique Index I0000463 OWNER_ID Non-Unique Index I0000464 MBRGRP_ID Non-Unique Index I0001238 AUCPAYINFO_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_87 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade F_88 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_89 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade F_90 OWNER_ID MEMBER MEMBER_ID Cascade F_91 ADMIN_ID MEMBER MEMBER_ID Cascade