Wikibase/Schema/wb changes subscription

From MediaWiki.org
Jump to navigation Jump to search

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