Wikibase/Schema/wb items per site/ja

This table holds links from items to Wikipedia articles.

ips_row_id
Unique row ID.

ips_item_id
The number of the QId of the item. This is  minus the Q.

ips_site_id
Id of the site that is linked to.


 * 例:,  ,

ips_site_page
Name of the page that is linked. This is non-normalized, so it uses spaces instead of underscores and may include namespace name.


 * 例:
 * Examples with namespace: ,

バージョン
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   database holds further details about sites, such as url, language, and if it has closed.