Manual:existencelinks table

The existencelinks table tracks the existence of page titles that another article's content depends on. It is similar to the pagelinks and was in fact split off from that table in the 1.45 release. Where pagelinks is used for internal links, the existencelinks table is used for if exists checks by Parserfunctions, Scribunto etc.

Note that the target page may or may not exist, and due to renames and deletions may refer to different page records as time goes by.

The page_id of the page containing the link.

Foreign key to linktarget.

DESCRIBEexistencelinks;

+-------------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| exl_from | int(10) unsigned | NO | PRI | 0 | |
| exl_target_id | bigint(20) unsigned | NO | PRI | NULL | |
+-------------------+---------------------+------+-----+---------+-------+

SHOWINDEXINexistencelinks;

// TODO

• MediaWiki database tables