uw_country


Description

A country of the world

Columns

Column Type Size Nulls Auto Default Children Parents Comments
country_code text 2147483647 null
adm_appl_referee.referee_country adm_appl_referee_referee_country_fkeyR
adm_std_employment.country_code adm_std_employment_country_code_fkeyR
std_citizenship.country_code std_citizenship_country_code_fkeyR
uw_country_citizenship.country_code uw_country_citizenship_country_code_fkeyR
uw_ext_org.country_code uw_ext_org_country_code_fkeyR
uw_location.country_code uw_location_country_code_fkeyR
uw_location_history.country_code uw_location_history_country_code_fkeyR
country_name text 2147483647 null

The full name of the country

country_short_name text 2147483647 null

The short name of the country

country_short_code text 2147483647 null

The two-letter ISO code for the country

Table contained 254 rows

Indexes

Constraint Name Type Sort Column(s)
uw_country_pkey Primary key Asc country_code
uw_country_country_short_code_key Must be unique Asc country_short_code

Relationships