chat_users

0 rows


Description

Keeps track of which users are in which chat rooms

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
chatid BIGINT 19 0
chat.id chatuser_cha2_fkR
userid BIGINT 19 0
user.id Implied ConstraintR
groupid BIGINT 19 0
version VARCHAR 16
ip VARCHAR 45
firstping BIGINT 19 0
lastping BIGINT 19 0
lastmessageping BIGINT 19 0
sid VARCHAR 32
course BIGINT 19 0
lang VARCHAR 30

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
chatuser_cha4_ix Performance Asc chatid
chatuser_gro2_ix Performance Asc groupid
chatuser_las2_ix Performance Asc lastping
chatuser_use2_ix Performance Asc userid

Relationships