Database Table: AUCPAYINFO

Reserved for IBM internal use.

Column Name Column Type Column Description
AUCPAYINFO_ID BIGINT
NOT NULL
Reserved for IBM internal use.
BANKINFO VARCHAR (254)
NULL
Reserved for IBM internal use.
BILLADDR BIGINT
NULL
Reserved for IBM internal use.
CAUSE CHARACTER (12)
NULL
Reserved for IBM internal use.
CAUSEID BIGINT
NULL
Reserved for IBM internal use.
COMMENTS VARCHAR (254)
NULL
Reserved for IBM internal use.
CREATETIME TIMESTAMP
NULL
Reserved for IBM internal use.
DESCR VARCHAR (254)
NULL
Reserved for IBM internal use.
DEVICE CHARACTER (64)
NULL
Reserved for IBM internal use.
ENCRYPT INTEGER
NULL, DEFAULT 1
Reserved for IBM internal use.
EXPDATE TIMESTAMP
NULL
Reserved for IBM internal use.
FIELD1 BIGINT
NULL
Reserved for IBM internal use.
FIELD2 VARCHAR (254)
NULL
Reserved for IBM internal use.
MEMBER_ID BIGINT
NOT NULL
Reserved for IBM internal use.
NAME CHARACTER (32)
NULL
Reserved for IBM internal use.
PAYMETHOD CHARACTER (64)
NULL
Reserved for IBM internal use.
STATUS CHARACTER (4)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034838930 AUCPAYINFO_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_77 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
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
F_80 AUCPAYINFO_ID AUCTION AUCPAYINFO_ID Cascade
F_87 AUCPAYINFO_ID AUCTIONLOG AUCPAYINFO_ID Cascade
F_97 AUCPAYINFO_ID AUTOBID AUCPAYINFO_ID Cascade