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 10 null
chatid bigint 11 0
chat.id chatuser_cha2_fk R
userid bigint 11 0
groupid bigint 11 0
version varchar 16
ip varchar 45
firstping bigint 10 0
lastping bigint 10 0
lastmessageping bigint 10 0
sid varchar 32
course bigint 10 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