Topic Last Modified: 2010-11-09
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. |