Table zot.verify 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
id int unsigned 10  √ 
attach.id Implied Constraint R
config.id Implied Constraint R
conv.id Implied Constraint R
fcontact.id Implied Constraint R
ffinder.id Implied Constraint R
group_member.id Implied Constraint R
groups.id Implied Constraint R
item.id Implied Constraint R
item_id.id Implied Constraint R
likes.id Implied Constraint R
mail.id Implied Constraint R
photo.id Implied Constraint R
profdef.id Implied Constraint R
profext.id Implied Constraint R
profile_check.id Implied Constraint R
register.id Implied Constraint R
sign.id Implied Constraint R
sys_perms.id Implied Constraint R
xconfig.id Implied Constraint R
xign.id Implied Constraint R
channel int unsigned 10 0
type char 32
token char 255
meta char 255
created datetime 19 0000-00-00 00:00:00

Table contained 1 rows at on aug 19 21:08 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
channel Performance Asc channel
created Performance Asc created
meta Performance Asc meta
token Performance Asc token
type Performance Asc type

Close relationships: