WebSphere Commerce database table: MBRREL

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


Column Description(s):
Column NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000328 DESCENDANT_ID+SEQUENCE Unique Index
SQL050212031239140 DESCENDANT_ID+ANCESTOR_ID Primary Key
I0000336 ANCESTOR_ID+SEQUENCE Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_450 DESCENDANT_ID MEMBER MEMBER_ID Cascade
F_451 ANCESTOR_ID MEMBER MEMBER_ID Cascade

Feedback