Topic Last Modified: 2012-09-28

Each record in this table represents one user in one IM conference and includes the number of messages sent by that user. Each conference is represented by multiple records in this table; one record for each user.

Column Data Type Key/Index Details

SessionIdTime

datetime

Primary, Foreign

Time of conference instance. Used in conjunction with SessionIdSeq to uniquely identify a conference instance. See the Conferences Table for more information.

SessionIdSeq

int

Primary, Foreign

ID number to identify the conference instance. Used in conjunction with SessionIdTime to uniquely identify a conference instance. See the Conferences Table for more information.

UserId

int

Foreign

Unique number identifying this user, referenced from the Users Table.

MessageCount

smallint

 

The number of messages sent by this user during this conference.