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. |
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 |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|