Schema:languages

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.