Table meta_common.regions_countries
List of regions belonging to some 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.region_id fk_regions_countries_regions C
country_id varchar 2
countries.country_id fk_regions_countries_countries C
comments text 65535  √  null

Analyzed at Wed Apr 25 13:19 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
region_id + country_id Primary key Asc/Asc PRIMARY
country_id Performance Asc fk_regions_countries_countries

Close relationships  within of separation: