Principal Table

 

Topic Last Modified: 2011-02-03

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.
prinTypeID	smallint, not null	Principal type (from PrincipalType table).
prinAllowedPermSet	bigint, not null	Principal user rights and permissions (as set in the Manage Users and User Groups Microsoft Lync Server 2010, Group Chat Admin Tool window) when prinUseInheritedPerms is False. Primary bits: 0: True if the principal can post files. 1: True if the principal is an administrator with administrator rights and permissions to manage users and groups (in Manage Users and User Groups). 2: True if the principal is an administrator with administrator rights and permissions to manage nodes (categories and chat rooms).
prinUseInheritedPerms	bit, not null	False if the principal has the user rights and permissions defined by prinAllowedPermSet. True if the principal inherits the user rights and permissions from its groups, containers, and so on, in an additive manner.
prinAddedBy	int	Principal ID of the creator.
prinAddedOn	bigint, not null	Time stamp for the creation time.
prinUpdatedBy	int	ID of the principal that last updated this.
prinUpdatedOn	bigint, not null	Time stamp for the last update.
prinVerifiedOn	datetime, not null	Date and time of the last Active Directory Sync refresh for the principal.

Keys

Column	Description
prinID	Primary key.
prinTypeID	Foreign key with lookup in PrincipalType.ptypeID table.