Wikibase/架構/wb items per site

This page is a translated version of the page Wikibase/Schema/wb items per site and the translation is 88% complete.

此表儲存到Client條目的項目連結。

字段

ips_row_id

唯一的行ID。

ips_item_id

項目的QId值。為page.page_title去除Q。

ips_site_id

連結到的網站ID。

例如： enwiki, commonswiki, be_x_oldwiki

ips_site_page

連結到的頁面名稱。這未正規化，所以使用空格而非底線，並可能包含命名空間名稱。

例如： "Weird Al" Yankovic: The Videos
含有命名空間的範例： Kategorie:Botaniker, Category:Botanists

版本

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

参阅

Quarry: wb_items_per_site – describe table, sample data, query examples
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.