Table zot.attach 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  √ 
verify.id Implied Constraint R
aid int unsigned 10 0
uid int unsigned 10 0
hash char 64
hubloc.hubloc_hash Defined in XML R
channel.channel_hash Defined in XML R
xchan.xchan_hash Defined in XML R
creator char 128
filename char 255
filetype char 64
filesize int unsigned 10 0
revision int unsigned 10 0
folder char 64
flags int unsigned 10 0
is_dir bit 0 0
is_photo bit 0 0
os_storage bit 0 0
os_path mediumtext 16777215
display_path mediumtext 16777215
data longblob 2147483647
created datetime 19 0000-00-00 00:00:00
edited datetime 19 0000-00-00 00:00:00
allow_cid mediumtext 16777215
allow_gid mediumtext 16777215
deny_cid mediumtext 16777215
deny_gid mediumtext 16777215

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
aid Performance Asc aid
created Performance Asc created
creator Performance Asc creator
edited Performance Asc edited
filename Performance Asc filename
filesize Performance Asc filesize
filetype Performance Asc filetype
flags Performance Asc flags
folder Performance Asc folder
hash Performance Asc hash
is_dir Performance Asc is_dir
is_photo Performance Asc is_photo
os_storage Performance Asc os_storage
revision Performance Asc revision
uid Performance Asc uid

Close relationships  within of separation: