Chat Users Table Schema (chat_users)


Description

Keeps track of which users are in which chat rooms

chat_users table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
chatid BIGINT 19 0
chat.id chatuser_cha2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
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

Table contained -1 rows

chat_users table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
chatuser_cha_ix Performance Asc chatid
chatuser_gro_ix Performance Asc groupid
chatuser_las_ix Performance Asc lastping
chatuser_use_ix Performance Asc userid

chat_users table relationships

Close relationships within degrees of separation