This table stores membership hierarchy relationships among users and orgEntities. Note that memberGroup is not part of the membership hierarchy.
Column Description(s):
Column Name | Column 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 is its own parent and sequence is 0. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000328 |
DESCENDANT_ID+SEQUENCE |
Unique Index |
SQL050212031239140 |
DESCENDANT_ID+ANCESTOR_ID |
Primary Key |
I0000336 |
ANCESTOR_ID+SEQUENCE |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_450 |
DESCENDANT_ID |
MEMBER |
MEMBER_ID |
Cascade |
F_451 |
ANCESTOR_ID |
MEMBER |
MEMBER_ID |
Cascade |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.