Table zot.photo 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
xchan char 255
xchan.xchan_hash Defined in XML R
resource_id char 255
created datetime 19 0000-00-00 00:00:00
edited datetime 19 0000-00-00 00:00:00
title char 255
description text 65535
album char 255
filename char 255
type char 128 image/jpeg
height smallint 5 0
width smallint 5 0
size int unsigned 10 0
data mediumblob 16777215
scale tinyint 3 0
photo_usage smallint 5 0
profile bit 0 0
is_nsfw bit 0 0
os_storage bit 0 0
os_path mediumtext 16777215
display_path mediumtext 16777215
photo_flags int unsigned 10 0
allow_cid mediumtext 16777215
allow_gid mediumtext 16777215
deny_cid mediumtext 16777215
deny_gid mediumtext 16777215

Table contained 5 888 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
album Performance Asc album
is_nsfw Performance Asc is_nsfw
os_storage Performance Asc os_storage
photo_flags Performance Asc photo_flags
photo_usage Performance Asc photo_usage
profile Performance Asc profile
resource_id Performance Asc resource_id
scale Performance Asc scale
size Performance Asc size
type Performance Asc type
uid Performance Asc uid
xchan Performance Asc xchan

Close relationships  within of separation: