Topic Last Modified: 2012-09-12
tblPrincipalAffiliations contains the principal affiliations that describe memberships in locations, including Active Directory Domain Services 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. |