Manual:Existencelinks table/ja

↑ Manual:コンテンツ

MediaWiki のデータベース レイアウト

existencelinks テーブル

MediaWiki バージョン:

≧ 1.45

The existencelinks table tracks the existence of page titles that another article's content depends on. It is similar to the pagelinks and was in fact split off from that table in the 1.45 release. Where pagelinks is used for internal links, the existencelinks table is used for if exists checks by Parserfunctions, Scribunto etc.

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

フィールド

exl_from

The page_id of the page containing the link.

exl_target_id

linktarget への外部キー。

スキーマの要約

MediaWiki バージョン:

≧ 1.45

DESCRIBE existencelinks;

+-------------------+---------------------+------+-----+---------+-------+
| Field             | Type                | Null | Key | Default | Extra |
+-------------------+---------------------+------+-----+---------+-------+
| exl_from          | int(10) unsigned    | NO   | PRI | 0       |       |
| exl_target_id     | bigint(20) unsigned | NO   | PRI | NULL    |       |
+-------------------+---------------------+------+-----+---------+-------+

インデックス

MediaWiki バージョン:

≧ 1.45

SHOW INDEX IN existencelinks;

+----------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table          | Non_unique | Key_name      | Seq_in_index | Column_name   | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| existencelinks |          0 | PRIMARY       |            1 | exl_from      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| existencelinks |          0 | PRIMARY       |            2 | exl_target_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| existencelinks |          1 | exl_target_id |            1 | exl_target_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| existencelinks |          1 | exl_target_id |            2 | exl_from      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+----------------+------------+---------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+