anl_conversation_history

Stores historical conversations.

Table 1. anl_conversation_history table
Column Description Example
conversation_id

bigint

System-generated conversation type identifier.

3654729
event_id

bigint

The event identifier from the source.

4457523
conversation_type_id

bigint

The conversation type identifier (1 or 2).

2
conversation_type

varchar

The conversation type (GROUP-CLINICAL or GROUP-ADHOC).

GROUP-ADHOC
jid1

varchar

The conversation initiator for the conference room, or the first user identified in alphbetical order.

jid2

varchar

The conversation initiator for the second user, or the static string ROOM.

ROOM
topic

varchar

The conversation topic.

 
created_at

datetime

The date when the conversation was created.

2017-11-14 08:52:57.512595
source_id

bigint

The source identifier of the appliance that is providing data.

1
control_id

bigint

The control identifier when the record was loaded.

12644