User table in Lync Server 2013
Topic Last Modified: 2012-10-02
The User table is a supporting table that stores a list of the various users who have participated in sessions recorded in the database. Each record in the table represents one user.
| Column | Data Type | Key/Index | Details |
|---|---|---|---|
UserKey |
int |
Primary |
Unique number identifying this user. |
URI |
nvarchar(450) |
Unique |
URI string. |
URIType |
int |
1 is unknown URI type. 2 is user URI. 4 is conference URI. 8 is phone URI. |
|
TenantKey |
int |
Foreign |
Tenant of the user, referenced from tenant table. |
LastPoorCallTime |
datetime |
Latest time stamp when the user had a poor audio call. |
|
NextUpdateTS |
datetime |
For internal use only. |