Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
tariqapro
.
rss_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
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: