手册:其他字段上的主关键存储

This is a page to track primary key storage in other fields in the core and in extensions used on WMF wikis. Nearly all of the primary keys are auto-incrementing numerical keys. Exceptions are marked accordingly. log_search.ls_value is not included here, but it can contain any number of primary keys.

用法

核心

Primary key	Storage elsewhere
actor.actor_id	archive.ar_actor
	filearchive.fa_actor
	image.img_actor
	ipblocks.ipb_by_actor
	oldimage.oi_actor
	logging.log_actor
	recentchanges.rc_actor
archive.ar_id	N/A
category.cat_id	N/A
comment.comment_id	revision_comment_temp.revcomment_comment_id
	archive.ar_comment_id
	ipblocks.ipb_reason_id
	image.img_description_id
	image_comment_temp.imgcomment_description_id
	oldimage.oi_description_id
	filearchive.fa_deleted_reason_id
	filearchive.fa_description_id
	recentchanges.rc_comment_id
	logging.log_comment_id
	protected_titles.pt_reason_id
	revision.rev_comment_id
content.content_id	slots.slot_content_id
externallinks.el_id	N/A
filearchive.fa_id	N/A
image.img_name (Note this primary key is not a numerical index, but the file name!)	image_comment_temp.imgcomment_name
ip_changes.ipc_rev_id	N/A
ipblocks.ipb_id	ipblocks.ipb_parent_block_id
job.job_id	N/A
linktarget.lt_id	N/A
logging.log_id	change_tag.ct_log_id
	log_search.ls_log_id
	recentchanges.rc_logid
	tag_summary.ts_log_id
page.page_id	archive.ar_page_id
	categorylinks.cl_from
	externallinks.el_from
	hitcounter.hc_id （在版本1.25移除）
	imagelinks.il_from
	iwlinks.iwl_from
	langlinks.ll_from
	logging.log_page
	pagelinks.pl_from
	page_props.pp_page
	page_restrictions.pr_page
	recentchanges.rc_cur_id
	redirect.rd_from
	revision.rev_page
	searchindex.si_page
	templatelinks.tl_from
page_restrictions.pr_id	N/A
recentchanges.rc_id	change_tag.ct_rc_id
	tag_summary.ts_rc_id
revision.rev_id	archive.ar_rev_id
	archive.ar_parent_id
	change_tag.ct_rev_id
	ip_changes.ipc_rev_id
	page.page_latest
	recentchanges.rc_this_oldid
	recentchanges.rc_last_oldid
	revision.rev_parent_id
	revision_comment_temp.revcomment_rev
	tag_summary.ts_rev_id
	slots.slot_revision_id
sites.site_id	N/A
site_stats.ss_row_id	N/A
slot_roles.role_id	slots.slot_role_id
text.old_id	archive.ar_text_id
	revision.rev_text_id
user.user_id	archive.ar_user
	filearchive.fa_deleted_user
	filearchive.fa_user
	image.img_user
	ipblocks.ipb_user
	ipblocks.ipb_by
	logging.log_user
	oldimage.oi_user
	protected_titles.pt_user
	recentchanges.rc_user
	revision.rev_user
	uploadstash.us_user
	user_former_groups.ufg_user
	user_groups.ug_user
	user_newtalk.user_id
	user_properties.up_user
	watchlist.wl_user
watchlist.wl_id	watchlist_expiry.we_item

Extensions used on Wikimedia wikis

Primary key	Storage elsewhere
actor.actor_id	cu_changes.cuc_actor
	cu_log.cul_actor
archive.ar_id	N/A
category.cat_id	N/A
comment.comment_id	cu_changes.cuc_comment_id
externallinks.el_id	N/A
filearchive.fa_id	N/A
ipblocks.ipb_id	N/A
job.job_id	N/A
page.page_id	titlekey.tk_page
	cu_changes.cuc_page_id
page_restrictions.pr_id	N/A
recentchanges.rc_id	N/A
revision.rev_id	abuse_filter_log.afl_rev_id
sites.site_id	N/A
site_stats.ss_row_id	N/A
text.old_id	N/A
user.user_id	abuse_filter.af_user
	abuse_filter_history.afh_user
	abuse_filter_log.afl_user
	cu_changes.cuc_user
	cu_log.cul_user