Difference between revisions of "Schema:languages"
Jump to navigation
Jump to search
m (→Description: Wording) |
(→Description: Clarifications and a link to the ISO standard) |
||
| Line 14: | Line 14: | ||
The language table establishes language codes, names, and ID numbers. | The language table establishes language codes, names, and ID numbers. | ||
| − | * '''lang_id''' - Unique language ID. | + | * '''lang_id''' - Unique integer auto-incremented language ID. |
| − | * '''lang_name''' - Full name of | + | * '''lang_name''' - Full name of this ISO 639-2-recognized language. |
| − | * '''lang_code''' - 3-letter code abbreviation of | + | * '''lang_code''' - 3-letter code abbreviation of this language name. These codes are defined by the ISO 639-2 standard and can be viewed at [https://www.loc.gov/standards/iso639-2/php/code_list.php this Library of Congress-hosted page]. They are not displayed on ISFDB pages at this time. |
* '''latin_script''' - a Yes/No flag indicating whether the language uses a Latin-derived script. If the language supports multiple scripts (e.g. Serbian) and one of them is Latin-derived, the flag is set to 'Yes'. This flag is used by nightly cleanup reports to find records that may have been entered using the wrong script. | * '''latin_script''' - a Yes/No flag indicating whether the language uses a Latin-derived script. If the language supports multiple scripts (e.g. Serbian) and one of them is Latin-derived, the flag is set to 'Yes'. This flag is used by nightly cleanup reports to find records that may have been entered using the wrong script. | ||
Latest revision as of 15:46, 16 July 2021
Schema Summary
+--------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+----------------+ | lang_id | int(11) | NO | PRI | NULL | auto_increment | | lang_name | varchar(64) | YES | MUL | NULL | | | lang_code | varchar(10) | YES | MUL | NULL | | | latin_script | varchar(10) | YES | MUL | NULL | | +--------------+-------------+------+-----+---------+----------------+
Description
The language table establishes language codes, names, and ID numbers.
- lang_id - Unique integer auto-incremented language ID.
- lang_name - Full name of this ISO 639-2-recognized language.
- lang_code - 3-letter code abbreviation of this language name. These codes are defined by the ISO 639-2 standard and can be viewed at this Library of Congress-hosted page. They are not displayed on ISFDB pages at this time.
- latin_script - a Yes/No flag indicating whether the language uses a Latin-derived script. If the language supports multiple scripts (e.g. Serbian) and one of them is Latin-derived, the flag is set to 'Yes'. This flag is used by nightly cleanup reports to find records that may have been entered using the wrong script.