public.countrylanguage
Documentation | World (PostgreSQL database) |
Schema | public |
Name | countrylanguage |
Module | World database diagram |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | countrycode | character(3) | public.country | Primary key. Foreign key to country.code | ||||
Primary key. Foreign key to country.code References: public.country |
||||||||
2 | language | text | Primary key. Country language. | |||||
Primary key. Country language. |
||||||||
3 | isofficial | boolean | Information on whether the language is official in a given country. | |||||
Information on whether the language is official in a given country. |
||||||||
4 | percentage | real | Percentage of language use. | |||||
Percentage of language use. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.countrylanguage | public.country | public.countrylanguage.countrycode = public.country.code | countrylanguage_countrycode_fkey Foreign key constraint referencing country.code |
|
public.countrylanguage.countrycode = public.country.code Name: countrylanguage_countrycode_fkeyForeign key constraint referencing country.code |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
countrylanguage_pkey | countrycode, language | Primary key. | |
Primary key. |
Uses
Name |
---|
public.countrylanguage
|
Exported: 2018-11-09 14:22, Last imported: 2018-08-06 09:37