| 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 (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 |
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 (removed in 1.31) |
| ip_changes.ipc_rev_id |
N/A |
| ipblocks.ipb_id |
ipblocks.ipb_parent_block_id |
| job.job_id |
N/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 |
N/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 |
N/A |
| site_stats.ss_row_id |
N/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 |