| 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
|