Principal Table

The Principal table contains all principals, including users, folders, and groups.

Columns

Column

Type

Description

prinID

int, not null

Principal ID.

prinGuid

uuid, not null

Principal GUID. This is broadly used as an alternate primary key because its meaning crosses over into the Active Directory Domain Services (AD DS) space. (The GUID for a cached principal is equal to the corresponding Active Directory object GUID.)

prinUri

nvarchar (256), not null

Principal URI. The sip scheme is used for users, and ma-grp is used for almost everything else.

prinName

nvarchar (256)

Display name. Used only by user types.

prinCompanyName

nvarchar (256)

Company name. Used only by user types.

prinEmail

nvarchar (256)

Email. Used only by user types.

prinADPath

nvarchar (256)

Domain name of the Active Directory object that the principal is a cached version of. Can be Null for types that are not Active Directory objects (such as federated users, system users, and federated groups).

prinADUserPrincipalName

nvarchar (256)

User’s user principal name (UPN). Used only by regular user types.

prinDisabled

bit, not null

True if the principal is considered disabled. This is used when a user leaves the company or the user’s SIP capabilities are disabled.