Table zot.likes 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
channel_id int unsigned 10 0
channel.channel_id Implied Constraint R
liker char 128
likee char 128
iid int unsigned 10 0
verb char 255
target_type char 255
target_id char 128
target mediumtext 16777215

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
channel_id Performance Asc channel_id
iid Performance Asc iid
likee Performance Asc likee
liker Performance Asc liker
target_id Performance Asc target_id
target_type Performance Asc target_type
verb Performance Asc verb

Close relationships: