Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| code | text | 2147483647 | null |
|
|
Full ISO-3166-2 subdivision code including country code prefix. |
|||||
| country_code | text | 2147483647 | null |
|
|
ISO-3166 alpha-2 country code. |
|||||
| name | text | 2147483647 | null |
|
|
Name of subdivision in US English. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| country_subdivisions_pkey | Primary key | Asc | code |
| country_subdivisions_country_code_idx | Performance | Asc | country_code |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| country_subdivisions_code_length | ((length(code) >= 4) AND (length(code) <= 6)) |
| country_subdivisions_code_matches_country | (substr(code, 1, 2) = country_code) |