country_subdivisions

57 rows


Description

Country subdivision (state, province, region, etc.) information per ISO-3166-2.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
code text 2147483647 null
organizations.country_subdivision_code organizations_country_subdivision_code_fkeyR

Full ISO-3166-2 subdivision code including country code prefix.

country_code text 2147483647 null
countries.code country_subdivisions_country_code_fkeyR

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_matches_country ((substr(code, 1, 2) = country_code))
country_subdivisions_code_length (((length(code) >= 4) AND (length(code) <= 6)))

Relationships