Wikibase/Schema/wb property info

From MediaWiki.org
Jump to navigation Jump to search

A lookup table for auxilliary information associated with wikibase properties. This information is derived from the primary data blob (read: wiki page containing JSON) describing the property.

Fields[edit]

pi_property_id[edit]

The ID if the property. Primary key. Can be joined against page.page_title if the namespace for properties is known.

pi_type[edit]

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[edit]

A JSON BLOB containing information associated with the property.

Versions[edit]

Current as of December 2016:

+----------------+------------------+------+-----+---------+-------+
| 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    |       |
+----------------+------------------+------+-----+---------+-------+