WebSphere Commerce database table: ORDPAYINFO
Each row in this table holds a name-value pair representing payment information for a particular Order. Values added to this table are encrypted when the "Instance/PDIEncrypt" configuration flag is "on".
Column Descriptions Column Name Column Type Description ORDERS_ID BIGINT NOT NULL The Order. ORDPAYINFO_ID BIGINT NOT NULL Generated unique key. NAME CHAR(64) NOT NULL The name-value pair name. VALUE VARCHAR(512) NOT NULL The name-value pair value. If the first character of the value is a space, then the value has been encrypted. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL060903235222430 ORDPAYINFO_ID Primary Key I0000179 ORDERS_ID Non-Unique Index Related reference
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_534 ORDERS_ID ORDERS ORDERS_ID Cascade