countrylanguage
Documentation | World (MySQL database) |
Name | countrylanguage |
Module | World database diagram |
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | CountryCode | char(3) | country | Primary key. Foreign key to country.code | ||||
Primary key. Foreign key to country.code References: country |
||||||||
2 | Language | char(30) | Primary key. Country language. | |||||
Primary key. Country language. |
||||||||
3 | IsOfficial | enum | Default: F | Information on whether the language is official in a given country. | ||||
Information on whether the language is official in a given country. Default: F |
||||||||
4 | Percentage | float(4, 1) | Default: 0.0 | Percentage of language use. | ||||
Percentage of language use. Default: 0.0 |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
countrylanguage | country | countrylanguage.CountryCode = country.Code | countryLanguage_ibfk_1 Foreign key constraint referencing country.Code |
|
countrylanguage.CountryCode = country.Code Name: countryLanguage_ibfk_1Foreign key constraint referencing country.Code |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PRIMARY | CountryCode, Language | Primary key. | |
Primary key. |
Uses
Name |
---|
countrylanguage
|
Exported: 2018-11-09 14:21, Last imported: 2018-08-06 09:22