WebSphere Commerce database table: MBRREL

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 Descriptions
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 does not have a parent, so its sequence is 0.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000328 DESCENDANT_ID+SEQUENCE Unique Index
SQL060903235213640 DESCENDANT_ID+ANCESTOR_ID Primary Key
I0000336 ANCESTOR_ID+SEQUENCE Non-Unique Index

Constraints
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
Related reference

Member data model

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 does not have a parent, so its sequence is 0.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Index Name	Indexed Column Names	Index Type
I0000328	DESCENDANT_ID+SEQUENCE	Unique Index
SQL060903235213640	DESCENDANT_ID+ANCESTOR_ID	Primary Key
I0000336	ANCESTOR_ID+SEQUENCE	Non-Unique Index

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