Topic Last Modified: 2010-03-26
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. Reference to the Conferences Table. |
SessionIdSeq |
int |
Primary, Foreign |
ID number to identify the conference instance. Used in conjunction with SessionIdTime to uniquely identify a conference instance. Reference to the Conferences Table. |
UserId |
int |
Primary, Foreign |
Unique number identifying this user, referenced from the Users Table. |
MessageCount |
smallint |
|
The number of messages sent by this user during this conference. |