Table rss_aggregator.articles
Stores the list of articles of each feed

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
article_id int unsigned 10  √  Unique identifier of the article (url is wrong as it can appear in several feeds)
feed_id int unsigned 10
feeds.feed_id fk_articles C
ID of the feed this article belongs to
date datetime 19  √  null Date of publication of the article
title text 65535  √  null Title of the article
headline text 65535  √  null Title of the article (full length)
description longtext 2147483647  √  null Summary of the article if available
link text 65535  √  null Link to the article
comments text 65535  √  null Comment about the article (if available)
author text 65535  √  null Author of the article (if available)
ts_article timestamp 19 CURRENT_TIMESTAMP Load date of the article

Analyzed at Wed Apr 25 13:20 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
article_id Primary key Asc PRIMARY
link Performance Asc articles_link_index
feed_id + link Must be unique Asc/Asc articles_link_unique
date Performance Asc idx_articles_date
feed_id Performance Asc idx_articles_feed_id
feed_id + date Performance Asc/Asc idx_articles_feed_id_date
ts_article Performance Asc ix_articles_ts_article

Close relationships  within of separation: