SchemaSpy Analysis of meta_common | Generated by SchemaSpy |
Generated by SchemaSpy on Wed Apr 25 13:19 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 |
---|---|---|---|---|
clusters | 1 | 4 | Stores the list of clusters, given by the country cluster an | |
continents | 2 | 5 | List of continents | |
countries | 3 | 4 | 12 | List of countries (ISO 3166-1 and 3166-2) |
countries_equiv | 1 | 17 | Country codes conversion table | |
languages | 1 | 4 | List of languages (ISO 639-2/B) | |
languages_equiv | 1 | 5 | Language codes conversion table | |
official_regions | 1 | 1 | 5 | List of geographic regions or groups of countries |
regions | 3 | 5 | List of geographic regions or groups of countries | |
regions_countries | 2 | 3 | List of regions belonging to some countries | |
regions_regions | 2 | 2 | List of regions belonging to other regions | |
users | 13 | Permanence System - ACL | ||
v_countries | 30 | |||
v_main_regions | 4 | |||
v_sub_regions | 8 | |||
11 Tables | 75 | |||
3 Views | 42 |