Manual:slots テーブル

From MediaWiki.org
Jump to navigation Jump to search
This page is a translated version of the page Manual:Slots table and the translation is 50% complete.
Other languages:
English • ‎français • ‎日本語
Manual:コンテンツ MediaWiki のデータベース レイアウト slots table/ja


MediaWiki バージョン: 1.31

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.

フィールド

slot_revision_id

Reference to revision.rev_id or archive.ar_rev_id. slot_revision_id and slot_role_id together comprise the primary key.

slot_role_id

slot_roles.role_id への参照です。

slot_content_id

content.content_id への参照です。

slot_origin

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

スキーマ

MediaWiki バージョン: 1.31

describe slots;

+------------------+----------------------+------+-----+---------+-------+
| 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    |       |
+------------------+----------------------+------+-----+---------+-------+