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 Column Description
NAME CHARACTER (64)
NOT NULL
The name-value pair name.
ORDERS_ID BIGINT
NOT NULL
The Order.
ORDPAYINFO_ID BIGINT
NOT NULL
Generated unique key.
VALUE VARCHAR (254)
NOT NULL
The name-value pair value. If the first character of the value is a space, then the value has been encrypted.
Indexes:
Index Name Indexed Column Names Index Type
I0000179 ORDERS_ID Non-Unique Index
SQL030416035022180 ORDPAYINFO_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_534 ORDERS_ID ORDERS ORDERS_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable