This table is used for Order notification.
Column Name | Column Type | Description |
---|---|---|
ORDERS_ID | BIGINT NOT NULL | Order ID. |
NOTIFYMERCHANT | INTEGER | Flag to indicate whether the merchant will be notified when the Order is processed as follows: 0 = do not notify the merchant when the Order is processed, 1 = notify the merchant when the Order is processed. |
NOTIFYSHOPPER | INTEGER | Flag to indicate whether the customer will be notified when the Order is processed as follows: 0 = do not notify the customer when the Order is processed, 1 = notify the customer when the Order is processed. |
OPTCOUNTER | SMALLINT | Reserved for IBM internal use. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL050212031247400 | ORDERS_ID | Primary Key |
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
---|---|---|---|---|
F_533 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |