AUCTION
Deprecated. Provided for backward compatibility only.
Column Descriptions:
Name Type Description AUCT_ID BIGINT NOT NULL Reserved for IBM internal use. REFCODE CHAR (36) NOT NULL Reserved for IBM internal use. AUCPAYINFO_ID BIGINT Reserved for IBM internal use. OWNER_ID BIGINT NOT NULL Reserved for IBM internal use. CATENTRY_ID BIGINT NOT NULL Reserved for IBM internal use. ADMIN_ID BIGINT Reserved for IBM internal use. FFMCENTER_ID INTEGER Reserved for IBM internal use. AUTYPE CHAR (4) NOT NULL Reserved for IBM internal use. AUSTATUS CHAR (4) NOT NULL Reserved for IBM internal use. AUQUANT DOUBLE NOT NULL 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. REALENDTIME 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. HIGHBID_ID BIGINT Reserved for IBM internal use. LOCKFLAG INTEGER Reserved for IBM internal use. UPDATETIME TIMESTAMP Reserved for IBM internal use. LASTBKTIME TIMESTAMP Reserved for IBM internal use. PRECEDENCE INTEGER Reserved for IBM internal use. FIELD1 BIGINT Reserved for IBM internal use. FIELD2 BIGINT Reserved for IBM internal use. RETRACT_BID INTEGER 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. MBRGRP_ID BIGINT 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 Primary Key I0000022 REFCODE Unique Index I0000023 ENDTIME Non-Unique Index I0000024 REFPRICE Non-Unique Index I0000025 STATE Non-Unique Index I0000026 AUTYPE Non-Unique Index I0000027 AUSTATUS Non-Unique Index I0000028 LOCKFLAG Non-Unique Index I0000029 UPDATETIME Non-Unique Index I0000030 LASTBKTIME Non-Unique Index I0000031 STARTTIME Non-Unique Index I0000455 BIDRULE_ID Non-Unique Index I0000456 ADMIN_ID Non-Unique Index I0000457 OWNER_ID Non-Unique Index I0000458 FFMCENTER_ID Non-Unique Index I0000459 CATENTRY_ID Non-Unique Index I0000460 MBRGRP_ID Non-Unique Index I0001237 AUCPAYINFO_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_80 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade F_81 BIDRULE_ID CONTRLRULE RULE_ID Cascade F_82 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_83 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_84 FFMCENTER_ID FFMCENTER FFMCENTER_ID Cascade F_85 OWNER_ID MEMBER MEMBER_ID Cascade F_86 ADMIN_ID MEMBER MEMBER_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_112 AUCT_ID BID AUCT_ID Cascade F_457 AUCT_ID MEMBRAUCT AUCT_ID Cascade F_78 AUCT_ID AUCTDESC AUCT_ID Cascade F_92 AUCT_ID AUCTSTRREL AUCT_ID Cascade F_98 AUCT_ID AUTOBID AUCT_ID Cascade