Difference between revisions of "Schema:languages"

From ISFDB
Jump to navigation Jump to search
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 history ID.
+
* '''lang_id''' - Unique language ID.
  
 
* '''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.

Revision as of 21:04, 14 December 2012

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    |                | 
+-----------+-------------+------+-----+---------+----------------+


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.