WebSphere Commerce database table: ORDOPTIONS

This table is used for Order notification.


Column Description(s):
Column NameColumn TypeDescription
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(es):
Index NameIndexed Column NamesIndex Type
SQL050212031247400 ORDERS_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_533 ORDERS_ID ORDERS ORDERS_ID Cascade

Feedback