Wikibase
MediaWiki Wikibase extension
wb_property_info

Part of the Property Info storage system.

Fields:

  • pi_property_id - Numeric representation of the Pid. P64 -> 64.
    • Can be joined against page.page_title if the namespace for Properties is known.
  • pi_type - The data type of the property.
    • This is repeated from the content of pi_info to allow properties to be queried by type efficiently.
  • pi_info - A JSON BLOB containing information associated with the property.
+----------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| pi_property_id | int(10) unsigned | NO | PRI | NULL | |
| pi_type | varbinary(32) | NO | MUL | NULL | |
| pi_info | blob | NO | | NULL | |
+----------------+------------------+------+-----+---------+-------+

Extra Indexes:

  • pi_type - Allowing queries by Property type (Eg. string, url etc.)

Example data:

pi_property_id pi_type pi_info
18 commonsMedia {"type":"commonsMedia","formatterURL":"https:\/\/commons.wikimedia.org\/wiki\/File:$1"}
20 wikibase-item {"type":"wikibase-item"}
353 external-id {"type":"external-id","formatterURL":"https:\/\/www.genenames.org\/tools\/search\/#!\/all?query=$1"}