Wikibase/Schema/wb_property_info

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

pi_property_id

The ID if the property. Primary key. 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.

Versions

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