AUTOBID
Deprecated. Provided for backward compatibility only.
Column Descriptions:
Name Type Description AUTOBID_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. STORE_ID INTEGER Reserved for IBM internal use. ADMIN_ID BIGINT Reserved for IBM internal use. AUCT_ID BIGINT NOT NULL Reserved for IBM internal use. ABQUANT DOUBLE NOT NULL Reserved for IBM internal use. PAYTYPE CHAR (64) NOT NULL Reserved for IBM internal use. ENCRYPT INTEGER NOT NULL Reserved for IBM internal use. DEVICE VARCHAR (64) NOT NULL Reserved for IBM internal use. EXPDATE TIMESTAMP NOT NULL Reserved for IBM internal use. QUANTSCALE INTEGER Reserved for IBM internal use. MAXBIDLIMIT DECIMAL (20,5) Reserved for IBM internal use. ABSTATUS CHAR (4) Reserved for IBM internal use. WINOPT CHAR (4) Reserved for IBM internal use. ABTIME TIMESTAMP Reserved for IBM internal use. LASTBID_ID BIGINT Reserved for IBM internal use. BID_ID BIGINT Reserved for IBM internal use. BKNAME VARCHAR (254) Reserved for IBM internal use. SHIPTO_ID BIGINT Reserved for IBM internal use. SHIPMODE INTEGER Reserved for IBM internal use. BIDMSG VARCHAR (254) Reserved for IBM internal use. MSGFLAG INTEGER Reserved for IBM internal use. STARTTIME TIMESTAMP Reserved for IBM internal use. ENDTIME TIMESTAMP Reserved for IBM internal use. ABFIELD1 BIGINT Reserved for IBM internal use. ABFIELD2 DECIMAL (20,5) Reserved for IBM internal use. ABFIELD3 VARCHAR (254) Reserved for IBM internal use. BILLADDR BIGINT Reserved for IBM internal use. INITBIDVAL DECIMAL (20,5) Reserved for IBM internal use. OPTCOUNTER SMALLINT NOT NULL DEFAULT 0 Reserved for IBM internal use.
Indexes:
Name Column Names Type <SYSTEM-GENERATED> AUTOBID_ID Primary Key I0000034 REFCODE Unique Index I0000035 BID_ID Non-Unique Index I0000036 ABQUANT Non-Unique Index I0000037 MAXBIDLIMIT Non-Unique Index I0000038 ABSTATUS Non-Unique Index I0000467 STORE_ID Non-Unique Index I0000468 ADMIN_ID Non-Unique Index I0000469 OWNER_ID Non-Unique Index I0001240 AUCT_ID Non-Unique Index I0001241 AUCPAYINFO_ID Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_100 OWNER_ID MEMBER MEMBER_ID Cascade F_101 ADMIN_ID MEMBER MEMBER_ID Cascade F_97 AUCPAYINFO_ID AUCPAYINFO AUCPAYINFO_ID Cascade F_98 AUCT_ID AUCTION AUCT_ID Cascade F_99 STORE_ID STORE STORE_ID Cascade