Table tariqapro.mailing_newsletter 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
newsletter_id int unsigned 10  √ 
mailing_newsletter_articles.newsletter_id fk_mailing_newsletter_articles_nl C
crea_date datetime 19 0000-00-00 00:00:00
subject text 65535
recipients text 65535
theme varchar 255 name of the visual theme to use
banner varchar 255 name of the banner to use
buzz enum 2 n if Yes, embed buzztracker's daily map in the newsletter
scrshot enum 2 n Embed a screenshot of Tarîqa
footer text 65535  √  null The foot message to print on the newsletter
sent enum 2 n if Yes, the newsletter was already sent

Analyzed at Wed Apr 25 13:31 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
newsletter_id Primary key Asc PRIMARY
newsletter_id Performance Asc ai_mailing_newsletter_id
sent Performance Asc idx_mailing_newsletter_sent

Close relationships  within of separation: