Manual:Iwlinks table

The iwlinks table stores the interwiki links with their targets. Not to confuse with the table.

iwl_from
The  of the referring page (i.e. the local page that the link appears on).

iwl_prefix
interwiki prefix code of the target. This is used the same way as a namespace is used when editing.

iwl_title
The title of the target page, including namespace ( FULLPAGENAME style). Spaces are converted to underscores, but the first letter is not automatically capitalized. So for example, an interwiki link to foo bar would have an iwl_title of "foo_bar".

Schema summary
++--+--+-+-+---+ ++--+--+-+-+---+ ++--+--+-+-+---+
 * Field     | Type             | Null | Key | Default | Extra |
 * iwl_from  | int(10) unsigned | NO   | PRI | 0       |       |
 * iwl_prefix | varbinary(32)   | NO   | PRI |         |       |
 * iwl_title | varbinary(255)   | NO   | PRI |         |       |

++--+--+-+-+---+ ++--+--+-+-+---+ ++--+--+-+-+---+
 * Field     | Type             | Null | Key | Default | Extra |
 * iwl_from  | int(10) unsigned | NO   | PRI | 0       |       |
 * iwl_prefix | varbinary(20)   | NO   | PRI |         |       |
 * iwl_title | varbinary(255)   | NO   | PRI |         |       |

Indexes
 +-++---+--+-+---+-+--++--++-+---+ +-++---+--+-+---+-+--++--++-+---+ +-++---+--+-+---+-+--++--++-+---+
 * Table  | Non_unique | Key_name              | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * iwlinks |         0 | PRIMARY               |            1 | iwl_from    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         0 | PRIMARY               |            2 | iwl_prefix  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         0 | PRIMARY               |            3 | iwl_title   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         1 | iwl_prefix_title_from |            1 | iwl_prefix  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         1 | iwl_prefix_title_from |            2 | iwl_title   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         1 | iwl_prefix_title_from |            3 | iwl_from    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         1 | iwl_prefix_from_title |            1 | iwl_prefix  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         1 | iwl_prefix_from_title |            2 | iwl_from    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * iwlinks |         1 | iwl_prefix_from_title |            3 | iwl_title   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |