Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MBRREL
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 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 SQL100520030354560 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
_vcc_freeselect_bottom_