Table zot.term 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
tid int unsigned 10  √ 
aid int unsigned 10 0
uid int unsigned 10 0
oid int unsigned 10 0
otype tinyint unsigned 3 0
type tinyint unsigned 3 0
term char 255
url char 255
imgurl char 255
term_hash char 255
parent_hash char 255

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

Indexes:
Column(s) Type Sort Constraint Name
tid Primary key Asc PRIMARY
aid Performance Asc aid
imgurl Performance Asc imgurl
oid Performance Asc oid
otype Performance Asc otype
parent_hash Performance Asc parent_hash
term Performance Asc term
term_hash Performance Asc term_hash
type Performance Asc type
uid Performance Asc uid