Difference between revisions of "Schema:languages"

From ISFDB
Jump to navigation Jump to search
(→‎Schema Summary: +latin_script)
Line 1: Line 1:
 
==Schema Summary==
 
==Schema Summary==
  
  +-----------+-------------+------+-----+---------+----------------+
+
  +--------------+-------------+------+-----+---------+----------------+
  | Field     | Type        | Null | Key | Default | Extra          |
+
  | Field       | Type        | Null | Key | Default | Extra          |
  +-----------+-------------+------+-----+---------+----------------+
+
  +--------------+-------------+------+-----+---------+----------------+
  | lang_id   | int(11)    | NO  | PRI | NULL    | auto_increment |
+
  | lang_id     | int(11)    | NO  | PRI | NULL    | auto_increment |
  | lang_name | varchar(64) | YES  | MUL | NULL    |                |
+
  | lang_name   | varchar(64) | YES  | MUL | NULL    |                |
  | lang_code | varchar(10) | YES  | MUL | NULL    |                |  
+
  | lang_code   | varchar(10) | YES  | MUL | NULL    |                |
  +-----------+-------------+------+-----+---------+----------------+
+
| latin_script | varchar(10) | YES  | MUL | NULL    |                |  
 
+
  +--------------+-------------+------+-----+---------+----------------+
  
 
==Description==
 
==Description==

Revision as of 12:46, 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.