SchemaSpy Analysis of rss_aggregator - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 25 13:20 CEST 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

rss_aggregator contains 31 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
feeds use_proxy bit 0 1 If set to 1, the feed will be downloaded through the proxy, otherwise direct connection will be used
feeds refresh_rate int unsigned 10 15 Refresh rate of the feed (in seconds). 0 means unrestricted
articles ts_article timestamp 19 CURRENT_TIMESTAMP Load date of the article
feeds has_audio enum 2 n
feeds has_pictures enum 2 n
feeds has_video enum 2 n
articles article_id int unsigned 10  √  Unique identifier of the article (url is wrong as it can appear in several feeds)
articles author text 65535  √  null Author of the article (if available)
articles comments text 65535  √  null Comment about the article (if available)
feeds copyright text 65535  √  null Copyright information
articles date datetime 19  √  null Date of publication of the article
articles description longtext 2147483647  √  null Summary of the article if available
feeds description text 65535  √  null Description of the feed
articles feed_id int unsigned 10 ID of the feed this article belongs to
feeds feed_id int unsigned 10  √  Unique identifier for the feed
newsticker_feeds feed_id int unsigned 10 The feed identifier
articles headline text 65535  √  null Title of the article (full length)
feeds language varchar 20  √  null Language of the feed (if avialable)
feeds last_refresh datetime 19  √  null Date/time at which the feed was last refreshed
articles link text 65535  √  null Link to the article
feeds link varchar 255  √  null URL of the site corresponding to the current feed
feeds manual_picture varchar 255  √  null
briefcase_templates name varchar 255
newsticker_feeds name varchar 255 The feed name
briefcase_templates path text 65535
feeds picture varchar 255  √  null URL to the embeded Logo
briefcase_templates template_id int 10  √ 
articles title text 65535  √  null Title of the article
feeds title varchar 255  √  null Title of the feed
feeds url varchar 512 Full URL of the feed. UNIQUE CONSTRAINT.
briefcase_templates user_id varchar 16