Table studip31.smiley 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
smiley_id int unsigned 10  √ 
smiley_name varchar 50
smiley_width int 10 0
smiley_height int 10 0
short_name varchar 50
smiley_counter int unsigned 10 0
short_counter int unsigned 10 0
fav_counter int unsigned 10 0
mkdate int unsigned 10  √  null
chdate int unsigned 10  √  null

Table contained 0 rows at Do Aug 02 15:27 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
smiley_id Primary key Asc PRIMARY
smiley_name Must be unique Asc name
short_name Performance Asc short