Table meta_common.official_regions
List of geographic regions or groups of countries

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
region_id int unsigned 10  √ 
countries.region_id FK_countries_official_regions R
regions.region_id Implied Constraint R
v_countries.region_id Implied Constraint R
v_sub_regions.region_id Implied Constraint R
name_en varchar 255
name_fr varchar 255
comments text 65535  √  null
continent_id int unsigned 10
continents.continent_id FK_official_regions_continents R

Analyzed at Wed Apr 25 13:19 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
region_id Primary key Asc PRIMARY
continent_id Performance Asc FK_official_regions_continents
name_en Performance Asc idx_regions_name_en
name_fr Performance Asc idx_regions_name_fr

Close relationships  within of separation: