Manual:Templatelinks table/en

The templatelinks table contains for each current transclusion the id of the host page, the namespace number of the included page, and its title without namespace.

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

tl_from
Key to the of the page containing the link.

tl_namespace
Key to of the target page. Used in conjunction with tl_title.

tl_title
Key to of the target page. Used in conjunction with tl_namespace.

tl_from_namespace
of the page containing the link.

tl_target_id
Foreign key to

Schema summary
+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field            | Type                | Null | Key | Default | Extra |
 * tl_from          | int(10) unsigned    | NO   | PRI | 0       |       |
 * tl_from_namespace | int(11)            | NO   | MUL | 0       |       |
 * tl_target_id     | bigint(20) unsigned | YES  | MUL | NULL    |       |

+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * Field            | Type                | Null | Key | Default | Extra |
 * tl_from          | int(10) unsigned    | NO   | PRI | 0       |       |
 * tl_namespace     | int(11)             | NO   | PRI | 0       |       |
 * tl_title         | varbinary(255)      | NO   | PRI |         |       |
 * tl_from_namespace | int(11)            | NO   | MUL | 0       |       |
 * tl_target_id     | bigint(20) unsigned | YES  | MUL | NULL    |       |

+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field            | Type             | Null | Key | Default | Extra |
 * tl_from          | int(10) unsigned | NO   | PRI | 0       |       |
 * tl_namespace     | int(11)          | NO   | PRI | 0       |       |
 * tl_title         | varbinary(255)   | NO   | PRI |         |       |
 * tl_from_namespace | int(11)         | NO   | MUL | 0       |       |

+---+--+--+-+-+---+ +---+--+--+-+-+---+ +---+--+--+-+-+---+
 * Field            | Type             | Null | Key | Default | Extra |
 * tl_from          | int(10) unsigned | NO   | PRI | 0       |       |
 * tl_from_namespace | int(11)         | NO   | MUL | 0       |       |
 * tl_namespace     | int(11)          | NO   | PRI | 0       |       |
 * tl_title         | varbinary(255)   | NO   | PRI |         |       |

+---+-+--+-+---+---+ +---+-+--+-+---+---+ +---+-+--+-+---+---+
 * Field            | Type                | Null | Key | Default   | Extra |
 * tl_from          | int(10) unsigned    | NO   | PRI | 0         |       |
 * tl_from_namespace | int(11)            | NO   |     | 0         |       |
 * tl_namespace     | int(11)             | NO   | PRI | 0         |       |
 * tl_title         | varchar(255) binary | NO   | PRI | 0         |       |

+---+-+--+-+---+---+ +---+-+--+-+---+---+ +---+-+--+-+---+---+
 * Field        | Type                | Null | Key | Default   | Extra |
 * tl_from      | int(10) unsigned    | NO   | PRI | 0         |       |
 * tl_namespace | int(11)             | NO   | PRI | 0         |       |
 * tl_title     | varchar(255) binary | NO   | PRI | 0         |       |

+---+-+--+-+---+---+ +---+-+--+-+---+---+ +---+-+--+-+---+---+
 * Field        | Type                | Null | Key | Default   | Extra |
 * tl_from      | int(8) unsigned     | NO   | PRI | 0         |       |
 * tl_namespace | int(8)              | NO   | PRI | 0         |       |
 * tl_title     | varchar(255) binary | NO   | PRI | 0         |       |

Indexes
 +---++--+--+---+---+-+--++--++-+---+ +---++--+--+---+---+-+--++--++-+---+ +---++--+--+---+---+-+--++--++-+---+
 * Table        | Non_unique | Key_name                         | Seq_in_index | Column_name       | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * templatelinks |         0 | PRIMARY                          |            1 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         0 | PRIMARY                          |            2 | tl_namespace      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         0 | PRIMARY                          |            3 | tl_title          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_namespace                     |            1 | tl_namespace      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_namespace                     |            2 | tl_title          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_namespace                     |            3 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace           |            1 | tl_from_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace           |            2 | tl_namespace      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace           |            3 | tl_title          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace           |            4 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_target_id                     |            1 | tl_target_id      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
 * templatelinks |         1 | tl_target_id                     |            2 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace_target_id |            1 | tl_from_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace_target_id |            2 | tl_target_id      | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace_target_id |            3 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |