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_target_id     | bigint(20) unsigned | NO   | PRI | NULL    |       |
 * tl_from_namespace | int(11)            | NO   | MUL | 0       |       |

+---+-+--+-+-+---+ +---+-+--+-+-+---+ +---+-+--+-+-+---+
 * 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_target_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_target_id                     |            1 | tl_target_id      | A         |           0 |     NULL | NULL   |      | 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   |      | BTREE      |         |               |
 * templatelinks |         1 | tl_backlinks_namespace_target_id |            3 | tl_from           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |