WebSphere Commerce database table: AUCPAYINFO

Reserved for IBM internal use.


Column Description(s):
Column NameColumn TypeDescription
AUCPAYINFO_ID BIGINT NOT NULL Reserved for IBM internal use.
MEMBER_ID BIGINT NOT NULL Reserved for IBM internal use.
NAME CHAR(32) Reserved for IBM internal use.
PAYMETHOD CHAR(64) Reserved for IBM internal use.
DEVICE CHAR(64) Reserved for IBM internal use.
EXPDATE TIMESTAMP Reserved for IBM internal use.
ENCRYPT INTEGER DEFAULT 1 Reserved for IBM internal use.
BANKINFO VARCHAR(254) Reserved for IBM internal use.
DESCR VARCHAR(254) Reserved for IBM internal use.
BILLADDR BIGINT Reserved for IBM internal use.
COMMENTS VARCHAR(254) Reserved for IBM internal use.
CAUSE CHAR(12) Reserved for IBM internal use.
CAUSEID BIGINT Reserved for IBM internal use.
STATUS CHAR(4) Reserved for IBM internal use.
CREATETIME TIMESTAMP Reserved for IBM internal use.
FIELD1 BIGINT Reserved for IBM internal use.
FIELD2 VARCHAR(254) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031159390 AUCPAYINFO_ID Primary Key
I0000454 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_77 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_80 AUCPAYINFO_ID AUCTION AUCPAYINFO_ID Cascade
F_87 AUCPAYINFO_ID AUCTIONLOG AUCPAYINFO_ID Cascade
F_97 AUCPAYINFO_ID AUTOBID AUCPAYINFO_ID Cascade
F_102 AUCPAYINFO_ID AUTOBIDLOG AUCPAYINFO_ID Cascade
F_111 AUCPAYINFO_ID BID AUCPAYINFO_ID Cascade
F_116 AUCPAYINFO_ID BIDLOG AUCPAYINFO_ID Cascade
F_122 AUCPAYINFO_ID BIDPAYMENT AUCPAYINFO_ID Cascade

Feedback