Table meta_common.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  √ 
regions_countries.region_id fk_regions_countries_regions C
regions_regions.child_region_id fk_regions_regions_child C
regions_regions.parent_region_id fk_regions_regions_parent C
official_regions.region_id Implied Constraint R
name_en varchar 255
name_fr varchar 255
comments text 65535  √  null
sub_region enum 2 0 1 If the region describes a subpart of a country; 0 if it is a group of countries

Analyzed at Wed Apr 25 13:19 CEST 2012

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

Close relationships  within of separation: