Lync Server 2013 中的 tblPrincipaltblPrincipal in Lync Server 2013

 

主題上次修改日期: 2012-09-12Topic Last Modified: 2012-09-12

tblPrincipal 包含所有主體,包括使用者、資料夾及群組。tblPrincipal contains all principals, including users, folders, and groups.

ColumnsColumns

Column 類型Type 描述Description

Tblprincipal.prinidprinID

int,非 nullint, not null

主體識別碼。Principal ID.

prinGuidprinGuid

GUID,非 nullGUID, not null

主體 GUID。Principal GUID. 因為它的意義會跨越 Active Directory 網域服務空間,所以這會被廣泛當作替代主鍵使用。This is broadly used as an alternate primary key because its meaning crosses over into the Active Directory Domain Services space. (快取主體的 GUID 等於對應的 Active Directory 物件 GUID。 ) (The GUID for a cached principal is equal to the corresponding Active Directory object GUID.)

prinUriprinUri

nvarchar (256),非 nullnvarchar (256), not null

主體 URI。SIP 配置可用於使用者,而 ma-grp 幾乎可用於其他所有項目。Principal URI. The SIP scheme is used for users, and ma-grp is used for almost everything else.

prinNameprinName

nvarchar(256)nvarchar (256)

一般名稱。僅可用於使用者類型。Common name. Used only by user types.

prinDisplayNameprinDisplayName

Nvarchar (256)Nvarchar (256)

顯示名稱。僅可用於使用者類型。Display name. Used only by user types.

prinCompanyNameprinCompanyName

nvarchar(256)nvarchar (256)

公司名稱。僅可用於使用者類型。Company name. Used only by user types.

prinEmailprinEmail

nvarchar(256)nvarchar (256)

電子郵件。僅可用於使用者類型。Email. Used only by user types.

prinADPathprinADPath

nvarchar (384)nvarchar (384)

Active Directory 物件 (主體為快取版本) 的網域名稱。非 Active Directory 物件的類型可以是 Null (例如系統使用者)。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 system users).

prinADUserPrincipalNameprinADUserPrincipalName

nvarchar(256)nvarchar (256)

使用者的使用者主體名稱 (UPN)。僅可用於一般使用者類型。User’s user principal name (UPN). Used only by regular user types.

prinDisabledprinDisabled

smallint,非 nullsmallint, not null

  • 0:主體為作用中狀態。0: Principal is active.

  • 1:主體已停用,因為使用者的 SIP 功能已停用。1: Principal is disabled because user’s SIP capabilities are disabled.

  • 2:主體已刪除,因為相關聯的 AD 物件已刪除。2: Principal is deleted because associated AD object has been deleted.

prinTypeIDprinTypeID

smallint,非 nullsmallint, not null

主體類型 (參照 tblPrincipalType 表格)。Principal type (from tblPrincipalType table).

prinPoolIDprinPoolID

臨界值Int

主體的 Lync 集區指派。Lync pool assignment for the principal.

prinPolicyIDprinPolicyID

臨界值Int

如果存在標記類型原則,則為 user 的 Persistent Chat Server policy value。Persistent Chat Server policy value for user, if tag type policy is present.

prinAddedByprinAddedBy

intint

建立者的主體識別碼。Principal ID of the creator.

prinAddedOnprinAddedOn

bigint,非 nullbigint, not null

建立時間的時間戳記。Time stamp for the creation time.

prinUpdatedByprinUpdatedBy

intint

最近一次進行更新之主體的識別碼。ID of the principal that last updated this.

prinUpdatedOnprinUpdatedOn

bigint,非 nullbigint, not null

最近一次更新的時間戳記。Time stamp for the last update.

prinVerifiedOnprinVerifiedOn

datetime,非 nulldatetime, not null

最近一次主體之 Active Directory Sync 重新整理的日期與時間。Date and time of the last Active Directory Sync refresh for the principal.

索引鍵Keys

Column 描述Description

Tblprincipal.prinidprinID

主索引鍵。Primary key.

prinTypeIDprinTypeID

在 tblPrincipalType.ptypeID 表格中查閱外部索引鍵。Foreign key with lookup in tblPrincipalType.ptypeID table.