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
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
course.id chatuser_cou2_fkR
lang VARCHAR 30

Indexes

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

Relationships