Reference > Database > WebSphere Commerce database tables > O

WebSphere Commerce database table: ORDOPTIONS

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... 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... 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
SQL100520030403670	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

_vcc_freeselect_bottom_

+

Search Tips   |   Advanced Search