MBRREL

This table stores member hierarchy relationships (ancestors and descendants) of organizational entities and registered users. Note that member groups are not part of the member hierarchy.

Column Descriptions:

NameTypeDescription
DESCENDANT_IDBIGINT NOT NULLDescendant member ID.
ANCESTOR_IDBIGINT NOT NULLAncestor member ID.
SEQUENCEINTEGER NOT NULLA number to indicate whether the ancestor is the parent, grandparent, great grandparent, and so on for the descendant. 1 means parent, 2 means grand parent, and so on. For the Root Organization, it does not have a parent, so its sequence is 0.
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>DESCENDANT_ID+ANCESTOR_IDPrimary Key
I0000328DESCENDANT_ID+SEQUENCEUnique Index
I0000336ANCESTOR_ID+SEQUENCENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_450DESCENDANT_IDMEMBERMEMBER_IDCascade
F_451ANCESTOR_IDMEMBERMEMBER_IDCascade