Difference between revisions of "Schema:languages"
Jump to navigation
Jump to search
(→Schema Summary: +latin_script) |
(→Description: 2016 cleanup) |
||
| Line 18: | Line 18: | ||
* '''lang_name''' - Full name of the language. | * '''lang_name''' - Full name of the language. | ||
| − | * '''lang_code''' - 3-letter code abbreviation of the Language Name. | + | * '''lang_code''' - 3-letter code abbreviation of the Language Name. These codes come from the Library of Congress and 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. | ||
Revision as of 12:50, 31 May 2016
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 language ID.
- lang_name - Full name of the language.
- lang_code - 3-letter code abbreviation of the Language Name. These codes come from the Library of Congress and 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.