Table zot.notify 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 10  √ 
addon.id Implied Constraint R
app.id Implied Constraint R
event.id Implied Constraint R
fserver.id Implied Constraint R
fsuggest.id Implied Constraint R
hook.id Implied Constraint R
manage.id Implied Constraint R
pconfig.id Implied Constraint R
profile.id Implied Constraint R
spam.id Implied Constraint R
hash char 64
name char 255
url char 255
photo char 255
date datetime 19 0000-00-00 00:00:00
msg mediumtext 16777215
aid int 10 0
uid int 10 0
link char 255
parent char 255
seen bit 0 0
type int 10 0
verb char 255
otype char 16

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
aid Performance Asc aid
date Performance Asc date
hash Performance Asc hash
link Performance Asc link
otype Performance Asc otype
parent Performance Asc parent
seen Performance Asc seen
type Performance Asc type
uid Performance Asc uid

Close relationships: