ORDPROMOCD

This table contains promotion codes captured for an order.

Column Descriptions:

NameTypeDescription
IDBIGINT NOT NULLThe primary key of this table.
ORDERS_IDBIGINT NOT NULLForeign key that references the ORDERS_ID column in the ORDERS table.
CODEVARCHAR (128) NOT NULLThe promotion code that is associated with this order.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>IDPrimary Key
I0000418ORDERS_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1076ORDERS_IDORDERSORDERS_IDCascade