Wikibase/架構/wb items per site
Appearance
此表儲存到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
版本
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 | | +---------------+------------------+------+-----+---------+----------------+
参见
- 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.