Manual:Linktarget table/en

lt_id
Primary key.

lt_namespace
Namespace of the link target.

lt_title
Text part of link target excluding namespace.

Schema summary
+--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++
 * Field       | Type                | Null | Key | Default | Extra          |
 * lt_id       | bigint(20) unsigned | NO   | PRI | NULL    | auto_increment |
 * lt_namespace | int(11)            | NO   | MUL | NULL    |                |
 * lt_title    | varbinary(255)      | NO   |     | NULL    |                |

Indexes
 ++++--+--+---+-+--++--++-+---+ ++++--+--+---+-+--++--++-+---+ ++++--+--+---+-+--++--++-+---+
 * Table     | Non_unique | Key_name           | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * linktarget |         0 | PRIMARY            |            1 | lt_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * linktarget |         0 | lt_namespace_title |            1 | lt_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * linktarget |         0 | lt_namespace_title |            2 | lt_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |

Indexes
 ++++--+--+---+-+--++--++-+---+ ++++--+--+---+-+--++--++-+---+ ++++--+--+---+-+--++--++-+---+
 * Table     | Non_unique | Key_name           | Seq_in_index | Column_name  | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * linktarget |         0 | PRIMARY            |            1 | lt_id        | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * linktarget |         0 | lt_namespace_title |            1 | lt_namespace | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * linktarget |         0 | lt_namespace_title |            2 | lt_title     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |