Table rss_aggregator.feeds
Stores the list of RSS feeds

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
feed_id int unsigned 10  √ 
articles.feed_id fk_articles C
newsticker_feeds.feed_id new_fk_constraint C
Unique identifier for the feed
url varchar 512 Full URL of the feed. UNIQUE CONSTRAINT.
title varchar 255  √  null Title of the feed
description text 65535  √  null Description of the feed
picture varchar 255  √  null URL to the embeded Logo
link varchar 255  √  null URL of the site corresponding to the current feed
language varchar 20  √  null Language of the feed (if avialable)
copyright text 65535  √  null Copyright information
refresh_rate int unsigned 10 15 Refresh rate of the feed (in seconds). 0 means unrestricted
last_refresh datetime 19  √  null Date/time at which the feed was last refreshed
use_proxy bit 0 1 If set to 1, the feed will be downloaded through the proxy, otherwise direct connection will be used
has_pictures enum 2 n
manual_picture varchar 255  √  null
has_video enum 2 n
has_audio enum 2 n

Analyzed at Wed Apr 25 13:20 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
feed_id Primary key Asc PRIMARY
url Performance Asc feeds_link_index

Close relationships: