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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000179 | ORDERS_ID | Non-Unique Index |
SQL030416035022180 | ORDPAYINFO_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_534 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|