tblPrincipalAffiliations

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.