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
|
K.A.
|
category.cat_id
|
K.A.
|
comment.comment_id
|
revision_comment_temp.revcomment_comment_id (removed in 1.40)
|
archive.ar_comment_id
|
ipblocks.ipb_reason_id
|
image.img_description_id
|
image_comment_temp.imgcomment_description_id (removed in 1.31)
|
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
|
K.A.
|
filearchive.fa_id
|
K.A.
|
image.img_name
(Note this primary key is not a numerical index, but the file name!)
|
image_comment_temp.imgcomment_name (removed in 1.31)
|
ip_changes.ipc_rev_id
|
K.A.
|
ipblocks.ipb_id
|
ipblocks.ipb_parent_block_id
|
job.job_id
|
K.A.
|
linktarget.lt_id
|
pagelinks.pl_target_id
|
logging.log_id
|
change_tag.ct_log_id
|
log_search.ls_log_id
|
recentchanges.rc_logid
|
tag_summary.ts_log_id (removed in 1.33)
|
page.page_id
|
archive.ar_page_id
|
categorylinks.cl_from
|
externallinks.el_from
|
hitcounter.hc_id (removed in 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
|
K.A.
|
recentchanges.rc_id
|
change_tag.ct_rc_id
|
tag_summary.ts_rc_id (removed in 1.33)
|
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 (removed in 1.40)
|
tag_summary.ts_rev_id (removed in 1.33)
|
slots.slot_revision_id
|
sites.site_id
|
K.A.
|
site_stats.ss_row_id
|
K.A.
|
slot_roles.role_id
|
slots.slot_role_id
|
text.old_id
|
archive.ar_text_id (removed in 1.35)
|
revision.rev_text_id (removed in 1.35)
|
user.user_id
|
archive.ar_user (removed in 1.34)
|
filearchive.fa_deleted_user (removed in 1.34)
|
filearchive.fa_user (removed in 1.34)
|
image.img_user (removed in 1.34)
|
ipblocks.ipb_user
|
ipblocks.ipb_by (removed in 1.34)
|
logging.log_user (removed in 1.34)
|
oldimage.oi_user (removed in 1.34)
|
protected_titles.pt_user
|
recentchanges.rc_user (removed in 1.34)
|
revision.rev_user (removed in 1.35)
|
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
|