View tariqapro.rss_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
article_id int unsigned 10 0
mailing_newsletter_articles.article_id Implied Constraint R
Unique identifier of the article (url is wrong as it can appear in several feeds)
feed_id int unsigned 10 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 0000-00-00 00:00:00 Load date of the article

Analyzed at Wed Apr 25 13:31 CEST 2012


Close relationships: