WebSphere Commerce database table: ORDOPTIONS

WebSphere Commerce database table: ORDOPTIONS

This table is used for Order notification.
Column Descriptions
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235222240 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
Related reference

Order data model

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.