Wikibase/Schema/wb_changes_subscription

Subscription table tracking which client wiki is using which entity. This information is used to decide determine which client wiki needs to be notified when an entity is changed. Detailed documentation on entity usage tracking can be found in the file docs/usagetracking.wiki.

See also Wikibase/Schema/wbc_entity_usage.

Fields

edit

cs_row_id

edit
  • Auto-increment row id for internal use; primary key.

cs_entity_id

edit
  • The ID of the entity used on the client wiki.

cs_subscriber_id

edit
  • The global ID (as used by the sites table) of the wiki using the entity (by WMF conventions, the same as the database name).


Versions

edit

Current as of December 2016.

+------------------+----------------+------+-----+---------+----------------+
| Field            | Type           | Null | Key | Default | Extra          |
+------------------+----------------+------+-----+---------+----------------+
| cs_row_id        | bigint(20)     | NO   | PRI | NULL    | auto_increment |
| cs_entity_id     | varbinary(255) | NO   | MUL | NULL    |                |
| cs_subscriber_id | varbinary(255) | NO   | MUL | NULL    |                |
+------------------+----------------+------+-----+---------+----------------+