Jump to content

Wikibase/Schema/wbs_propertypairs

From mediawiki.org

The wbs_propertypairs table stores statistics on property usage. It has statistics for 1) properties used for a given class/subclass, 2) properties used as qualifiers for a given property and 3) properties used as references for a given property. The statistics include a count and percentage of items/subclasses/qualifiers/references that have the given property pair.

Fields

[edit]

row_id

[edit]

auto-increment row ID for internal use. Primary key.

pid1

[edit]
  • context item: 31 (instance of) or 279 (subclass of)
  • context qualifier/reference: Property that has a qualifier or reference

qid1

[edit]
  • context item: QID of class
  • context qualifier/reference: Not used

pid2

[edit]

Property that counts are for.

count

[edit]

Count of instances/subclasses that have pid2.

probability

[edit]

Percentage of instances/subclasses that have pid2.

context

[edit]

What type of pair is this (item (class/subclass -> property), qualifier (property -> qualifier property) or reference (property -> reference property).

Schema

[edit]

DESCRIBE wbs_propertypairs;

+-------------+---------------------+------+-----+---------+----------------+
| Field       | Type                | Null | Key | Default | Extra          |
+-------------+---------------------+------+-----+---------+----------------+
| row_id      | bigint(20) unsigned | NO   | PRI | 0       | auto_increment |
| pid1        | int(10) unsigned    | NO   | MUL | NULL    |                |
| qid1        | int(10) unsigned    | YES  |     | NULL    |                |
| pid2        | int(10) unsigned    | NO   |     | NULL    |                |
| count       | int(10) unsigned    | NO   |     | NULL    |                |
| probability | float               | NO   |     | NULL    |                |
| context     | varbinary(32)       | NO   |     | NULL    |                |
+-------------+---------------------+------+-----+---------+----------------+
7 rows in set (0.01 sec)

See also

[edit]