Wikibase
MediaWiki Wikibase extension
wbt_term_in_lang

Stores a record per term with type in a language.

Part of the Item & Property Terms storage system.

Fields:

  • wbtl_id - an auto increment field
  • wbtl_type_id - reference to the wbt_type table
  • wbtl_text_in_lang_id - reference to the wbt_text_in_lang table
+----------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+----------------+
| wbtl_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| wbtl_type_id | int(10) unsigned | NO | MUL | NULL | |
| wbtl_text_in_lang_id | int(10) unsigned | NO | MUL | NULL | |
+----------------------+------------------+------+-----+---------+----------------+

Extra Indexes:

  • UNIQUE wbtl_text_in_lang_id, wbtl_type_id
  • wbtl_type_id