ORDOPTIONS

This table is used for Order notification.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLOrder ID.
NOTIFYMERCHANTINTEGERFlag 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.
NOTIFYSHOPPERINTEGERFlag 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.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ORDERS_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_533ORDERS_IDORDERSORDERS_IDCascade