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_


+

Search Tips   |   Advanced Search