SchemaSpy Analysis of tariqapro | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Apr 25 13:31 CEST 2012 | |
Database Type: MySQL - 5.5.16 |
|
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 |