Table iliasRelease_3_10_x_branch.chat_user Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
usr_id int 10 0
ut_lp_filter.usr_id Implied Constraint R
chat_id int 10 0
room_id int 10 0
chat_rooms.room_id Implied Constraint R
last_conn_timestamp int 10  √  null
kicked tinyint 3  √  0

Table contained 0 rows at Tue Aug 26 10:32 CEST 2014

Indexes:
Column(s) Type Sort Constraint Name
usr_id + chat_id + room_id Primary key Asc/Asc/Asc PRIMARY

Close relationships: