Wikibase/Schema/wb items per site

From MediaWiki.org
Jump to: navigation, search

This table holds links from items to Wikipedia articles.

Fields[edit]

ips_row_id[edit]

  • Unique row ID.

ips_item_id[edit]

  • The number of the QId of the item. This is page.page_title minus the Q.

ips_site_id[edit]

  • Id of the site that is linked to. For example, enwiki, commonswiki, be_x_oldwiki.

ips_site_page[edit]

  • Name of the page that is linked. This is non-normalized, so it uses spaces instead of underscores and may include namespace name.
  • Example: "Weird Al" Yankovic: The Videos
  • Examples with namespace: Kategorie:Botaniker, Category:Botanists

Versions[edit]

Current as of Wikibase 0.4 (19 Feb 2013)

+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| ips_row_id    | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| ips_item_id   | int(10) unsigned | NO   | MUL | NULL    |                |
| ips_site_id   | varbinary(32)    | NO   | MUL | NULL    |                |
| ips_site_page | varbinary(255)   | NO   | MUL | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+

See also[edit]

  • Quarry: wb_items_per_site — describe table, sample data
  • meta database — on WMF labs, the automatically maintained meta_p.wiki database holds further details about sites, such as url, language, and if it has closed.