Database Table: MBRREL

This table stores membership hierarchy relationships among users and orgEntities. Note that memberGroup is not part of the membership hierarchy.

Column Name Column Type Column Description
ANCESTOR_ID BIGINT
NOT NULL
Ancestor member ID.
DESCENDANT_ID BIGINT
NOT NULL
Descendant member ID.
SEQUENCE INTEGER
NOT NULL
A 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 is its own parent and sequence is 0.
Indexes:
Index Name Indexed Column Names Index Type
I0000328 DESCENDANT_ID, SEQUENCE Non-Unique Index
I0000336 ANCESTOR_ID, SEQUENCE Non-Unique Index
SQL030416035001320 DESCENDANT_ID, ANCESTOR_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_450 DESCENDANT_ID MEMBER MEMBER_ID Cascade
F_451 ANCESTOR_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable