Manual:Linktarget table/ja

This table store a page namespace-title tuples, each one with a unique integer id. This table is used for referenced page titles in tables that track links to pages: templatelinks, categorylinks, pagelinks and imagelinks tables.

This table contains immutable rows, which means only new rows are inserted, and never deleted or updated during normal wiki operation. However, the pruneUnusedLinkTargetRows.php maintenance script can be run to delete unused entries.

Access to this table from code is handled by instances of the interface.

During schema migration, this table is filled using the migrateLinksTable.php maintenance script. controls whether data is read/written to this table.

lt_id
主キー.

lt_namespace
リンク先の名前空間.

lt_title
リンク先から名前空間を除いたテキスト部分.



スキーマの要約
+--+-+--+-+-++ +--+-+--+-+-++ +--+-+--+-+-++
 * 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    |                |

インデックス
 ++++--+--+---+-+--++--++-+---+ ++++--+--+---+-+--++--++-+---+ ++++--+--+---+-+--++--++-+---+
 * 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      |         |               |