ORDERMGP

This table is used to track the customer segments to which an Order is associated.

Column Descriptions:

NameTypeDescription
ORDERS_IDBIGINT NOT NULLForeign key to the ORDERS table.
MBRGRP_IDBIGINT NOT NULLForeign key to the MBRGRP table.
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_ID+MBRGRP_IDPrimary Key
I0000650MBRGRP_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_510MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_511ORDERS_IDORDERSORDERS_IDCascade