Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
View
meta_common
.
v_sub_regions
Generated by
SchemaSpy
Implied relationships
Related columns
Constraints
Comments
Legend
Legend:
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
0
parent_region_name_en
varchar
255
parent_region_name_fr
varchar
255
parent_region_comments
text
65535
√
null
region_id
int unsigned
10
0
official_regions
.region_id
Implied Constraint
R
region_name_en
varchar
255
region_name_fr
varchar
255
region_comments
text
65535
√
null
Analyzed at Wed Apr 25 13:19 CEST 2012
Close relationships: