Topic Last Modified: 2010-03-07
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 timestamp when the user had a poor audio call. |
|
|
NextUpdateTS |
Datetime |
For internal use only. |