View tariqapro.latestnews_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 varchar 255 Title of the article (truncated to 255 chars)
headline text 65535  √  null Title of the article (full length)
summary text 65535  √  null Summary of the article
content text 65535  √  null Body of the article
language varchar 12  √  null Language of the article
agency text 65535  √  null Name of the Press Agency
latestnews_id int unsigned 10  √  null Internal ID of the article in the LatestNews database
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: