Table tariqapro.mailing_newsletter_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  √ 
latestnews_articles.article_id Implied Constraint R
rss_articles.article_id Implied Constraint R
newsletter_id int unsigned 10 0
mailing_newsletter.newsletter_id fk_mailing_newsletter_articles_nl C
section_id int unsigned 10 0
mailing_newsletter_sections.section_id fk_mailing_newsletter_articles_se C
title text 65535  √  null
link text 65535  √  null
content text 65535  √  null
n smallint 5 0
data text 65535  √  null if not null: it is the content of the article, otherwise it is stored in the title/link/content fields

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
article_id Primary key Asc PRIMARY
article_id Performance Asc ai_mailing_article_id
newsletter_id Performance Asc fk_mailing_newsletter_articles_nl
section_id Performance Asc fk_mailing_newsletter_articles_se

Close relationships: