List of Persistent Chat Server tables in Lync Server 2013

Artikkeli
07/23/2014

Topic Last Modified: 2012-10-06

The Persistent Chat database schema consists of the following tables.

Active Directory Sync

Table	Description
tblADCookie in Lync Server 2013	Contains the current Lightweight Directory Access Protocol (LDAP) Sync cookies. Each row corresponds to an Active Directory Domain Services domain that Persistent Chat Server is actively monitoring for changes. (Only the Active Directory domains that are relevant for Persistent Chat Server are represented in this table.)
tblPrincipalMemberDifference in Lync Server 2013	Contains group membership changes (both added and removed members) that have not yet been processed by the later Active Directory Sync steps and is one of the temporary tables (along with tblADUpdates table) that is used in the first step of Active Directory Sync. Membership changes are stored, processed, or both, only for groups that are listed in the tblPrincipal table or that already have members listed there.
tblADUpdates in Lync Server 2013	Contains changes to Active Directory Domain Services that have not yet been processed by the later Active Directory Sync steps and is one of the temporary tables (along with the tblPrincipalMemberDifference table) that is used in the first step of Active Directory Sync. Changes to Active Directory are stored, processed, or both only for principals that are already listed in the tblPrincipal table.
tblPrincipalMembers in Lync Server 2013	Contains principal memberships.
tblPrincipalMeta in Lync Server 2013	Contains the principals that have to be refreshed from Active Directory.
tblSkippedAffiliations in Lync Server 2013	Contains affiliations that could not be refreshed for some reason, usually due to Active Directory access errors. This table is for informational purposes only. Its content is not used. The principals with affiliations that could not be refreshed properly are kept in the tblPrincipalMeta table and are given another chance to be refreshed.

Principals, Affiliations, Nodes, Scopes, and Roles

Table	Description
tblPrincipalType in Lync Server 2013	Contains principal types to categorize what is in the tblPrincipal table. This table is static. It is set up during database creation and does not change.
tblPrincipal in Lync Server 2013	Contains all principals (users, folders, groups, and so on). Persistent Chat Server handles this as a flat heterogeneous list. Various columns are based on the type of each principal. Most of these principals are cached copies of objects stored in Active Directory. Creating the cached copy in the Principal table of these Active Directory objects is referred as provisioning. Some principals are created more aggressively than others, and some Active Directory objects are ignored altogether.
tblPrincipalAffiliations in Lync Server 2013	Contains principal affiliations that describe memberships in Active Directory security groups, Active Directory containers, and so on.
tblNode in Lync Server 2013	Contains the category node, as managed in Lync Server Control Panel.
tblRoleType in Lync Server 2013	Contains role types and their associated permission sets. This lookup table is static.
tblScopePrincipal in Lync Server 2013	Contains scopes assigned to nodes.
tblPrincipalRole in Lync Server 2013	Contains roles assigned to nodes.
tblSiopWhiteList in Lync Server 2013	Contains the registered Add-ins that can be associated with nodes.
tblEnumAttribute in Lync Server 2013	Contains only the hardcoded "Visibility" and "Behavior" attributes that are used in the tblNode table.
tblEnumValue in Lync Server 2013	Contains the values of the hardcoded "Visibility” and “Behavior" attributes that are used in the tblNode table.

Invites, Chats, and Other Client Support

Table	Description
tblPrincipalInvites in Lync Server 2013	Contains invites for all provisioned users in the system for all nodes with Auto Invite enabled.
tblChat in Lync Server 2013	Contains all chat messages.
tblLastInviteId in Lync Server 2013	Contains the last invite ID that was generated (and used in the tblPrincipalInvites table) for each user.
tblLastChatId in Lync Server 2013	Contains the last chat ID that was generated (and used in the tblChat table) for each user.
tblPreference in Lync Server 2013	Contains user client preferences (used by legacy clients only).
tblFileToken in Lync Server 2013	Contains temporary tokens for file transfer purposes. Each time a file is uploaded or downloaded, the Persistent Chat service generates a token that the client uses to access the Web service file store.

Server Support

Table	Description
tblServerIdentity in Lync Server 2013	Contains the active servers in the Persistent Chat Server pool.
tblAdminLock in Lync Server 2013	Contains the administrator lock to run some administrator commands. The system revision entry in the tblSystemRevision table is incremented after each release of the lock.
tblSystemRevision in Lync Server 2013	Contains the revision number entry used (along with the tblAdminLock table) for achieving consistency across multiple servers.
tblActivePeers in Lync Server 2013	Contains current peer-to-peer connections between Persistent Chat services.
tblConfig in Lync Server 2013	Contains the Persistent Chat Server unsupported configuration.