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:
| Name | Type | Description |
| DESCENDANT_ID | BIGINT NOT NULL | Descendant member ID. |
| ANCESTOR_ID | BIGINT NOT NULL | Ancestor 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 does not have a parent, so its sequence
is 0. |
| OPTCOUNTER | SMALLINT NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
| Name | Column Names | Type |
| <SYSTEM-GENERATED> | DESCENDANT_ID+ANCESTOR_ID | Primary Key |
| I0000328 | DESCENDANT_ID+SEQUENCE | Unique Index |
| I0000336 | ANCESTOR_ID+SEQUENCE | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_450 | DESCENDANT_ID | MEMBER | MEMBER_ID | Cascade |
| F_451 | ANCESTOR_ID | MEMBER | MEMBER_ID | Cascade |