Wikibase
MediaWiki Wikibase extension
wbt_property_terms

Stores a record per term per property per language. This table is very similar to / identical to wbt_item_terms, but for properties.

Part of the Item & Property Terms storage system.

Fields:

  • wbpt_id - an auto increment field
  • wbpt_property_id - numeric value of the item ID. So P64 # 64
  • wbpt_term_in_lang_id - reference to the wbt_term_in_lang table
+----------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+----------------+
| wbpt_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| wbpt_property_id | int(10) unsigned | NO | MUL | NULL | |
| wbpt_term_in_lang_id | int(10) unsigned | NO | MUL | NULL | |
+----------------------+------------------+------+-----+---------+----------------+

Using an integer to represent the item identifier was a design decision allowing for smaller tables and faster querying.

Extra Indexes:

  • UNIQUE wbit_term_in_lang, wbit_property_id
  • wbit_property_id

Example data:

wbpt_id wbpt_property_id wbpt_term_in_lang_id
1 9 5678
6 9 1111
7 10 888