app_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 bigserial 19 nextval('app_chat_users_id_seq'::regclass)
chatid int8 19 0
app_chat.id Defined in XMLR
userid int8 19 0
groupid int8 19 0
version varchar 16 ''::character varying
ip varchar 45 ''::character varying
firstping int8 19 0
lastping int8 19 0
lastmessageping int8 19 0
sid varchar 32 ''::character varying
course int8 19 0
lang varchar 30 ''::character varying

Indexes

Constraint Name Type Sort Column(s)
app_chatuser_id_pk Primary key Asc id
app_chatuser_cha_ix Performance Asc chatid
app_chatuser_gro_ix Performance Asc groupid
app_chatuser_las_ix Performance Asc lastping
app_chatuser_use_ix Performance Asc userid

Relationships