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 SourceForge.net


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