Table meta_common.regions_regions
List of regions belonging to other regions

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
parent_region_id int unsigned 10
regions.region_id fk_regions_regions_parent C
child_region_id int unsigned 10
regions.region_id fk_regions_regions_child C

Analyzed at Wed Apr 25 13:19 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
parent_region_id + child_region_id Primary key Asc/Asc PRIMARY
child_region_id Performance Asc fk_regions_regions_child

Close relationships  within of separation: