ORDAUDIT

Stores audit records for each order line submitted

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLThe ID of the order.
STOREENT_IDINTEGER NOT NULLThe ID of the store where the order is placed from.
LINECOUNTBIGINT NOT NULLThe number of order lines in an order.
TIMEPLACEDTIMESTAMP NOT NULLThe time when the order was submitted.
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
P_0032ORDERS_IDPrimary Key
I0001522TIMEPLACEDNon-Unique Index