Database Table: ORDOPTIONS

This table is used for Order notification.

Column Name Column Type Column Description
NOTIFYMERCHANT INTEGER
NULL
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
NULL
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.
ORDERS_ID BIGINT
NOT NULL
Order ID.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035021870 ORDERS_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_533 ORDERS_ID ORDERS ORDERS_ID Cascade

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