SchemaSpy Analysis of rss_aggregator - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Apr 25 13:20 CEST 2012 |
| ||||||
|
rss_aggregator contains 31 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
articles | article_id | int unsigned | 10 | √ | Unique identifier of the article (url is wrong as it can appear in several feeds) | ||
feeds | feed_id | int unsigned | 10 | √ | Unique identifier for the feed | ||
briefcase_templates | template_id | int | 10 | √ | |||
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 | |||
newsticker_feeds | feed_id | int unsigned | 10 | The feed identifier | |||
feeds | has_audio | enum | 2 | n | |||
feeds | has_pictures | enum | 2 | n | |||
feeds | has_video | enum | 2 | n | |||
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 | |
feeds | refresh_rate | int unsigned | 10 | 15 | Refresh rate of the feed (in seconds). 0 means unrestricted | ||
articles | title | text | 65535 | √ | null | Title of the article | |
feeds | title | varchar | 255 | √ | null | Title of the feed | |
articles | ts_article | timestamp | 19 | CURRENT_TIMESTAMP | Load date of the article | ||
feeds | url | varchar | 512 | Full URL of the feed. UNIQUE CONSTRAINT. | |||
feeds | use_proxy | bit | 0 | 1 | If set to 1, the feed will be downloaded through the proxy, otherwise direct connection will be used | ||
briefcase_templates | user_id | varchar | 16 |