STOREMBRGP

Each row of this table indicates that a Store recognizes a MemberGroup as a customer group.

Column Descriptions:

NameTypeDescription
MBRGRP_IDBIGINT NOT NULLThe MemberGroup.
STORE_IDINTEGER NOT NULLThe Store.
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>MBRGRP_ID+STORE_IDPrimary Key
I0000793STORE_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_801MBRGRP_IDMBRGRPMBRGRP_IDCascade
F_802STORE_IDSTORESTORE_IDCascade