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