SchemaSpy Analysis of tariqapro Generated by
SchemaSpy
Generated by SchemaSpy on Wed Apr 25 13:31 CEST 2012
Database Type: MySQL - 5.5.16 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Comments
__q_country_queries 9
__q_lexis_default_countryquery 3
__q_lexis_default_countryquery_upd 1
adv_search 2 5 The advanced search sources
backup_queries 2 9 Backup of data sources/queries to run on the search engines
channeltv 1 6 The TV channels
channeltv_categories 1 2 The categories for TV channels
clusters 4
continents 4
countries 8
countries_equiv 15
countries_reliefweb_maps 1 5 The maps from reliefweb
engines 2 10 Search engines
flavours 4 4 The countries themes
homepage_flavours 1 3 The homepage themes
languages 4
languages_equiv 5
latestnews_articles 11
latestnews_feeds 11
latestnews_feeds_countries 1 2 Stores the link latestnews feeds - countries
latestnews_feeds_themes 1 2 Stores the link latestnews feeds - themes
mailing_newsletter 1 10
mailing_newsletter_articles 2 8
mailing_newsletter_sections 1 3
newstickers_groups 1 2 The newsticker groups
newstickers_queries 2 2 The newstickers queries
queries 7 2 8 Data sources/queries to run on the search engines
queries_countries 3 6 Associates Data sources and Countries
queries_countries_tmp 6 Associates Data sources and Countries
queries_homepage 2 4 Associates Data sources and Homepage
queries_regions 3 6 Associates Data sources and Regions
queries_themes 2 5 Associates Data sources and Themes
queries_tmp 7 Data sources/queries to run on the search engines
quicksearch_sources 1 3 The sources for quick search
radio_categories 1 2 The list of radio categories
radios 1 5 The list of radio podcasts
regions 5
regions_countries 3
regions_regions 2
rss_articles 10
rss_feeds 12
rss_feeds_countries 2 Stores the connections between the feeds and the countries
rss_feeds_themes 2 Stores the connections between the feeds and the themes
sources 4 1 10 Data sources (inside search engines)
theme_users 2 2 The users that can modify a theme
themes 4 6 List of themes
themes_topics 1 1 4 The themes topics
topics_queries 2 3 The themes topics queries
users 13
v_countries 30
v_main_regions 4
v_sub_regions 8
weblogs 1 2
         
33 Tables     156  
20 Views     162