Manual:Slots table/ia

Le tabella slots (segmentos) representa un relation n:m inter versiones e objectos de contento. Un objecto de contento pote haber un "rolo" specific in un o plus versiones. Cata version pote haber plure objectos de contento, cata un del quales ha un rolo differente.

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
Referentia a o. slot_revision_id e slot_role_id insimul constitue le clave primari.

slot_role_id
Referentia a

slot_content_id
Referentia a

slot_origin
Le del version que ha originate le contento del segmento. Pro trovar versiones que ha cambiate segmentos, cerca slot_origin = slot_revision_id.

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

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