Persistent Chat database schema


Última modificación del tema:2015-10-20

This documents the schema of the Chat persistente database in Skype Empresarial Server.

The Chat persistente database refers to the database corresponding to the Skype Empresarial Server Back End Server roles PersistentChatStore (corresponding to the mgc database) and PersistentChatComplianceStore (corresponding to the mgccomp database). The goal of publishing this schema is to enable you to build queries and gain some insights into building useful reporting around chat usage, active rooms, top posters, and so on.

We reserve the right to evolve this schema. Microsoft does not make any guarantees to maintain full backward compatibility with this published schema.

Follow these best practices:

  • No SELECT* // is supported because the column list can grow.

  • No user-generated schema modifications are supported.

  • No write operations are supported.

  • Test any queries that you build on representatively-sized databases to be sure that the queries can perform at a level to meet your needs.