Table zot.chatroom 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
cr_id int unsigned 10  √ 
cr_aid int unsigned 10 0
cr_uid int unsigned 10 0
cr_name char 255
cr_created datetime 19 0000-00-00 00:00:00
cr_edited datetime 19 0000-00-00 00:00:00
cr_expire int unsigned 10 0
allow_cid mediumtext 16777215
allow_gid mediumtext 16777215
deny_cid mediumtext 16777215
deny_gid mediumtext 16777215

Table contained 2 rows at fr nov 06 17:11 CET 2015

Indexes:
Column(s) Type Sort Constraint Name
cr_id Primary key Asc PRIMARY
cr_aid Performance Asc cr_aid
cr_created Performance Asc cr_created
cr_edited Performance Asc cr_edited
cr_expire Performance Asc cr_expire
cr_name Performance Asc cr_name
cr_uid Performance Asc cr_uid