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