Manual:Slots table/ja

slots テーブルは、版とコンテンツ オブジェクトの間のn対mリレーションを表現します. A content object can have a specific "role" in one or more revisions. Each revision can have multiple content objects, each having a different role.

The table was introduced in MediaWiki 1.31 as part of the project. See for details. During migration from older versions, the table is populated by (run automatically by the upgrade script).

slot_revision_id
Reference to or. slot_revision_id and slot_role_id together comprise the primary key.

slot_role_id
への参照です.

slot_content_id
への参照です.

slot_origin
The of the revision that originated the slot's content. To find revisions that changed slots, look for slot_origin = slot_revision_id.

スキーマ
+--+--+--+-+-+---+ +--+--+--+-+-+---+ +--+--+--+-+-+---+
 * Field           | Type                 | Null | Key | Default | Extra |
 * slot_revision_id | bigint(20) unsigned | NO   | PRI | NULL    |       |
 * slot_role_id    | smallint(5) unsigned | NO   | PRI | NULL    |       |
 * slot_content_id | bigint(20) unsigned  | NO   |     | NULL    |       |
 * slot_origin     | bigint(20) unsigned  | NO   |     | NULL    |       |

インデックス
 +---++---+--+--+---+-+--++--++-+---+ +---++---+--+--+---+-+--++--++-+---+ +---++---+--+--+---+-+--++--++-+---+
 * Table | Non_unique | Key_name                 | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * slots |         0 | PRIMARY                   |            1 | slot_revision_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * slots |         0 | PRIMARY                   |            2 | slot_role_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * slots |         1 | slot_revision_origin_role |            1 | slot_revision_id | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * slots |         1 | slot_revision_origin_role |            2 | slot_origin      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * slots |         1 | slot_revision_origin_role |            3 | slot_role_id     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |