.png)
tblPrincipalAffiliations
Topic Last Modified: 2012-09-12
tblPrincipalAffiliations contains the principal affiliations that describe memberships in locations, including Active Directory Domain Services (AD DS) security groups, in Active Directory containers, in domains.
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 tblPrincipal.prinID table. |
| affiliationID | Foreign key with lookup in tblPrincipal.prinID table. |
