What is Member Data Model?

MEMBER DATA MODEL

Deals with users, user groups, organizational entities and roles.

Tables:
-MEMBER : Can be considered as a superset of USERS. It contains members of type O- OrgEntity, U- Users , G- MemberGroup

-MBRGRP & MBRGRPMBR : Contain User Groups and user belonging to a particular user group
select * from member where member_id=8000000000000001003;  -- A member group (G)
select * from member where member_id=451064;  -- A user ( U)
select * from mbrgrp where mbrgrp_id=8000000000000001003;  -- Member group (G) entry should be there in MBRGRP table also
select * from mbrgrpmbr where member_id=451064; -- User (U) belongs to one particular Group (G)

-USERS : Contains registered users, guest users, and generic users. Subset of MEMBER.
-USERDEMO & USERPROF  : Additional info for USERS
-USERREG : Contains Registered users
-USERPWDHST :  stores the previously used passwords of a registered user.
-ADDRESS : Stores addresses of a member
-ADDRBOOK:  Container for all addresses of a member. Only one address book per member.

-MBRREL : Relates user and OrgEntity
select * from USERS where dn like '%bv21%';  -- users_id=63341484
select * from MEMBER where member_id=63341484; -- It is a user -U
select * from MBRREL where descendant_id=63341484; -- Relates a User -U to OrgEntity -O
 "DESCENDANT_ID"         "ANCESTOR_ID"    "SEQUENCE"  "OPTCOUNTER"
  63341484  -2000   1       8338
  63341484  -2001   2       8913
(Sequence column: Relation to ancestor -1 means parent, 2 means grand parent, and so on.)

-MBRROLE : Assigns the reg. user a ‘role ‘ for the ‘OrgEntity’ for which he performs that role.
select * from MBRROLE where member_id=63341484;  --Assigns Role for an OrgEntity
 "MEMBER_ID"      "ROLE_ID" "ORGENTITY_ID"   "OPTCOUNTER"
63341484 -29    7000000000000001554       19070
select * from ROLE where role_id=-29;  -- Role here is Registered user.
select * from ORGENTITY where orgentity_id=7000000000000001554; -- A Org Unit (OU)