Reference > Database > WebSphere Commerce database tables > O
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 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 SQL100520030403830 ORDPAYINFO_ID Primary Key I0000179 ORDERS_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_534 ORDERS_ID ORDERS ORDERS_ID Cascade
Related reference
_vcc_freeselect_bottom_