Manual:slots table

From MediaWiki.org
Jump to navigation Jump to search

Other languages:
English • ‎dansk • ‎日本語
Manual:Contents MediaWiki database layout slots table


MediaWiki version: 1.31

The slots table represent an n:m relation between revisions and content objects. 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.

Fields[edit]

slot_revision_id[edit]

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[edit]

Reference to slot_roles.role_id

slot_content_id[edit]

Reference to content.content_id

slot_origin[edit]

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.