Table tariqa3.languages
List of languages (iso 639-2/b)

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
language_id varchar 2
translation_values.language_id fk_translation_values_languages C
ISO 639-1
iso_639_1 varchar 2  √  null ISO 639-1
iso_639_2 varchar 3  √  null ISO 639-2
name_en varchar 255 ISO 639-2/B
name_fr varchar 255 ISO 639-2/B
name varchar 255 Name in original language
dir varchar 3 rtl Horizontal direction of the text

Analyzed at Wed Apr 25 13:30 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
language_id Primary key Asc PRIMARY
name_en Performance Asc idx_languages_name_en
name_fr Performance Asc idx_languages_name_fr

Close relationships  within of separation: