ORDOPTIONS

This table is used for Order notification.

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ORDERS_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_533	ORDERS_ID	ORDERS	ORDERS_ID	Cascade