Brokenlinks table
From MediaWiki.org
| ↑ Manual:Contents | MediaWiki database layout | Brokenlinks table |
The links and brokenlinks tables have been merged to a single pagelinks table, which records the namespace+title key pair of target links rather than the page ID or the prefixed title.[1]
The brokenlinks table stores links to articles that don't exist yet. This is used for Special:Wantedpages (which is sometimes disabled), and perhaps for some link caching. It is the twin of the links table.
"DESCRIBE brokenlinks" results in this:
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| bl_from | int(8) unsigned | MUL | 0 | ||
| bl_to | varchar(255) binary | MUL |
bl_from stores the cur_id of the article where the link was put, bl_to stores the name (including namespace prefix) of the desired article.

