Table iliasRelease_4_2_x_branch.chat_invitations 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
chat_id int 10 0
room_id int 10 0
guest_id int 10 0
guest_informed tinyint 3 0
invitation_time int 10 0

Table contained 0 rows at Fri Apr 22 21:41 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
chat_id + room_id + guest_id Primary key Asc/Asc/Asc PRIMARY
guest_id + guest_informed + invitation_time Performance Asc/Asc/Asc i1_idx