Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
tariqapro
.
latestnews_articles
Generated by
SchemaSpy
Implied relationships
Related columns
Constraints
Comments
Legend
Legend:
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: