Topic Last Modified: 2011-01-27
The PrincipalAffiliations table contains the principal affiliations that describe memberships in locations including Active Directory Domain Services (AD DS) security groups, in Active Directory containers, in federated groups.
Columns
| Column | Type | Description |
|---|---|---|
|
principalID |
int, not null |
ID of the affiliated principal. |
|
affiliationID |
int, not null |
ID of the principal representing the affiliation. Each principal (except system-user-types) has a self-affiliation as well. |
|
index |
int, not null |
Index. The value for self-affiliations is -1, and for the other affiliations it increases sequentially from 1 within each <principalID, affiliationId> bucket. |
|
updatedBy |
int, not null |
Principal that did the latest update. This is usually 1, which means Active Directory Sync. |
Keys
| Columns | Description |
|---|---|
|
<principalID, index, affiliationID> |
Primary key. |
|
principalID |
Foreign key with lookup in Principal.prinID table. |
|
affiliationID |
Foreign key with lookup in Principal.prinID table. |