0 rows


Communication records


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
communication_customlink.commid commcust_com2_fkR
communication_user.commid commuser_com2_fkR
matrix_room.commid matrroom_com2_fkR
contextid BIGINT 19 null comm_con2_fkR

The id of the context that this communication instance relates to

instanceid BIGINT 19 null

ID of the instance where the communication is a part of

component VARCHAR 100

Component of the instance where the communication room is a part of

instancetype VARCHAR 100

The type of the instance for the given component

provider VARCHAR 100

Name of the selected communication provider

roomname VARCHAR 255 null

Name of the communication room

avatarfilename VARCHAR 100 null

Name of the avatar file name for the communication instance

active BIT 1 1

The communication instance is active or not

avatarsynced BIT 1 0

Indicate if the avatar has been synced with the provider


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
comm_con_ix Performance Asc contextid