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 |