Table tariqa3.user_articles 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
assoc_id int unsigned 10  √ 
user_id varchar 16
known_users.user_id FK_user_articles_users C
article_id varchar 255 The article identifier
ts timestamp 19 CURRENT_TIMESTAMP The current time

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
assoc_id Primary key Asc PRIMARY
user_id Performance Asc FK_user_articles_users

Close relationships  within of separation: