API:データベース フィールドとAPIプロパティの関連

This page is a translated version of the page API:Database field and API property associations and the translation is 70% complete.
MediaWiki バージョン:

This table shows some of the ways in which the logging , page , recentchanges , revision , and text tables are linked together and what properties from the recentchanges and revisions parts of the API are associated with them.

Sometimes there is not an exact match between items on the same row of this table, but they are related in some way. 例:「anon」プロパティは、操作を行った利用者について有用な情報を提供します。 It is put in the same row as rc_user because there was no closer match (except perhaps the user property); the recentchanges part of the API does not return a user id . 空色の印が付いたフィールドは廃止済み (obsolete)です。 ピンクの印が付いたフィールドは API 経由ではアクセスできない (inaccessible via API) ようです。 黄色の印が付いたフィールドは 不完全な一致 (inexact match) です。

データベース テーブル API 経由で取得されるプロパティ
logging page recentchanges revision text list=logevents list=recentchanges prop=revisions
log_id rc_logid logid logid
log_type rc_log_type type logtype
log_action rc_log_action action logaction
log_timestamp rc_timestamp rev_timestamp timestamp timestamp timestamp
log_user rc_user rev_user userid anon userid
log_text rc_user_text rev_user_text user user user
log_namespace page_namespace rc_namespace ns ns
log_title page_title rc_title title title
log_page page_id rc_cur_id rev_page pageid pageid
log_comment rc_comment rev_comment comment comment comment
log_params rc_params
log_deleted rc_deleted rev_deleted
page_is_redirect redirect
page_is_new rc_new new
page_latest rc_this_oldid rev_id revid revid
rc_id rcid
rc_minor rev_minor_edit minor minor
rc_bot bot
rc_last_oldid rev_parent_id revoldid parentid
rc_type type
rc_patrolled patrolled
rc_ip user
rc_old_len oldlen
page_len rc_new_len rev_len newlen size
rev_text_id old_id
rev_sha1 sha1
page.page_content_model revision.rev_content_model contentmodel
old_text content
tags tags tags
logging page recentchanges revision text list=logevents list=recentchanges prop=revisions